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
27372	POLYGON((-1.27656638622284 49.1162834167482,-1.2773214578628 49.1129684448242,-1.26164877414703 49.1045303344728,-1.2796989679336 49.0848083496094,-1.2796989679336 49.0848083496094,-1.30548012256622 49.0796279907227,-1.30548012256622 49.0796279907227,-1.31851553916925 49.077808380127,-1.31851553916925 49.077808380127,-1.32160818576807 49.0905647277831,-1.33656752109528 49.0992546081544,-1.3462256193161 49.1004486083984,-1.34502780437469 49.1036605834961,-1.34502780437469 49.1036605834961,-1.33688688278198 49.1066741943359,-1.33688688278198 49.1066741943359,-1.31782579421991 49.1068725585937,-1.29981184005737 49.1134071350099,-1.28965055942535 49.1124496459961,-1.27656638622284 49.1162834167482))	0.0006	POINT(-1.3104444616719066 49.09799676192437)
17883	POLYGON((7.04652786254883 45.0784873962402,7.02124786376953 45.0775909423828,7.02124786376953 45.0775909423828,7.0183157920838 45.0808296203614,7.01535892486572 45.0932312011718,7.01000881195068 45.1067008972168,7.00512409210216 45.1293716430665,7.00559711456305 45.1341857910157,7.00559711456305 45.1341857910157,7.0076699256897 45.1352348327638,7.01807212829601 45.1364059448242,7.02335596084595 45.1349563598634,7.02729606628418 45.1350555419922,7.0323362350465 45.1372413635254,7.0323362350465 45.1372413635254,7.04698896408087 45.1281967163086,7.04700899124146 45.1298408508301,7.04896211624146 45.1305656433105,7.05450010299688 45.129005432129,7.05450010299688 45.129005432129,7.05082082748419 45.1231422424316,7.04774618148804 45.1077423095703,7.04822397232056 45.1046142578126,7.05375719070429 45.0957794189453,7.04652786254883 45.0784873962402))	0.0006	POINT(7.030941685040825 45.1169250806173)
180611	MULTIPOLYGON(((9.9716215133667 54.6469497680663,9.96850776672358 54.6451072692874,9.96989345550543 54.6394577026368,9.97371196746826 54.6397361755372,9.97458362579351 54.6381034851074,9.97061443328869 54.6374702453614,9.97091007232677 54.6323204040528,9.96627998352051 54.6314010620119,9.9647264480592 54.6257667541506,9.95953178405767 54.626777648926,9.96031761169439 54.62943649292,9.95411396026611 54.6294288635254,9.9537734985351 54.6306838989259,9.95672512054449 54.6309127807618,9.95517635345465 54.6334533691408,9.95185279846197 54.6332435607911,9.94527816772455 54.6367263793948,9.94527816772455 54.6367263793948,9.94472217559826 54.6412506103516,9.9374990463258 54.6448593139648,9.93638896942144 54.6495819091798,9.94139003753662 54.6540260314942,9.93916702270519 54.6581954956054,9.94083309173584 54.6662483215333,9.94472217559826 54.6679153442384,9.94972229003918 54.6745834350589,9.96416664123535 54.675178527832,9.96416664123535 54.675178527832,9.97583198547369 54.6737518310549,9.98472309112555 54.6695823669434,9.98861122131353 54.6698608398438,9.98972320556646 54.6659736633302,9.99805641174328 54.6662483215333,9.99916553497314 54.6718063354492,10.0024995803834 54.6740264892578,10.0041656494141 54.673194885254,10.005277633667 54.667362213135,10.0097227096557 54.6634712219238,10.0097227096557 54.661804199219,10.0130548477173 54.661804199219,10.0163888931274 54.6643066406249,10.0302782058716 54.6640281677246,10.0308341979981 54.666805267334,10.0330562591554 54.6670837402346,10.0330562591554 54.6698608398438,10.034722328186 54.6695823669434,10.0325002670289 54.6620826721194,10.0180549621583 54.6634712219238,10.0147228240968 54.6606941223147,10.0236120223999 54.657917022705,10.0324993133544 54.6601371765137,10.0319442749025 54.657917022705,10.0336103439331 54.657917022705,10.0336103439331 54.6562500000001,10.0308341979981 54.6509704589844,10.0308341979981 54.6365852355957,10.0308341979981 54.6365852355957,10.0212373733521 54.6438369750977,10.0131568908693 54.6423797607421,10.0078878402711 54.6443519592288,9.99490642547607 54.642791748047,9.984052658081 54.6381454467776,9.98011016845703 54.6460151672364,9.9716215133667 54.6469497680663)),((9.80629444122314 54.7357711791993,9.80729484558105 54.7353019714357,9.81050491333008 54.7353553771972,9.8105792999267 54.7335853576661,9.80651855468744 54.7344093322753,9.80629444122314 54.7357711791993)),((9.78829383850098 54.7400398254397,9.78590297698969 54.7392463684084,9.78509235382074 54.7413330078128,9.78608608245844 54.7421989440921,9.78719997406017 54.7424240112307,9.78829383850098 54.7400398254397)),((9.79469680786138 54.747760772705,9.79546165466309 54.7455825805664,9.79350662231445 54.7456245422366,9.79219818115246 54.7459144592285,9.79164409637457 54.7475166320802,9.79469680786138 54.747760772705)),((9.7828750610351 54.785457611084,9.78071403503429 54.7846984863283,9.77951431274425 54.786766052246,9.79128742218023 54.7912750244141,9.79125499725347 54.789505004883,9.78786087036138 54.7890930175783,9.78750514984137 54.7862014770508,9.7828750610351 54.785457611084)),((9.6750745773316 54.4959716796877,9.67274570465094 54.4945831298828,9.67464160919201 54.4930419921875,9.66120719909668 54.4876136779785,9.65853500366217 54.487846374512,9.65217971801758 54.4833145141602,9.64338684082037 54.4814872741699,9.64422988891607 54.4791297912598,9.64151763916027 54.4767951965334,9.63177013397222 54.47322845459,9.63055801391613 54.4691276550295,9.63161373138428 54.4687767028809,9.62816047668463 54.4657516479492,9.63812065124512 54.463260650635,9.64162445068365 54.4606819152833,9.63992214202887 54.4594955444338,9.6413307189942 54.4545669555664,9.63828563690191 54.4527969360352,9.6225757598877 54.4464836120608,9.61957836151129 54.4469184875489,9.61340427398682 54.4422798156741,9.60030937194824 54.4416236877441,9.58946132659912 54.4345588684081,9.57239913940424 54.4323081970215,9.56995868682861 54.4326286315921,9.56983852386475 54.4339141845703,9.55851936340338 54.4318008422851,9.55349731445318 54.428367614746,9.55211639404297 54.4246940612795,9.55277442932129 54.4206771850587,9.55511379241938 54.4179306030273,9.55386257171637 54.4083671569825,9.56030464172375 54.4044761657717,9.54683303833002 54.399856567383,9.55583858490002 54.3899116516116,9.56573295593273 54.3728485107423,9.5561895370484 54.3578605651858,9.55094909667963 54.3556861877444,9.54477977752686 54.3565979003907,9.53326797485363 54.3550834655762,9.53197956085199 54.3543090820314,9.53349494934082 54.3518524169925,9.53165435791027 54.350986480713,9.52716064453125 54.3519020080567,9.51261997222895 54.3505401611328,9.50392818450933 54.3468742370607,9.49928569793713 54.343605041504,9.49932098388672 54.3420867919922,9.4948520660401 54.3419532775881,9.49471378326416 54.3406219482421,9.4912509918214 54.3395538330078,9.49033260345459 54.3406867980958,9.48857116699213 54.3391456604005,9.47643852233892 54.3381843566895,9.47602367401134 54.3362312316897,9.4740743637085 54.3387413024903,9.47149562835699 54.3373374938967,9.4698915481568 54.3401260375977,9.461350440979 54.3368225097656,9.44089889526373 54.3442573547366,9.41469669342047 54.3459815979006,9.39084148406982 54.3240089416504,9.39707374572748 54.3236122131348,9.39708614349371 54.321315765381,9.39903736114496 54.3213043212891,9.39907455444336 54.3234519958498,9.40201282501226 54.3233146667482,9.40143108367931 54.3154067993165,9.40321159362804 54.313663482666,9.40136528015131 54.3083496093751,9.40293502807623 54.3070335388184,9.39889907836914 54.3058052062989,9.40254497528082 54.3035545349121,9.40534973144537 54.2992744445801,9.39650821685791 54.3037452697754,9.39379978179926 54.3039817810059,9.39315032958996 54.3023872375488,9.39784717559826 54.2976493835449,9.40633773803711 54.2976341247559,9.39408016204845 54.2918777465823,9.39351081848145 54.2889633178711,9.39351081848145 54.2889633178711,9.38207149505627 54.2861518859866,9.37793445587158 54.2882347106935,9.37716102600103 54.2937583923341,9.36459922790527 54.2927665710451,9.3607635498048 54.2874870300296,9.36259937286388 54.2801475524905,9.34281063079845 54.2804336547854,9.33759212493902 54.2832794189453,9.32994937896729 54.2832717895508,9.3242702484132 54.2810630798342,9.32146644592291 54.277515411377,9.31468296051025 54.2769927978516,9.30763339996338 54.2722129821778,9.30270290374762 54.2718696594238,9.29823398590082 54.2747344970705,9.28697109222412 54.2758216857911,9.28172779083263 54.2843475341798,9.28363609313976 54.2906723022461,9.26741027832037 54.2965812683108,9.27355670928955 54.3017539978028,9.26292133331299 54.303165435791,9.25971412658703 54.3057670593263,9.25996398925787 54.309368133545,9.27459430694586 54.308460235596,9.27113342285151 54.3167152404785,9.27790546417248 54.3248748779299,9.26384925842291 54.3296470642091,9.26126956939697 54.3322525024414,9.2612361907959 54.3350372314454,9.26769542694097 54.3391151428225,9.26479816436768 54.3420753479004,9.25890064239502 54.3440475463868,9.24960041046148 54.3404350280764,9.24477863311768 54.3402786254883,9.2383337020874 54.3420486450198,9.23194408416748 54.346618652344,9.22008800506586 54.346263885498,9.21931076049816 54.3445129394531,9.2206707000733 54.3432350158691,9.23001670837408 54.3390007019042,9.22677898406982 54.3315849304199,9.22645759582525 54.3232498168948,9.22315120697027 54.3223457336426,9.21228408813471 54.326644897461,9.2027063369751 54.3227920532229,9.19209194183361 54.3156700134278,9.19021034240728 54.3174438476565,9.19281673431402 54.3236770629883,9.19679164886475 54.3278656005859,9.19681739807129 54.3305625915528,9.19121551513666 54.333377838135,9.17595481872559 54.3349304199219,9.17595481872559 54.3349304199219,9.17135143280035 54.3441581726074,9.17270851135265 54.3489799499512,9.18677711486822 54.3493766784668,9.18589401245123 54.3521232604982,9.18253898620617 54.3517379760744,9.18217182159418 54.3531913757324,9.18562126159679 54.3535041809081,9.18533802032476 54.3562316894532,9.18728446960455 54.3589210510256,9.19631481170654 54.3663597106936,9.20842933654779 54.3634109497073,9.2047843933106 54.381763458252,9.20899868011475 54.3833351135256,9.20798397064203 54.3858757019044,9.21250438690186 54.3849411010742,9.21272754669189 54.381576538086,9.22404956817633 54.3800506591797,9.23058414459229 54.3759841918945,9.23604106903082 54.3755798339845,9.24182415008539 54.3729553222659,9.25823497772211 54.3708190917969,9.26392745971691 54.3723373413088,9.26226806640631 54.3749542236328,9.25899982452404 54.3752174377444,9.26041412353527 54.3778877258304,9.25695991516119 54.3792648315432,9.26373577117931 54.3854103088379,9.26232147216808 54.389114379883,9.25844764709473 54.3916358947755,9.26507854461681 54.3959465026858,9.26403331756597 54.3996467590333,9.26909351348883 54.3997497558593,9.26916217803949 54.4027137756347,9.27324962615978 54.4034690856933,9.27174377441406 54.406623840332,9.27778053283697 54.4097633361816,9.27520847320557 54.413555145264,9.2805643081665 54.4163360595704,9.27934741973883 54.4195823669436,9.28622150421148 54.4193458557131,9.29087734222418 54.4213027954101,9.29010200500488 54.4247779846192,9.30027484893799 54.4310264587405,9.31029510498047 54.4312362670898,9.31095314025885 54.433048248291,9.30921363830572 54.4357795715332,9.31447792053217 54.4392585754395,9.31863784790045 54.4386596679687,9.32349014282221 54.442565917969,9.32328987121582 54.4453582763672,9.32717323303228 54.4481430053712,9.32591724395758 54.4523658752441,9.32724189758312 54.4546508789064,9.32181835174561 54.4619178771975,9.31281471252441 54.4659194946292,9.31778049469 54.4719619750979,9.31766796112066 54.4760475158694,9.31158351898193 54.4780731201172,9.30139160156256 54.4846992492679,9.29985809326178 54.4909973144531,9.28640460968023 54.4971733093263,9.28350830078136 54.5106124877931,9.28073787689215 54.5152511596682,9.29027938842785 54.5194282531739,9.29286479949957 54.522964477539,9.29786300659185 54.5252494812014,9.30410861969006 54.5309638977053,9.29452133178711 54.533763885498,9.29266834259033 54.5364913940433,9.31122398376471 54.5532150268557,9.31087684631348 54.5595741271975,9.30132865905767 54.5618553161621,9.29851436614996 54.5603103637696,9.29211139678955 54.5605812072754,9.28495693206793 54.5715370178223,9.26250839233398 54.5746498107912,9.25008106231684 54.5784606933595,9.25814342498785 54.5897979736328,9.25541973114014 54.5898780822754,9.25498008728033 54.5986099243166,9.26636886596685 54.5998878479005,9.26739215850841 54.6024627685548,9.26588153839123 54.6039123535156,9.25385093688971 54.6039314270019,9.25034046173096 54.6070823669436,9.24214267730724 54.6076660156249,9.24186229705811 54.6145744323732,9.23230552673346 54.6202239990237,9.2321891784668 54.6241455078127,9.22164916992193 54.6289405822754,9.20737266540522 54.6313476562502,9.20737743377686 54.6332397460938,9.21376705169678 54.6358261108399,9.21138477325439 54.6414604187013,9.22257804870611 54.6480331420899,9.18644618988037 54.6612129211426,9.17758083343512 54.6699523925782,9.17206668853765 54.6829109191894,9.1671991348266 54.686477661133,9.16591739654541 54.6917572021486,9.16742992401134 54.6929702758789,9.16846752166748 54.6919937133789,9.1717443466186 54.6987037658694,9.16204071044916 54.7012252807619,9.14980888366699 54.7008590698243,9.14737701416016 54.6998291015627,9.14357376098644 54.6927146911623,9.12448883056641 54.6906089782717,9.11192512512201 54.6928939819339,9.09280109405523 54.6934471130371,9.08597564697266 54.6964569091799,9.07538509368908 54.6966171264651,9.06238174438471 54.7007713317872,9.07220935821539 54.701671600342,9.08046531677252 54.7069435119628,9.08251762390137 54.7099990844729,9.08249855041515 54.7128982543946,9.07626628875727 54.7175331115725,9.0788631439209 54.7238273620608,9.0793628692627 54.7330055236817,9.07552814483654 54.7372817993165,9.07138061523449 54.7388496398926,9.0737037658692 54.7431030273438,9.08002090454107 54.7453651428225,9.07825660705572 54.7563591003418,9.09064292907709 54.7595825195315,9.09697246551519 54.7643852233888,9.11127567291271 54.7679443359375,9.10763072967535 54.7768592834473,9.11200714111339 54.7792968750003,9.12019824981684 54.78812789917,9.11228847503662 54.7906532287599,9.11246585845942 54.7952117919922,9.09907245635986 54.8151168823243,9.09682655334484 54.8158264160159,9.09198570251459 54.8141593933105,9.07801055908209 54.8167610168458,9.08257484436035 54.8191299438478,9.08064174652105 54.8203163146975,9.09889125823975 54.8300018310548,9.10619068145758 54.8302345275881,9.10504150390625 54.8353919982912,9.10973262786877 54.8402900695801,9.10929965972906 54.8482971191407,9.1145544052124 54.8588104248048,9.11711311340332 54.8609771728516,9.11161518096918 54.8635292053222,9.11161804199224 54.8710479736329,9.11335659027111 54.8735427856445,9.11335659027111 54.8735427856445,9.14333057403564 54.8730239868164,9.18614673614513 54.8631095886232,9.18756675720215 54.8611297607423,9.1946115493775 54.8591918945314,9.2050867080689 54.8590087890626,9.24013805389404 54.8499832153323,9.24483013153088 54.8438644409182,9.23516082763678 54.8351058959963,9.2357549667359 54.8311042785644,9.25008106231684 54.8097152709961,9.2733297348023 54.8117561340334,9.28404998779308 54.8096122741699,9.28609085083019 54.8044738769534,9.29477691650385 54.8018722534181,9.29539394378662 54.8032913208008,9.29204177856445 54.8061447143555,9.29348564147955 54.8089828491213,9.329345703125 54.8055686950684,9.34360980987549 54.8002471923829,9.34539604187017 54.8021774291995,9.34210014343262 54.8036308288574,9.34313297271729 54.8070640563964,9.34653091430675 54.8066329956056,9.35621452331543 54.8151359558105,9.36351203918457 54.8153457641604,9.36394500732428 54.8173141479494,9.37384796142584 54.821128845215,9.37249946594238 54.8221664428712,9.37624740600592 54.8291358947754,9.37425041198742 54.8311653137207,9.37462997436523 54.8332595825196,9.37875461578369 54.833080291748,9.38153839111339 54.8353919982912,9.38091182708746 54.8373527526857,9.38268089294434 54.8392028808593,9.39181518554699 54.838333129883,9.40274333953863 54.840503692627,9.40355682373047 54.8388595581055,9.40718364715588 54.8423194885255,9.41113090515137 54.8422966003419,9.418044090271 54.8381881713868,9.41853713989258 54.836627960205,9.4163866043092 54.8359336853027,9.41620254516602 54.8337821960449,9.42015171051025 54.8319549560546,9.41984939575195 54.8291625976562,9.42293357849121 54.8232231140137,9.42293357849121 54.8232231140137,9.41999244689941 54.8229446411134,9.41999244689941 54.8229446411134,9.41913414001465 54.822463989258,9.41793441772461 54.821960449219,9.41607570648188 54.8217201232911,9.41607570648188 54.8217201232911,9.41318225860596 54.8212356567384,9.41201877594 54.8241615295411,9.41201877594 54.8241615295411,9.41102886199951 54.8239631652834,9.40866184234631 54.8229560852051,9.40866184234631 54.8229560852051,9.40824985504162 54.8220291137696,9.40824985504162 54.8220291137696,9.407060623169 54.8223419189455,9.40469455718994 54.8224830627443,9.40469455718994 54.8224830627443,9.4096307754516 54.8191223144532,9.4096307754516 54.8191223144532,9.41017723083496 54.8186225891116,9.41039466857922 54.8184204101562,9.41039466857922 54.8184204101562,9.41151332855225 54.8160095214844,9.40785121917736 54.8133926391602,9.40785121917736 54.8133926391602,9.40652656555181 54.8123130798342,9.40457725524914 54.810787200928,9.40338516235363 54.809997558594,9.40226364135737 54.8083190917968,9.40226364135737 54.8083190917968,9.40260028839117 54.8042907714845,9.40260028839117 54.8042907714845,9.40401840209961 54.8017196655276,9.40573883056652 54.7994537353518,9.40632629394543 54.7983818054201,9.40590476989757 54.7966575622561,9.40560626983648 54.7955589294434,9.40560626983648 54.7955589294434,9.3948268890382 54.7925758361816,9.3948268890382 54.7925758361816,9.38970279693609 54.7907447814944,9.38618850708019 54.7897186279299,9.38169097900396 54.7888984680177,9.38169097900396 54.7888984680177,9.37889003753662 54.7879219055176,9.37889003753662 54.7879219055176,9.37717723846441 54.7863655090334,9.37547397613537 54.7855682373048,9.37547397613537 54.7855682373048,9.36658859252924 54.7827873229981,9.36658859252924 54.7827873229981,9.36322593688965 54.7819404602052,9.35988807678223 54.781318664551,9.35877609252924 54.7810935974122,9.35758781433111 54.7808494567873,9.35722064971935 54.779483795166,9.35722064971935 54.779483795166,9.36594772338873 54.7715950012206,9.37141036987305 54.7614250183106,9.37141036987305 54.7614250183106,9.37098407745373 54.7611160278323,9.37327861785889 54.7600135803223,9.37327861785889 54.7600135803223,9.37192821502686 54.7588653564454,9.376877784729 54.7565460205079,9.376877784729 54.7565460205079,9.37901496887207 54.7532005310061,9.40653419494635 54.7535018920899,9.40653419494635 54.7535018920899,9.41435718536377 54.7534065246583,9.41435718536377 54.7534065246583,9.43792152404785 54.7536354064944,9.45062637329107 54.7518730163575,9.45062637329107 54.7518730163575,9.45161724090588 54.7519721984863,9.45161724090588 54.7519721984863,9.45237541198736 54.7520484924319,9.45308780670177 54.7521171569827,9.45646858215338 54.7528381347656,9.45940113067633 54.7534713745119,9.46096515655523 54.754219055176,9.461259841919 54.7554855346679,9.461259841919 54.7554855346679,9.46027374267584 54.7602882385255,9.46027374267584 54.7602882385255,9.46823406219477 54.7654685974124,9.47082424163818 54.7661628723147,9.47224903106701 54.7669296264648,9.47224903106701 54.7669296264648,9.47471046447754 54.7723808288574,9.47471046447754 54.7723808288574,9.47932338714605 54.7715988159182,9.48365306854259 54.7710151672363,9.48626136779791 54.770992279053,9.48816776275646 54.7704849243165,9.48816776275646 54.7704849243165,9.48859405517578 54.7695388793946,9.48859405517578 54.7695388793946,9.4899721145631 54.7696838378909,9.49119377136225 54.7698554992679,9.49262809753424 54.7696151733398,9.49262809753424 54.7696151733398,9.49333477020269 54.7692527770997,9.49333477020269 54.7692527770997,9.49466514587402 54.7714347839355,9.49678134918224 54.7705535888671,9.49678134918224 54.7705535888671,9.50455570220953 54.7726325988772,9.50581741333019 54.7731094360354,9.50529384613048 54.7736282348633,9.50529384613048 54.7736282348633,9.5033969879151 54.7730751037599,9.5033969879151 54.7730751037599,9.50311374664307 54.773880004883,9.5045108795166 54.775890350342,9.50473022460949 54.7764778137208,9.50473022460949 54.7764778137208,9.50218009948736 54.7792739868165,9.5030918121339 54.7814521789551,9.5030918121339 54.7814521789551,9.50357627868664 54.781978607178,9.50440788269043 54.7849464416503,9.5037956237793 54.7852020263675,9.5030918121339 54.7874031066897,9.50478363037104 54.7874450683594,9.50478363037104 54.7874450683594,9.50569057464611 54.7878379821777,9.50569057464611 54.7878379821777,9.50544738769537 54.7889404296877,9.50496196746832 54.7897682189941,9.50496196746832 54.7897682189941,9.50671482086176 54.7911758422852,9.50574970245367 54.7926292419434,9.50574970245367 54.7926292419434,9.50265026092535 54.7936363220217,9.50146579742437 54.7944717407229,9.49968719482422 54.7961463928224,9.49968719482422 54.7961463928224,9.49897575378429 54.7986526489258,9.50541496276861 54.7995986938477,9.50541496276861 54.7995986938477,9.50568485260015 54.8006782531741,9.50341224670416 54.8008766174319,9.50340461730963 54.8018913269046,9.49969768524164 54.8036193847659,9.49982738494879 54.8040351867676,9.49982738494879 54.8040351867676,9.50383281707769 54.8041725158693,9.50383281707769 54.8041725158693,9.50528717041021 54.8070487976077,9.5045375823974 54.807239532471,9.50387191772472 54.8077735900879,9.50439262390137 54.8094444274905,9.50543117523199 54.8102073669436,9.50398349761969 54.8109779357912,9.50390529632574 54.8110198974611,9.50164985656738 54.8124313354493,9.50164985656738 54.8124313354493,9.49625778198254 54.8150901794433,9.49205207824701 54.8148498535156,9.49093246459972 54.8194351196289,9.49220657348638 54.8201370239257,9.49195003509533 54.8226356506348,9.49195003509533 54.8226356506348,9.50081157684338 54.8241996765138,9.50364589691162 54.8292732238772,9.51673126220709 54.8388671875002,9.52344799041754 54.8368453979493,9.53137397766113 54.8436508178711,9.54012966156012 54.8483009338379,9.56470870971685 54.8546371459964,9.56919097900396 54.8579711914062,9.57187652587902 54.8571243286134,9.57023715972895 54.8583946228027,9.57367706298828 54.863708496094,9.58470344543468 54.8652000427247,9.58649730682367 54.8670387268069,9.58481788635254 54.8701667785646,9.58632946014404 54.8739128112795,9.59397697448742 54.8782386779785,9.59305763244635 54.8765640258792,9.59305763244635 54.8765640258792,9.61417770385737 54.8762359619141,9.59964752197266 54.8667068481445,9.59406566619884 54.8602142333984,9.58975124359137 54.8510665893555,9.58986568450928 54.8457145690919,9.59334373474127 54.8400955200196,9.60443305969238 54.8307723999025,9.61271286010742 54.8297843933105,9.62353038787842 54.8317413330081,9.65365695953375 54.8203964233398,9.65421485900879 54.8224487304688,9.66263484954845 54.8234748840331,9.7102108001709 54.8089447021484,9.76068973541265 54.8014221191409,9.76855850219732 54.7971954345704,9.76856231689447 54.7951736450195,9.7662467956543 54.7943267822266,9.76833438873297 54.7930641174319,9.76781463623041 54.7898750305179,9.77057647705084 54.786418914795,9.77679920196539 54.787567138672,9.77810668945307 54.7864875793457,9.778000831604 54.7844696044921,9.77460289001476 54.7833976745608,9.78447151184082 54.7773361206055,9.78307247161865 54.776554107666,9.78577613830561 54.7699127197266,9.77652454376221 54.7671852111819,9.77876758575451 54.7640037536623,9.7752046585083 54.7645378112792,9.77535533905029 54.7629776000977,9.7716464996339 54.7620506286621,9.77242946624756 54.7598114013673,9.77009773254406 54.7591247558594,9.77273368835449 54.7574462890625,9.77271461486822 54.7549476623536,9.7753696441651 54.754821777344,9.77534866333002 54.7523994445801,9.77318859100353 54.7526016235353,9.77198410034185 54.7468681335449,9.7688627243042 54.7479095458984,9.76985549926758 54.7443161010744,9.77335453033442 54.7447204589844,9.77742862701416 54.7423324584961,9.77743816375732 54.7408599853516,9.78358459472668 54.7415237426761,9.78392314910889 54.7389297485353,9.78656768798828 54.736614227295,9.78323841094971 54.7372398376468,9.78095722198486 54.7364006042483,9.78097248077398 54.7345886230471,9.78175640106213 54.7331314086917,9.78574562072765 54.7329177856446,9.78574752807623 54.7309722900393,9.79064178466808 54.7322921752932,9.79059791564941 54.7348861694335,9.79576206207281 54.7321395874024,9.79922771453857 54.7344741821292,9.80213928222651 54.7338104248049,9.8052158355714 54.7372817993165,9.80610370635986 54.7360725402833,9.80304908752447 54.734100341797,9.81118488311779 54.7326126098633,9.81512451171875 54.730640411377,9.81591796875 54.7285537719729,9.81567668914801 54.731029510498,9.81736278533941 54.7312889099122,9.81816196441662 54.7297859191896,9.82164382934582 54.7292823791504,9.82016468048107 54.7306594848636,9.82748889923096 54.7362442016602,9.8252477645874 54.7386894226076,9.82612133026123 54.7403182983401,9.82796573638916 54.7404022216796,9.82826328277599 54.7422065734864,9.8354434967041 54.742317199707,9.83707809448248 54.7439308166503,9.84023284912121 54.7425842285159,9.85780429840099 54.7427902221682,9.86443519592285 54.7402114868163,9.87020683288574 54.7411460876465,9.87456512451183 54.7338371276855,9.87173366546625 54.7323226928712,9.87160587310791 54.729404449463,9.87524223327642 54.7278518676758,9.87418079376221 54.7261886596682,9.87578201293951 54.7227668762206,9.8807430267334 54.7206649780276,9.88377475738537 54.7200317382812,9.88607025146479 54.7243156433105,9.89897060394298 54.7253761291504,9.91403961181646 54.7301025390624,9.91630363464367 54.7243957519531,9.91311454772949 54.7229461669924,9.91822052001959 54.7214164733888,9.92022609710693 54.7187614440917,9.92148590087902 54.7098808288576,9.96193408966064 54.714138031006,10.0336103439331 54.692081451416,10.0369453430176 54.6893043518069,10.0375013351441 54.6826400756836,10.034722328186 54.6723594665528,10.0313901901246 54.673194885254,10.0325002670289 54.6751403808595,10.0297222137452 54.6768074035644,10.0302782058716 54.6790275573731,10.0269441604614 54.6787490844728,10.0297222137452 54.6804161071777,10.0291662216187 54.682083129883,10.0241651535035 54.6818046569826,10.0302782058716 54.6862487792968,10.0269441604614 54.6840286254885,10.0219430923462 54.6840286254885,10.0291662216187 54.6881942749025,10.0275001525878 54.6895828247073,10.0269441604614 54.687915802002,10.0208330154418 54.687915802002,10.0202770233155 54.6895828247073,10.0224990844727 54.692081451416,10.0147228240968 54.6926383972167,10.0130548477173 54.6895828247073,9.99916553497314 54.6876373291016,9.99583435058599 54.6848602294923,9.99638652801508 54.6809730529788,9.99472141265875 54.6804161071777,9.98694515228266 54.6845817565919,9.98694515228266 54.6862487792968,9.99027919769293 54.6859741210938,9.99472141265875 54.6887512207031,9.99472141265875 54.6912498474122,9.99138927459728 54.6934738159181,9.99305534362793 54.6990280151367,9.98805522918701 54.7012481689454,9.98250102996826 54.7009735107424,9.98138809204102 54.6981925964355,9.98250102996826 54.6968040466311,9.97416591644281 54.6934738159181,9.9752779006958 54.6909713745118,9.97361183166515 54.6893043518069,9.98027801513666 54.6870841979982,9.97749996185308 54.6826400756836,9.96861171722423 54.6834716796877,9.96138858795177 54.6781959533691,9.95027828216564 54.6781959533691,9.93805503845226 54.6729164123536,9.94027709960938 54.6706962585449,9.93694305419933 54.667362213135,9.93861103057873 54.6656951904297,9.93805503845226 54.6637496948242,9.93527698516851 54.661804199219,9.93527698516851 54.6576385498046,9.9374990463258 54.6548614501955,9.93305683135998 54.6509704589844,9.93138885498053 54.6459732055667,9.93194484710699 54.6423606872561,9.92972278594971 54.641529083252,9.93027877807617 54.6348609924316,9.93194484710699 54.6331939697268,9.93805503845226 54.6326370239257,9.93527698516851 54.6297454833986,9.93527698516851 54.6297454833986,9.9343194961549 54.6290283203124,9.9343194961549 54.6290283203124,9.93194484710699 54.6270828247073,9.91305541992193 54.6287498474121,9.91083335876465 54.6304168701172,9.91250133514404 54.6337509155275,9.90805530548101 54.6345825195312,9.90527915954584 54.6320838928225,9.90527915954584 54.6301383972168,9.909167289734 54.6281929016113,9.89194583892834 54.6231956481933,9.88972187042242 54.6206932067874,9.87916660308849 54.6156959533692,9.87583160400391 54.6098594665527,9.8619432449342 54.6054153442385,9.85916519165045 54.6023597717286,9.85360908508306 54.6004180908203,9.8436098098756 54.6009712219241,9.84249973297125 54.5993041992189,9.83638668060308 54.5984725952151,9.83250236511236 54.5965270996094,9.83250236511236 54.5951385498047,9.83860969543451 54.5943069458007,9.82472324371338 54.5915260314943,9.82083225250256 54.5887489318848,9.8219451904298 54.5862503051759,9.81861019134527 54.5848617553713,9.8125 54.5862503051759,9.8125 54.5881958007812,9.82083225250256 54.5906944274905,9.82472324371338 54.59375,9.82027912139898 54.5940284729003,9.81416606903082 54.5923614501954,9.81027793884289 54.5893058776855,9.80472087860107 54.5884704589846,9.80472087860107 54.5862503051759,9.80138874053961 54.5823593139648,9.80194473266607 54.5795822143556,9.80361080169689 54.5795822143556,9.80972194671642 54.5873603820801,9.81027793884289 54.5856933593753,9.81472206115734 54.5843048095705,9.81027793884289 54.5790290832522,9.79749870300304 54.5776405334473,9.79194355010998 54.5737495422364,9.78527832031256 54.5731925964357,9.77361106872564 54.5754165649413,9.78083419799816 54.578193664551,9.78083419799816 54.5795822143556,9.77313613891607 54.5784721374514,9.77249908447271 54.5804176330567,9.77027893066401 54.5806961059571,9.76750087738043 54.5790290832522,9.76694393157965 54.5745849609376,9.76360988616943 54.569305419922,9.7641658782959 54.5665283203125,9.76861095428478 54.5665283203125,9.76861095428478 54.5651397705078,9.75361156463623 54.5584716796875,9.75305461883545 54.554027557373,9.74027919769298 54.5448608398439,9.73805427551281 54.5406951904298,9.73861026763927 54.5379180908203,9.73472213745112 54.5323600769044,9.72583007812511 54.530773162842,9.72337913513184 54.5310096740723,9.71916675567627 54.5345840454104,9.7137393951416 54.5330734252929,9.71972084045416 54.5300674438478,9.71680641174316 54.5284385681152,9.71675491333019 54.5259704589845,9.71218204498291 54.5200958251954,9.70280361175537 54.5194206237796,9.70139026641846 54.5256958007812,9.69916534423828 54.5273628234866,9.6702766418457 54.5254173278809,9.65848255157471 54.5226020812991,9.65083408355719 54.5223617553712,9.64638710021973 54.5240287780761,9.64516544342052 54.5229148864748,9.64916801452637 54.521251678467,9.63916683197027 54.5218048095706,9.63527870178234 54.5184707641604,9.63527870178234 54.5151405334475,9.63305664062506 54.5143051147463,9.62694358825695 54.5229148864748,9.63305664062506 54.5248603820803,9.63360977172863 54.5270843505862,9.62707328796392 54.5310592651369,9.61638927459728 54.52791595459,9.6041660308839 54.5268058776856,9.59972190856928 54.5229148864748,9.60305595397955 54.522083282471,9.60527610778809 54.5234718322754,9.60486316680908 54.5206413269043,9.59730911254888 54.5189514160157,9.58706569671637 54.5123176574708,9.58694458007824 54.5101585388184,9.57902050018322 54.5104522705078,9.57314586639399 54.5124473571777,9.5574827194215 54.5109710693359,9.55671691894531 54.5130004882814,9.5486097335816 54.5123596191406,9.54509925842285 54.5088462829592,9.54907035827642 54.5078506469728,9.5486097335816 54.5051383972167,9.55138778686535 54.5031929016114,9.55749893188488 54.5034713745118,9.56138896942144 54.5009727478027,9.57083415985119 54.5020828247073,9.57750034332275 54.5004158020021,9.56694316864019 54.4951400756836,9.5702800750733 54.4890136718749,9.57638835906977 54.4862518310549,9.57361221313477 54.479862213135,9.57416629791265 54.47513961792,9.57750034332275 54.47513961792,9.57805442810064 54.4768066406249,9.5825014114381 54.4779167175293,9.58250808715815 54.4834747314454,9.57750034332275 54.4884719848633,9.58194541931164 54.4940261840822,9.58194541931164 54.5004158020021,9.58083343505871 54.5009727478027,9.59583377838135 54.5059738159183,9.61361122131348 54.5079154968264,9.62416553497314 54.5115280151367,9.6286096572876 54.5115280151367,9.63865375518799 54.5080261230469,9.63916683197027 54.5098609924318,9.64694309234619 54.5101394653321,9.66638946533203 54.5056953430177,9.66852283477795 54.5043067932129,9.6702766418457 54.4987487792968,9.6750745773316 54.4959716796877)))	0.0010	POINT(9.527258499556256 54.62871912133023)
45028	POLYGON((-0.165669828653336 42.9544944763184,-0.149245783686638 42.9801139831544,-0.149245783686638 42.9801139831544,-0.151812061667442 42.9797401428224,-0.151812061667442 42.9797401428224,-0.162909358739796 42.9766616821289,-0.162909358739796 42.9766616821289,-0.174721896648407 42.9777069091797,-0.174721896648407 42.9777069091797,-0.16819965839386 42.9617729187012,-0.170191794633865 42.9587631225586,-0.170191794633865 42.9587631225586,-0.165669828653336 42.9544944763184))	0.0006	POINT(-0.16263593981662433 42.97185325622562)
36817	POLYGON((5.78837871551525 46.7572402954102,5.78653144836431 46.7529220581055,5.78653144836431 46.7529220581055,5.78153800964367 46.7465476989747,5.78153800964367 46.7465476989747,5.79921817779535 46.7404327392578,5.81345033645641 46.7432022094727,5.82572412490845 46.7375335693361,5.834788799286 46.7404708862305,5.834788799286 46.7404708862305,5.84379529953009 46.7490234375,5.84379529953009 46.7490234375,5.8300199508667 46.7663841247559,5.81118965148931 46.7767219543458,5.81118965148931 46.7767219543458,5.78837871551525 46.7572402954102))	0.0006	POINT(5.8114985148112615 46.75174433390304)
40715	POLYGON((1.89156150817865 46.2517929077148,1.88885641098034 46.2545928955079,1.89180338382727 46.2610168457032,1.89180338382727 46.2610168457032,1.91621398925776 46.2721214294434,1.91319131851208 46.2785034179688,1.91713070869451 46.2914390563965,1.91713070869451 46.2914390563965,1.92862749099737 46.2974281311036,1.95233190059668 46.2862472534181,1.95233190059668 46.2862472534181,1.97157490253454 46.2762908935547,1.98020398616791 46.2508926391602,1.98020398616791 46.2508926391602,1.95654344558727 46.2540626525879,1.94461834430695 46.2430038452148,1.93960678577434 46.2430725097657,1.93020629882818 46.2512168884278,1.91080260276794 46.2549514770509,1.89156150817865 46.2517929077148))	0.0006	POINT(1.9302496345420077 46.26611729672086)
38459	POLYGON((0.51356482505804 49.7299880981446,0.509736061096305 49.7425498962402,0.505423903465328 49.7445030212403,0.487474590539932 49.7376976013185,0.472018212080002 49.7389144897462,0.472018212080002 49.7389144897462,0.487620145082587 49.7502670288086,0.487620145082587 49.7502670288086,0.507896125316563 49.7501373291016,0.507896125316563 49.7501373291016,0.513836324215049 49.7458076477051,0.526664257049561 49.7435951232911,0.526664257049561 49.7435951232911,0.52783119678503 49.7409782409668,0.539671719074249 49.7384948730469,0.539671719074249 49.7384948730469,0.546239495277462 49.7386360168458,0.546239495277462 49.7386360168458,0.548462092876434 49.729591369629,0.537908017635459 49.7247047424318,0.537908017635459 49.7247047424318,0.535582423210144 49.7341232299805,0.531000077724514 49.7353858947755,0.51356482505804 49.7299880981446))	0.0006	POINT(0.5177803233914149 49.73957061767584)
27625	POLYGON((0.113518066704273 48.6311302185059,0.103556565940437 48.6334800720215,0.0997954532505219 48.6310234069825,0.0841336399317356 48.6089363098146,0.0762365832925411 48.6047554016113,0.0762365832925411 48.6047554016113,0.0693946182727245 48.5955696105958,0.0693946182727245 48.5955696105958,0.108936384320373 48.5892105102538,0.108936384320373 48.5892105102538,0.128518298268318 48.6091957092285,0.146288752555961 48.6161155700684,0.133069306612015 48.6264724731445,0.133069306612015 48.6264724731445,0.113518066704273 48.6311302185059))	0.0006	POINT(0.10364889726046814 48.611564091273735)
73061	POLYGON((10.1976623535157 47.2327575683594,10.2139205932618 47.2457542419435,10.217022895813 47.2503204345703,10.2117319107056 47.2530059814454,10.178409576416 47.2610816955566,10.1755914688111 47.264030456543,10.1762514114381 47.2701911926269,10.1762514114381 47.2701911926269,10.1872110366822 47.2726020812989,10.1949853897095 47.2731170654298,10.1956472396851 47.2744026184082,10.201252937317 47.2768707275391,10.20761013031 47.2752685546875,10.2222261428834 47.2758140563965,10.2322998046875 47.2704772949218,10.2380723953248 47.2719917297364,10.2422647476197 47.2780647277832,10.2451162338257 47.2789344787599,10.2456150054933 47.2804565429688,10.2482814788818 47.2790985107422,10.2570343017578 47.2808876037598,10.2599220275879 47.281608581543,10.2615232467651 47.2842636108398,10.2648057937622 47.2850570678712,10.2648057937622 47.2850570678712,10.2717981338501 47.2754364013671,10.2786254882812 47.2711639404297,10.2964782714845 47.272315979004,10.3022012710572 47.2712326049804,10.3052740097045 47.2686080932617,10.3129234313965 47.2575035095215,10.3204698562623 47.2515716552736,10.321195602417 47.2496566772462,10.3196401596069 47.2444000244141,10.3199615478517 47.2402153015138,10.3190784454345 47.2376556396486,10.3125715255738 47.2350425720216,10.3031692504884 47.2338752746583,10.3031692504884 47.2338752746583,10.2975769042969 47.233612060547,10.2942562103271 47.2313613891603,10.2894744873046 47.2201042175294,10.2869033813477 47.2177429199219,10.2716732025146 47.213436126709,10.2655839920044 47.2095527648926,10.2358903884888 47.1818580627443,10.2261991500856 47.1767044067383,10.2087478637696 47.1696662902831,10.2087478637696 47.1696662902831,10.1995773315431 47.1826553344727,10.1969432830811 47.1888580322266,10.1989898681641 47.1930160522462,10.2080469131469 47.2006187438965,10.2106685638428 47.2039337158203,10.2118873596193 47.2096977233888,10.2114295959473 47.2175140380859,10.2101430892944 47.2218589782715,10.2082319259645 47.2244415283204,10.1976623535157 47.2327575683594))	0.0006	POINT(10.245569705963169 47.244485460478714)
36103	POLYGON((6.64040851593029 47.6217269897462,6.62786340713512 47.6361732482911,6.62786340713512 47.6361732482911,6.64224100112926 47.6352958679199,6.65044212341309 47.6468238830567,6.65044212341309 47.6468238830567,6.66091394424438 47.6325225830078,6.68110418319708 47.6183433532715,6.68110418319708 47.6183433532715,6.68039989471447 47.6137313842774,6.68039989471447 47.6137313842774,6.67042112350475 47.611442565918,6.67042112350475 47.611442565918,6.65063142776501 47.6225166320801,6.64040851593029 47.6217269897462))	0.0006	POINT(6.658189739499854 47.62607792445595)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point