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.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlü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"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie 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"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
19492POLYGON((10.9417600631714 46.0377883911133,10.915807723999 46.0245628356934,10.9124813079835 46.0158386230469,10.9143514633179 46.0094680786134,10.9116802215577 46.0024909973145,10.9005355834962 45.9922752380371,10.9007291793824 45.9910888671875,10.9007291793824 45.9910888671875,10.9036636352539 45.9901237487794,10.9139986038209 45.9829177856446,10.9124526977539 45.9801101684571,10.9050979614258 45.9771499633789,10.8959150314331 45.9698181152345,10.8880462646484 45.9600067138672,10.8890275955201 45.9496803283693,10.8950538635254 45.9425392150879,10.9002180099488 45.943687438965,10.9116497039795 45.9501419067383,10.9315881729127 45.9658393859864,10.9348239898682 45.9708251953125,10.9348239898682 45.9708251953125,10.9472026824952 45.9760894775392,10.9472026824952 45.9760894775392,10.9529151916505 45.9796600341797,10.9480886459351 45.9852447509767,10.9434986114503 45.9926528930665,10.9436464309692 45.993766784668,10.9547386169434 46.0107078552247,10.9568481445312 46.0162315368653,10.9556932449341 46.0192642211914,10.953504562378 46.0207862854004,10.953504562378 46.0207862854004,10.9487638473511 46.0233535766602,10.9512920379639 46.0266418457032,10.9545869827271 46.0273323059083,10.9569892883301 46.0332107543945,10.9468574523926 46.0361404418946,10.9468574523926 46.0361404418946,10.9417600631714 46.0377883911133))0.0006POINT(10.928332228409653 45.99453594810088)
44991POLYGON((1.74706578254705 43.4175033569336,1.7393976449967 43.4204521179199,1.73313856124889 43.42777633667,1.73313856124889 43.42777633667,1.73083353042614 43.4180946350099,1.69964706897747 43.4167633056641,1.69397664070141 43.4115371704102,1.69397664070141 43.4115371704102,1.68988537788397 43.4069175720215,1.68988537788397 43.4069175720215,1.70372700691235 43.3934440612794,1.70372700691235 43.3934440612794,1.70706176757818 43.3954925537111,1.71995699405682 43.3943214416504,1.73287212848663 43.3860511779786,1.73287212848663 43.3860511779786,1.73405861854553 43.396053314209,1.74706578254705 43.4175033569336))0.0006POINT(1.7167776963290813 43.406478433048086)
17192POLYGON((8.60060596466076 44.9908943176271,8.59766578674328 44.9936141967775,8.59692001342779 44.9999542236329,8.5987977981568 45.0078659057618,8.60006618499767 45.0235900878907,8.59587860107433 45.0303382873536,8.58292388916027 45.0333862304688,8.55677986145025 45.033962249756,8.55677986145025 45.033962249756,8.5456809997558 45.028434753418,8.53987407684338 45.0272789001466,8.52692699432384 45.0141563415528,8.52692699432384 45.0141563415528,8.52373981475841 45.0106506347656,8.52296161651623 45.0084648132324,8.52283668518072 45.0043029785157,8.52491855621344 45.0025787353517,8.52344417572021 44.9941062927247,8.51741600036627 44.9844360351563,8.51741600036627 44.9844360351563,8.51942729949957 44.9833297729493,8.51942729949957 44.9833297729493,8.52075862884516 44.9839248657228,8.53164958953863 44.9831428527832,8.53841876983654 44.9808654785157,8.54119396209722 44.97900390625,8.56749534606934 44.9874801635743,8.58814144134521 44.9783515930176,8.58847904205334 44.9763946533204,8.59672737121593 44.9748420715333,8.59672737121593 44.9748420715333,8.59781646728527 44.9767951965331,8.59764289855968 44.9855728149415,8.59609031677246 44.9867286682129,8.59451198577887 44.9865989685059,8.59451580047607 44.9878692626954,8.59580898284918 44.9912872314454,8.60060596466076 44.9908943176271))0.0006POINT(8.561172768876427 44.9978629447319)
25656POLYGON((2.65831923484814 48.8385620117188,2.66233134269709 48.8501586914062,2.66233134269709 48.8501586914062,2.68228745460516 48.8492050170898,2.68228745460516 48.8492050170898,2.69726133346552 48.8542823791504,2.69726133346552 48.8542823791504,2.69864058494568 48.849105834961,2.69864058494568 48.849105834961,2.68568515777588 48.839412689209,2.67001152038574 48.8467445373536,2.66838622093201 48.8409118652344,2.66838622093201 48.8409118652344,2.65831923484814 48.8385620117188))0.0006POINT(2.679371522023129 48.84708052415114)
1390934POLYGON((-3.70986294746399 43.316707611084,-3.71334099769592 43.3199882507325,-3.71861505508423 43.319450378418,-3.72016406059265 43.3274650573732,-3.72938799858088 43.3283805847169,-3.73434710502619 43.3314170837403,-3.7322580814361 43.3473701477051,-3.72832798957819 43.3501472473146,-3.72355794906611 43.3484420776367,-3.72225904464722 43.3502159118652,-3.72540903091425 43.3546791076661,-3.72224092483521 43.3549499511719,-3.72041296958923 43.357925415039,-3.71329092979425 43.3619689941406,-3.71342301368708 43.3637924194337,-3.70714592933655 43.3588447570801,-3.69380402564997 43.3532791137696,-3.68512296676636 43.3516426086426,-3.6848669052124 43.3498306274415,-3.67919206619257 43.3498916625978,-3.67141389846802 43.3472213745118,-3.66307401657099 43.3516998291016,-3.65815091133118 43.3427505493165,-3.65802407264709 43.3330535888672,-3.65122294425959 43.3257522583008,-3.65152788162231 43.3221054077148,-3.64821410179127 43.3177909851074,-3.63693904876698 43.3104171752931,-3.64238190650934 43.3072280883789,-3.64355397224421 43.3039436340333,-3.64918303489685 43.3011016845703,-3.66485190391529 43.3032455444336,-3.67497110366816 43.3017997741699,-3.68215107917786 43.3088874816895,-3.6882910728454 43.3055534362794,-3.70986294746399 43.316707611084))0.0006POINT(-3.6903137411389673 43.33368399483822)
1389840POLYGON((-0.620837986469269 40.7561225891114,-0.626533985137939 40.7578887939453,-0.62878102064127 40.7569351196289,-0.638620018959045 40.7587699890137,-0.63967102766037 40.7621917724611,-0.63152498006815 40.7684288024902,-0.635142028331757 40.7723426818848,-0.638710975646916 40.7732276916504,-0.642629027366524 40.7773780822753,-0.650066018104496 40.7811775207521,-0.622482001781464 40.7987327575685,-0.61863899230957 40.799503326416,-0.615947008132821 40.7988815307617,-0.614974021911621 40.7955436706543,-0.611851990222874 40.7930564880371,-0.605068981647435 40.7921867370606,-0.60068899393076 40.7838439941407,-0.602392971515656 40.7798995971681,-0.581838011741638 40.7700576782227,-0.576336026191655 40.7714996337891,-0.579123020172119 40.7661247253417,-0.583195984363556 40.7629585266114,-0.597330987453347 40.7648963928223,-0.601595997810307 40.7674980163574,-0.611304998397827 40.7603950500489,-0.617489993572235 40.7606773376465,-0.620837986469269 40.7561225891114))0.0006POINT(-0.6151068095977161 40.77423917330231)
1388126POLYGON((-4.50295591354364 37.5691719055177,-4.5019741058349 37.5726852416993,-4.51291179656982 37.5827178955078,-4.51106119155878 37.5925483703613,-4.50813913345337 37.5976867675782,-4.48307323455811 37.6159400939943,-4.47196483612055 37.6196594238282,-4.45277404785156 37.6327285766602,-4.44468784332275 37.6452178955079,-4.42174816131592 37.6595497131348,-4.41165590286255 37.6696281433106,-4.40712594985962 37.6765060424804,-4.40766811370844 37.675121307373,-4.40318918228144 37.669174194336,-4.3999028205871 37.6674270629883,-4.39866304397577 37.6641578674318,-4.40183782577509 37.6473770141602,-4.40935182571405 37.6401596069337,-4.42412614822382 37.631519317627,-4.4239678382873 37.6226158142091,-4.42555522918701 37.6220474243165,-4.42635202407831 37.6163597106934,-4.42063903808594 37.6079025268555,-4.4185619354248 37.5999984741212,-4.41411304473871 37.5976524353027,-4.40755891799927 37.5906105041504,-4.40415620803833 37.5891380310059,-4.40347194671625 37.5901718139648,-4.39731216430658 37.5895690917969,-4.39663696289057 37.5880165100098,-4.38838195800781 37.58455657959,-4.39447402954102 37.5796089172364,-4.40264701843262 37.5775718688966,-4.40163516998285 37.5732040405274,-4.40469121932978 37.5676803588868,-4.41030311584473 37.563835144043,-4.41135787963867 37.5555763244629,-4.42412090301514 37.5528564453126,-4.45523118972778 37.5598487854005,-4.46459197998047 37.5649070739747,-4.46904087066645 37.5631942749025,-4.47718620300287 37.5628280639648,-4.4897351264953 37.5670585632325,-4.49734687805176 37.5672988891602,-4.50295591354364 37.5691719055177))0.0006POINT(-4.434179089286082 37.604161002419254)
27723POLYGON((0.355353653430939 48.8693084716797,0.350169271230754 48.8698692321778,0.325385868549404 48.8584403991699,0.325385868549404 48.8584403991699,0.299981206655616 48.8492012023926,0.291100353002605 48.8416862487793,0.291100353002605 48.8416862487793,0.297109961509761 48.8362159729004,0.297109961509761 48.8362159729004,0.323272913694382 48.8244590759278,0.36020228266716 48.8280143737794,0.36020228266716 48.8280143737794,0.376795679330826 48.8397903442384,0.372735321521702 48.8489418029785,0.375056862831116 48.8518447875978,0.375056862831116 48.8518447875978,0.376964122057075 48.8548583984376,0.359336853027401 48.8604278564454,0.355353653430939 48.8693084716797))0.0006POINT(0.3395733154482659 48.84718110826285)
29556POLYGON((4.53057956695568 46.310188293457,4.5436897277832 46.3151245117188,4.56118535995483 46.3319816589355,4.56118535995483 46.3319816589355,4.5629706382752 46.3384971618652,4.5629706382752 46.3384971618652,4.55385112762457 46.3392677307129,4.54349184036261 46.3463516235353,4.53401565551758 46.344654083252,4.52782440185553 46.3497543334962,4.52782440185553 46.3497543334962,4.51016616821289 46.3428382873535,4.50391626358032 46.3335609436036,4.50391626358032 46.3335609436036,4.52276134490972 46.3141174316407,4.53057956695568 46.310188293457))0.0006POINT(4.536689917246535 46.33467534383142)
21347POLYGON((0.288047045469398 44.8631782531738,0.275381296873149 44.8675880432129,0.256445854902267 44.8675193786621,0.239023059606552 44.8719787597656,0.243751078844184 44.859546661377,0.243751078844184 44.859546661377,0.224220633506775 44.8700256347657,0.222429364919606 44.8872756958008,0.228121533989963 44.892879486084,0.228121533989963 44.892879486084,0.267973214387894 44.8935585021973,0.292352020740566 44.8970947265626,0.300661891698837 44.8935050964355,0.300661891698837 44.8935050964355,0.305857211351395 44.8845481872559,0.291384935379085 44.8722343444825,0.288047045469398 44.8631782531738))0.0006POINT(0.26301147788766593 44.87917900085452)