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
35258POLYGON((9.38122367858892 42.7896080017091,9.36798667907709 42.7805976867676,9.3552131652832 42.7772369384766,9.33958435058605 42.7604866027832,9.33958435058605 42.7604866027832,9.33708381652838 42.7648620605469,9.3412504196167 42.7693061828614,9.3387498855592 42.7751388549805,9.34041786193842 42.7768058776857,9.34069442749023 42.7793045043945,9.33958435058605 42.783473968506,9.34236240386963 42.7873611450196,9.34263992309576 42.7970848083496,9.33958435058605 42.8009719848634,9.33847236633312 42.8040161132814,9.33847236633312 42.8040161132814,9.35865211486822 42.8070602416993,9.35865211486822 42.8070602416993,9.36930370330811 42.7952766418458,9.38122367858892 42.7896080017091))0.0006POINT(9.347869069952765 42.78527129323866)
30752POLYGON((-1.34596157073975 48.3595924377442,-1.34112107753748 48.3586082458497,-1.33492088317865 48.3458862304688,-1.33998775482172 48.3329238891602,-1.33555459976196 48.3270149230958,-1.33816587924952 48.3205032348633,-1.33816587924952 48.3205032348633,-1.33503258228302 48.3182220458984,-1.33503258228302 48.3182220458984,-1.32142245769501 48.3227539062499,-1.31206250190729 48.3198280334473,-1.28903543949116 48.3270416259766,-1.28903543949116 48.3270416259766,-1.29515099525446 48.3430290222169,-1.287229180336 48.3512992858887,-1.28761279582977 48.3644599914551,-1.28761279582977 48.3644599914551,-1.29544174671167 48.3664474487305,-1.29471921920771 48.3758087158203,-1.30399978160852 48.3771629333497,-1.30399978160852 48.3771629333497,-1.31041228771204 48.3720741271973,-1.33929491043091 48.3646583557129,-1.34596157073975 48.3595924377442))0.0006POINT(-1.3156944409660274 48.345856708029075)
58088POLYGON((6.7006511688233 50.0843849182129,6.70230436325068 50.0892524719238,6.70230436325068 50.0892524719238,6.70842790603643 50.0892028808594,6.71821308135998 50.0915107727052,6.73028373718273 50.0906372070314,6.73232936859137 50.0934371948243,6.7327232360841 50.0967559814454,6.73549175262457 50.0964584350586,6.73817825317388 50.1000061035157,6.74038028717047 50.0997924804689,6.74235677719116 50.1038208007814,6.7519063949585 50.1095123291017,6.75140142440796 50.1112899780273,6.74817085266113 50.1136856079102,6.74990844726568 50.1152648925782,6.75503158569347 50.1178016662599,6.76234197616583 50.1178436279297,6.76234197616583 50.1178436279297,6.76434850692743 50.114974975586,6.76996898651123 50.1154708862304,6.77549266815186 50.1136512756349,6.77527379989624 50.1123390197754,6.77208280563366 50.1117668151855,6.77137470245367 50.11079788208,6.77584648132336 50.1080970764161,6.77584648132336 50.1080970764161,6.77684259414684 50.1068305969238,6.77649116516119 50.1056060791016,6.78093528747564 50.1051979064942,6.78361368179333 50.1037368774415,6.78583669662476 50.0982589721681,6.7890243530274 50.095832824707,6.7890243530274 50.095832824707,6.78460121154785 50.0959854125978,6.77874231338512 50.0946655273439,6.77830171585083 50.0953025817872,6.76390171051037 50.0910415649415,6.76346015930176 50.0917205810547,6.75568246841436 50.0908508300782,6.7546467781068 50.0855484008789,6.75312757492077 50.0838661193849,6.74915504455566 50.0838165283203,6.74973058700567 50.0829162597656,6.73520469665533 50.0800170898438,6.71515321731567 50.0704421997071,6.71515321731567 50.0704421997071,6.70373153686535 50.0718307495117,6.70026540756231 50.0766410827638,6.70043802261364 50.0791969299316,6.69742250442505 50.0815315246583,6.69742250442505 50.0815315246583,6.7006511688233 50.0843849182129))0.0006POINT(6.748517118967546 50.09695368546709)
54495POLYGON((5.53050613403332 46.1564903259277,5.52847814559942 46.1529922485352,5.52847814559942 46.1529922485352,5.5071258544923 46.160343170166,5.48770380020142 46.160343170166,5.48770380020142 46.160343170166,5.48936176300043 46.1825866699219,5.4940323829652 46.1880340576173,5.4940323829652 46.1880340576173,5.50584506988537 46.213191986084,5.51360559463512 46.2171478271485,5.52738618850719 46.2151107788087,5.52738618850719 46.2151107788087,5.52490949630743 46.2019233703613,5.53309297561657 46.198471069336,5.53309297561657 46.198471069336,5.5318684577943 46.1924591064453,5.54058933258057 46.1914100646973,5.54224348068243 46.1884727478028,5.53979730606079 46.1824264526368,5.53979730606079 46.1824264526368,5.53050613403332 46.1564903259277))0.0006POINT(5.519382703872021 46.185656229655)
41529POLYGON((5.98541021347046 49.042049407959,5.99496841430675 49.0380973815919,5.99496841430675 49.0380973815919,5.97857713699352 49.0260238647461,5.98372888565075 49.020435333252,5.98162651062023 49.0140800476074,5.98162651062023 49.0140800476074,5.97391414642334 49.0177192687988,5.9737720489502 49.0209693908691,5.98541021347046 49.042049407959))0.0006POINT(5.983176920149138 49.0257280137804)
28487POLYGON((4.69554138183605 47.5846138000489,4.69828367233276 47.5787925720214,4.69407224655151 47.5731201171876,4.69456624984753 47.5635337829589,4.69803524017345 47.5613479614257,4.69803524017345 47.5613479614257,4.74096965789801 47.5747261047364,4.75657653808605 47.5743217468262,4.75657653808605 47.5743217468262,4.76047897338873 47.5869674682617,4.75675106048595 47.5925788879395,4.75675106048595 47.5925788879395,4.74890375137335 47.596405029297,4.73975324630737 47.5962066650392,4.72398900985723 47.6080207824707,4.72398900985723 47.6080207824707,4.7140674591065 47.5933990478516,4.69499492645269 47.5913009643555,4.69554138183605 47.5846138000489))0.0006POINT(4.725129736794438 47.58397801717124)
69080POLYGON((12.2858018875123 50.3058624267578,12.2872257232667 50.3052368164064,12.2788486480714 50.2969970703126,12.282229423523 50.2953796386719,12.2806119918823 50.29496383667,12.2819547653198 50.294059753418,12.280481338501 50.2926063537598,12.2911605834962 50.2956352233887,12.2920627593994 50.2949562072754,12.2899665832521 50.2945289611816,12.2791090011597 50.2875442504883,12.2761030197144 50.2875366210938,12.2766304016113 50.2828063964844,12.2777395248414 50.2820854187011,12.2815809249877 50.2834472656251,12.2834110260011 50.2824363708497,12.2803201675416 50.2805480957032,12.2818441390992 50.2796249389649,12.2891664505005 50.2771606445314,12.2929477691652 50.2768859863281,12.2948818206788 50.2756690979004,12.2948818206788 50.2756690979004,12.2909364700319 50.2749481201172,12.293911933899 50.2704925537111,12.2871780395509 50.2643585205079,12.2881860733033 50.2631721496583,12.280816078186 50.2639541625977,12.2660160064698 50.2587013244629,12.2660160064698 50.2587013244629,12.261438369751 50.261257171631,12.2537031173707 50.2710876464845,12.2501382827759 50.2698860168457,12.2478313446046 50.2702789306641,12.2481479644777 50.2693328857422,12.2470407485962 50.2682609558106,12.238221168518 50.2697372436525,12.2346153259278 50.2694396972656,12.2326641082764 50.2709999084474,12.2300605773927 50.2712097167969,12.2132282257081 50.2702026367188,12.2117395401001 50.2713241577148,12.2014570236205 50.2727813720704,12.1999940872192 50.274269104004,12.201771736145 50.2760620117189,12.2023210525513 50.287754058838,12.2015924453736 50.2893753051759,12.1956186294556 50.2931709289551,12.1962900161743 50.2958068847657,12.1962900161743 50.2958068847657,12.201153755188 50.2951049804689,12.205457687378 50.2917556762695,12.2059183120728 50.2947731018067,12.2244882583618 50.2931480407714,12.2255525588989 50.2907562255859,12.2293519973754 50.2932357788085,12.23406124115 50.2895011901857,12.2395820617677 50.2894821166992,12.2432327270508 50.2905960083008,12.2417669296266 50.2885475158693,12.2440118789673 50.2880897521973,12.2472457885743 50.2919654846193,12.246446609497 50.2935256958008,12.2483129501343 50.2938499450685,12.2502412796021 50.2973556518555,12.2546253204347 50.301139831543,12.2546710968018 50.3038597106934,12.2661895751954 50.3071212768556,12.2670040130615 50.3048553466798,12.2692918777466 50.3040466308594,12.2707223892212 50.3047103881836,12.2725038528442 50.3031425476075,12.2783460617065 50.3048896789551,12.2820911407472 50.3032379150391,12.2858018875123 50.3058624267578))0.0006POINT(12.25477333591413 50.28537948817426)
21032POLYGON((7.42645215988159 48.1325225830079,7.41278028488165 48.1300277709962,7.39796066284185 48.1064529418946,7.39796066284185 48.1064529418946,7.41251182556164 48.1049003601074,7.41720390319824 48.0995407104493,7.41720390319824 48.0995407104493,7.42052268981945 48.1041488647462,7.42445516586309 48.1040267944336,7.42445516586309 48.1040267944336,7.43944358825695 48.1214637756348,7.43944358825695 48.1214637756348,7.42766857147222 48.1263122558594,7.42645215988159 48.1325225830079))0.0006POINT(7.419850936302832 48.112375406118595)
1401682POLYGON((-2.99234294891352 41.5480651855469,-2.98442506790161 41.5596809387208,-2.98605704307556 41.5634651184082,-2.98992896080011 41.5659217834473,-2.98942589759827 41.5704536437988,-2.99227905273426 41.5778579711914,-2.97745108604431 41.5858459472656,-2.96301698684681 41.5858306884766,-2.95525908470148 41.5983848571778,-2.94330501556391 41.6006965637208,-2.94179892539978 41.6069450378418,-2.93885588645929 41.6097259521485,-2.91731595993042 41.6164627075196,-2.90716290473932 41.6251182556153,-2.89410996437073 41.6269264221191,-2.88821601867676 41.620174407959,-2.86395192146301 41.6058006286621,-2.86754393577576 41.6039848327638,-2.8669810295105 41.6026611328125,-2.86259889602661 41.6037902832031,-2.85737490653992 41.5949478149415,-2.8652400970459 41.5865364074707,-2.89540910720825 41.5737342834473,-2.90699791908264 41.5722122192384,-2.92368197441101 41.5735092163087,-2.93320202827448 41.564552307129,-2.93378305435169 41.5599441528321,-2.93158102035522 41.5558052062988,-2.93586111068714 41.5549240112305,-2.95517706871033 41.5419540405273,-2.95662689208984 41.5432243347168,-2.99234294891352 41.5480651855469))0.0006POINT(-2.929579411783498 41.58384310814645)
68546POLYGON((11.1455421447755 52.1662940979005,11.1488084793092 52.1696853637695,11.1572685241699 52.1689987182618,11.1594314575195 52.1679000854493,11.160795211792 52.1700782775879,11.1709442138672 52.1748428344726,11.175700187683 52.1749229431153,11.177001953125 52.1738815307617,11.1794500350952 52.1742477416993,11.1785116195679 52.1750869750977,11.1807899475098 52.1757659912111,11.1835880279542 52.1750221252442,11.1891307830811 52.1758460998536,11.1965160369874 52.1822891235352,11.1949033737184 52.1830368041992,11.1979846954345 52.1845359802246,11.2005043029785 52.1828422546387,11.2025899887086 52.1842956542969,11.1991605758666 52.1915016174318,11.1991605758666 52.1915016174318,11.217345237732 52.1846199035646,11.217345237732 52.1846199035646,11.2328872680664 52.1828727722169,11.2328872680664 52.1828727722169,11.2259063720704 52.1755294799805,11.2273578643798 52.1748085021973,11.2257795333863 52.1731033325196,11.2249784469605 52.1733055114747,11.2188940048217 52.1678733825683,11.2103662490844 52.1642074584961,11.1998672485352 52.1615524291992,11.2006225585938 52.1593093872071,11.1980924606324 52.1593246459962,11.1942491531372 52.1518898010254,11.1964054107667 52.1513748168945,11.1901922225953 52.149585723877,11.188838005066 52.147071838379,11.1899557113647 52.1455650329589,11.2258806228639 52.1292877197266,11.2238359451294 52.127555847168,11.1856689453126 52.1434288024903,11.1838626861572 52.143856048584,11.1760377883912 52.1417388916016,11.1635990142823 52.1438522338868,11.1635990142823 52.1438522338868,11.1630096435548 52.1447334289551,11.1584959030153 52.1452751159669,11.1552200317382 52.1507797241212,11.1526098251343 52.1523399353028,11.1467199325562 52.1648216247558,11.1449909210205 52.1656417846681,11.1455421447755 52.1662940979005))0.0006POINT(11.188887895322342 52.16527893963985)