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
63505POLYGON((11.3453903198242 53.1897163391114,11.3490428924561 53.189754486084,11.3538427352906 53.2011489868165,11.3524360656739 53.2034950256348,11.3566923141479 53.2045059204102,11.3619804382325 53.2092437744141,11.3533782958984 53.2096557617188,11.354115486145 53.2126502990723,11.3520507812499 53.2145538330078,11.3515710830688 53.2162933349609,11.3551959991455 53.2217674255372,11.3551959991455 53.2217674255372,11.3526601791382 53.2234497070314,11.3374300003053 53.2245330810547,11.3317470550538 53.2258224487305,11.3289241790771 53.229419708252,11.330665588379 53.2319869995118,11.330665588379 53.2319869995118,11.3218832015991 53.2326393127442,11.3231706619262 53.2301597595215,11.2999629974365 53.2299613952637,11.2971944808961 53.2309417724609,11.2826919555664 53.2291564941407,11.2653226852418 53.2235755920411,11.2606315612793 53.2190399169922,11.2516460418702 53.214672088623,11.2557668685913 53.2122116088868,11.2774791717529 53.2070770263673,11.2764072418213 53.2048721313477,11.2747926712036 53.2041625976563,11.2749042510986 53.2002792358398,11.2749042510986 53.2002792358398,11.2821350097657 53.1884574890138,11.295386314392 53.1863479614258,11.2958793640136 53.1871299743653,11.2937383651734 53.1895866394044,11.2973384857178 53.1891860961914,11.2967357635498 53.1881484985352,11.3011245727538 53.185890197754,11.3074474334717 53.1854515075683,11.3122205734254 53.1862678527832,11.3184022903442 53.1854705810547,11.3196067810059 53.1842918395997,11.3351020812989 53.1893920898438,11.3453903198242 53.1897163391114))0.0006POINT(11.314655910838741 53.20787273753775)
54363POLYGON((4.78899383544928 45.9235534667969,4.80776023864746 45.9208068847657,4.80776023864746 45.9208068847657,4.83061552047741 45.9215469360353,4.85122108459478 45.9290657043458,4.85122108459478 45.9290657043458,4.85298919677734 45.9321250915528,4.87408590316772 45.9367866516113,4.87408590316772 45.9367866516113,4.87171792984009 45.9427070617676,4.86147642135631 45.94873046875,4.86147642135631 45.94873046875,4.84506654739386 45.9526481628418,4.84506654739386 45.9526481628418,4.81513977050793 45.9485473632812,4.81513977050793 45.9485473632812,4.80885219573986 45.9477844238281,4.80885219573986 45.9477844238281,4.79963397979748 45.9466323852539,4.79963397979748 45.9466323852539,4.79066848754894 45.9452972412109,4.79066848754894 45.9452972412109,4.79705286026001 45.9399375915528,4.78899383544928 45.9235534667969))0.0006POINT(4.828225156535339 45.939672553021005)
67724MULTIPOLYGON(((9.75059509277355 48.3193435668945,9.75706386566173 48.3221626281739,9.75168800354004 48.321949005127,9.75168800354004 48.321949005127,9.74722671508795 48.3244895935059,9.74722671508795 48.3244895935059,9.75257873535156 48.3245086669922,9.7497825622558 48.3257484436035,9.74994087219238 48.3277893066407,9.75652027130127 48.3269157409668,9.7610330581665 48.3253746032715,9.76235580444347 48.3221817016601,9.76107406616211 48.3219833374025,9.76099872589117 48.3210639953614,9.76099872589117 48.3210639953614,9.75791358947765 48.3209457397462,9.75840759277355 48.3193092346192,9.76396274566662 48.3199005126953,9.76463794708263 48.3158111572266,9.76956272125244 48.3150939941407,9.76978492736816 48.3120079040527,9.77525424957287 48.3109474182129,9.77174854278559 48.3089904785157,9.7718648910523 48.307674407959,9.77038955688471 48.307228088379,9.77040576934809 48.3061408996583,9.76738262176519 48.3046379089356,9.76977348327642 48.2997360229492,9.77479553222662 48.3009452819824,9.7761688232423 48.2986068725587,9.77770900726313 48.2988967895509,9.77770900726313 48.2988967895509,9.77837181091314 48.2968978881837,9.78034687042236 48.2973136901855,9.78196048736572 48.2938461303712,9.78849411010737 48.2939338684083,9.79023933410645 48.2906341552735,9.78729915618896 48.2908592224121,9.78783416748041 48.2827529907227,9.79439353942877 48.2809715270997,9.79439353942877 48.2809715270997,9.78846836090088 48.2808227539062,9.78536510467535 48.2756156921387,9.77689552307135 48.2745895385743,9.7767591476441 48.2756423950195,9.77325916290278 48.2754936218263,9.77356910705561 48.2732009887695,9.77244472503668 48.2732849121094,9.77174377441412 48.2713813781738,9.75885963439953 48.271152496338,9.75821495056147 48.2692070007325,9.7599020004273 48.2685317993165,9.76066112518311 48.2655830383302,9.76163387298595 48.2657508850098,9.76326656341553 48.2619667053224,9.76674556732183 48.2627983093262,9.76775360107433 48.2597122192383,9.76992130279535 48.2599067687988,9.77110767364508 48.2553215026857,9.77536201477051 48.2562217712403,9.77675056457525 48.2524528503419,9.78263282775885 48.2531509399414,9.78509616851812 48.246925354004,9.79126834869396 48.2473602294923,9.79079055786127 48.245964050293,9.79327869415295 48.245216369629,9.79327869415295 48.245216369629,9.79589366912853 48.2421035766602,9.79506492614746 48.2407951354982,9.79851341247559 48.2405395507814,9.79787826538086 48.239128112793,9.79908847808849 48.2385101318359,9.78558349609375 48.2375144958497,9.79332065582281 48.2357215881348,9.79468917846685 48.2341384887696,9.79487323760986 48.2316513061523,9.77857303619385 48.2282371520997,9.77858924865723 48.2271308898926,9.78015136718761 48.2261428833008,9.7717103958131 48.2273559570314,9.76889228820806 48.2259521484376,9.7683191299439 48.2274131774903,9.76441287994385 48.2267951965333,9.7669620513916 48.2164459228516,9.7669620513916 48.2164459228516,9.76731872558599 48.2151184082032,9.76468276977539 48.2132759094239,9.76558876037598 48.212013244629,9.76190662384039 48.2115783691406,9.76166152954102 48.2108345031739,9.75345993041992 48.210922241211,9.7531147003175 48.2088012695313,9.754961013794 48.2085685729982,9.75575637817383 48.2066802978516,9.74262428283703 48.2043952941896,9.74178981781017 48.2035255432129,9.74178981781017 48.2035255432129,9.73893070220953 48.2075157165527,9.73371410369884 48.206527709961,9.73272514343262 48.2087593078614,9.72457027435308 48.2081336975098,9.72275638580328 48.2105751037598,9.71946907043457 48.210922241211,9.71923542022716 48.2120628356934,9.71684741973877 48.2116317749024,9.7143955230714 48.2144279479981,9.71040534973156 48.2149391174316,9.70825386047369 48.2140769958497,9.71178531646729 48.2161445617676,9.70703220367432 48.2205505371094,9.70703220367432 48.2205505371094,9.71121025085455 48.2226409912109,9.70875167846691 48.2240524291993,9.71627807617199 48.2313270568848,9.71204853057856 48.236644744873,9.70943355560303 48.236068725586,9.70787048339855 48.240364074707,9.7042350769043 48.2421073913575,9.70586490631104 48.2444953918457,9.704758644104 48.2454948425294,9.70022773742681 48.2460289001465,9.69562435150152 48.2443580627442,9.69548511505127 48.2462806701661,9.68787765502935 48.2455940246583,9.6875429153443 48.2471389770508,9.68458938598633 48.2466583251953,9.68321704864513 48.2482223510742,9.68561840057384 48.248706817627,9.6851224899292 48.2510147094728,9.68257331848156 48.2504997253419,9.6798353195191 48.2540512084962,9.6764545440675 48.2541236877442,9.67625617980968 48.2555236816407,9.66972255706798 48.2549705505371,9.67037582397467 48.2513427734376,9.67037582397467 48.2513427734376,9.66735935211182 48.2506370544434,9.661286354065 48.2538642883301,9.65459346771246 48.253173828125,9.65343570709229 48.2555236816407,9.64720153808599 48.2524871826172,9.64372253417974 48.2566604614258,9.63665103912354 48.2553024291992,9.62699222564703 48.2510452270507,9.62699222564703 48.2510452270507,9.62534809112555 48.2511749267579,9.62736797332764 48.2519111633301,9.62653541564941 48.2532806396486,9.62409114837652 48.2536926269532,9.62408828735346 48.2561111450196,9.61999225616461 48.2562866210938,9.6197395324707 48.2583885192871,9.61513900756836 48.2574157714844,9.61332607269287 48.2586212158204,9.61087131500244 48.2573814392091,9.61087131500244 48.2573814392091,9.60021781921392 48.2575798034669,9.59718990325933 48.2582397460939,9.59564590454113 48.2609329223634,9.59472179412842 48.2599182128907,9.59308338165283 48.2618751525879,9.59120559692388 48.2614440917969,9.5890035629273 48.2640533447266,9.58714008331299 48.2780532836915,9.5852041244508 48.2807426452637,9.5835542678833 48.2811012268066,9.56961536407471 48.2781066894532,9.56393051147467 48.2795600891113,9.56015014648438 48.2792930603028,9.55993843078625 48.2727737426759,9.55729961395258 48.271339416504,9.55721569061285 48.2700805664064,9.54908752441406 48.2690658569337,9.54612636566173 48.2675285339357,9.54598045349121 48.2653961181641,9.54421615600586 48.2640342712403,9.54037570953375 48.263469696045,9.54312229156506 48.2614250183107,9.54339981079096 48.2596397399903,9.54263687133783 48.2593994140626,9.54340934753429 48.2584342956543,9.53971862792969 48.2592201232911,9.53932094573975 48.2561302185059,9.52831840515142 48.2539558410646,9.52831840515142 48.2539558410646,9.52657985687262 48.2543029785156,9.52657985687262 48.2543029785156,9.52259922027588 48.2554359436036,9.52195739746088 48.2565727233887,9.52846431732178 48.2604789733886,9.53050708770752 48.2606658935547,9.53037166595459 48.2634353637695,9.52041721344006 48.2608833312988,9.51945781707769 48.2617378234864,9.52445602416998 48.2636451721192,9.52375698089605 48.2649230957032,9.52679538726807 48.2665405273438,9.5264682769776 48.2681121826172,9.5249166488648 48.268898010254,9.51657009124767 48.2667655944825,9.51706314086925 48.2676849365234,9.51597499847423 48.268898010254,9.50653171539301 48.2690200805664,9.50777816772461 48.2746238708496,9.50589561462402 48.2758407592773,9.50592327117926 48.2784385681152,9.50752353668213 48.2806015014648,9.50880336761475 48.2812271118164,9.51436996459972 48.2804222106934,9.51723957061773 48.2817611694336,9.5212898254394 48.2819671630859,9.52349376678478 48.2842445373536,9.52698802947992 48.2833099365234,9.52942562103271 48.2840538024903,9.53288269042969 48.2883720397949,9.53895378112799 48.2893409729004,9.5417881011964 48.2918663024903,9.5492572784425 48.2929992675781,9.55387306213379 48.2918968200685,9.5569953918457 48.2934646606446,9.55647754669195 48.2958755493164,9.55366325378424 48.2971839904786,9.55151844024664 48.3000869750977,9.55340957641607 48.3019561767579,9.5548467636109 48.3015022277832,9.55519390106213 48.3065376281739,9.54410552978516 48.3077659606935,9.54500484466547 48.30863571167,9.54375362396246 48.3098907470704,9.53360843658442 48.3138160705567,9.53351211547852 48.3159370422364,9.53351211547852 48.3159370422364,9.53436660766607 48.3184242248536,9.53783512115479 48.3182373046875,9.54209709167492 48.3202018737793,9.54589939117437 48.319450378418,9.54995918273931 48.3200531005861,9.54981136322021 48.322120666504,9.5524635314942 48.3230056762695,9.55572509765625 48.3265686035156,9.55590057373041 48.3279533386232,9.55844879150391 48.3293685913087,9.55626678466808 48.3313446044921,9.55757808685314 48.3325691223146,9.56370735168463 48.3308067321778,9.56746864318853 48.330837249756,9.56806373596197 48.3300247192383,9.57546329498297 48.329475402832,9.57602310180658 48.3283767700196,9.5801038742066 48.3271942138672,9.5805072784425 48.3286895751953,9.57947540283209 48.3297996520997,9.5794353485108 48.3319358825684,9.5812225341798 48.3351516723632,9.58608913421637 48.3395538330078,9.58894824981695 48.3468246459961,9.59089946746826 48.3485488891602,9.59135246276855 48.3503074645997,9.5899772644043 48.3539009094239,9.59206390380865 48.3563270568848,9.59206390380865 48.3563270568848,9.59883403778088 48.3579216003419,9.59995937347412 48.3568954467773,9.60612297058111 48.3591842651367,9.60834312438965 48.3580513000489,9.6086101531983 48.3604087829591,9.61033630371099 48.3612136840821,9.61240768432629 48.3593635559083,9.61635112762457 48.3591423034668,9.61834144592285 48.3602447509766,9.62457275390619 48.3580741882325,9.62453174591064 48.3618774414062,9.62974166870123 48.3625640869142,9.63406658172613 48.3659439086915,9.63825988769543 48.3638381958008,9.6352596282959 48.3618087768556,9.63889884948736 48.3612899780273,9.63847446441662 48.3600730895996,9.63847446441662 48.3600730895996,9.63654994964594 48.3567581176758,9.63478851318365 48.3571739196778,9.63193607330328 48.3544387817383,9.6279554367066 48.3529663085938,9.62550258636469 48.3536300659181,9.62167739868164 48.3517837524414,9.62311363220221 48.3453750610352,9.61909198760992 48.34476852417,9.61845970153809 48.342414855957,9.62261390686041 48.3318748474121,9.62529563903809 48.3296775817872,9.6305770874024 48.329906463623,9.63851833343506 48.332290649414,9.64803409576427 48.330177307129,9.64824199676525 48.3314208984376,9.65008544921886 48.3300590515138,9.65450096130371 48.3306121826172,9.65715789794933 48.3298110961913,9.65662288665771 48.3285865783691,9.65838146209728 48.3274688720704,9.6591615676881 48.3252182006837,9.66393184661871 48.3229064941407,9.66947650909435 48.3225059509277,9.67702579498302 48.3242874145507,9.67977619171154 48.3223915100098,9.68036460876476 48.3207054138185,9.68426418304443 48.3197250366211,9.68829536438 48.320484161377,9.69193553924572 48.3229293823243,9.70078277587896 48.3235511779786,9.70320510864269 48.320484161377,9.70855045318604 48.3201179504395,9.70564937591553 48.316951751709,9.7017240524292 48.3162841796875,9.70310306549078 48.3151779174805,9.70199489593506 48.3144950866699,9.70547389984131 48.3144493103028,9.70353603363037 48.3117294311523,9.70791244506842 48.3111686706544,9.70836257934582 48.3091926574708,9.7194442749024 48.3107109069824,9.72144031524658 48.3080635070801,9.72323703765869 48.3086585998536,9.72496700286871 48.3066215515138,9.73308277130127 48.3090782165528,9.72869300842291 48.3053703308105,9.73348617553717 48.3048400878906,9.73584842681885 48.305419921875,9.73871612548834 48.3091278076172,9.74514198303234 48.308433532715,9.75004959106451 48.3100585937501,9.75016307830811 48.3131980895997,9.75192737579346 48.3133544921876,9.75066089630133 48.3155937194825,9.75059509277355 48.3193435668945)),((9.83648967742931 48.2867240905762,9.83126640319819 48.2854804992676,9.82245826721191 48.2804374694825,9.82003307342535 48.2756652832031,9.81834125518799 48.275302886963,9.81716728210444 48.2763862609864,9.81339359283459 48.275650024414,9.81345272064215 48.2742652893066,9.80526161193848 48.27254486084,9.80526161193848 48.27254486084,9.80485153198254 48.2624893188476,9.80212497711193 48.2573280334473,9.80395793914795 48.2514533996583,9.80395793914795 48.2514533996583,9.80946922302252 48.2520256042481,9.81142807006836 48.2506103515626,9.811098098755 48.2491416931153,9.83106899261486 48.2532806396486,9.83207798004162 48.2511177062989,9.8342142105102 48.251190185547,9.83391952514648 48.2466659545898,9.84454727172863 48.2462959289551,9.84594917297369 48.2491912841797,9.8456563949585 48.2529296875001,9.84739685058594 48.2567062377931,9.84759044647228 48.2604026794434,9.85376930236822 48.2584800720215,9.85790634155285 48.2664337158204,9.85790634155285 48.2664337158204,9.86280155181896 48.2689361572267,9.86397838592541 48.2706680297853,9.86397838592541 48.2706680297853,9.86220550537121 48.2702713012696,9.85820770263666 48.2732429504396,9.85669612884521 48.2724151611328,9.85520935058594 48.2769660949708,9.8523349761964 48.2783699035646,9.84597015380871 48.2768936157227,9.83847713470465 48.2872047424316,9.83648967742931 48.2867240905762)))0.0006POINT(9.674109368678588 48.283853244739994)
59432POLYGON((7.87430381774914 47.1254653930665,7.88838911056513 47.1302490234376,7.88838911056513 47.1302490234376,7.89233303070068 47.1349830627441,7.89295005798346 47.1419410705567,7.89126586914068 47.1448135375977,7.88477611541748 47.1496620178223,7.88477611541748 47.1496620178223,7.87926006317139 47.16064453125,7.87870216369635 47.1638298034669,7.87990617752081 47.1684608459473,7.87990617752081 47.1684608459473,7.86696100234985 47.1668701171876,7.86562490463263 47.1627006530762,7.86045408248896 47.1575965881349,7.85049390792847 47.1563682556152,7.85049390792847 47.1563682556152,7.84635400772095 47.1567687988282,7.84635400772095 47.1567687988282,7.84688520431524 47.1539611816406,7.84904098510748 47.1508369445801,7.84904098510748 47.1508369445801,7.8577032089234 47.1473770141602,7.85369396209717 47.1431999206543,7.85197114944464 47.1391601562501,7.85314321517939 47.132911682129,7.85314321517939 47.132911682129,7.85966777801519 47.1316566467286,7.86404800415039 47.1340637207032,7.86675596237183 47.1340599060059,7.87153100967407 47.130298614502,7.87430381774914 47.1254653930665))0.0006POINT(7.867042526122079 47.14719796949821)
26101POLYGON((1.72949671745312 48.6461639404297,1.73994672298443 48.6384124755861,1.7578501701355 48.6315650939942,1.75968039035803 48.6213378906251,1.75266993045813 48.6086082458496,1.75266993045813 48.6086082458496,1.76496922969818 48.6053695678712,1.76319766044617 48.5999717712403,1.76319766044617 48.5999717712403,1.7750917673111 48.5982856750488,1.7750917673111 48.5982856750488,1.77711117267614 48.6047401428224,1.80578994750982 48.6105728149413,1.8275467157365 48.6192169189453,1.8275467157365 48.6192169189453,1.82235014438641 48.6348915100097,1.80234849452984 48.6388473510742,1.77649068832409 48.6382637023926,1.76887667179108 48.6428451538086,1.76679325103765 48.6529083251954,1.78679025173193 48.6641426086426,1.78597807884228 48.6745605468751,1.78597807884228 48.6745605468751,1.76716506481171 48.6740074157715,1.75968444347387 48.6652641296387,1.73749017715454 48.6524658203126,1.73749017715454 48.6524658203126,1.72949671745312 48.6461639404297))0.0006POINT(1.7729367415110824 48.63242778071653)
180592POLYGON((12.2433490753175 51.3484039306641,12.2419757843018 51.3493499755859,12.2419757843018 51.3493499755859,12.2419929504395 51.3497810363771,12.242078781128 51.3505439758302,12.2423772811889 51.3512229919434,12.2425346374512 51.3519401550293,12.2426052093506 51.3526802062988,12.2426052093506 51.3526802062988,12.2423934936523 51.3531684875489,12.2423934936523 51.3531684875489,12.241928100586 51.3537673950195,12.2417259216308 51.3541221618653,12.2417259216308 51.3541221618653,12.24094581604 51.3604774475099,12.24094581604 51.3604774475099,12.2409830093384 51.3614768981934,12.2412042617798 51.3623657226562,12.2412042617798 51.3623657226562,12.2414045333863 51.3642616271974,12.2414045333863 51.3642616271974,12.2415189743041 51.3649864196778,12.2417459487916 51.3656692504883,12.2419815063478 51.3662033081055,12.2421350479127 51.3668327331543,12.2427253723145 51.3676261901856,12.2429161071777 51.3681068420411,12.2429161071777 51.3681068420411,12.2432165145875 51.3711013793945,12.2432165145875 51.3711013793945,12.2423858642579 51.3711853027344,12.2374019622802 51.3717002868653,12.2374019622802 51.3717002868653,12.2397212982178 51.3729705810548,12.2397212982178 51.3729705810548,12.2412710189819 51.3732604980469,12.2422924041749 51.3735237121582,12.2422924041749 51.3735237121582,12.2439374923707 51.3741302490234,12.2439374923707 51.3741302490234,12.2447538375854 51.3744888305665,12.2460508346559 51.3751792907714,12.2468395233155 51.3756523132325,12.2475757598878 51.3761405944824,12.2475757598878 51.3761405944824,12.2493076324462 51.3773918151856,12.2493076324462 51.3773918151856,12.2509946823121 51.3786430358887,12.2526655197144 51.3794746398926,12.2545204162597 51.3802185058595,12.2545204162597 51.3802185058595,12.2588806152344 51.3806686401367,12.2588806152344 51.3806686401367,12.2591199874878 51.3812942504883,12.2591428756714 51.3818969726564,12.2586135864257 51.3823280334473,12.2572374343872 51.3828239440918,12.2572374343872 51.3828239440918,12.2562208175659 51.3859634399413,12.2584276199341 51.3899002075196,12.2584276199341 51.3899002075196,12.2647180557252 51.3930168151856,12.2679233551026 51.3970718383789,12.2599020004274 51.3998489379884,12.2555694580078 51.3997955322266,12.2494812011719 51.4063262939454,12.252558708191 51.4060173034669,12.252558708191 51.4060173034669,12.255976676941 51.4054374694825,12.255976676941 51.4054374694825,12.2640962600708 51.402988433838,12.2632598876953 51.4116325378418,12.2704257965088 51.4130973815919,12.2682495117188 51.4197731018068,12.2736787796021 51.4190864562988,12.2801322937012 51.4184875488282,12.2860908508301 51.4181175231934,12.2860908508301 51.4181175231934,12.3119802474977 51.4183883666992,12.3119802474977 51.4183883666992,12.315040588379 51.4186096191406,12.321665763855 51.4190826416016,12.321665763855 51.4190826416016,12.3294534683228 51.4194831848145,12.3294534683228 51.4194831848145,12.3331184387207 51.4197044372559,12.3331518173219 51.4190940856934,12.3331241607667 51.4183921813965,12.3403224945069 51.418083190918,12.3493232727051 51.4178581237794,12.3493232727051 51.4178581237794,12.3581228256227 51.4176406860352,12.3581228256227 51.4176406860352,12.3579273223878 51.4155311584473,12.3599014282226 51.4154663085939,12.3617324829102 51.4154052734376,12.362060546875 51.4183883666992,12.362060546875 51.4183883666992,12.3614959716797 51.4198265075684,12.3642482757568 51.4219284057618,12.3642482757568 51.4219284057618,12.3753194808959 51.424114227295,12.3766984939576 51.4235267639161,12.3786964416504 51.4228248596193,12.3815670013429 51.4221458435059,12.3899059295655 51.4205093383789,12.3926000595093 51.4198608398439,12.3926000595093 51.4198608398439,12.3961915969849 51.4183006286621,12.3961915969849 51.4183006286621,12.3968620300293 51.4177970886231,12.397334098816 51.4198226928712,12.3980236053467 51.4211959838868,12.3980236053467 51.4211959838868,12.4005832672119 51.4249458312989,12.4034900665283 51.4242401123048,12.4034900665283 51.4242401123048,12.4045448303223 51.4239883422852,12.4057321548462 51.4251861572266,12.4057321548462 51.4251861572266,12.4067430496215 51.4263114929199,12.4048624038697 51.4295539855957,12.4222393035889 51.4274826049806,12.4222393035889 51.4274826049806,12.4235715866089 51.4266395568849,12.4260969161988 51.4271202087402,12.4260969161988 51.4271202087402,12.4423961639405 51.4305877685546,12.4423961639405 51.4305877685546,12.4415979385376 51.4372520446778,12.4404106140137 51.4435882568359,12.4412050247193 51.4480667114258,12.4412050247193 51.4480667114258,12.4448719024658 51.4472503662109,12.4448719024658 51.4472503662109,12.4482021331787 51.4446029663087,12.4531869888305 51.4436378479005,12.4531869888305 51.4436378479005,12.4710960388184 51.4424743652344,12.4710960388184 51.4424743652344,12.4699220657349 51.4389228820801,12.4695405960083 51.4377593994141,12.4701843261719 51.4376564025879,12.4715862274171 51.4374465942384,12.4715862274171 51.4374465942384,12.4713220596313 51.4356498718261,12.4713220596313 51.4356498718261,12.4727725982667 51.4342231750489,12.4726142883301 51.4328727722169,12.4725503921509 51.4323997497558,12.4798555374146 51.4321861267091,12.4868259429932 51.4315567016602,12.4868259429932 51.4315567016602,12.4893808364869 51.4313697814942,12.4893808364869 51.4313697814942,12.4928894042969 51.4316062927247,12.4934425354004 51.428077697754,12.4920148849487 51.4280281066895,12.4920148849487 51.4280281066895,12.4920320510864 51.4257774353027,12.4920320510864 51.4257774353027,12.492039680481 51.42529296875,12.4924421310425 51.4252700805664,12.4924421310425 51.4252700805664,12.4935541152955 51.4223594665527,12.4919090270997 51.4222640991211,12.4919090270997 51.4222640991211,12.4921464920045 51.4204406738282,12.4893064498901 51.4203453063966,12.4889183044433 51.4176864624023,12.4889183044433 51.4176864624023,12.4753742218018 51.4173736572267,12.4750337600707 51.4198379516602,12.4653825759888 51.4203414916992,12.4653825759888 51.4203414916992,12.4627256393434 51.4194602966309,12.4615850448608 51.4187126159668,12.4588537216186 51.4187965393067,12.4588537216186 51.4187965393067,12.4572496414186 51.41459274292,12.4572496414186 51.41459274292,12.4573364257814 51.4102172851562,12.4615392684936 51.4078598022462,12.4661445617676 51.4034996032715,12.4702291488648 51.4037742614747,12.4714756011964 51.4023208618165,12.4683094024658 51.4012947082521,12.4683094024658 51.4012947082521,12.4695692062378 51.3947563171387,12.4695692062378 51.3947563171387,12.4697332382202 51.3942222595216,12.4688358306886 51.3940849304199,12.4671421051025 51.3935203552246,12.4659099578857 51.3929557800293,12.4649868011475 51.3922233581543,12.4649868011475 51.3922233581543,12.4635047912599 51.3915367126466,12.4635047912599 51.3915367126466,12.4631128311157 51.3914642333986,12.4647989273072 51.3905258178712,12.4647989273072 51.3905258178712,12.4666004180908 51.3842124938965,12.4768085479737 51.3834495544434,12.4768085479737 51.3834495544434,12.4763698577882 51.382942199707,12.4760303497315 51.3824157714844,12.4754619598389 51.381561279297,12.4754619598389 51.381561279297,12.4731254577637 51.3777122497559,12.4731254577637 51.3777122497559,12.4731616973878 51.3772277832031,12.4732513427734 51.3766403198242,12.473087310791 51.3754997253419,12.473087310791 51.3754997253419,12.4722299575807 51.3714256286621,12.4722299575807 51.3714256286621,12.4727640151978 51.3706474304199,12.4727430343628 51.3701438903809,12.4727430343628 51.3701438903809,12.4667549133302 51.3679733276368,12.4667549133302 51.3679733276368,12.4668817520143 51.3679084777833,12.479606628418 51.3612442016602,12.4955739974976 51.3604698181153,12.4987382888794 51.3605041503907,12.5048475265503 51.3525695800782,12.5048475265503 51.3525695800782,12.506422996521 51.3504638671876,12.506422996521 51.3504638671876,12.5082235336305 51.3482475280763,12.5086736679077 51.3476905822755,12.5091371536256 51.3471221923829,12.5126514434815 51.3469734191895,12.5183610916138 51.3483772277833,12.5213747024536 51.3485870361328,12.5213747024536 51.3485870361328,12.5280313491822 51.349292755127,12.5280313491822 51.349292755127,12.5271120071411 51.3480110168458,12.5266265869141 51.3467674255371,12.5265016555787 51.3458786010743,12.5264577865601 51.3455467224122,12.5264577865601 51.3455467224122,12.5269565582276 51.3444786071777,12.5269565582276 51.3444786071777,12.5275382995606 51.3436584472656,12.5277290344239 51.3434028625489,12.5283327102662 51.3427696228027,12.5283327102662 51.3427696228027,12.5291891098024 51.3423042297364,12.5291891098024 51.3423042297364,12.5298929214478 51.3419685363771,12.5306262969972 51.341651916504,12.5326585769653 51.3408164978028,12.5328845977784 51.3407287597657,12.5359659194946 51.3415222167968,12.5359659194946 51.3415222167968,12.538670539856 51.340602874756,12.538670539856 51.340602874756,12.5357866287232 51.3394203186036,12.5374059677125 51.3386535644531,12.537013053894 51.3375816345216,12.5388317108155 51.3367919921875,12.5386571884155 51.33642578125,12.5386571884155 51.33642578125,12.5377597808838 51.3356246948242,12.5377597808838 51.3356246948242,12.5361204147339 51.3346176147462,12.5341911315918 51.3335418701172,12.5318956375122 51.3329696655273,12.5299320220947 51.3324394226075,12.5299320220947 51.3324394226075,12.526861190796 51.3315353393555,12.526861190796 51.3315353393555,12.5342655181884 51.3287162780762,12.535846710205 51.3277702331544,12.5426073074341 51.324073791504,12.5400686264039 51.3222160339355,12.5365810394288 51.3190460205078,12.5359182357788 51.3183364868165,12.5349731445314 51.3174285888673,12.5349731445314 51.3174285888673,12.5333356857299 51.316780090332,12.5333356857299 51.316780090332,12.5328807830811 51.3168792724611,12.5324392318727 51.3169784545898,12.5315427780152 51.3174858093262,12.5315341949463 51.3169555664062,12.5328207015992 51.3155212402345,12.5395936965943 51.3079223632814,12.5395679473878 51.3073501586915,12.5391654968262 51.3063545227051,12.5391654968262 51.3063545227051,12.5050325393677 51.3027153015137,12.5050325393677 51.3027153015137,12.5032100677491 51.2967796325685,12.5032100677491 51.2967796325685,12.5019569396973 51.2930564880372,12.5003786087037 51.2894287109376,12.5003786087037 51.2894287109376,12.4968214035035 51.2891654968261,12.5005674362183 51.2822151184083,12.5005674362183 51.2822151184083,12.4938335418702 51.2828063964844,12.495099067688 51.2772254943848,12.4897727966309 51.2775039672852,12.4852466583251 51.2613639831543,12.4908142089844 51.2630577087402,12.4931621551513 51.2602920532227,12.488989830017 51.2586326599122,12.488989830017 51.2586326599122,12.4880123138427 51.2576446533203,12.4880123138427 51.2576446533203,12.4787759780884 51.2576560974122,12.4779071807862 51.2581481933595,12.4792070388795 51.2610130310059,12.4762859344483 51.2618179321289,12.4738674163819 51.2612838745117,12.4738674163819 51.2612838745117,12.4484376907349 51.2684860229492,12.4484376907349 51.2684860229492,12.4493322372436 51.2754020690919,12.447154045105 51.2826118469239,12.4340410232544 51.2844200134277,12.4320383071899 51.2852554321288,12.4320383071899 51.2852554321288,12.4299793243408 51.285083770752,12.4299793243408 51.285083770752,12.4176712036134 51.2838554382324,12.4145002365113 51.2835350036622,12.4151277542114 51.2799911499024,12.4126768112183 51.2790031433107,12.4126768112183 51.2790031433107,12.4122323989868 51.2804069519043,12.4100475311279 51.2803230285645,12.4100475311279 51.2803230285645,12.4097976684571 51.281219482422,12.409499168396 51.2823295593262,12.4058494567872 51.2822189331055,12.4058494567872 51.2822189331055,12.4031629562378 51.2824974060059,12.4031629562378 51.2824974060059,12.401647567749 51.2822875976563,12.4012727737427 51.2829513549806,12.4012727737427 51.2829513549806,12.3934364318848 51.2822303771973,12.3934364318848 51.2822303771973,12.393316268921 51.2799911499024,12.3907480239869 51.2800254821777,12.3907480239869 51.2800254821777,12.3856172561646 51.2819366455079,12.3856172561646 51.2819366455079,12.3817224502563 51.2828445434571,12.3806934356691 51.2840042114258,12.3774700164795 51.2871780395508,12.3774700164795 51.2871780395508,12.3770780563356 51.2875633239747,12.3770780563356 51.2875633239747,12.3765239715577 51.2883987426758,12.3762922286988 51.2894020080566,12.3762655258178 51.2908782958985,12.3762159347534 51.2909126281738,12.3745632171631 51.292064666748,12.3736295700074 51.2938079833986,12.3721761703492 51.2937431335449,12.3721761703492 51.2937431335449,12.3691272735596 51.2886352539064,12.3691272735596 51.2886352539064,12.36803150177 51.2867431640626,12.3663578033448 51.2872276306153,12.3634967803956 51.2892456054689,12.3634967803956 51.2892456054689,12.3643207550048 51.2908058166504,12.3547363281249 51.296241760254,12.3547363281249 51.296241760254,12.3534879684448 51.2962722778321,12.3501186370849 51.2963600158693,12.3501186370849 51.2963600158693,12.3531408309938 51.2901191711425,12.3531408309938 51.2901191711425,12.3501462936402 51.2898902893068,12.3515481948853 51.2862052917481,12.3519515991211 51.2837409973145,12.3519515991211 51.2837409973145,12.3532104492187 51.2832794189454,12.3522109985353 51.2809104919435,12.3483333587647 51.2786865234376,12.3483333587647 51.2786865234376,12.3482189178466 51.2769126892091,12.3466272354126 51.2758598327637,12.3466272354126 51.2758598327637,12.3481855392456 51.2739257812501,12.3449258804322 51.2742195129395,12.3449258804322 51.2742195129395,12.3441524505616 51.2731819152832,12.3457326889039 51.2725067138672,12.3448677062989 51.2713775634766,12.3408050537111 51.2709197998048,12.3454160690309 51.2696342468262,12.3454160690309 51.2696342468262,12.3452119827271 51.2688179016113,12.3452119827271 51.2688179016113,12.3433647155763 51.2681884765626,12.3419132232667 51.2688522338867,12.3405265808105 51.2686042785645,12.3410005569458 51.2676544189454,12.3374729156494 51.2672805786134,12.335641860962 51.2687950134277,12.3321104049682 51.2685928344727,12.3321104049682 51.2685928344727,12.3319787979127 51.271022796631,12.3272485733033 51.2712631225587,12.3258113861085 51.2689628601074,12.3236961364747 51.269287109375,12.3236961364747 51.269287109375,12.3232860565186 51.2679901123047,12.3224487304688 51.2656631469727,12.322413444519 51.2647743225098,12.3228559494019 51.257106781006,12.3228559494019 51.257106781006,12.3176441192627 51.2569732666017,12.3148975372316 51.2556915283203,12.3161268234253 51.254493713379,12.3161268234253 51.254493713379,12.3127870559693 51.2516288757324,12.3155241012573 51.2508506774902,12.3107089996339 51.2487258911133,12.3158950805664 51.2453269958496,12.3134460449219 51.2428550720215,12.3089857101442 51.2431831359864,12.3089857101442 51.2431831359864,12.3075418472291 51.2432861328124,12.3075418472291 51.2432861328124,12.3025779724121 51.2432289123535,12.3007898330688 51.2422370910644,12.2940788269044 51.2414703369141,12.2910652160645 51.2422409057618,12.2823514938354 51.2444725036622,12.2823514938354 51.2444725036622,12.2830228805543 51.2429237365723,12.2830228805543 51.2429237365723,12.270474433899 51.2417373657228,12.2580795288086 51.2381553649903,12.2575397491455 51.2394218444824,12.2536497116089 51.2385368347169,12.2514343261719 51.24324798584,12.2561931610108 51.2443542480469,12.2561931610108 51.2443542480469,12.2541275024415 51.248462677002,12.2593774795533 51.2503929138185,12.2505836486817 51.2650489807129,12.2473859786988 51.2658348083497,12.2517004013063 51.2672462463379,12.2517004013063 51.2672462463379,12.2520179748536 51.2688255310059,12.2479066848755 51.2780647277833,12.2475233078003 51.2789192199707,12.2475233078003 51.2789192199707,12.2532377243043 51.2797698974609,12.2532377243043 51.2797698974609,12.2522010803224 51.2834472656251,12.2513780593873 51.2836914062501,12.2503414154054 51.2839889526368,12.2499418258667 51.2863235473633,12.2499418258667 51.2863235473633,12.2532005310059 51.2859687805176,12.2532005310059 51.2859687805176,12.2614002227783 51.2857131958008,12.26149559021 51.2844505310059,12.2625246047975 51.283977508545,12.2634048461914 51.2833404541015,12.2635145187378 51.2820892333985,12.2635612487794 51.281421661377,12.2700777053834 51.2814674377442,12.2700777053834 51.2814674377442,12.2805957794189 51.2810745239258,12.2805957794189 51.2810745239258,12.2729606628419 51.2866554260255,12.2715559005738 51.2870712280274,12.2676105499269 51.2882461547853,12.2636690139772 51.2891349792482,12.2625408172609 51.2986640930177,12.2612142562867 51.2985115051269,12.2612142562867 51.2985115051269,12.2505683898926 51.2979049682617,12.2519683837891 51.2992248535156,12.2493953704835 51.3055839538574,12.2493953704835 51.3055839538574,12.2474231719971 51.3050613403321,12.2459716796876 51.3087997436524,12.2440767288208 51.3129959106446,12.2398748397828 51.3161811828614,12.2398748397828 51.3161811828614,12.2432422637939 51.3182716369629,12.2432422637939 51.3182716369629,12.2376270294191 51.3175201416016,12.2369356155397 51.3189888000489,12.2399425506592 51.3194923400878,12.2395601272584 51.3204078674318,12.2368812561036 51.3262977600099,12.2368812561036 51.3262977600099,12.2429676055909 51.3273315429688,12.2427740097046 51.3301849365235,12.2427740097046 51.3301849365235,12.2426891326905 51.3313674926759,12.2449607849122 51.3317909240723,12.2449979782104 51.3304862976075,12.2449979782104 51.3304862976075,12.2477188110353 51.3298873901367,12.2477188110353 51.3298873901367,12.2471685409546 51.3309059143068,12.2492980957031 51.3313674926759,12.2509775161744 51.331729888916,12.2560377120972 51.33256149292,12.2582502365113 51.3325729370117,12.2591037750244 51.3334808349611,12.2593002319337 51.334114074707,12.2593240737916 51.3347282409669,12.2593240737916 51.3347282409669,12.2584934234619 51.3355598449707,12.2584934234619 51.3355598449707,12.2567930221558 51.3361701965333,12.2565946578979 51.3362541198732,12.2565946578979 51.3362541198732,12.2563972473146 51.3363380432129,12.2563972473146 51.3363380432129,12.2561988830568 51.3364028930664,12.256028175354 51.3364601135253,12.256028175354 51.3364601135253,12.2497091293336 51.3384094238282,12.2497091293336 51.3384094238282,12.2497444152831 51.3393325805665,12.2498941421509 51.3402595520021,12.2498941421509 51.3402595520021,12.2498140335083 51.3411865234375,12.2498140335083 51.3411865234375,12.2493467330932 51.3424797058106,12.2483854293823 51.344036102295,12.2483854293823 51.344036102295,12.2473449707032 51.3454093933107,12.2473449707032 51.3454093933107,12.247233390808 51.345500946045,12.2458581924438 51.3467521667482,12.2458581924438 51.3467521667482,12.2448959350586 51.3475074768068,12.2448959350586 51.3475074768068,12.2443790435791 51.3479003906251,12.2442684173583 51.348030090332,12.2441282272339 51.3481216430665,12.2441282272339 51.3481216430665,12.2437896728516 51.3482780456544,12.2437896728516 51.3482780456544,12.2436056137086 51.3483428955079,12.2433490753175 51.3484039306641))0.0010POINT(12.370665952051317 51.34058689165719)
13937POLYGON((15.2503280639648 40.7151756286622,15.2479257583619 40.7186737060548,15.2479257583619 40.7186737060548,15.2431249618531 40.7306632995605,15.2431249618531 40.7306632995605,15.2414016723633 40.7346801757813,15.2430686950684 40.7372093200684,15.2427396774291 40.7476959228517,15.239899635315 40.7513275146486,15.2407379150392 40.7639770507812,15.2392168045044 40.7696647644044,15.2399702072144 40.7748985290527,15.2451419830323 40.778678894043,15.252649307251 40.7875061035157,15.25244140625 40.7884979248048,15.2639484405518 40.7914123535156,15.2639484405518 40.7914123535156,15.2667551040649 40.793743133545,15.2667551040649 40.793743133545,15.2720947265625 40.783805847168,15.2826986312866 40.777400970459,15.295310974121 40.7619018554688,15.3063907623292 40.7546806335449,15.3063907623292 40.7546806335449,15.3027353286744 40.7527618408204,15.2962236404419 40.745491027832,15.2835683822632 40.7386131286622,15.2751140594483 40.7369117736818,15.2719917297363 40.734992980957,15.265139579773 40.730079650879,15.264123916626 40.7274322509766,15.2503280639648 40.7151756286622))0.0006POINT(15.262996335183447 40.755388690579366)
13760POLYGON((14.3570213317871 40.8393287658693,14.3479003906251 40.8482818603516,14.3479003906251 40.8482818603516,14.3502521514892 40.8490867614747,14.3502521514892 40.8490867614747,14.3650541305543 40.8510894775392,14.3650541305543 40.8510894775392,14.3914070129395 40.8370895385743,14.3944597244263 40.8326530456544,14.3944597244263 40.8326530456544,14.3801717758179 40.8386459350587,14.3570213317871 40.8393287658693))0.0006POINT(14.367630264975846 40.84338968450383)
67426POLYGON((9.41648769378662 48.7425689697265,9.40670585632319 48.7355041503906,9.40376377105713 48.7351074218751,9.40368556976318 48.7325782775879,9.39854717254644 48.7265014648439,9.39413642883306 48.7262077331544,9.39413642883306 48.7262077331544,9.39114379882812 48.7232818603517,9.39099407196039 48.7203369140626,9.38860034942627 48.7185859680177,9.38860034942627 48.7185859680177,9.39896011352545 48.7160835266114,9.41257286071789 48.7084350585938,9.41257286071789 48.7084350585938,9.41605281829845 48.7077789306641,9.43279552459717 48.6990547180176,9.44767761230474 48.7000770568849,9.44767761230474 48.7000770568849,9.44850635528564 48.7007255554199,9.44850635528564 48.7007255554199,9.44878387451178 48.7054748535157,9.45244979858398 48.7075080871583,9.44332599639893 48.7108917236329,9.44145202636713 48.712718963623,9.44161605834961 48.714527130127,9.44618701934814 48.7174835205079,9.44148349761957 48.719783782959,9.44179725646978 48.721580505371,9.44307231903076 48.7225799560547,9.43815231323242 48.7256813049316,9.43815231323242 48.7256813049316,9.43090343475342 48.7270698547363,9.42647171020519 48.7294998168946,9.41934204101557 48.7364997863771,9.42016315460216 48.739315032959,9.41656017303467 48.739315032959,9.41619491577143 48.7398338317871,9.41845607757574 48.7402877807617,9.41648769378662 48.7425689697265))0.0006POINT(9.422807567998001 48.72059450651475)
12963POLYGON((15.9407501220703 40.1989707946778,15.9378776550294 40.1994400024415,15.9295873641968 40.2055816650391,15.9289836883545 40.2131423950195,15.9313802719116 40.2182159423829,15.9313774108887 40.2205314636231,15.9295053482057 40.2297973632813,15.9266157150269 40.2350273132325,15.9280242919922 40.2478179931641,15.9331703186036 40.2534713745118,15.9395952224731 40.2581405639648,15.9431324005127 40.2631912231446,15.9431324005127 40.2631912231446,15.9366569519042 40.2659912109375,15.9344205856324 40.2684097290038,15.9208230972291 40.2646903991699,15.9081773757935 40.2628021240235,15.8913917541505 40.2641067504883,15.8835620880128 40.2635192871094,15.8835620880128 40.2635192871094,15.880467414856 40.2595481872559,15.8797578811646 40.2567291259767,15.8820333480835 40.2518043518067,15.8850688934326 40.2516098022462,15.8851413726807 40.2493705749513,15.8818283081055 40.2421531677247,15.8766012191774 40.2370567321777,15.8765020370483 40.2331466674805,15.8798046112062 40.226692199707,15.8864583969117 40.2267036437989,15.8947048187257 40.2238121032716,15.8974723815919 40.220573425293,15.9043750762939 40.2041168212892,15.9047756195069 40.1980133056642,15.903959274292 40.1949081420899,15.9133062362671 40.1867523193361,15.918360710144 40.1800575256348,15.9180002212525 40.1776733398438,15.9180002212525 40.1776733398438,15.9262485504152 40.1814117431642,15.9322328567506 40.1860466003419,15.934042930603 40.1938629150391,15.9407501220703 40.1989707946778))0.0006POINT(15.911449250720844 40.22903033665253)