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
54118POLYGON((5.25092697143549 45.9324836730958,5.2538628578186 45.938606262207,5.24853610992443 45.9542427062989,5.24853610992443 45.9542427062989,5.25785303115839 45.9556159973146,5.26111268997204 45.9651718139649,5.2785086631776 45.9762916564941,5.2785086631776 45.9762916564941,5.28129768371588 45.9790534973146,5.28129768371588 45.9790534973146,5.29205226898193 45.9685935974122,5.28416061401367 45.9602317810059,5.29177045822144 45.9481658935547,5.29177045822144 45.9481658935547,5.26289510726934 45.9293365478516,5.26289510726934 45.9293365478516,5.25092697143549 45.9324836730958))0.0006POINT(5.270374029874844 45.955930233001766)
67705POLYGON((9.97034454345714 48.532455444336,9.97494602203381 48.5313529968262,9.97834491729736 48.5287246704103,9.97579956054693 48.5212326049805,9.97579956054693 48.5212326049805,9.98093318939215 48.5195655822754,9.98329544067383 48.5215110778809,9.98621845245367 48.5215339660645,9.98884487152094 48.5201950073242,9.99730587005615 48.5227432250977,9.99788761138916 48.5214157104493,10.0036211013795 48.5220527648926,10.0035591125489 48.5201568603517,10.0064907073975 48.5207252502442,10.0074090957642 48.5195617675782,10.0051803588868 48.5191383361816,10.0028886795045 48.5168075561524,10.0055541992188 48.5155868530273,10.0062923431397 48.5134963989257,10.0049686431885 48.5119247436525,10.0049686431885 48.5119247436525,10.0124168395996 48.5110702514648,10.0122280120851 48.5121078491212,10.0143241882324 48.5128021240235,10.0136938095093 48.5150032043458,10.0155467987061 48.5151748657228,10.0189628601074 48.5200996398926,10.0247039794923 48.518539428711,10.027156829834 48.5195922851562,10.0280179977418 48.5215301513672,10.0307397842408 48.5200424194336,10.0320606231689 48.5205841064453,10.0352020263673 48.5233497619629,10.0317296981813 48.5254592895509,10.0333480834961 48.5261573791505,10.0322856903077 48.5281944274903,10.04323387146 48.5257759094239,10.0436820983888 48.5270652770997,10.0436820983888 48.5270652770997,10.0417289733887 48.5273780822754,10.0400524139405 48.5314636230469,10.0252103805542 48.5346641540528,10.023817062378 48.5303688049316,10.0068273544312 48.5302963256836,10.0093688964844 48.5346679687499,10.0074977874757 48.534938812256,10.0082578659058 48.5361022949219,10.0056133270263 48.5364952087402,10.0063428878784 48.5380172729493,10.0041055679322 48.5383491516114,10.0056686401367 48.5403518676759,10.0038795471191 48.5405349731446,10.0038795471191 48.5405349731446,9.9955291748048 48.5414047241211,9.99382019042963 48.5404052734375,9.99189472198486 48.5405883789062,9.99033641815186 48.5355796813965,9.98602581024181 48.5360260009766,9.98040771484381 48.5397491455079,9.97463321685791 48.5365142822267,9.97034454345714 48.532455444336))0.0006POINT(10.007642761866295 48.52612304687503)
48322POLYGON((-0.339773803949356 47.2772331237794,-0.357133656740189 47.2615928649903,-0.357133656740189 47.2615928649903,-0.369741469621601 47.2507324218751,-0.377299666404724 47.2343368530274,-0.375142514705658 47.2311630249025,-0.345342963933888 47.2269935607911,-0.345342963933888 47.2269935607911,-0.326357394456807 47.242530822754,-0.314836293458882 47.2618942260742,-0.306684315204564 47.2662162780762,-0.305235743522587 47.2766647338868,-0.288834214210453 47.2896728515626,-0.288834214210453 47.2896728515626,-0.297362446784916 47.2920455932617,-0.323988944292012 47.2825355529786,-0.334068983793259 47.2828025817871,-0.339773803949356 47.2772331237794))0.0006POINT(-0.3325360732919662 47.262039633358306)
17590POLYGON((8.11396121978754 44.3342742919923,8.11618328094482 44.3368568420411,8.11551189422619 44.3393478393555,8.11114406585699 44.3417358398437,8.0804710388183 44.342254638672,8.0804710388183 44.342254638672,8.07588577270502 44.3413543701171,8.07588577270502 44.3413543701171,8.07289791107189 44.3270339965821,8.07443809509277 44.3234558105469,8.07443809509277 44.3234558105469,8.07799625396734 44.321201324463,8.0831880569458 44.3121376037598,8.0831880569458 44.3121376037598,8.08558368682867 44.3075714111329,8.10301876068127 44.3019027709961,8.10301876068127 44.3019027709961,8.1039924621582 44.307113647461,8.10591125488293 44.3112106323243,8.11012458801281 44.3160858154297,8.10618972778332 44.3275413513184,8.10696411132818 44.3326148986817,8.10882377624517 44.3340263366699,8.11396121978754 44.3342742919923))0.0006POINT(8.094316855720887 44.325166287629536)
14426POLYGON((13.1523685455323 46.151538848877,13.159447669983 46.1431503295899,13.1634197235107 46.1365623474122,13.164475440979 46.132884979248,13.1634006500245 46.1289901733398,13.1649599075317 46.1237678527833,13.1704950332643 46.1192321777344,13.1750078201295 46.1169929504396,13.177116394043 46.1134605407715,13.1766195297241 46.1120491027831,13.1718063354493 46.1077728271484,13.1718063354493 46.1077728271484,13.1663656234741 46.1102027893066,13.1567268371582 46.1113777160645,13.140703201294 46.1103439331055,13.1312437057496 46.1114120483398,13.1312437057496 46.1114120483398,13.1260719299317 46.1090774536134,13.1224079132081 46.1095428466797,13.1092319488526 46.1141967773439,13.1115798950195 46.1363487243653,13.1179342269898 46.1451644897461,13.1179342269898 46.1451644897461,13.1202583312988 46.1483688354493,13.1323013305665 46.1502647399903,13.1476888656617 46.1505432128906,13.1523685455323 46.151538848877))0.0006POINT(13.147792889521716 46.12529211777909)
70373POLYGON((11.1102590560914 50.9131126403809,11.106990814209 50.9211196899415,11.1059665679932 50.9266586303712,11.1118192672729 50.929958343506,11.1194305419922 50.9252662658691,11.1201314926147 50.927619934082,11.1243524551392 50.9270553588867,11.1282453536987 50.9285926818848,11.1329936981202 50.9280624389648,11.137303352356 50.9298210144042,11.1415643692017 50.926010131836,11.1504697799684 50.9244728088378,11.1536207199097 50.9248161315919,11.1536207199097 50.9248161315919,11.152967453003 50.9289703369141,11.1486873626708 50.9344902038575,11.1467094421388 50.9397277832032,11.1438703536987 50.9403305053712,11.1418933868409 50.9456748962402,11.1410484313965 50.9453849792481,11.1357717514038 50.9490013122559,11.1345653533935 50.9628677368165,11.1370515823364 50.9633941650391,11.1344556808473 50.9725761413574,11.1558856964111 50.977352142334,11.1547574996948 50.9802742004395,11.1585140228272 50.9808197021486,11.1596784591674 50.9794731140137,11.1626234054566 50.980136871338,11.1626234054566 50.980136871338,11.165083885193 50.9807014465333,11.1646823883057 50.9815826416017,11.1679105758667 50.9820251464844,11.1670713424684 50.9841156005859,11.1703863143921 50.9846649169922,11.1699514389039 50.9861526489259,11.1720809936524 50.9865341186525,11.1716232299804 50.9883728027344,11.175108909607 50.9888648986817,11.175108909607 50.9888648986817,11.1664838790895 51.0027732849122,11.1635866165161 51.0026435852052,11.1639995574951 51.0095520019532,11.1711673736573 51.0091171264648,11.1735973358155 51.0183067321778,11.1706647872925 51.0187301635743,11.1706647872925 51.0187301635743,11.169589996338 51.0174140930176,11.1468667984009 51.0181922912598,11.1459522247314 51.0175399780274,11.1459522247314 51.0175399780274,11.1494073867798 51.0152664184571,11.1397724151612 51.014015197754,11.1405029296876 51.0111618041992,11.1231603622437 51.0091133117677,11.1214141845704 51.0125236511231,11.1266250610352 51.0143966674806,11.12477684021 51.0224266052247,11.1199388504029 51.0230827331542,11.1082563400269 51.033042907715,11.1082563400269 51.033042907715,11.1067733764648 51.0342140197754,11.1015605926513 51.033863067627,11.0984458923341 51.0512542724609,11.0879697799683 51.0514488220216,11.093334197998 51.0601043701172,11.0891160964967 51.0607376098634,11.0896368026733 51.0634880065919,11.0915298461914 51.0652809143066,11.0915298461914 51.0652809143066,11.0860099792481 51.0646133422852,11.0810508728028 51.0654411315918,11.0786018371583 51.0683135986329,11.0794267654418 51.0714836120607,11.0813407897949 51.0737686157227,11.0729837417604 51.0747566223146,11.0731239318848 51.0757179260255,11.0711688995361 51.0758361816406,11.071231842041 51.0774459838868,11.0664196014405 51.0775489807129,11.0664424896241 51.0794143676759,11.0664424896241 51.0794143676759,11.0465526580811 51.0776443481446,11.046778678894 51.0798492431641,11.0419521331788 51.0799522399902,11.0419521331788 51.0799522399902,11.0397090911866 51.0652236938477,11.0374717712402 51.0656394958496,11.0358114242554 51.0628204345704,11.0333271026612 51.0628585815429,11.0333461761475 51.0644798278808,11.0311460494995 51.0656051635743,11.0239553451538 51.0674018859863,11.0231332778931 51.0629081726075,11.0198764801025 51.0603637695314,11.0160121917725 51.0594024658204,10.9989900588989 51.0602302551271,10.9921770095826 51.0588645935059,10.9905929565431 51.0684356689453,10.9905929565431 51.0684356689453,10.9759626388551 51.0648727416993,10.9759626388551 51.0648727416993,10.9769315719606 51.0619354248047,10.9752445220947 51.0617179870606,10.9760112762452 51.0598793029786,10.9773273468018 51.06014251709,10.9778423309326 51.0560913085938,10.9796113967897 51.0559768676759,10.9804134368898 51.0521125793457,10.984616279602 51.0526542663574,10.9861450195313 51.0432357788086,10.9800577163697 51.04252243042,10.9803867340088 51.0410804748535,10.9656314849855 51.0400619506837,10.9654893875123 51.0386505126953,10.9545440673829 51.0372886657715,10.9507226943971 51.0349388122559,10.948781967163 51.0356864929199,10.9483156204224 51.0342903137208,10.9459619522096 51.0345268249511,10.9456310272217 51.0331573486328,10.9435997009277 51.0323982238771,10.93834400177 51.0323066711426,10.9383258819581 51.0304183959962,10.9364137649536 51.0304870605469,10.9364137649536 51.0304870605469,10.9321594238282 51.029899597168,10.9313840866089 51.0282287597657,10.9295682907105 51.0278205871583,10.9287080764772 51.0242767333986,10.9275484085084 51.0238227844239,10.9298877716065 51.0176239013673,10.9250535964966 51.0146560668945,10.923836708069 51.0158119201661,10.9132461547852 51.015048980713,10.9101219177247 51.0182266235351,10.9112205505371 51.0198326110841,10.9103174209596 51.0209617614747,10.9052801132203 51.0207290649414,10.8975839614868 51.0248832702637,10.8823213577271 51.0252418518066,10.8811836242677 51.0274314880372,10.876651763916 51.0280838012696,10.8698167800903 51.0280265808107,10.862985610962 51.0265426635743,10.862985610962 51.0265426635743,10.8553466796876 51.0258369445801,10.8578729629516 51.0134391784669,10.8607873916626 51.0063171386719,10.8607873916626 51.0063171386719,10.8637962341309 51.0008087158204,10.8709840774536 51.0008850097656,10.8718605041505 51.0000190734863,10.87921333313 51.0011100769044,10.8830728530884 51.0005416870117,10.8878593444825 50.9931373596191,10.8915796279908 50.989959716797,10.886311531067 50.9878044128417,10.8798408508302 50.9825401306153,10.8730802536011 50.9796333312988,10.8631134033204 50.9772720336914,10.8631134033204 50.9772720336914,10.8666133880615 50.9693794250489,10.8654165267945 50.9693832397462,10.8657665252687 50.9648933410646,10.8657665252687 50.9648933410646,10.8728771209716 50.9650039672851,10.87269115448 50.9596519470215,10.8763484954834 50.9591178894044,10.8777084350586 50.9634246826173,10.8846559524537 50.9610099792481,10.8938980102538 50.9605102539063,10.8964824676515 50.9511451721193,10.8972091674805 50.9445648193361,10.8993043899537 50.9447708129884,10.9004869461061 50.9414863586426,10.9125595092775 50.940975189209,10.9167861938476 50.9422645568848,10.9174127578735 50.9407424926759,10.9283990859986 50.9429397583008,10.9276885986328 50.9447174072266,10.9291515350341 50.9457893371583,10.9385051727295 50.9468727111817,10.9419488906861 50.9436035156251,10.950234413147 50.9417343139648,10.9523305892945 50.9376335144042,10.9578895568847 50.9352798461914,10.9577198028564 50.9339408874512,10.9594879150392 50.9341926574708,10.9625511169434 50.92435836792,10.9636716842652 50.9240112304688,10.9645223617554 50.9207954406739,10.963550567627 50.919807434082,10.95823097229 50.918872833252,10.9490127563478 50.9140625000001,10.9316682815552 50.9095306396484,10.9323959350587 50.904136657715,10.9333457946777 50.902198791504,10.9344692230226 50.9021492004396,10.9361648559571 50.8948745727539,10.9361648559571 50.8948745727539,10.9441118240357 50.8941955566407,10.9477081298828 50.8909721374512,10.9616765975953 50.8939437866212,10.9598827362061 50.890724182129,10.963267326355 50.8903694152832,10.9644765853882 50.8938484191895,10.9742546081544 50.8924865722657,10.9696636199952 50.8956794738769,10.9780387878419 50.8979568481446,10.9805583953858 50.9022293090821,10.9802122116089 50.9045524597169,11.0020637512208 50.9079437255861,11.0046520233155 50.9025764465332,11.0125722885132 50.9033622741699,11.0125722885132 50.9033622741699,11.0144386291504 50.9047088623048,11.0552492141724 50.9080810546876,11.0552492141724 50.9080810546876,11.0601110458375 50.9082984924316,11.0596542358398 50.9116783142091,11.0770244598389 50.9131622314453,11.0816030502319 50.9107131958008,11.0955839157104 50.9130363464355,11.1102590560914 50.9131126403809))0.0006POINT(11.014535333429098 50.99097282545908)
34093POLYGON((5.67670583724976 48.1363105773925,5.67590332031256 48.1422424316407,5.68535566329967 48.150619506836,5.68535566329967 48.150619506836,5.68422222137463 48.1582336425782,5.68422222137463 48.1582336425782,5.63027143478405 48.1522026062012,5.6219334602356 48.14847946167,5.6219334602356 48.14847946167,5.60622358322155 48.143383026123,5.60622358322155 48.143383026123,5.59288311004633 48.1401748657228,5.60672378540045 48.1374282836914,5.60672378540045 48.1374282836914,5.63196945190441 48.138210296631,5.6514072418214 48.1355514526368,5.6625127792359 48.128791809082,5.6625127792359 48.128791809082,5.67670583724976 48.1363105773925))0.0006POINT(5.644060187869673 48.14325353834368)
13202POLYGON((16.3631439208985 39.7038726806641,16.3579082489014 39.7068634033204,16.354669570923 39.7052116394044,16.3541297912599 39.6954536437989,16.3363361358644 39.6751022338868,16.3112678527832 39.6528663635254,16.3039684295655 39.6532325744629,16.3039684295655 39.6532325744629,16.2942276000977 39.6516227722169,16.2932701110841 39.6590766906739,16.2932701110841 39.6590766906739,16.2948608398438 39.66117477417,16.3025951385498 39.6652374267579,16.3051757812501 39.6659927368165,16.3084354400635 39.6652221679688,16.3089637756347 39.6659965515137,16.3017082214355 39.6750793457031,16.2908000946045 39.6778221130371,16.2811546325684 39.6851654052734,16.2802314758301 39.6870613098145,16.2891998291017 39.6951866149902,16.2857360839845 39.7060317993165,16.2810573577881 39.7120246887208,16.2810573577881 39.7120246887208,16.2805538177491 39.7169952392578,16.2834548950196 39.7192878723145,16.2861328125001 39.7203445434571,16.2994422912598 39.7207412719727,16.2994422912598 39.7207412719727,16.3107070922852 39.717342376709,16.3162918090821 39.719856262207,16.3189792633058 39.7223930358888,16.3372688293458 39.7160491943359,16.3624782562256 39.7113304138185,16.3624782562256 39.7113304138185,16.3631439208985 39.7038726806641))0.0006POINT(16.309553309849388 39.69102979387561)
51889POLYGON((-1.02994084358215 45.9134407043458,-1.00888657569885 45.8939399719239,-1.00888657569885 45.8939399719239,-1.01741647720337 45.8857192993165,-1.03296256065363 45.8781509399414,-1.03994846343994 45.8623275756836,-1.03994846343994 45.8623275756836,-1.05247747898096 45.8679122924805,-1.07703840732569 45.8705062866211,-1.08842527866364 45.8771476745606,-1.10236096382135 45.8793258666993,-1.10236096382135 45.8793258666993,-1.10097301006306 45.8815269470215,-1.10152900218964 45.8837509155274,-1.10069501399988 45.8854179382325,-1.09625005722046 45.8870849609375,-1.09597194194794 45.8887481689454,-1.09375 45.8895835876465,-1.09069395065308 45.8934707641602,-1.0870840549469 45.8954162597657,-1.08569598197931 45.8976402282716,-1.08293879032129 45.8984298706055,-1.08293879032129 45.8984298706055,-1.0820477008819 45.8979835510255,-1.08121085166931 45.8987884521485,-1.07373380661005 45.894603729248,-1.06618106365198 45.9031982421876,-1.05210530757898 45.9042816162109,-1.03847503662104 45.9179611206056,-1.03847503662104 45.9179611206056,-1.02994084358215 45.9134407043458))0.0006POINT(-1.0683800816535625 45.88994471232101)
57315POLYGON((8.04419040679932 49.8630485534668,8.05612277984631 49.8663406372071,8.05487155914307 49.8676528930665,8.06486606597906 49.8712692260743,8.06486606597906 49.8712692260743,8.05817317962658 49.8744125366211,8.05906391143805 49.8749542236328,8.05473804473871 49.8772735595703,8.05659103393566 49.8786201477052,8.04886341094971 49.8842239379883,8.05035877227778 49.8849487304688,8.05035877227778 49.8849487304688,8.04600715637213 49.8882751464845,8.04419612884527 49.8874549865722,8.0428323745727 49.8885040283203,8.0428323745727 49.8885040283203,8.03841304779053 49.8866806030274,8.0368585586549 49.8881759643555,8.03392124176025 49.8870429992677,8.03208827972406 49.8882713317871,8.02910900115978 49.8863449096681,8.02910900115978 49.8863449096681,8.03052711486822 49.8848838806153,8.03375244140631 49.8838500976563,8.03579235076916 49.8807907104493,8.03512287139893 49.8775787353517,8.03579139709467 49.8759841918946,8.03149414062511 49.8733444213868,8.02661323547375 49.8721313476562,8.02609157562262 49.8703804016114,8.02402973175043 49.8700942993165,8.02810478210449 49.8644104003907,8.02929878234858 49.856990814209,8.02929878234858 49.856990814209,8.03702926635742 49.8612365722656,8.04419040679932 49.8630485534668))0.0006POINT(8.041182218279184 49.877235085623646)