Datenbank-Dokumentation

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

Beschreibung
Enthält mit dem Douglas-Peucker-Algorithmus simplifizierte Varianten der Polygondaten aus der Tabelle `Orte`, sowie (für bestimmte `Kategorien`) Hexagone, die dem jeweiligen Polygon möglichst gut entsprechen.

Spalten
Der Name von Spalten, die Teil des Primärschlüssels sind wird fett dargestellt, die Namen von Fremdschlüsseln unterstrichen. Kursivierte Werte im Feld Datentyp bedeuten, dass der Wert optional (nullable) ist.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlüssel, der auf die Tabelle `orte` verweist.
geodaten

geometry

Dieser Datentyp speichert geometrische Daten in MySQL-Datenbanken. Die einfachste Möglichkeit diese manuell einzutragen, ist die Verwendung der GeomFromText-Funktion. Diese erlaubt die Eingabe der Daten im WKT-Format.
Alle geographischen Koordinaten in VerbaAlpina werden in der Reihenfolge <Längengrad>, <Breitengrad> angegeben. Die Eingabe eines Punktes mit den Koordinaten Breitengrad 48.135876 und Längengrad 11.583720 könnte somit folgendermaßen über die phpMyAdmin-Oberfläche angegeben werden:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone.
mittelpunkt

point

