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
60556	POLYGON((9.30036640167242 47.4330787658691,9.30162620544434 47.4352111816407,9.3062601089477 47.4370307922364,9.30648708343512 47.4386444091798,9.30416488647467 47.4398384094239,9.30317115783703 47.4433364868164,9.29289340972895 47.4484214782715,9.29131221771252 47.4498672485352,9.2903985977174 47.4527969360353,9.28600788116455 47.4561424255372,9.28087520599365 47.4563865661621,9.27744007110601 47.4522476196288,9.27367782592785 47.4499244689941,9.26437377929693 47.4517631530761,9.26437377929693 47.4517631530761,9.262848854065 47.4495544433595,9.26327323913569 47.4474258422853,9.26213264465338 47.4448699951172,9.26499271392828 47.4408493041992,9.2642183303833 47.4372978210449,9.27194976806641 47.4342193603516,9.27679061889648 47.4304542541504,9.28501987457281 47.4312591552734,9.28914928436279 47.4285163879395,9.29216575622564 47.4308624267579,9.29521369934076 47.4304885864259,9.29854679107672 47.4317245483399,9.29854679107672 47.4317245483399,9.30036640167242 47.4330787658691))	0.0006	POINT(9.28458132062643 47.44163213457382)
180918	POLYGON((0.741884768009129 44.0652008056642,0.750387728214264 44.0655364990236,0.753346979618186 44.0563697814941,0.758697152137756 44.0511283874515,0.756565213203373 44.0412368774416,0.764047920703945 44.029640197754,0.822057127952689 44.0555953979495,0.836679518222866 44.0469818115235,0.850633859634513 44.0476799011233,0.853537142276878 44.042190551758,0.864664435386771 44.0387001037599,0.857867896556854 44.0349006652835,0.849297761917228 44.0344734191897,0.840035915374756 44.0243148803714,0.828458666801566 44.0288391113284,0.819879472255707 44.0276947021487,0.81455105543148 44.0228157043459,0.822487592697257 44.0146369934084,0.817423522472438 44.0090713500979,0.825148642063198 44.0044097900393,0.826871812343597 43.9974937438965,0.804556548595485 43.9768447875978,0.800900101661796 43.9772567749023,0.791497766971588 43.9695777893066,0.792216300964412 43.9661521911621,0.78377765417099 43.9549140930178,0.760114133358115 43.9453048706057,0.760549128055629 43.9386672973634,0.770003974437714 43.9221420288086,0.809297919273433 43.9323005676272,0.81994271278387 43.9249801635742,0.840336859226284 43.9160041809084,0.849346697330475 43.9171791076661,0.852140426635799 43.9226989746093,0.856064736843052 43.9210205078127,0.864677667617855 43.9231796264651,0.875289261341095 43.9128265380859,0.88819748163229 43.9096183776857,0.889230489730949 43.9042472839358,0.90465384721756 43.8989257812502,0.885672032833043 43.8914031982423,0.882866084575653 43.8858299255373,0.886032879352683 43.8722457885744,0.904105901718253 43.860954284668,0.912698388099727 43.848487854004,0.895379722118378 43.8492546081545,0.895239293575287 43.8398971557618,0.925163149833793 43.8320274353029,0.914785206318015 43.8185768127442,0.905987083911953 43.8106575012207,0.897291123867092 43.7885360717774,0.904057025909424 43.7842979431153,0.917444229125977 43.7858619689941,0.923683822155112 43.7909393310549,0.942079126834983 43.7918663024903,0.953983128070888 43.7873725891113,0.953983128070888 43.7873725891113,0.95909887552267 43.7718048095704,0.969891250133571 43.7613754272463,0.966055691242275 43.7595672607423,0.974622428417206 43.7592964172366,0.992189943790436 43.7438926696777,0.985922276973781 43.7438240051271,1.02341938018805 43.7218742370606,1.02047073841089 43.719207763672,1.02738797664642 43.7104339599611,1.04072976112366 43.7121772766116,1.06570315361023 43.7002296447756,1.05990552902222 43.6955795288086,1.05890512466442 43.6892242431642,1.05222594738012 43.6850204467775,1.05133903026581 43.6786384582521,1.04902243614197 43.6760139465334,1.05683445930492 43.6738433837891,1.05801486969 43.6708488464355,1.06251776218426 43.6711616516114,1.07482600212103 43.6617126464845,1.09345817565924 43.6643829345704,1.10138344764709 43.6605606079102,1.09056234359747 43.6504516601563,1.09018838405609 43.6441917419434,1.11545729637157 43.636730194092,1.11487364768982 43.6397781372071,1.1234176158905 43.63924407959,1.13058114051819 43.642650604248,1.13850307464611 43.6418151855471,1.14671063423168 43.635581970215,1.14260029792797 43.6213111877444,1.15865409374248 43.6051750183108,1.17141819000238 43.6068954467773,1.18090021610271 43.6141014099122,1.18843924999248 43.6056251525881,1.20030069351196 43.5958747863769,1.19934272766113 43.5691833496094,1.1867705583573 43.5726013183596,1.17362117767345 43.570770263672,1.1612087488175 43.574546813965,1.16391563415527 43.5719642639161,1.15643024444591 43.556827545166,1.12524700164806 43.5544929504395,1.11216735839849 43.5567398071289,1.11826348304749 43.5455627441407,1.10567903518682 43.5369720458986,1.09708154201519 43.5332298278809,1.0914422273637 43.542491912842,1.08417057991028 43.5464782714846,1.07488083839411 43.5464019775392,1.05961644649506 43.5393257141116,1.05055177211767 43.5410346984866,1.06739473342907 43.5346488952636,1.07641196250927 43.5269165039062,1.06828510761267 43.5236244201662,1.05516922473919 43.524883270264,1.05290603637695 43.5183105468753,1.07288718223572 43.5044174194335,1.05930840969097 43.5041427612305,1.05138516426092 43.4891319274905,1.0337508916856 43.4868240356448,1.03748977184307 43.4855613708497,1.02214729785914 43.4791984558105,1.01753282547008 43.4735946655276,1.04420793056499 43.4584846496583,1.03735184669495 43.4552116394045,1.03907501697535 43.4524955749512,1.03499138355266 43.4534301757814,1.03227162361151 43.4412155151368,1.02216529846197 43.4359283447267,1.01891350746155 43.4306564331055,1.02859902381903 43.4204406738282,1.02278780937195 43.41170501709,1.00430834293365 43.4138412475588,0.993933141231594 43.4072685241701,1.00160706043249 43.3910217285159,0.998925507068634 43.3843841552736,1.00503730773931 43.3799896240235,1.00287568569195 43.3768615722656,0.995370924472866 43.3744926452637,0.993662059307042 43.3665313720703,0.980536639690456 43.3630485534668,0.966509282588959 43.3711814880371,0.968799591064453 43.3775978088379,0.963531553745383 43.3866691589357,0.946900188922996 43.3852272033692,0.944291293621063 43.3808860778811,0.927284777164459 43.3950691223146,0.925468921661377 43.4009361267089,0.917391002178192 43.4031486511231,0.917251110076904 43.4063339233401,0.904704928398246 43.407829284668,0.902230024337712 43.4052848815921,0.885638892650718 43.4100303649903,0.871438741684017 43.4114723205568,0.864437758922634 43.4158325195313,0.861395120620841 43.4133262634278,0.857068598270473 43.4144744873049,0.844401001930237 43.4098854064943,0.820541322231406 43.4169845581055,0.813957750797272 43.4125137329103,0.80729699134838 43.3997230529786,0.770421624183768 43.4168090820314,0.751999378204403 43.4171562194824,0.75702041387558 43.40775680542,0.747292459011192 43.3960990905762,0.751650214195251 43.3900680541994,0.744298636913356 43.3817901611328,0.731535673141479 43.3721885681152,0.71534276008606 43.3788871765139,0.675321161747036 43.3323059082032,0.674718856811523 43.3295135498046,0.65625 43.3174133300782,0.644252777099723 43.3123931884766,0.611653387546596 43.3156738281252,0.606810986995811 43.3108863830569,0.606810986995811 43.3108863830569,0.579670488834381 43.3211975097659,0.571099102497158 43.3198356628421,0.54706913232809 43.3298072814941,0.539687514305115 43.3271255493166,0.514701068401337 43.3333435058594,0.505965948104915 43.3331871032718,0.497721403837204 43.3259925842285,0.493539661169109 43.3254814147951,0.479815751314163 43.332588195801,0.472977310419196 43.3324813842774,0.444980084896201 43.3407363891604,0.442971318960247 43.3279266357423,0.418737828731651 43.328079223633,0.395822793245316 43.3342437744143,0.393631309270916 43.3374404907227,0.398671567440147 43.3514404296874,0.378548383712825 43.3553657531738,0.36387553811079 43.3495712280275,0.34615579247486 43.3481407165529,0.339845210313854 43.3437728881839,0.331350296735764 43.342655181885,0.325406849384422 43.3747749328616,0.312128901481628 43.3671188354494,0.300993472337723 43.3714714050295,0.298759490251655 43.3885803222657,0.271196514368057 43.3826217651369,0.231704190373421 43.3677139282227,0.223359867930469 43.3698310852052,0.206344842910767 43.3677787780763,0.198075875640029 43.3749198913575,0.182031214237327 43.3711814880371,0.176024243235645 43.3804435729983,0.180075094103927 43.3791236877442,0.173804938793239 43.4027709960938,0.15695665776741 43.3989295959475,0.148338928818646 43.4051666259766,0.1444381326437 43.4151000976564,0.134548753500042 43.4224891662597,0.137459442019576 43.4339904785159,0.166064128279743 43.4423789978027,0.148125097155514 43.4655380249025,0.144530102610645 43.4637603759768,0.136513367295208 43.4659004211426,0.13074146211153 43.4740638732912,0.127279192209301 43.4906539916995,0.129964828491211 43.4930839538574,0.127468124032021 43.4989967346191,0.112247779965514 43.5173721313478,0.0918862894178574 43.5102462768555,0.0819998234510422 43.5173645019532,0.0805762633680729 43.523952484131,0.0677421838045689 43.5194129943849,0.0536214411259266 43.5187683105469,0.0398568399250507 43.5369033813477,0.0300545729697888 43.5445671081542,0.0157821346074343 43.5433921813968,0.00946008227776929 43.5578308105469,-0.00166577007621527 43.5653228759766,-0.00658623594785013 43.5928268432619,-0.0150087103247074 43.605525970459,-0.0335159115493298 43.6047210693361,-0.0338846370577812 43.6074752807617,-0.0381077304481323 43.6062583923342,-0.0441594049333958 43.6110153198243,-0.0441594049333958 43.6110153198243,-0.0561003088951111 43.6064910888674,-0.0742125958203133 43.6061782836916,-0.0755890384316444 43.5927963256838,-0.0975088551640511 43.5894279479982,-0.0967829748988152 43.5824050903321,-0.0967829748988152 43.5824050903321,-0.12221571803093 43.5854148864748,-0.128911778330689 43.5812225341798,-0.13841958343977 43.5811309814455,-0.150982037186623 43.5854568481446,-0.15782243013382 43.5814476013186,-0.162107899785042 43.5816650390624,-0.176560878753605 43.5968322753909,-0.176560878753605 43.5968322753909,-0.205010920762959 43.5839996337891,-0.210606768727246 43.5932388305665,-0.228803426027298 43.5896453857425,-0.238911703228894 43.5830383300783,-0.242837071418762 43.5849838256838,-0.242837071418762 43.5849838256838,-0.249482125043812 43.596664428711,-0.254007279872894 43.5967102050782,-0.24720419943327 43.6159591674808,-0.274354100227299 43.6160430908203,-0.281512916088047 43.6237449645998,-0.282111585140228 43.643077850342,-0.266967505216542 43.6369438171387,-0.263361573219299 43.6387252807619,-0.261803299188614 43.6479492187502,-0.259197652339935 43.6531600952151,-0.246275529265404 43.6549453735353,-0.239730194211006 43.671241760254,-0.253921031951904 43.6729431152344,-0.256714046001434 43.6758041381837,-0.254545480012894 43.6826248168945,-0.241215929389 43.6926765441897,-0.247380658984184 43.7092437744142,-0.222235918044987 43.7188720703127,-0.194143295288029 43.737018585205,-0.196676880121174 43.7467956542972,-0.218864366412163 43.7503280639648,-0.213933557271957 43.7556610107422,-0.209199026226997 43.7563133239748,-0.207783877849579 43.7596626281739,-0.2156824767589 43.7724075317383,-0.214827731251717 43.7826271057131,-0.222127765417042 43.7870941162109,-0.218646913766861 43.7965888977051,-0.226956263184547 43.8076667785647,-0.216000452637672 43.8125381469729,-0.212633237242642 43.8092765808108,-0.194708436727467 43.809211730957,-0.196344271302223 43.8291206359864,-0.189844444394112 43.8336982727052,-0.193419978022575 43.8400154113769,-0.208908215165081 43.8576698303223,-0.195623129606247 43.8682746887209,-0.188914731144905 43.8654098510743,-0.185723334550858 43.8668899536135,-0.193995684385243 43.8816871643069,-0.201230615377426 43.8854675292972,-0.209406912326813 43.885368347168,-0.223553866147995 43.8924293518069,-0.232168093323651 43.8910293579101,-0.240257903933525 43.89794921875,-0.232803344726506 43.9015846252444,-0.227948307991028 43.910888671875,-0.22358413040638 43.9119262695315,-0.216888591647148 43.9076385498047,-0.200575128197613 43.9146385192871,-0.177077353000641 43.9356803894044,-0.166098311543408 43.92919921875,-0.157376185059491 43.9314804077148,-0.148757606744653 43.9392585754395,-0.135133340954781 43.9362983703616,-0.125395178794861 43.9435043334961,-0.102561041712704 43.9272766113281,-0.0955101326107979 43.9307670593265,-0.0985684767364887 43.9425582885744,-0.0924671366810799 43.9479637145996,-0.0798961967229275 43.9434814453124,-0.0753200873732567 43.9446105957032,-0.0613407194613842 43.9584312438968,-0.0441898331045536 43.9636688232425,-0.0361689254640964 43.9837417602539,0.00559954950591646 43.9555854797364,0.00547521049162469 43.9451370239258,-0.0203855205327272 43.9292945861816,0.0159415286035482 43.9123420715334,0.0331778787077042 43.8999786376954,0.0413024425507729 43.9035072326661,0.058618139475584 43.898380279541,0.0690832883120152 43.9053459167483,0.0750816687942688 43.914680480957,0.0699471682310673 43.9353370666507,0.0554246678948971 43.9571380615235,0.0674302950502579 43.9673233032226,0.0675357058643726 43.9742431640625,0.0760456100107376 43.9831428527834,0.0760456100107376 43.9831428527834,0.107387967407817 43.9853820800782,0.127415299415702 43.9985809326175,0.126847431063709 44.0019264221193,0.140999749302978 43.9936408996584,0.138624876737708 43.9765968322754,0.152050659060592 43.9732093811035,0.161034524440709 43.9743499755862,0.165308684110641 43.9804344177248,0.166041240096149 43.9942932128909,0.180956915021 44.0026931762698,0.189806640148277 44.0150070190429,0.193465650081748 44.0136871337891,0.201762139797211 44.0142326354983,0.214733630418777 44.0227851867676,0.225965231657142 44.0197296142579,0.232774898409957 44.0223884582521,0.232994541525898 44.0093917846682,0.25063577294344 44.0042610168459,0.268923133611736 44.0040626525879,0.273552358150539 43.9980545043945,0.282437652349586 43.9979858398439,0.303003638982773 43.9912376403811,0.305492788553295 43.9939918518066,0.318025529384556 43.9972457885745,0.31547999382019 44.0099716186524,0.32474011182785 44.0078010559083,0.357013463973999 44.0154113769531,0.372811108827591 44.0083732604982,0.382336765527782 44.008239746094,0.393874317407722 44.0194931030276,0.398032426834106 44.0213470458986,0.407709538936672 44.0220451354983,0.418932557106075 44.0282897949219,0.442449927330074 44.0287628173828,0.45067688822752 44.0457191467287,0.459759086370582 44.0553779602052,0.481846272945404 44.0534286499026,0.485696971416587 44.0586891174319,0.501613438129539 44.056510925293,0.50471663475048 44.0506668090821,0.5115802884103 44.0627365112306,0.538427472114563 44.0529518127444,0.566978871822471 44.0606155395508,0.576570630073604 44.0749473571778,0.592675149440765 44.0792617797854,0.601221859455109 44.078010559082,0.599314868450165 44.074951171875,0.625904023647422 44.0618286132815,0.631648659706173 44.0495071411136,0.652207732200736 44.0429077148438,0.654464900493736 44.0329627990723,0.662558913230953 44.0245933532716,0.67958569526678 44.0293464660645,0.682755291461888 44.0422363281251,0.694546639919338 44.0451240539553,0.707922756671906 44.0582885742189,0.717152535915375 44.0576019287109,0.741884768009129 44.0652008056642))	0.0010	POINT(0.4696367575782748 43.70282774260553)
69312	POLYGON((10.268274307251 53.5089721679689,10.2689199447632 53.5094032287598,10.2684125900269 53.5112800598145,10.2707710266114 53.5130462646484,10.2693910598755 53.5144538879396,10.2724599838256 53.5186920166016,10.270079612732 53.5211334228516,10.2712907791138 53.5232276916505,10.2732343673707 53.5234489440918,10.2736444473268 53.5257568359376,10.2789001464844 53.5272674560547,10.2862854003906 53.5251426696777,10.2885208129882 53.5243301391602,10.2873048782348 53.5232124328614,10.2908277511598 53.5212516784669,10.2911205291749 53.5199394226075,10.2975988388063 53.5210113525392,10.299524307251 53.5221633911134,10.3005075454713 53.5246353149415,10.3005075454713 53.5246353149415,10.3048276901245 53.5245933532715,10.3033084869385 53.5217399597168,10.312581062317 53.5189323425294,10.3080883026124 53.5120506286621,10.3109703063965 53.5113182067872,10.3109703063965 53.5113182067872,10.3048677444458 53.5073814392091,10.3005342483521 53.5022087097169,10.2957429885864 53.5018768310547,10.2950096130372 53.5008697509766,10.2931671142579 53.5016555786133,10.2832183837891 53.498878479004,10.2832183837891 53.498878479004,10.2709131240845 53.505931854248,10.2711915969849 53.5075492858888,10.268274307251 53.5089721679689))	0.0006	POINT(10.287891006469772 53.51509105137421)
1399382	POLYGON((-3.81071209907532 41.6715126037599,-3.80858993530268 41.6680793762208,-3.82668399810791 41.667350769043,-3.86008691787708 41.6708641052247,-3.86972999572754 41.6705932617188,-3.87507510185242 41.6767120361329,-3.88370203971863 41.6750717163085,-3.88282394409168 41.6785011291504,-3.8864820003509 41.6789512634278,-3.88992810249323 41.6814537048341,-3.89749503135681 41.6932487487794,-3.88978695869446 41.7077178955078,-3.88420510292048 41.7022132873536,-3.87575602531433 41.6985931396484,-3.87348389625538 41.7002792358398,-3.86969399452204 41.7000122070314,-3.86650109291077 41.6976928710938,-3.86084008216852 41.7019577026368,-3.85869288444519 41.7004699707031,-3.8567869663238 41.6955757141113,-3.84514999389637 41.6870346069337,-3.83211803436279 41.6853713989257,-3.82351398468012 41.6816864013672,-3.81713700294495 41.6752777099609,-3.81071209907532 41.6715126037599))	0.0006	POINT(-3.860207299391391 41.686092535654744)
50986	POLYGON((1.93554639816296 49.9984741210938,1.93534004688274 49.9990119934083,1.93534004688274 49.9990119934083,1.93510031700146 50.0024757385254,1.93510031700146 50.0024757385254,1.92767012119299 50.0105056762696,1.92733430862427 50.0171775817871,1.90905582904816 50.0224761962891,1.90905582904816 50.0224761962891,1.91109073162079 50.0322761535645,1.91901910305023 50.0404510498047,1.91901910305023 50.0404510498047,1.92036402225506 50.0493621826172,1.92948317527777 50.0469017028808,1.92948317527777 50.0469017028808,1.94170761108398 50.0419578552246,1.9657216072082 50.0393981933594,1.9657216072082 50.0393981933594,1.95963394641888 50.0342788696289,1.9740270376206 50.0210723876953,1.9740270376206 50.0210723876953,1.95096981525421 50.0020217895508,1.93554639816296 49.9984741210938))	0.0006	POINT(1.9368095993996122 50.02407403425739)
39782	POLYGON((4.13241958618175 43.7087898254394,4.12497711181641 43.7132759094239,4.12724256515514 43.7306594848633,4.12724256515514 43.7306594848633,4.1135334968568 43.7289924621583,4.10219573974621 43.7234382629396,4.10219573974621 43.7234382629396,4.11074113845825 43.7021026611329,4.11074113845825 43.7021026611329,4.10855817794811 43.6995697021484,4.10855817794811 43.6995697021484,4.11725807189947 43.6972770690919,4.12572717666632 43.700309753418,4.13241958618175 43.7087898254394))	0.0006	POINT(4.116260822002783 43.712321941669224)
58608	POLYGON((6.47510814666754 51.4876441955567,6.47350311279297 51.4891586303711,6.47359895706188 51.4952964782716,6.46858406066895 51.4976654052735,6.46253061294561 51.505714416504,6.45532417297375 51.5079040527344,6.45436763763428 51.5089263916017,6.45571279525763 51.5149574279786,6.45270538330078 51.5179443359374,6.4485702514649 51.519630432129,6.45169925689709 51.5214843750001,6.45330905914307 51.5240287780762,6.45254898071283 51.52543258667,6.44978666305542 51.5267791748047,6.44834995269775 51.5293006896972,6.45529794692999 51.5296363830568,6.45788764953613 51.5273017883301,6.46110963821411 51.5271263122559,6.46235132217407 51.5245094299318,6.46448659896856 51.524700164795,6.46902322769171 51.5222244262696,6.46956300735479 51.5205230712891,6.47459983825684 51.5208930969239,6.477198123932 51.5197563171386,6.48039293289196 51.5216941833496,6.47398328781134 51.5272483825684,6.47743320465099 51.527774810791,6.47854042053228 51.5296401977539,6.47747516632086 51.5300903320313,6.48128843307495 51.5320663452148,6.48711967468256 51.5383949279786,6.46433925628668 51.5511398315429,6.49874687194836 51.5670623779297,6.49874687194836 51.5670623779297,6.50173854827887 51.5646934509278,6.50793361663813 51.5636940002441,6.51168489456182 51.565227508545,6.51536798477167 51.5644340515137,6.51990461349487 51.559642791748,6.51959705352789 51.5565032958984,6.52089691162121 51.554744720459,6.52657556533825 51.5563888549805,6.53341388702404 51.5547256469728,6.53341388702404 51.5547256469728,6.54366397857666 51.5558280944824,6.54667043685913 51.5544891357422,6.54576206207275 51.5496101379395,6.54197788238525 51.5485839843751,6.54336833953857 51.5453681945801,6.54069471359253 51.5445404052735,6.54186248779308 51.5427322387696,6.53916406631481 51.5416870117188,6.53845834732061 51.5396537780762,6.54090881347668 51.53470993042,6.54761695861822 51.530128479004,6.54827260971075 51.528377532959,6.56192064285278 51.5307197570801,6.56836509704601 51.5338363647461,6.58100843429571 51.5360870361328,6.58221101760864 51.535026550293,6.58026838302618 51.532917022705,6.58181428909302 51.5313911437988,6.58544111251842 51.5313758850099,6.58765268325811 51.5279731750488,6.58667707443237 51.527717590332,6.5877628326416 51.5256690979003,6.58922338485729 51.5258178710938,6.58909702301025 51.5246505737305,6.58784008026129 51.5242576599122,6.58955430984497 51.5222778320314,6.58955430984497 51.5222778320314,6.59022998809826 51.5204544067383,6.58785820007324 51.5196456909181,6.58611679077148 51.5123100280763,6.58350944519043 51.5090255737305,6.58637332916254 51.5042266845703,6.58260202407831 51.5034255981446,6.58292007446295 51.500545501709,6.57829332351685 51.5001296997071,6.57150888443005 51.4969291687012,6.57139492034923 51.4947204589844,6.57044506072998 51.494686126709,6.57013511657715 51.4895515441895,6.57404184341431 51.4847068786621,6.57583093643183 51.4845428466798,6.57894515991217 51.4808197021484,6.57847452163702 51.4802856445313,6.57847452163702 51.4802856445313,6.57133674621576 51.4797325134277,6.56430816650396 51.4735336303711,6.55455636978144 51.4723510742189,6.55041980743403 51.4726562500001,6.54428768157965 51.4773712158203,6.53649425506592 51.4797019958496,6.53303861618048 51.4784469604493,6.53106355667114 51.4789314270021,6.52831888198858 51.4761352539064,6.51834917068493 51.4777984619141,6.51306343078619 51.4813423156739,6.50453138351446 51.4797286987305,6.49760913848877 51.4757156372071,6.49760913848877 51.4757156372071,6.49769544601452 51.4767112731934,6.48784589767456 51.4783020019531,6.48592948913586 51.4805793762208,6.48298835754406 51.4797325134277,6.47880744934093 51.4814987182618,6.47625255584722 51.4844665527344,6.47510814666754 51.4876441955567))	0.0006	POINT(6.523558153046543 51.51703647330956)
56598	POLYGON((4.62285280227667 46.2464828491211,4.63025522232056 46.2483139038087,4.63025522232056 46.2483139038087,4.65324211120605 46.2348251342773,4.65324211120605 46.2348251342773,4.65885734558111 46.2226562500001,4.6748452186585 46.2171630859376,4.6748452186585 46.2171630859376,4.66579389572144 46.2096672058107,4.66618251800548 46.1964111328126,4.66618251800548 46.1964111328126,4.65723276138311 46.1976852416993,4.64491319656383 46.1930198669434,4.62662696838379 46.1943359375001,4.62662696838379 46.1943359375001,4.60857629776012 46.2108039855958,4.60973882675177 46.2212257385254,4.60973882675177 46.2212257385254,4.61347103118902 46.230323791504,4.62326335906988 46.2366790771486,4.62285280227667 46.2464828491211))	0.0006	POINT(4.6408371210098744 46.21859340667732)
50263	POLYGON((2.06618380546581 49.6380577087403,2.07643914222729 49.6341209411622,2.07643914222729 49.6341209411622,2.09011387825012 49.6377639770508,2.09792137146007 49.6297149658203,2.09792137146007 49.6297149658203,2.11458420753473 49.6374244689941,2.12178659439093 49.633773803711,2.12178659439093 49.633773803711,2.1259508132934 49.6354217529297,2.12905859947205 49.6446990966798,2.1337201595307 49.6456565856934,2.1337201595307 49.6456565856934,2.13499355316162 49.6587677001954,2.1110396385194 49.6654891967775,2.1110396385194 49.6654891967775,2.09727621078497 49.664794921875,2.08234906196594 49.6711349487305,2.08234906196594 49.6711349487305,2.0783030986787 49.6612815856934,2.0783030986787 49.6612815856934,2.0884513854981 49.6604499816896,2.09513854980469 49.6557006835938,2.08439040184032 49.6444511413574,2.06618380546581 49.6380577087403))	0.0006	POINT(2.1012191474438286 49.64832814534509)
31583	POLYGON((1.94731128215801 47.1166725158691,1.93720245361328 47.1109275817871,1.93720245361328 47.1109275817871,1.92026126384741 47.1040344238282,1.90638518333429 47.1081085205079,1.89273262023931 47.1037673950195,1.88789880275721 47.104763031006,1.88789880275721 47.104763031006,1.88918387889873 47.1287994384766,1.88155233860016 47.1449775695801,1.89331638813024 47.1594772338867,1.89331638813024 47.1594772338867,1.93026554584503 47.1647415161133,1.93026554584503 47.1647415161133,1.93664491176605 47.159912109375,1.93664491176605 47.159912109375,1.93288135528576 47.1353340148925,1.94731128215801 47.1166725158691))	0.0006	POINT(1.9141743603874877 47.13184334250059)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point