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
34431	POLYGON((5.18535137176514 48.427516937256,5.186022758484 48.4342269897462,5.21199750900263 48.4504661560059,5.21199750900263 48.4504661560059,5.16016340255737 48.4486770629883,5.16016340255737 48.4486770629883,5.16076469421387 48.4392890930176,5.17822313308727 48.4333419799806,5.18127822875988 48.4271240234375,5.18127822875988 48.4271240234375,5.18535137176514 48.427516937256))	0.0006	POINT(5.181724023819004 48.438690948486375)
180301	POLYGON((12.7640008926392 48.7979125976564,12.7660236358642 48.8024482727053,12.7689199447632 48.8019638061526,12.7696542739868 48.8055152893069,12.7651538848878 48.8065719604493,12.7657442092896 48.8103599548341,12.7551403045655 48.8132781982423,12.7577247619629 48.8152427673342,12.7496356964111 48.8185653686526,12.7527284622192 48.8229637145996,12.7565956115723 48.8243789672853,12.7590045928955 48.8286933898926,12.7620029449462 48.8284187316895,12.7624559402465 48.8302345275881,12.7675619125367 48.8298530578615,12.766194343567 48.8309059143067,12.7683610916139 48.8320693969727,12.7658596038819 48.8345375061036,12.7691583633423 48.8365936279296,12.7892827987671 48.8266181945802,12.806700706482 48.8226318359378,12.8204517364503 48.8235244750979,12.8305597305298 48.8265914916994,12.8386745452881 48.8306846618655,12.845009803772 48.8376960754395,12.8487882614137 48.8397216796877,12.8464097976685 48.8457832336426,12.8503561019898 48.8461952209475,12.8498821258545 48.8473930358887,12.8428249359131 48.8531303405763,12.8477420806885 48.8544273376464,12.8475255966188 48.8572845458987,12.8460931777954 48.8570022583007,12.8451633453369 48.8594779968264,12.8412609100341 48.8614120483398,12.8384628295898 48.8667259216311,12.8423089981079 48.8712425231935,12.8475780487061 48.8713302612305,12.8485975265504 48.8729553222657,12.8399381637574 48.8811912536621,12.8368129730225 48.8902282714845,12.8440465927125 48.8970336914065,12.8624982833863 48.8981552124025,12.8638372421265 48.8995819091799,12.8614463806152 48.900947570801,12.8618278503418 48.9028854370119,12.8687553405762 48.9047164916994,12.8697042465209 48.9068107604981,12.8747320175171 48.9066238403322,12.8724527359009 48.9110984802246,12.8757028579712 48.9100036621097,12.876000404358 48.911617279053,12.8703050613404 48.9126663208011,12.8683061599733 48.9156227111819,12.8625965118408 48.9180259704592,12.866982460022 48.9178810119629,12.8642845153808 48.9196777343751,12.8642673492432 48.9221076965335,12.8704824447632 48.9243850708008,12.867621421814 48.9259147644046,12.8679237365722 48.9284820556642,12.860224723816 48.9288253784182,12.8609218597412 48.926036834717,12.8586931228638 48.925132751465,12.8543167114258 48.9280853271485,12.8639965057373 48.9316787719729,12.8618984222412 48.9328994750978,12.86252784729 48.9340400695803,12.8685932159425 48.9374122619629,12.8648424148561 48.9406051635742,12.8640508651733 48.9445457458498,12.8728704452515 48.9463806152344,12.8699283599855 48.9493522644044,12.8694753646852 48.9534912109378,12.8745431900024 48.9495658874515,12.8806438446045 48.9494361877441,12.8819885253906 48.9481582641603,12.8873920440674 48.949401855469,12.8914270401002 48.954471588135,12.8914270401002 48.954471588135,12.9003429412843 48.9485664367678,12.9006204605104 48.9450607299805,12.9132919311524 48.9358863830566,12.9310035705568 48.9363479614257,12.9435014724731 48.938793182373,12.9441089630128 48.9413528442385,12.9496355056763 48.9412307739258,12.9521818161012 48.9364852905275,12.9484014511109 48.9338340759277,12.9449844360352 48.9354209899903,12.9470634460449 48.9333152770997,12.9450206756591 48.931262969971,12.9492864608765 48.928379058838,12.9588689804078 48.9299049377443,12.9578838348389 48.9368743896486,12.9601364135742 48.9384536743163,12.960205078125 48.9449119567873,12.9648809432983 48.948741912842,12.9736471176147 48.9491691589357,12.9786415100098 48.9514541625978,12.9768362045289 48.9570350646974,12.9842691421509 48.9506149291995,12.9892129898071 48.9484443664552,13.009274482727 48.9493179321288,13.0168018341066 48.9440383911133,13.0252408981323 48.9418754577639,13.0248384475709 48.9399147033693,13.0275707244874 48.9359931945801,13.0282859802247 48.9230079650881,13.0209894180299 48.9210853576662,13.0150575637817 48.9262504577639,13.0068693161011 48.922924041748,13.0064992904663 48.9207839965823,13.0085506439209 48.9187393188477,13.0138654708862 48.9206428527834,13.0281696319581 48.9058685302736,13.033989906311 48.908561706543,13.0361099243164 48.9018554687502,13.0420112609864 48.901954650879,13.0423860549927 48.8984260559083,13.0446338653566 48.8957481384278,13.050742149353 48.8925209045411,13.0606689453125 48.8825302124026,13.0845365524293 48.880023956299,13.0974712371826 48.8835945129396,13.0998830795289 48.8797149658203,13.1029138565064 48.8822898864746,13.1073989868164 48.8809318542482,13.1087980270385 48.8830947875979,13.1149301528931 48.8816833496096,13.116557121277 48.8830032348633,13.1157999038696 48.884147644043,13.122660636902 48.8881340026857,13.1297874450683 48.8839073181155,13.1360139846802 48.8837318420411,13.140585899353 48.8812408447266,13.1437883377075 48.8766632080078,13.1439390182495 48.8781623840334,13.1570177078248 48.8728408813476,13.1658678054809 48.8720169067384,13.1648807525635 48.8706817626954,13.1670942306519 48.8697547912598,13.1665210723878 48.867416381836,13.1743631362914 48.8652610778811,13.1752796173097 48.8682823181153,13.1693954467773 48.8711776733398,13.1738891601563 48.8710136413575,13.1749591827392 48.8718605041506,13.1739549636841 48.8737030029299,13.1770362854004 48.8729209899903,13.1766777038575 48.8681488037112,13.1798191070557 48.868217468262,13.182975769043 48.873245239258,13.1902217864991 48.8705673217773,13.1894426345826 48.8722686767578,13.1936407089233 48.8731765747073,13.1946983337402 48.8708572387696,13.1917486190796 48.8673629760742,13.1994905471802 48.8687248229982,13.2036724090576 48.8666496276855,13.2017240524292 48.8647270202636,13.1953592300415 48.864097595215,13.1954631805419 48.8627738952638,13.1954631805419 48.8627738952638,13.1889610290527 48.8618698120119,13.1926259994506 48.860809326172,13.194679260254 48.8550453186037,13.2036285400391 48.848976135254,13.2076663970948 48.8487625122073,13.2016820907593 48.848072052002,13.2072525024415 48.8425712585452,13.2028226852416 48.842353820801,13.196925163269 48.8360824584961,13.20046043396 48.8342056274416,13.198130607605 48.8326225280762,13.1992349624634 48.8283843994142,13.1904382705688 48.8267898559571,13.1807107925415 48.827850341797,13.1784343719484 48.8246383666992,13.1678791046144 48.8178291320801,13.1718196868896 48.8163833618163,13.1732501983643 48.8186073303224,13.1755418777467 48.8171691894533,13.1788845062256 48.8204345703125,13.1819972991944 48.8203048706055,13.1830253601074 48.8238525390627,13.1864471435547 48.823383331299,13.1863975524903 48.8190383911134,13.1916828155519 48.8176422119141,13.1958074569703 48.8178977966311,13.1967449188234 48.819850921631,13.2007265090944 48.8186569213868,13.2023839950562 48.8215065002444,13.2087488174438 48.8217544555666,13.2159814834595 48.8204612731935,13.216682434082 48.8193473815918,13.211890220642 48.8179626464844,13.2125291824341 48.8152656555176,13.2201833724976 48.8127479553225,13.2247104644777 48.8132934570315,13.2286977767944 48.8102874755859,13.2267847061158 48.8087425231936,13.2287960052491 48.8071899414065,13.2332420349121 48.80823135376,13.2352113723755 48.8119926452639,13.2408695220948 48.8096389770508,13.2456226348878 48.8030967712405,13.2413024902344 48.801139831543,13.2398929595948 48.7968902587893,13.2416276931763 48.791229248047,13.2392549514772 48.7887649536135,13.2336835861207 48.7893562316897,13.2351942062379 48.7882423400878,13.2214365005494 48.7821197509768,13.2286281585694 48.7799606323242,13.2270345687867 48.7784996032716,13.2260246276856 48.7726478576662,13.2294769287109 48.7722930908206,13.230938911438 48.7699623107912,13.24169921875 48.7688407897949,13.2443962097169 48.7649230957033,13.2520790100098 48.7655792236329,13.2551603317261 48.7627944946289,13.2554769515992 48.7616424560546,13.2522687911987 48.7595520019531,13.2513685226441 48.755195617676,13.2449131011964 48.7553634643555,13.2439374923707 48.7537574768068,13.2489423751832 48.7491149902344,13.2535562515259 48.7488861083986,13.2573051452637 48.7466049194338,13.2587051391602 48.7410621643067,13.2587051391602 48.7410621643067,13.2577228546142 48.7333488464357,13.2557039260864 48.7302665710449,13.2533578872681 48.7297554016113,13.2541799545289 48.72412109375,13.2493314743043 48.7206344604492,13.2482929229737 48.7164649963379,13.2506341934205 48.7143363952639,13.2488212585449 48.7125816345215,13.2403154373169 48.7117309570312,13.232584953308 48.7130546569827,13.231876373291 48.7149810791018,13.2308654785157 48.7134323120117,13.2240715026855 48.7149848937989,13.2236595153809 48.7132110595703,13.2266616821289 48.7112197875977,13.213285446167 48.7100830078126,13.2108669281007 48.7025375366213,13.2014446258545 48.701560974121,13.2014303207397 48.6981163024905,13.1719484329225 48.7013854980469,13.1671438217164 48.6988105773926,13.158730506897 48.700080871582,13.1580648422242 48.7018356323244,13.1593952178956 48.7027931213378,13.1534729003907 48.7036361694337,13.1507396697999 48.7066078186035,13.148051261902 48.7066726684573,13.1454887390137 48.7053108215334,13.1476421356201 48.6996536254882,13.1520681381226 48.6993141174318,13.1503047943115 48.698123931885,13.1418457031251 48.7005577087402,13.1378679275513 48.6984024047854,13.140480041504 48.6977005004886,13.1415224075317 48.6953620910644,13.1376152038574 48.6932525634768,13.134129524231 48.6933784484864,13.1298952102662 48.6894760131837,13.1142482757568 48.6894035339358,13.1150865554811 48.6827507019044,13.1107397079469 48.6822891235351,13.1004962921143 48.6698760986329,13.0982637405396 48.669273376465,13.1020212173463 48.668411254883,13.0995302200317 48.6629714965821,13.1006278991699 48.6626739501955,13.1001119613647 48.658863067627,13.0970344543457 48.658718109131,13.0962810516357 48.655029296875,13.1007003784179 48.6538543701173,13.1001348495483 48.6519165039064,13.1031293869019 48.651279449463,13.1024198532105 48.6499366760257,13.105266571045 48.6437606811523,13.0972757339479 48.6423530578613,13.0964956283569 48.6371345520021,13.0916404724121 48.6359634399414,13.0915145874025 48.6346168518069,13.106372833252 48.633728027344,13.1062002182008 48.629222869873,13.1055402755737 48.6280593872071,13.1032056808473 48.6298332214358,13.0912504196166 48.6273612976076,13.0944585800171 48.6266746520997,13.0932779312135 48.6249008178711,13.0950241088867 48.6240425109863,13.0932779312135 48.6215820312501,13.0913200378418 48.6220321655273,13.0901250839234 48.6192092895508,13.0841999053955 48.6200752258301,13.0848093032837 48.6241455078127,13.0818967819213 48.6268157958986,13.0764284133911 48.6268424987796,13.0705785751343 48.6237564086914,13.0598011016846 48.6219444274902,13.0583744049073 48.6231956481934,13.0596151351929 48.6269187927248,13.0569992065431 48.6272468566896,13.0525884628297 48.6246681213381,13.0449190139772 48.6264724731445,13.0445756912231 48.6227645874025,13.0399723052979 48.6227188110352,13.0273265838624 48.6277465820312,13.023367881775 48.6212882995606,13.023328781128 48.6168632507326,13.0214519500734 48.617301940918,13.0183877944946 48.607906341553,13.0228404998779 48.6074256896972,13.0221710205078 48.6055068969729,13.0249357223511 48.6051902770996,13.0238122940065 48.6007919311525,13.0185327529907 48.5989036560059,13.018666267395 48.6006927490236,13.0049200057985 48.604835510254,13.0035085678101 48.6030960083011,12.9991321563721 48.6042785644531,12.9952745437623 48.601402282715,12.9975709915162 48.6001510620117,12.9970035552978 48.5991287231445,12.9942846298218 48.6006126403809,12.9942846298218 48.6006126403809,12.9863405227662 48.6017684936526,12.9890651702882 48.6061897277834,12.985149383545 48.6103477478027,12.976110458374 48.6092338562014,12.967381477356 48.6112670898438,12.967381477356 48.6112670898438,12.964840888977 48.6133651733399,12.9570713043213 48.6145439147949,12.9576148986816 48.6172409057618,12.9523735046388 48.6185264587404,12.9531993865968 48.6201019287111,12.945520401001 48.6228523254397,12.9464483261108 48.6251182556153,12.9442195892335 48.6296577453616,12.9466743469239 48.633399963379,12.9489841461182 48.6329078674317,12.9504823684694 48.6413688659669,12.9479913711548 48.6496200561525,12.9464302062989 48.649627685547,12.9448175430298 48.6529388427734,12.9371328353882 48.6532249450684,12.9360809326173 48.6493148803711,12.9331130981445 48.649974822998,12.9271364212036 48.6548385620117,12.9279613494874 48.6564025878906,12.9237251281739 48.6580619812014,12.9203138351442 48.656364440918,12.9183416366577 48.6527519226075,12.9099569320678 48.6550941467286,12.9057168960572 48.6542129516604,12.9043474197389 48.6569976806643,12.9059791564942 48.6603469848634,12.9036417007447 48.6619606018068,12.8978052139282 48.6628723144533,12.8876924514771 48.6604957580568,12.8800506591797 48.6630897521975,12.8738803863526 48.6677474975587,12.8644285202028 48.6663932800295,12.8668603897096 48.6627807617189,12.8643817901612 48.6609497070312,12.8601722717286 48.6634979248049,12.8579998016359 48.6615447998049,12.8543510437013 48.6616401672365,12.8562679290772 48.6644897460938,12.8545398712158 48.6745300292969,12.849425315857 48.676097869873,12.8464498519897 48.6820068359377,12.8423023223876 48.6810951232912,12.8433885574341 48.6790924072267,12.8410749435425 48.6784515380862,12.8404426574706 48.6799850463868,12.8300218582153 48.6774520874024,12.8285369873046 48.6790542602538,12.8303813934326 48.6804199218752,12.8246803283691 48.685920715332,12.825598716736 48.6869468688966,12.8236322402954 48.6893081665042,12.8238763809205 48.6921348571777,12.8224945068359 48.6919593811037,12.8212099075317 48.6957817077638,12.8118429183961 48.6998176574709,12.8010244369508 48.7121086120608,12.7947511672974 48.7157402038577,12.7989168167114 48.7184257507325,12.7952461242675 48.7210464477541,12.8045845031738 48.724117279053,12.8053274154664 48.722007751465,12.813943862915 48.7241859436037,12.8080825805665 48.7393684387208,12.8009901046753 48.7383918762208,12.7974309921265 48.7419662475589,12.7931051254273 48.7408103942871,12.7898902893068 48.7433090209962,12.7869548797607 48.7425117492677,12.7854709625244 48.7465400695801,12.7830944061279 48.7451744079592,12.7786827087402 48.7456893920901,12.7777996063232 48.7477416992189,12.7811307907104 48.7485694885253,12.7788791656495 48.7516136169435,12.7755403518677 48.7506217956544,12.7747411727905 48.7518692016604,12.7758302688599 48.7521629333499,12.7735080718994 48.7592544555666,12.7753334045411 48.7601509094239,12.7743892669678 48.7626647949221,12.7706422805787 48.764892578125,12.772141456604 48.7661094665528,12.7698669433594 48.7660865783694,12.769344329834 48.769760131836,12.7711753845216 48.7698936462405,12.7702131271363 48.7743644714357,12.773157119751 48.7735595703127,12.7737903594972 48.7780723571778,12.7780771255493 48.7780380249023,12.7779712677003 48.779857635498,12.7797794342041 48.7800979614261,12.777858734131 48.7821006774905,12.7755537033082 48.7820014953613,12.7746181488038 48.785583496094,12.7682428359986 48.7858047485353,12.7680568695068 48.7873573303223,12.7644596099855 48.7887687683107,12.7638139724731 48.7927322387695,12.7660799026489 48.794315338135,12.7622146606445 48.7940597534179,12.7640008926392 48.7979125976564))	0.0010	POINT(13.007169467752641 48.77794827547943)
1388254	POLYGON((-3.42978405952448 37.2759437561036,-3.43028998374939 37.2679901123047,-3.43664693832397 37.2535972595215,-3.43796896934504 37.2478523254395,-3.43634390830988 37.2459373474121,-3.44056510925293 37.2328872680664,-3.44382810592646 37.2301788330079,-3.44827508926386 37.2292594909669,-3.4516019821167 37.2219200134277,-3.4588840007782 37.2179985046387,-3.46733999252308 37.2167320251466,-3.47475790977472 37.2135543823243,-3.48198795318598 37.2020339965821,-3.4909679889679 37.2052230834961,-3.49632596969604 37.206211090088,-3.49777293205256 37.2051582336426,-3.50191688537598 37.2114524841309,-3.5098340511322 37.2171058654786,-3.50473403930664 37.2198295593262,-3.50149297714233 37.2238006591797,-3.49116802215576 37.225700378418,-3.48991894721985 37.2277984619141,-3.48058390617371 37.2327232360841,-3.48223400115961 37.24072265625,-3.47623300552357 37.243782043457,-3.47371888160706 37.247200012207,-3.4753210544585 37.2492294311525,-3.47410893440235 37.2501373291016,-3.46344304084778 37.2538452148437,-3.46306204795837 37.2617340087891,-3.45808911323547 37.2675895690919,-3.45288801193232 37.2672653198243,-3.44795608520508 37.2704849243164,-3.44119596481323 37.2718544006349,-3.44037795066828 37.270637512207,-3.43703198432917 37.2712173461914,-3.43604111671448 37.2734565734863,-3.42978405952448 37.2759437561036))	0.0006	POINT(-3.4655321868689986 37.239730938060895)
57256	POLYGON((7.08308172225952 50.4003410339355,7.08404397964472 50.398738861084,7.08850526809698 50.3976554870607,7.09193086624151 50.3951110839844,7.09475994110107 50.3947601318359,7.09475994110107 50.3947601318359,7.09969520568848 50.3943214416504,7.09969520568848 50.3943214416504,7.09503126144415 50.3910217285157,7.09743309021007 50.3909301757812,7.08953475952154 50.3871650695802,7.08905696868908 50.3859825134278,7.09308767318726 50.3855705261231,7.09153699874878 50.3848114013672,7.0916051864624 50.3834800720215,7.0916051864624 50.3834800720215,7.08956527709972 50.3828620910645,7.09079170227056 50.3818817138673,7.08420801162725 50.3778839111329,7.08420801162725 50.3778839111329,7.0738353729248 50.3781509399414,7.07198953628551 50.3810615539552,7.07037210464478 50.3814086914062,7.0717396736145 50.3829345703125,7.07024335861212 50.3833694458008,7.06637239456182 50.3813972473146,7.06249046325689 50.3845863342286,7.05836534500122 50.3822479248047,7.05337953567511 50.3841514587402,7.0513010025025 50.3840637207031,7.05157184600836 50.3868980407715,7.04870843887329 50.3863716125489,7.04733467102056 50.3876190185548,7.04854917526245 50.3898811340332,7.04661130905151 50.3899841308594,7.04483509063721 50.3880844116211,7.04483509063721 50.3880844116211,7.04416465759283 50.3893432617189,7.0459299087525 50.392162322998,7.04754686355597 50.3923988342286,7.04754686355597 50.3923988342286,7.05004501342779 50.3927268981934,7.05117273330688 50.3915710449219,7.05638980865479 50.3947792053224,7.05489397048962 50.3951950073243,7.0621385574342 50.3961334228516,7.06621122360241 50.3984413146973,7.0685915946961 50.3980712890626,7.07632970809948 50.4003677368165,7.08308172225952 50.4003410339355))	0.0006	POINT(7.070972072834912 50.38891523711539)
19456	MULTIPOLYGON(((10.6871862411499 46.2413482666016,10.6793479919434 46.2319908142091,10.6793479919434 46.2319908142091,10.6849994659424 46.2284317016603,10.7094707489014 46.2182312011719,10.7193622589112 46.2159690856935,10.7441072463989 46.2133750915527,10.7473554611206 46.2111549377442,10.7549257278444 46.212242126465,10.7549257278444 46.212242126465,10.7532253265381 46.2187576293945,10.7544050216675 46.222354888916,10.7343664169312 46.2383575439454,10.7343664169312 46.2383575439454,10.7227573394776 46.2415084838867,10.7055549621581 46.2416687011719,10.7007303237915 46.239860534668,10.6915636062623 46.2402305603027,10.6871862411499 46.2413482666016)),((10.7368860244752 46.163459777832,10.7429704666137 46.1693038940431,10.7472763061523 46.1703529357911,10.7507019042969 46.1689605712892,10.7527751922607 46.1633071899414,10.7560415267944 46.1594467163085,10.770359992981 46.1744613647462,10.7748775482178 46.1857948303223,10.7631044387818 46.1979141235353,10.7569589614869 46.2004241943361,10.7569589614869 46.2004241943361,10.7439546585083 46.1966209411622,10.7329177856445 46.1958847045898,10.7156562805175 46.1991767883302,10.7115125656128 46.1990242004394,10.7109804153442 46.1979179382324,10.713134765625 46.1943473815919,10.72309589386 46.1891555786134,10.7237043380737 46.1845970153809,10.7205934524537 46.1811485290527,10.7172231674195 46.1736755371094,10.7207822799682 46.1694412231446,10.7207822799682 46.1694412231446,10.730658531189 46.1720123291017,10.7361717224122 46.171974182129,10.7368860244752 46.163459777832)))	0.0006	POINT(10.728866662711427 46.20395353931053)
67328	POLYGON((9.41572856903088 49.3590812683107,9.41510391235352 49.3584442138671,9.41830730438232 49.3560180664062,9.4165506362915 49.3544311523439,9.41759681701666 49.3477249145509,9.41569900512701 49.3433723449708,9.41282367706299 49.3468894958497,9.40979003906244 49.3452949523926,9.40314006805431 49.3440437316894,9.39697647094727 49.3408241271973,9.39708328247082 49.337989807129,9.40040016174322 49.3349914550781,9.392641067505 49.3305892944337,9.39821243286144 49.3259735107423,9.3968830108642 49.3249015808106,9.39424419403076 49.3189735412598,9.39745330810547 49.3152427673339,9.39600658416748 49.3126983642578,9.39680767059332 49.3121757507325,9.39469718933105 49.310962677002,9.38871192932129 49.3100128173828,9.38832473754894 49.308937072754,9.39060974121099 49.3064842224121,9.38982009887707 49.3013496398926,9.39366245269775 49.2988128662109,9.39366245269775 49.2988128662109,9.38147926330566 49.2974090576171,9.37847042083752 49.2895774841309,9.37294769287121 49.2892990112305,9.3642721176148 49.2827873229982,9.35824489593517 49.2812232971192,9.35766792297369 49.2805976867676,9.36055850982677 49.278736114502,9.35827922821051 49.2774353027344,9.35827922821051 49.2774353027344,9.35670566558844 49.2800369262696,9.34919834136963 49.2788467407227,9.34621715545654 49.2821693420411,9.33385848999023 49.2819976806641,9.33367252349865 49.2828598022462,9.32922744750977 49.2818870544434,9.32115554809582 49.2852478027344,9.32324314117432 49.2898330688477,9.32048797607433 49.2905960083008,9.31569004058844 49.2949447631836,9.31518745422375 49.2963790893555,9.31809520721447 49.2967147827148,9.31686401367199 49.2981414794923,9.31920146942144 49.300952911377,9.31542491912853 49.3029479980468,9.31500244140619 49.3044433593751,9.31935501098633 49.3081436157227,9.31746006011974 49.3141403198243,9.32489585876465 49.3139419555665,9.32867145538324 49.3159866333008,9.32760238647467 49.3231468200684,9.32106876373297 49.3224296569825,9.32050704956055 49.3285140991211,9.31468486785883 49.3279151916504,9.31325721740728 49.3260993957521,9.30624198913574 49.3248023986816,9.29898452758795 49.326057434082,9.28746318817139 49.3299255371094,9.28746318817139 49.3299255371094,9.28885746002209 49.3352127075195,9.29338169097906 49.3418655395508,9.29297065734863 49.3443183898926,9.29467487335216 49.3475379943848,9.3153285980224 49.3570785522462,9.3153285980224 49.3570785522462,9.31831169128424 49.3528289794922,9.32000923156733 49.3454246520996,9.32132530212408 49.3456535339356,9.32126617431652 49.3441123962402,9.33254909515381 49.3472976684571,9.34357070922852 49.3465042114258,9.35365486145025 49.3439712524414,9.35304546356201 49.3470420837403,9.35614681243908 49.3526878356934,9.37462425231945 49.3575706481935,9.37544059753418 49.3632621765138,9.37544059753418 49.3632621765138,9.38681316375732 49.3658790588379,9.39548301696777 49.3654518127441,9.3988819122315 49.3664360046387,9.40576076507563 49.3649826049805,9.40488433837891 49.3641738891601,9.41572856903088 49.3590812683107))	0.0006	POINT(9.35581348682276 49.32250796789412)
38452	POLYGON((0.538906753063316 49.8106155395508,0.539911150932369 49.8012962341309,0.545765101909694 49.7962265014648,0.545765101909694 49.7962265014648,0.551703214645443 49.780101776123,0.551703214645443 49.780101776123,0.532284438610077 49.7792091369629,0.532284438610077 49.7792091369629,0.527433514595089 49.7845039367676,0.51717072725296 49.7842864990235,0.51717072725296 49.7842864990235,0.515570402145329 49.7960739135743,0.511596202850342 49.7975578308107,0.511596202850342 49.7975578308107,0.512121677398682 49.8201370239258,0.512121677398682 49.8201370239258,0.516250014305172 49.8229179382325,0.522638022899571 49.8246154785156,0.522638022899571 49.8246154785156,0.524244189262333 49.8254089355469,0.528547525405941 49.8165893554687,0.538906753063316 49.8106155395508))	0.0006	POINT(0.5274963009925279 49.801032111758296)
35921	POLYGON((6.60597085952764 47.1900901794434,6.61049652099615 47.1844406127931,6.60067701339727 47.1700592041016,6.60067701339727 47.1700592041016,6.60967683792114 47.1661186218262,6.60967683792114 47.1661186218262,6.6222186088562 47.1755599975587,6.6344952583313 47.1710281372071,6.63871669769293 47.1724739074708,6.63871669769293 47.1724739074708,6.63896465301519 47.1892356872559,6.63562107086182 47.1917915344238,6.60597085952764 47.1900901794434))	0.0006	POINT(6.620492339134248 47.176620801289936)
1409520	POLYGON((-4.53937911987305 43.3439178466797,-4.59924983978271 43.3508644104004,-4.62640094757074 43.3506278991699,-4.61989688873291 43.3625946044922,-4.62283897399902 43.3651275634767,-4.62270879745478 43.3685340881348,-4.61573886871332 43.3673362731935,-4.61517000198364 43.3705177307129,-4.61789321899408 43.3712692260743,-4.61825609207153 43.3728752136232,-4.61025810241699 43.3747444152833,-4.60595321655273 43.3725242614746,-4.6014609336853 43.3748855590821,-4.60081577301025 43.3729133605957,-4.59735584259033 43.3727569580079,-4.59355688095093 43.3756828308106,-4.59471416473377 43.3774833679199,-4.59289598464966 43.3805694580079,-4.5891809463501 43.3820343017579,-4.58935785293573 43.3892707824708,-4.58088493347168 43.3910751342775,-4.57654476165771 43.3962516784669,-4.57430505752563 43.3943061828613,-4.57013797760004 43.3951377868653,-4.5681939125061 43.3931961059571,-4.56152820587158 43.3940277099609,-4.55819606781006 43.3929176330568,-4.55680513381958 43.3937492370605,-4.55764007568348 43.3976402282716,-4.55652713775635 43.3984718322754,-4.55013895034784 43.3968048095704,-4.54708290100092 43.3998603820801,-4.53460216522211 43.4004173278809,-4.53125 43.3993072509767,-4.53013992309565 43.3979148864746,-4.52347278594971 43.3976402282716,-4.51221418380732 43.3931961059571,-4.51300287246704 43.3895797729493,-4.51051902770996 43.3805694580079,-4.5212578773498 43.3716430664064,-4.52288293838495 43.3685569763184,-4.52083587646484 43.3661079406739,-4.53436708450312 43.3682975769044,-4.53527688980097 43.3646621704102,-4.53073215484619 43.3587455749513,-4.53510618209833 43.3584632873535,-4.5387458801269 43.3554420471192,-4.53427410125732 43.3533515930176,-4.53418302536011 43.3511657714844,-4.53736686706537 43.3467903137207,-4.53671312332153 43.3443222045899,-4.53937911987305 43.3439178466797))	0.0006	POINT(-4.566039421979093 43.37659102795176)
33795	POLYGON((3.48496580123913 48.4121551513673,3.47768974304211 48.3832778930664,3.47768974304211 48.3832778930664,3.48256969451916 48.3822593688965,3.51630306243896 48.389991760254,3.52905130386358 48.3856163024902,3.54941892623913 48.3958511352539,3.55220270156866 48.402370452881,3.55220270156866 48.402370452881,3.55247712135315 48.4091796875,3.54203391075146 48.4212226867677,3.52197384834295 48.4183082580567,3.51267242431641 48.4263343811036,3.51267242431641 48.4263343811036,3.50831675529486 48.424617767334,3.50959181785595 48.4083557128907,3.48496580123913 48.4121551513673))	0.0006	POINT(3.5176144987345426 48.404470205307064)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point