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
71803	POLYGON((16.048807144165 47.7028007507324,16.0406188964844 47.6959495544434,16.0406188964844 47.6959495544434,16.0521087646486 47.6834678649903,16.0542335510254 47.6796035766601,16.0529727935791 47.6743812561035,16.0433807373047 47.6536331176759,16.0433807373047 47.6536331176759,16.0565147399903 47.6542663574219,16.0625438690187 47.655559539795,16.0732917785645 47.6668586730958,16.0762844085694 47.6665115356446,16.0866947174073 47.6624374389648,16.1011295318604 47.6645965576172,16.1011295318604 47.6645965576172,16.0996131896973 47.6750030517579,16.1099395751953 47.6819915771485,16.1099395751953 47.6819915771485,16.1053199768066 47.6976509094238,16.1032962799072 47.7017707824708,16.1002883911133 47.703224182129,16.0856266021729 47.7044792175294,16.0779628753663 47.7126808166505,16.0779628753663 47.7126808166505,16.075366973877 47.7127418518066,16.075366973877 47.7127418518066,16.048807144165 47.7028007507324))	0.0006	POINT(16.075168976416997 47.68350777259245)
69459	POLYGON((9.17595481872559 54.3349304199219,9.17135143280035 54.3441581726074,9.17270851135265 54.3489799499512,9.17943286895758 54.3482666015624,9.18677711486822 54.3493766784668,9.18589401245123 54.3521232604982,9.18253898620617 54.3517379760742,9.18217182159418 54.3531913757324,9.18562126159679 54.3535041809081,9.18533802032476 54.3562316894532,9.18533802032476 54.3562316894532,9.18249607086182 54.355655670166,9.1650133132934 54.3581809997559,9.15615272521984 54.3617706298829,9.15214920043951 54.3609733581543,9.15038776397705 54.3627128601074,9.15050983428949 54.3642044067383,9.14246749877941 54.3651962280275,9.14560508728027 54.3734550476075,9.14360427856457 54.3735160827638,9.14484310150141 54.3746871948243,9.12401580810553 54.3781051635743,9.12347602844244 54.3767013549805,9.11153697967541 54.3782119750976,9.11153697967541 54.3782119750976,9.1082267761231 54.3730926513672,9.09993553161627 54.3660430908203,9.09993553161627 54.3660430908203,9.10579490661627 54.3632049560547,9.10697841644293 54.3580017089844,9.1080722808839 54.3569984436035,9.11700057983404 54.3533096313477,9.12457466125488 54.3520278930665,9.12457466125488 54.3520278930665,9.13123607635498 54.3508949279785,9.13476753234875 54.3486251831056,9.13589477539057 54.3465270996095,9.13460445404053 54.3397331237794,9.13514232635504 54.3382682800293,9.13828945159918 54.3374214172364,9.14904499053955 54.3374557495117,9.15265846252447 54.3364257812499,9.15131187438959 54.3342933654785,9.14391231536865 54.3311233520508,9.14294528961193 54.3281784057618,9.14425563812267 54.3226776123048,9.14592266082764 54.3204879760743,9.15477275848394 54.3184700012207,9.15477275848394 54.3184700012207,9.16648101806641 54.316879272461,9.17243003845226 54.3172302246094,9.17267608642589 54.318214416504,9.16307353973389 54.3256988525392,9.16245174407959 54.3278999328614,9.16848754882824 54.3324394226075,9.17595481872559 54.3349304199219))	0.0006	POINT(9.148129931363238 54.34906324906785)
48673	POLYGON((-0.490087121725082 48.4851646423339,-0.489232391118946 48.4914588928222,-0.478198140859604 48.5015716552735,-0.478198140859604 48.5015716552735,-0.492665201425552 48.5021171569825,-0.509293854236603 48.5088424682618,-0.509293854236603 48.5088424682618,-0.518632471561375 48.4975509643555,-0.534906804561615 48.4915466308595,-0.534906804561615 48.4915466308595,-0.518987476825714 48.4834556579589,-0.519926607608795 48.4736328124999,-0.515146136283875 48.4679756164552,-0.515146136283875 48.4679756164552,-0.510497450828439 48.4691314697266,-0.50933909416193 48.4757003784181,-0.499514698982239 48.4831314086915,-0.490087121725082 48.4851646423339))	0.0006	POINT(-0.5072924933012627 48.488306830911114)
16710	MULTIPOLYGON(((13.5260477066041 42.9222297668457,13.5171308517457 42.9105644226074,13.511727333069 42.8999633789064,13.5098590850831 42.8930320739746,13.5112981796266 42.8912734985352,13.5238609313964 42.8882637023926,13.5390548706055 42.8738708496094,13.5406742095948 42.8695831298829,13.5394048690796 42.8605728149415,13.5248613357544 42.8555335998536,13.506238937378 42.8557319641114,13.5013942718505 42.8521385192872,13.5013942718505 42.8521385192872,13.4899587631227 42.848846435547,13.4904937744141 42.8434524536133,13.4943161010743 42.8372497558594,13.4985256195068 42.8271064758301,13.495966911316 42.8256835937501,13.477765083313 42.8251762390137,13.4736576080322 42.8294677734375,13.4703998565673 42.8311195373536,13.4672851562501 42.829933166504,13.4598140716552 42.8245201110841,13.4657640457153 42.8092803955079,13.4657640457153 42.8092803955079,13.4677629470826 42.799186706543,13.4617004394532 42.7902450561525,13.4665679931641 42.7752838134766,13.4683303833008 42.7732353210449,13.4771585464478 42.773063659668,13.4816808700562 42.7741317749023,13.4868154525757 42.7790718078614,13.4938669204712 42.7831001281739,13.5021276474 42.7828292846681,13.5015363693237 42.778980255127,13.5061292648315 42.7765312194824,13.5061292648315 42.7765312194824,13.507700920105 42.7772789001465,13.5163660049438 42.7870483398439,13.5306558609008 42.7969512939454,13.5325956344604 42.8021125793458,13.5334520339966 42.8131904602051,13.5354366302491 42.8176193237305,13.5445556640624 42.8179130554199,13.546501159668 42.8168640136719,13.5477695465088 42.8138656616212,13.5559406280518 42.8053588867189,13.5723695755005 42.8014678955079,13.5756263732911 42.8017807006836,13.5756263732911 42.8017807006836,13.5819969177247 42.8051071166993,13.5907850265502 42.8074684143067,13.6024179458618 42.8073120117188,13.6141185760497 42.8112678527833,13.619468688965 42.8143730163575,13.619468688965 42.8143730163575,13.6154928207397 42.8160705566406,13.6159267425538 42.8245697021485,13.6214370727539 42.8260231018068,13.6254301071168 42.8285484313964,13.6274223327636 42.8341636657715,13.6297874450684 42.8362007141113,13.641794204712 42.8406867980958,13.6512327194213 42.83744430542,13.659824371338 42.8356895446778,13.6696128845215 42.8368148803712,13.6722421646118 42.839714050293,13.671498298645 42.8409423828126,13.671498298645 42.8409423828126,13.6667699813844 42.8456077575684,13.6662950515748 42.8476600646973,13.6678028106689 42.8504066467286,13.6718978881837 42.8486938476562,13.7074899673462 42.8499031066894,13.7074899673462 42.8499031066894,13.7234039306642 42.8563117980958,13.7234039306642 42.8563117980958,13.7425737380982 42.8568115234376,13.7425737380982 42.8568115234376,13.7385702133179 42.8603515625,13.7351560592651 42.8669013977051,13.7317953109742 42.8672523498536,13.7317953109742 42.8672523498536,13.7263298034669 42.866310119629,13.7263298034669 42.866310119629,13.7174263000489 42.8624000549317,13.7094545364379 42.8601684570312,13.700433731079 42.8589668273926,13.6978788375855 42.8594322204591,13.6903114318849 42.8636627197266,13.6775207519531 42.8733024597169,13.6775207519531 42.8733024597169,13.6740293502808 42.8751640319825,13.6657123565673 42.8747673034668,13.6639366149903 42.8701934814454,13.6554927825929 42.8701095581055,13.6533660888672 42.8716278076172,13.6532220840455 42.8771133422852,13.6374883651734 42.8906478881836,13.6318922042847 42.8894233703613,13.6281433105469 42.8872718811036,13.621590614319 42.8865242004394,13.6183128356934 42.8947906494142,13.6183128356934 42.8947906494142,13.609914779663 42.8995323181152,13.6033401489258 42.9076042175294,13.6023731231691 42.9124717712402,13.5976610183717 42.9187698364258,13.5931186676026 42.9200477600099,13.5817184448243 42.919376373291,13.5782108306885 42.9211540222169,13.5780973434449 42.9266471862793,13.5791473388672 42.9289512634278,13.5791473388672 42.9289512634278,13.5780229568483 42.9312896728516,13.5655450820922 42.9294662475587,13.5618057250977 42.9264221191407,13.560308456421 42.9239845275879,13.5549049377443 42.9221267700195,13.5424213409424 42.9217529296875,13.5312080383301 42.9249000549316,13.5260477066041 42.9222297668457)),((13.4246139526367 42.8065109252929,13.4356203079224 42.8067588806153,13.4356203079224 42.8067588806153,13.4370012283326 42.814079284668,13.4370012283326 42.814079284668,13.4223251342773 42.8121337890626,13.4223251342773 42.8121337890626,13.4246139526367 42.8065109252929)))	0.0006	POINT(13.587651533308843 42.850131474218294)
1407238	POLYGON((-5.64606094360346 40.014331817627,-5.64697313308716 40.0112457275392,-5.66568708419794 40.0036010742188,-5.67615985870361 39.9922256469726,-5.6916508674621 39.9837684631348,-5.69309997558594 39.9858322143555,-5.70035314559931 39.9859085083009,-5.72353410720825 40.0202522277833,-5.72924089431751 40.0481605529786,-5.73325920104975 40.0524978637695,-5.73404312133789 40.0600891113282,-5.7275719642638 40.0636291503907,-5.72078084945679 40.0629615783692,-5.71126985549927 40.0687789916993,-5.70912504196167 40.067008972168,-5.70675897598261 40.0680122375489,-5.70421981811518 40.0651664733888,-5.69996976852417 40.0664749145508,-5.69989490509033 40.0604133605956,-5.68629503250116 40.0535354614258,-5.68073415756226 40.0543098449706,-5.67403602600092 40.0526809692382,-5.67160606384277 40.0484237670899,-5.66742086410522 40.0462875366212,-5.66795921325684 40.0345344543457,-5.63279676437372 40.0422744750977,-5.62716102600098 40.0331611633301,-5.62687587738026 40.0260429382325,-5.62923717498774 40.0237388610841,-5.64067411422729 40.0222549438477,-5.64427900314331 40.0197563171388,-5.64606094360346 40.014331817627))	0.0006	POINT(-5.68286222027191 40.036689019972314)
28176	POLYGON((5.35987949371344 47.0811347961427,5.34578657150274 47.0766487121582,5.34578657150274 47.0766487121582,5.33253335952759 47.0765914916993,5.33253335952759 47.0765914916993,5.32041454315191 47.0829811096192,5.29200506210339 47.0905799865723,5.2808985710144 47.1020507812499,5.2808985710144 47.1020507812499,5.29569196701061 47.1019020080568,5.31267547607422 47.1082115173341,5.31267547607422 47.1082115173341,5.32693767547613 47.0908279418945,5.335361480713 47.0880088806153,5.335361480713 47.0880088806153,5.35746526718151 47.0838165283204,5.35987949371344 47.0811347961427))	0.0006	POINT(5.3229315578938055 47.08964157104498)
27084	POLYGON((-1.75121378898615 49.5907897949219,-1.76495385169972 49.6174850463867,-1.75702631473541 49.6302986145021,-1.75702631473541 49.6302986145021,-1.75468373298645 49.6311912536622,-1.75468373298645 49.6311912536622,-1.74141263961786 49.6210784912111,-1.73304247856134 49.6027717590333,-1.73304247856134 49.6027717590333,-1.75121378898615 49.5907897949219))	0.0006	POINT(-1.749676148096681 49.617541842990555)
38285	POLYGON((1.06049525737757 49.6751861572266,1.05772113800055 49.6895408630372,1.05772113800055 49.6895408630372,1.06688618659985 49.6970558166505,1.08609282970428 49.7018356323242,1.09665322303778 49.6954765319825,1.09665322303778 49.6954765319825,1.09679627418524 49.6890182495117,1.09100043773657 49.6835708618165,1.07690000534063 49.679832458496,1.07027065753948 49.6749000549317,1.06049525737757 49.6751861572266))	0.0006	POINT(1.0779263973236617 49.68831218372696)
44188	POLYGON((0.817423522472438 44.0090713500978,0.822487592697257 44.0146369934083,0.81455105543148 44.0228157043458,0.819879472255707 44.0276947021485,0.819879472255707 44.0276947021485,0.807772397995052 44.0326309204102,0.79737514257431 44.0439643859863,0.79737514257431 44.0439643859863,0.764047920703945 44.029640197754,0.764047920703945 44.029640197754,0.76490181684494 44.0126495361329,0.778329730033931 44.0090255737305,0.784255206584987 44.0035705566406,0.793752074241695 44.0031318664551,0.793752074241695 44.0031318664551,0.811595082283077 44.0045967102052,0.817423522472438 44.0090713500978))	0.0006	POINT(0.7969641014934048 44.019866228103695)
35302	POLYGON((9.30152702331549 42.6267585754395,9.28302192687988 42.6624755859376,9.28302192687988 42.6624755859376,9.30243587493896 42.6697654724122,9.32375240325922 42.6699943542482,9.32375240325922 42.6699943542482,9.3219194412232 42.6667366027833,9.36038112640375 42.6362190246583,9.37903785705572 42.6340141296387,9.3922376632691 42.6378631591798,9.3922376632691 42.6378631591798,9.3945226669311 42.6347465515138,9.3945226669311 42.6347465515138,9.40558624267589 42.6245040893556,9.39823436737055 42.6205177307129,9.39823436737055 42.6205177307129,9.37085819244396 42.6192245483398,9.34425640106195 42.6262588500978,9.30152702331549 42.6267585754395))	0.0006	POINT(9.353863345252146 42.641926447550546)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point