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
19041	MULTIPOLYGON(((11.7296485900879 43.7603416442871,11.7283782958984 43.7627296447755,11.7342720031739 43.7639312744141,11.7497062683105 43.7627029418945,11.7601699829103 43.7698173522949,11.7661991119385 43.7790412902832,11.7750406265259 43.7794837951661,11.7825393676757 43.7814559936524,11.7840719223022 43.7837028503419,11.7846832275391 43.7877578735352,11.7790966033936 43.79056930542,11.7781200408936 43.7968406677247,11.7867336273193 43.8112983703614,11.7917699813843 43.8118476867676,11.7957401275634 43.8148651123047,11.8081588745117 43.8298873901368,11.8081588745117 43.8298873901368,11.8176279067994 43.8231697082521,11.8426322937012 43.8089675903321,11.8426322937012 43.8089675903321,11.8396711349487 43.8076171875001,11.8355855941772 43.8014221191406,11.8396968841554 43.7934799194337,11.8393878936769 43.7851333618165,11.8381595611572 43.7830734252929,11.8288946151733 43.7779197692872,11.8141584396363 43.7749900817871,11.8116512298585 43.7628593444825,11.8131122589111 43.7529563903809,11.8162050247194 43.7503242492677,11.8164434432985 43.7482490539552,11.803032875061 43.7459030151367,11.7890319824218 43.7447357177734,11.7868032455445 43.7344436645507,11.7916860580444 43.7326431274415,11.797812461853 43.7202186584474,11.7957658767701 43.7034530639649,11.79656124115 43.6952056884766,11.79656124115 43.6952056884766,11.778881072998 43.6989936828614,11.7632369995118 43.7004280090332,11.7482471466064 43.6952972412111,11.7336263656617 43.6848258972169,11.7277641296387 43.685718536377,11.7168426513672 43.6920242309571,11.7037696838379 43.6921157836914,11.6971807479859 43.6934967041016,11.6971807479859 43.6934967041016,11.6947908401489 43.6947135925293,11.7023181915283 43.7282829284668,11.7151813507081 43.7381935119629,11.7180910110474 43.7459602355958,11.7224311828613 43.7463607788087,11.7407064437867 43.7383613586426,11.741177558899 43.740535736084,11.7398777008057 43.7452507019043,11.7296485900879 43.7603416442871)),((11.9140672683715 43.7998733520508,11.9084405899047 43.7927474975587,11.9048624038696 43.7912216186525,11.9000272750855 43.7901916503906,11.8890352249147 43.791603088379,11.8870658874512 43.7927970886231,11.883261680603 43.7927665710449,11.8713989257814 43.7871856689454,11.8713989257814 43.7871856689454,11.8635272979736 43.7888870239258,11.8607530593873 43.7984733581543,11.8480939865112 43.8069839477539,11.8430824279786 43.8089599609376,11.8430824279786 43.8089599609376,11.8518171310426 43.8123283386232,11.8563356399536 43.8166160583496,11.8683805465699 43.8178558349609,11.8711109161377 43.817497253418,11.8728637695313 43.8146362304688,11.8771257400513 43.8114776611329,11.897394180298 43.8087234497071,11.9107122421265 43.8136596679688,11.9143991470337 43.8076782226562,11.9132537841797 43.8025283813476,11.9140672683715 43.7998733520508)),((11.7781171798707 43.6808433532715,11.7856855392456 43.6881332397461,11.7922401428223 43.6879196166992,11.7986488342285 43.6864738464355,11.7986488342285 43.6864738464355,11.8066215515138 43.6752128601074,11.8066215515138 43.6752128601074,11.7903718948365 43.6733322143555,11.7845935821534 43.6692428588867,11.7776660919189 43.6769905090332,11.7781171798707 43.6808433532715)))	0.0006	POINT(11.788581498359834 43.75803360155809)
53166	POLYGON((6.52711296081549 43.921241760254,6.52589035034185 43.9305000305176,6.53073024749762 43.9353866577149,6.53073024749762 43.9353866577149,6.54696607589722 43.9216346740724,6.54696607589722 43.9216346740724,6.55911493301397 43.9114036560059,6.56894540786749 43.8922538757325,6.56894540786749 43.8922538757325,6.54448127746582 43.8916740417482,6.54448127746582 43.8916740417482,6.53784847259533 43.9006271362305,6.53180599212646 43.9207496643066,6.52711296081549 43.921241760254))	0.0006	POINT(6.543386055873031 43.912801595834665)
1401458	POLYGON((-4.38849401473988 40.634952545166,-4.39387178421015 40.6332473754884,-4.40724611282343 40.6343994140626,-4.41952419280994 40.6334304809571,-4.41915321350098 40.6549644470215,-4.42200803756708 40.6752624511719,-4.43180894851685 40.704128265381,-4.43458700180054 40.7061729431153,-4.43556499481201 40.7158813476563,-4.43222999572754 40.7172393798828,-4.43012189865101 40.7281761169433,-4.42679023742676 40.729621887207,-4.43042278289795 40.7362213134767,-4.43102884292597 40.7423858642578,-4.43862819671631 40.7497673034668,-4.45435380935663 40.7545356750488,-4.45979022979731 40.7588272094727,-4.46697092056269 40.7691307067872,-4.4737401008606 40.774658203125,-4.4723978042602 40.7820701599122,-4.48047685623163 40.7861633300782,-4.48129796981812 40.7915954589843,-4.48047304153437 40.7945404052735,-4.4730811119079 40.800048828125,-4.47045087814325 40.800148010254,-4.46761798858637 40.8039283752441,-4.46519088745117 40.8131790161133,-4.45442676544189 40.8262405395508,-4.448805809021 40.829616546631,-4.43897581100458 40.8279724121095,-4.43601417541504 40.8291549682618,-4.43727207183838 40.8308410644532,-4.4361891746521 40.8345642089844,-4.4398398399353 40.8411331176759,-4.43438577651972 40.8565673828126,-4.43123912811274 40.8608055114747,-4.42731904983521 40.8628692626954,-4.42379283905024 40.8626861572267,-4.41561079025263 40.8596343994142,-4.40468502044678 40.8529510498048,-4.40925884246826 40.8398437499999,-4.40827417373657 40.8380966186525,-4.41042280197144 40.8303909301758,-4.4033899307251 40.8230895996094,-4.39583921432495 40.8220558166504,-4.39772176742548 40.8145370483398,-4.39382410049433 40.7994766235352,-4.38631916046143 40.7902374267579,-4.37961912155151 40.7854423522949,-4.3767237663269 40.7778282165527,-4.3767237663269 40.7715339660645,-4.37412118911743 40.7671279907228,-4.37181711196894 40.7668800354005,-4.3686699867248 40.7630958557129,-4.37414216995234 40.7538185119629,-4.37781810760492 40.7511596679687,-4.38335609436024 40.7388153076172,-4.38521385192871 40.7382545471193,-4.38540077209473 40.7237930297852,-4.38744306564331 40.7172355651856,-4.39075183868403 40.7135925292969,-4.39244604110718 40.6782989501953,-4.38849401473988 40.634952545166))	0.0006	POINT(-4.421696370647769 40.771037378618836)
53073	POLYGON((0.112999863922596 46.6926307678224,0.106798067689056 46.6873779296876,0.0851044952869415 46.6951446533204,0.080478399992046 46.6939888000488,0.080478399992046 46.6939888000488,0.063436485827026 46.705711364746,0.063436485827026 46.705711364746,0.0798809081315994 46.7228813171387,0.0786861106754486 46.7290115356445,0.0786861106754486 46.7290115356445,0.0939265936612514 46.7402458190919,0.0939265936612514 46.7402458190919,0.106499835848922 46.7433586120607,0.11536176502716 46.7408599853516,0.11536176502716 46.7408599853516,0.105929873883838 46.7255401611328,0.116607777774334 46.7186470031738,0.114109046757221 46.7089691162109,0.125408262014389 46.7028732299805,0.125408262014389 46.7028732299805,0.112999863922596 46.6926307678224))	0.0006	POINT(0.09712625518445749 46.7159965515137)
24455	POLYGON((3.67949223518366 45.5900650024415,3.66171503067022 45.6082878112794,3.66074132919312 45.618091583252,3.66074132919312 45.618091583252,3.66335558891291 45.6242256164551,3.65951156616217 45.6301383972169,3.66566920280468 45.6352081298829,3.66895461082464 45.6447143554688,3.66895461082464 45.6447143554688,3.67591071128845 45.6487159729005,3.68331336975103 45.645133972168,3.69625735282892 45.6473770141602,3.6998929977417 45.6455078125001,3.6998929977417 45.6455078125001,3.70572924613953 45.6380271911622,3.71376824378967 45.6362533569335,3.71376824378967 45.6362533569335,3.71086215972895 45.6298789978027,3.7235958576203 45.6161994934082,3.71816587448126 45.5942726135254,3.71816587448126 45.5942726135254,3.71100282669079 45.5918235778809,3.71142911911011 45.5860748291017,3.71142911911011 45.5860748291017,3.70671296119701 45.586338043213,3.70243906974792 45.5921745300294,3.67949223518366 45.5900650024415))	0.0006	POINT(3.6919796741925976 45.62051626352168)
50962	POLYGON((1.5252361297608 49.9989547729492,1.54551839828503 50.0134468078614,1.54595971107489 50.0199546813966,1.54595971107489 50.0199546813966,1.53630352020275 50.0211982727051,1.53360390663147 50.0239143371583,1.53780603408813 50.0295600891113,1.53134703636181 50.0344696044922,1.53134703636181 50.0344696044922,1.515778541565 50.0341262817383,1.515778541565 50.0341262817383,1.49756586551661 50.0227394104004,1.49776101112366 50.0194358825683,1.49776101112366 50.0194358825683,1.51448118686682 50.0126495361329,1.5252361297608 49.9989547729492))	0.0006	POINT(1.5248138427734887 50.022562408447286)
30782	POLYGON((-1.47980797290802 47.8985900878906,-1.47604870796204 47.9074134826661,-1.4623411893844 47.9079818725587,-1.4623411893844 47.9079818725587,-1.43876314163208 47.9017791748048,-1.4289835691452 47.8899726867676,-1.4289835691452 47.8899726867676,-1.42958247661585 47.8865509033203,-1.43448209762573 47.8855285644532,-1.44443202018732 47.8872070312501,-1.46368515491474 47.8838081359863,-1.46368515491474 47.8838081359863,-1.48480021953577 47.892791748047,-1.47980797290802 47.8985900878906))	0.0006	POINT(-1.4536874202581147 47.89410664485057)
56430	POLYGON((4.67038106918335 45.8557167053223,4.65581130981457 45.8564453125001,4.63696622848516 45.8460273742676,4.63696622848516 45.8460273742676,4.63313817977905 45.8407974243165,4.62477254867548 45.8398437500001,4.62477254867548 45.8398437500001,4.62187242507946 45.8350067138671,4.62187242507946 45.8350067138671,4.63060474395758 45.8322563171387,4.63628530502319 45.8235015869142,4.63628530502319 45.8235015869142,4.66811800003063 45.8273429870605,4.67541217803961 45.8431129455566,4.67541217803961 45.8431129455566,4.67038106918335 45.8557167053223))	0.0006	POINT(4.643244711558066 45.83916956583662)
47552	POLYGON((1.81097400188457 50.8563652038575,1.82036471366894 50.8638839721681,1.81555604934692 50.8729629516602,1.81555604934692 50.8729629516602,1.79640829563152 50.8890647888184,1.79640829563152 50.8890647888184,1.76336085796351 50.8786659240724,1.76336085796351 50.8786659240724,1.76181280612946 50.8701705932618,1.76963949203503 50.8626937866212,1.76963949203503 50.8626937866212,1.77387201786047 50.8606452941895,1.78855013847351 50.8639221191406,1.79996013641357 50.8569526672363,1.79996013641357 50.8569526672363,1.81097400188457 50.8563652038575))	0.0006	POINT(1.789694889386537 50.86904449462897)
12341	POLYGON((14.2935485839845 41.9951362609864,14.2660379409791 42.004249572754,14.2575788497924 42.0048713684083,14.2440414428711 41.9978370666505,14.2407140731811 41.9973602294923,14.2268819808961 41.9990310668946,14.2268819808961 41.9990310668946,14.2315759658815 41.9912261962891,14.2097320556641 41.9779281616212,14.2097320556641 41.9779281616212,14.2045087814332 41.9719047546388,14.2012157440186 41.9563179016113,14.1881561279297 41.9633522033693,14.1881561279297 41.9633522033693,14.1884126663208 41.958236694336,14.1869029998779 41.9470520019532,14.1794786453247 41.9305877685547,14.1716489791871 41.9231643676759,14.1708736419677 41.9159622192384,14.1708736419677 41.9159622192384,14.1926078796387 41.9270133972169,14.1956033706665 41.9295921325685,14.1956033706665 41.9295921325685,14.1947669982911 41.9329109191895,14.1961746215821 41.9407997131348,14.2043008804322 41.9528274536133,14.2086820602418 41.9555587768555,14.2182321548463 41.9598922729492,14.2289390563965 41.9606590270997,14.2396211624146 41.9572982788087,14.2429037094117 41.9552230834962,14.2428073883057 41.9542770385743,14.2428073883057 41.9542770385743,14.2549695968628 41.9645042419435,14.276460647583 41.9763069152833,14.2845773696901 41.9770317077637,14.2879009246827 41.9818878173829,14.286889076233 41.9828567504883,14.286889076233 41.9828567504883,14.2835969924927 41.9846496582031,14.2832870483398 41.9874992370606,14.289273262024 41.989860534668,14.294529914856 41.9948272705079,14.2935485839845 41.9951362609864))	0.0006	POINT(14.229962238045665 41.96564403800083)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point