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
51374	POLYGON((2.37755012512213 49.6982078552247,2.38116574287415 49.695915222168,2.3903598785401 49.6985778808594,2.39987444877636 49.696434020996,2.41359829902649 49.7004356384278,2.41359829902649 49.7004356384278,2.42228603363043 49.6929206848145,2.42127084732061 49.683479309082,2.42127084732061 49.683479309082,2.40518260002148 49.6807060241699,2.40518260002148 49.6807060241699,2.3951349258424 49.6813507080079,2.38215088844299 49.6866111755371,2.3774721622467 49.6852607727052,2.3774721622467 49.6852607727052,2.37071752548229 49.6928253173828,2.37276291847235 49.6954689025879,2.37276291847235 49.6954689025879,2.37603402137751 49.6975708007812,2.37603402137751 49.6975708007812,2.37755012512213 49.6982078552247))	0.0006	POINT(2.3925940632820555 49.69143428802493)
23868	POLYGON((3.99531126022345 46.4251022338868,3.98411798477167 46.4196624755859,3.9846334457398 46.4164772033691,3.9846334457398 46.4164772033691,3.98798942565918 46.4076499938966,3.97756862640387 46.3978691101075,3.97756862640387 46.3978691101075,3.96137356758118 46.3976936340333,3.96137356758118 46.3976936340333,3.96423077583319 46.42094039917,3.94363808631908 46.4379501342773,3.94363808631908 46.4379501342773,3.93944692611706 46.4441795349121,3.95235800743103 46.4539604187012,3.95099854469305 46.4641761779785,3.96514821052551 46.4779968261719,3.96514821052551 46.4779968261719,3.97433996200562 46.4795684814454,3.97908902168268 46.4739799499512,3.99872207641613 46.4649047851563,4.00154161453253 46.4587554931641,4.00154161453253 46.4587554931641,3.9975318908692 46.4525566101074,4.00430059432989 46.4437103271485,4.00269126892096 46.4404983520508,3.98928880691528 46.4369888305664,3.99531126022345 46.4251022338868))	0.0006	POINT(3.9764701403104734 46.43851397587704)
13173	POLYGON((16.424566268921 39.5747413635255,16.4235000610351 39.5846900939943,16.4243392944337 39.5915260314943,16.4347972869874 39.6095962524415,16.4438991546631 39.6189727783203,16.4438991546631 39.6189727783203,16.4451332092286 39.6268424987794,16.4451332092286 39.6268424987794,16.4431991577148 39.6296958923341,16.4323043823242 39.6318664550782,16.4293041229249 39.6311111450196,16.4230365753174 39.6254348754882,16.4230365753174 39.6254348754882,16.4139709472656 39.6073379516602,16.4112224578859 39.6044731140137,16.4082736968995 39.603858947754,16.4046478271484 39.5782814025879,16.4045009613038 39.5710296630861,16.4057426452637 39.5685615539551,16.4057426452637 39.5685615539551,16.424566268921 39.5747413635255))	0.0006	POINT(16.424512481689494 39.604891586303765)
22334	POLYGON((-0.243758201599064 45.002025604248,-0.24808669090271 45.0021934509277,-0.24808669090271 45.0021934509277,-0.257242500782013 45.0034675598146,-0.269652456045151 44.9995536804199,-0.284046858549061 45.0117454528809,-0.284046858549061 45.0117454528809,-0.269960641860962 45.0120086669922,-0.266574978828373 45.0216941833497,-0.274121135473251 45.0342712402345,-0.271696478128376 45.0408401489258,-0.271696478128376 45.0408401489258,-0.260827302932682 45.0456085205078,-0.250472366809845 45.0402259826661,-0.250472366809845 45.0402259826661,-0.246390312910023 45.0176277160645,-0.236432984471264 45.0110969543458,-0.236432984471264 45.0110969543458,-0.243758201599064 45.002025604248))	0.0006	POINT(-0.2594443493418906 45.019358952840214)
1398720	POLYGON((-3.98263907432556 42.2276458740234,-3.98827290534973 42.2329902648926,-4.00687122344971 42.2349815368652,-4.01438522338867 42.2419052124025,-4.01376295089722 42.250701904297,-4.02758979797363 42.2645721435547,-4.00466394424427 42.2556457519532,-3.98804306983948 42.255573272705,-3.97660398483276 42.2644500732421,-3.9662680625915 42.2657470703126,-3.9607200622558 42.2564888000489,-3.95229697227478 42.2486419677734,-3.95835494995106 42.2419471740723,-3.96171188354492 42.2420997619629,-3.96146297454828 42.2432518005372,-3.96873211860645 42.2397155761719,-3.97012400627131 42.2372817993165,-3.96868109703058 42.2349243164063,-3.97101497650135 42.2354164123535,-3.97155094146729 42.2324142456055,-3.97457695007319 42.2297744750977,-3.97728300094599 42.2331199645996,-3.97606992721552 42.2284393310547,-3.97971701622009 42.2282562255859,-3.97797107696533 42.2258644104004,-3.97943711280811 42.2251091003418,-3.97930908203119 42.2270011901855,-3.98263907432556 42.2276458740234))	0.0006	POINT(-3.9799301624297696 42.24088739465787)
12421	POLYGON((13.7124271392823 42.1439018249512,13.7156858444215 42.1533241271974,13.7156858444215 42.1533241271974,13.7323627471924 42.1442527770996,13.7439441680908 42.1430091857911,13.7527942657471 42.1385040283204,13.763752937317 42.1312065124513,13.763752937317 42.1312065124513,13.7596235275269 42.1245307922364,13.7596235275269 42.1245307922364,13.7501525878906 42.1251296997071,13.7378520965577 42.1213455200196,13.7263545989991 42.1088905334474,13.7233266830445 42.1036949157716,13.7180261611939 42.0822753906251,13.7174196243287 42.0739288330078,13.7216777801515 42.0635566711426,13.7233047485352 42.0631523132324,13.7233047485352 42.0631523132324,13.7220582962036 42.0626754760742,13.7220582962036 42.0626754760742,13.7181644439697 42.0621566772462,13.7098083496094 42.0648193359376,13.706823348999 42.064811706543,13.706823348999 42.064811706543,13.7058172225953 42.0650177001954,13.7058172225953 42.0650177001954,13.7002220153809 42.0678749084474,13.6942205429078 42.0734596252441,13.688835144043 42.0827674865722,13.6907100677491 42.0866317749025,13.6907100677491 42.0866317749025,13.6970577239991 42.086009979248,13.7023458480836 42.0905532836914,13.7009563446045 42.0929183959962,13.7011222839356 42.0954322814942,13.7092685699463 42.1039390563964,13.7178535461426 42.1214065551758,13.7187957763672 42.1268882751465,13.7124271392823 42.1439018249512))	0.0006	POINT(13.719757446875992 42.097933744772945)
45454	POLYGON((0.383288651704788 43.3066864013672,0.382732987403926 43.3134956359864,0.391885876655579 43.32914352417,0.385863453149909 43.3336181640626,0.385863453149909 43.3336181640626,0.386634469032344 43.3361930847169,0.393631309270916 43.3374404907227,0.393631309270916 43.3374404907227,0.395822793245316 43.3342437744142,0.418737828731651 43.3280792236329,0.442971318960247 43.3279266357423,0.442971318960247 43.3279266357423,0.440159350633564 43.3140716552734,0.431304067373333 43.3061637878418,0.431304067373333 43.3061637878418,0.431359350681362 43.3060302734376,0.431359350681362 43.3060302734376,0.400109767913875 43.3020896911622,0.383288651704788 43.3066864013672))	0.0006	POINT(0.4094239291218098 43.3214645385743)
45294	POLYGON((-0.0101750269532204 43.542236328125,0.00683084409683943 43.5375022888183,0.0151407346129417 43.5400161743165,0.0157821346074343 43.5433921813966,0.0157821346074343 43.5433921813966,0.00946008227776929 43.5578308105469,0.00946008227776929 43.5578308105469,-0.00166577007621527 43.5653228759766,-0.00166577007621527 43.5653228759766,-0.0236993543803123 43.5522575378418,-0.0236993543803123 43.5522575378418,-0.023353423923254 43.5468673706055,-0.023353423923254 43.5468673706055,-0.0112271290271906 43.5453033447266,-0.0101750269532204 43.542236328125))	0.0006	POINT(-0.003313088589984702 43.549742834908656)
1406012	POLYGON((-0.899652004241887 38.2680740356446,-0.913958013057709 38.2813301086426,-0.923729002475625 38.2830924987794,-0.929256021976471 38.2816925048829,-0.935003995895329 38.2834053039551,-0.934853017330113 38.2850532531738,-0.938906013965607 38.2844924926758,-0.94192498922348 38.2860145568848,-0.948611974716187 38.2836456298828,-0.95691800117487 38.297306060791,-0.971395015716553 38.3296432495117,-0.958481013774872 38.3283576965332,-0.942843973636627 38.3288002014161,-0.937489986419678 38.3303947448732,-0.925508975982609 38.3293724060059,-0.896938025951329 38.340690612793,-0.873766005039158 38.3478126525879,-0.869937002658844 38.3433876037599,-0.858579993247986 38.3382377624513,-0.858713984489441 38.3352317810059,-0.852833986282349 38.3324546813965,-0.846933007240239 38.3331565856934,-0.846397995948792 38.3315505981445,-0.836637973785344 38.3265800476075,-0.840137004852295 38.3259239196777,-0.839784026145935 38.3239440917969,-0.833932995796204 38.3137512207031,-0.828805029392242 38.3085670471191,-0.825416028499603 38.2906227111816,-0.865606009960118 38.2815780639648,-0.875308990478459 38.2777519226075,-0.885673999786377 38.2696228027344,-0.894478023052102 38.2659263610841,-0.895870983600616 38.2639884948731,-0.899652004241887 38.2680740356446))	0.0006	POINT(-0.8936553842880897 38.30680746190691)
60375	POLYGON((8.2406578063966 47.1627120971679,8.23568344116222 47.1668930053712,8.23481464385986 47.1707763671875,8.23634433746344 47.1764945983888,8.23417472839361 47.1836471557618,8.23438835144054 47.187427520752,8.23011207580578 47.1903991699219,8.22923755645763 47.194248199463,8.22688484191906 47.1983108520508,8.22688484191906 47.1983108520508,8.22710132598883 47.2062721252443,8.22528171539312 47.2123718261719,8.22639465332037 47.2166862487794,8.22639465332037 47.2166862487794,8.23289012908936 47.212013244629,8.23289012908936 47.212013244629,8.23333072662365 47.2084617614747,8.23608207702642 47.2082862854004,8.23881244659418 47.2099342346191,8.24233627319342 47.2068672180175,8.24236583709728 47.2047309875489,8.239821434021 47.2003364562989,8.24402236938482 47.1927185058594,8.24487209320074 47.1890716552734,8.24793720245373 47.188949584961,8.26067543029779 47.1944198608398,8.26067543029779 47.1944198608398,8.26242256164551 47.1935005187989,8.26762962341303 47.1867485046387,8.27440738677979 47.181667327881,8.27611541748047 47.1816711425782,8.27611541748047 47.1816711425782,8.28095912933361 47.1791954040528,8.28477191925043 47.1758689880372,8.28682518005377 47.1697616577148,8.28630924224859 47.167194366455,8.28095722198481 47.1649017333985,8.28077983856201 47.1625823974609,8.2832174301148 47.1600685119629,8.28434085845947 47.1572227478028,8.28888416290289 47.1564292907715,8.29150772094732 47.1545257568359,8.28890419006342 47.1502990722657,8.28837299346935 47.147102355957,8.28626632690424 47.1448326110841,8.28626632690424 47.1448326110841,8.28035926818848 47.1457862854005,8.27134513854986 47.1503829956055,8.26993656158459 47.1520118713379,8.26807785034185 47.1522865295411,8.26465797424328 47.1507682800294,8.2627849578858 47.1468238830566,8.25421619415295 47.1451148986816,8.25421619415295 47.1451148986816,8.25592041015625 47.1479644775392,8.25606155395513 47.1529159545899,8.2525053024292 47.1584815979004,8.2406578063966 47.1627120971679))	0.0006	POINT(8.256775454471027 47.17738924528426)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point