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
21909	POLYGON((-0.490688771009445 45.1979408264161,-0.518257915973606 45.1994819641114,-0.539718627929574 45.2057876586914,-0.539718627929574 45.2057876586914,-0.54443371295929 45.2085571289063,-0.54443371295929 45.2085571289063,-0.552892088890076 45.2134361267091,-0.552892088890076 45.2134361267091,-0.554125547409001 45.2259864807129,-0.563537418842259 45.2367477416993,-0.563537418842259 45.2367477416993,-0.551174104213658 45.2543487548829,-0.551174104213658 45.2543487548829,-0.539789795875492 45.2607574462891,-0.487838536500931 45.2536926269531,-0.487838536500931 45.2536926269531,-0.47968998551363 45.2496948242188,-0.475582718849182 45.2360038757324,-0.481563240289631 45.2265701293945,-0.477875858545247 45.2165298461915,-0.480848908424321 45.206340789795,-0.476030051708165 45.2004165649415,-0.476030051708165 45.2004165649415,-0.490688771009445 45.1979408264161))	0.0006	POINT(-0.5186813836511939 45.2245773647143)
180324	POLYGON((10.78469202231554 48.27660468313971,10.544926397315521 48.00011934962634,10.065395147315485 48.00011934962634,9.825629522315467 48.27660468313971,10.065395147315485 48.55159557269398,10.544926397315521 48.55159557269398,10.78469202231554 48.27660468313971))	-1.0000	POINT(10.305160772315503 48.27610653515334)
15862	POLYGON((9.38452816009527 45.7725753784181,9.38502025604259 45.7693328857423,9.39460372924816 45.7606620788575,9.40107154846186 45.7588844299317,9.40107154846186 45.7588844299317,9.41033077240002 45.7502021789552,9.41033077240002 45.7502021789552,9.41023063659674 45.7472038269043,9.40422916412359 45.7455406188965,9.40543365478516 45.7468338012696,9.40127658843994 45.7498283386232,9.39792633056652 45.7504806518556,9.39668369293213 45.7492675781251,9.39668369293213 45.7492675781251,9.36422729492188 45.7559204101563,9.35826873779308 45.7531471252441,9.35826873779308 45.7531471252441,9.35401439666748 45.75931930542,9.35297870635992 45.7624435424805,9.35608768463135 45.7680702209473,9.35608768463135 45.7680702209473,9.35949516296392 45.7738990783691,9.35949516296392 45.7738990783691,9.37210273742676 45.7801856994629,9.37210273742676 45.7801856994629,9.38452816009527 45.7725753784181))	0.0006	POINT(9.38250198364262 45.7594981384278)
56550	POLYGON((4.74390125274664 45.7556190490723,4.72535610198975 45.7522010803223,4.71604394912725 45.753963470459,4.71604394912725 45.753963470459,4.70885419845581 45.7502899169923,4.71196985244745 45.7354164123536,4.71196985244745 45.7354164123536,4.7275562286377 45.73779296875,4.7275562286377 45.73779296875,4.75233793258673 45.7502174377441,4.75233793258673 45.7502174377441,4.74413633346563 45.7524719238281,4.74390125274664 45.7556190490723))	0.0006	POINT(4.728171984354674 45.747113545735694)
55968	POLYGON((4.92680883407587 45.3746643066407,4.93583583831793 45.3729591369629,4.93857955932623 45.3666152954102,4.94380474090588 45.3471946716308,4.93916463851929 45.3416099548341,4.93916463851929 45.3416099548341,4.95756816864014 45.3452072143555,4.95756816864014 45.3452072143555,4.960518360138 45.3542633056641,4.97299528121954 45.3671035766603,4.97299528121954 45.3671035766603,4.96496629714977 45.3999214172364,4.96601247787476 45.4096145629884,4.96601247787476 45.4096145629884,4.96359205245977 45.4069824218751,4.94184064865118 45.405143737793,4.94184064865118 45.405143737793,4.931396484375 45.3985900878907,4.92680883407587 45.3746643066407))	0.0006	POINT(4.951148033142127 45.37547492980964)
62180	POLYGON((9.34816932678228 52.7148208618164,9.33160781860357 52.7150573730469,9.32213878631586 52.7208900451661,9.32398128509521 52.7223472595214,9.33025169372559 52.7238464355469,9.3505067825318 52.7258377075196,9.34483623504633 52.7384834289551,9.33758068084711 52.739330291748,9.33633518219006 52.7382583618165,9.33197593688965 52.7383308410646,9.33481407165527 52.7394599914552,9.33132362365723 52.7410202026368,9.33836746215815 52.744426727295,9.3401460647583 52.749526977539,9.34183692932135 52.7506561279298,9.34119129180914 52.7523727416993,9.33883094787603 52.7538909912111,9.33348655700684 52.7542686462403,9.32855510711676 52.7583847045899,9.32647609710693 52.7568893432618,9.32378005981451 52.7580070495605,9.31884288787853 52.7578392028809,9.31722164154064 52.7590141296387,9.31722164154064 52.7590141296387,9.31605148315424 52.7583465576172,9.30493545532238 52.7638244628906,9.30493545532238 52.7638244628906,9.30271244049078 52.7648124694825,9.30271244049078 52.7648124694825,9.30065250396734 52.7605590820314,9.30065250396734 52.7605590820314,9.30012512207026 52.7597007751466,9.3012895584107 52.7577781677247,9.30413532257086 52.7535057067872,9.30602550506597 52.7531929016114,9.30638122558605 52.7516250610351,9.30386257171642 52.7505073547364,9.30970478057867 52.7328834533691,9.3063898086549 52.7307815551759,9.30829620361339 52.7283744812012,9.3074769973756 52.7267570495605,9.3074769973756 52.7267570495605,9.30769920349115 52.7257766723633,9.30602455139166 52.7239494323731,9.3013534545899 52.7238960266113,9.3007221221925 52.7229232788087,9.30560207366955 52.7219543457032,9.30484771728527 52.7182235717775,9.30270767211908 52.7161140441895,9.28699684143078 52.7204055786133,9.29145336151123 52.7236862182618,9.29638671875006 52.7238540649415,9.29968738555908 52.7264328002931,9.29968738555908 52.7264328002931,9.29570579528809 52.7268257141114,9.29498767852789 52.7292175292969,9.29677581787115 52.7341384887695,9.29045963287354 52.7343139648438,9.2812929153443 52.7387695312501,9.2812929153443 52.7387695312501,9.28166770935064 52.7342834472656,9.2801246643067 52.734359741211,9.27926063537598 52.7324638366699,9.28172302246099 52.7312736511232,9.27750205993658 52.7265434265136,9.27145957946772 52.7283821105958,9.26980876922613 52.7264595031739,9.26702308654785 52.7267227172852,9.26690578460688 52.7275505065918,9.2645778656007 52.7283821105958,9.26215171813965 52.72855758667,9.26067066192633 52.7274894714355,9.26067066192633 52.7274894714355,9.2572813034057 52.7210426330566,9.25715637207043 52.7140846252443,9.25409030914312 52.7130546569824,9.25430011749268 52.7111282348634,9.24827194213873 52.709442138672,9.2485151290893 52.7078552246094,9.24941539764416 52.7078895568848,9.24703598022461 52.7029495239259,9.24974155426037 52.7020072937012,9.24667739868164 52.6999015808105,9.24667739868164 52.6999015808105,9.24769878387463 52.6992568969727,9.25002384185791 52.7001380920411,9.25024318695074 52.6979293823243,9.24710178375256 52.6953353881837,9.24809741973883 52.6950874328613,9.24562168121338 52.6905479431152,9.24626064300548 52.6889915466309,9.26096630096436 52.6875000000001,9.25945472717291 52.6854438781739,9.25945472717291 52.6854438781739,9.2645311355592 52.6849021911622,9.2641420364381 52.6866416931153,9.26628017425543 52.6853256225587,9.27006912231457 52.6855735778809,9.27621364593517 52.6868209838867,9.27745819091797 52.6883888244628,9.28137016296398 52.6871337890626,9.27920150756847 52.6847076416016,9.27501106262207 52.6847763061524,9.27355480194092 52.6822166442872,9.27055835723877 52.681007385254,9.26874256134045 52.6790962219238,9.26965618133556 52.6773223876954,9.27256298065186 52.67586517334,9.27571582794195 52.6765174865724,9.28008365631115 52.6781082153321,9.28252029418945 52.6801910400391,9.28252029418945 52.6801910400391,9.28742980957037 52.6847114562989,9.29284477233887 52.6918411254883,9.29527378082281 52.6901397705079,9.30393505096441 52.689479827881,9.31499195098877 52.6888504028321,9.31336307525635 52.6911277770996,9.33966159820557 52.6889076232911,9.34793663024914 52.6940078735353,9.35185146331787 52.6936492919922,9.36935997009277 52.683162689209,9.38502693176281 52.6928520202637,9.34816932678228 52.7148208618164))	0.0006	POINT(9.293955097353603 52.71922491430269)
24653	POLYGON((3.21420693397528 45.5355606079102,3.21618127822887 45.5325584411622,3.21227908134466 45.5307006835938,3.19831895828253 45.5320434570313,3.1814172267915 45.54301071167,3.1814172267915 45.54301071167,3.17866325378418 45.55135345459,3.17866325378418 45.55135345459,3.18966603279119 45.5569000244142,3.21206474304199 45.5583839416504,3.21206474304199 45.5583839416504,3.21420693397528 45.5355606079102))	0.0006	POINT(3.1977220665325334 45.5448417663575)
180299	POLYGON((11.1899433135987 50.2711868286135,11.1871395111085 50.2695541381839,11.1754875183107 50.2698287963867,11.1739702224733 50.2712783813479,11.1773014068604 50.2761917114258,11.1794080734253 50.2753906250002,11.1837100982666 50.2808952331546,11.1773099899293 50.2810935974124,11.1718406677247 50.2835464477541,11.1655044555663 50.2823448181155,11.1584796905519 50.2892036437988,11.1537675857545 50.2835426330567,11.1514787673951 50.2859878540038,11.1459226608278 50.2849578857422,11.1415567398071 50.2891921997073,11.1431970596315 50.2933769226076,11.139726638794 50.2929649353027,11.1402673721314 50.2948532104494,11.1376571655273 50.2997245788576,11.1331586837768 50.3001785278323,11.1315240859986 50.3055610656738,11.1327285766602 50.3105468750001,11.1348276138305 50.3140525817872,11.1432285308839 50.3190612792971,11.151912689209 50.3210716247561,11.1560888290406 50.3241844177247,11.1581773757936 50.3237762451172,11.1593208312988 50.3261528015137,11.1570911407471 50.3265533447266,11.1591978073121 50.3303909301761,11.1361083984376 50.349666595459,11.1391077041627 50.3535041809084,11.1266784667969 50.3561782836913,11.1216869354249 50.349002838135,11.1167974472047 50.3493347167969,11.1140451431274 50.3525276184082,11.1166172027588 50.3537902832034,11.1192913055421 50.3592910766602,11.1153049468995 50.3670082092285,11.1000299453736 50.3674888610843,11.0968437194825 50.3659400939942,11.0897369384767 50.3658866882326,11.0879526138306 50.3647727966311,11.0880470275879 50.3628387451173,11.0856294631959 50.3623542785647,11.0867729187012 50.3592987060547,11.0819511413575 50.3539009094241,11.0857534408569 50.3520355224609,11.0810747146607 50.351619720459,11.0735673904419 50.3536529541017,11.0641193389893 50.3492088317872,11.0593671798706 50.3493232727053,11.0429887771606 50.344722747803,11.0411548614503 50.3466720581056,11.0368633270265 50.3452110290527,11.0324068069459 50.351501464844,11.0434970855712 50.3522338867188,11.0432729721069 50.3533325195312,11.0317029953003 50.3551292419433,11.0362272262574 50.358684539795,11.0334177017212 50.3613586425783,11.0326461791993 50.3603057861329,11.024043083191 50.3606185913086,11.0216121673585 50.3621520996094,11.0178890228271 50.3612060546875,11.0080432891846 50.3652000427249,10.9934873580934 50.3654670715334,10.9920520782471 50.3603134155274,10.9941492080689 50.3534736633301,10.9978275299073 50.3538932800295,10.9995193481446 50.3519744873048,10.9963703155517 50.34672164917,10.9929542541505 50.3490295410159,10.9857807159424 50.3473205566409,10.9825010299683 50.3517951965334,10.9616193771363 50.3677253723144,10.9566612243653 50.368480682373,10.962730407715 50.3719253540041,10.9633045196534 50.375915527344,10.961787223816 50.3775863647463,10.9596815109253 50.3753089904788,10.9484405517579 50.3817520141602,10.949954032898 50.383472442627,10.9457178115845 50.3864669799808,10.9457178115845 50.3864669799808,10.9376344680787 50.3919067382812,10.9328260421753 50.3924255371093,10.9190149307252 50.3889045715332,10.9119186401368 50.3852615356448,10.9094161987305 50.3871879577637,10.8988542556763 50.3847122192383,10.8931179046631 50.3803253173829,10.8848686218262 50.3885040283205,10.8871879577637 50.3925743103027,10.8779830932618 50.3932304382325,10.8762359619141 50.3965301513674,10.8727464675904 50.3967933654787,10.8677444458009 50.3942718505861,10.8662834167481 50.3892745971682,10.8618383407592 50.3876686096192,10.8508520126343 50.3883590698243,10.849895477295 50.3903884887695,10.8304433822632 50.3926162719726,10.8199691772461 50.3848953247073,10.8168048858643 50.3860168457034,10.8108940124512 50.3841209411621,10.8104810714722 50.3823776245117,10.8042507171631 50.3791084289552,10.7901582717896 50.3822250366213,10.7858810424805 50.385383605957,10.7737741470336 50.3719711303714,10.7668523788452 50.3704605102542,10.7658805847168 50.3717803955081,10.7629423141479 50.3697166442873,10.7647399902345 50.3691101074222,10.7623014450074 50.3682518005374,10.7605094909668 50.3624191284181,10.7545099258422 50.3581733703614,10.7494173049928 50.3579521179202,10.7387180328369 50.3628654479983,10.7152662277221 50.3635902404785,10.717929840088 50.3555412292482,10.7124547958375 50.3546447753907,10.7143039703369 50.3463439941409,10.7201948165895 50.3495635986328,10.7288722991943 50.3479423522949,10.7269735336305 50.3469696044923,10.7287673950195 50.3446273803713,10.7270298004152 50.341148376465,10.7281484603882 50.3381195068359,10.719599723816 50.3331642150882,10.7150020599365 50.3330307006837,10.7162141799928 50.3280563354494,10.7143898010254 50.3254776000976,10.7153959274293 50.3211746215823,10.7218046188354 50.3180198669436,10.7273149490356 50.3186264038086,10.7369327545167 50.3141517639162,10.7418451309205 50.315914154053,10.7507600784303 50.3095054626468,10.7524604797364 50.3065605163574,10.7594718933106 50.3038024902346,10.7625188827515 50.2983665466311,10.7707290649414 50.2926712036132,10.7753896713258 50.2946853637696,10.7869768142701 50.2939376831055,10.7942094802857 50.2953758239747,10.7970352172852 50.292751312256,10.8025503158569 50.2919807434083,10.8043785095215 50.2886352539065,10.8017082214355 50.28332901001,10.8039197921754 50.2797546386719,10.8106956481934 50.2796783447267,10.8114728927613 50.2777328491212,10.8145236968995 50.2788658142092,10.8198623657228 50.2771377563477,10.826331138611 50.2779502868652,10.8324480056763 50.2736244201661,10.8359260559083 50.2730636596681,10.8422479629516 50.275520324707,10.8463582992555 50.2750930786136,10.8454046249391 50.2695007324221,10.8512792587281 50.2648048400881,10.8514947891236 50.262763977051,10.8503293991089 50.2597770690918,10.8519525527955 50.2516021728517,10.8476524353027 50.2450218200685,10.8446664810182 50.2431564331057,10.8360605239869 50.2419548034669,10.8359117507935 50.2395057678225,10.8252325057983 50.2376098632812,10.8072681427003 50.2401962280275,10.8079566955568 50.2414855957032,10.805832862854 50.243721008301,10.8067722320558 50.2443466186524,10.8005638122559 50.2514419555667,10.7929105758667 50.2502403259277,10.7818431854249 50.2512855529787,10.784366607666 50.2485046386721,10.7696313858032 50.2408409118655,10.7498168945313 50.2424774169925,10.7461338043212 50.2437820434571,10.7482032775879 50.2478256225587,10.7321681976318 50.2518386840821,10.7264947891235 50.2475662231448,10.7298078536987 50.2448768615724,10.7293205261231 50.2427558898929,10.7262382507325 50.2408905029299,10.7277908325195 50.2367095947266,10.7270183563232 50.2308921813965,10.7292022705079 50.2300071716308,10.7292022705079 50.2300071716308,10.7460775375366 50.2276039123537,10.7547369003296 50.2235527038576,10.7616338729859 50.2229347229005,10.762749671936 50.2218818664553,10.7568140029907 50.2185821533204,10.7557382583619 50.216724395752,10.7567567825317 50.2158203125,10.7537183761597 50.2132377624512,10.7643890380859 50.2092018127443,10.7666053771973 50.2068023681643,10.7652549743652 50.2060203552248,10.7713146209717 50.2017059326172,10.772315979004 50.19787979126,10.7753887176515 50.1984939575195,10.7768793106079 50.1944961547852,10.7801580429078 50.1943969726565,10.7796850204468 50.1830787658693,10.7815847396851 50.1821022033694,10.7814111709595 50.1764907836915,10.7752771377565 50.1744537353517,10.7729291915894 50.1658210754397,10.7763376235962 50.1498680114749,10.7777881622314 50.1489295959474,10.7795009613038 50.14958190918,10.783652305603 50.1460266113283,10.7864809036255 50.1483955383301,10.7852354049684 50.1508178710938,10.790241241455 50.1520309448243,10.7886829376221 50.149055480957,10.7946043014526 50.1443367004397,10.7924318313599 50.1416320800783,10.7960834503175 50.1413536071779,10.8043699264526 50.1409988403323,10.8025732040405 50.1468162536624,10.8083839416504 50.1490402221679,10.811785697937 50.1489677429199,10.812539100647 50.1464118957521,10.8178939819337 50.1472473144532,10.8188467025757 50.1495056152346,10.8245391845703 50.1464424133304,10.8351593017578 50.1474800109863,10.8419265747071 50.1442413330081,10.8475189208986 50.1469039916995,10.845552444458 50.1479911804199,10.8472585678101 50.1495513916016,10.8416032791138 50.1518249511719,10.8440475463868 50.152843475342,10.8428792953492 50.1539268493652,10.8517980575562 50.1575164794924,10.8553934097289 50.1570281982425,10.8610191345215 50.1509399414064,10.8731327056886 50.1478652954104,10.8776359558105 50.1451454162598,10.8788442611694 50.1421546936037,10.8738355636597 50.1372833251953,10.8727922439576 50.1381072998047,10.8698244094849 50.136287689209,10.8709707260133 50.1282577514648,10.8682889938354 50.1261100769043,10.861780166626 50.1255798339843,10.8617458343506 50.1233596801758,10.8648777008057 50.1211013793948,10.8631525039673 50.1170196533203,10.8601322174073 50.1153755187988,10.8577709197999 50.106616973877,10.859395980835 50.0976524353027,10.8614587783815 50.0949554443362,10.860116004944 50.0917854309082,10.860116004944 50.0917854309082,10.8619089126587 50.087963104248,10.8658018112183 50.0885810852053,10.864972114563 50.0898513793946,10.8676719665527 50.0935668945314,10.8761472702027 50.0953483581542,10.8761472702027 50.0953483581542,10.8792562484741 50.0940513610842,10.8800821304322 50.0906944274903,10.8847732543945 50.093143463135,10.8847732543945 50.093143463135,10.8804082870483 50.0946693420412,10.8868932723999 50.1026535034183,10.8837022781373 50.1041603088381,10.887924194336 50.1089744567873,10.8913726806642 50.1098175048828,10.8906412124635 50.1110649108889,10.899697303772 50.1131210327149,10.909686088562 50.1129493713379,10.9123992919921 50.1144256591799,10.911826133728 50.1160812377931,10.9141454696655 50.1188812255862,10.9169206619262 50.1194648742678,10.9265689849853 50.117027282715,10.9309692382812 50.1131782531741,10.9374570846557 50.1127128601074,10.9417667388917 50.1186790466309,10.9485759735109 50.1225852966311,10.9463005065918 50.1246185302736,10.9485530853273 50.1260566711425,10.9477310180664 50.1279220581055,10.9391393661499 50.1311416625978,10.934217453003 50.1363067626955,10.9301052093505 50.1351242065429,10.9292507171631 50.1396980285647,10.9249114990235 50.1381492614748,10.9220838546753 50.1412734985352,10.9154834747316 50.1405601501464,10.9179544448852 50.1430053710938,10.9259204864503 50.1444816589356,10.9246635437013 50.1479835510255,10.9210805892945 50.1496810913086,10.9287910461426 50.1506767272949,10.9387893676758 50.1537170410159,10.9391241073608 50.1551361083986,10.9426593780518 50.154323577881,10.9476432800293 50.1555976867679,10.9483757019043 50.1545333862308,10.9517078399659 50.1559143066406,10.9505538940429 50.1568031311037,10.9565629959108 50.162696838379,10.9558992385865 50.1665420532228,10.9526796340943 50.171081542969,10.9599828720093 50.1744537353517,10.9623155593872 50.1723747253421,10.9772186279298 50.1747970581054,10.9798240661621 50.1747398376467,10.9805917739868 50.1730995178223,10.9835081100464 50.173320770264,10.9860143661498 50.1758842468263,10.9910726547242 50.1746482849122,10.993353843689 50.1770668029787,11.0078086853028 50.1773757934573,11.0092706680299 50.1796875000001,11.0001935958863 50.1849060058593,11.0050563812255 50.1883239746095,11.0035457611084 50.1901206970218,11.0107736587525 50.1920509338378,11.0109920501709 50.193790435791,11.004451751709 50.1956100463869,11.0012302398682 50.19841003418,11.0073690414428 50.1996879577636,10.9995765686036 50.1997604370118,10.9962120056153 50.202503204346,10.9977855682374 50.2040786743166,10.9877691268921 50.2048568725587,10.9884281158447 50.2071304321291,10.9864530563356 50.2070960998538,10.9841032028199 50.209686279297,10.9853591918946 50.2116966247558,10.9916925430298 50.2139663696291,11.0167608261108 50.2163276672363,11.0186100006104 50.2186851501465,11.0217542648317 50.2176742553714,11.0217542648317 50.2176742553714,11.0340633392334 50.2186431884767,11.034218788147 50.2150344848632,11.0359210968018 50.2142868041992,11.0395545959473 50.2132720947267,11.0414524078369 50.2161254882814,11.0432043075563 50.2160530090335,11.0435476303101 50.2142333984378,11.0609216690064 50.2084197998047,11.064715385437 50.2055740356448,11.0669078826904 50.2106857299806,11.0706405639649 50.208667755127,11.0739250183105 50.2100830078124,11.0798053741456 50.2093772888186,11.0870571136476 50.2063179016116,11.0879030227662 50.2044143676758,11.0950870513917 50.2093887329104,11.1025733947754 50.2104377746584,11.1086826324464 50.205764770508,11.118245124817 50.2037353515626,11.1181964874268 50.2000350952148,11.1099481582642 50.2006111145022,11.111107826233 50.1982040405275,11.1086921691895 50.1956672668458,11.1159172058106 50.1918411254885,11.1233940124512 50.195499420166,11.1320495605469 50.1950302124023,11.1394891738892 50.1927375793458,11.1407585144044 50.1953582763675,11.1457195281983 50.1953048706057,11.147891998291 50.197334289551,11.1530055999756 50.1981582641604,11.160309791565 50.1932601928714,11.1599216461182 50.1885719299318,11.1797304153444 50.1851119995117,11.1906032562257 50.1964988708496,11.1978845596314 50.1988220214843,11.1981849670411 50.2020950317385,11.1981849670411 50.2020950317385,11.1856317520142 50.1996879577636,11.1767368316651 50.2001380920412,11.1732635498047 50.2013702392578,11.1685419082643 50.2064476013186,11.1835775375367 50.2117385864259,11.1819343566895 50.2135391235353,11.1833028793336 50.2140617370608,11.1823501586914 50.2189636230469,11.1804132461547 50.2188758850098,11.1814517974854 50.2218475341798,11.1799087524415 50.2247352600098,11.1911516189576 50.2282218933106,11.1922225952148 50.2294769287111,11.1896238327026 50.2321090698244,11.193585395813 50.2344436645509,11.1923961639404 50.2365188598633,11.1935987472535 50.238166809082,11.1915140151978 50.2376136779788,11.1902160644532 50.2399597167969,11.1931753158569 50.2418251037599,11.1775732040405 50.2486305236817,11.1788406372071 50.2509078979492,11.1812076568603 50.2496337890627,11.1891469955444 50.2503433227539,11.1902236938477 50.2510566711426,11.1881351470947 50.2522125244142,11.189341545105 50.2531051635743,11.1920518875123 50.2532577514651,11.1927556991577 50.2514533996584,11.1962614059449 50.2522430419922,11.1957206726075 50.2555465698244,11.1979351043701 50.254364013672,11.2017793655396 50.2562141418459,11.1988000869752 50.263313293457,11.1947240829468 50.2621688842773,11.1921091079712 50.2650146484374,11.1959619522095 50.267272949219,11.193949699402 50.2668304443362,11.1922235488893 50.2706336975097,11.1899433135987 50.2711868286135),(11.0496168136596 50.2621994018555,11.0515956878662 50.2633056640625,11.0515956878662 50.2633056640625,11.0540409088135 50.2636070251467,11.0588312149048 50.2650680541992,11.0596466064453 50.2651748657229,11.060531616211 50.2652969360354,11.0623884201049 50.2643966674808,11.0637435913087 50.2650451660158,11.0638704299927 50.2651100158691,11.0638704299927 50.2651100158691,11.0614995956422 50.2687454223633,11.0614995956422 50.2687454223633,11.0573072433472 50.2691459655763,11.0534934997559 50.2695503234863,11.0534934997559 50.2695503234863,11.0527334213258 50.2705879211427,11.0527334213258 50.2705879211427,11.0510177612306 50.2715034484866,11.0515613555908 50.2723922729493,11.0515613555908 50.2723922729493,11.0508642196655 50.2739982604981,11.0508642196655 50.2739982604981,11.0495433807373 50.2739219665529,11.048152923584 50.2738418579102,11.048152923584 50.2738418579102,11.0449523925782 50.2751693725586,11.0449523925782 50.2751693725586,11.0444049835206 50.2751274108889,11.0434770584107 50.2750587463381,11.0407896041871 50.2732734680179,11.0417728424072 50.2720985412598,11.0417728424072 50.2720985412598,11.0407123565674 50.2702751159668,11.0407123565674 50.2702751159668,11.0404443740845 50.2701263427737,11.0401344299316 50.2700271606445,11.0401344299316 50.2700271606445,11.0358791351319 50.2723503112792,11.0358791351319 50.2723503112792,11.0332679748535 50.2723464965823,11.0325355529785 50.2721328735352,11.0325355529785 50.2721328735352,11.0317525863649 50.2712287902832,11.0317525863649 50.2712287902832,11.0317363739015 50.2710037231448,11.0313243865968 50.2706069946289,11.0306882858278 50.2701606750491,11.0303773880006 50.2700080871583,11.0303773880006 50.2700080871583,11.023726463318 50.2665481567383,11.0230855941773 50.2682075500488,11.0185308456421 50.2676696777345,11.0185308456421 50.2676696777345,11.0125675201417 50.266597747803,11.0122289657593 50.2677688598635,11.0114974975587 50.2675857543948,11.0109624862672 50.2674446105957,11.0109415054322 50.268135070801,11.0104608535766 50.2690658569336,11.0104608535766 50.2690658569336,11.0057258605958 50.2738990783691,10.9965944290162 50.2760620117189,10.9965944290162 50.2760620117189,10.9959878921509 50.275760650635,10.9954118728638 50.275760650635,10.9946985244751 50.2760353088379,10.9944190979004 50.2761611938479,10.9941825866699 50.2763252258304,10.9941148757936 50.2765960693361,10.9941148757936 50.2765960693361,10.9941186904907 50.276954650879,10.9941186904907 50.276954650879,10.9936027526855 50.2772903442385,10.9928464889526 50.2774658203125,10.9928464889526 50.2774658203125,10.9914684295655 50.277229309082,10.9914684295655 50.277229309082,10.9896774291992 50.2765235900882,10.989128112793 50.2763481140138,10.989128112793 50.2763481140138,10.9886198043823 50.2760963439942,10.9886198043823 50.2760963439942,10.988042831421 50.2759552001955,10.9875240325928 50.2760581970217,10.9873027801515 50.2763366699221,10.9872074127198 50.2766532897951,10.9870824813843 50.2767333984377,10.9868307113647 50.2768974304202,10.9862976074219 50.276882171631,10.9862976074219 50.276882171631,10.9850301742555 50.276554107666,10.9804468154908 50.2814598083497,10.9832525253296 50.2825698852539,10.9832525253296 50.2825698852539,10.9848508834839 50.2836799621584,10.9879093170167 50.2847557067871,10.9893550872803 50.286071777344,10.9917507171631 50.2868537902831,10.9917507171631 50.2868537902831,10.993621826172 50.2884674072265,10.993621826172 50.2884674072265,10.9899511337281 50.2920341491701,10.9854698181153 50.2905883789062,10.9854698181153 50.2905883789062,10.9781885147096 50.2900085449219,10.9781885147096 50.2900085449219,10.9767427444459 50.2900047302248,10.9739770889283 50.2901306152345,10.9721240997316 50.2902755737307,10.9689989089966 50.2908821105959,10.9673757553101 50.2915344238281,10.9673757553101 50.2915344238281,10.9631977081298 50.2936668395997,10.9631977081298 50.2936668395997,10.9601192474366 50.2977294921877,10.9535531997681 50.2956237792971,10.9503030776978 50.2965621948244,10.9506549835205 50.2980613708499,10.9463758468629 50.2986373901367,10.9463758468629 50.2986373901367,10.9462804794313 50.2974510192872,10.9462804794313 50.2974510192872,10.9426946640016 50.2970314025881,10.9426946640016 50.2970314025881,10.942587852478 50.2960968017578,10.942587852478 50.2960968017578,10.9406633377076 50.2961311340333,10.9406633377076 50.2961311340333,10.9396896362304 50.2955970764163,10.9380960464478 50.2949180603027,10.9380960464478 50.2949180603027,10.9361324310303 50.2937469482422,10.9361324310303 50.2937469482422,10.935830116272 50.2928924560549,10.934931755066 50.2930030822754,10.934931755066 50.2930030822754,10.933219909668 50.2931900024415,10.933219909668 50.2931900024415,10.9325628280641 50.2934722900392,10.9309539794922 50.2941513061526,10.9306917190552 50.2946853637696,10.9306917190552 50.2946853637696,10.9306545257569 50.2952232360841,10.9306545257569 50.2952232360841,10.9304370880127 50.2959976196291,10.9293184280395 50.2965431213382,10.9268283843994 50.2946434020999,10.9248685836791 50.295364379883,10.9227590560914 50.2950553894042,10.9227590560914 50.2950553894042,10.9202556610108 50.2946891784668,10.9192399978638 50.2925872802735,10.9192399978638 50.2925872802735,10.9185295104981 50.2916793823245,10.9149007797241 50.2911338806155,10.9134387969971 50.2909240722659,10.9133644104004 50.290466308594,10.9131870269777 50.2893943786621,10.9105787277221 50.2883338928225,10.9097023010254 50.2875823974609,10.9097023010254 50.2875823974609,10.906421661377 50.2883033752442,10.906421661377 50.2883033752442,10.906102180481 50.2870826721193,10.9058551788331 50.2861099243165,10.9058551788331 50.2861099243165,10.90043258667 50.2859153747559,10.90043258667 50.2859153747559,10.8954992294312 50.2853012084963,10.8913068771362 50.2844619750976,10.888433456421 50.2834091186526,10.8873901367189 50.2828826904298,10.8873901367189 50.2828826904298,10.8889293670654 50.2821998596192,10.8889293670654 50.2821998596192,10.890275001526 50.2819519042972,10.892095565796 50.2813911437991,10.8939542770387 50.2803306579593,10.8946981430054 50.2801933288574,10.8958053588867 50.279983520508,10.8969659805299 50.27946472168,10.8974390029908 50.27893447876,10.8976163864136 50.2782936096193,10.8978214263916 50.2776374816896,10.8978214263916 50.2776374816896,10.8992538452148 50.2759742736816,10.8992538452148 50.2759742736816,10.9003124237062 50.2750167846682,10.902226448059 50.2739334106448,10.9041423797609 50.2730712890625,10.9041423797609 50.2730712890625,10.9048128128052 50.2726707458497,10.9048128128052 50.2726707458497,10.9051895141602 50.2723541259768,10.9056062698365 50.2718238830568,10.9055585861207 50.271194458008,10.9053430557252 50.2706451416018,10.9052000045778 50.270320892334,10.9052000045778 50.270320892334,10.9081058502197 50.2686920166016,10.9145202636719 50.2686157226564,10.9145202636719 50.2686157226564,10.917254447937 50.268280029297,10.9207849502565 50.2658653259277,10.9207849502565 50.2658653259277,10.9167566299439 50.2659339904785,10.9167566299439 50.2659339904785,10.9164676666259 50.2633552551272,10.9179182052613 50.2623405456545,10.9198713302613 50.2609672546387,10.9208850860596 50.2598457336428,10.9201765060425 50.2590484619142,10.9196376800537 50.2584381103518,10.9183683395387 50.2577323913574,10.9183683395387 50.2577323913574,10.9174375534057 50.2572135925294,10.9174375534057 50.2572135925294,10.9182205200196 50.2552413940433,10.9145870208741 50.2537956237794,10.9130449295045 50.2540092468265,10.9106378555298 50.2547836303713,10.9086647033693 50.2547111511233,10.9041805267334 50.2545547485353,10.9042129516601 50.2534637451174,10.9016323089601 50.2536163330078,10.9016323089601 50.2536163330078,10.8966321945192 50.2548027038574,10.8966321945192 50.2548027038574,10.8942108154297 50.2539138793948,10.8920221328735 50.2506179809573,10.8954038619996 50.2488899230956,10.8989601135253 50.2479400634768,10.9041795730591 50.2446899414065,10.9092864990235 50.24133682251,10.9113779067994 50.241508483887,10.913902282715 50.2398338317873,10.9212951660157 50.2413024902345,10.9212951660157 50.2413024902345,10.9282293319702 50.243236541748,10.9282293319702 50.243236541748,10.9289293289184 50.2414627075198,10.9326219558716 50.2418060302734,10.9353647232056 50.2394943237306,10.9382514953613 50.2391967773438,10.9382514953613 50.2391967773438,10.9406318664551 50.2401580810548,10.9406318664551 50.2401580810548,10.9408674240113 50.24133682251,10.944944381714 50.2437744140626,10.944944381714 50.2437744140626,10.9478311538697 50.2433586120605,10.9478311538697 50.2433586120605,10.9500980377197 50.2441978454592,10.9514188766479 50.2444000244142,10.9579010009766 50.2444458007814,10.96018409729 50.2440299987795,10.9619989395143 50.2430877685547,10.9619989395143 50.2430877685547,10.9630603790283 50.2425422668458,10.9630603790283 50.2425422668458,10.9651355743408 50.2410507202151,10.9649438858032 50.2400894165039,10.9649438858032 50.2400894165039,10.9669713973999 50.2365264892579,10.9669713973999 50.2365264892579,10.9707641601562 50.2370948791506,10.9709606170654 50.2371215820315,10.971420288086 50.2367782592773,10.971420288086 50.2367782592773,10.974720954895 50.2302131652832,10.974720954895 50.2302131652832,10.9724578857423 50.2296638488771,10.9756011962891 50.2236442565919,10.9756011962891 50.2236442565919,10.9755296707153 50.223201751709,10.9755296707153 50.223201751709,10.9757928848267 50.2228164672854,10.9763927459718 50.2225990295412,10.9769906997681 50.2223548889163,10.9774999618531 50.2220954895022,10.9777631759644 50.2216949462892,10.9777631759644 50.2216949462892,10.9842624664307 50.2222824096679,10.9842624664307 50.2222824096679,10.9842319488525 50.2242546081546,10.9855318069459 50.2243919372561,10.987133026123 50.2245826721194,10.9876499176025 50.2251243591311,10.9898834228516 50.2274513244629,10.9902906417846 50.2288436889651,10.9898443222046 50.230438232422,10.9898443222046 50.230438232422,10.9897680282594 50.2311935424806,10.9897680282594 50.2311935424806,10.9932651519776 50.2316398620608,10.998637199402 50.2328910827637,10.9969415664673 50.2343750000002,10.9943656921387 50.2362747192383,10.9948110580444 50.2385673522952,10.9942874908447 50.2395324707034,10.9968452453613 50.2412757873535,10.9993925094605 50.2419853210452,11.0010070800782 50.2434196472168,11.0010070800782 50.2434196472168,11.0104913711548 50.2460136413575,11.0104913711548 50.2460136413575,11.0099573135376 50.247211456299,11.0144777297974 50.2473983764649,11.0161600112916 50.2472457885745,11.0190734863281 50.2480888366702,11.0232791900634 50.2515602111816,11.0232791900634 50.2515602111816,11.0256452560425 50.2510299682618,11.0256452560425 50.2510299682618,11.0293302536011 50.2492675781252,11.0349531173706 50.253845214844,11.0332450866699 50.2566795349124,11.0346994400024 50.2599563598635,11.0383882522584 50.258483886719,11.0460662841798 50.2597885131837,11.0496168136596 50.2621994018555))	0.0010	POINT(10.948499966919417 50.242227596052196)
24288	POLYGON((3.69734573364269 44.8753089904786,3.71953797340393 44.8847541809083,3.72266888618469 44.8938217163087,3.72266888618469 44.8938217163087,3.71058130264294 44.9075584411621,3.71058130264294 44.9075584411621,3.7018706798554 44.9100875854493,3.68772792816156 44.9233322143555,3.68962764740002 44.9366378784179,3.67513418197632 44.9499893188476,3.67513418197632 44.9499893188476,3.66536259651195 44.9353866577149,3.66536259651195 44.9353866577149,3.65239644050604 44.9213752746583,3.65212845802307 44.9081230163574,3.64429235458385 44.9043045043946,3.64887332916254 44.8983650207521,3.64511084556591 44.8851318359376,3.64511084556591 44.8851318359376,3.65438032150274 44.8806648254394,3.65438032150274 44.8806648254394,3.68494701385509 44.8969383239746,3.69226670265203 44.8926734924316,3.6913526058197 44.8729515075684,3.6913526058197 44.8729515075684,3.69734573364269 44.8753089904786))	0.0006	POINT(3.6800078296661893 44.90411636352544)
23330	POLYGON((-0.521623313426858 43.3752250671387,-0.507277607917729 43.3814926147462,-0.503516972064972 43.3907012939454,-0.508903682231789 43.3950004577638,-0.508903682231789 43.3950004577638,-0.527274012565613 43.4041824340821,-0.536018013954163 43.4051780700684,-0.536018013954163 43.4051780700684,-0.546632707118931 43.3986434936524,-0.546632707118931 43.3986434936524,-0.554769098758641 43.3882102966309,-0.554769098758641 43.3882102966309,-0.546025276184025 43.3877830505371,-0.521623313426858 43.3752250671387))	0.0006	POINT(-0.5306433989450958 43.39334223820619)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point