Dieser Datentyp speichert geometrische Daten in MySQL-Datenbanken. Die einfachste Möglichkeit diese manuell einzutragen, ist die Verwendung der GeomFromText-Funktion. Diese erlaubt die Eingabe der Daten im WKT-Format.
Alle geographischen Koordinaten in VerbaAlpina werden in der Reihenfolge <Längengrad>, <Breitengrad> angegeben. Die Eingabe eines Punktes mit den Koordinaten Breitengrad 48.135876 und Längengrad 11.583720 könnte somit folgendermaßen über die phpMyAdmin-Oberfläche angegeben werden:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
62421MULTIPOLYGON(((9.7905740737915 53.2943649291993,9.79232215881348 53.2938423156738,9.7910270690918 53.2913818359376,9.78858852386475 53.2900543212892,9.78431797027594 53.2897605895997,9.78421211242687 53.2888793945314,9.79100227355957 53.2891998291016,9.79188919067394 53.287223815918,9.77690029144298 53.2871780395509,9.77552509307873 53.2862777709961,9.77182102203381 53.2889785766602,9.77156162261969 53.2910614013672,9.76861763000483 53.2921600341796,9.76861763000483 53.2921600341796,9.76672744750988 53.2921752929688,9.765700340271 53.2935333251953,9.75896835327148 53.2969055175782,9.75864696502691 53.298496246338,9.7560653686524 53.3005905151367,9.75704956054693 53.3021202087403,9.75380516052257 53.3028106689454,9.75278568267822 53.3049926757812,9.74923038482672 53.3069381713868,9.74929237365728 53.3090782165527,9.73423385620123 53.309627532959,9.73423385620123 53.309627532959,9.73500156402599 53.3061561584474,9.72345352172846 53.3030166625978,9.72018718719477 53.3001937866211,9.72099685668945 53.2976799011231,9.70341110229504 53.2963104248048,9.70596790313721 53.2932128906251,9.70370197296143 53.2934112548829,9.70081996917736 53.2959136962891,9.69634342193604 53.2954177856445,9.69457817077637 53.2934646606446,9.68937110900885 53.2927284240723,9.68793296813971 53.2942771911622,9.68900299072277 53.2964324951172,9.69303035736084 53.2977142333984,9.6883220672608 53.2975959777831,9.69017982482922 53.2985496520996,9.68487167358404 53.2986373901368,9.68436622619629 53.3129730224609,9.68436622619629 53.3129730224609,9.66471958160406 53.304859161377,9.65296840667719 53.2987060546875,9.65296840667719 53.2987060546875,9.65552711486816 53.296184539795,9.67077445983892 53.3020629882814,9.66701602935797 53.2960700988769,9.66263961791992 53.2950859069825,9.65888690948486 53.2956314086914,9.6572780609132 53.2946701049805,9.65790653228765 53.2930831909181,9.6524162292481 53.2930755615236,9.65152168273926 53.2919540405275,9.65152168273926 53.2919540405275,9.65326595306402 53.2906951904297,9.64225482940674 53.288890838623,9.63673210144037 53.2898178100587,9.63330173492437 53.2863502502441,9.63330173492437 53.2863502502441,9.64006900787354 53.2864494323731,9.64449787139904 53.2848701477051,9.64880084991461 53.2880172729492,9.66960144042969 53.2902717590333,9.67709064483654 53.2880020141602,9.67632198333746 53.2866439819336,9.67865467071528 53.2828521728516,9.67763042449963 53.2824287414551,9.67763042449963 53.2824287414551,9.69007205963135 53.275863647461,9.69812011718756 53.2736053466798,9.69485378265387 53.2726593017579,9.69746875762945 53.2715187072754,9.69655704498291 53.2697219848633,9.6989107131958 53.2691688537599,9.69897842407232 53.2676696777344,9.70820713043219 53.2639961242677,9.70486164093018 53.2581710815431,9.70328330993647 53.2577095031739,9.70319843292242 53.2565002441406,9.69317531585705 53.2564315795899,9.69284152984631 53.2548027038575,9.69082069396973 53.2550468444825,9.69117164611811 53.2559661865234,9.69017696380615 53.2564125061035,9.68208694458008 53.2561683654786,9.68115615844727 53.252857208252,9.68002891540522 53.252254486084,9.67639350891119 53.2529258728028,9.67622184753418 53.2519226074218,9.67381286621094 53.2509651184083,9.66934967041027 53.2529907226563,9.66594886779797 53.2522659301759,9.65973663330084 53.2553291320801,9.63965320587164 53.2521781921388,9.63864994049084 53.2465476989746,9.63457202911388 53.2455368041993,9.63457202911388 53.2455368041993,9.63549041748047 53.2443542480469,9.64219570159918 53.2416954040528,9.64219570159918 53.2416954040528,9.64334964752197 53.2424507141114,9.64551639556896 53.2420768737794,9.64556503295904 53.2428550720214,9.65017032623291 53.2446632385254,9.65237712860113 53.2428894042969,9.65817928314209 53.2419242858887,9.65944290161133 53.2432518005371,9.66207313537603 53.2428398132325,9.66364574432379 53.2420883178712,9.66210937500011 53.2409172058107,9.66468334197992 53.2403068542481,9.66468334197992 53.2403068542481,9.66834545135498 53.2394943237306,9.66862106323248 53.2380485534669,9.6722326278686 53.2373085021974,9.6750946044923 53.2347564697265,9.68837833404547 53.2359161376953,9.69341850280762 53.2350540161133,9.69887351989757 53.2404441833496,9.68070316314697 53.2417602539064,9.6828556060791 53.2428817749024,9.68382167816173 53.2489814758301,9.70176982879644 53.2525978088379,9.70811653137218 53.2523002624512,9.70856857299816 53.2551918029786,9.71676731109619 53.2554168701172,9.73442554473877 53.2648239135743,9.74076080322266 53.2608451843262,9.74169826507568 53.2612266540527,9.74350738525396 53.259792327881,9.743088722229 53.2588348388672,9.74687480926525 53.2574501037598,9.74997901916504 53.2598190307618,9.75487709045404 53.2596511840821,9.75487709045404 53.2596511840821,9.75761699676514 53.259433746338,9.75565624237072 53.2533721923829,9.76284790039057 53.251522064209,9.76895332336437 53.2656097412111,9.77820205688471 53.2665138244628,9.7837285995484 53.2660560607911,9.78934288024902 53.2686500549316,9.80357360839849 53.2729454040528,9.80458068847668 53.2709693908692,9.80458068847668 53.2709693908692,9.83014488220215 53.2715034484863,9.84596920013439 53.2816123962402,9.84596920013439 53.2816123962402,9.85159778594976 53.2904930114747,9.84797859191895 53.2908096313478,9.84866619110113 53.288932800293,9.84473896026623 53.2887344360351,9.84305095672607 53.2933120727538,9.8177108764649 53.2973747253419,9.79685497283947 53.2946434020997,9.79737949371349 53.2956619262695,9.79396057128906 53.2964515686035,9.79396057128906 53.2964515686035,9.79244136810303 53.296703338623,9.7905740737915 53.2943649291993)),((9.64898967742926 53.2491416931153,9.64674663543713 53.2489013671875,9.64669609069824 53.2452850341797,9.64889621734625 53.2454376220703,9.64898967742926 53.2491416931153)),((9.68807220458979 53.2541885375978,9.69091510772705 53.254264831543,9.69310283660883 53.2528190612793,9.6813755035401 53.2507820129395,9.68108463287354 53.2515296936036,9.68348312377935 53.2517471313477,9.6857967376709 53.2540321350098,9.68807220458979 53.2541885375978)),((9.64637088775635 53.2830200195312,9.64325523376465 53.2841491699218,9.63835620880133 53.2840576171876,9.63835620880133 53.2840576171876,9.63699340820312 53.2816696166992,9.63335514068598 53.2813186645508,9.62873077392589 53.2740325927736,9.62873077392589 53.2740325927736,9.64201354980474 53.2726135253907,9.64637088775635 53.2830200195312)),((9.66405391693115 53.239112854004,9.66740798950195 53.2366790771484,9.67210197448736 53.2364616394044,9.67215251922607 53.2352371215821,9.67457485198975 53.2337646484376,9.67457485198975 53.2337646484376,9.66013050079357 53.2337303161621,9.64706993103027 53.2407035827638,9.64706993103027 53.2407035827638,9.65325355529785 53.2409553527831,9.65319728851318 53.2397232055664,9.65945339202875 53.240146636963,9.66405391693115 53.239112854004)))0.0006POINT(9.711110278035749 53.27438220383196)
72141POLYGON((14.1736669540406 48.178150177002,14.1495189666747 48.1519279479982,14.1495189666747 48.1519279479982,14.1619844436646 48.1350555419923,14.1649456024171 48.1338119506837,14.1752767562866 48.1324005126953,14.1752767562866 48.1324005126953,14.1884813308716 48.1375846862794,14.1884813308716 48.1375846862794,14.1946372985841 48.1454772949219,14.1938676834107 48.1475296020508,14.188648223877 48.152156829834,14.1885290145875 48.1534652709962,14.2178001403809 48.1602439880372,14.2178001403809 48.1602439880372,14.1876029968261 48.1805534362794,14.183074951172 48.1806983947755,14.1736669540406 48.178150177002))0.0006POINT(14.182300679823957 48.15124780991506)
64302POLYGON((13.3383369445801 51.6588516235353,13.3963594436646 51.6657791137695,13.4048156738282 51.6685409545899,13.4046134948732 51.6730957031251,13.4066410064698 51.6751518249513,13.4062633514404 51.6760406494142,13.4272146224975 51.6798362731934,13.4265699386597 51.6822128295898,13.4336071014405 51.682415008545,13.4336071014405 51.682415008545,13.4373254776002 51.6877632141114,13.4376115798951 51.6895103454589,13.439094543457 51.6913833618164,13.4410400390625 51.6919097900391,13.4394197463989 51.6937408447266,13.4390583038331 51.695785522461,13.4415245056152 51.6978492736818,13.4471263885499 51.6982307434083,13.4468641281128 51.6993293762208,13.4482278823854 51.699806213379,13.4585781097413 51.6996574401855,13.4621381759644 51.7004852294921,13.4605255126954 51.7020225524903,13.4599514007569 51.7101097106933,13.4558391571045 51.7168045043946,13.4459114074707 51.7166748046876,13.4462718963622 51.7218132019043,13.454556465149 51.7223739624025,13.4539575576783 51.7243156433106,13.4554109573364 51.724594116211,13.454785346985 51.7263565063477,13.4522943496704 51.7264976501466,13.4504528045655 51.7286262512207,13.4458084106445 51.7294502258301,13.4365320205689 51.7283668518068,13.4291543960572 51.7288475036621,13.4276447296144 51.7346916198732,13.4213609695435 51.7357482910157,13.415919303894 51.7347755432129,13.4146318435669 51.7336807250977,13.4072122573854 51.7342071533204,13.4063072204591 51.7366027832032,13.4090023040772 51.7377166748047,13.4079303741456 51.7381858825684,13.393271446228 51.7349319458008,13.3930730819702 51.7390899658204,13.3976593017579 51.7393913269044,13.4001054763794 51.7431030273438,13.397071838379 51.7439422607423,13.4026393890381 51.7480201721193,13.4035491943361 51.7525444030762,13.4074335098266 51.7561225891113,13.4074335098266 51.7561225891113,13.3975648880006 51.7563781738281,13.3911819458009 51.7581367492677,13.3909301757813 51.7628860473633,13.3888235092164 51.7659950256347,13.3782529830934 51.7720680236818,13.34503364563 51.772258758545,13.3454704284669 51.7757682800293,13.349126815796 51.7843475341798,13.349126815796 51.7843475341798,13.3206310272217 51.7906227111816,13.3123683929443 51.7870559692384,13.3092765808105 51.7839965820314,13.2974081039429 51.7781639099122,13.2956066131592 51.7759895324708,13.2922773361205 51.7751884460449,13.2988986968995 51.7679290771485,13.3006811141968 51.7669410705568,13.3027153015137 51.7681617736816,13.3045568466188 51.7672004699707,13.3039140701295 51.7664337158204,13.3075437545776 51.7650604248047,13.3063964843751 51.7614936828614,13.3114662170411 51.7613754272461,13.3138236999513 51.7624359130861,13.3141555786133 51.7638130187989,13.3254756927491 51.7652702331543,13.3329448699952 51.7638244628906,13.3363485336304 51.7506713867188,13.336633682251 51.7461624145508,13.3272542953492 51.7464523315429,13.3282737731934 51.7380981445312,13.3282737731934 51.7380981445312,13.3380317687989 51.7359924316406,13.3412513732911 51.7259941101074,13.3431320190429 51.7233657836913,13.3403367996217 51.7159614562989,13.3483877182007 51.7156143188477,13.3486032485962 51.7139511108399,13.3475036621095 51.7139778137207,13.3486251831056 51.7117462158203,13.3455667495728 51.7108039855958,13.3488349914551 51.7081413269044,13.3510541915894 51.7079505920411,13.3493175506592 51.7054290771486,13.3507061004638 51.7046928405762,13.351739883423 51.7005882263184,13.3505849838257 51.6995010375978,13.3451395034791 51.7004699707032,13.3442945480348 51.6992301940919,13.3463134765626 51.6983795166015,13.3458576202392 51.697338104248,13.3480310440064 51.6961860656738,13.3477392196655 51.6940574645997,13.3422327041626 51.6854133605958,13.3341398239136 51.6800994873047,13.3341398239136 51.6800994873047,13.3307399749756 51.6775856018067,13.3286323547364 51.672550201416,13.3286247253419 51.6693916320801,13.3298749923706 51.6622505187988,13.3318481445314 51.6613540649415,13.3340911865235 51.6585388183594,13.3340911865235 51.6585388183594,13.3383369445801 51.6588516235353))0.0006POINT(13.377427906825668 51.72330464987921)
70275POLYGON((12.3379278182983 50.8509750366211,12.3349370956421 50.8526420593262,12.3268070220947 50.8516464233399,12.3281574249268 50.8479957580566,12.3246021270753 50.8465309143066,12.3195447921753 50.8509750366211,12.3174581527711 50.8496131896973,12.3127307891846 50.8516235351563,12.3127307891846 50.8516235351563,12.2961330413818 50.8415412902832,12.2961330413818 50.8415412902832,12.3022747039795 50.8325729370118,12.3029870986939 50.8299903869629,12.2993354797363 50.8296165466309,12.2993354797363 50.8296165466309,12.300389289856 50.8269996643068,12.3069477081299 50.8187637329102,12.3157052993774 50.8194465637207,12.3206424713134 50.8216285705568,12.3338785171509 50.8204193115236,12.3330202102662 50.8220443725587,12.3475770950319 50.8236312866212,12.3468866348267 50.826499938965,12.3479709625244 50.828197479248,12.3467016220092 50.83207321167,12.3495874404908 50.8331718444824,12.3476810455323 50.8348426818848,12.3479804992675 50.8368759155273,12.3479804992675 50.8368759155273,12.3410797119141 50.838249206543,12.3366041183472 50.8437805175782,12.3354034423829 50.8478927612304,12.3379278182983 50.8509750366211))0.0006POINT(12.325535356998463 50.836559295654325)
52791POLYGON((-0.164957731962204 46.5476036071778,-0.122783645987511 46.532585144043,-0.122783645987511 46.532585144043,-0.153646051883641 46.5176010131837,-0.165182381868362 46.5227050781251,-0.165182381868362 46.5227050781251,-0.173513352870941 46.5305786132814,-0.16868694126606 46.5362701416016,-0.175157397985458 46.5410842895509,-0.164957731962204 46.5476036071778))0.0006POINT(-0.1568770590755611 46.53152423434796)
1407666POLYGON((-8.91231441497803 43.0128250122071,-8.91605091094959 43.0045013427734,-8.91922378540039 43.0027885437012,-8.92316436767572 43.0039863586427,-8.92759323120117 43.0025787353517,-8.94497108459461 42.9873771667482,-8.95172882080078 42.9862518310547,-8.95438861846912 42.9894180297853,-8.95368003845215 42.9913177490236,-8.95967578887939 42.9928436279298,-8.96797943115229 42.991714477539,-8.96822071075439 42.995231628418,-8.9771728515625 42.9995117187501,-8.97798538208002 43.0025672912598,-8.98363018035889 43.0038566589355,-8.98502731323242 43.0059700012207,-8.98365306854248 43.008617401123,-8.98084259033197 43.0103836059571,-8.97757244110107 43.0264167785645,-8.98275947570801 43.0309257507324,-8.98668193817139 43.0428352355958,-8.97927665710444 43.0484466552735,-8.97375679016108 43.0609474182129,-8.95390796661371 43.0741233825684,-8.94384765624994 43.0854835510254,-8.95090389251703 43.091983795166,-8.94982147216797 43.0933570861817,-8.95186805725098 43.1001548767089,-8.95788478851318 43.1033935546876,-8.96356201171875 43.1024055480958,-8.96614742279047 43.1058692932128,-8.9603796005249 43.1113586425781,-8.962248802185 43.1139068603516,-8.9603443145752 43.1170463562012,-8.96783256530756 43.1223983764648,-8.96756744384766 43.1253471374512,-8.94567966461176 43.1300201416016,-8.94784545898432 43.1460914611818,-8.9504337310791 43.1433906555177,-8.95392799377436 43.1441688537599,-8.96292209625244 43.142864227295,-8.96470642089844 43.1440238952636,-8.96433925628656 43.1478118896485,-8.96909141540522 43.1517677307129,-8.97203826904297 43.1511001586915,-8.97438812255854 43.1528854370117,-8.97925186157221 43.1527214050294,-8.98199844360346 43.1541328430175,-8.98079681396484 43.1564483642579,-8.98429965972895 43.1637153625488,-8.98748874664307 43.1673927307129,-8.98957633972162 43.1661033630372,-8.98983573913574 43.1688804626465,-8.98334503173822 43.1813201904297,-8.98044109344477 43.1812019348146,-8.97088718414295 43.1761970520021,-8.96846008300776 43.1763916015625,-8.95905876159662 43.1719436645509,-8.95639419555664 43.1689758300781,-8.95009231567383 43.1679000854493,-8.94875717163086 43.1728706359863,-8.94573211669922 43.1746635437012,-8.93993377685541 43.1861114501953,-8.92693901062006 43.1842765808105,-8.92161464691156 43.1807556152344,-8.92644596099842 43.1769409179688,-8.93361663818359 43.1647834777833,-8.92883682250977 43.1636810302735,-8.92906284332275 43.1584053039551,-8.91522598266602 43.1512527465821,-8.91419601440424 43.1487350463867,-8.90900230407709 43.1512069702148,-8.90630054473871 43.1560821533204,-8.89762687683105 43.1596107482911,-8.89313507080072 43.1573867797852,-8.88903903961176 43.1590461730958,-8.88372611999506 43.1569976806641,-8.87904262542725 43.1570053100587,-8.87930297851557 43.1556053161622,-8.87555122375488 43.1554679870605,-8.87418556213373 43.1528968811036,-8.8606748580932 43.1497230529786,-8.85303497314453 43.1450386047363,-8.84096145629877 43.1424522399903,-8.83782863616943 43.1375846862793,-8.84089660644531 43.1390724182129,-8.84563255310059 43.1379585266113,-8.84681606292725 43.1366882324219,-8.8427791595459 43.1259689331056,-8.84490776062006 43.1244468688965,-8.84971714019775 43.125270843506,-8.85051155090332 43.1230239868165,-8.85725021362299 43.1202507019044,-8.8525772094726 43.1072273254395,-8.86626815795898 43.1089630126954,-8.86991024017328 43.0903053283692,-8.87721252441395 43.0869064331055,-8.88355827331543 43.0797004699708,-8.88459014892578 43.0693664550781,-8.88666152954102 43.067928314209,-8.88701057434082 43.0622100830079,-8.88532161712646 43.0603370666504,-8.88777637481689 43.0588035583496,-8.88969135284424 43.0594520568848,-8.89096260070795 43.0556793212891,-8.8935813903808 43.0545806884766,-8.89725971221918 43.0554161071778,-8.90465831756592 43.0477523803712,-8.9090518951416 43.0394744873047,-8.91491413116455 43.035717010498,-8.91329956054688 43.0341529846191,-8.91463088989258 43.0325431823731,-8.91022396087646 43.0295753479003,-8.91613101959223 43.0251770019532,-8.91231441497803 43.0128250122071))0.0006POINT(-8.92837316111511 43.10217649894851)
27823POLYGON((0.0735961124301525 48.8172912597657,0.0445071011782829 48.784725189209,0.0445071011782829 48.784725189209,0.0463716015220825 48.7792205810547,0.0560864210129921 48.780818939209,0.0787181854248615 48.7750205993653,0.0787181854248615 48.7750205993653,0.0864900350571816 48.7897071838379,0.0864900350571816 48.7897071838379,0.0953613892197041 48.8089485168458,0.0953613892197041 48.8089485168458,0.0923166126013371 48.8112602233887,0.0787865370512577 48.811004638672,0.0787865370512577 48.811004638672,0.0735961124301525 48.8172912597657))0.0006POINT(0.07400694595922427 48.794814518519864)
24081POLYGON((2.87352967262274 45.375373840332,2.86098408699036 45.3803291320802,2.85237860679632 45.3923416137695,2.85237860679632 45.3923416137695,2.82807612419134 45.3907585144044,2.8153538703919 45.4003982543946,2.78972530365002 45.3905220031738,2.78514766693127 45.3845787048339,2.78514766693127 45.3845787048339,2.81097626686102 45.3683624267579,2.83484077453608 45.3635101318359,2.86465907096863 45.3507919311523,2.86465907096863 45.3507919311523,2.87478351593018 45.3689308166505,2.87352967262274 45.375373840332))0.0006POINT(2.835188593183291 45.378114972795764)
37334POLYGON((0.790919065475464 48.9811401367189,0.788612067699546 48.9807548522949,0.788612067699546 48.9807548522949,0.782371759414673 48.9748649597169,0.782371759414673 48.9748649597169,0.783519804477748 48.974220275879,0.783519804477748 48.974220275879,0.790065407752991 48.9780731201173,0.790065407752991 48.9780731201173,0.790919065475464 48.9811401367189))0.0006POINT(0.7866730160183755 48.97744072808168)
16804POLYGON((12.9849557876586 42.9586639404298,13.0008583068847 42.9620094299318,13.0008583068847 42.9620094299318,13.0101947784424 42.964111328125,13.0182819366456 42.9742012023926,13.029676437378 43.003273010254,13.0372867584229 43.0146675109864,13.0332069396973 43.0248565673829,13.0232105255128 43.0220108032228,12.9872045516967 43.0197906494141,12.969799041748 43.015079498291,12.9629993438722 43.01176071167,12.9509887695312 43.011688232422,12.9509887695312 43.011688232422,12.9473161697388 43.0055809020996,12.9450626373292 43.0047111511231,12.9440031051635 42.9996948242189,12.9435682296754 42.995834350586,12.9453592300416 42.9796600341798,12.9654188156128 42.9615058898926,12.9703464508057 42.9604110717775,12.9762477874757 42.9617652893067,12.9849557876586 42.9586639404298))0.0006POINT(12.981719667261315 42.99204427545729)