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
73889POLYGON((16.2453441619873 45.6082191467286,16.2380924224854 45.6189002990723,16.2372817993165 45.6264533996582,16.2354507446289 45.6305465698242,16.2314586639405 45.6327857971191,16.2164382934571 45.6354179382324,16.2137756347657 45.6367263793946,16.210777282715 45.6417579650879,16.2100238800049 45.6484413146973,16.2060642242433 45.6551551818848,16.1928977966309 45.6652336120606,16.1860752105712 45.6689147949219,16.1806793212892 45.6777572631837,16.1772956848145 45.6909408569337,16.1622333526611 45.708610534668,16.1541175842285 45.7120628356935,16.1528167724611 45.7135887145997,16.1529712677003 45.7154197692872,16.1561164855958 45.720069885254,16.1574459075928 45.7278442382812,16.1683387756349 45.739631652832,16.1786460876466 45.741985321045,16.1871356964112 45.7422561645509,16.2086658477784 45.7378005981446,16.2086658477784 45.7378005981446,16.2018966674805 45.7345352172852,16.1957855224609 45.7302246093751,16.1943492889405 45.7275276184081,16.1946468353272 45.7251815795898,16.1983451843261 45.7205848693848,16.206003189087 45.7167587280273,16.2109909057618 45.7105522155761,16.2119750976562 45.707202911377,16.210699081421 45.7015686035157,16.2115020751954 45.6992568969727,16.2180004119874 45.6960334777833,16.2270526885987 45.6942520141602,16.2298831939698 45.6923141479493,16.2311000823975 45.6891136169434,16.2308006286621 45.6768836975098,16.2319221496582 45.6730728149413,16.236692428589 45.671241760254,16.2517280578614 45.6712265014648,16.2583923339844 45.6718940734863,16.2701282501221 45.6748085021973,16.2701282501221 45.6748085021973,16.2718048095704 45.6605415344239,16.2764625549317 45.6517715454102,16.2785396575928 45.6425933837891,16.2836418151855 45.6359062194825,16.2836418151855 45.6359062194825,16.2848739624023 45.6338844299316,16.2847175598146 45.631404876709,16.2794265747071 45.6234474182129,16.2726078033448 45.6200561523438,16.262981414795 45.6217308044434,16.2569332122802 45.6204223632812,16.2539138793946 45.6169319152832,16.2560596466066 45.6113700866699,16.2560596466066 45.6113700866699,16.2453441619873 45.6082191467286))0.0006POINT(16.222708257039447 45.67517833709719)
67299POLYGON((9.42034912109375 49.2350196838379,9.42135047912598 49.2400703430177,9.42070770263672 49.2417716979982,9.41427707672119 49.246036529541,9.4156484603883 49.2469367980958,9.41493511199957 49.2474060058595,9.41545391082764 49.2484855651855,9.42029666900646 49.2495384216309,9.42308044433599 49.2538833618165,9.42651653289795 49.2548599243165,9.42578792572016 49.2579307556153,9.42746353149414 49.2592239379884,9.42259788513184 49.261661529541,9.42521190643316 49.2665100097656,9.42512416839605 49.26859664917,9.4273509979248 49.270450592041,9.4280939102174 49.2728691101075,9.43335723876959 49.2767181396485,9.43252086639416 49.2778434753419,9.43396663665783 49.2789993286133,9.43274879455566 49.2830429077149,9.43394184112543 49.2832336425782,9.43551063537603 49.2819366455079,9.44051647186285 49.2818946838379,9.44426441192627 49.2834396362306,9.44426441192627 49.2834396362306,9.44809436798096 49.2793273925781,9.44488525390619 49.2758178710939,9.4486665725708 49.2751884460449,9.44751453399658 49.2725486755371,9.44946002960205 49.2678184509277,9.44946002960205 49.2678184509277,9.45435333251959 49.2640571594239,9.45839118957525 49.26420211792,9.46599102020264 49.2559623718262,9.47504997253418 49.2584571838379,9.47830104827881 49.2555236816407,9.47818279266357 49.2526741027833,9.47313308715826 49.2516632080078,9.47720527648926 49.2508277893066,9.4783878326416 49.2475395202636,9.47759056091314 49.2423858642579,9.46183681488031 49.239559173584,9.46194648742676 49.2351341247558,9.46736431121832 49.2348861694336,9.46661853790283 49.2337760925294,9.4743595123291 49.2308845520021,9.47872924804693 49.2308158874512,9.47975921630871 49.2262916564942,9.48318290710444 49.2261352539062,9.48315143585199 49.2250175476075,9.49252414703375 49.2234115600585,9.49976253509533 49.220760345459,9.49719810485846 49.2179679870605,9.50016403198242 49.2166633605957,9.50444984436029 49.2165908813477,9.50768756866461 49.225383758545,9.50290775299067 49.2247123718262,9.50222778320318 49.2263946533204,9.50685501098633 49.2277946472169,9.50618743896484 49.232852935791,9.50814628601086 49.2331428527833,9.50980186462408 49.2354583740234,9.51920795440668 49.2383575439454,9.51906585693371 49.2372589111329,9.52246570587158 49.2355880737306,9.53224754333496 49.2341537475586,9.53270435333263 49.2326545715331,9.5370912551881 49.233097076416,9.5370912551881 49.233097076416,9.53876113891607 49.2299270629883,9.55341339111322 49.2210731506348,9.56115436553966 49.2184753417969,9.54785633087158 49.2124633789063,9.5526113510133 49.2108840942383,9.56165218353271 49.2140998840333,9.56350994110113 49.2124481201172,9.55817699432379 49.2106437683106,9.56049633026134 49.2092666625978,9.55075645446777 49.2053604125977,9.54719924926769 49.2019691467285,9.54671764373785 49.198570251465,9.551344871521 49.1970901489257,9.55123519897455 49.1964073181153,9.55350017547602 49.1963996887208,9.55214786529541 49.1939582824707,9.55598735809326 49.1815223693849,9.56677436828625 49.1800651550293,9.57490348815929 49.1775856018066,9.57814121246344 49.1754913330079,9.58629894256586 49.1750907897949,9.5920581817627 49.1759719848633,9.60565090179438 49.1739959716798,9.60565090179438 49.1739959716798,9.6155052185058 49.1708259582521,9.61661052703869 49.1681632995607,9.61313343048101 49.1580696105958,9.60870170593262 49.1588897705079,9.60298824310297 49.1563606262206,9.60311508178705 49.1539688110353,9.60311508178705 49.1539688110353,9.59221839904785 49.1507148742676,9.59038829803472 49.1539573669434,9.58333492279047 49.1548995971681,9.57571601867681 49.1531066894532,9.5711030960083 49.1505432128906,9.5662345886231 49.1533546447754,9.56182956695551 49.1535148620605,9.5551118850708 49.1554908752442,9.55124950408936 49.1587142944337,9.55308437347412 49.1602592468262,9.54904079437256 49.1636161804199,9.54204845428461 49.1641349792482,9.54212474823004 49.1672019958497,9.53975772857666 49.1696205139161,9.54336357116705 49.1794204711915,9.53575611114513 49.1872596740722,9.53165340423578 49.1879196166993,9.53083324432373 49.1918411254883,9.52640342712408 49.1930084228516,9.51886940002447 49.1909179687501,9.52066135406494 49.1851501464844,9.5200891494751 49.1822662353516,9.51202487945568 49.1833763122559,9.51117134094238 49.1848068237305,9.49982166290283 49.1855163574219,9.49828052520752 49.1863670349121,9.49544334411621 49.1848907470703,9.49209976196283 49.185977935791,9.48282051086431 49.1847419738771,9.48014068603527 49.1875343322754,9.46940231323237 49.1826934814454,9.46592140197748 49.1792793273926,9.45841217041027 49.178768157959,9.45841217041027 49.178768157959,9.45801830291754 49.1804924011231,9.45424461364746 49.1817626953126,9.45671939849865 49.1866073608398,9.45478534698486 49.1871910095215,9.45583629608149 49.1919174194337,9.45564937591558 49.1999130249025,9.44924259185797 49.1990852355956,9.45062732696539 49.2004127502443,9.44661140441906 49.2020301818848,9.44460964202887 49.2056732177734,9.44291400909418 49.2053337097169,9.44196033477778 49.2081298828126,9.44357490539562 49.2083969116211,9.44215106964106 49.2125854492188,9.43847560882574 49.2130012512208,9.43847560882574 49.2130012512208,9.4394969940185 49.2158966064454,9.44338989257812 49.2180862426758,9.44788360595709 49.2185516357422,9.45220947265625 49.2204780578613,9.44999790191656 49.2211151123046,9.44833564758312 49.2236633300781,9.44059085845947 49.2273139953613,9.43750858306885 49.2275924682618,9.43186283111578 49.2263603210449,9.42580318450922 49.2276878356935,9.42440509796137 49.2349433898925,9.42034912109375 49.2350196838379))0.0006POINT(9.495210553392969 49.2153784669476)
1398520POLYGON((-5.56675004959106 40.2910614013673,-5.57293796539301 40.2904815673829,-5.5781569480896 40.292251586914,-5.5859260559082 40.2979164123535,-5.59941911697382 40.3123397827148,-5.59148693084711 40.3187484741212,-5.58670377731318 40.3257026672364,-5.57184982299799 40.3374481201171,-5.55933618545527 40.3320960998536,-5.55425310134888 40.3246688842773,-5.5606369972229 40.3027191162111,-5.5678601264953 40.2995796203614,-5.56675004959106 40.2910614013673))0.0006POINT(-5.574609756469694 40.31041781107589)
72932POLYGON((12.5346260070801 47.512966156006,12.5416431427003 47.5152740478516,12.5474557876587 47.51570892334,12.562355041504 47.5121688842773,12.569206237793 47.5095596313477,12.5733919143678 47.5038604736329,12.5814399719238 47.4833831787109,12.5814399719238 47.4833831787109,12.5454349517823 47.4891815185547,12.537844657898 47.4919967651368,12.5328445434571 47.4961395263672,12.5307521820068 47.5002326965332,12.5346260070801 47.512966156006))0.0006POINT(12.553202867507977 47.501154581705755)
15879POLYGON((9.33455753326422 46.0809783935547,9.33429431915289 46.0800094604493,9.33429431915289 46.0800094604493,9.34822177886957 46.075870513916,9.34822177886957 46.075870513916,9.36616706848139 46.0850944519044,9.37994003295893 46.096118927002,9.37994003295893 46.096118927002,9.36487579345709 46.0991287231446,9.35774803161621 46.0931854248047,9.35774803161621 46.0931854248047,9.34589576721203 46.0844306945801,9.34207344055181 46.087329864502,9.33851814270014 46.0856552124023,9.33455753326422 46.0809783935547))0.0006POINT(9.352321147918705 46.08664185660229)
48520POLYGON((-1.09582841396326 47.8799285888672,-1.08983588218678 47.8676986694336,-1.08983588218678 47.8676986694336,-1.05526900291432 47.8664779663087,-1.04679310321808 47.873348236084,-1.03758633136749 47.8718719482422,-1.03758633136749 47.8718719482422,-1.02756357192987 47.8917617797852,-1.01157629489893 47.9055480957032,-1.01168441772455 47.9192047119141,-1.01168441772455 47.9192047119141,-1.02364599704742 47.9252662658692,-1.04339849948883 47.9274253845216,-1.0517441034317 47.9310150146484,-1.0517441034317 47.9310150146484,-1.06614542007446 47.938533782959,-1.08013117313385 47.9357261657715,-1.09451377391815 47.9387664794923,-1.09451377391815 47.9387664794923,-1.0962598323822 47.9297752380371,-1.10253703594208 47.92529296875,-1.10253703594208 47.92529296875,-1.09305810928345 47.9115753173828,-1.10178470611572 47.9044761657715,-1.10178470611572 47.9044761657715,-1.10036134719843 47.9011459350587,-1.08076500892633 47.898838043213,-1.07166850566858 47.8831558227539,-1.07541084289545 47.8807754516603,-1.09582841396326 47.8799285888672))0.0006POINT(-1.0671464698067725 47.90572186174067)
53993POLYGON((5.0864686965943 43.846794128418,5.10286045074463 43.83895111084,5.11840629577631 43.8251838684082,5.1233053207398 43.8151397705078,5.1233053207398 43.8151397705078,5.11132383346563 43.8206062316895,5.09233379364019 43.8218421936036,5.09233379364019 43.8218421936036,5.07194948196411 43.829559326172,5.07789611816406 43.8446884155273,5.0864686965943 43.846794128418))0.0006POINT(5.100018310546902 43.82797470092778)
48390POLYGON((-0.463353395462036 47.0818710327148,-0.491782009601593 47.0828514099122,-0.515130400657654 47.077938079834,-0.515130400657654 47.077938079834,-0.507524430751801 47.0826911926269,-0.508612155914307 47.096565246582,-0.488254964351597 47.1068420410156,-0.486850589513779 47.1102256774902,-0.49359530210495 47.1155128479004,-0.49359530210495 47.1155128479004,-0.486810952424946 47.1206283569337,-0.509647011756897 47.1335258483887,-0.509647011756897 47.1335258483887,-0.480022817850056 47.1330604553223,-0.467698693275452 47.1381340026856,-0.453494966030121 47.1345329284669,-0.444002538919392 47.122386932373,-0.449773997068405 47.1131401062012,-0.436948597431126 47.1078453063966,-0.436948597431126 47.1078453063966,-0.445090025663319 47.096248626709,-0.46083790063858 47.0883102416993,-0.463353395462036 47.0818710327148))0.0006POINT(-0.4793069118803018 47.10805147344418)
53160POLYGON((6.54696607589722 43.9216346740724,6.5783953666687 43.947006225586,6.5783953666687 43.947006225586,6.59706783294678 43.9316902160645,6.60145139694214 43.9324111938478,6.6080780029298 43.9451293945313,6.628167629242 43.9539756774903,6.628167629242 43.9539756774903,6.63710021972656 43.9514884948731,6.64268159866333 43.9459419250489,6.64424848556519 43.932415008545,6.65777540206903 43.9295120239259,6.65777540206903 43.9295120239259,6.64870691299438 43.9274711608887,6.64949178695679 43.900390625,6.63509464263922 43.8918800354005,6.63509464263922 43.8918800354005,6.62719869613653 43.8889732360841,6.62021398544312 43.8807830810547,6.62021398544312 43.8807830810547,6.60659694671631 43.878360748291,6.57871580123896 43.8847732543945,6.56894540786749 43.8922538757325,6.56894540786749 43.8922538757325,6.55911493301397 43.9114036560059,6.54696607589722 43.9216346740724))0.0006POINT(6.612984142303483 43.91771621704109)
21521POLYGON((0.874470889568443 45.3874435424805,0.869701921939964 45.3747787475586,0.874397158622799 45.368968963623,0.886262714862937 45.3745155334473,0.904991567134857 45.377082824707,0.904991567134857 45.377082824707,0.92393559217453 45.379753112793,0.935625910758972 45.395378112793,0.935625910758972 45.395378112793,0.928645670413971 45.4042930603027,0.92374283075327 45.4040946960449,0.901701390743256 45.3968849182129,0.887582480907497 45.3976554870606,0.874470889568443 45.3874435424805))0.0006POINT(0.9039750465980249 45.38717768742488)