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
44236	POLYGON((0.822369992733002 43.8816146850587,0.868991315364951 43.8730468750001,0.868991315364951 43.8730468750001,0.875105142593441 43.8876686096193,0.875105142593441 43.8876686096193,0.871428489685115 43.8897933959962,0.863650143146515 43.8860855102539,0.844400882721061 43.8954582214357,0.844400882721061 43.8954582214357,0.814002275466919 43.8940620422364,0.814002275466919 43.8940620422364,0.822369992733002 43.8816146850587))	0.0006	POINT(0.8511316234415797 43.887087735262895)
28157	POLYGON((4.55486869812017 47.2397689819335,4.54730081558228 47.24418258667,4.52591419219982 47.2700653076173,4.52591419219982 47.2700653076173,4.56015205383306 47.2760467529297,4.5866460800172 47.2852325439454,4.5866460800172 47.2852325439454,4.58451652526867 47.2834701538086,4.58451652526867 47.2834701538086,4.5598077774049 47.2409362792969,4.5598077774049 47.2409362792969,4.55486869812017 47.2397689819335))	0.0006	POINT(4.561462792483335 47.26540062644269)
69550	POLYGON((10.8903093338013 54.1738891601564,10.8903236389161 54.172103881836,10.8917322158814 54.1720962524415,10.8917322158814 54.1720962524415,10.8934354782104 54.1743278503419,10.8954992294312 54.1739463806153,10.9019880294799 54.1754493713379,10.9052467346191 54.1720352172852,10.9067754745484 54.1718063354493,10.913332939148 54.1773071289064,10.9218492507936 54.1777572631836,10.9265804290772 54.1763496398926,10.9301328659058 54.1764335632325,10.9330425262452 54.178050994873,10.93199634552 54.1790618896486,10.9331254959106 54.1802062988282,10.9367733001708 54.1791229248047,10.9415416717529 54.1798629760742,10.9468030929565 54.1838378906249,10.943497657776 54.1884117126465,10.9459095001221 54.1907043457031,10.9439325332642 54.1935119628907,10.9461526870729 54.1949501037599,10.9429454803467 54.1957778930665,10.9419040679932 54.1972808837891,10.9290771484376 54.2041969299316,10.9290771484376 54.2041969299316,10.9262752532958 54.2028160095214,10.9209251403809 54.2039375305177,10.9197111129762 54.2050361633301,10.9138593673706 54.2050476074219,10.9101371765137 54.2082633972169,10.9105014801027 54.20955657959,10.9105014801027 54.20955657959,10.9047040939331 54.2072334289551,10.9004955291749 54.2075958251954,10.9004955291749 54.2075958251954,10.8971414566041 54.2061080932618,10.9010858535767 54.201946258545,10.8994922637939 54.1952705383301,10.9007081985473 54.1942329406738,10.8999891281128 54.1926994323732,10.8923454284668 54.1907920837403,10.8922615051271 54.1883163452149,10.8954782485962 54.1834449768067,10.8932113647461 54.1766014099122,10.8900556564332 54.1746520996095,10.8903093338013 54.1738891601564))	0.0006	POINT(10.914555143802763 54.18905266295093)
33080	POLYGON((2.33739256858837 47.7226486206056,2.32666134834295 47.7105026245117,2.28430390357971 47.6957473754883,2.28430390357971 47.6957473754883,2.30195116996765 47.6889877319336,2.29311251640326 47.6729316711426,2.30950903892517 47.6602287292482,2.29513549804693 47.6418685913086,2.29395437240612 47.6314926147462,2.29395437240612 47.6314926147462,2.3324215412141 47.642448425293,2.38040065765392 47.6696548461915,2.40643811225891 47.6709594726564,2.40643811225891 47.6709594726564,2.39697432518011 47.6782379150392,2.39600753784174 47.6941719055177,2.39600753784174 47.6941719055177,2.38952922821045 47.7033920288087,2.39510059356689 47.7165184020996,2.39510059356689 47.7165184020996,2.37027788162231 47.7132568359376,2.33739256858837 47.7226486206056))	0.0006	POINT(2.346903562545807 47.68199702671603)
1399216	POLYGON((-3.17045998573298 42.2697601318361,-3.1795990467071 42.277603149414,-3.19092893600464 42.2821388244629,-3.19169902801514 42.2923240661622,-3.19483304023743 42.2972908020021,-3.20022296905518 42.298755645752,-3.20913910865778 42.3061447143555,-3.20645594596863 42.31649017334,-3.21225190162659 42.3223152160646,-3.21570992469788 42.3217926025391,-3.23042798042297 42.3117065429689,-3.23936009407043 42.3086891174317,-3.24336910247803 42.3130035400391,-3.24476194381714 42.3185043334962,-3.251804113388 42.3197402954103,-3.25152611732477 42.3291244506836,-3.23730707168573 42.3434104919434,-3.23515105247492 42.3514137268067,-3.23135089874268 42.3549690246582,-3.21585988998402 42.351676940918,-3.20854210853577 42.3381271362305,-3.20369601249689 42.3413848876954,-3.19805788993835 42.3359489440919,-3.19338989257807 42.333824157715,-3.18897795677185 42.3355407714845,-3.18548107147217 42.3269004821778,-3.18046307563782 42.3246841430665,-3.17193007469172 42.315357208252,-3.17133498191833 42.3110733032227,-3.15961098670948 42.3051185607911,-3.15670299530029 42.301887512207,-3.15829396247864 42.2882156372071,-3.15623307228088 42.2837486267091,-3.15996193885798 42.2812881469727,-3.16355800628662 42.2741317749025,-3.17045998573298 42.2697601318361))	0.0006	POINT(-3.2002414907727683 42.313831002371714)
71273	POLYGON((13.9422407150269 46.9391212463379,13.9328222274781 46.941593170166,13.9281816482545 46.9417343139649,13.9040365219117 46.9335403442383,13.8939580917358 46.9286041259766,13.8778753280641 46.914794921875,13.8778753280641 46.914794921875,13.8868427276611 46.9104385375977,13.8971824645996 46.9072341918946,13.9045896530151 46.9064903259277,13.9219388961792 46.9073295593262,13.9283838272095 46.9053611755371,13.9309406280518 46.9017066955566,13.9355869293214 46.8893585205079,13.9388780593873 46.885108947754,13.9461326599121 46.880283355713,13.9591693878174 46.8737831115724,13.9637975692749 46.8695793151856,13.9602184295655 46.8547477722169,13.9583368301392 46.835220336914,13.9583368301392 46.835220336914,13.9652423858643 46.8310585021974,13.9711408615112 46.8256149291993,13.9733934402467 46.821403503418,13.9779167175294 46.8029098510743,13.9798583984375 46.7996253967286,13.9844799041749 46.7962570190431,14.0025358200074 46.7896881103516,14.019139289856 46.7851638793946,14.0290517807007 46.7858009338379,14.0417432785034 46.7890014648439,14.0417432785034 46.7890014648439,14.0461215972901 46.7947425842285,14.0500516891481 46.7977752685548,14.0645046234131 46.7973670959473,14.0780820846559 46.8048095703126,14.0930891036988 46.802589416504,14.0977773666382 46.8043403625489,14.1033716201783 46.8079719543458,14.1033716201783 46.8079719543458,14.1211805343629 46.825855255127,14.1228179931642 46.8301658630371,14.1231374740601 46.8343696594238,14.1190719604492 46.8405494689942,14.1213636398317 46.8434410095215,14.1297702789306 46.850025177002,14.1297702789306 46.850025177002,14.1133041381837 46.8393058776857,14.1042833328247 46.8356742858888,14.0998973846437 46.8349113464357,14.0926275253296 46.8358955383301,14.0786952972413 46.8409652709961,14.0663785934449 46.8439559936525,14.0493984222412 46.8463897705079,14.0272979736328 46.8474388122559,14.0192661285401 46.849220275879,14.0117292404174 46.8522186279297,14.0024175643921 46.8589515686036,13.9979085922241 46.8648681640626,13.994875907898 46.8724403381348,13.9894495010377 46.8972244262695,13.9843368530275 46.90678024292,13.9766960144043 46.9123420715333,13.9559993743897 46.9191589355469,13.9480419158937 46.9238510131837,13.9434347152711 46.9301033020019,13.9419889450073 46.9360733032228,13.9422407150269 46.9391212463379))	0.0006	POINT(14.005001181986838 46.85718416811817)
1409304	POLYGON((-2.51651906967157 43.3424987792969,-2.51969790458679 43.3446350097656,-2.52779388427734 43.3411026000978,-2.53662800788874 43.3424987792969,-2.54245305061335 43.3373527526856,-2.56520795822138 43.3380546569824,-2.58027291297913 43.3448524475099,-2.5889430046081 43.3471908569337,-2.59809994697565 43.3543090820312,-2.60081696510315 43.3578491210938,-2.59482097625732 43.3577575683594,-2.59351491928101 43.3612442016602,-2.58792400360107 43.361198425293,-2.58169507980341 43.3643531799316,-2.58149194717402 43.3705940246583,-2.56214904785151 43.367317199707,-2.55069398880005 43.3743057250978,-2.54097199439997 43.3731956481934,-2.53902697563171 43.3756942749023,-2.53291702270508 43.3770828247071,-2.51736211776728 43.375415802002,-2.51364207267761 43.3773612976075,-2.51269888877863 43.3712120056152,-2.51602602004994 43.3657264709473,-2.50667309761047 43.357852935791,-2.50529408454895 43.3604736328125,-2.50100493431086 43.361141204834,-2.50102305412292 43.3590431213379,-2.50633597373962 43.3569145202637,-2.50335907936096 43.3542175292969,-2.50561308860767 43.3499412536622,-2.51651906967157 43.3424987792969))	0.0006	POINT(-2.5429248732904925 43.35878667523787)
73473	POLYGON((15.8135795593263 44.0110626220703,15.8254499435425 44.000804901123,15.8261623382569 43.9989776611329,15.8250980377198 43.9968223571777,15.8164749145508 43.9907341003418,15.801483154297 43.9837455749512,15.7879943847656 43.9821128845214,15.7817716598511 43.9802322387696,15.7793188095094 43.97806930542,15.778784751892 43.9750671386719,15.7812242507934 43.9687957763673,15.7893867492677 43.9603424072266,15.7972192764282 43.954761505127,15.8128938674926 43.9466819763184,15.8128938674926 43.9466819763184,15.805911064148 43.9354400634767,15.8006868362426 43.9310569763184,15.7968425750734 43.9295310974121,15.7926454544069 43.9296226501466,15.7881498336793 43.9315147399903,15.7822980880738 43.9379920959474,15.7783031463624 43.940773010254,15.7634563446046 43.9440460205079,15.7602758407594 43.9440498352051,15.7575521469117 43.9428215026855,15.7512397766114 43.9341545104981,15.7512397766114 43.9341545104981,15.7464408874513 43.9367752075196,15.7423629760743 43.944190979004,15.7360887527466 43.95064163208,15.7320194244385 43.951198577881,15.7227325439453 43.9478721618653,15.7192783355713 43.9486999511719,15.7181110382081 43.9507789611818,15.7210483551027 43.9561386108398,15.7276678085327 43.9611663818361,15.7294702529907 43.9768600463867,15.7327432632446 43.9825401306152,15.7400598526002 43.989227294922,15.7457027435303 44.0023880004884,15.7503128051758 44.0105895996095,15.7645349502563 44.021411895752,15.7672920227051 44.0289840698242,15.7690753936768 44.0304832458497,15.771821975708 44.0310974121094,15.7744646072388 44.0305252075195,15.7796792984009 44.0266838073732,15.7887344360351 44.0228691101075,15.7963390350342 44.0180969238281,15.8135795593263 44.0110626220703))	0.0006	POINT(15.772128922598737 43.97202589073965)
72774	POLYGON((15.8616151809693 47.0275039672852,15.8750848770142 47.0395317077638,15.8750848770142 47.0395317077638,15.8801002502442 47.0373725891114,15.8864660263062 47.0374870300292,15.925524711609 47.0470733642579,15.9316434860231 47.0505409240723,15.9350776672364 47.0575561523439,15.9350776672364 47.0575561523439,15.9530210494995 47.0571479797363,15.9530210494995 47.0571479797363,15.9655447006226 47.0515785217286,15.9655447006226 47.0515785217286,15.9765748977661 47.032512664795,15.9759683609009 47.0297737121583,15.9716730117797 47.0232696533204,15.9716730117797 47.0232696533204,15.9704446792603 47.0207633972168,15.9697647094727 47.0099449157715,15.9679765701294 47.0054473876954,15.9637794494629 47.0038681030273,15.9485511779786 47.0055618286133,15.946249961853 47.0049133300782,15.9471778869629 47.0026321411134,15.9586954116821 46.9893379211426,15.9629125595093 46.9804840087891,15.9729051589965 46.9708480834961,15.9737577438355 46.9690017700196,15.9735708236694 46.964900970459,15.9692869186401 46.9577827453613,15.963828086853 46.952823638916,15.9542541503907 46.9477310180665,15.9469270706178 46.94637298584,15.9469270706178 46.94637298584,15.9358224868774 46.9495468139649,15.929334640503 46.9526863098145,15.924732208252 46.9567451477051,15.9204149246217 46.9627342224121,15.9140195846558 46.9668998718263,15.906086921692 46.9669303894043,15.8890018463135 46.9621925354004,15.8840351104737 46.9628753662109,15.8801136016847 46.965259552002,15.8758955001832 46.9707641601563,15.8749074935914 46.9753952026368,15.8789339065552 46.9943504333497,15.8787908554077 47.0025253295898,15.8737144470214 47.0122261047364,15.8616151809693 47.0275039672852))	0.0006	POINT(15.932114760081008 47.00000731150315)
1388226	POLYGON((-3.02895498275757 37.2629623413087,-3.01832294464106 37.2747192382813,-3.01358389854425 37.2758979797363,-3.00125694274897 37.2763252258301,-2.99350810050964 37.2741241455078,-2.98012900352478 37.2742500305176,-2.98033404350281 37.2718238830568,-2.99252796173096 37.2505912780762,-3.00628399848927 37.2411804199219,-3.01053500175476 37.2405471801758,-3.01192092895502 37.2359428405762,-3.0291969776153 37.2187576293945,-3.04134202003479 37.2103157043457,-3.05441498756409 37.193473815918,-3.0516459941864 37.1830215454103,-3.0452349185943 37.1783447265625,-3.0476438999176 37.1756553649903,-3.04673004150385 37.173267364502,-3.05012607574463 37.1667861938477,-3.0478720664978 37.1637840270996,-3.05163002014154 37.1572494506837,-3.05951595306396 37.1597328186035,-3.06580400466913 37.178524017334,-3.07360792160028 37.1752281188965,-3.07792711257929 37.1797523498535,-3.08025789260864 37.1795501708985,-3.08082795143127 37.1847877502442,-3.09676194190979 37.2131614685059,-3.0952160358429 37.2316474914551,-3.09367609024048 37.233642578125,-3.09454393386841 37.2427940368653,-3.08656001090998 37.2424621582031,-3.0833420753479 37.2265853881836,-3.07378792762756 37.2107276916504,-3.07300591468805 37.2049217224121,-3.06863689422602 37.1963233947755,-3.06573796272272 37.2063064575196,-3.06126189231873 37.2025032043457,-3.05596494674677 37.217514038086,-3.05165100097656 37.2220878601074,-3.05330991744995 37.2233467102051,-3.04849910736078 37.2269744873047,-3.04498410224909 37.2323989868165,-3.0323240756988 37.255111694336,-3.03330397605896 37.2555885314942,-3.02926993370056 37.259204864502,-3.02895498275757 37.2629623413087))	0.0006	POINT(-3.047455943149043 37.21869344296664)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point