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
66734	MULTIPOLYGON(((9.15082550048828 48.5510253906251,9.15165615081798 48.547924041748,9.15548610687267 48.5490379333497,9.16397762298584 48.5485839843749,9.16840648651117 48.5501136779786,9.16840648651117 48.5501136779786,9.16984367370605 48.5505523681641,9.17132186889648 48.5484924316407,9.17132186889648 48.5484924316407,9.17210865020752 48.54647064209,9.17078113555908 48.5459594726562,9.17422580719006 48.542808532715,9.17575550079346 48.5388412475587,9.17248630523687 48.5295753479005,9.17371654510509 48.5276679992677,9.16721916198736 48.5236206054688,9.16435337066645 48.5229759216309,9.16435337066645 48.5229759216309,9.16282081604015 48.5225791931152,9.15660095214849 48.5267219543458,9.14799022674555 48.5232810974122,9.14170074462896 48.5235557556152,9.14170074462896 48.5235557556152,9.13549232482916 48.530143737793,9.12987136840832 48.5316390991211,9.13235473632818 48.533863067627,9.13029003143311 48.534107208252,9.13029003143311 48.534107208252,9.12952327728277 48.536319732666,9.1254558563233 48.5379409790039,9.12470722198492 48.5409622192382,9.12507629394531 48.5422821044923,9.13091278076183 48.5442428588867,9.12769794464111 48.5487518310548,9.11957931518566 48.5527687072754,9.11782646179205 48.5567779541017,9.12561130523693 48.5665969848633,9.12561130523693 48.5665969848633,9.13419055938726 48.5636253356934,9.14001941680903 48.5630493164064,9.14006805419933 48.5613059997559,9.14228630065929 48.5604438781739,9.14139938354492 48.5597152709961,9.14288520812988 48.5584182739258,9.14438247680658 48.5586433410645,9.15070056915278 48.5535850524903,9.15082550048828 48.5510253906251)),((9.14978313446051 48.5461082458497,9.14888572692871 48.5477104187013,9.14494991302496 48.5474700927734,9.14634418487549 48.5441093444824,9.14969921112055 48.5452194213867,9.14978313446051 48.5461082458497)))	0.0006	POINT(9.147897922329198 48.543517439601644)
28209	POLYGON((5.39491987228388 47.1584434509277,5.39234352111828 47.1536521911621,5.39234352111828 47.1536521911621,5.38405752182018 47.1463279724122,5.37064886093134 47.1446418762208,5.37064886093134 47.1446418762208,5.35776853561413 47.1643333435058,5.35776853561413 47.1643333435058,5.38939046859753 47.174285888672,5.39443540573114 47.1686325073242,5.39491987228388 47.1584434509277))	0.0006	POINT(5.380432510376023 47.15729446411135)
17958	POLYGON((7.74135684967047 45.0456924438478,7.75689315795904 45.058723449707,7.7682957649231 45.0717811584472,7.7682957649231 45.0717811584472,7.78738498687756 45.0733680725098,7.79832220077509 45.0685348510743,7.7997899055481 45.0669746398927,7.79941606521612 45.0623970031739,7.80050897598278 45.0557098388672,7.81140518188477 45.0440406799317,7.81140518188477 45.0440406799317,7.81008815765375 45.0328483581544,7.80253219604504 45.0293235778809,7.79608488082891 45.0286598205568,7.7840747833252 45.0251464843749,7.78301191329962 45.0213928222656,7.7856531143189 45.0165672302247,7.78138780593883 45.0129661560059,7.77671718597412 45.0124664306641,7.77671718597412 45.0124664306641,7.76502418518072 45.0203437805176,7.76351690292364 45.0225868225098,7.76338386535656 45.0270156860353,7.75905895233149 45.0321350097657,7.75101900100708 45.0369873046875,7.74540615081798 45.0387992858887,7.74311304092402 45.0414848327637,7.74135684967047 45.0456924438478))	0.0006	POINT(7.778883828057218 45.03978644477)
50939	POLYGON((1.91003632545471 50.2285118103027,1.9284076690675 50.2309341430664,1.94301140308386 50.2227821350098,1.94301140308386 50.2227821350098,1.95289397239696 50.2349548339844,1.94794452190393 50.2447357177736,1.94794452190393 50.2447357177736,1.93284678459173 50.2474899291992,1.91504716873169 50.2409667968751,1.90694582462311 50.2452239990234,1.90694582462311 50.2452239990234,1.90242385864258 50.2393531799316,1.91128349304205 50.2317085266114,1.91003632545471 50.2285118103027))	0.0006	POINT(1.926826367011463 50.23687714796803)
52658	POLYGON((-0.0985328331589699 46.134750366211,-0.0879487246274948 46.1399345397949,-0.0879487246274948 46.1399345397949,-0.0552050955593586 46.1339340209961,-0.0571058392524719 46.1240768432618,-0.0383880585430916 46.1137123107911,-0.0383880585430916 46.1137123107911,-0.0506470203399658 46.1081390380859,-0.060228306800127 46.1003570556641,-0.0585339553654194 46.0971488952638,-0.0706571936606792 46.0913352966309,-0.0706571936606792 46.0913352966309,-0.0740534290670212 46.0939254760743,-0.0890308320522308 46.0942230224609,-0.0890308320522308 46.0942230224609,-0.11646477878088 46.1017379760743,-0.11646477878088 46.1017379760743,-0.114937052130699 46.1083755493164,-0.119763001799583 46.1141815185548,-0.104784093797093 46.1226654052734,-0.104133374989033 46.1292648315431,-0.0985328331589699 46.134750366211))	0.0006	POINT(-0.08109062750421402 46.111843109130916)
180946	POLYGON((5.80146980285656 44.7067794799808,5.77464771270763 44.6985015869143,5.75531148910522 44.6969642639161,5.7363595962525 44.7126693725587,5.71793222427374 44.7153739929201,5.70405960083019 44.7292976379397,5.69588327407837 44.7221641540527,5.6680030822755 44.7246780395509,5.66065692901611 44.7213706970218,5.64710187911987 44.7240982055665,5.64397859573364 44.7315788269045,5.63566398620617 44.7334785461426,5.6290650367738 44.7447967529299,5.62631464004528 44.7532920837404,5.60769844055187 44.7558593750002,5.58614444732677 44.7641296386721,5.58204650878912 44.7778701782227,5.54840040206921 44.7931098937988,5.54585027694708 44.7879142761232,5.55387401580816 44.7749214172364,5.54883861541748 44.7706871032717,5.48202800750744 44.7865867614749,5.47800827026373 44.7918128967287,5.46412134170538 44.793888092041,5.46022510528564 44.7999458312991,5.47505092620861 44.8079566955569,5.484766483307 44.823070526123,5.46379518508917 44.825981140137,5.47491931915283 44.8678894042971,5.4704532623291 44.8780860900881,5.48048830032343 44.898174285889,5.48356485366833 44.9230117797854,5.47767496109003 44.9667625427248,5.48836088180548 44.9896659851076,5.49306011199957 44.9954147338869,5.48043584823614 45.0130844116214,5.48360919952404 45.0227851867677,5.47641801834106 45.0267677307128,5.47772979736334 45.0334396362307,5.46522903442388 45.0435447692871,5.46651697158808 45.0540275573732,5.47577714920055 45.0702896118165,5.48456954956049 45.073040008545,5.49419593811047 45.0716705322267,5.48638820648193 45.0807838439943,5.47371768951422 45.0863876342773,5.46395015716558 45.0869293212892,5.44781160354626 45.0717926025391,5.43597459793091 45.0568733215335,5.42287302017223 45.0530929565432,5.41229724884045 45.0459632873536,5.39797306060791 45.0449943542481,5.38541698455811 45.0550842285156,5.38481283187878 45.0489616394045,5.39726829528803 45.0383338928223,5.38409471511841 45.0359802246097,5.3697967529298 45.0439491271973,5.34438991546637 45.0495338439944,5.34058618545544 45.0618896484376,5.32107734680176 45.0551719665528,5.32048225402843 45.0518608093262,5.30579757690441 45.0553817749026,5.30400276184088 45.0608596801758,5.29162025451666 45.0638885498049,5.28983402252203 45.0609283447266,5.27668666839611 45.0598526000976,5.27468824386602 45.056957244873,5.26895713806152 45.0544624328615,5.26633167266851 45.056163787842,5.26516580581676 45.0593872070315,5.24653720855719 45.0607261657715,5.24451303482061 45.0669746398929,5.23172807693481 45.0711669921875,5.22416925430304 45.0799140930176,5.21344947814953 45.0827484130859,5.18060493469244 45.0839538574219,5.17093992233276 45.0688285827639,5.16264057159418 45.0655670166017,5.14617252349854 45.0762825012208,5.13833475112926 45.0727729797365,5.13454294204706 45.074676513672,5.13895511627197 45.0800209045412,5.15607213973993 45.082790374756,5.1628942489624 45.098430633545,5.17405986785889 45.1052856445314,5.18688917160034 45.120128631592,5.18965148925781 45.140953063965,5.1839275360108 45.1498298645021,5.19073247909557 45.1542472839358,5.18845081329346 45.1707382202148,5.1757836341859 45.1812744140626,5.1655797958374 45.2002716064455,5.16741514205944 45.2101364135743,5.17808103561407 45.2166633605958,5.20171308517456 45.2173995971679,5.18409919738781 45.2326812744141,5.17654085159307 45.2484016418456,5.16253805160528 45.2467193603517,5.15310239791881 45.2563056945803,5.14107179641729 45.2452507019045,5.12219524383545 45.2454376220703,5.13063097000122 45.2836761474612,5.13878917694092 45.2964401245119,5.13536262512213 45.2982788085937,5.12099361419683 45.2973289489748,5.11636161804199 45.2913093566894,5.10791063308716 45.2878456115725,5.08853149414062 45.2862548828124,5.07541513442987 45.2818336486816,5.07356595993053 45.2832298278809,5.05911016464239 45.3136253356933,5.05279731750494 45.3189926147462,5.03291130065929 45.3181037902834,5.02064704895031 45.319290161133,5.0096521377564 45.3422317504885,4.99014711380005 45.3439865112305,4.95773983001715 45.3293800354004,4.94814777374273 45.328582763672,4.9281783103944 45.3227310180666,4.87877893447882 45.2977142333984,4.85861635208136 45.2985191345218,4.85879898071289 45.3089523315429,4.8004937171936 45.2983589172364,4.8004937171936 45.2983589172364,4.80948877334595 45.2876853942871,4.8088464736939 45.2588500976562,4.80163383483887 45.2459945678712,4.80320787429815 45.2252731323242,4.81220865249634 45.2049522399904,4.80587959289562 45.1975708007812,4.80585718154907 45.1917533874511,4.81168603897106 45.1837577819824,4.81024074554443 45.17493057251,4.8118371963501 45.1652565002441,4.82409429550177 45.1612586975099,4.82871294021606 45.1561279296876,4.8285746574403 45.154239654541,4.80413150787365 45.1312675476075,4.80403852462769 45.1224670410156,4.81478691101074 45.1114578247073,4.82502365112305 45.1039886474612,4.82959699630737 45.0980033874514,4.83046150207531 45.0840225219728,4.82781648635864 45.0785522460937,4.82915544509893 45.0728492736817,4.83583068847656 45.0682716369629,4.85359048843378 45.0638084411623,4.86074590682989 45.0554275512698,4.85410165786755 45.0462532043459,4.84194803237909 45.0379104614259,4.83989763259882 45.0288543701174,4.84540843963623 45.0199546813965,4.83670806884777 45.007511138916,4.85186767578125 44.9937210083008,4.85256624221813 44.9795341491701,4.86048984527594 44.9655494689941,4.87427711486822 44.956367492676,4.88658952713024 44.936653137207,4.87108516693115 44.9162254333498,4.86863374710083 44.9096031188966,4.85757541656494 44.9028892517092,4.85432386398327 44.8965225219727,4.86128139495861 44.8782234191896,4.85676383972168 44.8695564270022,4.8499836921693 44.8647956848147,4.84394598007208 44.8556289672852,4.8441185951234 44.8454666137695,4.83714723587036 44.8413162231447,4.82331609725958 44.8394889831545,4.82028055191046 44.8301925659181,4.82148504257214 44.8173828125001,4.80028200149548 44.8123283386232,4.80098962783825 44.8059844970703,4.79723167419434 44.8039817810058,4.79553556442255 44.7940406799319,4.7836470603944 44.7840766906739,4.76653623580927 44.7787666320804,4.76177167892462 44.7736015319825,4.76103973388672 44.7712173461915,4.76932096481329 44.7595863342287,4.75950670242315 44.748474121094,4.76415967941278 44.7320404052734,4.76422023773205 44.7150268554688,4.77196836471563 44.705997467041,4.78158998489391 44.6788444519044,4.78220987319958 44.6725234985352,4.77673912048346 44.6639137268067,4.77907276153559 44.6546974182129,4.77290248870855 44.6426315307619,4.75808954238903 44.6307373046877,4.75242614746105 44.6189346313477,4.74040460586548 44.602394104004,4.74420261383068 44.6008911132814,4.74116897583013 44.5887756347658,4.73286437988287 44.5858879089358,4.71087217330933 44.5820007324219,4.70640420913696 44.5763130187988,4.70472002029419 44.5635185241699,4.69573831558233 44.5630722045901,4.6924462318421 44.5465164184571,4.70658779144298 44.5340728759768,4.70312881469721 44.5245628356933,4.69310092926037 44.5167007446289,4.68788194656366 44.5029335021973,4.6894149780274 44.4923477172852,4.69953727722179 44.4800834655765,4.70041036605841 44.4693908691406,4.69528913497936 44.4457969665527,4.68928670883179 44.4405136108401,4.67597770690924 44.4367027282717,4.66710662841803 44.429912567139,4.6630535125733 44.4070243835452,4.66437339782721 44.3989448547366,4.64906454086304 44.3730735778811,4.64683723449707 44.3482818603516,4.65061521530151 44.3298072814943,4.65061521530151 44.3298072814943,4.67988395690929 44.3206939697266,4.67988395690929 44.3206939697266,4.71301698684692 44.3206481933596,4.7132186889649 44.3240051269531,4.72166299819946 44.3265914916993,4.76299524307257 44.3250999450684,4.7719402313233 44.3175544738771,4.78092908859264 44.3174552917482,4.79590034484869 44.3051109313967,4.80456352233892 44.303897857666,4.8039984703064 44.2692070007326,4.81251239776611 44.2580184936523,4.81344842910767 44.2324256896975,4.82534170150763 44.2284469604492,4.85709428787231 44.2459907531741,4.88025045394903 44.2617683410646,4.90128278732311 44.2642784118655,4.89703989028942 44.2584190368653,4.93291044235229 44.2621536254884,4.94283151626598 44.2690429687503,4.98959445953369 44.2857666015627,5.00247907638555 44.2860908508302,5.02950048446661 44.29789352417,5.06056451797491 44.3081398010254,5.07651185989374 44.2840843200685,5.10954713821411 44.2805480957033,5.1495294570924 44.3006820678712,5.15326309204096 44.3101806640627,5.16643428802496 44.3148574829102,5.16883945465082 44.3141250610353,5.17282676696777 44.3082122802736,5.17010641098022 44.2987365722659,5.16554355621349 44.2895812988284,5.15025329589855 44.2820816040041,5.14745807647711 44.2691688537597,5.16053152084362 44.2656173706056,5.16154766082769 44.2455902099611,5.15181398391735 44.238307952881,5.15000677108765 44.2352371215821,5.17560625076294 44.2208671569827,5.20877504348761 44.214424133301,5.23814964294445 44.2132339477539,5.2404465675354 44.2308273315432,5.24853563308722 44.2311210632326,5.25650882720953 44.2300567626955,5.28066778182983 44.2197952270508,5.303297996521 44.2053947448731,5.30362415313721 44.2087974548342,5.31799554824829 44.2087936401367,5.33572626113892 44.2043113708496,5.35579013824463 44.2136001586916,5.38452911376947 44.2011909484864,5.38128042221069 44.1923828125001,5.38664960861212 44.1792716979982,5.38324069976807 44.1552848815919,5.39695024490362 44.152339935303,5.41583395004278 44.1546516418458,5.42755651474005 44.149150848389,5.43575572967529 44.1522483825683,5.4383687973023 44.1388092041016,5.44757080078131 44.1367568969727,5.44951391220098 44.1240997314454,5.45471668243408 44.1192283630372,5.49878787994396 44.115718841553,5.49878787994396 44.115718841553,5.5076150894165 44.11775970459,5.51108837127686 44.1239585876466,5.54214572906494 44.1332626342773,5.5513334274292 44.1496467590334,5.5704226493836 44.1486167907714,5.58118820190435 44.1551513671876,5.58076906204235 44.1585922241214,5.56437444686901 44.1709022521975,5.57581567764282 44.1861953735354,5.57970428466797 44.1883201599123,5.59426021575939 44.1875,5.60205316543585 44.1915016174319,5.60932636260998 44.1907081604004,5.61695528030401 44.1786193847659,5.62977266311657 44.1740913391116,5.63879489898693 44.1662826538086,5.63113641738892 44.150577545166,5.67860555648804 44.1460990905765,5.68272829055786 44.163486480713,5.64583015441906 44.1674461364747,5.64389657974249 44.170524597168,5.65159273147583 44.1895751953127,5.67319631576549 44.1890449523927,5.67603731155396 44.1914329528811,5.67603731155396 44.1914329528811,5.68523120880138 44.1936836242676,5.68592214584356 44.1971817016602,5.67672252655035 44.2134094238283,5.68113279342651 44.2306938171387,5.67264413833618 44.2456703186038,5.67425203323376 44.2558631896973,5.68665266036993 44.2660713195804,5.67561006546015 44.2758865356446,5.64678144454962 44.2670898437501,5.64560699462902 44.2738914489749,5.63261222839367 44.2836990356446,5.63298845291138 44.2904510498047,5.64021158218384 44.2937011718752,5.63379907608032 44.3008804321292,5.62532663345337 44.3026237487795,5.61605691909796 44.3093833923343,5.60831832885754 44.3061180114747,5.61321592330927 44.3157730102542,5.63020944595348 44.327850341797,5.6312193870545 44.33122253418,5.62380027771007 44.3352165222168,5.61575222015387 44.332401275635,5.58692598342896 44.3320388793947,5.56227111816418 44.3345603942874,5.54912996292126 44.3305892944338,5.53997755050665 44.3324203491213,5.53690958023077 44.3420829772949,5.5210008621217 44.349231719971,5.50327301025396 44.3442687988281,5.49294424057018 44.3371353149417,5.47856998443615 44.3510398864746,5.46885633468634 44.3513488769534,5.46278190612799 44.3672370910646,5.4349536895752 44.3691177368166,5.43132829666149 44.3753318786622,5.44262170791637 44.3812675476075,5.44170188903803 44.3916816711426,5.43283939361572 44.4116630554199,5.41839742660534 44.4247703552249,5.43858242034918 44.4335556030276,5.47272253036499 44.4209327697755,5.48150348663341 44.4228706359866,5.48604440689098 44.4289665222171,5.49361515045177 44.4282188415528,5.4978489875794 44.4364242553713,5.49549007415783 44.438804626465,5.46851778030396 44.4463996887209,5.46383571624767 44.4520530700686,5.46021747589111 44.4685859680178,5.46682167053223 44.4735183715821,5.4589085578919 44.4885215759277,5.4578428268432 44.4981536865234,5.47084712982183 44.5000000000001,5.47492504119879 44.4942588806154,5.4831337928772 44.4912185668946,5.51102972030634 44.4915084838869,5.54971361160284 44.4799003601077,5.56043004989618 44.4743041992187,5.56909990310669 44.4765777587892,5.6036367416383 44.46549987793,5.61774349212658 44.4746322631837,5.62632894515986 44.4977760314942,5.63318777084345 44.5020980834962,5.65124416351324 44.4993209838869,5.66450405120844 44.5018959045412,5.64632606506348 44.5200767517092,5.62765312194836 44.5343589782717,5.61498689651489 44.5327758789063,5.59724903106695 44.5432739257813,5.60714769363409 44.5683517456055,5.61389827728277 44.5718193054202,5.61843109130859 44.5839653015139,5.6263189315797 44.5866241455079,5.62747669219971 44.5949707031251,5.63703060150158 44.6092185974124,5.6460919380188 44.6099205017092,5.64946174621593 44.6193809509279,5.6428422927857 44.6242599487306,5.63989305496216 44.6342735290529,5.64171552658092 44.6510848999026,5.65155076980597 44.655216217041,5.65930461883545 44.6510505676271,5.68349504470837 44.6499786376953,5.72550487518311 44.6400871276857,5.74915552139294 44.6510772705081,5.7537693977356 44.6605300903323,5.77111959457397 44.6542778015137,5.79062032699591 44.6532974243166,5.80101680755627 44.6748275756836,5.81327724456781 44.6799049377444,5.82995843887335 44.6912422180177,5.82545852661133 44.7009811401369,5.80146980285656 44.7067794799808),(4.98860979080206 44.4231986999512,5.00619602203369 44.4117164611819,5.0187602043153 44.4159774780275,5.01771593093872 44.4071388244631,5.0134978294372 44.4054412841796,5.01861667633062 44.3925895690918,5.03275918960577 44.390895843506,5.04759979248053 44.3821220397951,5.07088184356701 44.3832244873049,5.07031965255737 44.3764457702639,5.05326509475708 44.3648872375491,5.02505922317505 44.3610000610351,5.02145290374762 44.3443603515626,5.0090065002442 44.333766937256,5.01333475112921 44.3256530761719,4.99729824066173 44.3183746337893,4.99220514297485 44.3126220703125,4.98701763153082 44.2927169799804,4.97996759414673 44.2972488403321,4.92183589935303 44.3087959289554,4.88946294784546 44.3040199279786,4.89072704315191 44.313720703125,4.88221979141241 44.3252944946292,4.89532804489136 44.3380622863771,4.87911033630377 44.3453712463381,4.86952686309814 44.3450775146487,4.89291000366205 44.3648262023928,4.8933129310609 44.3678741455078,4.90708494186413 44.3746299743653,4.91176176071173 44.3882179260256,4.91016244888311 44.3951530456545,4.9185152053833 44.4077835083008,4.94550466537481 44.4149475097659,4.95196199417109 44.4200477600098,4.95927762985235 44.4197807312012,4.97054672241205 44.4298477172853,4.97509479522716 44.4294586181642,4.97949218750006 44.4236869812013,4.98860979080206 44.4231986999512))	0.0010	POINT(5.248130957313911 44.67578855265428)
51039	POLYGON((1.82320940494543 49.8797492980958,1.82730233669292 49.8777046203614,1.84048676490789 49.8830146789552,1.84048676490789 49.8830146789552,1.84885931015026 49.8872375488282,1.84852445125586 49.8940620422364,1.84852445125586 49.8940620422364,1.82287073135387 49.8944282531739,1.81246900558477 49.8872108459474,1.81246900558477 49.8872108459474,1.82320940494543 49.8797492980958))	0.0006	POINT(1.8325202226639519 49.88676948547372)
72665	POLYGON((15.3208837509155 46.6507720947265,15.314962387085 46.6535072326661,15.3081483840944 46.6546897888183,15.3081483840944 46.6546897888183,15.3102083206177 46.6573219299318,15.3098192214966 46.660228729248,15.302290916443 46.6699867248535,15.301459312439 46.6732749938965,15.3034725189209 46.6775741577149,15.3164930343629 46.6967239379884,15.3164930343629 46.6967239379884,15.3272266387939 46.7023239135742,15.3305864334106 46.704990386963,15.3306322097779 46.7078437805177,15.3246068954469 46.7196083068848,15.3240041732789 46.7226028442383,15.326364517212 46.724937438965,15.333137512207 46.7281188964844,15.333137512207 46.7281188964844,15.3432569503784 46.7258796691895,15.3464832305908 46.7239837646486,15.3418750762941 46.7189178466797,15.3407526016235 46.7154579162598,15.3442296981812 46.708351135254,15.3500623703004 46.7015647888185,15.3545360565187 46.6988792419435,15.3684196472169 46.6954841613771,15.3758850097657 46.688533782959,15.3872499465943 46.6831588745118,15.3872499465943 46.6831588745118,15.3870897293091 46.6693916320801,15.396653175354 46.6653861999512,15.396653175354 46.6653861999512,15.3919696807862 46.6539268493652,15.3919696807862 46.6539268493652,15.3810186386109 46.6548347473146,15.3708438873292 46.6509399414064,15.357276916504 46.6562690734863,15.3479413986207 46.6542015075684,15.3441095352174 46.6511039733887,15.3352031707764 46.6560859680176,15.3208837509155 46.6507720947265))	0.0006	POINT(15.343483040972512 46.68436245801977)
27534	POLYGON((-0.245812550187111 48.6174545288086,-0.25553885102272 48.619052886963,-0.265351593494358 48.6076660156251,-0.277221262454873 48.6016693115234,-0.277221262454873 48.6016693115234,-0.292406797409058 48.6041946411133,-0.292406797409058 48.6041946411133,-0.281680256128254 48.5818557739258,-0.281680256128254 48.5818557739258,-0.281076312065068 48.5819625854492,-0.281076312065068 48.5819625854492,-0.273781269788685 48.5866012573242,-0.267075598239899 48.5991821289062,-0.249054342508202 48.6031875610352,-0.241406232118493 48.6109848022461,-0.241406232118493 48.6109848022461,-0.245812550187111 48.6174545288086))	0.0006	POINT(-0.26901224534952917 48.599654912948616)
51065	POLYGON((1.85492956638336 50.2869987487794,1.84421503543859 50.2793197631835,1.82879328727722 50.2802352905275,1.81471586227428 50.275188446045,1.81471586227428 50.275188446045,1.80769884586334 50.2631607055664,1.80769884586334 50.2631607055664,1.84704923629766 50.262565612793,1.86413323879248 50.2747116088868,1.86365091800701 50.2780914306641,1.86365091800701 50.2780914306641,1.85492956638336 50.2869987487794))	0.0006	POINT(1.8373865105889609 50.27424656261101)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point