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
60866POLYGON((9.04756546020508 47.4561958312988,9.03948116302496 47.4530067443848,9.03747272491455 47.4511642456055,9.03732490539562 47.4497985839844,9.03992176055908 47.4450111389161,9.03992176055908 47.4450111389161,9.04233074188227 47.4433174133302,9.04890346527094 47.4460563659668,9.05525398254406 47.4455604553223,9.05525398254406 47.4455604553223,9.05930709838879 47.4483795166017,9.05930709838879 47.4483795166017,9.05283164978039 47.4545059204103,9.04756546020508 47.4561958312988))0.0006POINT(9.04729813795828 47.44861133282008)
1399928POLYGON((-4.69366121292114 42.6784324645996,-4.69580078124994 42.6799240112305,-4.71155023574829 42.6765365600587,-4.71723604202271 42.6782531738282,-4.7326288223266 42.670482635498,-4.74449491500854 42.6771926879882,-4.7540168762207 42.6807289123535,-4.75923776626587 42.6902046203614,-4.767165184021 42.698097229004,-4.76265907287598 42.7049293518068,-4.75273418426508 42.710205078125,-4.74542188644409 42.708568572998,-4.74086809158325 42.7051086425781,-4.72824907302851 42.7056770324708,-4.72344017028809 42.7234535217285,-4.71306085586548 42.7328414916993,-4.69794797897339 42.7416572570801,-4.69529294967651 42.7375106811523,-4.68850803375233 42.7323417663575,-4.68185281753534 42.731502532959,-4.67849111557001 42.7214927673341,-4.67398023605347 42.7203979492188,-4.66206121444702 42.7057647705079,-4.64898681640619 42.720199584961,-4.64389991760243 42.7223014831542,-4.64129304885864 42.7215843200684,-4.63988685607904 42.7229156494142,-4.64124298095697 42.7252998352052,-4.6256628036499 42.7328910827637,-4.61844205856318 42.7399520874023,-4.60646295547485 42.742057800293,-4.59945678710938 42.7408142089844,-4.59440422058094 42.7415237426758,-4.59415817260737 42.7429161071777,-4.59104919433594 42.7374114990236,-4.58396100997925 42.7330627441407,-4.58006620407104 42.7339897155762,-4.5701642036438 42.7327728271485,-4.56209802627563 42.7374229431152,-4.56796216964722 42.7268447875977,-4.57231998443598 42.7204246520996,-4.57546710968012 42.718849182129,-4.57745409011835 42.7143211364746,-4.58580112457275 42.707847595215,-4.59051799774159 42.7070617675782,-4.59658098220825 42.7015953063965,-4.5969181060791 42.6976280212403,-4.59236478805542 42.69095993042,-4.61865377426147 42.6832160949707,-4.63268518447876 42.6830024719239,-4.64654922485352 42.6884918212891,-4.64980602264399 42.6939659118653,-4.64978313446045 42.6921844482422,-4.66632318496693 42.6825523376465,-4.6801609992981 42.6942634582519,-4.68650388717651 42.6872711181642,-4.69032382965088 42.6858558654786,-4.69366121292114 42.6784324645996))0.0006POINT(-4.6568029888888995 42.71078517980746)
22622POLYGON((-0.563748478889465 44.1754837036133,-0.55427497625351 44.1765403747559,-0.541651964187508 44.1720657348633,-0.456007778644562 44.1729431152343,-0.456007778644562 44.1729431152343,-0.450160026550293 44.1455039978028,-0.460496157407704 44.1223144531251,-0.460496157407704 44.1223144531251,-0.469808191060963 44.1013259887696,-0.469808191060963 44.1013259887696,-0.502504587173405 44.1086807250977,-0.524406552314758 44.1164665222169,-0.534150123596191 44.1241340637208,-0.548449099063873 44.1384010314942,-0.549984216690063 44.1489562988281,-0.563748478889465 44.1754837036133))0.0006POINT(-0.5027969519297016 44.13995997111007)
26558POLYGON((-0.522890329360962 49.1225128173828,-0.550476431846505 49.1398658752442,-0.550476431846505 49.1398658752442,-0.550073802471161 49.1477966308594,-0.550073802471161 49.1477966308594,-0.521228432655221 49.1529273986816,-0.521228432655221 49.1529273986816,-0.518741011619568 49.1294555664063,-0.512090682983342 49.1242141723634,-0.512090682983342 49.1242141723634,-0.522890329360962 49.1225128173828))0.0006POINT(-0.5309370040892987 49.138157653808626)
70582POLYGON((11.3333225250245 51.3729820251465,11.3325500488282 51.37797164917,11.342872619629 51.3803176879883,11.3422794342042 51.3824615478516,11.3472499847412 51.3845596313477,11.3472499847412 51.3845596313477,11.349892616272 51.3883857727051,11.3509292602539 51.387664794922,11.3574256896973 51.3897743225098,11.3587732315063 51.3856468200685,11.3620281219483 51.382869720459,11.3653612136841 51.3830757141114,11.365595817566 51.386028289795,11.3684043884277 51.3877792358399,11.3705940246583 51.3856773376464,11.3766155242919 51.3855056762696,11.3783168792724 51.3872375488282,11.3932504653932 51.383903503418,11.3938236236573 51.3813133239746,11.3968524932862 51.3813323974611,11.3976135253907 51.3771476745605,11.3959407806396 51.3729324340821,11.3911466598511 51.3725471496582,11.3898363113404 51.3679885864259,11.3904199600219 51.3666839599611,11.3904199600219 51.3666839599611,11.3627405166627 51.3671646118165,11.3614768981935 51.364933013916,11.3368682861329 51.3600540161133,11.3368682861329 51.3600540161133,11.3333225250245 51.3729820251465))0.0006POINT(11.36622397104903 51.378507868448956)
31348POLYGON((2.25807166099554 47.05721282959,2.24911546707165 47.0579719543458,2.24911546707165 47.0579719543458,2.2444801330567 47.0568733215333,2.23985886573803 47.0472984313965,2.26331853866583 47.0183601379396,2.26331853866583 47.0183601379396,2.26773238182062 47.0210151672364,2.26773238182062 47.0210151672364,2.29803919792181 47.0352859497071,2.29803919792181 47.0352859497071,2.30151057243359 47.0631713867188,2.30151057243359 47.0631713867188,2.25807166099554 47.05721282959))0.0006POINT(2.269372536585944 47.0425379826473)
20030POLYGON((12.2276020050049 45.7689857482911,12.231346130371 45.7661170959473,12.2385168075563 45.7638092041017,12.2427253723145 45.7654151916504,12.2452535629272 45.768440246582,12.2452535629272 45.768440246582,12.2417230606079 45.7760848999023,12.2405729293823 45.7957382202148,12.2405729293823 45.7957382202148,12.2271299362183 45.7946777343751,12.2067861557007 45.7966575622559,12.2038908004762 45.7921829223633,12.2039203643798 45.7906723022462,12.2039203643798 45.7906723022462,12.2074260711671 45.7842903137208,12.2071886062623 45.7825965881349,12.2045974731446 45.7829666137695,12.2035417556763 45.7814102172851,12.2065153121949 45.7760353088379,12.2112455368042 45.7721748352051,12.2112455368042 45.7721748352051,12.2276020050049 45.7689857482911))0.0006POINT(12.221474965413428 45.780251457577684)
65585POLYGON((11.601040840149 50.2234420776367,11.5983829498291 50.2249450683595,11.6115951538087 50.2338409423829,11.6103553771974 50.2401695251465,11.6064386367798 50.2418746948243,11.613624572754 50.2443580627441,11.6095228195191 50.2453269958496,11.608699798584 50.2485275268555,11.6106853485107 50.2500228881837,11.6106681823731 50.2510833740234,11.6082792282104 50.2509460449219,11.608256340027 50.2517738342285,11.6101207733154 50.2534751892089,11.6097269058229 50.2540245056153,11.6053047180176 50.2539520263671,11.6116542816162 50.2589569091797,11.6083774566651 50.2599143981935,11.6091470718385 50.2610054016114,11.6170854568483 50.2624855041504,11.6220197677612 50.2598533630372,11.6224632263184 50.2589950561524,11.6213827133179 50.2572708129883,11.6293458938599 50.2580261230469,11.6267395019531 50.2629203796387,11.6241331100464 50.2637023925781,11.6241331100464 50.2637023925781,11.6218919754028 50.2644882202148,11.6201114654541 50.2669448852539,11.6104888916015 50.2685050964357,11.6053142547607 50.2681350708008,11.6036462783813 50.2676467895509,11.600929260254 50.2643318176271,11.594720840454 50.2623672485352,11.5845708847046 50.2555885314941,11.5799274444581 50.2544822692871,11.569302558899 50.2556800842286,11.5648651123048 50.2593460083008,11.5618143081666 50.2603454589844,11.5477600097656 50.2614746093751,11.5431661605835 50.2631797790528,11.5412645339966 50.2654113769531,11.5412645339966 50.2654113769531,11.5334043502808 50.2622985839845,11.5331573486329 50.2631645202638,11.5307273864746 50.2631034851075,11.529034614563 50.2614555358888,11.5243644714357 50.2603645324707,11.5277061462403 50.2558975219727,11.5262413024903 50.2550086975098,11.5218610763551 50.25687789917,11.5157661437989 50.2573547363282,11.5134973526001 50.2549896240235,11.5023612976075 50.2533683776856,11.5011863708497 50.2542152404786,11.4975938796998 50.2542190551758,11.4952144622804 50.2525482177735,11.4944915771486 50.2501983642578,11.4902229309083 50.2514495849611,11.4870014190674 50.2503890991211,11.4859828948975 50.2493171691895,11.4864358901978 50.2481689453126,11.4853162765503 50.2443008422852,11.4829502105712 50.2432060241699,11.4822540283204 50.2401161193847,11.4756860733032 50.2332344055177,11.4631805419922 50.2384262084962,11.4598588943482 50.2358245849609,11.4598588943482 50.2358245849609,11.4628744125366 50.2344245910645,11.4599723815918 50.2324676513672,11.4606142044068 50.2308959960938,11.4564123153687 50.2305259704591,11.4556999206544 50.2285804748536,11.4593296051025 50.2263565063477,11.459059715271 50.2255287170411,11.459059715271 50.2255287170411,11.460397720337 50.2237014770508,11.4627361297608 50.2235450744629,11.4716434478761 50.2167778015137,11.4751253128052 50.2183227539062,11.4775037765503 50.2207832336426,11.477554321289 50.2232055664064,11.4756755828858 50.2228965759278,11.4776191711427 50.226345062256,11.4808330535889 50.2250480651855,11.4816923141479 50.2225570678712,11.4807481765747 50.2196235656739,11.4788084030151 50.2194061279298,11.4736738204956 50.2139053344727,11.4774274826049 50.2096366882324,11.4782810211182 50.2041397094728,11.4813890457154 50.20458984375,11.4831914901734 50.2022895812989,11.4886493682862 50.201847076416,11.486743927002 50.1991996765137,11.488983154297 50.199016571045,11.4902887344361 50.1977844238282,11.4902887344361 50.1977844238282,11.4968700408936 50.1987800598145,11.4966487884521 50.2009239196778,11.4944705963135 50.2013473510742,11.4925708770753 50.2029838562012,11.4949140548707 50.2070465087891,11.4970216751099 50.2079391479493,11.4953308105469 50.2088623046876,11.5067758560181 50.2169494628906,11.5158290863038 50.2185974121094,11.5186433792115 50.2157936096192,11.5233726501466 50.2146530151367,11.5267944335938 50.2121200561525,11.5363063812256 50.2116928100587,11.5427532196045 50.2089881896974,11.5438671112062 50.207359313965,11.5416946411133 50.2023124694825,11.5425367355347 50.1991806030275,11.5443725585938 50.1972656250001,11.5435428619386 50.1946029663087,11.547254562378 50.1951179504395,11.554181098938 50.1914253234864,11.5579442977906 50.191734313965,11.5624160766603 50.1880569458008,11.5668516159059 50.1864776611328,11.568699836731 50.1870079040528,11.568699836731 50.1870079040528,11.565242767334 50.189094543457,11.5700006484986 50.1918640136719,11.5722723007203 50.1974601745605,11.576699256897 50.2010078430177,11.5767660140991 50.2125244140626,11.5787010192872 50.2143592834474,11.5841140747071 50.2156066894531,11.5858879089356 50.2189636230469,11.591136932373 50.2221336364747,11.5952167510987 50.2220878601075,11.5994577407836 50.2204895019532,11.5991201400757 50.2222747802736,11.601040840149 50.2234420776367))0.0006POINT(11.538403181468773 50.232147525338576)
42906POLYGON((6.30378675460815 48.3431587219239,6.30952692031872 48.3476524353027,6.30737733840942 48.3562240600587,6.30737733840942 48.3562240600587,6.29618453979492 48.3511772155762,6.29618453979492 48.3511772155762,6.28062868118286 48.3387336730957,6.25708913803095 48.3359260559083,6.25708913803095 48.3359260559083,6.2541613578797 48.3296394348145,6.24954175949108 48.3283081054688,6.24954175949108 48.3283081054688,6.25278043746948 48.3265266418457,6.25278043746948 48.3265266418457,6.25727272033697 48.3264541625977,6.26217365264904 48.3214302062989,6.26217365264904 48.3214302062989,6.28593063354498 48.3332290649415,6.29101228713995 48.3328514099122,6.29101228713995 48.3328514099122,6.29449701309198 48.342140197754,6.30378675460815 48.3431587219239))0.0006POINT(6.2770534469968124 48.33647119431275)
25113POLYGON((2.22422456741344 48.8535156250001,2.22567701339722 48.8594055175782,2.22567701339722 48.8594055175782,2.20356369018555 48.8606300354004,2.20356369018555 48.8606300354004,2.19786095619207 48.854763031006,2.19786095619207 48.854763031006,2.20236992835993 48.8495788574219,2.19557690620434 48.8411598205567,2.18720984458923 48.837730407715,2.18720984458923 48.837730407715,2.18079519271856 48.830623626709,2.18079519271856 48.830623626709,2.19943046569824 48.8297882080078,2.19943046569824 48.8297882080078,2.21823072433466 48.8269805908204,2.22404837608349 48.8351478576661,2.22404837608349 48.8351478576661,2.22422456741344 48.8535156250001))0.0006POINT(2.204309622446727 48.84374512566468)