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.
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 | geometryDieser 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:
| beliebig | Die simplifizierten Geodaten. |
epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
mittelpunkt | pointDieser 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:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
id_ort | geodaten | epsilon | mittelpunkt |
---|---|---|---|
46792 | POLYGON((3.17500233650213 50.5575828552247,3.19105315208441 50.5472717285157,3.19105315208441 50.5472717285157,3.20124912261963 50.5536651611329,3.20119071006786 50.5601806640626,3.19308948516857 50.5640182495118,3.17810344696051 50.5619773864747,3.17810344696051 50.5619773864747,3.17500233650213 50.5575828552247)) | 0.0006 | POINT(3.1886056065560036 50.556743144989106) |
64675 | POLYGON((12.6754093170165 48.9499282836914,12.6666316986085 48.953140258789,12.6641778945923 48.9523429870605,12.6626014709473 48.9494667053223,12.6571350097657 48.9506530761718,12.6560029983522 48.950080871582,12.6560029983522 48.950080871582,12.6525611877443 48.9500923156739,12.6513233184815 48.9526824951172,12.6493759155275 48.9528160095216,12.6468849182129 48.9585800170899,12.6416330337524 48.9550704956055,12.6403799057007 48.9520645141602,12.635440826416 48.9522132873536,12.6331720352173 48.9509506225587,12.6279592514039 48.9579162597656,12.6340522766114 48.9612998962402,12.6351346969605 48.9604415893555,12.6360607147217 48.9609985351562,12.6351890563966 48.9622955322265,12.6445903778077 48.965072631836,12.6445903778077 48.965072631836,12.6471185684205 48.9659881591797,12.6462125778199 48.9677619934082,12.649395942688 48.965576171875,12.6528053283691 48.9712600708007,12.6509046554565 48.97123336792,12.6521749496461 48.9727478027345,12.6505584716798 48.9742088317871,12.6515350341796 48.9746589660645,12.6535053253174 48.9734687805176,12.6542282104492 48.9789695739747,12.6474590301515 48.9789009094239,12.6442861557007 48.9810333251953,12.6415996551514 48.9799346923829,12.6415910720825 48.9812927246094,12.6453943252565 48.9819641113281,12.6453943252565 48.9819641113281,12.6462106704711 48.9846687316896,12.6488895416261 48.9855613708497,12.6494512557983 48.9877548217774,12.6533899307252 48.9893074035645,12.6625785827637 48.9893379211426,12.6638660430909 48.9918136596681,12.6628961563111 48.9918327331544,12.6630582809448 48.9933242797853,12.6691999435425 48.9912414550782,12.6725759506226 48.9884681701661,12.6791763305663 48.9859619140625,12.680760383606 48.9862289428712,12.6798009872437 48.984962463379,12.6819925308228 48.9841461181641,12.6822223663331 48.9831771850587,12.6880702972413 48.9818954467775,12.6923274993896 48.982322692871,12.6916646957398 48.9806747436524,12.6922540664673 48.9795112609864,12.6911659240723 48.9785003662109,12.6946573257446 48.977653503418,12.6948947906494 48.976505279541,12.6913948059083 48.9758872985841,12.6907835006714 48.9745292663575,12.7009658813477 48.9712753295898,12.705945968628 48.9757957458496,12.7064247131348 48.9772033691406,12.7091312408448 48.9776191711427,12.7091312408448 48.9776191711427,12.7086019515991 48.9745559692383,12.7073001861572 48.9755058288575,12.7056818008424 48.9735946655273,12.707447052002 48.9703369140625,12.705454826355 48.9682960510253,12.7029399871827 48.9688949584962,12.7004890441895 48.9685134887696,12.7009019851685 48.967056274414,12.698106765747 48.9672393798829,12.7032566070556 48.9605407714845,12.6958723068237 48.9610214233398,12.6961145401002 48.9589118957521,12.6931028366089 48.9585189819336,12.6868400573731 48.9598197937012,12.6827354431152 48.9584846496583,12.677438735962 48.9552612304688,12.6776447296143 48.9531593322754,12.6754093170165 48.9499282836914)) | 0.0006 | POINT(12.669348603203218 48.97046089172365) |
70405 | POLYGON((10.8627681732177 51.027931213379,10.862985610962 51.0265426635743,10.862985610962 51.0265426635743,10.8553466796876 51.0258369445801,10.8578729629516 51.0134391784669,10.8607873916626 51.0063171386719,10.8607873916626 51.0063171386719,10.8387889862061 51.001262664795,10.8387889862061 51.001262664795,10.8359804153443 51.0073356628419,10.8310565948486 51.0068168640138,10.8210515975952 51.0035362243653,10.8210515975952 51.0035362243653,10.8226518630983 51.0121765136719,10.8191061019897 51.0212936401367,10.8210258483887 51.0224571228028,10.8202772140503 51.0257072448732,10.805682182312 51.034366607666,10.805682182312 51.034366607666,10.8048553466797 51.0365715026857,10.8048553466797 51.0365715026857,10.8149099349975 51.0356712341308,10.816370010376 51.0363693237305,10.8313522338867 51.0341339111329,10.8269195556642 51.0288200378418,10.8346462249756 51.0279502868653,10.8431749343873 51.0294456481934,10.8617963790894 51.0296058654785,10.8627681732177 51.027931213379)) | 0.0006 | POINT(10.833698477063882 51.0215065819877) |
67967 | POLYGON((7.78394365310669 49.0583992004395,7.7894291877746 49.0615615844727,7.78715896606445 49.0661315917969,7.79029846191406 49.0694999694825,7.79076194763195 49.0719795227051,7.7925882339477 49.0728797912598,7.7925882339477 49.0728797912598,7.7940154075622 49.0721015930176,7.79709672927856 49.0733489990234,7.80212450027472 49.0713882446288,7.81235742568964 49.0750846862794,7.81583309173584 49.0731849670411,7.81674623489391 49.0715446472168,7.81674623489391 49.0715446472168,7.81728076934809 49.0700607299804,7.82684803009033 49.0692100524902,7.82630252838146 49.0681800842286,7.82721185684215 49.0661048889161,7.82611322402954 49.0644226074219,7.82752609252941 49.0589408874512,7.81869173049921 49.0545349121094,7.81869173049921 49.0545349121094,7.81572294235235 49.0549583435059,7.81263160705561 49.0571060180664,7.81048345565807 49.0612564086915,7.79440259933472 49.0656852722169,7.79207372665405 49.0610733032228,7.78919839859009 49.0593605041504,7.78943347930903 49.0587234497071,7.78816032409668 49.0579719543457,7.78394365310669 49.0583992004395)) | 0.0006 | POINT(7.805415360132864 49.06545511881513) |
31660 | POLYGON((1.26126086711895 48.0482177734376,1.2425309419632 48.0507469177247,1.23081624507904 48.0598335266113,1.23081624507904 48.0598335266113,1.23208427429205 48.0632705688477,1.25086390972137 48.0695457458497,1.26642918586737 48.0707588195801,1.2741504907608 48.0835456848145,1.2741504907608 48.0835456848145,1.28919243812561 48.0736656188965,1.31377828121185 48.0683403015137,1.31377828121185 48.0683403015137,1.29446113109589 48.0510406494141,1.29446113109589 48.0510406494141,1.27333509922039 48.0439109802247,1.26126086711895 48.0482177734376)) | 0.0006 | POINT(1.2694739341736065 48.06304244995121) |
48649 | POLYGON((-0.94639390707016 48.3521118164064,-0.942065000534001 48.3534965515137,-0.940461218357086 48.3625793457032,-0.92607319355011 48.3699302673341,-0.92607319355011 48.3699302673341,-0.917325973510629 48.3730125427246,-0.904445528984013 48.3694267272949,-0.884927213191986 48.3709335327149,-0.884927213191986 48.3709335327149,-0.882672548294067 48.3678665161133,-0.872838258743286 48.3659439086915,-0.857556104660034 48.3743247985841,-0.842512607574463 48.3653182983398,-0.827124416828099 48.365062713623,-0.806913733482361 48.3739891052246,-0.806913733482361 48.3739891052246,-0.80324649810791 48.3685226440431,-0.809208154678345 48.3597564697265,-0.804174065589905 48.3507041931152,-0.804174065589905 48.3507041931152,-0.800980925559998 48.3448524475098,-0.809341073036194 48.329875946045,-0.802982330322266 48.3209533691407,-0.802982330322266 48.3209533691407,-0.81654167175293 48.3252296447754,-0.841591060161591 48.3144111633302,-0.858493566513062 48.3257598876954,-0.866747856140137 48.3222846984863,-0.869177341461068 48.3123397827149,-0.869177341461068 48.3123397827149,-0.880620598792916 48.3188209533693,-0.878579080104771 48.3255729675293,-0.878579080104771 48.3255729675293,-0.873570203781014 48.3263397216798,-0.876477301120758 48.3326148986816,-0.900115370750427 48.3367538452149,-0.914207637309971 48.3327674865722,-0.924366652965546 48.3333053588867,-0.941053867340031 48.3253974914551,-0.941053867340031 48.3253974914551,-0.946844756603241 48.3311080932618,-0.94639390707016 48.3521118164064)) | 0.0006 | POINT(-0.8703295254125578 48.34515092431049) |
1402288 | POLYGON((-5.47161912918085 42.0062751770021,-5.47269678115845 42.0135650634766,-5.48755884170532 42.0258445739747,-5.48815393447876 42.029956817627,-5.49259614944458 42.0332794189453,-5.48639678955072 42.0387916564942,-5.49573421478266 42.0455589294435,-5.49610614776611 42.0491790771485,-5.50763416290283 42.0574913024903,-5.50275611877436 42.0625343322755,-5.50147485733032 42.0665054321289,-5.50893497467035 42.0770072937013,-5.51827907562256 42.0846824645996,-5.5178370475769 42.0906105041504,-5.52078008651728 42.0971260070801,-5.51662015914911 42.0934371948243,-5.51030015945435 42.0929374694824,-5.51010894775391 42.0911483764649,-5.49835300445551 42.0836601257325,-5.48980617523188 42.0737762451172,-5.48325395584101 42.0598068237305,-5.47698402404785 42.0564498901368,-5.48081493377686 42.0524101257325,-5.46410179138184 42.0436325073242,-5.45452690124512 42.0406684875488,-5.43856906890863 42.0314903259277,-5.43038511276245 42.0351486206056,-5.42466402053833 42.0356292724609,-5.42148017883301 42.0306625366211,-5.44732999801636 42.0136413574219,-5.44769906997681 42.0107192993165,-5.45921802520752 42.0069313049317,-5.47161912918085 42.0062751770021)) | 0.0006 | POINT(-5.481961682438831 42.050954937934925) |
45111 | POLYGON((0.211927220225448 42.8667640686036,0.202647149562949 42.8679428100586,0.197951391339302 42.873992919922,0.178274422883931 42.8834037780762,0.173663929104862 42.8825988769532,0.173663929104862 42.8825988769532,0.156404539942741 42.8867301940918,0.145425349473953 42.9084320068359,0.145425349473953 42.9084320068359,0.146282315254211 42.9181365966797,0.141003996133804 42.9236297607421,0.139701008796749 42.933666229248,0.136340916156882 42.9359893798829,0.113681808113995 42.9335556030273,0.113681808113995 42.9335556030273,0.0972357541322708 42.9406166076661,0.0833760425449555 42.9400177001954,0.0499440468847183 42.9533653259278,0.0476197488606545 42.9564247131348,0.0534315519035431 42.9618873596191,0.0555566810072037 42.9752922058106,0.0555566810072037 42.9752922058106,0.0643575713039013 42.9774475097656,0.0681577324867817 42.9837341308594,0.0681117475033375 43.0001487731935,0.0619404949248406 43.0091705322266,0.0430677421392147 43.0242919921876,0.0430677421392147 43.0242919921876,0.0522671192885014 43.0233383178712,0.0605227798223495 43.0151138305665,0.0725049450994106 43.0102653503419,0.0810441896320526 43.012866973877,0.073879890143985 43.0252876281739,0.0692386701703072 43.04549407959,0.0692386701703072 43.04549407959,0.101036973297653 43.0431976318361,0.10361689329153 43.0556411743164,0.109883300960064 43.0601654052736,0.109883300960064 43.0601654052736,0.141986161470413 43.0779151916504,0.156415387988204 43.0900878906251,0.156415387988204 43.0900878906251,0.163656905293465 43.0871543884278,0.167502582073325 43.0918731689453,0.167502582073325 43.0918731689453,0.178780332207793 43.0882530212403,0.1849430948497 43.0920677185059,0.1849430948497 43.0920677185059,0.189178600907383 43.0880470275879,0.186451077461356 43.0860595703126,0.186451077461356 43.0860595703126,0.174523577094078 43.0723304748535,0.174523577094078 43.0723304748535,0.168299511075077 43.0673141479492,0.158941924572048 43.0668983459473,0.158692240715027 43.0502319335939,0.158692240715027 43.0502319335939,0.145396903157348 43.0341682434082,0.145396903157348 43.0341682434082,0.145616441965103 43.0272254943848,0.132941439747867 43.0233345031738,0.138882607221603 43.0138092041017,0.13811960816389 43.0069122314454,0.135832369327545 43.003818511963,0.118285983800945 42.991985321045,0.103373773396129 42.970012664795,0.109175011515674 42.9650001525879,0.132262095809097 42.967700958252,0.146153286099434 42.9583396911622,0.152144178748244 42.9628372192383,0.152809560298977 42.9767303466797,0.152809560298977 42.9767303466797,0.161879613995495 42.9789695739747,0.164784908294678 42.9762039184571,0.165828600525799 42.9521026611328,0.172670379281101 42.947208404541,0.177015691995734 42.9457664489747,0.191184535622654 42.944320678711,0.194913864135856 42.9421768188477,0.196806892752704 42.9389953613282,0.196164697408676 42.9355583190918,0.193688496947289 42.9325714111329,0.182983711361885 42.9255409240723,0.180844455957413 42.9224433898926,0.183575719595069 42.919906616211,0.188280969858283 42.9203338623048,0.201120361685867 42.9247360229493,0.205320432782287 42.9232101440431,0.207815483212528 42.9202156066895,0.21203321218502 42.9101562500001,0.211537018418426 42.8998489379883,0.224884375929946 42.8815422058107,0.225364699959698 42.870979309082,0.225364699959698 42.870979309082,0.211927220225448 42.8667640686036)) | 0.0006 | POINT(0.1429976308916973 42.982934708290934) |
31778 | POLYGON((1.39059424400335 48.3220863342285,1.39746999740606 48.3129615783691,1.41057598590857 48.3078384399415,1.4192014932633 48.2995605468751,1.41815650463116 48.2961807250977,1.41815650463116 48.2961807250977,1.43623864650721 48.2899322509767,1.4503996372224 48.2926177978515,1.4503996372224 48.2926177978515,1.45756316185009 48.2916069030762,1.46035766601557 48.2961158752443,1.46035766601557 48.2961158752443,1.46302890777599 48.3025550842286,1.45886826515198 48.308765411377,1.45969116687775 48.3221397399902,1.45969116687775 48.3221397399902,1.44665646553051 48.325813293457,1.44525372982031 48.3353881835938,1.43725264072418 48.3389434814454,1.44219017028803 48.3435897827148,1.44219017028803 48.3435897827148,1.43384850025171 48.3462944030763,1.41245138645183 48.3427352905275,1.41245138645183 48.3427352905275,1.40984272956842 48.3330192565918,1.40005576610571 48.3313217163087,1.39561295509344 48.3216667175294,1.39059424400335 48.3220863342285)) | 0.0006 | POINT(1.4329095019234928 48.31683377866397) |
1401486 | POLYGON((-2.52352690696711 41.9744338989258,-2.54415798187256 41.9739265441895,-2.54878211021423 41.9718360900879,-2.57231402397156 41.9796791076661,-2.57984709739685 41.9962615966798,-2.57518792152399 42.0066566467286,-2.56523489952082 42.0139503479004,-2.55596089363098 42.0348472595216,-2.55122089385981 42.0388526916505,-2.55197095870972 42.0456047058105,-2.54900503158569 42.0515060424805,-2.53946995735163 42.0549812316895,-2.53533101081848 42.0541458129883,-2.53244495391834 42.0552253723145,-2.51481795310974 42.0688591003418,-2.49983310699463 42.0623931884766,-2.49125909805292 42.0479621887208,-2.4861741065979 42.0430603027344,-2.48236107826233 42.0425186157227,-2.47935700416565 42.0346069335937,-2.47942304611206 42.0294380187989,-2.469162940979 42.0212631225585,-2.45965409278864 42.0171127319336,-2.46862506866449 42.0089950561525,-2.47435188293451 41.9939460754395,-2.48150706291199 41.9914855957032,-2.48489594459528 41.985939025879,-2.49762892723083 41.9862213134766,-2.50654506683344 41.9837493896484,-2.51776504516602 41.9797439575195,-2.52352690696711 41.9744338989258)) | 0.0006 | POINT(-2.5172605355580395 42.01830673217776) |