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.
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.
Spaltenname | Datentyp | Mögliche Werte | Beschreibung |
---|---|---|---|
id_ort | int(10) unsigned | beliebig | Fremdschlüssel, der auf die Tabelle `orte` verweist. |
geodaten | geometryDieser 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:
| beliebig | Die simplifizierten Geodaten. |
epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
mittelpunkt | pointDieser 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:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
id_ort | geodaten | epsilon | mittelpunkt |
---|---|---|---|
59238 | POLYGON((8.3083639144898 47.2554092407226,8.31675910949707 47.2452430725098,8.31675910949707 47.2452430725098,8.32447242736822 47.2480773925782,8.32709407806402 47.2502021789551,8.34558010101324 47.2490921020509,8.35153198242193 47.2508964538575,8.35153198242193 47.2508964538575,8.34407711029058 47.2554817199708,8.34032726287847 47.2590141296387,8.33209419250494 47.2573776245117,8.32446289062511 47.2626724243164,8.32446289062511 47.2626724243164,8.31908893585216 47.2614364624024,8.31614303588873 47.2588844299318,8.31188583374023 47.2576828002931,8.3083639144898 47.2554092407226)) | 0.0006 | POINT(8.328414678573665 47.254392623901424) |
17504 | POLYGON((8.12010860443121 44.5539131164552,8.12365245819097 44.5542831420898,8.12492275238043 44.5579490661621,8.13906955719 44.5685844421388,8.14362812042231 44.5822296142579,8.141845703125 44.5839195251465,8.141845703125 44.5839195251465,8.12764453887939 44.5914993286133,8.12764453887939 44.5914993286133,8.1237144470216 44.5913238525391,8.1237144470216 44.5913238525391,8.12510871887207 44.5889396667481,8.11570262908947 44.5788307189942,8.11257171630871 44.5770263671876,8.11257171630871 44.5770263671876,8.09706878662115 44.5637130737306,8.09687423706049 44.5606651306152,8.09687423706049 44.5606651306152,8.12010860443121 44.5539131164552)) | 0.0006 | POINT(8.12192016177711 44.57540618048779) |
23055 | POLYGON((-1.36334455013264 43.3007965087891,-1.35503137111664 43.303581237793,-1.32900321483612 43.2991600036622,-1.32900321483612 43.2991600036622,-1.32189476490015 43.303550720215,-1.32864153385157 43.3163452148437,-1.34695649147034 43.3173828125001,-1.35101735591888 43.3236083984375,-1.36306691169739 43.328239440918,-1.36396908760071 43.3350944519044,-1.36396908760071 43.3350944519044,-1.36824321746815 43.3314018249512,-1.36824321746815 43.3314018249512,-1.36334455013264 43.3007965087891)) | 0.0006 | POINT(-1.3501833860690438 43.31729360727169) |
38783 | POLYGON((1.99495661258709 43.149253845215,1.97848987579357 43.1286354064941,1.97848987579357 43.1286354064941,1.97114384174353 43.1377105712891,1.95757257938396 43.1410369873048,1.95757257938396 43.1410369873048,1.96671509742737 43.1477165222169,1.96214532852167 43.1565971374513,1.96271741390234 43.1726493835449,1.96271741390234 43.1726493835449,1.97459483146667 43.169605255127,1.98097169399273 43.1738777160645,1.98097169399273 43.1738777160645,1.99191546440136 43.1749954223634,1.99191546440136 43.1749954223634,1.997798204422 43.1702995300294,1.99524879455566 43.164249420166,1.99951946735382 43.1589012145996,1.99951946735382 43.1589012145996,1.9940984249115 43.1547927856445,1.99495661258709 43.149253845215)) | 0.0006 | POINT(1.9799537062645522 43.157520866394094) |
29094 | POLYGON((4.28129339218145 46.8233833312989,4.29227733612061 46.8009719848633,4.29227733612061 46.8009719848633,4.2667407989502 46.7884407043457,4.2667407989502 46.7884407043457,4.25754499435436 46.7995185852051,4.23809480667114 46.8005332946778,4.23441028594976 46.8068656921388,4.22678518295294 46.8106918334962,4.23265266418463 46.8160972595215,4.23265266418463 46.8160972595215,4.26319313049328 46.8258247375488,4.28129339218145 46.8233833312989)) | 0.0006 | POINT(4.257055282592816 46.80648644765222) |
62687 | POLYGON((8.44731044769298 52.5314140319824,8.44075679779058 52.5262298583984,8.40163898468029 52.5240325927736,8.40549564361578 52.5216712951661,8.40570926666265 52.519603729248,8.39910411834722 52.5185775756836,8.39796352386475 52.5202484130861,8.38541793823254 52.5179519653321,8.38598060607904 52.5201034545898,8.38090038299561 52.519302368164,8.37794685363781 52.5200233459473,8.37675571441662 52.5168266296387,8.31181812286388 52.5064201354982,8.31181812286388 52.5064201354982,8.31184101104748 52.5049934387208,8.30831527709967 52.5009880065919,8.30832386016851 52.4991111755372,8.30832386016851 52.4991111755372,8.30818271636963 52.4950714111329,8.3110523223877 52.4960746765138,8.31205749511724 52.4944763183595,8.30618667602545 52.4902343750001,8.30716609954834 52.4829711914063,8.30585002899181 52.4771842956544,8.30585002899181 52.4771842956544,8.31633472442633 52.4774780273439,8.31633472442633 52.4774780273439,8.31431961059565 52.4819564819336,8.32519245147716 52.4838180541993,8.32616519927984 52.4816932678223,8.32991981506348 52.482177734375,8.3318195343017 52.4778938293458,8.3450717926026 52.4795608520508,8.34780979156488 52.4818229675292,8.34975719451899 52.4802398681641,8.35676956176763 52.481731414795,8.35818672180176 52.4841461181641,8.36026287078852 52.4854164123536,8.36007976531982 52.4892654418946,8.36479663848883 52.4892387390138,8.36392116546642 52.4912223815918,8.37197017669689 52.4921188354493,8.37224197387707 52.4935379028321,8.37547969818115 52.4917678833008,8.37612438201904 52.4931030273438,8.38133716583252 52.4913711547852,8.38859176635748 52.4973220825196,8.39098644256592 52.5030441284181,8.40193462371832 52.5056648254394,8.40281295776362 52.5081062316896,8.40442657470697 52.508373260498,8.40655517578125 52.5080757141114,8.4065341949464 52.5060997009277,8.4074907302857 52.5050582885742,8.4074907302857 52.5050582885742,8.40865230560303 52.5035667419433,8.41499233245855 52.503246307373,8.41499233245855 52.503246307373,8.41871356964111 52.5072326660157,8.41385173797602 52.5081214904786,8.41334533691418 52.5091819763184,8.42341136932373 52.5115432739258,8.42341136932373 52.5115432739258,8.44691371917736 52.5173225402832,8.44691371917736 52.5173225402832,8.45769786834728 52.5287094116211,8.46086692810059 52.5297088623047,8.46086692810059 52.5297088623047,8.45421886444097 52.53226852417,8.44972038269049 52.53076171875,8.44731044769298 52.5314140319824)) | 0.0006 | POINT(8.375586468832873 52.502336447579545) |
1403086 | POLYGON((2.30200695991527 41.898078918457,2.28880906105047 41.9038887023926,2.28389501571661 41.8996658325196,2.27768898010265 41.8992385864258,2.27418804168707 41.9023628234863,2.27077603340155 41.9022064208986,2.26638007164001 41.8952331542969,2.25999808311462 41.9017028808594,2.26078701019298 41.9029426574707,2.26210188865667 41.9013442993164,2.26611995697027 41.9034652709962,2.26487302780151 41.9098510742189,2.26720905303961 41.9104003906251,2.26343011856085 41.918083190918,2.26555895805365 41.9197692871095,2.27054810523987 41.9182853698731,2.27071499824524 41.9198722839357,2.27461004257214 41.9217987060547,2.27385997772228 41.9233551025392,2.27683901786804 41.9252166748047,2.28105688095098 41.9205474853515,2.28338003158569 41.9203453063965,2.28361701965326 41.9218978881836,2.30196404457092 41.9087715148927,2.30078601837164 41.9064636230469,2.3042631149292 41.8988494873047,2.30200695991527 41.898078918457)) | 0.0006 | POINT(2.276748519677425 41.90975526662977) |
64956 | POLYGON((11.8616828918458 49.1553688049318,11.8628511428834 49.1593475341797,11.8582992553711 49.1608695983887,11.8614501953126 49.1654663085938,11.8613233566285 49.1703338623048,11.875415802002 49.1694412231445,11.8816471099854 49.1699752807618,11.8860378265382 49.1719093322754,11.8851633071901 49.1725082397461,11.8856115341187 49.173770904541,11.8908004760743 49.1752891540527,11.8981180191041 49.1754302978516,11.8987102508545 49.1736145019532,11.9065399169922 49.1734199523926,11.9102048873901 49.1791114807129,11.9158372879028 49.1825866699218,11.9168128967286 49.1844902038575,11.918758392334 49.1848258972168,11.9224348068237 49.1875686645508,11.9276094436645 49.1889495849609,11.9324159622192 49.1876487731933,11.9365119934083 49.1878395080566,11.9359035491943 49.1950721740724,11.9359035491943 49.1950721740724,11.9488668441772 49.1943016052247,11.9502620697022 49.1932411193848,11.9499015808105 49.1894569396973,11.9526348114013 49.1885948181152,11.9548482894898 49.1855430603027,11.9544897079468 49.1845855712891,11.9613742828369 49.1853218078614,11.9624738693237 49.1840019226075,11.9637565612794 49.1842117309571,11.9638786315918 49.1832542419433,11.9682693481446 49.1859169006349,11.9715003967285 49.1838684082032,11.9744806289673 49.1861763000488,11.9776277542114 49.1858749389648,11.9796390533447 49.1852188110353,11.9782600402833 49.1832008361818,11.9831819534302 49.1812553405762,11.9826307296753 49.180274963379,11.9852256774902 49.1794319152833,11.9865331649781 49.1808891296387,11.9890422821046 49.1808013916016,11.9869318008423 49.1826820373535,11.9903440475464 49.1852035522462,11.9988555908203 49.1856918334961,12.0022411346436 49.1873207092285,12.0047321319581 49.1866569519044,12.0013628005982 49.184669494629,12.0032968521118 49.1833267211915,12.0024271011354 49.1809387207031,12.0047473907472 49.1792144775391,12.0075407028198 49.1790351867677,12.0078887939454 49.1774291992189,12.0115699768066 49.1775398254394,12.011905670166 49.1768798828125,12.0104885101318 49.1758728027345,12.0139360427857 49.1742172241211,12.0132703781128 49.1735763549806,12.0115604400635 49.1741828918458,12.0106744766235 49.1708602905274,12.0094881057739 49.1697845458986,12.0048084259033 49.1701812744142,12.003517150879 49.1683807373047,12.0049495697021 49.1659164428712,12.0026283264161 49.1653900146486,12.002986907959 49.1632423400879,11.9986972808837 49.1629676818848,11.9994812011719 49.1621475219728,11.9994812011719 49.1621475219728,11.9949922561646 49.1593742370607,11.9887990951539 49.1600494384767,11.9877862930297 49.153907775879,11.9859857559205 49.1528968811036,11.9841508865357 49.1538963317871,11.9833545684815 49.1520881652833,11.9801387786865 49.1514282226563,11.9795484542847 49.1469459533692,11.9761257171631 49.1457862854004,11.979573249817 49.1446075439454,11.9842195510865 49.1409568786621,11.9833850860597 49.1401405334474,11.9848241806031 49.1395378112794,11.9814844131471 49.1362953186036,11.9731760025024 49.1340751647949,11.972869873047 49.133487701416,11.9760465621948 49.1324462890625,11.9725799560547 49.1311607360841,11.9760570526124 49.1291999816895,11.9734668731691 49.1283226013183,11.9746446609498 49.1269416809083,11.9714565277101 49.1280250549317,11.9644956588746 49.1272430419923,11.9644956588746 49.1272430419923,11.9445323944092 49.1266479492189,11.9416637420655 49.1274337768556,11.948395729065 49.1347961425782,11.9536457061769 49.1516036987305,11.9571275711061 49.156536102295,11.9543523788453 49.156364440918,11.9523344039918 49.1522331237793,11.947283744812 49.1530265808106,11.942626953125 49.1523399353028,11.940221786499 49.1544570922852,11.9350910186768 49.1566085815431,11.9339084625244 49.1557006835937,11.9341526031495 49.1533126831055,11.9326906204224 49.1535110473633,11.9313774108888 49.1517753601075,11.9350585937501 49.1508674621582,11.9327344894409 49.1480407714845,11.9380760192871 49.1478118896485,11.9386253356935 49.1450958251954,11.9362497329713 49.1435775756837,11.9318084716797 49.1440773010254,11.9306564331055 49.1399536132813,11.9264631271362 49.1395759582519,11.924958229065 49.1415557861329,11.9206857681274 49.1421928405763,11.9165391921998 49.1443443298339,11.9107084274293 49.1442718505859,11.9076480865479 49.1451301574707,11.907853126526 49.1460266113281,11.9031705856323 49.1458320617677,11.9025526046754 49.1490898132325,11.8986291885377 49.1485710144043,11.8971157073974 49.1474838256837,11.9002799987794 49.1464080810547,11.9017324447631 49.1421165466309,11.8996629714966 49.1383819580078,11.8966903686524 49.1375007629395,11.8966903686524 49.1375007629395,11.8926467895508 49.1413688659669,11.8921546936035 49.1433258056641,11.8891878128052 49.1440925598145,11.8863306045532 49.146770477295,11.8807744979858 49.147201538086,11.8795013427734 49.1491851806642,11.8703260421754 49.1535797119142,11.8688650131227 49.1513137817382,11.8632316589356 49.152416229248,11.8616828918458 49.1553688049318)) | 0.0006 | POINT(11.9485692511072 49.161593377173375) |
15411 | POLYGON((10.2567939758301 45.9422111511231,10.2479496002197 45.9332733154297,10.2479496002197 45.9332733154297,10.251566886902 45.9340972900391,10.2555770874023 45.9306144714357,10.2598209381104 45.929515838623,10.2598209381104 45.929515838623,10.2645978927612 45.9342346191406,10.2836055755616 45.939079284668,10.2836055755616 45.939079284668,10.2866945266725 45.9477119445801,10.2866945266725 45.9477119445801,10.28031539917 45.9535636901855,10.28031539917 45.9535636901855,10.2793846130372 45.9467849731445,10.2737722396852 45.945095062256,10.2630910873414 45.9445533752443,10.2630910873414 45.9445533752443,10.2567939758301 45.9422111511231)) | 0.0006 | POINT(10.268035941653844 45.94046847025556) |
51901 | POLYGON((-0.628187596797886 46.1435737609863,-0.61585396528244 46.1384506225587,-0.602328419685364 46.1425857543946,-0.583080828189793 46.1395645141603,-0.583080828189793 46.1395645141603,-0.582472801208496 46.1223106384278,-0.567079603671971 46.1138458251954,-0.568746328353882 46.1105728149415,-0.568746328353882 46.1105728149415,-0.574772238731327 46.1051940917969,-0.597042560577279 46.1116180419922,-0.625873863697052 46.1062202453614,-0.632350206375008 46.1012725830078,-0.646223068237305 46.098258972168,-0.646223068237305 46.098258972168,-0.659590482711735 46.0999259948731,-0.659590482711735 46.0999259948731,-0.661232233047429 46.1121063232423,-0.661232233047429 46.1121063232423,-0.646795690059605 46.1408157348633,-0.628187596797886 46.1435737609863)) | 0.0006 | POINT(-0.6155251413583358 46.117337226867726) |