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
1402714POLYGON((-5.72802591323847 41.3913269042969,-5.72838783264154 41.3945159912109,-5.71351480484009 41.4219245910645,-5.70673179626465 41.4248657226563,-5.70480394363398 41.4239845275879,-5.69656705856318 41.4290504455567,-5.6890230178833 41.4199142456055,-5.67510223388672 41.4081344604493,-5.67308998107904 41.4083518981934,-5.67234420776367 41.4053611755372,-5.67678880691517 41.403465270996,-5.69232320785517 41.4036712646484,-5.70980215072626 41.4017372131348,-5.71778106689447 41.3959999084473,-5.72802591323847 41.3913269042969))0.0006POINT(-5.698877573013265 41.40945025852751)
51898POLYGON((-1.2343070507049 45.9674263000489,-1.23545551300049 45.9687995910644,-1.25183045864105 45.9604644775392,-1.26393592357624 45.9661674499512,-1.28652739524836 45.9585227966309,-1.32141578197474 45.9620018005371,-1.354549050331 45.9546813964844,-1.37597298622131 45.9456787109375,-1.37597298622131 45.9456787109375,-1.37708294391632 45.9462509155273,-1.37958300113667 45.9454154968262,-1.37847304344177 45.9476394653321,-1.37902700901026 45.9484710693361,-1.38097095489496 45.9484710693361,-1.38374996185303 45.9468040466309,-1.38541805744171 45.9473609924317,-1.38236200809473 45.9495849609376,-1.38569402694702 45.9506950378418,-1.38874995708466 45.954029083252,-1.38874995708466 45.9554176330568,-1.38791596889496 45.9556961059571,-1.38847196102142 45.95902633667,-1.38652801513672 45.9606933593749,-1.38680601119995 45.9643058776856,-1.38909578323364 45.9676399230958,-1.38986194133753 45.9662513732911,-1.39152801036835 45.9668045043945,-1.39125001430511 45.9681930541992,-1.39291596412659 45.9698600769044,-1.39125001430511 45.9706954956055,-1.39125001430511 45.9731941223144,-1.39430594444275 45.9745826721191,-1.39708197116852 45.977638244629,-1.39569401741028 45.977638244629,-1.39374995231628 45.9809722900391,-1.39513802528381 45.983196258545,-1.39235997200012 45.9829177856446,-1.39097201824188 45.9851379394531,-1.39097201824188 45.9870834350586,-1.38930594921106 45.9879150390626,-1.38736200332642 45.9964332580568,-1.38736200332642 45.9964332580568,-1.38709425926208 45.9971656799318,-1.36734044551849 46.0032653808594,-1.36734044551849 46.0032653808594,-1.3639349937439 45.9970474243165,-1.3551744222641 45.999496459961,-1.33832907676691 45.9942893981934,-1.32306778430939 46.0022773742676,-1.32409977912903 46.0029335021974,-1.32334196567535 46.0034713745117,-1.32334196567535 46.0034713745117,-1.32236099243158 46.002082824707,-1.31986105442047 46.0018043518066,-1.31986105442047 46.0006942749025,-1.32152700424194 45.9993057250977,-1.3201390504837 45.996250152588,-1.31736099719996 45.9954147338867,-1.31569504737848 45.9937515258789,-1.30152702331537 45.9893074035645,-1.28847301006317 45.9884719848633,-1.2879159450531 45.987361907959,-1.27986204624176 45.987361907959,-1.25930595397944 45.9906959533693,-1.24569499492645 45.9901390075685,-1.24208295345306 45.9876403808594,-1.23902904987335 45.9870834350586,-1.2345819473266 45.9829177856446,-1.2343070507049 45.9798622131347,-1.23652899265284 45.9756927490235,-1.2362509965896 45.9737510681153,-1.23736095428467 45.9731941223144,-1.23513805866236 45.9718055725099,-1.23374998569489 45.9690284729004,-1.2343070507049 45.9674263000489))0.0006POINT(-1.3380092559633832 45.976380683280354)
1400498POLYGON((-5.76865386962891 40.5723495483399,-5.77170801162714 40.5793609619141,-5.76923322677612 40.5946846008301,-5.7710719108581 40.5974235534669,-5.78732204437256 40.6014556884766,-5.7918758392334 40.6075325012208,-5.7960700988769 40.6100616455078,-5.79916191101069 40.6218299865723,-5.81291484832758 40.6323471069336,-5.81161308288574 40.6348953247071,-5.8048009872436 40.6384887695313,-5.80517005920404 40.6402740478516,-5.80151891708368 40.6414260864259,-5.80217790603632 40.6425094604493,-5.79231977462763 40.6448554992676,-5.78442478179932 40.6412353515626,-5.77842712402338 40.6419944763184,-5.76100683212275 40.639072418213,-5.73748207092285 40.6181030273438,-5.73874711990351 40.5764427185059,-5.74818515777588 40.5735359191895,-5.75879383087153 40.57474899292,-5.76229000091547 40.5718650817872,-5.76865386962891 40.5723495483399))0.0006POINT(-5.780650843744655 40.612890989884136)
49007POLYGON((0.379126042127609 48.2551078796388,0.384426951408386 48.2439079284668,0.384426951408386 48.2439079284668,0.403739184141159 48.2526969909668,0.403739184141159 48.2526969909668,0.411236315965709 48.2573165893556,0.411236315965709 48.2573165893556,0.405117630958671 48.2619361877442,0.391365796327648 48.2586631774903,0.387737274170036 48.2608795166016,0.387737274170036 48.2608795166016,0.379126042127609 48.2551078796388))0.0006POINT(0.3954444473440462 48.25502811778681)
22029POLYGON((-0.114876881241798 44.4180374145507,-0.112703986465874 44.4157829284669,-0.112703986465874 44.4157829284669,-0.115089133381844 44.4038619995118,-0.132021933793965 44.4001007080078,-0.132021933793965 44.4001007080078,-0.145207062363568 44.4033279418946,-0.156049475073814 44.3978729248047,-0.156049475073814 44.3978729248047,-0.1645190417766 44.400577545166,-0.166253492236137 44.407096862793,-0.178945779800301 44.4166946411132,-0.178945779800301 44.4166946411132,-0.17307856678957 44.4218978881836,-0.153047606348991 44.4127807617188,-0.149559319019261 44.418529510498,-0.155749410390854 44.4238128662109,-0.156184107065201 44.4306983947755,-0.156184107065201 44.4306983947755,-0.138724654912835 44.4262428283692,-0.128517955541554 44.4194526672364,-0.114876881241798 44.4180374145507))0.0006POINT(-0.14649684230482482 44.413234165736625)
22483POLYGON((-1.02691376209259 43.5040397644044,-1.02368104457855 43.5017089843751,-1.02368104457855 43.5017089843751,-1.01800131797785 43.5059661865234,-0.992383241653386 43.5040283203124,-0.992383241653386 43.5040283203124,-0.99377137422556 43.5090408325195,-0.99377137422556 43.5090408325195,-1.01907658576965 43.5174369812013,-1.03640544414515 43.5283241271974,-1.04185307025909 43.5337715148926,-1.0390487909317 43.5401992797852,-1.0390487909317 43.5401992797852,-1.04652833938599 43.5412445068359,-1.04652833938599 43.5412445068359,-1.05947422981257 43.5453300476074,-1.07651543617249 43.5390319824219,-1.09038531780243 43.5402412414551,-1.09038531780243 43.5402412414551,-1.07865226268768 43.535816192627,-1.07857131958008 43.5325851440431,-1.08800160884857 43.5262489318847,-1.08108425140375 43.5229949951172,-1.08108425140375 43.5229949951172,-1.07415020465845 43.5196723937989,-1.0689971446991 43.5084495544434,-1.0689971446991 43.5084495544434,-1.04607021808624 43.5115623474121,-1.03267872333527 43.5092926025391,-1.02691376209259 43.5040397644044))0.0006POINT(-1.0464870066478142 43.522237711939326)
47556POLYGON((2.69982147216803 50.4595413208009,2.68600654602062 50.4673156738282,2.68600654602062 50.4673156738282,2.69492626190186 50.4761085510254,2.69492626190186 50.4761085510254,2.70359992980968 50.4794044494629,2.70359992980968 50.4794044494629,2.70867300033569 50.4827575683594,2.70867300033569 50.4827575683594,2.7148203849793 50.4853019714356,2.7148203849793 50.4853019714356,2.7254586219787 50.479778289795,2.7299280166626 50.4805679321289,2.7299280166626 50.4805679321289,2.76628828048712 50.4664230346679,2.76628828048712 50.4664230346679,2.76368498802196 50.4577674865723,2.75611090660107 50.4538307189942,2.75611090660107 50.4538307189942,2.74542355537415 50.4597053527832,2.72740340232843 50.4557723999023,2.72740340232843 50.4557723999023,2.71464514732367 50.4616203308105,2.69982147216803 50.4595413208009))0.0006POINT(2.72280640187475 50.47014684262485)
64782POLYGON((12.7790441513062 48.3276863098145,12.7830600738525 48.3275451660156,12.7889995574951 48.3257217407227,12.788800239563 48.3243522644044,12.790491104126 48.3253250122071,12.7967576980592 48.3231964111328,12.8008747100831 48.3232650756837,12.8083457946778 48.3201179504395,12.8051156997681 48.3165016174318,12.8058452606201 48.3153686523438,12.8093700408937 48.3163414001466,12.80943775177 48.3126220703126,12.812219619751 48.3130073547364,12.8143577575684 48.316017150879,12.8170852661132 48.3163681030274,12.8202905654908 48.3142852783204,12.8229427337646 48.3153266906739,12.8229427337646 48.3153266906739,12.8244781494142 48.3189811706544,12.8239336013794 48.3200263977051,12.8319835662842 48.3199920654297,12.832896232605 48.3221511840821,12.830701828003 48.3225212097168,12.8312892913819 48.3241081237794,12.828411102295 48.3296737670898,12.8290252685547 48.3306770324706,12.8339834213258 48.3316688537598,12.8258771896363 48.3351249694824,12.8254833221436 48.3401794433594,12.8329219818115 48.3411293029786,12.832462310791 48.3391151428223,12.8350067138671 48.3364524841309,12.8395118713379 48.3370056152345,12.8420896530153 48.3361587524414,12.8438415527344 48.3338737487794,12.8426475524903 48.3300552368164,12.8464479446411 48.3299751281738,12.8457078933716 48.3339576721191,12.8486394882203 48.3346061706544,12.8496122360229 48.333522796631,12.8496122360229 48.333522796631,12.8518829345704 48.3338813781739,12.8542175292969 48.336986541748,12.8570098876953 48.3364143371582,12.8557004928589 48.3378105163575,12.8592519760132 48.3361968994141,12.8613033294678 48.3373298645021,12.8592910766602 48.3384094238281,12.8606882095337 48.338550567627,12.8611297607423 48.3421211242675,12.8647918701172 48.3455848693848,12.8641290664673 48.3514289855958,12.8627185821533 48.3540954589844,12.8651170730591 48.3559684753419,12.8705177307129 48.3551712036134,12.8708763122559 48.3578338623048,12.8699617385865 48.3601379394531,12.8765811920167 48.3599700927734,12.8759088516235 48.3647422790528,12.8717412948609 48.3703994750978,12.8691120147706 48.3782920837403,12.8672103881837 48.3808517456055,12.8687753677369 48.38920211792,12.8653106689454 48.38960647583,12.8653106689454 48.38960647583,12.8597602844238 48.3904571533204,12.8563404083253 48.3876037597656,12.8576202392579 48.3861312866211,12.8566513061524 48.3845214843751,12.8554115295411 48.3842964172363,12.8547019958497 48.3872261047364,12.8508739471436 48.3873901367189,12.8490428924562 48.3872108459473,12.8498229980469 48.3851890563966,12.8483800888062 48.385238647461,12.846962928772 48.3866539001465,12.8403053283691 48.3847007751465,12.8381042480469 48.3835601806642,12.8364276885986 48.3792762756349,12.8302402496339 48.3783645629883,12.8289804458618 48.3811264038085,12.8252325057985 48.3803939819336,12.82474899292 48.3812942504884,12.8207225799561 48.3784103393556,12.8201656341553 48.3791885375978,12.808801651001 48.3793106079102,12.8079566955567 48.380298614502,12.8055381774902 48.3796920776368,12.7989091873169 48.3843116760254,12.8004531860353 48.3852767944337,12.7966508865356 48.3859748840333,12.7966508865356 48.3859748840333,12.7945423126221 48.3827629089355,12.7936878204346 48.3829689025879,12.7923259735108 48.3812789916993,12.7864780426025 48.3832893371583,12.7855958938599 48.3823280334474,12.7835178375245 48.3823699951172,12.7795448303223 48.37504196167,12.7808904647827 48.3723335266114,12.778920173645 48.372356414795,12.7789497375489 48.3715362548829,12.776403427124 48.3699073791505,12.7702188491821 48.3710517883302,12.76881980896 48.3723297119142,12.7702474594117 48.3734169006348,12.7620182037353 48.3753051757813,12.7547330856324 48.3754348754883,12.7408266067505 48.3792877197266,12.7407312393189 48.3780860900879,12.7376356124878 48.3768157958985,12.7376356124878 48.3768157958985,12.7455530166627 48.3651504516602,12.7376155853272 48.3627853393556,12.7420959472657 48.3598251342773,12.7408895492554 48.3596954345704,12.7422294616699 48.3580245971681,12.7470588684082 48.3606147766113,12.7474508285522 48.3594551086427,12.7459335327148 48.3584442138672,12.7509679794312 48.3546142578124,12.7516622543335 48.3526954650879,12.7562322616577 48.3537712097168,12.7612257003785 48.3528785705567,12.7600984573365 48.3501014709474,12.7588300704956 48.350399017334,12.7618379592897 48.345100402832,12.7642183303833 48.3437652587891,12.7633228302003 48.3421821594238,12.7660074234009 48.3407173156739,12.766450881958 48.3386459350586,12.772297859192 48.3346786499024,12.7758693695068 48.3299446105957,12.7790441513062 48.3276863098145))0.0006POINT(12.813444445904064 48.354667118617485)
64227POLYGON((14.4449596405029 52.5175247192383,14.4439992904664 52.5183258056642,14.4470119476319 52.520435333252,14.4439945220948 52.5225524902343,14.4524841308594 52.5258483886719,14.4510126113892 52.5320510864259,14.4487190246581 52.532772064209,14.4524993896484 52.536506652832,14.4500341415406 52.5414810180664,14.4500341415406 52.5414810180664,14.4432287216188 52.540382385254,14.4411954879761 52.5389709472656,14.4365110397339 52.5380363464357,14.4090185165406 52.5261611938478,14.4045467376709 52.5252952575685,14.3997430801392 52.522762298584,14.3964233398438 52.5187225341798,14.3930654525758 52.5168418884278,14.3825216293336 52.5133819580079,14.3719940185547 52.5124893188477,14.3621215820313 52.5144004821778,14.362512588501 52.5216712951661,14.3609914779664 52.5228729248048,14.3548221588136 52.5204887390138,14.3455982208253 52.5295181274415,14.3375005722046 52.5477218627929,14.3375005722046 52.5477218627929,14.336986541748 52.5511817932129,14.3269157409668 52.5560264587402,14.2992525100708 52.5543403625488,14.3020925521852 52.5585975646973,14.3011865615846 52.5602149963378,14.3011865615846 52.5602149963378,14.3006105422974 52.56160736084,14.2597837448121 52.5678024291992,14.2485885620117 52.557903289795,14.2456350326539 52.5535926818848,14.2393436431885 52.5474128723146,14.2411890029907 52.5446166992189,14.2411890029907 52.5446166992189,14.2537870407104 52.5300979614258,14.2497491836548 52.5290718078614,14.2513246536256 52.5208587646484,14.2562961578369 52.5202713012695,14.2538204193116 52.5164794921875,14.2587509155274 52.5138816833496,14.2551469802856 52.5111198425294,14.2512817382812 52.5056762695313,14.2466068267823 52.5016441345216,14.2466039657594 52.500057220459,14.2425842285157 52.4991340637208,14.243673324585 52.4972610473633,14.2303981781006 52.4942779541017,14.2290630340576 52.4966545104982,14.2203598022461 52.4929580688478,14.2203598022461 52.4929580688478,14.2293910980226 52.4903373718262,14.2378358840942 52.4813842773438,14.2450094223023 52.4782829284669,14.2498388290406 52.4718360900879,14.2498388290406 52.4718360900879,14.2617073059083 52.4764671325685,14.2626342773439 52.4754104614259,14.2611780166626 52.4734077453614,14.268458366394 52.4703903198243,14.2874546051027 52.4772491455079,14.2893314361573 52.4883956909181,14.2949476242067 52.4922599792482,14.3150939941407 52.4895858764648,14.3160457611084 52.4924468994141,14.3236713409424 52.4929542541504,14.326057434082 52.4948120117188,14.3240747451783 52.4964714050294,14.33038520813 52.4984931945801,14.3328504562378 52.4976387023927,14.3333969116212 52.4962730407716,14.3616790771484 52.4968338012695,14.3623075485229 52.4951324462891,14.3623075485229 52.4951324462891,14.374306678772 52.4961433410645,14.3883056640626 52.5030670166017,14.399697303772 52.5044975280763,14.4164609909057 52.514259338379,14.4187669754029 52.5187377929687,14.4274139404298 52.5217895507812,14.4282684326172 52.5211753845215,14.434666633606 52.5226898193361,14.4433479309083 52.5167770385743,14.4449596405029 52.5175247192383))0.0006POINT(14.331074324521193 52.5158990513195)
18030POLYGON((8.01552486419678 45.4076080322266,8.00995922088629 45.3988418579102,8.00995922088629 45.3988418579102,8.0041875839234 45.3949432373048,7.99846076965332 45.3930969238281,7.99524593353283 45.3930473327637,7.99474906921387 45.3938331604004,7.99607181549084 45.395565032959,7.99959993362432 45.3971405029297,7.99856185913092 45.3993148803712,7.99558210372919 45.399040222168,7.99302387237555 45.3968734741212,7.99302387237555 45.3968734741212,7.99143600463867 45.3981246948243,7.98135709762585 45.3985939025879,7.97892284393322 45.4005241394044,7.97484397888178 45.4093055725098,7.97438287734991 45.4132843017578,7.97438287734991 45.4132843017578,7.97769689559942 45.4182586669922,7.98612499237066 45.4196891784668,7.99688291549683 45.417652130127,8.01312637329113 45.4118309020997,8.01552486419678 45.4076080322266))0.0006POINT(7.993613346763326 45.40285077302356)