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
36190POLYGON((6.43329668045038 47.7855377197266,6.41114473342896 47.7792396545411,6.36825227737432 47.787624359131,6.36825227737432 47.787624359131,6.35852718353277 47.7928047180175,6.35852718353277 47.7928047180175,6.35921716690063 47.798854827881,6.35921716690063 47.798854827881,6.38939189910883 47.8112106323242,6.39944458007812 47.8119850158692,6.39944458007812 47.8119850158692,6.42263841629028 47.8058128356934,6.42263841629028 47.8058128356934,6.41614770889294 47.7928314208985,6.43329668045038 47.7855377197266))0.0006POINT(6.390438590730953 47.79735592433389)
32959POLYGON((1.91167151927948 48.0884857177736,1.91307866573339 48.0794906616212,1.92162382602692 48.0773277282716,1.92162382602692 48.0773277282716,1.91614043712627 48.068359375,1.90460610389715 48.0651359558107,1.90241515636455 48.0555419921874,1.90241515636455 48.0555419921874,1.89733362197876 48.0500946044922,1.86753976345074 48.0624465942383,1.85416293144226 48.0589523315431,1.85416293144226 48.0589523315431,1.83756661415111 48.0707130432129,1.83812439441681 48.0807800292969,1.83812439441681 48.0807800292969,1.84019792079926 48.0872802734376,1.86459875106812 48.085018157959,1.86490428447735 48.0951881408692,1.86490428447735 48.0951881408692,1.88163709640503 48.0980148315431,1.88971352577209 48.1055870056153,1.88971352577209 48.1055870056153,1.89124989509577 48.0957565307618,1.90576088428509 48.0937042236328,1.91167151927948 48.0884857177736))0.0006POINT(1.8822195629279215 48.07880226771042)
73799POLYGON((15.6539421081544 46.1074600219727,15.6492958068848 46.1104354858398,15.6438751220704 46.118953704834,15.6399307250978 46.1389350891113,15.6366338729859 46.1446685791016,15.6313800811769 46.1470603942872,15.620237350464 46.1445693969726,15.6176223754884 46.1458320617676,15.6142253875732 46.1493644714356,15.6136407852174 46.1566925048829,15.615966796875 46.1649856567383,15.6163988113404 46.1716690063477,15.6163988113404 46.1716690063477,15.6267957687378 46.1744346618652,15.6320066452028 46.1774101257325,15.641363143921 46.1783981323243,15.6522827148438 46.1853027343751,15.6522827148438 46.1853027343751,15.6626033782958 46.1695671081544,15.6736984252931 46.1654663085938,15.6788311004638 46.1604728698732,15.6828441619873 46.1580390930176,15.6857748031616 46.1537971496583,15.6907320022584 46.1498413085938,15.6925249099731 46.1454544067383,15.6922807693482 46.1346282958986,15.6933317184449 46.1307525634766,15.7021684646607 46.1276016235352,15.7057065963745 46.1229782104493,15.7146024703979 46.1168823242189,15.7193241119386 46.1104278564453,15.7245779037477 46.1059379577636,15.7245779037477 46.1059379577636,15.7236700057983 46.1027793884278,15.7212581634522 46.1011123657227,15.7110843658448 46.0998077392578,15.6922483444215 46.0947647094728,15.6857414245606 46.0917396545411,15.6857414245606 46.0917396545411,15.6802883148194 46.0911979675294,15.677146911621 46.0924873352051,15.6759490966797 46.094165802002,15.6750936508179 46.1005439758302,15.669005393982 46.1071166992188,15.6626577377319 46.1083908081055,15.6539421081544 46.1074600219727))0.0006POINT(15.668394279480031 46.1334838867188)
68923POLYGON((12.4496297836304 51.0771217346191,12.4507446289062 51.0773048400879,12.449806213379 51.0787200927734,12.4526348114014 51.0812454223633,12.4530973434448 51.0834617614747,12.4583826065063 51.0845489501954,12.4583826065063 51.0845489501954,12.4610624313354 51.084930419922,12.4596967697145 51.0884552001953,12.4611930847169 51.0907135009766,12.4575853347779 51.0922698974609,12.4572553634644 51.0932579040528,12.4587020874023 51.0936546325683,12.4564857482911 51.0954551696778,12.4590940475465 51.0952186584473,12.458872795105 51.0966758728028,12.4573850631715 51.0983467102051,12.454065322876 51.0992851257325,12.4540863037111 51.1007881164551,12.4508991241456 51.1031913757324,12.4484815597534 51.103141784668,12.448302268982 51.1043128967286,12.448302268982 51.1043128967286,12.4461784362794 51.1041336059571,12.4453554153443 51.1052894592285,12.4437541961671 51.1049575805665,12.4428958892823 51.1035842895508,12.435251235962 51.1033172607422,12.4105300903321 51.0980453491212,12.4118509292603 51.1057891845703,12.4108314514161 51.1098403930664,12.4133167266847 51.1104545593262,12.4122924804689 51.1119842529297,12.4174871444702 51.114158630371,12.4147224426269 51.1192245483399,12.4166307449342 51.1193733215333,12.4168148040772 51.1248512268067,12.4105634689331 51.1251525878907,12.4078369140625 51.1228561401368,12.3999462127686 51.1208724975586,12.3998670578003 51.1199913024902,12.3964395523072 51.1183547973632,12.3930416107177 51.1275787353516,12.3918666839601 51.1282119750977,12.3909177780151 51.1270561218262,12.3750734329223 51.1253662109376,12.3750734329223 51.1253662109376,12.3680067062378 51.1203613281251,12.3681135177613 51.114158630371,12.3710155487061 51.1074218750001,12.3686561584473 51.1060028076172,12.3703718185425 51.1024551391602,12.361333847046 51.1013221740723,12.3583059310914 51.1017417907715,12.3569536209106 51.1029319763184,12.3554105758667 51.1008148193359,12.3566646575928 51.1003608703613,12.3546028137208 51.0974349975586,12.3533077239991 51.0979232788087,12.3520517349244 51.0961875915527,12.3520517349244 51.0961875915527,12.3565797805786 51.0943412780762,12.3551235198975 51.0908126831055,12.3549070358277 51.086727142334,12.3534955978394 51.0866050720214,12.353617668152 51.0846061706544,12.3610258102418 51.0797996520996,12.3680219650269 51.078598022461,12.3680219650269 51.078598022461,12.3753204345704 51.0771141052246,12.3847217559816 51.0802917480469,12.3861246109009 51.0811958312989,12.3855829238892 51.0834922790528,12.392957687378 51.0841140747071,12.394305229187 51.0837783813478,12.3980817794801 51.0785179138184,12.4104480743409 51.072853088379,12.4104480743409 51.072853088379,12.4128046035767 51.0758209228515,12.4188318252565 51.0767784118653,12.4209756851196 51.0781440734864,12.4281902313232 51.0781936645508,12.4331464767457 51.0768814086915,12.4357023239136 51.0777549743653,12.4389381408693 51.0770111083984,12.4415931701661 51.0783233642578,12.4496297836304 51.0771217346191))0.0006POINT(12.409633703010075 51.097038180329086)
16375POLYGON((9.32750415802013 44.8738250732422,9.3230876922608 44.8745346069337,9.31536197662365 44.8691444396973,9.31272125244135 44.8654441833496,9.3143110275268 44.8644332885743,9.31235504150391 44.8585243225099,9.29305171966547 44.8431701660157,9.28651332855236 44.8359527587891,9.28604412078869 44.8305778503419,9.28789234161377 44.8257751464845,9.28789234161377 44.8257751464845,9.29642963409418 44.8184700012208,9.31111431121826 44.8114128112794,9.31937789916998 44.8055534362793,9.32257556915283 44.8009834289551,9.32257556915283 44.8009834289551,9.32633781433111 44.799919128418,9.33090782165533 44.8009414672852,9.35523223876964 44.8128128051759,9.36414241790783 44.823356628418,9.36414241790783 44.823356628418,9.35895824432373 44.826385498047,9.34935474395758 44.8407173156739,9.34589672088629 44.861198425293,9.34271430969233 44.8707618713379,9.32750415802013 44.8738250732422))0.0006POINT(9.322259788513218 44.834560394287166)
49481POLYGON((3.10245037078869 49.19730758667,3.11454939842235 49.1907768249512,3.1109533309936 49.1705627441407,3.11360692977911 49.1676025390626,3.12687945365906 49.1622009277344,3.1424081325531 49.1608200073243,3.13947105407721 49.154483795166,3.12676358222967 49.1485099792482,3.12705659866333 49.1450653076172,3.12705659866333 49.1450653076172,3.1416866779328 49.14262008667,3.1416866779328 49.14262008667,3.15166783332836 49.1535530090332,3.15953207016003 49.1568412780762,3.15953207016003 49.1568412780762,3.15996694564819 49.1600227355957,3.18146252632147 49.1718864440919,3.18146252632147 49.1718864440919,3.18346214294434 49.1751098632814,3.17431521415716 49.1912269592286,3.17431521415716 49.1912269592286,3.16754269599915 49.1880989074708,3.16363477706915 49.1928329467775,3.16363477706915 49.1928329467775,3.14135789871227 49.1878890991212,3.13556361198431 49.1960067749023,3.13556361198431 49.1960067749023,3.13611555099493 49.2024230957031,3.13025784492504 49.1972885131836,3.1195018291474 49.2029266357422,3.10973191261297 49.2024230957031,3.10973191261297 49.2024230957031,3.10245037078869 49.19730758667))0.0006POINT(3.142278805375154 49.175543189048824)
64816POLYGON((11.201364517212 49.0465507507324,11.2019271850587 49.0475921630859,11.204460144043 49.0467758178712,11.2053775787355 49.0477409362794,11.2094421386719 49.0459175109864,11.2102909088135 49.0477905273438,11.2125396728516 49.0472106933594,11.2135219573974 49.0488319396973,11.2159519195557 49.0484733581543,11.216591835022 49.0510330200195,11.2221422195435 49.049747467041,11.2227678298951 49.0485725402833,11.2254295349122 49.0490341186525,11.2250728607178 49.0516967773439,11.2312145233155 49.049716949463,11.246434211731 49.0472145080568,11.2514133453369 49.0488624572754,11.2531156539918 49.0527381896974,11.2553882598876 49.0527839660646,11.2553882598876 49.0527839660646,11.2578229904175 49.0533599853516,11.2588481903077 49.0526275634766,11.2615747451783 49.0554237365724,11.2659215927125 49.0577049255372,11.265103340149 49.0587539672853,11.267134666443 49.0599632263184,11.2656412124635 49.0607299804688,11.2618284225464 49.060214996338,11.2613582611085 49.0625495910645,11.2658557891847 49.0630111694336,11.2702856063843 49.0618476867676,11.2735528945923 49.0641288757325,11.2779035568238 49.0621223449708,11.2778644561769 49.0641479492187,11.2810993194581 49.0671005249024,11.281421661377 49.0691452026367,11.2834424972535 49.0712814331055,11.2855997085572 49.0701065063477,11.2895002365113 49.0716972351074,11.2917261123658 49.0763854980469,11.2940149307252 49.0756797790527,11.2941884994508 49.0828819274903,11.2913942337036 49.0828399658203,11.291205406189 49.0838737487794,11.2889242172241 49.0841979980469,11.2884435653687 49.0832633972169,11.2814054489136 49.083351135254,11.2749643325807 49.0881271362306,11.2688264846801 49.0957145690917,11.271508216858 49.0980987548828,11.2714424133302 49.0991706848145,11.2772445678712 49.09965133667,11.2815074920655 49.102336883545,11.2873115539551 49.1028633117676,11.288372039795 49.1015357971192,11.2909488677979 49.1024589538575,11.2885169982911 49.105381011963,11.2865476608276 49.1055946350099,11.2916221618653 49.1092720031738,11.2882051467896 49.1106376647949,11.2856073379517 49.1151618957519,11.2866897583008 49.1164665222169,11.2869024276734 49.1198310852051,11.2823381423951 49.1282386779786,11.2841358184815 49.1291885375976,11.2847261428834 49.1309204101562,11.2847261428834 49.1309204101562,11.2785186767579 49.1335983276367,11.277847290039 49.1319389343263,11.2749605178833 49.1314010620118,11.2744693756103 49.1324119567872,11.2697629928589 49.1321487426758,11.2694911956788 49.129695892334,11.2649145126343 49.1289253234863,11.2617435455322 49.1303863525391,11.2580375671387 49.1291770935059,11.2500524520874 49.1287002563477,11.2404365539551 49.1326675415039,11.2350864410401 49.1333160400391,11.2362279891969 49.1355018615723,11.2413282394409 49.1354141235352,11.240532875061 49.1389846801758,11.226342201233 49.1370353698731,11.2261400222778 49.1409568786621,11.2239494323732 49.1420516967774,11.2302732467651 49.1431884765626,11.2298860549928 49.145664215088,11.2279109954835 49.1456336975099,11.2265529632568 49.1482963562013,11.2268371582032 49.1490020751954,11.2307033538818 49.1489219665527,11.2309103012084 49.1526374816895,11.2350988388061 49.1539421081543,11.2341957092286 49.1567382812501,11.2281770706178 49.1568832397461,11.2256736755372 49.1545600891114,11.2208814620973 49.1560211181642,11.218225479126 49.1526641845703,11.2108621597291 49.1555213928223,11.2090196609498 49.155143737793,11.2091569900513 49.1560974121094,11.2039375305175 49.1565093994141,11.2014713287354 49.153835296631,11.202615737915 49.1533241271973,11.2022228240968 49.1508522033691,11.1958799362184 49.1512794494629,11.1944189071656 49.1488685607911,11.1957836151122 49.1493797302247,11.1976261138916 49.147804260254,11.1982841491699 49.1449203491212,11.1939764022827 49.1438407897949,11.1940832138063 49.139820098877,11.192626953125 49.1395874023438,11.1950540542604 49.1377639770507,11.1903924942017 49.1345710754396,11.1913528442383 49.1320457458497,11.1901826858522 49.1307220458984,11.1888914108276 49.1315040588379,11.186840057373 49.1356277465821,11.1838464736938 49.1372032165528,11.1791639328003 49.1376342773438,11.1759757995605 49.1419906616211,11.1704425811768 49.1414299011232,11.1683549880981 49.1431503295898,11.1640949249268 49.1414489746094,11.1597051620484 49.1412506103516,11.1597051620484 49.1412506103516,11.1607484817505 49.1383399963379,11.1657752990724 49.1370239257812,11.1653022766114 49.1296234130859,11.1685333251954 49.128345489502,11.1657638549805 49.1272811889648,11.1672763824462 49.1256523132324,11.1699466705322 49.1264381408691,11.1706247329712 49.1249580383301,11.1703519821166 49.1230621337892,11.1673412322999 49.1214447021485,11.1681661605834 49.1205940246583,11.1673288345337 49.1195297241212,11.1684350967407 49.1192321777345,11.1675701141357 49.1171607971192,11.169882774353 49.115951538086,11.1681070327759 49.1143951416016,11.1675462722778 49.1114654541016,11.1716251373292 49.1101570129396,11.1720333099366 49.1089591979981,11.1673650741578 49.1063232421875,11.1686410903931 49.1044807434081,11.167462348938 49.1024017333985,11.1697645187379 49.0995178222657,11.1700668334962 49.0948715209961,11.1676731109619 49.0946960449219,11.1678485870361 49.0936813354493,11.1700353622438 49.0933532714844,11.1698284149171 49.0922393798828,11.166117668152 49.0903282165528,11.1628551483154 49.0901412963867,11.1627969741822 49.0938644409181,11.1614074707032 49.0934600830079,11.1610221862792 49.0903396606445,11.163348197937 49.0871696472168,11.1623783111572 49.0863037109375,11.1623783111572 49.0863037109375,11.1665725708008 49.0845947265625,11.1652803421021 49.0832633972169,11.1706447601318 49.0770797729493,11.1709232330322 49.0754852294922,11.1685857772827 49.0727577209473,11.1724300384522 49.0676612854005,11.1724300384522 49.0676612854005,11.1734943389893 49.0663871765137,11.1772832870485 49.0671882629395,11.1758546829224 49.0648612976074,11.1780767440795 49.0642166137696,11.1793889999391 49.0621299743653,11.1807804107667 49.0617828369141,11.1794891357422 49.0604667663574,11.1818675994872 49.0593376159668,11.181233406067 49.0580291748048,11.1874237060548 49.0563621520997,11.1872053146362 49.055446624756,11.1896152496338 49.0545768737793,11.1894664764405 49.0536956787109,11.1924219131469 49.052761077881,11.1921348571777 49.0508460998536,11.1987476348876 49.0486030578613,11.1982593536378 49.0478630065918,11.201364517212 49.0465507507324))0.0006POINT(11.219139757003415 49.10152951408836)
22776POLYGON((0.642262995243073 44.3005828857422,0.64275819063198 44.3100852966309,0.621941149234829 44.3163108825684,0.621941149234829 44.3163108825684,0.588645577430782 44.3064270019532,0.58182817697525 44.315128326416,0.572915554046688 44.314121246338,0.572915554046688 44.314121246338,0.556314468383732 44.3043899536133,0.556760013103428 44.2949256896973,0.556760013103428 44.2949256896973,0.575332641601676 44.2980804443359,0.604458510875759 44.288948059082,0.618721663951987 44.2884483337402,0.630609691143093 44.2745780944825,0.630609691143093 44.2745780944825,0.645040392875671 44.2814178466798,0.644873142242432 44.2902755737305,0.644873142242432 44.2902755737305,0.6417116522789 44.2921333312989,0.642262995243073 44.3005828857422))0.0006POINT(0.6075636684894875 44.298303222656294)
61459POLYGON((6.59497976303106 46.5740089416503,6.57929182052618 46.5768661499024,6.57929182052618 46.5768661499024,6.57848596572887 46.5785942077637,6.57931709289562 46.5820350646973,6.57931709289562 46.5820350646973,6.57993698120129 46.5844268798828,6.58508110046392 46.584976196289,6.58806180953974 46.5917549133301,6.58806180953974 46.5917549133301,6.59827709197998 46.5981292724609,6.59827709197998 46.5981292724609,6.60340690612799 46.594093322754,6.60929298400873 46.5918159484864,6.61560297012335 46.5911140441896,6.61560297012335 46.5911140441896,6.61726713180542 46.587589263916,6.61948490142828 46.5855941772461,6.62042903900158 46.581859588623,6.62042903900158 46.581859588623,6.60445785522467 46.580837249756,6.59497976303106 46.5740089416503))0.0006POINT(6.597826344626339 46.58597401210242)
60923POLYGON((8.84067440032959 46.5148849487305,8.83812999725347 46.5122184753418,8.83569145202637 46.503200531006,8.83420658111572 46.5016441345215,8.82894229888922 46.5000076293946,8.82723045349132 46.4982566833497,8.82378005981445 46.4932632446289,8.8229455947876 46.4887046813966,8.81751537322998 46.4833335876465,8.8164463043214 46.4799919128418,8.81195735931408 46.4836425781251,8.81195735931408 46.4836425781251,8.81396293640137 46.4956245422363,8.81696796417236 46.4988365173341,8.81729412078857 46.5053710937501,8.82079505920416 46.512722015381,8.82676792144775 46.5197525024414,8.82676792144775 46.5197525024414,8.83265113830578 46.5190277099609,8.84067440032959 46.5148849487305))0.0006POINT(8.82445706819237 46.500730414139646)