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
1405744POLYGON((-0.614696025848389 38.4763603210449,-0.593895018100739 38.4604530334473,-0.591361999511719 38.4562683105469,-0.596620023250523 38.4459953308107,-0.60229301452631 38.4428215026855,-0.607854008674565 38.4347114562989,-0.61058497428894 38.4283027648926,-0.608716011047363 38.4235115051271,-0.605800986289978 38.4213066101075,-0.604888975620213 38.417293548584,-0.596301019191742 38.4089546203614,-0.584860026836338 38.4017715454102,-0.579024970531464 38.4012908935548,-0.577395975589752 38.3989982604981,-0.577814996242523 38.3977432250977,-0.597765028476715 38.3990364074708,-0.613146007061005 38.3971443176271,-0.624616980552616 38.3996315002443,-0.636241018772068 38.3964157104493,-0.646317005157414 38.4017181396484,-0.663554012775364 38.4072456359864,-0.67595499753952 38.4175987243653,-0.686860024929047 38.4240150451661,-0.705693006515446 38.4521751403809,-0.668482005596104 38.465847015381,-0.66566002368927 38.4695320129395,-0.662644982337952 38.4705696105958,-0.658685982227269 38.4756622314454,-0.655979990959167 38.4835014343262,-0.653243005275726 38.4858703613282,-0.655502021312714 38.4940338134766,-0.648678004741612 38.4965820312501,-0.643043994903564 38.4959449768068,-0.635432004928589 38.4980354309083,-0.631372988223973 38.502296447754,-0.630335986614227 38.4936981201172,-0.626684010028839 38.4892807006836,-0.626078009605408 38.4854125976562,-0.621421992778721 38.4823379516603,-0.619624018669128 38.4784851074219,-0.614696025848389 38.4763603210449))0.0006POINT(-0.6276281282305505 38.44694633483893)
14374POLYGON((13.0969028472902 46.354305267334,13.1076755523682 46.3511085510254,13.106939315796 46.3476753234864,13.11287689209 46.3350257873535,13.1143226623536 46.3339767456055,13.121259689331 46.3362770080567,13.1232032775879 46.3356742858887,13.1246747970581 46.3321571350097,13.1247358322144 46.3286476135254,13.1231451034547 46.3260002136232,13.1221046447754 46.3149948120118,13.1221046447754 46.3149948120118,13.1136560440065 46.3020057678224,13.1136560440065 46.3020057678224,13.1024293899537 46.3048477172852,13.0862598419189 46.3026924133301,13.0798301696777 46.3071784973145,13.075535774231 46.3239555358886,13.0820388793945 46.3301696777344,13.0812225341798 46.3338088989258,13.0797338485718 46.3344078063966,13.0797338485718 46.3344078063966,13.0919837951661 46.345314025879,13.0969028472902 46.354305267334))0.0006POINT(13.103740236033616 46.32746223781424)
31647POLYGON((1.50587201118481 48.1002578735352,1.50422835350037 48.0937652587891,1.51371145248413 48.0751838684083,1.49800300598145 48.0674514770508,1.49800300598145 48.0674514770508,1.49404716491711 48.0667877197265,1.49029469490063 48.0589981079102,1.49029469490063 48.0589981079102,1.47413480281836 48.0662803649903,1.46592807769775 48.0626525878906,1.46592807769775 48.0626525878906,1.44850647449499 48.0812072753907,1.4483460187912 48.0903434753417,1.4483460187912 48.0903434753417,1.4603803157807 48.0950431823731,1.46395087242126 48.1044082641602,1.47638869285583 48.1092567443848,1.47638869285583 48.1092567443848,1.48017287254345 48.1071090698243,1.49902105331427 48.1106185913087,1.50128185749065 48.1015014648437,1.50587201118481 48.1002578735352))0.0006POINT(1.481106105304944 48.08474131992887)
17676POLYGON((7.0192632675172 44.2322006225587,7.00701284408581 44.2378311157227,7.00573158264166 44.2394599914551,7.01095008850109 44.2438507080079,7.00334692001343 44.2794570922852,7.00003385543835 44.2817916870118,7.00003385543835 44.2817916870118,7.02794599533092 44.2997169494629,7.05516719818115 44.3099632263185,7.05828905105602 44.3121376037598,7.05828905105602 44.3121376037598,7.0620107650758 44.31205368042,7.07791185379034 44.3070831298828,7.08227014541626 44.3048782348634,7.10065317153931 44.3040008544922,7.12446403503424 44.3216667175293,7.11696815490734 44.3417320251465,7.11919784545898 44.348487854004,7.12158679962164 44.3516502380372,7.12158679962164 44.3516502380372,7.12383413314819 44.3529663085939,7.13063907623297 44.35408782959,7.13362789154058 44.3517341613771,7.15034294128418 44.3472328186035,7.155846118927 44.3467597961427,7.15795612335205 44.3476486206054,7.1657338142395 44.3466644287111,7.16910982131958 44.3451957702637,7.17272377014154 44.3405342102051,7.18050479888927 44.3358612060547,7.18878078460699 44.3349380493164,7.18878078460699 44.3349380493164,7.190260887146 44.3249855041504,7.20333719253546 44.3172454833985,7.20981884002691 44.3039398193361,7.20802307128906 44.3005027770996,7.19815301895153 44.2957763671874,7.19423103332531 44.2926368713379,7.19007587432867 44.2872314453125,7.19444084167486 44.2752189636232,7.20101499557501 44.248291015625,7.20233297348034 44.245189666748,7.21411800384527 44.2352676391603,7.22096300125128 44.2326164245606,7.22096300125128 44.2326164245606,7.21442222595215 44.2247390747071,7.2140908241272 44.2151908874511,7.2133898735047 44.2123260498047,7.21118688583385 44.2098464965821,7.19785118103027 44.2023506164552,7.18975400924688 44.1998863220216,7.19014215469372 44.198757171631,7.19014215469372 44.198757171631,7.18752384185802 44.1992721557617,7.18702888488764 44.2002639770508,7.18420553207409 44.1999282836915,7.16681098937983 44.2031898498535,7.16027832031244 44.2057266235353,7.14189577102667 44.2017707824708,7.11844968795788 44.2146682739259,7.09947633743286 44.2201690673829,7.0764427185058 44.2317581176758,7.03768634796148 44.2255668640137,7.02387666702282 44.2334442138672,7.0192632675172 44.2322006225587))0.0006POINT(7.136609070003084 44.276581764221234)
63492POLYGON((11.8758172988893 53.3151855468751,11.8767547607421 53.3163604736329,11.8753662109376 53.3180465698243,11.8808250427247 53.3212318420411,11.8779172897339 53.321849822998,11.8848867416383 53.3257713317872,11.8832178115846 53.3266716003419,11.8801212310791 53.3260650634767,11.8805980682373 53.326904296875,11.885199546814 53.3280677795411,11.8871860504151 53.3301391601562,11.8841390609742 53.3373374938965,11.8881845474244 53.3389396667482,11.8948621749878 53.3392143249512,11.9035291671752 53.3416137695312,11.9109735488892 53.3339309692382,11.9130029678346 53.3349418640138,11.9220285415649 53.3307495117188,11.9308462142945 53.3308525085449,11.933165550232 53.3315353393555,11.9360389709473 53.3344421386719,11.9357633590698 53.3388862609864,11.9321670532227 53.3405380249024,11.9364280700684 53.343147277832,11.9433231353761 53.3436317443848,11.9473838806153 53.3474235534668,11.9485120773317 53.3502235412599,11.9526872634888 53.353572845459,11.9526872634888 53.353572845459,11.9402875900269 53.3582649230957,11.9417371749878 53.3598594665528,11.9406099319458 53.3612289428711,11.936469078064 53.3628158569337,11.9352531433105 53.3642234802246,11.9333486557008 53.3643531799316,11.931742668152 53.3662605285644,11.9290332794191 53.3666038513185,11.9283199310303 53.3691558837891,11.9138879776002 53.3746376037599,11.9068603515626 53.3748626708985,11.8867483139039 53.3786582946777,11.8803367614746 53.3808059692384,11.8803367614746 53.3808059692384,11.879017829895 53.3795166015624,11.8774518966675 53.3803901672363,11.8693885803224 53.3768386840821,11.8584384918213 53.3683319091797,11.8473958969116 53.3708992004395,11.8473958969116 53.3708992004395,11.8472909927368 53.3664855957032,11.8448648452759 53.3608856201172,11.8395462036134 53.3554763793946,11.8343124389649 53.3547897338867,11.8317060470582 53.3525695800782,11.8288841247559 53.3516654968262,11.8270015716553 53.3485221862792,11.8217506408691 53.3477439880372,11.8189392089845 53.3446464538575,11.8166399002075 53.3441047668458,11.8142375946045 53.3421325683593,11.8142375946045 53.3421325683593,11.8127803802491 53.3406219482422,11.8153114318848 53.3383636474609,11.8200664520263 53.3391761779785,11.8216361999512 53.3404350280762,11.8372344970704 53.3332824707032,11.8432054519654 53.3321113586427,11.843731880188 53.3341102600098,11.8456974029542 53.3340530395508,11.845295906067 53.3307685852052,11.8438758850098 53.3309822082519,11.8429737091065 53.329444885254,11.8391466140747 53.3305130004883,11.8379993438721 53.3283309936524,11.8503618240356 53.3270072937012,11.8439693450928 53.3202552795411,11.8435268402099 53.3170776367188,11.8435268402099 53.3170776367188,11.8630943298341 53.3163414001465,11.8700017929078 53.3149795532227,11.8712253570558 53.3162078857422,11.8731899261475 53.3146820068359,11.8758172988893 53.3151855468751))0.0006POINT(11.8788406790757 53.34374679007183)
53258POLYGON((5.86404752731323 43.9456443786622,5.86545133590704 43.9368705749513,5.86545133590704 43.9368705749513,5.87485647201532 43.9222068786622,5.87485647201532 43.9222068786622,5.86760759353638 43.918041229248,5.85355329513555 43.9172630310058,5.82651424407965 43.922435760498,5.82651424407965 43.922435760498,5.81759357452404 43.9294891357422,5.82921123504633 43.9428977966309,5.82921123504633 43.9428977966309,5.85587120056158 43.9491271972657,5.86404752731323 43.9456443786622))0.0006POINT(5.850056905012882 43.931414384108365)
1405308POLYGON((-2.36924290657038 42.6354103088379,-2.36589503288269 42.6370315551758,-2.36547589302057 42.6352462768555,-2.36924290657038 42.6354103088379))0.0006POINT(-2.3668712774912133 42.6358960469564)
58825POLYGON((7.79782390594482 51.1471099853517,7.7965984344483 51.1472587585449,7.79243946075451 51.1442184448243,7.77901363372803 51.1427650451661,7.7731142044068 51.1442642211915,7.76421213150024 51.1442451477051,7.75437831878656 51.1471481323243,7.74564170837402 51.1436309814454,7.73518848419195 51.1427421569824,7.7271151542663 51.1439476013184,7.72297906875616 51.1429862976075,7.72109460830694 51.1402854919434,7.71520853042603 51.1398735046387,7.71056795120239 51.1468124389648,7.71256446838379 51.1528663635254,7.70673227310192 51.1557960510255,7.70053434371954 51.1550636291505,7.69600343704235 51.156593322754,7.69141960144037 51.1563949584962,7.69141960144037 51.1563949584962,7.68173789978027 51.1552696228027,7.67997646331798 51.1559829711914,7.6805472373963 51.1576538085937,7.67669534683228 51.1585960388184,7.67602443695068 51.1573905944824,7.67024660110479 51.1558837890626,7.67024660110479 51.1558837890626,7.6688666343689 51.1536369323731,7.66402482986456 51.152744293213,7.66200399398815 51.1537132263185,7.65567207336426 51.1491203308107,7.65326404571533 51.1487007141114,7.64765644073492 51.1426010131836,7.6429014205932 51.1396408081055,7.63909244537354 51.1392059326172,7.64199733734142 51.1385192871095,7.64182043075567 51.1346702575683,7.63876342773443 51.1338844299318,7.64192819595331 51.1310729980469,7.63733673095703 51.1266479492188,7.63598680496222 51.1278839111329,7.63222312927252 51.1260452270508,7.63568687438976 51.1241760253907,7.63667964935314 51.1222381591797,7.63276290893566 51.1217193603516,7.63162565231323 51.1195297241211,7.62885093688959 51.1213607788087,7.62523508071905 51.1219825744629,7.62400627136236 51.1208076477051,7.61859083175665 51.1229896545411,7.61573648452764 51.1208114624025,7.61757946014404 51.1199378967286,7.61850404739386 51.1181869506836,7.6158452033996 51.1179237365723,7.61663389205944 51.1153678894044,7.61562538146973 51.1147956848146,7.61395359039312 51.115447998047,7.61357975006109 51.116626739502,7.61157131195068 51.1155662536622,7.60966157913202 51.1166000366212,7.6079015731811 51.1156921386718,7.60736227035522 51.1142463684083,7.60854959487909 51.1115036010742,7.60258579254162 51.1119422912599,7.60261678695684 51.1107635498047,7.60425376892084 51.1108932495118,7.60438871383673 51.1101036071777,7.60013484954834 51.1081428527833,7.59919881820684 51.1064186096193,7.60116004943848 51.1061630249023,7.60115957260143 51.105251312256,7.59801816940308 51.1042633056641,7.59734439849859 51.102466583252,7.60223531723028 51.100456237793,7.60223531723028 51.100456237793,7.6062645912171 51.0979881286622,7.60581827163702 51.0973854064942,7.60683012008667 51.0962104797364,7.60280084609985 51.0925178527831,7.60417413711554 51.0918045043946,7.60421514511108 51.0904197692871,7.60183858871466 51.09033203125,7.6006970405578 51.0880813598633,7.59936141967779 51.0874710083008,7.60262107849127 51.084327697754,7.60051202774048 51.0837211608888,7.60118246078486 51.0825271606445,7.60061073303228 51.0814170837403,7.60470056533813 51.0797309875488,7.61036109924322 51.0798988342286,7.60989856719982 51.0776062011719,7.60989856719982 51.0776062011719,7.6179404258728 51.0753402709962,7.62637662887585 51.0685234069824,7.63515615463257 51.0708541870118,7.63900995254517 51.0745697021485,7.64065313339239 51.0724563598633,7.64852523803711 51.0733375549317,7.65881633758551 51.07719039917,7.66119384765625 51.0764083862305,7.67581367492681 51.0804748535157,7.67947578430187 51.0805244445801,7.68686819076538 51.0832099914551,7.68687963485729 51.086036682129,7.69183969497686 51.0865020751953,7.69622421264654 51.0821990966797,7.70025253295904 51.0807762145997,7.70209789276123 51.0791015625,7.70844984054571 51.0775871276857,7.71612071990978 51.0729103088379,7.71612071990978 51.0729103088379,7.72194004058844 51.0741577148438,7.72630023956293 51.074031829834,7.74129343032848 51.071617126465,7.74216413497925 51.0735549926758,7.74868774414057 51.0736808776855,7.74933767318737 51.0721282958985,7.7516646385194 51.071689605713,7.7571578025819 51.0737648010255,7.77447080612183 51.0751228332521,7.77405071258551 51.0766716003419,7.77550935745245 51.0771484375001,7.78339672088629 51.0754776000977,7.7877082824707 51.0794563293458,7.79258108139044 51.0780105590821,7.79422760009777 51.0762481689453,7.79755163192743 51.0748863220215,7.8030571937561 51.0755615234376,7.80943775177013 51.0725059509277,7.81332445144653 51.0727577209473,7.81792545318615 51.0749855041504,7.81792545318615 51.0749855041504,7.822741508484 51.0824089050292,7.81916522979748 51.0859107971192,7.82216262817394 51.0901908874513,7.81979036331188 51.091407775879,7.82073307037359 51.0924110412598,7.81952238082891 51.0960388183593,7.8282904624939 51.1034049987793,7.82615518569958 51.1074447631837,7.82037639617926 51.1086959838867,7.82272243499756 51.1143684387208,7.82509565353394 51.1146392822266,7.82675886154186 51.1160545349122,7.82589578628546 51.1168823242188,7.82790899276733 51.1179351806642,7.82619762420649 51.1193275451661,7.8283109664917 51.1198921203614,7.829583644867 51.1186599731446,7.83141231536877 51.1187019348145,7.83126449584967 51.1205253601075,7.82950782775885 51.120719909668,7.82973718643188 51.1217041015626,7.82630491256708 51.1234207153321,7.831220626831 51.1227645874023,7.83282518386847 51.1252174377442,7.83439922332758 51.1257019042969,7.83437156677252 51.1234512329103,7.8355798721314 51.1230926513673,7.83944988250738 51.1252059936525,7.83796548843395 51.127628326416,7.83311128616339 51.1309204101564,7.82809400558483 51.1318244934082,7.82885885238653 51.1292114257814,7.82475471496588 51.1304321289062,7.81696939468389 51.1379890441895,7.81447649002075 51.139129638672,7.81290006637585 51.1445846557618,7.80676984786987 51.1444168090821,7.80151081085205 51.1467247009277,7.79782390594482 51.1471099853517))0.0006POINT(7.706509076847783 51.11139658759623)
1389326POLYGON((0.605181992054042 42.0891914367676,0.601406991481781 42.0900192260743,0.610760986805019 42.0952796936036,0.599198997020778 42.0966796875001,0.595943987369594 42.099880218506,0.592939972877502 42.1111145019531,0.579990029335136 42.123161315918,0.594790995121116 42.1320457458496,0.597243010997829 42.1362533569337,0.600337982177791 42.1377143859863,0.606544017791748 42.1502876281738,0.611375987529868 42.1533164978028,0.614494025707359 42.1517639160156,0.621384024620113 42.1526832580567,0.628840982913971 42.1493415832519,0.636004984378928 42.1438484191895,0.65547102689743 42.1394195556641,0.671886980533714 42.123935699463,0.685155987739563 42.1237297058107,0.697847008705253 42.1250038146973,0.698005974292812 42.1264724731446,0.702202022075653 42.1219062805176,0.699579000473079 42.1069831848146,0.694935977459011 42.101360321045,0.69558101892477 42.0991439819336,0.685069978237152 42.0917663574219,0.679265022277832 42.076057434082,0.668844997882843 42.0611763000489,0.667935013771171 42.0521087646486,0.66857302188879 42.0489158630372,0.671205997467155 42.047420501709,0.66604799032217 42.0417785644532,0.656777024269218 42.0403900146484,0.656545996665955 42.0315475463868,0.651740014553013 42.0262680053711,0.656953990459499 42.0148544311524,0.663914978504181 42.0145530700684,0.657316982746238 42.0016174316406,0.646620988845882 41.9967613220215,0.644378006458339 41.9923667907714,0.645371973514557 41.9871482849122,0.641955018043632 41.9820899963379,0.642062008380947 41.9869041442872,0.638568997383118 41.9946212768555,0.623799979686851 41.9917869567871,0.616940021514836 41.9872207641602,0.613942980766296 41.9895019531251,0.613038003444785 41.9946174621583,0.611163973808402 41.994785308838,0.609578013420162 41.9921531677247,0.60314899682993 41.9931030273438,0.601593971252498 41.9948539733887,0.593933999538478 41.9951477050781,0.59170001745224 41.9998741149903,0.586881995201225 41.9978981018066,0.582729995250816 41.9996223449707,0.575320005416984 42.0065460205079,0.573251008987484 42.0124969482422,0.574324011802616 42.0219459533691,0.584744989872092 42.0223579406738,0.591780006885642 42.0246353149415,0.595529019832668 42.02836227417,0.600035011768341 42.0292472839356,0.602560997009391 42.0356597900391,0.602442026138363 42.0423088073732,0.612111985683441 42.0594749450685,0.609448015689907 42.0606536865235,0.600058019161281 42.059986114502,0.604378998279628 42.068630218506,0.604012012481803 42.077522277832,0.60614097118372 42.080955505371,0.602729022503013 42.0819816589357,0.605181992054042 42.0891914367676))0.0006POINT(0.6276884724697006 42.058502939012335)
51633POLYGON((3.0545551776886 49.8962020874024,3.05063247680664 49.8812637329102,3.05063247680664 49.8812637329102,3.03809595108032 49.8859405517579,3.03138780593872 49.8977813720704,3.03138780593872 49.8977813720704,3.0545551776886 49.8962020874024))0.0006POINT(3.0427819490432735 49.890038808186915)