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 |
|---|---|---|---|
| 55435 | POLYGON((6.31209993362427 46.1340026855469,6.30617427825928 46.1247406005859,6.29009056091303 46.1172027587891,6.29009056091303 46.1172027587891,6.27545595169079 46.115634918213,6.2632031440736 46.1259918212891,6.25138616561895 46.119930267334,6.2415881156922 46.1192741394044,6.22791147232061 46.1099586486816,6.22791147232061 46.1099586486816,6.21701622009289 46.1115379333496,6.21701622009289 46.1115379333496,6.22083139419556 46.1251029968262,6.22984600067144 46.1373291015625,6.2231702804566 46.1424102783204,6.2231702804566 46.1424102783204,6.23119497299194 46.157585144043,6.24185848236078 46.1635627746582,6.24185848236078 46.1635627746582,6.26212596893322 46.1499519348146,6.28050327301025 46.1521606445314,6.28968048095709 46.1499214172364,6.28968048095709 46.1499214172364,6.30172777175903 46.1449737548828,6.31209993362427 46.1340026855469)) | 0.0006 | POINT(6.256482998530106 46.13316106796268) |
| 61856 | POLYGON((8.25884819030756 52.874195098877,8.25421237945557 52.866455078125,8.25188064575201 52.8661346435547,8.25013160705578 52.8625106811524,8.25345802307129 52.8619804382324,8.25363063812262 52.8588523864747,8.25539875030512 52.8565101623536,8.25529670715343 52.8552856445313,8.25311851501476 52.8549995422364,8.23798656463617 52.8412208557129,8.23542118072521 52.8376197814942,8.23563957214355 52.8315773010255,8.23943996429443 52.8242988586426,8.24348163604742 52.8198585510254,8.24179553985601 52.8197288513184,8.24449634552013 52.8089141845704,8.23739814758295 52.8069114685059,8.23746490478521 52.8047256469727,8.2390661239624 52.8047561645508,8.23976421356201 52.8006477355958,8.23976421356201 52.8006477355958,8.24379348754883 52.8008041381837,8.24517726898193 52.7980957031251,8.24833679199224 52.797550201416,8.24899387359631 52.7959899902344,8.25234794616711 52.7957000732422,8.25222587585449 52.7981185913087,8.26780986785889 52.7980918884277,8.28510570526117 52.7953796386719,8.28643035888672 52.7956199645996,8.28602504730225 52.7966613769531,8.29012775421143 52.7978553771974,8.29416465759277 52.7963523864746,8.29505157470709 52.7943153381348,8.30170726776117 52.7902450561524,8.30348491668701 52.7865905761719,8.30639266967779 52.7847633361816,8.30724906921398 52.782814025879,8.30937290191656 52.7820320129396,8.30937290191656 52.7820320129396,8.31267261505127 52.7826805114746,8.31221389770502 52.7859840393067,8.32291889190668 52.7896385192872,8.32528781890881 52.7872924804687,8.32621288299566 52.7827644348146,8.32584762573248 52.7786903381348,8.32965660095215 52.7762641906739,8.33418369293219 52.7777404785157,8.33441543579107 52.7760009765626,8.33877372741694 52.7764587402344,8.33888721466076 52.7786712646486,8.34145450592047 52.7826690673829,8.34438419342035 52.781909942627,8.35409545898438 52.7823791503906,8.36035919189464 52.7844238281249,8.36024188995367 52.7871742248536,8.35575580596924 52.7885246276855,8.35556030273449 52.7959785461426,8.35840797424322 52.7963066101075,8.35904216766363 52.7994918823242,8.35365295410168 52.7992172241212,8.36581134796154 52.8067817687989,8.3694314956665 52.8065567016601,8.37347316741955 52.8139762878419,8.37649917602533 52.8146400451661,8.38223743438715 52.8191680908203,8.38593769073492 52.8194122314454,8.38952064514166 52.8208694458008,8.39410591125494 52.8250122070314,8.39668846130377 52.8253555297852,8.39668846130377 52.8253555297852,8.39362716674816 52.8288536071778,8.39303016662592 52.8314247131349,8.39659595489502 52.8320274353027,8.40638637542725 52.8404884338379,8.40574836730963 52.8445625305177,8.40638446807867 52.8485565185547,8.40413284301769 52.8488044738769,8.40358066558844 52.8496742248536,8.3887233734132 52.8496322631837,8.38569355010986 52.850528717041,8.38514137268072 52.8530426025392,8.37824630737305 52.8555870056153,8.36561965942377 52.8540802001953,8.36379337310802 52.8536186218262,8.36276149749762 52.8521995544435,8.35610103607189 52.8522758483887,8.35440349578857 52.8557472229004,8.35102081298822 52.8559455871583,8.34583568573004 52.8617630004883,8.34429073333752 52.8672599792482,8.3357515335083 52.8771896362305,8.33207702636724 52.8842582702638,8.33207702636724 52.8842582702638,8.32625198364263 52.8811416625977,8.32218074798595 52.8804740905762,8.31894302368164 52.8782920837403,8.31546020507818 52.8783569335938,8.30966281890863 52.8768310546876,8.30591011047363 52.8775634765625,8.30147075653088 52.8762435913087,8.29791069030773 52.876979827881,8.29023838043213 52.8763999938966,8.28202056884766 52.8784179687501,8.27316761016846 52.8767776489258,8.2644739151001 52.8770065307618,8.25884819030756 52.874195098877)) | 0.0006 | POINT(8.317584865498127 52.82509900938791) |
| 1396844 | POLYGON((-2.25884890556335 40.3959083557128,-2.22004389762873 40.4195365905763,-2.21420693397516 40.4206619262695,-2.20473504066467 40.4282455444335,-2.1931619644165 40.4329223632813,-2.18894100189203 40.4329910278321,-2.17673110961914 40.4257888793945,-2.18229508399958 40.3802070617676,-2.19378590583796 40.3648071289063,-2.23366403579706 40.366081237793,-2.25884890556335 40.3959083557128)) | 0.0006 | POINT(-2.2066413879394178 40.40671501159669) |
| 56060 | POLYGON((4.89284467697155 45.4867401123047,4.88733673095703 45.4866905212402,4.88733673095703 45.4866905212402,4.88070201873779 45.4775695800781,4.86590480804438 45.4780426025391,4.85753774642944 45.4656066894531,4.82472419738781 45.4502105712891,4.82472419738781 45.4502105712891,4.83310699462902 45.449073791504,4.8328413963319 45.4460716247559,4.8328413963319 45.4460716247559,4.84186315536505 45.4460945129395,4.85644483566296 45.433666229248,4.86468601226812 45.4322052001953,4.86468601226812 45.4322052001953,4.89733839035034 45.4383621215821,4.91860580444347 45.4521751403809,4.91860580444347 45.4521751403809,4.92067575454723 45.4554100036621,4.92067575454723 45.4554100036621,4.91432809829718 45.4687881469726,4.91432809829718 45.4687881469726,4.89284467697155 45.4867401123047)) | 0.0006 | POINT(4.875097209757092 45.45719354802913) |
| 23048 | POLYGON((-1.05658364295959 43.4848175048828,-1.06333673000336 43.4947509765625,-1.06333673000336 43.4947509765625,-1.0689971446991 43.5084495544434,-1.0689971446991 43.5084495544434,-1.07415020465845 43.5196723937989,-1.08108425140375 43.5229949951172,-1.08108425140375 43.5229949951172,-1.08959126472473 43.5118904113771,-1.10733020305634 43.5143203735353,-1.10733020305634 43.5143203735353,-1.11632907390594 43.5034294128418,-1.13298046588898 43.4997062683107,-1.13298046588898 43.4997062683107,-1.12815761566162 43.486328125,-1.11438703536976 43.4721755981445,-1.11993849277491 43.4592018127442,-1.1186836957931 43.4558410644531,-1.10967254638672 43.45365524292,-1.1062655448913 43.4438743591309,-1.0877103805542 43.4439163208009,-1.0877103805542 43.4439163208009,-1.08462238311768 43.4418716430664,-1.07634174823761 43.4518508911133,-1.07274615764618 43.4503173828126,-1.07274615764618 43.4503173828126,-1.05978727340698 43.4585456848144,-1.05978727340698 43.4585456848144,-1.0636098384856 43.4683570861817,-1.05658364295959 43.4848175048828)) | 0.0006 | POINT(-1.0898716655270615 43.480654091670644) |
| 22936 | POLYGON((0.291106760501805 44.1328811645507,0.280145257711411 44.1207580566407,0.280145257711411 44.1207580566407,0.271072506904602 44.1100044250489,0.262489378452358 44.1075820922852,0.261707067489681 44.0947570800781,0.261707067489681 44.0947570800781,0.240776360034943 44.0720787048341,0.247029677033424 44.0592651367187,0.232810169458446 44.0460662841798,0.232810169458446 44.0460662841798,0.22996208071703 44.0527648925782,0.207823485136146 44.0652160644531,0.1940192282201 44.0622329711915,0.165930122137013 44.0639953613282,0.165930122137013 44.0639953613282,0.164162322878951 44.0776672363282,0.155571997165794 44.0805702209473,0.154451206326598 44.0939865112305,0.136731222271976 44.1098709106445,0.136731222271976 44.1098709106445,0.131909877061958 44.1189689636231,0.135797336697578 44.1241950988771,0.135797336697578 44.1241950988771,0.169479876756725 44.1227111816407,0.187385559081974 44.127223968506,0.191730409860725 44.13671875,0.215736448764801 44.1360511779785,0.215736448764801 44.1360511779785,0.237996220588684 44.1306457519531,0.251085668802318 44.1405220031739,0.263073951005879 44.1351737976075,0.291106760501805 44.1328811645507)) | 0.0006 | POINT(0.20965130673724458 44.100550055503895) |
| 62100 | POLYGON((7.83552646636963 52.6349563598633,7.83420276641857 52.6347198486328,7.83274555206299 52.6369667053223,7.82607412338251 52.6353187561036,7.82482671737665 52.6371574401856,7.8232274055481 52.6373977661133,7.81441068649298 52.6348266601563,7.81476306915295 52.634147644043,7.8117728233338 52.6330490112305,7.81176090240484 52.6308937072754,7.81176090240484 52.6308937072754,7.81329774856573 52.627914428711,7.81123352050793 52.6274223327637,7.81298637390137 52.6241569519043,7.81523704528809 52.6243591308595,7.8175511360169 52.6197471618652,7.81555175781256 52.6191177368164,7.82197618484503 52.6063117980958,7.81859064102179 52.6033058166505,7.82002210617071 52.6008720397949,7.81794929504406 52.59920501709,7.815667629242 52.5998039245606,7.81407499313366 52.5980224609376,7.81977748870861 52.5933609008789,7.81827545166027 52.5915451049806,7.82126522064215 52.5906105041504,7.82074975967402 52.5900344848634,7.82338333129883 52.58988571167,7.81691265106201 52.5846290588378,7.81871986389172 52.584312438965,7.81829738616943 52.5827560424805,7.81970024108892 52.5828704833984,7.81861972808844 52.5779457092286,7.82012033462524 52.57381439209,7.82194471359259 52.5734329223634,7.81994104385387 52.5708847045899,7.82245492935186 52.5700874328614,7.82454586029064 52.5724182128907,7.83190584182739 52.572826385498,7.835032939911 52.5706634521484,7.83505773544317 52.5682601928712,7.83505773544317 52.5682601928712,7.84615421295177 52.5689010620117,7.84972906112677 52.5718536376954,7.84954595565802 52.5725669860841,7.85246181488037 52.5716285705568,7.85395336151129 52.5725746154786,7.84938049316418 52.5757751464844,7.85139465332037 52.5794258117677,7.84914731979381 52.5824546813965,7.84727334976202 52.5824241638184,7.85211658477789 52.5862007141113,7.85097646713263 52.5897178649903,7.85097646713263 52.5897178649903,7.85011625289928 52.5933990478516,7.84885978698736 52.593132019043,7.84803915023804 52.5960083007812,7.84932184219372 52.5963096618652,7.84771537780767 52.6049423217773,7.84536790847778 52.6101608276367,7.84102582931524 52.6122207641602,7.84153366088867 52.6156425476075,7.83926391601574 52.6170158386232,7.83948802948004 52.6192169189454,7.83783006668102 52.6197471618652,7.83553457260138 52.6174430847167,7.83264207839972 52.6162567138672,7.82885551452642 52.6208572387696,7.8317956924439 52.6259918212891,7.83288049697882 52.6255187988282,7.83364009857183 52.6265563964844,7.83002233505249 52.6288337707521,7.83536338806158 52.6303825378419,7.83746051788341 52.6333541870118,7.83552646636963 52.6349563598633)) | 0.0006 | POINT(7.830632950808605 52.60250534882419) |
| 71681 | POLYGON((16.3181648254395 48.1028861999513,16.3096580505372 48.0925407409669,16.3096580505372 48.0925407409669,16.2874794006348 48.0959739685059,16.2847118377686 48.0944442749023,16.2775001525878 48.0870933532716,16.2673988342285 48.0865669250488,16.2673988342285 48.0865669250488,16.2628269195557 48.0972442626954,16.2628269195557 48.0972442626954,16.2581443786622 48.1061630249024,16.2581443786622 48.1061630249024,16.3181648254395 48.1028861999513)) | 0.0006 | POINT(16.28032604853316 48.09545230865485) |
| 50413 | POLYGON((2.12599682807917 49.2997970581055,2.10884952545177 49.3040771484376,2.10884952545177 49.3040771484376,2.09957313537598 49.303882598877,2.09957313537598 49.303882598877,2.0968976020813 49.2862968444824,2.0968976020813 49.2862968444824,2.12254905700684 49.2850837707521,2.12254905700684 49.2850837707521,2.12599682807917 49.2997970581055)) | 0.0006 | POINT(2.1090817186567725 49.29538642035598) |
| 61679 | POLYGON((8.61435985565186 47.5383148193359,8.61080455780035 47.5355758666993,8.61021041870117 47.5308837890625,8.60722160339361 47.5265884399415,8.60722160339361 47.5265884399415,8.60338973999029 47.5262298583986,8.60048580169672 47.5279884338379,8.59664058685314 47.5285682678223,8.59249877929682 47.5337371826172,8.58908271789562 47.5325431823731,8.5865592956543 47.530143737793,8.58440685272217 47.530616760254,8.58440685272217 47.530616760254,8.58236312866211 47.5395851135254,8.57422447204596 47.5456657409668,8.5725440979005 47.548210144043,8.56555271148687 47.5490646362305,8.56343269348145 47.5516548156739,8.55924892425548 47.5527801513672,8.55569171905523 47.555061340332,8.55569171905523 47.555061340332,8.55567741394043 47.5567626953124,8.55567741394043 47.5567626953124,8.55928134918224 47.5571136474611,8.56265640258783 47.5592308044434,8.56460571289074 47.5609931945801,8.56621360778814 47.5646743774415,8.56864929199213 47.5663719177247,8.56864929199213 47.5663719177247,8.57552528381359 47.5654563903809,8.57939624786383 47.5628814697266,8.58106899261475 47.5594787597656,8.58941936492926 47.5585899353027,8.59878826141363 47.5520324707031,8.59878826141363 47.5520324707031,8.59913539886486 47.5484466552735,8.60119342803949 47.545207977295,8.60827827453619 47.5427284240724,8.61435985565186 47.5383148193359)) | 0.0006 | POINT(8.582869529724157 47.54659512168486) |