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
52967POLYGON((0.598648011684475 46.5283393859864,0.606265425682182 46.519546508789,0.603135943412781 46.5093994140626,0.600368022918701 46.5064773559571,0.585464775562343 46.5059661865236,0.562396049499625 46.4992866516113,0.566495537757987 46.4869422912598,0.566495537757987 46.4869422912598,0.560007691383362 46.4759941101074,0.560007691383362 46.4759941101074,0.584137678146362 46.4640808105469,0.629647672176361 46.4548301696777,0.629647672176361 46.4548301696777,0.639265954494533 46.4623870849609,0.653966009616852 46.4643211364747,0.66346400976181 46.4623260498046,0.676944673061428 46.4665832519531,0.699679970741272 46.4598197937012,0.699679970741272 46.4598197937012,0.716842532157955 46.475513458252,0.696609258651733 46.4837646484376,0.696609258651733 46.4837646484376,0.678063333034629 46.4883880615235,0.673181593418178 46.5052871704102,0.658576130867118 46.5145492553712,0.657809615135193 46.5247917175292,0.650336265563965 46.5337562561035,0.641115009784755 46.5362968444824,0.635677814483643 46.542163848877,0.619487881660461 46.5347213745118,0.610231816768703 46.5374221801759,0.610231816768703 46.5374221801759,0.598648011684475 46.5283393859864))0.0006POINT(0.6322028320283071 46.495054006576574)
22543POLYGON((-0.222235918044987 43.7188720703126,-0.194143295288029 43.737018585205,-0.194143295288029 43.737018585205,-0.196676880121174 43.746795654297,-0.218864366412163 43.7503280639648,-0.218864366412163 43.7503280639648,-0.235686436295452 43.7437400817871,-0.26881563663477 43.7417526245117,-0.29014641046524 43.7495574951172,-0.294685631990376 43.7485542297364,-0.290816873311996 43.7428550720215,-0.292782217264175 43.7396621704102,-0.292782217264175 43.7396621704102,-0.277722775936127 43.7320022583008,-0.276536941528263 43.7253913879395,-0.284564733505249 43.7090377807618,-0.3006731569767 43.7024612426758,-0.302607446908894 43.6923065185547,-0.316402703523636 43.6919746398927,-0.316347241401559 43.6852340698242,-0.316347241401559 43.6852340698242,-0.317977964878082 43.6694679260255,-0.312651097774506 43.6605949401855,-0.312651097774506 43.6605949401855,-0.305975228547993 43.6498107910156,-0.305975228547993 43.6498107910156,-0.29766833782196 43.648136138916,-0.285245746374073 43.6518898010255,-0.274568200111389 43.6458358764649,-0.282111585140228 43.6430778503419,-0.282111585140228 43.6430778503419,-0.266967505216542 43.6369438171387,-0.263361573219299 43.6387252807617,-0.261803299188614 43.6479492187501,-0.261803299188614 43.6479492187501,-0.259197652339935 43.653160095215,-0.246275529265404 43.6549453735352,-0.24327561259264 43.6639595031738,-0.24327561259264 43.6639595031738,-0.239730194211006 43.671241760254,-0.239730194211006 43.671241760254,-0.253921031951904 43.6729431152344,-0.256714046001434 43.6758041381837,-0.254545480012894 43.6826248168945,-0.241215929389 43.6926765441895,-0.247380658984184 43.7092437744142,-0.222235918044987 43.7188720703126))0.0006POINT(-0.26865172774893026 43.69077068826428)
29962POLYGON((3.02312183380138 48.1356735229492,3.01322984695429 48.1434783935547,3.00388574600231 48.1448631286622,3.00388574600231 48.1448631286622,3.00547289848339 48.1516380310059,3.00008058547979 48.1647758483887,2.98970913887035 48.1717300415039,2.99079585075384 48.188190460205,2.99079585075384 48.188190460205,2.99818325042736 48.1926078796387,3.01589179039013 48.1875953674318,3.02801871299755 48.1933326721193,3.03212213516247 48.1914596557618,3.03212213516247 48.1914596557618,3.04201173782354 48.1898460388184,3.06622338294983 48.1921043395997,3.06622338294983 48.1921043395997,3.06689262390137 48.1786956787111,3.07834649086004 48.1727333068849,3.06896352767944 48.1573333740236,3.06896352767944 48.1573333740236,3.05723690986645 48.145362854004,3.05723690986645 48.145362854004,3.03882837295544 48.1427803039552,3.02312183380138 48.1356735229492))0.0006POINT(3.030760099490554 48.16931311289477)
48786POLYGON((0.233928173780441 47.6454544067382,0.231156140565929 47.6428833007813,0.218010514974651 47.6555061340332,0.218010514974651 47.6555061340332,0.210162207484359 47.64754486084,0.210660845041389 47.6311302185059,0.201909482479095 47.6155815124513,0.201909482479095 47.6155815124513,0.20454411208641 47.605972290039,0.209402084350643 47.6055221557618,0.212617486715317 47.6117858886719,0.217307761311588 47.6127700805665,0.230001732707024 47.6083984375001,0.230001732707024 47.6083984375001,0.232709124684447 47.6108932495118,0.259114831686077 47.6123008728028,0.259114831686077 47.6123008728028,0.258225828409195 47.625717163086,0.250530570745582 47.634407043457,0.253687441349086 47.6434898376465,0.233928173780441 47.6454544067382))0.0006POINT(0.22715024501090406 47.62505722045905)
60053POLYGON((8.97414207458496 47.1090660095215,8.96226501464849 47.104404449463,8.95768833160406 47.0986061096192,8.9582138061524 47.0968894958497,8.96293830871593 47.0937614440917,8.9740829467774 47.0913734436036,8.97545337677002 47.090087890625,8.96928882598888 47.0853958129883,8.96570873260498 47.0811958312988,8.96364688873302 47.0756759643556,8.95485687255871 47.0668487548829,8.95310401916504 47.063316345215,8.95074844360363 47.0536842346193,8.95074844360363 47.0536842346193,8.95315742492681 47.0497360229493,8.9557256698609 47.0482254028321,8.97449016571045 47.0482749938965,8.99213600158686 47.0589485168458,8.99635982513433 47.0602226257324,8.99635982513433 47.0602226257324,9.01058387756359 47.062110900879,9.02378463745123 47.0656547546387,9.02733039855963 47.0680122375488,9.02882957458507 47.0706253051758,9.03691577911383 47.0776100158691,9.04610157012945 47.0809097290039,9.05024433135986 47.0810165405275,9.05577087402355 47.0789260864259,9.06211662292486 47.0796012878419,9.06211662292486 47.0796012878419,9.06233501434338 47.0856285095215,9.07296943664562 47.0996856689454,9.07323265075689 47.1141357421875,9.07598972320568 47.1179504394531,9.07598972320568 47.1179504394531,9.07375812530523 47.1197624206543,9.06851196289068 47.1192588806153,9.06685924530035 47.1177215576172,9.06645870208735 47.1122856140137,9.06381225585932 47.1109046936036,9.05628967285162 47.1103515625001,9.04812335968018 47.1072654724122,9.03580188751226 47.1070365905762,9.0290641784668 47.1028366088867,9.0128259658814 47.1004104614258,9.00298595428478 47.1003532409669,8.98732280731207 47.1027641296387,8.9825963973999 47.1042938232423,8.97414207458496 47.1090660095215))0.0006POINT(9.012496590614374 47.087172587712644)
72765POLYGON((15.9423007965089 46.861972808838,15.968116760254 46.8656234741212,15.9754838943482 46.8654823303223,15.9816942214965 46.8614654541016,16.0001544952393 46.8447952270508,16.0001544952393 46.8447952270508,16.0046882629396 46.8752288818361,16.0073795318604 46.8787002563476,16.0178394317628 46.8866348266602,16.0178394317628 46.8866348266602,16.0309123992919 46.8916130065918,16.0309123992919 46.8916130065918,16.0183753967286 46.9007568359376,16.0107154846191 46.9040031433105,16.0041313171388 46.9037399291992,15.986330986023 46.8995780944825,15.9792289733887 46.8991775512695,15.9773426055909 46.9006233215333,15.9738359451295 46.9086570739747,15.9690771102906 46.9119606018068,15.9633111953735 46.9136543273927,15.9595232009889 46.913185119629,15.9558620452881 46.9112930297853,15.9390192031861 46.8954963684083,15.9390192031861 46.8954963684083,15.9287977218627 46.8957290649414,15.9287977218627 46.8957290649414,15.927640914917 46.8933448791504,15.9286842346191 46.8913726806641,15.9378747940065 46.8864707946777,15.9406328201295 46.883773803711,15.9423007965089 46.861972808838))0.0006POINT(15.975666999816934 46.88898714127084)
69869POLYGON((9.90358066558849 54.1107444763184,9.89932823181164 54.107723236084,9.89237117767334 54.1078758239746,9.89036750793457 54.1069526672363,9.89118289947521 54.1065521240236,9.87973785400402 54.1032066345216,9.87426567077642 54.1011428833008,9.87169742584234 54.0991096496582,9.86432266235357 54.0966453552246,9.86264991760248 54.0981636047363,9.86051750183105 54.0977325439454,9.86051750183105 54.0977325439454,9.86088848114019 54.0953788757325,9.85703659057617 54.0851669311524,9.85446739196783 54.0812644958497,9.85177230834972 54.0695037841797,9.85177230834972 54.0695037841797,9.85412311553966 54.0695800781251,9.86678123474121 54.0633926391602,9.86415004730225 54.061637878418,9.87530326843273 54.0610733032227,9.88549804687494 54.0581398010254,9.91393661499029 54.0639991760254,9.92222404479992 54.0630569458009,9.92968463897705 54.0634536743165,9.92968463897705 54.0634536743165,9.93074703216558 54.0662956237793,9.93418598175055 54.0684051513673,9.93572139739996 54.075927734375,9.93388557434088 54.0819740295411,9.93383407592768 54.0859336853027,9.92568111419689 54.0947952270508,9.93044948577892 54.0993003845215,9.92874908447277 54.0996704101563,9.92878437042236 54.1027412414551,9.92878437042236 54.1027412414551,9.92646884918224 54.10453414917,9.92757225036632 54.1089057922364,9.92537498474121 54.1097564697266,9.90620517730719 54.1088943481445,9.90358066558849 54.1107444763184))0.0006POINT(9.896607637405447 54.087801551818885)
12938POLYGON((15.7211885452271 40.3277702331544,15.709758758545 40.3375701904297,15.7055807113647 40.3432426452638,15.705122947693 40.3602104187013,15.7062196731569 40.36576461792,15.7103366851808 40.3709373474121,15.7109537124634 40.3782958984375,15.68195438385 40.3943977355957,15.68195438385 40.3943977355957,15.7215051651002 40.3953971862793,15.7261695861817 40.3932266235352,15.724835395813 40.390811920166,15.7449645996094 40.390811920166,15.7533226013185 40.3843193054199,15.7622852325439 40.3755149841309,15.7782726287842 40.3630714416505,15.7838687896729 40.3597946166992,15.7977781295776 40.3701515197755,15.7977781295776 40.3701515197755,15.8085107803345 40.357967376709,15.814588546753 40.3562088012695,15.814588546753 40.3562088012695,15.7550792694093 40.3358268737792,15.7211885452271 40.3277702331544))0.0006POINT(15.74420074794607 40.36834998752763)
42148POLYGON((6.51926946640015 48.9699325561523,6.49018573760986 48.9674377441406,6.49018573760986 48.9674377441406,6.50322914123547 48.9808349609375,6.50228881835938 48.9869651794435,6.50228881835938 48.9869651794435,6.50654840469372 48.9902992248535,6.50654840469372 48.9902992248535,6.5181827545166 48.9861869812013,6.5181827545166 48.9861869812013,6.51926946640015 48.9699325561523))0.0006POINT(6.505691003799474 48.98125457763676)
38258POLYGON((0.761436581611576 49.812313079834,0.745447874069328 49.8060684204103,0.745447874069328 49.8060684204103,0.740046143531799 49.8139038085939,0.740046143531799 49.8139038085939,0.734888434410095 49.8205871582032,0.734888434410095 49.8205871582032,0.752231836319027 49.8302154541016,0.752231836319027 49.8302154541016,0.761807024478912 49.8301696777344,0.768031477928275 49.8254013061523,0.768031477928275 49.8254013061523,0.765199720859641 49.8139190673828,0.761436581611576 49.812313079834))0.0006POINT(0.7515180661128599 49.819134932297985)