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
35385	POLYGON((9.38422489166271 42.3987922668458,9.36618900299072 42.3960685729981,9.36618900299072 42.3960685729981,9.35358619689936 42.40087890625,9.33938884735113 42.4021224975587,9.33938884735113 42.4021224975587,9.34142780303966 42.4051017761232,9.35477828979487 42.4061355590821,9.38422489166271 42.3987922668458))	0.0006	POINT(9.355646610260038 42.400911331176836)
64149	POLYGON((14.5293655395508 52.2204513549805,14.5387992858887 52.2206573486328,14.5471487045289 52.2233200073242,14.5552892684937 52.2241363525391,14.5552892684937 52.2241363525391,14.5595083236695 52.2182083129883,14.5671434402467 52.2170257568359,14.5801982879638 52.217845916748,14.5867147445679 52.2158737182617,14.5856275558473 52.2135353088379,14.5948238372804 52.2093200683595,14.6029634475709 52.2089653015137,14.6029634475709 52.2089653015137,14.6137990951538 52.1982307434082,14.5880479812622 52.1871299743653,14.5928916931153 52.1825256347656,14.5932941436768 52.1806564331055,14.5922317504884 52.1807365417481,14.5914306640626 52.1777191162109,14.5935144424439 52.1762962341309,14.5942783355713 52.1729278564453,14.5942783355713 52.1729278564453,14.582389831543 52.1733436584473,14.5774583816529 52.1696739196778,14.5749216079711 52.169563293457,14.5668897628785 52.1651649475099,14.5624294281007 52.1642684936524,14.5567169189454 52.1654701232911,14.5560989379883 52.1646270751954,14.5522909164429 52.1662635803223,14.5381660461427 52.1683616638184,14.5342979431153 52.1667098999024,14.5312366485597 52.1640930175782,14.5271615982056 52.1635627746583,14.5284729003907 52.1626625061036,14.5191402435304 52.162109375,14.5149679183961 52.1628189086913,14.51478099823 52.1615486145021,14.5115232467651 52.1586761474609,14.506386756897 52.1587219238282,14.4811792373658 52.1645088195801,14.4802713394166 52.1681785583497,14.4456405639648 52.1636276245117,14.4457969665528 52.1645736694336,14.4448490142823 52.1646232604982,14.4434413909912 52.1637687683106,14.4432392120362 52.1616249084473,14.4432392120362 52.1616249084473,14.4394454956056 52.1635704040528,14.4377183914185 52.1626472473145,14.4346218109132 52.1633567810059,14.4316053390503 52.1656799316406,14.4311571121217 52.1667671203613,14.4328346252442 52.1686668395996,14.4297428131105 52.1705551147462,14.4273128509522 52.1741905212402,14.4273128509522 52.1741905212402,14.430871963501 52.1763725280762,14.4295387268067 52.1802444458008,14.4312915802003 52.1835746765137,14.4363698959352 52.1849060058595,14.436658859253 52.187328338623,14.4338073730469 52.1897583007812,14.4346971511841 52.1915168762208,14.4330282211304 52.1923828124999,14.4346208572389 52.1990966796875,14.431492805481 52.2005805969239,14.4288206100465 52.2006225585938,14.4293012619019 52.2025833129883,14.4273767471314 52.2027168273926,14.4264163970947 52.2051277160645,14.4278707504272 52.2057075500488,14.4280567169191 52.2069854736329,14.4253911972046 52.2102394104004,14.4227409362794 52.2108039855957,14.4205522537231 52.2129287719728,14.4212455749513 52.2181358337403,14.4212455749513 52.2181358337403,14.4187202453614 52.2200241088868,14.4204053878785 52.220859527588,14.4247608184815 52.2186851501465,14.4285945892334 52.2313728332521,14.4225759506226 52.2343521118163,14.4252586364746 52.2355079650879,14.4448728561403 52.226791381836,14.4609107971193 52.2255249023439,14.4841079711913 52.2256164550781,14.5005359649659 52.2233123779297,14.5160627365112 52.2225837707521,14.5293655395508 52.2204513549805))	0.0006	POINT(14.494298217001981 52.189952421724136)
41914	POLYGON((5.61601638793945 49.0397987365724,5.60205984115612 49.0368270874025,5.58166360855103 49.0231895446778,5.58166360855103 49.0231895446778,5.57141542434704 49.0140342712403,5.57141542434704 49.0140342712403,5.57692050933844 49.0125198364258,5.57692050933844 49.0125198364258,5.60007810592651 49.0152969360353,5.60229825973522 49.012378692627,5.60229825973522 49.012378692627,5.62311363220215 49.021282196045,5.62612056732189 49.0239410400391,5.62186288833612 49.0298385620117,5.6254415512085 49.0321540832521,5.6254415512085 49.0321540832521,5.61567592620844 49.033042907715,5.61601638793945 49.0397987365724))	0.0006	POINT(5.601200356203009 49.022857666015696)
57524	POLYGON((7.43793201446533 49.3537864685059,7.44101238250738 49.355541229248,7.44355916976934 49.3538284301759,7.44355916976934 49.3538284301759,7.4479718208313 49.3564224243165,7.45202302932745 49.3622932434083,7.45045518875133 49.3641967773438,7.45631217956543 49.3646507263183,7.45692777633673 49.3653793334961,7.45692777633673 49.3653793334961,7.45583629608154 49.3666687011719,7.4569730758667 49.3682975769043,7.45593833923346 49.3725318908691,7.45273828506475 49.3723754882812,7.44620418548584 49.3695755004883,7.44328355789185 49.3696174621582,7.44151973724371 49.3739662170411,7.43960428237915 49.374813079834,7.43032121658325 49.3707809448243,7.42260694503778 49.3712196350098,7.41969203948975 49.3703346252443,7.4154510498048 49.3713188171386,7.41448831558233 49.3698310852051,7.4116640090943 49.3684692382813,7.41204071044916 49.365821838379,7.41074466705322 49.3633918762208,7.40896844863892 49.3634605407716,7.40896844863892 49.3634605407716,7.40898418426519 49.3618431091309,7.41709709167492 49.3587532043457,7.42359685897833 49.3597640991212,7.42563724517822 49.3592262268067,7.42558288574213 49.3583679199219,7.43380212783813 49.3566474914551,7.43420362472546 49.354721069336,7.43695688247681 49.3550071716309,7.43793201446533 49.3537864685059))	0.0006	POINT(7.434432917171083 49.364043659634085)
52971	POLYGON((0.321871548891181 46.1305236816407,0.313767313957214 46.1486244201661,0.299647241830883 46.1621093749999,0.290101796388683 46.1613616943359,0.290101796388683 46.1613616943359,0.282428115606308 46.1469154357911,0.285044729709625 46.130714416504,0.285044729709625 46.130714416504,0.312602490186805 46.122386932373,0.312602490186805 46.122386932373,0.319618821144104 46.1251754760742,0.321871548891181 46.1305236816407))	0.0006	POINT(0.3011664612727196 46.140206770463436)
16691	POLYGON((13.058897972107 43.5767135620117,13.0598945617676 43.5760955810548,13.0703325271606 43.5777397155763,13.0775375366212 43.5759162902833,13.0775375366212 43.5759162902833,13.0839824676514 43.5823936462402,13.0839824676514 43.5823936462402,13.0915050506591 43.5865898132324,13.108437538147 43.5923957824708,13.1207218170167 43.6061248779297,13.1180820465089 43.610507965088,13.1130189895631 43.6131362915038,13.1104364395143 43.6128959655762,13.1070013046265 43.6141815185547,13.1051645278931 43.6158180236817,13.0962438583375 43.6286964416504,13.0962438583375 43.6286964416504,13.069531440735 43.6311111450195,13.0610866546631 43.6292533874511,13.0494403839111 43.620304107666,13.0384807586669 43.6143188476562,13.0254764556885 43.6046943664551,13.0218448638916 43.6033248901368,13.0218448638916 43.6033248901368,13.0214157104492 43.6000366210938,13.0214157104492 43.6000366210938,13.0297317504884 43.5991821289064,13.0353736877441 43.5970993041993,13.0398731231691 43.5912971496581,13.0378780364991 43.58602142334,13.0447692871095 43.5797462463379,13.0516319274902 43.5773887634277,13.058897972107 43.5767135620117))	0.0006	POINT(13.067150473594706 43.59979224205021)
24625	POLYGON((3.02304744720459 45.497673034668,3.01920652389538 45.4985008239746,3.02526664733898 45.5063972473145,3.02304077148432 45.5122070312501,3.02304077148432 45.5122070312501,3.00339388847357 45.5116500854493,3.00339388847357 45.5116500854493,2.99229145050049 45.5004844665528,2.9949040412904 45.4975318908691,2.9949040412904 45.4975318908691,2.995109319687 45.4907760620117,2.97551894187939 45.4673614501954,2.96482491493219 45.4603881835939,2.95064997673035 45.4575195312501,2.95064997673035 45.4575195312501,2.95467233657837 45.4514999389648,2.96744275093084 45.4473609924316,2.97688364982605 45.4478416442872,2.99229979515076 45.4400100708008,2.99229979515076 45.4400100708008,3.00051164627075 45.4423141479492,3.00143289566046 45.4549942016602,3.01859211921698 45.4607353210449,3.02475070953381 45.4695510864257,3.02475070953381 45.4695510864257,3.02734112739569 45.4801216125489,3.02304744720459 45.497673034668))	0.0006	POINT(2.99693154371706 45.47628417381877)
26854	POLYGON((-0.944261848926544 48.9669914245605,-0.915084302425328 48.9895477294923,-0.909472107887268 48.9985885620117,-0.909472107887268 48.9985885620117,-0.908418357372227 48.9918594360351,-0.908418357372227 48.9918594360351,-0.912637293338776 48.9832153320314,-0.900735914707184 48.9690017700195,-0.904383122920933 48.9634895324708,-0.904383122920933 48.9634895324708,-0.917022049427032 48.9591941833496,-0.943535506725311 48.966609954834,-0.943535506725311 48.966609954834,-0.944261848926544 48.9669914245605))	0.0006	POINT(-0.9170276614335648 48.97761887770435)
35430	POLYGON((9.3644962310791 42.3878974914552,9.36618900299072 42.3960685729981,9.36618900299072 42.3960685729981,9.35358619689936 42.40087890625,9.33938884735113 42.4021224975587,9.33938884735113 42.4021224975587,9.32577133178705 42.3986167907716,9.32577133178705 42.3986167907716,9.32671070098888 42.396167755127,9.32671070098888 42.396167755127,9.35276889801037 42.3910179138184,9.35574150085461 42.3884849548341,9.35031604766851 42.3831214904786,9.35031604766851 42.3831214904786,9.3644962310791 42.3878974914552))	0.0006	POINT(9.345953192029716 42.394319534301836)
62630	POLYGON((7.49642038345337 52.4579734802247,7.50168180465693 52.4535636901857,7.50313711166393 52.454044342041,7.50438785552973 52.4519195556642,7.51225090026861 52.4503440856935,7.52832698822033 52.4422798156739,7.53168821334839 52.4408798217775,7.53287696838379 52.4416122436524,7.53514575958263 52.4392585754396,7.54805326461792 52.4330787658692,7.54500007629406 52.426414489746,7.54775094985962 52.4250564575196,7.54775094985962 52.4250564575196,7.56955575942999 52.4209823608399,7.57169246673584 52.4244003295899,7.56622695922863 52.4272117614747,7.5643110275268 52.4323120117189,7.5643110275268 52.4323120117189,7.57096529006958 52.4323310852051,7.57575416564941 52.4413299560547,7.57749128341669 52.4469985961915,7.59086847305309 52.4637832641603,7.60345268249523 52.474967956543,7.60803842544556 52.4740142822266,7.60803842544556 52.4740142822266,7.61148214340204 52.4773025512696,7.61143684387207 52.4793815612793,7.60914278030396 52.4829597473146,7.61138439178478 52.4937057495118,7.60601758956915 52.4941520690919,7.60601758956915 52.4941520690919,7.59673166275019 52.4907913208008,7.59592914581305 52.4887237548829,7.5880770683288 52.4882965087891,7.58282899856567 52.4893112182618,7.56653213500982 52.4986305236816,7.5670213699342 52.5006904602052,7.56108474731457 52.500186920166,7.55593872070318 52.5045585632324,7.55162286758417 52.5067596435547,7.55137300491339 52.512119293213,7.54815912246715 52.5120620727538,7.54437112808233 52.515796661377,7.54158639907848 52.5171051025391,7.54052114486706 52.5265502929687,7.54052114486706 52.5265502929687,7.5242395401001 52.5222320556641,7.5046529769898 52.5190429687501,7.5046529769898 52.5190429687501,7.50539016723644 52.510913848877,7.50768232345575 52.5058021545411,7.50645923614508 52.504508972168,7.50538730621338 52.5004806518555,7.50862455368048 52.500186920166,7.51287794113159 52.4980430603027,7.5115323066712 52.4947814941407,7.51307821273798 52.4945945739747,7.5125665664674 52.4928283691406,7.51001739501959 52.4930267333984,7.50788164138805 52.4899482727051,7.50466012954712 52.4897003173829,7.50398540496832 52.4875411987305,7.50504779815668 52.4862365722657,7.50369167327887 52.4796752929688,7.50114631652843 52.473991394043,7.50114631652843 52.473991394043,7.4963779449464 52.466968536377,7.4977645874024 52.4620895385742,7.49642038345337 52.4579734802247))	0.0006	POINT(7.544732654795966 52.477228725657774)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point