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
33760POLYGON((3.60246348381037 48.4198951721193,3.60260033607483 48.4318161010743,3.60260033607483 48.4318161010743,3.5900936126709 48.4461364746095,3.59063935279846 48.4525756835938,3.56755447387695 48.4576911926271,3.56755447387695 48.4576911926271,3.54247331619274 48.458553314209,3.54247331619274 48.458553314209,3.53321194648743 48.4482879638672,3.51364541053778 48.4401321411133,3.51364541053778 48.4401321411133,3.51267242431641 48.4263343811036,3.51267242431641 48.4263343811036,3.52197384834295 48.4183082580567,3.54203391075146 48.4212226867677,3.55247712135315 48.4091796875,3.55220270156866 48.402370452881,3.55220270156866 48.402370452881,3.55917000770569 48.4019355773926,3.55917000770569 48.4019355773926,3.57547807693493 48.4093246459962,3.58471035957336 48.4083595275879,3.58471035957336 48.4083595275879,3.60235333442688 48.4197158813477,3.60235333442688 48.4197158813477,3.60246348381037 48.4198951721193))0.0006POINT(3.560889849296009 48.42764414273782)
68817POLYGON((12.4764242172241 50.5225105285645,12.4713134765625 50.5188369750978,12.4713134765625 50.5188369750978,12.4661922454835 50.5138549804688,12.4661922454835 50.5138549804688,12.4716272354127 50.5132026672364,12.4718408584596 50.5065231323242,12.4637928009034 50.5040855407716,12.4605426788331 50.5053558349609,12.4586687088013 50.5047492980958,12.4577264785768 50.5024528503419,12.4677610397339 50.5001296997071,12.4682846069336 50.4991493225098,12.4617443084717 50.4993324279785,12.4603614807129 50.4972953796387,12.4649381637573 50.4953880310059,12.4645624160767 50.4945030212403,12.4674320220948 50.4922790527344,12.4719781875611 50.4906616210938,12.4738683700562 50.4879722595215,12.4787063598634 50.4859352111818,12.4860801696777 50.488166809082,12.492943763733 50.4929809570312,12.4952793121338 50.4885025024415,12.494589805603 50.4855537414552,12.4953107833863 50.4839324951173,12.4921998977661 50.4794502258302,12.4950199127197 50.4784355163575,12.493658065796 50.46928024292,12.493658065796 50.46928024292,12.4956369400025 50.4673919677734,12.4956369400025 50.4673919677734,12.5012645721436 50.4687423706055,12.5036954879761 50.4658813476562,12.5076475143433 50.4653091430664,12.5098447799684 50.466911315918,12.5092639923097 50.4691352844239,12.5142774581909 50.4699745178223,12.5157146453857 50.4732055664063,12.5219383239746 50.4720001220703,12.5242586135864 50.4734611511231,12.5157957077026 50.4750938415528,12.5112447738648 50.477840423584,12.5127840042114 50.4795227050782,12.5230388641358 50.4818191528321,12.5224304199219 50.4827575683594,12.5271635055543 50.4816093444824,12.5300741195679 50.4787864685059,12.5322875976564 50.4781074523927,12.5354413986205 50.4795913696288,12.5366849899293 50.4816055297852,12.5419054031373 50.4812965393067,12.5446615219117 50.4820594787598,12.5476140975952 50.4847412109374,12.549409866333 50.4883804321289,12.5495433807374 50.4911231994628,12.5481557846069 50.4929504394531,12.5520477294922 50.4948348999025,12.5566444396972 50.5018272399902,12.5589628219604 50.5012626647949,12.5678672790528 50.5038146972656,12.5726051330568 50.5037193298339,12.572283744812 50.5057144165038,12.5685338973998 50.5070877075195,12.5677795410157 50.5095024108887,12.5734872817994 50.5112190246582,12.5705900192261 50.5124130249023,12.5758972167969 50.5133628845215,12.5765552520753 50.5145111083984,12.5849266052246 50.5154685974122,12.5835676193237 50.5169677734374,12.5849266052246 50.5205345153809,12.5879421234132 50.5220031738282,12.5876741409302 50.5242233276367,12.5876741409302 50.5242233276367,12.5731544494629 50.5273017883301,12.5550050735474 50.5230255126954,12.550940513611 50.51469039917,12.5483140945435 50.5188598632814,12.5432224273683 50.5186653137208,12.5434827804565 50.5168495178224,12.5412263870239 50.516269683838,12.5394515991212 50.5163459777832,12.5400047302247 50.5173873901367,12.5390920639039 50.5181427001953,12.5377349853516 50.5161666870118,12.5342721939087 50.5154190063478,12.5315589904786 50.5199050903321,12.5278177261353 50.5199165344239,12.5272607803345 50.5207557678223,12.5258016586303 50.520637512207,12.5267143249512 50.5195312500001,12.5214595794678 50.5178337097167,12.5241403579711 50.5161666870118,12.5239229202271 50.5153846740723,12.5198860168457 50.5170211791992,12.519630432129 50.5179824829102,12.5151433944702 50.5186805725098,12.5131673812867 50.5164031982421,12.5071382522583 50.5157051086427,12.5076837539674 50.5139503479004,12.506483078003 50.5135917663575,12.4906320571899 50.5116348266601,12.4891605377198 50.5165405273439,12.4764242172241 50.5225105285645))0.0006POINT(12.519566288361215 50.49992920802192)
43237POLYGON((6.90034484863281 48.0963821411133,6.92753267288219 48.096290588379,6.93200778961182 48.0975112915039,6.9306373596192 48.1038551330568,6.9306373596192 48.1038551330568,6.92785215377813 48.1067390441896,6.93132972717291 48.1167793273926,6.94329357147211 48.1357383728027,6.95552110672008 48.1467819213868,6.95552110672008 48.1467819213868,6.91704368591303 48.1654548645021,6.91704368591303 48.1654548645021,6.90925168991083 48.1609840393066,6.90665292739862 48.1475181579591,6.89659357070934 48.1399955749512,6.89659357070934 48.1399955749512,6.90457153320318 48.1279296875001,6.90173387527477 48.1080932617188,6.8966789245606 48.1022987365723,6.8966789245606 48.1022987365723,6.90034484863281 48.0963821411133))0.0006POINT(6.918876004219095 48.125536918640194)
53563MULTIPOLYGON(((4.83813905715942 43.4625701904297,4.82933473587036 43.4599990844727,4.82975625991821 43.4565544128419,4.84164476394653 43.4509086608886,4.84074544906616 43.4475135803223,4.81873130798351 43.4251174926758,4.81641483306885 43.4186134338379,4.83812904357904 43.405418395996,4.83812904357904 43.405418395996,4.83680486679077 43.4051399230956,4.83569478988659 43.4034729003907,4.8365268707276 43.4018058776856,4.83597278594971 43.3979148864746,4.8379168510437 43.3962516784669,4.83902692794805 43.3934707641602,4.84208297729498 43.3959732055665,4.84708404541016 43.3920822143555,4.84902811050415 43.3920822143555,4.85208415985107 43.3940277099609,4.85347223281872 43.3912506103517,4.85485982894897 43.3912506103517,4.85430622100836 43.3890266418458,4.86847114562988 43.3904151916505,4.87236213684088 43.3898620605469,4.85375022888189 43.3881950378418,4.84930610656744 43.3840293884277,4.84847211837769 43.3810119628906,4.84680604934704 43.3820838928223,4.8445839881897 43.3812484741211,4.84486198425304 43.3804168701173,4.85069417953497 43.3790283203126,4.85097217559809 43.3779182434082,4.8445839881897 43.3784713745118,4.84208297729498 43.3768043518067,4.8365268707276 43.3765258789063,4.83319520950317 43.3751373291016,4.83819484710705 43.3756942749023,4.83930492401123 43.3748626708986,4.84263896942144 43.3759727478027,4.84569311141979 43.3731956481934,4.8498620986939 43.3731956481934,4.85097217559809 43.3762512207031,4.8518061637879 43.3762512207031,4.85485982894897 43.3712501525879,4.8579158782959 43.3701400756835,4.85875082016003 43.3670845031739,4.85986089706415 43.3673629760743,4.8601388931275 43.3704147338868,4.86236095428478 43.3693046569824,4.86430501937878 43.3656959533691,4.86597108840942 43.3665275573731,4.86486101150524 43.3684730529786,4.86513900756842 43.3698616027832,4.86791706085216 43.3684730529786,4.87041807174688 43.3643074035646,4.872640132904 43.3631935119629,4.8740282058717 43.358196258545,4.87597179412842 43.3565292358399,4.87680578231823 43.3565292358399,4.87680578231823 43.358470916748,4.87514019012463 43.360694885254,4.87819385528576 43.3601379394532,4.8801379203797 43.358470916748,4.87985992431641 43.3573608398437,4.88291597366327 43.3556938171388,4.88486003875744 43.3562507629396,4.88541698455822 43.3576393127441,4.88263797760015 43.3615264892579,4.88291597366327 43.364028930664,4.88486003875744 43.3645820617676,4.88541698455822 43.3631935119629,4.88875102996826 43.3631935119629,4.88958311080933 43.3601379394532,4.89041709899908 43.3601379394532,4.89263916015625 43.3615264892579,4.89152717590326 43.3634719848633,4.89624881744396 43.3643074035646,4.9018058776856 43.3681945800782,4.9018058776856 43.3704147338868,4.90513801574707 43.3712501525879,4.90541601181042 43.3726387023926,4.90958404541027 43.3745841979982,4.9109721183778 43.3776397705078,4.91208219528198 43.3779182434082,4.91069412231445 43.3734741210938,4.88458204269415 43.3545837402344,4.8770837783814 43.3515281677247,4.8770837783814 43.3515281677247,4.87541580200195 43.3520851135255,4.8756937980653 43.3545837402344,4.87041807174688 43.3556938171388,4.8673610687257 43.3548622131348,4.86458301544189 43.3565292358399,4.86125087738043 43.3556938171388,4.86097288131714 43.3531951904297,4.86236095428478 43.3529167175293,4.86236095428478 43.3518066406251,4.86430501937878 43.3504180908204,4.87013912200928 43.3509712219238,4.87097120285028 43.3526382446289,4.87319421768188 43.3526382446289,4.87597179412842 43.3506927490234,4.87541580200195 43.3498611450196,4.87013912200928 43.3490295410156,4.86958312988281 43.3470840454102,4.86680507659923 43.3456954956056,4.86486101150524 43.3426399230957,4.86125087738043 43.3406944274902,4.85624980926525 43.3348617553711,4.85458421707148 43.3343048095703,4.8498620986939 43.3343048095703,4.85263776779186 43.3348617553711,4.85291576385504 43.3362503051758,4.84764003753662 43.3362503051758,4.84541511535645 43.3373603820801,4.84291696548462 43.3418045043946,4.83763885498058 43.3394165039064,4.83763885498058 43.3394165039064,4.83544778823864 43.3422660827637,4.83223533630377 43.3668670654298,4.75432157516491 43.4093894958496,4.73485231399548 43.4297256469727,4.74973535537714 43.4595069885254,4.76434135437017 43.4737396240234,4.77265930175776 43.4773902893068,4.80097198486334 43.4778251647949,4.815980911255 43.4698181152344,4.82461500167841 43.4728393554688,4.83813905715942 43.4625701904297)),((4.87375020980835 43.368751525879,4.87791585922241 43.3668060302735,4.8770837783814 43.3620834350587,4.87486219406134 43.3618049621583,4.87430620193487 43.3629150390625,4.87375020980835 43.368751525879)))0.0006POINT(4.856864482106527 43.376522005490436)
40965POLYGON((1.04555571079254 45.8092575073242,1.03612089157116 45.8072624206543,1.02981460094458 45.7980995178222,1.02148008346558 45.7945785522461,1.00183498859417 45.7951393127442,0.990630984306449 45.7884368896486,0.977232515811977 45.7914581298829,0.96688216924673 45.7840499877931,0.952402412891331 45.7821922302247,0.94010233879095 45.7764549255372,0.937021434307042 45.7820854187012,0.937021434307042 45.7820854187012,0.928634822368622 45.7829132080079,0.918108642101288 45.7773056030274,0.918108642101288 45.7773056030274,0.920348882675171 45.7742195129396,0.914320170879421 45.7647857666017,0.923407077789363 45.7527923583984,0.91551399230957 45.7406501770021,0.926221251487732 45.7340354919434,0.926221251487732 45.7340354919434,0.935554146766719 45.7393608093262,0.949592709541378 45.7319869995118,0.949592709541378 45.7319869995118,0.952000141143913 45.7333183288575,0.952000141143913 45.7333183288575,0.968639910221157 45.7404556274414,0.973079144954738 45.74955368042,0.989510953426361 45.7569541931152,0.998886108398494 45.7581825256349,1.01302671432506 45.7550201416016,1.01302671432506 45.7550201416016,1.03147828578955 45.7796096801758,1.03180062770844 45.7900733947755,1.04593455791473 45.7992820739746,1.04593455791473 45.7992820739746,1.04927062988293 45.8043670654297,1.04555571079254 45.8092575073242))0.0006POINT(0.9736841176007645 45.76991663752379)
22705POLYGON((-0.672367691993713 44.3479919433595,-0.644205749034882 44.353931427002,-0.627620458602905 44.347152709961,-0.622686862945557 44.3467826843263,-0.618392527103424 44.3485565185548,-0.611339390277806 44.3535461425782,-0.603270947933197 44.3664779663087,-0.600026667118073 44.3768959045411,-0.603107035160065 44.3909416198731,-0.603107035160065 44.3909416198731,-0.641469299793243 44.4002304077149,-0.641469299793243 44.4002304077149,-0.642391681671143 44.4001083374023,-0.642391681671143 44.4001083374023,-0.65863794088358 44.3782501220704,-0.672367691993713 44.3479919433595))0.0006POINT(-0.6288322846094693 44.37347640991218)
46803POLYGON((2.78907585144049 50.5830612182618,2.79206490516663 50.5862884521485,2.79206490516663 50.5862884521485,2.80843496322632 50.6077194213868,2.82857894897472 50.6188049316407,2.82857894897472 50.6188049316407,2.83138203620905 50.6200218200685,2.83138203620905 50.6200218200685,2.83378171920788 50.6110496520997,2.84805345535273 50.5929489135742,2.84805345535273 50.5929489135742,2.83878397941589 50.586151123047,2.82592368125916 50.5830993652345,2.82592368125916 50.5830993652345,2.80823469161987 50.5788536071778,2.80823469161987 50.5788536071778,2.78907585144049 50.5830612182618))0.0006POINT(2.821159496903432 50.596750974655244)
46099POLYGON((2.05320835113525 44.0651092529297,2.04509377479565 44.0614204406739,2.03760051727295 44.0527839660645,2.03760051727295 44.0527839660645,2.02968740463257 44.0535621643067,2.02965211868298 44.0475654602051,2.02577853202831 44.0464057922363,2.02577853202831 44.0464057922363,2.04645419120789 44.0271453857422,2.04645419120789 44.0271453857422,2.0561597347259 44.0211105346679,2.0561597347259 44.0211105346679,2.06769561767578 44.0227584838868,2.06769561767578 44.0227584838868,2.07282590866089 44.027904510498,2.07326412200933 44.0446777343751,2.07326412200933 44.0446777343751,2.07299304008495 44.0513534545899,2.05320835113525 44.0651092529297))0.0006POINT(2.0509647793240338 44.040926615397176)
65116POLYGON((10.1605796813966 47.4539031982423,10.1660833358765 47.4569664001465,10.1773672103882 47.4594345092775,10.1781196594239 47.4619255065918,10.1807041168213 47.4637756347657,10.1850013732911 47.4630432128907,10.2000017166138 47.4647293090821,10.2012023925781 47.4656219482422,10.2016420364381 47.469566345215,10.1985397338867 47.4699554443361,10.1957416534424 47.4789237976075,10.1957416534424 47.4789237976075,10.2071380615234 47.4790687561035,10.2116498947144 47.4781494140626,10.2170209884645 47.4797439575195,10.2255058288574 47.4792098999024,10.2287483215332 47.4801521301271,10.2369108200073 47.4803314208984,10.2380399703979 47.4799232482911,10.2381124496461 47.478729248047,10.2391986846924 47.4787673950195,10.2396812438965 47.4802780151367,10.2415914535522 47.4799842834474,10.2445735931398 47.4851684570313,10.2443151474 47.4863090515137,10.2461442947388 47.486312866211,10.2469673156739 47.4835815429688,10.2488746643067 47.483856201172,10.2491874694824 47.484790802002,10.2524747848511 47.4848365783692,10.252908706665 47.480182647705,10.2557210922241 47.479549407959,10.2587680816652 47.4771308898925,10.2587680816652 47.4771308898925,10.2578382492067 47.474838256836,10.2588977813721 47.4720993041992,10.2555103302003 47.4685249328614,10.2540149688722 47.4681701660157,10.2552022933961 47.4664573669433,10.2514829635621 47.4630355834962,10.2490472793579 47.4627418518067,10.2481527328492 47.4639358520508,10.2453174591064 47.4613418579103,10.2459516525269 47.456527709961,10.2474889755248 47.4563789367676,10.2447662353516 47.4551582336427,10.2447662353516 47.4551582336427,10.2392120361329 47.4509048461913,10.2341842651367 47.4498062133789,10.2305974960328 47.4469757080079,10.2293500900269 47.4474487304689,10.2266845703126 47.445571899414,10.2164955139161 47.4439926147462,10.2114868164062 47.4444541931153,10.2090435028077 47.4432525634767,10.1971244812012 47.4432487487793,10.1979618072509 47.442756652832,10.1945219039918 47.4422721862793,10.1915254592897 47.4406166076661,10.1904630661011 47.4389610290528,10.1855106353761 47.4390029907227,10.1804513931274 47.4370460510255,10.1756076812745 47.4366455078125,10.1757764816285 47.4411468505861,10.1736974716187 47.4452552795411,10.1759214401245 47.4495315551759,10.1699771881104 47.4510574340821,10.1589155197144 47.451328277588,10.1589155197144 47.451328277588,10.1605796813966 47.4539031982423))0.0006POINT(10.218911405922753 47.46343374943391)
39089POLYGON((2.74077177047729 43.2645797729493,2.75252056121826 43.2545928955078,2.75252056121826 43.2545928955078,2.76116633415228 43.2441520690917,2.75956654548651 43.2412414550781,2.75956654548651 43.2412414550781,2.747718334198 43.2326164245606,2.7330100536347 43.2261848449708,2.72894501686102 43.2274093627931,2.72894501686102 43.2274093627931,2.72716760635387 43.233871459961,2.71168732643127 43.239543914795,2.69824552536011 43.2407379150391,2.69824552536011 43.2407379150391,2.694011926651 43.2409248352051,2.68668007850658 43.2519836425782,2.68668007850658 43.2519836425782,2.69095015525829 43.2543182373048,2.69095015525829 43.2543182373048,2.71173357963573 43.2598724365236,2.71173357963573 43.2598724365236,2.74077177047729 43.2645797729493))0.0006POINT(2.7225150607881625 43.244865962437274)