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
20175	POLYGON((11.4057359695436 45.1895637512208,11.4010038375854 45.1911582946778,11.3886327743531 45.187572479248,11.3833770751953 45.1854515075683,11.3781518936158 45.1816444396972,11.3720922470093 45.1796836853028,11.3673143386841 45.1857872009278,11.3699207305909 45.1875495910644,11.3699207305909 45.1875495910644,11.3784942626954 45.1904602050782,11.3824119567872 45.1934394836427,11.3906908035278 45.2117729187011,11.3844461441041 45.2189598083497,11.3763380050659 45.2218399047852,11.3763380050659 45.2218399047852,11.3769330978394 45.2275581359864,11.3785057067871 45.2295417785645,11.3823843002319 45.2311897277833,11.3850259780885 45.2355804443359,11.3918800354004 45.2535438537597,11.3918800354004 45.2535438537597,11.4021501541137 45.2525329589844,11.4064674377443 45.2464370727539,11.4075212478638 45.2400131225587,11.4034366607666 45.2365264892578,11.4007387161255 45.2266197204591,11.4024219512941 45.2218246459961,11.4024219512941 45.2218246459961,11.4045763015748 45.2173309326172,11.406367301941 45.1930694580079,11.4057359695436 45.1895637512208))	0.0006	POINT(11.388919321696013 45.2140469868978)
1401570	POLYGON((-1.97811603546143 41.5266952514648,-1.98023605346674 41.5284729003907,-1.99440705776209 41.5305252075195,-2.0048189163208 41.5339584350586,-2.01491999626154 41.5334930419923,-2.01305294036865 41.5370903015137,-2.02081108093256 41.5569000244141,-2.01765704154968 41.5672683715821,-2.00802493095398 41.5735778808595,-2.00370407104481 41.5721549987794,-1.99362599849701 41.5770950317383,-1.9805999994278 41.5647125244141,-1.98180603981018 41.562038421631,-1.97667300701136 41.557415008545,-1.97348701953888 41.5579719543458,-1.96863698959345 41.55078125,-1.97037398815155 41.5486793518068,-1.96727395057678 41.5460739135743,-1.97298800945282 41.5341644287109,-1.97191894054413 41.5328216552734,-1.97811603546143 41.5266952514648))	0.0006	POINT(-1.9896566033363121 41.54959449768072)
18923	POLYGON((13.7136459350587 37.8464469909669,13.7280216217042 37.8418807983398,13.7328672409057 37.8389549255371,13.7353992462158 37.8345870971681,13.73060131073 37.8107261657715,13.73060131073 37.8107261657715,13.7418260574341 37.8012428283692,13.7418260574341 37.8012428283692,13.7454881668092 37.8003425598146,13.7560176849365 37.8049964904785,13.7696638107301 37.8077201843262,13.7776489257812 37.8074951171876,13.7942218780519 37.8110771179199,13.8025436401368 37.8154640197753,13.805775642395 37.824291229248,13.8046798706056 37.8295631408693,13.7998571395875 37.8341064453125,13.799033164978 37.837257385254,13.799033164978 37.837257385254,13.7918901443481 37.8362350463868,13.7892532348632 37.8369903564454,13.7842664718628 37.8417854309081,13.7830610275269 37.8452262878418,13.7786102294922 37.8511962890626,13.7636861801147 37.8641777038575,13.7558450698853 37.8694381713868,13.7541093826294 37.8691749572754,13.7541093826294 37.8691749572754,13.7535476684571 37.8653678894044,13.7562103271486 37.8525352478028,13.7547302246093 37.8496055603027,13.7474002838135 37.8531646728516,13.7228078842164 37.8568992614746,13.7157268524171 37.8522720336915,13.7136459350587 37.8464469909669))	0.0006	POINT(13.76217665391813 37.835547727697076)
40343	POLYGON((1.8759988546372 45.1819229125976,1.86323893070232 45.1838645935059,1.85897624492657 45.1824684143066,1.8565857410432 45.1760864257813,1.8565857410432 45.1760864257813,1.86109209060675 45.1767463684082,1.87386345863354 45.1678428649903,1.88748049736034 45.1693229675294,1.88748049736034 45.1693229675294,1.91250574588781 45.1798973083497,1.91250574588781 45.1798973083497,1.91369950771337 45.1892204284669,1.90993404388428 45.1948852539064,1.90993404388428 45.1948852539064,1.90266454219818 45.190860748291,1.89505076408386 45.1946296691895,1.89069259166712 45.1934700012206,1.88751721382147 45.1872863769531,1.8759988546372 45.1819229125976))	0.0006	POINT(1.8864336808523134 45.182705349392414)
20138	POLYGON((12.0639019012452 45.4200477600099,12.0528507232665 45.4137382507325,12.0432691574097 45.4145164489747,12.0387992858886 45.4169578552247,12.0314378738403 45.4169578552247,12.0248594284058 45.4165344238281,12.0154628753663 45.4121856689453,12.0107622146608 45.4119758605958,12.0106639862061 45.4183349609376,12.0144453048707 45.4250755310059,12.0144453048707 45.4250755310059,12.0203886032105 45.4304885864258,12.0203886032105 45.4304885864258,12.0369405746461 45.4352073669434,12.0369405746461 45.4352073669434,12.0424299240112 45.4350433349609,12.0415258407592 45.4298744201661,12.0440196990967 45.4277648925782,12.0478782653809 45.4272384643555,12.0546865463256 45.429054260254,12.0590553283691 45.4280357360841,12.0639019012452 45.4200477600099))	0.0006	POINT(12.03453104836603 45.42380015055345)
61730	POLYGON((8.89285945892345 47.2755203247071,8.89323711395264 47.2840156555176,8.89323711395264 47.2840156555176,8.88622856140137 47.2838554382325,8.88417816162109 47.2864112854004,8.87487030029303 47.2913398742677,8.86271762847906 47.2900848388673,8.85699558258062 47.2862014770508,8.85479259490978 47.2875289916993,8.85068893432617 47.2925109863282,8.83942317962658 47.2936630249024,8.83615875244146 47.2932510375977,8.83327388763433 47.2914886474609,8.8267450332641 47.2845458984376,8.8267450332641 47.2845458984376,8.8307514190675 47.2814636230469,8.82776546478277 47.2787284851075,8.82874107360851 47.2744674682618,8.83640861511225 47.2675399780274,8.83640861511225 47.2675399780274,8.85307407379145 47.2654724121095,8.85799312591553 47.27054977417,8.86410236358643 47.2713623046876,8.86945438385021 47.2741584777833,8.89285945892345 47.2755203247071))	0.0006	POINT(8.854868769645723 47.28167756398525)
26616	POLYGON((0.195351243019161 49.240535736084,0.188740372657833 49.23628616333,0.187606737017688 49.2303619384766,0.187606737017688 49.2303619384766,0.188224673271122 49.2240524291993,0.196362063288802 49.2201309204103,0.196362063288802 49.2201309204103,0.214933350682372 49.2223510742188,0.220269426703453 49.2137832641602,0.220269426703453 49.2137832641602,0.230259358882847 49.2144203186036,0.234192281961441 49.2204742431641,0.234192281961441 49.2204742431641,0.237014323473034 49.2231750488282,0.247855305671749 49.2166290283204,0.256171792745704 49.2185363769532,0.254674732685032 49.2250061035157,0.239841312170029 49.2329902648927,0.239841312170029 49.2329902648927,0.231073811650333 49.2366485595704,0.215278804302216 49.2365875244141,0.213169828057403 49.2397804260254,0.213169828057403 49.2397804260254,0.195351243019161 49.240535736084))	0.0006	POINT(0.2192374377147406 49.22649002075201)
35770	POLYGON((6.53166151046764 47.2889747619629,6.52226829528809 47.2915496826172,6.5137820243836 47.3001060485841,6.51748943328863 47.3202972412109,6.51748943328863 47.3202972412109,6.5357718467713 47.3171997070312,6.54278135299688 47.3125801086426,6.54278135299688 47.3125801086426,6.54331111907965 47.305950164795,6.53957319259644 47.3037109375,6.52015686035168 47.3009605407715,6.52131843566906 47.2976722717285,6.53365421295172 47.2920875549318,6.53166151046764 47.2889747619629))	0.0006	POINT(6.529387620779247 47.304920489971465)
15578	POLYGON((8.93059253692621 45.8412628173829,8.94074630737305 45.8450469970704,8.94074630737305 45.8450469970704,8.95293521881109 45.8459968566895,8.95293521881109 45.8459968566895,8.95763111114513 45.8435554504395,8.96002960205089 45.8399085998535,8.96289539337158 45.8386802673341,8.96289539337158 45.8386802673341,8.9570684432984 45.835678100586,8.95109844207775 45.8309211730957,8.94751834869385 45.8300209045411,8.94751834869385 45.8300209045411,8.93023109436041 45.8302268981934,8.93023109436041 45.8302268981934,8.93059253692621 45.8412628173829))	0.0006	POINT(8.948338190714555 45.8380846659343)
70896	POLYGON((10.5481462478638 50.7327003479004,10.5429410934449 50.7309226989746,10.5403575897217 50.7318382263183,10.5318412780762 50.7311782836914,10.5282621383668 50.7335281372071,10.5203599929811 50.7352638244628,10.5204448699951 50.736354827881,10.5276632308959 50.7383041381837,10.5286426544191 50.7393760681153,10.5197505950928 50.7370910644531,10.5074720382691 50.7368125915527,10.503743171692 50.7354202270508,10.5026798248292 50.7373085021974,10.4972915649415 50.7389640808106,10.4922580718994 50.7370567321778,10.4913368225099 50.7355537414551,10.4879770278931 50.7360305786133,10.4938745498658 50.7409782409669,10.4958734512329 50.7402763366699,10.4972352981568 50.7423400878907,10.4924840927125 50.7463417053223,10.4879732131958 50.7482147216797,10.4780893325807 50.7463035583497,10.4736223220826 50.7468872070313,10.47132396698 50.7487754821778,10.470199584961 50.7547340393066,10.4646511077882 50.7585639953613,10.4633722305298 50.7610206604003,10.4479236602784 50.7611236572266,10.4444036483765 50.7627754211426,10.4444036483765 50.7627754211426,10.4434366226196 50.7642326354982,10.4441118240356 50.7692108154297,10.4441118240356 50.7692108154297,10.443229675293 50.7715034484863,10.4464187622071 50.7740783691406,10.4454793930054 50.776668548584,10.4477758407593 50.7786331176759,10.4519329071044 50.7798919677735,10.451717376709 50.7824325561525,10.4497146606445 50.7836265563965,10.461109161377 50.786735534668,10.467082977295 50.7897682189943,10.4715938568115 50.7936210632325,10.468358039856 50.7934226989747,10.4700736999512 50.7955093383789,10.4691648483278 50.7959327697754,10.461314201355 50.7963066101074,10.4537916183472 50.7946586608887,10.4498872756959 50.7953681945801,10.4505949020386 50.7970428466797,10.4490594863892 50.7988662719728,10.4482889175416 50.8021774291992,10.4510860443116 50.8026199340821,10.4519081115723 50.8040962219239,10.4540519714356 50.8040962219239,10.4570465087891 50.80619430542,10.4566726684571 50.8104858398439,10.4516134262085 50.8138504028321,10.4555759429932 50.8146057128907,10.4577322006226 50.8166694641114,10.4669933319091 50.8156890869141,10.4693212509155 50.8177146911621,10.468339920044 50.819480895996,10.4751873016357 50.8180160522461,10.4870309829712 50.823413848877,10.4945297241211 50.8315773010255,10.4939193725587 50.8337249755861,10.4958229064942 50.8354797363282,10.4958229064942 50.8354797363282,10.5019321441651 50.8329811096191,10.5113096237184 50.8328704833984,10.5115375518798 50.8357849121094,10.5144786834716 50.8367958068848,10.5144786834716 50.8367958068848,10.5146770477294 50.8352661132814,10.5169076919556 50.8337631225587,10.5242519378662 50.8323287963868,10.5316228866578 50.826946258545,10.5378656387329 50.8270378112793,10.5402984619141 50.8239784240723,10.5404291152955 50.8192367553712,10.5422248840333 50.8165512084962,10.5420370101929 50.813304901123,10.5420370101929 50.813304901123,10.5416507720948 50.810317993164,10.5446577072144 50.805850982666,10.5455055236818 50.8018646240235,10.5455055236818 50.8018646240235,10.5411157608032 50.7984848022462,10.5400905609131 50.7955169677735,10.5414791107178 50.7926902770996,10.5411663055421 50.7915115356446,10.5387372970582 50.7900009155274,10.5374860763549 50.7867889404297,10.5381355285645 50.7828750610352,10.5413856506348 50.7828216552736,10.5444812774659 50.7844200134278,10.5480995178223 50.7837371826172,10.5582056045533 50.7842254638672,10.5614671707154 50.782585144043,10.5646133422852 50.7788314819337,10.5645513534546 50.7749633789063,10.5668315887452 50.7721023559571,10.5630340576172 50.7659034729004,10.5646800994873 50.7558250427247,10.5670061111451 50.7551689147949,10.5754508972169 50.7413597106935,10.5840635299683 50.7361373901367,10.5840635299683 50.7361373901367,10.5820312500001 50.7334823608398,10.5723104476928 50.7367095947266,10.5706329345703 50.7340927124023,10.5501174926758 50.7338790893555,10.5481462478638 50.7327003479004))	0.0006	POINT(10.50343986979705 50.78126318412916)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point