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
45488POLYGON((1.47048890590668 44.3506622314454,1.47403359413158 44.3452987670899,1.46685922145844 44.3378067016602,1.46685922145844 44.3378067016602,1.45891010761267 44.3413429260254,1.44163453578949 44.3349761962891,1.43688452243811 44.3357391357422,1.38998901844036 44.353572845459,1.38878881931305 44.3569488525392,1.40143716335297 44.3618812561035,1.40247046947485 44.3652877807618,1.39162290096277 44.3720436096192,1.39162290096277 44.3720436096192,1.39817011356365 44.3757781982422,1.41435885429382 44.3741569519044,1.41435885429382 44.3741569519044,1.41993296146399 44.3646850585938,1.43211722373974 44.3693084716797,1.43652319908142 44.3679313659669,1.44270718097687 44.3552856445312,1.47048890590668 44.3506622314454))0.0006POINT(1.4269884884357746 44.35733566284184)
66201POLYGON((12.4199800491334 49.1833343505861,12.4192752838135 49.1845741271974,12.4249629974366 49.1851196289062,12.425440788269 49.1889572143555,12.4301338195802 49.1900062561036,12.432165145874 49.1917304992676,12.4314279556276 49.1931037902833,12.4375782012939 49.1958312988282,12.4357280731202 49.1996688842774,12.4364862442017 49.2028312683106,12.4374284744264 49.2033729553223,12.441424369812 49.2009735107422,12.441801071167 49.2021484375001,12.440149307251 49.2030830383302,12.443736076355 49.2024574279786,12.4451017379761 49.2043304443359,12.4426927566529 49.2048568725587,12.4428262710572 49.2057838439941,12.4470605850221 49.2055664062501,12.4471397399903 49.2085227966309,12.4424982070922 49.2095680236818,12.4413614273071 49.2086143493653,12.4400444030763 49.2103729248047,12.438027381897 49.2107429504395,12.4351329803468 49.2108268737794,12.4334888458253 49.2095603942872,12.4303207397461 49.2100219726564,12.4299488067626 49.2120513916016,12.4283638000489 49.2125930786133,12.4271106719971 49.2101135253906,12.4256925582886 49.210018157959,12.4243688583374 49.2133369445802,12.4251928329468 49.2154006958007,12.4221925735473 49.2155761718751,12.4209451675414 49.2180633544921,12.416597366333 49.2195358276368,12.4154510498047 49.2236099243164,12.4110145568848 49.2237930297851,12.4100885391235 49.2244873046876,12.4102907180787 49.2257957458496,12.4055852890015 49.226676940918,12.4055852890015 49.226676940918,12.4050426483154 49.2247505187989,12.4065837860107 49.2213401794434,12.4057579040527 49.2208671569824,12.3924970626832 49.227451324463,12.3835048675537 49.228702545166,12.3599128723145 49.2287406921387,12.3599128723145 49.2287406921387,12.3638486862183 49.2195510864259,12.3635873794556 49.2167930603028,12.3583421707153 49.2194404602052,12.3557615280151 49.2180786132812,12.3549690246583 49.2190132141114,12.3507928848267 49.2180442810059,12.3525304794312 49.2164077758789,12.3520689010621 49.2151184082032,12.3497734069825 49.214714050293,12.3468818664551 49.2073669433595,12.3486728668214 49.2046089172364,12.3486728668214 49.2046089172364,12.3476333618165 49.1993827819825,12.352427482605 49.200870513916,12.3525638580322 49.1990509033203,12.3556642532349 49.198268890381,12.3536777496338 49.1955299377441,12.3504905700684 49.1969146728516,12.3504629135132 49.195484161377,12.3540401458741 49.1936645507812,12.3498744964601 49.1901664733887,12.3531274795533 49.1901512145996,12.3518619537354 49.1886596679689,12.3502731323243 49.188747406006,12.3502674102783 49.1875152587892,12.3561620712281 49.1884536743165,12.3622856140136 49.188045501709,12.3636665344238 49.1875534057617,12.3638525009156 49.1856269836426,12.3615522384644 49.1857833862306,12.3606224060059 49.184799194336,12.3742761611938 49.183292388916,12.3733186721803 49.1823120117188,12.3707056045533 49.1821746826173,12.372938156128 49.180633544922,12.369668006897 49.1812629699708,12.3657045364381 49.1781539916993,12.3656902313233 49.1763648986818,12.3693628311158 49.1730461120606,12.3683300018311 49.1701126098633,12.3661355972291 49.1676635742189,12.3667993545532 49.1656646728516,12.3657341003418 49.162956237793,12.3678998947144 49.1600875854492,12.3678998947144 49.1600875854492,12.3702087402344 49.1591300964356,12.370041847229 49.1571159362794,12.373236656189 49.1571350097657,12.3729219436646 49.1593055725098,12.376407623291 49.1587028503418,12.3783922195435 49.1610450744629,12.3807888031007 49.16024017334,12.3818359374999 49.1628227233888,12.384017944336 49.1624641418456,12.3839435577394 49.1644325256348,12.3873481750489 49.1634330749512,12.3865337371827 49.1626091003419,12.388976097107 49.162956237793,12.3870859146119 49.1602249145509,12.3893013000489 49.1600532531738,12.3893013000489 49.1600532531738,12.3950977325439 49.1633644104005,12.3967065811158 49.1632614135743,12.4045181274413 49.16947555542,12.4097023010254 49.1690940856935,12.4112634658813 49.1693496704102,12.4121799468995 49.1706352233888,12.4176445007324 49.170711517334,12.4170837402345 49.1745452880861,12.4119939804077 49.1795539855958,12.4199800491334 49.1833343505861))0.0006POINT(12.392457617431154 49.19351449533672)
15131POLYGON((9.75003910064709 45.6481208801271,9.74446201324469 45.6601524353028,9.74944114685053 45.660011291504,9.74944114685053 45.660011291504,9.76177978515631 45.6593933105469,9.7741327285766 45.6635284423828,9.77766323089611 45.6653785705566,9.78192043304443 45.6714897155762,9.78259563446045 45.6739234924316,9.78259563446045 45.6739234924316,9.78526878356945 45.6740837097169,9.78526878356945 45.6740837097169,9.79042625427257 45.6583137512207,9.78914260864258 45.6528701782227,9.78923511505138 45.6447677612305,9.79067134857172 45.641040802002,9.79067134857172 45.641040802002,9.78407382965088 45.64461517334,9.77121257781988 45.6462059020997,9.75908756256104 45.6463661193848,9.75003910064709 45.6481208801271))0.0006POINT(9.774456453323392 45.657966041564976)
67550POLYGON((7.74586439132702 48.0616340637208,7.74571800231939 48.0584907531738,7.74999666214001 48.0551528930663,7.74974441528315 48.0534210205079,7.7530450820924 48.0478897094728,7.7530450820924 48.0478897094728,7.76520299911505 48.0441894531251,7.77477121353155 48.0380516052247,7.77758169174206 48.0405960083008,7.77953910827631 48.0403633117677,7.78633594512951 48.0328788757325,7.78633594512951 48.0328788757325,7.7884979248048 48.0337944030762,7.79029893875128 48.0366554260254,7.79138612747204 48.0410346984864,7.79077482223522 48.0423965454102,7.79239797592169 48.0438575744629,7.79635763168335 48.0531044006349,7.79289102554327 48.0534400939942,7.79528999328613 48.0552787780762,7.79708480834961 48.0590629577636,7.79559087753307 48.0591125488282,7.79605531692505 48.0610580444337,7.80570697784424 48.0618743896484,7.8052129745484 48.0638885498048,7.81501770019543 48.0711135864258,7.81750631332397 48.0695266723633,7.8201260566712 48.0702133178712,7.82470798492437 48.0690269470215,7.82470798492437 48.0690269470215,7.82241964340221 48.0715408325196,7.81507110595697 48.0726737976074,7.81355857849121 48.0742378234864,7.81160926818853 48.0736236572267,7.80714464187633 48.0746955871583,7.79063320159906 48.0825462341309,7.78987693786621 48.0841445922851,7.78987693786621 48.0841445922851,7.78446817398071 48.0857696533204,7.78615379333502 48.0827140808105,7.78604745864874 48.0802574157715,7.78234624862671 48.080192565918,7.78285217285156 48.0824546813965,7.77907896041876 48.0824699401857,7.77704381942755 48.0845603942872,7.77730703353882 48.0858688354492,7.76974725723272 48.087345123291,7.76809978485113 48.0863075256349,7.75767135620123 48.0843200683595,7.75767135620123 48.0843200683595,7.75670766830444 48.0820999145508,7.7552757263183 48.0820198059082,7.75305795669561 48.0799026489259,7.75143623352051 48.074089050293,7.75143623352051 48.074089050293,7.75279378891003 48.0697250366212,7.74848985672003 48.0677185058595,7.7458806037904 48.0687866210938,7.74501800537121 48.0676498413087,7.74444627761841 48.0646743774415,7.74715852737438 48.0629692077637,7.74586439132702 48.0616340637208))0.0006POINT(7.780445419374108 48.065324814593225)
71742POLYGON((16.6887931823731 48.7319946289063,16.6814746856689 48.7213172912598,16.6805038452149 48.7185363769531,16.6814060211183 48.7170333862305,16.6884403228761 48.7156066894532,16.7220897674562 48.7134475708008,16.7304058074951 48.711784362793,16.7351207733154 48.7094917297363,16.7377948760987 48.7067489624023,16.7404346466065 48.69877243042,16.7404346466065 48.69877243042,16.7399196624756 48.6932144165039,16.7385368347168 48.6913719177246,16.7153778076172 48.6818847656251,16.7153778076172 48.6818847656251,16.7058792114258 48.6897621154786,16.7003402709962 48.6927909851075,16.6977405548096 48.6927795410156,16.696237564087 48.6917037963867,16.6964015960693 48.6876792907716,16.6954517364503 48.6858558654785,16.6865921020508 48.6826629638673,16.6792659759521 48.6829376220704,16.6687965393067 48.6885871887208,16.6653442382812 48.6927032470704,16.6647624969482 48.6979789733888,16.6702899932862 48.7183723449708,16.6702899932862 48.7183723449708,16.6887931823731 48.7319946289063))0.0006POINT(16.70119653429307 48.70050171443398)
42660POLYGON((6.92873382568359 49.0690460205079,6.93342638015747 49.0774421691895,6.93056964874268 49.0798873901368,6.93743371963512 49.0838317871094,6.93743371963512 49.0838317871094,6.94562911987305 49.0877838134767,6.94562911987305 49.0877838134767,6.95060396194464 49.0875930786134,6.95216178894043 49.0814208984376,6.97145318984985 49.083854675293,6.97145318984985 49.083854675293,6.97495603561407 49.0852050781251,6.97617483139038 49.0800170898438,6.97617483139038 49.0800170898438,6.95912647247326 49.068000793457,6.95912647247326 49.068000793457,6.92873382568359 49.0690460205079))0.0006POINT(6.953130394220388 49.08047318458563)
1407026POLYGON((-7.01051807403564 38.4862098693848,-7.00635194778442 38.4821739196778,-7.00363779067993 38.4751586914063,-6.9989972114563 38.471046447754,-6.99827909469604 38.4652976989746,-6.9912281036377 38.4577026367189,-6.99599123001093 38.4518928527833,-6.99671983718872 38.4476432800294,-6.9986371994018 38.4469299316406,-7.00207614898682 38.4480018615723,-7.00820016860962 38.4471321105958,-7.01396703720093 38.4437026977539,-7.01333808898926 38.4480476379395,-7.01555109024048 38.4503479003906,-7.01726722717285 38.450122833252,-7.02184104919434 38.4458923339845,-7.0201997756958 38.4427261352539,-7.02271890640259 38.4390068054199,-7.02835893630981 38.437671661377,-7.02967691421509 38.4401473999024,-7.03721189498901 38.4399223327636,-7.04017400741571 38.4417114257814,-7.04010581970215 38.4440002441407,-7.04233312606812 38.4446716308594,-7.04642391204834 38.4427032470703,-7.04714202880859 38.4399757385254,-7.05075693130493 38.4401092529297,-7.05436897277832 38.4364891052246,-7.0567369461059 38.4372901916504,-7.05352592468256 38.4400444030762,-7.06121110916132 38.4404792785646,-7.06609487533564 38.4381217956544,-7.06038093566889 38.4365196228027,-7.06173276901245 38.4348678588867,-7.06397819519043 38.4340858459473,-7.06961917877192 38.4364547729492,-7.08402109146118 38.4459075927736,-7.09751510620117 38.448585510254,-7.11585092544556 38.4697227478027,-7.12365484237671 38.4731483459473,-7.14672613143921 38.4669113159179,-7.14841985702509 38.4684638977051,-7.15358877182007 38.4683341979982,-7.15792083740229 38.4705467224122,-7.16292190551758 38.4680557250976,-7.16828012466425 38.4729537963868,-7.17065715789789 38.4687004089357,-7.17360019683838 38.4688568115234,-7.1742467880249 38.4651679992676,-7.18056678771967 38.4661140441895,-7.18266582489008 38.4632110595704,-7.18512821197504 38.4651489257814,-7.19407081604004 38.4619293212892,-7.20090579986572 38.4661865234375,-7.2051568031311 38.4664192199708,-7.21508216857904 38.4702491760253,-7.22633409500122 38.4675102233887,-7.22919178009022 38.4650917053224,-7.23325109481812 38.4653434753418,-7.23494911193848 38.4614906311035,-7.23869180679321 38.4621925354005,-7.24557209014887 38.4605636596681,-7.24791097640991 38.4633407592773,-7.25360584259022 38.4645385742188,-7.26070594787598 38.4639129638672,-7.25786399841309 38.4681587219238,-7.2678170204162 38.4689216613769,-7.27211093902588 38.4750595092775,-7.28337717056269 38.4695434570314,-7.28336477279657 38.4674072265626,-7.28620481491089 38.4689445495605,-7.28895092010498 38.4677429199219,-7.28938007354736 38.4693412780762,-7.29410696029663 38.468879699707,-7.29476118087763 38.472583770752,-7.29716587066645 38.4732704162599,-7.2959041595459 38.4760360717775,-7.29634809494019 38.4802856445313,-7.30044412612909 38.4829559326172,-7.30770492553711 38.4809532165527,-7.31217479705805 38.4744987487793,-7.31487083435059 38.473731994629,-7.31985807418823 38.4751091003419,-7.32171916961664 38.4795570373536,-7.32082605361938 38.4853782653809,-7.31538391113281 38.4964637756348,-7.31396389007568 38.5078544616699,-7.31456518173218 38.5138778686523,-7.31194877624512 38.5159873962403,-7.31098794937134 38.5161666870117,-7.30318880081177 38.5096321105958,-7.29876804351807 38.5084953308106,-7.29216909408569 38.5091438293458,-7.2768239974975 38.5047454833984,-7.26512289047236 38.5061264038087,-7.25156879425043 38.510108947754,-7.24103498458862 38.5163612365724,-7.22137689590448 38.5324478149415,-7.21815395355219 38.5381469726563,-7.21766185760498 38.543830871582,-7.23194313049316 38.5515022277831,-7.23125982284546 38.5566596984863,-7.23574876785273 38.5639533996582,-7.24207878112787 38.5859260559083,-7.24638414382935 38.5859375,-7.25488281249994 38.594051361084,-7.26268720626831 38.5955085754396,-7.26116800308222 38.5976028442383,-7.2612800598144 38.6005172729493,-7.25936985015869 38.6037673950196,-7.25928783416748 38.606430053711,-7.25583982467646 38.605770111084,-7.25197887420654 38.6080169677736,-7.25027704238886 38.6069831848146,-7.24678993225098 38.6097450256348,-7.24673700332642 38.6053619384767,-7.2444028854369 38.6021766662598,-7.23216390609741 38.6073608398438,-7.23234176635742 38.6045608520508,-7.22979879379272 38.6034622192384,-7.22784805297852 38.6040382385254,-7.2268648147583 38.6103782653809,-7.22262811660761 38.608211517334,-7.21888399124146 38.6110725402832,-7.21685791015619 38.6080398559571,-7.21884489059443 38.6047706604004,-7.21252012252808 38.6084861755372,-7.21120119094849 38.6057395935059,-7.21252298355097 38.6040077209473,-7.21013021469105 38.6033020019531,-7.20654201507557 38.60693359375,-7.20604276657099 38.6039009094239,-7.20026588439941 38.6030502319337,-7.19683122634882 38.6057434082032,-7.19390392303467 38.603370666504,-7.19179582595814 38.6034584045411,-7.19309997558588 38.6009941101075,-7.18770503997803 38.6000175476074,-7.19058799743647 38.5960960388185,-7.19023704528809 38.5936317443849,-7.18506813049316 38.5923767089845,-7.18204784393311 38.5929260253907,-7.18131017684931 38.594051361084,-7.1831698417663 38.5942649841309,-7.17827606201172 38.5969619750978,-7.17761802673334 38.5936965942384,-7.16467905044556 38.5967712402345,-7.16100502014154 38.5939826965333,-7.15506601333618 38.5926818847657,-7.15475797653193 38.5905380249023,-7.14839887619019 38.5845489501954,-7.14316415786743 38.5862884521486,-7.13747310638422 38.5857162475587,-7.13179779052723 38.5869750976563,-7.12789821624756 38.5844421386719,-7.12242221832275 38.583568572998,-7.12038898468018 38.5757255554199,-7.0840430259704 38.5723266601563,-7.06598281860346 38.5729026794434,-7.04609298706055 38.5482673645019,-7.03954982757563 38.5379371643068,-7.03467512130732 38.5356369018555,-7.0299391746521 38.5278549194337,-7.02773523330688 38.5269775390626,-7.0255331993103 38.5195770263672,-7.02299690246576 38.5180778503419,-7.0201158523559 38.504451751709,-7.01394796371454 38.4980278015137,-7.01325082778931 38.4900512695313,-7.01051807403564 38.4862098693848))0.0006POINT(-7.169611580978465 38.51573248868865)
18287POLYGON((9.24735069274908 39.5391654968262,9.25025463104248 39.5410614013672,9.25025463104248 39.5410614013672,9.25483417510998 39.5458297729493,9.26616764068615 39.554615020752,9.2760124206543 39.5568542480469,9.30401992797863 39.5602073669434,9.307041168213 39.5640716552734,9.3071174621582 39.5655059814454,9.30211639404303 39.5720977783203,9.30984973907471 39.5753288269044,9.31481075286865 39.5756950378419,9.31481075286865 39.5756950378419,9.32223320007324 39.5717735290527,9.33222961425781 39.5613174438478,9.33881282806391 39.5362777709962,9.33881282806391 39.5362777709962,9.33822727203375 39.5282707214355,9.32849121093761 39.5240097045898,9.31511211395264 39.5212898254395,9.3046636581422 39.5104522705078,9.30284690856939 39.5097694396973,9.25366878509527 39.5070686340333,9.25366878509527 39.5070686340333,9.25348281860346 39.5263137817383,9.25012207031261 39.5364494323732,9.24735069274908 39.5391654968262))0.0006POINT(9.293731249295785 39.54398184556233)
50135POLYGON((3.81695914268494 49.9705886840821,3.81292176246654 49.9829025268556,3.80902457237249 49.9848709106445,3.80042266845714 49.981819152832,3.80042266845714 49.981819152832,3.77631378173828 49.9949264526367,3.75118160247808 50.0009307861329,3.7350606918335 50.0001487731935,3.7350606918335 50.0001487731935,3.74409151077271 50.0230598449706,3.74409151077271 50.0230598449706,3.74919629096985 50.022258758545,3.76162600517284 50.02836227417,3.76381683349621 50.0414772033692,3.7779302597047 50.0459899902345,3.7779302597047 50.0459899902345,3.79883313179022 50.0474281311036,3.81582736968994 50.0390434265138,3.81582736968994 50.0390434265138,3.81332778930675 50.0222625732422,3.84493613243114 50.0232620239258,3.86703848838818 50.0145187377931,3.87046027183533 50.0157165527343,3.87046027183533 50.0157165527343,3.88146090507502 50.0061721801759,3.88146090507502 50.0061721801759,3.867511510849 49.9776687622071,3.867511510849 49.9776687622071,3.84933495521557 49.9810943603516,3.81695914268494 49.9705886840821))0.0006POINT(3.8068979608601987 50.010142096157786)
39794POLYGON((4.04754924774164 43.6231689453126,4.04621267318731 43.6300125122071,4.06149339675915 43.6383590698242,4.06149339675915 43.6383590698242,4.08045053482061 43.6232261657715,4.08279657363892 43.6097145080567,4.08279657363892 43.6097145080567,4.07271957397472 43.6026077270509,4.05983209609997 43.5987663269043,4.05167150497448 43.6068077087402,4.04754924774164 43.6231689453126))0.0006POINT(4.064701557159487 43.618073654174836)