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
28260POLYGON((4.95794391632091 47.431755065918,4.94397974014288 47.4298171997071,4.91053342819225 47.4154968261719,4.91053342819225 47.4154968261719,4.91122150421154 47.3979721069337,4.92553281784063 47.4020767211913,4.96379661560064 47.3926734924316,4.97356081008911 47.3935089111328,4.97356081008911 47.3935089111328,4.97925853729259 47.3976974487304,4.97925853729259 47.3976974487304,4.99204683303833 47.4024314880371,4.99207782745373 47.4086265563966,4.96136617660534 47.4255485534669,4.95794391632091 47.431755065918))0.0006POINT(4.955333641597278 47.407450539725176)
54098POLYGON((4.98959445953369 44.2857666015626,4.97168731689459 44.279426574707,4.97168731689459 44.279426574707,4.9771466255188 44.270637512207,4.98984527587902 44.267906188965,4.98983240127575 44.26469039917,4.98983240127575 44.26469039917,4.99352216720587 44.2588005065919,4.99352216720587 44.2588005065919,5.01220750808722 44.2674102783203,5.02531194686895 44.2666358947755,5.02578973770142 44.2698440551758,5.02578973770142 44.2698440551758,5.02542638778687 44.2730026245118,5.02542638778687 44.2730026245118,5.02281761169445 44.2866439819336,5.01715040206915 44.2922401428222,5.01715040206915 44.2922401428222,5.00247907638555 44.2860908508302,4.98959445953369 44.2857666015626))0.0006POINT(5.003485227886051 44.274057890239554)
37077POLYGON((5.69571924209606 46.7674713134767,5.68824577331549 46.7759323120117,5.68824577331549 46.7759323120117,5.67601346969604 46.7794342041016,5.67601346969604 46.7794342041016,5.67084932327271 46.7744369506836,5.67477226257336 46.765438079834,5.66945505142218 46.7602272033691,5.66945505142218 46.7602272033691,5.69093799591076 46.7548713684082,5.69093799591076 46.7548713684082,5.69388818740845 46.7591056823731,5.69388818740845 46.7591056823731,5.69571924209606 46.7674713134767))0.0006POINT(5.682955521803691 46.76665291419397)
62727POLYGON((7.95459604263306 53.0854225158692,7.94110536575329 53.0870819091798,7.94900369644176 53.0956916809083,7.91451692581177 53.1094779968263,7.91610813140875 53.1134567260742,7.90162801742554 53.1194763183594,7.89783620834351 53.1193771362305,7.88513422012335 53.109661102295,7.88513422012335 53.109661102295,7.86989498138433 53.0977973937989,7.82772207260138 53.0987129211426,7.79053974151623 53.0918731689454,7.78646564483648 53.0937461853027,7.77464914321911 53.0844688415528,7.76684093475353 53.0865974426271,7.76684093475353 53.0865974426271,7.78286790847784 53.0309028625489,7.77945423126226 53.0274429321289,7.76986122131359 53.0296058654786,7.70416450500488 53.0195960998536,7.70416450500488 53.0195960998536,7.71242904663092 53.0156326293945,7.71242904663092 53.0156326293945,7.71309566497808 53.0150756835938,7.71220779418945 53.0141258239747,7.71243906021124 53.011703491211,7.71445989608765 53.0103225708008,7.7146511077882 53.0091590881349,7.71219062805181 53.008129119873,7.71276617050177 53.0058822631836,7.71122169494629 53.0022048950196,7.71186590194714 53.0007438659669,7.71657514572144 53.0005149841309,7.71844196319591 52.9889297485352,7.72316074371332 52.9721450805664,7.71617794036871 52.9682426452637,7.71943521499634 52.9659576416017,7.71943521499634 52.9659576416017,7.72320604324352 52.9645156860352,7.72320604324352 52.9645156860352,7.72624397277832 52.9635848999023,7.72476100921637 52.9627609252929,7.72939014434814 52.9604454040527,7.72869729995739 52.9596099853516,7.73160600662243 52.9559822082521,7.73591375350964 52.9568977355958,7.74096012115479 52.9564819335938,7.74091625213634 52.9451446533204,7.74269866943365 52.9468994140626,7.75303745269781 52.944034576416,7.75303745269781 52.944034576416,7.7701935768128 52.9394454956056,7.77546596527105 52.9418563842774,7.77853488922119 52.9406204223634,7.77580118179333 52.9376068115234,7.7867951393128 52.9346084594727,7.82381868362438 52.9275550842286,7.82664680480963 52.9243431091309,7.83205604553234 52.9205284118652,7.83027601242065 52.9157218933107,7.82676029205322 52.9147109985352,7.82569932937622 52.9100952148439,7.8204174041748 52.9056243896485,7.8204174041748 52.9056243896485,7.82986688613903 52.9036407470703,7.84184598922735 52.9054260253907,7.87889528274542 52.9142608642579,7.91371154785156 52.9240417480468,7.91085243225092 52.9271469116211,7.91464138031006 52.9296188354492,7.92465543746954 52.9281196594239,7.92369318008434 52.9347496032715,7.92428350448614 52.9361190795898,7.92612266540533 52.9362411499025,7.92526721954346 52.9338760375977,7.93136739730835 52.9322052001954,7.9312105178833 52.9308319091797,7.933017730713 52.9306411743165,7.93241500854504 52.9287986755372,7.93431234359747 52.927806854248,7.93431234359747 52.927806854248,7.93622827529913 52.9274215698243,7.94377946853638 52.9317245483398,7.96098089218151 52.9432258605957,7.96040201187139 52.964153289795,7.96040201187139 52.964153289795,7.90715885162365 52.9963340759278,7.9024019241333 52.9928512573243,7.89822721481323 52.9954261779786,7.90077304840088 53.0002250671388,7.8986225128175 53.0007934570313,7.9064617156983 53.0146255493165,7.91166543960571 53.0211181640626,7.91342639923096 53.0207023620605,7.92792367935186 53.0394325256348,7.92517805099499 53.0402030944825,7.92972373962408 53.0513916015626,7.92849922180181 53.0515556335449,7.92925357818609 53.0532569885255,7.92152738571167 53.0571670532228,7.92249488830561 53.0581893920898,7.92511653900146 53.0569648742676,7.93067598342896 53.056739807129,7.95060253143311 53.0769157409667,7.95100784301758 53.0801544189454,7.95397377014154 53.0800399780275,7.95459604263306 53.0854225158692))0.0006POINT(7.834670242273629 52.99392405096093)
46400POLYGON((3.72322988510132 50.1354904174806,3.72632360458368 50.1456565856935,3.73271942138683 50.1511230468751,3.77237010002148 50.1601867675782,3.77237010002148 50.1601867675782,3.77691125869757 50.159122467041,3.78338050842285 50.1444358825684,3.78338050842285 50.1444358825684,3.78942179679871 50.1357116699219,3.81099820137035 50.1279907226563,3.81099820137035 50.1279907226563,3.8044960498811 50.1223487854004,3.778722524643 50.1232261657715,3.76607012748724 50.1077308654786,3.76607012748724 50.1077308654786,3.75136351585382 50.1000900268555,3.75136351585382 50.1000900268555,3.72379374504089 50.1211471557618,3.72379374504089 50.1211471557618,3.72322988510132 50.1354904174806))0.0006POINT(3.7656724703939726 50.13136010420956)
14837POLYGON((11.816809654236 42.5399398803712,11.8005056381226 42.5451164245605,11.8005056381226 42.5451164245605,11.7970600128175 42.5462112426758,11.7806663513184 42.5296249389648,11.7781867980958 42.5257797241211,11.7681427001954 42.5207176208496,11.7444581985475 42.5172386169435,11.732852935791 42.5107955932618,11.7216005325319 42.5066032409668,11.7013301849366 42.5068359375001,11.6924810409545 42.5047187805176,11.6874399185181 42.501678466797,11.6938009262086 42.4956703186036,11.6972904205323 42.4936027526857,11.6972904205323 42.4936027526857,11.7030401229858 42.4842758178712,11.7167396545411 42.4896202087402,11.7190551757812 42.4919967651367,11.7276716232299 42.4930992126465,11.734091758728 42.4912147521973,11.7346410751342 42.4884300231935,11.7582788467408 42.4860153198243,11.761812210083 42.4889602661133,11.7611837387085 42.4915466308594,11.7620992660522 42.4927787780762,11.7704629898072 42.4999008178712,11.774073600769 42.500946044922,11.7763042449952 42.4977493286133,11.7762813568116 42.4910392761231,11.7795257568359 42.482608795166,11.7795257568359 42.482608795166,11.7885284423829 42.4837722778321,11.790662765503 42.487533569336,11.8044109344484 42.4961471557618,11.8090534210206 42.4940872192382,11.8058166503906 42.4875144958496,11.8058166503906 42.4875144958496,11.8205986022949 42.4927635192872,11.8205986022949 42.4927635192872,11.8189182281495 42.4946365356446,11.8145160675049 42.505699157715,11.8184194564819 42.5130233764648,11.8196754455566 42.5180282592774,11.8198785781861 42.5328254699708,11.816809654236 42.5399398803712))0.0006POINT(11.766268942091234 42.502718946668864)
47972POLYGON((-1.5324239730835 47.295021057129,-1.51736760139465 47.2948684692384,-1.50878155231476 47.29158782959,-1.50882983207697 47.2778091430665,-1.50244045257568 47.2687683105469,-1.50647854804993 47.2624244689941,-1.50419235229492 47.2593307495118,-1.49512207508081 47.2623710632324,-1.49512207508081 47.2623710632324,-1.46262288093567 47.2779006958009,-1.46262288093567 47.2779006958009,-1.442065000534 47.2880516052247,-1.40457630157471 47.2975769042969,-1.40457630157471 47.2975769042969,-1.41602003574371 47.3163299560547,-1.44379651546473 47.3363304138185,-1.44379651546473 47.3363304138185,-1.45166671276081 47.3277626037599,-1.47875595092773 47.3218307495117,-1.47875595092773 47.3218307495117,-1.52235066890711 47.3255310058594,-1.53185296058649 47.3100738525391,-1.53185296058649 47.3100738525391,-1.5324239730835 47.295021057129))0.0006POINT(-1.480263917342449 47.296506632929315)
16704POLYGON((13.6245927810668 43.5165863037111,13.6182680130006 43.5146217346191,13.603934288025 43.5005264282227,13.5990409851074 43.4943313598633,13.5995988845825 43.49275970459,13.5921125411987 43.480094909668,13.5921125411987 43.480094909668,13.5848703384399 43.4895057678223,13.5731773376465 43.4950218200684,13.5731773376465 43.4950218200684,13.5746936798097 43.5052108764648,13.5797348022462 43.5094909667969,13.5797348022462 43.5094909667969,13.5853137969971 43.5181083679199,13.5942707061768 43.52299118042,13.604603767395 43.5444183349611,13.6097650527955 43.5593070983887,13.6097650527955 43.5593070983887,13.6145839691163 43.556526184082,13.6165275573732 43.5529174804688,13.625415802002 43.5504150390625,13.6287508010865 43.548194885254,13.6276378631593 43.5468063354492,13.6290264129639 43.5445823669434,13.6276378631593 43.5406951904297,13.6218061447144 43.5345840454102,13.6209716796876 43.5312500000001,13.6215276718141 43.5276374816895,13.6229162216186 43.5256958007813,13.6245822906494 43.5254173278809,13.6234722137451 43.5237503051758,13.6251382827759 43.5226402282715,13.6240282058716 43.5193061828614,13.6245927810668 43.5165863037111))0.0006POINT(13.607660293579144 43.522342681884794)
1388544POLYGON((-6.2153959274292 37.7912521362305,-6.21216011047363 37.7862434387208,-6.20743989944458 37.7713432312013,-6.20877504348755 37.7694129943848,-6.20556402206421 37.7660408020021,-6.21976089477539 37.7544822692871,-6.22027397155762 37.7485313415527,-6.21686601638794 37.7437477111816,-6.22188520431507 37.7414932250978,-6.22185516357422 37.7397460937501,-6.22680616378784 37.7390441894532,-6.22671699523926 37.7414512634277,-6.23468208312988 37.7385749816896,-6.23370504379272 37.7439994812012,-6.23619079589838 37.7443199157714,-6.24338388442987 37.7409248352051,-6.24747085571289 37.7409934997559,-6.2522931098938 37.7427940368652,-6.25515079498291 37.7458877563478,-6.25407123565674 37.747386932373,-6.24535083770746 37.7467498779297,-6.2445330619812 37.7477645874024,-6.24830913543701 37.7591018676757,-6.25188493728638 37.7630500793457,-6.25823497772217 37.760570526123,-6.26604604721069 37.7614135742188,-6.27108192443848 37.7587890625001,-6.27836179733276 37.7584266662597,-6.3030748367309 37.7616691589355,-6.31089019775391 37.7648811340333,-6.31975793838501 37.7639656066894,-6.32911586761475 37.7598266601564,-6.34866380691528 37.7574539184571,-6.35286903381342 37.7553443908693,-6.36006689071655 37.7549209594727,-6.37596082687378 37.750099182129,-6.38989782333374 37.7477073669435,-6.42335081100464 37.7340812683105,-6.43074989318848 37.7274780273438,-6.45011997222895 37.7188758850098,-6.45416116714472 37.7213516235352,-6.460608959198 37.7210197448732,-6.4736499786377 37.7253456115723,-6.48109292984009 37.7222595214845,-6.48045492172236 37.7207641601562,-6.48290777206421 37.7208290100099,-6.4818930625915 37.7267341613771,-6.48397016525269 37.7313270568849,-6.48177480697626 37.7365379333496,-6.47735118865961 37.739730834961,-6.47616815567017 37.7449760437012,-6.48007202148438 37.7462005615235,-6.48049211502075 37.7643508911133,-6.48470401763916 37.7699394226074,-6.48032808303827 37.7761116027833,-6.47068691253651 37.7772178649903,-6.47809410095209 37.7899551391603,-6.47816181182856 37.7937812805176,-6.4732031822204 37.7987022399902,-6.47476911544794 37.8083381652833,-6.47364711761475 37.8125076293945,-6.4752311706543 37.8203887939453,-6.46259403228754 37.8131294250489,-6.46342992782593 37.8118515014649,-6.45500612258911 37.8109397888184,-6.44464111328119 37.8141288757324,-6.43794679641724 37.8115844726563,-6.43444919586182 37.8127746582032,-6.4309458732605 37.8116607666016,-6.42862987518299 37.8141632080079,-6.42660808563227 37.8139152526857,-6.42490386962885 37.8111801147461,-6.42174196243286 37.8105964660645,-6.40881109237671 37.8123588562013,-6.41056108474731 37.8148765563966,-6.40872192382801 37.8217658996582,-6.41010713577271 37.8240318298341,-6.41928577423096 37.8291816711427,-6.42028617858881 37.8370971679689,-6.41681003570557 37.8467025756836,-6.41831016540527 37.8535423278809,-6.42883682250971 37.854892730713,-6.43260478973383 37.8575134277343,-6.44064283370966 37.8554229736328,-6.44998502731318 37.8566894531251,-6.44823503494263 37.8603363037111,-6.45221185684204 37.8661842346193,-6.44994878768915 37.8744125366212,-6.44289493560791 37.8786468505861,-6.44392776489258 37.8810195922852,-6.43796110153193 37.8910522460939,-6.43691492080677 37.8991355895997,-6.44092416763306 37.900001525879,-6.4451150894165 37.9030761718751,-6.45102882385254 37.9014320373536,-6.45269823074329 37.9023399353028,-6.45150613784779 37.9113464355469,-6.45987176895136 37.9144554138183,-6.46107101440424 37.9176979064941,-6.45850276947021 37.9184837341309,-6.45554208755493 37.9237518310547,-6.44606781005859 37.9288597106934,-6.44806194305414 37.9349899291992,-6.44572305679321 37.9377593994142,-6.44541120529169 37.9430389404297,-6.4470272064209 37.9452438354493,-6.44413280487061 37.9480247497558,-6.44133806228632 37.9481315612794,-6.44349002838135 37.9510841369629,-6.44068717956537 37.953899383545,-6.44400310516357 37.955738067627,-6.44210195541376 37.9564170837402,-6.43578577041626 37.9547271728516,-6.42938184738153 37.9508323669435,-6.41430091857899 37.9474983215332,-6.41065692901611 37.944206237793,-6.39959812164307 37.9395256042481,-6.36966180801386 37.9182167053224,-6.34196805953979 37.9116134643555,-6.33559322357178 37.9081802368165,-6.32052803039545 37.8905258178711,-6.30935382843012 37.8852195739747,-6.29784393310547 37.8772087097169,-6.28242111206049 37.8718452453614,-6.27646780014032 37.8664894104004,-6.25408220291138 37.8386688232422,-6.24754619598389 37.8264236450195,-6.23075485229487 37.8156700134277,-6.22223091125477 37.8045539855958,-6.2153959274292 37.7912521362305))0.0006POINT(-6.380252904670157 37.81904010624851)
34646POLYGON((3.80160093307506 48.9083786010742,3.80159783363348 48.9152641296388,3.78989195823664 48.9216461181642,3.76445603370667 48.9217414855958,3.76445603370667 48.9217414855958,3.75819778442394 48.9202423095704,3.75819778442394 48.9202423095704,3.75837445259094 48.9108238220215,3.75088453292852 48.9004592895509,3.75088453292852 48.9004592895509,3.75742602348328 48.8953552246094,3.7673420906068 48.8972053527832,3.77690982818604 48.8948593139649,3.79559850692749 48.9003868103028,3.79559850692749 48.9003868103028,3.79692792892467 48.907024383545,3.80160093307506 48.9083786010742))0.0006POINT(3.7742715477943842 48.90851354599007)