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
30628POLYGON((-3.85791802406311 48.6286544799806,-3.87116670608515 48.625114440918,-3.87101840972889 48.6219177246094,-3.85609483718866 48.6175537109376,-3.85609483718866 48.6175537109376,-3.8591833114624 48.6143493652345,-3.85872626304621 48.6138458251953,-3.85872626304621 48.6138458251953,-3.86053776741016 48.6151580810546,-3.86249995231628 48.6127471923829,-3.85948204994196 48.6095733642579,-3.87064909934998 48.6039962768555,-3.87510514259327 48.5884056091309,-3.8725574016571 48.5821800231934,-3.8725574016571 48.5821800231934,-3.88710999488825 48.5800437927247,-3.88817620277405 48.5767784118652,-3.90119814872742 48.5720291137696,-3.9110825061797 48.5607528686525,-3.9110825061797 48.5607528686525,-3.91885042190546 48.5652770996094,-3.92624878883362 48.5814781188966,-3.92624878883362 48.5814781188966,-3.92337298393238 48.5880241394043,-3.93490290641785 48.5982856750488,-3.93490290641785 48.5982856750488,-3.94155550003046 48.6119537353516,-3.94155550003046 48.6119537353516,-3.93891215324402 48.6145286560059,-3.92964649200434 48.6123352050781,-3.91709375381464 48.6261329650879,-3.90400528907776 48.6304702758789,-3.89529991149902 48.6385040283204,-3.89529991149902 48.6385040283204,-3.88761067390436 48.6355743408203,-3.88013911247253 48.639720916748,-3.88013911247253 48.639720916748,-3.87486100196838 48.6393051147462,-3.87319493293757 48.6373596191407,-3.86458396911621 48.6356925964355,-3.86014008522034 48.6337509155274,-3.85764002799988 48.6306953430175,-3.85791802406311 48.6286544799806))0.0006POINT(-3.889694548788489 48.60920152210058)
21713POLYGON((0.303529381752071 45.4322242736818,0.315989553928432 45.4360084533692,0.303214967250881 45.4455604553224,0.302619069814796 45.4588890075684,0.302619069814796 45.4588890075684,0.310780584812107 45.4587593078614,0.329155474901256 45.4437828063965,0.334363371133918 45.4598197937012,0.334363371133918 45.4598197937012,0.347984313964787 45.4574279785157,0.362602680921555 45.4407463073731,0.362602680921555 45.4407463073731,0.374035656452293 45.4298248291017,0.365885525941906 45.4109115600587,0.365885525941906 45.4109115600587,0.357705771923065 45.4121170043946,0.356755346059913 45.409236907959,0.356755346059913 45.409236907959,0.324638396501598 45.3948516845703,0.324638396501598 45.3948516845703,0.319590508937836 45.4038047790528,0.319590508937836 45.4038047790528,0.311142772436199 45.4121360778809,0.308522760868129 45.4260902404786,0.303529381752071 45.4322242736818))0.0006POINT(0.3331237932046776 45.429602146148746)
31153POLYGON((-2.56679368019104 47.8546562194824,-2.55778884887684 47.8572463989258,-2.55456328392029 47.8663864135742,-2.55456328392029 47.8663864135742,-2.55088114738459 47.8720741271973,-2.5521867275238 47.8812141418458,-2.5521867275238 47.8812141418458,-2.56733322143555 47.8792152404785,-2.58702898025513 47.8825988769531,-2.5908048152923 47.8849563598633,-2.5904176235199 47.8952751159668,-2.57919883728016 47.9067192077637,-2.58039832115168 47.9100799560547,-2.59424614906305 47.9056243896484,-2.59424614906305 47.9056243896484,-2.6190972328186 47.8928413391114,-2.62750673294062 47.883846282959,-2.62750673294062 47.883846282959,-2.61948943138123 47.8684425354004,-2.6103298664093 47.8606986999511,-2.6103298664093 47.8606986999511,-2.6019177436828 47.8636894226075,-2.58664631843567 47.8635635375977,-2.57685780525202 47.8558998107911,-2.56679368019104 47.8546562194824))0.0006POINT(-2.5855133136113184 47.87844991683961)
56965POLYGON((6.76988363265997 45.1995391845703,6.78667259216314 45.1784553527832,6.80052804946905 45.1689224243165,6.80067491531372 45.1551704406738,6.7968430519104 45.1529655456544,6.80218458175659 45.1508750915528,6.80218458175659 45.1508750915528,6.8441333770752 45.1344528198242,6.84927177429211 45.1284332275391,6.8535332679748 45.1285972595216,6.8535332679748 45.1285972595216,6.89646005630499 45.1402015686036,6.90195322036743 45.1445121765137,6.90195322036743 45.1445121765137,6.89626789093018 45.1533012390137,6.90086078643799 45.1643104553223,6.91997003555298 45.1684532165528,6.94143676757818 45.1706771850585,6.94515895843506 45.1730346679688,6.9446172714234 45.1737937927247,6.9446172714234 45.1737937927247,6.94290924072271 45.1761894226075,6.94214439392096 45.179615020752,6.92038917541504 45.1860237121581,6.91419839859014 45.1988067626954,6.90075016021729 45.2021560668945,6.88484525680536 45.2195053100585,6.87393951416027 45.226303100586,6.87393951416027 45.226303100586,6.86011266708374 45.2252235412598,6.85642242431652 45.2153968811035,6.83868551254272 45.2208404541015,6.83605670928961 45.2237892150878,6.83873701095592 45.2304840087891,6.83685302734375 45.2336959838868,6.83222770690918 45.2349014282228,6.8176007270813 45.235752105713,6.79993581771851 45.2416458129883,6.78536319732666 45.2401313781739,6.77312612533575 45.2344703674316,6.76842355728149 45.2354927062988,6.76842355728149 45.2354927062988,6.76018476486217 45.2192764282228,6.76988363265997 45.1995391845703))0.0006POINT(6.855302489081123 45.188952778661005)
63991POLYGON((13.9492092132569 53.1502914428711,13.9549465179444 53.1477394104004,13.9551982879639 53.1463737487793,13.9602994918823 53.1482429504396,13.9657115936279 53.1460685729981,13.9637079238892 53.1443786621094,13.9802541732789 53.1425743103027,13.9827041625977 53.1442260742188,13.9845190048219 53.1478805541993,13.9872159957886 53.1499977111816,13.9873514175416 53.1524696350098,13.9908895492554 53.1548156738282,13.9994468688965 53.1564369201661,14.0022726058961 53.1596031188965,14.0022726058961 53.1596031188965,14.0010423660279 53.1669349670411,14.001717567444 53.1718673706055,14.0047702789307 53.1735229492187,14.004942893982 53.1749496459962,14.0084075927734 53.1791534423829,14.0131988525391 53.1813888549805,14.0140619277955 53.1865844726563,14.0195245742798 53.1868858337403,14.0175752639771 53.1904335021973,14.0195951461792 53.1956596374512,14.0221729278566 53.1981124877931,14.0279302597046 53.2009544372559,14.0328350067139 53.2021331787109,14.0410137176514 53.2119750976563,14.051607131958 53.2105293273926,14.0580949783326 53.2081871032715,14.0680952072144 53.2070007324219,14.0963287353517 53.2075576782227,14.0963287353517 53.2075576782227,14.0931224822998 53.2152976989747,14.0925540924073 53.2204742431641,14.094319343567 53.229248046875,14.0938081741333 53.2344970703126,14.0978384017944 53.2558288574219,14.0978384017944 53.2558288574219,14.0792961120605 53.2581024169922,14.0708131790162 53.2611274719239,14.0614013671876 53.2598495483399,14.0563488006592 53.2601585388185,14.0439882278444 53.2641944885255,14.0439882278444 53.2641944885255,14.0382852554322 53.2648506164551,14.0346155166626 53.2632560729982,14.0350589752198 53.2579421997071,14.0320796966553 53.2565269470215,14.0311679840087 53.2546997070313,14.0246629714966 53.2517890930177,14.0236797332764 53.2503700256348,14.0113458633423 53.242832183838,14.0066852569581 53.2447662353516,14.0061960220337 53.239372253418,14.007776260376 53.2337913513184,14.0136585235596 53.2270545959473,13.9990835189819 53.226490020752,13.9740257263184 53.2188644409181,13.9648218154907 53.2198333740236,13.9648218154907 53.2198333740236,13.9607639312745 53.2097625732421,13.9675626754761 53.2085456848145,13.9665203094483 53.2067298889161,13.9577398300171 53.2084732055664,13.954068183899 53.20560836792,13.9537019729615 53.2032928466797,13.9566965103151 53.2023506164551,13.9577417373657 53.1984405517579,13.9592094421387 53.1966667175294,13.9571113586426 53.1950569152833,13.9549493789673 53.1949653625489,13.9566402435304 53.1923065185547,13.9545679092408 53.1910285949707,13.9565010070801 53.1895904541016,13.9574203491212 53.1898651123047,13.9558391571045 53.1865158081055,13.9481182098389 53.1803016662597,13.949058532715 53.1789245605469,13.9419145584108 53.178737640381,13.9421310424805 53.1769065856934,13.9329137802124 53.1770210266114,13.9253559112549 53.1730384826661,13.9214611053467 53.1687660217286,13.9237070083619 53.1693420410156,13.9314002990724 53.1670722961426,13.9347791671753 53.1585121154786,13.9440822601318 53.151611328125,13.9492092132569 53.1502914428711))0.0006POINT(13.999780676338156 53.20025390453555)
14006POLYGON((11.8611192703247 44.9601669311523,11.8590679168702 44.9602165222168,11.862476348877 44.9522552490236,11.8511085510253 44.9391899108888,11.842827796936 44.934425354004,11.828592300415 44.9341583251953,11.8308858871461 44.938663482666,11.8065013885499 44.9378089904786,11.796160697937 44.9396629333496,11.7924909591676 44.9425048828126,11.7744998931885 44.9419975280762,11.7734880447389 44.9396095275879,11.7760734558106 44.9269447326661,11.7673797607422 44.9269104003906,11.7643270492554 44.9247817993165,11.7646703720093 44.9168739318849,11.763352394104 44.8959350585938,11.763352394104 44.8959350585938,11.7693481445314 44.8932151794435,11.7609529495239 44.8723602294921,11.7578220367432 44.8707160949708,11.7499027252198 44.8716011047364,11.741216659546 44.8670692443849,11.7414350509644 44.8562698364258,11.7480630874634 44.848487854004,11.7518787384033 44.8584632873536,11.756986618042 44.8603019714355,11.7621517181396 44.8600349426271,11.7646217346192 44.8578910827637,11.7646207809449 44.852352142334,11.7658920288087 44.8496932983398,11.7679176330568 44.8473472595215,11.7731008529664 44.8444023132325,11.7834901809692 44.8425636291504,11.7914657592775 44.8428840637208,11.8219499588012 44.8378372192382,11.8368520736695 44.8335342407227,11.8423156738282 44.8253555297852,11.8423156738282 44.8253555297852,11.8454647064209 44.8285140991211,11.848638534546 44.8416748046875,11.846516609192 44.8427696228027,11.8330869674683 44.8418045043946,11.8307027816773 44.8458290100098,11.8317975997926 44.8526840209962,11.8545122146608 44.8695030212403,11.8579835891725 44.8701095581055,11.8922185897827 44.8627281188964,11.9050235748292 44.8611717224122,11.9050235748292 44.8611717224122,11.9118127822877 44.8603477478028,11.9070987701417 44.8899230957031,11.9510412216187 44.8887977600098,11.9556760787964 44.8907585144044,11.9345674514771 44.9023284912109,11.9633541107178 44.9043617248535,11.9706201553344 44.905788421631,11.9802732467651 44.9172019958497,11.9824733734131 44.9235572814943,11.9945278167725 44.9259033203126,11.9975481033326 44.9247627258301,12.0041856765748 44.9257202148439,11.9920682907104 44.9424514770508,11.9987812042237 44.9477767944337,11.9987812042237 44.9477767944337,11.9997320175172 44.9527854919434,11.9805879592897 44.9561538696289,11.9550361633302 44.9528770446778,11.939832687378 44.9489402770996,11.9296283721925 44.9486236572267,11.914855003357 44.9512176513672,11.88822555542 44.9471092224122,11.8792057037354 44.949462890625,11.8781995773315 44.9567604064941,11.8772840499878 44.9576950073243,11.8715705871582 44.9593048095704,11.8611192703247 44.9601669311523))0.0006POINT(11.85369224297378 44.898448994285204)
35592POLYGON((5.91746473312384 47.1575660705567,5.93348455429089 47.1691780090333,5.93348455429089 47.1691780090333,5.93421459198004 47.1731224060059,5.93421459198004 47.1731224060059,5.93131160736095 47.1722145080566,5.93131160736095 47.1722145080566,5.90767478942865 47.1721801757813,5.90414476394665 47.1782608032227,5.89326286315924 47.1847496032715,5.89326286315924 47.1847496032715,5.89097547531139 47.1842308044434,5.89097547531139 47.1842308044434,5.89131927490229 47.1741485595703,5.9014196395874 47.1666793823243,5.89370107650768 47.1626739501954,5.89370107650768 47.1626739501954,5.91144704818737 47.1620597839355,5.91746473312384 47.1575660705567))0.0006POINT(5.910409477022032 47.17240185207795)
32162POLYGON((1.24898886680609 47.0208282470703,1.23222029209137 47.0141448974609,1.23222029209137 47.0141448974609,1.22063410282135 47.0249061584472,1.20673298835754 47.0282936096193,1.20673298835754 47.0282936096193,1.24082338809978 47.0471267700195,1.27486646175385 47.0755920410156,1.28432083129888 47.0775718688965,1.28432083129888 47.0775718688965,1.28913044929504 47.0722312927246,1.29376935958862 47.0722541809082,1.29376935958862 47.0722541809082,1.28915095329285 47.0628547668456,1.28915095329285 47.0628547668456,1.27253592014313 47.050407409668,1.27609694004059 47.0408058166504,1.24898886680609 47.0208282470703))0.0006POINT(1.2609097046010793 47.04953743429744)
35886POLYGON((6.71355628967291 47.3977661132813,6.70361089706427 47.3984718322754,6.67294597625738 47.4140701293946,6.67294597625738 47.4140701293946,6.67607975006104 47.4338150024415,6.67607975006104 47.4338150024415,6.71394968032843 47.4390563964845,6.71394968032843 47.4390563964845,6.71752214431763 47.4151306152344,6.72318029403687 47.4094352722168,6.71355628967291 47.3977661132813))0.0006POINT(6.6983820438385395 47.419468688964905)
1400140POLYGON((-4.66899776458735 42.0538749694825,-4.67048215866089 42.0546646118164,-4.67036104202265 42.0583953857423,-4.67334222793579 42.0582504272462,-4.66607904434204 42.0650939941407,-4.65887403488153 42.0618820190429,-4.64255094528198 42.0746574401856,-4.63433313369751 42.0917320251464,-4.62764310836792 42.0963211059571,-4.6157870292663 42.1104087829591,-4.60742521286011 42.1111412048341,-4.60181188583368 42.1154594421387,-4.59794616699213 42.1151275634766,-4.593994140625 42.1109848022462,-4.56646013259888 42.110679626465,-4.56288385391235 42.1128463745117,-4.55643177032471 42.1126899719239,-4.56207895278925 42.1051864624023,-4.55704307556152 42.0812683105469,-4.58311796188354 42.0822105407715,-4.59744215011597 42.0690956115723,-4.59762907028198 42.0673370361329,-4.61145210266108 42.0600280761719,-4.61318397521967 42.0630874633789,-4.61663722991938 42.0634078979492,-4.61770200729364 42.0577087402344,-4.60847091674793 42.0468406677247,-4.60826396942139 42.0376014709473,-4.61317300796503 42.0348701477052,-4.61951398849482 42.0324821472168,-4.62742710113525 42.0320205688477,-4.63423490524292 42.0341300964355,-4.64089393615723 42.0319633483887,-4.65475416183472 42.0358085632325,-4.66330289840698 42.0416908264161,-4.65635108947754 42.0498809814453,-4.66899776458735 42.0538749694825))0.0006POINT(-4.619391004244463 42.07057857513431)