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
44844POLYGON((1.34319174289715 43.7072715759277,1.3403698205949 43.7006149291993,1.34767591953283 43.6916084289552,1.34586405754101 43.6847686767579,1.35094428062445 43.678897857666,1.35094428062445 43.678897857666,1.35961210727697 43.664608001709,1.35961210727697 43.664608001709,1.3589621782304 43.6626281738282,1.3589621782304 43.6626281738282,1.34577059745794 43.6622314453126,1.33180046081543 43.6707038879395,1.31028306484234 43.6662483215331,1.31028306484234 43.6662483215331,1.30916702747351 43.6767616271973,1.29836094379425 43.6923866271972,1.29836094379425 43.6923866271972,1.29664897918701 43.6944847106933,1.29664897918701 43.6944847106933,1.34319174289715 43.7072715759277))0.0006POINT(1.3322875123275588 43.679603576660156)
32358POLYGON((1.76825499534618 46.90140914917,1.74722313880932 46.9035949707032,1.74722313880932 46.9035949707032,1.72836673259735 46.9053878784181,1.71085286140442 46.9164047241212,1.71085286140442 46.9164047241212,1.69727838039404 46.9065437316895,1.68034982681274 46.8857383728028,1.67558193206793 46.8691062927246,1.67558193206793 46.8691062927246,1.68758141994488 46.8626708984376,1.7029780149461 46.8715820312501,1.70802962779999 46.8711853027344,1.71657228469849 46.862548828125,1.72235548496258 46.845573425293,1.72235548496258 46.845573425293,1.73074352741236 46.8494300842285,1.74529922008526 46.8675727844238,1.75726056098949 46.8738632202149,1.76574325561529 46.8899917602539,1.76351296901709 46.9002227783204,1.76825499534618 46.90140914917))0.0006POINT(1.7220951261975128 46.8817859831311)
20909POLYGON((8.06734561920172 48.9942970275879,8.05976581573486 48.9902801513673,8.05493259429937 48.9963340759277,8.00850105285656 48.9979133605957,7.9984564781189 48.9911613464357,8.00631904602056 48.9866523742676,8.00631904602056 48.9866523742676,8.02665996551508 48.971076965332,8.02665996551508 48.971076965332,8.04531574249273 48.9748802185059,8.04531574249273 48.9748802185059,8.06087684631353 48.9846916198732,8.06734561920172 48.9942970275879))0.0006POINT(8.03387232621514 48.984991391499875)
1405612POLYGON((-0.872870028018951 42.831943511963,-0.876293003559113 42.8287582397462,-0.882645010948067 42.8333702087402,-0.887647986411935 42.8327140808107,-0.911508023738804 42.840187072754,-0.911668002605325 42.8424224853516,-0.922523021697998 42.8481864929199,-0.933763980865479 42.8450736999512,-0.953364014625549 42.853298187256,-0.964348018169346 42.8646965026856,-0.966911971569061 42.8653068542482,-0.964851021766606 42.8668899536133,-0.952459990978241 42.8688888549804,-0.935975015163422 42.8830451965333,-0.932421028614044 42.8797531127929,-0.929535984992867 42.8887786865234,-0.930868983268738 42.8965034484863,-0.926618993282204 42.9075126647949,-0.927626013755798 42.9093017578126,-0.925280988216343 42.9167404174806,-0.91812402009964 42.9273109436036,-0.918605029582977 42.9327239990236,-0.913352012634277 42.938045501709,-0.907718002796116 42.9502449035645,-0.898569583892822 42.9579887390137,-0.897500276565495 42.9558410644532,-0.885161995887756 42.9556198120118,-0.864740014076233 42.950954437256,-0.846069991588593 42.95170211792,-0.835877001285496 42.953411102295,-0.820019006729069 42.9510383605957,-0.808800995349884 42.9514541625978,-0.800714194774628 42.9565773010254,-0.7844140529632 42.9642868041992,-0.773862004280033 42.9651527404785,-0.766504108905792 42.9685440063477,-0.752805233001595 42.9669609069825,-0.744222044944763 42.9543762207031,-0.743530988693237 42.9506072998047,-0.733271777629795 42.946159362793,-0.732284545898438 42.9430618286134,-0.734586000442505 42.939868927002,-0.731975972652435 42.9392051696777,-0.733384013175908 42.9331550598145,-0.732011973857823 42.9318389892578,-0.733582973480225 42.9307746887206,-0.726752042770272 42.9208641052246,-0.727500021457615 42.9192619323731,-0.744091987609806 42.9192123413087,-0.745817005634308 42.9219017028809,-0.753443002700692 42.924503326416,-0.783181011676788 42.9217300415039,-0.789822995662632 42.918628692627,-0.788981974124908 42.9171142578126,-0.801097989082336 42.9078483581544,-0.809051990509033 42.9043006896973,-0.813300013542175 42.9040069580078,-0.819064021110478 42.9006729125977,-0.820427000522557 42.8933067321778,-0.81920999288559 42.889217376709,-0.813601016998291 42.888210296631,-0.816231012344304 42.8847999572755,-0.816304028034153 42.878589630127,-0.814686000347137 42.8769187927247,-0.819968998432159 42.8725814819337,-0.818503022193909 42.8693733215332,-0.820967018604279 42.8674964904785,-0.826892971992379 42.8671455383301,-0.837321996688843 42.8615341186524,-0.841256022453251 42.8529472351075,-0.856801986694336 42.846893310547,-0.857221007347107 42.8333854675294,-0.85468202829361 42.8289413452149,-0.85479599237442 42.8235321044922,-0.864663004875183 42.8222312927247,-0.86388099193573 42.8303833007813,-0.872870028018951 42.831943511963))0.0006POINT(-0.8400050927149331 42.900497486716844)
63876POLYGON((8.56466007232677 49.882537841797,8.5528440475465 49.8819847106934,8.5532550811767 49.879421234131,8.54083728790289 49.8770942687989,8.53235912322998 49.8736038208009,8.5226879119873 49.8725509643555,8.5226879119873 49.8725509643555,8.5217218399049 49.8752784729004,8.51782226562506 49.8776092529298,8.51567554473883 49.8816032409668,8.50735473632818 49.8828163146974,8.50421714782721 49.8850212097168,8.50117588043213 49.8893508911133,8.50092124938965 49.8911933898926,8.49595737457287 49.8926086425782,8.49992465972906 49.8949127197266,8.49735164642334 49.8965568542482,8.49717140197748 49.8977966308595,8.50069713592529 49.9001998901367,8.50034427642834 49.9027938842775,8.49795150756847 49.9049797058107,8.50153636932384 49.9066925048829,8.49762439727778 49.9095764160157,8.50111198425293 49.9121398925782,8.49837112426752 49.9156723022462,8.49979877471924 49.915870666504,8.49952220916748 49.9220848083497,8.50066661834717 49.9230575561523,8.50218772888195 49.9226799011232,8.50411796569836 49.9248466491699,8.51080417633062 49.9249916076661,8.51224613189697 49.9301643371583,8.51675319671625 49.9314041137696,8.52069282531738 49.9312362670898,8.52865886688244 49.9401855468749,8.5289068222047 49.9436035156251,8.54088878631586 49.946590423584,8.55083942413324 49.9467773437501,8.55051898956299 49.9491691589356,8.55051898956299 49.9491691589356,8.57371807098389 49.9504356384277,8.5788249969483 49.9435005187989,8.5788249969483 49.9435005187989,8.56607437133783 49.9429054260255,8.5665044784547 49.9337425231935,8.56993293762213 49.9341163635254,8.57085132598888 49.9224967956544,8.56307601928711 49.9213905334474,8.56244087219238 49.9222793579102,8.55763816833502 49.9228019714355,8.55274868011486 49.9206733703613,8.55000686645519 49.9205551147461,8.5506410598756 49.9061317443849,8.5551805496217 49.9062271118165,8.55445098876959 49.8998680114746,8.55979537963862 49.8996887207032,8.56004238128656 49.8956985473634,8.56181526184093 49.8955917358398,8.56238079071056 49.888584136963,8.56540203094488 49.8875923156739,8.56466007232677 49.882537841797))0.0006POINT(8.53206222852075 49.91026929219567)
49899POLYGON((3.23072862625122 49.8975524902344,3.22853326797491 49.9041862487794,3.2078795433045 49.9145774841309,3.21572208404541 49.930233001709,3.21499919891352 49.9369621276856,3.22205758094793 49.9406394958497,3.22205758094793 49.9406394958497,3.22278523445129 49.9351959228517,3.22278523445129 49.9351959228517,3.2269303798675 49.925308227539,3.23646426200867 49.9168357849121,3.25898241996777 49.9075469970704,3.25898241996777 49.9075469970704,3.25703334808361 49.9044075012208,3.25703334808361 49.9044075012208,3.23072862625122 49.8975524902344))0.0006POINT(3.232198301951129 49.92008234659838)
13251POLYGON((16.1406936645508 38.0262527465821,16.1127109527588 38.0255966186523,16.1143188476562 38.0310401916504,16.1123275756837 38.0387496948242,16.1123275756837 38.0387496948242,16.1199073791505 38.0392608642579,16.1200027465821 38.0415039062501,16.1197662353516 38.0445556640626,16.114845275879 38.0521507263185,16.1105976104736 38.0629806518555,16.1121883392334 38.072437286377,16.1116676330567 38.0861930847169,16.1059684753419 38.0923576354982,16.099729537964 38.0961151123048,16.099729537964 38.0961151123048,16.1049633026123 38.0976219177246,16.1116027832032 38.1030044555664,16.1133518218995 38.1054725646973,16.1257820129395 38.1120529174805,16.1590270996094 38.1147689819337,16.1590270996094 38.1147689819337,16.1576385498047 38.1048622131348,16.1576385498047 38.096248626709,16.1512508392335 38.0768051147462,16.1495838165284 38.0673599243164,16.1492595672608 38.0579833984374,16.1492595672608 38.0579833984374,16.1405372619628 38.0596733093262,16.129508972168 38.0557174682617,16.1259422302247 38.0466995239259,16.1275196075439 38.0446968078614,16.1322288513184 38.0419921875,16.136770248413 38.0417060852051,16.1429157257081 38.0442733764648,16.1429157257081 38.0442733764648,16.1431922912599 38.0420837402344,16.1454162597656 38.0398597717286,16.145139694214 38.0384712219238,16.1431922912599 38.03763961792,16.1431922912599 38.0345840454102,16.1448612213136 38.0318069458009,16.1406936645508 38.0262527465821))0.0006POINT(16.13020729437112 38.06235290155182)
180943MULTIPOLYGON(((5.49878787994396 44.115718841553,5.45471668243408 44.1192283630372,5.44951391220098 44.1240997314454,5.44757080078131 44.1367568969727,5.4383687973023 44.1388092041016,5.43575572967529 44.1522483825683,5.42755651474005 44.149150848389,5.41583395004278 44.1546516418458,5.39695024490362 44.152339935303,5.38324069976807 44.1552848815919,5.38664960861212 44.1792716979982,5.38128042221069 44.1923828125001,5.38452911376947 44.2011909484864,5.35579013824463 44.2136001586916,5.33572626113892 44.2043113708496,5.31799554824829 44.2087936401367,5.30362415313721 44.2087974548342,5.303297996521 44.2053947448731,5.28066778182983 44.2197952270508,5.25650882720953 44.2300567626955,5.24853563308722 44.2311210632326,5.2404465675354 44.2308273315432,5.23814964294445 44.2132339477539,5.20877504348761 44.214424133301,5.17560625076294 44.2208671569827,5.15000677108765 44.2352371215821,5.15181398391735 44.238307952881,5.16154766082769 44.2455902099611,5.16053152084362 44.2656173706056,5.14745807647711 44.2691688537597,5.15025329589855 44.2820816040041,5.16554355621349 44.2895812988284,5.17010641098022 44.2987365722659,5.17282676696777 44.3082122802736,5.16883945465082 44.3141250610353,5.16643428802496 44.3148574829102,5.15326309204096 44.3101806640627,5.1495294570924 44.3006820678712,5.10954713821411 44.2805480957033,5.07651185989374 44.2840843200685,5.06056451797491 44.3081398010254,5.02950048446661 44.29789352417,5.00247907638555 44.2860908508302,4.98959445953369 44.2857666015627,4.94283151626598 44.2690429687503,4.93291044235229 44.2621536254884,4.89703989028942 44.2584190368653,4.90128278732311 44.2642784118655,4.88025045394903 44.2617683410646,4.85709428787231 44.2459907531741,4.82534170150763 44.2284469604492,4.81344842910767 44.2324256896975,4.81251239776611 44.2580184936523,4.8039984703064 44.2692070007326,4.80456352233892 44.303897857666,4.79590034484869 44.3051109313967,4.78092908859264 44.3174552917482,4.7719402313233 44.3175544738771,4.76299524307257 44.3250999450684,4.72166299819946 44.3265914916993,4.7132186889649 44.3240051269531,4.71301698684692 44.3206481933596,4.67988395690929 44.3206939697266,4.65061521530151 44.3298072814943,4.65061521530151 44.3298072814943,4.65318155288696 44.2948074340821,4.64922380447388 44.2703590393066,4.64922380447388 44.2703590393066,4.65147876739502 44.2591514587405,4.67736005783092 44.2349739074708,4.67293262481695 44.2186012268068,4.67365694046032 44.2147102355959,4.68189334869379 44.2117424011232,4.69993591308605 44.2161064147952,4.70859527587891 44.2134971618654,4.71029758453381 44.2068367004396,4.70383930206305 44.1976623535157,4.7083158493042 44.191722869873,4.72111654281616 44.1880111694335,4.72006368637091 44.1780281066896,4.71625089645386 44.1760444641116,4.71872472763062 44.1523818969728,4.7181334495545 44.140678405762,4.70508193969727 44.1081733703614,4.71678543090826 44.0947952270508,4.72321319580089 44.0793533325195,4.72781896591198 44.0784530639649,4.74833917617809 44.0870590209962,4.75772094726574 44.0879325866702,4.76003503799433 44.0783462524414,4.76288700103765 44.0748672485354,4.78680753707886 44.0643539428712,4.78741025924688 44.0549163818361,4.81364631652838 44.0340423583987,4.82028961181652 44.0170135498049,4.83489799499517 44.0154647827151,4.84225416183477 44.0111007690432,4.84311819076549 44.0004196166994,4.84534406661993 43.9955940246583,4.84094142913818 43.9859161376955,4.81296682357794 43.9880065917971,4.81017780303955 43.9779167175292,4.814368724823 43.9646759033203,4.79198122024536 43.9522705078125,4.77728796005249 43.9381980895999,4.74945068359375 43.9314651489257,4.73906135559088 43.9240684509278,4.73906135559088 43.9240684509278,4.81097364425665 43.9142761230472,4.85480546951294 43.9107933044434,4.88133478164667 43.901565551758,4.88133478164667 43.901565551758,4.90294551849365 43.8876686096194,4.92200851440435 43.8867568969727,4.96965312957769 43.8697433471682,4.99765110015875 43.8448562622071,5.02772140502941 43.8285827636719,5.03535366058355 43.8201408386233,5.04262447357183 43.8065032958987,5.0481390953064 43.7897262573245,5.13878774642956 43.7527961730958,5.18626213073742 43.7355079650879,5.23637771606457 43.7474708557132,5.31529998779291 43.7365646362306,5.34369897842407 43.7187728881839,5.44529294967657 43.6800956726075,5.48808097839355 43.66764831543,5.53050804138189 43.6592330932618,5.57362318038952 43.6619834899903,5.60694360733032 43.6586875915527,5.64142227172852 43.671989440918,5.65715408325207 43.6854438781739,5.67311286926281 43.6935081481935,5.71202611923229 43.6906433105471,5.73788261413586 43.7165565490724,5.75365066528332 43.7246208190917,5.75365066528332 43.7246208190917,5.7573328018189 43.7294082641602,5.7573328018189 43.7294082641602,5.74801683425903 43.7414855957032,5.71627426147472 43.7569313049319,5.71355819702154 43.7811203002931,5.7053484916687 43.7796478271484,5.68429756164556 43.7894515991213,5.67448329925537 43.8073616027835,5.65980339050299 43.815715789795,5.6544451713562 43.8251113891604,5.63137245178234 43.82857131958,5.62768173217773 43.8308029174806,5.59938049316412 43.8271293640139,5.5717186927796 43.8292922973633,5.56379795074474 43.8207359313966,5.55092859268194 43.8174171447756,5.54478216171259 43.8176155090333,5.5486474037171 43.8479652404786,5.56132793426519 43.8574638366701,5.57273721694952 43.8635101318361,5.59029006958008 43.8872337341309,5.60655975341797 43.9160842895508,5.58338308334362 43.9159126281739,5.56763315200811 43.9426383972168,5.54499197006231 43.9390563964847,5.52960014343273 43.9460220336914,5.51267385482788 43.9454040527344,5.50797224044811 43.9578018188477,5.5195693969726 43.9940109252931,5.54286766052252 44.0244483947753,5.54459810256958 44.0698928833009,5.51713514328014 44.0634307861331,5.50263738632196 44.0634498596194,5.49816513061523 44.0730972290041,5.49878787994396 44.115718841553)),((4.97509479522716 44.4294586181642,4.97949218750006 44.4236869812013,4.98860979080206 44.4231986999512,5.00619602203369 44.4117164611819,5.0187602043153 44.4159774780275,5.01771593093872 44.4071388244631,5.0134978294372 44.4054412841796,5.01861667633062 44.3925895690918,5.03275918960577 44.390895843506,5.04759979248053 44.3821220397951,5.07088184356701 44.3832244873049,5.07031965255737 44.3764457702639,5.05326509475708 44.3648872375491,5.02505922317505 44.3610000610351,5.02145290374762 44.3443603515626,5.0090065002442 44.333766937256,5.01333475112921 44.3256530761719,4.99729824066173 44.3183746337893,4.99220514297485 44.3126220703125,4.98701763153082 44.2927169799804,4.97996759414673 44.2972488403321,4.92183589935303 44.3087959289554,4.88946294784546 44.3040199279786,4.89072704315191 44.313720703125,4.88221979141241 44.3252944946292,4.89532804489136 44.3380622863771,4.87911033630377 44.3453712463381,4.86952686309814 44.3450775146487,4.89291000366205 44.3648262023928,4.8933129310609 44.3678741455078,4.90708494186413 44.3746299743653,4.91176176071173 44.3882179260256,4.91016244888311 44.3951530456545,4.9185152053833 44.4077835083008,4.94550466537481 44.4149475097659,4.95196199417109 44.4200477600098,4.95927762985235 44.4197807312012,4.97054672241205 44.4298477172853,4.97509479522716 44.4294586181642)))0.0010POINT(5.1363204841290715 44.066759150876315)
24617POLYGON((2.82303595542913 45.5128440856934,2.83373594284063 45.4939155578613,2.84513473510754 45.4879684448243,2.84412765502935 45.4681739807129,2.84412765502935 45.4681739807129,2.85334634780878 45.4664306640626,2.85877251625067 45.4612693786621,2.85877251625067 45.4612693786621,2.88043117523199 45.4694252014161,2.90004634857178 45.4714813232422,2.92875957489014 45.4659996032716,2.93612790107738 45.4571990966797,2.95064997673035 45.4575195312501,2.95064997673035 45.4575195312501,2.96482491493219 45.4603881835939,2.97551894187939 45.4673614501954,2.995109319687 45.4907760620117,2.9949040412904 45.4975318908691,2.9949040412904 45.4975318908691,2.98999977111822 45.4980621337891,2.96460628509533 45.4821357727051,2.95190834999084 45.4967460632324,2.95130062103266 45.5034255981446,2.95995831489563 45.5195503234864,2.94868040084839 45.5258026123048,2.96512460708612 45.5332908630372,2.96564555168152 45.5401611328125,2.96564555168152 45.5401611328125,2.96532511711126 45.5404319763184,2.96532511711126 45.5404319763184,2.95061445236217 45.5406608581543,2.93017506599438 45.5311317443848,2.91644930839544 45.5338516235352,2.89456772804266 45.5259552001954,2.88975238800055 45.525218963623,2.88717150688177 45.5281600952148,2.88717150688177 45.5281600952148,2.87908172607422 45.5308723449706,2.82303595542913 45.5128440856934))0.0006POINT(2.9226706027985054 45.49939446700249)
32477POLYGON((2.12624454498291 46.5022087097169,2.13101363182068 46.503273010254,2.13920545578014 46.5155448913575,2.18275380134583 46.513298034668,2.18275380134583 46.513298034668,2.18574190139771 46.5071067810059,2.19470143318188 46.5062484741211,2.19470143318188 46.5062484741211,2.19761729240423 46.4942131042481,2.20378851890558 46.4894943237305,2.20016384124767 46.4806137084962,2.20016384124767 46.4806137084962,2.19630169868475 46.487045288086,2.17470049858093 46.4938430786133,2.14698076248169 46.4862899780274,2.14190745353704 46.4864234924318,2.13419675827038 46.4908866882324,2.13368225097656 46.4978332519531,2.12624454498291 46.5022087097169))0.0006POINT(2.1703677177429643 46.497471279568195)