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
12712MULTIPOLYGON(((15.3507776260377 41.584041595459,15.3517656326295 41.5911903381349,15.350721359253 41.5989494323731,15.3469457626344 41.6008796691895,15.3262128829957 41.6036224365235,15.3176584243774 41.6061058044435,15.3098363876343 41.6091728210449,15.3035106658936 41.6168556213379,15.3212118148803 41.6258468627931,15.3248109817505 41.6257286071778,15.3352642059327 41.6202964782715,15.3366460800172 41.6068000793458,15.3509082794189 41.6033630371093,15.3572721481324 41.6151237487793,15.3488416671753 41.627540588379,15.34055519104 41.6336212158204,15.3258514404297 41.6413002014161,15.3203563690186 41.642261505127,15.3158626556396 41.6397590637207,15.3144130706788 41.6399536132814,15.31520652771 41.6523666381837,15.3203458786012 41.666877746582,15.3257150650024 41.6717185974122,15.3288669586183 41.6793823242188,15.331078529358 41.7032051086425,15.3341989517213 41.7117919921876,15.325566291809 41.7211608886719,15.325566291809 41.7211608886719,15.3189554214479 41.730899810791,15.3099699020386 41.7398185729982,15.2972011566162 41.7458114624025,15.2990255355836 41.7516784667969,15.3070802688599 41.7618103027345,15.30908203125 41.7629928588868,15.3134412765504 41.7616043090821,15.3195495605469 41.7611732482911,15.3301887512208 41.7644920349121,15.334740638733 41.7673645019532,15.334740638733 41.7673645019532,15.3427438735962 41.7727966308594,15.3665571212769 41.7729682922364,15.3830852508545 41.7643013000488,15.3952140808105 41.7530593872071,15.4076347351075 41.748233795166,15.4138536453248 41.7469673156739,15.4221544265748 41.7399826049805,15.4243507385254 41.735595703125,15.4328260421753 41.731575012207,15.4584493637086 41.7250442504882,15.4659366607666 41.7247734069824,15.48104763031 41.7276077270508,15.4881973266602 41.7255706787111,15.515461921692 41.7117080688477,15.5151453018189 41.7020568847657,15.5197820663452 41.6973304748535,15.5197820663452 41.6973304748535,15.5169038772583 41.6935348510743,15.5155820846558 41.689079284668,15.5163936614991 41.6867103576661,15.5285778045654 41.6766204833984,15.5252933502198 41.6745529174805,15.5214910507202 41.6739883422852,15.5246953964235 41.6649131774902,15.5376615524292 41.652214050293,15.5414867401122 41.6472358703614,15.5397825241089 41.6373519897461,15.5361347198487 41.6331748962403,15.5304765701294 41.6297721862792,15.5313940048219 41.6262931823732,15.5332326889039 41.6248474121094,15.5461130142213 41.6219902038574,15.5540657043457 41.6257286071778,15.57102394104 41.6171264648438,15.5683002471923 41.6130294799806,15.5683002471923 41.6130294799806,15.5594158172607 41.6001777648927,15.5589666366578 41.5969467163087,15.5601902008057 41.5955543518067,15.5723791122438 41.5900344848633,15.5627803802491 41.5808143615723,15.5510683059692 41.578338623047,15.5338029861451 41.5936164855958,15.514657020569 41.5955467224122,15.5061264038086 41.5954704284668,15.4881296157838 41.5831527709961,15.4883518218995 41.5776405334473,15.4942798614501 41.5716247558594,15.4753408432006 41.5650596618653,15.454381942749 41.5617675781251,15.4512519836426 41.5603904724121,15.4512519836426 41.5603904724121,15.4432821273803 41.5575218200684,15.4383449554443 41.558017730713,15.4279680252076 41.5570945739747,15.4201602935791 41.5550346374512,15.4176321029664 41.5518646240234,15.4136514663696 41.5518913269044,15.3892288208008 41.5603981018066,15.3912200927736 41.5623245239259,15.3894329071046 41.5662002563477,15.3759326934815 41.5777931213379,15.3507776260377 41.584041595459)),((15.606294631958 41.6035919189453,15.5987749099732 41.5985565185548,15.5847110748291 41.6043891906739,15.5847110748291 41.6043891906739,15.5863809585571 41.6108970642089,15.5863809585571 41.6108970642089,15.606294631958 41.6035919189453)),((15.5034542083741 41.5745124816895,15.505470275879 41.5758094787598,15.4998426437377 41.5821838378906,15.4898738861084 41.5791854858398,15.4948472976685 41.5737342834473,15.5034542083741 41.5745124816895)),((15.4924049377443 41.5456123352052,15.498330116272 41.5586318969727,15.4986801147461 41.5605735778809,15.4972610473634 41.5613555908204,15.4834775924683 41.5544204711915,15.4898595809937 41.5452194213867,15.4924049377443 41.5456123352052)))0.0006POINT(15.42494042600453 41.65139478440334)
37991POLYGON((1.23677039146423 49.6562004089356,1.23025715351116 49.675220489502,1.23025715351116 49.675220489502,1.22980463504791 49.6782989501954,1.21664512157452 49.6795272827149,1.21664512157452 49.6795272827149,1.21008813381195 49.6725463867189,1.21008813381195 49.6725463867189,1.21156966686254 49.6658096313477,1.20652019977575 49.6648788452149,1.20216226577753 49.6588478088379,1.20709502696997 49.6496353149415,1.20709502696997 49.6496353149415,1.23456704616547 49.6534423828126,1.23677039146423 49.6562004089356))0.0006POINT(1.217826076916331 49.6665240696499)
19998POLYGON((11.5677833557129 44.9506835937501,11.561882019043 44.9595832824708,11.5513200759888 44.968173980713,11.5531015396118 44.9709243774415,11.5594558715821 44.9749488830566,11.5599212646486 44.9846000671388,11.5567111968995 44.9840087890625,11.5567111968995 44.9840087890625,11.5574007034301 44.988998413086,11.5632371902466 44.9901466369628,11.5736255645753 44.9893188476562,11.5736255645753 44.9893188476562,11.5786170959473 44.9887351989747,11.5822687149049 44.9863319396972,11.5812320709229 44.9843826293945,11.5820188522339 44.9795951843263,11.5907983779908 44.9785499572754,11.6047649383545 44.9798431396485,11.6084537506103 44.970531463623,11.6109447479249 44.9697303771972,11.6164569854736 44.9739685058595,11.6231670379639 44.975154876709,11.6295413970948 44.9745216369629,11.6405878067017 44.9768409729004,11.6561679840088 44.9864540100098,11.6561679840088 44.9864540100098,11.6630640029908 44.97562789917,11.6630640029908 44.97562789917,11.6538619995117 44.9690551757814,11.6558561325074 44.9638786315918,11.6558675765991 44.9613571166993,11.6452713012695 44.9538879394532,11.6411161422729 44.9533729553223,11.6367492675782 44.9543190002441,11.635724067688 44.953254699707,11.6326990127563 44.9444122314454,11.6324777603149 44.9384193420411,11.6324777603149 44.9384193420411,11.6231880187988 44.9450912475586,11.602409362793 44.945442199707,11.5951223373414 44.9426116943359,11.5802507400514 44.9475669860841,11.5734119415283 44.951198577881,11.5677833557129 44.9506835937501))0.0006POINT(11.605083132899113 44.96882212439252)
64897POLYGON((10.2239151000977 50.3509712219238,10.2223596572875 50.3500785827637,10.2195568084718 50.3509063720703,10.2133436203003 50.3505134582521,10.2133264541627 50.348705291748,10.2097034454346 50.3501014709473,10.2049045562745 50.3484344482422,10.2034158706666 50.3504180908204,10.2036828994751 50.3548812866211,10.2010974884034 50.35453414917,10.1992692947388 50.3589019775391,10.1977100372315 50.3585891723633,10.1959323883057 50.3616790771486,10.1935138702393 50.3615684509278,10.1935920715333 50.3689804077148,10.1907234191896 50.3687858581544,10.1901054382325 50.3729858398438,10.1918411254883 50.3743553161622,10.1899557113648 50.3764762878419,10.1898756027222 50.3779144287111,10.1898756027222 50.3779144287111,10.1999263763429 50.3794174194337,10.2011451721192 50.3780326843262,10.2039146423339 50.3784103393555,10.2092266082764 50.3727188110353,10.2164764404297 50.3742218017579,10.2177658081055 50.3727226257324,10.2298316955568 50.3737220764161,10.2309150695801 50.3712425231934,10.2343473434449 50.3713302612305,10.2367029190063 50.3726768493652,10.2367029190063 50.3726768493652,10.2374534606935 50.3718948364258,10.2370376586914 50.3707809448243,10.2451276779175 50.3679809570314,10.2451276779175 50.3679809570314,10.2389097213746 50.3680686950685,10.2371425628663 50.3620262145996,10.2348461151124 50.3601112365723,10.2318954467773 50.3547439575196,10.2292470932007 50.3529930114747,10.226752281189 50.3539581298828,10.2238721847535 50.3534736633301,10.2239151000977 50.3509712219238))0.0006POINT(10.214931798535767 50.3643925688988)
48365POLYGON((0.157333746552524 47.5294075012207,0.161770507693404 47.5199851989747,0.153390094637984 47.4943237304688,0.153390094637984 47.4943237304688,0.200659438967762 47.4845008850098,0.200659438967762 47.4845008850098,0.220109254121724 47.5019531250001,0.220109254121724 47.5019531250001,0.224843129515648 47.5272789001466,0.224843129515648 47.5272789001466,0.207174643874168 47.5266761779786,0.205636888742561 47.5329437255859,0.193120315671081 47.5380363464355,0.193120315671081 47.5380363464355,0.166210353374538 47.5398254394531,0.166210353374538 47.5398254394531,0.157333746552524 47.5294075012207))0.0006POINT(0.1905363099650082 47.517553091049244)
56569POLYGON((4.65589857101446 45.9267768859864,4.65277099609381 45.9262123107911,4.65277099609381 45.9262123107911,4.63914775848394 45.9233741760255,4.64815950393677 45.908390045166,4.64815950393677 45.908390045166,4.67014455795299 45.9053764343262,4.67014455795299 45.9053764343262,4.66478061676025 45.9110488891603,4.6661834716798 45.9245834350587,4.6661834716798 45.9245834350587,4.65589857101446 45.9267768859864))0.0006POINT(4.6576676368714 45.917302218350564)
48642POLYGON((-0.294089615345001 48.485336303711,-0.293498784303665 48.4923210144044,-0.293498784303665 48.4923210144044,-0.313125193119049 48.4950790405274,-0.319293171167374 48.5002822875978,-0.30895626544941 48.5183296203614,-0.30895626544941 48.5183296203614,-0.32023906707758 48.5229301452636,-0.32023906707758 48.5229301452636,-0.334972620010376 48.5090827941895,-0.336825251579285 48.5024223327637,-0.353789061307907 48.4964981079103,-0.353151798248291 48.483772277832,-0.353151798248291 48.483772277832,-0.340938448905888 48.4680900573731,-0.340938448905888 48.4680900573731,-0.335100680589676 48.4650764465333,-0.335100680589676 48.4650764465333,-0.299090653657913 48.4802207946777,-0.299090653657913 48.4802207946777,-0.294089615345001 48.485336303711))0.0006POINT(-0.3227023154496919 48.492509078979545)
27999POLYGON((0.556151866912955 48.6021766662598,0.567074298858699 48.5957679748536,0.567303180694694 48.5861701965333,0.570997476577759 48.5840225219728,0.579595446586609 48.5869979858399,0.583224415779114 48.5847854614259,0.583224415779114 48.5847854614259,0.565646290779114 48.5757064819336,0.565646290779114 48.5757064819336,0.552677035331726 48.5798492431642,0.539992094039917 48.5747184753419,0.539992094039917 48.5747184753419,0.537755131721553 48.5778770446777,0.551563858985958 48.600471496582,0.556151866912955 48.6021766662598))0.0006POINT(0.5614888497761602 48.584553854806146)
65271POLYGON((11.5531568527221 49.6009407043458,11.5499773025513 49.6036491394043,11.5516996383667 49.6058006286621,11.5516996383667 49.6058006286621,11.5549669265747 49.6094741821289,11.5549879074097 49.611141204834,11.5534296035767 49.6115188598634,11.5513916015625 49.6150703430177,11.5538539886475 49.6162185668946,11.5536298751832 49.6173362731935,11.5582275390624 49.6173477172852,11.5565023422241 49.6201362609864,11.5534248352051 49.6193618774415,11.5498628616334 49.6204681396486,11.5396966934205 49.6127967834472,11.5300168991089 49.6119079589845,11.5290765762329 49.6134414672853,11.5290765762329 49.6134414672853,11.5208225250245 49.6132621765137,11.5215950012208 49.611011505127,11.5210857391358 49.6096916198732,11.5162353515626 49.609130859375,11.5209894180298 49.6082077026368,11.5208616256714 49.6067771911622,11.5172853469849 49.6076087951661,11.5223321914673 49.6043701171875,11.5189256668091 49.6045532226562,11.5155715942383 49.6060523986817,11.5154705047607 49.6071510314942,11.5110025405884 49.6097259521485,11.5071821212768 49.6080055236818,11.5059881210327 49.6091766357422,11.5069475173951 49.6113548278809,11.506049156189 49.6120910644532,11.4969425201417 49.610939025879,11.4969396591188 49.6101303100587,11.4946813583375 49.6100769042969,11.4949855804444 49.6087265014648,11.4925365447999 49.6087913513183,11.4874467849731 49.6110763549805,11.4872236251831 49.6123123168945,11.4851627349854 49.6117820739747,11.4827861785889 49.6093101501466,11.4865427017211 49.6095390319825,11.4813137054443 49.6077384948731,11.4823513031006 49.6063270568848,11.4857702255249 49.6063232421876,11.4830751419067 49.6038360595704,11.4837818145753 49.6018524169922,11.4824542999268 49.6012420654298,11.478554725647 49.6021308898926,11.4776172637939 49.6003112792969,11.4749479293823 49.5997314453124,11.4734668731689 49.5997200012208,11.4730052947999 49.6008644104004,11.4706926345826 49.6008033752441,11.4707660675049 49.5989761352539,11.4735345840455 49.5989799499512,11.4742069244385 49.5973205566407,11.47008228302 49.5966453552246,11.4659938812256 49.5929718017579,11.4659938812256 49.5929718017579,11.4653654098512 49.5913200378419,11.4608707427979 49.5894432067872,11.462655067444 49.5893936157228,11.4618854522706 49.5876007080079,11.4632749557496 49.5864639282227,11.4628467559815 49.5844612121583,11.4637727737427 49.581672668457,11.4652013778687 49.5811309814454,11.4646701812744 49.5802078247071,11.462929725647 49.5810050964355,11.461431503296 49.5801620483399,11.4620571136474 49.5782318115234,11.4620571136474 49.5782318115234,11.4658575057985 49.5773010253907,11.4702568054199 49.5793495178223,11.4725036621094 49.5789070129395,11.4754543304443 49.579792022705,11.4769163131714 49.5795631408693,11.4785499572755 49.5768661499023,11.4795818328859 49.5773010253907,11.4787302017211 49.5789527893067,11.4792737960816 49.5804595947265,11.4843006134033 49.5846138000488,11.4852046966553 49.5835838317872,11.4936723709108 49.5862007141114,11.4936895370485 49.5850410461426,11.4947528839112 49.5849304199219,11.4950752258301 49.5864295959474,11.4969158172609 49.5844345092775,11.4970836639405 49.5858535766602,11.4981498718262 49.5852165222169,11.5010194778443 49.5887794494629,11.5026330947876 49.5891609191895,11.5062007904053 49.5877342224122,11.5059204101564 49.5888557434083,11.5081968307495 49.5891761779785,11.5102262496949 49.5876541137696,11.5138111114503 49.588981628418,11.5139722824097 49.5900421142578,11.5165815353394 49.588436126709,11.5167226791382 49.585319519043,11.5139055252075 49.5836257934571,11.5102653503417 49.5783691406249,11.5130796432496 49.5778274536133,11.5145454406739 49.5761718750001,11.5134763717651 49.5757942199706,11.5136909484863 49.5715827941896,11.5159912109376 49.5711135864257,11.5192403793336 49.5677528381349,11.5246505737306 49.5684509277343,11.5307884216309 49.5650749206544,11.5307884216309 49.5650749206544,11.5314407348633 49.5632247924805,11.5379467010499 49.562843322754,11.5376882553101 49.5617485046387,11.5423612594605 49.5597496032716,11.5444116592408 49.5599136352539,11.5479946136475 49.5630912780762,11.554084777832 49.5651473999025,11.5524692535401 49.5679359436036,11.5532732009888 49.5685272216797,11.5499296188354 49.5705223083497,11.5515089035034 49.5738182067872,11.5556001663209 49.5730247497559,11.5566825866699 49.5738258361818,11.5556993484497 49.5744018554688,11.5569925308228 49.5752868652345,11.5612573623658 49.5761032104492,11.5612573623658 49.5761032104492,11.5590991973877 49.5811004638672,11.5613174438477 49.5825157165527,11.5610656738282 49.5855331420899,11.5590772628784 49.5857238769532,11.5593557357788 49.5889244079591,11.5582027435303 49.5893669128418,11.5580101013184 49.5881805419922,11.5557823181153 49.5894432067872,11.552851676941 49.5877075195312,11.5529584884643 49.5887756347657,11.5511865615846 49.5893859863282,11.5503120422363 49.5930213928223,11.5510244369507 49.5945816040038,11.5528964996339 49.5947799682617,11.5508441925048 49.5951919555664,11.5526981353761 49.5989265441895,11.5541391372681 49.5996360778808,11.5531568527221 49.6009407043458))0.0006POINT(11.51295940940447 49.592044701447364)
1398288POLYGON((-4.83974218368525 41.0295867919923,-4.85421419143671 41.0248222351074,-4.85597610473633 41.0256690979005,-4.86826992034912 41.0238380432129,-4.87222194671625 41.0210456848145,-4.87320613861084 41.0175437927246,-4.87476778030396 41.0197525024414,-4.87593221664429 41.0189399719239,-4.87798118591309 41.0203018188477,-4.87994813919067 41.0242347717285,-4.88523292541504 41.0268707275391,-4.89562606811523 41.0417060852052,-4.90214920043945 41.0446891784669,-4.90442800521845 41.047836303711,-4.90137720108027 41.047607421875,-4.8882851600647 41.0528755187989,-4.88611793518061 41.0524749755861,-4.88593292236328 41.0555114746095,-4.87703323364258 41.0597457885743,-4.87579584121704 41.0618362426759,-4.86692476272577 41.0608940124512,-4.86626911163324 41.0595245361329,-4.86084413528442 41.0609016418458,-4.84924077987671 41.0603942871094,-4.8403530120849 41.0557365417481,-4.83635520935059 41.0463485717774,-4.8346529006958 41.0343322753907,-4.83974218368525 41.0295867919923))0.0006POINT(-4.871439933776837 41.04055630719227)