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
37502POLYGON((0.865741610527095 49.2516746520997,0.85969120264059 49.2435188293458,0.85969120264059 49.2435188293458,0.86470752954483 49.2301559448243,0.858307361602726 49.2205619812012,0.863243162631989 49.2144165039064,0.863243162631989 49.2144165039064,0.866757214069366 49.2160873413087,0.866757214069366 49.2160873413087,0.867586314678135 49.2192878723146,0.880174696445522 49.2243461608887,0.880174696445522 49.2243461608887,0.884714066982269 49.2338790893556,0.897659838199559 49.2387199401857,0.895370483398551 49.245361328125,0.895370483398551 49.245361328125,0.88011234998703 49.2550048828126,0.865741610527095 49.2516746520997))0.0006POINT(0.8734883876408048 49.23157321705546)
1409320POLYGON((-2.73665404319757 43.1824378967286,-2.73815608024591 43.1847991943359,-2.73973298072809 43.1844367980958,-2.7458570003509 43.1885032653809,-2.75364708900452 43.1853828430177,-2.76177906990046 43.18896484375,-2.77410411834717 43.1873435974121,-2.77513003349299 43.1892852783204,-2.77615809440613 43.1874465942383,-2.7849171161651 43.1885452270509,-2.78638696670532 43.1868209838868,-2.8001890182494 43.1921005249024,-2.79446601867676 43.1995201110839,-2.79452800750727 43.2144165039063,-2.78032588958735 43.2294006347656,-2.77846407890314 43.2303428649903,-2.77606201171869 43.2303848266602,-2.77417302131647 43.228370666504,-2.77495408058167 43.2267150878906,-2.77026391029358 43.2234649658203,-2.75059509277338 43.2183265686036,-2.74801301956177 43.2145118713379,-2.74659299850458 43.2008666992188,-2.74165892601013 43.1973419189453,-2.73566389083862 43.1833724975587,-2.73665404319757 43.1824378967286))0.0006POINT(-2.765538902282679 43.20172409057621)
65156POLYGON((12.1154899597168 49.5479545593262,12.1151456832886 49.5492362976075,12.1163835525513 49.5494461059571,12.1165084838867 49.5510902404786,12.1191339492798 49.5514297485353,12.11869430542 49.5535430908204,12.117455482483 49.5537414550782,12.1196422576905 49.556209564209,12.1192312240601 49.5587997436524,12.1130094528198 49.5597076416016,12.1101026535034 49.561710357666,12.1095952987672 49.5642280578614,12.104419708252 49.567539215088,12.101050376892 49.5656623840333,12.1026115417481 49.5631294250489,12.0992994308472 49.5633850097657,12.0996704101563 49.5612182617188,12.1014947891235 49.5599517822266,12.1008634567261 49.5596809387208,12.0928344726564 49.5607490539551,12.0916366577149 49.5596656799317,12.0812702178955 49.5616035461426,12.0763578414917 49.5644721984864,12.0756063461304 49.5622596740723,12.072385787964 49.5627517700195,12.0726613998413 49.5646476745606,12.0682907104492 49.5648841857911,12.0679025650024 49.5681953430176,12.0692567825318 49.5698318481445,12.0677976608276 49.5709075927736,12.0679931640626 49.5726509094239,12.0727882385254 49.5737266540527,12.0706882476807 49.5771827697754,12.0713281631469 49.5781364440918,12.0690698623657 49.57763671875,12.0690698623657 49.57763671875,12.0677928924562 49.5792121887208,12.0682458877565 49.5799255371094,12.0792903900146 49.5849914550782,12.0842266082763 49.5827522277833,12.0895709991456 49.5834465026855,12.0896320343019 49.5867614746093,12.0906600952149 49.5876922607423,12.090401649475 49.5895042419435,12.0861225128174 49.5902748107911,12.0868625640869 49.5908699035645,12.0858259201051 49.592601776123,12.0817270278931 49.5925598144532,12.0803995132447 49.5938491821289,12.0786876678468 49.5922966003419,12.0720233917237 49.594638824463,12.0743036270142 49.5961990356446,12.0700635910034 49.5965003967286,12.0702333450319 49.5978851318359,12.0732612609864 49.6028099060059,12.0732612609864 49.6028099060059,12.0756788253785 49.6022453308107,12.080177307129 49.6042976379395,12.0923500061036 49.5964508056642,12.0944185256959 49.597053527832,12.0955266952515 49.5999794006349,12.0975637435914 49.6000213623047,12.1009550094604 49.6066322326661,12.1064538955688 49.6089363098146,12.1093654632569 49.6117324829103,12.1148443222046 49.6148490905763,12.1191711425782 49.6125717163086,12.1188707351686 49.6139373779297,12.1209144592286 49.6145629882814,12.1186618804931 49.6159553527833,12.1190671920776 49.6172714233398,12.1257781982422 49.6175003051758,12.1257781982422 49.6175003051758,12.1272897720337 49.6151313781738,12.1290025711061 49.6145935058595,12.1311283111572 49.6155853271484,12.1320247650147 49.6187324523926,12.1371021270753 49.6185531616212,12.1399583816528 49.6162261962891,12.1399583816528 49.6162261962891,12.140461921692 49.6147766113282,12.1440868377687 49.6154708862305,12.1456518173219 49.6146659851075,12.1440553665162 49.6069068908691,12.1417226791382 49.6055259704591,12.1381731033326 49.606990814209,12.1358337402344 49.6049919128418,12.136013031006 49.6033592224122,12.138692855835 49.6035804748536,12.1407995224 49.6024169921875,12.1455669403077 49.6041564941406,12.1488418579102 49.6019668579103,12.1520404815673 49.6019744873048,12.1511754989625 49.6005744934083,12.1532354354859 49.600887298584,12.1534318923951 49.6021614074707,12.1587390899658 49.6019134521485,12.1589450836182 49.6002464294434,12.1627655029297 49.6010360717775,12.1648950576783 49.5993576049805,12.1635074615479 49.5988922119141,12.1639165878296 49.5978965759278,12.1666479110717 49.5988273620607,12.1677808761597 49.5987548828126,12.1679544448853 49.5977745056152,12.1761178970337 49.6004066467285,12.1875095367431 49.6003265380859,12.1891984939576 49.6014976501466,12.1888103485107 49.6030426025391,12.1919317245484 49.6032104492188,12.1974382400513 49.6015357971191,12.1968698501587 49.6001205444336,12.1932582855225 49.5980529785156,12.19407081604 49.5963783264161,12.1953277587891 49.5966835021973,12.196053504944 49.5956802368165,12.1933307647706 49.5946426391602,12.1958103179932 49.5945892333984,12.1976690292359 49.5934295654296,12.1976690292359 49.5934295654296,12.1940622329712 49.5937957763673,12.1936798095704 49.5925331115724,12.1946420669556 49.5909347534181,12.1894083023071 49.5894088745118,12.1871843338014 49.5848541259765,12.1888847351075 49.5836143493652,12.1883087158204 49.5829734802247,12.1804132461549 49.5835762023927,12.1797351837158 49.5820121765137,12.1845045089722 49.581455230713,12.1849384307862 49.574520111084,12.1841583251954 49.5731925964356,12.1794967651367 49.5718307495118,12.1846952438354 49.5707550048828,12.183892250061 49.5699577331544,12.1761903762817 49.5697097778321,12.1765651702881 49.5681648254394,12.1742115020752 49.5677337646484,12.1741552352905 49.5669059753419,12.1677494049072 49.5669212341309,12.1613874435426 49.5685539245605,12.1614704132081 49.5637817382813,12.1583147048951 49.566131591797,12.1518707275391 49.565830230713,12.1486616134644 49.5686492919922,12.1476135253906 49.5683593750001,12.1402988433838 49.564453125,12.13076877594 49.5622749328613,12.1278495788575 49.5600852966309,12.1267910003662 49.5582618713379,12.127088546753 49.5557098388672,12.1312484741211 49.5530090332031,12.1339721679688 49.5497512817382,12.1259689331055 49.5498657226563,12.1154899597168 49.5479545593262))0.0006POINT(12.129984112529044 49.58588590250388)
38694POLYGON((1.88064789772028 43.1475410461426,1.87448990345007 43.1426467895508,1.85684728622442 43.144630432129,1.85196006298071 43.1606063842774,1.85196006298071 43.1606063842774,1.84303498268139 43.1718559265138,1.84415614604956 43.1815490722656,1.84415614604956 43.1815490722656,1.85272836685192 43.1813316345215,1.86766946315771 43.1873207092285,1.86766946315771 43.1873207092285,1.88165295124054 43.184497833252,1.88165295124054 43.184497833252,1.88801503181452 43.1713829040528,1.88283145427704 43.1655120849609,1.88741064071667 43.1453285217286,1.88741064071667 43.1453285217286,1.88064789772028 43.1475410461426))0.0006POINT(1.8673113794888245 43.16726505055152)
15129POLYGON((9.70477390289312 45.6604156494141,9.69861412048346 45.6591567993164,9.68659591674816 45.6503982543945,9.67784595489513 45.647445678711,9.67784595489513 45.647445678711,9.65978240966803 45.6565513610841,9.65978240966803 45.6565513610841,9.668779373169 45.663429260254,9.66969299316412 45.6653861999512,9.67641544342052 45.6713676452637,9.67959976196283 45.6651229858398,9.67959976196283 45.6651229858398,9.68127155303961 45.6643104553223,9.693925857544 45.6640701293946,9.70380020141613 45.665325164795,9.70477390289312 45.6604156494141))0.0006POINT(9.681221707662008 45.66013997395837)
60635POLYGON((8.6837940216065 47.749496459961,8.68505096435547 47.7505226135254,8.68579483032232 47.7541046142579,8.69008636474615 47.7574882507325,8.6886415481568 47.7629165649415,8.6886415481568 47.7629165649415,8.68607807159418 47.7637901306153,8.67136287689215 47.7756462097168,8.67136287689215 47.7756462097168,8.6600542068482 47.7732086181642,8.65779304504395 47.7718963623048,8.65779304504395 47.7718963623048,8.65906143188482 47.7686691284179,8.65645694732666 47.7667503356934,8.65888690948492 47.7640953063965,8.65927696228027 47.7619857788087,8.65616607666027 47.7587394714356,8.65531253814697 47.7564392089845,8.65605163574219 47.755599975586,8.65605163574219 47.755599975586,8.66172409057623 47.7505569458007,8.66490745544445 47.7504806518555,8.66834163665783 47.7523193359375,8.67462921142584 47.7532653808594,8.67969226837164 47.7523345947266,8.6837940216065 47.749496459961))0.0006POINT(8.669320487976115 47.76065460205082)
42158POLYGON((6.63378334045416 49.0687294006348,6.6243634223938 49.0644836425782,6.6243634223938 49.0644836425782,6.61542034149164 49.067653656006,6.60818910598761 49.0631446838379,6.5990691184997 49.0785751342774,6.60089731216442 49.0847778320312,6.60089731216442 49.0847778320312,6.60092306137096 49.0859375,6.60092306137096 49.0859375,6.62707281112671 49.0922508239747,6.62707281112671 49.0922508239747,6.63378334045416 49.0687294006348))0.0006POINT(6.613581260045407 49.07775020599369)
1407702POLYGON((-8.83782863616943 43.1375846862793,-8.83043956756586 43.139633178711,-8.81698226928711 43.1346130371094,-8.81550025939941 43.1354370117188,-8.81485843658442 43.1395301818848,-8.82210826873779 43.1448135375977,-8.82288932800287 43.1466979980469,-8.82109642028809 43.1485214233398,-8.82974720001221 43.1651000976562,-8.82650375366211 43.1666793823242,-8.82716464996332 43.1701393127443,-8.829833984375 43.169605255127,-8.83299255371094 43.1733322143555,-8.83364200592035 43.1872177124023,-8.8363037109375 43.1958732604982,-8.82798767089838 43.2135467529296,-8.81869602203369 43.2176589965821,-8.81803512573242 43.2219581604004,-8.81478881835938 43.2239418029785,-8.81586265563965 43.2255172729493,-8.80870628356934 43.2253532409669,-8.79633522033691 43.2325973510743,-8.79384422302246 43.2309951782227,-8.78922176361084 43.2353439331055,-8.78149318695068 43.2369346618652,-8.77497482299799 43.2411613464355,-8.77160358428955 43.238468170166,-8.76966190338123 43.2296562194824,-8.76508426666248 43.2227668762208,-8.75098896026611 43.2238235473634,-8.74447059631348 43.2170753479003,-8.74645233154291 43.2125091552735,-8.73885345458984 43.2112617492676,-8.73913097381592 43.2088470458985,-8.72365283966064 43.2052307128907,-8.72140407562256 43.2060470581056,-8.71713733673096 43.2039756774902,-8.71338558197021 43.1980934143067,-8.70497608184809 43.1963005065918,-8.70178127288813 43.1901588439943,-8.69956111907959 43.189567565918,-8.70390033721924 43.1817817687988,-8.71050739288324 43.178508758545,-8.71275043487549 43.1753883361817,-8.70834541320795 43.1761398315431,-8.70657062530518 43.173366546631,-8.68838787078857 43.1708068847657,-8.68832015991211 43.1667709350587,-8.68614101409906 43.1651496887208,-8.68939971923822 43.1597480773926,-8.68836784362793 43.1557769775391,-8.6902437210083 43.1493797302246,-8.68761825561518 43.1446800231934,-8.68895435333246 43.1397514343262,-8.69904327392572 43.1389312744142,-8.7033052444458 43.1342811584474,-8.71451377868652 43.1294059753419,-8.71186065673828 43.1237716674805,-8.70244598388672 43.1182098388672,-8.69822502136225 43.119068145752,-8.69594573974609 43.1146545410157,-8.69746398925781 43.1118240356446,-8.68999481201166 43.1002082824707,-8.69088172912592 43.0949172973633,-8.68820571899414 43.0855674743653,-8.70026683807367 43.0907211303711,-8.70416545867914 43.0939102172853,-8.73602199554438 43.1006927490234,-8.74309730529785 43.0983085632324,-8.75063800811768 43.100929260254,-8.75265502929682 43.1030387878418,-8.74588584899902 43.1087989807129,-8.74576759338379 43.1105537414551,-8.75061130523682 43.1109580993653,-8.76842498779297 43.1080970764161,-8.77005672454828 43.108959197998,-8.77028656005854 43.1167488098144,-8.79100894927973 43.1127853393556,-8.80782032012939 43.1187591552734,-8.81335830688477 43.1176872253419,-8.8234024047851 43.0986099243165,-8.82778930664057 43.1000633239747,-8.83111000061035 43.0981636047364,-8.83454895019526 43.0985488891602,-8.83776283264154 43.1037750244141,-8.8513097763061 43.1042594909669,-8.85725021362299 43.1202507019044,-8.85051155090332 43.1230239868165,-8.84971714019775 43.125270843506,-8.84490776062006 43.1244468688965,-8.8427791595459 43.1259689331056,-8.84681606292725 43.1366882324219,-8.84563255310059 43.1379585266113,-8.84089660644531 43.1390724182129,-8.83782863616943 43.1375846862793))0.0006POINT(-8.767253977187115 43.15594368792597)
59141POLYGON((8.11469364166271 47.5228805541992,8.09561920166027 47.5247650146484,8.09137821197515 47.523868560791,8.09137821197515 47.523868560791,8.08246707916271 47.5187759399415,8.08222866058361 47.5178070068361,8.08222866058361 47.5178070068361,8.08860683441162 47.5140533447266,8.08912754058849 47.509220123291,8.09045886993408 47.5076599121094,8.09493255615234 47.506233215332,8.10453891754156 47.5060958862305,8.10453891754156 47.5060958862305,8.11106109619152 47.5062980651857,8.11605930328363 47.5085296630859,8.11987209320068 47.5197410583497,8.11987209320068 47.5197410583497,8.11538028717047 47.5212287902832,8.11469364166271 47.5228805541992))0.0006POINT(8.099691232045547 47.515259424845425)
70633POLYGON((10.9759626388551 51.0648727416993,10.9725055694581 51.0647430419923,10.9715299606324 51.0657005310059,10.96488571167 51.0638656616211,10.9607610702515 51.06400680542,10.9434795379639 51.0606346130372,10.9408998489381 51.0610885620118,10.9440813064576 51.0558166503906,10.936484336853 51.0531425476075,10.9355707168579 51.0546646118164,10.9237241744995 51.0518455505372,10.9189147949219 51.0519638061525,10.9176073074341 51.0494575500488,10.9098930358887 51.0487289428712,10.9098930358887 51.0487289428712,10.911361694336 51.0454330444337,10.9133644104004 51.0458755493163,10.9138040542603 51.0440177917482,10.9117889404298 51.040454864502,10.914158821106 51.0405349731445,10.9122819900514 51.0349464416504,10.9170923233033 51.0350799560547,10.9310531616212 51.032527923584,10.9364137649536 51.0304870605469,10.9364137649536 51.0304870605469,10.9383258819581 51.0304183959962,10.93834400177 51.0323066711426,10.9435997009277 51.0323982238771,10.9456310272217 51.0331573486328,10.9459619522096 51.0345268249511,10.9483156204224 51.0342903137208,10.948781967163 51.0356864929199,10.9507226943971 51.0349388122559,10.9545440673829 51.0372886657715,10.9654893875123 51.0386505126953,10.9656314849855 51.0400619506837,10.9803867340088 51.0410804748535,10.9800577163697 51.04252243042,10.9861450195313 51.0432357788086,10.984616279602 51.0526542663574,10.9804134368898 51.0521125793457,10.9796113967897 51.0559768676759,10.9778423309326 51.0560913085938,10.9773273468018 51.06014251709,10.9760112762452 51.0598793029786,10.9752445220947 51.0617179870606,10.9769315719606 51.0619354248047,10.9759626388551 51.0648727416993))0.0006POINT(10.947741731684317 51.047025071813735)