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 |
---|---|---|---|
62132 | POLYGON((8.14153289794928 53.1295928955079,8.14554500579845 53.1320266723633,8.14335536956787 53.1338386535645,8.14466571807867 53.1358947753907,8.14444065094006 53.1392822265626,8.14736366271967 53.1422500610351,8.14700031280523 53.1496353149415,8.15381622314447 53.1503067016602,8.15673446655285 53.1536750793458,8.15519046783447 53.155143737793,8.15513992309576 53.1628532409669,8.15771579742432 53.164520263672,8.15855121612549 53.1665420532227,8.16262912750244 53.1649818420411,8.16451168060303 53.1652984619142,8.16519832611095 53.1661567687989,8.16415596008295 53.1675186157227,8.16832447052008 53.1695709228516,8.16756343841553 53.1704864501953,8.16540908813477 53.1700401306152,8.16413211822504 53.1720962524415,8.16305828094482 53.1718635559083,8.15967559814464 53.1744041442871,8.16144752502453 53.1768493652344,8.16144752502453 53.1768493652344,8.17059898376465 53.1835517883301,8.1777143478393 53.1820411682129,8.18903732299805 53.1905212402344,8.19209194183361 53.1893730163575,8.1988401412965 53.1986541748048,8.20049953460705 53.2038841247559,8.20049953460705 53.2038841247559,8.20357894897467 53.2051582336426,8.20551013946539 53.2022895812988,8.20939636230474 53.2030258178712,8.21739006042486 53.2016563415527,8.22325038909912 53.2018623352051,8.22867965698237 53.1987991333008,8.22840976715082 53.1979408264161,8.24566459655773 53.2005157470704,8.24580860137951 53.1994476318361,8.24778842926031 53.1993942260743,8.2473001480102 53.1972084045411,8.25444793701178 53.1932945251465,8.27329063415533 53.1911010742188,8.27543830871588 53.1916007995605,8.27743816375744 53.1888771057128,8.29009628295893 53.1894912719728,8.29396247863775 53.1912078857423,8.29600620269781 53.1907768249513,8.29681587219244 53.1919441223145,8.30044841766363 53.191764831543,8.30037975311279 53.1904411315918,8.3039054870606 53.1890830993652,8.3039054870606 53.1890830993652,8.30233669281017 53.1851081848145,8.29244518280035 53.1802368164062,8.29481124877941 53.1742248535157,8.29697990417492 53.1712532043458,8.2990293502807 53.1706771850586,8.29915046691906 53.1691436767578,8.29637432098389 53.1702003479004,8.29631900787348 53.1689109802246,8.30109596252436 53.1682434082031,8.3026123046875 53.1660308837892,8.29673576354986 53.1668510437012,8.29692840576172 53.1656875610353,8.30004692077631 53.1652641296387,8.30175018310553 53.1629219055177,8.30184650421148 53.1609725952148,8.30420875549316 53.1604042053224,8.30658817291271 53.155876159668,8.30796432495129 53.1555786132814,8.30930137634283 53.15336227417,8.3122644424439 53.1530456542969,8.3122644424439 53.1530456542969,8.30763721466076 53.1507263183594,8.30540561676031 53.1486701965332,8.30553531646729 53.1469650268556,8.2998628616333 53.1458282470704,8.29915809631359 53.1417541503907,8.30067825317388 53.1398315429688,8.2969446182251 53.138526916504,8.28827762603771 53.1304397583008,8.28567790985102 53.1214447021486,8.28605651855469 53.1183738708496,8.28416061401379 53.1172599792481,8.28415489196783 53.1159629821778,8.27933025360119 53.1082344055176,8.27803611755377 53.1033630371094,8.27803611755377 53.1033630371094,8.27983474731445 53.0981903076171,8.27543449401867 53.095672607422,8.27211380004894 53.0954399108887,8.2382230758667 53.0859146118165,8.23307037353521 53.0858917236329,8.22646427154552 53.082763671875,8.22646427154552 53.082763671875,8.22300529479975 53.0823478698731,8.21898555755627 53.0858726501466,8.21561336517334 53.0852241516114,8.21417140960699 53.0871047973634,8.20767211914068 53.0867233276368,8.20614719390869 53.0886955261232,8.20224094390881 53.0908584594727,8.19542884826654 53.0918846130372,8.19443988800055 53.0942420959474,8.19629478454584 53.0944747924805,8.19491863250732 53.0960273742676,8.20252227783209 53.1011581420899,8.20265769958496 53.1094779968263,8.20469760894781 53.1128005981446,8.20056247711176 53.1141700744629,8.19306087493908 53.1125335693359,8.1856107711792 53.1122169494629,8.17150211334234 53.1091270446778,8.12809085845942 53.107837677002,8.12809085845942 53.107837677002,8.13010406494152 53.1280136108399,8.13801765441889 53.1276550292969,8.14153289794928 53.1295928955079)) | 0.0006 | POINT(8.2319353739421 53.15058546066286) |
43348 | POLYGON((1.7218582630158 42.9319229125977,1.72571146488195 42.9337043762207,1.72466075420385 42.9369544982911,1.71514284610754 42.9483032226563,1.69963669776922 42.9545745849609,1.69963669776922 42.9545745849609,1.68677914142603 42.9529685974121,1.68677914142603 42.9529685974121,1.67923963069921 42.9490623474122,1.66063034534454 42.9521865844728,1.66063034534454 42.9521865844728,1.65943598747259 42.9349937438965,1.66825640201569 42.9325561523439,1.67000722885138 42.9293327331544,1.67000722885138 42.9293327331544,1.68025243282312 42.9287643432618,1.68025243282312 42.9287643432618,1.7218582630158 42.9319229125977)) | 0.0006 | POINT(1.6875833553426594 42.941361819996615) |
54983 | POLYGON((5.18249368667608 44.257682800293,5.18464326858532 44.267951965332,5.18115520477295 44.2883796691896,5.18115520477295 44.2883796691896,5.17010641098022 44.2987365722657,5.17010641098022 44.2987365722657,5.16554355621349 44.2895812988282,5.15025329589855 44.2820816040039,5.14745807647711 44.2691688537597,5.14745807647711 44.2691688537597,5.16053152084362 44.2656173706056,5.16154766082769 44.2455902099611,5.16154766082769 44.2455902099611,5.18249368667608 44.257682800293)) | 0.0006 | POINT(5.166461541102539 44.274358896108836) |
1401070 | POLYGON((-3.82166790962214 41.4282379150392,-3.82970404624939 41.4258308410646,-3.83294701576233 41.4212303161622,-3.84491991996765 41.4132728576661,-3.85280990600586 41.4136810302735,-3.86811709403986 41.4076232910157,-3.87384200096125 41.4001197814943,-3.88966393470764 41.3971557617189,-3.89347910881042 41.4022483825684,-3.89706397056574 41.4002571105958,-3.90854907035828 41.4080924987794,-3.90592288970936 41.4102134704591,-3.89332604408264 41.4130668640138,-3.89077091217041 41.4159622192383,-3.88611102104187 41.4173507690431,-3.89379596710199 41.4429588317872,-3.88542199134821 41.4504280090333,-3.88055396080011 41.4524917602538,-3.87358903884888 41.4500503540039,-3.87516593933105 41.4452362060546,-3.86742210388172 41.4417762756348,-3.84649705886829 41.437957763672,-3.84189295768738 41.4337310791016,-3.82166790962214 41.4282379150392)) | 0.0006 | POINT(-3.871879733127064 41.422998842985805) |
14695 | POLYGON((12.6070041656494 42.4045104980469,12.615309715271 42.4145164489746,12.615309715271 42.4145164489746,12.6202440261841 42.4137535095215,12.6281948089601 42.4062652587891,12.6647872924805 42.4001998901368,12.6647872924805 42.4001998901368,12.6634607315064 42.3930244445801,12.6634607315064 42.3930244445801,12.6570310592652 42.3751983642579,12.6543769836426 42.3737373352051,12.6543769836426 42.3737373352051,12.6484003067017 42.3708686828614,12.6447401046752 42.3716011047363,12.6395912170411 42.374210357666,12.6397218704224 42.3765144348145,12.621808052063 42.4070930480958,12.6150045394898 42.4089775085449,12.6144151687623 42.4075546264648,12.6122064590455 42.4062309265138,12.6070041656494 42.4045104980469)) | 0.0006 | POINT(12.63721156120304 42.3942867279053) |
71621 | POLYGON((15.3916120529175 48.2794075012207,15.404375076294 48.2887153625488,15.4077491760253 48.2927970886231,15.4148721694947 48.3282699584962,15.4148721694947 48.3282699584962,15.4124069213867 48.3318328857422,15.4124069213867 48.3318328857422,15.3755521774292 48.3307151794434,15.3755521774292 48.3307151794434,15.3803367614746 48.3152465820313,15.3808612823486 48.3094100952148,15.3791179656983 48.3067321777343,15.3722286224366 48.3019638061523,15.3713274002075 48.2997245788575,15.3745231628419 48.2953300476075,15.3916120529175 48.2794075012207)) | 0.0006 | POINT(15.391186269124368 48.31139755249027) |
35280 | POLYGON((9.09423732757574 42.5642280578613,9.09099864959717 42.5579833984374,9.08013820648205 42.5524368286134,9.08098411560059 42.5425529479981,9.07452297210693 42.5381164550782,9.07452297210693 42.5381164550782,9.06721115112305 42.5342864990236,9.04018974304205 42.5314025878907,9.03482723236084 42.5183448791504,9.03980636596685 42.5051155090332,9.03594970703119 42.4951667785645,9.03594970703119 42.4951667785645,9.03183078765869 42.4969215393066,9.01826858520519 42.493938446045,8.98779392242432 42.4674034118653,8.97066116333008 42.4619216918945,8.96515560150158 42.4561805725099,8.93236827850347 42.4557762145997,8.91903972625738 42.4595108032228,8.91903972625738 42.4595108032228,8.91645240783691 42.4673728942872,8.91645240783691 42.4673728942872,8.94773864746099 42.4735336303711,9.02009296417236 42.5113792419434,9.0060443878175 42.5285453796387,9.0060443878175 42.5285453796387,9.02035045623791 42.5518722534181,9.02035045623791 42.5518722534181,9.03198337554926 42.5612945556641,9.0380363464356 42.5733337402344,9.0380363464356 42.5733337402344,9.04138469696045 42.5750350952149,9.04138469696045 42.5750350952149,9.05241966247564 42.5798034667969,9.07455635070801 42.5790214538575,9.07455635070801 42.5790214538575,9.09344768524164 42.5709114074707,9.09423732757574 42.5642280578613)) | 0.0006 | POINT(9.022508853190685 42.52355039441913) |
20884 | POLYGON((7.78539562225342 48.8952827453613,7.80040550231939 48.890022277832,7.80040550231939 48.890022277832,7.80675792694092 48.9022827148438,7.80675792694092 48.9022827148438,7.79984807968134 48.9035224914551,7.79984807968134 48.9035224914551,7.7696447372436 48.9075317382814,7.7696447372436 48.9075317382814,7.78539562225342 48.8952827453613)) | 0.0006 | POINT(7.793189790513769 48.900222354465114) |
57401 | POLYGON((7.61448812484753 49.6410026550294,7.61435842514032 49.6459274291992,7.61250305175776 49.6513557434082,7.6155738830567 49.6551551818848,7.61508369445801 49.6575317382812,7.61508369445801 49.6575317382812,7.60629224777216 49.6604843139649,7.60270547866821 49.6638145446778,7.59983634948742 49.6633262634278,7.59603977203375 49.6657676696778,7.59932947158813 49.6677856445314,7.59563827514648 49.6684417724609,7.59445047378534 49.6706771850585,7.58520746231079 49.6730155944825,7.58520746231079 49.6730155944825,7.58360481262207 49.6701850891114,7.57389307022106 49.6672592163086,7.57237386703503 49.6653366088867,7.56870365142822 49.6659278869629,7.56870365142822 49.6659278869629,7.56786680221552 49.6644134521484,7.56786680221552 49.6644134521484,7.5689115524292 49.6620864868165,7.57252597808838 49.6603584289551,7.57214117050171 49.6580352783204,7.56849813461309 49.6545944213868,7.57003116607666 49.6531219482423,7.57003116607666 49.6531219482423,7.5728821754455 49.6514053344728,7.57348155975336 49.6484146118164,7.57348155975336 49.6484146118164,7.57492733001709 49.6481246948243,7.57367706298834 49.6459045410156,7.57568407058722 49.6446075439453,7.58018922805792 49.645076751709,7.58507490158092 49.6402206420898,7.58618879318243 49.6387825012207,7.58364248275751 49.6373481750489,7.58364915847778 49.6361083984376,7.58364915847778 49.6361083984376,7.58648824691784 49.637062072754,7.58763742446899 49.6363639831544,7.58868551254278 49.6370201110839,7.58834552764904 49.6377754211425,7.59349775314342 49.6391334533691,7.59350156784063 49.6398086547852,7.60180568695063 49.6402740478516,7.607409477234 49.6419486999513,7.61260938644409 49.6365432739257,7.61260938644409 49.6365432739257,7.61424398422247 49.6379356384278,7.61448812484753 49.6410026550294)) | 0.0006 | POINT(7.588437473072745 49.652167451147946) |
65629 | POLYGON((10.148193359375 49.7618789672852,10.1538419723511 49.7528915405273,10.1503553390503 49.7511711120606,10.1484680175782 49.7529258728028,10.146019935608 49.7516059875489,10.1445932388306 49.7529983520508,10.1329326629639 49.7507209777832,10.1309223175049 49.7520790100098,10.1279449462891 49.7511253356934,10.1214132308959 49.7570343017579,10.1175222396851 49.7590255737305,10.1016101837159 49.7620124816895,10.1016101837159 49.7620124816895,10.1046171188355 49.7661781311035,10.1030950546264 49.768871307373,10.1030950546264 49.768871307373,10.1101922988891 49.768898010254,10.1123609542847 49.7670516967773,10.1148242950439 49.7698135375978,10.1214027404785 49.7688293457032,10.1220731735229 49.766616821289,10.1405153274537 49.7671089172363,10.1439771652223 49.7629432678223,10.1464710235595 49.7638359069825,10.148193359375 49.7618789672852)) | 0.0006 | POINT(10.127002159754449 49.760687510172545) |