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
72906	POLYGON((11.4255285263062 47.3183059692384,11.427306175232 47.3447341918945,11.427306175232 47.3447341918945,11.4314365386962 47.3441200256348,11.4347267150878 47.3419494628907,11.4436807632446 47.3289070129396,11.4467353820802 47.3265495300294,11.4550886154176 47.3241424560547,11.4807271957399 47.3204727172852,11.4884634017944 47.3172836303712,11.4927120208741 47.310214996338,11.4937992095948 47.3024139404297,11.4922599792481 47.2994766235352,11.4858722686768 47.2934951782228,11.4856615066529 47.2893867492676,11.4856615066529 47.2893867492676,11.4707803726196 47.2697830200196,11.4707803726196 47.2697830200196,11.455439567566 47.2660064697266,11.455439567566 47.2660064697266,11.4605588912964 47.2803535461426,11.4607477188111 47.2863197326661,11.457013130188 47.2889480590821,11.4421157836914 47.2938995361329,11.4373092651367 47.2964706420898,11.4331645965577 47.3021240234376,11.4255285263062 47.3183059692384))	0.0006	POINT(11.459242894099344 47.304433382474514)
1402320	POLYGON((-6.2136549949646 42.1121673583985,-6.21456193923945 42.1179389953614,-6.21301221847528 42.1212348937989,-6.20689296722406 42.1231498718263,-6.20187616348267 42.1330795288086,-6.21226501464832 42.1480598449707,-6.17025804519653 42.1581611633301,-6.1600837707519 42.165756225586,-6.1539192199707 42.1613082885742,-6.14327812194824 42.158805847168,-6.13996076583857 42.1480674743652,-6.13840293884266 42.1314582824707,-6.12165784835815 42.1208114624025,-6.13248109817505 42.1200485229493,-6.14420986175531 42.1170272827148,-6.15399599075312 42.1104927062988,-6.15487384796137 42.1057662963867,-6.16962909698481 42.1024055480958,-6.1780052185058 42.1064529418946,-6.2136549949646 42.1121673583985))	0.0006	POINT(-6.169632585425084 42.129589080810604)
1406642	MULTIPOLYGON(((-0.580624997615814 39.1835403442383,-0.584509015083256 39.1938362121583,-0.56344997882843 39.194507598877,-0.559692025184631 39.1933746337892,-0.541720986366215 39.1950874328613,-0.510118007659912 39.2090454101564,-0.512807011604309 39.2109527587892,-0.511595010757446 39.2134628295898,-0.502779006958008 39.215518951416,-0.481961995363235 39.2305374145508,-0.480747014284077 39.2068824768066,-0.491632014513016 39.1964683532715,-0.495094001293182 39.1880035400391,-0.502521991729679 39.1829109191895,-0.510827004909515 39.1811065673829,-0.511164009571019 39.1840133666993,-0.518149971961918 39.1871528625489,-0.520807027816716 39.1846351623536,-0.521555006504059 39.1749000549317,-0.547122001647892 39.173324584961,-0.556156992912292 39.1744613647462,-0.580624997615814 39.1835403442383)),((-0.500702977180481 39.1653022766113,-0.51475399732584 39.1625938415528,-0.514428019523564 39.1639671325684,-0.520416975021305 39.1684188842775,-0.5188289880752 39.1701316833497,-0.521310985088348 39.1742668151855,-0.516952991485596 39.1777305603027,-0.517310976982117 39.1761169433594,-0.508894026279393 39.1745529174805,-0.507682025432587 39.1731643676759,-0.503437995910645 39.1733436584473,-0.507604002952576 39.1714172363282,-0.501721978187504 39.1696205139161,-0.500702977180481 39.1653022766113)))	0.0006	POINT(-0.5231843163818295 39.19234405476373)
58401	POLYGON((8.07255935668951 49.7215423583985,8.06274414062506 49.7283172607422,8.06051349639893 49.7309226989746,8.05274200439453 49.727855682373,8.05274200439453 49.727855682373,8.03437519073486 49.7223930358887,8.02934455871582 49.7200775146484,8.02728366851812 49.714828491211,8.018479347229 49.7108917236329,8.018479347229 49.7108917236329,8.01905632019054 49.7083396911622,8.02319431304932 49.7091140747071,8.02328681945806 49.7081260681153,8.02800273895258 49.7079238891602,8.03200244903576 49.7065505981445,8.03396320343012 49.707546234131,8.03832054138195 49.705680847168,8.0396203994751 49.7033691406251,8.04521846771252 49.70516204834,8.04794216156006 49.7021255493165,8.05068397521973 49.7027778625489,8.05068397521973 49.7027778625489,8.05746746063238 49.7063636779786,8.0580043792724 49.7053756713868,8.06171703338634 49.708221435547,8.0606775283814 49.7090072631837,8.06311130523682 49.7102737426758,8.06241989135742 49.711036682129,8.06713676452648 49.7132606506349,8.07085418701172 49.7168693542481,8.06817531585693 49.719295501709,8.07255935668951 49.7215423583985))	0.0006	POINT(8.046154914363765 49.71241206507534)
1405418	POLYGON((-1.46866095066065 42.3258476257325,-1.47007203102112 42.3292274475098,-1.48149895668024 42.3334465026855,-1.48687100410456 42.3458213806152,-1.49458801746357 42.3495330810547,-1.50114595890039 42.3617057800294,-1.49480700492853 42.3622627258301,-1.49627304077148 42.3700332641602,-1.49316394329065 42.3715705871582,-1.47491705417633 42.3723106384277,-1.46661901473993 42.383373260498,-1.46291804313654 42.3847045898438,-1.44680595397938 42.3833694458008,-1.43617904186243 42.3877449035646,-1.42116594314575 42.3871688842774,-1.41740298271168 42.3894157409669,-1.41672599315643 42.39412689209,-1.42569494247431 42.3989219665528,-1.42611002922052 42.4047088623047,-1.42896103858948 42.4096832275391,-1.40619003772736 42.4072341918946,-1.3748379945755 42.3873863220215,-1.35715901851648 42.381462097168,-1.35973000526423 42.3783645629883,-1.35700404644007 42.3744163513184,-1.3505699634552 42.3700752258301,-1.34180903434748 42.3730354309083,-1.33617699146271 42.3720092773439,-1.33377301692957 42.3650779724121,-1.32974302768702 42.3613166809083,-1.3325560092926 42.3592071533204,-1.32903897762299 42.3553886413574,-1.33742201328278 42.3455505371094,-1.34313297271729 42.3425254821778,-1.3522310256958 42.339527130127,-1.37510704994202 42.3157272338868,-1.38361704349512 42.3037338256835,-1.39768004417419 42.2926368713379,-1.3994300365448 42.2973594665527,-1.40521395206446 42.301197052002,-1.40844905376434 42.3057899475098,-1.41191697120661 42.3048858642578,-1.41876602172852 42.3060760498047,-1.43248701095581 42.3158569335938,-1.44507896900177 42.3115692138672,-1.46866095066065 42.3258476257325))	0.0006	POINT(-1.411771138509082 42.35583080715605)
24806	POLYGON((2.68380808830267 45.7862777709962,2.67916798591625 45.7962341308595,2.68871498107922 45.8085861206055,2.67435383796703 45.82674407959,2.67435383796703 45.82674407959,2.66079401969915 45.8282623291016,2.65881109237671 45.8218803405763,2.65080857276922 45.8184890747071,2.65080857276922 45.8184890747071,2.63754463195806 45.8085060119629,2.64109802246099 45.7986755371094,2.65544223785406 45.7983055114746,2.67814707756054 45.7858924865722,2.67814707756054 45.7858924865722,2.68380808830267 45.7862777709962))	0.0006	POINT(2.665142859731478 45.80778421674461)
22350	POLYGON((-0.0454741902649403 44.9546928405762,-0.0488015674054054 44.960105895996,-0.0488015674054054 44.960105895996,-0.0531894490122795 44.9661064147949,-0.0671381577849388 44.9637832641602,-0.0708249136804966 44.9659805297853,-0.0818833634256748 44.9771156311036,-0.0841884613036541 44.990623474121,-0.0895939841866493 44.996078491211,-0.0895939841866493 44.996078491211,-0.104644782841149 44.9995498657228,-0.104644782841149 44.9995498657228,-0.112775400280839 44.9975395202638,-0.120951294898873 44.9904251098632,-0.120951294898873 44.9904251098632,-0.116508804261628 44.9806480407715,-0.118225567042828 44.9704360961914,-0.129300415515786 44.9598617553712,-0.129300415515786 44.9598617553712,-0.118667632341328 44.9532928466797,-0.115573123097363 44.9471626281739,-0.108328536152783 44.9428253173829,-0.0990201607345966 44.9422111511232,-0.0936742871999172 44.9370727539062,-0.0936742871999172 44.9370727539062,-0.0677331313490299 44.9507751464844,-0.0454741902649403 44.9546928405762))	0.0006	POINT(-0.0935947521087669 44.968822332528944)
53185	POLYGON((6.38735246658325 43.9763565063477,6.37696075439453 43.9858131408692,6.37766313552856 43.988826751709,6.37766313552856 43.988826751709,6.39616346359259 43.9904518127443,6.41703748703014 43.9975128173828,6.42799186706537 43.9910430908203,6.42799186706537 43.9910430908203,6.4325795173645 43.985179901123,6.42130613327038 43.9752883911134,6.42927026748663 43.9668884277345,6.42927026748663 43.9668884277345,6.4202446937561 43.9675865173341,6.41377210617077 43.9592666625978,6.39124155044567 43.9616355895997,6.38834190368652 43.9642562866212,6.39073181152349 43.9740257263184,6.38735246658325 43.9763565063477))	0.0006	POINT(6.406210731057592 43.97828764073995)
73897	POLYGON((16.9218502044677 42.9504318237305,16.9245147705079 42.9381332397461,16.9295845031739 42.9259147644044,16.925163269043 42.9081878662109,16.925163269043 42.9081878662109,16.9223613739015 42.9079170227051,16.9198608398438 42.9056930541992,16.9168701171876 42.9057006835937,16.9143047332764 42.903751373291,16.9115276336671 42.9043045043946,16.9101390838624 42.9023628234863,16.9059715270996 42.9001388549806,16.9026393890381 42.9006958007814,16.8987503051758 42.8990287780762,16.8962497711182 42.8990287780762,16.895414352417 42.897373199463,16.8934726715089 42.89652633667,16.8856945037842 42.8968048095704,16.8837509155273 42.8979148864747,16.8818035125732 42.8956909179688,16.8790893554688 42.89652633667,16.8762493133544 42.8948593139648,16.872917175293 42.8954162597656,16.8701362609863 42.8937492370607,16.8640270233155 42.8931961059571,16.862361907959 42.895694732666,16.8593063354493 42.8934707641603,16.8576393127442 42.8934707641603,16.8556957244873 42.8954162597656,16.8484725952148 42.8973617553711,16.8509712219239 42.8998603820802,16.8581943511964 42.9009704589844,16.8598613739013 42.9029159545899,16.859582901001 42.904582977295,16.8609714508057 42.9051399230958,16.8604946136475 42.9059715270997,16.8604946136475 42.9059715270997,16.8589267730713 42.9071350097657,16.8597927093506 42.9111328125001,16.8649139404297 42.9212493896485,16.8732166290284 42.9300575256348,16.8935890197754 42.9371986389161,16.9092292785645 42.9472007751465,16.9218502044677 42.9504318237305))	0.0006	POINT(16.885609782019348 42.90633339105654)
62801	POLYGON((12.7312936782837 54.2361297607422,12.7306194305421 54.2355575561523,12.7321138381959 54.2327194213867,12.7458257675171 54.2321815490724,12.7585163116456 54.2335243225097,12.7596683502198 54.2280044555665,12.7581186294557 54.2271156311035,12.7520236968995 54.2304801940917,12.7489795684815 54.2303161621094,12.7474613189698 54.2247467041016,12.7464981079103 54.2241973876954,12.7464981079103 54.2241973876954,12.7325267791749 54.230037689209,12.7240781784057 54.2255973815919,12.7206459045411 54.2262229919434,12.7177333831787 54.2247467041016,12.7155799865723 54.2117958068847,12.7046794891359 54.2078552246095,12.702003479004 54.2028694152832,12.7043924331664 54.1935577392579,12.6997661590576 54.1926574707031,12.7006044387818 54.1892852783204,12.6936979293824 54.1875076293945,12.6911783218385 54.1849670410157,12.687110900879 54.1835823059082,12.6790351867677 54.1832199096681,12.6727333068848 54.1751785278321,12.6704807281494 54.1672325134278,12.6636314392089 54.1662101745605,12.6592769622804 54.1670036315918,12.6557235717773 54.1663818359376,12.6519584655763 54.1614875793457,12.6439180374146 54.1580390930176,12.6425294876099 54.1599769592285,12.6401090621949 54.1586990356445,12.6242094039918 54.1457443237305,12.6230812072754 54.1461410522461,12.6230812072754 54.1461410522461,12.620771408081 54.1483535766603,12.6211366653442 54.1501808166503,12.6196231842042 54.1505317687989,12.6184148788453 54.1492919921876,12.6167020797729 54.1499519348146,12.6131629943848 54.1520576477052,12.6146526336671 54.1530952453613,12.6106615066528 54.1547317504883,12.6081552505494 54.1538696289064,12.6040449142457 54.154323577881,12.60169506073 54.155746459961,12.6043357849121 54.156852722168,12.604793548584 54.1580657958986,12.6086015701294 54.1580009460449,12.6092014312745 54.1586837768555,12.6083450317383 54.160270690918,12.6063814163209 54.1598739624023,12.6051940917969 54.1612663269043,12.6023283004761 54.1615142822267,12.6004848480225 54.1591720581055,12.5988130569457 54.1600608825685,12.5954141616822 54.1591033935547,12.5938119888306 54.1604690551758,12.5915641784668 54.1595726013184,12.5906295776368 54.1617546081544,12.5925292968751 54.1620979309083,12.5918912887573 54.1644172668458,12.5864028930665 54.1702690124512,12.5858297348023 54.1765403747559,12.5779962539673 54.1807594299316,12.5801477432252 54.182228088379,12.5771970748903 54.1829261779786,12.5740184783937 54.1818885803223,12.5691871643068 54.1823463439942,12.5660390853883 54.1839218139649,12.5668544769287 54.1848640441896,12.5706491470338 54.1848220825195,12.5720901489258 54.1885185241699,12.5720901489258 54.1885185241699,12.5779123306276 54.1914062500001,12.5873975753785 54.1927299499512,12.5923652648926 54.1931228637696,12.6005468368531 54.1884231567382,12.6280174255371 54.1959800720215,12.6282434463502 54.1952857971192,12.6258697509766 54.194049835205,12.6290302276612 54.1932144165039,12.6344528198243 54.1956748962403,12.6326484680176 54.197925567627,12.6362314224244 54.2080688476562,12.6362314224244 54.2080688476562,12.6374988555908 54.2082977294922,12.6388387680054 54.2065696716309,12.6432199478149 54.2043724060059,12.6497163772584 54.2043609619141,12.650019645691 54.209197998047,12.6679878234864 54.2044525146484,12.6699333190917 54.2026100158693,12.6719865798951 54.2023048400879,12.6772871017457 54.2089614868165,12.6972532272339 54.205883026123,12.7027378082275 54.2139358520509,12.7107830047609 54.2189865112305,12.7128200531006 54.2264060974122,12.7121152877808 54.2270126342773,12.7267370224 54.2322425842285,12.7294158935547 54.2345123291016,12.7289609909058 54.235221862793,12.7301425933839 54.2367095947266,12.7312936782837 54.2361297607422))	0.0006	POINT(12.650650710703097 54.188581413197745)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point