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
51789POLYGON((-1.0845912694931 46.1087799072266,-1.07842743396759 46.0982360839844,-1.08921432495112 46.0939254760743,-1.08921432495112 46.0939254760743,-1.10312533378601 46.0948600769044,-1.10312533378601 46.0948600769044,-1.10847294330597 46.0973625183105,-1.11513996124268 46.1023597717285,-1.12152802944183 46.1026382446289,-1.12291598320007 46.1015281677247,-1.13180494308466 46.1020851135255,-1.13374900817871 46.1048622131348,-1.13597297668451 46.1059722900391,-1.13791704177856 46.1059722900391,-1.1393049955368 46.1037483215333,-1.14124894142151 46.1037483215333,-1.14486205577845 46.108470916748,-1.14152801036823 46.1095848083496,-1.14097094535828 46.110694885254,-1.13319504261017 46.1093063354492,-1.13097298145289 46.110694885254,-1.12541604042048 46.1112518310547,-1.12430596351624 46.1131858825683,-1.12430596351624 46.1131858825683,-1.11550176143641 46.1212768554689,-1.10343444347382 46.1173591613771,-1.10343444347382 46.1173591613771,-1.09429848194122 46.1160392761232,-1.0845912694931 46.1087799072266))0.0006POINT(-1.1184992492198746 46.1061883653914)
14406POLYGON((13.2477769851685 46.3186721801759,13.2396287918092 46.322078704834,13.2336282730104 46.3229866027833,13.2067518234253 46.3256263732911,13.1890592575074 46.3260231018068,13.1690330505372 46.325065612793,13.1478462219239 46.3167991638184,13.1292800903321 46.3148002624511,13.1221046447754 46.3149948120118,13.1221046447754 46.3149948120118,13.1136560440065 46.3020057678224,13.1136560440065 46.3020057678224,13.1052837371826 46.2965850830078,13.0993423461915 46.2893333435059,13.0966587066651 46.2843666076661,13.0966587066651 46.2843666076661,13.1006612777711 46.2812232971191,13.101324081421 46.2650527954103,13.098045349121 46.2514266967773,13.0929441452028 46.245891571045,13.0929441452028 46.245891571045,13.0993366241456 46.2467460632324,13.1153526306152 46.2404022216797,13.1153526306152 46.2404022216797,13.12073802948 46.2430305480958,13.1332902908325 46.2557716369629,13.1413068771363 46.2569007873536,13.1543102264404 46.26224899292,13.1543102264404 46.26224899292,13.1713027954102 46.2740859985352,13.1970958709717 46.2858009338378,13.1995134353638 46.2861480712891,13.1995134353638 46.2861480712891,13.1996583938599 46.2884521484376,13.2032690048219 46.2959251403809,13.205216407776 46.2979278564453,13.2161493301392 46.2967224121095,13.2277841567993 46.2974662780762,13.2375497817993 46.3034858703614,13.2399864196778 46.3068923950195,13.2409200668335 46.3149948120118,13.2477769851685 46.3186721801759))0.0006POINT(13.1583010975908 46.28760956554883)
38101POLYGON((1.44739186763769 49.9269561767579,1.4639413356781 49.934757232666,1.49405479431164 49.9383392333984,1.49814879894262 49.9439582824707,1.49814879894262 49.9439582824707,1.47308766841888 49.9458656311035,1.45061707496649 49.9582061767579,1.45061707496649 49.9582061767579,1.44719803333282 49.9547882080079,1.44719803333282 49.9547882080079,1.42647159099585 49.9360389709474,1.42647159099585 49.9360389709474,1.44739186763769 49.9269561767579))0.0006POINT(1.4602788885434892 49.944325129191135)
50525POLYGON((2.43282556533825 49.2839012145997,2.41760182380682 49.287353515625,2.40863800048839 49.2960586547853,2.40863800048839 49.2960586547853,2.41147041320801 49.2984008789062,2.40720891952515 49.303207397461,2.40720891952515 49.303207397461,2.44642210006725 49.3115806579591,2.4565155506134 49.3101272583008,2.4565155506134 49.3101272583008,2.45689892768871 49.2998352050782,2.45062041282659 49.2943420410157,2.45674061775219 49.2887306213378,2.45674061775219 49.2887306213378,2.44605684280407 49.2828216552735,2.43282556533825 49.2839012145997))0.0006POINT(2.4346734841665305 49.29696553548181)
14949POLYGON((7.88808488845825 44.0056686401367,7.89341211318964 44.0082855224611,7.89910078048706 44.0068092346192,7.91317319870001 44.007884979248,7.91317319870001 44.007884979248,7.93351316452026 43.9996452331544,7.93351316452026 43.9996452331544,7.93854808807367 43.9885826110841,7.94100713729858 43.9778594970703,7.919349193573 43.9774856567383,7.90836000442505 43.9799308776856,7.90378999710083 43.9823608398439,7.90267515182501 43.9840469360352,7.90371417999268 43.9858512878419,7.90368986129772 43.9885330200195,7.8975181579591 43.9953155517579,7.88820505142212 44.0012588500978,7.88808488845825 44.0056686401367))0.0006POINT(7.910636901855486 43.993944055893905)
57714POLYGON((6.19782209396368 50.1475296020508,6.19741201400757 50.1438713073731,6.20215654373169 50.1416702270508,6.20056772232056 50.1409454345704,6.20056772232056 50.1409454345704,6.19887733459473 50.1404113769532,6.19945669174206 50.1400566101075,6.19873476028454 50.1387481689453,6.18995809555054 50.1350364685059,6.18995809555054 50.1350364685059,6.18672466278082 50.1349792480469,6.1870694160462 50.1364250183105,6.18549299240124 50.139862060547,6.18733882904053 50.1409950256348,6.18587017059338 50.1427955627443,6.18253612518316 50.1441307067872,6.17861938476562 50.1443252563477,6.17609643936157 50.1407852172853,6.17231893539434 50.1409950256348,6.16938829421997 50.1417579650879,6.16935253143311 50.1435623168945,6.17099618911737 50.1438255310059,6.16997766494751 50.1451148986818,6.17142820358282 50.1453590393066,6.17045307159435 50.1476898193361,6.1688055992127 50.1474647521973,6.16518878936768 50.1506843566895,6.15643262863165 50.1496505737305,6.15287160873419 50.150089263916,6.15287160873419 50.150089263916,6.14852809906012 50.1518898010254,6.14220666885382 50.148006439209,6.14055442810053 50.1479797363282,6.14063596725464 50.1495246887206,6.13431167602545 50.1517791748047,6.13211345672607 50.1535530090332,6.13197660446178 50.1548805236816,6.13253259658825 50.1555442810059,6.13864850997925 50.1550903320314,6.14338970184326 50.1558570861816,6.14752292633057 50.1606292724611,6.14593458175665 50.1630935668946,6.14151048660278 50.1654205322267,6.13971138000488 50.1683349609375,6.14055919647222 50.1696395874023,6.14758443832409 50.1704559326172,6.14427185058594 50.1735038757325,6.14689493179327 50.1777763366699,6.15271997451794 50.1762504577637,6.15601634979254 50.1718482971191,6.1603417396546 50.1718177795411,6.16119194030762 50.1746253967286,6.16119194030762 50.1746253967286,6.16744947433472 50.174144744873,6.16912984848034 50.1732978820801,6.168360233307 50.1714782714844,6.173415184021 50.171112060547,6.17197322845465 50.1696968078614,6.17492294311529 50.1695098876953,6.17700242996216 50.1707077026368,6.18010520935059 50.1693115234375,6.18438148498535 50.1711921691895,6.18678331375128 50.1711654663085,6.18678331375128 50.1711654663085,6.18967819213879 50.1665191650391,6.1886568069458 50.1646423339845,6.19170904159557 50.1536521911622,6.1960906982423 50.1508255004883,6.19782209396368 50.1475296020508))0.0006POINT(6.168707868632189 50.155079112333446)
12806POLYGON((18.2515087127686 40.2292518615723,18.2495517730713 40.2200927734376,18.228717803955 40.2037467956544,18.228717803955 40.2037467956544,18.2255115509034 40.2024993896485,18.2222518920899 40.2041282653809,18.2124481201172 40.2097282409669,18.2030944824219 40.2185592651368,18.1959114074706 40.2216110229493,18.1901397705078 40.2294654846191,18.1887531280519 40.2344856262208,18.1890888214112 40.2373847961427,18.1890888214112 40.2373847961427,18.1929779052734 40.2369270324708,18.2111854553223 40.2386665344239,18.2197513580322 40.2410926818848,18.2312908172607 40.2541542053224,18.2312908172607 40.2541542053224,18.2440547943115 40.2469902038574,18.2440547943115 40.2469902038574,18.2464351654053 40.2350616455078,18.2515087127686 40.2292518615723))0.0006POINT(18.21884881882441 40.22886294410349)
73734POLYGON((16.3907012939453 46.3898658752442,16.4019622802734 46.3856735229492,16.4075736999511 46.3811874389649,16.4103622436523 46.3768730163575,16.4119262695312 46.3688354492189,16.4179573059083 46.3583450317384,16.4213981628419 46.3569412231446,16.4295845031739 46.3567237854005,16.43265914917 46.3547401428223,16.432830810547 46.3532333374023,16.4315338134766 46.3517036437989,16.4191074371339 46.3442916870117,16.4148864746095 46.3428649902344,16.4148864746095 46.3428649902344,16.4095478057862 46.3463821411133,16.3970184326172 46.3494987487794,16.3933849334717 46.3528861999513,16.3921909332276 46.3711738586426,16.3887596130371 46.3779296875001,16.3907012939453 46.3898658752442))0.0006POINT(16.411487980892822 46.36115867213205)
1390396POLYGON((-1.4572149515152 41.5770606994629,-1.45085597038269 41.5861396789551,-1.44919896125793 41.586753845215,-1.44788002967834 41.5922584533691,-1.44271302223206 41.594009399414,-1.44180798530579 41.5957527160645,-1.43193995952606 41.5954551696777,-1.43039000034321 41.5970191955566,-1.42099702358246 41.5955123901368,-1.41927003860468 41.5925331115724,-1.41927194595337 41.5855369567871,-1.41570496559143 41.584270477295,-1.41133594512939 41.5848693847656,-1.40929400920868 41.5824737548829,-1.39693403244013 41.581699371338,-1.38017797470093 41.5676612854004,-1.36829495429993 41.5651817321777,-1.33927404880524 41.5501365661622,-1.34242403507233 41.5441856384277,-1.35093200206751 41.5381927490234,-1.35515999793995 41.5317764282228,-1.36201798915857 41.5283508300782,-1.36127698421478 41.5258827209473,-1.36452996730799 41.5243186950684,-1.36496901512146 41.5210723876954,-1.36929500102997 41.5192527770997,-1.36819696426386 41.5153007507325,-1.36946201324463 41.5125541687012,-1.37255394458765 41.5101890563964,-1.37484300136566 41.511157989502,-1.37449204921717 41.5083808898926,-1.37620997428894 41.5071983337402,-1.38084101676941 41.5079765319825,-1.38087999820709 41.5040321350099,-1.38900494575495 41.5025062561036,-1.39157199859619 41.4985427856446,-1.39143002033234 41.496910095215,-1.38640701770777 41.4975700378419,-1.38445103168482 41.4933624267578,-1.39007604122156 41.490650177002,-1.38634097576136 41.4823570251465,-1.38830304145813 41.4819946289064,-1.38743305206293 41.4808502197267,-1.39082205295563 41.4779510498047,-1.38502800464624 41.4764099121094,-1.40160000324249 41.4531440734864,-1.41288101673126 41.4470748901368,-1.42069399356842 41.4511909484864,-1.41800498962391 41.4574050903321,-1.42623496055603 41.4637413024903,-1.4250500202179 41.4720497131348,-1.4288220405578 41.4785308837891,-1.43359398841858 41.4827575683595,-1.44477605819696 41.4885368347169,-1.4491200447082 41.5007820129396,-1.44500398635864 41.5080413818359,-1.44720995426178 41.5079994201661,-1.4483430385589 41.516227722168,-1.45674800872791 41.5291213989259,-1.45626699924463 41.5337982177734,-1.46015501022333 41.5472259521486,-1.4572149515152 41.5770606994629))0.0006POINT(-1.4040329847179205 41.52526029993279)
70258POLYGON((12.3707084655762 50.9905509948731,12.3684606552123 50.9853668212892,12.3702011108398 50.9846649169922,12.3621559143066 50.9810295104981,12.3589668273926 50.9829444885254,12.3557815551758 50.9813766479493,12.3557815551758 50.9813766479493,12.3521947860719 50.9793701171875,12.3487949371338 50.978858947754,12.3497524261475 50.9781875610352,12.3481426239014 50.9753608703614,12.3404378890991 50.9723129272461,12.3415069580079 50.969093322754,12.3448524475098 50.9650344848633,12.3464441299438 50.9652786254883,12.3490896224976 50.9608535766602,12.345027923584 50.9597663879394,12.345027923584 50.9597663879394,12.3450107574464 50.9579048156738,12.3433866500854 50.9553985595704,12.3456563949586 50.9540786743165,12.3456563949586 50.9540786743165,12.3477392196656 50.9555549621583,12.3507127761841 50.9538459777831,12.3622875213624 50.9590873718262,12.3698329925537 50.9596138000488,12.372498512268 50.9585609436036,12.372498512268 50.9585609436036,12.3766326904298 50.9617881774903,12.3738994598389 50.9639854431152,12.378077507019 50.9657821655273,12.3763074874878 50.9664306640626,12.3764619827271 50.9688491821289,12.3807973861695 50.969596862793,12.379158973694 50.9717292785646,12.3908777236938 50.9742126464844,12.395323753357 50.9783630371093,12.3918409347534 50.9838371276855,12.3903427124024 50.9834747314454,12.38538646698 50.9916915893556,12.38538646698 50.9916915893556,12.3834075927734 50.9903717041015,12.379532814026 50.9922256469728,12.3758163452149 50.9906044006349,12.3707084655762 50.9905509948731))0.0006POINT(12.364269495010403 50.97187527743256)