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
61111POLYGON((7.22513484954834 46.1267967224121,7.22177219390869 46.1245079040527,7.21567392349243 46.1244735717774,7.21153402328491 46.122184753418,7.20332479476923 46.1207466125489,7.19915580749512 46.1151657104493,7.19915580749512 46.1151657104493,7.19542312622082 46.106845855713,7.18654108047497 46.1069526672363,7.18035221099854 46.1025733947754,7.181471824646 46.0986824035646,7.18171501159674 46.0900726318359,7.18480920791637 46.0848426818848,7.18480920791637 46.0848426818848,7.18729019165039 46.087631225586,7.1909170150758 46.087459564209,7.19181108474743 46.0838432312012,7.19479608535767 46.0790634155274,7.19456481933605 46.0760612487793,7.1927862167359 46.0730972290039,7.185212135315 46.0634956359864,7.18514394760143 46.0614852905274,7.18665218353277 46.0589027404786,7.18651294708263 46.054126739502,7.18651294708263 46.054126739502,7.1903219223023 46.0479812622071,7.19547700881964 46.0420761108399,7.20172214508057 46.0371513366699,7.20172214508057 46.0371513366699,7.20751476287842 46.0332336425781,7.20848083496105 46.0290908813477,7.21306276321423 46.0239753723145,7.22045707702648 46.0209426879884,7.22783517837536 46.0137748718263,7.23388910293579 46.0122451782227,7.23690605163569 46.0096778869629,7.23965692520147 46.0017433166505,7.24507617950434 45.995174407959,7.26658010482794 45.9877510070801,7.2677497863769 45.9840354919435,7.27358722686773 45.9754486083984,7.27394199371349 45.9701957702637,7.27297687530518 45.9684600830079,7.26735877990723 45.9670715332032,7.26536178588873 45.9645881652833,7.26536178588873 45.9645881652833,7.26782512664801 45.95463180542,7.27842903137207 45.9455757141113,7.28110790252686 45.9412498474122,7.29920816421509 45.9408874511719,7.30299377441406 45.9388275146484,7.30315113067633 45.9368591308593,7.29911708831787 45.9319801330568,7.29617595672607 45.9256782531739,7.29617595672607 45.9256782531739,7.30372810363781 45.9217071533204,7.31805706024181 45.919849395752,7.32208204269421 45.9157295227052,7.3263020515443 45.9141235351564,7.33216619491571 45.9136848449706,7.34856700897228 45.9172821044922,7.35829114913952 45.9140357971193,7.36094903945923 45.9086265563965,7.36468076705944 45.9058837890626,7.37064981460577 45.9063835144044,7.37506818771374 45.9044036865236,7.37506818771374 45.9044036865236,7.38444089889526 45.9000320434571,7.39144277572632 45.9001998901368,7.39808320999157 45.9046134948731,7.40108585357672 45.9101600646973,7.40349817276007 45.9118614196778,7.41510391235357 45.9112243652344,7.41752481460577 45.9132347106934,7.43053483963018 45.9183158874512,7.43658781051647 45.9223747253419,7.43942689895636 45.9259262084962,7.44494819641113 45.9301490783691,7.44786214828491 45.9342536926271,7.45775413513195 45.9358558654785,7.46227598190313 45.9384536743165,7.47084999084473 45.9367599487305,7.47504711151117 45.9370117187501,7.4776668548584 45.9396324157715,7.47547817230236 45.9495124816896,7.47621011734009 45.9521141052247,7.47946500778204 45.955493927002,7.48818922042858 45.9601440429688,7.48818922042858 45.9601440429688,7.48846817016602 45.9643707275391,7.4835958480835 45.9677810668945,7.48226213455206 45.9717712402344,7.4762229919433 45.9784584045411,7.47372484207165 45.9846954345704,7.46129512786865 45.9930610656738,7.45880317688 45.9934158325196,7.45508623123169 45.9903526306152,7.44528388977045 45.9907913208009,7.43713521957409 45.9889221191406,7.43464708328241 45.9900360107423,7.43350791931164 45.9936180114746,7.43350791931164 45.9936180114746,7.42339992523199 45.9960746765136,7.41606998443598 45.9940795898437,7.40336704254156 45.9987411499024,7.39211893081665 46.0127639770507,7.37973785400396 46.0157356262207,7.37421512603765 46.0193023681641,7.37316989898682 46.0213890075685,7.37450695037853 46.0293846130372,7.36859512329113 46.0348167419434,7.37028884887701 46.039836883545,7.36992311477661 46.0411567687988,7.36525821685797 46.043327331543,7.35866594314581 46.0518760681153,7.35613679885876 46.0594558715821,7.35813093185436 46.0637359619141,7.35813093185436 46.0637359619141,7.3467311859132 46.0639762878417,7.33966016769409 46.06693649292,7.33612823486322 46.0710029602052,7.33467197418213 46.074691772461,7.329089164734 46.076301574707,7.32396078109747 46.0808486938478,7.31478023529053 46.0798683166504,7.30831384658813 46.0818557739258,7.30441284179699 46.085765838623,7.29303598403942 46.0913391113282,7.28934383392345 46.0959854125977,7.28394317626959 46.0975189208984,7.28394317626959 46.0975189208984,7.27083921432506 46.1023063659669,7.26615285873419 46.108814239502,7.25537586212153 46.1128463745118,7.24919509887707 46.1173553466797,7.24546194076549 46.1213836669922,7.22513484954834 46.1267967224121))0.0006POINT(7.321690205265544 46.008360834682705)
44960POLYGON((1.49764490127575 43.6943969726562,1.48413252830517 43.6908226013185,1.46487152576452 43.6907958984375,1.46156311035156 43.6842155456543,1.46156311035156 43.6842155456543,1.45921325683588 43.6839752197266,1.45921325683588 43.6839752197266,1.46150982379919 43.6912803649902,1.46150982379919 43.6912803649902,1.46871602535253 43.6949920654297,1.47023987770081 43.7048149108887,1.47626280784618 43.7097129821778,1.47626280784618 43.7097129821778,1.47863745689392 43.7048606872559,1.48993468284613 43.7073822021484,1.48993468284613 43.7073822021484,1.49764490127575 43.6943969726562))0.0006POINT(1.472575604915661 43.69586348533632)
42873POLYGON((6.39942836761475 48.2940979003907,6.4020352363587 48.2841072082521,6.41483068466192 48.2735557556153,6.41483068466192 48.2735557556153,6.38764619827271 48.2592697143555,6.38764619827271 48.2592697143555,6.37161016464245 48.2645378112793,6.37161016464245 48.2645378112793,6.37789392471313 48.2937507629395,6.37789392471313 48.2937507629395,6.39163446426392 48.2902259826661,6.39942836761475 48.2940979003907))0.0006POINT(6.390641819347071 48.277332652698924)
63552POLYGON((9.0023279190064 50.4948768615723,8.99168777465826 50.4940795898437,8.97865772247309 50.4903984069824,8.98322010040295 50.4889297485351,8.98750305175776 50.4794540405273,8.98439788818365 50.476490020752,8.98404884338385 50.4737663269042,8.98016834259045 50.4707832336426,8.97891044616699 50.4682617187501,8.98046588897711 50.4681129455566,8.97959136962896 50.4651031494141,8.98888587951654 50.4641304016114,8.99014854431152 50.4594917297363,8.98665046691895 50.4577980041504,8.9860925674439 50.4567565917969,8.98756980896002 50.455509185791,8.98620128631603 50.4533653259277,8.97040939331066 50.4496307373048,8.96949291229248 50.4505004882813,8.96382236480719 50.4497566223145,8.96436023712153 50.4483871459962,8.96060276031506 50.4486541748048,8.95814228057867 50.4476013183594,8.95682239532476 50.4444427490236,8.96081924438482 50.4433555603028,8.96329021453863 50.440616607666,8.95380401611328 50.4333992004395,8.94813060760498 50.4311256408692,8.94703388214111 50.4327735900879,8.94318580627441 50.4323730468751,8.93931198120129 50.4340476989747,8.93161869049084 50.4344635009766,8.9296932220459 50.4326477050782,8.92301082611078 50.4344215393068,8.91839313507074 50.4368324279785,8.91664695739757 50.4363746643068,8.90710449218756 50.4381141662598,8.9033784866333 50.4333038330078,8.90040683746338 50.4270782470704,8.90040683746338 50.4270782470704,8.90037059783947 50.4198684692384,8.90037059783947 50.4198684692384,8.90961360931408 50.4193763732911,8.91173648834234 50.4178123474122,8.91958045959478 50.4195594787599,8.92406558990479 50.4109802246094,8.93620777130133 50.4147300720215,8.93874454498291 50.4125671386719,8.94410705566412 50.4147720336914,8.94541740417486 50.4162178039551,8.94870090484625 50.4155235290528,8.95754051208496 50.4158821105958,8.95477771759045 50.4136581420898,8.95506191253656 50.4105987548828,8.94997215271002 50.4069137573242,8.95133304595947 50.4045219421388,8.94923210144049 50.4011726379395,8.95275974273687 50.4000854492188,8.95240592956543 50.3963203430177,8.95123291015636 50.3947448730469,8.95228004455561 50.3937072753907,8.94886875152588 50.390007019043,8.94696140289307 50.3902244567871,8.94581127166742 50.3866806030275,8.94581127166742 50.3866806030275,8.94478797912609 50.3852806091309,8.94527626037598 50.3811492919923,8.95045375823986 50.381633758545,8.9511537551881 50.3796348571778,8.95478725433355 50.3795471191407,8.95572662353516 50.3813781738281,8.96437168121344 50.3825569152833,8.96485900878906 50.3891944885254,8.97026824951178 50.3899269104004,8.97251701354986 50.3883094787599,8.97420024871838 50.3884925842286,8.9798202514649 50.3788185119629,8.98308944702148 50.3800048828126,8.98793792724609 50.3797645568848,9.00561618804943 50.3885726928712,9.00781250000006 50.3845672607423,9.00991725921637 50.3834609985351,9.02026367187511 50.3834152221681,9.02207756042486 50.3798942565919,9.0251140594483 50.3781967163087,9.04423904418957 50.3886642456055,9.04591369628906 50.3877639770508,9.05361557006836 50.3908767700196,9.06033897399902 50.3869285583497,9.06033897399902 50.3869285583497,9.06278896331798 50.3850631713868,9.07496452331554 50.3841247558594,9.07625865936291 50.3832130432129,9.08296394348145 50.3848876953126,9.08354854583746 50.3841667175293,9.08814048767101 50.3849906921387,9.08868122100841 50.3831214904786,9.09091377258312 50.3812065124513,9.0944585800172 50.381736755371,9.09552192687983 50.3824157714844,9.09806823730474 50.3902626037598,9.09951496124273 50.3912086486816,9.11203765869152 50.3954734802247,9.11698246002203 50.3959121704102,9.11940002441412 50.3974647521974,9.11940002441412 50.3974647521974,9.11707210540777 50.4010009765624,9.11727523803722 50.4084510803223,9.12305355072033 50.4154891967775,9.12063884735113 50.4156913757325,9.12626934051514 50.424488067627,9.12025165557861 50.4260101318359,9.1204338073731 50.4274978637696,9.11868000030518 50.4282150268555,9.1124668121339 50.4244117736816,9.1071920394898 50.4246215820314,9.10291862487793 50.4266662597657,9.09987545013428 50.4262123107911,9.09356689453119 50.4275512695312,9.09833812713629 50.432487487793,9.10427379608166 50.4361381530763,9.10427379608166 50.4361381530763,9.1021585464477 50.4369125366211,9.09762954711925 50.4356231689454,9.08721828460705 50.438606262207,9.08710575103754 50.4394187927247,9.09468555450439 50.4433479309083,9.09587955474848 50.4458389282227,9.09394645690918 50.4496841430664,9.09121131896978 50.4497146606446,9.09437847137463 50.4573822021485,9.0857658386231 50.4568901062012,9.08078002929682 50.4595489501954,9.07954025268549 50.4585876464845,9.07602691650391 50.4591636657715,9.07026672363293 50.4561958312989,9.06914710998547 50.4582405090333,9.0619421005249 50.4647483825685,9.06141948699951 50.4692306518556,9.05978870391846 50.4693756103516,9.05867958068859 50.4711570739746,9.05912780761724 50.4755744934083,9.06207084655762 50.4784736633301,9.06088161468517 50.4809265136718,9.06141948699951 50.4849891662599,9.0720586776734 50.4899559020997,9.07670974731445 50.4933624267578,9.07722663879395 50.4953727722168,9.05770492553717 50.5000114440919,9.04736804962158 50.4996643066406,9.04242515563965 50.497989654541,9.04242515563965 50.497989654541,9.02647304534918 50.4964904785157,9.02166748046875 50.4935798645021,9.00969505310064 50.4897766113282,9.00592708587652 50.4895057678223,9.00567054748529 50.4909133911133,9.00861644744873 50.4954338073731,9.0023279190064 50.4948768615723))0.0006POINT(9.01461479935469 50.42933659613888)
23369POLYGON((-0.15782243013382 43.5814476013184,-0.162107899785042 43.5816650390624,-0.162107899785042 43.5816650390624,-0.166828721761647 43.5763053894044,-0.194016829132977 43.5645332336427,-0.197596341371536 43.5583229064941,-0.197596341371536 43.5583229064941,-0.186153128743115 43.5605125427247,-0.184465348720551 43.5553131103517,-0.184465348720551 43.5553131103517,-0.172012344002724 43.5587234497071,-0.163277551531792 43.5572738647461,-0.158719673752785 43.5628738403321,-0.158719673752785 43.5628738403321,-0.152398988604432 43.5715675354004,-0.152398988604432 43.5715675354004,-0.15782243013382 43.5814476013184))0.0006POINT(-0.17191796936092293 43.56614255905155)
30525POLYGON((-4.17989540100098 48.0988121032715,-4.14532232284546 48.1028900146484,-4.12917184829712 48.0965766906739,-4.10199546813959 48.1056060791016,-4.10199546813959 48.1056060791016,-4.08615541458119 48.1130104064943,-4.07875442504883 48.1214981079103,-4.07875442504883 48.1214981079103,-4.08632564544678 48.1263275146484,-4.10141038894648 48.1291122436525,-4.11664104461659 48.1279678344728,-4.1306533813476 48.142360687256,-4.13586378097534 48.1426582336426,-4.16628789901722 48.1295166015626,-4.19188022613525 48.1302223205566,-4.19188022613525 48.1302223205566,-4.20786046981806 48.1192588806153,-4.20650434494019 48.1128883361816,-4.20197677612305 48.1117477416993,-4.20197677612305 48.1117477416993,-4.18865823745728 48.1070861816406,-4.17989540100098 48.0988121032715))0.0006POINT(-4.1442839985801765 48.11841020129982)
28102POLYGON((4.60092115402222 47.0226669311525,4.58279418945318 47.0246810913086,4.57038974761969 47.033748626709,4.57038974761969 47.033748626709,4.56700468063366 47.0432662963868,4.57560157775885 47.0512199401855,4.59281921386719 47.0538024902343,4.59281921386719 47.0538024902343,4.60446357727062 47.0492706298828,4.61732721328747 47.051181793213,4.61732721328747 47.051181793213,4.60976505279552 47.047233581543,4.61290693283075 47.0447959899902,4.61290693283075 47.0447959899902,4.61256980896007 47.0445289611818,4.61256980896007 47.0445289611818,4.60544538497936 47.0233688354493,4.60092115402222 47.0226669311525))0.0006POINT(4.597530673531986 47.042224884033246)
46945POLYGON((3.40539216995245 50.4283409118653,3.38601756095886 50.43998336792,3.38601756095886 50.43998336792,3.36281323432928 50.4364814758301,3.36281323432928 50.4364814758301,3.37312030792248 50.4294738769531,3.35105085372925 50.4206352233887,3.35105085372925 50.4206352233887,3.3521740436554 50.4164924621583,3.3521740436554 50.4164924621583,3.35729384422308 50.4153099060059,3.37861585617077 50.42582321167,3.40539216995245 50.4283409118653))0.0006POINT(3.368211130301196 50.42717774709072)
14405POLYGON((12.6940097808838 46.3440780639648,12.6941080093384 46.3446197509767,12.6941080093384 46.3446197509767,12.6932106018066 46.3477096557617,12.6988859176637 46.3518295288087,12.7030534744263 46.3529396057128,12.7129726409913 46.3680572509767,12.7193956375122 46.3730354309082,12.728081703186 46.3772163391113,12.7389230728149 46.3882217407227,12.7347307205201 46.3902168273926,12.7324590682984 46.3951034545899,12.7392864227295 46.3995513916017,12.7400932312013 46.4011383056641,12.7336950302125 46.4086074829102,12.6991472244262 46.4084205627443,12.6908349990844 46.4099197387695,12.6795797348022 46.4169845581055,12.6786060333253 46.436580657959,12.679488182068 46.4430770874023,12.6841363906861 46.4494895935059,12.6930990219116 46.4533882141114,12.6930990219116 46.4533882141114,12.689847946167 46.4538917541504,12.6705751419067 46.462184906006,12.6545858383179 46.4599761962891,12.6462955474854 46.4574508666993,12.6428337097169 46.4507141113281,12.6426858901978 46.4460372924805,12.6409378051758 46.4424705505372,12.6332578659059 46.4388847351075,12.6332578659059 46.4388847351075,12.6296186447145 46.4336051940919,12.6262588500977 46.4322013854981,12.6237792968751 46.4323501586915,12.6193580627443 46.4286613464355,12.6192770004272 46.4215469360352,12.6212186813356 46.4154739379883,12.6157999038697 46.4027061462403,12.6029653549195 46.3952598571778,12.5900259017945 46.3833694458007,12.5840787887573 46.3819732666017,12.5773878097535 46.3847732543946,12.5648012161255 46.3774223327637,12.5580005645753 46.3699417114258,12.5580005645753 46.3699417114258,12.5780420303345 46.3655433654785,12.5868549346924 46.3685493469239,12.6058254241944 46.3566284179689,12.6057281494142 46.3555793762208,12.6009874343873 46.3522491455079,12.5959472656251 46.3498153686523,12.6110124588012 46.3443794250488,12.619023323059 46.3472480773926,12.6272020339967 46.3486404418946,12.6318798065186 46.3465423583986,12.6334161758424 46.343776702881,12.6389122009277 46.3401908874512,12.6389122009277 46.3401908874512,12.6491661071777 46.337730407715,12.6556367874147 46.3395423889161,12.6573047637939 46.3424682617188,12.6619224548339 46.346664428711,12.6792316436767 46.348503112793,12.6940097808838 46.3440780639648))0.0006POINT(12.65276339650158 46.39081496000292)
38197POLYGON((1.54190826416021 49.7944984436036,1.52797174453747 49.7983474731445,1.52692115306849 49.8015632629396,1.50665509700781 49.792896270752,1.50665509700781 49.792896270752,1.50896692276001 49.8121452331543,1.50058567523962 49.8143081665038,1.50058567523962 49.8143081665038,1.49928951263428 49.833854675293,1.49424767494207 49.8347625732422,1.49424767494207 49.8347625732422,1.51803588867193 49.8599700927735,1.51803588867193 49.8599700927735,1.52513003349299 49.8636207580566,1.52513003349299 49.8636207580566,1.52858674526226 49.8613624572754,1.52227365970612 49.8566589355469,1.52475905418407 49.8442344665528,1.52475905418407 49.8442344665528,1.5402067899704 49.8390045166016,1.5402067899704 49.8390045166016,1.54717218875885 49.8153915405275,1.54190826416021 49.7944984436036))0.0006POINT(1.5191968462684307 49.83051889592954)