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
22688	POLYGON((-0.616947948932648 44.2235260009766,-0.62231832742691 44.1843872070312,-0.62231832742691 44.1843872070312,-0.619535684585514 44.170394897461,-0.621961832046509 44.159954071045,-0.641611993312836 44.1275405883788,-0.641611993312836 44.1275405883788,-0.64884752035141 44.1186599731446,-0.677895367145538 44.1009674072266,-0.677895367145538 44.1009674072266,-0.702398896217289 44.1116638183595,-0.707959234714508 44.1173439025878,-0.727152287960052 44.116870880127,-0.785756766796055 44.0865402221679,-0.785756766796055 44.0865402221679,-0.82441455125803 44.082691192627,-0.82441455125803 44.082691192627,-0.838475406169891 44.0874710083009,-0.838475406169891 44.0874710083009,-0.834887325763702 44.0974807739258,-0.847005605697632 44.1601638793945,-0.847005605697632 44.1601638793945,-0.794626832008248 44.1782608032228,-0.789705693721771 44.1842613220216,-0.780321836471501 44.1853256225587,-0.7714248895644 44.1935348510742,-0.7714248895644 44.1935348510742,-0.743123173713684 44.1897926330568,-0.713810801506042 44.189868927002,-0.684580564498845 44.1912078857423,-0.641606569290161 44.1983261108398,-0.633596837520599 44.201946258545,-0.616947948932648 44.2235260009766))	0.0006	POINT(-0.7274646516889085 44.14629614353181)
53082	POLYGON((0.365104347467479 46.718879699707,0.355802088975963 46.7181091308593,0.341407746076641 46.7084426879883,0.331404983997402 46.7078399658203,0.317329138517493 46.693458557129,0.304582267999763 46.6885833740234,0.305923968553657 46.6747283935547,0.305923968553657 46.6747283935547,0.301626890897808 46.6729621887208,0.283354192972183 46.6837120056152,0.283354192972183 46.6837120056152,0.282225191593227 46.690315246582,0.2753922045232 46.6949844360353,0.277316898107642 46.7015151977538,0.264841616153831 46.7050552368165,0.264841616153831 46.7050552368165,0.284762322902736 46.7212791442871,0.289816588163433 46.7313003540039,0.286549687385616 46.7340049743653,0.286549687385616 46.7340049743653,0.283267468214149 46.7600479125978,0.283267468214149 46.7600479125978,0.295494049787635 46.7661895751953,0.310368150472641 46.764747619629,0.334832191467399 46.7695617675782,0.334832191467399 46.7695617675782,0.342413872480392 46.762809753418,0.342413872480392 46.762809753418,0.336400210857448 46.7573890686036,0.336394101381359 46.7508392333985,0.341864943504333 46.7413711547851,0.36177039146429 46.7316856384278,0.36624720692646 46.7255630493164,0.365104347467479 46.718879699707))	0.0006	POINT(0.3114447187294366 46.723190770004756)
29182	POLYGON((4.72087574005138 46.746711730957,4.70407962799072 46.7509078979492,4.69677019119268 46.7471961975097,4.69677019119268 46.7471961975097,4.69305562973017 46.7406768798828,4.69305562973017 46.7406768798828,4.70943641662598 46.7333641052247,4.74501705169678 46.7302360534668,4.74501705169678 46.7302360534668,4.72896385192871 46.7382164001466,4.72087574005138 46.746711730957))	0.0006	POINT(4.713304138183605 46.74054183959961)
63218	POLYGON((10.9252843856812 53.6938552856445,10.9239540100097 53.6946144104004,10.9221420288085 53.6994705200196,10.916660308838 53.6991653442384,10.916660308838 53.6991653442384,10.9185037612916 53.7034721374513,10.9205627441407 53.7050666809082,10.9406766891481 53.7055091857911,10.9499473571777 53.704387664795,10.9516983032226 53.7067604064941,10.9551067352295 53.7068748474122,10.953426361084 53.7097930908204,10.9621915817261 53.7152595520021,10.9621915817261 53.7152595520021,10.9702730178834 53.7174034118652,10.9713830947876 53.7192115783692,10.9755849838257 53.7198333740234,10.978572845459 53.7215042114257,10.9813404083252 53.7238464355469,10.9829015731813 53.7280349731445,11.0036449432374 53.7295608520508,11.0126428604127 53.7293548583984,11.0126428604127 53.7293548583984,11.0163640975952 53.7288970947267,11.0186405181886 53.7254028320313,11.0186405181886 53.7254028320313,11.0149192810058 53.7233085632325,11.0176448822021 53.7117042541504,11.0154533386232 53.7095222473145,11.0161437988282 53.7076683044435,11.0152091979981 53.7055244445802,11.0168600082399 53.7042427062988,11.0212144851686 53.7037315368652,11.0228805541992 53.7011985778808,11.0308732986451 53.6998100280763,11.0323753356934 53.6987953186036,11.0323753356934 53.6987953186036,11.030550956726 53.6969261169434,11.0320396423341 53.694923400879,11.0316486358644 53.6913490295411,11.038317680359 53.6856498718262,11.038317680359 53.6856498718262,11.0343313217163 53.6817588806152,11.0347595214844 53.6762733459473,11.0295343399047 53.6713294982911,11.0274724960328 53.6722297668457,11.0263748168946 53.6683082580567,11.0294513702393 53.6675148010254,11.0306243896486 53.6681098937989,11.0299520492554 53.6663703918458,11.0250282287597 53.6657524108887,11.0245409011841 53.6617584228517,11.0219688415528 53.6617317199707,11.021900177002 53.6597747802734,11.0247793197632 53.6538658142091,11.0208444595337 53.65242767334,11.0179691314697 53.6484146118165,11.0133285522461 53.6473388671875,11.0090913772583 53.6509780883789,11.0146312713623 53.6526336669923,11.0142536163331 53.6565437316896,11.0115938186646 53.6567802429199,11.0107669830323 53.6585006713868,11.0082502365112 53.6593093872071,11.0063505172729 53.6585540771486,11.0069875717163 53.6574020385743,11.0055913925171 53.6556816101075,11.0010442733766 53.6561393737794,11.0035829544068 53.6585998535156,11.0024948120117 53.6612548828125,11.0002346038819 53.6620903015136,11.0002346038819 53.6620903015136,11.0060844421387 53.6669273376465,10.9945688247681 53.6720771789551,10.9850215911865 53.6734275817872,10.9826812744141 53.6752433776857,10.9865732192994 53.6769332885742,10.9840478897095 53.6797943115234,10.9830894470215 53.6793289184571,10.9781169891359 53.6826744079591,10.9800052642822 53.6864662170411,10.9758167266846 53.6882438659668,10.9644422531128 53.6876678466797,10.9634408950806 53.6859741210939,10.958493232727 53.6861419677735,10.9583559036255 53.6889381408693,10.9569406509399 53.6896820068359,10.9517574310303 53.6861419677735,10.9510383605956 53.6883544921875,10.9501333236695 53.6886367797852,10.9459009170533 53.6862258911132,10.9252843856812 53.6938552856445))	0.0006	POINT(10.993768555777452 53.68762261526927)
46774	POLYGON((2.45342373847961 50.8526268005371,2.46640658378595 50.8671913146973,2.45540499687195 50.8789138793946,2.45540499687195 50.8789138793946,2.44546341896068 50.8905220031738,2.45147442817694 50.8959503173829,2.44226574897766 50.9114265441895,2.44226574897766 50.9114265441895,2.45057535171509 50.9157905578614,2.47723245620728 50.9137496948242,2.47723245620728 50.9137496948242,2.48152947425848 50.9044303894044,2.48902320861828 50.8999938964844,2.49409413337713 50.8993682861329,2.49561762809759 50.9058227539064,2.49561762809759 50.9058227539064,2.51453495025646 50.908229827881,2.51453495025646 50.908229827881,2.52133941650396 50.9043998718263,2.52133941650396 50.9043998718263,2.50879240036022 50.8977394104005,2.50395512580883 50.887752532959,2.49361419677734 50.8795394897462,2.49645972251898 50.8729743957519,2.51956057548534 50.8636817932129,2.51956057548534 50.8636817932129,2.50011348724371 50.8535690307618,2.48793792724615 50.8356819152833,2.48793792724615 50.8356819152833,2.47564554214489 50.8324737548828,2.47564554214489 50.8324737548828,2.45342373847961 50.8526268005371))	0.0006	POINT(2.4843227017310907 50.884716403099844)
40952	POLYGON((0.710514545440731 45.8022003173828,0.707490503788108 45.7782478332521,0.714764952659664 45.769214630127,0.711681544780731 45.7628555297853,0.711681544780731 45.7628555297853,0.710395753383693 45.7541275024413,0.713748514652309 45.7520980834961,0.722025156021175 45.7542266845704,0.722025156021175 45.7542266845704,0.74099588394165 45.7566986083985,0.734539985656681 45.7766761779786,0.739978313446045 45.7822113037109,0.749485075473785 45.7820930480957,0.762051343917904 45.7770118713379,0.765136301517487 45.7796745300294,0.765136301517487 45.7796745300294,0.77022689580923 45.7884788513184,0.77022689580923 45.7884788513184,0.762003242969627 45.7969436645508,0.752389132976532 45.7971038818359,0.742600083351249 45.8043785095216,0.71872121095663 45.8055839538574,0.710514545440731 45.8022003173828))	0.0006	POINT(0.7362644699487206 45.77750275351789)
68093	POLYGON((6.69329595565802 49.6929092407227,6.69462585449224 49.7006034851075,6.69462585449224 49.7006034851075,6.70574426651001 49.6982460021972,6.71258687973022 49.6955032348633,6.72651195526129 49.6985359191895,6.72651195526129 49.6985359191895,6.72770833969122 49.6949996948243,6.72455072402965 49.6931343078613,6.72510910034174 49.6918754577637,6.72925233840942 49.689525604248,6.72914695739757 49.6852455139161,6.73007917404175 49.6829338073732,6.72886610031139 49.680892944336,6.72909212112427 49.6778640747071,6.72653341293335 49.6759872436525,6.71872711181635 49.6760520935059,6.71872711181635 49.6760520935059,6.71473932266235 49.6771430969239,6.70649480819714 49.6757316589355,6.70775842666637 49.6792144775392,6.70950603485107 49.6802291870117,6.70498657226557 49.6830863952637,6.70286655426037 49.6815834045411,6.70154571533214 49.6825447082521,6.69949054718023 49.6814079284669,6.6993455886842 49.6852989196777,6.6993455886842 49.6852989196777,6.69329595565802 49.6929092407227))	0.0006	POINT(6.713849084717928 49.6864656720843)
57176	POLYGON((7.24847841262823 50.5789794921875,7.23011493682867 50.5814590454102,7.22263813018799 50.5833930969239,7.22263813018799 50.5833930969239,7.22856330871593 50.5886840820312,7.2264771461488 50.589786529541,7.22767686843883 50.5900268554687,7.2270975112915 50.5914344787599,7.22957706451416 50.5921897888185,7.23180341720587 50.5911102294923,7.23166704177868 50.5934638977051,7.23820018768311 50.5949363708496,7.2360639572143 50.5967597961427,7.23819780349726 50.5976104736329,7.23520278930664 50.5997695922852,7.24220943450939 50.6005554199219,7.24220943450939 50.6005554199219,7.24938583374035 50.5986938476563,7.25287628173834 50.5952987670899,7.25584173202526 50.5945701599121,7.25963544845587 50.595359802246,7.26752138137817 50.6010208129883,7.27327156066895 50.5995178222657,7.2753052711488 50.6010131835938,7.27441024780285 50.6031150817871,7.27572202682495 50.6042060852052,7.27643156051636 50.6070518493653,7.27846050262451 50.6075973510742,7.27720212936401 50.6088027954102,7.27124357223522 50.6086006164552,7.26973533630371 50.610767364502,7.26718378067028 50.6112327575685,7.26740646362305 50.6129264831544,7.26959228515625 50.6142730712891,7.26887607574463 50.6145973205566,7.26887607574463 50.6145973205566,7.2682609558106 50.6151008605956,7.26958322525036 50.6160392761232,7.26998758316051 50.6177711486816,7.27243566513073 50.6194229125977,7.27340221405041 50.6220359802246,7.28220415115368 50.6227035522461,7.31515407562256 50.6307220458985,7.31515407562256 50.6307220458985,7.31950426101685 50.6298446655275,7.32992601394665 50.6298408508301,7.32992601394665 50.6298408508301,7.32886123657232 50.6259117126465,7.32632017135626 50.6247634887695,7.32599973678583 50.6236457824708,7.31041097640997 50.6195144653321,7.31107425689703 50.6170578002931,7.31107425689703 50.6170578002931,7.30413579940796 50.6164703369141,7.30012702941889 50.6136093139649,7.29238462448131 50.6150550842286,7.28490734100342 50.6148986816407,7.2825164794923 50.611385345459,7.28287029266363 50.6085014343262,7.27811813354492 50.6022911071778,7.27762746810919 50.6003761291505,7.27866125106817 50.5987205505371,7.27866125106817 50.5987205505371,7.27455377578735 50.5967254638672,7.27172136306774 50.597583770752,7.26511621475231 50.5973358154297,7.2638258934021 50.5955314636231,7.26016378402704 50.5948791503907,7.26088857650768 50.5923881530763,7.2571849822998 50.5915184020996,7.2547345161438 50.5892066955566,7.25504827499401 50.5875167846681,7.25116920471191 50.5858535766602,7.25203752517706 50.5851669311524,7.25041437149059 50.5832862854004,7.24819421768188 50.5826644897462,7.24940919876099 50.5818710327148,7.24847841262823 50.5789794921875))	0.0006	POINT(7.2687213451831845 50.60377794736394)
52137	POLYGON((-0.809242665767613 45.691734313965,-0.794974863529205 45.6952705383302,-0.775150120258274 45.6928176879883,-0.775150120258274 45.6928176879883,-0.77895313501358 45.7012176513672,-0.77895313501358 45.7012176513672,-0.77707314491272 45.7190856933594,-0.77707314491272 45.7190856933594,-0.790518820285797 45.7150917053224,-0.80927985906601 45.7163619995117,-0.811645925044957 45.7030830383302,-0.811645925044957 45.7030830383302,-0.813186407089233 45.6970634460449,-0.809242665767613 45.691734313965))	0.0006	POINT(-0.7925267127843784 45.7036869342511)
57042	POLYGON((7.54532718658453 50.0211601257324,7.53679227828979 50.0184173583984,7.5367159843446 50.0191879272461,7.52549982070917 50.0190963745118,7.52564239501959 50.0199356079102,7.52241992950439 50.0198440551758,7.51937866210949 50.0215377807618,7.51937866210949 50.0215377807618,7.51824474334722 50.0193481445312,7.51824474334722 50.0193481445312,7.5180721282959 50.0154266357422,7.5190629959107 50.015453338623,7.51944351196295 50.0136260986328,7.52359914779663 50.0128707885742,7.52485036849987 50.0118560791017,7.52431011199951 50.0095558166504,7.52810955047607 50.0086822509766,7.52810955047607 50.0086822509766,7.53363609313976 50.0072250366212,7.53465795516973 50.0056304931641,7.53465795516973 50.0056304931641,7.53727340698242 50.0053634643556,7.53987121582031 50.0093002319336,7.5409660339356 50.0090980529786,7.54272222518915 50.0114021301271,7.54272222518915 50.0114021301271,7.54702758789074 50.0189971923828,7.54689311981207 50.0207061767578,7.54532718658453 50.0211601257324))	0.0006	POINT(7.530486771038638 50.01429721287322)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point