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
25426	POLYGON((2.90915822982788 48.5704078674318,2.9097735881806 48.5830307006837,2.9097735881806 48.5830307006837,2.92042946815491 48.5833435058594,2.92042946815491 48.5833435058594,2.92451071739197 48.5737380981446,2.93803071975708 48.5691871643067,2.93967437744152 48.5659294128419,2.93967437744152 48.5659294128419,2.93610715866089 48.5570220947266,2.91320204734802 48.5513572692871,2.91320204734802 48.5513572692871,2.90140295028687 48.5571594238282,2.9010443687439 48.5604629516602,2.9010443687439 48.5604629516602,2.90541982650763 48.5615196228027,2.90915822982788 48.5704078674318))	0.0006	POINT(2.9176798313856387 48.567330121994075)
49957	POLYGON((3.41095161437994 49.2797355651857,3.41320466995245 49.2762489318848,3.41320466995245 49.2762489318848,3.40398693084728 49.2729530334473,3.39288020133978 49.2613487243653,3.38382363319408 49.2644081115723,3.38054609298717 49.274486541748,3.36869144439697 49.2805709838868,3.36869144439697 49.2805709838868,3.36403775215155 49.2812232971192,3.36552929878246 49.2842216491699,3.37437915802008 49.2861366271973,3.37437915802008 49.2861366271973,3.39452290534979 49.2893981933593,3.39916920661938 49.2877731323243,3.40149450302118 49.2810592651367,3.41095161437994 49.2797355651857))	0.0006	POINT(3.3880932927132257 49.278907537460356)
63423	POLYGON((12.3317518234253 53.3180122375488,12.3251018524171 53.3213005065918,12.3251018524171 53.3213005065918,12.3110218048096 53.3232192993165,12.3107652664186 53.3272399902345,12.2913036346436 53.3286781311036,12.2795591354371 53.3278121948243,12.2781610488892 53.3270225524902,12.2787408828736 53.3264541625978,12.2718353271484 53.3240585327148,12.2646188735962 53.3250007629395,12.2602071762086 53.3239135742188,12.2574682235718 53.3250198364258,12.2600069046021 53.3277244567872,12.2524356842041 53.3315086364747,12.2452936172485 53.3330154418945,12.2425117492676 53.337776184082,12.2364301681519 53.3419799804688,12.2328243255615 53.3503646850586,12.2305374145509 53.3525619506837,12.2294349670411 53.3581619262695,12.2216043472291 53.3573455810548,12.2121849060059 53.3531608581543,12.2121849060059 53.3531608581543,12.2014093399047 53.3535804748536,12.1977510452271 53.3527183532714,12.1911201477051 53.3539505004884,12.1859703063965 53.350284576416,12.1849374771119 53.3469848632813,12.1874399185182 53.3463249206544,12.1868486404419 53.3433341979982,12.1685600280762 53.3391151428223,12.1565074920655 53.3497161865236,12.1558017730714 53.3560600280762,12.1519508361816 53.3615036010743,12.1412620544434 53.3590545654298,12.1394414901733 53.3614158630372,12.1394414901733 53.3614158630372,12.1310834884643 53.3658142089844,12.1344022750855 53.3677482604982,12.1254835128785 53.3732872009278,12.1179609298706 53.3714637756348,12.115842819214 53.3813095092774,12.1124868392944 53.3820533752443,12.1193447113037 53.3829269409181,12.1202850341798 53.3798828125001,12.1331615447999 53.3796768188478,12.1358709335328 53.3777351379395,12.1559610366822 53.3902587890625,12.1701202392578 53.3917160034181,12.1617164611817 53.3969306945802,12.1605339050293 53.4010467529298,12.1627416610718 53.4029388427736,12.17094039917 53.4049606323243,12.1755704879761 53.4076309204102,12.173701286316 53.4130592346191,12.1716251373292 53.4134559631348,12.1716251373292 53.4134559631348,12.1730947494508 53.4145126342774,12.1719951629639 53.4164505004883,12.1815605163575 53.4183082580568,12.1892395019531 53.41609954834,12.1892395019531 53.41609954834,12.1964778900147 53.4126205444337,12.1970472335817 53.4148864746094,12.2009868621826 53.4179229736328,12.2081346511842 53.4175453186036,12.2049398422242 53.4251785278321,12.208345413208 53.426441192627,12.2144708633423 53.4237403869629,12.2146682739258 53.4195594787598,12.2184553146362 53.4201889038086,12.2224025726319 53.4187774658204,12.2281093597412 53.4196510314943,12.2392597198486 53.4162216186524,12.2410230636597 53.4094619750976,12.2587451934815 53.4135284423828,12.2615118026733 53.4115524291993,12.2677001953126 53.4124984741212,12.2760248184204 53.4152374267578,12.2808895111083 53.4112548828126,12.2840261459351 53.4099540710449,12.2857990264893 53.4076805114746,12.292799949646 53.405975341797,12.2930517196656 53.4040298461915,12.3003282546997 53.3973083496094,12.3060922622682 53.3959388732911,12.308687210083 53.3939323425293,12.308687210083 53.3939323425293,12.2947006225586 53.3880500793457,12.2871246337891 53.3836860656738,12.2799167633057 53.3816757202148,12.2750558853149 53.3789787292481,12.2796611785889 53.3753700256349,12.2903585433961 53.3707923889161,12.2992525100709 53.3699493408204,12.3083639144897 53.3674430847168,12.3085136413574 53.3663253784181,12.3118467330934 53.3662490844727,12.3125829696655 53.3644142150879,12.3118495941162 53.363021850586,12.300043106079 53.3635482788086,12.2994890213013 53.3591880798341,12.2962856292726 53.3591423034669,12.2898073196412 53.3546714782715,12.3114595413209 53.3520965576172,12.31507396698 53.3566741943359,12.3184251785278 53.357048034668,12.3184251785278 53.357048034668,12.3254194259645 53.3481597900391,12.32661151886 53.3439254760743,12.3375654220582 53.3425483703614,12.3447732925416 53.3339004516603,12.3429775238038 53.3318862915039,12.3429775238038 53.3318862915039,12.3404254913331 53.3297767639161,12.3317518234253 53.3180122375488))	0.0006	POINT(12.236747980117837 53.37278060255381)
69039	POLYGON((13.0409440994262 51.2631492614747,13.0412340164185 51.2665824890137,13.0445442199706 51.2667694091797,13.0421571731568 51.2729263305665,13.0472869873048 51.2740669250489,13.0469541549684 51.2758369445801,13.0501966476442 51.2760734558106,13.0499248504638 51.2786827087402,13.0485706329346 51.2796363830566,13.049412727356 51.2816162109376,13.0477561950685 51.2833366394044,13.0488338470459 51.2843933105469,13.0488481521607 51.2864723205568,13.0522937774659 51.2872428894044,13.0525732040406 51.2881584167482,13.0497188568116 51.2881927490235,13.0430746078491 51.2916412353516,13.0412111282349 51.2940406799317,13.040506362915 51.2927055358887,13.0329389572144 51.2945251464844,13.0331163406372 51.2956619262696,13.0302772521973 51.2957267761231,13.0307044982911 51.2980194091798,13.0358800888062 51.2989158630371,13.0360193252565 51.3014526367189,13.0436172485352 51.3035392761231,13.0416526794435 51.3103675842285,13.038522720337 51.3106536865234,13.0378694534303 51.3144378662109,13.0378694534303 51.3144378662109,13.0365152359009 51.3154144287109,13.0362062454224 51.3262329101564,13.0327529907228 51.3269348144532,13.027723312378 51.335823059082,13.0252752304078 51.3383522033693,13.0085668563842 51.344264984131,13.0098695755005 51.3457565307617,13.0045671463013 51.3476333618164,13.0021324157715 51.3448944091798,12.9878797531128 51.3498001098633,12.9879913330078 51.3484115600586,12.9831790924073 51.3487281799316,12.9831991195678 51.3469619750977,12.9786434173584 51.3472557067872,12.9758491516114 51.3455505371094,12.9751615524293 51.3538742065431,12.9641380310059 51.3547554016114,12.9577646255494 51.3541221618653,12.9587030410767 51.35205078125,12.9535074234009 51.3508567810059,12.9430923461915 51.351001739502,12.9396686553956 51.3501434326172,12.9364938735963 51.3490867614746,12.9369106292725 51.3477249145508,12.9290246963502 51.3475761413574,12.928560256958 51.3515625000001,12.928560256958 51.3515625000001,12.9178352355958 51.3542861938478,12.9100561141968 51.3539772033693,12.9104585647584 51.3506851196289,12.9027872085571 51.3458366394043,12.9007701873779 51.3476715087891,12.8984537124634 51.3470687866211,12.9003372192383 51.3448867797852,12.8997774124147 51.341579437256,12.90207862854 51.3410644531251,12.8999586105347 51.3376121520996,12.9002351760864 51.3330001831055,12.9002351760864 51.3330001831055,12.8990430831909 51.3319168090821,12.8985300064088 51.325653076172,12.9028825759888 51.3247985839844,12.9078855514527 51.3221206665039,12.8965044021608 51.3214988708497,12.8896293640138 51.319694519043,12.887990951538 51.3221664428712,12.8838663101196 51.3185348510743,12.8797788619995 51.3181037902833,12.8764944076539 51.315975189209,12.8814525604249 51.313804626465,12.8715591430665 51.3054962158203,12.8701066970825 51.3060111999512,12.8701066970825 51.3060111999512,12.8717880249025 51.3004531860353,12.8884429931641 51.2929306030273,12.8917636871338 51.2930068969727,12.8921270370484 51.2911720275879,12.899248123169 51.2881355285645,12.8962888717653 51.2853355407716,12.8962154388428 51.2811584472657,12.8975067138672 51.2806015014649,12.8996000289917 51.2813873291017,12.9004440307617 51.2802276611329,12.8994045257569 51.2784461975099,12.901894569397 51.2774772644044,12.9122619628906 51.2773017883302,12.9088964462281 51.2719612121583,12.9145164489746 51.2707557678223,12.9140501022338 51.2675971984864,12.9220552444459 51.2681159973145,12.9218139648438 51.2670669555665,12.9227609634401 51.2668800354004,12.9257488250732 51.2699890136718,12.9269714355469 51.2699050903321,12.9287080764771 51.2674636840821,12.9270219802858 51.267333984375,12.9271259307862 51.2658462524414,12.9294719696045 51.266284942627,12.9290876388551 51.2651329040527,12.9301977157593 51.2627792358398,12.9313888549805 51.2627830505372,12.9315776824952 51.2612037658692,12.9297428131104 51.2609519958496,12.930311203003 51.2583312988282,12.9240036010743 51.2581977844239,12.9257793426514 51.2524375915528,12.9255619049073 51.249122619629,12.9298028945924 51.2484741210938,12.9302358627319 51.2471771240235,12.9302358627319 51.2471771240235,12.9374237060548 51.2482986450195,12.9374055862427 51.247127532959,12.9433460235597 51.2474555969238,12.9426193237305 51.2486228942872,12.9435338973999 51.2496376037599,12.9452552795411 51.2485656738282,12.9489574432374 51.2488670349122,12.9547786712646 51.2461280822754,12.9570083618165 51.245979309082,12.958167076111 51.2437705993652,12.9606313705445 51.2437171936036,12.9594812393189 51.2404289245606,12.9636869430542 51.2426528930665,12.9642114639282 51.2446861267091,12.9675741195679 51.2442817687989,12.967345237732 51.2434768676757,12.9750499725342 51.2430076599121,12.97518825531 51.2455787658692,12.9814548492432 51.2460861206055,12.9827222824096 51.2493896484374,12.9848518371582 51.2500381469727,12.9943504333497 51.2490272521973,12.995065689087 51.2524414062499,12.9987630844117 51.2547492980958,13.0096120834351 51.2553367614747,13.009123802185 51.2629776000977,13.0106678009034 51.2663040161133,13.0179758071899 51.2624397277833,13.0196895599366 51.2638702392579,13.0279636383057 51.2611427307129,13.0383548736573 51.2617301940918,13.0400094985962 51.2634735107423,13.0409440994262 51.2631492614747))	0.0006	POINT(12.961523564238334 51.293420666142524)
1407658	POLYGON((-8.52290916442871 42.8260231018068,-8.52473735809326 42.8270339965821,-8.52613353729242 42.8324203491212,-8.52393054962158 42.833610534668,-8.52394866943354 42.8366928100586,-8.53084468841553 42.8392677307129,-8.5289363861084 42.8403434753419,-8.52950954437256 42.8417091369628,-8.53259086608881 42.8415527343751,-8.53827762603754 42.8462982177735,-8.54145336151123 42.8462524414063,-8.54611110687256 42.8407783508301,-8.55085945129395 42.8456954956055,-8.56100273132319 42.8421783447265,-8.56418228149408 42.8448944091797,-8.57182216644276 42.8478012084962,-8.58104801177979 42.8482055664063,-8.58084487915039 42.8543815612794,-8.58570671081537 42.8548088073732,-8.58671188354487 42.8563232421875,-8.5926456451416 42.8560523986816,-8.59287929534906 42.8602447509767,-8.60235595703119 42.8565292358398,-8.60224437713612 42.8589515686036,-8.6031351089477 42.8602638244629,-8.60463905334473 42.8585243225098,-8.60628700256342 42.8639907836914,-8.6171150207519 42.8659934997559,-8.6185827255249 42.8688125610352,-8.62173271179199 42.8691329956055,-8.62341022491455 42.8711662292481,-8.63025474548334 42.8722610473634,-8.62890052795404 42.8748588562013,-8.6302232742309 42.8760719299316,-8.6229248046875 42.8820762634278,-8.62317085266108 42.8858604431153,-8.62084579467768 42.8889656066896,-8.62415313720703 42.8987960815431,-8.62131595611572 42.9033889770509,-8.6229772567749 42.9072494506836,-8.62059307098389 42.9076957702636,-8.62163925170898 42.9089355468749,-8.6182336807251 42.917137145996,-8.61061286926258 42.9155006408693,-8.60900783538813 42.9171104431152,-8.60464763641357 42.9146766662598,-8.59360599517817 42.9124488830568,-8.58862400054926 42.9138259887696,-8.59352588653564 42.9255943298341,-8.59835815429676 42.9295616149903,-8.59438991546625 42.9357948303223,-8.60567188262939 42.9434471130372,-8.61530590057367 42.9364776611329,-8.61736583709717 42.936637878418,-8.61965656280518 42.9386405944824,-8.6254158020019 42.9400138854981,-8.6247730255127 42.9434127807618,-8.63125991821278 42.9453620910645,-8.63060760498047 42.9496154785156,-8.62710189819336 42.9509582519531,-8.62827205657953 42.9526138305663,-8.61606693267822 42.9664649963379,-8.60954570770264 42.9672775268556,-8.60714244842529 42.9702072143555,-8.6027946472168 42.9684028625488,-8.59706783294672 42.9745635986328,-8.59232139587402 42.9749336242676,-8.59250259399414 42.9792251586915,-8.58858489990234 42.9837226867676,-8.57763385772705 42.9857521057129,-8.57806015014648 42.9808502197265,-8.5726146697998 42.9697380065918,-8.56938076019287 42.9686813354492,-8.56876754760737 42.9660911560059,-8.56257057189941 42.9623680114747,-8.55348205566406 42.9618873596191,-8.5509414672851 42.958309173584,-8.54310035705566 42.9549293518067,-8.54040622711182 42.9514389038087,-8.5393648147583 42.9439201354982,-8.53677845001221 42.9429626464844,-8.52407646179199 42.9488983154297,-8.5229320526123 42.9581298828126,-8.5095329284668 42.9620704650879,-8.50779438018799 42.9664764404297,-8.51885318756104 42.9674377441407,-8.52295112609858 42.9814186096192,-8.5147590637207 42.9815521240236,-8.51296806335449 42.9896049499512,-8.50238609313965 42.9826164245607,-8.49417018890375 42.9861831665038,-8.49102878570557 42.9856033325196,-8.48572826385498 42.9811668395996,-8.48529529571533 42.9769859313965,-8.47513866424561 42.9794273376465,-8.47259998321533 42.9773406982422,-8.46854305267334 42.9770851135255,-8.46052265167236 42.972900390625,-8.45209217071533 42.971420288086,-8.44489860534668 42.9649391174316,-8.43311595916748 42.9698944091797,-8.43077754974365 42.9654960632324,-8.42794227600098 42.9704627990723,-8.41924285888666 42.9692420959473,-8.41588592529291 42.9664916992189,-8.40985774993891 42.9656791687011,-8.40494632720942 42.967399597168,-8.39986991882324 42.9739646911622,-8.38947105407715 42.9711074829103,-8.39519786834711 42.9654159545898,-8.40133380889887 42.9492759704589,-8.4185962677002 42.9307136535645,-8.41938877105713 42.9281539916993,-8.41583824157709 42.9255256652833,-8.41640090942383 42.9234199523926,-8.4144287109375 42.9228706359864,-8.41260433197021 42.9177207946778,-8.41652584075928 42.9038124084473,-8.41496658325184 42.8900985717773,-8.41890811920166 42.8839492797851,-8.42608261108398 42.8817100524903,-8.43968009948725 42.8804397583008,-8.446702003479 42.8733100891114,-8.44885063171381 42.8749351501465,-8.47303295135498 42.8679733276367,-8.47071743011469 42.8542671203614,-8.46727561950672 42.8517456054688,-8.46554374694819 42.8442077636719,-8.4742317199707 42.8385696411133,-8.47708988189697 42.8386497497558,-8.47718334197992 42.8361015319825,-8.4807300567627 42.833351135254,-8.48576927185053 42.8246536254883,-8.48992824554443 42.8241233825685,-8.49721908569336 42.8267593383789,-8.50362777709955 42.8266296386719,-8.50820159912104 42.8285446166993,-8.52290916442871 42.8260231018068))	0.0006	POINT(-8.535128370688758 42.912193966608)
1403266	POLYGON((2.02224302291864 41.7077178955078,2.02879095077515 41.7109260559083,2.03272700309759 41.7165603637696,2.03838610649115 41.717010498047,2.04851508140575 41.7108840942384,2.06466007232666 41.7119026184083,2.06612801551819 41.7140769958496,2.07703590393078 41.7099227905275,2.08466601371765 41.7108535766602,2.08708500862122 41.7078590393067,2.08412194252014 41.7021446228028,2.08606600761425 41.6952629089355,2.09053993225109 41.6942901611329,2.09656405448908 41.6881256103516,2.09680509567272 41.6816139221193,2.09990906715399 41.6815567016601,2.1064760684967 41.6781845092773,2.11293506622326 41.6692199707031,2.11258101463324 41.6667404174805,2.10451793670666 41.6646804809571,2.10282206535345 41.661304473877,2.09591388702398 41.6589546203613,2.09088611602783 41.6596145629884,2.08828592300426 41.6611785888672,2.08865690231323 41.6636009216309,2.08591103553783 41.6663970947266,2.08001708984386 41.6664047241212,2.07131791114807 41.6634216308595,2.06625604629528 41.659812927246,2.04966807365429 41.6566543579102,2.04069995880127 41.6529426574708,2.03543901443487 41.655975341797,2.02861595153814 41.6546821594239,2.02597188949596 41.6564903259277,2.0208420753479 41.6567687988281,2.01899790763855 41.655445098877,2.01457405090338 41.6569061279298,2.01453304290777 41.6585235595703,2.01208496093756 41.6562232971192,2.01050806045538 41.6581840515138,2.01094102859497 41.6657638549805,2.00460004806513 41.6757812500001,2.00615906715393 41.6781005859376,2.01053500175487 41.6783218383788,2.01307201385504 41.6805000305177,2.00949096679688 41.6863517761231,2.00953006744385 41.6924209594728,2.01303791999823 41.6920852661133,2.02034497261047 41.6967620849611,2.02205610275274 41.6989936828614,2.0201370716095 41.7053413391113,2.02224302291864 41.7077178955078))	0.0006	POINT(2.053385482114949 41.67979296515975)
53822	POLYGON((6.13754701614391 43.3081245422364,6.14851617813116 43.3060417175294,6.14851617813116 43.3060417175294,6.15737009048468 43.3083381652833,6.1649279594422 43.3171043395997,6.20261096954351 43.321575164795,6.21138572692871 43.3194885253907,6.21138572692871 43.3194885253907,6.21470689773571 43.3257560729982,6.22722578048717 43.3299636840821,6.23048496246338 43.3361778259278,6.23048496246338 43.3361778259278,6.23208904266357 43.3487243652345,6.17523717880255 43.3708305358887,6.17523717880255 43.3708305358887,6.16603422164923 43.3702354431152,6.1475243568421 43.3603401184082,6.13835287094122 43.3589248657227,6.13835287094122 43.3589248657227,6.13970422744757 43.3488540649415,6.13498783111578 43.3320121765137,6.13897228240967 43.3184471130372,6.13754701614391 43.3081245422364))	0.0006	POINT(6.175984295931778 43.33510919050744)
13902	POLYGON((15.4437141418458 40.6406784057618,15.4285354614258 40.6361083984376,15.4224185943604 40.6303977966309,15.4224185943604 40.6303977966309,15.3917818069458 40.6424827575685,15.387125968933 40.6468505859375,15.3733215332031 40.6532096862792,15.3583202362061 40.6567497253419,15.3572607040405 40.6576995849609,15.3481693267823 40.6724281311036,15.3518171310426 40.7029495239258,15.3508596420289 40.7073554992677,15.3461971282959 40.7119369506837,15.3416013717651 40.712272644043,15.3416013717651 40.712272644043,15.3463401794434 40.7188835144043,15.3498764038086 40.7208595275879,15.3528175354003 40.7215118408204,15.3686838150025 40.717067718506,15.3809976577759 40.715259552002,15.3829212188721 40.7157020568848,15.386528968811 40.7228393554688,15.386528968811 40.7228393554688,15.3933401107788 40.7185058593751,15.4034337997436 40.7173271179199,15.4116430282593 40.712818145752,15.4116430282593 40.712818145752,15.4067106246949 40.7109832763672,15.4012155532837 40.7110633850098,15.3993749618531 40.7119102478028,15.3965311050416 40.7097778320312,15.4107093811036 40.6934471130372,15.4206886291505 40.686248779297,15.4290113449097 40.6756858825685,15.4433336257935 40.6441497802734,15.4437141418458 40.6406784057618))	0.0006	POINT(15.387070655822773 40.69067110334128)
54783	POLYGON((4.46302509307856 45.1019973754884,4.47575855255138 45.1002502441407,4.48078298568726 45.1089668273925,4.48653745651239 45.1039352416992,4.49288034439098 45.1085968017579,4.49288034439098 45.1085968017579,4.51374530792248 45.1032829284668,4.51476144790655 45.0938377380372,4.51476144790655 45.0938377380372,4.50815820693975 45.084716796875,4.49317312240595 45.0757598876954,4.49086856842047 45.0689277648926,4.49550199508661 45.0592308044434,4.49550199508661 45.0592308044434,4.48611402511597 45.0588150024415,4.47401571273809 45.0635681152344,4.45139551162731 45.0669288635254,4.45139551162731 45.0669288635254,4.4126119613648 45.0659408569337,4.40436077117931 45.0743751525879,4.40574312210083 45.0813369750977,4.40574312210083 45.0813369750977,4.4102144241333 45.0827484130859,4.41158008575439 45.0930404663085,4.43642473220831 45.1094551086426,4.43642473220831 45.1094551086426,4.44201421737671 45.1116905212402,4.44201421737671 45.1116905212402,4.46302509307856 45.1019973754884))	0.0006	POINT(4.463871036257097 45.087445667811835)
18664	POLYGON((13.7741193771362 37.5005111694336,13.7727565765382 37.4987106323243,13.7655124664307 37.4942283630372,13.7656030654908 37.48392868042,13.7676591873169 37.4805793762207,13.7698535919189 37.4805030822755,13.7698535919189 37.4805030822755,13.7732591629029 37.4776916503907,13.768186569214 37.4560317993164,13.7644166946411 37.4529304504395,13.7614488601685 37.4457168579101,13.760106086731 37.4379768371583,13.760106086731 37.4379768371583,13.7747631072998 37.441707611084,13.7950906753541 37.4379501342773,13.80087184906 37.4347839355469,13.8039674758912 37.4349212646485,13.8060855865478 37.4366836547852,13.8060855865478 37.4366836547852,13.8073205947877 37.4407806396484,13.8059101104736 37.4462890624999,13.8059930801392 37.4595756530762,13.8080997467042 37.4657516479492,13.8111743927003 37.4672889709473,13.8130149841308 37.470272064209,13.8123979568482 37.4742240905763,13.8111591339112 37.47607421875,13.8111591339112 37.47607421875,13.804186820984 37.4771308898926,13.7948694229126 37.4806251525879,13.7826309204102 37.4918479919434,13.7801628112794 37.4975090026855,13.7766580581666 37.5002021789551,13.7741193771362 37.5005111694336))	0.0006	POINT(13.787408568642395 37.465868631998724)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point