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
13560	POLYGON((14.7254648208618 41.214641571045,14.7216720581055 41.2115135192871,14.711049079895 41.2106781005859,14.7077722549439 41.2127876281739,14.7047882080078 41.2134056091308,14.6951704025269 41.213809967041,14.6674156188965 41.2109565734863,14.6674156188965 41.2109565734863,14.6649312973022 41.2093467712403,14.6621408462524 41.2091598510742,14.6474456787109 41.2157096862793,14.6459579467774 41.2193794250488,14.6459579467774 41.2193794250488,14.6505937576294 41.2286453247071,14.6505937576294 41.2286453247071,14.6546688079835 41.241611480713,14.6546688079835 41.241611480713,14.6645851135255 41.2397155761719,14.6698484420777 41.2372283935547,14.6807107925416 41.2361450195314,14.6882047653199 41.236156463623,14.6943883895875 41.2384490966798,14.7193965911866 41.239055633545,14.7193965911866 41.239055633545,14.7181911468506 41.2308464050294,14.7254648208618 41.214641571045))	0.0006	POINT(14.681297149658242 41.22435562133793)
68986	POLYGON((12.8002882003785 50.9735679626465,12.7961349487305 50.9754943847656,12.7947893142701 50.9788551330566,12.7914419174195 50.9784355163575,12.7894840240478 50.9768066406251,12.78444480896 50.9766998291016,12.7812004089355 50.9777069091797,12.779857635498 50.9785270690919,12.7791471481324 50.9806098937988,12.7821245193481 50.9857711791993,12.7769136428834 50.9859466552736,12.7744617462158 50.9877128601075,12.7685127258302 50.9809722900392,12.7637624740601 50.979461669922,12.7621822357178 50.9795188903809,12.7626152038575 50.98051071167,12.756890296936 50.9800720214843,12.7482767105103 50.9812355041504,12.7479209899903 50.9833068847657,12.7460660934448 50.9856452941896,12.7485847473145 50.9849472045899,12.7485637664794 50.9880447387696,12.7498893737793 50.9883270263672,12.7498664855957 50.9893074035646,12.732560157776 50.9880104064941,12.732560157776 50.9880104064941,12.7258491516113 50.9851531982422,12.7267436981202 50.9835853576661,12.7156963348389 50.9810066223145,12.7161417007447 50.9789733886719,12.7094354629517 50.9794883728028,12.7094488143922 50.9812698364258,12.7036571502686 50.9818115234375,12.7031126022339 50.9790573120118,12.6952352523804 50.9698562622071,12.693962097168 50.9668846130371,12.697832107544 50.9665718078614,12.6966371536256 50.9629821777344,12.69282913208 50.96346282959,12.6925449371339 50.9620056152344,12.695468902588 50.9588165283204,12.6943140029907 50.9576187133789,12.708426475525 50.9555892944337,12.7174158096313 50.9486389160156,12.7251272201538 50.9528694152833,12.7281970977784 50.9556617736817,12.7327613830567 50.9563217163087,12.7330770492554 50.9545974731446,12.7343683242798 50.9541778564453,12.7374343872071 50.9586639404298,12.7419586181641 50.9576034545898,12.7412757873535 50.9564476013184,12.7426176071167 50.9561882019043,12.7406816482545 50.9518203735353,12.7386379241943 50.9516906738281,12.7433099746704 50.9489974975586,12.7460250854493 50.940601348877,12.7481241226196 50.9407043457032,12.7497272491456 50.9393882751465,12.7525215148925 50.9402961730958,12.7556943893434 50.9393424987794,12.755828857422 50.9385948181152,12.755828857422 50.9385948181152,12.7592210769653 50.9389152526857,12.7595911026002 50.9415473937989,12.7687511444093 50.9400444030762,12.768572807312 50.9419479370117,12.7714195251465 50.9418830871582,12.7739210128784 50.9437942504884,12.7745361328126 50.9455833435059,12.7739067077637 50.9487457275392,12.7892074584962 50.9486618041992,12.7898788452148 50.9475326538087,12.7965354919435 50.9441184997558,12.8075866699219 50.9463005065919,12.8075866699219 50.9463005065919,12.8074131011962 50.9499702453614,12.8055257797242 50.9518623352051,12.8043880462647 50.9553565979005,12.8048458099365 50.9568176269531,12.8036184310914 50.9582176208497,12.8045167922974 50.9636840820312,12.8012762069702 50.9658966064454,12.8038921356201 50.9668884277345,12.8119621276856 50.9654884338378,12.8120965957643 50.9676170349121,12.8004322052003 50.9701461791993,12.8014326095582 50.9707756042482,12.8002882003785 50.9735679626465))	0.0006	POINT(12.756234114820346 50.96416971900248)
70116	MULTIPOLYGON(((9.47451782226562 53.9086570739747,9.47225475311279 53.9071884155274,9.47225475311279 53.9071884155274,9.47111320495617 53.9085006713868,9.47211265563959 53.9093627929689,9.47112274169928 53.9106674194337,9.47451782226562 53.9086570739747)),((9.47496795654303 53.9011764526367,9.47659301757812 53.9000205993653,9.46981239318853 53.8979263305663,9.46981239318853 53.8979263305663,9.4576673507691 53.8963241577149,9.45674800872803 53.8984985351562,9.45884513854986 53.9011306762696,9.46148109436047 53.9015502929687,9.45927429199224 53.9022483825684,9.45927429199224 53.9022483825684,9.46097373962408 53.9036903381348,9.46659374237066 53.9046897888185,9.46386909484863 53.9079551696777,9.46495532989508 53.9083518981934,9.4680547714234 53.9050903320313,9.46973133087164 53.9058380126954,9.46973133087164 53.9058380126954,9.47496795654303 53.9011764526367)))	0.0006	POINT(9.465493743025727 53.90264287364881)
52035	POLYGON((-0.512462973594666 45.7809371948243,-0.537447392940521 45.7920722961426,-0.541282355785313 45.7984237670898,-0.555880367755833 45.8077812194825,-0.555880367755833 45.8077812194825,-0.547226369380951 45.8155174255371,-0.541334629058838 45.8279609680176,-0.541334629058838 45.8279609680176,-0.523358166217804 45.8376083374024,-0.504678666591587 45.8393363952637,-0.498949170112553 45.848834991455,-0.498949170112553 45.848834991455,-0.481975466012955 45.8418960571289,-0.481975466012955 45.8418960571289,-0.488269805908203 45.837013244629,-0.488269805908203 45.837013244629,-0.501056909561157 45.8227119445801,-0.497286111116352 45.8128471374512,-0.508051097393036 45.7909812927247,-0.503969609737396 45.7847366333008,-0.503969609737396 45.7847366333008,-0.512462973594666 45.7809371948243))	0.0006	POINT(-0.5149337209406164 45.81842295328779)
22465	POLYGON((-0.797767579555511 43.7712707519531,-0.785216569900456 43.7737998962403,-0.773073494434357 43.7601051330566,-0.773073494434357 43.7601051330566,-0.78153920173645 43.752223968506,-0.783059597015381 43.7389450073243,-0.783059597015381 43.7389450073243,-0.806109428405762 43.7441864013672,-0.806109428405762 43.7441864013672,-0.797580003738403 43.7607727050781,-0.797767579555511 43.7712707519531))	0.0006	POINT(-0.7886588394641819 43.754454040527364)
14066	POLYGON((10.8160324096681 44.1165809631347,10.8051147460938 44.1195678710938,10.7923126220703 44.1288986206055,10.7847089767456 44.1304817199708,10.7847089767456 44.1304817199708,10.7742586135864 44.135612487793,10.7607755661011 44.1519660949708,10.7552671432496 44.1550941467286,10.7443037033081 44.1573715209962,10.7159757614137 44.1567916870117,10.7099294662476 44.1559104919434,10.7099294662476 44.1559104919434,10.7082176208496 44.1613922119141,10.7030277252197 44.1673126220704,10.7012271881104 44.1713981628419,10.7015409469604 44.1740608215333,10.7070150375366 44.1829719543457,10.7052402496338 44.1921348571777,10.7052402496338 44.1921348571777,10.7219257354736 44.1966667175294,10.7265739440918 44.199432373047,10.7265729904175 44.2066688537598,10.729868888855 44.2171096801758,10.7868347167969 44.219066619873,10.8043909072877 44.2350273132324,10.7998151779175 44.2399826049805,10.7966403961183 44.2418251037598,10.7984018325806 44.2458114624023,10.8175354003907 44.2509574890137,10.8248510360718 44.2510108947755,10.8305311203003 44.2480316162111,10.8320569992065 44.2455101013183,10.8350200653077 44.2437362670898,10.8511667251588 44.2366790771484,10.8621788024902 44.2331542968751,10.8621788024902 44.2331542968751,10.8511333465576 44.2284049987793,10.8538799285889 44.2161979675293,10.8568677902222 44.2136993408204,10.8561992645264 44.2083358764649,10.8492107391359 44.2010040283203,10.8389816284179 44.1992416381837,10.8335552215577 44.1957397460938,10.8240108489991 44.1832771301271,10.817967414856 44.1653327941895,10.8098592758179 44.15580368042,10.8066005706788 44.1420593261719,10.811414718628 44.1314697265626,10.8160324096681 44.1165809631347))	0.0006	POINT(10.785438557465902 44.19000967343652)
1407656	POLYGON((-8.83240699768061 42.9634323120118,-8.84240055084223 42.9642448425294,-8.84591293334955 42.9658737182618,-8.85419082641602 42.9598693847656,-8.86253547668457 42.9640846252442,-8.86496162414551 42.9640769958497,-8.86602878570557 42.9625358581544,-8.87134647369385 42.9653396606446,-8.87280464172363 42.9580116271974,-8.88042831420893 42.960075378418,-8.89466762542725 42.9603309631349,-8.89660835266108 42.9682769775391,-8.90102481842041 42.973560333252,-8.89738655090332 42.9780769348144,-8.90011787414545 42.9789428710937,-8.8998966217041 42.9817352294922,-8.9022331237793 42.9843711853027,-8.90162658691395 42.9868659973145,-8.89196777343744 42.9909858703614,-8.89376640319824 42.9970855712891,-8.89824676513672 43.0013542175292,-8.90304946899408 43.0000114440917,-8.90619373321528 43.0018615722656,-8.90314197540278 43.0076217651368,-8.90452098846436 43.0098533630372,-8.90898132324219 43.0095481872558,-8.91231441497803 43.0128250122071,-8.91613101959223 43.0251770019532,-8.91022396087646 43.0295753479003,-8.91463088989258 43.0325431823731,-8.91329956054688 43.0341529846191,-8.91491413116455 43.035717010498,-8.9090518951416 43.0394744873047,-8.90465831756592 43.0477523803712,-8.89725971221918 43.0554161071778,-8.8935813903808 43.0545806884766,-8.89096260070795 43.0556793212891,-8.88969135284424 43.0594520568848,-8.88777637481689 43.0588035583496,-8.88532161712646 43.0603370666504,-8.88701057434082 43.0622100830079,-8.88666152954102 43.067928314209,-8.88459014892578 43.0693664550781,-8.88355827331543 43.0797004699708,-8.87721252441395 43.0869064331055,-8.86991024017328 43.0903053283692,-8.86626815795898 43.1089630126954,-8.8525772094726 43.1072273254395,-8.8513097763061 43.1042594909669,-8.83776283264154 43.1037750244141,-8.83454895019526 43.0985488891602,-8.83111000061035 43.0981636047364,-8.82778930664057 43.1000633239747,-8.8234024047851 43.0986099243165,-8.81335830688477 43.1176872253419,-8.80782032012939 43.1187591552734,-8.79100894927973 43.1127853393556,-8.77028656005854 43.1167488098144,-8.77005672454828 43.108959197998,-8.76842498779297 43.1080970764161,-8.75061130523682 43.1109580993653,-8.74576759338379 43.1105537414551,-8.74588584899902 43.1087989807129,-8.75265502929682 43.1030387878418,-8.75063800811768 43.100929260254,-8.74309730529785 43.0983085632324,-8.73602199554438 43.1006927490234,-8.70416545867914 43.0939102172853,-8.70026683807367 43.0907211303711,-8.68820571899414 43.0855674743653,-8.68301868438721 43.0770492553712,-8.68733787536621 43.0609817504883,-8.68730640411377 43.0540161132813,-8.69690799713135 43.050235748291,-8.71003055572504 43.0474624633789,-8.71793460845947 43.0400810241699,-8.71692085266108 43.0384330749512,-8.71995162963856 43.0336875915528,-8.71130657196045 43.0289916992188,-8.70764255523676 43.0250854492189,-8.71514129638672 43.0153427124025,-8.71867847442627 43.0149917602538,-8.71907711029053 43.0068855285644,-8.71590900421143 43.0007972717285,-8.72012996673584 42.9950332641602,-8.73519515991205 42.9977073669435,-8.74081325530994 42.9980010986329,-8.74226856231684 42.9962615966798,-8.75274181365967 43.0010986328125,-8.75164985656733 43.0018730163575,-8.7536792755127 43.0040130615235,-8.76114845275879 43.0062484741211,-8.77694416046143 43.0029563903809,-8.79241466522217 43.0071830749512,-8.79919815063471 43.0062637329102,-8.8119745254516 42.9971351623536,-8.81457996368397 43.0026435852052,-8.82391738891602 43.0039978027344,-8.8293781280517 43.0025939941406,-8.83958625793451 42.9970893859864,-8.84133911132807 42.9883155822754,-8.83718585968018 42.9860153198242,-8.83503532409668 42.9820861816407,-8.83358478546143 42.9724998474122,-8.83700561523438 42.9688873291016,-8.83657073974604 42.9666137695313,-8.83111858367914 42.9654769897462,-8.83240699768061 42.9634323120118))	0.0006	POINT(-8.821428691115308 43.03145881011108)
17386	POLYGON((8.03505802154541 45.5377769470215,8.03376197814941 45.5307006835938,8.03376197814941 45.5307006835938,8.02448177337646 45.529151916504,8.01799869537365 45.5390892028809,8.01799869537365 45.5390892028809,8.00997066497797 45.5561065673829,8.00997066497797 45.5561065673829,8.02635478973394 45.5597686767578,8.02635478973394 45.5597686767578,8.0309791564942 45.5537681579589,8.03505802154541 45.5377769470215))	0.0006	POINT(8.024244655262365 45.544729752974106)
56611	POLYGON((4.75476217269903 46.1418533325196,4.74562025070202 46.140007019043,4.74378490447998 46.136890411377,4.75091409683239 46.124397277832,4.74991941452038 46.1114845275879,4.74991941452038 46.1114845275879,4.71307229995728 46.1155242919923,4.69479370117199 46.1116104125977,4.69479370117199 46.1116104125977,4.69614505767834 46.126434326172,4.69614505767834 46.126434326172,4.69722986221325 46.1292648315431,4.69106960296637 46.1332473754883,4.69106960296637 46.1332473754883,4.69863796234131 46.1362495422364,4.7028951644898 46.1448440551758,4.7028951644898 46.1448440551758,4.71117496490484 46.1448249816896,4.72021532058722 46.1372489929199,4.74279594421398 46.1420555114746,4.74279594421398 46.1420555114746,4.75476217269903 46.1418533325196))	0.0006	POINT(4.7186023621332875 46.130743480864076)
51166	POLYGON((2.29988169670116 49.8223838806153,2.31002736091619 49.8300056457521,2.33575034141546 49.8310203552246,2.33575034141546 49.8310203552246,2.34081935882568 49.8299865722656,2.35039997100841 49.8105430603028,2.35039997100841 49.8105430603028,2.32499337196356 49.7947425842286,2.32499337196356 49.7947425842286,2.32324767112738 49.7976531982423,2.30066871643072 49.8024215698243,2.30066871643072 49.8024215698243,2.30459141731268 49.8161125183105,2.29988169670116 49.8223838806153))	0.0006	POINT(2.3232455620399532 49.813353611872806)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point