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
68538POLYGON((11.1991605758666 52.1915016174318,11.1939210891724 52.1934471130371,11.188835144043 52.1929550170898,11.1867322921754 52.1941986083985,11.184847831726 52.1973838806153,11.1823015213013 52.1983909606933,11.1749429702759 52.1966667175294,11.1711177825928 52.19437789917,11.1621398925781 52.1939888000489,11.1584148406982 52.1964988708496,11.1576814651489 52.2013969421388,11.1554508209228 52.2040443420411,11.1451253890991 52.2047576904298,11.1424226760864 52.2020988464356,11.136739730835 52.200798034668,11.136739730835 52.200798034668,11.1342105865479 52.2020797729493,11.1269588470459 52.2006340026857,11.1264066696168 52.2019691467286,11.1294956207277 52.2030220031738,11.1247968673706 52.2062873840333,11.1136388778687 52.2071533203126,11.09818649292 52.2110900878906,11.0961866378784 52.2093086242676,11.0965385437013 52.2082748413086,11.093786239624 52.2082862854005,11.0914134979249 52.2104682922363,11.0880451202393 52.2103843688966,11.0880451202393 52.2103843688966,11.077184677124 52.218677520752,11.077184677124 52.218677520752,11.0788574218751 52.22465133667,11.0862445831299 52.2286338806153,11.0862445831299 52.2286338806153,11.0919704437256 52.2288894653321,11.0973463058472 52.2338943481446,11.10013961792 52.2347297668458,11.100962638855 52.2336120605469,11.1045122146607 52.2340660095214,11.1045122146607 52.2340660095214,11.1106872558594 52.2346649169922,11.1110696792603 52.2315673828126,11.1130514144897 52.2275466918945,11.1184968948365 52.2234725952148,11.1191902160645 52.2197265625,11.1299486160279 52.2197685241699,11.1297731399536 52.2208938598633,11.133451461792 52.2210464477539,11.1310663223267 52.2222442626954,11.1398401260376 52.2222976684571,11.1401367187499 52.2246704101562,11.142804145813 52.2247543334962,11.1402606964111 52.2302551269532,11.1426763534546 52.2312507629395,11.1392545700073 52.234748840332,11.1415624618531 52.2363281250001,11.1486339569093 52.2370719909669,11.149510383606 52.2388763427736,11.1535568237305 52.2381172180176,11.1500215530396 52.2357597351075,11.1522684097291 52.2280044555665,11.1633949279786 52.2296447753906,11.16254901886 52.2278671264648,11.1637725830079 52.2264289855956,11.1722993850707 52.2265815734864,11.1740846633911 52.2284164428712,11.1740674972535 52.2312393188478,11.1774749755861 52.2308502197266,11.1784572601318 52.2338409423828,11.1802425384522 52.233669281006,11.1806526184083 52.2356185913087,11.1740245819093 52.2351951599122,11.1744899749756 52.2369384765626,11.1811170578003 52.2372703552247,11.1964426040649 52.2335472106934,11.1968126296998 52.2357139587403,11.1977767944336 52.2355651855469,11.1982316970826 52.2327728271486,11.2076320648193 52.2296981811524,11.2071008682252 52.2275772094727,11.2087945938111 52.2272148132324,11.2080564498902 52.2240524291992,11.2124280929566 52.2235794067383,11.2125968933105 52.2212677001954,11.2140445709229 52.2211151123047,11.2140474319459 52.2185668945312,11.2126264572144 52.2184867858887,11.2126083374025 52.2173461914064,11.2201690673829 52.215789794922,11.2207784652711 52.2127265930176,11.2208309173584 52.2113876342774,11.2147397994996 52.2104873657228,11.217324256897 52.2053985595703,11.2031536102295 52.203556060791,11.2143306732178 52.2040481567383,11.2346944808961 52.2067222595215,11.234227180481 52.1978302001954,11.2300214767457 52.1974945068361,11.217345237732 52.1846199035646,11.217345237732 52.1846199035646,11.1991605758666 52.1915016174318))0.0006POINT(11.157274904251135 52.21788990020753)
29878POLYGON((3.98899054527288 47.574275970459,3.99494338035589 47.5539093017578,3.99494338035589 47.5539093017578,4.00852155685425 47.5567893981934,4.00250864028942 47.5453453063965,4.00962400436407 47.5412330627441,4.00962400436407 47.5412330627441,4.02528858184809 47.542808532715,4.02528858184809 47.542808532715,4.03299665451055 47.5495529174805,4.03198909759533 47.55521774292,4.03198909759533 47.55521774292,4.0206441879273 47.5767059326172,4.0206441879273 47.5767059326172,4.00442123413097 47.5785102844239,4.00442123413097 47.5785102844239,3.98899054527288 47.574275970459))0.0006POINT(4.012927398085651 47.55767083168033)
46508POLYGON((3.142895936966 50.1964912414551,3.14433503150946 50.1909217834473,3.15637731552135 50.1815681457519,3.15637731552135 50.1815681457519,3.17763471603394 50.1817741394043,3.20163559913635 50.1754760742188,3.20163559913635 50.1754760742188,3.20911026000971 50.1773223876953,3.20801568031317 50.1797943115234,3.20801568031317 50.1797943115234,3.20700979232799 50.1937789916993,3.20700979232799 50.1937789916993,3.19813203811657 50.1985626220704,3.19813203811657 50.1985626220704,3.19659328460688 50.1985359191894,3.19659328460688 50.1985359191894,3.18010282516485 50.1876335144044,3.16072106361395 50.2019386291505,3.16072106361395 50.2019386291505,3.142895936966 50.1964912414551))0.0006POINT(3.1847920166819192 50.189129076506)
65280POLYGON((11.2669229507447 49.4545555114747,11.2616653442383 49.4545478820801,11.2609901428223 49.4528427124025,11.2497844696045 49.4581527709962,11.2484264373779 49.4622268676758,11.2490940093994 49.4634132385255,11.2481498718263 49.4639053344728,11.2481498718263 49.4639053344728,11.2490043640137 49.4647598266602,11.2200660705567 49.4697341918946,11.2200660705567 49.4697341918946,11.2099361419678 49.4708442687989,11.2089471817017 49.4723815917969,11.2209167480469 49.4754257202148,11.219144821167 49.4792060852051,11.2172784805298 49.4808540344238,11.223448753357 49.4825706481934,11.2220602035523 49.4830284118653,11.2230682373048 49.4848022460938,11.224757194519 49.4841804504396,11.2286767959594 49.4849662780763,11.2286767959594 49.4849662780763,11.2294807434083 49.4851760864258,11.2289476394653 49.4865341186524,11.229817390442 49.4872665405274,11.2317304611207 49.4857292175294,11.2336740493774 49.4857788085938,11.2337112426758 49.4874649047852,11.2360153198243 49.4887619018555,11.2403373718263 49.4883041381837,11.2399950027467 49.4873771667481,11.2412824630738 49.486785888672,11.2436408996582 49.4880905151368,11.2439336776733 49.4892921447754,11.2465715408325 49.4902267456056,11.2494792938233 49.4933395385742,11.2537775039673 49.4943923950196,11.2537775039673 49.4943923950196,11.2558946609497 49.4927062988282,11.2606458663941 49.4954872131347,11.2631874084473 49.4913558959962,11.265064239502 49.491985321045,11.2685070037842 49.4887580871583,11.2696266174316 49.4862403869629,11.272713661194 49.4850425720215,11.275360107422 49.4855461120607,11.275360107422 49.4855461120607,11.2771110534669 49.4853897094727,11.2771110534669 49.4853897094727,11.2986965179444 49.4780502319336,11.3040657043458 49.4730262756348,11.3061981201172 49.4733924865723,11.3066930770874 49.4749450683595,11.3098554611207 49.4750022888184,11.3103857040406 49.4687652587891,11.3158111572265 49.4655761718751,11.3158111572265 49.4655761718751,11.3147907257081 49.4648170471191,11.3132829666138 49.4654235839845,11.3125467300416 49.4643592834474,11.3091354370117 49.4650497436525,11.3091611862184 49.4665489196777,11.3078536987305 49.4676017761232,11.3071870803833 49.4665641784668,11.3024978637695 49.4659957885743,11.3014249801636 49.4645347595216,11.2985372543336 49.4643516540528,11.2979068756105 49.4679718017578,11.2962322235108 49.4685401916505,11.2919797897339 49.4659805297853,11.2890033721924 49.4662628173828,11.2883090972901 49.4677314758301,11.2861499786377 49.467342376709,11.287003517151 49.4714202880859,11.2862806320192 49.4719924926758,11.2846975326538 49.4705657958986,11.2824678421021 49.4718017578125,11.2788181304933 49.4706420898438,11.2788181304933 49.4706420898438,11.2758598327636 49.471263885498,11.26953125 49.4700202941895,11.2641258239747 49.4704093933106,11.2612152099611 49.4722633361816,11.2540187835693 49.4667625427247,11.2577896118165 49.4659996032715,11.2571554183961 49.4643402099609,11.2621421813965 49.4637298583984,11.2617864608766 49.4621391296387,11.2603387832641 49.4622917175294,11.2669229507447 49.4545555114747))0.0006POINT(11.264736518431288 49.47509054119669)
60972POLYGON((8.60525131225586 46.2624626159669,8.58467674255371 46.2652626037598,8.57481575012201 46.2692527770996,8.57481575012201 46.2692527770996,8.56013107299816 46.2686119079591,8.54984664917004 46.2637176513673,8.53315067291271 46.2629051208497,8.52262496948242 46.2599220275879,8.5089635848999 46.2602577209473,8.49932479858393 46.2531356811523,8.47499465942388 46.2492218017579,8.47119998931896 46.2452087402344,8.46082210540783 46.2383880615236,8.46082210540783 46.2383880615236,8.46435165405279 46.225643157959,8.47043323516851 46.2243003845215,8.47756481170649 46.2246856689453,8.47756481170649 46.2246856689453,8.490800857544 46.2259330749512,8.50130271911621 46.2238845825196,8.51005935668945 46.2201538085938,8.51401710510254 46.2194137573243,8.51734447479254 46.2197647094727,8.52227115631109 46.2219161987305,8.53309631347662 46.2198715209962,8.53309631347662 46.2198715209962,8.54653263092052 46.2227821350098,8.55746173858648 46.2236824035645,8.56546974182123 46.2223472595215,8.57750225067133 46.2220840454102,8.58365440368664 46.2195625305177,8.58992004394537 46.2197341918945,8.60081958770746 46.2148551940917,8.60538959503168 46.2143898010254,8.60500431060797 46.2160568237306,8.60623359680187 46.2170333862306,8.60623359680187 46.2170333862306,8.61262416839605 46.2238426208496,8.61275291442877 46.2252883911133,8.61067867279058 46.227867126465,8.60995769500732 46.2305488586426,8.614580154419 46.2341728210449,8.61502456665045 46.2357559204102,8.61384010314947 46.2377510070801,8.60803031921392 46.2404823303223,8.60400772094738 46.2437248229981,8.60413646698004 46.2492675781251,8.60696220397949 46.2522392272949,8.60752677917475 46.2545280456542,8.60743427276617 46.2576866149903,8.60525131225586 46.2624626159669))0.0006POINT(8.555302410125769 46.23597656250004)
25279POLYGON((2.72113156318676 49.00830078125,2.71278405189514 49.0075645446778,2.71278405189514 49.0075645446778,2.73103404045105 49.0282058715821,2.73063325881969 49.0316581726074,2.72133326530468 49.034423828125,2.72133326530468 49.034423828125,2.71629524230963 49.0454101562501,2.71925139427196 49.0476455688477,2.71925139427196 49.0476455688477,2.72879314422619 49.0488548278809,2.73087477684021 49.0457382202149,2.76051545143127 49.0429534912111,2.76051545143127 49.0429534912111,2.77397632598883 49.0393829345703,2.76915931701666 49.0338325500489,2.77242636680614 49.0278968811036,2.77242636680614 49.0278968811036,2.76156139373791 49.0207252502443,2.76233148574829 49.0137596130371,2.76233148574829 49.0137596130371,2.75486898422241 49.0105781555176,2.75486898422241 49.0105781555176,2.73075604438787 49.015884399414,2.72113156318676 49.00830078125))0.0006POINT(2.7417182127635242 49.02865155537928)
35637POLYGON((6.17720127105724 47.0696678161622,6.17756175994879 47.0628013610841,6.17314863204956 47.0610847473146,6.14392185211182 47.0636672973634,6.12906074523926 47.0613937377931,6.12863111495983 47.0548934936525,6.12863111495983 47.0548934936525,6.15750360488903 47.0262832641603,6.15750360488903 47.0262832641603,6.1705317497254 47.0262107849122,6.1705317497254 47.0262107849122,6.18497991561895 47.0394821166993,6.2053270339967 47.0480766296387,6.2053270339967 47.0480766296387,6.1943039894104 47.053825378418,6.18494796752924 47.0518913269044,6.18213176727295 47.0546646118165,6.18509197235119 47.0643768310547,6.18509197235119 47.0643768310547,6.17720127105724 47.0696678161622))0.0006POINT(6.170601518530657 47.050429494757495)
22329POLYGON((-0.245671510696354 45.1082153320313,-0.221237495541573 45.1077613830567,-0.221237495541573 45.1077613830567,-0.231787964701653 45.0963363647461,-0.215350285172462 45.0846176147462,-0.228431761264801 45.0516624450684,-0.228431761264801 45.0516624450684,-0.242242321372032 45.0517387390138,-0.250472366809845 45.0402259826661,-0.250472366809845 45.0402259826661,-0.260827302932682 45.0456085205078,-0.271696478128376 45.0408401489258,-0.271696478128376 45.0408401489258,-0.274181902408543 45.0470390319824,-0.2875936627388 45.0561332702636,-0.296540230512619 45.0573539733887,-0.304172188043538 45.0539665222169,-0.304172188043538 45.0539665222169,-0.306554943323022 45.0568504333497,-0.303077280521393 45.0629806518555,-0.287763327360153 45.0691833496095,-0.287763327360153 45.0691833496095,-0.28054603934288 45.0738410949708,-0.278229713439885 45.0874786376954,-0.250992029905319 45.1023292541504,-0.245671510696354 45.1082153320313))0.0006POINT(-0.2640456968545687 45.06631210327154)
73842POLYGON((15.3084707260132 45.5386619567872,15.313985824585 45.5433883666992,15.3217000961304 45.5440330505371,15.3236284255983 45.5491752624513,15.3316745758057 45.554744720459,15.3316745758057 45.554744720459,15.3317031860353 45.5595817565919,15.3288125991822 45.567943572998,15.3307514190674 45.5798492431641,15.328335762024 45.5868873596192,15.3310222625733 45.5904579162598,15.3357076644897 45.5918807983398,15.3447294235231 45.5917167663574,15.3550930023194 45.5935554504395,15.3611640930177 45.5935592651367,15.3640956878663 45.5921554565431,15.3749799728394 45.582389831543,15.382848739624 45.5794715881349,15.3884353637695 45.5797271728516,15.3949413299561 45.5835456848145,15.399868965149 45.5882530212403,15.4047193527222 45.5907287597656,15.4022283554078 45.5952949523927,15.3975915908813 45.5983047485351,15.4015064239503 45.6046981811524,15.4015064239503 45.6046981811524,15.4086618423462 45.6140556335449,15.4101419448852 45.6213111877441,15.4186611175537 45.6265678405763,15.4221725463867 45.6342086791992,15.4269638061523 45.6393814086915,15.4266920089722 45.6421661376953,15.4224929809571 45.6513252258301,15.4197397232056 45.654109954834,15.4135961532593 45.6555824279786,15.4084720611572 45.6483879089355,15.404302597046 45.6462593078614,15.4006309509278 45.6458778381349,15.3862419128418 45.6483573913575,15.3833646774292 45.6493186950683,15.3786125183105 45.652847290039,15.3786125183105 45.652847290039,15.3552942276002 45.6562118530274,15.3375492095947 45.656421661377,15.3281402587891 45.6515464782715,15.332441329956 45.6464233398438,15.3261032104493 45.6433372497559,15.3125238418579 45.6410026550294,15.3013353347778 45.6339759826661,15.3008003234863 45.6249084472657,15.2958402633668 45.61722946167,15.2823295593262 45.6134872436524,15.2791662216187 45.6046905517579,15.2910928726197 45.5943412780763,15.2929763793946 45.5909080505372,15.2929763793946 45.5909080505372,15.297896385193 45.5819396972656,15.2935523986816 45.5690574645996,15.2940845489502 45.5587158203126,15.2986373901368 45.5484199523925,15.3068170547485 45.5393943786622,15.3084707260132 45.5386619567872))0.0006POINT(15.354427744130662 45.60467166587957)
54278POLYGON((5.19960165023815 45.9290771484375,5.20830154418951 45.9261512756348,5.21249914169323 45.9200973510742,5.21055507659906 45.9170112609864,5.22881841659552 45.901382446289,5.24604082107544 45.896240234375,5.24604082107544 45.896240234375,5.24859285354614 45.8945960998536,5.24859285354614 45.8945960998536,5.2239990234375 45.8916320800782,5.20883178710949 45.8823890686036,5.21045255661016 45.8790588378906,5.21045255661016 45.8790588378906,5.20240116119379 45.8831825256348,5.18662023544312 45.9009170532227,5.18060493469244 45.9135742187501,5.18060493469244 45.9135742187501,5.17592048645014 45.9250221252442,5.18069791793829 45.930274963379,5.18069791793829 45.930274963379,5.19217920303356 45.9248733520508,5.19960165023815 45.9290771484375))0.0006POINT(5.208690756843238 45.9061535426549)