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
45913POLYGON((0.903111338615474 44.1900558471681,0.907852053642387 44.175163269043,0.907852053642387 44.175163269043,0.899514973163605 44.173267364502,0.901351809501762 44.1641807556153,0.901351809501762 44.1641807556153,0.889793753624076 44.1668853759766,0.889793753624076 44.1668853759766,0.890030682087058 44.1702728271484,0.882225215434971 44.1739501953125,0.870263338089103 44.1689910888672,0.863911569118557 44.1735687255859,0.863911569118557 44.1735687255859,0.85363215208065 44.1747817993165,0.85363215208065 44.1747817993165,0.853674948215485 44.1842460632325,0.859686553478298 44.1927375793457,0.859686553478298 44.1927375793457,0.860991477966422 44.1929779052734,0.860991477966422 44.1929779052734,0.903111338615474 44.1900558471681))0.0006POINT(0.8786629617214998 44.177068710327184)
50626POLYGON((2.76544380187988 49.3113708496094,2.77142786979681 49.3168411254884,2.77212786674505 49.3233337402345,2.75686621665966 49.3226814270019,2.75465035438538 49.3288154602051,2.75465035438538 49.3288154602051,2.84389138221752 49.3489646911622,2.84389138221752 49.3489646911622,2.84775829315191 49.3254280090333,2.84775829315191 49.3254280090333,2.83866000175487 49.3235397338867,2.82146692276001 49.3085021972656,2.82146692276001 49.3085021972656,2.82887530326855 49.317295074463,2.80910515785217 49.3202323913574,2.77394127845776 49.3080635070801,2.77394127845776 49.3080635070801,2.76544380187988 49.3113708496094))0.0006POINT(2.8015248635236567 49.32204953361965)
69985POLYGON((9.15158748626709 54.8179359436035,9.16755008697521 54.8277778625489,9.17267608642589 54.8288841247559,9.17346954345697 54.8303718566895,9.17346954345697 54.8303718566895,9.17970561981201 54.8337936401368,9.17970561981201 54.8337936401368,9.17992305755627 54.8272972106933,9.20589923858643 54.8104400634766,9.20589923858643 54.8104400634766,9.18255329132074 54.7986602783204,9.16908264160151 54.7873458862305,9.16908264160151 54.7873458862305,9.1655006408692 54.7876472473145,9.1655006408692 54.7876472473145,9.16235351562506 54.7879753112794,9.16336441040045 54.7904014587403,9.15592956542963 54.7902412414552,9.15584278106701 54.7920150756837,9.14880943298351 54.7953338623046,9.1538343429566 54.8039779663086,9.15572738647467 54.8108520507812,9.15607261657709 54.8176231384277,9.15158748626709 54.8179359436035))0.0006POINT(9.169284322987455 54.80818143098254)
38206POLYGON((1.42987370491034 49.7573890686035,1.40375685691833 49.7466163635254,1.38612377643585 49.7525215148926,1.3762618303299 49.7503395080566,1.3762618303299 49.7503395080566,1.35738933086395 49.7601432800294,1.34984767436976 49.7681579589844,1.34984767436976 49.7681579589844,1.3520872592926 49.7774543762207,1.36923837661737 49.7840118408203,1.36923837661737 49.7840118408203,1.37871944904339 49.7848281860352,1.38973724842077 49.7796096801758,1.39875972270971 49.7799873352051,1.39875972270971 49.7799873352051,1.41264772415173 49.771167755127,1.41264772415173 49.771167755127,1.42987370491034 49.7573890686035))0.0006POINT(1.3830116636613037 49.76858183916878)
45101POLYGON((0.35463926196104 42.8820266723634,0.360661119222755 42.8784790039062,0.360335320234242 42.8724594116212,0.360335320234242 42.8724594116212,0.35535320639616 42.8617935180665,0.35535320639616 42.8617935180665,0.347380399703979 42.864170074463,0.347380399703979 42.864170074463,0.345015525817928 42.8690757751465,0.345015525817928 42.8690757751465,0.34799703955656 42.8809280395508,0.34799703955656 42.8809280395508,0.35463926196104 42.8820266723634))0.0006POINT(0.35228861371679443 42.87144660949713)
45205POLYGON((0.616481184959468 43.0204200744628,0.607841610908622 43.0185012817383,0.592641949653625 43.0260353088379,0.592641949653625 43.0260353088379,0.593219518661556 43.0354499816896,0.593219518661556 43.0354499816896,0.608047306537685 43.034008026123,0.608047306537685 43.034008026123,0.615650832653046 43.02152633667,0.615650832653046 43.02152633667,0.616481184959468 43.0204200744628))0.0006POINT(0.6043442010879913 43.0272960662842)
32402POLYGON((1.79582071304327 47.2378196716309,1.81462013721477 47.2299919128418,1.81462013721477 47.2299919128418,1.83907926082622 47.2193069458009,1.83907926082622 47.2193069458009,1.83744382858276 47.1983680725098,1.84223711490631 47.1775817871093,1.84223711490631 47.1775817871093,1.82357800006878 47.1739692687989,1.81391704082495 47.1665687561036,1.81391704082495 47.1665687561036,1.80059027671814 47.166820526123,1.80059027671814 47.166820526123,1.77823293209076 47.1850967407227,1.7729793787002 47.2017707824707,1.7729793787002 47.2017707824707,1.78394854068767 47.2273216247559,1.77611076831823 47.2313842773438,1.77611076831823 47.2313842773438,1.79090237617498 47.2319602966309,1.79582071304327 47.2378196716309))0.0006POINT(1.806449717283293 47.20206928253175)
65127POLYGON((11.912278175354 49.6451911926271,11.91499042511 49.6422424316407,11.913673400879 49.6394042968749,11.9141254425049 49.638313293457,11.9238290786744 49.6380004882813,11.9269304275513 49.6397972106934,11.9356985092163 49.6392631530763,11.9352302551269 49.6439590454103,11.9456682205201 49.6440849304199,11.9537076950073 49.6414375305176,11.959836959839 49.6415901184081,11.9599227905273 49.6403312683106,11.9743967056276 49.6401519775392,11.975685119629 49.6374549865723,11.9753913879395 49.6351280212402,11.9753913879395 49.6351280212402,11.9781036376953 49.6399421691895,11.9790086746216 49.63920211792,11.9773626327515 49.6379356384278,11.9766311645508 49.6349029541016,11.9790201187133 49.6315155029297,11.9899616241455 49.6292037963868,11.9900979995728 49.6326942443848,12.0029640197754 49.6294822692872,12.0099544525147 49.6315116882324,12.0111856460572 49.6295013427734,12.0158557891845 49.6302986145021,12.0274953842164 49.6297035217286,12.026177406311 49.6203346252442,12.0309114456177 49.6210556030275,12.0356731414795 49.6231231689454,12.0365734100342 49.6226692199708,12.0347385406494 49.6216163635254,12.0430660247803 49.6187210083008,12.0408878326416 49.6130180358887,12.0423688888551 49.6095504760743,12.0466127395631 49.6076393127441,12.0483884811402 49.6081657409669,12.0492982864379 49.6067390441895,12.0647773742676 49.61137008667,12.0647773742676 49.61137008667,12.07217502594 49.6132850646973,12.0770683288575 49.6157951354982,12.0813035964967 49.6203422546387,12.0801677703858 49.6211509704591,12.0840768814088 49.6241836547852,12.0823278427125 49.6244850158691,12.0837106704713 49.6260871887208,12.0867948532106 49.6255226135255,12.0874300003053 49.6267280578613,12.0865726470948 49.6280174255372,12.0821800231934 49.6284027099609,12.0826969146729 49.6300048828126,12.0803794860839 49.631004333496,12.0748596191407 49.6312255859375,12.0741872787476 49.6318511962891,12.0761795043946 49.6327133178712,12.0729303359985 49.6352462768555,12.0774745941163 49.6381797790527,12.0765371322632 49.6399803161622,12.0748481750488 49.6387825012207,12.0706758499145 49.6403961181641,12.0727968215942 49.6411628723146,12.0740337371827 49.6405487060546,12.077564239502 49.6442489624024,12.0791740417482 49.6438865661621,12.0798435211182 49.6448593139649,12.0786638259889 49.6452331542969,12.0789957046509 49.6468658447266,12.0831995010376 49.6487083435059,12.0868577957154 49.6486740112305,12.0885257720947 49.646339416504,12.0919609069825 49.6450309753417,12.0919609069825 49.6450309753417,12.096064567566 49.6479949951172,12.0975875854493 49.6533470153809,12.09348487854 49.6537475585938,12.0867195129395 49.6574401855469,12.0831136703491 49.6573257446288,12.0831136703491 49.6573257446288,12.0785970687866 49.6581497192383,12.0770864486695 49.6553611755371,12.0777111053468 49.6533088684083,12.0753211975098 49.6522636413575,12.0763883590698 49.6507797241212,12.0744943618775 49.6481895446778,12.0749416351318 49.6462211608887,12.0692682266235 49.6426811218263,12.0699787139894 49.6406936645509,12.0646715164185 49.6402740478516,12.0629625320435 49.6392707824708,12.0599927902222 49.6395530700684,12.0581903457642 49.6382560729981,12.0530405044556 49.6375274658203,12.0555305480958 49.6365661621094,12.0526189804077 49.6373710632325,12.0515975952149 49.6366386413574,12.0491781234741 49.6401901245117,12.0374965667724 49.6440467834474,12.0336570739746 49.6422729492188,12.0276927947999 49.6420822143555,12.0268993377686 49.6437110900879,12.0292053222656 49.6456260681152,12.0254678726197 49.6461791992188,12.0209398269653 49.6493339538575,12.0100383758544 49.6508026123048,12.0055322647094 49.6529426574708,12.0023574829102 49.6560173034669,11.9985523223877 49.6557693481446,11.9920549392701 49.6523208618165,11.9848804473878 49.6591453552246,11.9844102859498 49.6618499755861,11.9712781906128 49.6675643920899,11.9712781906128 49.6675643920899,11.9672660827636 49.6682662963867,11.9616584777833 49.671226501465,11.9570579528809 49.6722221374512,11.9559545516968 49.673755645752,11.9522914886475 49.6746025085449,11.9509878158569 49.673225402832,11.9474315643312 49.6725425720215,11.9407424926758 49.6751022338867,11.9304761886597 49.6730461120607,11.9141683578491 49.6762275695801,11.9018859863282 49.6799354553222,11.8980321884156 49.6801452636719,11.9074850082397 49.6729545593262,11.9111089706421 49.672649383545,11.9121007919312 49.6705780029297,11.9119415283204 49.6651878356935,11.9082851409913 49.6596565246583,11.9063358306886 49.6504211425782,11.9067955017089 49.6472358703614,11.9140653610229 49.6500549316407,11.912278175354 49.6451911926271))0.0006POINT(12.019748267842795 49.64263776522965)
43726POLYGON((2.6019177436828 43.9009780883789,2.61746740341192 43.9003524780275,2.61746740341192 43.9003524780275,2.6056609153747 43.9104499816895,2.61186051368713 43.9195442199706,2.59741139411926 43.9328384399414,2.5968902111054 43.9396514892579,2.60444617271429 43.9438362121582,2.60745263099682 43.9503898620607,2.63094305992132 43.9490661621094,2.63411498069769 43.9555854797364,2.63411498069769 43.9555854797364,2.63191676139826 43.9583740234375,2.63814306259167 43.9667587280273,2.63407349586487 43.9717826843263,2.63407349586487 43.9717826843263,2.60613989830023 43.9691123962403,2.59754562377935 43.9721069335938,2.59022307395935 43.9679107666016,2.5721361637116 43.9720458984376,2.55154180526745 43.9634590148926,2.54179644584667 43.9558753967286,2.54179644584667 43.9558753967286,2.5404715538026 43.9502449035646,2.54906320571905 43.9507293701171,2.54906320571905 43.9507293701171,2.55190587043762 43.9535789489747,2.56147742271423 43.9530868530273,2.56532502174389 43.9467735290528,2.58272027969366 43.9408302307129,2.5895409584046 43.9207229614258,2.57445955276489 43.9128341674805,2.57445955276489 43.9128341674805,2.58355951309198 43.9111785888672,2.6019177436828 43.9009780883789))0.0006POINT(2.5917994064443644 43.94374286427222)
62789POLYGON((13.3284978866578 54.5058250427247,13.3290166854858 54.5040969848632,13.327790260315 54.4997863769532,13.3251333236695 54.4976539611818,13.3327894210816 54.4897460937501,13.3327894210816 54.4897460937501,13.3185596466066 54.4847831726074,13.3173341751099 54.4828186035157,13.3146209716797 54.484260559082,13.3145923614502 54.4831123352051,13.3049621582032 54.484718322754,13.3054704666139 54.4877700805665,13.3026332855226 54.4882659912109,13.3013916015625 54.4872131347657,13.294647216797 54.4883689880371,13.2947969436645 54.4866523742676,13.2927560806276 54.4870567321777,13.2855882644654 54.4938087463379,13.2874298095703 54.4974403381348,13.2798318862914 54.4976081848145,13.2779111862183 54.5008201599121,13.2660102844238 54.4981918334961,13.2673377990723 54.4955673217773,13.2659273147584 54.4918861389161,13.2696342468262 54.488597869873,13.2773990631104 54.488307952881,13.2858467102051 54.4844970703125,13.2860536575317 54.4786796569824,13.2860536575317 54.4786796569824,13.281660079956 54.4768180847169,13.2806444168092 54.475196838379,13.2766971588135 54.4784927368165,13.2679557800293 54.4788055419922,13.2675008773804 54.4771423339845,13.2675008773804 54.4771423339845,13.266944885254 54.4784736633301,13.2680568695069 54.4798622131348,13.265832901001 54.4801406860352,13.2608337402344 54.4790267944337,13.2597217559815 54.4779167175293,13.2574996948242 54.4781951904297,13.2574996948242 54.4801406860352,13.2563877105712 54.48152923584,13.2580556869507 54.4823608398438,13.2580556869507 54.4837493896484,13.2558336257935 54.4859733581544,13.2458333969116 54.4870834350587,13.2425012588501 54.4862518310547,13.243055343628 54.4851951599122,13.2391672134401 54.4843063354492,13.2386112213136 54.4829177856445,13.2302780151367 54.4840278625488,13.2274999618531 54.4859733581544,13.2269439697267 54.4918060302735,13.2280559539796 54.4934730529786,13.2263898849488 54.4948616027832,13.2286100387573 54.4968070983887,13.2291679382324 54.5037498474122,13.2336101531982 54.5048599243163,13.2308340072632 54.5059738159181,13.2302780151367 54.5070838928223,13.2336101531982 54.5087509155274,13.2313880920411 54.5106925964355,13.2248020172119 54.5109710693359,13.2248020172119 54.5109710693359,13.2256307601929 54.5110321044922,13.2256107330323 54.5120887756348,13.2245483398438 54.516716003418,13.2285633087158 54.5193977355958,13.2288112640382 54.5223121643066,13.2266740798951 54.5246391296387,13.2315511703491 54.5262756347656,13.2301235198976 54.526424407959,13.2310447692872 54.5347938537598,13.2266235351562 54.5390930175782,13.2262983322144 54.5444068908693,13.2136144638062 54.5449066162109,13.2132377624512 54.5440864562988,13.2107419967652 54.5439529418945,13.2093544006348 54.5466766357422,13.2102842330933 54.5501403808594,13.2102842330933 54.5501403808594,13.2269439697267 54.5531959533691,13.240279197693 54.5543060302734,13.2458333969116 54.5526657104493,13.255277633667 54.5520820617676,13.2597217559815 54.5484733581543,13.266944885254 54.5476379394531,13.2691669464111 54.545696258545,13.2730569839478 54.5451393127443,13.2763891220093 54.5434722900391,13.2863903045655 54.5431938171387,13.2880506515504 54.5423622131348,13.2875003814697 54.541805267334,13.289722442627 54.5412483215332,13.290831565857 54.5381927490236,13.2941665649414 54.5379180908203,13.2958326339722 54.5362510681152,13.2947225570679 54.5340270996093,13.2902793884278 54.5323600769044,13.2902793884278 54.5259704589845,13.2880563735962 54.5248603820801,13.2875003814697 54.5218048095704,13.2941665649414 54.5209732055665,13.2974987030029 54.5193061828613,13.2991666793823 54.5165290832521,13.3008327484131 54.5159721374513,13.3008327484131 54.5148620605469,13.3030548095704 54.514072418213,13.3030548095704 54.514072418213,13.3013496398926 54.5130538940429,13.3075389862061 54.509750366211,13.3284978866578 54.5058250427247))0.0006POINT(13.266717544623813 54.50777697563173)