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.

Spaltenname	Datentyp	Mögliche Werte	Beschreibung
id_ort	int(10) unsigned	beliebig	Fremdschlü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"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die 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"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
40071	POLYGON((2.79308676719666 42.6909828186036,2.79517173767096 42.7046623229981,2.78071022033691 42.7184448242188,2.78071022033691 42.7184448242188,2.75374341011047 42.7258110046387,2.73478436470043 42.7275276184083,2.72378897666943 42.7341728210449,2.72378897666943 42.7341728210449,2.74780797958385 42.7052459716797,2.74374914169317 42.6884841918945,2.74599266052257 42.685459136963,2.74599266052257 42.685459136963,2.77271318435663 42.6835975646973,2.77271318435663 42.6835975646973,2.77400588989269 42.6864852905275,2.79308676719666 42.6909828186036))	0.0006	POINT(2.759250624974621 42.70483652750656)
1398922	MULTIPOLYGON(((-3.57237195968622 42.5956802368165,-3.56872296333307 42.5937080383302,-3.55325198173512 42.5962600708008,-3.53328704833979 42.6118965148926,-3.53420090675354 42.6147918701173,-3.50254797935486 42.614559173584,-3.49493598937988 42.6157608032228,-3.49068093299866 42.6126174926758,-3.49261093139648 42.6052780151368,-3.49122095108032 42.603874206543,-3.48298811912537 42.6079788208008,-3.4821159839629 42.6055564880372,-3.47753405570984 42.6043243408204,-3.48236894607538 42.5987930297853,-3.47989296913147 42.5890884399414,-3.484137058258 42.5722808837892,-3.48198294639587 42.5726165771486,-3.4825599193573 42.56982421875,-3.48721909523005 42.5687675476074,-3.4922850131988 42.5701751708986,-3.50735211372375 42.5682563781738,-3.52361607551575 42.576675415039,-3.52398109436029 42.5679016113281,-3.52959394454956 42.5631637573242,-3.53384709358215 42.5634536743165,-3.53343296051025 42.5590057373047,-3.53654408454889 42.556812286377,-3.53702211379999 42.5427894592286,-3.54139995574951 42.5463981628419,-3.54154396057123 42.5488929748536,-3.5493819713592 42.5496902465821,-3.55439591407776 42.5520439147949,-3.56161594390863 42.5502243041992,-3.56944489479059 42.5553932189943,-3.56909203529352 42.5674896240236,-3.56527209281921 42.5720825195314,-3.56748104095453 42.5818405151367,-3.56430101394648 42.583408355713,-3.56363105773926 42.5874366760255,-3.5686109066009 42.5922126770021,-3.57337403297424 42.5906600952148,-3.57237195968622 42.5956802368165)),((-3.45732998847961 42.5452308654786,-3.46181797981262 42.5477180480958,-3.46679091453547 42.5481834411621,-3.47124409675587 42.5571823120118,-3.47487711906427 42.5594444274902,-3.47288703918446 42.5620613098146,-3.47674798965454 42.5682716369629,-3.46434998512262 42.5736236572265,-3.46078705787659 42.5731430053712,-3.45604395866394 42.5693626403809,-3.44915509223932 42.5720405578613,-3.44218111038208 42.5678520202637,-3.44468808174122 42.5641479492188,-3.43976902961725 42.5576477050781,-3.44818806648254 42.5493469238282,-3.44986295700073 42.5452613830568,-3.45732998847961 42.5452308654786)))	0.0006	POINT(-3.516244054800014 42.577422671601475)
1408002	MULTIPOLYGON(((-7.913016796112 42.5083656311035,-7.91476106643671 42.49959564209,-7.92959785461426 42.4968948364259,-7.93243980407709 42.4940605163574,-7.92092800140375 42.4823951721191,-7.9198842048645 42.473445892334,-7.91385221481323 42.45698928833,-7.92582416534418 42.4510612487794,-7.92856788635254 42.4514808654785,-7.93467092514038 42.4490127563477,-7.93946886062616 42.4420204162598,-7.94414615631098 42.441062927246,-7.93819522857666 42.4369506835938,-7.93747186660767 42.433650970459,-7.94341421127319 42.4319458007813,-7.94278287887568 42.429485321045,-7.95156383514404 42.429412841797,-7.95389604568481 42.4266395568849,-7.96426582336426 42.4252967834474,-7.96569299697876 42.4235191345215,-7.96829605102539 42.4244766235351,-7.97307014465326 42.4229278564454,-7.97319984436035 42.425163269043,-7.97672605514521 42.4267196655275,-7.9753680229187 42.4347457885743,-7.97323703765863 42.4352912902832,-7.97254800796509 42.4436187744141,-7.97980690002441 42.4461212158204,-7.97937679290766 42.4526329040527,-7.98160600662226 42.4499244689943,-7.9871621131897 42.4529914855956,-7.99627017974854 42.4540824890138,-8.00345611572254 42.4496803283692,-8.02323627471924 42.4417991638184,-8.02623558044434 42.4495162963867,-8.02678680419916 42.4629173278809,-8.03619575500483 42.4625663757324,-8.04040145874023 42.4645233154296,-8.04673862457275 42.4624519348145,-8.04753875732422 42.464054107666,-8.04054641723627 42.4735755920411,-8.04165554046625 42.4757499694824,-8.04023361206049 42.4772605895996,-8.03797817230225 42.4767303466796,-8.03170585632319 42.483741760254,-8.03061389923096 42.4869575500488,-8.02809524536133 42.487102508545,-8.02348709106445 42.4836158752442,-8.02229976654047 42.4847297668458,-8.01871490478504 42.4805488586426,-8.00415134429932 42.4740753173828,-8.00061607360834 42.4771919250489,-7.98961496353149 42.4784469604492,-7.99023008346558 42.4803810119629,-7.97857379913324 42.4890365600587,-7.97001409530634 42.4978218078613,-7.96779918670654 42.5019683837891,-7.97191905975342 42.5075683593751,-7.98156881332397 42.5123252868652,-7.98761081695557 42.5079650878907,-7.98925685882568 42.5109176635742,-7.98434495925903 42.5157051086427,-7.97724103927612 42.5339202880861,-7.96730613708496 42.5420303344727,-7.96924400329584 42.5417594909669,-7.97393608093256 42.5451736450196,-7.97417783737183 42.5492935180665,-7.96750688552851 42.5532951354982,-7.96559906005859 42.5606880187989,-7.95707988739008 42.565055847168,-7.94892311096186 42.5666236877443,-7.94908714294434 42.5708503723146,-7.94432401657104 42.5739288330079,-7.93058681488037 42.5785827636718,-7.92784118652344 42.5785102844238,-7.91726779937733 42.5616683959961,-7.91139507293695 42.5560531616212,-7.88988018035889 42.550178527832,-7.8885707855224 42.5381088256837,-7.89397096633905 42.5392799377442,-7.90085411071772 42.5362396240234,-7.9019250869751 42.5350036621094,-7.9000740051269 42.5315856933594,-7.90259504318237 42.5289649963379,-7.90731477737421 42.5309219360352,-7.91182518005365 42.5273056030273,-7.9238429069519 42.5250244140625,-7.90143918991089 42.521339416504,-7.90252208709711 42.514518737793,-7.91056299209595 42.5124549865724,-7.913016796112 42.5083656311035)),((-7.98912477493286 42.5722389221191,-7.98617315292358 42.5712814331056,-7.98357915878296 42.5692977905273,-7.98338079452515 42.5633201599122,-7.98041105270386 42.5596656799316,-7.99585294723511 42.5592079162599,-7.99434423446655 42.5671501159669,-7.98912477493286 42.5722389221191)))	0.0006	POINT(-7.965281646028004 42.49031911070612)
28525	POLYGON((4.46524333953869 47.8433227539063,4.47393321990972 47.8509826660157,4.46676540374762 47.8592262268066,4.46907281875616 47.8686676025391,4.46907281875616 47.8686676025391,4.50434970855713 47.8814239501953,4.50434970855713 47.8814239501953,4.50809431076055 47.8799476623536,4.50809431076055 47.8799476623536,4.51888227462769 47.8650817871094,4.50823497772217 47.858024597168,4.50717449188244 47.8512954711914,4.49069786071772 47.8383941650391,4.48875856399542 47.8316917419435,4.48875856399542 47.8316917419435,4.47194671630865 47.8241729736328,4.47194671630865 47.8241729736328,4.46524333953869 47.8433227539063))	0.0006	POINT(4.489139753229521 47.85518444285676)
41189	POLYGON((6.86785936355591 48.5431861877441,6.86636209487926 48.5491790771484,6.87594842910772 48.559024810791,6.87594842910772 48.559024810791,6.86961793899536 48.5640602111817,6.86961793899536 48.5640602111817,6.84164953231812 48.556438446045,6.84164953231812 48.556438446045,6.85165691375738 48.5425300598146,6.86630725860596 48.5342826843262,6.86630725860596 48.5342826843262,6.86785936355591 48.5431861877441))	0.0006	POINT(6.862993153658806 48.551137057217716)
72216	POLYGON((13.448793411255 48.2864913940431,13.4830780029298 48.3040504455567,13.4830780029298 48.3040504455567,13.472620010376 48.3093414306641,13.472620010376 48.3093414306641,13.4658565521241 48.3128623962403,13.4636478424073 48.3051719665527,13.4556331634521 48.3039054870606,13.4454555511476 48.3046226501465,13.433219909668 48.3093681335449,13.433219909668 48.3093681335449,13.4016380310059 48.3005905151368,13.4016380310059 48.3005905151368,13.425178527832 48.2882652282715,13.425178527832 48.2882652282715,13.4354772567749 48.2929801940919,13.4382781982423 48.284740447998,13.4382781982423 48.284740447998,13.448793411255 48.2864913940431))	0.0006	POINT(13.44571606318161 48.29993036058218)
29638	POLYGON((2.95423436164862 47.6456871032716,2.94158124923712 47.6575355529786,2.94158124923712 47.6575355529786,2.96723556518566 47.6867980957032,2.98248171806347 47.696216583252,3.00105333328247 47.7023391723633,2.99315881729132 47.7113418579102,2.9926109313966 47.718101501465,3.01434421539307 47.7413635253907,3.01434421539307 47.7413635253907,3.02703189849865 47.7380065917969,3.02703189849865 47.7380065917969,3.03233885765076 47.7323150634766,3.04128861427313 47.7296600341797,3.04241728782654 47.7230072021485,3.05206727981567 47.715389251709,3.06157422065735 47.7135124206543,3.06157422065735 47.7135124206543,3.05913043022156 47.7105789184571,3.06783652305609 47.6984939575195,3.06288957595825 47.698081970215,3.06288957595825 47.698081970215,3.04287457466125 47.6943855285644,3.01772689819342 47.6821594238282,3.00739574432379 47.6699180603028,2.9858124256134 47.6548881530763,2.98633456230175 47.6446342468262,2.98096871376043 47.6391983032227,2.98096871376043 47.6391983032227,2.96391153335577 47.6351356506348,2.95423436164862 47.6456871032716))	0.0006	POINT(3.0122229735057 47.69421488444015)
33841	POLYGON((4.18143177032476 48.480754852295,4.17688989639288 48.4876174926758,4.17688989639288 48.4876174926758,4.17291021347052 48.4936676025391,4.17291021347052 48.4936676025391,4.16744613647467 48.4920387268066,4.16744613647467 48.4920387268066,4.15806579589855 48.495101928711,4.15806579589855 48.495101928711,4.11362838745117 48.4875526428223,4.07318115234386 48.4667205810548,4.07318115234386 48.4667205810548,4.07787942886353 48.4635925292969,4.07787942886353 48.4635925292969,4.09278011322027 48.4652023315431,4.10568714141851 48.4600868225098,4.16031980514532 48.4721374511719,4.16635799407965 48.4777793884277,4.18143177032476 48.480754852295))	0.0006	POINT(4.137386136584873 48.48005506727434)
17743	POLYGON((8.49202156066889 45.8056144714356,8.49545860290533 45.8064231872559,8.50113964080816 45.8056755065919,8.51725006103521 45.7995147705079,8.52231025695812 45.7947235107423,8.5204381942749 45.7882156372071,8.5204381942749 45.7882156372071,8.51911354064936 45.7865104675293,8.51593112945562 45.7851524353027,8.50881481170666 45.7841567993165,8.50273799896246 45.7870674133301,8.50273799896246 45.7870674133301,8.50493144989019 45.7944564819337,8.4906406402589 45.8039894104005,8.4906406402589 45.8039894104005,8.49202156066889 45.8056144714356))	0.0006	POINT(8.50697364807134 45.79471817016607)
70637	POLYGON((10.9631118774415 51.0863647460938,10.9677076339722 51.0859222412111,10.9705524444581 51.088924407959,10.9700031280519 51.0897636413575,10.9732236862183 51.0903282165528,10.9772739410402 51.0951881408691,10.9791927337647 51.0955924987793,10.9808721542358 51.0976753234863,10.9808721542358 51.0976753234863,10.9780540466309 51.1001434326172,10.975468635559 51.1044540405273,10.9736967086791 51.1114082336426,10.9719381332397 51.1114158630371,10.9696760177613 51.1237335205078,10.9634819030762 51.1247825622559,10.9634819030762 51.1247825622559,10.9568872451782 51.1259155273438,10.9568872451782 51.1259155273438,10.9509868621827 51.1248588562012,10.9502954483033 51.121467590332,10.9572458267211 51.1187705993653,10.9474992752075 51.1161270141602,10.9496927261353 51.1138038635254,10.9467449188232 51.1120605468749,10.9510583877564 51.1072959899903,10.9482936859131 51.1052017211913,10.9452505111694 51.0987091064453,10.9452505111694 51.0987091064453,10.9530344009401 51.0988922119142,10.9491739273072 51.0942649841309,10.9491739273072 51.0942649841309,10.9584112167358 51.0935707092286,10.9581251144409 51.0920600891114,10.9600954055787 51.0918846130372,10.959620475769 51.090129852295,10.9613494873047 51.0901603698731,10.9631118774415 51.0863647460938))	0.0006	POINT(10.961491213904507 51.1039505004883)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point