Datenbank-Dokumentation

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.

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.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlüssel, der auf die Tabelle `orte` verweist.
geodaten

geometry

Dieser 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:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone.
mittelpunkt

point

Dieser 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:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
23224POLYGON((-0.522383570671025 43.340847015381,-0.53188294172287 43.3317832946778,-0.53188294172287 43.3317832946778,-0.543913006782532 43.3366394042969,-0.560195028781891 43.3491706848145,-0.573549747467041 43.3526039123536,-0.573549747467041 43.3526039123536,-0.575876593589726 43.3592720031739,-0.572018802165985 43.3655242919923,-0.572018802165985 43.3655242919923,-0.559342682361603 43.3689231872559,-0.558769285678864 43.378215789795,-0.558769285678864 43.378215789795,-0.542093157768193 43.3698387145997,-0.542093157768193 43.3698387145997,-0.550102055072728 43.3583908081055,-0.53140664100647 43.3499717712403,-0.53045117855072 43.3436470031739,-0.522383570671025 43.340847015381))0.0006POINT(-0.5516832570234776 43.355710771348825)
1402868POLYGON((1.68009698390966 41.5134391784668,1.67415297031403 41.5173912048341,1.68052101135254 41.5249557495118,1.67637503147131 41.5310859680176,1.6856809854508 41.5376472473144,1.68917000293732 41.5376777648926,1.6899590492248 41.5358314514161,1.70192396640789 41.541690826416,1.70327401161205 41.5374946594238,1.69842600822449 41.5337677001953,1.69736802577972 41.5279426574707,1.69215798377996 41.5226860046387,1.68809902668011 41.5230445861817,1.68168294429773 41.5209541320801,1.68009698390966 41.5134391784668))0.0006POINT(1.6884920001030292 41.528972080775695)
14269POLYGON((12.7338457107543 43.8703155517579,12.7289772033692 43.8648033142089,12.7245817184449 43.8621826171876,12.7018241882324 43.8595085144043,12.699933052063 43.8576965332031,12.7000751495361 43.855770111084,12.6977529525757 43.8537063598633,12.683515548706 43.8538246154786,12.683515548706 43.8538246154786,12.6837825775146 43.861499786377,12.6837825775146 43.861499786377,12.6913833618163 43.8630447387695,12.6957607269287 43.8746757507325,12.7145080566406 43.8819885253907,12.7211771011352 43.8826332092286,12.7237272262573 43.8820190429689,12.7237272262573 43.8820190429689,12.7331037521362 43.8736839294434,12.7344951629639 43.8708953857422,12.7344951629639 43.8708953857422,12.7338457107543 43.8703155517579))0.0006POINT(12.70969820022581 43.866824340820365)
29636POLYGON((3.02379798889172 47.7863731384277,3.02758431434626 47.7997665405273,3.02434444427502 47.8130798339845,3.02434444427502 47.8130798339845,3.05682921409613 47.816261291504,3.05682921409613 47.816261291504,3.08189368247997 47.8143310546876,3.09143471717846 47.8069877624512,3.09533190727245 47.797290802002,3.10391330719006 47.7935295104982,3.12403964996344 47.7927474975586,3.12715816497797 47.7954788208008,3.12715816497797 47.7954788208008,3.13589954376221 47.7873077392579,3.15654349327099 47.7863998413087,3.17524743080151 47.7804756164551,3.17524743080151 47.7804756164551,3.16066670417791 47.7675361633301,3.15809035301208 47.7586555480956,3.15809035301208 47.7586555480956,3.13793587684637 47.7589073181152,3.113361120224 47.7706527709962,3.10834050178534 47.7703857421874,3.10860753059399 47.7637634277344,3.10860753059399 47.7637634277344,3.08859872817999 47.7646713256835,3.08092308044445 47.7558822631837,3.0607569217683 47.7571105957032,3.04011440277105 47.7468948364259,3.03669357299805 47.7403526306152,3.02703189849865 47.7380065917969,3.02703189849865 47.7380065917969,3.01434421539307 47.7413635253907,3.01434421539307 47.7413635253907,3.02025723457331 47.7465476989747,3.01400279998779 47.7630119323732,3.02258777618403 47.7666091918945,3.02379798889172 47.7863731384277))0.0006POINT(3.0839995629079175 47.77533690993854)
30536POLYGON((-3.87515282630909 48.3010635375977,-3.84259700775146 48.3121757507324,-3.83658814430237 48.3248863220215,-3.81602692604065 48.327980041504,-3.79575443267817 48.3269348144532,-3.79575443267817 48.3269348144532,-3.79868698120112 48.3219718933106,-3.79090929031372 48.3205680847167,-3.79090929031372 48.3205680847167,-3.79238700866699 48.3172340393067,-3.80216813087463 48.3165435791016,-3.81529927253717 48.310890197754,-3.8146710395813 48.2939414978028,-3.79343366622919 48.2751693725587,-3.79407501220703 48.2618141174316,-3.79025363922119 48.259449005127,-3.77487492561335 48.2604866027831,-3.77487492561335 48.2604866027831,-3.74930930137634 48.2177658081055,-3.73940467834467 48.2159767150879,-3.73940467834467 48.2159767150879,-3.73340773582458 48.2038459777832,-3.73740673065186 48.2019500732422,-3.75385522842407 48.2073822021484,-3.75385522842407 48.2073822021484,-3.76131248474121 48.2121124267579,-3.80360412597656 48.2136688232422,-3.82409334182739 48.2100448608398,-3.84498786926264 48.2123641967773,-3.8666410446167 48.2021446228027,-3.88247394561768 48.2024421691896,-3.88247394561768 48.2024421691896,-3.87357592582697 48.2310523986818,-3.87357592582697 48.2310523986818,-3.87387084960938 48.2378616333009,-3.86302828788757 48.2494773864746,-3.8666296005249 48.262767791748,-3.86261200904835 48.2690887451172,-3.87666034698486 48.2853775024413,-3.87666034698486 48.2853775024413,-3.88354349136347 48.3009452819824,-3.87515282630909 48.3010635375977))0.0006POINT(-3.815044001835125 48.26140482832749)
1409108POLYGON((-2.10600805282593 43.0921707153321,-2.1141619682312 43.0867805480958,-2.12562203407282 43.0827026367187,-2.13026189804071 43.0879364013672,-2.12858700752253 43.0890769958497,-2.13347291946405 43.0919418334962,-2.13138389587402 43.0928916931153,-2.13526892662048 43.0936470031739,-2.13316106796265 43.0950012207032,-2.12545490264893 43.0968360900879,-2.12038397789001 43.0965080261232,-2.11710691452026 43.0946197509766,-2.11505603790283 43.0953140258789,-2.10986804962147 43.0930480957031,-2.10587811470032 43.0961074829102,-2.10344791412348 43.0959968566895,-2.10600805282593 43.0921707153321))0.0006POINT(-2.1209452301263556 43.092536211013844)
27383POLYGON((-1.22597408294678 49.0495033264161,-1.23385417461395 49.0431671142578,-1.23385417461395 49.0431671142578,-1.23510134220112 49.0368003845215,-1.24514663219452 49.0303497314454,-1.24597430229187 49.0146980285645,-1.24597430229187 49.0146980285645,-1.21605503559113 49.0156288146973,-1.21605503559113 49.0156288146973,-1.20588338375092 49.015968322754,-1.19747376441944 49.0198097229004,-1.19747376441944 49.0198097229004,-1.19808638095856 49.0300903320313,-1.21484398841852 49.0474014282227,-1.21484398841852 49.0474014282227,-1.22597408294678 49.0495033264161))0.0006POINT(-1.2217729568481146 49.029608154296916)
1407120POLYGON((-5.73477697372431 38.0862731933594,-5.73592805862427 38.0945358276368,-5.7339448928833 38.0982093811036,-5.73406314849854 38.1081390380859,-5.73495006561279 38.1144866943359,-5.74061393737787 38.1265563964844,-5.73869180679321 38.1328353881837,-5.73067378997803 38.1371192932129,-5.71857213973993 38.1362762451172,-5.71528816223145 38.133846282959,-5.70884704589844 38.1422576904298,-5.70429086685175 38.1433715820314,-5.6945858001709 38.1503639221193,-5.7056040763855 38.1640853881836,-5.70566320419312 38.1693992614747,-5.70187520980829 38.1672515869142,-5.69488286972046 38.1711044311523,-5.69376087188715 38.1682128906251,-5.68601894378662 38.1615867614747,-5.68412113189692 38.1570777893066,-5.68669605255121 38.1464157104493,-5.68633079528803 38.1380462646486,-5.6833181381225 38.1336822509767,-5.68342590332026 38.1284713745118,-5.68783092498779 38.1245231628419,-5.69095802307129 38.1165046691895,-5.68813419342035 38.1110267639161,-5.69109487533564 38.1053352355958,-5.70607089996332 38.094612121582,-5.7103009223938 38.0810623168945,-5.71944522857666 38.0850868225098,-5.73277091979975 38.0875358581544,-5.73477697372431 38.0862731933594))0.0006POINT(-5.708235308527921 38.12860286235815)
66427POLYGON((10.8715505599977 48.5312118530275,10.8642568588257 48.5062179565431,10.8642568588257 48.5062179565431,10.8593397140503 48.5055084228516,10.8533363342286 48.5062294006348,10.8533363342286 48.5062294006348,10.8456792831421 48.5098533630372,10.8431510925294 48.5150833129883,10.8355407714843 48.5120201110841,10.8345346450806 48.5134391784668,10.8320722579957 48.5130310058594,10.8285083770753 48.517650604248,10.8335485458375 48.5186386108398,10.8290901184083 48.5208778381348,10.8293418884277 48.5225830078126,10.8314256668092 48.5237236022949,10.8303146362305 48.5255317687989,10.829725265503 48.5264320373535,10.8254795074462 48.5271644592285,10.8230667114258 48.5267219543458,10.8210458755494 48.5303268432617,10.8215084075928 48.5327606201171,10.8231582641602 48.5323410034181,10.8256864547729 48.5338745117189,10.8244342803956 48.5390396118165,10.8227119445801 48.5386466979981,10.8219861984253 48.5435943603517,10.8193063735963 48.5438079833986,10.8188810348511 48.5450592041016,10.8149738311769 48.5459632873536,10.816107749939 48.5474967956544,10.8008975982666 48.5472869873047,10.7955646514893 48.5455932617188,10.7945928573609 48.5461883544922,10.7948007583618 48.5447692871093,10.7924966812134 48.5444221496583,10.7921543121338 48.5415306091309,10.7877368927002 48.5410461425782,10.788374900818 48.5389022827148,10.7903537750245 48.5370750427246,10.7902116775514 48.5359230041504,10.7733221054078 48.5349044799805,10.7733221054078 48.5349044799805,10.7734146118164 48.5369186401368,10.7725200653077 48.5367851257325,10.7720594406129 48.5391426086425,10.7696762084962 48.5405921936036,10.7678689956665 48.5404739379883,10.7678747177124 48.5415077209473,10.7658290863038 48.5413703918458,10.7659549713136 48.5446510314943,10.7681674957276 48.5454292297364,10.7635660171509 48.5485420227051,10.7626533508301 48.5501556396484,10.7633733749391 48.5531120300293,10.761287689209 48.5555610656738,10.7635698318481 48.5543403625489,10.763988494873 48.5564994812011,10.7687759399413 48.5576286315919,10.7692518234253 48.5607299804688,10.7707548141479 48.5626792907715,10.7742528915406 48.5632629394532,10.7807931900026 48.5626258850098,10.7807931900026 48.5626258850098,10.790228843689 48.5615577697754,10.7905683517457 48.5639152526857,10.7932510375977 48.5639419555665,10.7932577133179 48.5650863647462,10.7997608184814 48.5650863647462,10.7998495101928 48.5641670227051,10.8012857437134 48.5642356872559,10.8010396957397 48.5615386962892,10.8089733123779 48.5587196350098,10.8094034194947 48.5582237243652,10.8074607849121 48.5572853088379,10.8097734451294 48.5566520690919,10.8093280792236 48.5548362731934,10.8131999969482 48.554500579834,10.8131923675537 48.553321838379,10.8166818618774 48.5526008605958,10.8172197341919 48.5540580749512,10.8275747299194 48.553020477295,10.8279237747193 48.554557800293,10.8286533355713 48.5543403625489,10.8286533355713 48.5543403625489,10.8524084091187 48.5557212829591,10.8532848358154 48.5571403503418,10.8562946319581 48.5574798583985,10.8501110076905 48.5828933715821,10.851682662964 48.5829429626465,10.8509941101075 48.585147857666,10.8524446487426 48.5851707458496,10.8522491455079 48.5862159729005,10.8522491455079 48.5862159729005,10.8600492477417 48.5871543884278,10.8632154464723 48.5863952636719,10.8647804260255 48.5873184204102,10.8714809417725 48.5878448486329,10.8714809417725 48.5878448486329,10.8743677139283 48.5879440307617,10.8693561553955 48.5739593505859,10.8732137680054 48.5397834777832,10.8715505599977 48.5312118530275))0.0006POINT(10.814456406761659 48.547623690436886)
47653POLYGON((2.09543013572699 50.5548706054689,2.0775294303894 50.5514183044434,2.0775294303894 50.5514183044434,2.0725183486939 50.5504226684571,2.06832075119019 50.5442962646484,2.04938316345221 50.5415916442872,2.03946185112 50.5300445556641,2.04066467285162 50.5267868041993,2.04066467285162 50.5267868041993,2.04591894149792 50.5207481384277,2.05942988395697 50.5150260925293,2.05942988395697 50.5150260925293,2.10217189788818 50.5221138000489,2.1138551235199 50.5295028686525,2.11769580841076 50.5361366271972,2.11769580841076 50.5361366271972,2.1027336120606 50.5395660400391,2.09623527526855 50.5523986816407,2.09623527526855 50.5523986816407,2.09543013572699 50.5548706054689))0.0006POINT(2.0775212614160257 50.536667873984925)