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 |
---|---|---|---|
44150 | POLYGON((0.597401440143528 43.782741546631,0.61451226472866 43.7809562683106,0.617386519909019 43.7748947143555,0.617386519909019 43.7748947143555,0.6480633020401 43.7730598449706,0.6480633020401 43.7730598449706,0.652982175350189 43.8060874938965,0.657159566879216 43.8075942993165,0.657159566879216 43.8075942993165,0.664961934089661 43.815315246582,0.664961934089661 43.815315246582,0.634002268314475 43.808433532715,0.606002509593964 43.8097038269043,0.606002509593964 43.8097038269043,0.596997082233543 43.8021240234376,0.600176155567169 43.7924270629882,0.597401440143528 43.782741546631)) | 0.0006 | POINT(0.6302011907100927 43.79586911201479) |
32013 | POLYGON((0.982040286064262 48.3557319641114,0.970371782779807 48.3501663208009,0.951715111732597 48.3493881225587,0.951715111732597 48.3493881225587,0.938809096813259 48.354850769043,0.909000098705349 48.3601150512696,0.907346844673157 48.3701019287109,0.907346844673157 48.3701019287109,0.926529109477997 48.3841133117676,0.926529109477997 48.3841133117676,0.932676792144775 48.381015777588,0.948628127574921 48.3852806091309,0.948628127574921 48.3852806091309,0.982040286064262 48.3557319641114)) | 0.0006 | POINT(0.9385643418019073 48.367665217473004) |
37807 | POLYGON((1.35813152790075 49.3406562805176,1.3368160724641 49.3232078552247,1.3368160724641 49.3232078552247,1.33578419685375 49.3198051452638,1.34408533573151 49.3110008239747,1.34408533573151 49.3110008239747,1.35889911651617 49.312198638916,1.3719220161438 49.307415008545,1.39205563068401 49.3086547851564,1.39205563068401 49.3086547851564,1.39595174789434 49.3248825073242,1.39595174789434 49.3248825073242,1.37804877758032 49.3325538635255,1.37804877758032 49.3325538635255,1.35813152790075 49.3406562805176)) | 0.0006 | POINT(1.3656179990087882 49.32004819597524) |
1389722 | POLYGON((-0.132319003343582 40.7919883728028,-0.118421003222409 40.8326988220214,-0.112933002412262 40.8332061767578,-0.110127002000695 40.835838317871,-0.103882998228073 40.8348999023438,-0.101120002567711 40.8392524719239,-0.087525002658367 40.8453025817871,-0.075391001999321 40.8552742004395,-0.060107000172081 40.8524627685547,-0.048165000975075 40.8484001159668,-0.036616001278162 40.8488540649414,-0.034914001822472 40.85111618042,-0.032643999904394 40.8374481201172,-0.025526000186744 40.8335151672363,-0.035195998847485 40.8264541625978,-0.039154998958111 40.8275375366212,-0.046966001391411 40.8244285583497,-0.056735999882221 40.8134117126466,-0.062679998576641 40.8106117248535,-0.063000001013279 40.8090324401857,-0.065430998802128 40.8092651367188,-0.067204996943474 40.805835723877,-0.070207998156434 40.8046798706055,-0.068691000342312 40.8022804260254,-0.087250001728478 40.7987861633301,-0.092505000531617 40.8016395568848,-0.096478000283128 40.7996940612792,-0.106596998870373 40.7992286682129,-0.112103000283184 40.7979240417482,-0.115955002605915 40.791961669922,-0.126096993684769 40.7939147949219,-0.132319003343582 40.7919883728028)) | 0.0006 | POINT(-0.07715948424749383 40.82119172619238) |
71333 | POLYGON((13.1001873016358 46.8276824951172,13.0877227783204 46.8270187377929,13.0743455886841 46.8125495910645,13.0644273757935 46.8135147094727,13.0644273757935 46.8135147094727,13.0388984680176 46.8152046203614,13.0388984680176 46.8152046203614,13.0382823944091 46.8056259155275,13.040533065796 46.7958030700685,13.043924331665 46.7899703979493,13.0527639389039 46.7791137695314,13.0550270080566 46.774742126465,13.0553913116455 46.7702102661133,13.0528173446655 46.7631072998048,13.038561820984 46.7359008789062,13.032078742981 46.7337875366211,13.0149774551392 46.7337493896484,13.0082721710205 46.73201751709,12.9998416900636 46.7267189025879,12.9930067062377 46.7200469970703,12.9930067062377 46.7200469970703,12.9904680252076 46.7059631347656,12.9904680252076 46.7059631347656,13.0567045211793 46.6973648071289,13.0567045211793 46.6973648071289,13.0796308517456 46.6974258422852,13.0796308517456 46.6974258422852,13.0961809158326 46.7149314880372,13.1001243591309 46.7206993103027,13.1018161773682 46.7250213623047,13.103343963623 46.7372779846191,13.1046190261842 46.772850036621,13.1071376800537 46.7843513488771,13.1142358779908 46.7913932800294,13.1307783126831 46.8013534545899,13.1307783126831 46.8013534545899,13.1001873016358 46.8276824951172)) | 0.0006 | POINT(13.059167040718954 46.75989638434519) |
73174 | POLYGON((10.1349039077759 47.2503662109376,10.1207218170165 47.2539405822755,10.1172428131105 47.2556495666505,10.1162643432618 47.2592582702638,10.1156425476074 47.2727127075196,10.1156425476074 47.2727127075196,10.0895242691041 47.2790107727051,10.0895242691041 47.2790107727051,10.0739536285402 47.2776184082032,10.0684509277344 47.2760429382325,10.0666065216064 47.273593902588,10.0641527175903 47.2642631530763,10.0620555877685 47.2615394592286,10.0396537780763 47.2493934631347,10.0396537780763 47.2493934631347,10.0487155914307 47.2446937561035,10.0636672973633 47.2448768615723,10.0671224594117 47.2440223693849,10.0673532485962 47.2404403686524,10.064079284668 47.2272071838379,10.064079284668 47.2272071838379,10.0905075073243 47.2252120971681,10.0978498458862 47.2259788513184,10.1000423431396 47.2274360656739,10.1060190200806 47.2353286743165,10.1234703063965 47.239658355713,10.1349039077759 47.2503662109376)) | 0.0006 | POINT(10.084880755497892 47.25217569791358) |
1402582 | POLYGON((-5.87347984313965 41.5642127990723,-5.88068723678589 41.5647315979003,-5.88927698135376 41.5713005065919,-5.89184999465942 41.5768089294434,-5.89023399353022 41.5822448730469,-5.90172576904291 41.5897903442384,-5.90681505203236 41.5906524658204,-5.90817117691034 41.5930671691895,-5.90622520446777 41.6007537841797,-5.90836477279652 41.601905822754,-5.90664577484131 41.6053085327148,-5.91289281845093 41.6097450256347,-5.91803979873657 41.6100006103517,-5.91924810409546 41.6064453125,-5.92781305313105 41.6156959533691,-5.92849397659302 41.6187934875489,-5.92466688156128 41.6305084228516,-5.91570997238159 41.6320610046386,-5.90381288528442 41.6464385986329,-5.8975458145141 41.6515426635743,-5.85424900054926 41.6355476379395,-5.87371683120728 41.6138801574708,-5.87614679336542 41.6088676452637,-5.86398601531982 41.5957183837892,-5.86390781402582 41.5880279541016,-5.8605871200561 41.5866889953613,-5.86023902893066 41.5850219726564,-5.86751604080195 41.5700798034667,-5.87347984313965 41.5642127990723)) | 0.0006 | POINT(-5.894001705305889 41.601637159075096) |
50213 | POLYGON((1.9415810108186 49.387077331543,1.92105853557587 49.3951950073243,1.92105853557587 49.3951950073243,1.95131921768188 49.4187583923341,1.95131921768188 49.4187583923341,1.96026694774633 49.4164466857911,1.96794950962067 49.4201698303223,1.9800199270249 49.4153022766114,1.9800199270249 49.4153022766114,1.98239433765406 49.4087867736817,1.97545588016516 49.3995513916016,1.97545588016516 49.3995513916016,1.97035276889807 49.3998947143555,1.96853482723242 49.3902511596681,1.96438789367676 49.388282775879,1.95986127853399 49.3867263793945,1.94730937480938 49.3924789428712,1.9415810108186 49.387077331543)) | 0.0006 | POINT(1.9599026511697588 49.402807572308774) |
63371 | POLYGON((13.661768913269 53.5983047485352,13.6596117019654 53.6040000915528,13.6547079086304 53.6039428710938,13.653190612793 53.6053428649903,13.6466693878174 53.6063346862794,13.6440544128418 53.6059341430664,13.6449308395387 53.6080169677734,13.6353845596313 53.6056518554688,13.6248025894166 53.6061058044434,13.6265363693238 53.6119537353516,13.6144895553589 53.6135368347169,13.6154699325561 53.6158294677736,13.6147251129151 53.6219291687012,13.613676071167 53.62162399292,13.5767211914063 53.6383934020997,13.5786209106446 53.6389389038086,13.5844364166261 53.6548652648926,13.5878267288208 53.6604194641113,13.596667289734 53.6578407287599,13.5987386703491 53.6582221984864,13.5997505187989 53.6599044799804,13.5981426239014 53.6628417968751,13.5892810821533 53.6655616760254,13.589744567871 53.6669807434083,13.6002120971681 53.6634101867677,13.6066722869872 53.6624832153321,13.6185684204102 53.6785316467285,13.6213121414186 53.6832122802734,13.6211032867432 53.6845321655273,13.6245393753053 53.688087463379,13.6250047683716 53.6931114196778,13.6429557800294 53.691577911377,13.6489562988282 53.6890678405762,13.6575040817262 53.6978988647461,13.6575040817262 53.6978988647461,13.6609144210817 53.6985397338868,13.6791944503785 53.6967201232911,13.6828212738037 53.6976280212402,13.6921682357788 53.697582244873,13.6999073028564 53.6997947692872,13.7079210281373 53.6989288330079,13.7079210281373 53.6989288330079,13.7242126464843 53.6966819763184,13.7341146469116 53.693286895752,13.7341146469116 53.693286895752,13.7477293014528 53.6882591247559,13.7540760040283 53.6905136108399,13.7553777694703 53.6892814636231,13.7534790039063 53.6865730285645,13.7581996917725 53.6854782104492,13.7694931030273 53.684871673584,13.7961101531982 53.6855239868164,13.7961101531982 53.6855239868164,13.7918787002564 53.6784439086914,13.7823514938355 53.6786613464357,13.7823514938355 53.6786613464357,13.7650489807129 53.6790199279786,13.7509326934816 53.6723175048828,13.7230749130249 53.668571472168,13.7197637557985 53.6651573181152,13.7134675979614 53.6610870361328,13.7110252380371 53.6618499755859,13.7066612243653 53.6601486206055,13.6973896026611 53.6524391174317,13.6942901611328 53.6512489318848,13.7056856155396 53.6455612182618,13.7149105072022 53.6426849365236,13.7185621261596 53.6406478881836,13.7278451919557 53.6390838623048,13.7278451919557 53.6390838623048,13.7345705032349 53.6363067626953,13.7365093231202 53.6322479248046,13.7354459762574 53.6291275024415,13.7296657562257 53.6252288818359,13.7356348037721 53.6249313354493,13.7456274032593 53.6270675659181,13.7480850219727 53.6253242492676,13.7571249008179 53.6227912902833,13.7581901550294 53.6215858459473,13.7581901550294 53.6215858459473,13.7582750320436 53.6189537048341,13.762770652771 53.6156921386719,13.7583017349244 53.6145935058594,13.7541446685792 53.6150817871093,13.7566099166871 53.6129417419434,13.7562351226807 53.6113548278808,13.7446470260621 53.611831665039,13.7435655593873 53.6102333068848,13.7346057891846 53.604907989502,13.7342681884766 53.603614807129,13.7292470932007 53.6034049987793,13.7235145568849 53.6015281677247,13.7232475280762 53.5999641418457,13.7162075042725 53.5982017517089,13.7061309814453 53.5918846130372,13.7041540145875 53.5915565490723,13.7017107009888 53.5926628112792,13.6990585327148 53.5919570922853,13.6990585327148 53.5919570922853,13.6976041793823 53.5958442687989,13.693868637085 53.5980987548828,13.6924953460694 53.5975036621095,13.6940307617189 53.590389251709,13.6893920898438 53.587718963623,13.6845846176147 53.5863800048829,13.6830959320069 53.5886535644532,13.680477142334 53.5900535583496,13.6761064529419 53.5900230407715,13.6733303070069 53.5932235717774,13.6683616638184 53.5932960510254,13.6683616638184 53.5932960510254,13.6667375564575 53.5955467224121,13.661768913269 53.5983047485352)) | 0.0006 | POINT(13.692272084099939 53.64065095356534) |
39992 | POLYGON((3.07623744010931 44.5194625854493,3.06893181800842 44.5027046203614,3.09955954551708 44.4804306030273,3.09955954551708 44.4804306030273,3.11732530593883 44.4737854003906,3.11732530593883 44.4737854003906,3.12984418869024 44.4833526611329,3.10972738266003 44.4975166320801,3.09813213348389 44.5201034545898,3.09793019294744 44.5269813537599,3.10668683052069 44.5392417907714,3.10668683052069 44.5392417907714,3.10814309120184 44.5504417419435,3.10814309120184 44.5504417419435,3.10023927688604 44.5588111877442,3.09388184547436 44.5746078491212,3.07660722732544 44.5694999694825,3.07660722732544 44.5694999694825,3.08346986770641 44.560317993164,3.07490944862366 44.5332908630372,3.07623744010931 44.5194625854493)) | 0.0006 | POINT(3.097497379779878 44.52519741058353) |