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 |
|---|---|---|---|
| 25698 | POLYGON((2.35346364974987 48.9656257629394,2.34370541572582 48.967212677002,2.33331298828136 48.9553833007814,2.33331298828136 48.9553833007814,2.34579586982738 48.9465293884278,2.34579586982738 48.9465293884278,2.35202693939209 48.9504852294922,2.35202693939209 48.9504852294922,2.35346364974987 48.9656257629394)) | 0.0006 | POINT(2.344930082559669 48.95470428466802) |
| 15829 | POLYGON((10.4642295837403 45.0945892333984,10.4332504272462 45.091651916504,10.4183349609376 45.0928459167481,10.4183349609376 45.0928459167481,10.4203653335571 45.0993461608887,10.4165449142457 45.1000976562499,10.4124937057496 45.1033325195314,10.4127817153931 45.1206741333009,10.4169473648071 45.120964050293,10.4169473648071 45.120964050293,10.4243135452271 45.121208190918,10.4238758087159 45.1184120178223,10.4479694366456 45.1139221191407,10.4492273330689 45.1139068603516,10.4550876617432 45.1184234619141,10.4575872421265 45.1162147521972,10.4575872421265 45.1162147521972,10.4676952362061 45.0964241027832,10.4642295837403 45.0945892333984)) | 0.0006 | POINT(10.43408743540451 45.10844654507109) |
| 25275 | POLYGON((2.78525257110601 49.0047454833985,2.77313709259033 49.0092201232911,2.77427220344543 49.0122451782228,2.77427220344543 49.0122451782228,2.77902030944836 49.0111274719239,2.79067015647888 49.0170402526856,2.80064821243298 49.0174865722657,2.80064821243298 49.0174865722657,2.80636000633234 49.0145950317383,2.80636000633234 49.0145950317383,2.80968332290649 48.9917755126954,2.80968332290649 48.9917755126954,2.80656194686901 48.9933624267579,2.80656194686901 48.9933624267579,2.78525257110601 49.0047454833985)) | 0.0006 | POINT(2.7945093938282914 49.007218769618525) |
| 56621 | POLYGON((4.74143648147583 45.968547821045,4.7447967529298 45.9751358032228,4.7359766960144 45.9785118103028,4.71089792251598 45.9792442321778,4.70775318145752 45.9819946289063,4.69810533523565 45.9799957275391,4.69810533523565 45.9799957275391,4.69452714920055 45.9749870300294,4.69452714920055 45.9749870300294,4.70280838012695 45.9666481018068,4.72154331207287 45.9623107910157,4.72154331207287 45.9623107910157,4.7301983833313 45.9611358642578,4.73704481124889 45.9689674377443,4.74143648147583 45.968547821045)) | 0.0006 | POINT(4.717090300151344 45.972483771188) |
| 56782 | POLYGON((5.97804641723633 45.6864624023438,5.95973920822144 45.7013816833497,5.94568634033203 45.7024192810059,5.94568634033203 45.7024192810059,5.94902849197382 45.7117919921874,5.96450233459478 45.7237854003907,5.96450233459478 45.7237854003907,5.98162698745728 45.7070960998536,5.9903874397279 45.6911926269531,5.97804641723633 45.6864624023438)) | 0.0006 | POINT(5.964356210496711 45.705592685275654) |
| 63496 | POLYGON((12.0616235733032 53.3714179992675,12.0557870864869 53.3704338073732,12.0452852249147 53.3709869384766,12.0513715744019 53.3668670654297,12.048062324524 53.3650283813476,12.0474042892456 53.3612403869629,12.0515184402466 53.3602218627931,12.054488182068 53.3537864685059,12.0528812408447 53.3532829284669,12.0573396682739 53.3493423461915,12.0488023757935 53.3481216430665,12.0461263656616 53.3474807739257,12.0463390350342 53.3466949462892,12.0387115478516 53.3450813293458,12.0392684936523 53.3442497253419,12.0227231979371 53.3379631042481,12.023295402527 53.336727142334,12.0146112442017 53.3344230651855,12.0146112442017 53.3344230651855,12.0071353912354 53.3323402404785,12.0043745040894 53.3332633972167,12.0025606155397 53.3351211547852,12.0045080184938 53.338062286377,12.0031480789184 53.3404693603516,12.0025157928467 53.3465805053711,11.9986972808837 53.3460540771485,11.998664855957 53.3433952331543,11.9927806854249 53.3434371948243,11.9927806854249 53.3434371948243,11.9824209213257 53.3458099365234,11.9838495254517 53.3529739379884,11.9898319244385 53.3530654907227,11.9941940307618 53.3505668640138,12.0019178390504 53.3532676696778,12.0017528533936 53.3563461303712,11.9989233016968 53.3592834472657,11.9938526153565 53.3595237731934,11.9903440475464 53.3575515747071,11.9821338653564 53.3569259643555,11.9659910202027 53.3576469421388,11.9629030227661 53.3569641113282,11.9530725479125 53.3595733642579,11.9550638198853 53.3625259399415,11.944507598877 53.3586502075196,11.958312034607 53.3521919250488,11.9570989608765 53.3514633178712,11.9526872634888 53.353572845459,11.9526872634888 53.353572845459,11.9402875900269 53.3582649230957,11.9417371749878 53.3598594665528,11.9406099319458 53.3612289428711,11.936469078064 53.3628158569337,11.9352531433105 53.3642234802246,11.9333486557008 53.3643531799316,11.931742668152 53.3662605285644,11.9290332794191 53.3666038513185,11.9283199310303 53.3691558837891,11.9138879776002 53.3746376037599,11.9068603515626 53.3748626708985,11.8867483139039 53.3786582946777,11.8803367614746 53.3808059692384,11.8803367614746 53.3808059692384,11.8835430145265 53.3828659057618,11.8869657516479 53.3874626159668,11.8886060714723 53.393711090088,11.8881835937501 53.3946075439453,11.8853435516357 53.3951416015626,11.8856267929078 53.397933959961,11.8888731002808 53.3992996215821,11.8935146331787 53.3995895385742,11.9023275375366 53.3976898193359,11.9072360992432 53.4002304077149,11.912618637085 53.4010887145997,11.914218902588 53.4022102355958,11.9199180603028 53.4017295837403,11.9207201004029 53.4023323059082,11.9197664260865 53.4040145874024,11.9163875579833 53.4055824279785,11.913745880127 53.4053001403809,11.9136972427369 53.4075202941895,11.9171304702759 53.4094772338867,11.9202728271484 53.4145545959473,11.9266834259034 53.4159889221193,11.9325656890869 53.4196586608888,11.932011604309 53.4238929748535,11.932011604309 53.4238929748535,11.9391279220582 53.4247779846193,11.9415340423585 53.4206085205079,11.9374818801881 53.4176979064942,11.9420309066772 53.4164772033691,11.9428691864015 53.4146614074708,11.9462509155273 53.4130363464355,11.9593925476075 53.4096450805665,11.9622993469238 53.4075012207032,11.9643125534058 53.4078636169434,11.9722242355347 53.405601501465,11.9753017425538 53.4058799743653,11.9753017425538 53.4058799743653,11.9762239456178 53.4046630859376,11.9750089645387 53.4020729064943,11.9724225997925 53.3998641967774,11.97438621521 53.3983230590821,11.9719038009644 53.3942337036133,11.9736280441285 53.3927574157716,11.9730644226075 53.3898353576661,11.9738874435426 53.3874702453613,11.9766931533815 53.3877601623536,11.9778251647949 53.3892097473145,11.9803428649903 53.3898620605469,12.0008783340455 53.3910331726075,12.0047197341919 53.3934516906739,12.0115289688111 53.39510345459,12.0141839981079 53.3979644775392,12.0141839981079 53.3979644775392,12.0158767700195 53.396900177002,12.0199060440063 53.3990440368653,12.0246076583863 53.3984375,12.024435043335 53.3956260681153,12.0359964370729 53.3938102722169,12.0424737930298 53.390251159668,12.0450820922852 53.3904533386232,12.049295425415 53.3888168334962,12.0514030456543 53.3863449096681,12.0559129714966 53.3841857910157,12.056339263916 53.383487701416,12.0551252365113 53.3819007873535,12.0573072433472 53.3806953430176,12.0573129653931 53.3783073425293,12.064151763916 53.3774185180663,12.0648775100709 53.375431060791,12.0616235733032 53.3714179992675)) | 0.0006 | POINT(11.97680779237017 53.37816948523889) |
| 49330 | POLYGON((-1.48236095905304 46.3726387023926,-1.48159635066975 46.3717422485352,-1.46271562576294 46.3742866516114,-1.45348584651947 46.3726348876954,-1.44065821170801 46.3772048950196,-1.44065821170801 46.3772048950196,-1.417032122612 46.373161315918,-1.41894590854633 46.3570442199708,-1.39959597587585 46.3538894653321,-1.36985731124872 46.3540115356445,-1.36595261096954 46.3561668395997,-1.36595261096954 46.3561668395997,-1.36013758182526 46.3521766662597,-1.35604643821711 46.3529739379883,-1.35604643821711 46.3529739379883,-1.35412871837616 46.3412513732911,-1.35412871837616 46.3412513732911,-1.37041699886322 46.3459739685059,-1.38597202301025 46.3409729003907,-1.39235997200012 46.3418045043945,-1.39597296714783 46.3406944274903,-1.40236103534693 46.3406944274903,-1.40930497646326 46.3429183959962,-1.4129159450531 46.3454170227051,-1.42041599750507 46.3470840454103,-1.42791700363159 46.3470840454103,-1.42986094951624 46.3448600769044,-1.428472995758 46.3443069458008,-1.42930495738983 46.3429183959962,-1.433748960495 46.3429183959962,-1.4373619556427 46.3398628234864,-1.46764004230494 46.3423614501953,-1.47125005722046 46.3456954956055,-1.47431576251978 46.3545837402344,-1.47652900218964 46.358196258545,-1.47763895988464 46.3643074035645,-1.48236095905304 46.3726387023926)) | 0.0006 | POINT(-1.4173072278499335 46.35303984747998) |
| 32585 | POLYGON((1.35472476482391 47.6890106201172,1.34412384033209 47.6937675476075,1.34541165828716 47.7059745788575,1.34541165828716 47.7059745788575,1.33664691448212 47.7086067199708,1.32742989063269 47.706916809082,1.32139253616339 47.7152404785157,1.31066441535955 47.7216377258302,1.31066441535955 47.7216377258302,1.30172550678265 47.7082481384278,1.30172550678265 47.7082481384278,1.28203177452099 47.6939697265625,1.27257442474371 47.694480895996,1.26044166088116 47.7005462646486,1.26044166088116 47.7005462646486,1.25370931625378 47.6878509521484,1.2641259431839 47.6721878051758,1.26294803619396 47.6617012023926,1.27177631855017 47.6532897949219,1.27177631855017 47.6532897949219,1.28098106384289 47.6558456420899,1.28098106384289 47.6558456420899,1.30384135246283 47.6623115539552,1.32862031459814 47.6744880676271,1.32862031459814 47.6744880676271,1.35472476482391 47.6890106201172)) | 0.0006 | POINT(1.3009116268158727 47.68904418945319) |
| 15375 | POLYGON((10.3758525848389 45.6887588500977,10.3623838424684 45.6983871459962,10.3623838424684 45.6983871459962,10.3537921905517 45.6968231201172,10.3515872955323 45.6975250244141,10.3462657928466 45.6957702636718,10.3291521072388 45.689552307129,10.3013076782227 45.6774978637695,10.2989616394043 45.6727676391602,10.2983961105347 45.6683464050294,10.2994556427002 45.664405822754,10.2994556427002 45.664405822754,10.3053035736084 45.6663627624512,10.3113822937012 45.6649971008301,10.3190479278566 45.6596107482911,10.3220129013063 45.6539840698243,10.3220129013063 45.6539840698243,10.3251161575317 45.6529426574706,10.3330459594727 45.6588325500489,10.3547601699829 45.6603164672852,10.3644990921022 45.662296295166,10.3644990921022 45.662296295166,10.3681182861328 45.6669960021973,10.3685903549194 45.6689987182618,10.3654851913453 45.6727333068849,10.3630428314208 45.6784439086914,10.3657808303834 45.6817588806152,10.3746929168701 45.6859817504884,10.3758525848389 45.6887588500977)) | 0.0006 | POINT(10.33951374462677 45.673684392656654) |
| 62562 | POLYGON((10.1139345169067 51.6137580871583,10.1104373931885 51.6113662719728,10.1104965209962 51.6098594665528,10.115348815918 51.6088714599611,10.1135053634644 51.6046981811525,10.112292289734 51.6046409606933,10.1113729476929 51.6005897521974,10.11252784729 51.5974655151368,10.1175355911254 51.5973358154297,10.1159200668335 51.5939750671387,10.1249389648438 51.5940055847168,10.1265573501588 51.5924377441407,10.1323709487915 51.5918159484864,10.1331529617311 51.5943641662598,10.1397647857667 51.5943832397462,10.1413145065309 51.5965309143067,10.1495914459229 51.5956993103027,10.1495914459229 51.5956993103027,10.1492700576783 51.5905685424806,10.1461162567139 51.587429046631,10.1544885635376 51.5841979980469,10.1533050537109 51.5821952819824,10.1490411758423 51.5808525085449,10.1496114730836 51.5798645019532,10.1496114730836 51.5798645019532,10.1438922882081 51.5782165527343,10.143217086792 51.5758399963378,10.143217086792 51.5758399963378,10.1388025283813 51.5754585266113,10.1380767822266 51.5777130126953,10.1395769119263 51.5779609680176,10.1387577056885 51.5810813903809,10.1330089569091 51.581325531006,10.1327905654908 51.5833930969239,10.1295862197877 51.5831871032715,10.1295557022095 51.5851097106934,10.1225881576538 51.5842514038087,10.1215791702271 51.5857772827149,10.1185474395753 51.5856170654298,10.1096210479737 51.5823822021486,10.0875358581544 51.586238861084,10.0891790390014 51.5882797241212,10.0863456726075 51.5901222229005,10.0868539810181 51.5930213928223,10.0909776687623 51.5922241210938,10.0958395004272 51.594482421875,10.098030090332 51.5990409851075,10.0907440185547 51.5989112854003,10.085397720337 51.5975036621094,10.0845756530762 51.5987586975098,10.0721282958985 51.6027526855469,10.0709629058838 51.6058921813965,10.0737752914429 51.6077003479004,10.0706844329834 51.6091842651367,10.0706844329834 51.6091842651367,10.0742225646972 51.6140289306642,10.07914352417 51.6147842407228,10.0822906494142 51.6170768737793,10.1001043319702 51.622169494629,10.1033697128296 51.6223526000977,10.1132564544678 51.6191711425782,10.1127061843873 51.6181831359863,10.1139345169067 51.6137580871583)) | 0.0006 | POINT(10.115866507253376 51.59510784764447) |