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
51675POLYGON((-0.296574324369431 45.5644989013673,-0.319818764924946 45.5798377990724,-0.319818764924946 45.5798377990724,-0.326933115720749 45.5675048828126,-0.322724908590317 45.5617370605469,-0.321403533220291 45.5420379638671,-0.321403533220291 45.5420379638671,-0.312709331512394 45.5439987182617,-0.296574324369431 45.5644989013673))0.0006POINT(-0.31767328456042065 45.56018638610844)
16735POLYGON((13.5477514266969 42.9905090332032,13.5430431365967 42.9902458190919,13.5430431365967 42.9902458190919,13.5433731079103 42.9800834655762,13.5412750244142 42.9718437194824,13.532250404358 42.9713134765624,13.529808998108 42.9692535400391,13.5285863876343 42.9645500183105,13.5214223861695 42.9498977661134,13.5167760849 42.9505348205567,13.5158815383911 42.9498329162599,13.5143241882324 42.9325942993163,13.5151319503785 42.9320831298828,13.5151319503785 42.9320831298828,13.5260477066041 42.9222297668457,13.5260477066041 42.9222297668457,13.5312080383301 42.9249000549316,13.5424213409424 42.9217529296875,13.5549049377443 42.9221267700195,13.560308456421 42.9239845275879,13.5618057250977 42.9264221191407,13.5655450820922 42.9294662475587,13.5780229568483 42.9312896728516,13.5791473388672 42.9289512634278,13.5791473388672 42.9289512634278,13.5814800262452 42.9298171997071,13.5851192474365 42.9362487792969,13.5862350463868 42.9490547180177,13.585729598999 42.9528694152833,13.585729598999 42.9528694152833,13.5853796005249 42.9607009887696,13.5735864639282 42.966552734375,13.5522747039796 42.9812316894531,13.5498771667481 42.9819946289062,13.5468549728395 42.9868812561035,13.5477514266969 42.9905090332032))0.0006POINT(13.549847793579158 42.950159890311134)
38472POLYGON((1.23129642009735 49.3995437622071,1.23607492446911 49.4012069702148,1.25643777847296 49.3966827392579,1.25643777847296 49.3966827392579,1.24999439716339 49.3876609802247,1.28613030910486 49.3869285583497,1.28613030910486 49.3869285583497,1.28919553756725 49.3754920959474,1.28919553756725 49.3754920959474,1.28623867034912 49.3629608154297,1.28623867034912 49.3629608154297,1.27222788333893 49.3542480468749,1.27222788333893 49.3542480468749,1.27215528488171 49.3473777770997,1.24609911441814 49.3475227355957,1.24609911441814 49.3475227355957,1.21222341060644 49.349723815918,1.20957100391394 49.3523902893068,1.20957100391394 49.3523902893068,1.21702110767365 49.3789443969727,1.23168742656702 49.3817291259766,1.24249136447918 49.3932266235352,1.23129642009735 49.3995437622071))0.0006POINT(1.2538520422849204 49.37235745516694)
29368POLYGON((4.53553771972668 46.4641571044922,4.54470300674438 46.461483001709,4.54470300674438 46.461483001709,4.54138422012335 46.4551963806152,4.54138422012335 46.4551963806152,4.52881288528448 46.4450988769532,4.52407503128057 46.4438629150391,4.51508283615112 46.447063446045,4.51508283615112 46.447063446045,4.49735307693481 46.4533424377442,4.49735307693481 46.4533424377442,4.47713661193853 46.4617919921875,4.47561788558954 46.464916229248,4.47561788558954 46.464916229248,4.48519515991217 46.4643516540527,4.49389410018921 46.4674110412598,4.51150083541881 46.4640350341798,4.53553771972668 46.4641571044922))0.0006POINT(4.5120255526374615 46.45733597699336)
39567POLYGON((3.37315869331371 43.4735794067383,3.35365366935736 43.4879112243652,3.33729314804083 43.4942436218262,3.33729314804083 43.4942436218262,3.33048868179327 43.5165863037111,3.33048868179327 43.5165863037111,3.33797049522411 43.5253639221191,3.3606214523316 43.5309944152833,3.3606214523316 43.5309944152833,3.36987948417675 43.5303535461426,3.38443374633789 43.5210075378419,3.38443374633789 43.5210075378419,3.40981149673468 43.5011405944824,3.40981149673468 43.5011405944824,3.39489006996155 43.4844779968261,3.3828427791596 43.4807777404786,3.37315869331371 43.4735794067383))0.0006POINT(3.3661057651043516 43.506900548934986)
19584POLYGON((11.5098495483398 46.051139831543,11.5221128463745 46.0617523193361,11.5221128463745 46.0617523193361,11.5165643692017 46.0684623718262,11.5165643692017 46.0684623718262,11.5098209381105 46.0695114135743,11.5060644149781 46.0715866088868,11.5038175582886 46.07474899292,11.5109281539918 46.08504486084,11.5117101669312 46.0886306762696,11.5107307434083 46.1020698547364,11.5107307434083 46.1020698547364,11.5150957107544 46.1133880615235,11.5150957107544 46.1133880615235,11.522813796997 46.1201705932617,11.5319766998291 46.1253433227539,11.5415267944337 46.1240539550782,11.5452709197998 46.1221656799316,11.5452709197998 46.1221656799316,11.5567617416382 46.1266708374023,11.5567617416382 46.1266708374023,11.5683660507202 46.1285362243653,11.5683660507202 46.1285362243653,11.5712785720826 46.1300277709962,11.5739288330078 46.1345825195313,11.5735569000244 46.1369705200195,11.5687055587769 46.1364021301271,11.5655784606933 46.1385459899903,11.5676622390748 46.1440010070801,11.5718784332275 46.1468315124512,11.5718784332275 46.1468315124512,11.5672540664673 46.1540489196777,11.5609836578369 46.1693801879883,11.5563802719117 46.1710090637207,11.5522756576539 46.1753692626954,11.5522756576539 46.1753692626954,11.5514860153198 46.1759834289551,11.5514860153198 46.1759834289551,11.5442724227906 46.1828155517579,11.538818359375 46.1821594238281,11.5342435836793 46.1702804565431,11.5262393951415 46.1628303527832,11.5262393951415 46.1628303527832,11.5287141799927 46.1598663330078,11.5246829986573 46.1556625366211,11.5088052749635 46.1457443237305,11.5026760101318 46.138641357422,11.4937238693238 46.1209678649903,11.5021982192993 46.1110153198242,11.5054054260254 46.104103088379,11.5046453475952 46.0950546264649,11.50319480896 46.0917701721193,11.50319480896 46.0917701721193,11.4981136322021 46.0829467773439,11.4973640441895 46.0680694580079,11.4998331069947 46.0620231628419,11.4998331069947 46.0620231628419,11.5098495483398 46.051139831543))0.0006POINT(11.531879291199829 46.12137249059848)
30454POLYGON((-4.45253086090088 48.5704345703126,-4.46151304244995 48.567165374756,-4.48100709915161 48.550895690918,-4.50705718994141 48.5528793334962,-4.51197195053095 48.5518455505372,-4.52449703216547 48.5548629760743,-4.52449703216547 48.5548629760743,-4.52347278594971 48.5551376342773,-4.52736091613758 48.5559730529785,-4.53319406509399 48.5548629760743,-4.5356941223144 48.5559730529785,-4.53875017166132 48.5598602294922,-4.54430389404297 48.5598602294922,-4.54819488525385 48.5576400756837,-4.55347108840942 48.5601387023926,-4.55374908447266 48.5612487792969,-4.56097221374512 48.5601387023926,-4.58708381652832 48.5618057250977,-4.58958387374878 48.5645828247071,-4.59069395065302 48.5704154968263,-4.59293556213379 48.5729179382324,-4.59293556213379 48.5729179382324,-4.59316730499268 48.5732116699219,-4.59316730499268 48.5732116699219,-4.59437131881714 48.57474899292,-4.58923435211182 48.5796051025391,-4.56952571868891 48.577060699463,-4.54972505569452 48.5797920227051,-4.54263019561768 48.5887565612793,-4.52569484710693 48.5935401916504,-4.52569484710693 48.5935401916504,-4.52236080169678 48.592082977295,-4.52069520950317 48.5856933593751,-4.51680707931513 48.5873603820802,-4.5018048286438 48.5870819091798,-4.50041723251343 48.5831947326661,-4.49569511413569 48.5812492370607,-4.49486112594599 48.5793037414551,-4.49013805389404 48.5748596191407,-4.48458385467529 48.572639465332,-4.48291587829584 48.5730094909669,-4.48291587829584 48.5730094909669,-4.45253086090088 48.5704345703126))0.0006POINT(-4.533616100038779 48.570223127092675)
60221POLYGON((9.81669616699219 47.0214653015136,9.82588195800787 47.0194473266603,9.82954883575439 47.0172157287599,9.83036804199213 47.0166244506836,9.8337516784668 47.0147590637208,9.8337516784668 47.0147590637208,9.82741355896007 47.0072784423828,9.81836700439453 47.002956390381,9.81817817688 47.0015373229981,9.82116413116455 46.9946022033691,9.81950473785412 46.9915504455566,9.81698513031 46.9896354675293,9.79820346832275 46.9886741638184,9.78510284423834 46.9865837097168,9.77348518371588 46.9804344177247,9.77348518371588 46.9804344177247,9.76920413970947 46.9827995300293,9.76727867126471 46.9825401306153,9.75620079040533 46.9662094116212,9.75016307830811 46.9648094177247,9.74773406982433 46.962215423584,9.74270343780529 46.9616088867188,9.73852825164795 46.9578247070314,9.73179435729986 46.9576034545899,9.72391510009777 46.9478302001954,9.71627902984631 46.9474372863771,9.70911216735846 46.9486274719238,9.70911216735846 46.9486274719238,9.70452690124517 46.9516868591309,9.69570541381842 46.9542541503906,9.68288803100586 46.954860687256,9.68288803100586 46.954860687256,9.67118644714361 46.9595527648926,9.67118644714361 46.9595527648926,9.67561912536632 46.9650955200196,9.6701717376709 46.9671363830566,9.6690673828125 46.9700584411622,9.66532993316656 46.9736022949219,9.66672706604015 46.980583190918,9.66672706604015 46.980583190918,9.67309284210216 46.9795265197754,9.67706966400152 46.9806823730469,9.6887350082398 46.9875564575196,9.69667625427246 46.9934539794922,9.70154094696045 46.9955215454102,9.71068191528315 47.0031127929688,9.7250909805299 47.0044593811036,9.72879123687744 47.0081367492676,9.73097229003918 47.0133056640626,9.73796558380138 47.0176391601563,9.7401113510133 47.0221138000489,9.74503326416021 47.0247077941894,9.74503326416021 47.0247077941894,9.74831485748297 47.026912689209,9.75259494781494 47.0281639099121,9.76737689971924 47.028392791748,9.78306007385265 47.0335540771486,9.78841304779053 47.0363922119142,9.78841304779053 47.0363922119142,9.79111671447748 47.0339241027832,9.79196739196789 47.0333671569825,9.7942943572998 47.0316696166992,9.79582691192627 47.0307998657227,9.7963924407959 47.030559539795,9.79858493804932 47.0301208496095,9.80232334136974 47.0289306640626,9.80665016174322 47.0257453918458,9.80739402771007 47.0251502990723,9.81351757049561 47.0216941833496,9.81669616699219 47.0214653015136))0.0006POINT(9.752651767454328 46.99513930168708)
60025POLYGON((6.14496803283697 46.1678199768067,6.14414310455328 46.1695861816406,6.14414310455328 46.1695861816406,6.13681316375744 46.1680526733398,6.13147687911999 46.1708145141602,6.11899280548096 46.1723976135254,6.11561203002935 46.1744194030761,6.11561203002935 46.1744194030761,6.10897111892706 46.1743049621583,6.1044068336488 46.1731872558594,6.1044068336488 46.1731872558594,6.10500192642206 46.1709632873536,6.10944986343384 46.1692581176758,6.10999679565424 46.1682319641114,6.10270309448254 46.1649169921876,6.10270309448254 46.1649169921876,6.10556507110601 46.1596298217773,6.10330104827887 46.1554336547851,6.10330104827887 46.1554336547851,6.10786676406866 46.1544609069825,6.11300516128534 46.1562042236328,6.12865304946894 46.1513061523438,6.13664484024054 46.1527099609376,6.14349603652954 46.1558303833008,6.14349603652954 46.1558303833008,6.14340019226086 46.1612663269043,6.14482402801525 46.1642265319825,6.14496803283697 46.1678199768067))0.0006POINT(6.121220518041589 46.16475536205153)
58945POLYGON((7.25260591506952 51.4133300781251,7.24662828445435 51.4113121032715,7.23599433898937 51.4120063781738,7.22835540771496 51.4108848571777,7.220941066742 51.4122734069825,7.20586204528809 51.4183082580566,7.19860982894897 51.4192123413086,7.19144105911255 51.418155670166,7.180823802948 51.4199790954591,7.17665624618542 51.4180526733398,7.17708587646484 51.4168930053711,7.17360496520996 51.4150390625001,7.16709518432617 51.4132499694825,7.16583871841442 51.4164772033692,7.1547088623048 51.4142494201661,7.15163516998297 51.4167022705078,7.15022754669201 51.4164199829103,7.14944314956676 51.4184646606446,7.14838123321528 51.4184646606446,7.14780426025396 51.420249938965,7.14467859268194 51.4232368469239,7.13603019714355 51.4260368347169,7.13603019714355 51.4260368347169,7.13684177398676 51.4232139587403,7.13599205017101 51.4200668334962,7.13436365127563 51.4171295166016,7.12999010086065 51.4131317138672,7.11947107315063 51.4085044860841,7.11704015731812 51.4078826904298,7.11435985565197 51.4088783264161,7.10844326019293 51.406665802002,7.11097192764294 51.4058494567872,7.11199808120733 51.4006195068361,7.1183695793153 51.3941688537598,7.11875247955322 51.3916511535645,7.11754035949718 51.3899116516113,7.11924028396606 51.3873023986817,7.11657190322876 51.3856811523438,7.11602783203119 51.3821258544923,7.11767530441284 51.3802719116211,7.11767530441284 51.3802719116211,7.12233638763428 51.3781585693359,7.12556457519526 51.3792572021486,7.12569379806519 51.3810272216797,7.12783813476574 51.3804397583008,7.13013172149658 51.3814964294434,7.13046073913586 51.3800010681152,7.13352632522594 51.3776397705079,7.13764905929577 51.3793144226075,7.13855648040771 51.3787612915039,7.13771343231201 51.3777961730958,7.13905239105236 51.3754730224609,7.14043045043951 51.3751258850099,7.14853048324596 51.3777160644532,7.14933586120617 51.3767395019532,7.1490244865418 51.3749465942383,7.15290546417248 51.37455368042,7.15236806869518 51.3720550537109,7.1554536819458 51.3700942993165,7.15937852859508 51.3651161193848,7.15816831588739 51.3641662597657,7.15700292587286 51.3601531982423,7.15290069580078 51.3562126159669,7.15033197402954 51.355110168457,7.14726114273077 51.3515052795411,7.14942598342896 51.3499946594239,7.15270042419439 51.3501739501954,7.15331411361706 51.3492736816407,7.15151596069342 51.3488807678223,7.1504683494569 51.3469619750977,7.14925289154053 51.3467292785646,7.14871406555176 51.3449859619141,7.1502037048341 51.3443260192871,7.14552593231201 51.3421020507812,7.14618253707886 51.3412361145019,7.14537763595587 51.3397560119629,7.14648818969727 51.3382987976075,7.14755630493175 51.3386726379395,7.14947032928461 51.3374710083009,7.1481347084046 51.3363723754882,7.14845323562628 51.3343505859376,7.15388965606701 51.3339271545411,7.15737962722778 51.3298225402832,7.16460037231445 51.3271217346191,7.16621494293207 51.3256225585938,7.16653347015392 51.3231163024902,7.16557502746588 51.3224868774414,7.16614818573004 51.3203086853027,7.16959381103527 51.3173980712891,7.16674327850347 51.3144721984864,7.16728782653803 51.3129005432129,7.16728782653803 51.3129005432129,7.17554855346685 51.3097496032716,7.17554855346685 51.3097496032716,7.18615436553955 51.3151206970215,7.20459604263306 51.3203239440919,7.20679712295532 51.3232765197755,7.20385313034063 51.3268585205078,7.2064638137818 51.3309478759766,7.21276044845592 51.3349800109863,7.21685600280773 51.3362121582031,7.21676063537609 51.3391647338868,7.22731781005865 51.3401260375978,7.22965669631969 51.3436317443848,7.22969341278082 51.3453407287598,7.23245191574091 51.346996307373,7.23260974884039 51.3532752990723,7.23113203048706 51.3548469543458,7.2322244644165 51.3599205017089,7.2316837310791 51.3608512878419,7.2251996994018 51.3668594360353,7.22001600265514 51.3681373596191,7.21902894973749 51.3700714111329,7.23710584640509 51.3762779235841,7.24364519119268 51.3759803771973,7.25561428070063 51.3831634521484,7.25561428070063 51.3831634521484,7.25705289840704 51.3850059509278,7.25458145141613 51.3851547241212,7.25278043746948 51.3886413574219,7.25437879562389 51.3898582458497,7.25242280960083 51.3906517028809,7.24925088882446 51.3899154663087,7.24828338623053 51.391788482666,7.24938535690308 51.3937110900879,7.24604749679565 51.3949050903321,7.24718570709234 51.3952980041504,7.24683952331543 51.4010047912598,7.25212144851679 51.402458190918,7.25110101699835 51.4034461975098,7.25168800353998 51.4059410095215,7.25019550323498 51.4068908691407,7.25583934783941 51.4101600646973,7.25260591506952 51.4133300781251))0.0006POINT(7.176277798817611 51.3742912980847)