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
39801POLYGON((3.87128019332886 43.6481933593751,3.85703444480902 43.6535186767579,3.85703444480902 43.6535186767579,3.84368586540222 43.6635551452638,3.84282016754162 43.6704292297364,3.86322784423822 43.6788177490235,3.86234974861145 43.6822624206544,3.86234974861145 43.6822624206544,3.88327336311346 43.6874656677246,3.88327336311346 43.6874656677246,3.88211250305187 43.6740760803222,3.86699604988104 43.6574440002443,3.87128019332886 43.6481933593751))0.0006POINT(3.8646198113759738 43.66991742451992)
16613POLYGON((8.89542388916016 45.6213645935059,8.89763545990002 45.625675201416,8.89737510681158 45.6277084350586,8.89307880401611 45.6334762573243,8.89562606811535 45.6370162963867,8.89562606811535 45.6370162963867,8.89901447296148 45.6362342834473,8.9100742340089 45.6364784240723,8.92501544952404 45.6409912109376,8.93754863739019 45.6423835754395,8.93754863739019 45.6423835754395,8.93006324768072 45.6363410949708,8.93349456787121 45.6273956298829,8.93349456787121 45.6273956298829,8.91640663146967 45.6224517822266,8.89979362487793 45.6232643127442,8.89542388916016 45.6213645935059))0.0006POINT(8.912326216697757 45.63234853744511)
65976POLYGON((11.8862857818604 48.2558326721192,11.8905258178711 48.2555809020996,11.888973236084 48.2535057067872,11.8953227996827 48.2533340454101,11.8967447280884 48.2550239562989,11.8990278244019 48.254825592041,11.8979749679567 48.2571029663087,11.8997325897217 48.2597808837892,11.899507522583 48.2621192932129,11.9006137847902 48.2646331787109,11.9034566879272 48.265151977539,11.9060392379761 48.2669296264648,11.910982131958 48.2650375366212,11.9105806350709 48.2632446289062,11.9171838760377 48.2624855041504,11.9172401428224 48.2597694396973,11.9258842468261 48.2606391906739,11.9268836975098 48.2584304809571,11.9319858551025 48.2533226013184,11.9319858551025 48.2533226013184,11.9339857101441 48.2521820068359,11.9416103363037 48.251838684082,11.9440507888794 48.2478485107422,11.9476995468139 48.2451133728028,11.9497480392456 48.2465705871582,11.9538469314576 48.2472076416017,11.9545583724975 48.2439689636231,11.9631633758545 48.2449722290039,11.9637565612794 48.2436408996583,11.9680442810059 48.2434234619141,11.9700450897217 48.2382965087891,11.9700450897217 48.2382965087891,11.9676256179811 48.2321243286134,11.9645566940309 48.233024597168,11.9621839523316 48.2315139770508,11.9621839523316 48.2315139770508,11.9460887908937 48.2321281433105,11.9410467147827 48.231315612793,11.9397039413452 48.2309226989746,11.940845489502 48.2294502258301,11.9321870803832 48.2288055419922,11.9340724945069 48.2279472351075,11.9330129623413 48.2243804931641,11.9252882003784 48.2270202636719,11.9239940643312 48.2253494262695,11.9060993194581 48.2276420593263,11.9077291488648 48.2258148193361,11.9077291488648 48.2258148193361,11.9046850204468 48.2238388061524,11.9012689590454 48.2251663208008,11.8991823196412 48.2243385314942,11.8915843963622 48.2249832153321,11.8918609619141 48.223430633545,11.8803071975707 48.2225456237793,11.8753299713135 48.226448059082,11.8753299713135 48.226448059082,11.876371383667 48.2271690368652,11.8765258789064 48.2292938232421,11.8742561340332 48.2342491149903,11.8701810836792 48.2343444824219,11.8697481155396 48.2381248474122,11.8724117279053 48.238094329834,11.8716583251953 48.2438850402831,11.8689432144166 48.2440452575685,11.8685598373413 48.246711730957,11.8721103668213 48.2475395202637,11.8714370727539 48.2494697570801,11.8714370727539 48.2494697570801,11.8720922470093 48.251693725586,11.8767547607421 48.2513732910157,11.8764266967773 48.2526359558107,11.8819360733032 48.2509346008302,11.8849668502808 48.2513427734376,11.8862857818604 48.2558326721192))0.0006POINT(11.911879434977514 48.242818858525546)
19383POLYGON((11.1996145248414 46.8213119506836,11.2383699417114 46.8182106018066,11.2431707382202 46.815128326416,11.2435235977174 46.8113441467285,11.2376813888549 46.8028793334962,11.2255973815919 46.7790260314943,11.2141714096069 46.7626457214355,11.2078762054443 46.7432022094727,11.2030382156372 46.739974975586,11.2009611129761 46.7370262145997,11.2007274627687 46.7351417541505,11.2023754119874 46.7318878173828,11.2048521041871 46.7293930053711,11.2016592025757 46.7262039184571,11.2016592025757 46.7262039184571,11.2001361846924 46.7292861938477,11.174488067627 46.7345809936524,11.1682024002076 46.7406921386719,11.1691122055053 46.7464103698732,11.1756820678711 46.7499542236328,11.1874332427979 46.7491455078126,11.1955471038819 46.7516784667968,11.2023725509645 46.7665252685548,11.185344696045 46.7661399841309,11.1785707473756 46.7641296386719,11.1690549850464 46.7583618164062,11.1583127975465 46.75825881958,11.1569042205811 46.7590484619141,11.1572885513307 46.7601470947266,11.1612596511841 46.7608833312989,11.162181854248 46.7626686096191,11.1615962982179 46.7640533447267,11.1517581939698 46.7718620300293,11.1482973098755 46.7734298706055,11.1482973098755 46.7734298706055,11.15656375885 46.7761192321778,11.1618824005128 46.7751350402833,11.1729202270509 46.7779617309571,11.1804580688477 46.7803611755372,11.1916418075562 46.7870597839355,11.1955299377443 46.7914962768556,11.1977500915528 46.7984008789062,11.1955089569092 46.8141632080079,11.1996145248414 46.8213119506836))0.0006POINT(11.188124967175908 46.765603797380344)
42966POLYGON((6.77314996719366 47.9138793945312,6.76804113388067 47.9130897521973,6.75048589706421 47.8877029418945,6.74827718734741 47.877296447754,6.73729372024536 47.8654747009277,6.73729372024536 47.8654747009277,6.73816394805908 47.8620491027832,6.78495216369623 47.8495750427247,6.78495216369623 47.8495750427247,6.78694295883173 47.860034942627,6.77130126953131 47.877513885498,6.81794214248663 47.8993835449219,6.81794214248663 47.8993835449219,6.77724981307989 47.8982429504396,6.77125787734991 47.9036712646486,6.77314996719366 47.9138793945312))0.0006POINT(6.771016407012954 47.881489817301464)
22776POLYGON((0.642262995243073 44.3005828857422,0.64275819063198 44.3100852966309,0.621941149234829 44.3163108825684,0.621941149234829 44.3163108825684,0.588645577430782 44.3064270019532,0.58182817697525 44.315128326416,0.572915554046688 44.314121246338,0.572915554046688 44.314121246338,0.556314468383732 44.3043899536133,0.556760013103428 44.2949256896973,0.556760013103428 44.2949256896973,0.575332641601676 44.2980804443359,0.604458510875759 44.288948059082,0.618721663951987 44.2884483337402,0.630609691143093 44.2745780944825,0.630609691143093 44.2745780944825,0.645040392875671 44.2814178466798,0.644873142242432 44.2902755737305,0.644873142242432 44.2902755737305,0.6417116522789 44.2921333312989,0.642262995243073 44.3005828857422))0.0006POINT(0.6075636684894875 44.298303222656294)
39435POLYGON((4.15764284133917 43.8200225830079,4.15022373199469 43.8052597045898,4.14557886123663 43.8054084777833,4.14557886123663 43.8054084777833,4.14707899093639 43.7934570312501,4.14707899093639 43.7934570312501,4.16868114471436 43.7865943908693,4.17835235595703 43.774845123291,4.180251121521 43.7681465148926,4.17649698257446 43.7619132995606,4.17649698257446 43.7619132995606,4.18503284454351 43.7621650695802,4.19951915740978 43.7512779235841,4.19951915740978 43.7512779235841,4.20208740234381 43.7500267028809,4.20208740234381 43.7500267028809,4.23411989212042 43.757595062256,4.23411989212042 43.757595062256,4.23077058792126 43.7635192871094,4.21495723724365 43.769115447998,4.21691036224371 43.7785987854003,4.21691036224371 43.7785987854003,4.21047592163086 43.7956161499025,4.21047592163086 43.7956161499025,4.2130184173584 43.8018417358399,4.20843029022222 43.8075828552246,4.20843029022222 43.8075828552246,4.18545722961426 43.8180313110352,4.15764284133917 43.8200225830079))0.0006POINT(4.190920829772996 43.781160490853495)
64973POLYGON((13.097776412964 49.0094642639161,13.0991744995117 49.0113029479981,13.0977306365967 49.0124244689941,13.0921783447266 49.0127334594727,13.0880060195923 49.0150375366212,13.0929183959961 49.0183601379395,13.0949611663818 49.0217590332032,13.0897626876831 49.0253524780274,13.0824699401857 49.0230751037598,13.0794467926025 49.0238723754884,13.0760936737061 49.0210342407226,13.0691022872926 49.0177116394043,13.0632238388062 49.0224647521972,13.0621356964112 49.0223197937012,13.0613880157471 49.0201034545898,13.0590028762819 49.0192489624024,13.0511455535889 49.0269622802734,13.0442686080934 49.0307350158691,13.0400829315186 49.0299949645997,13.0404615402223 49.0327758789063,13.0386762619019 49.03422164917,13.0340070724488 49.0339317321777,13.030466079712 49.0358276367188,13.027271270752 49.0331192016602,13.0174646377564 49.0298309326172,13.016721725464 49.0310707092285,13.0191173553467 49.0336990356446,13.0169897079468 49.0359535217286,13.0157976150513 49.0396080017091,13.0104866027833 49.0409317016602,13.0075445175171 49.0446434020996,12.9987087249756 49.0423126220704,12.9958639144898 49.0464515686036,12.9958639144898 49.0464515686036,12.9934616088868 49.0441932678224,12.9933910369874 49.04203414917,12.9905748367309 49.04203414917,12.9892330169679 49.0399780273438,12.9846744537354 49.0410423278809,12.9842538833618 49.0403137207031,12.9870462417602 49.0368499755861,12.9890670776368 49.0364875793458,12.9882736206055 49.0330505371093,12.9934482574463 49.0322608947754,12.9917201995851 49.0257568359376,12.9964218139648 49.0198898315429,12.9964218139648 49.0198898315429,12.995273590088 49.0169906616212,12.9959506988526 49.0165977478027,13.0007266998292 49.0174102783203,13.0066080093384 49.0168380737304,13.0095396041871 49.0155754089357,13.0103836059571 49.0139198303223,13.0097446441652 49.0105743408203,13.01535987854 49.0064888000488,13.01535987854 49.0064888000488,13.0383443832397 48.9979324340821,13.0366773605348 48.9958724975586,13.0388307571411 48.9952125549316,13.0375957489014 48.9943580627442,13.0399112701415 48.994441986084,13.042727470398 48.9886894226075,13.0454921722413 48.9884757995607,13.0458450317383 48.9902381896972,13.0478010177612 48.9897460937501,13.0478010177612 48.9897460937501,13.0520896911622 48.990421295166,13.0589094161988 48.9887886047364,13.0643501281739 48.9913368225099,13.0689535140992 48.9948730468751,13.072759628296 48.994915008545,13.075719833374 48.9968147277833,13.0790567398071 48.9943313598632,13.0843915939331 48.993278503418,13.0854625701904 48.9958877563477,13.087809562683 48.997573852539,13.0944185256959 48.9989051818848,13.0968608856201 49.0005645751954,13.0937128067017 49.007423400879,13.097776412964 49.0094642639161))0.0006POINT(13.03897170779076 49.01758580268186)
24367POLYGON((3.77303576469416 45.1533775329591,3.78386116027838 45.1421813964844,3.77967762947094 45.1359710693359,3.77878618240368 45.1222114562989,3.77340292930614 45.1164741516113,3.77340292930614 45.1164741516113,3.76005649566662 45.1151008605957,3.74790310859692 45.1249351501466,3.73147630691534 45.1195945739747,3.73147630691534 45.1195945739747,3.72745490074163 45.1223487854004,3.72745490074163 45.1223487854004,3.7284176349641 45.1288795471192,3.74409079551697 45.1366653442384,3.74735641479487 45.1430282592773,3.74735641479487 45.1430282592773,3.75951647758484 45.1567955017091,3.77303576469416 45.1533775329591))0.0006POINT(3.753807432511327 45.13052996467146)
13910POLYGON((15.3420009613037 40.4253425598145,15.3421154022217 40.4286689758302,15.3421154022217 40.4286689758302,15.3428659439087 40.4316864013672,15.3518943786621 40.4425926208497,15.376868247986 40.4576225280762,15.3803539276123 40.4580650329591,15.3844232559204 40.4663162231446,15.3758249282836 40.4779434204102,15.3757381439208 40.4918632507324,15.3786029815674 40.497013092041,15.3838300704957 40.5010795593262,15.3838300704957 40.5010795593262,15.3809280395509 40.5013160705567,15.3662662506105 40.5067672729493,15.3634519577028 40.5083618164062,15.3548812866211 40.5165939331055,15.3548812866211 40.5165939331055,15.3518590927125 40.5152626037599,15.3340759277344 40.4868659973146,15.3346099853516 40.4704971313477,15.3257904052736 40.4543762207031,15.3142166137695 40.4460563659669,15.3088054656982 40.4435615539552,15.3045721054078 40.443759918213,15.300241470337 40.4423942565919,15.2982673645019 40.4413528442384,15.2960577011108 40.4383583068848,15.2960577011108 40.4383583068848,15.3017826080323 40.4339942932129,15.305645942688 40.4331512451173,15.3158617019653 40.4347572326661,15.3207302093506 40.4398040771485,15.3238458633423 40.4401206970216,15.3290395736694 40.4341316223145,15.3303298950196 40.43021774292,15.3304147720336 40.4260787963868,15.3314924240112 40.4245262145996,15.3341627120972 40.4237480163575,15.3420009613037 40.4253425598145))0.0006POINT(15.340223899254452 40.45894740178039)