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.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlü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"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie 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"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
31117MULTIPOLYGON(((-3.02514004707331 47.4176406860352,-3.02402710914606 47.4162483215333,-3.02874994277948 47.4156951904297,-3.02847194671625 47.4168052673341,-3.02514004707331 47.4176406860352)),((-3.01958298683167 47.4134712219238,-3.0190269947052 47.41263961792,-3.01152896881104 47.4120826721193,-3.01152896881104 47.4112510681153,-3.0131950378418 47.4112510681153,-3.01458311080921 47.4095840454102,-3.01624894142151 47.4093055725098,-3.01680493354797 47.4106941223145,-3.02041697502136 47.4109725952149,-3.02069497108459 47.4131927490234,-3.01958298683167 47.4134712219238)),((-2.990972995758 47.4023628234863,-2.98819494247431 47.3993072509766,-2.98486089706415 47.3990287780762,-2.98097205162037 47.4006958007814,-2.98013806343073 47.3970832824707,-2.97569394111633 47.3968048095703,-2.97486209869385 47.3951377868652,-2.97180604934692 47.3945846557618,-2.97097110748291 47.3934707641603,-2.96263909339899 47.3929176330567,-2.96236109733582 47.3943061828614,-2.96097302436823 47.3943061828614,-2.95597290992737 47.3929176330567,-2.95597290992737 47.3912506103516,-2.95152807235718 47.3906936645508,-2.94763803482056 47.3926391601563,-2.94402790069574 47.3926391601563,-2.94264006614685 47.3934707641603,-2.94264006614685 47.3948593139648,-2.94041705131519 47.3937492370607,-2.94041705131519 47.3926391601563,-2.95180606842041 47.3876380920411,-2.954027891159 47.3843040466309,-2.95430588722223 47.3820838928223,-2.95319390296936 47.3806953430176,-2.94875001907349 47.3795814514161,-2.94875001907349 47.3754158020021,-2.9473619461059 47.3734741210937,-2.94597196578979 47.3731956481934,-2.94624996185303 47.3715286254884,-2.94847202301025 47.3709716796876,-2.94791603088379 47.372917175293,-2.94930601119995 47.3731956481934,-2.94958400726318 47.374584197998,-2.95097208023071 47.3748626708984,-2.9526379108429 47.3773612976075,-2.95541596412659 47.3773612976075,-2.95569396018982 47.3759727478028,-2.95680403709412 47.3759727478028,-2.95736098289484 47.3784713745117,-2.95513796806335 47.3804168701172,-2.9598610401153 47.3840293884278,-2.96291708946222 47.3829154968261,-2.96430492401117 47.3840293884278,-2.96930503845215 47.3840293884278,-2.97652792930603 47.385971069336,-2.97819399833679 47.3873596191407,-2.97736191749573 47.389305114746,-2.9820818901062 47.3901405334474,-2.98269081115717 47.3920822143555,-2.98652696609497 47.3937492370607,-2.98902702331543 47.3943061828614,-2.99291706085205 47.3926391601563,-2.99513888359064 47.3937492370607,-2.99763989448547 47.3926391601563,-3.00097203254694 47.3945846557618,-2.99652695655823 47.3954162597656,-2.99402689933771 47.3945846557618,-2.99291706085205 47.3954162597656,-2.99180507659912 47.3968048095703,-2.99430489540094 47.3995819091798,-2.99263906478882 47.4001388549806,-2.99513888359064 47.4012489318848,-2.99513888359064 47.4020843505859,-2.990972995758 47.4023628234863)),((-2.99680590629578 47.3995819091798,-2.99513888359064 47.3990287780762,-2.99513888359064 47.3979148864747,-2.9998619556427 47.3984718322754,-2.99680590629578 47.3995819091798)),((-2.94458389282221 47.3706932067872,-2.94569396972656 47.3679161071778,-2.94680595397944 47.3679161071778,-2.94708395004267 47.3693046569825,-2.94458389282221 47.3706932067872)),((-2.97041797637939 47.3584709167482,-2.96847105026245 47.3573608398438,-2.96847105026245 47.3551406860353,-2.97097110748291 47.3551406860353,-2.97375011444086 47.356803894043,-2.97291803359985 47.3579177856446,-2.97041797637939 47.3584709167482)),((-2.96569490432739 47.3562507629395,-2.96513891220081 47.3529167175294,-2.96763896942133 47.3537483215332,-2.96569490432739 47.3562507629395)))0.0006POINT(-2.968234642916615 47.36034405311122)
68093POLYGON((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.0006POINT(6.713849084717928 49.6864656720843)
58483POLYGON((7.69141578674322 50.7259941101075,7.69247627258295 50.7253456115722,7.69059371948254 50.723388671875,7.68310928344732 50.7202529907228,7.6816143989563 50.7172927856445,7.6816143989563 50.7172927856445,7.67799615859991 50.7166175842285,7.67799615859991 50.7166175842285,7.67530202865606 50.7163734436036,7.67555952072144 50.7182083129883,7.67275238037121 50.7181930541992,7.67378425598139 50.7198829650879,7.67117595672607 50.7198638916017,7.67393875122076 50.7318534851074,7.67393875122076 50.7318534851074,7.67683792114269 50.7324752807618,7.67076492309565 50.7355308532715,7.67076492309565 50.7355308532715,7.67992973327648 50.7357826232911,7.67992973327648 50.7357826232911,7.68659162521357 50.7314224243164,7.69141578674322 50.7259941101075))0.0006POINT(7.6789565086365075 50.72502644856774)
70111MULTIPOLYGON(((9.50435543060314 53.7194976806641,9.51673412322998 53.7335166931153,9.51737499237066 53.7332954406738,9.52151870727539 53.7391052246094,9.52436065673834 53.7387428283693,9.5251207351684 53.7399711608887,9.52416515350342 53.7420539855957,9.52690315246593 53.7429656982422,9.52814102172846 53.7445411682129,9.53805732727051 53.7416343688964,9.55091571807861 53.7611999511719,9.55091571807861 53.7611999511719,9.55610847473156 53.7607879638673,9.55610847473156 53.7607879638673,9.56052398681641 53.7579841613771,9.5610923767091 53.7566184997559,9.56526279449457 53.7550849914551,9.56418800354004 53.75146484375,9.56418800354004 53.75146484375,9.56490230560303 53.7499618530273,9.5665044784547 53.7501716613771,9.57383155822765 53.7378005981446,9.57354831695562 53.7354621887208,9.57773303985607 53.7282066345215,9.58085727691662 53.7273483276368,9.58341979980469 53.7221908569337,9.58341979980469 53.7221908569337,9.57680320739757 53.7205963134766,9.57262229919445 53.7177352905273,9.56969833374035 53.7177124023438,9.56969833374035 53.7177124023438,9.56635093688959 53.7177238464356,9.56404972076422 53.7162513732911,9.55617809295654 53.7146186828614,9.54716491699219 53.7146492004395,9.54362010955811 53.7167625427247,9.53226184844976 53.7173385620117,9.51763916015631 53.7138595581056,9.51763916015631 53.7138595581056,9.50435543060314 53.7194976806641)),((9.50044822692877 53.7105178833008,9.49614810943609 53.7096862792968,9.49614810943609 53.7096862792968,9.49566841125483 53.7106056213379,9.49662399292004 53.7111816406251,9.50044822692877 53.7105178833008)))0.0006POINT(9.551032178526572 53.73493269897586)
62928POLYGON((13.879267692566 53.5041389465333,13.878357887268 53.5025100708009,13.878357887268 53.5025100708009,13.8839015960694 53.5010261535645,13.8839015960694 53.5010261535645,13.8936071395874 53.4985542297364,13.8939523696901 53.5137214660645,13.9152784347534 53.5081138610841,13.9363231658936 53.5055313110352,13.9363231658936 53.5055313110352,13.9415302276611 53.5132293701171,13.9435844421387 53.5234184265138,13.9486532211305 53.5329551696778,13.9494705200195 53.536434173584,13.9488391876221 53.5381965637208,13.9488391876221 53.5381965637208,13.9448652267457 53.5473747253419,13.942406654358 53.5595169067384,13.9374637603761 53.5598678588868,13.9355993270874 53.5590209960938,13.9287595748901 53.5621528625488,13.9249773025514 53.5611267089844,13.9188747406007 53.5617942810059,13.9167737960815 53.5613822937011,13.9170236587526 53.5600776672363,13.9103536605834 53.5597953796387,13.9091577529908 53.5587921142579,13.9064769744874 53.5616188049316,13.9039936065674 53.5615425109864,13.9038028717041 53.5558013916016,13.9003810882569 53.5553092956543,13.89586353302 53.5564155578614,13.8957548141479 53.5540962219239,13.8938999176025 53.5517921447755,13.8939123153688 53.5503959655762,13.8825864791871 53.5420265197754,13.8976736068726 53.5330123901368,13.8928098678589 53.5268249511719,13.886833190918 53.5137748718262,13.879267692566 53.5041389465333))0.0006POINT(13.912831575442619 53.53688734005662)
64092POLYGON((12.8634881973267 52.4592170715333,12.8637819290161 52.4600486755372,12.866328239441 52.4597167968751,12.8696489334106 52.4559364318848,12.8774785995485 52.4533271789551,12.880394935608 52.4544372558595,12.8848733901978 52.4541778564454,12.8915424346924 52.4502563476562,12.8951988220214 52.4542083740236,12.8949575424195 52.4582328796387,12.8935308456422 52.4607620239258,12.8935308456422 52.4607620239258,12.9259500503541 52.4577217102051,12.944528579712 52.4521064758301,12.942660331726 52.4502639770507,12.9428863525391 52.4487304687499,12.9487581253053 52.442440032959,12.9461593627931 52.4406852722168,12.947533607483 52.4394226074219,12.9459686279298 52.4331283569336,12.9405117034912 52.4329414367677,12.9350576400757 52.4252166748048,12.935724258423 52.4214859008789,12.9340314865113 52.4176712036133,12.9368429183959 52.4157180786134,12.9364938735963 52.4135131835938,12.9380388259888 52.4110832214355,12.9376907348633 52.4081802368165,12.9343299865723 52.4066162109375,12.9353275299073 52.4053382873535,12.934310913086 52.398509979248,12.9353017807008 52.3911514282227,12.9353017807008 52.3911514282227,12.9379396438598 52.3905220031738,12.9404945373536 52.3857765197754,12.9448699951171 52.3850212097169,12.9498004913331 52.3825187683105,12.9497261047364 52.3775825500489,12.9505405426026 52.3757781982422,12.9475345611573 52.3719825744629,12.9501323699952 52.3643341064454,12.9548702239991 52.3610000610351,12.9582748413086 52.3610382080078,12.9601125717163 52.3587265014648,12.9629774093628 52.3584899902345,12.9672803878784 52.3537559509278,12.9697132110595 52.3483734130861,12.9606456756593 52.3446426391602,12.959457397461 52.3413963317872,12.9549589157105 52.3366050720215,12.9536113739013 52.3311347961427,12.948489189148 52.3266334533691,12.942542076111 52.3233718872071,12.9301376342775 52.3298873901368,12.9242601394653 52.3292961120605,12.9148302078248 52.3262748718262,12.9112710952759 52.3289108276368,12.9103269577027 52.3414649963379,12.8970584869384 52.3408660888672,12.8961219787599 52.3398323059083,12.8814764022828 52.338665008545,12.8824033737183 52.3330268859864,12.8818292617798 52.331729888916,12.8570718765259 52.3331718444825,12.8566732406617 52.3299331665039,12.8598852157593 52.3292846679689,12.8658323287964 52.3236694335938,12.8553361892701 52.3245964050294,12.8561925888062 52.3221588134766,12.8555049896241 52.3168640136719,12.8522090911866 52.3113937377931,12.8522729873657 52.3083953857422,12.8553800582886 52.3088645935059,12.8554496765137 52.3079376220704,12.852396965027 52.3073959350585,12.8522558212281 52.303295135498,12.8522558212281 52.303295135498,12.8522653579712 52.2990150451661,12.8225078582764 52.3011131286622,12.8225078582764 52.3011131286622,12.8190021514894 52.3034477233888,12.8182077407838 52.3082504272462,12.8206996917725 52.3101882934571,12.8227214813234 52.315227508545,12.8249988555908 52.3175392150879,12.827844619751 52.323169708252,12.8227310180665 52.3356971740724,12.8237476348878 52.3430824279786,12.8207006454468 52.3586540222168,12.8204441070557 52.3633651733399,12.8242778778076 52.3758354187012,12.8044633865356 52.3787803649903,12.8044633865356 52.3787803649903,12.8044261932374 52.3835029602051,12.803204536438 52.3837814331055,12.8116464614868 52.3981475830079,12.8125123977662 52.4072189331055,12.8091850280762 52.4128036499024,12.8140525817872 52.4120674133301,12.8152475357056 52.4133529663087,12.8275232315064 52.4115715026856,12.8468799591064 52.4059982299806,12.8554182052613 52.4044952392578,12.8566436767579 52.4085121154786,12.8538064956666 52.4096755981445,12.8528175354005 52.4118423461915,12.8536176681519 52.4145126342774,12.8576374053955 52.4165115356445,12.8554086685182 52.418083190918,12.8550901412965 52.4249114990234,12.8487825393677 52.4261779785157,12.851734161377 52.4277191162111,12.848279953003 52.4376640319825,12.8491716384888 52.4412040710449,12.8484859466554 52.445182800293,12.8505392074586 52.4482154846193,12.8583889007569 52.4499130249023,12.8639707565308 52.4535560607911,12.8638858795166 52.4575347900391,12.8658456802369 52.4582710266114,12.8634881973267 52.4592170715333))0.0006POINT(12.885386276245153 52.38357283274333)
36925POLYGON((5.54059457778942 46.6598205566407,5.55191564559942 46.6565322875977,5.55191564559942 46.6565322875977,5.55214881896978 46.6628875732422,5.5663676261903 46.6638832092285,5.57012414932251 46.6691589355469,5.57012414932251 46.6691589355469,5.57846498489391 46.6731185913086,5.58234739303589 46.6865081787109,5.58234739303589 46.6865081787109,5.57731962203991 46.6856651306153,5.57731962203991 46.6856651306153,5.56934213638311 46.6847381591797,5.56300973892218 46.6881408691407,5.56300973892218 46.6881408691407,5.55748462677002 46.6917419433595,5.55279016494751 46.6865653991699,5.54441833496094 46.6844711303712,5.54441833496094 46.6844711303712,5.5463891029359 46.6812744140626,5.5343017578125 46.6702194213868,5.53446722030651 46.6667480468751,5.53446722030651 46.6667480468751,5.54059457778942 46.6598205566407))0.0006POINT(5.558482087176833 46.676030366317136)
61233POLYGON((7.79914093017584 46.2407073974609,7.7972497940064 46.2375984191895,7.8012809753418 46.2337532043457,7.8012809753418 46.2337532043457,7.81170511245728 46.227867126465,7.81976890563976 46.2271385192872,7.8228549957276 46.2241020202637,7.83368682861334 46.2269897460938,7.84369611740118 46.2200508117676,7.84850597381586 46.2150993347168,7.84850597381586 46.2150993347168,7.85395812988293 46.218044281006,7.85395812988293 46.218044281006,7.8603458404541 46.2218856811524,7.86021280288702 46.2245101928711,7.86107397079462 46.2257041931153,7.86897182464611 46.2301712036134,7.87267208099365 46.23637008667,7.87137985229504 46.2402305603027,7.87118816375744 46.2480468750001,7.86900806427002 46.2542991638185,7.86900806427002 46.2542991638185,7.86401700973522 46.2607803344727,7.85909795761114 46.2646446228027,7.8573780059815 46.2672424316406,7.85465097427368 46.2682075500489,7.85465097427368 46.2682075500489,7.85434913635265 46.2658691406249,7.85269021987909 46.2643928527833,7.8443222045899 46.2599334716798,7.83401012420649 46.2560195922852,7.81805276870728 46.2439231872559,7.80638885498053 46.2446937561036,7.79914093017584 46.2407073974609))0.0006POINT(7.843607931426114 46.24053573608403)
52047POLYGON((-0.897360980510712 45.5285453796388,-0.892579615116006 45.5311241149902,-0.889053165912514 45.54248046875,-0.889053165912514 45.54248046875,-0.879874765872955 45.5402107238771,-0.862294375896454 45.5460472106934,-0.846539914608002 45.5386695861818,-0.846539914608002 45.5386695861818,-0.851731538772526 45.5243911743165,-0.851731538772526 45.5243911743165,-0.85598003864277 45.5135536193848,-0.856737375259399 45.5137786865236,-0.858750998973733 45.5103912353516,-0.858750998973733 45.5103912353516,-0.862917006015721 45.5115280151367,-0.866527020931187 45.5145835876465,-0.868194997310582 45.5145835876465,-0.875415980815887 45.519027709961,-0.877637982368469 45.5193061828613,-0.87847197055811 45.5209732055665,-0.87708401679987 45.5220832824708,-0.87847197055811 45.5229148864746,-0.879306018352509 45.5251388549805,-0.882359981536865 45.5259704589845,-0.88763898611063 45.5293045043945,-0.892360985279083 45.5304183959961,-0.895694971084595 45.5276374816894,-0.897360980510712 45.5285453796388))0.0006POINT(-0.8725577879834616 45.52550351178211)
41003POLYGON((5.92804718017584 49.2292709350587,5.90124988555914 49.2185478210449,5.85437202453613 49.2119674682617,5.85437202453613 49.2119674682617,5.8483099937439 49.2126045227052,5.8483099937439 49.2126045227052,5.85547590255743 49.2274856567383,5.86448621749889 49.2304573059083,5.86693668365479 49.2367401123048,5.86693668365479 49.2367401123048,5.87819147109991 49.2456817626954,5.87819147109991 49.2456817626954,5.88817453384399 49.2480278015137,5.91374444961559 49.2448120117188,5.92197895050049 49.2402687072755,5.92197895050049 49.2402687072755,5.92721843719494 49.2386550903321,5.92721843719494 49.2386550903321,5.91961526870728 49.2317428588868,5.92804718017584 49.2292709350587))0.0006POINT(5.8876215031272885 49.23169366936942)