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 |
|---|---|---|---|
| 61455 | POLYGON((6.56712388992315 46.8163604736328,6.56156921386719 46.8211250305176,6.56156921386719 46.8211250305176,6.56959295272839 46.8288078308107,6.57034683227545 46.8313674926759,6.57281398773193 46.8339385986328,6.57913112640381 46.8373641967773,6.58290481567388 46.8379592895508,6.58290481567388 46.8379592895508,6.5857920646668 46.8343544006347,6.58530282974243 46.8313407897949,6.5919389724732 46.8306579589844,6.59962320327759 46.82719039917,6.59962320327759 46.82719039917,6.59906816482544 46.8249588012695,6.59906816482544 46.8249588012695,6.5933599472047 46.8249893188477,6.58168697357183 46.820899963379,6.57797718048101 46.8211975097657,6.57563018798839 46.8184394836426,6.57034301757812 46.8179168701172,6.56712388992315 46.8163604736328)) | 0.0006 | POINT(6.581303369431305 46.827147710891026) |
| 1409186 | POLYGON((-2.25362491607666 43.2679214477539,-2.2565860748291 43.2726249694824,-2.25537109374994 43.2741928100585,-2.25256299972528 43.2730026245118,-2.25167894363403 43.2758598327637,-2.25263595581055 43.279125213623,-2.25518393516541 43.2803840637208,-2.25479197502136 43.2823638916017,-2.25711393356323 43.2818298339843,-2.25876188278193 43.276123046875,-2.26100707054138 43.2758483886719,-2.26646089553833 43.281421661377,-2.26579809188837 43.2863502502441,-2.26338005065918 43.2865257263184,-2.26445293426514 43.288631439209,-2.28499007225037 43.2948608398438,-2.27930593490601 43.2954177856445,-2.26652693748463 43.3006935119629,-2.26152706146235 43.3012504577637,-2.25847291946411 43.3037490844728,-2.25319409370422 43.3029174804688,-2.24930596351618 43.3034706115722,-2.24819397926325 43.3051376342773,-2.24569392204279 43.3059730529785,-2.24624991416925 43.3034706115722,-2.24930596351618 43.3012504577637,-2.24902796745295 43.3001403808593,-2.24565696716309 43.3023910522462,-2.24065399169916 43.2961463928223,-2.22744202613819 43.29105758667,-2.22174906730646 43.2860412597656,-2.21878409385675 43.285743713379,-2.21228408813477 43.2813224792482,-2.21318411827087 43.274513244629,-2.21172094345087 43.2752227783204,-2.20722603797913 43.2730827331544,-2.22593092918396 43.2701797485353,-2.23374891281128 43.2757148742676,-2.24216794967646 43.2735824584962,-2.24679708480829 43.2699661254884,-2.25259208679199 43.2696800231935,-2.25362491607666 43.2679214477539)) | 0.0006 | POINT(-2.247832775115938 43.2859800385266) |
| 49751 | POLYGON((4.10166645050055 49.6857376098634,4.10757207870495 49.6975097656251,4.10352468490601 49.7063980102539,4.10352468490601 49.7063980102539,4.11088466644293 49.7154541015626,4.11282491683971 49.7256507873536,4.11959362030041 49.730926513672,4.11959362030041 49.730926513672,4.13609218597423 49.7303619384767,4.13609218597423 49.7303619384767,4.15095901489252 49.7281646728516,4.16631126403809 49.7296714782716,4.16631126403809 49.7296714782716,4.16248559951782 49.7181053161621,4.16594839096075 49.7125396728516,4.16594839096075 49.7125396728516,4.14047145843512 49.7085380554199,4.14188861846924 49.6987648010255,4.15105772018433 49.6906471252441,4.15105772018433 49.6906471252441,4.14430570602428 49.6866569519043,4.14669895172119 49.6778526306152,4.14669895172119 49.6778526306152,4.12702131271368 49.6779212951661,4.12702131271368 49.6779212951661,4.12407016754156 49.6835289001466,4.11512422561651 49.6842308044434,4.11512422561651 49.6842308044434,4.10166645050055 49.6857376098634)) | 0.0006 | POINT(4.13428119250711 49.70461463928228) |
| 69219 | POLYGON((9.25862026214605 54.2287635803222,9.24307632446295 54.2251434326172,9.23026943206798 54.2254371643067,9.23026943206798 54.2254371643067,9.22804450988781 54.2260360717773,9.22495651245123 54.2293815612793,9.22175979614263 54.2301559448243,9.22067642211908 54.2310409545899,9.22176551818859 54.2320518493652,9.21054840087891 54.2390594482422,9.20910930633551 54.2415466308594,9.20910930633551 54.2415466308594,9.21845340728765 54.2408180236816,9.23351478576666 54.2547645568848,9.23337554931635 54.2563438415528,9.23337554931635 54.2563438415528,9.25062847137451 54.2751007080079,9.25043487548834 54.2779350280763,9.25043487548834 54.2779350280763,9.25236034393311 54.276065826416,9.25578308105474 54.2755165100098,9.25637722015392 54.2746238708497,9.25637722015392 54.2746238708497,9.25521183013922 54.2671508789064,9.25112628936773 54.2630767822266,9.25194644927979 54.2596664428712,9.26348018646235 54.253833770752,9.26690101623541 54.2506256103516,9.26902389526373 54.2498474121093,9.27965450286877 54.2497634887696,9.27965450286877 54.2497634887696,9.27658271789551 54.2439765930177,9.27617549896246 54.2361679077148,9.27781963348394 54.2317276000976,9.27781963348394 54.2317276000976,9.25862026214605 54.2287635803222)) | 0.0006 | POINT(9.24642047882085 54.248657117571184) |
| 51660 | POLYGON((3.07837343215937 49.9663734436036,3.08107256889343 49.9648361206055,3.08107256889343 49.9648361206055,3.08728647232061 49.9342079162598,3.08409476280224 49.9314079284669,3.06833982467657 49.9298362731934,3.06833982467657 49.9298362731934,3.06375908851624 49.9390907287599,3.06508374214178 49.9627685546876,3.06508374214178 49.9627685546876,3.07428121566784 49.9676399230958,3.07837343215937 49.9663734436036)) | 0.0006 | POINT(3.07425338571726 49.95032743974173) |
| 1404110 | POLYGON((1.04039204120636 41.8574714660646,1.03912699222559 41.8544273376466,1.03657197952271 41.8545913696289,1.03527903556829 41.8528060913087,1.03101098537451 41.8523330688477,1.03135895729065 41.8544578552246,1.02894103527075 41.8558387756348,1.02503502368933 41.8517341613771,1.02111697196966 41.8505401611329,1.01997995376598 41.8389282226563,1.02458798885351 41.838478088379,1.02397298812872 41.8315391540528,1.02159297466272 41.8281478881837,1.01785504817974 41.8282699584961,1.01709198951727 41.8222084045411,1.0120799541474 41.813102722168,1.01184105873108 41.8208541870117,1.00696396827709 41.8215560913085,1.00851094722753 41.8264808654785,1.00197005271923 41.85884475708,0.99817997217184 41.8658485412599,0.985769987106323 41.8739433288574,0.975730001926365 41.8843498229982,0.978846013545933 41.8873748779297,0.977086007595005 41.8900985717773,0.980976998806057 41.8953056335449,0.98069399595272 41.902759552002,0.985300004482326 41.9078445434571,0.991291999816895 41.9103546142579,0.999579012394008 41.9069747924806,1.00558197498327 41.9100723266602,1.00988495349878 41.907527923584,1.01393795013433 41.9006652832032,1.01288902759546 41.8951110839844,1.01428198814398 41.8936767578125,1.02024900913244 41.8921699523927,1.02234494686138 41.8955917358398,1.02814805507671 41.8979797363282,1.03648304939276 41.8975257873536,1.03743994235992 41.894359588623,1.0392290353775 41.8938789367676,1.03896701335918 41.8874435424805,1.04323601722729 41.8806114196777,1.03979694843292 41.8780555725099,1.04221904277807 41.8681221008301,1.04039204120636 41.8574714660646)) | 0.0006 | POINT(1.0158538420995464 41.86956125895186) |
| 58482 | POLYGON((7.54245376586914 50.6207275390624,7.53973579406738 50.6205062866212,7.53583765029907 50.6228256225585,7.52952098846441 50.6224288940431,7.52952098846441 50.6224288940431,7.52576208114618 50.6185531616212,7.52648544311529 50.6163024902345,7.52487373352051 50.6127128601075,7.51908636093134 50.6113662719728,7.51832866668713 50.6090393066407,7.5140905380249 50.6075973510742,7.5140905380249 50.6075973510742,7.50884437561035 50.605770111084,7.50884437561035 50.605770111084,7.50796318054199 50.6033973693848,7.51383733749395 50.598487854004,7.51383733749395 50.598487854004,7.51465940475464 50.5982475280762,7.51465940475464 50.5982475280762,7.51282167434692 50.6004333496094,7.52096986770624 50.603343963623,7.5257425308227 50.6023864746095,7.52481794357311 50.6049118041992,7.5307497978211 50.6062088012696,7.53198480606073 50.6099319458008,7.53672885894781 50.6134567260743,7.54104900360102 50.6127319335938,7.53999233245844 50.6113090515137,7.54149150848389 50.6108779907227,7.54211950302135 50.6121368408204,7.54325151443481 50.611915588379,7.54325151443481 50.611915588379,7.54397439956671 50.6190643310547,7.54245376586914 50.6207275390624)) | 0.0006 | POINT(7.526708400610733 50.610033902255005) |
| 64505 | POLYGON((9.76377201080334 49.870304107666,9.7534294128418 49.864974975586,9.75338268280024 49.862590789795,9.75460433959961 49.8601608276368,9.7489910125733 49.8516006469727,9.74816036224365 49.8487281799316,9.74384784698498 49.8442993164062,9.74410915374767 49.8435821533204,9.74410915374767 49.8435821533204,9.7483806610108 49.840934753418,9.74984836578381 49.8422317504883,9.75273609161377 49.8408927917482,9.75543212890625 49.8419456481934,9.75900363922131 49.8395042419434,9.75961780548101 49.8376007080078,9.76199340820318 49.8369331359863,9.7634973526001 49.8377151489259,9.77453231811535 49.8347625732422,9.77884006500256 49.8378143310547,9.78126525878912 49.8384399414063,9.78202342987061 49.8360900878906,9.78670883178717 49.8334732055665,9.78616905212408 49.8323707580566,9.78963279724127 49.832347869873,9.79096221923834 49.8299713134766,9.7959499359132 49.8303718566896,9.7974424362182 49.82723236084,9.80120849609375 49.8283805847168,9.80370330810547 49.8270912170411,9.80386924743652 49.825267791748,9.80630302429199 49.8252639770508,9.80630302429199 49.8252639770508,9.81768512725841 49.8257904052734,9.82218933105469 49.8269424438477,9.82586574554449 49.8236541748046,9.82586574554449 49.8236541748046,9.82665729522716 49.8256568908691,9.83376979827875 49.8262557983399,9.83376979827875 49.8262557983399,9.83380603790289 49.8276672363281,9.83079147338879 49.8293762207031,9.83444499969477 49.8296852111816,9.83391475677502 49.8308258056641,9.83524513244629 49.8311576843263,9.83375930786133 49.8379249572754,9.82989692687988 49.8405723571777,9.82999038696295 49.8438034057618,9.82885360717779 49.8464431762696,9.83112049102783 49.8475456237794,9.83112049102783 49.8475456237794,9.83334636688232 49.8485641479493,9.83238697051996 49.8494949340821,9.83421516418468 49.8500633239746,9.83373069763195 49.850914001465,9.83616638183599 49.8528823852539,9.82945251464844 49.8572692871094,9.82944011688244 49.8591156005861,9.83108520507824 49.8619232177735,9.82644367218029 49.8653297424316,9.82908058166498 49.8698463439943,9.82816505432129 49.8725662231446,9.82816505432129 49.8725662231446,9.82029438018805 49.8729324340821,9.8193359375 49.8756446838379,9.81552219390863 49.8765945434571,9.81602096557617 49.8776931762695,9.81214427947998 49.8781204223633,9.812578201294 49.8789138793946,9.80847454071056 49.8796463012696,9.80872535705566 49.880599975586,9.80480194091791 49.8812980651857,9.80294322967541 49.8798751831056,9.79754447937012 49.8796348571777,9.79249858856201 49.8781890869142,9.7900829315185 49.8786506652833,9.78996849060064 49.8778953552247,9.78012943267828 49.8784980773926,9.77496719360346 49.8765029907227,9.77454853057873 49.8747100830079,9.76377201080334 49.870304107666)) | 0.0006 | POINT(9.800263718713722 49.849347030060216) |
| 34544 | POLYGON((4.03478765487671 49.063892364502,4.02605581283564 49.0755958557129,4.02767801284801 49.0787200927735,4.0143923759461 49.0923042297363,4.0143923759461 49.0923042297363,4.03288888931274 49.0977287292481,4.04747629165655 49.0979270935059,4.04747629165655 49.0979270935059,4.07554292678833 49.0666656494141,4.07554292678833 49.0666656494141,4.06639719009411 49.059814453125,4.06800889968872 49.0510330200195,4.06800889968872 49.0510330200195,4.05769920349132 49.0506362915039,4.03478765487671 49.063892364502)) | 0.0006 | POINT(4.046881982258424 49.074446269444074) |
| 51800 | POLYGON((-0.846296072006169 46.1822547912598,-0.870703339576664 46.1793975830079,-0.874607861042023 46.1731262207032,-0.874607861042023 46.1731262207032,-0.887318432331085 46.1775970458984,-0.900526046752873 46.1871948242188,-0.900526046752873 46.1871948242188,-0.8861083984375 46.195858001709,-0.862323343753815 46.1978759765626,-0.862323343753815 46.1978759765626,-0.85271281003952 46.1985740661622,-0.84483414888382 46.1947212219239,-0.846296072006169 46.1822547912598)) | 0.0006 | POINT(-0.8719073086976815 46.18706639607754) |