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 |
---|---|---|---|
58462 | POLYGON((7.54723215103155 50.6602630615234,7.54832410812378 50.6597976684571,7.54766464233404 50.6592483520509,7.54846096038818 50.6585311889648,7.55062675476086 50.6587753295899,7.55037260055542 50.6576423645019,7.55717182159424 50.6558532714844,7.55844354629528 50.6529769897461,7.56187057495112 50.65389251709,7.56250953674322 50.6525115966797,7.56617736816406 50.6513977050782,7.56617736816406 50.6513977050782,7.56637859344494 50.650676727295,7.55987262725836 50.6512031555176,7.55612897872919 50.6503677368165,7.55629634857183 50.6495094299317,7.55477619171154 50.6486854553223,7.55092525482178 50.6479949951173,7.55092525482178 50.6479949951173,7.55069684982305 50.6486892700196,7.54630231857305 50.648307800293,7.54596471786493 50.6493911743164,7.54172182083141 50.6483993530273,7.53400897979748 50.6536598205566,7.53004932403564 50.6544494628907,7.52674293518066 50.6567687988282,7.52674293518066 50.6567687988282,7.53483104705816 50.6605682373048,7.53560972213756 50.6590118408204,7.53898525238043 50.658504486084,7.5398006439209 50.6590461730958,7.53758096694958 50.6598739624023,7.54091978073131 50.6603889465333,7.54136085510265 50.6614837646485,7.54136085510265 50.6614837646485,7.54723215103155 50.6602630615234)) | 0.0006 | POINT(7.547800391061011 50.65472902570456) |
12860 | POLYGON((16.3189010620118 40.6468734741211,16.3168811798097 40.6469535827637,16.30837059021 40.6519813537598,16.3054981231689 40.6557731628419,16.3040065765382 40.6666450500489,16.3042373657228 40.6739311218262,16.3042373657228 40.6739311218262,16.294382095337 40.6760139465333,16.2898292541504 40.6750335693361,16.2831153869629 40.6754150390626,16.2719726562501 40.6797294616699,16.2719726562501 40.6797294616699,16.2699069976807 40.6769485473634,16.2707386016847 40.6703376770021,16.2813568115236 40.6631507873535,16.2938461303711 40.6745605468751,16.2982883453369 40.668888092041,16.3031177520753 40.6544151306152,16.2948532104493 40.6515502929689,16.2681541442871 40.6524620056152,16.2654361724853 40.6527252197267,16.2632198333741 40.6541824340821,16.2573909759521 40.6531486511231,16.2426013946533 40.6432533264161,16.240608215332 40.6384811401367,16.241138458252 40.626865386963,16.2426948547364 40.6233978271484,16.2426948547364 40.6233978271484,16.2445449829103 40.6141433715821,16.2493534088136 40.6082954406739,16.2506313323976 40.60453414917,16.2503376007081 40.5989456176757,16.2503376007081 40.5989456176757,16.2543640136719 40.5988464355469,16.2815608978271 40.5915298461914,16.2815608978271 40.5915298461914,16.2919273376465 40.5887603759766,16.3053436279297 40.5901374816895,16.3122367858887 40.5933647155762,16.3122367858887 40.5933647155762,16.3101043701172 40.5979156494141,16.3066539764405 40.6106986999512,16.3103942871093 40.6231422424316,16.3203315734864 40.6366157531738,16.3222675323486 40.6430320739747,16.3224201202394 40.6472473144531,16.3189010620118 40.6468734741211)) | 0.0006 | POINT(16.28317517819617 40.63827879532527) |
65673 | MULTIPOLYGON(((11.6671772003175 48.7208824157716,11.6711959838867 48.7210388183594,11.6718158721924 48.7225074768066,11.6801977157593 48.7217102050782,11.691990852356 48.7225723266602,11.6987857818604 48.7203216552735,11.7072582244874 48.7204742431641,11.7214269638063 48.7179718017578,11.7581682205201 48.7185401916504,11.7581682205201 48.7185401916504,11.784478187561 48.7178001403809,11.7847061157227 48.7197570800782,11.7847061157227 48.7197570800782,11.7849502563477 48.7228240966797,11.8004674911499 48.729694366455,11.8150491714478 48.7445335388185,11.8150491714478 48.7445335388185,11.810832977295 48.7515449523926,11.8089656829835 48.7500610351562,11.8029975891114 48.750644683838,11.7873287200928 48.7470283508302,11.7809457778931 48.751979827881,11.7826948165894 48.7568626403809,11.7967414855956 48.758716583252,11.8027353286744 48.7646484375001,11.8054828643798 48.7634735107422,11.804693222046 48.76961517334,11.804693222046 48.76961517334,11.795081138611 48.769905090332,11.7835531234742 48.7676544189454,11.7774362564087 48.768581390381,11.7750387191774 48.7677536010742,11.7604742050171 48.7686958312989,11.7557888031005 48.7664260864258,11.7553882598878 48.7635726928711,11.7612094879152 48.764232635498,11.7628984451295 48.7627143859863,11.7673273086548 48.7622680664062,11.7674713134765 48.7613792419434,11.7653264999391 48.7596092224122,11.7669696807861 48.7589950561523,11.7629766464234 48.7576675415039,11.756823539734 48.7590866088868,11.7534551620484 48.7587547302247,11.7527494430543 48.757781982422,11.7491054534912 48.7596588134766,11.7427816390992 48.7611045837403,11.7392959594727 48.7641754150391,11.7211236953736 48.7638168334962,11.7120580673218 48.760166168213,11.7120580673218 48.760166168213,11.7149477005004 48.7556915283204,11.702244758606 48.752281188965,11.6661767959596 48.7483825683594,11.65540599823 48.744140625,11.6554670333863 48.7427101135254,11.6554670333863 48.7427101135254,11.6570892333984 48.729694366455,11.6687946319581 48.7243385314943,11.6671772003175 48.7208824157716)),((11.7257089614869 48.7508697509766,11.7255039215089 48.7557334899903,11.7189292907714 48.7557182312012,11.7196960449219 48.7539749145509,11.7181406021118 48.7528343200684,11.7204113006592 48.7500915527344,11.7257089614869 48.7508697509766)),((11.7263631820679 48.7476882934571,11.7270851135255 48.7461318969728,11.7302370071411 48.7465209960939,11.7306280136108 48.7453117370607,11.727412223816 48.7445373535156,11.7230882644654 48.7472915649415,11.7263631820679 48.7476882934571))) | 0.0006 | POINT(11.748198057399724 48.74785631762742) |
69798 | POLYGON((9.35933017730713 54.1482086181641,9.35949134826654 54.1444206237794,9.36300659179693 54.1393127441407,9.37543964385986 54.1341171264648,9.37175655364996 54.1258239746095,9.37185955047619 54.1136970520021,9.37185955047619 54.1136970520021,9.36825847625744 54.1128387451173,9.36848163604748 54.1113243103027,9.36388969421392 54.110408782959,9.36858463287365 54.1073913574219,9.36624717712414 54.1061935424806,9.36921215057384 54.1044425964355,9.3525772094726 54.0977668762207,9.3525772094726 54.0977668762207,9.35000705719 54.0990295410156,9.34640407562267 54.1029129028321,9.35183811187738 54.1048736572265,9.34899139404297 54.1067352294923,9.34916782379145 54.1093063354492,9.34559917449945 54.108985900879,9.34390544891357 54.1105880737306,9.34658050537115 54.1134681701661,9.35000324249279 54.1146774291992,9.339189529419 54.1177101135255,9.31376838684082 54.1186676025391,9.31376838684082 54.1186676025391,9.3046932220459 54.125057220459,9.31199741363525 54.128044128418,9.31199741363525 54.128044128418,9.31240272521973 54.128875732422,9.31578922271723 54.1291847229005,9.31719589233393 54.130859375,9.32154941558838 54.1316108703614,9.32635879516596 54.1364059448242,9.33113288879395 54.1374855041504,9.33681011199945 54.1402320861818,9.34148979187012 54.1408309936524,9.3476419448852 54.1441688537598,9.35115146636969 54.1445159912111,9.35468101501465 54.1469726562501,9.35781574249279 54.1476211547852,9.35781574249279 54.1476211547852,9.35933017730713 54.1482086181641)) | 0.0006 | POINT(9.346100407977461 54.122803798941725) |
39020 | POLYGON((2.32833933830273 42.8626937866212,2.30218863487249 42.8659896850587,2.28704929351807 42.8603935241699,2.28704929351807 42.8603935241699,2.26714968681335 42.8661422729493,2.26150846481329 42.8781089782716,2.26150846481329 42.8781089782716,2.25609207153326 42.8828353881836,2.25763034820568 42.8859138488771,2.27346849441534 42.8906898498536,2.2727422714234 42.8969268798828,2.2727422714234 42.8969268798828,2.29809999465942 42.8988227844239,2.29809999465942 42.8988227844239,2.30140686035162 42.8852462768556,2.32833933830273 42.8626937866212)) | 0.0006 | POINT(2.281671698888189 42.880534362793036) |
28554 | POLYGON((4.48683881759644 47.5971755981446,4.51615190505987 47.5982894897462,4.54201507568371 47.6075592041016,4.54201507568371 47.6075592041016,4.55169820785534 47.6132278442382,4.55169820785534 47.6132278442382,4.54516029357904 47.6214790344239,4.54762268066406 47.6241950988769,4.54762268066406 47.6241950988769,4.53154277801519 47.6323204040528,4.51162862777721 47.6340980529786,4.50381135940557 47.6426353454591,4.50616407394415 47.6561470031739,4.48627853393555 47.6588134765624,4.48627853393555 47.6588134765624,4.47443103790295 47.6438102722169,4.46331501007086 47.6367950439454,4.46234035491943 47.6264991760254,4.46234035491943 47.6264991760254,4.46184062957764 47.6131172180177,4.46928596496582 47.6006469726562,4.46928596496582 47.6006469726562,4.48683881759644 47.5971755981446)) | 0.0006 | POINT(4.505425734953488 47.62444322759457) |
22781 | POLYGON((0.462864637374992 44.3384399414064,0.462336659431514 44.3552703857423,0.462336659431514 44.3552703857423,0.470572799444199 44.3583221435548,0.479613602161464 44.3568534851075,0.484372913837433 44.3624649047852,0.484372913837433 44.3624649047852,0.51795589923853 44.3380928039551,0.516745150089264 44.3213424682617,0.516745150089264 44.3213424682617,0.507759332656917 44.3188591003419,0.483828037977275 44.3207664489747,0.476708978414649 44.3254127502443,0.473996520042419 44.3319396972657,0.462864637374992 44.3384399414064)) | 0.0006 | POINT(0.48572923243049054 44.34048870631635) |
65559 | POLYGON((10.9215507507325 48.0343170166017,10.9229068756105 48.0393104553223,10.9239597320557 48.0386047363281,10.9235944747925 48.0444564819337,10.9210720062256 48.0441589355469,10.9215450286865 48.0461730957032,10.9170446395875 48.0466766357422,10.9168596267701 48.0493774414064,10.9055852890015 48.0499877929689,10.9054927825927 48.0521430969239,10.9079408645629 48.0522079467774,10.9077768325806 48.0538482666016,10.9123601913453 48.0539474487305,10.9117736816407 48.059211730957,10.9117736816407 48.059211730957,10.9160461425781 48.0626182556153,10.9293022155762 48.0651092529297,10.9299688339233 48.0636596679688,10.9335660934449 48.0640144348146,10.9354486465455 48.0580024719239,10.9457111358643 48.0590286254883,10.9465188980104 48.0568237304689,10.946660041809 48.048366546631,10.9517736434937 48.0490188598634,10.9532556533813 48.0462036132812,10.9639863967897 48.0440025329589,10.9695568084718 48.0404624938965,10.9695568084718 48.0404624938965,10.9678716659547 48.0389747619629,10.9676933288574 48.0369338989258,10.9703855514527 48.0325622558594,10.9753856658936 48.0313110351562,10.9751319885254 48.0285682678223,10.9751319885254 48.0285682678223,10.9718990325928 48.0282325744629,10.9718990325928 48.0282325744629,10.9697990417481 48.0287170410157,10.9709091186525 48.0302810668946,10.9677906036377 48.030460357666,10.9660243988037 48.0274009704589,10.9642143249512 48.0271949768068,10.9632740020753 48.0259513854981,10.9614725112915 48.0267753601075,10.9573755264283 48.0256500244141,10.9572448730469 48.021713256836,10.9538803100587 48.0215225219727,10.9487247467041 48.0237846374511,10.9463672637941 48.0257225036621,10.9471874237061 48.0262641906738,10.9460620880127 48.0272903442384,10.9432392120362 48.0287742614746,10.9417877197265 48.0282135009767,10.9387350082397 48.0295066833496,10.9375915527343 48.0316543579103,10.9360723495483 48.0322799682617,10.9323444366455 48.0317001342773,10.929768562317 48.0332336425781,10.9215507507325 48.0343170166017)) | 0.0006 | POINT(10.943471072012958 48.03962948447783) |
44690 | POLYGON((0.588250458240623 43.1052818298341,0.567419767379874 43.1266555786133,0.567419767379874 43.1266555786133,0.558375000953731 43.1252632141114,0.556416153907776 43.1221923828125,0.524177849292755 43.1231307983398,0.511411309242192 43.1191940307617,0.511411309242192 43.1191940307617,0.522929370403403 43.1020889282227,0.555331170558873 43.1010780334474,0.555331170558873 43.1010780334474,0.574791610240993 43.0994033813477,0.574791610240993 43.0994033813477,0.588250458240623 43.1052818298341)) | 0.0006 | POINT(0.5513889652032424 43.113124553973904) |
52540 | POLYGON((0.164662569761276 45.9789237976074,0.156482860446033 45.967140197754,0.143656879663524 45.9625549316407,0.1392564773559 45.9639396667481,0.1392564773559 45.9639396667481,0.144364774227142 45.9556350708008,0.141765668988342 45.9462242126465,0.146514192223606 45.9405860900879,0.146514192223606 45.9405860900879,0.153883352875766 45.9401931762696,0.153883352875766 45.9401931762696,0.186900615692196 45.9529762268066,0.201273545622882 45.9538383483887,0.201273545622882 45.9538383483887,0.202166154980659 45.9756736755371,0.202166154980659 45.9756736755371,0.177325561642647 45.9739418029786,0.164662569761276 45.9789237976074)) | 0.0006 | POINT(0.1647850809728697 45.95799165613514) |