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
68978POLYGON((12.7620573043823 50.8827705383301,12.764931678772 50.8786735534669,12.764931678772 50.8786735534669,12.768349647522 50.8796234130859,12.7689418792726 50.8809700012208,12.7718582153321 50.8800773620605,12.7741956710817 50.8807754516602,12.7740745544433 50.8788452148438,12.769718170166 50.8767623901367,12.7767744064331 50.8747062683105,12.7719306945802 50.8704986572266,12.7775211334229 50.8670043945312,12.7840995788575 50.8706016540528,12.7862386703492 50.8689727783204,12.7931776046753 50.8720779418946,12.7954301834108 50.8707466125488,12.7966413497925 50.8667526245118,12.8042745590209 50.8669166564941,12.8042745590209 50.8669166564941,12.8127508163453 50.8714561462402,12.8192501068116 50.8774032592775,12.8235731124878 50.8767776489258,12.8268527984619 50.8823280334472,12.8268527984619 50.8823280334472,12.8248224258423 50.8832778930665,12.8252649307252 50.8847198486328,12.8227043151855 50.8853187561036,12.8248672485353 50.8895797729493,12.8205757141114 50.8899955749512,12.813931465149 50.8926239013672,12.8086690902709 50.8926925659181,12.8024387359619 50.8976593017579,12.7858352661133 50.900417327881,12.7858352661133 50.900417327881,12.7800035476684 50.8915214538574,12.7815208435058 50.8856048583986,12.7669792175294 50.8903274536133,12.7666816711426 50.8883171081544,12.7620573043823 50.8827705383301))0.0006POINT(12.792863971308687 50.88092452601387)
53577POLYGON((5.02199935913097 43.5561599731445,5.03104782104492 43.5572700500489,5.04069900512707 43.5687103271484,5.05369806289679 43.5601119995117,5.06262445449835 43.5584564208984,5.06262445449835 43.5584564208984,5.06600046157843 43.5559806823732,5.07476854324347 43.5588836669922,5.08247375488281 43.5676193237305,5.08728218078613 43.5677680969239,5.09203863143921 43.5671730041504,5.10279178619396 43.5555877685547,5.10757541656506 43.5550994873048,5.10757541656506 43.5550994873048,5.12172031402582 43.5229263305664,5.12172031402582 43.5229263305664,5.11807203292852 43.5132141113281,5.11807203292852 43.5132141113281,5.11673402786266 43.5201988220215,5.10470247268688 43.5256690979005,5.06099796295172 43.5272941589356,5.04740715026867 43.5235633850099,5.03541421890259 43.5345153808595,5.03237533569336 43.5447807312012,5.02199935913097 43.5561599731445))0.0006POINT(5.077933967113548 43.54544496536258)
1399976POLYGON((-4.72634983062738 41.8545036315918,-4.74796581268305 41.8405380249024,-4.75430393218988 41.8335342407228,-4.75832891464222 41.8257751464844,-4.76914310455322 41.825839996338,-4.76999616622919 41.8231086730958,-4.78915691375727 41.8180122375489,-4.78883504867548 41.8194847106934,-4.79330015182495 41.8220367431641,-4.79478788375849 41.8287582397462,-4.79910516738892 41.8340873718262,-4.81373500823975 41.8629798889161,-4.82280111312866 41.8674316406251,-4.82920980453491 41.8750495910646,-4.83229112625116 41.8803825378419,-4.83236694335932 41.8867950439453,-4.83817386627197 41.8985176086425,-4.85600614547724 41.9131736755372,-4.85781288146973 41.9130897521973,-4.85584592819214 41.9155807495118,-4.85112619400019 41.9274749755859,-4.84024620056147 41.9328269958497,-4.84075212478638 41.9345283508302,-4.83784294128412 41.934051513672,-4.83043622970581 41.9369621276856,-4.79533100128174 41.9530830383301,-4.79302406311029 41.9491081237793,-4.78616905212397 41.9464797973634,-4.78038883209229 41.9472503662109,-4.77435588836664 41.9415893554688,-4.76780319213862 41.9462852478028,-4.76587104797358 41.9461708068849,-4.76590299606318 41.9434127807618,-4.76190280914307 41.9440231323242,-4.76064014434814 41.9472961425781,-4.75418996810913 41.9473953247071,-4.7545981407165 41.9491424560548,-4.74143409728998 41.9521560668946,-4.73995494842524 41.9558944702148,-4.72367000579834 41.9501533508302,-4.70910882949823 41.9515533447266,-4.70979213714594 41.9483070373535,-4.70414209365845 41.9418182373047,-4.70071220397944 41.9393920898439,-4.69219303131098 41.938804626465,-4.68807506561274 41.9289779663086,-4.68806982040405 41.9196395874023,-4.67781782150269 41.8979949951173,-4.68604803085327 41.8909912109374,-4.70100593566889 41.8872680664063,-4.7187128067016 41.8734016418457,-4.7281551361084 41.8688163757324,-4.73220777511597 41.8617630004884,-4.72634983062738 41.8545036315918))0.0006POINT(-4.770399930342156 41.903258341663346)
27378POLYGON((-1.40226888656616 49.1497535705566,-1.40381717681885 49.1395568847657,-1.39855980873108 49.1335716247559,-1.37465393543243 49.1265830993653,-1.36439919471735 49.1187057495117,-1.36439919471735 49.1187057495117,-1.35842752456665 49.1224098205566,-1.35842752456665 49.1224098205566,-1.368416070938 49.1367225646972,-1.37797999382019 49.1378440856935,-1.37797999382019 49.1378440856935,-1.40226888656616 49.1497535705566))0.0006POINT(-1.377211754972264 49.13128245960584)
44685POLYGON((0.601363241672516 43.1278648376465,0.601849734783229 43.1211700439454,0.611190438270683 43.1136207580567,0.621044635772762 43.0908393859863,0.621044635772762 43.0908393859863,0.62979835271841 43.1004371643067,0.62979835271841 43.1004371643067,0.615144789218903 43.1318054199219,0.615144789218903 43.1318054199219,0.601363241672516 43.1278648376465))0.0006POINT(0.6162643300162863 43.11209106445315)
28869POLYGON((3.41364908218389 47.3842582702637,3.39441037178045 47.3870544433594,3.36805820465099 47.3966369628907,3.36805820465099 47.3966369628907,3.36452817916876 47.4058494567871,3.36452817916876 47.4058494567871,3.39518117904669 47.4179000854493,3.42068052291881 47.4172096252443,3.42068052291881 47.4172096252443,3.40866184234625 47.3959808349609,3.41364908218389 47.3842582702637))0.0006POINT(3.39184362888344 47.40245857238775)
1405098POLYGON((-1.87924003601074 43.211540222168,-1.87972998619074 43.2096557617188,-1.87605404853815 43.2086486816406,-1.8702449798584 43.2106399536134,-1.86776697635651 43.2075462341309,-1.85832905769348 43.2105331420898,-1.8575249910354 43.2094535827637,-1.85995697975153 43.2084884643555,-1.85711705684662 43.2055854797364,-1.86070394515991 43.2033729553223,-1.86058294773102 43.199993133545,-1.8698849678039 43.1988487243653,-1.87435901164997 43.1998329162598,-1.87671101093287 43.1964340209961,-1.88964903354639 43.1867446899415,-1.88970899581903 43.1821174621583,-1.89545595645905 43.1785964965821,-1.8997620344162 43.1786308288575,-1.90777504444122 43.1715507507324,-1.91682302951813 43.1691856384278,-1.92088496685028 43.1725540161133,-1.92285203933716 43.1789855957032,-1.92201304435724 43.1867141723633,-1.91464197635639 43.1943130493164,-1.91094601154327 43.2043457031251,-1.9131840467453 43.2092781066895,-1.9129810333252 43.2213211059571,-1.91593205928797 43.2229881286621,-1.91084504127502 43.2272262573243,-1.90857303142542 43.2241134643555,-1.90991103649139 43.2230110168457,-1.90951395034784 43.2204513549805,-1.90322196483612 43.2184104919433,-1.90815603733063 43.2171783447266,-1.90292096138 43.2111587524415,-1.89479804038996 43.209602355957,-1.89223802089685 43.2103080749512,-1.88993895053858 43.2073593139649,-1.88829803466791 43.2116470336914,-1.88948702812195 43.2139015197754,-1.88672304153442 43.214412689209,-1.88170194625849 43.2068214416504,-1.88210999965668 43.2108306884767,-1.88133001327515 43.2122879028321,-1.87924003601074 43.211540222168))0.0006POINT(-1.8913768719542836 43.204014084555915)
37645POLYGON((0.462374329566956 48.9165077209473,0.453955203294754 48.9200515747071,0.440494805574417 48.9172554016114,0.437006354332027 48.9196205139161,0.438130646944103 48.9261741638184,0.438130646944103 48.9261741638184,0.451636165380478 48.943702697754,0.448697566986198 48.9501457214357,0.452686995267982 48.9562683105469,0.471307218074799 48.9605026245118,0.471307218074799 48.9605026245118,0.501458406448364 48.9520378112794,0.501458406448364 48.9520378112794,0.499999403953552 48.9454498291017,0.499999403953552 48.9454498291017,0.490051358938217 48.9285621643067,0.490051358938217 48.9285621643067,0.474706232547874 48.931037902832,0.462374329566956 48.9165077209473))0.0006POINT(0.4679695400927087 48.937780168321474)
65740POLYGON((11.2294073104858 47.7136573791504,11.2264957427979 47.7140121459962,11.2255420684815 47.7131462097169,11.2257308959962 47.7091751098633,11.2193241119386 47.7070999145508,11.2183752059937 47.7048263549805,11.2110452651978 47.704460144043,11.2093515396119 47.700870513916,11.2069683074952 47.6985549926758,11.2054567337037 47.6993980407715,11.2017717361451 47.6982650756837,11.2017717361451 47.6982650756837,11.1987648010255 47.6977081298829,11.1984262466431 47.6986618041993,11.197473526001 47.6985473632812,11.1962070465088 47.7011489868163,11.1965217590332 47.703498840332,11.1948080062867 47.7043914794921,11.1945781707764 47.7056045532227,11.1924686431885 47.7050743103027,11.1913261413575 47.7081642150879,11.1929092407227 47.7089805603028,11.187873840332 47.7149047851562,11.1827926635743 47.7149772644042,11.1827602386475 47.7135848999023,11.1796169281006 47.714054107666,11.1792478561402 47.7153205871583,11.1792478561402 47.7153205871583,11.1818981170654 47.7176246643068,11.1865091323852 47.7181587219239,11.1882371902466 47.72078704834,11.1862754821777 47.7212982177735,11.1900568008423 47.724937438965,11.1935453414918 47.7250175476075,11.1926527023317 47.7316207885743,11.2005805969238 47.7328186035156,11.2005805969238 47.7328186035156,11.2041463851929 47.7294692993165,11.2067470550538 47.729850769043,11.2075128555298 47.728443145752,11.2111110687256 47.727611541748,11.2138938903809 47.7247619628907,11.2231111526489 47.7248268127442,11.2231111526489 47.7248268127442,11.22474193573 47.7206726074219,11.2274436950684 47.7205200195313,11.2275133132935 47.7180290222167,11.2298192977905 47.716537475586,11.2282037734986 47.7168807983399,11.2270202636719 47.715461730957,11.2288465499878 47.7150459289551,11.2294073104858 47.7136573791504))0.0006POINT(11.20450631309962 47.71411162731697)
59526POLYGON((7.15940618515015 47.021598815918,7.16300392150879 47.0203590393066,7.16724395751959 47.0228538513184,7.1698632240296 47.0227317810059,7.17571401596069 47.0191116333008,7.17855882644653 47.0132026672364,7.18425893783569 47.0110244750978,7.18425893783569 47.0110244750978,7.18697786331188 47.011100769043,7.20108413696295 47.0194816589356,7.20108413696295 47.0194816589356,7.18601703643799 47.0281372070313,7.18412113189709 47.0309295654297,7.18371486663813 47.0358543395997,7.18371486663813 47.0358543395997,7.17835712432861 47.0353202819825,7.17835712432861 47.0353202819825,7.17340517044079 47.0298347473146,7.15940618515015 47.021598815918))0.0006POINT(7.179952303568547 47.02351231045199)