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
41521POLYGON((5.86772918701172 48.9675025939943,5.87376117706299 48.9831581115724,5.87376117706299 48.9831581115724,5.88511514663696 48.982048034668,5.88511514663696 48.982048034668,5.90584182739263 48.972053527832,5.91514301300049 48.9736366271972,5.91514301300049 48.9736366271972,5.91773796081554 48.9706764221192,5.91175889968878 48.9615440368653,5.91976356506359 48.9585609436036,5.91976356506359 48.9585609436036,5.91685676574713 48.9530334472657,5.90678358078009 48.9517478942871,5.90678358078009 48.9517478942871,5.89906454086315 48.955436706543,5.88409042358404 48.9549713134766,5.86772918701172 48.9675025939943))0.0006POINT(5.900247798246542 48.96667772180898)
18696POLYGON((15.0108518600464 37.5783843994141,15.0116767883301 37.5642585754394,15.0156507492066 37.5572738647462,15.0186271667482 37.5565872192383,15.0223979949952 37.5508575439453,15.0223979949952 37.5508575439453,14.9998998641968 37.5398254394532,14.9906330108643 37.5335502624511,14.9906330108643 37.5335502624511,14.9871339797974 37.535400390625,14.9871339797974 37.535400390625,14.9883899688721 37.5435447692872,14.9929609298707 37.5486030578614,14.9967546463013 37.5558700561524,15.001181602478 37.5690116882325,15.0049409866332 37.5753707885743,15.0108518600464 37.5783843994141))0.0006POINT(15.002579033374822 37.551771640777616)
44029POLYGON((0.987807869911251 43.6358108520509,0.966078281402588 43.6429405212403,0.966078281402588 43.6429405212403,0.967526555061454 43.6471862792969,0.967526555061454 43.6471862792969,0.977663516998348 43.6539306640626,0.977663516998348 43.6539306640626,0.985245287418365 43.651954650879,0.991459131240958 43.6557502746583,0.994886219501609 43.6541748046875,0.994886219501609 43.6541748046875,0.999668896198216 43.6482048034669,0.997517347335815 43.6306686401368,0.997517347335815 43.6306686401368,0.987807869911251 43.6358108520509))0.0006POINT(0.983680358954887 43.646394457135955)
65878POLYGON((11.1995639801025 49.8327026367188,11.1977882385255 49.8329734802247,11.1969842910768 49.8350868225098,11.1932516098023 49.8357276916505,11.1942443847657 49.8379707336426,11.1889982223512 49.8388328552246,11.189091682434 49.8366622924805,11.1878261566162 49.8356895446778,11.1822519302369 49.8349685668945,11.1751060485841 49.8323402404785,11.1732559204102 49.8333320617676,11.1728258132936 49.8353500366211,11.1672830581665 49.8368492126466,11.1749830245972 49.8384017944336,11.1758184432983 49.8393974304199,11.1694240570069 49.8387947082521,11.1692714691162 49.8427276611328,11.1712846755982 49.8434295654298,11.1681213378907 49.8450393676758,11.1592378616334 49.8435897827149,11.1474180221559 49.8450164794921,11.1444644927979 49.8437080383301,11.1412382125854 49.8448600769044,11.1400527954102 49.8415641784669,11.1377506256104 49.8399848937988,11.1377506256104 49.8399848937988,11.1361818313599 49.8381576538086,11.1374521255494 49.8353538513185,11.1381120681764 49.8296012878419,11.1419610977173 49.8303527832031,11.1431484222412 49.8286628723146,11.1449413299561 49.8286094665528,11.1421728134156 49.8264846801759,11.1524982452393 49.8218612670899,11.1596717834474 49.816677093506,11.1596717834474 49.816677093506,11.1641292572021 49.8132400512696,11.168553352356 49.8124198913575,11.1689109802246 49.8112144470215,11.1715774536134 49.8129692077637,11.1734361648561 49.8126182556153,11.174695968628 49.8112602233887,11.171854019165 49.811824798584,11.17316532135 49.8111724853516,11.1726818084718 49.8094558715821,11.1769332885743 49.8092231750489,11.1816301345826 49.8110313415527,11.1846094131469 49.8103561401367,11.1838417053223 49.8120880126954,11.1850414276124 49.8123245239258,11.187310218811 49.8086471557617,11.189458847046 49.8082313537598,11.1912937164308 49.8101081848145,11.1965713500978 49.8107223510742,11.1963844299316 49.8131446838379,11.2012739181519 49.8128280639648,11.2006473541259 49.8165473937988,11.2029304504395 49.8167037963868,11.2029304504395 49.8167037963868,11.2039756774902 49.8177947998047,11.2023811340333 49.8190269470215,11.2005262374878 49.8186988830567,11.2019968032837 49.8212699890136,11.1996459960937 49.8241004943849,11.2012042999269 49.8250465393068,11.1981325149537 49.8261260986328,11.2036237716675 49.8269386291505,11.2055969238281 49.8295974731445,11.2043561935425 49.8322410583497,11.2029561996461 49.8316497802736,11.1995639801025 49.8327026367188))0.0006POINT(11.176505075182277 49.826067842756025)
71875POLYGON((15.9615926742554 48.3261566162111,15.9368743896485 48.3265380859376,15.9361219406128 48.3252296447754,15.9376630783082 48.3214073181153,15.9376630783082 48.3214073181153,15.9311046600342 48.3058738708496,15.9270715713501 48.3003845214845,15.890983581543 48.2854690551758,15.890983581543 48.2854690551758,15.885365486145 48.268741607666,15.8873434066772 48.2669563293458,15.8950643539429 48.2642631530763,15.8950643539429 48.2642631530763,15.9213905334472 48.2654457092285,15.9213905334472 48.2654457092285,15.922158241272 48.267791748047,15.9243650436403 48.2696838378907,15.9311151504517 48.272258758545,15.9959373474122 48.2831420898438,15.9959373474122 48.2831420898438,16.0063800811769 48.2947235107421,15.9993667602539 48.2971458435059,15.9993667602539 48.2971458435059,15.9615926742554 48.3261566162111))0.0006POINT(15.936100171959954 48.28948195084286)
25083POLYGON((2.23546266555798 48.7275619506836,2.22079396247875 48.7256698608399,2.21290206909174 48.7288017272949,2.21290206909174 48.7288017272949,2.21369051933289 48.7378463745117,2.2040359973908 48.7369194030763,2.2040359973908 48.7369194030763,2.22641491889959 48.7500343322754,2.22641491889959 48.7500343322754,2.23802423477179 48.7355651855469,2.23802423477179 48.7355651855469,2.24099969863886 48.7329330444337,2.23546266555798 48.7275619506836))0.0006POINT(2.2228084405263595 48.73555437723798)
57220POLYGON((7.36294603347773 50.671199798584,7.35582113265997 50.6652297973633,7.35649204254156 50.6636810302734,7.35516738891602 50.6616821289064,7.35565710067749 50.6553535461425,7.35766506195063 50.6549224853516,7.35897636413569 50.6494941711426,7.33804988861084 50.6422424316407,7.33348083496094 50.6383972167969,7.32415151596075 50.6404266357422,7.32217502594006 50.6417160034179,7.31463146209728 50.638599395752,7.31466817855846 50.637435913086,7.31466817855846 50.637435913086,7.31638526916504 50.6350975036622,7.31638526916504 50.6350975036622,7.31515407562256 50.6307220458985,7.31515407562256 50.6307220458985,7.31950426101685 50.6298446655275,7.32992601394665 50.6298408508301,7.32992601394665 50.6298408508301,7.33729553222656 50.6305770874024,7.33766174316401 50.6295585632325,7.34857845306402 50.6255683898927,7.34959650039684 50.6230659484864,7.35158157348638 50.621337890625,7.36027050018311 50.620330810547,7.36226844787609 50.6179809570313,7.3664112091065 50.6186866760255,7.3664112091065 50.6186866760255,7.37178564071667 50.6217155456544,7.38181400299078 50.619728088379,7.37685298919683 50.6227912902832,7.37647294998163 50.6246604919434,7.3727498054505 50.6259307861328,7.37250995635986 50.6273994445801,7.37736892700207 50.6286315917969,7.37578678131115 50.6306953430177,7.37814378738415 50.630802154541,7.38046360015869 50.6329650878906,7.38777160644543 50.6320915222168,7.38772964477533 50.634204864502,7.38517522811884 50.6355667114259,7.3845238685609 50.6396026611329,7.38937330245983 50.641212463379,7.38972520828253 50.6420936584473,7.38793516159063 50.6436653137208,7.38793516159063 50.6436653137208,7.38070440292364 50.6452636718751,7.37690877914429 50.6475944519043,7.37639331817633 50.6514892578125,7.37762594223034 50.6523323059082,7.37645435333263 50.653964996338,7.37729692459106 50.6557731628418,7.3761568069458 50.6567230224611,7.37658214569103 50.6575622558594,7.37214136123652 50.6612625122071,7.37131357192993 50.6666336059571,7.36854839324957 50.6683578491212,7.36704015731823 50.6705589294435,7.36294603347773 50.671199798584))0.0006POINT(7.359139068921451 50.639828554789254)
52189POLYGON((0.0746836513282005 45.7148361206054,0.0519267916680519 45.7382659912111,0.0519267916680519 45.7382659912111,0.0262300670148079 45.7229118347169,0.0199670176953077 45.7281150817871,0.0199670176953077 45.7281150817871,0.0107034435496871 45.7238235473633,0.0107034435496871 45.7238235473633,0.0150862969458103 45.7222366333009,0.0139876073225764 45.7058982849122,0.0232270099222092 45.6979255676271,0.0253102723509073 45.6912307739258,0.0253102723509073 45.6912307739258,0.0277095586060909 45.6906089782715,0.0277095586060909 45.6906089782715,0.0342541001738255 45.6956481933594,0.039245069026947 45.6956176757812,0.0578070469201748 45.6754302978516,0.0578070469201748 45.6754302978516,0.0758511722088429 45.6874084472656,0.0790206491947743 45.7011604309083,0.0849090442061993 45.7067985534668,0.0849090442061993 45.7067985534668,0.0746836513282005 45.7148361206054))0.0006POINT(0.04079356404916661 45.706616940705715)
36028POLYGON((6.45185947418224 46.8420639038087,6.44189167022699 46.830047607422,6.43980503082281 46.8160057067872,6.43099880218512 46.8123207092286,6.43099880218512 46.8123207092286,6.4182505607605 46.8166580200196,6.38829469680792 46.8154258728028,6.37853336334229 46.8171997070313,6.3761510848999 46.8202629089355,6.3761510848999 46.8202629089355,6.38213014602661 46.8371734619141,6.37274456024181 46.8446235656739,6.37389183044434 46.8550262451173,6.38292694091803 46.857707977295,6.40790843963623 46.8548889160156,6.41711139678955 46.862907409668,6.44151163101196 46.8676681518555,6.44151163101196 46.8676681518555,6.46131849288935 46.8621788024903,6.46131849288935 46.8621788024903,6.45976114273066 46.8515930175782,6.45185947418224 46.8420639038087))0.0006POINT(6.415955679757269 46.83934202648351)
17260POLYGON((7.95490884780895 45.0306282043457,7.95762014389049 45.0394134521486,7.95337820053106 45.0474739074708,7.94674015045166 45.0559577941895,7.94416093826294 45.0580749511719,7.94178915023815 45.0581245422364,7.94178915023815 45.0581245422364,7.94575786590588 45.0683517456055,7.94828987121582 45.070930480957,7.95282506942749 45.0727348327636,7.95282506942749 45.0727348327636,7.9693431854248 45.0684051513673,7.9693431854248 45.0684051513673,7.98361015319836 45.0495376586915,7.99101305007946 45.0465316772461,7.99485397338867 45.0478897094727,8.00380516052257 45.0408630371094,8.00380516052257 45.0408630371094,8.00527095794678 45.0378150939943,8.00527095794678 45.0378150939943,8.00103664398193 45.0359344482422,8.00156497955328 45.034309387207,8.00456905364996 45.0332183837891,8.008222579956 45.0339889526368,8.008222579956 45.0339889526368,8.01909828186041 45.0238494873047,8.01909828186041 45.0238494873047,8.0187349319458 45.0211181640626,8.01640987396252 45.0192298889161,8.00783252716059 45.014389038086,7.9972758293153 45.0106773376465,7.99513578414917 45.0017242431641,7.99620294570934 44.9972801208497,7.99620294570934 44.9972801208497,7.98941278457642 44.9985084533693,7.98386478424084 45.0101013183594,7.9746880531311 45.0192184448243,7.96580314636236 45.0248336791993,7.95687484741205 45.0278358459473,7.95490884780895 45.0306282043457))0.0006POINT(7.982734643496044 45.03671822181118)