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
70194POLYGON((9.24728012084967 53.9092102050781,9.2611026763916 53.9111061096192,9.26457309722906 53.9083938598634,9.26701259613043 53.9007186889649,9.28521156311041 53.9010848999024,9.28790760040283 53.9042472839356,9.28813171386719 53.9070968627929,9.29340267181408 53.9074096679688,9.29340267181408 53.9074096679688,9.27546977996826 53.9206924438477,9.27546977996826 53.9206924438477,9.26096630096436 53.9308166503907,9.23976898193365 53.9367942810059,9.23976898193365 53.9367942810059,9.24007797241217 53.9355850219727,9.23627471923828 53.933391571045,9.22918224334722 53.9312591552736,9.23009014129644 53.9293479919434,9.23009014129644 53.9293479919434,9.2313404083252 53.9266929626465,9.23244571685785 53.9268836975098,9.2354669570924 53.9240379333496,9.23969268798828 53.9247550964355,9.24246120452892 53.9221954345703,9.2439947128297 53.9191474914552,9.24521446228027 53.9190864562989,9.24645328521734 53.9160957336427,9.24343872070324 53.9150657653809,9.24728012084967 53.9092102050781))0.0006POINT(9.253774711063974 53.91983427320213)
50566POLYGON((2.42342066764843 49.3361053466798,2.40346026420599 49.3385353088379,2.38872456550598 49.336410522461,2.38138556480408 49.340446472168,2.38138556480408 49.340446472168,2.38398694992065 49.3530158996581,2.37954711914062 49.3663406372071,2.37954711914062 49.3663406372071,2.388509273529 49.3696708679199,2.388509273529 49.3696708679199,2.39000415802008 49.3666572570801,2.39483213424688 49.3669242858888,2.39483213424688 49.3669242858888,2.39415526390076 49.3636131286622,2.40334224700928 49.3606376647949,2.40752768516552 49.3544998168945,2.42631411552441 49.3517608642579,2.43115401268017 49.3458480834962,2.43115401268017 49.3458480834962,2.42174935340893 49.3428459167482,2.42342066764843 49.3361053466798))0.0006POINT(2.399677073955576 49.35412712097174)
28692POLYGON((4.66317892074585 47.4072761535646,4.66300821304333 47.4081802368163,4.66300821304333 47.4081802368163,4.68045091629023 47.4124565124513,4.68671560287487 47.4075241088868,4.68671560287487 47.4075241088868,4.69828367233276 47.3967132568361,4.69828367233276 47.3967132568361,4.68593263626099 47.3872756958008,4.67753887176525 47.3906211853028,4.67062568664562 47.3989677429199,4.66632032394409 47.3973999023438,4.66632032394409 47.3973999023438,4.66317892074585 47.4072761535646))0.0006POINT(4.67741405046908 47.40124863844656)
1389756POLYGON((0.029984999448061 40.8239364624024,0.020052000880241 40.8276748657227,0.017926000058651 40.8241577148439,0.01539999991661 40.8234214782715,0.015814999118504 40.8168334960938,0.005805001128579 40.8133201599122,-0.003759999992269 40.8212356567383,-0.006558999884874 40.8209686279296,-0.021183999255243 40.8287773132325,-0.025526000186744 40.8335151672363,-0.032643999904394 40.8374481201172,-0.034914001822472 40.85111618042,-0.031339999288207 40.8498764038087,-0.028584999963641 40.8510055541993,-0.028381999582052 40.8542137145997,-0.014773000031653 40.861156463623,-0.006643000058773 40.8689002990724,-0.003343000076711 40.8686332702637,-0.000869999988879 40.8716239929199,0.006750999949872 40.8741264343262,0.013423999771589 40.8739700317384,0.021457999944801 40.8804969787598,0.02394700050354 40.8846015930176,0.029394000768775 40.8778305053711,0.045471001416502 40.8666725158691,0.048957999795789 40.8622550964355,0.051686998456773 40.8617248535157,0.065471000969524 40.865562438965,0.072743996977806 40.8653526306152,0.073615998029766 40.8611221313477,0.070511996746063 40.8560638427734,0.05853499844676 40.8512840270997,0.057227000594196 40.8460235595704,0.051610998809338 40.8433074951172,0.040690001100302 40.8415145874025,0.041409999132156 40.8342208862305,0.034967001527605 40.8320465087891,0.029984999448061 40.8239364624024))0.0006POINT(0.018225216039348402 40.84935110968516)
30346POLYGON((-2.73699569702148 48.497341156006,-2.72751021385187 48.5131149291992,-2.71052050590515 48.520694732666,-2.71052050590515 48.520694732666,-2.70708394050598 48.5187492370605,-2.70680594444275 48.516529083252,-2.70402789115906 48.5162506103516,-2.70152807235712 48.5118064880372,-2.69680500030518 48.5093040466309,-2.69486093521112 48.5070838928224,-2.68930506706238 48.5073623657228,-2.69041705131531 48.5056953430176,-2.68819499015802 48.5048599243165,-2.68791699409479 48.5001373291015,-2.68614530563354 48.5006942749025,-2.68614530563354 48.5006942749025,-2.68463802337646 48.4985504150391,-2.68509221076965 48.498016357422,-2.68014740943897 48.4943923950196,-2.68014740943897 48.4943923950196,-2.68102383613586 48.4923973083497,-2.67974257469172 48.4917335510254,-2.68810868263245 48.48392868042,-2.68810868263245 48.48392868042,-2.70707345008844 48.4856491088867,-2.73699569702148 48.497341156006))0.0006POINT(-2.695954627990697 48.50296005249029)
1400618POLYGON((-6.25749683380127 40.7104301452636,-6.24208307266235 40.7164421081544,-6.23550701141352 40.7165794372559,-6.22844886779785 40.7248039245605,-6.22231578826899 40.7243270874023,-6.21780109405512 40.7256774902344,-6.20641708374018 40.7218322753906,-6.20454502105707 40.7257766723634,-6.20100593566895 40.7279891967774,-6.19930076599121 40.7270011901857,-6.19789314270014 40.7297134399415,-6.1959462165832 40.729850769043,-6.17582798004145 40.7255706787111,-6.16326093673706 40.7151794433594,-6.16191577911371 40.7120628356934,-6.16214895248413 40.7082290649415,-6.16485214233393 40.7077941894532,-6.16382884979248 40.7002029418946,-6.15980100631702 40.6956024169923,-6.1579761505127 40.6890258789063,-6.15227079391479 40.679714202881,-6.14992618560791 40.6778793334962,-6.14552021026606 40.677303314209,-6.15841293334961 40.6537437438966,-6.16484117507935 40.6503410339357,-6.17190122604364 40.6571044921876,-6.17922592163086 40.6601791381835,-6.18534803390497 40.6598472595216,-6.18894004821772 40.6625022888185,-6.20934486389154 40.6694602966309,-6.21183395385742 40.6791687011719,-6.21868085861206 40.6893997192383,-6.22113990783691 40.7009315490723,-6.22396802902216 40.7033729553222,-6.2287540435791 40.705909729004,-6.23387289047241 40.7060585021973,-6.2369771003722 40.7083168029786,-6.23982620239246 40.7065162658692,-6.24241304397572 40.7081260681153,-6.25404119491571 40.7041511535645,-6.25749683380127 40.7104301452636))0.0006POINT(-6.198390281200373 40.69985294342046)
38897POLYGON((2.03799080848705 43.0740432739258,2.03024387359631 43.074333190918,2.03024387359631 43.074333190918,2.02224612236023 43.0785865783693,2.02224612236023 43.0785865783693,2.02347350120556 43.0952911376953,2.00098395347607 43.1075897216797,1.98227918148041 43.1101036071777,1.98227918148041 43.1101036071777,1.99105978012096 43.1205215454102,1.99105978012096 43.1205215454102,2.00924301147461 43.1206703186036,2.00924301147461 43.1206703186036,2.0336778163911 43.1141204833986,2.0336778163911 43.1141204833986,2.03200483322149 43.1011085510253,2.05301475524908 43.0894203186036,2.05301475524908 43.0894203186036,2.04253196716314 43.0747032165528,2.03799080848705 43.0740432739258))0.0006POINT(2.020027060257827 43.09832884136004)
13537POLYGON((14.6710844039918 41.176181793213,14.6672916412354 41.1715126037598,14.65891456604 41.1756629943848,14.6588525772094 41.1670951843262,14.6616582870483 41.1593894958497,14.6704721450805 41.1436233520508,14.6757068634033 41.1430091857911,14.6852569580079 41.1474456787111,14.6852569580079 41.1474456787111,14.6859502792358 41.1489486694337,14.7055721282959 41.1550712585449,14.7095632553101 41.1528549194336,14.7125473022462 41.1491317749024,14.7125473022462 41.1491317749024,14.7170238494874 41.149513244629,14.7192525863647 41.1524772644044,14.7189598083497 41.1542243957521,14.7147111892701 41.1583366394043,14.7130002975464 41.165428161621,14.7152128219604 41.1664733886719,14.7152128219604 41.1664733886719,14.7116489410402 41.169002532959,14.6981830596924 41.1731643676758,14.6911354064943 41.1740531921388,14.6731643676758 41.1726837158203,14.6710844039918 41.176181793213))0.0006POINT(14.693927192688017 41.15953338623052)
29100POLYGON((4.32024049758905 46.6810646057129,4.31520128250122 46.6809959411622,4.31111478805542 46.6873359680176,4.25148677825939 46.6932792663574,4.228437423706 46.6995429992676,4.228437423706 46.6995429992676,4.22905969619751 46.706226348877,4.24912691116333 46.7158737182617,4.24973201751715 46.7228164672853,4.25888347625727 46.7351722717285,4.25228977203375 46.754795074463,4.27290296554571 46.7649879455566,4.27290296554571 46.7649879455566,4.27478837966919 46.7548713684082,4.28561210632336 46.7433128356934,4.34536457061768 46.7323722839355,4.34536457061768 46.7323722839355,4.33673286437988 46.7243690490723,4.33298349380499 46.7146034240723,4.34448909759521 46.7102470397949,4.34907341003424 46.7045364379884,4.34748888015747 46.6981811523438,4.34748888015747 46.6981811523438,4.3443403244018 46.6920661926269,4.32024049758905 46.6810646057129))0.0006POINT(4.295564273993187 46.717155615488714)
50463POLYGON((2.22962069511419 49.7021942138672,2.20540308952343 49.6986351013184,2.19203639030468 49.7028961181642,2.19203639030468 49.7028961181642,2.21579504013067 49.6867408752443,2.21579504013067 49.6867408752443,2.22844099998468 49.6903800964357,2.23246264457697 49.7020797729493,2.23246264457697 49.7020797729493,2.22962069511419 49.7021942138672))0.0006POINT(2.2160058816274373 49.69718254937076)