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.

Spaltenname	Datentyp	Mögliche Werte	Beschreibung
id_ort	int(10) unsigned	beliebig	Fremdschlü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"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die 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"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
55742	POLYGON((5.42383766174328 45.1927185058594,5.41047859191906 45.2022781372071,5.40591764450073 45.2034835815429,5.39856529235851 45.1990394592285,5.38362693786627 45.2075653076172,5.37406444549572 45.2074546813965,5.37406444549572 45.2074546813965,5.37316703796392 45.2073287963867,5.37316703796392 45.2073287963867,5.37142848968512 45.2009010314941,5.37142848968512 45.2009010314941,5.3746333122254 45.1944618225098,5.38848733901983 45.1928062438965,5.38428640365595 45.1725997924805,5.388171195984 45.1705284118653,5.388171195984 45.1705284118653,5.38914632797247 45.1709938049316,5.38914632797247 45.1709938049316,5.39635610580444 45.1757850646973,5.41487312316906 45.1807441711426,5.42383766174328 45.1927185058594))	0.0006	POINT(5.388650870323249 45.19179477691652)
64474	POLYGON((10.8376407623292 49.1977500915527,10.8277463912965 49.195972442627,10.8251266479493 49.1962661743165,10.8235521316529 49.194751739502,10.8200683593751 49.1992340087891,10.8185424804689 49.1990203857422,10.8183135986329 49.1975479125977,10.8164548873902 49.1967430114747,10.8053922653199 49.1988677978516,10.8029851913453 49.1980209350587,10.7960691452027 49.1983795166017,10.7942895889283 49.1969642639161,10.7930593490601 49.1977157592773,10.7948236465455 49.1990242004395,10.7940711975098 49.2016334533691,10.792781829834 49.2017173767091,10.7875652313234 49.2016601562499,10.7824440002441 49.1991882324218,10.7813787460327 49.1977882385254,10.778681755066 49.1965827941896,10.7779989242554 49.1972045898438,10.7842311859131 49.2019920349121,10.7813625335693 49.2020263671876,10.7815446853638 49.2027168273925,10.7842378616334 49.2031707763673,10.7842378616334 49.2031707763673,10.7772331237794 49.2049140930176,10.7746362686158 49.2043800354005,10.7753038406373 49.2036437988282,10.7713489532471 49.2033920288086,10.7685089111329 49.2011222839356,10.765519142151 49.2015419006349,10.7628631591796 49.2004165649415,10.7629642486572 49.2012786865234,10.7612342834474 49.2011947631837,10.7596950531006 49.2034378051758,10.7514362335206 49.1991271972657,10.7495584487915 49.1970443725587,10.7403192520142 49.1966781616212,10.7405881881715 49.1956367492677,10.7367448806763 49.1927490234375,10.7374572753907 49.1896781921387,10.7345752716065 49.1867866516114,10.7330398559571 49.1870613098146,10.7310705184937 49.1857795715332,10.7310705184937 49.1857795715332,10.7354278564453 49.1759223937989,10.7330932617189 49.1727409362794,10.7287330627442 49.1701583862306,10.7300710678101 49.1690254211426,10.733338356018 49.172191619873,10.7366218566896 49.1704750061035,10.7329616546631 49.1681632995607,10.7352685928345 49.1657752990723,10.7385473251343 49.165813446045,10.7382526397706 49.1646537780762,10.736029624939 49.164306640625,10.7377395629883 49.1634941101075,10.7361173629761 49.162696838379,10.7368917465211 49.1610755920411,10.7349309921265 49.1612968444825,10.7340755462646 49.1601562500001,10.7339878082275 49.1591300964356,10.7363882064819 49.1591262817382,10.7363882064819 49.1591262817382,10.7388963699341 49.158805847168,10.7433414459229 49.1564102172853,10.7490739822387 49.1591529846192,10.7478380203248 49.1613578796387,10.7492370605469 49.1614532470703,10.7494325637819 49.1648445129395,10.7620868682862 49.1637268066406,10.7627525329591 49.1625289916993,10.7616453170776 49.1608200073243,10.7647790908815 49.156967163086,10.7696237564087 49.1550483703613,10.7682285308839 49.1532592773438,10.7717018127443 49.1514282226563,10.7712955474855 49.1499252319337,10.7729082107543 49.149040222168,10.7683019638062 49.1466941833496,10.7723121643066 49.138210296631,10.7755041122437 49.1377449035645,10.7773313522339 49.1384620666504,10.7780084609985 49.1370468139648,10.77965259552 49.1367988586426,10.7798671722412 49.1361045837403,10.7769775390624 49.1340713500977,10.7834367752075 49.1322212219239,10.7826499938965 49.1314125061035,10.7863311767578 49.1304244995118,10.7860670089722 49.1297836303711,10.7875337600709 49.1296920776368,10.7903480529786 49.1327056884766,10.7917776107789 49.1289329528809,10.8025350570679 49.1263885498047,10.8032274246215 49.1231651306153,10.8080434799194 49.1219367980958,10.8074808120729 49.1196098327637,10.8115987777711 49.1185913085938,10.8193311691285 49.119197845459,10.8193311691285 49.119197845459,10.8201503753663 49.1207962036132,10.8236198425292 49.123161315918,10.8236846923829 49.1246910095216,10.8272781372071 49.1250114440919,10.828984260559 49.1239547729493,10.8328332901002 49.1237030029297,10.8438386917115 49.1275978088379,10.8437089920044 49.1286506652833,10.8470964431762 49.1289291381837,10.8318738937378 49.1375846862794,10.833483695984 49.1385307312012,10.8410215377808 49.1343078613282,10.8472013473512 49.1339111328126,10.8472013473512 49.1339111328126,10.8535079956055 49.1341247558595,10.8554506301881 49.1355133056641,10.8542194366456 49.1358222961426,10.8540410995483 49.1377143859863,10.8620538711549 49.1385498046875,10.8618125915527 49.1392974853515,10.8536520004272 49.1407012939454,10.8509769439698 49.1404304504395,10.8512229919435 49.1422653198243,10.8533277511598 49.1431846618653,10.8537578582765 49.1447525024415,10.862416267395 49.1466827392579,10.8617897033691 49.1485710144043,10.8546934127807 49.1499786376953,10.8515691757202 49.148406982422,10.8473873138428 49.1483573913574,10.8474750518799 49.1491584777832,10.8527383804321 49.150707244873,10.8516492843628 49.1518707275392,10.8395843505859 49.1521606445313,10.8346881866455 49.1540069580078,10.8375282287599 49.1561775207519,10.8409461975099 49.1566429138184,10.840765953064 49.1583175659181,10.8423213958741 49.1591033935548,10.8362703323364 49.1586990356446,10.8354310989381 49.1602210998535,10.8373746871948 49.1616744995117,10.8306980133057 49.164031982422,10.8315010070801 49.1651191711427,10.8295040130616 49.1660232543945,10.82825756073 49.1642723083497,10.8317298889161 49.1625709533692,10.8235425949098 49.1626586914063,10.8241195678711 49.1648254394532,10.8273162841798 49.167064666748,10.8236322402955 49.1681556701661,10.8232736587525 49.165512084961,10.8204212188721 49.1656455993653,10.8195953369141 49.1673011779785,10.8160495758057 49.1663055419922,10.8128547668458 49.1685523986818,10.8169679641723 49.1723632812501,10.8206682205201 49.1718215942383,10.8218793869018 49.1725044250489,10.8222627639772 49.1744270324708,10.8253707885743 49.1775856018066,10.8287591934204 49.1774864196778,10.8286199569703 49.1791839599609,10.8251504898072 49.1794471740722,10.8335285186768 49.1866188049317,10.8419647216797 49.188087463379,10.8419647216797 49.188087463379,10.8410749435425 49.1903648376465,10.8460407257081 49.1919403076171,10.8416786193848 49.1941680908204,10.8417692184448 49.1954078674318,10.8375415802002 49.1953239440918,10.8376407623292 49.1977500915527))	0.0006	POINT(10.798353376059735 49.164919162618716)
66002	POLYGON((11.3324747085571 48.7935791015626,11.3297853469849 48.7963638305664,11.3251543045044 48.7962150573732,11.3252573013306 48.797435760498,11.3210983276368 48.7978363037111,11.3148946762085 48.8005447387695,11.3178806304932 48.8015899658204,11.3105087280273 48.8044509887696,11.3121271133423 48.8076057434083,11.3107995986939 48.8080558776857,11.3113727569581 48.8113708496095,11.3080253601075 48.812328338623,11.3080615997314 48.8161697387696,11.3058061599733 48.81644821167,11.3062620162964 48.8187828063965,11.3020792007447 48.818962097168,11.3019886016846 48.8203315734863,11.2978229522706 48.8204803466797,11.2978792190552 48.8222236633301,11.2955799102784 48.8223762512208,11.2954273223878 48.8271903991699,11.2994899749756 48.8265571594239,11.3024644851685 48.8305206298828,11.2968072891235 48.83353805542,11.2931442260742 48.8341827392578,11.2928876876832 48.835563659668,11.290205001831 48.8368682861329,11.2799243927003 48.8409156799316,11.2750520706177 48.8410110473633,11.2750339508056 48.8432884216309,11.2706298828125 48.8457183837892,11.2710676193237 48.8466606140137,11.2741394042969 48.8466644287111,11.277219772339 48.8485412597657,11.2787895202637 48.8533172607422,11.2772006988525 48.8554687500001,11.2818908691406 48.8585968017578,11.2818908691406 48.8585968017578,11.2858572006226 48.8585357666015,11.2858572006226 48.8585357666015,11.2923030853271 48.8571739196778,11.2949552536011 48.8557739257813,11.294665336609 48.8538894653321,11.2993631362916 48.8536186218263,11.2988576889038 48.8493881225586,11.2939605712891 48.8491096496582,11.2915840148926 48.8479919433595,11.2954502105712 48.840160369873,11.298285484314 48.8393783569337,11.3053321838379 48.8404235839844,11.3109550476074 48.840171813965,11.3114538192749 48.8390541076661,11.319001197815 48.8407516479493,11.3192319869996 48.8416061401367,11.3223037719726 48.8416900634767,11.3251485824585 48.8407592773439,11.3294296264649 48.8408737182618,11.33002948761 48.8376998901368,11.3336849212646 48.8379440307617,11.3342351913453 48.8366622924805,11.3370351791382 48.8370552062989,11.3370351791382 48.8370552062989,11.3365812301636 48.8337440490723,11.3413877487184 48.8335151672363,11.3414812088012 48.8310317993165,11.344449043274 48.8309364318849,11.3446569442749 48.8172416687011,11.3425617218017 48.8169250488282,11.3425207138062 48.8148155212402,11.3392677307129 48.8149147033693,11.3380632400512 48.8097953796386,11.340763092041 48.8084030151367,11.3373870849609 48.8069496154785,11.3378858566284 48.8019027709961,11.3417053222657 48.8007316589356,11.3417091369629 48.7986450195312,11.338641166687 48.7991065979005,11.3324747085571 48.7935791015626))	0.0006	POINT(11.31043117077322 48.829094973477474)
62071	POLYGON((10.1706047058105 51.8131408691407,10.1691265106201 51.8127861022949,10.1697959899902 51.8082618713379,10.1649923324586 51.8046226501465,10.1645650863647 51.8015365600587,10.1665897369385 51.8004531860352,10.1651706695557 51.8001060485841,10.1619710922242 51.7951965332032,10.1537141799927 51.7935447692872,10.1537141799927 51.7935447692872,10.1535835266113 51.7916374206544,10.1582441329957 51.7880516052247,10.1565837860108 51.7862625122071,10.1532392501832 51.7860565185547,10.1531801223756 51.7835960388184,10.1566877365113 51.7828598022462,10.1599435806276 51.7793922424316,10.1570968627929 51.7778091430665,10.1539545059205 51.7789421081544,10.1522874832153 51.777156829834,10.1521139144897 51.7733230590821,10.1487121582031 51.7649040222168,10.1419124603272 51.7575798034669,10.14594745636 51.7550163269044,10.1498107910157 51.7540397644043,10.1498107910157 51.7540397644043,10.1698169708253 51.7535591125489,10.1721706390381 51.7527732849122,10.1726312637329 51.7512435913086,10.1733322143555 51.7521629333497,10.1780319213868 51.7514038085937,10.1788921356202 51.7534332275391,10.1811809539795 51.7535781860352,10.1928482055665 51.7516708374024,10.1932525634766 51.753101348877,10.1973028182985 51.7529678344727,10.1973438262941 51.7537956237792,10.2061014175416 51.7516479492188,10.2051486968995 51.7566986083986,10.2059631347656 51.7585182189943,10.2114934921265 51.7607879638672,10.2140455245972 51.7618141174316,10.2345809936523 51.7631111145021,10.2345809936523 51.7631111145021,10.232837677002 51.7653884887695,10.2372474670411 51.7657623291016,10.2337312698364 51.7670936584474,10.2347469329834 51.771884918213,10.2371196746827 51.7728881835938,10.2433977127076 51.7730712890626,10.2435312271118 51.777687072754,10.229235649109 51.7770881652832,10.2315759658813 51.7785224914551,10.2304582595825 51.7811927795411,10.2310247421266 51.7834434509278,10.2276496887208 51.7849273681642,10.2317905426025 51.7878761291505,10.2343330383301 51.793914794922,10.2388181686401 51.7951126098633,10.2415246963502 51.7989387512208,10.2405462265015 51.8001441955566,10.2442646026612 51.8020057678224,10.2444305419923 51.8034515380861,10.2579507827759 51.8067665100099,10.2611274719239 51.8042449951171,10.2612829208374 51.8078422546387,10.2634677886963 51.8120040893556,10.2564115524292 51.8097038269043,10.2503414154053 51.8104553222657,10.2483711242675 51.8125457763672,10.2557573318482 51.8153228759766,10.254225730896 51.8221740722656,10.254225730896 51.8221740722656,10.2504253387452 51.8243370056153,10.2461442947388 51.8240661621095,10.2473869323732 51.8251304626464,10.245581626892 51.826099395752,10.2462520599366 51.8281860351563,10.2453222274781 51.8309173583986,10.2411127090454 51.8331756591798,10.2381038665771 51.8313255310059,10.2362384796143 51.8324928283692,10.2315492630006 51.8324546813965,10.2275753021241 51.8291435241699,10.2233180999756 51.8297348022462,10.2207221984863 51.8268585205079,10.2222213745118 51.8262329101562,10.2191352844239 51.8228607177735,10.2162065505981 51.8218650817872,10.2179880142212 51.819278717041,10.2204580307007 51.8178443908693,10.219765663147 51.8172111511231,10.2177152633668 51.818328857422,10.2151279449462 51.8161926269532,10.2119226455688 51.8162994384766,10.2065944671632 51.8214378356934,10.2026624679566 51.8268241882325,10.2026624679566 51.8268241882325,10.2000236511231 51.8241195678711,10.1974182128907 51.8229904174805,10.1965370178223 51.8178863525391,10.1980781555176 51.8153610229492,10.1975841522217 51.8133201599121,10.1830015182496 51.8086204528809,10.1713533401489 51.8119087219239,10.1706047058105 51.8131408691407))	0.0006	POINT(10.206377955845463 51.79383043561665)
1400426	POLYGON((-5.63360786437983 41.0478858947754,-5.6393609046936 41.0441627502443,-5.63136577606201 41.0289421081544,-5.63141822814936 41.018295288086,-5.64336299896235 41.0175895690919,-5.64571285247803 41.0192108154297,-5.65052604675293 41.01708984375,-5.65305614471436 41.0190658569337,-5.65590286254883 41.0195083618165,-5.65672779083252 41.0183868408203,-5.66336011886597 41.0313224792481,-5.65992307662964 41.0351867675781,-5.66292190551752 41.038143157959,-5.66558885574341 41.036449432373,-5.67429304122925 41.04398727417,-5.67195701599115 41.044776916504,-5.67501783370966 41.0477752685547,-5.67159509658813 41.0484771728517,-5.66697502136225 41.0468902587891,-5.66786098480219 41.0526351928712,-5.67331981658924 41.0549049377441,-5.67422723770136 41.0567474365234,-5.672529220581 41.0591735839845,-5.66286993026728 41.0577697753907,-5.6611971855163 41.0590858459474,-5.65791320800781 41.0588111877442,-5.65572690963745 41.0541496276855,-5.65151309967035 41.0546798706055,-5.65071296691895 41.0528602600098,-5.64287281036377 41.0531311035156,-5.63908720016474 41.0548858642579,-5.63840103149414 41.0523338317872,-5.63444519042969 41.0509719848634,-5.63360786437983 41.0478858947754))	0.0006	POINT(-5.655616673556215 41.042281410910924)
1396556	POLYGON((-3.54916310310352 38.7143325805664,-3.55997109413147 38.704917907715,-3.57427501678461 38.6814041137696,-3.58860993385309 38.6672897338868,-3.59213590621948 38.6712646484376,-3.59304594993591 38.6796417236328,-3.59039306640619 38.6843490600585,-3.58295607566828 38.6858978271484,-3.58944702148432 38.6922645568847,-3.59783911705017 38.6946678161622,-3.62239408493042 38.7060356140137,-3.61760592460627 38.7121887207032,-3.61529707908625 38.7192115783691,-3.6240758895874 38.7209434509277,-3.64061093330383 38.731918334961,-3.63362288475025 38.7338676452637,-3.63169693946833 38.7387084960937,-3.6318678855896 38.7409782409669,-3.64231610298157 38.7423896789552,-3.63906407356257 38.7519302368164,-3.62705302238464 38.7546997070314,-3.63300108909607 38.7651481628418,-3.63494491577143 38.7741584777832,-3.64109706878662 38.778232574463,-3.65822005271906 38.8012809753419,-3.66771197319031 38.8079032897949,-3.67425394058228 38.8225173950196,-3.65427708625793 38.8247413635254,-3.64953207969666 38.8287963867188,-3.63108706474304 38.8311500549316,-3.61824607849121 38.8410224914552,-3.60612106323242 38.8461608886719,-3.58676004409784 38.847297668457,-3.57808995246887 38.8497428894044,-3.57003498077387 38.8569946289063,-3.55957198143005 38.8600387573242,-3.55967688560486 38.865894317627,-3.56626796722406 38.8759269714357,-3.57413792610163 38.881160736084,-3.58123707771301 38.883773803711,-3.58074092864985 38.8934097290039,-3.57493805885315 38.8918952941895,-3.55499792098999 38.9061698913575,-3.53502798080439 38.8791847229003,-3.52987694740295 38.8609771728515,-3.5211460590362 38.8488960266113,-3.51744389533997 38.8486251831055,-3.51184511184687 38.8521003723144,-3.51396203041071 38.845043182373,-3.50752305984497 38.829345703125,-3.50897288322449 38.8193817138673,-3.50783801078791 38.8150825500489,-3.51616811752308 38.7836723327637,-3.51372909545893 38.7742881774902,-3.51453900337219 38.7666778564454,-3.52192091941828 38.7641220092773,-3.52490592002869 38.7614326477051,-3.52344298362726 38.7599601745607,-3.52487897872919 38.7562599182129,-3.53382897377003 38.7512550354004,-3.52963089942932 38.7497863769531,-3.5320611000061 38.7468795776368,-3.53500103950489 38.7461204528809,-3.53277802467346 38.7383422851563,-3.5341870784759 38.7267303466797,-3.53650903701771 38.723430633545,-3.54916310310352 38.7143325805664))	0.0006	POINT(-3.5776606725923616 38.78196837685328)
65669	MULTIPOLYGON(((11.7367906570435 48.8849716186524,11.7390308380128 48.8898773193359,11.7317485809326 48.8906631469727,11.7296190261842 48.8920860290528,11.7225046157837 48.8916511535645,11.7197227478027 48.8939743041993,11.7169790267945 48.898765563965,11.7191963195801 48.9034156799318,11.7189502716064 48.9060897827148,11.7205047607423 48.9120292663574,11.7230434417725 48.9164352416993,11.7253799438477 48.924861907959,11.7284955978394 48.9300842285156,11.7284955978394 48.9300842285156,11.7272129058838 48.9344177246095,11.7284135818482 48.9349060058594,11.7415161132814 48.9352569580078,11.7448797225953 48.9375953674316,11.7514638900757 48.9355850219726,11.7489156723024 48.9378890991211,11.7490825653077 48.939598083496,11.7549610137939 48.9386444091796,11.7663354873658 48.9388351440429,11.7663354873658 48.9388351440429,11.7683238983155 48.9386253356934,11.7680854797364 48.9368476867676,11.7644624710084 48.9356193542481,11.7746801376344 48.9352607727052,11.779522895813 48.9314804077149,11.779522895813 48.9314804077149,11.781322479248 48.9283103942871,11.7762165069581 48.9236373901367,11.7762165069581 48.9236373901367,11.7671470642091 48.92391204834,11.762448310852 48.9164924621583,11.7541551589966 48.9145698547363,11.7540445327759 48.909236907959,11.7500715255738 48.9065208435059,11.7523260116578 48.9066047668458,11.7513895034791 48.9057579040527,11.751989364624 48.9051933288574,11.7552003860473 48.9053764343262,11.7564182281495 48.9044609069824,11.7578058242798 48.9058837890625,11.759578704834 48.9052963256836,11.7605075836182 48.903263092041,11.7605075836182 48.903263092041,11.7604398727418 48.9011611938477,11.762448310852 48.8996963500978,11.7649221420289 48.8957023620606,11.760823249817 48.8944091796875,11.7553148269654 48.8992729187012,11.7518863677978 48.898063659668,11.7572460174561 48.8942871093751,11.7667675018311 48.8911209106446,11.7658443450929 48.8871116638184,11.7662906646729 48.8838310241699,11.7367906570435 48.8849716186524)),((11.7545013427734 48.9205474853516,11.7523603439332 48.9216613769531,11.7509479522705 48.9214172363282,11.7503261566162 48.9200820922853,11.7524166107178 48.9196166992188,11.7545013427734 48.9205474853516)),((11.7903299331666 48.926139831543,11.7843971252441 48.9232749938966,11.7762165069581 48.9236373901367,11.7762165069581 48.9236373901367,11.7803678512573 48.9180068969728,11.7802019119263 48.9137802124024,11.7783260345459 48.9109840393067,11.7811908721924 48.9104309082031,11.7811908721924 48.9104309082031,11.7936201095582 48.9062385559083,11.7981414794923 48.9033432006837,11.7981414794923 48.9033432006837,11.7996263504028 48.9047927856446,11.8035306930543 48.9048461914064,11.8047027587891 48.9068374633789,11.8119010925294 48.9086074829102,11.8118114471437 48.9073028564454,11.8141918182373 48.9045333862305,11.8142080307007 48.9011039733888,11.8171491622925 48.8993530273437,11.8195438385011 48.9006271362306,11.8218612670898 48.9000358581543,11.8254537582397 48.9066848754883,11.838264465332 48.907585144043,11.8410139083862 48.9088096618652,11.8400888442994 48.9108810424805,11.8381767272949 48.9108238220215,11.8355293273926 48.9128074645996,11.8272705078126 48.9142265319825,11.8217887878418 48.913402557373,11.8215160369874 48.9184265136718,11.8229665756226 48.920539855957,11.8229665756226 48.920539855957,11.8218116760254 48.9222450256348,11.8146781921386 48.9229393005371,11.8087787628174 48.9193115234376,11.8013353347779 48.9196434020997,11.7978248596192 48.9185218811035,11.7951259613037 48.9196968078613,11.7944355010986 48.9224395751953,11.7903299331666 48.926139831543)))	0.0006	POINT(11.766709322383637 48.91340001726013)
49397	POLYGON((3.47764754295355 48.9778861999512,3.46738600730902 48.9776268005372,3.44407653808599 48.9707565307618,3.44407653808599 48.9707565307618,3.44216132164007 48.9736137390138,3.44216132164007 48.9736137390138,3.43370938301092 48.9871330261232,3.43370938301092 48.9871330261232,3.42784237861645 48.9964065551759,3.42784237861645 48.9964065551759,3.40883827209478 49.0230903625488,3.4109263420105 49.0260696411133,3.4109263420105 49.0260696411133,3.41724729537975 49.0299415588379,3.42396688461304 49.0255737304689,3.43793296813971 49.0262145996094,3.43793296813971 49.0262145996094,3.44974064826971 49.0191764831544,3.44974064826971 49.0191764831544,3.46062469482422 49.0085334777833,3.46947479248053 49.0062141418458,3.46947479248053 49.0062141418458,3.4676611423493 48.9960517883301,3.48873519897461 48.9816894531251,3.48873519897461 48.9816894531251,3.47764754295355 48.9778861999512))	0.0006	POINT(3.4453028392792255 49.00053009033209)
66838	POLYGON((8.61046695709229 48.2136917114258,8.61408424377453 48.2161903381349,8.61371421813971 48.2181282043458,8.61570262908936 48.2196006774903,8.61499977111828 48.2214317321777,8.61242866516113 48.2232131958008,8.60266399383556 48.2220115661621,8.60200214385986 48.2227630615236,8.60260391235357 48.2235755920411,8.60431480407715 48.2231750488282,8.610520362854 48.2248878479004,8.61265182495117 48.2265090942383,8.61354541778576 48.2354736328126,8.61452484130865 48.236972808838,8.61781120300287 48.2386932373047,8.62081241607666 48.2369537353516,8.62740325927729 48.2363929748536,8.62964534759533 48.2351188659667,8.63619232177734 48.2374877929689,8.63733196258551 48.2393836975098,8.63664436340332 48.2415237426758,8.64236545562744 48.2419166564942,8.64204216003412 48.2451133728028,8.63739490509045 48.2472915649414,8.63537883758551 48.2507553100587,8.64599323272716 48.2538566589355,8.64374160766602 48.258918762207,8.65050983428961 48.2608757019043,8.65043926239019 48.2616767883301,8.65394878387463 48.2625350952148,8.65948295593267 48.2665290832521,8.66621685028076 48.2687835693359,8.66621685028076 48.2687835693359,8.6730308532716 48.271656036377,8.67857837677008 48.2775306701661,8.68405914306635 48.2787017822265,8.6835241317749 48.2807884216309,8.6782369613648 48.2841911315918,8.67162895202637 48.283260345459,8.66820335388184 48.2840576171875,8.65956783294689 48.2833023071289,8.65664672851562 48.2842979431153,8.65667152404785 48.2854499816896,8.64775466918945 48.2889137268066,8.64965915679937 48.2895240783691,8.64884567260754 48.293212890625,8.64884567260754 48.293212890625,8.64077758789062 48.2923774719238,8.63968181610102 48.2914237976074,8.64093208312994 48.2893753051757,8.63601493835455 48.2886276245117,8.63232707977301 48.2863807678224,8.61935138702393 48.2845840454103,8.62140083312988 48.2824325561524,8.62147617340099 48.2804756164552,8.6195821762085 48.2785720825195,8.62026691436762 48.2782783508301,8.61960315704351 48.2773208618165,8.61849975585938 48.277988433838,8.61753940582275 48.2773780822754,8.61129283905029 48.2681427001954,8.60742664337164 48.2664031982422,8.60616970062267 48.2640876770021,8.58795452117931 48.2607421875001,8.57854366302485 48.2623672485352,8.57249355316162 48.2648429870607,8.56836891174316 48.2649078369142,8.56836891174316 48.2649078369142,8.55819988250744 48.2635307312011,8.55568599700928 48.2623977661133,8.55267429351807 48.2551307678224,8.55473518371593 48.2554473876953,8.5636072158814 48.2490386962891,8.57558250427252 48.2499427795411,8.57580947875971 48.2476081848145,8.57735633850098 48.2452239990235,8.57960033416742 48.2456855773926,8.58093833923346 48.242473602295,8.58372211456299 48.2401390075684,8.58186626434338 48.2376594543457,8.58744812011724 48.2339973449707,8.5912971496582 48.2326354980469,8.60048675537121 48.2330703735353,8.60651302337652 48.2307472229004,8.60696887969971 48.2297401428224,8.60562705993652 48.2285728454591,8.59921741485601 48.2283210754395,8.59670829772949 48.2263679504395,8.59400177001964 48.2260513305663,8.59412860870373 48.2248764038087,8.5926132202149 48.2236824035645,8.5943489074707 48.2229995727538,8.59698390960699 48.2178573608398,8.59657669067394 48.2169075012208,8.59657669067394 48.2169075012208,8.60250473022455 48.218807220459,8.60818481445312 48.2170333862306,8.60910987854015 48.2139739990235,8.61046695709229 48.2136917114258))	0.0006	POINT(8.617512187179289 48.25200773745169)
27118	POLYGON((-1.60125350952137 49.5989646911622,-1.64572405815125 49.615306854248,-1.64572405815125 49.615306854248,-1.66448879241943 49.608829498291,-1.66448879241943 49.608829498291,-1.68029141426075 49.5958938598634,-1.67469501495356 49.5834274291993,-1.66497194766998 49.5811080932618,-1.66497194766998 49.5811080932618,-1.65992045402527 49.5806732177734,-1.62639379501343 49.5948562622071,-1.62639379501343 49.5948562622071,-1.60125350952137 49.5989646911622))	0.0006	POINT(-1.6516097982724276 49.5965967178345)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point