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 |
---|---|---|---|
1389588 | POLYGON((-0.271448999643326 42.007926940918,-0.273151993751526 41.9997024536132,-0.277171999215966 41.9951667785646,-0.287896007299366 41.9914054870605,-0.294335991144067 41.9864234924318,-0.306847006082421 41.9825553894044,-0.312817990779877 41.9791946411133,-0.32166999578476 41.9762077331543,-0.333059012889805 41.9751548767091,-0.336320012807732 41.9773826599122,-0.333972990512734 41.9798431396486,-0.338066011667252 41.9809646606446,-0.342489987611771 41.9857215881348,-0.346881985664311 42.0008544921874,-0.356812000274545 42.0112304687501,-0.347357988357487 42.0170288085939,-0.345757991075516 42.029899597168,-0.320591986179352 42.0317687988281,-0.3192999958992 42.0254745483398,-0.307770013809204 42.0207633972169,-0.297800987958851 42.012638092041,-0.291673988103867 42.0119018554689,-0.287591993808746 42.0070838928223,-0.271448999643326 42.007926940918)) | 0.0006 | POINT(-0.3152516056661601 41.999404077944604) |
1401326 | POLYGON((-4.02569389343256 41.2346458435059,-4.0219521522522 41.2342109680176,-4.02254390716553 41.2331314086915,-4.01965188980103 41.2319869995118,-4.01917314529413 41.2342681884767,-4.01657104492188 41.2334022521974,-4.0174298286438 41.2326545715333,-4.01486587524414 41.2327766418458,-4.01438283920288 41.2346725463867,-4.01262283325195 41.2319221496582,-4.00899505615223 41.2327384948731,-4.00867080688471 41.2295265197754,-4.00672006607056 41.228343963623,-4.00529813766479 41.2296829223634,-4.00129413604725 41.2277069091797,-3.99891591072071 41.2283477783204,-3.99085688591003 41.2240219116211,-3.99245691299427 41.2216873168946,-3.98960590362549 41.2217559814453,-3.98830008506775 41.2189826965332,-3.99108290672302 41.2127723693849,-3.9860639572143 41.2107162475587,-3.98062896728516 41.204517364502,-3.97901511192322 41.2058143615723,-3.97712588310236 41.2055511474609,-3.97756791114807 41.203941345215,-3.97245097160339 41.2031364440918,-3.96386790275574 41.2043190002442,-3.962483882904 41.2026557922364,-3.96417593955988 41.2009201049805,-3.96675491333008 41.2018699645997,-3.96961402893066 41.1991996765137,-3.9675190448761 41.1962699890137,-3.96799111366272 41.1934928894044,-3.9627211093902 41.1927261352539,-3.96318411827087 41.1885871887208,-3.97761106491089 41.1739921569825,-4.00141382217402 41.1777229309083,-4.01145601272577 41.1817245483399,-4.01546096801752 41.1801109313965,-4.0226149559021 41.1824455261232,-4.0266118049621 41.1811027526856,-4.02685880661011 41.1869926452637,-4.02436685562134 41.1908264160156,-4.01805400848389 41.1921691894531,-4.01552200317383 41.2019195556641,-4.01848506927485 41.2045516967773,-4.01638793945313 41.2085609436036,-4.02058410644531 41.2091827392579,-4.02040004730219 41.2110824584961,-4.023512840271 41.2133979797363,-4.02259922027588 41.2189903259277,-4.03057813644409 41.2257118225098,-4.03059911727905 41.2277717590332,-4.02868604660028 41.2276000976564,-4.02578115463251 41.2317237854004,-4.02569389343256 41.2346458435059)) | 0.0006 | POINT(-4.00188987595692 41.21161672047209) |
29531 | POLYGON((4.80149602890009 46.3224906921387,4.80776071548473 46.3263816833497,4.81020879745495 46.3382797241212,4.81020879745495 46.3382797241212,4.81391143798828 46.3405151367188,4.81249666214001 46.3472747802736,4.81249666214001 46.3472747802736,4.80525112152094 46.3559112548828,4.81180715560919 46.3606071472168,4.81180715560919 46.3606071472168,4.78987503051769 46.3674316406251,4.78987503051769 46.3674316406251,4.78242635726934 46.3457069396973,4.78242635726934 46.3457069396973,4.78100681304937 46.3236885070801,4.78100681304937 46.3236885070801,4.80149602890009 46.3224906921387)) | 0.0006 | POINT(4.800253808498447 46.34445476531988) |
34660 | POLYGON((3.75314092636114 48.7377166748047,3.73335146903997 48.7452087402345,3.73335146903997 48.7452087402345,3.73976230621344 48.7503662109376,3.73079395294184 48.758758544922,3.72972512245178 48.768913269043,3.73452925682068 48.7747917175294,3.73452925682068 48.7747917175294,3.73984527587891 48.7821426391602,3.73984527587891 48.7821426391602,3.75443744659418 48.7832374572755,3.775716304779 48.7753944396973,3.775716304779 48.7753944396973,3.78465247154236 48.7678451538087,3.78899931907654 48.7529640197753,3.78899931907654 48.7529640197753,3.75314092636114 48.7377166748047)) | 0.0006 | POINT(3.7523372173309335 48.76424002647405) |
1408644 | POLYGON((-2.94453406333918 42.526668548584,-2.93743205070496 42.5302963256837,-2.92239189147944 42.5322761535646,-2.91638207435608 42.5280303955079,-2.91750311851501 42.5259971618653,-2.9033429622649 42.519256591797,-2.89803695678705 42.5109138488771,-2.9036030769347 42.4921340942384,-2.91893410682678 42.4943771362305,-2.93390607833851 42.5021171569825,-2.93535804748529 42.4974403381348,-2.94195795059198 42.5074424743653,-2.93561506271357 42.5195426940919,-2.94453406333918 42.526668548584)) | 0.0006 | POINT(-2.923769033872112 42.51434560922485) |
64284 | POLYGON((12.1732149124146 52.5974655151368,12.1733846664429 52.5822563171387,12.1742153167726 52.57958984375,12.1767282485962 52.5764961242676,12.1810779571533 52.5751762390137,12.1590604782105 52.5606956481934,12.1519660949707 52.5440254211426,12.1489973068238 52.5399208068848,12.1433591842651 52.5366325378418,12.1449871063233 52.5331649780274,12.142261505127 52.5284156799316,12.1431770324707 52.5280265808105,12.1458320617676 52.5296630859375,12.1500701904298 52.528995513916,12.1546363830566 52.5296974182128,12.1581974029541 52.5342063903809,12.1646289825439 52.5353965759278,12.1685771942139 52.5376548767091,12.173888206482 52.5386924743652,12.178017616272 52.535083770752,12.1793766021729 52.5350952148439,12.1796035766603 52.5336647033693,12.1815872192383 52.5340919494628,12.1886892318726 52.5324211120605,12.1856317520142 52.5270996093751,12.1777868270874 52.5238914489747,12.1738004684448 52.5187225341798,12.1672945022584 52.5149841308594,12.1695070266724 52.5102691650391,12.1686429977418 52.5097122192384,12.1715555191041 52.5063362121583,12.1715555191041 52.5063362121583,12.1808366775513 52.5002975463867,12.1847305297852 52.4960441589356,12.1905851364135 52.4988670349121,12.1961088180543 52.4991760253907,12.1996765136718 52.4972534179688,12.2027235031128 52.4975433349611,12.2077970504761 52.4995574951172,12.2095165252687 52.5021438598632,12.2115001678467 52.5031318664552,12.2174615859985 52.500213623047,12.2213640213013 52.5005187988282,12.2277641296388 52.5059471130372,12.2239046096802 52.5094680786133,12.2239980697632 52.5115242004396,12.2316398620605 52.5162277221681,12.2327365875244 52.5190467834473,12.2310466766359 52.5218772888183,12.2355594635011 52.523780822754,12.2449836730956 52.5215225219727,12.2467670440674 52.5188598632813,12.254409790039 52.5193367004395,12.2582159042358 52.5178871154785,12.2589273452759 52.5153388977052,12.2574892044068 52.5113754272462,12.2594785690308 52.5087280273438,12.2599220275879 52.5042343139648,12.2669115066529 52.5013046264649,12.2700834274293 52.5009994506835,12.2624521255493 52.4954719543458,12.2700052261353 52.4936714172363,12.2714452743531 52.4874801635742,12.278450012207 52.4871482849122,12.2825164794922 52.4894027709961,12.2846403121948 52.4922256469726,12.2861986160278 52.4925765991212,12.293906211853 52.4922599792482,12.2948589324951 52.4926757812501,12.2948379516603 52.4945030212403,12.2974786758423 52.49617767334,12.3101291656495 52.4907608032227,12.3207559585572 52.4955139160156,12.3298892974854 52.4968605041505,12.330101966858 52.4952011108399,12.3276662826538 52.4914131164551,12.324273109436 52.4920501708984,12.319432258606 52.490421295166,12.3158721923828 52.490592956543,12.3130512237549 52.4897079467775,12.3093614578248 52.4862632751465,12.3101615905763 52.4830970764161,12.308295249939 52.4802894592286,12.3087282180786 52.4789772033691,12.3125000000001 52.4778861999512,12.3159351348877 52.4750213623048,12.3238658905029 52.4762306213379,12.327509880066 52.4792633056641,12.3307819366455 52.4785537719727,12.3252592086791 52.4720916748047,12.3251161575317 52.4642295837403,12.3150815963746 52.4604606628417,12.3149480819703 52.4593467712402,12.3172159194946 52.4567947387695,12.3171796798707 52.4540939331055,12.3171796798707 52.4540939331055,12.3196687698365 52.4537506103516,12.3217220306396 52.4444656372071,12.3279590606689 52.4397125244142,12.3323678970337 52.4408569335939,12.3341207504272 52.4389495849611,12.3439645767212 52.4393844604492,12.361180305481 52.4427719116212,12.361180305481 52.4427719116212,12.370285987854 52.4433250427246,12.3808822631835 52.4464149475098,12.3935852050782 52.448097229004,12.3952684402467 52.4506416320801,12.4029455184938 52.4528579711915,12.4061975479127 52.4569816589357,12.4144334793091 52.4570770263673,12.4175920486451 52.4555053710938,12.427043914795 52.4588890075685,12.4234657287599 52.4554557800294,12.4234132766724 52.4535598754883,12.4258708953857 52.4545364379883,12.4262504577637 52.455852508545,12.4296674728394 52.455852508545,12.4279298782349 52.4572296142579,12.4281749725342 52.4581451416016,12.4281749725342 52.4581451416016,12.4320135116577 52.4576683044434,12.4379129409791 52.4625244140625,12.4414949417114 52.4714622497559,12.4482316970826 52.4727363586426,12.4476642608644 52.475830078125,12.4496259689331 52.4790000915527,12.4357194900514 52.4756736755372,12.4139261245728 52.4759140014649,12.411916732788 52.4781951904297,12.4141798019409 52.4794464111328,12.4125452041627 52.4808464050294,12.4148683547974 52.4817619323731,12.4160785675049 52.4845771789551,12.4205722808839 52.4880142211915,12.424123764038 52.492473602295,12.4110832214357 52.4949684143068,12.4170408248901 52.5001983642579,12.4198932647705 52.4986495971681,12.4242324829102 52.50154876709,12.4203863143921 52.503303527832,12.4189014434814 52.5082092285157,12.4146642684937 52.5087623596191,12.4146642684937 52.5087623596191,12.4120578765869 52.5064201354982,12.411280632019 52.5009727478028,12.4081144332886 52.5017433166504,12.4033107757569 52.5049209594727,12.4030561447145 52.5069160461426,12.4039764404297 52.5084457397461,12.4006652832032 52.5106658935548,12.3955373764038 52.5114326477051,12.389820098877 52.5101280212403,12.385111808777 52.5145645141602,12.3824157714844 52.5153274536133,12.3766956329347 52.5153503417969,12.3706169128419 52.5131340026855,12.3669233322144 52.5143623352051,12.3656930923462 52.5127868652345,12.3599996566773 52.51558303833,12.3574562072755 52.5154266357422,12.3559484481812 52.5149612426758,12.3559932708741 52.5135498046876,12.3529767990112 52.5105018615723,12.3487701416016 52.5107383728028,12.3466901779175 52.5125122070313,12.3460512161256 52.5206298828126,12.3399667739869 52.5229263305663,12.3346109390259 52.5275421142578,12.3259658813477 52.5278701782228,12.324489593506 52.528549194336,12.3267974853516 52.5298080444336,12.32523727417 52.5309677124023,12.3234806060792 52.5305786132812,12.322772026062 52.5291061401368,12.3206043243409 52.5291290283204,12.3151903152465 52.5269165039064,12.3114023208619 52.52734375,12.3087282180786 52.5290641784669,12.3079967498779 52.5310287475587,12.3087673187256 52.5355148315429,12.3060131072999 52.5381736755372,12.3045387268066 52.5455360412597,12.306736946106 52.5480766296387,12.313801765442 52.5505676269532,12.313801765442 52.5505676269532,12.3007411956787 52.5483283996583,12.2921810150146 52.5512428283693,12.2963485717775 52.5543403625488,12.2901105880738 52.5555572509766,12.2838325500489 52.554298400879,12.280174255371 52.5513572692872,12.2728891372682 52.5492362976075,12.2598323822022 52.5470504760743,12.2539262771608 52.5473175048829,12.2527198791504 52.5523262023926,12.2546977996827 52.5560836791993,12.2547369003297 52.5589904785156,12.2579345703126 52.5671195983887,12.2581787109376 52.5703353881837,12.2646131515503 52.5717735290528,12.2711839675903 52.57181930542,12.274757385254 52.5736923217773,12.2848196029664 52.5757484436036,12.2934093475342 52.5797119140626,12.2897672653198 52.5816841125489,12.2895689010621 52.5852203369141,12.2899608612061 52.5876541137695,12.2933645248413 52.5896530151368,12.2928371429444 52.5934562683105,12.2917070388795 52.5947494506837,12.2824220657349 52.598602294922,12.2697639465331 52.6001396179199,12.2657613754273 52.6020240783691,12.2581949234009 52.6011352539062,12.245614051819 52.6042022705078,12.2357635498047 52.6147804260254,12.2369565963745 52.6222724914551,12.2409191131592 52.626121520996,12.2405176162719 52.6294822692871,12.2425241470337 52.6312789916992,12.2415733337402 52.6319122314454,12.2368078231813 52.629867553711,12.2368078231813 52.629867553711,12.2368726730347 52.6288757324219,12.2225818634034 52.6271286010742,12.209418296814 52.6240882873536,12.2035369873047 52.6187477111818,12.1951608657837 52.6195831298829,12.1718940734864 52.6257820129396,12.1718940734864 52.6257820129396,12.1692657470704 52.6210861206055,12.1691331863403 52.6167526245118,12.1755685806275 52.6173286437989,12.1737871170045 52.6163406372071,12.1707706451416 52.6123313903809,12.1702880859376 52.6077003479005,12.1765651702881 52.6064682006835,12.1732149124146 52.5974655151368)) | 0.0006 | POINT(12.293421572997811 52.521047992866585) |
43227 | POLYGON((6.72270107269281 48.2603759765626,6.72185993194591 48.2685165405274,6.72185993194591 48.2685165405274,6.70417737960815 48.2781791687013,6.70417737960815 48.2781791687013,6.68034124374395 48.2726936340331,6.68034124374395 48.2726936340331,6.68052768707281 48.2591400146485,6.67529058456421 48.2494201660157,6.67529058456421 48.2494201660157,6.70645141601568 48.2470245361329,6.72613954544079 48.2517738342285,6.72613954544079 48.2517738342285,6.72270107269281 48.2603759765626)) | 0.0006 | POINT(6.701945965106717 48.262131324181226) |
62241 | MULTIPOLYGON(((10.3170385360718 53.3044090270997,10.3197793960572 53.3031692504884,10.321180343628 53.3035354614258,10.3227462768555 53.305835723877,10.3241777420044 53.3053398132325,10.3242616653444 53.3040542602539,10.3263235092163 53.3047485351562,10.3259239196778 53.3028602600098,10.3420009613038 53.2959747314453,10.3433799743652 53.2926559448243,10.3457469940186 53.2907752990723,10.3658437728882 53.2849807739258,10.3658437728882 53.2849807739258,10.3625583648681 53.2826881408693,10.3624963760377 53.2764282226563,10.3571882247925 53.2716674804688,10.3574247360231 53.2686195373535,10.3574247360231 53.2686195373535,10.3394918441773 53.2647705078126,10.3378524780274 53.2620620727539,10.3364152908326 53.2614059448243,10.3335638046265 53.2624816894532,10.3297481536866 53.2616424560546,10.3203516006471 53.2629051208496,10.3203516006471 53.2629051208496,10.3326168060303 53.2731094360352,10.3345966339111 53.2789306640626,10.333381652832 53.2828903198243,10.3320980072023 53.2851715087891,10.3271837234497 53.2858238220215,10.3168869018556 53.2982254028321,10.305856704712 53.300579071045,10.305856704712 53.300579071045,10.3117151260377 53.3044395446778,10.3165225982667 53.3035202026368,10.3170385360718 53.3044090270997)),((10.3647394180298 53.2685394287109,10.3594179153442 53.2683105468751,10.3594179153442 53.2683105468751,10.3589124679567 53.2716865539551,10.3626270294189 53.272975921631,10.3647394180298 53.2685394287109))) | 0.0006 | POINT(10.334067968514043 53.28552095300953) |
49829 | POLYGON((3.5289740562439 49.7778015136719,3.53023791313171 49.7685661315919,3.52342319488525 49.7600784301759,3.50589776039124 49.7536582946778,3.50589776039124 49.7536582946778,3.51217651367193 49.7450141906738,3.49620246887213 49.7334823608398,3.49620246887213 49.7334823608398,3.50159072875982 49.7302322387695,3.50159072875982 49.7302322387695,3.51627635955816 49.733585357666,3.54005241394054 49.715358734131,3.55622267723089 49.7152061462403,3.56010174751293 49.7176322937012,3.56010174751293 49.7176322937012,3.57418847084045 49.7268829345704,3.59623074531567 49.7331314086915,3.59623074531567 49.7331314086915,3.59717702865606 49.7393989562989,3.60677051544201 49.7463607788087,3.60677051544201 49.7463607788087,3.60794830322271 49.7567863464357,3.599920988083 49.7605819702148,3.56259703636169 49.7454490661622,3.55215501785284 49.7453613281251,3.53486943244945 49.759105682373,3.53992176055908 49.7634201049805,3.54020190238953 49.7741737365723,3.54020190238953 49.7741737365723,3.53259634971619 49.7778930664062,3.53259634971619 49.7778930664062,3.5289740562439 49.7778015136719)) | 0.0006 | POINT(3.546945987209249 49.74663629839502) |
22323 | POLYGON((-0.311208218336049 44.996280670166,-0.315916925668716 44.9955787658692,-0.322694838047028 44.9865188598633,-0.343361794948578 44.9781150817872,-0.343361794948578 44.9781150817872,-0.348947912454491 44.9740715026857,-0.348947912454491 44.9740715026857,-0.329905599355698 44.964485168457,-0.326341480016652 44.9555549621583,-0.326341480016652 44.9555549621583,-0.310547918081227 44.9526748657227,-0.310547918081227 44.9526748657227,-0.294816792011261 44.9551429748536,-0.294816792011261 44.9551429748536,-0.290221482515335 44.9685249328614,-0.281401187181473 44.9713821411133,-0.281401187181473 44.9713821411133,-0.283217072486877 44.9778861999513,-0.300483405590001 44.9828262329102,-0.300762712955418 44.9895057678223,-0.311208218336049 44.996280670166)) | 0.0006 | POINT(-0.3132622212171243 44.97177448272712) |