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
69843POLYGON((9.89752101898193 54.1967468261719,9.91495037078857 54.2147903442383,9.90752696990967 54.2164459228517,9.90768337249762 54.2184104919435,9.89789199829107 54.2272109985352,9.89867210388184 54.2295036315919,9.89608192443848 54.2305793762208,9.89718818664551 54.2336921691896,9.89535427093517 54.234390258789,9.89092350006104 54.2333831787111,9.89092350006104 54.2333831787111,9.89371776580822 54.2363128662109,9.89372634887701 54.2389717102051,9.89372634887701 54.2389717102051,9.89654922485357 54.2365951538087,9.89871025085455 54.2366333007814,9.90347766876226 54.2410850524903,9.90223789215094 54.2431526184083,9.90662384033214 54.2430763244628,9.9070777893067 54.2413177490234,9.9154109954834 54.2406539916993,9.91569232940685 54.2425079345704,9.92862224578869 54.2421188354493,9.93120574951178 54.2438964843751,9.93201732635504 54.2462539672852,9.93340778350836 54.2466545104982,9.93356800079351 54.2484703063965,9.93666458129894 54.2485198974609,9.93701553344732 54.2498397827148,9.93834972381603 54.2497749328613,9.93989753723139 54.247501373291,9.93864822387695 54.2457466125488,9.93549633026134 54.2452011108399,9.93582248687756 54.2437019348145,9.93461036682129 54.2426643371583,9.93607234954834 54.242202758789,9.93928337097168 54.2440795898439,9.94056415557861 54.2422065734864,9.94233989715582 54.2424392700195,9.94890308380138 54.2399787902833,9.95002365112316 54.2410736083984,9.9481372833252 54.2422599792482,9.95037460327154 54.2436065673828,9.95277786254883 54.2402839660645,9.95415019989019 54.2396430969238,9.95653533935553 54.2413711547852,9.95898342132574 54.239315032959,9.95898342132574 54.239315032959,9.96100616455089 54.2393760681153,9.96586513519293 54.2369995117188,9.97362804412853 54.2389373779298,9.97541427612299 54.2382965087891,9.97541427612299 54.2382965087891,9.97784709930431 54.2336730957031,9.97721672058105 54.2313194274903,9.97601509094238 54.2305145263672,9.97620582580566 54.2274703979493,9.97883510589605 54.2242050170899,9.97883510589605 54.2242050170899,9.97805404663097 54.2228927612306,9.97965145111095 54.2213249206542,9.97730636596691 54.2188186645508,9.97815418243408 54.2146644592285,9.97697925567621 54.212989807129,9.97662448883062 54.2093887329103,9.97402763366705 54.2087669372559,9.96773529052734 54.2109489440919,9.96470260620129 54.2071571350099,9.96650314331055 54.2077636718751,9.96889019012463 54.2067527770997,9.960117340088 54.2026367187501,9.960117340088 54.2026367187501,9.95461845397955 54.2002601623536,9.95138740539551 54.2013969421387,9.95048141479492 54.2003593444824,9.94925403594976 54.20174407959,9.94739723205566 54.1996002197266,9.9430885314942 54.1987648010255,9.93736362457287 54.1997261047364,9.93324279785156 54.2032470703126,9.9292364120484 54.2003974914551,9.92731857299816 54.2006607055664,9.92724323272705 54.1959457397462,9.92475986480724 54.1938323974609,9.92361545562756 54.1889419555665,9.92194080352789 54.1870460510254,9.91886615753174 54.1868438720704,9.91695499420177 54.185516357422,9.91645050048828 54.1865539550781,9.91419982910162 54.1865806579591,9.91207981109619 54.1825942993165,9.9062261581422 54.1818466186524,9.9062261581422 54.1818466186524,9.90446472167974 54.183032989502,9.90402126312256 54.1851768493653,9.89995670318615 54.1857223510743,9.89802837371826 54.187816619873,9.89279556274425 54.1897010803223,9.89415645599371 54.1909561157227,9.89415645599371 54.1909561157227,9.89754962921148 54.1925086975099,9.89752101898193 54.1967468261719))0.0006POINT(9.934221277142564 54.22104501252129)
22580POLYGON((-0.416263073682728 43.6140403747559,-0.417990177869797 43.6172294616699,-0.406522333621979 43.6278495788575,-0.416365355253163 43.6432189941407,-0.416365355253163 43.6432189941407,-0.400130689144135 43.637981414795,-0.400130689144135 43.637981414795,-0.376219958066883 43.6291007995605,-0.376219958066883 43.6291007995605,-0.382038205861988 43.6175994873047,-0.388150423765182 43.6134185791016,-0.388150423765182 43.6134185791016,-0.394183248281479 43.6183815002441,-0.413830429315567 43.6108665466309,-0.413830429315567 43.6108665466309,-0.416263073682728 43.6140403747559))0.0006POINT(-0.40042605002718873 43.62428487141929)
15209POLYGON((9.71622276306164 45.4835929870605,9.72083854675287 45.4830627441407,9.72083854675287 45.4830627441407,9.74646663665771 45.4813575744629,9.74878025054932 45.4820823669434,9.75110816955566 45.4849395751954,9.75110816955566 45.4849395751954,9.7560510635376 45.4986572265626,9.7560510635376 45.4986572265626,9.75268268585205 45.5004463195801,9.72700595855707 45.5002784729004,9.72700595855707 45.5002784729004,9.71710109710693 45.4853096008301,9.71710109710693 45.4853096008301,9.71622276306164 45.4835929870605))0.0006POINT(9.736311571938643 45.48942674909324)
30783POLYGON((-1.48187267780298 47.831802368164,-1.47963607311249 47.8348083496095,-1.46511399745935 47.8348579406739,-1.45657908916468 47.8317489624025,-1.42249763011927 47.8316192626953,-1.41484594345081 47.8274993896485,-1.41484594345081 47.8274993896485,-1.40914928913116 47.8274078369142,-1.40914928913116 47.8274078369142,-1.40495133399963 47.8474845886232,-1.40495133399963 47.8474845886232,-1.41042768955225 47.8532829284668,-1.43924450874329 47.8564414978028,-1.44349753856653 47.8626060485839,-1.46240890026087 47.8671989440918,-1.47565567493439 47.8773384094238,-1.47565567493439 47.8773384094238,-1.48506903648376 47.8733024597168,-1.48506903648376 47.8733024597168,-1.49712240695953 47.8624916076661,-1.5025389194488 47.8423347473146,-1.50654733180994 47.8401794433595,-1.50654733180994 47.8401794433595,-1.49495935440058 47.8342590332032,-1.49495935440058 47.8342590332032,-1.48187267780298 47.831802368164))0.0006POINT(-1.4577318143844236 47.84656539916998)
61840POLYGON((8.58362579345709 47.3578147888184,8.58740139007574 47.3564453125001,8.58740139007574 47.3564453125001,8.59200763702404 47.3574371337892,8.60279083251947 47.3565826416016,8.61572933197033 47.3592071533203,8.62682628631597 47.3583526611329,8.62682628631597 47.3583526611329,8.62404918670649 47.3618698120117,8.62340354919434 47.3643760681153,8.62340354919434 47.3643760681153,8.61753559112555 47.3667068481446,8.61452579498291 47.3718948364259,8.61452579498291 47.3718948364259,8.60838222503668 47.3729553222656,8.60482788085943 47.3753700256348,8.60482788085943 47.3753700256348,8.60437107086182 47.3736381530762,8.60250473022455 47.3725090026856,8.59250545501709 47.3737258911133,8.59250545501709 47.3737258911133,8.59142017364513 47.3712348937989,8.58779811859137 47.3693656921386,8.58670043945318 47.3671875,8.58011531829834 47.3670692443849,8.58066368103027 47.3691291809083,8.57786464691168 47.369270324707,8.57676696777349 47.3683166503906,8.57775497436523 47.3655433654786,8.57682228088385 47.365146636963,8.5790166854859 47.3629989624023,8.57819366455072 47.3620986938477,8.5808830261231 47.3595123291017,8.58444976806652 47.3583793640137,8.58362579345709 47.3578147888184))0.0006POINT(8.597306672264581 47.36571480246156)
17860POLYGON((7.49202108383184 45.3723716735839,7.50225496292126 45.3737754821777,7.51370000839245 45.3733024597169,7.52409076690685 45.3714447021485,7.53153276443493 45.3727722167969,7.53153276443493 45.3727722167969,7.53086090087885 45.3686676025391,7.53306818008434 45.3579444885254,7.53971099853516 45.3416023254395,7.54265022277838 45.3399772644043,7.54265022277838 45.3399772644043,7.54605484008789 45.3383407592773,7.55878591537481 45.3269271850586,7.55720901489263 45.3195343017579,7.55335092544561 45.317050933838,7.55330610275269 45.3133697509766,7.56045579910284 45.305534362793,7.56289482116699 45.2986946105958,7.56275701522821 45.2891426086426,7.56737279891968 45.2870788574219,7.56737279891968 45.2870788574219,7.5618081092835 45.2850761413574,7.5618081092835 45.2850761413574,7.55299091339111 45.2832908630372,7.55299091339111 45.2832908630372,7.55095577239996 45.2868309020997,7.54764699935913 45.2894020080566,7.53330183029175 45.2951774597168,7.52796602249157 45.2936515808105,7.52796602249157 45.2936515808105,7.52606582641602 45.2909164428712,7.52132081985485 45.2910003662111,7.50175189971935 45.2971191406251,7.5001602172851 45.2995262145996,7.49999523162853 45.301986694336,7.49999523162853 45.301986694336,7.49591016769409 45.3262176513672,7.48846817016602 45.3319435119628,7.47948217391973 45.349464416504,7.47769021987926 45.3554878234864,7.4725170135498 45.3593673706055,7.4725170135498 45.3593673706055,7.49202108383184 45.3723716735839))0.0006POINT(7.529212894893874 45.32207598005024)
13186POLYGON((16.2687454223633 39.3339347839355,16.2618923187255 39.338306427002,16.2618923187255 39.338306427002,16.260503768921 39.354907989502,16.260503768921 39.354907989502,16.2655277252198 39.3531036376953,16.2767143249513 39.3459739685059,16.2983570098878 39.3453712463379,16.3026618957519 39.354103088379,16.3110218048095 39.3617820739746,16.3106899261476 39.3719444274903,16.3133964538574 39.3753852844239,16.3133964538574 39.3753852844239,16.3213577270508 39.3744354248046,16.3389282226563 39.3791961669921,16.3605365753174 39.382740020752,16.3734798431396 39.3821105957031,16.380687713623 39.3872604370117,16.3865814208985 39.3940124511719,16.3972187042236 39.3929824829102,16.4056167602539 39.3948211669923,16.4056167602539 39.3948211669923,16.4030723571778 39.3878326416016,16.4045524597168 39.3783073425294,16.4078979492188 39.3726425170899,16.4122028350831 39.3679428100585,16.4075546264649 39.3584289550781,16.4009132385254 39.348472595215,16.3980522155762 39.3352470397949,16.3945693969727 39.3317184448242,16.3872966766358 39.3300323486328,16.3752212524415 39.3319129943848,16.3706512451173 39.3350105285646,16.3706512451173 39.3350105285646,16.3685741424561 39.3393478393555,16.3632469177247 39.3437690734864,16.3462829589844 39.3449630737305,16.3375415802002 39.343605041504,16.3367195129395 39.3375816345215,16.3349266052246 39.3353652954102,16.3280029296875 39.3336715698242,16.3264503479004 39.3348121643068,16.3092613220215 39.3384857177735,16.2825374603271 39.3336486816406,16.2687454223633 39.3339347839355))0.0006POINT(16.344125140797036 39.356445485895364)
20222POLYGON((11.095645904541 45.3366928100587,11.0865936279297 45.3359146118164,11.0829038619996 45.3407402038574,11.0782594680787 45.3501777648926,11.0750007629394 45.3525314331055,11.0555076599122 45.3493919372559,11.0555076599122 45.3493919372559,11.0588293075563 45.3448524475099,11.0539522171021 45.3441200256349,11.0488119125366 45.3417625427247,11.0520420074464 45.3305130004882,11.0508899688722 45.3268394470215,11.044460296631 45.32723236084,11.0435619354249 45.3299293518067,11.0360727310181 45.3299751281739,11.0360727310181 45.3299751281739,11.0358982086182 45.3200874328614,11.0358982086182 45.3200874328614,11.0366802215577 45.314510345459,11.0418977737427 45.3067283630372,11.0535573959351 45.2986183166504,11.0654449462891 45.2954864501954,11.0820455551148 45.2943305969239,11.0851593017579 45.2888107299805,11.0851593017579 45.2888107299805,11.087441444397 45.2891349792481,11.0851249694824 45.2931137084962,11.0768518447875 45.3019142150879,11.0705127716065 45.3176918029785,11.0727653503418 45.3185768127443,11.0791521072388 45.3121604919434,11.0829877853393 45.30961227417,11.0991430282593 45.3049163818361,11.1269483566285 45.294994354248,11.1317892074585 45.2897758483888,11.139850616455 45.2783164978028,11.1495056152344 45.2740325927736,11.1516799926758 45.2738571166992,11.1516799926758 45.2738571166992,11.164252281189 45.2746009826661,11.1666126251221 45.2793426513673,11.174768447876 45.289577484131,11.1901149749756 45.2993354797363,11.1972026824952 45.3022422790527,11.2032451629639 45.302459716797,11.2032451629639 45.302459716797,11.208062171936 45.3069648742676,11.2102289199829 45.3111801147462,11.2101688385011 45.3158836364747,11.2030382156372 45.316879272461,11.1939840316773 45.3156547546387,11.1939840316773 45.3156547546387,11.1806888580322 45.3169364929199,11.1599664688111 45.3154830932617,11.1379299163819 45.3167533874512,11.1209726333618 45.3190956115723,11.1073055267334 45.3234977722169,11.0935678482056 45.3315734863282,11.095645904541 45.3366928100587))0.0006POINT(11.108631462886448 45.312673108331154)
1409390POLYGON((-2.54578995704651 43.1792030334473,-2.54002594947809 43.1813659667969,-2.50790095329285 43.174976348877,-2.49692988395691 43.1777000427247,-2.49243688583374 43.1807060241699,-2.49000811576843 43.1798286437989,-2.48483610153198 43.1715965270997,-2.48694491386402 43.16939163208,-2.50157690048218 43.1673851013184,-2.50281190872192 43.1654243469238,-2.50785088539118 43.1658706665039,-2.50968408584583 43.1614303588868,-2.50493192672724 43.1557388305665,-2.50801801681519 43.1543273925782,-2.5102720260619 43.1569862365722,-2.51966595649719 43.1540679931641,-2.53017997741688 43.1542930603028,-2.5334849357605 43.1517333984376,-2.53798389434814 43.1519241333009,-2.55276608467102 43.1572647094728,-2.55544590950012 43.1607055664062,-2.55351996421808 43.1650047302246,-2.55460810661305 43.1662406921387,-2.54947304725647 43.167007446289,-2.55333995819086 43.1728286743165,-2.55128002166737 43.172161102295,-2.55212593078613 43.1741676330566,-2.54956388473505 43.1761894226075,-2.55010604858398 43.1777229309083,-2.54578995704651 43.1792030334473))0.0006POINT(-2.5252952493469936 43.16700836707809)
1409654POLYGON((-1.26647698879242 38.1292457580566,-1.26310098171234 38.1301498413087,-1.26054894924164 38.1257057189942,-1.25515604019165 38.1241378784181,-1.2535560131073 38.1222839355469,-1.24021005630493 38.1189422607422,-1.23630499839777 38.113925933838,-1.23265898227686 38.1137161254883,-1.22578895091999 38.1072502136232,-1.22751200199122 38.0968627929689,-1.23836600780481 38.0851097106935,-1.24161803722382 38.0787811279297,-1.24749100208271 38.0739707946777,-1.2492870092392 38.0693664550782,-1.25268995761866 38.0695800781251,-1.25495600700378 38.0744895935059,-1.26064395904541 38.0759887695313,-1.25889205932617 38.0869026184082,-1.26510894298548 38.0911407470704,-1.26185703277582 38.0935974121095,-1.26432502269745 38.0958137512208,-1.26977002620691 38.0970573425294,-1.27230203151697 38.1037559509278,-1.27694904804224 38.104030609131,-1.27866494655609 38.1076965332032,-1.27230703830713 38.1065216064454,-1.26647698879242 38.1292457580566))0.0006POINT(-1.2548670035141833 38.099847059983546)