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
64340POLYGON((13.5568675994874 52.1480102539062,13.5622663497925 52.1464881896974,13.5630149841309 52.1456489562989,13.5625505447389 52.1446266174316,13.5646963119508 52.142822265625,13.5840969085694 52.1485977172852,13.5855255126954 52.14701461792,13.5861492156982 52.1557197570801,13.5892562866212 52.1572875976562,13.5892562866212 52.1572875976562,13.5962600708008 52.1597442626954,13.6100025177003 52.1599273681642,13.6180772781373 52.1630287170411,13.6299829483033 52.1654090881348,13.6314859390259 52.1649208068848,13.630916595459 52.1639366149902,13.6334724426271 52.1638069152833,13.6301031112671 52.1599617004395,13.6301031112671 52.1599617004395,13.6261730194092 52.1568946838379,13.6099863052368 52.1504859924318,13.6260337829591 52.1436729431152,13.6286611557007 52.1435699462891,13.6278324127198 52.1415367126466,13.6468486785889 52.1334762573242,13.6594343185424 52.1339454650879,13.6594343185424 52.1339454650879,13.6607456207275 52.1307411193848,13.6612768173218 52.1249389648438,13.6612768173218 52.1249389648438,13.6602897644043 52.1225318908691,13.661211013794 52.1154251098633,13.6594209671021 52.1126174926759,13.6436471939087 52.1200370788574,13.643581390381 52.1184654235841,13.6489248275757 52.1168556213379,13.641978263855 52.1128540039062,13.6438322067261 52.1111297607421,13.6434326171876 52.1083221435547,13.6360111236572 52.1081924438477,13.6397886276245 52.1053199768066,13.6393957138062 52.1030349731446,13.6340532302857 52.1039962768555,13.6338062286378 52.1029663085938,13.6301231384277 52.1025581359864,13.6363973617554 52.1011085510255,13.6229228973389 52.0732116699219,13.6229228973389 52.0732116699219,13.6146440505983 52.0747680664062,13.605586051941 52.0779762268067,13.6036100387573 52.0802574157715,13.5966014862061 52.0837554931641,13.5774841308594 52.0903701782227,13.556160926819 52.0908012390138,13.5408229827882 52.0972175598145,13.5408229827882 52.0972175598145,13.5443468093872 52.1041946411133,13.5459127426147 52.1107254028321,13.549220085144 52.1185913085938,13.5489358901979 52.1378059387207,13.549861907959 52.140464782715,13.5541315078735 52.1460647583008,13.5568675994874 52.1480102539062))0.0006POINT(13.611155940640396 52.1263612316501)
72855POLYGON((11.3239784240723 47.1898078918458,11.3113632202149 47.1724967956544,11.2912588119507 47.1680946350099,11.2912588119507 47.1680946350099,11.2851724624634 47.1734619140626,11.2815179824829 47.178680419922,11.2775487899781 47.194019317627,11.2751321792603 47.198371887207,11.2597246170044 47.2107048034668,11.2555704116821 47.2156219482422,11.2556028366088 47.2236442565917,11.2605361938477 47.2414588928223,11.2605361938477 47.2414588928223,11.2964954376221 47.2438774108887,11.2964954376221 47.2438774108887,11.2907867431642 47.2373695373536,11.2893257141114 47.2335205078125,11.2944860458374 47.2266502380372,11.2948904037476 47.2233619689942,11.2933111190796 47.2202072143555,11.2878799438477 47.2157783508302,11.2876853942871 47.2143630981446,11.2920742034913 47.2103385925293,11.3134708404542 47.1966590881348,11.3134708404542 47.1966590881348,11.3239784240723 47.1898078918458))0.0006POINT(11.287182922363318 47.209543151855506)
41824POLYGON((5.5832781791687 49.2554550170898,5.57814311981213 49.2646331787109,5.58138942718506 49.2704658508301,5.57214117050177 49.2859687805176,5.57214117050177 49.2859687805176,5.5640110969544 49.2858810424805,5.5640110969544 49.2858810424805,5.56724214553844 49.2795257568359,5.55342626571655 49.2753601074219,5.54457092285156 49.2683334350587,5.54457092285156 49.2683334350587,5.54454278945923 49.257438659668,5.54454278945923 49.257438659668,5.5591130256654 49.2597389221191,5.55348968505871 49.2513427734376,5.55699205398565 49.2418785095215,5.55320310592657 49.2358055114747,5.55320310592657 49.2358055114747,5.56787252426153 49.2377319335938,5.58036661148077 49.2431068420411,5.58036661148077 49.2431068420411,5.5832781791687 49.2554550170898))0.0006POINT(5.562791324797179 49.26139050438295)
66757POLYGON((9.43211460113537 48.0162887573242,9.42027473449713 48.0139083862306,9.41872501373297 48.0156936645508,9.4133119583131 48.015209197998,9.41315841674805 48.0144538879395,9.41183757781982 48.0145530700684,9.41217803955084 48.0135879516602,9.40518474578863 48.0168037414551,9.40569686889643 48.0142784118652,9.40888118743896 48.0126266479492,9.40528011322027 48.0125427246094,9.40627956390387 48.0097312927246,9.40097522735596 48.009479522705,9.39979362487804 48.0110321044922,9.39635562896734 48.0102233886719,9.40012550353998 48.0046768188477,9.40128993988043 48.0004043579103,9.4030504226684 48.000114440918,9.40313243865972 47.9976615905762,9.40526390075689 47.9945373535156,9.40526390075689 47.9945373535156,9.40231800079346 47.9885139465332,9.40034770965576 47.9891738891602,9.3912343978883 47.9871253967286,9.38493347167974 47.9897918701172,9.37993812561035 47.9884796142579,9.37481498718273 47.9854393005371,9.37224292755133 47.9875450134277,9.36990356445324 47.9873466491699,9.36377143859869 47.9907684326172,9.36143398284918 47.9925537109376,9.35919380187994 47.9966201782227,9.35743808746338 47.9962310791016,9.35649013519293 47.9990539550782,9.35487270355225 47.9983100891114,9.35221385955822 47.9996299743653,9.351625442505 47.9991493225099,9.34888076782227 48.0019607543945,9.35001850128168 48.0026016235352,9.34921646118175 48.0036811828614,9.34611415863037 48.004566192627,9.33500194549566 48.0025596618653,9.33500194549566 48.0025596618653,9.33390331268322 48.0094566345216,9.33904743194586 48.0191268920898,9.34530448913574 48.0231475830078,9.35293483734125 48.0240898132325,9.34650897979742 48.0272254943848,9.34348011016851 48.0272369384766,9.3433723449707 48.0289611816407,9.34178447723383 48.02982711792,9.34445858001715 48.0306739807129,9.34253120422363 48.0345268249512,9.34841346740734 48.0380668640138,9.36057186126703 48.0426979064941,9.35781574249279 48.0453491210938,9.36029815673834 48.0470008850099,9.35893630981457 48.0473289489747,9.35935115814215 48.0485305786133,9.36225414276123 48.0482177734376,9.3614673614502 48.0492172241212,9.36428642272955 48.0525283813477,9.36718559265148 48.0518379211426,9.36629009246832 48.0528907775879,9.36960315704351 48.0545768737794,9.37209224700933 48.0536422729492,9.37485504150402 48.0583000183105,9.38590908050548 48.0599060058595,9.38590908050548 48.0599060058595,9.39678192138683 48.0630187988281,9.39717769622797 48.0603332519531,9.40217399597168 48.0611915588379,9.40512657165539 48.056854248047,9.40606880187988 48.0488777160645,9.40797042846691 48.0501556396486,9.40963363647467 48.0434951782228,9.41075515747076 48.0436935424806,9.41130828857433 48.0459632873535,9.4160099029541 48.0485839843751,9.41699504852295 48.0482788085939,9.41582202911371 48.0467643737794,9.41569995880127 48.0437698364258,9.41214561462408 48.0389785766602,9.41266250610357 48.0368194580079,9.41785144805914 48.0367431640626,9.42028331756597 48.0334320068359,9.42769622802746 48.0346450805665,9.42941093444824 48.029125213623,9.42935180664068 48.0244331359864,9.43127536773687 48.0240898132325,9.43161010742188 48.0222511291503,9.43410110473644 48.0217094421387,9.43408966064453 48.019760131836,9.43211460113537 48.0162887573242))0.0006POINT(9.385438129466111 48.02293810280421)
73748POLYGON((16.4819927215577 46.4175643920898,16.486400604248 46.4321594238282,16.496379852295 46.4430770874023,16.496379852295 46.4430770874023,16.4820156097412 46.4479141235352,16.4820156097412 46.4479141235352,16.465482711792 46.447193145752,16.4571285247803 46.447738647461,16.4546966552735 46.4495315551759,16.4546394348146 46.4550971984864,16.4449138641358 46.4621925354005,16.4393119812012 46.4640235900879,16.4260826110839 46.4652938842774,16.4260826110839 46.4652938842774,16.4164867401124 46.4631843566894,16.4164867401124 46.4631843566894,16.4167232513429 46.4582481384277,16.4131507873535 46.4515571594238,16.4131507873535 46.4515571594238,16.4170513153077 46.447193145752,16.4178943634033 46.4439315795899,16.4172191619873 46.4407730102538,16.412883758545 46.433391571045,16.4120044708253 46.4300880432129,16.4123516082765 46.4256248474121,16.4145545959473 46.4196166992188,16.4157924652101 46.409637451172,16.4148216247558 46.4041481018067,16.4126091003419 46.4012336730957,16.4080638885498 46.3994293212891,16.3987274169922 46.3989982604981,16.3909854888916 46.3999977111818,16.3909854888916 46.3999977111818,16.3899936676025 46.3941841125488,16.3907012939453 46.3898658752442,16.3907012939453 46.3898658752442,16.4019622802734 46.3856735229492,16.4075736999511 46.3811874389649,16.4103622436523 46.3768730163575,16.4119262695312 46.3688354492189,16.4179573059083 46.3583450317384,16.4213981628419 46.3569412231446,16.4295845031739 46.3567237854005,16.43265914917 46.3547401428223,16.432830810547 46.3532333374023,16.4315338134766 46.3517036437989,16.4191074371339 46.3442916870117,16.4148864746095 46.3428649902344,16.4148864746095 46.3428649902344,16.4113273620606 46.3391380310059,16.4067153930663 46.3382225036622,16.3821506500244 46.3441619873047,16.3769626617433 46.3439407348633,16.368881225586 46.3332977294922,16.367805480957 46.3226623535157,16.3789520263672 46.3215179443361,16.3789520263672 46.3215179443361,16.3873748779297 46.3240776062012,16.3938083648682 46.3244438171387,16.4169883728027 46.3182716369629,16.4353885650635 46.3178215026857,16.4403266906739 46.3196983337403,16.4424095153809 46.3250427246094,16.4442558288574 46.3270530700684,16.4497737884521 46.3286628723146,16.4497737884521 46.3286628723146,16.4573001861572 46.3397064208984,16.4596061706544 46.3416366577148,16.472541809082 46.3445701599121,16.4815158843995 46.3478126525879,16.4854106903077 46.3502807617188,16.4854106903077 46.3502807617188,16.4837570190431 46.3571243286133,16.483720779419 46.3711128234863,16.4781131744385 46.3792114257812,16.4781131744385 46.3792114257812,16.4668312072754 46.3805923461915,16.4605197906495 46.3869667053223,16.4532203674316 46.3920974731446,16.4523468017578 46.3944549560547,16.4525585174561 46.3988533020021,16.4504928588868 46.4036178588867,16.4507694244386 46.4106941223146,16.4523143768311 46.4136009216308,16.4568099975587 46.4159317016603,16.4819927215577 46.4175643920898))0.0006POINT(16.43196153079765 46.38840008903954)
41833POLYGON((5.42856407165527 49.165309906006,5.43139076232916 49.1644592285157,5.43139076232916 49.1644592285157,5.44658231735235 49.1625785827637,5.47174263000483 49.1514854431153,5.48179721832287 49.1526908874513,5.48629808425898 49.1430358886719,5.48629808425898 49.1430358886719,5.49508285522461 49.1418228149414,5.49745178222651 49.1474380493165,5.50683355331415 49.1494750976563,5.51072883605963 49.1551513671875,5.51072883605963 49.1551513671875,5.5303697586059 49.168098449707,5.5303697586059 49.168098449707,5.5140581130982 49.176830291748,5.5140581130982 49.176830291748,5.48052263259899 49.167018890381,5.42856407165527 49.165309906006))0.0006POINT(5.486348231633518 49.158498340182874)
51516POLYGON((2.77814197540289 50.0994300842286,2.77103042602539 50.0943183898926,2.75046634674084 50.0914497375489,2.75046634674084 50.0914497375489,2.74177956581121 50.094898223877,2.74104547500622 50.104694366455,2.74953722953808 50.1128044128419,2.74953722953808 50.1128044128419,2.76418328285223 50.110694885254,2.7782599925996 50.1139640808106,2.78089785575878 50.1111564636232,2.78089785575878 50.1111564636232,2.77814197540289 50.0994300842286))0.0006POINT(2.761353631814412 50.10406843821215)
1399368POLYGON((-3.88008499145508 42.1707763671876,-3.87088990211481 42.1704139709473,-3.86806702613831 42.1674804687501,-3.85718607902527 42.1668891906738,-3.85070204734802 42.172592163086,-3.84630990028381 42.163673400879,-3.84242606163014 42.161262512207,-3.83659410476685 42.162311553955,-3.82122993469233 42.1714668273925,-3.81753993034357 42.1755180358887,-3.81515192985529 42.1705627441407,-3.80710005760193 42.1656761169434,-3.79513001441956 42.1484680175782,-3.78508305549616 42.145435333252,-3.7821729183197 42.1479682922364,-3.7679939270019 42.1394042968751,-3.78824210166925 42.1376914978028,-3.78635311126703 42.1345596313476,-3.79141211509705 42.1317558288575,-3.80840802192682 42.1277313232422,-3.82090401649475 42.129364013672,-3.8249089717865 42.1349639892578,-3.83141994476318 42.1378784179688,-3.83782696723938 42.1355018615723,-3.82910490036005 42.1254234313965,-3.82872891426075 42.1217041015626,-3.8330500125885 42.1209182739258,-3.83746004104614 42.1159324645997,-3.84364295005793 42.1152381896973,-3.85417294502253 42.1092720031739,-3.86290192604065 42.1072158813477,-3.86502194404602 42.1013526916504,-3.86189508438105 42.0945930480956,-3.86824393272394 42.0990867614747,-3.8721170425415 42.1045265197754,-3.88182091712946 42.1109352111817,-3.89022898674 42.1136169433594,-3.89544606208801 42.1114158630371,-3.89503598213196 42.1199455261232,-3.88627004623407 42.1272735595704,-3.87065792083735 42.1296195983887,-3.84637594223022 42.1406097412111,-3.86092209815979 42.1441917419433,-3.87073588371277 42.1405334472656,-3.8705739974975 42.1446495056153,-3.87382388114929 42.1459732055665,-3.87702989578247 42.1608200073243,-3.88152503967279 42.1655158996583,-3.88008499145508 42.1707763671876))0.0006POINT(-3.8435400724410713 42.138327280680365)
73372POLYGON((16.2537479400636 46.509147644043,16.2515716552735 46.4906997680665,16.2522640228272 46.4855880737306,16.2522640228272 46.4855880737306,16.2438163757325 46.486873626709,16.2263145446778 46.4935607910157,16.2109756469728 46.4935417175293,16.2109184265136 46.4828758239746,16.2006931304932 46.4828643798829,16.185375213623 46.4864044189453,16.1853370666505 46.4792938232423,16.1802253723144 46.479290008545,16.1700191497803 46.4828338623047,16.1700954437256 46.4970550537109,16.1598720550537 46.4970436096192,16.1547985076905 46.504150390625,16.139461517334 46.5041351318359,16.1394424438478 46.5005798339844,16.1343307495118 46.5005722045899,16.1342926025392 46.4934616088867,16.1291790008545 46.4934577941896,16.1087493896486 46.4969902038574,16.1036968231202 46.5076522827149,16.0883388519287 46.5040817260743,16.0730209350587 46.5076179504396,16.0576858520508 46.5076026916505,16.037254333496 46.5111389160157,16.0372734069825 46.5146942138672,16.0065994262695 46.5146598815919,16.0065994262695 46.5146598815919,16.006618499756 46.5182151794434,16.006618499756 46.5182151794434,16.0117511749267 46.5217781066895,16.0118465423583 46.5395545959473,16.0169582366944 46.5395584106446,16.0220890045166 46.5431213378907,16.022108078003 46.5466766357422,16.0272216796875 46.5466804504396,16.0272407531738 46.5502357482911,16.0630073547364 46.5467185974122,16.0630073547364 46.5467185974122,16.083475112915 46.5502967834474,16.0885314941407 46.5396347045898,16.1089591979981 46.536102294922,16.1191844940187 46.5361137390137,16.1293888092042 46.5325660705568,16.1447467803955 46.5361404418945,16.1447639465332 46.5396957397462,16.1498775482178 46.5396995544434,16.1601219177247 46.5432662963867,16.1602725982667 46.5717086791993,16.1602725982667 46.5717086791993,16.1704978942871 46.571720123291,16.1705188751221 46.5752754211426,16.18585395813 46.5752944946289,16.1858730316163 46.5788497924806,16.1909847259521 46.5788536071778,16.1910037994386 46.5824089050293,16.1910037994386 46.5824089050293,16.2012271881104 46.5824203491212,16.2215824127197 46.5646629333496,16.2368984222413 46.5611228942872,16.2368984222413 46.5611228942872,16.2368793487549 46.5575675964357,16.2572917938234 46.5504798889161,16.2572536468506 46.5433692932129,16.2572536468506 46.5433692932129,16.2572326660156 46.5398139953614,16.2367458343506 46.5326805114746,16.2366485595703 46.5106430053711,16.2537479400636 46.509147644043))0.0006POINT(16.145056043352444 46.52735121590754)
41421POLYGON((6.06287574768066 48.4493675231934,6.06720638275146 48.4646606445312,6.06720638275146 48.4646606445312,6.05877733230597 48.46102142334,6.04435348510754 48.4641571044922,6.04435348510754 48.4641571044922,6.04141473770142 48.4550247192383,6.04494571685791 48.4489288330079,6.04973316192638 48.4481735229493,6.04973316192638 48.4481735229493,6.05717468261724 48.4520988464356,6.06190586090088 48.4524612426757,6.06287574768066 48.4493675231934))0.0006POINT(6.0541400114695705 48.45607376098635)