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
36389	POLYGON((5.89354228973389 47.4435272216797,5.87450122833252 47.4566268920898,5.87450122833252 47.4566268920898,5.86681079864513 47.4685173034669,5.86840820312511 47.4784965515137,5.85905122756969 47.485652923584,5.86497402191156 47.4902877807618,5.86615657806396 47.4969902038574,5.86615657806396 47.4969902038574,5.87520647048945 47.4907760620117,5.87773466110241 47.4933090209961,5.87773466110241 47.4933090209961,5.87886381149303 47.4844055175782,5.87886381149303 47.4844055175782,5.89664554595959 47.4682464599611,5.91003084182739 47.463508605957,5.92495059967041 47.4620971679688,5.9283447265625 47.4646530151367,5.9283447265625 47.4646530151367,5.93396949768072 47.4594306945801,5.93396949768072 47.4594306945801,5.91728019714361 47.4466361999512,5.90750551223766 47.4473381042482,5.89354228973389 47.4435272216797))	0.0006	POINT(5.891458552816686 47.471996307373075)
56796	POLYGON((5.9686222076416 45.7588195800782,5.97403287887585 45.7686882019044,5.97403287887585 45.7686882019044,5.97421026229864 45.7750930786134,5.98217916488659 45.7831649780273,5.98055028915411 45.7961730957032,5.98055028915411 45.7961730957032,5.95806741714483 45.7949180603027,5.95806741714483 45.7949180603027,5.95267963409424 45.7659530639648,5.95267963409424 45.7659530639648,5.9686222076416 45.7588195800782))	0.0006	POINT(5.9686974612149895 45.778958407315365)
38597	POLYGON((0.878461837768612 49.3962554931641,0.898109853267613 49.4063148498536,0.90832889080059 49.4237480163575,0.90832889080059 49.4237480163575,0.907411634922084 49.4242706298828,0.907411634922084 49.4242706298828,0.878054797649497 49.4275474548341,0.864125609397945 49.4240455627442,0.864125609397945 49.4240455627442,0.87018191814434 49.4072570800782,0.860851228237266 49.3953590393066,0.860851228237266 49.3953590393066,0.864152669906616 49.3928184509278,0.878461837768612 49.3962554931641))	0.0006	POINT(0.8823381387271113 49.412695371187695)
62943	POLYGON((14.114377975464 53.6077575683594,14.1135225296021 53.6138725280762,14.1000146865845 53.6161041259766,14.0952444076538 53.6184387207032,14.0921554565429 53.6220970153809,14.0823507308961 53.6248664855958,14.0773286819459 53.6293296813965,14.0695152282716 53.6337203979493,14.0694856643677 53.6376075744629,14.0683288574219 53.6403121948242,14.0602016448976 53.6432991027833,14.0611448287964 53.6448478698731,14.0681419372559 53.6478385925293,14.0698699951172 53.6515655517578,14.0689458847046 53.6561889648438,14.0706129074098 53.65824508667,14.0675611495973 53.6583328247071,14.0673456192018 53.65922164917,14.0620231628419 53.6583938598633,14.0603694915772 53.655014038086,14.0521621704102 53.6531448364258,14.0476083755493 53.6524581909179,14.0427131652832 53.6537055969238,14.0469732284546 53.6558151245118,14.0436840057373 53.65726852417,14.0436534881591 53.6583938598633,14.045033454895 53.6585960388184,14.0442581176759 53.6611709594727,14.0475845336914 53.6633453369141,14.0449628829956 53.6644439697267,14.0466108322145 53.6645851135254,14.0475454330444 53.6665840148926,14.049283027649 53.6665344238282,14.0484247207642 53.6677093505861,14.0504169464111 53.6683731079102,14.0479316711426 53.6704025268555,14.0495710372925 53.6708145141602,14.0499687194824 53.6719818115234,14.0495824813842 53.6737480163574,14.0481548309327 53.6740760803224,14.0474653244019 53.6758422851563,14.048490524292 53.6768989562989,14.0479431152344 53.6785545349121,14.0465278625488 53.6786651611329,14.0471239089966 53.6809616088868,14.0496101379395 53.683219909668,14.0563764572144 53.6820182800294,14.0614023208619 53.6852989196778,14.0632152557374 53.6846733093262,14.0647201538086 53.6876945495605,14.0674896240236 53.6884002685547,14.06547164917 53.6902198791504,14.0647859573365 53.689250946045,14.063214302063 53.6900215148926,14.0624313354492 53.6913261413574,14.0646162033081 53.6932945251465,14.0619897842408 53.6945381164551,14.0619897842408 53.6945381164551,14.0531702041627 53.6949195861816,14.0504951477051 53.695571899414,14.0482044219971 53.6979751586915,14.0449075698853 53.6978797912598,14.0447235107422 53.6954231262208,14.0483942031861 53.6950912475587,14.0454835891725 53.6945190429688,14.045283317566 53.6909332275392,14.0434064865112 53.6905937194825,14.0385007858276 53.6863212585449,14.0313138961793 53.6778793334961,14.0339994430543 53.6726913452148,14.0377731323243 53.6719703674318,14.0350542068481 53.6697731018066,14.0344142913819 53.6674156188966,14.0325613021852 53.667652130127,14.0303344726564 53.6621322631837,14.0252246856691 53.6617698669434,14.0240268707276 53.660816192627,13.986879348755 53.6536293029786,13.986879348755 53.6536293029786,13.9759349822997 53.6513824462891,13.9744281768799 53.6535644531251,13.9662685394287 53.6552963256837,13.948031425476 53.6540679931641,13.9446945190431 53.6521835327149,13.9443140029908 53.650203704834,13.9402942657471 53.6494216918945,13.9401979446412 53.6503486633301,13.9377985000611 53.6485252380372,13.9205541610718 53.6516036987305,13.9196786880494 53.6572418212891,13.9075136184692 53.6577453613282,13.9042730331421 53.6523056030273,13.9051132202149 53.6514358520508,13.9123497009278 53.6525955200196,13.9085741043092 53.6451530456543,13.9006099700927 53.6459007263184,13.9006099700927 53.6459007263184,13.8900346755983 53.6307754516602,13.8922843933106 53.6303253173829,13.891121864319 53.6286048889161,13.8944454193116 53.6213378906251,13.8964786529542 53.6212158203125,13.8962602615356 53.6197662353516,13.8962602615356 53.6197662353516,13.9036407470704 53.620319366455,13.9138422012329 53.6186256408691,13.9128150939941 53.616325378418,13.9337759017945 53.6179733276367,13.9369935989381 53.6138801574707,13.9340467453004 53.6108436584473,13.9362316131593 53.609188079834,13.9326639175416 53.6097908020021,13.9372444152832 53.604949951172,13.9408311843872 53.6038246154786,13.9408311843872 53.6038246154786,13.9420871734619 53.6145935058594,13.9437408447267 53.6156196594238,13.9518842697144 53.6139450073242,13.9561443328857 53.6117744445801,13.9712305068971 53.6148757934571,13.9778041839601 53.6032028198243,13.9805011749268 53.6030654907226,13.982216835022 53.607334136963,13.9875354766846 53.6070785522461,13.9884853363038 53.6091194152832,13.9882335662842 53.6116523742676,13.9905290603638 53.612361907959,13.9930238723755 53.6117782592775,13.992693901062 53.6076507568359,13.9932098388672 53.6061630249023,13.9954071044923 53.6052627563477,13.9959955215455 53.6027603149415,14.0050554275514 53.5982704162598,14.0050554275514 53.5982704162598,14.006675720215 53.5994300842286,14.0116949081421 53.5992126464845,14.0181360244752 53.5971412658692,14.0249814987183 53.5965156555176,14.0293674468995 53.599521636963,14.0283241271974 53.6013946533203,14.0354328155518 53.601963043213,14.0386829376221 53.5996932983398,14.0395298004152 53.5967102050782,14.0430545806885 53.5942993164062,14.0443201065063 53.5910758972169,14.04780960083 53.5889892578125,14.0441312789918 53.5842704772949,14.0670204162599 53.5885353088379,14.0721988677979 53.5836334228516,14.0813102722169 53.5927963256836,14.114377975464 53.6077575683594))	0.0006	POINT(14.011700687408496 53.64366923014324)
1399278	POLYGON((-3.65820407867432 42.1629486083986,-3.66283702850342 42.1601524353028,-3.67364001274109 42.162940979004,-3.67451095581049 42.1687202453614,-3.69623088836664 42.1798477172852,-3.7025899887085 42.179901123047,-3.70747590065002 42.1848869323731,-3.7150568962096 42.1880073547364,-3.7167661190033 42.1871795654298,-3.71784210205078 42.1912422180177,-3.72970700263971 42.2035255432129,-3.74578905105579 42.2042922973633,-3.76153302192688 42.21004486084,-3.76314902305597 42.2123680114747,-3.75997400283813 42.218360900879,-3.74843502044678 42.224178314209,-3.72777891159058 42.2267341613771,-3.71818804740906 42.2240676879883,-3.70622301101685 42.2255859375,-3.6638770103454 42.205291748047,-3.6592481136322 42.1922874450684,-3.66187095642084 42.1836280822755,-3.65765905380243 42.1826248168945,-3.65393304824829 42.1759719848633,-3.65820407867432 42.1629486083986))	0.0006	POINT(-3.703438301881128 42.1939495404562)
1400330	POLYGON((-5.12806415557861 40.9485740661622,-5.13372993469238 40.9503669738771,-5.13502407073975 40.9481735229493,-5.14025115966797 40.9477462768556,-5.14083576202381 40.9441909790039,-5.14670991897577 40.9414443969727,-5.16852998733521 40.9374160766602,-5.17862701416016 40.9367218017579,-5.18299102783203 40.9412231445313,-5.18017387390137 40.9447631835938,-5.18376398086542 40.9469985961915,-5.19079494476318 40.9562683105469,-5.19548320770264 40.9547233581544,-5.19707584381098 40.957618713379,-5.20697689056396 40.9648399353028,-5.20647096633911 40.9671020507813,-5.21022701263428 40.9671592712402,-5.21308517456049 40.9722633361818,-5.20710897445673 40.9748725891114,-5.2080779075622 40.9785766601563,-5.20462703704834 40.9802818298341,-5.20357418060303 40.9843368530274,-5.19879007339478 40.9863204956056,-5.19901323318481 40.9880180358887,-5.18996095657349 40.9874420166017,-5.1882472038269 40.9884376525879,-5.18808698654169 40.9958610534669,-5.17985105514526 40.9966506958008,-5.17540216445923 41.0001487731935,-5.174232006073 41.0036735534669,-5.16386222839355 41.0076141357422,-5.1608772277832 41.0050315856934,-5.15664005279535 41.0052642822266,-5.15614795684814 41.0029335021973,-5.15040588378906 41.0022544860839,-5.14815711975098 40.9970283508301,-5.14174604415888 40.9940071105958,-5.13530921936029 40.9875946044922,-5.13412714004517 40.9822120666505,-5.13141393661499 40.9795608520508,-5.13218688964844 40.9737014770509,-5.12900114059448 40.9710578918458,-5.13223314285273 40.9607009887696,-5.12795686721802 40.959644317627,-5.12625694274897 40.9566497802735,-5.1274938583374 40.9541130065919,-5.12806415557861 40.9485740661622))	0.0006	POINT(-5.16760005121644 40.97242570960008)
60235	POLYGON((9.21100044250494 46.7634544372559,9.20612430572504 46.7727355957032,9.20630168914806 46.7755012512208,9.20848464965815 46.7776107788085,9.20848464965815 46.7776107788085,9.21002197265631 46.7838249206543,9.21002197265631 46.7838249206543,9.20449447631836 46.7878417968751,9.20449447631836 46.7878417968751,9.19901180267328 46.7862892150878,9.18543529510498 46.7846946716309,9.18543529510498 46.7846946716309,9.18305969238281 46.7819900512696,9.17823123931896 46.780948638916,9.17534255981445 46.779209136963,9.16729736328131 46.7811813354493,9.16729736328131 46.7811813354493,9.16205596923828 46.7811508178712,9.15975856781006 46.7799453735352,9.15846443176264 46.7777137756347,9.15846443176264 46.7777137756347,9.16652393341076 46.7749366760254,9.17487716674816 46.7749366760254,9.17487716674816 46.7749366760254,9.17736721038824 46.7743453979493,9.18156909942638 46.7715034484864,9.1945686340332 46.7713356018067,9.20156860351562 46.7699203491212,9.20402145385748 46.7687759399415,9.20660591125494 46.764461517334,9.21100044250494 46.7634544372559))	0.0006	POINT(9.187708727518745 46.777737045288106)
44330	POLYGON((0.445306360721588 43.3923377990724,0.442599862814006 43.3979682922364,0.442599862814006 43.3979682922364,0.434949696063995 43.411750793457,0.434949696063995 43.411750793457,0.42598989605915 43.4102783203126,0.420580297708511 43.4155502319336,0.407172143459434 43.4152374267579,0.407172143459434 43.4152374267579,0.406181395053977 43.4084548950196,0.395494014024734 43.4020767211915,0.395494014024734 43.4020767211915,0.401829570531902 43.4006538391114,0.401829570531902 43.4006538391114,0.407674431800842 43.3961410522461,0.411514371633587 43.3843154907227,0.41575700044632 43.3841018676758,0.41575700044632 43.3841018676758,0.433752059936637 43.3865547180176,0.445306360721588 43.3923377990724))	0.0006	POINT(0.4182422835576355 43.40090580990445)
35146	POLYGON((8.89728832244879 42.1411895751954,8.89422798156744 42.1465225219728,8.88688182830805 42.1478881835939,8.88688182830805 42.1478881835939,8.84002304077148 42.1392631530762,8.83440685272228 42.1308784484863,8.83440685272228 42.1308784484863,8.82092475891113 42.1229782104492,8.82086849212652 42.1164321899413,8.82086849212652 42.1164321899413,8.84623908996582 42.1117439270021,8.85343074798584 42.1031646728516,8.86992835998535 42.0988731384278,8.86992835998535 42.0988731384278,8.8733749389649 42.1082878112794,8.89357852935797 42.1278877258301,8.89728832244879 42.1411895751954))	0.0006	POINT(8.858953654766111 42.12432384490972)
66828	POLYGON((8.93152236938471 49.3225593566895,8.93324279785162 49.3246688842775,8.93324279785162 49.3246688842775,8.93133640289307 49.3278465270996,8.92663764953619 49.3258628845215,8.91244888305658 49.3257522583008,8.90949153900146 49.3273658752442,8.89312458038336 49.328971862793,8.89046669006342 49.3298225402833,8.89015865325939 49.3328514099121,8.8856601715089 49.3327522277833,8.88044834136969 49.3297233581544,8.88044834136969 49.3297233581544,8.88373851776129 49.3264350891114,8.88387489318853 49.322811126709,8.88284873962408 49.3201599121094,8.88033962249756 49.3194656372071,8.8777494430542 49.3162879943848,8.87979221343994 49.3111991882325,8.87722492218018 49.3081741333008,8.86920547485352 49.305233001709,8.86931610107422 49.3040199279785,8.86931610107422 49.3040199279785,8.87670707702637 49.3059692382814,8.88558769226086 49.3045959472657,8.89071178436279 49.3048400878907,8.89312171936047 49.3072509765626,8.89456844329845 49.3067855834961,8.89712047576916 49.3078384399415,8.89956951141363 49.3107147216798,8.9117517471314 49.3143730163575,8.91431427001953 49.3176269531249,8.93152236938471 49.3225593566895))	0.0006	POINT(8.894846498966253 49.31813657283787)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point