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
52769POLYGON((0.0545954257250401 46.120174407959,0.0463644824922653 46.1190147399903,0.0463644824922653 46.1190147399903,0.0116998665035908 46.1159439086915,-0.00608204118901767 46.1093902587891,-0.00750436680391431 46.1060295104981,-0.00750436680391431 46.1060295104981,-0.0153392907231478 46.1076240539552,-0.0153392907231478 46.1076240539552,-0.0281064864248037 46.1110153198242,-0.0294531565159559 46.1140518188476,-0.0383880585430916 46.1137123107911,-0.0383880585430916 46.1137123107911,-0.0305421240627766 46.1178169250488,-0.0213282834738493 46.1298141479493,-0.0196647979319096 46.1330299377441,-0.0243090577423573 46.1389770507814,-0.0110318521037698 46.1488494873047,-0.0110318521037698 46.1488494873047,0.00251489575020969 46.1512603759766,0.009050075896198 46.1560096740723,0.0183191560209934 46.154624938965,0.0183191560209934 46.154624938965,0.0266483314336483 46.1521492004395,0.0266483314336483 46.1521492004395,0.0305495951325838 46.1315765380861,0.0449362024664879 46.1282119750977,0.0545954257250401 46.120174407959))0.0006POINT(0.0011850710251632296 46.12819558602797)
57955POLYGON((7.05077838897705 49.6546096801759,7.05200529098516 49.6595077514649,7.0440464019776 49.6715850830079,7.04601287841808 49.6727294921876,7.05278825759899 49.6732482910157,7.05319023132336 49.6738281250001,7.05190753936768 49.6748695373536,7.05372953414923 49.6761589050293,7.05372953414923 49.6761589050293,7.07539844512945 49.6627693176269,7.07574939727783 49.6611671447754,7.07841777801519 49.6612930297853,7.06987237930298 49.6562614440919,7.07524442672729 49.6527404785157,7.08140373229992 49.6535110473632,7.08167648315435 49.6483497619629,7.0850043296814 49.646297454834,7.08728170394903 49.6471328735352,7.08912467956543 49.6492538452149,7.09255027770996 49.6484260559083,7.09249782562267 49.6474151611328,7.09032630920404 49.6463966369629,7.09040355682373 49.6453971862794,7.09869384765625 49.6452522277832,7.10108137130737 49.6423072814943,7.10719823837286 49.6442451477052,7.10818529129028 49.6438179016114,7.10767841339117 49.6454849243165,7.10972785949718 49.6441688537598,7.11163139343262 49.6445045471191,7.11163139343262 49.6445045471191,7.11596298217773 49.6442489624024,7.12009811401379 49.6471519470215,7.12843656539917 49.6437721252442,7.12843656539917 49.6437721252442,7.13730192184454 49.640380859375,7.13403940200806 49.6400413513185,7.13610267639154 49.6339874267579,7.1345009803772 49.6336975097656,7.1345009803772 49.6336975097656,7.12399244308472 49.6313209533691,7.12546825408936 49.6296615600587,7.11950826644903 49.6253318786622,7.12312173843395 49.6226577758789,7.11985492706305 49.6182823181153,7.12283706665039 49.61531829834,7.12014818191528 49.6159057617189,7.11393404006952 49.6097106933594,7.11116456985479 49.6108551025391,7.11116456985479 49.6108551025391,7.1065492630006 49.6122207641602,7.10809183120728 49.6131401062013,7.1063122749328 49.6149673461915,7.10780429840099 49.6169929504394,7.10445165634155 49.6202125549318,7.1045379638673 49.62211227417,7.10267353057867 49.6250076293946,7.10267353057867 49.6250076293946,7.10175657272339 49.6260070800782,7.10266733169561 49.6268463134766,7.09816694259655 49.6283302307129,7.09716033935547 49.6301078796388,7.09324455261242 49.6321563720703,7.09210968017584 49.6339416503907,7.08508396148687 49.6332969665528,7.08284187316906 49.6361465454103,7.07557106018072 49.6381416320802,7.07376003265387 49.6399955749512,7.07172203063959 49.6397895812989,7.07578325271612 49.6432991027833,7.06778430938726 49.6457595825195,7.05425453186047 49.6546859741211,7.05077838897705 49.6546096801759))0.0006POINT(7.0952019757695055 49.64058621724449)
68226POLYGON((6.91326761245733 50.2649993896486,6.91126251220709 50.263469696045,6.91126251220709 50.263469696045,6.90635633468628 50.2671699523927,6.90521430969244 50.2696113586426,6.89973211288464 50.2698097229004,6.89973211288464 50.2698097229004,6.89311218261719 50.2723770141602,6.89031982421881 50.2721366882325,6.88940954208385 50.269889831543,6.88787031173712 50.2727317810058,6.88976192474377 50.2753791809083,6.88976192474377 50.2753791809083,6.89575242996222 50.2790184020997,6.89607334136974 50.2816200256348,6.88006114959722 50.2834396362305,6.88006114959722 50.2834396362305,6.88853836059582 50.297924041748,6.87941265106201 50.2977256774902,6.87707567214972 50.2999496459961,6.87343215942388 50.301239013672,6.87362289428717 50.3018684387208,6.86868524551397 50.3024215698242,6.86868524551397 50.3024215698242,6.86769962310802 50.3028068542481,6.8701958656311 50.3080024719239,6.86982297897339 50.3099174499513,6.87260580062866 50.3128700256348,6.86734199523937 50.3163604736328,6.86378288269054 50.3163566589357,6.85920047760015 50.3177604675293,6.8602495193482 50.3191108703613,6.86345720291138 50.3196601867675,6.86530685424799 50.321216583252,6.86454200744629 50.3236503601075,6.86454200744629 50.3236503601075,6.86763334274303 50.3227920532228,6.86846637725836 50.3209381103516,6.87156724929821 50.3192253112794,6.87539815902721 50.3191757202148,6.88027334213257 50.3216438293458,6.88582897186291 50.322036743164,6.88582897186291 50.322036743164,6.88890457153332 50.3217430114747,6.88890457153332 50.3217430114747,6.89201879501348 50.3207702636719,6.89224243164074 50.3151016235352,6.89926576614386 50.3152427673341,6.90847492218018 50.3099708557129,6.91655206680304 50.3082695007324,6.91706609725964 50.3068809509277,6.92771434783936 50.306869506836,6.93628120422369 50.3089027404786,6.93721485137951 50.3103179931641,6.94471502304083 50.313819885254,6.94471502304083 50.313819885254,6.9458012580871 50.3126640319824,6.94409513473516 50.309181213379,6.95019674301159 50.3013877868652,6.9488205909729 50.2978248596192,6.95062732696533 50.2956809997559,6.95244073867804 50.2953147888184,6.95244073867804 50.2953147888184,6.95736885070812 50.2920532226564,6.95736885070812 50.2920532226564,6.95677089691162 50.2882347106934,6.95247459411632 50.2851638793946,6.94915580749517 50.280143737793,6.95133256912226 50.2788696289063,6.95133256912226 50.2788696289063,6.95305871963512 50.2727508544922,6.9509325027467 50.2713088989257,6.9509325027467 50.2713088989257,6.95039033889776 50.2708587646485,6.95039033889776 50.2708587646485,6.94697380065929 50.2701301574707,6.94356441497814 50.2683753967285,6.94321250915527 50.2672653198243,6.94121026992804 50.2675361633302,6.93642377853405 50.2654151916504,6.93641757965088 50.2684707641602,6.93528032302868 50.2679023742676,6.93394613266003 50.269744873047,6.93146038055414 50.2706489562988,6.92170095443731 50.2703437805176,6.91700410842901 50.2714843750001,6.91491699218756 50.2686271667481,6.91490650177013 50.2663650512695,6.91326761245733 50.2649993896486))0.0006POINT(6.908854836767429 50.29320586811414)
62341POLYGON((9.6574878692627 52.0320396423341,9.6575927734375 52.0340690612794,9.65435314178478 52.0362281799318,9.65225601196295 52.0361518859864,9.65064048767084 52.0379447937013,9.6512069702149 52.0503730773927,9.66112613677984 52.0457267761231,9.66254615783703 52.0462493896486,9.65092372894287 52.0522384643555,9.64509868621826 52.0516242980958,9.64590358734125 52.053077697754,9.64337825775158 52.0546607971192,9.6489000320434 52.0596389770507,9.64777374267584 52.0630302429199,9.65130519866943 52.0619468688965,9.65129661560064 52.0598335266114,9.65395736694342 52.0601158142089,9.65484809875494 52.0663261413575,9.65701007843023 52.0654792785645,9.65358352661138 52.0699882507325,9.65510559082031 52.0705299377442,9.65510559082031 52.0705299377442,9.65640449523931 52.0705490112305,9.65811538696295 52.0680503845215,9.66018867492681 52.0672187805176,9.67014598846441 52.0710067749024,9.67200374603283 52.0692024230958,9.67077445983892 52.0685806274415,9.67460918426508 52.0680236816406,9.67394065856934 52.0670738220215,9.67628097534185 52.0659637451172,9.68389701843262 52.0677642822266,9.68373012542725 52.068920135498,9.68772411346447 52.0691757202148,9.68829059600836 52.0677490234376,9.69454669952393 52.0688705444337,9.69348430633539 52.0727844238282,9.69757556915283 52.0708770751954,9.69754600524914 52.0742073059083,9.70192241668701 52.0752067565918,9.70050811767578 52.0776252746583,9.69892883300793 52.0777397155762,9.69936370849609 52.0803871154785,9.70157432556147 52.0800514221192,9.70500850677502 52.0856704711915,9.70521450042719 52.0839271545411,9.70749759674078 52.0836639404296,9.71077251434332 52.0850524902344,9.71170902252209 52.0841217041016,9.71237182617188 52.0845947265626,9.71402454376226 52.0869636535646,9.71310329437256 52.0891113281251,9.71090507507336 52.0903129577637,9.71168327331537 52.0933418273926,9.71373748779303 52.0958671569825,9.73572254180908 52.1043205261232,9.7399730682373 52.1051750183105,9.7399730682373 52.1051750183105,9.73644638061523 52.1021194458009,9.73173046112066 52.0890464782716,9.73706436157227 52.0871124267578,9.7329797744751 52.0839729309082,9.7363338470459 52.0822143554688,9.73649120330816 52.0786819458009,9.7384414672851 52.0790328979493,9.74010753631597 52.0754470825196,9.74010753631597 52.0754470825196,9.74035835266125 52.0735130310059,9.73506927490234 52.0750885009765,9.73407077789301 52.073299407959,9.7376537322998 52.0719833374025,9.73502635955822 52.0685768127442,9.73367214202881 52.0631904602051,9.73105049133295 52.0624313354493,9.72996807098389 52.060962677002,9.73119068145758 52.0588226318361,9.72969150543207 52.0585937500001,9.73057842254644 52.0552864074708,9.72689151763916 52.0534400939941,9.72689151763916 52.0534400939941,9.7242517471314 52.0551719665527,9.72470092773432 52.0567092895508,9.72256278991694 52.059986114502,9.72120189666748 52.0600776672364,9.71824264526373 52.0625686645508,9.71349143981939 52.0599021911622,9.71442604064953 52.058494567871,9.71556758880615 52.0587959289551,9.71857452392589 52.054714202881,9.72944450378418 52.0448760986329,9.72776031494135 52.0444068908692,9.72606468200689 52.0454750061035,9.72392082214355 52.0445785522461,9.72480106353765 52.0434226989747,9.72367382049561 52.042823791504,9.71800518035894 52.0415878295899,9.71598434448254 52.0401954650879,9.71296215057373 52.0338478088379,9.71434116363531 52.0325431823731,9.70928668975836 52.0338516235353,9.70928668975836 52.0338516235353,9.70739936828608 52.0400276184083,9.69958686828613 52.0396690368653,9.69675445556646 52.0455856323242,9.69072437286377 52.0474967956544,9.68938064575195 52.0459594726562,9.68623542785645 52.0464134216309,9.6846160888673 52.0480308532715,9.68239784240717 52.0473365783691,9.67963981628412 52.0498924255372,9.66946697235102 52.0548400878907,9.6574878692627 52.0320396423341))0.0006POINT(9.698929906965398 52.06375644443272)
13007MULTIPOLYGON(((16.5775032043458 39.0183715820312,16.5867080688477 39.0139923095703,16.5867080688477 39.0139923095703,16.5894412994386 39.0103149414062,16.589849472046 39.0084877014161,16.5888042449952 39.0072441101075,16.5916862487793 39.0038108825684,16.598934173584 38.9965324401855,16.6056327819825 38.9924087524414,16.6056327819825 38.9924087524414,16.5797386169434 38.9936981201173,16.5688266754151 38.9909324645997,16.5635719299318 38.9857063293458,16.5536861419679 38.9860382080079,16.549695968628 38.9873123168946,16.549695968628 38.9873123168946,16.5332565307618 39.0071525573732,16.5301208496093 39.0132637023927,16.5283374786378 39.0136108398438,16.5283374786378 39.0136108398438,16.5308265686035 39.0150299072267,16.5392417907715 39.0167655944824,16.5434036254883 39.009132385254,16.547040939331 38.9995422363282,16.5494174957277 38.998935699463,16.5570049285889 39.0010490417482,16.5606098175049 39.0054054260255,16.5619792938232 39.0088195800781,16.5614624023438 39.010540008545,16.5624713897705 39.0112762451171,16.5775032043458 39.0183715820312)),((16.5188808441162 39.0146827697754,16.5056133270265 39.0165023803712,16.5056133270265 39.0165023803712,16.5097732543945 39.0112953186036,16.5097732543945 39.0112953186036,16.5188808441162 39.0146827697754)))0.0006POINT(16.562582771243274 39.004024227556464)
32940POLYGON((2.60160493850714 47.7699317932129,2.59841179847723 47.7631530761719,2.56192255020147 47.7379531860353,2.55854916572571 47.7312355041504,2.53817749023449 47.7204551696778,2.53817749023449 47.7204551696778,2.56100010871899 47.7058105468751,2.58372449874878 47.6969833374023,2.58372449874878 47.6969833374023,2.58971023559576 47.6953468322754,2.58971023559576 47.6953468322754,2.59058976173407 47.7023353576661,2.60631155967724 47.7111740112305,2.62042355537426 47.7258186340333,2.63072133064281 47.7451210021972,2.62956738471985 47.7556037902831,2.63608336448681 47.7689018249513,2.63608336448681 47.7689018249513,2.60160493850714 47.7699317932129))0.0006POINT(2.5919162962172466 47.728417290581625)
44553POLYGON((0.690306782722473 42.9541816711427,0.696220636367855 42.9486885070802,0.696220636367855 42.9486885070802,0.698456406593323 42.9519119262695,0.698456406593323 42.9519119262695,0.714096069335994 42.973991394043,0.723772764205933 42.9818611145021,0.723772764205933 42.9818611145021,0.713421881198826 42.9885940551758,0.699646770954189 42.9873580932617,0.699646770954189 42.9873580932617,0.684424042701835 42.9788055419922,0.684424042701835 42.9788055419922,0.690619051456565 42.9669456481934,0.690306782722473 42.9541816711427))0.0006POINT(0.7009632161685806 42.97006879534045)
71223POLYGON((16.4622707366944 47.4300422668457,16.4853954315187 47.4260940551759,16.4956531524658 47.4267807006837,16.5017948150635 47.4289894104004,16.5140686035157 47.4405479431152,16.5221824645997 47.4510612487793,16.5239353179932 47.458152770996,16.5214920043946 47.4654006958007,16.5214920043946 47.4654006958007,16.5481510162354 47.4568595886232,16.5577831268311 47.4523544311524,16.5858993530274 47.4231033325195,16.5836124420166 47.4203109741212,16.5836124420166 47.4203109741212,16.5817909240723 47.4196357727051,16.5826683044433 47.4153900146486,16.5787925720215 47.4137077331544,16.5754566192628 47.4078407287599,16.5584983825684 47.4082794189454,16.5486335754395 47.4066810607911,16.5399131774903 47.4115753173829,16.5272541046144 47.4101333618164,16.5207538604737 47.4123420715332,16.5158138275146 47.4074363708497,16.5088920593262 47.4072914123536,16.5119876861573 47.4002990722657,16.4974708557129 47.3909835815431,16.493995666504 47.3927993774414,16.4971504211426 47.3981056213379,16.4905109405518 47.3960571289063,16.491231918335 47.4001960754395,16.4863319396974 47.4003944396973,16.4882259368897 47.406894683838,16.4846572875977 47.4093437194825,16.4601554870606 47.4120750427247,16.4485473632812 47.4105453491212,16.4485473632812 47.4105453491212,16.4472942352294 47.41166305542,16.4442787170411 47.411937713623,16.4422588348389 47.4136772155762,16.4399852752686 47.4190521240234,16.4396095275878 47.4230804443359,16.4431667327881 47.4249954223633,16.4622707366944 47.4300422668457))0.0006POINT(16.50933061644092 47.419031808542684)
32136POLYGON((0.965293824672813 47.2208671569825,0.955526530742702 47.2229194641113,0.935705065727234 47.2203178405762,0.913273811340332 47.2022361755372,0.907341778278408 47.1930313110351,0.907341778278408 47.1930313110351,0.916489601135311 47.1867599487305,0.916489601135311 47.1867599487305,0.930098533630371 47.1897926330567,0.944313108921051 47.1866989135743,0.958063781261558 47.190559387207,0.972705483436698 47.1995811462403,0.972705483436698 47.1995811462403,0.974384307861385 47.2062301635742,0.965293824672813 47.2208671569825))0.0006POINT(0.9406951921327342 47.19988332475938)
57056POLYGON((7.58316993713373 49.9933013916016,7.5732889175415 49.9902381896974,7.57572603225708 49.9884300231934,7.57572603225708 49.9884300231934,7.56915712356573 49.9865112304689,7.56487751007086 49.9869155883788,7.56124353408819 49.9910202026368,7.55703735351562 49.9910545349121,7.55556726455694 49.989990234375,7.55328273773199 49.9910125732422,7.55240726470959 49.9902687072754,7.55240726470959 49.9902687072754,7.54902935028088 49.993377685547,7.55054664611828 49.9939117431641,7.54974985122686 49.9948196411133,7.54245090484625 49.9951629638672,7.54220962524408 49.9963455200196,7.5451283454895 49.9961280822755,7.54754829406738 49.9991836547852,7.55256700515747 50.0002632141114,7.5553412437439 50.0025444030762,7.55343484878534 50.0040626525879,7.55343484878534 50.0040626525879,7.55627584457403 50.0053329467774,7.5572619438172 50.0043067932129,7.55856323242188 50.0056190490723,7.56169223785406 50.0058517456055,7.5642490386964 50.0074310302735,7.56803083419805 50.0077247619629,7.56805562973022 50.0102577209474,7.57087564468389 50.0118789672853,7.57230567932123 50.0108985900879,7.57248830795294 50.0072631835938,7.57661533355724 50.0076293945313,7.57785081863415 50.0102119445801,7.58107566833502 50.0108757019043,7.58107566833502 50.0108757019043,7.58179330825811 50.0097007751466,7.57810544967663 50.0088806152344,7.57799148559576 50.0079345703125,7.57995176315313 50.0083198547364,7.57815933227545 50.0024147033693,7.57610082626337 50.0005760192871,7.57805776596081 49.9991950988771,7.57778644561768 49.9943084716798,7.58316993713373 49.9933013916016))0.0006POINT(7.564659870995455 50.00010647243926)