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
60045	POLYGON((8.89565467834473 47.0249290466309,8.90572166442877 47.0240478515624,8.91468906402588 47.020263671875,8.91656112670904 47.0135993957521,8.92065334320074 47.0094680786133,8.92261028289795 47.0056953430176,8.9328432083131 47.0011138916017,8.93698978424067 46.9941635131836,8.94563865661632 46.9908256530762,8.94519138336176 46.9885025024415,8.9389123916626 46.9864463806153,8.93894386291504 46.9843749999999,8.9475593566894 46.9723968505859,8.95476245880133 46.9709968566895,8.95476245880133 46.9709968566895,8.96230125427246 46.973617553711,8.96707916259777 46.9768714904785,8.97691440582275 46.9800148010254,8.98260211944586 46.9872932434083,8.99067783355719 46.9935340881348,8.99585437774658 46.9952239990236,9.00269794464106 47.0017280578614,9.01101398468023 47.0054588317871,9.01101398468023 47.0054588317871,9.01693153381342 47.0084495544435,9.02257728576666 47.0129241943361,9.02777004241943 47.0134773254395,9.03764057159424 47.016902923584,9.03764057159424 47.016902923584,9.03945636749279 47.0198593139648,9.04497241973883 47.0231552124023,9.05243587493902 47.0236396789551,9.05243587493902 47.0236396789551,9.06040763854986 47.0249061584472,9.07310962677002 47.029956817627,9.07783985137934 47.030460357666,9.07783985137934 47.030460357666,9.07793426513672 47.0329971313478,9.07508659362799 47.0354957580567,9.07461833953857 47.0415496826173,9.06720638275141 47.0496292114258,9.06256675720226 47.0569801330566,9.06256675720226 47.0569801330566,9.05428981781006 47.0546607971191,9.05428981781006 47.0546607971191,9.05571079254156 47.050807952881,9.0548620223999 47.0485420227052,9.05136299133306 47.0473518371583,9.03755092620855 47.0460166931153,9.0338659286499 47.0467910766602,9.02811813354498 47.0507888793945,9.02653312683117 47.0552444458008,9.02653312683117 47.0552444458008,9.02037239074701 47.0540390014648,9.00486373901373 47.055202484131,8.9985141754151 47.0579566955566,8.99635982513433 47.0602226257324,8.99635982513433 47.0602226257324,8.99213600158686 47.0589485168458,8.97449016571045 47.0482749938965,8.9557256698609 47.0482254028321,8.95315742492681 47.0497360229493,8.95074844360363 47.0536842346193,8.95074844360363 47.0536842346193,8.94433784484869 47.0521736145019,8.93678569793707 47.0472259521485,8.9233341217041 47.0426788330079,8.91480922698969 47.0439987182618,8.9059944152832 47.042694091797,8.9041748046875 47.0384140014648,8.90611267089844 47.0323219299318,8.89891242980957 47.0297584533692,8.89565467834473 47.0249290466309))	0.0006	POINT(8.992551936043661 47.02590221828886)
32822	POLYGON((1.05982220172888 47.7842826843262,1.05397331714636 47.7940864562989,1.02943480014807 47.7997169494629,1.02112925052649 47.8081855773926,1.02112925052649 47.8081855773926,1.01610827445995 47.8087921142578,1.00612425804138 47.7931289672852,0.992403686046714 47.7892150878907,0.984007120132503 47.7925643920898,0.984007120132503 47.7925643920898,0.985874533653373 47.7831153869629,0.996021747589168 47.7765083312989,0.996021747589168 47.7765083312989,1.01493740081798 47.774284362793,1.02454078197479 47.7670707702637,1.02454078197479 47.7670707702637,1.05982220172888 47.7842826843262))	0.0006	POINT(1.0131297670305381 47.78845500946047)
15813	POLYGON((10.3676300048829 45.108757019043,10.3651390075684 45.1029434204103,10.3646450042725 45.0992622375488,10.3651485443115 45.0894775390625,10.3670072555542 45.0890617370606,10.3647508621216 45.0781059265137,10.3593368530273 45.0748138427735,10.3577890396118 45.0727233886719,10.3605346679688 45.0680198669434,10.3638420104981 45.0666122436524,10.3661127090455 45.0643424987792,10.3667993545532 45.0622138977052,10.3650121688843 45.0474357604981,10.3646154403687 45.046241760254,10.3615570068359 45.0463066101075,10.3615570068359 45.0463066101075,10.3664121627807 45.0401268005371,10.3664121627807 45.0401268005371,10.371364593506 45.0433616638183,10.3801259994507 45.0433807373047,10.3897857666015 45.041187286377,10.3897857666015 45.041187286377,10.3894014358521 45.0472831726075,10.3873920440674 45.0487747192384,10.3866777420043 45.0507278442383,10.3877544403077 45.0658378601075,10.3932647705078 45.0768547058106,10.3958272933961 45.0786399841308,10.3987340927123 45.0790824890137,10.4017734527588 45.0833206176757,10.4001779556274 45.0970916748047,10.3986949920655 45.0996704101564,10.3986949920655 45.0996704101564,10.3970222473145 45.1021385192871,10.3820772171022 45.1085395812989,10.3676300048829 45.108757019043))	0.0006	POINT(10.377224458966955 45.06998934064597)
27320	POLYGON((-1.53128182888031 49.2397041320802,-1.52678501605988 49.2499046325684,-1.52678501605988 49.2499046325684,-1.53382098674774 49.2596969604492,-1.54640436172485 49.2640113830567,-1.54640436172485 49.2640113830567,-1.55297958850861 49.2671165466309,-1.55297958850861 49.2671165466309,-1.55938732624048 49.2622337341309,-1.56887722015375 49.2607955932617,-1.57696604728693 49.2530212402344,-1.57696604728693 49.2530212402344,-1.57365465164185 49.2442169189453,-1.57365465164185 49.2442169189453,-1.56441247463221 49.2421989440917,-1.54976630210871 49.2450218200685,-1.53128182888031 49.2397041320802))	0.0006	POINT(-1.5538203418254648 49.2541370391846)
70263	POLYGON((12.3994283676148 51.031650543213,12.4016952514648 51.0288391113282,12.4004926681519 51.0282554626465,12.4041633605958 51.0224914550782,12.4106922149658 51.0226631164552,12.4116067886352 51.0209579467773,12.4132070541382 51.0210189819337,12.4174680709839 51.0125808715821,12.4162864685059 51.0116081237794,12.4062185287475 51.0103340148926,12.4082727432252 51.0092926025391,12.4095039367676 51.00350189209,12.407808303833 51.0028572082521,12.407808303833 51.0028572082521,12.4088439941407 50.9975204467774,12.4105491638184 50.9966812133789,12.4096860885621 50.9919891357422,12.4014148712159 50.992015838623,12.3898487091066 50.9906005859375,12.38538646698 50.9916915893556,12.38538646698 50.9916915893556,12.3903427124024 50.9834747314454,12.3918409347534 50.9838371276855,12.395323753357 50.9783630371093,12.3908777236938 50.9742126464844,12.379158973694 50.9717292785646,12.3807973861695 50.969596862793,12.3764619827271 50.9688491821289,12.3763074874878 50.9664306640626,12.378077507019 50.9657821655273,12.3738994598389 50.9639854431152,12.3766326904298 50.9617881774903,12.372498512268 50.9585609436036,12.372498512268 50.9585609436036,12.3817214965821 50.9558296203614,12.383807182312 50.9534912109376,12.383807182312 50.9534912109376,12.3912057876586 50.9567108154297,12.3883876800538 50.9581985473633,12.3893089294435 50.9587860107422,12.3926849365236 50.958408355713,12.3949203491212 50.9597473144532,12.4019908905029 50.9571990966797,12.4037017822266 50.9591102600098,12.414831161499 50.9575004577637,12.4319162368775 50.9651985168458,12.4406709671022 50.9591560363771,12.442105293274 50.9590339660645,12.4442052841187 50.956657409668,12.4411430358887 50.9559364318849,12.4416694641113 50.9549713134766,12.444372177124 50.9557685852051,12.4469680786133 50.9513244628906,12.4454193115235 50.9494514465333,12.4459505081177 50.9477348327638,12.4515008926392 50.9452133178711,12.4504318237305 50.9441871643066,12.4470920562745 50.9453964233398,12.4444856643678 50.9433784484863,12.4389610290527 50.9438018798829,12.4421758651734 50.9409484863282,12.4394330978394 50.9400863647461,12.4411277770997 50.9356384277343,12.4440326690675 50.9359588623048,12.4439945220948 50.9340438842774,12.4473924636841 50.9318428039551,12.451005935669 50.9327659606934,12.4510688781739 50.9362907409669,12.4538450241089 50.9359130859376,12.4533920288086 50.9336051940919,12.4584226608276 50.9319915771486,12.4557027816773 50.9306411743165,12.4557218551635 50.9287261962892,12.4587898254394 50.9275131225587,12.4631376266481 50.9272766113281,12.4678773880005 50.9235076904297,12.4780883789063 50.9258613586426,12.4829874038696 50.9221954345704,12.4955987930298 50.9260482788087,12.4958686828614 50.9339828491211,12.4889554977417 50.9335517883301,12.4937171936035 50.9392776489258,12.4887495040894 50.9430351257324,12.48508644104 50.9429969787598,12.4854574203492 50.9473381042482,12.4828844070435 50.9484786987305,12.4829263687135 50.9494705200196,12.4779586791992 50.9515991210939,12.4769945144653 50.9533691406249,12.4728364944459 50.9561386108399,12.4795589447022 50.9603805541993,12.4774599075319 50.9627227783203,12.4777212142945 50.9635505676271,12.4735803604127 50.9661903381349,12.4734392166138 50.9676780700684,12.4755239486694 50.9682731628419,12.4744729995728 50.9691047668456,12.4751501083375 50.9696540832521,12.4730129241943 50.9706802368165,12.4680051803589 50.9695701599122,12.4671602249147 50.9708251953126,12.4583969116212 50.9746284484864,12.4582977294923 50.9759902954102,12.4609327316284 50.9769325256347,12.4594478607178 50.9789123535157,12.4635906219484 50.979778289795,12.463475227356 50.9810943603516,12.4613914489747 50.9803657531738,12.4604663848876 50.9810829162599,12.4641027450562 50.9827842712403,12.4618082046509 50.9861907958984,12.459997177124 50.9848442077637,12.4593925476074 50.9890937805177,12.4622831344605 50.9893226623535,12.4639911651612 50.9932899475099,12.4639911651612 50.9932899475099,12.4641246795655 50.9950904846191,12.4670066833496 50.9954528808594,12.4668788909912 50.9978141784669,12.4684963226319 50.9982833862305,12.4684886932374 50.9998016357422,12.4723711013794 51.0001983642579,12.4713296890259 51.0025367736816,12.4659681320192 51.0019073486329,12.4622898101807 51.0073432922364,12.4569778442382 51.0119590759278,12.4530420303345 51.0120239257813,12.452368736267 51.0143241882324,12.4559736251831 51.0152168273927,12.4588747024536 51.0244560241699,12.4476852416992 51.0281639099122,12.4476852416992 51.0281639099122,12.4451398849488 51.025676727295,12.4443321228027 51.0234298706055,12.4377717971802 51.0252418518066,12.4364366531373 51.0236892700196,12.4347372055054 51.0250205993652,12.4360456466676 51.0269699096681,12.4345359802247 51.0277252197267,12.4263229370117 51.026538848877,12.42156124115 51.0246086120605,12.4191198349 51.0304374694825,12.4158506393432 51.0304260253906,12.4155464172363 51.0334129333496,12.4155464172363 51.0334129333496,12.4116096496583 51.0348815917969,12.4061346054078 51.0343399047852,12.4061346054078 51.0343399047852,12.4046583175659 51.0341911315918,12.4034309387208 51.0324668884277,12.3994283676148 51.031650543213))	0.0006	POINT(12.437267341613797 50.978252156575536)
18608	POLYGON((8.66693401336681 40.8667678833008,8.66076469421387 40.859504699707,8.6594028472901 40.8566436767578,8.65923023223877 40.8533821105958,8.66174602508551 40.8504180908204,8.66174602508551 40.8504180908204,8.6600399017334 40.8482246398926,8.65395355224609 40.8458824157715,8.64587306976313 40.8397789001465,8.63599586486828 40.826099395752,8.63369083404552 40.8248672485352,8.62902927398687 40.8250694274902,8.61733818054205 40.8206863403321,8.61050891876232 40.8164291381836,8.59749984741222 40.8031158447266,8.58956241607672 40.7927131652833,8.57893180847168 40.781135559082,8.5779819488526 40.776725769043,8.58095455169683 40.7723388671875,8.58095455169683 40.7723388671875,8.56538772583008 40.7772903442382,8.55779266357416 40.7772445678712,8.55712795257574 40.7738723754883,8.5464382171632 40.7757873535156,8.53192615509045 40.7836837768555,8.52528095245356 40.7816200256348,8.51819229125988 40.7884712219238,8.51883602142345 40.7912216186523,8.50890922546381 40.8065757751465,8.49665832519537 40.8133430480958,8.48158740997326 40.8135452270508,8.47062015533459 40.81502532959,8.46539497375488 40.8171653747559,8.46687316894531 40.8190307617189,8.46687316894531 40.8190307617189,8.47263908386242 40.8184738159181,8.47402954101574 40.8193092346193,8.47819137573242 40.8187484741212,8.48291587829601 40.8195838928223,8.48458194732666 40.8187484741212,8.48541641235352 40.8198623657227,8.49680519103998 40.8201370239258,8.50430583953857 40.820972442627,8.50819206237793 40.8223609924318,8.51124954223638 40.821804046631,8.51263809204113 40.8226394653321,8.53736019134516 40.8248596191407,8.55541801452648 40.8301391601562,8.56152820587153 40.8309707641602,8.58013916015625 40.8373603820801,8.59208202362066 40.8423614501953,8.59375000000006 40.8443069458008,8.6020832061767 40.8479156494141,8.60763931274425 40.8512496948243,8.61069583892822 40.8545837402344,8.61458206176758 40.8559722900391,8.62263774871832 40.8615264892579,8.62596988677979 40.8654212951661,8.62597274780268 40.8681945800782,8.62875080108648 40.8715286254883,8.62958145141613 40.8779220581055,8.63125133514416 40.8793106079103,8.63125133514416 40.8793106079103,8.63430404663092 40.8794326782227,8.64325237274181 40.8772964477539,8.66693401336681 40.8667678833008))	0.0006	POINT(8.571988487243697 40.82673463087819)
58892	POLYGON((6.20025253295898 51.1064567565918,6.2059497833252 51.1019897460938,6.20142459869396 51.1001625061035,6.20580196380627 51.0910949707031,6.20580196380627 51.0910949707031,6.1973495483399 51.0866050720214,6.19624996185314 51.0881652832032,6.19440937042242 51.0874404907228,6.19384193420422 51.0881309509277,6.1789984703064 51.0841217041016,6.1752753257752 51.0821533203125,6.17403125762945 51.0833091735841,6.16459226608288 51.0784950256348,6.15407133102423 51.0761032104493,6.15407133102423 51.0761032104493,6.15522432327276 51.0786056518555,6.15465068817139 51.0798377990723,6.14809989929205 51.081485748291,6.1462407112121 51.0843620300293,6.13503789901739 51.0869178771973,6.13110399246222 51.0888710021974,6.12641906738287 51.0890731811524,6.11704301834118 51.0967979431153,6.10290479660046 51.0978088378906,6.09766006469727 51.1022262573243,6.09340000152594 51.1033630371094,6.09148454666149 51.105884552002,6.09139204025274 51.1112098693847,6.08774042129511 51.1134986877441,6.08629465103161 51.1174507141114,6.08044624328613 51.1222038269044,6.08044624328613 51.1222038269044,6.07987928390503 51.1248435974122,6.08084344863903 51.1261405944824,6.0835046768189 51.1239242553711,6.08706140518194 51.1246299743653,6.08665895462036 51.1255416870118,6.08440971374517 51.1259956359864,6.08658742904663 51.1276397705079,6.08864402771007 51.1278877258301,6.08693599700939 51.129306793213,6.08923482894892 51.1302185058594,6.09186840057373 51.1349754333497,6.09597635269176 51.1347503662111,6.10093402862555 51.1365814208985,6.11592817306519 51.1390686035157,6.12121963500988 51.1408843994141,6.1215963363648 51.1425895690919,6.12595081329351 51.1451225280763,6.13540410995489 51.1453971862793,6.14472007751476 51.1471252441407,6.14759969711298 51.1486396789551,6.15459108352661 51.1481094360351,6.15459108352661 51.1481094360351,6.15338134765619 51.1461486816407,6.15572023391724 51.1415214538575,6.16751241683966 51.1389122009277,6.16708803176891 51.1381416320801,6.17107439041138 51.1380043029786,6.18126392364508 51.1405677795411,6.18724870681757 51.1405754089355,6.18417882919312 51.1380119323731,6.1863312721253 51.1379737854004,6.18209791183472 51.1294288635254,6.17790651321417 51.1269035339355,6.18164777755749 51.1227836608888,6.18013572692877 51.1205749511719,6.18318462371838 51.1181373596191,6.18507528305059 51.1192092895508,6.18810462951672 51.1165161132812,6.19027137756348 51.1173896789551,6.19416809082043 51.115219116211,6.18829107284557 51.1119079589844,6.20025253295898 51.1064567565918))	0.0006	POINT(6.143788109087014 51.11559776410666)
35120	POLYGON((8.70056247711187 41.9532699584962,8.67420768737799 41.9467544555665,8.64878845214844 41.961223602295,8.62653732299799 41.9650230407715,8.62287139892578 41.9704856872559,8.63125133514416 41.9686203002929,8.63125133514416 41.9686203002929,8.63180541992188 41.9679183959961,8.63819313049316 41.9684715270997,8.63902759552002 41.9676399230958,8.64235973358149 41.9676399230958,8.64486217498779 41.9687500000001,8.64847183227533 41.9687500000001,8.65097332000732 41.9718055725098,8.65513896942133 41.9729156494141,8.65958309173595 41.9765281677246,8.66319561004639 41.9770851135255,8.66847229003906 41.9826393127441,8.66847229003906 41.9826393127441,8.6741943359375 41.9770202636719,8.68700218200695 41.9743957519531,8.70056247711187 41.9532699584962))	0.0006	POINT(8.652724856422077 41.96943791707361)
180925	POLYGON((3.09025359153759 50.0537414550781,3.07449221611023 50.0452995300294,3.03041219711315 50.0574798583986,3.02491402626032 50.0541496276855,3.01196980476391 50.0580406188967,3.0068354606629 50.0546073913576,2.97153592109686 50.0413665771487,2.96917581558228 50.0466918945315,2.9488892555238 50.0533218383791,2.94002079963684 50.0504722595216,2.9348664283753 50.0452423095706,2.92571830749506 50.0444641113282,2.92017483711243 50.0485916137695,2.91697406768799 50.0355300903323,2.89615273475658 50.0365562438966,2.87574696540838 50.0270004272463,2.87856912612915 50.0245246887208,2.87118887901312 50.0210762023926,2.85637688636791 50.0235824584963,2.85542178153997 50.0260696411133,2.85497164726257 50.0323638916016,2.86995458602905 50.0349502563479,2.87619280815119 50.0442543029785,2.86472868919378 50.0599250793457,2.85670351982117 50.0609931945804,2.85541367530823 50.0779914855956,2.83790373802196 50.07194519043,2.83123469352716 50.0631675720215,2.82281184196484 50.0659484863281,2.81051445007319 50.0597610473634,2.80719780921936 50.0624580383303,2.79450988769543 50.0500526428225,2.78091740608227 50.0483512878419,2.77573919296265 50.0428009033203,2.76201915740967 50.0390548706055,2.75219535827637 50.0403213500976,2.74233841896057 50.0480079650882,2.7637460231781 50.0605964660647,2.76042485237127 50.0696334838868,2.7744619846344 50.07922744751,2.78183579444885 50.0911140441897,2.77814197540289 50.0994300842287,2.78089785575878 50.1111564636233,2.7782599925996 50.1139640808106,2.76418328285223 50.110694885254,2.74953722953808 50.112804412842,2.72992968559265 50.1258621215823,2.71109962463379 50.1281547546386,2.70712828636169 50.1264305114747,2.71352005004894 50.1101913452148,2.69885396957403 50.1059341430663,2.69757533073425 50.1025733947757,2.7189936637879 50.0876426696778,2.70385909080511 50.0809898376466,2.69164896011353 50.0920677185061,2.68238854408276 50.0950698852538,2.67208075523376 50.0936355590823,2.65652561187744 50.1002845764163,2.6475465297699 50.094409942627,2.6357791423797 50.1000175476076,2.63064575195324 50.1051101684571,2.63072776794439 50.1072769165038,2.61681056022655 50.110279083252,2.59290409088146 50.1065559387208,2.58895158767706 50.1117858886719,2.57567143440258 50.1133308410645,2.56935453414923 50.1204032897949,2.56964325904846 50.1226043701174,2.58663463592535 50.1373634338379,2.57643246650696 50.1392784118652,2.56837010383612 50.1359634399416,2.5564115047456 50.1421813964843,2.55132913589483 50.1417045593261,2.54602742195141 50.1360626220704,2.5446875095368 50.1265640258791,2.54809021949768 50.1240997314455,2.5323321819306 50.1150779724123,2.51494932174683 50.1408195495608,2.47597527503973 50.1368598937989,2.46939992904669 50.1336441040039,2.45504951477062 50.1311759948733,2.42965793609631 50.0881843566897,2.41984057426458 50.0885238647462,2.41450786590576 50.1006507873538,2.39738965034496 50.1065063476562,2.39488816261297 50.1101913452148,2.37545967102056 50.1092605590823,2.38611340522777 50.1394348144532,2.39191365242016 50.1451492309571,2.38977694511414 50.1554832458496,2.39882326126099 50.1564445495605,2.40326809883118 50.1648025512696,2.41452956199652 50.164173126221,2.41484594345093 50.1731109619142,2.44032454490673 50.1805191040038,2.45082068443298 50.1785202026369,2.47388744354254 50.1886520385743,2.4956903457641 50.1945610046388,2.49505305290228 50.1995506286621,2.48892784118664 50.204860687256,2.48520421981806 50.2077980041506,2.47551774978649 50.2081718444826,2.45959901809704 50.2195510864258,2.45206618309027 50.2302131652832,2.43685460090632 50.2272644042969,2.41739988327038 50.2282943725588,2.40701317787182 50.2342987060546,2.38947439193731 50.2247657775881,2.38231992721569 50.2260665893558,2.36782002449041 50.2080154418947,2.36173105239874 50.2070770263672,2.33287763595581 50.2390823364258,2.31476712226868 50.2344207763672,2.31625008583075 50.2313919067384,2.32080841064453 50.2328376770022,2.33130073547358 50.2217254638672,2.32713222503668 50.2130966186526,2.32318043708807 50.2187538146972,2.31838870048517 50.2191467285159,2.30169320106506 50.2129554748536,2.26935124397289 50.2276496887208,2.25343060493469 50.214683532715,2.22274613380432 50.208854675293,2.22442102432251 50.2173614501955,2.19990777969366 50.2151756286623,2.19948959350597 50.2124137878419,2.18773651123053 50.2096786499025,2.17918133735668 50.2100105285646,2.17849779129034 50.2072944641114,2.1732966899873 50.2078857421877,2.14976000785833 50.1904296874999,2.14166712760937 50.2024612426758,2.13569164276123 50.2074470520021,2.12192964553839 50.2102890014648,2.11455893516552 50.2028617858887,2.09663844108587 50.2066307067873,2.08571362495434 50.2010154724121,2.08360648155218 50.216968536377,2.06848716735846 50.22709274292,2.067944765091 50.2329788208008,2.0638155937196 50.2344551086426,2.06451463699335 50.240577697754,2.07782196998608 50.2487297058107,2.06440448760986 50.2556266784668,2.04866814613342 50.2567710876465,2.02623581886303 50.2695541381839,2.01185035705566 50.2679672241213,2.00322890281677 50.2703857421877,1.99412822723389 50.2757148742676,1.96973645687109 50.2824554443362,1.95987367630016 50.2904891967774,1.94935262203217 50.2861976623536,1.94564843177795 50.2877464294435,1.93445813655859 50.2993507385256,1.95957565307629 50.3117942810061,1.96393442153942 50.3180541992188,1.95820438861858 50.3259429931643,1.94619476795208 50.3314895629885,1.93675470352184 50.3288040161135,1.91949617862713 50.3126640319824,1.89888286590588 50.3133354187015,1.89732873439795 50.3183670043946,1.8829026222229 50.3181648254396,1.87535440921783 50.3227272033691,1.86913096904755 50.3344688415528,1.85213291645056 50.3410644531251,1.85169816017162 50.3429107666018,1.83066356182104 50.3460464477542,1.80467855930328 50.3596038818361,1.76184868812567 50.3616065979005,1.7550551891328 50.3570480346682,1.74033939838415 50.3545227050781,1.73005211353296 50.3478240966799,1.6948367357254 50.3388824462891,1.69252991676342 50.3429069519044,1.67724919319159 50.3338203430176,1.66228687763225 50.3314590454104,1.66430974006659 50.3345336914065,1.65162706375122 50.3398094177247,1.64649868011475 50.3400764465332,1.6415438652038 50.3521537780764,1.63132560253155 50.3605003356935,1.63279283046734 50.3648948669435,1.61583280563354 50.3685493469238,1.61583280563354 50.3685493469238,1.616945028305 50.3698616027834,1.60972201824188 50.369026184082,1.59138894081116 50.3748626708986,1.58749997615826 50.3743057250976,1.58694398403179 50.3768043518067,1.58249998092657 50.377639770508,1.57916796207428 50.3815269470217,1.57805597782129 50.3862495422365,1.57361102104198 50.3884735107422,1.56972301006317 50.3937492370608,1.55916595458984 50.3945846557617,1.5552779436112 50.3984718322756,1.5552779436112 50.4015274047853,1.55805599689484 50.4037513732911,1.56194400787359 50.4115295410158,1.56194400787359 50.416805267334,1.56472301483166 50.4201393127444,1.56583297252666 50.4293060302737,1.56805503368378 50.4309730529786,1.57194495201111 50.4629173278809,1.57472097873693 50.4690284729006,1.5769430398941 50.4926376342776,1.57639002799982 50.5137481689453,1.57916796207428 50.5276374816897,1.58361005783092 50.5365295410159,1.58694398403179 50.5404167175295,1.59027898311615 50.5398597717287,1.6058340072633 50.5326385498049,1.62472295761114 50.5195846557618,1.62027704715734 50.5248603820804,1.60361194610601 50.5373611450196,1.60305500030523 50.5423622131348,1.60527801513683 50.5440292358401,1.60527801513683 50.5465278625491,1.59805500507355 50.5523605346682,1.58749997615826 50.5576400756838,1.58027803897863 50.5640296936037,1.57639002799982 50.570972442627,1.57639002799982 50.5781936645507,1.57916796207428 50.5859718322754,1.57639002799982 50.6406936645508,1.57083296775818 50.6670837402343,1.56694495677959 50.6737518310546,1.56416702270519 50.6831932067871,1.56250095367437 50.684307098389,1.56194400787359 50.6956939697265,1.55916595458984 50.698471069336,1.56360995769506 50.7023696899413,1.56527900695812 50.7070846557618,1.56916701793671 50.7076377868654,1.57083296775818 50.7131958007815,1.57305502891546 50.7131958007815,1.572499036789 50.7165260314943,1.56583297252666 50.7201385498049,1.56138801574713 50.7259712219238,1.56583297252666 50.72513961792,1.56583297252666 50.7268066406252,1.56750094890606 50.7268066406252,1.56583297252666 50.7229156494142,1.56750094890606 50.72180557251,1.57138895988464 50.7276382446291,1.57583296298992 50.7279167175295,1.57138895988464 50.7204170227052,1.57305502891546 50.7179183959963,1.57583296298992 50.7173614501954,1.57416701316845 50.7187500000001,1.57416701316845 50.7220840454104,1.57916796207428 50.7262496948244,1.5769430398941 50.7273597717287,1.5808340311051 50.7301406860352,1.58583402633678 50.731803894043,1.59138894081116 50.7293052673341,1.59138894081116 50.7279167175295,1.59416699409491 50.7284736633303,1.59527695178991 50.749584197998,1.59361100196844 50.7512512207031,1.60027694702148 50.7543067932132,1.60638999938976 50.7670822143555,1.6058340072633 50.7756958007815,1.60416805744183 50.7765274047854,1.6046679019928 50.781806945801,1.60249900817877 50.7845840454102,1.6058340072633 50.7909736633301,1.60527801513683 50.7968063354494,1.60194599628454 50.8037490844729,1.59916698932648 50.8045845031741,1.59250104427343 50.820972442627,1.58861005306244 50.8231925964355,1.58972299098969 50.8304176330569,1.58694398403179 50.8337516784668,1.58583402633678 50.8412513732911,1.58249998092657 50.8481941223145,1.57749998569483 50.8526382446292,1.57861196994781 50.863193511963,1.5808340311051 50.8648605346681,1.57972204685217 50.8670845031738,1.5808340311051 50.8706932067871,1.58472204208385 50.8723602294922,1.60638999938976 50.8709716796874,1.61249995231628 50.8726615905762,1.61305594444281 50.8740272521975,1.63138997554779 50.8751373291018,1.6425000429154 50.8784713745117,1.64916694164287 50.8834724426269,1.66750001907343 50.8926849365237,1.67916703224182 50.9020843505859,1.68972194194805 50.9137496948242,1.70250105857855 50.9218063354494,1.70916700363159 50.9281959533694,1.71249997615814 50.9293060302737,1.71249997615814 50.9306945800781,1.74194395542145 50.9437484741213,1.77860999107372 50.9545822143555,1.81916797161114 50.9604148864748,1.83916699886333 50.9651374816896,1.84416794776917 50.9681930541993,1.84861195087444 50.9643058776858,1.84749996662146 50.9618072509767,1.84972202777857 50.9618072509767,1.85194396972656 50.9648628234864,1.84583401679998 50.9684715270997,1.85749995708471 50.9679183959961,1.86749899387365 50.969306945801,1.8663890361787 50.9704170227054,1.85416603088385 50.9690284729004,1.85083401203156 50.9712486267092,1.84083294868481 50.9734725952151,1.85583198070532 50.9718055725099,1.89361095428467 50.979862213135,1.91694498062139 50.9887504577636,1.93416595458984 50.9968070983888,1.93860995769506 51.0004158020021,1.95472204685217 51.0015258789065,1.96027803421015 51.0004158020021,1.96083402633661 50.9990272521975,1.97694504261023 50.9973602294922,1.98249995708477 50.9990272521975,1.98472201824188 50.9979171752932,2.00194501876831 50.998474121094,2.07500624656683 51.007637023926,2.07500624656683 51.007637023926,2.06771206855785 51.0065040588379,2.08890724182129 51.0035324096679,2.11007332801825 50.9877166748047,2.10926985740662 50.9841690063479,2.12134146690369 50.9789505004883,2.12513375282293 50.9701347351076,2.13565516471863 50.9630928039553,2.14181876182562 50.9474754333497,2.18877005577099 50.8746490478516,2.19231986999523 50.8611869812013,2.20361638069153 50.8497123718261,2.20264720916754 50.8429412841796,2.20812296867376 50.8380851745605,2.21343040466314 50.8105468750002,2.22671318054199 50.8078231811525,2.25483298301697 50.7880325317385,2.27368593215942 50.7832336425781,2.2876183986665 50.7868156433105,2.2885782718659 50.777038574219,2.3126096725465 50.7872047424316,2.31905794143671 50.7824401855472,2.3405625820161 50.7809066772464,2.3603334426881 50.7753906250003,2.3657238483429 50.7754745483398,2.36919450759893 50.7819252014161,2.37431812286377 50.7830276489259,2.40433096885693 50.7716369628908,2.4036421775819 50.7688789367677,2.41147756576549 50.7667350769042,2.38212275505072 50.7549896240236,2.36363625526423 50.7515678405764,2.34219479560846 50.7406997680663,2.33968257904053 50.7306709289552,2.34772205352795 50.7278060913088,2.35564780235302 50.7161293029786,2.3861665725708 50.6985778808595,2.36352467536926 50.6846427917481,2.37730240821844 50.6716842651369,2.39859056472784 50.6805381774902,2.40368270874023 50.6799163818359,2.41451096534735 50.66943359375,2.41613435745234 50.6658325195315,2.42153191566467 50.6655158996582,2.43018746376049 50.6567993164062,2.4508216381073 50.6534461975097,2.47318267822266 50.6385993957521,2.49141263961803 50.631935119629,2.51685428619379 50.6362648010255,2.52428507804871 50.6413536071778,2.53478240966797 50.6416625976564,2.53834652900701 50.631607055664,2.54174375534063 50.6288833618165,2.54633212089539 50.6270141601564,2.56174898147589 50.6275024414065,2.56430101394653 50.6244316101075,2.56775903701782 50.6324653625488,2.57811546325689 50.6325302124026,2.58499336242676 50.6369247436525,2.58961582183844 50.637691497803,2.59259748458874 50.6319503784183,2.61314010620123 50.6340332031251,2.61582922935486 50.6274452209474,2.63051605224604 50.6179504394534,2.67170882225031 50.6262168884277,2.67649984359747 50.6358947753909,2.68195843696606 50.6363029479982,2.69811654090887 50.6291465759278,2.71860218048096 50.6293640136719,2.72606611251837 50.6138458251954,2.74718236923223 50.6052474975589,2.75151801109325 50.6068916320802,2.75032901763916 50.6134414672854,2.76015877723705 50.6314430236817,2.76452398300177 50.6333465576174,2.78457856178284 50.6292457580568,2.7924473285675 50.6336669921878,2.75917744636541 50.6506843566897,2.76969051361095 50.6636238098147,2.79657602310181 50.6629638671877,2.80918788909923 50.6693725585937,2.82127594947821 50.6612777709962,2.83540153503424 50.6590538024905,2.84550237655634 50.6522750854494,2.86973786354076 50.6310958862305,2.86198735237133 50.6275062561035,2.84127521514898 50.6275901794436,2.83138203620905 50.6200218200686,2.80843496322632 50.607719421387,2.78907585144049 50.5830612182619,2.80823469161987 50.5788536071778,2.81504797935497 50.5659675598147,2.81316518783581 50.5493087768557,2.80379009246826 50.5511856079104,2.79447221755981 50.5492057800295,2.80123710632324 50.5376853942871,2.79938626289362 50.5285720825198,2.80377197265631 50.5269088745117,2.81437015533459 50.5281257629394,2.82477068901068 50.5256118774414,2.86205816268932 50.5297698974609,2.88696455955511 50.5376586914065,2.88207721710205 50.5077552795412,2.88705968856823 50.5078315734864,2.89196968078619 50.5023040771484,2.90164089202887 50.5010108947757,2.90483093261719 50.5034561157228,2.91014337539673 50.4998359680176,2.92686462402355 50.5078048706056,2.95067620277405 50.511901855469,2.96306467056274 50.5102005004885,2.96470975875854 50.5127792358398,2.99423050880443 50.4966621398925,3.00834417343151 50.4927673339844,3.02481579780584 50.4813194274903,3.0174412727356 50.4728393554688,3.01644110679632 50.4683418273928,3.00826764106756 50.4558563232422,3.01666069030773 50.4520683288576,3.01634812355053 50.442092895508,3.02985858917236 50.4448471069339,3.03844594955444 50.4421958923342,3.04617071151733 50.4505233764649,3.06652522087103 50.4585304260254,3.06781721115112 50.4468498229983,3.08178615570068 50.443729400635,3.07472157478344 50.4386444091797,3.06851935386669 50.4256477355958,3.03897929191601 50.4231834411624,3.02951574325573 50.4115409851075,3.01462221145641 50.4034729003907,2.9954633712768 50.3999366760255,2.99172711372387 50.4016990661623,2.98051810264599 50.4028816223145,2.99042201042181 50.3949470520021,2.99393463134771 50.3817672729494,3.00937533378612 50.3633918762207,3.00646996498119 50.3611564636231,3.00891137123114 50.3585624694824,3.01345849037176 50.3594131469728,3.03880596160889 50.344020843506,3.04669237136847 50.3458137512209,3.06111359596252 50.3327789306641,3.06036567687994 50.3289184570312,3.08430576324463 50.3111915588379,3.07578921318066 50.3072357177737,3.06527471542358 50.307315826416,3.04761147499079 50.2938461303713,3.05520367622387 50.2897567749025,3.05509734153753 50.2822952270508,3.04430842399597 50.2831077575686,3.0361421108247 50.2875480651856,3.01527404785156 50.2837791442872,3.0122435092926 50.2679786682129,3.01864409446722 50.2643928527832,3.03434824943548 50.2667808532718,3.04623579978949 50.2761688232424,3.05464148521435 50.2753295898438,3.06216096878046 50.2718238830568,3.07747721672064 50.2743644714358,3.10755920410156 50.2685699462891,3.13815927505493 50.265251159668,3.14909124374395 50.2624816894532,3.14716720581055 50.2462234497073,3.1747357845307 50.2414207458499,3.17797660827642 50.2353286743166,3.18685078620916 50.2349281311038,3.18411731719982 50.2262306213381,3.17760777473461 50.2219581604007,3.17888522148138 50.2190742492676,3.14279222488403 50.2192382812499,3.13257408142096 50.2025833129884,3.13119506835932 50.1994934082034,3.142895936966 50.1964912414551,3.14433503150946 50.1909217834473,3.15637731552135 50.1815681457519,3.14680337905889 50.1787338256837,3.13751411438 50.1669464111331,3.11564755439758 50.1666450500491,3.10095858573925 50.1619682312012,3.11553573608404 50.1482162475587,3.13553786277782 50.1442070007326,3.13533306121826 50.1407432556152,3.09596705436701 50.1245155334474,3.09360098838818 50.1216430664062,3.10429358482361 50.1113777160644,3.10460090637207 50.1046333312989,3.10962796211248 50.1047821044923,3.11405467987072 50.092384338379,3.10372853279125 50.0809593200686,3.08885264396667 50.0821762084963,3.08766865730291 50.0755653381348,3.09810757637024 50.0684356689455,3.0858354568482 50.0642242431641,3.08587622642528 50.0553436279298,3.09025359153759 50.0537414550781),(3.09588623046886 50.1631317138675,3.09005808830267 50.1717567443848,3.06272578239452 50.1737747192383,3.06013202667248 50.1678581237795,3.04039835929871 50.1597061157228,3.03952693939215 50.1536254882812,3.02628946304333 50.1510162353516,3.0191764831543 50.1537132263183,3.0078263282777 50.1486854553223,3.00374555587774 50.1501579284668,2.99471831321711 50.1381492614748,3.00238895416265 50.1299591064454,3.00053071975719 50.1201095581055,3.01062798500067 50.112804412842,3.02463746070873 50.1163864135745,3.03703618049633 50.1305809020997,3.05225205421448 50.1323814392092,3.06729435920715 50.1287384033205,3.07236838340765 50.1308174133302,3.06779432296753 50.1474876403809,3.09588623046886 50.1631317138675))	0.0010	POINT(2.337302443469023 50.45271566098597)
13942	POLYGON((11.5937156677247 44.7126274108886,11.5840206146241 44.7081222534181,11.5840206146241 44.7081222534181,11.5765533447265 44.7045707702638,11.574010848999 44.6999740600586,11.5786066055298 44.6961975097657,11.5752172470093 44.6933746337891,11.5630884170532 44.6921424865723,11.5496225357057 44.6984481811523,11.540901184082 44.6898040771486,11.5507650375366 44.690746307373,11.5210599899293 44.6596908569335,11.5155782699586 44.6588935852051,11.5023288726807 44.6525650024415,11.500433921814 44.6500015258789,11.500433921814 44.6500015258789,11.5076637268066 44.6481628417969,11.5239067077637 44.6407470703126,11.5543355941773 44.6389350891114,11.5688438415527 44.6357002258302,11.5764913558961 44.637134552002,11.5764913558961 44.637134552002,11.5975379943848 44.6471939086915,11.6003494262696 44.6437072753906,11.6003494262696 44.6437072753906,11.6014451980592 44.6506042480469,11.6068363189698 44.659107208252,11.6218061447145 44.6662597656251,11.633448600769 44.6738777160646,11.633448600769 44.6738777160646,11.6155557632447 44.6910514831544,11.6155557632447 44.6910514831544,11.5937156677247 44.7126274108886))	0.0006	POINT(11.570138216018718 44.67011046409612)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point