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
72016	POLYGON((13.0391912460328 48.1101608276368,13.0355205535889 48.1173133850098,13.0352020263672 48.1202392578125,13.0374917984009 48.1221542358398,13.0505800247193 48.1276817321778,13.0538902282714 48.130096435547,13.0542459487915 48.1341323852539,13.0522899627686 48.1436195373535,13.0522899627686 48.1436195373535,13.0470523834229 48.1400871276857,13.0470523834229 48.1400871276857,13.0365858078003 48.132884979248,13.032241821289 48.1309280395508,13.0163497924806 48.1330642700196,13.0135517120362 48.1300201416016,13.0077333450319 48.1189575195313,13.004174232483 48.1167907714844,12.9973249435425 48.1153106689454,12.9973249435425 48.1153106689454,13.0222921371459 48.1149330139161,13.0241184234619 48.1121482849121,13.0261096954346 48.0995674133301,13.0261096954346 48.0995674133301,13.0385303497316 48.1015129089356,13.0391912460328 48.1101608276368))	0.0006	POINT(13.031135559082069 48.1229244867961)
25023	POLYGON((2.54796552658092 48.6496582031251,2.54244899749762 48.644027709961,2.5406653881073 48.6338195800782,2.52141213417053 48.6318817138673,2.52141213417053 48.6318817138673,2.5052227973938 48.6318511962891,2.5052227973938 48.6318511962891,2.49663662910473 48.6314277648927,2.49161934852594 48.6394119262695,2.49161934852594 48.6394119262695,2.49048852920532 48.642635345459,2.50939297676092 48.6574783325196,2.51816439628607 48.6603736877442,2.51816439628607 48.6603736877442,2.53375220298761 48.6572952270509,2.53375220298761 48.6572952270509,2.54796552658092 48.6496582031251))	0.0006	POINT(2.516746237874044 48.64379215240485)
54524	POLYGON((5.37488698959362 46.0481491088868,5.3840584754945 46.0460281372071,5.40164804458624 46.0352325439454,5.42475891113293 46.0313072204591,5.42475891113293 46.0313072204591,5.44128561019909 46.0254020690919,5.44128561019909 46.0254020690919,5.44603967666632 46.030517578125,5.43806123733526 46.0340576171876,5.43669271469128 46.0405387878418,5.44800710678101 46.0511703491211,5.44803380966198 46.0575828552247,5.44803380966198 46.0575828552247,5.43895673751842 46.0565795898439,5.42748022079462 46.0613021850587,5.42748022079462 46.0613021850587,5.40346479415905 46.0593299865723,5.39620590209972 46.0712203979493,5.3831720352174 46.0751075744629,5.3831720352174 46.0751075744629,5.37632656097412 46.0589981079102,5.37632656097412 46.0589981079102,5.3785452842713 46.0531616210939,5.37488698959362 46.0481491088868))	0.0006	POINT(5.415160054745956 46.04979938009518)
40261	POLYGON((1.49550628662109 45.0831718444825,1.50048792362213 45.088436126709,1.49603986740118 45.0940589904786,1.49831759929657 45.1100807189943,1.49831759929657 45.1100807189943,1.50680005550385 45.1124725341798,1.5132305622102 45.1212692260742,1.51798343658442 45.1214408874512,1.5464398860932 45.1052436828614,1.5464398860932 45.1052436828614,1.54373681545263 45.0957527160646,1.52420997619635 45.088436126709,1.53254270553595 45.0809440612793,1.53254270553595 45.0809440612793,1.525051355362 45.0767745971681,1.51540076732641 45.075954437256,1.50499761104584 45.081901550293,1.49550628662109 45.0831718444825))	0.0006	POINT(1.5175320611280905 45.09601211547859)
17529	POLYGON((8.02067756652843 44.7525978088379,8.01349830627441 44.7466888427734,8.01083564758301 44.7491760253906,8.00832653045666 44.7495002746582,8.00144290924067 44.7450256347657,8.00144290924067 44.7450256347657,7.99978113174444 44.7352104187012,7.99978113174444 44.7352104187012,8.00304126739513 44.7282600402831,8.00304126739513 44.7282600402831,8.00662708282482 44.7288398742675,8.02670097351086 44.7224273681642,8.04532337188726 44.7206115722657,8.05419635772705 44.7239303588868,8.05723190307617 44.728702545166,8.05691623687756 44.7320556640626,8.05898475646978 44.7354888916016,8.06123924255382 44.7350921630859,8.06608104705816 44.7301597595216,8.06608104705816 44.7301597595216,8.07485294342052 44.7359428405762,8.07485294342052 44.7359428405762,8.05575275421143 44.7476501464844,8.03490829467773 44.7522239685059,8.02648067474371 44.7496643066407,8.02067756652843 44.7525978088379))	0.0006	POINT(8.033123931884823 44.73695388793947)
38962	POLYGON((2.38216757774364 42.8484649658204,2.37084913253784 42.8463516235353,2.37084913253784 42.8463516235353,2.35435152053833 42.8605842590331,2.34167098999023 42.86421585083,2.32833933830273 42.8626937866212,2.32833933830273 42.8626937866212,2.30140686035162 42.8852462768556,2.29809999465942 42.8988227844239,2.29809999465942 42.8988227844239,2.31314921379089 42.9005470275879,2.31314921379089 42.9005470275879,2.33216905593872 42.8996047973633,2.34415745735163 42.8940925598145,2.39064478874207 42.8884963989259,2.41273999214172 42.8948974609376,2.41273999214172 42.8948974609376,2.40898895263678 42.8885078430176,2.40094399452215 42.8847579956055,2.38057899475103 42.8656425476075,2.38216757774364 42.8484649658204))	0.0006	POINT(2.3541717767715697 42.879311943054255)
66266	POLYGON((11.4385261535646 49.8737754821777,11.4364318847657 49.8742065429688,11.4289188385011 49.8715934753419,11.4207458496094 49.8701133728027,11.4198865890503 49.8724784851075,11.4189548492432 49.8725318908693,11.4195213317871 49.8744506835938,11.4156408309937 49.874626159668,11.4135351181031 49.8737525939941,11.4136056900025 49.8723487854005,11.4158248901367 49.8719062805176,11.4145574569703 49.8704223632812,11.4098329544067 49.8716239929199,11.4074592590331 49.8705253601074,11.4045820236205 49.8671226501465,11.4092140197754 49.8639869689941,11.4072971343995 49.8635101318359,11.4074602127076 49.8625526428223,11.4102182388307 49.8582954406738,11.4127063751222 49.8574295043945,11.4094877243043 49.8565101623536,11.409839630127 49.8559684753419,11.4036426544189 49.8557739257813,11.4021015167236 49.8537445068361,11.3985538482667 49.8552665710449,11.3969211578369 49.8543243408204,11.3949127197267 49.8548088073732,11.3953323364259 49.856388092041,11.3935861587525 49.8575248718262,11.3935861587525 49.8575248718262,11.3939571380615 49.8587837219239,11.3903970718385 49.8611335754394,11.3943758010864 49.8625411987306,11.3947544097901 49.8641204833984,11.3926916122437 49.8647499084472,11.3938522338867 49.8672332763672,11.3933038711548 49.8676872253419,11.3968811035156 49.8684234619142,11.3990325927734 49.871006011963,11.4027099609376 49.872615814209,11.4034109115601 49.8735733032228,11.4027290344238 49.8750877380371,11.403606414795 49.8758201599121,11.4069023132324 49.8778190612794,11.4094762802124 49.8770065307618,11.4095411300659 49.8782196044922,11.4095411300659 49.8782196044922,11.4148950576782 49.8786010742188,11.4143228530884 49.8821220397949,11.4117832183839 49.8833045959473,11.4178113937378 49.8832206726075,11.412564277649 49.8847923278809,11.4107065200806 49.8845176696778,11.409185409546 49.8872756958008,11.4066429138185 49.8883018493653,11.4112205505372 49.8880844116212,11.4108228683473 49.8898811340333,11.4124908447267 49.8896789550781,11.4167318344116 49.8864669799805,11.4233999252319 49.8863220214844,11.4256229400635 49.8853607177735,11.4256229400635 49.8853607177735,11.4258546829224 49.884376525879,11.4244318008423 49.8828430175781,11.4275512695314 49.8842658996582,11.4299602508546 49.8814125061035,11.4310913085938 49.8815650939941,11.4310913085938 49.8815650939941,11.4316339492798 49.878734588623,11.4385261535646 49.8737754821777))	0.0006	POINT(11.410804126573684 49.87242292321249)
33787	POLYGON((3.42087173461914 48.4090194702148,3.4579422473908 48.3971214294434,3.47048139572149 48.3746719360352,3.47048139572149 48.3746719360352,3.45011496543896 48.3728523254395,3.43158388137829 48.3608474731446,3.42658209800715 48.3616943359375,3.41400814056408 48.3765373229981,3.41479158401501 48.3902740478515,3.41479158401501 48.3902740478515,3.42087173461914 48.4090194702148))	0.0006	POINT(3.4371649026871416 48.38079643249513)
64417	POLYGON((11.9992933273315 50.1704711914062,11.9957399368286 50.1719970703125,11.9891462326051 50.1695060729982,11.9879932403566 50.1720504760743,11.9910192489624 50.1737937927246,11.9913530349731 50.175048828125,11.9895858764649 50.1767730712891,11.9901866912843 50.1816139221191,11.9871559143066 50.1841468811036,11.9870615005493 50.1860580444336,11.9932193756104 50.187110900879,11.9936571121216 50.1880760192871,11.9837274551392 50.1892242431641,11.9738998413086 50.1887283325195,11.9747505187988 50.1912727355958,11.9728107452393 50.1920013427734,11.9727506637574 50.1932449340821,11.9727506637574 50.1932449340821,11.9717645645141 50.1953086853027,11.9681520462037 50.1963539123536,11.9658317565919 50.1983909606934,11.9657983779908 50.2022705078125,11.9641170501709 50.2027664184571,11.9617757797242 50.2023200988771,11.9598131179811 50.1996002197266,11.9603052139283 50.1982879638672,11.9547233581543 50.1955070495605,11.9539375305176 50.1977577209474,11.9550342559814 50.19921875,11.9511861801147 50.2012748718262,11.9501075744628 50.2003898620607,11.946141242981 50.2004394531251,11.9467897415162 50.1973533630372,11.943941116333 50.196804046631,11.942699432373 50.1993141174316,11.9372816085817 50.2000122070312,11.9332113265991 50.1980361938478,11.9352302551269 50.1948013305665,11.9332141876222 50.192108154297,11.9344682693483 50.1918830871582,11.9356203079223 50.1891975402831,11.9387493133545 50.1897506713868,11.9382247924805 50.1909294128418,11.9410228729248 50.1912269592286,11.9409351348877 50.189723968506,11.9432563781738 50.1881752014161,11.9408264160157 50.1848030090331,11.9408254623413 50.1829147338868,11.9434852600098 50.182357788086,11.9427089691162 50.1803627014161,11.9357481002809 50.1800346374511,11.9331617355347 50.1788597106935,11.9377765655518 50.173942565918,11.9311265945435 50.1713371276856,11.9223766326905 50.1701850891113,11.9206094741822 50.1682548522949,11.9220075607301 50.1676902770996,11.9218511581421 50.1662406921387,11.9119348526001 50.1611633300782,11.9119348526001 50.1611633300782,11.8911790847778 50.1503753662109,11.8905658721924 50.1490516662598,11.8886032104492 50.1485061645508,11.8852214813233 50.1454162597656,11.8852214813233 50.1454162597656,11.8862342834473 50.1436576843262,11.8862342834473 50.1436576843262,11.8931999206544 50.1438789367676,11.895115852356 50.1418762207032,11.8946046829225 50.1406860351562,11.90149974823 50.1385498046874,11.9040040969849 50.1351890563966,11.9104413986206 50.1355323791504,11.9120206832886 50.136848449707,11.9154024124145 50.1371192932128,11.9172601699829 50.136043548584,11.9173259735109 50.1354141235352,11.9161205291749 50.1358337402345,11.9168453216553 50.1338615417482,11.9130220413209 50.1328926086427,11.9061555862427 50.133155822754,11.9056148529053 50.1309700012208,11.903079032898 50.1294860839844,11.903079032898 50.1294860839844,11.9070768356324 50.1255226135254,11.905704498291 50.123634338379,11.91059589386 50.1238327026368,11.91330909729 50.1228179931641,11.9138345718384 50.1212882995605,11.917332649231 50.1183776855469,11.9256658554078 50.1134605407716,11.9293870925903 50.1134223937989,11.9304752349854 50.1156234741212,11.932541847229 50.1150131225587,11.944730758667 50.1072006225587,11.944730758667 50.1072006225587,11.9455003738404 50.1067581176758,11.9455003738404 50.1067581176758,11.9535350799562 50.1100234985352,11.9543342590332 50.1119117736818,11.959011077881 50.1128959655761,11.9584360122681 50.1142349243165,11.9625091552735 50.116497039795,11.9642057418823 50.1161499023438,11.9698429107667 50.1196594238282,11.9692144393922 50.1219520568848,11.9733581542969 50.1260108947755,11.9830389022827 50.1262664794922,11.9831314086915 50.1269836425781,11.9806652069091 50.1282501220703,11.9837179183961 50.1287918090821,11.9840030670165 50.1296234130859,11.9819478988648 50.1361236572266,11.9963960647584 50.134765625,11.9978904724122 50.1368713378906,11.9943447113038 50.1496047973634,11.9964504241944 50.1550483703613,11.9964504241944 50.1550483703613,11.9951801300049 50.1547317504884,11.9933195114137 50.1561431884766,11.9953031539917 50.1577377319337,11.9971075057983 50.1576614379883,11.996922492981 50.1602172851563,11.9992685317993 50.1613197326661,11.9978942871094 50.1617088317872,12.0000953674316 50.1631011962892,12.0011796951295 50.1659202575683,12.0045099258423 50.166660308838,12.0019311904907 50.167091369629,12.0025434494019 50.1691436767579,12.0013370513917 50.1695365905763,12.0004940032958 50.1685752868653,11.9982872009278 50.1701164245605,11.9992933273315 50.1704711914062))	0.0006	POINT(11.950887981214048 50.159196007520656)
36500	POLYGON((5.65017509460444 47.3629188537598,5.66891765594488 47.3426208496094,5.66891765594488 47.3426208496094,5.66223239898693 47.3270111083985,5.65617275238037 47.3218154907227,5.65125274658209 47.321704864502,5.65125274658209 47.321704864502,5.64229536056513 47.311695098877,5.64229536056513 47.311695098877,5.64002513885498 47.3123855590821,5.64002513885498 47.3123855590821,5.62817811965942 47.3168525695801,5.62467432022095 47.3148040771485,5.62467432022095 47.3148040771485,5.61289405822748 47.3204040527345,5.59815883636475 47.3205528259277,5.59815883636475 47.3205528259277,5.5902099609375 47.319435119629,5.5902099609375 47.319435119629,5.60138225555426 47.3255691528321,5.6082496643067 47.3341369628907,5.6082496643067 47.3341369628907,5.61779499053955 47.339683532715,5.6165761947633 47.3424072265625,5.6165761947633 47.3424072265625,5.63116693496704 47.3499946594239,5.63679599761969 47.3620452880859,5.63679599761969 47.3620452880859,5.64375257492071 47.3641357421875,5.64375257492071 47.3641357421875,5.65017509460444 47.3629188537598))	0.0006	POINT(5.630060450236027 47.33186988830572)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point