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 |
|---|---|---|---|
| 46917 | POLYGON((3.26824879646307 50.2781486511231,3.27747654914856 50.2668685913087,3.27532696723949 50.2605323791503,3.27071166038507 50.259204864502,3.27071166038507 50.259204864502,3.27800893783569 50.2515754699707,3.28264689445496 50.2520027160645,3.28264689445496 50.2520027160645,3.28643178939819 50.2650680541992,3.29717326164251 50.276554107666,3.29242849349981 50.2822685241699,3.29242849349981 50.2822685241699,3.28380012512218 50.2853584289551,3.26824879646307 50.2781486511231)) | 0.0006 | POINT(3.281387732579182 50.26700445321892) |
| 1390488 | POLYGON((-1.40898001193989 41.0714378356935,-1.39985799789423 41.0789222717286,-1.39863705635065 41.0846176147461,-1.38130605220789 41.0946884155273,-1.36666703224182 41.097770690918,-1.36275398731232 41.0942993164063,-1.36066198348993 41.0879440307618,-1.3780859708786 41.0730857849121,-1.39725601673126 41.0659599304199,-1.40516197681421 41.066318511963,-1.40898001193989 41.0714378356935)) | 0.0006 | POINT(-1.38593680858608 41.08150444030766) |
| 22187 | POLYGON((-0.198189318180084 44.6830215454102,-0.212213188409748 44.6842193603516,-0.23445138335228 44.681308746338,-0.23445138335228 44.681308746338,-0.240557223558426 44.6937026977539,-0.240557223558426 44.6937026977539,-0.231313079595566 44.704746246338,-0.231313079595566 44.704746246338,-0.213301822543087 44.7015228271484,-0.195703908801022 44.7057647705079,-0.195703908801022 44.7057647705079,-0.197019785642567 44.7029075622559,-0.188574805855751 44.6929931640626,-0.188574805855751 44.6929931640626,-0.192417353391647 44.6836853027345,-0.192417353391647 44.6836853027345,-0.198189318180084 44.6830215454102)) | 0.0006 | POINT(-0.21167247649280435 44.69350457191474) |
| 58770 | POLYGON((8.53377246856695 51.8314018249513,8.53117084503185 51.8257179260254,8.52974605560303 51.8180351257325,8.52452373504639 51.8155746459962,8.52494239807135 51.8143043518066,8.52086162567133 51.8106346130371,8.52140140533447 51.8095817565919,8.51469421386719 51.8060531616212,8.50555324554443 51.8032417297363,8.49771118164057 51.7981643676758,8.49234104156506 51.7976760864258,8.4871883392334 51.7954177856446,8.47937774658214 51.7948837280275,8.47049236297602 51.7916183471681,8.46831703186041 51.7918357849122,8.46008110046381 51.784351348877,8.45256710052496 51.7822456359863,8.4476461410523 51.7794151306152,8.41769313812262 51.7595710754395,8.40937137603771 51.748924255371,8.41015243530279 51.7479667663575,8.40909767150879 51.7348022460939,8.4073362350465 51.7292556762696,8.40379905700695 51.7274017333984,8.40310764312756 51.7193565368653,8.40310764312756 51.7193565368653,8.41068077087397 51.7183189392089,8.42835617065441 51.719825744629,8.43331909179693 51.7181129455568,8.43752479553223 51.7186737060547,8.44153976440424 51.7171974182129,8.46258163452148 51.7229614257814,8.46457672119141 51.7205810546876,8.46810436248785 51.7210922241211,8.46810436248785 51.7210922241211,8.46914005279541 51.721305847168,8.46843910217285 51.7226371765137,8.47135448455816 51.7232856750488,8.47283363342285 51.722080230713,8.4828777313233 51.7241783142091,8.48431491851812 51.7224655151367,8.49135780334478 51.7237739562989,8.49045848846441 51.7142562866211,8.49512958526623 51.7137870788574,8.49907779693604 51.7155799865723,8.5036153793335 51.7115440368653,8.50054454803472 51.7112045288086,8.50117588043213 51.7103424072267,8.50490760803228 51.7108192443849,8.50594234466553 51.7099990844728,8.5177259445191 51.7131843566895,8.5194988250733 51.7120552062988,8.51916885375971 51.7093200683594,8.52277660369873 51.7096252441407,8.52879238128662 51.7125511169435,8.52762985229498 51.7132949829102,8.52901172637945 51.7145156860352,8.53362274169922 51.7154388427735,8.53588676452642 51.7177009582521,8.53622055053717 51.7161521911622,8.53503513336187 51.71590423584,8.53809642791754 51.7131805419922,8.53576183319092 51.7115135192871,8.53737735748302 51.7096519470215,8.54005527496349 51.7103614807129,8.54200935363764 51.7088165283204,8.54555606842052 51.7114791870118,8.55119132995611 51.7107810974122,8.55256748199469 51.7090950012208,8.55177307128912 51.7042846679689,8.56128692626953 51.7053909301759,8.56086254119884 51.7081947326661,8.57251167297358 51.7172889709473,8.58240699768078 51.7232398986818,8.58273696899414 51.7253875732422,8.59253501892096 51.7253646850587,8.59470844268793 51.7277069091798,8.59855556488048 51.7292251586915,8.5981121063233 51.729892730713,8.61900520324718 51.7287254333497,8.61679458618175 51.7273750305176,8.61782550811768 51.7266082763671,8.62287521362316 51.7281913757325,8.62382316589361 51.7262992858888,8.62831115722668 51.7274589538575,8.62824535369867 51.7255210876466,8.64234733581549 51.7268714904786,8.64234733581549 51.7268714904786,8.64123058319092 51.7329444885255,8.64392662048351 51.7343635559082,8.63950061798107 51.7416191101074,8.6403865814209 51.7429924011231,8.63996696472168 51.7497329711914,8.64179897308355 51.7524528503417,8.63937377929699 51.753604888916,8.63687610626215 51.7615089416504,8.64080810546875 51.7643165588379,8.64154052734375 51.769115447998,8.63576316833496 51.7712745666504,8.64240741729731 51.7766075134278,8.6656436920166 51.7861099243165,8.6814022064209 51.7904472351074,8.67840671539307 51.7924270629883,8.67840671539307 51.7924270629883,8.67530345916759 51.7941780090333,8.67393684387218 51.7938804626465,8.66564083099371 51.7991676330568,8.66013908386242 51.7966880798341,8.64548206329346 51.8091468811035,8.64160251617432 51.8078269958496,8.63192844390875 51.8136405944825,8.63190269470226 51.815315246582,8.62661075592052 51.8197326660156,8.61994266510021 51.8198051452637,8.61845684051525 51.8178100585938,8.6161470413208 51.8180503845216,8.61489105224615 51.8149719238281,8.612470626831 51.8147659301758,8.60985946655279 51.811222076416,8.60464000701904 51.8096466064453,8.60340595245367 51.8114089965821,8.5985889434815 51.8085517883301,8.5966854095459 51.8131179809571,8.57074737548822 51.81742477417,8.5738897323609 51.8248443603515,8.5715656280517 51.8248405456544,8.57138442993175 51.8260345458984,8.57334613800043 51.8263549804689,8.57456588745123 51.8380393981935,8.57120037078852 51.843418121338,8.57120037078852 51.843418121338,8.56226348876959 51.8416938781739,8.56257343292242 51.8409271240234,8.56008815765381 51.8397178649903,8.55663967132568 51.8394584655762,8.55582332611095 51.8402175903321,8.55310058593756 51.839527130127,8.54310131073004 51.8343467712402,8.53377246856695 51.8314018249513)) | 0.0006 | POINT(8.55053349508759 51.76063449140909) |
| 59413 | POLYGON((7.64839506149292 47.5653381347657,7.64979076385498 47.5686645507813,7.65544414520275 47.5748596191407,7.65638303756714 47.577262878418,7.66909980773931 47.5768508911133,7.67035484313971 47.5780296325683,7.67074918746954 47.5817909240724,7.67194986343384 47.5838203430176,7.67194986343384 47.5838203430176,7.67740488052362 47.5763473510743,7.68145513534546 47.5746879577637,7.68158721923828 47.5732612609863,7.67984914779669 47.5709114074708,7.6774520874024 47.5707015991211,7.67344713211054 47.5724182128906,7.66707992553717 47.5678634643555,7.65433597564697 47.5672721862794,7.64839506149292 47.5653381347657)) | 0.0006 | POINT(7.668042828055009 47.57434710334333) |
| 20626 | POLYGON((7.43254613876343 48.8608856201172,7.43561983108526 48.8524208068848,7.43162441253673 48.8431663513185,7.43162441253673 48.8431663513185,7.45349454879766 48.8365516662598,7.4623069763183 48.8389167785645,7.4623069763183 48.8389167785645,7.45857715606689 48.848258972168,7.45977497100836 48.8584213256837,7.46417188644421 48.8601837158204,7.46417188644421 48.8601837158204,7.45865631103521 48.8657608032228,7.45865631103521 48.8657608032228,7.43254613876343 48.8608856201172)) | 0.0006 | POINT(7.4518101398761925 48.8517379760743) |
| 17758 | POLYGON((8.69723224639898 45.3564186096191,8.67961502075195 45.3642387390137,8.67961502075195 45.3642387390137,8.67462825775158 45.3824157714844,8.67462825775158 45.3824157714844,8.68538093566906 45.3856506347656,8.68968296051031 45.3926734924317,8.69743919372564 45.3950347900391,8.69743919372564 45.3950347900391,8.70174121856689 45.3902206420898,8.70951652526867 45.383861541748,8.71434974670416 45.3837738037109,8.71895503997803 45.3809356689454,8.72014331817633 45.379020690918,8.72014331817633 45.379020690918,8.72147464752197 45.3756904602051,8.72147464752197 45.3756904602051,8.70974731445324 45.3736763000489,8.69754981994635 45.3621139526368,8.69723224639898 45.3564186096191)) | 0.0006 | POINT(8.700566141228979 45.37905923943772) |
| 25911 | POLYGON((2.3450973033905 48.7970733642579,2.34781217575085 48.8009834289552,2.34781217575085 48.8009834289552,2.34489369392401 48.8056983947754,2.34489369392401 48.8056983947754,2.33776092529297 48.8130416870118,2.32906317710888 48.8137855529786,2.32906317710888 48.8137855529786,2.31906294822693 48.809970855713,2.31906294822693 48.809970855713,2.32393789291376 48.8015518188477,2.32393789291376 48.8015518188477,2.3450973033905 48.7970733642579)) | 0.0006 | POINT(2.3343665003776946 48.806174596150804) |
| 14282 | POLYGON((13.537748336792 45.9850692749025,13.4939289093018 45.9901580810547,13.4939289093018 45.9901580810547,13.4957342147827 45.9870414733887,13.4948892593384 45.9853553771974,13.49085521698 45.9826469421387,13.4880514144899 45.9856491088868,13.4774255752563 45.9881019592285,13.4666166305541 45.9879837036133,13.4657964706421 45.9869461059571,13.4657964706421 45.9869461059571,13.4654474258423 45.9850997924806,13.4641628265382 45.9848289489746,13.4596042633057 45.9862709045411,13.4420003890992 45.9763832092286,13.4376049041749 45.9729499816896,13.4376049041749 45.9729499816896,13.4409399032594 45.9695549011232,13.4437446594238 45.9588127136231,13.4432792663575 45.9579544067383,13.437707901001 45.9564628601074,13.4294357299805 45.9514236450196,13.4211893081665 45.9424209594727,13.4213962554932 45.939666748047,13.4213962554932 45.939666748047,13.421748161316 45.9313850402833,13.421748161316 45.9313850402833,13.4337596893311 45.9284896850586,13.4464492797852 45.9303817749023,13.4488925933838 45.929759979248,13.456868171692 45.9222412109376,13.456868171692 45.9222412109376,13.4617309570314 45.92484664917,13.4810304641724 45.9298362731935,13.4868030548095 45.9300422668458,13.4868030548095 45.9300422668458,13.4945449829103 45.9384765625001,13.4945449829103 45.9384765625001,13.4970245361329 45.9431343078614,13.4976196289062 45.9507598876954,13.4923076629639 45.9548835754394,13.5151386260987 45.96337890625,13.5183725357056 45.9626235961914,13.5183725357056 45.9626235961914,13.537748336792 45.9850692749025)) | 0.0006 | POINT(13.467429832978729 45.95853432742037) |
| 73143 | POLYGON((10.002345085144 47.2711944580079,9.99583530426031 47.2795715332032,9.99405097961437 47.2847137451172,9.99507427215576 47.2875328063966,10.0024185180663 47.2980232238771,10.0024929046631 47.3005104064941,10.0002326965332 47.3067855834962,10.000774383545 47.3113441467286,10.0095529556274 47.329200744629,10.0238761901855 47.3457946777345,10.0238761901855 47.3457946777345,10.0092058181762 47.3404960632325,10.0032663345337 47.3451919555665,10.0032663345337 47.3451919555665,9.97081470489513 47.3407440185547,9.96745491027838 47.338924407959,9.96575546264648 47.3349761962891,9.95943260192882 47.3368072509767,9.9547004699707 47.3368873596193,9.92670631408703 47.3305854797364,9.92670631408703 47.3305854797364,9.92735671997065 47.3197593688966,9.92646312713629 47.3173789978028,9.92506027221674 47.3164367675781,9.88665199279797 47.3099975585938,9.88665199279797 47.3099975585938,9.92928504943848 47.2866325378418,9.92928504943848 47.2866325378418,9.93387031555181 47.2898025512695,9.93692684173595 47.2901229858398,9.94359493255627 47.2812385559083,9.94667053222668 47.2787017822266,9.96690940856934 47.2748489379884,9.96861553192144 47.2718925476075,9.96910572052013 47.2666893005372,9.96910572052013 47.2666893005372,10.002345085144 47.2711944580079)) | 0.0006 | POINT(9.966205332014333 47.3085465961033) |