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 |
|---|---|---|---|
| 53703 | POLYGON((6.1466846466065 44.5295410156251,6.15062665939331 44.5308990478517,6.15816450119024 44.5278549194337,6.15816450119024 44.5278549194337,6.17190456390381 44.5493621826172,6.17159509658819 44.5629119873047,6.17159509658819 44.5629119873047,6.16330528259277 44.5649795532227,6.16441822052002 44.573585510254,6.16018199920654 44.5744667053223,6.16018199920654 44.5744667053223,6.13229370117193 44.5752601623536,6.13229370117193 44.5752601623536,6.13378047943115 44.5686683654785,6.14214277267462 44.5660591125489,6.1461753845216 44.5599555969239,6.15009212493908 44.5429840087891,6.1466846466065 44.5295410156251)) | 0.0006 | POINT(6.15374121946451 44.55688364365528) |
| 13439 | POLYGON((15.2479438781738 41.2369308471681,15.2418746948243 41.238826751709,15.2109985351562 41.237720489502,15.2067832946778 41.239902496338,15.2067832946778 41.239902496338,15.2051057815552 41.2516746520997,15.2004461288453 41.2550125122071,15.2004022598267 41.2562942504883,15.2058248519897 41.2614974975587,15.2152223587037 41.2658309936524,15.2212867736817 41.266170501709,15.2212867736817 41.266170501709,15.2293024063111 41.267417907715,15.2365341186525 41.273292541504,15.2506170272828 41.2717437744141,15.2567853927613 41.2677574157714,15.2621536254883 41.2611122131348,15.2762460708618 41.2508659362794,15.2806940078735 41.2417755126953,15.2806940078735 41.2417755126953,15.2767086029054 41.2422828674317,15.2536573410034 41.2397689819337,15.2479438781738 41.2369308471681)) | 0.0006 | POINT(15.235788692127612 41.2533512115479) |
| 13178 | POLYGON((16.7618446350098 39.2929000854493,16.7446937561036 39.3049201965332,16.7421989440919 39.3091773986817,16.7322273254395 39.314811706543,16.7071037292481 39.323902130127,16.7071037292481 39.323902130127,16.6923427581788 39.3337097167969,16.6900672912598 39.3374977111818,16.6896953582765 39.3413505554199,16.6741790771484 39.3596992492676,16.6643505096435 39.3631744384765,16.6536655426026 39.3746986389161,16.6538181304932 39.3761291503907,16.6538181304932 39.3761291503907,16.6521415710449 39.3772048950196,16.6384143829346 39.3783836364746,16.6302471160889 39.3730850219728,16.6289882659913 39.3708305358887,16.6203117370605 39.3696289062501,16.6172924041748 39.3712539672852,16.6172924041748 39.3712539672852,16.6172676086426 39.3664436340333,16.6148586273194 39.3606567382814,16.6117763519287 39.3619537353516,16.6075496673584 39.3599014282228,16.6055488586425 39.3580551147461,16.6019668579102 39.3496704101562,16.5970668792725 39.34428024292,16.5868358612061 39.344051361084,16.5844402313232 39.3428916931152,16.5844402313232 39.3428916931152,16.5873241424561 39.3303031921387,16.5860557556153 39.3285903930665,16.5824127197266 39.3279571533203,16.5870304107666 39.3201789855957,16.5967693328858 39.308864593506,16.5873718261719 39.3004455566406,16.5826606750488 39.294246673584,16.5834236145019 39.2930412292482,16.5805416107178 39.2871475219727,16.5755023956299 39.2832794189453,16.5633087158203 39.2812995910645,16.5493545532228 39.2830276489259,16.5493545532228 39.2830276489259,16.5489311218262 39.2811965942383,16.5394325256348 39.2692184448243,16.5319156646729 39.2616577148439,16.5232276916504 39.255313873291,16.5187358856202 39.2528686523438,16.5020008087158 39.2500381469728,16.4916133880615 39.2420387268067,16.4916133880615 39.2420387268067,16.4991607666016 39.2326164245605,16.5164813995361 39.2267570495605,16.5392112731934 39.2241821289062,16.5543994903564 39.2263946533204,16.5636215209962 39.2290077209473,16.5698738098146 39.2199859619141,16.5697402954103 39.2176666259766,16.5722732543945 39.2123413085938,16.5817337036133 39.2014389038085,16.6003189086913 39.1930999755859,16.6003189086913 39.1930999755859,16.6138229370118 39.1952514648438,16.6138229370118 39.1952514648438,16.6165790557861 39.1973991394043,16.6306266784669 39.201457977295,16.6388912200928 39.2017898559571,16.6517581939698 39.1988639831542,16.6787872314454 39.2067947387695,16.6953048706054 39.2035331726075,16.696584701538 39.1994819641113,16.7201595306397 39.1984367370607,16.7234077453614 39.1963386535646,16.7243843078613 39.1936378479004,16.7339801788331 39.1917266845703,16.7486515045167 39.1907958984375,16.7584724426271 39.1932563781739,16.7638359069825 39.1960945129395,16.7643203735353 39.1973915100098,16.7712326049805 39.1983222961426,16.7745399475097 39.1949195861816,16.7745399475097 39.1949195861816,16.7789211273194 39.1969413757325,16.7626895904541 39.222511291504,16.7510147094727 39.2374458312988,16.7474689483643 39.2467308044433,16.7594776153564 39.2664337158204,16.7594776153564 39.2664337158204,16.7581310272217 39.2709388732911,16.7553977966309 39.2743263244629,16.7517642974855 39.2843208312988,16.7532005310059 39.2876510620117,16.7618446350098 39.2929000854493)) | 0.0006 | POINT(16.641725888816282 39.27662588960384) |
| 13859 | POLYGON((15.5819578170777 40.1467018127442,15.579662322998 40.1432914733887,15.5751838684083 40.1425590515138,15.5681314468384 40.1396484375001,15.5681314468384 40.1396484375001,15.5552616119385 40.1370010375977,15.5552616119385 40.1370010375977,15.5446910858155 40.1345176696778,15.5446910858155 40.1345176696778,15.5376338958741 40.1326026916504,15.5307703018189 40.1283683776855,15.521598815918 40.1262626647949,15.5168228149415 40.1261863708497,15.5113248825073 40.1305427551271,15.5113248825073 40.1305427551271,15.5078678131104 40.1310157775879,15.5082197189332 40.1357040405273,15.5052909851075 40.1429634094239,15.5005216598511 40.1506881713868,15.4965353012085 40.1526679992677,15.4951047897339 40.1610107421876,15.4956769943237 40.1644134521486,15.4956769943237 40.1644134521486,15.4963560104371 40.1654281616211,15.4939765930176 40.1683425903321,15.4900331497192 40.1709251403809,15.4914703369141 40.1764488220215,15.4942798614501 40.1815071105958,15.4966907501221 40.1804275512696,15.4987688064575 40.1755714416505,15.5140075683594 40.1683540344239,15.5166625976563 40.1564025878907,15.5292587280274 40.1513214111328,15.5347309112548 40.1515274047852,15.5465831756592 40.1551475524903,15.5535583496093 40.1611061096193,15.5549125671387 40.1659545898439,15.5577774047852 40.1672325134277,15.5777902603151 40.1650161743165,15.577995300293 40.1617355346681,15.577995300293 40.1617355346681,15.5819578170777 40.1467018127442)) | 0.0006 | POINT(15.529516824861872 40.15162081834753) |
| 15078 | POLYGON((8.25597190856945 44.2084655761719,8.25753593444824 44.2074928283692,8.25866413116455 44.2023887634278,8.25921344757074 44.1955223083497,8.25855827331549 44.1929168701173,8.25439834594738 44.1875038146974,8.24626255035406 44.1838684082031,8.24626255035406 44.1838684082031,8.24370193481457 44.1845817565919,8.23507118225109 44.1912841796875,8.22650909423828 44.2015228271486,8.21780395507818 44.202808380127,8.20251560211182 44.2008209228516,8.19959545135504 44.1994972229005,8.19060420989985 44.1989440917969,8.17869567871099 44.2018127441407,8.17869567871099 44.2018127441407,8.1775102615357 44.2111473083497,8.17338085174561 44.2128105163575,8.17156696319586 44.2172622680665,8.17224121093756 44.2173118591309,8.17224121093756 44.2173118591309,8.17883968353271 44.2179908752443,8.19435214996344 44.2259635925294,8.19874095916748 44.2309265136718,8.20328712463379 44.2382431030274,8.20368576049799 44.2422676086425,8.20368576049799 44.2422676086425,8.21723842620855 44.2304344177247,8.23909282684338 44.2150764465333,8.25317764282232 44.2087059020996,8.25597190856945 44.2084655761719)) | 0.0006 | POINT(8.21513228262628 44.2088010234218) |
| 68037 | POLYGON((7.45262956619263 49.3509407043457,7.45171642303472 49.3482398986816,7.44972229003912 49.3481788635254,7.45043802261347 49.3475418090821,7.44835901260382 49.3453407287599,7.44296216964727 49.3431053161621,7.44537162780756 49.3392372131349,7.44502305984497 49.3330154418946,7.43518114089977 49.3363494873047,7.43503427505493 49.3341102600099,7.43503427505493 49.3341102600099,7.42790651321411 49.3326835632325,7.4246249198913 49.3338088989259,7.4246249198913 49.3338088989259,7.42666530609142 49.3370170593262,7.42953252792364 49.336986541748,7.43123292922979 49.3390579223633,7.43035507202154 49.3396377563477,7.43038797378551 49.3412780761718,7.4316086769104 49.3443908691406,7.42975473403936 49.3455810546876,7.42991256713867 49.3465576171876,7.43793201446533 49.3537864685059,7.43793201446533 49.3537864685059,7.44101238250738 49.355541229248,7.44355916976934 49.3538284301759,7.44355916976934 49.3538284301759,7.44596385955816 49.3522338867188,7.44765567779547 49.3527221679687,7.45262956619263 49.3509407043457)) | 0.0006 | POINT(7.438127320388297 49.34367949387128) |
| 73384 | POLYGON((16.1451263427735 46.607250213623,16.1297912597656 46.6072311401368,16.1297912597656 46.6072311401368,16.1246604919435 46.6036720275879,16.1246395111084 46.6001167297364,16.1297149658204 46.5930099487305,16.1450290679933 46.589469909668,16.1449356079102 46.5716934204102,16.1602725982667 46.5717086791993,16.1602725982667 46.5717086791993,16.1704978942871 46.571720123291,16.1705188751221 46.5752754211426,16.18585395813 46.5752944946289,16.1858730316163 46.5788497924806,16.1909847259521 46.5788536071778,16.1910037994386 46.5824089050293,16.1910037994386 46.5824089050293,16.1910228729249 46.585964202881,16.1859493255616 46.5930709838868,16.1451072692872 46.6036949157715,16.1451263427735 46.607250213623)) | 0.0006 | POINT(16.16010246276862 46.58753166198735) |
| 18771 | POLYGON((14.4588642120362 37.8917694091797,14.4381866455078 37.8838081359863,14.4256229400635 37.8850746154785,14.4203300476074 37.8827896118165,14.4093103408815 37.871494293213,14.406967163086 37.8674812316896,14.406967163086 37.8674812316896,14.4176645278931 37.8630104064941,14.4215402603151 37.8603973388672,14.4243822097778 37.8558769226075,14.4269647598267 37.8542213439941,14.4369297027588 37.8516960144042,14.4414539337158 37.8516159057617,14.4621019363403 37.8444023132325,14.4655685424806 37.8412475585939,14.4627981185914 37.8349838256837,14.4584178924561 37.8306770324708,14.4553651809693 37.8238677978516,14.4546928405762 37.8180618286133,14.4595499038696 37.8156471252441,14.475401878357 37.8118972778321,14.4829196929932 37.813949584961,14.4934949874879 37.8258857727051,14.5030918121338 37.8434638977052,14.5025787353517 37.8470306396484,14.5057411193849 37.8518867492675,14.5282993316651 37.863208770752,14.5340356826783 37.8619575500489,14.541093826294 37.8659057617187,14.5463542938233 37.8738861083986,14.5517559051515 37.8773498535156,14.557622909546 37.8793487548829,14.5661134719849 37.8780899047853,14.570897102356 37.8807525634767,14.570897102356 37.8807525634767,14.5720386505128 37.8818626403809,14.5736837387086 37.8884162902833,14.5705795288086 37.8939018249512,14.5680465698242 37.8954544067384,14.5457553863525 37.8972816467285,14.5331897735596 37.9060554504394,14.5322771072389 37.9079360961914,14.5322771072389 37.9079360961914,14.5262336730957 37.9087257385253,14.5023622512817 37.899600982666,14.4994297027588 37.8975067138672,14.4946842193604 37.8963966369629,14.4725503921509 37.8951225280762,14.4653186798096 37.8962860107422,14.4633769989014 37.895908355713,14.4588642120362 37.8917694091797)) | 0.0006 | POINT(14.490715599060104 37.86838722229008) |
| 23785 | POLYGON((3.24891853332514 46.3356475830079,3.26019406318676 46.3419952392578,3.2744541168214 46.3439903259277,3.2744541168214 46.3439903259277,3.28708171844494 46.3419494628907,3.28708171844494 46.3419494628907,3.28450727462774 46.3219223022462,3.27560377120983 46.3192520141603,3.27139043807995 46.3135070800782,3.26187133789062 46.3148536682129,3.26187133789062 46.3148536682129,3.25030446052551 46.3175086975098,3.25030446052551 46.3175086975098,3.24534153938305 46.3294334411622,3.24891853332514 46.3356475830079)) | 0.0006 | POINT(3.2666699205126726 46.32845442635677) |
| 46914 | POLYGON((3.39652752876282 50.2838897705078,3.38815069198603 50.2916107177735,3.37319970130926 50.2901649475098,3.36700987815868 50.2850036621095,3.36700987815868 50.2850036621095,3.3647940158844 50.2828178405763,3.3647940158844 50.2828178405763,3.37083005905157 50.2670707702637,3.37083005905157 50.2670707702637,3.38759016990662 50.2659950256348,3.38759016990662 50.2659950256348,3.39979314804077 50.2751159667968,3.39652752876282 50.2838897705078)) | 0.0006 | POINT(3.3781766096751187 50.27854633331304) |