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
12527POLYGON((13.9120779037475 42.2642631530762,13.898783683777 42.2660408020021,13.898783683777 42.2660408020021,13.8562030792237 42.2635765075685,13.8433389663697 42.2574424743653,13.8433389663697 42.2574424743653,13.8447380065918 42.2517890930176,13.8430213928223 42.234302520752,13.8470697402954 42.2209053039551,13.8500699996949 42.2197914123536,13.8568754196167 42.2247581481934,13.860040664673 42.2245635986329,13.860040664673 42.2245635986329,13.8879508972169 42.2366790771485,13.8974723815919 42.2420463562012,13.9050588607788 42.2418174743653,13.9037103652955 42.2560348510743,13.9052066802979 42.2599029541016,13.9120779037475 42.2642631530762))0.0006POINT(13.87298785315626 42.24510892232266)
22802POLYGON((0.484953492879868 44.435890197754,0.490360617637577 44.4423637390137,0.490360617637577 44.4423637390137,0.479611456394196 44.4485740661622,0.475880861282405 44.4614486694337,0.444774627685661 44.4693603515625,0.434356600046158 44.4758110046387,0.433842897415161 44.4691162109376,0.433842897415161 44.4691162109376,0.434555977583045 44.4628295898439,0.422753274440765 44.4524765014649,0.422041118145046 44.439136505127,0.422041118145046 44.439136505127,0.430747240781898 44.4378814697266,0.430747240781898 44.4378814697266,0.445524632930812 44.4374580383301,0.445524632930812 44.4374580383301,0.454848974943275 44.4380912780762,0.459867864847297 44.4324226379396,0.476079016924018 44.4378585815431,0.484953492879868 44.435890197754))0.0006POINT(0.45063575804238376 44.44833374023443)
32505POLYGON((1.16567003726959 46.8840141296387,1.16559255123138 46.8638191223145,1.17450201511394 46.8608932495118,1.18444693088537 46.8615074157715,1.2040914297105 46.8511543273926,1.2040914297105 46.8511543273926,1.20422589778894 46.8506584167481,1.20422589778894 46.8506584167481,1.19707179069519 46.8463134765625,1.19884538650518 46.8261337280274,1.19884538650518 46.8261337280274,1.19578635692602 46.8234291076661,1.15661799907696 46.826976776123,1.14903831481934 46.8226127624512,1.14903831481934 46.8226127624512,1.13097822666174 46.8349571228027,1.11255693435663 46.8559188842774,1.11294233798992 46.8840446472169,1.10639917850494 46.8934745788575,1.10639917850494 46.8934745788575,1.11658918857569 46.9072151184081,1.11658918857569 46.9072151184081,1.12990486621851 46.9040718078614,1.13378691673284 46.9100074768067,1.13378691673284 46.9100074768067,1.14312160015106 46.9079780578613,1.15232515335077 46.8924560546875,1.15723347663885 46.8922195434571,1.16567003726959 46.8840141296387))0.0006POINT(1.1573108179228855 46.866468293326264)
37374POLYGON((1.0603405237199 49.1428031921388,1.03132867813122 49.1432914733887,1.03132867813122 49.1432914733887,1.0050755739212 49.1330032348632,1.0050755739212 49.1330032348632,1.00582969188696 49.1265869140626,0.999969601631221 49.1214790344238,0.999969601631221 49.1214790344238,1.03235721588146 49.1198272705079,1.03235721588146 49.1198272705079,1.05016446113581 49.1247138977051,1.0656751394273 49.1354064941407,1.0656751394273 49.1354064941407,1.06459784507757 49.1414947509766,1.0603405237199 49.1428031921388))0.0006POINT(1.0321246385575031 49.13154384068084)
40334POLYGON((1.96245503425598 45.0812301635742,1.95530605316162 45.0931205749513,1.95961546897888 45.1088485717775,1.95961546897888 45.1088485717775,1.94938278198248 45.137062072754,1.94938278198248 45.137062072754,1.9387965202331 45.1317596435546,1.92909014225017 45.1377258300781,1.92909014225017 45.1377258300781,1.92492437362677 45.1346969604493,1.92492437362677 45.1346969604493,1.93004512786871 45.125057220459,1.91759371757513 45.1098709106445,1.89366841316229 45.1082115173339,1.89366841316229 45.1082115173339,1.88895738124859 45.102752685547,1.89039206504827 45.0964546203614,1.89039206504827 45.0964546203614,1.90367746353144 45.0919303894044,1.91721141338348 45.0954666137696,1.92540204524988 45.0919914245605,1.93355119228369 45.0792999267579,1.92913174629211 45.0731430053712,1.93186962604528 45.0595359802247,1.93186962604528 45.0595359802247,1.94391596317291 45.0641441345214,1.94437348842632 45.0742416381837,1.95840942859644 45.075294494629,1.96245503425598 45.0812301635742))0.0006POINT(1.9288111541952737 45.10194192613879)
49688POLYGON((3.92396187782293 49.6732711791993,3.91881847381592 49.6790962219239,3.89355540275574 49.6773147583009,3.88921093940735 49.6791267395021,3.89676880836487 49.6907997131347,3.88436293602001 49.6967124938964,3.88436293602001 49.6967124938964,3.89098072052013 49.7020645141602,3.89098072052013 49.7020645141602,3.90653300285339 49.7016983032227,3.93093061447149 49.696346282959,3.93093061447149 49.696346282959,3.94272637367254 49.6921844482423,3.94272637367254 49.6921844482423,3.95396852493292 49.6799850463868,3.95396852493292 49.6799850463868,3.94286370277405 49.6733131408691,3.93895673751837 49.675464630127,3.92396187782293 49.6732711791993))0.0006POINT(3.9175892935859338 49.68803723653163)
1400574POLYGON((-5.99194478988647 40.6842727661133,-5.995934009552 40.6877174377443,-5.99760723114014 40.6870460510254,-5.99479913711548 40.6843070983886,-5.99674701690668 40.6831855773926,-6.00328588485718 40.6862754821777,-6.00998020172113 40.6817169189454,-6.01116514205933 40.6791267395021,-6.01758813858032 40.6765022277832,-6.02160120010376 40.6791496276855,-6.02058696746826 40.6813545227051,-6.02595186233521 40.6845932006835,-6.02879905700678 40.6894645690918,-6.03265285491938 40.6912269592285,-6.04082822799683 40.6932449340821,-6.04547119140625 40.690990447998,-6.04978084564209 40.6939163208009,-6.05445718765253 40.694004058838,-6.0622501373291 40.6966781616212,-6.06174612045288 40.7061042785645,-6.05749082565308 40.7062149047852,-6.04844093322748 40.711254119873,-6.04091691970825 40.7222366333008,-6.03875017166138 40.721435546875,-6.03638601303101 40.7272453308105,-6.01609516143793 40.7380180358887,-5.99854612350464 40.7369537353516,-5.99456596374506 40.7340126037598,-5.98890495300293 40.7371673583985,-5.98562479019159 40.7353248596192,-5.96641206741327 40.7370376586913,-5.95999622344971 40.7352027893068,-5.96321678161621 40.7314720153809,-5.97687816619873 40.7274284362793,-5.97972488403315 40.7243537902831,-5.9719090461731 40.7150077819824,-5.96332788467407 40.7083740234376,-5.96140718460083 40.709083557129,-5.95581388473511 40.7059860229492,-5.95595979690552 40.7015304565431,-5.96102905273438 40.6949424743653,-5.96353387832642 40.6951065063477,-5.96136379241943 40.6918296813965,-5.96369504928583 40.6883354187012,-5.96836519241333 40.6866569519043,-5.97046709060669 40.6817779541016,-5.97366380691523 40.6818389892579,-5.97724914550776 40.6842575073242,-5.98393392562866 40.6829223632813,-5.99194478988647 40.6842727661133))0.0006POINT(-6.00095603903944 40.70212009974891)
68794POLYGON((12.9879999160766 50.6964416503907,12.9814071655274 50.6977348327637,12.9730157852173 50.6974830627443,12.9711809158325 50.7002944946289,12.9683847427368 50.7010383605958,12.9678220748903 50.7005920410157,12.9710960388183 50.6970901489258,12.9517583847046 50.6956748962403,12.9513673782349 50.6949729919435,12.9541749954224 50.6928405761719,12.9461488723754 50.6905899047852,12.939642906189 50.6904525756837,12.9383897781372 50.688835144043,12.9383897781372 50.688835144043,12.9340143203736 50.6907997131349,12.9294118881225 50.6957778930665,12.9269123077393 50.6943283081056,12.9239912033081 50.6953887939454,12.9206647872925 50.6941070556642,12.9192132949829 50.6964492797851,12.9247322082521 50.6987304687501,12.9216737747194 50.7018013000489,12.9129152297975 50.7010192871095,12.9035549163819 50.7039604187013,12.8992176055908 50.7009277343751,12.8992176055908 50.7009277343751,12.8985061645509 50.7019958496094,12.8935289382935 50.7022323608398,12.8896465301514 50.7047538757324,12.8910627365113 50.7069396972656,12.8946046829225 50.7069015502931,12.8949375152589 50.7100715637208,12.9011373519899 50.7107009887696,12.9011373519899 50.7107009887696,12.9023723602295 50.7060546875,12.904242515564 50.7051963806152,12.90655708313 50.7063636779786,12.9058341979982 50.7162818908692,12.9123764038087 50.7177505493165,12.9135599136353 50.7211723327637,12.9240045547486 50.7215766906738,12.9258995056152 50.7157630920411,12.9274082183838 50.7170639038086,12.9276695251465 50.714599609375,12.9297580718995 50.7154960632324,12.9288606643677 50.718692779541,12.9295387268066 50.7221870422364,12.9339342117309 50.7221603393556,12.9334096908569 50.7270584106446,12.9383907318115 50.7265663146973,12.9351406097412 50.7300643920898,12.9376249313355 50.732551574707,12.9392700195313 50.7317237854004,12.9421377182008 50.7336730957031,12.9442834854127 50.7326545715332,12.9436025619507 50.7280502319337,12.9465017318726 50.7246475219728,12.9536190032959 50.7251358032227,12.9560575485229 50.7286224365235,12.9576282501221 50.7256011962892,12.963872909546 50.7262077331544,12.9662036895753 50.723617553711,12.978973388672 50.7282600402832,12.978973388672 50.7282600402832,12.9834079742433 50.7284278869629,12.9900646209717 50.7223892211913,12.9975566864014 50.7214088439941,12.9977130889894 50.7177047729493,13.000283241272 50.7167015075684,13.0096492767335 50.7160491943361,13.0096492767335 50.7160491943361,13.0005655288697 50.7145729064942,12.9977025985718 50.70955657959,12.9991331100464 50.7037010192872,12.9927396774293 50.6986618041993,12.9879999160766 50.6964416503907))0.0006POINT(12.942493731180873 50.71066223144534)
37451POLYGON((1.42629706859594 48.8957824707031,1.40210556983953 48.9070396423341,1.40067732334143 48.9166603088379,1.40067732334143 48.9166603088379,1.43116152286535 48.9213180541992,1.43116152286535 48.9213180541992,1.4479593038559 48.9246406555176,1.4479593038559 48.9246406555176,1.46056759357447 48.909538269043,1.46056759357447 48.909538269043,1.46143448352825 48.8996047973633,1.46143448352825 48.8996047973633,1.46305823326117 48.8963584899903,1.45836782455456 48.8948936462402,1.43909490108496 48.8984489440919,1.42629706859594 48.8957824707031))0.0006POINT(1.4395016034444639 48.909069824218776)
35330POLYGON((9.34604740142828 42.5450248718262,9.36203193664551 42.5249862670898,9.3912878036499 42.5220260620118,9.3912878036499 42.5220260620118,9.40076446533209 42.5215034484863,9.40076446533209 42.5215034484863,9.40293312072765 42.5187110900879,9.39624118804943 42.5146141052246,9.39303207397467 42.505470275879,9.38884258270275 42.5046157836914,9.38462924957287 42.5098800659181,9.38462924957287 42.5098800659181,9.3677101135255 42.5053100585939,9.34173583984375 42.5104598999025,9.33499336242681 42.5059547424318,9.33499336242681 42.5059547424318,9.3339147567749 42.5355186462403,9.34604740142828 42.5450248718262))0.0006POINT(9.373872869155047 42.51667291977832)