Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)
Beschreibung
Enthält mit dem Douglas-Peucker-Algorithmus simplifizierte Varianten der Polygondaten aus der Tabelle `Orte`, sowie (für bestimmte `Kategorien`) Hexagone, die dem jeweiligen Polygon möglichst gut entsprechen.
Enthält mit dem Douglas-Peucker-Algorithmus simplifizierte Varianten der Polygondaten aus der Tabelle `Orte`, sowie (für bestimmte `Kategorien`) Hexagone, die dem jeweiligen Polygon möglichst gut entsprechen.
Spalten
Der Name von Spalten, die Teil des Primärschlüssels sind wird fett dargestellt, die Namen von Fremdschlüsseln unterstrichen. Kursivierte Werte im Feld Datentyp bedeuten, dass der Wert optional (nullable) ist.
| Spaltenname | Datentyp | Mögliche Werte | Beschreibung |
|---|---|---|---|
| id_ort | int(10) unsigned | beliebig | Fremdschlüssel, der auf die Tabelle `orte` verweist. |
| geodaten | geometryDieser Datentyp speichert geometrische Daten in MySQL-Datenbanken. Die einfachste Möglichkeit diese manuell einzutragen, ist die Verwendung der GeomFromText-Funktion. Diese erlaubt die Eingabe der Daten im WKT-Format. Alle geographischen Koordinaten in VerbaAlpina werden in der Reihenfolge <Längengrad>, <Breitengrad> angegeben. Die Eingabe eines Punktes mit den Koordinaten Breitengrad 48.135876 und Längengrad 11.583720 könnte somit folgendermaßen über die phpMyAdmin-Oberfläche angegeben werden:
| beliebig | Die simplifizierten Geodaten. |
| epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
| mittelpunkt | pointDieser Datentyp speichert geometrische Daten in MySQL-Datenbanken. Die einfachste Möglichkeit diese manuell einzutragen, ist die Verwendung der GeomFromText-Funktion. Diese erlaubt die Eingabe der Daten im WKT-Format. Alle geographischen Koordinaten in VerbaAlpina werden in der Reihenfolge <Längengrad>, <Breitengrad> angegeben. Die Eingabe eines Punktes mit den Koordinaten Breitengrad 48.135876 und Längengrad 11.583720 könnte somit folgendermaßen über die phpMyAdmin-Oberfläche angegeben werden:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
| id_ort | geodaten | epsilon | mittelpunkt |
|---|---|---|---|
| 27172 | POLYGON((-1.43651270866388 49.5924263000488,-1.42618894577026 49.5915222167968,-1.41719901561737 49.5794219970704,-1.40322756767273 49.5746917724611,-1.40093839168549 49.5680160522462,-1.39660513401031 49.5660552978516,-1.38107717037201 49.5673370361328,-1.38107717037201 49.5673370361328,-1.37630736827845 49.5753402709961,-1.3688029050827 49.5770950317383,-1.3688029050827 49.5770950317383,-1.35471296310413 49.5811767578126,-1.34828722476954 49.5863647460939,-1.35436797142029 49.5953712463379,-1.35177874565119 49.5983085632324,-1.35177874565119 49.5983085632324,-1.35356962680817 49.6008110046387,-1.35356962680817 49.6008110046387,-1.36327648162836 49.5999946594239,-1.39382314682007 49.6146888732911,-1.39382314682007 49.6146888732911,-1.40699303150166 49.6117515563965,-1.42595243453968 49.6128463745118,-1.42595243453968 49.6128463745118,-1.44161903858185 49.6043777465821,-1.43651270866388 49.5924263000488)) | 0.0006 | POINT(-1.3870497560500785 49.59074737548832) |
| 17620 | POLYGON((7.43886899948131 44.2938308715821,7.453773021698 44.2992324829102,7.453773021698 44.2992324829102,7.45617294311535 44.3008003234864,7.45845699310308 44.304515838623,7.45974016189581 44.3107910156251,7.46317005157476 44.3153877258301,7.47281694412231 44.320297241211,7.49977302551281 44.326904296875,7.50392580032354 44.326930999756,7.50392580032354 44.326930999756,7.50953578948975 44.3283882141114,7.51317596435547 44.3221206665039,7.52056789398193 44.314395904541,7.52056789398193 44.314395904541,7.50698804855347 44.3084297180177,7.49528694152832 44.2985877990723,7.48788118362432 44.2891807556153,7.48814392089838 44.281120300293,7.48978281021118 44.2796516418456,7.48982715606689 44.2763442993164,7.48798799514771 44.2724456787111,7.48266315460211 44.268409729004,7.48266315460211 44.268409729004,7.47552299499512 44.2707672119142,7.45274496078503 44.2823867797853,7.44482803344732 44.2878341674805,7.43886899948131 44.2938308715821)) | 0.0006 | POINT(7.48194683922665 44.29954528808599) |
| 68734 | POLYGON((14.1006402969361 51.1784820556641,14.1021823883057 51.1791458129884,14.1009817123414 51.1826858520508,14.1077814102174 51.185691833496,14.0992059707643 51.1970443725587,14.0992059707643 51.1970443725587,14.0968942642213 51.2003059387207,14.0942726135254 51.2016296386719,14.0932674407959 51.2038230895997,14.0929899215698 51.2107505798341,14.0937423706055 51.2141571044922,14.095365524292 51.2156562805176,14.0940780639648 51.2177238464356,14.0944318771363 51.2226409912111,14.093152999878 51.2248229980469,14.0890684127808 51.2269020080567,14.0889739990234 51.2304725646973,14.0889739990234 51.2304725646973,14.096480369568 51.2299652099609,14.099458694458 51.2308082580566,14.1030616760255 51.2359695434571,14.1041860580444 51.2426528930665,14.1086244583131 51.2445335388183,14.1194524765015 51.2471809387208,14.1213006973268 51.2454948425293,14.1249961853028 51.2461280822754,14.1233444213868 51.2483024597169,14.1250677108766 51.2486839294435,14.1280078887941 51.2464675903321,14.133888244629 51.2451400756837,14.1379194259644 51.2456550598146,14.1382312774658 51.2479782104493,14.1408500671388 51.2473297119141,14.1413135528565 51.2453880310059,14.1468620300293 51.246753692627,14.1463985443116 51.2517852783204,14.1463985443116 51.2517852783204,14.1497993469239 51.2505073547363,14.1550245285034 51.2463378906249,14.1600151062012 51.2444801330568,14.1588726043701 51.2412986755371,14.162302017212 51.2403907775879,14.162302017212 51.2403907775879,14.1604690551758 51.2341156005861,14.1629600524903 51.2340354919433,14.1645936965942 51.2323799133301,14.1635055541992 51.2316932678224,14.1646547317505 51.2280998229982,14.1719598770142 51.2259635925294,14.1706581115723 51.2233085632325,14.1661815643311 51.2241973876954,14.1642389297486 51.2223205566406,14.1654825210571 51.2202720642091,14.1650409698487 51.2170715332032,14.1630687713623 51.2148094177246,14.1635818481446 51.2133255004884,14.1685485839844 51.2104835510254,14.1700124740601 51.206169128418,14.1659278869629 51.2049369812012,14.1667194366456 51.2015533447266,14.162000656128 51.2013473510742,14.1587400436403 51.1956748962403,14.155858039856 51.1942176818848,14.1530609130859 51.1943778991699,14.1485824584962 51.1881332397462,14.1485824584962 51.1881332397462,14.1414365768432 51.1856842041015,14.1409606933595 51.1818351745605,14.1366014480591 51.1792602539062,14.1262340545654 51.1757278442384,14.1262340545654 51.1757278442384,14.1168804168702 51.1794395446778,14.1144323348998 51.1780128479004,14.1134052276611 51.1756820678712,14.1111841201783 51.1771469116211,14.1103458404541 51.1759567260742,14.1006402969361 51.1784820556641)) | 0.0006 | POINT(14.132125139236495 51.21739412608901) |
| 42813 | POLYGON((6.35653543472301 48.1373596191406,6.35397148132336 48.1308860778809,6.34654474258434 48.1264228820801,6.34995651245117 48.1201820373536,6.3405995368957 48.119197845459,6.32209157943737 48.1230506896973,6.32209157943737 48.1230506896973,6.31343126297003 48.1428298950196,6.30969190597534 48.1452140808106,6.29973554611217 48.1445999145509,6.28899955749512 48.163875579834,6.30368852615362 48.1733741760254,6.30368852615362 48.1733741760254,6.32234621047985 48.1683921813965,6.33726263046276 48.1551704406739,6.3568201065064 48.1587791442872,6.3568201065064 48.1587791442872,6.36046695709234 48.1464881896973,6.35653543472301 48.1373596191406)) | 0.0006 | POINT(6.330263455708888 48.145057042439824) |
| 45869 | POLYGON((0.792216300964412 43.9661521911621,0.813564717769623 43.9548950195314,0.809297919273433 43.9323005676271,0.809297919273433 43.9323005676271,0.770003974437714 43.9221420288086,0.770003974437714 43.9221420288086,0.760549128055629 43.9386672973634,0.760549128055629 43.9386672973634,0.760114133358115 43.9453048706055,0.78377765417099 43.9549140930176,0.785137295723075 43.9580955505371,0.785137295723075 43.9580955505371,0.792216300964412 43.9661521911621)) | 0.0006 | POINT(0.7833041201035703 43.94363975524908) |
| 36429 | POLYGON((5.67680263519293 47.342887878418,5.69896650314331 47.3540840148927,5.69896650314331 47.3540840148927,5.7071681022644 47.3506088256836,5.7071681022644 47.3506088256836,5.71216535568237 47.3375091552735,5.70544528961187 47.3327407836915,5.70544528961187 47.3327407836915,5.69897031784063 47.3288726806641,5.69897031784063 47.3288726806641,5.68176460266113 47.3366508483887,5.67680263519293 47.342887878418)) | 0.0006 | POINT(5.699257547205169 47.34087822654037) |
| 28345 | POLYGON((4.98782062530523 47.47908782959,5.00642395019537 47.4637222290039,5.00642395019537 47.4637222290039,5.01535034179693 47.4606323242187,5.03367853164684 47.4656562805177,5.06177854537975 47.4587936401367,5.07486104965221 47.4630203247071,5.08784723281872 47.4585800170898,5.08784723281872 47.4585800170898,5.10631322860718 47.4638938903809,5.10631322860718 47.4638938903809,5.110507965088 47.4766616821288,5.10663604736322 47.4893112182617,5.11299324035645 47.4942016601562,5.11299324035645 47.4942016601562,5.10401487350464 47.4976615905762,5.10401487350464 47.4976615905762,5.08249044418346 47.4908523559571,5.0737886428833 47.4936103820801,5.07498741149902 47.5001983642579,5.07498741149902 47.5001983642579,5.05160331726086 47.4933166503906,5.05160331726086 47.4933166503906,5.02199697494513 47.4798240661621,5.00218439102179 47.4792480468751,4.99289464950567 47.4823074340821,4.99289464950567 47.4823074340821,4.98782062530523 47.47908782959)) | 0.0006 | POINT(5.060935161731913 47.47942451194482) |
| 1403920 | POLYGON((0.951843023300171 41.3518409729005,0.948185026645774 41.3522377014161,0.944895982742423 41.3500099182129,0.939396023750362 41.3493690490724,0.934190988540763 41.3504219055176,0.921890020370483 41.3485984802247,0.911800026893673 41.349895477295,0.905218005180416 41.3477516174317,0.90161502361309 41.3476486206055,0.893064022064266 41.3435096740723,0.884615004062766 41.3414993286133,0.87211400270462 41.3408393859863,0.863326013088226 41.3381118774414,0.846698999405021 41.354850769043,0.844802975654602 41.3620109558105,0.845661997795105 41.370288848877,0.83818697929388 41.3818092346193,0.840517997741813 41.3828277587892,0.8388450145722 41.390537261963,0.840731978416443 41.3933410644532,0.835843980312347 41.3974380493165,0.835105001926536 41.4021530151367,0.830581009388084 41.4047698974611,0.824846982955876 41.4180946350098,0.820086002349854 41.4211425781251,0.816649019718227 41.4266319274903,0.813713014125824 41.4355163574218,0.817870020866394 41.4321365356445,0.839989006519431 41.4221076965332,0.846973001957053 41.4238624572754,0.849862992763519 41.4225883483888,0.854022026062125 41.4233207702637,0.859187006950435 41.422679901123,0.861441016197205 41.4209289550782,0.864198029041404 41.4216270446778,0.867507994175014 41.4185180664064,0.875925004482212 41.4160194396973,0.880313992500419 41.4166259765624,0.884056985378379 41.4192199707032,0.88735401630413 41.4191474914552,0.890344977378845 41.4167366027832,0.904700994491577 41.4093742370606,0.910084009170532 41.4042167663575,0.913441002368984 41.3981513977051,0.917432010173911 41.3949470520021,0.916392982006073 41.3915596008301,0.919978022575378 41.3887367248535,0.927613019943237 41.3874473571778,0.93467599153513 41.3800735473633,0.938956022262687 41.3780899047853,0.940635979175624 41.3685150146486,0.943778991699276 41.3671188354493,0.952305018901939 41.3579025268555,0.951843023300171 41.3518409729005)) | 0.0006 | POINT(0.8819521553112031 41.38820374686768) |
| 30821 | POLYGON((-1.24904811382288 48.1330680847167,-1.24867033958424 48.1297149658204,-1.22568368911743 48.1126060485841,-1.22958922386164 48.1064300537111,-1.22401571273792 48.1008338928222,-1.2314909696579 48.0923767089844,-1.2314909696579 48.0923767089844,-1.2481724023819 48.0994262695312,-1.25853669643396 48.0998268127443,-1.25853669643396 48.0998268127443,-1.26852571964264 48.1009063720704,-1.27270257472986 48.1069717407227,-1.2990549802779 48.1153221130372,-1.2990549802779 48.1153221130372,-1.29895639419556 48.1197319030762,-1.29895639419556 48.1197319030762,-1.29282331466663 48.128231048584,-1.27509737014765 48.1325798034669,-1.27509737014765 48.1325798034669,-1.24904811382288 48.1330680847167)) | 0.0006 | POINT(-1.26239494273532 48.11251911364109) |
| 41611 | POLYGON((5.35150814056391 48.5866851806642,5.3730320930481 48.5824241638185,5.3730320930481 48.5824241638185,5.37746000289911 48.575984954834,5.37450313568121 48.56551361084,5.37450313568121 48.56551361084,5.36197137832653 48.5591316223146,5.32713842391979 48.5511054992677,5.32713842391979 48.5511054992677,5.32341384887695 48.5572891235352,5.31213188171392 48.5633773803712,5.31213188171392 48.5633773803712,5.31425666809082 48.5697326660157,5.32701587677013 48.5730667114258,5.33711051940924 48.5874748229981,5.33711051940924 48.5874748229981,5.35150814056391 48.5866851806642)) | 0.0006 | POINT(5.343966126441997 48.570105075836274) |