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
1402318	POLYGON((-5.79798603057856 42.099967956543,-5.79901218414307 42.1015892028809,-5.80989503860468 42.0982971191407,-5.824049949646 42.0982284545899,-5.82470703125 42.096363067627,-5.82848787307734 42.094425201416,-5.83605909347534 42.0963478088379,-5.83555793762207 42.0989532470703,-5.84658193588257 42.1007499694824,-5.84402894973749 42.1044883728028,-5.84472894668579 42.1107025146486,-5.84069013595575 42.1125946044923,-5.83795309066767 42.1187591552734,-5.83195686340326 42.1193580627443,-5.81202602386475 42.1265296936036,-5.80637121200562 42.1305389404298,-5.80451583862305 42.1298484802247,-5.8062481880188 42.1277351379396,-5.80521297454823 42.1245727539063,-5.80130195617676 42.121192932129,-5.79667615890503 42.1084060668946,-5.79750299453735 42.1052360534669,-5.79503011703491 42.105899810791,-5.79296779632568 42.1040840148927,-5.79273986816401 42.1027679443359,-5.79677581787109 42.102165222168,-5.79798603057856 42.099967956543))	0.0006	POINT(-5.815733231030956 42.109223145705066)
53343	POLYGON((7.14131164550787 43.8414764404297,7.12861633300776 43.84859085083,7.12861633300776 43.84859085083,7.10076141357416 43.8274383544922,7.08867073059082 43.8226776123047,7.08867073059082 43.8226776123047,7.1020703315736 43.8189735412599,7.10859394073492 43.8138160705567,7.13168001174921 43.8090248107911,7.13256406784069 43.805591583252,7.13256406784069 43.805591583252,7.15618038177496 43.8163719177246,7.14250516891491 43.8249778747559,7.14131164550787 43.8414764404297))	0.0006	POINT(7.121754242823704 43.82352300790642)
61164	POLYGON((7.20085716247553 46.1640968322755,7.19137620925909 46.1589965820313,7.18684005737316 46.1606292724609,7.18052196502697 46.1607856750489,7.16804218292236 46.1579055786134,7.16804218292236 46.1579055786134,7.15552997589117 46.152027130127,7.15282392501837 46.1484756469727,7.14524793624889 46.1436157226562,7.14524793624889 46.1436157226562,7.15992498397821 46.1282043457031,7.15969085693371 46.1264724731445,7.15354490280163 46.1176376342775,7.15354490280163 46.1176376342775,7.16733694076538 46.1186294555663,7.17788887023926 46.1162796020509,7.189684867859 46.1174201965332,7.19915580749512 46.1151657104493,7.19915580749512 46.1151657104493,7.20332479476923 46.1207466125489,7.21153402328491 46.122184753418,7.21567392349243 46.1244735717774,7.22177219390869 46.1245079040527,7.22513484954834 46.1267967224121,7.22513484954834 46.1267967224121,7.22842884063732 46.1289062500001,7.22863721847528 46.1305923461915,7.22313499450695 46.133918762207,7.22463893890387 46.1368637084962,7.22267103195202 46.139045715332,7.22179985046398 46.1422348022462,7.2175807952882 46.1474304199218,7.21531915664684 46.1532745361329,7.21348905563354 46.1557235717774,7.20085716247553 46.1640968322755))	0.0006	POINT(7.192727411494582 46.13629890890685)
68748	POLYGON((13.9980545043946 51.3112106323242,13.9962339401246 51.3118400573732,13.9930753707886 51.3097915649415,13.9885797500611 51.3100166320801,13.9813022613526 51.3086128234863,13.9801187515259 51.3064575195312,13.9774217605592 51.3059425354003,13.9777727127076 51.3079338073731,13.9749813079833 51.308448791504,13.9756479263306 51.3102378845215,13.9818105697632 51.3111534118652,13.9848899841309 51.3132972717286,13.9796314239503 51.3135070800781,13.9789571762086 51.3146705627443,13.9773063659669 51.3145027160646,13.9735021591187 51.316463470459,13.973183631897 51.3143386840821,13.9646310806274 51.3173828125001,13.95356464386 51.3173942565917,13.9532842636108 51.3186340332031,13.9461793899536 51.3203048706056,13.9367561340333 51.3209686279297,13.9347648620605 51.3197021484376,13.9326257705689 51.320125579834,13.9326257705689 51.320125579834,13.9232378005983 51.3218307495118,13.9080228805542 51.3186378479004,13.8994140625001 51.3182563781739,13.9011888504028 51.3144493103028,13.9117708206177 51.3104400634766,13.899577140808 51.3015785217285,13.8934774398804 51.3008918762208,13.8928518295288 51.299602508545,13.8900823593141 51.2996559143066,13.8896780014039 51.2982635498047,13.8928956985475 51.2978630065919,13.8936958312988 51.2925453186036,13.9003086090087 51.2850227355957,13.9077520370483 51.2852554321288,13.9101142883301 51.2801094055176,13.9095134735109 51.2764587402345,13.9155778884888 51.2767066955568,13.9173269271851 51.2739639282228,13.9117450714112 51.271297454834,13.9137392044067 51.269142150879,13.9299640655518 51.2647132873536,13.9332933425904 51.264892578125,13.9325189590454 51.2629699707031,13.9325189590454 51.2629699707031,13.9410705566407 51.262523651123,13.9562749862672 51.2667655944825,13.9688997268677 51.2612953186036,13.9937572479249 51.2604408264161,13.9937572479249 51.2604408264161,13.9937438964844 51.2625389099122,13.9983386993409 51.2697410583496,14.0034713745117 51.2753067016603,14.0029602050782 51.2770805358887,14.0078868865967 51.2874717712402,14.0023107528687 51.2896995544435,13.9985914230347 51.2942543029786,13.9961166381837 51.3031005859376,14.004940032959 51.3067016601563,13.9993515014649 51.3091735839844,13.9980545043946 51.3112106323242))	0.0006	POINT(13.951853722333952 51.29651743173601)
19280	POLYGON((11.1988525390626 43.3271293640136,11.2050409317017 43.3236274719239,11.2149686813356 43.3199043273926,11.2172298431397 43.3196716308594,11.2274408340455 43.3223838806152,11.2315225601196 43.3227233886719,11.2326364517213 43.3219223022461,11.2326364517213 43.3219223022461,11.2403202056884 43.3236351013185,11.2421426773072 43.3196411132812,11.2509765625 43.3201141357423,11.2598628997804 43.3253364562989,11.2629642486573 43.3318939208985,11.2602405548096 43.3341979980469,11.2661876678467 43.3535194396973,11.2720794677736 43.3526840209962,11.2806568145753 43.3475074768068,11.3068380355835 43.3444404602052,11.3131608963013 43.3500328063965,11.3158693313599 43.3591957092285,11.3158693313599 43.3591957092285,11.3137636184693 43.3655052185059,11.3143472671509 43.3684921264649,11.3112363815308 43.3908843994142,11.3056211471558 43.410472869873,11.3056211471558 43.410472869873,11.3010454177856 43.4106292724609,11.2921237945557 43.4065933227539,11.284083366394 43.4006423950196,11.2795906066895 43.4046745300294,11.2686939239503 43.4051895141603,11.2589426040651 43.403995513916,11.2567100524903 43.4000511169434,11.2564992904663 43.3963737487793,11.2535400390626 43.3908309936524,11.2513084411621 43.3892288208008,11.247323036194 43.3903045654298,11.2444849014283 43.3936920166016,11.2401523590088 43.394702911377,11.2287502288819 43.3965644836426,11.2202482223511 43.3960304260254,11.217755317688 43.3984298706055,11.2144260406494 43.4053535461426,11.2154150009156 43.4152107238771,11.2128944396974 43.4175300598144,11.207989692688 43.4178657531739,11.207989692688 43.4178657531739,11.20964717865 43.415195465088,11.2085046768188 43.4116516113282,11.2016792297363 43.4062919616699,11.1803979873658 43.4024238586427,11.1760063171387 43.4040031433105,11.1760063171387 43.4040031433105,11.1631298065187 43.3942985534668,11.1518077850342 43.3915214538575,11.146430015564 43.391658782959,11.1346197128296 43.3872413635254,11.129379272461 43.3729515075684,11.122320175171 43.3634338378907,11.1254262924194 43.3583755493164,11.1341037750244 43.3492889404298,11.1341037750244 43.3492889404298,11.1539268493653 43.3509826660157,11.1654729843141 43.3550415039064,11.1947526931763 43.3461532592773,11.1998100280762 43.3399505615236,11.1964797973633 43.3300247192384,11.1970357894898 43.3283805847169,11.1988525390626 43.3271293640136))	0.0006	POINT(11.22881019816684 43.37132981244258)
1397372	MULTIPOLYGON(((-3.07951807975769 40.8432540893556,-3.07750701904291 40.8489570617676,-3.07428193092341 40.8517608642579,-3.07032108306885 40.8518447875978,-3.07189607620234 40.8468360900879,-3.07734298706049 40.8410301208497,-3.07951807975769 40.8432540893556)),((-3.07597589492786 40.8076286315919,-3.08065891265869 40.8079299926758,-3.08340096473688 40.8101997375488,-3.08749008178711 40.8093948364258,-3.09457397460932 40.8117408752441,-3.0999178886413 40.8110427856445,-3.10130190849293 40.8157081604005,-3.09961700439453 40.8227729797363,-3.10148191452026 40.8255004882814,-3.09545803070068 40.8339157104493,-3.08989691734314 40.8344726562501,-3.08464598655701 40.8380165100099,-3.08191299438471 40.8343162536622,-3.07930302619934 40.8339385986328,-3.0700569152832 40.8259620666505,-3.07711291313171 40.8158607482911,-3.07597589492786 40.8076286315919)))	0.0006	POINT(-3.0867145270874894 40.823153629477204)
23387	POLYGON((-0.641838610172272 43.380630493164,-0.628960013389531 43.3909950256349,-0.608501791954041 43.4003181457521,-0.608501791954041 43.4003181457521,-0.611692488193512 43.4056930541993,-0.624197423458043 43.4018440246583,-0.633240759372654 43.4028587341309,-0.633240759372654 43.4028587341309,-0.634864330291691 43.3980560302735,-0.634864330291691 43.3980560302735,-0.645071148872319 43.3866348266602,-0.641838610172272 43.380630493164))	0.0006	POINT(-0.6277248588474953 43.39711484042089)
70461	POLYGON((12.086452484131 50.76957321167,12.0870008468629 50.7652740478517,12.0813159942627 50.7637481689454,12.073006629944 50.7639236450196,12.07399559021 50.7621269226075,12.0754804611207 50.7615432739258,12.0755262374879 50.7591361999512,12.076810836792 50.7593383789064,12.0770502090454 50.7580299377441,12.0809173583984 50.7582740783692,12.0722608566285 50.7531700134278,12.0681819915773 50.7542152404785,12.0674114227296 50.753677368164,12.071538925171 50.7519569396973,12.0742139816285 50.7480049133302,12.0843887329102 50.746868133545,12.0867204666138 50.751163482666,12.0920839309692 50.7524490356446,12.0950469970704 50.7520027160646,12.0950469970704 50.7520027160646,12.0962457656861 50.7542724609375,12.1005592346193 50.7575874328613,12.0968265533448 50.7604675292969,12.1001234054566 50.7618522644044,12.0985202789307 50.7622604370117,12.1015844345094 50.7655410766602,12.1015844345094 50.7655410766602,12.1006078720094 50.7668685913086,12.09831905365 50.7675628662111,12.096251487732 50.7656211853027,12.0929927825929 50.7670249938965,12.092740058899 50.7687759399414,12.086452484131 50.76957321167))	0.0006	POINT(12.086587697267609 50.75937044620518)
47870	POLYGON((2.23670935630804 50.7689170837403,2.24486637115473 50.7722053527833,2.24398469924932 50.7753067016602,2.23180532455456 50.7851371765137,2.23180532455456 50.7851371765137,2.21039605140686 50.7650375366212,2.18673777580267 50.7564582824707,2.18673777580267 50.7564582824707,2.18887162208563 50.7504806518555,2.18887162208563 50.7504806518555,2.2020308971405 50.7554931640626,2.2020308971405 50.7554931640626,2.22195434570307 50.7659988403321,2.23670935630804 50.7689170837403))	0.0006	POINT(2.2136001586914413 50.76481569730325)
18912	POLYGON((13.3952865600587 37.8565635681153,13.3979988098145 37.8569679260254,13.3990497589112 37.8594055175782,13.3976173400879 37.8683166503907,13.3920440673829 37.8820724487306,13.4033842086793 37.8976745605469,13.4144525527955 37.9097023010254,13.4144525527955 37.9097023010254,13.4327487945557 37.9063034057618,13.4327487945557 37.9063034057618,13.4382991790771 37.9045600891113,13.4406480789185 37.902717590332,13.4416265487671 37.8967552185059,13.4382057189941 37.8928413391114,13.435591697693 37.8928184509278,13.4315452575683 37.8900833129884,13.4322242736817 37.8826789855958,13.4376058578492 37.8770980834962,13.4386320114136 37.8726768493652,13.4327421188355 37.8657722473146,13.444622039795 37.8441009521485,13.4488134384155 37.8408088684083,13.4488134384155 37.8408088684083,13.4432458877565 37.8322677612305,13.4306020736695 37.8197898864747,13.4266624450684 37.8202247619628,13.4048719406128 37.8138809204102,13.393147468567 37.8155822753906,13.3771934509277 37.8287467956544,13.3875045776368 37.8414955139161,13.3944129943848 37.853084564209,13.3952865600587 37.8565635681153))	0.0006	POINT(13.420864320570468 37.86715501354592)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point