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
1402164MULTIPOLYGON(((-4.06753015518188 41.5620498657227,-4.07684183120722 41.5553703308107,-4.08290719985962 41.5544052124023,-4.08528184890741 41.5559310913086,-4.09657716751099 41.5501747131348,-4.10191106796259 41.5499801635742,-4.10486698150635 41.5538787841797,-4.10838794708241 41.5530433654786,-4.11522483825684 41.5545082092286,-4.11954021453857 41.5592956542968,-4.12280988693237 41.5604858398438,-4.12785816192627 41.559799194336,-4.13104486465454 41.5616683959962,-4.13352012634277 41.5687561035157,-4.13709783554071 41.570297241211,-4.15094804763794 41.568214416504,-4.15292692184448 41.5748977661134,-4.15865421295166 41.5724639892578,-4.15345287322987 41.5795135498046,-4.1579270362854 41.5855026245118,-4.15866994857788 41.5908355712891,-4.15121078491211 41.5957298278809,-4.15848588943481 41.5959358215333,-4.16913795471186 41.5991973876953,-4.18285894393915 41.5994453430175,-4.19028615951532 41.5961494445802,-4.20173692703241 41.5963287353516,-4.21777009963989 41.5934066772462,-4.22420883178705 41.5937767028809,-4.22189617156977 41.5977096557618,-4.21718502044678 41.5999298095703,-4.21784305572504 41.6068344116211,-4.20137882232666 41.6172561645509,-4.19901514053339 41.6237182617189,-4.20430088043207 41.6290588378907,-4.19968795776367 41.6302642822266,-4.18110418319702 41.6229057312011,-4.17795610427856 41.6234436035156,-4.16891717910767 41.6281280517579,-4.16817378997803 41.6368255615235,-4.16466712951654 41.6380920410156,-4.15834379196167 41.6371002197267,-4.15057516098022 41.6423187255859,-4.14840698242182 41.6413612365724,-4.1456561088562 41.6337661743165,-4.13949823379511 41.6317939758301,-4.13531398773188 41.6272926330566,-4.13113403320307 41.6298332214355,-4.12909412384033 41.6292572021486,-4.12776279449463 41.6307563781738,-4.10987615585327 41.6223564147949,-4.10183811187744 41.6204872131348,-4.1013679504394 41.6168975830078,-4.09543800353998 41.6132621765137,-4.08836317062378 41.6151504516603,-4.08394384384155 41.6128578186035,-4.07590818405146 41.6203269958497,-4.06913185119629 41.6229515075684,-4.06721115112305 41.6221733093262,-4.0637531280517 41.6119117736816,-4.05506086349487 41.6072425842286,-4.04497289657587 41.6053619384766,-4.0417799949646 41.6023292541504,-4.04194402694702 41.5967712402344,-4.0449800491333 41.5939140319824,-4.04858112335199 41.5932273864747,-4.05189514160151 41.5837211608887,-4.05792808532709 41.5777282714844,-4.06114578247065 41.5765571594238,-4.05830383300781 41.574447631836,-4.06041908264154 41.5710067749024,-4.06694221496582 41.5671615600586,-4.06753015518188 41.5620498657227)),((-4.13299083709717 41.5617904663086,-4.1356959342956 41.5601272583008,-4.13674688339233 41.5619468688965,-4.13299083709717 41.5617904663086)))0.0006POINT(-4.126647481268264 41.59715948568348)
38816POLYGON((2.35267376899725 43.3578758239746,2.32309889793396 43.356544494629,2.31658792495739 43.3608016967773,2.31295847892761 43.3704872131348,2.31295847892761 43.3704872131348,2.31308341026312 43.3713874816895,2.31308341026312 43.3713874816895,2.32384085655224 43.365821838379,2.34133958816528 43.3765220642089,2.33717060089117 43.3862037658693,2.32614994049072 43.3971748352051,2.32614994049072 43.3971748352051,2.32332634925842 43.4096260070801,2.33047342300421 43.4137001037599,2.33960366249079 43.4128303527832,2.33960366249079 43.4128303527832,2.34560036659246 43.4075050354004,2.3441469669342 43.4007644653321,2.35540962219244 43.3899574279786,2.36057758331299 43.3633651733399,2.36057758331299 43.3633651733399,2.35267376899725 43.3578758239746))0.0006POINT(2.3332578341166412 43.38361013503306)
37251POLYGON((7.03207874298096 47.7261848449708,6.99198007583618 47.7142333984376,6.99198007583618 47.7142333984376,6.99383831024164 47.7080307006836,7.00060462951666 47.7046089172364,7.00060462951666 47.7046089172364,7.02756547927862 47.7053680419922,7.02756547927862 47.7053680419922,7.03741788864147 47.7215576171874,7.03741788864147 47.7215576171874,7.03207874298096 47.7261848449708))0.0006POINT(7.014105319976847 47.71257514953616)
56576POLYGON((4.66062927246099 45.9501266479493,4.66279125213629 45.9494552612305,4.66279125213629 45.9494552612305,4.68400239944458 45.9742622375489,4.68400239944458 45.9742622375489,4.67676830291759 45.9780731201172,4.65836191177374 45.9790191650391,4.65836191177374 45.9790191650391,4.64829874038708 45.9760322570802,4.64829874038708 45.9760322570802,4.64761447906494 45.9643936157227,4.64761447906494 45.9643936157227,4.65225982666027 45.9655342102052,4.65547466278076 45.9629287719728,4.66062927246099 45.9501266479493))0.0006POINT(4.660519259316635 45.96735627310624)
49413POLYGON((3.30474948883068 48.94877243042,3.29241371154779 48.9693794250489,3.29241371154779 48.9693794250489,3.28761267662054 48.9705848693847,3.27509760856628 48.964771270752,3.2778749465943 48.9554481506348,3.26784110069275 48.9479637145997,3.26290369033825 48.9489364624023,3.26290369033825 48.9489364624023,3.26017951965326 48.9447975158693,3.26017951965326 48.9447975158693,3.26516056060791 48.9390640258789,3.26516056060791 48.9390640258789,3.26947951316833 48.9374542236329,3.28377223014837 48.9401664733887,3.30474948883068 48.94877243042))0.0006POINT(3.2751828352610444 48.951301066080774)
49652POLYGON((3.53888940811169 49.627239227295,3.54629611968994 49.6225700378418,3.55690860748302 49.6037139892579,3.55690860748302 49.6037139892579,3.55388593673717 49.5978240966796,3.55994510650646 49.5892753601075,3.55183362960827 49.5856819152833,3.55183362960827 49.5856819152833,3.54415917396557 49.5880279541016,3.53613519668579 49.5860748291016,3.53613519668579 49.5860748291016,3.52656888961786 49.588680267334,3.51122832298273 49.5862541198732,3.50179648399364 49.5885963439941,3.47291469573986 49.5805778503418,3.45926761627209 49.5845947265626,3.45926761627209 49.5845947265626,3.45829582214355 49.5872230529786,3.45829582214355 49.5872230529786,3.45645451545721 49.5884513854981,3.45645451545721 49.5884513854981,3.4711196422578 49.5882949829102,3.48663020133972 49.5971412658693,3.48351812362665 49.6102104187012,3.47840738296509 49.6108512878419,3.47840738296509 49.6108512878419,3.46951484680181 49.6183815002441,3.4848902225495 49.6310081481934,3.48338413238531 49.6341400146485,3.48338413238531 49.6341400146485,3.4926016330719 49.6373405456544,3.51294088363659 49.6359176635743,3.52844691276556 49.6274490356445,3.53888940811169 49.627239227295))0.0006POINT(3.5044460730119726 49.60231064305165)
58777POLYGON((8.15136051177973 51.1733169555664,8.14729595184332 51.1777076721192,8.14068889617931 51.180721282959,8.140549659729 51.182487487793,8.13641548156744 51.1819572448732,8.13794326782227 51.1834373474122,8.12596035003662 51.1908645629883,8.12333965301525 51.1902961730958,8.12228298187267 51.1916084289551,8.1294145584107 51.1944541931153,8.11324691772472 51.1940422058105,8.11225605010992 51.1954727172852,8.11225605010992 51.1954727172852,8.1106128692627 51.1937370300294,8.10641670227051 51.1926002502443,8.1013584136964 51.1876525878906,8.08359909057623 51.1796607971193,8.07666778564459 51.1799163818361,8.07265949249279 51.1815147399903,8.07202243804932 51.1838340759278,8.07020092010498 51.1835975646973,8.06518936157238 51.1800270080568,8.05760192871099 51.1799774169922,8.05695819854742 51.1807632446289,8.05543899536144 51.1788864135742,8.04145050048839 51.176929473877,8.03377914428711 51.1722755432129,8.02231025695801 51.1711769104004,8.01130580902094 51.1675872802734,8.00787258148188 51.1675109863282,8.00159072875982 51.1621398925782,7.9948081970216 51.1620750427247,7.99156999588024 51.1605377197266,7.99677371978765 51.1540679931641,7.99380683898937 51.152816772461,7.99380683898937 51.152816772461,8.0036039352417 51.1452865600586,8.00044631958013 51.1420135498046,8.00058841705328 51.1404495239259,7.99539518356329 51.1396179199219,7.99632072448736 51.1370620727539,7.99872779846197 51.136215209961,7.99529457092291 51.1359329223633,7.99256563186651 51.1329498291016,7.99305009841925 51.1300888061524,7.99162578582764 51.12943649292,7.99376964569097 51.1292991638185,7.99530696868896 51.1277503967286,7.99506950378412 51.1265449523926,7.99327087402344 51.1256484985352,7.99506044387823 51.1246376037598,7.99496746063244 51.1233978271485,7.9905366897583 51.1207885742189,7.9905633926391 51.1163139343263,7.98876619338995 51.1143684387208,7.98929405212414 51.1125679016113,7.98664903640741 51.1112327575684,7.98857307434088 51.1105651855469,7.99126148223877 51.1113586425781,7.98072576522827 51.1020851135254,7.98194742202764 51.1014442443849,7.97801971435547 51.0987434387208,7.9789185523988 51.0945739746094,7.97362518310547 51.093334197998,7.97287034988415 51.0896186828614,7.96376943588251 51.0892601013185,7.95885467529308 51.086612701416,7.95885467529308 51.086612701416,7.95965862274181 51.0857658386231,7.95791578292852 51.0854873657227,7.9582371711731 51.0845832824708,7.96278381347662 51.0811614990234,7.96277856826788 51.0773468017578,7.96674776077271 51.0742797851564,7.96467304229748 51.0732917785645,7.96685123443609 51.071086883545,7.97146368026745 51.0698356628418,7.97407150268555 51.0676078796387,7.97008943557751 51.0636024475098,7.97271823883062 51.0620307922363,7.97127628326427 51.057300567627,7.97127628326427 51.057300567627,7.97829484939575 51.0574798583986,7.98175001144415 51.0564651489258,7.98898363113403 51.057674407959,7.99207687377935 51.0599098205566,8.00172519683844 51.0629882812501,8.00048732757568 51.0650062561036,7.99743700027472 51.0651397705078,7.99573373794567 51.0694236755372,8.00387096405035 51.0722084045411,8.01015281677246 51.0699310302734,8.02232265472423 51.0713424682618,8.02498912811279 51.0738487243652,8.03449153900152 51.0762634277344,8.03922080993658 51.078971862793,8.04445838928228 51.0788421630861,8.04591941833502 51.0814743041993,8.05749607086193 51.0820121765138,8.05911254882818 51.0838737487794,8.06125640869152 51.0836143493652,8.06206226348877 51.0802879333497,8.06579875946045 51.0799827575684,8.06830406188959 51.0846786499024,8.06712913513195 51.0890731811524,8.07044219970714 51.0921325683594,8.07308387756353 51.0913772583008,8.07558536529552 51.0941009521486,8.080234527588 51.09623336792,8.08093452453619 51.0956878662109,8.08094024658197 51.0974998474121,8.08989524841309 51.0980339050294,8.08916187286383 51.098762512207,8.09173583984381 51.100456237793,8.1046714782716 51.1013908386231,8.10592937469488 51.1041641235352,8.10997581481939 51.1047134399415,8.1115808486939 51.1035308837891,8.11279392242443 51.1046981811524,8.11579036712658 51.1045341491699,8.11740112304688 51.1060256958008,8.12583065032965 51.1050453186036,8.12674140930187 51.1031723022462,8.13027286529547 51.1034545898439,8.13449382781982 51.1056365966797,8.13713169097906 51.1111068725585,8.14033508300781 51.1066169738771,8.14775085449219 51.1092529296875,8.14858436584473 51.1074867248536,8.15291309356695 51.1078529357911,8.1541509628297 51.1065635681153,8.15820980072021 51.1065902709961,8.16048622131359 51.10795211792,8.16134929656982 51.1064453125001,8.16863822937006 51.1085014343263,8.16928291320812 51.1070556640626,8.18509387969976 51.1105575561523,8.18531894683838 51.1097793579101,8.18786811828613 51.1111335754395,8.18942070007319 51.1146926879884,8.19597816467297 51.1145362854004,8.19549942016602 51.1126708984375,8.1978178024292 51.1109085083009,8.19834518432612 51.106632232666,8.19915390014648 51.1061897277833,8.19788551330578 51.1052360534669,8.19917201995844 51.1043815612793,8.20082378387451 51.1007690429689,8.20485210418701 51.0973129272462,8.20409870147699 51.0969543457032,8.20582962036133 51.0968170166016,8.21387100219732 51.0904731750488,8.22348213195795 51.0929679870606,8.22348213195795 51.0929679870606,8.22587299346924 51.0952186584473,8.22607326507563 51.0972557067872,8.22778797149658 51.0997886657715,8.23879528045654 51.1043395996094,8.23879528045654 51.1043395996094,8.23924350738537 51.1074218750001,8.24157619476318 51.1121177673341,8.23941898345959 51.1107330322265,8.2385892868042 51.1109733581544,8.23921012878412 51.1122131347657,8.23179721832287 51.1133842468262,8.22879600524908 51.1153259277344,8.22503471374517 51.1151695251466,8.22469520568853 51.1165351867677,8.22659873962414 51.1203155517578,8.22560119628912 51.1221237182618,8.22354793548595 51.1213989257814,8.21850013732922 51.1243019104004,8.21792602539062 51.1230621337891,8.21197891235357 51.1230010986328,8.20956802368175 51.1249275207521,8.20702552795422 51.1249046325685,8.20050048828136 51.1227760314942,8.19922065734875 51.1202087402345,8.19569301605236 51.1214065551757,8.19244194030773 51.1243591308594,8.19906139373791 51.1252975463868,8.19643020629877 51.1288108825684,8.19505119323736 51.1282424926759,8.19421672821051 51.1294822692872,8.19702148437506 51.1315383911133,8.19406986236567 51.1333389282227,8.19159889221203 51.1318893432618,8.19052028656012 51.132553100586,8.19275951385509 51.136058807373,8.19262599945074 51.1378822326661,8.18841361999517 51.1442871093751,8.18402099609381 51.1462707519531,8.18094444274908 51.146842956543,8.17563247680675 51.1449012756348,8.17362308502209 51.1478652954103,8.16760921478277 51.1473045349121,8.170090675354 51.1413497924805,8.16712188720714 51.1385803222656,8.16101551055908 51.1368141174316,8.16018962860107 51.1385803222656,8.15798759460449 51.139907836914,8.15567970275885 51.1397209167481,8.15581512451178 51.1406364440918,8.15280342102056 51.1408920288086,8.1518173217774 51.1421203613282,8.14634609222406 51.1405220031739,8.14455223083507 51.1386680603027,8.14352512359613 51.1397209167481,8.13919258117676 51.1405296325685,8.13947772979736 51.1411666870118,8.13569450378418 51.1414031982423,8.13536548614508 51.1425132751465,8.13020038604742 51.1434097290039,8.1304550170899 51.145133972168,8.13625717163092 51.1534156799316,8.14761543273926 51.158893585205,8.14627456665033 51.1647377014161,8.15033340454102 51.1653633117677,8.14953613281256 51.1667480468751,8.14791297912609 51.1664886474609,8.14730834960949 51.1676483154297,8.15020370483404 51.1679496765137,8.14930057525635 51.1691093444825,8.14945030212408 51.1717948913575,8.15136051177973 51.1733169555664))0.0006POINT(8.10154665580822 51.121990936143064)
19533POLYGON((10.9856796264648 46.1361389160157,10.9772481918335 46.1206588745118,10.9687328338624 46.1149635314941,10.9687328338624 46.1149635314941,10.9618606567383 46.1168098449706,10.9526491165161 46.113670349121,10.9472198486329 46.1098289489747,10.9444599151612 46.1095237731935,10.9439172744751 46.1129646301271,10.945481300354 46.1175155639648,10.9543457031251 46.1257362365724,10.9588594436647 46.1278190612794,10.9579086303712 46.1359024047852,10.9541845321655 46.1381072998047,10.9541845321655 46.1381072998047,10.9538917541503 46.1417198181153,10.9403972625732 46.1563682556153,10.9375524520873 46.1581535339357,10.9311952590944 46.1597328186035,10.9279727935791 46.1568489074708,10.9309587478638 46.147232055664,10.9309587478638 46.147232055664,10.9302339553834 46.1428031921387,10.9242992401124 46.1461753845216,10.923194885254 46.1499977111816,10.9217348098755 46.1506614685059,10.8946657180786 46.1560745239258,10.8946657180786 46.1560745239258,10.8975648880005 46.1611862182617,10.8976497650148 46.1704483032228,10.9010009765625 46.1891555786134,10.9020709991456 46.190715789795,10.9020709991456 46.190715789795,10.9046621322632 46.1886558532715,10.9314174652101 46.190486907959,10.9314174652101 46.190486907959,10.9535703659058 46.1804847717286,10.9634923934936 46.1786193847657,10.9634923934936 46.1786193847657,10.9754114151001 46.1687545776368,10.9754114151001 46.1687545776368,10.9778909683228 46.166301727295,10.9861917495729 46.1625633239747,10.9983377456666 46.1611595153809,10.9998207092286 46.157829284668,10.9998540878296 46.1552734375,10.9935684204102 46.1505088806153,10.9889297485352 46.1451873779297,10.9915761947632 46.1423263549805,10.9915761947632 46.1423263549805,10.9856796264648 46.1361389160157))0.0006POINT(10.948883285522502 46.150646896362325)
14263POLYGON((12.5124673843385 43.9921951293946,12.5131464004517 43.9886093139649,12.5105381011963 43.9878463745118,12.5076780319214 43.984661102295,12.5099554061891 43.976978302002,12.5069665908813 43.9750595092774,12.5041475296021 43.974708557129,12.5056877136232 43.9685249328614,12.5056877136232 43.9685249328614,12.5071487426757 43.9661598205567,12.5048151016236 43.9618110656739,12.5100803375244 43.9560470581056,12.5100803375244 43.9560470581056,12.5118350982666 43.9541969299317,12.5139684677125 43.9485549926758,12.5141229629517 43.9458808898926,12.5128078460693 43.9423866271974,12.5128078460693 43.9423866271974,12.5147743225098 43.9418182373047,12.5370788574218 43.9435043334961,12.5405025482178 43.9462394714357,12.5561561584473 43.9530372619629,12.5756378173828 43.940357208252,12.5756378173828 43.940357208252,12.5758590698242 43.9459609985351,12.5795822143556 43.9504089355469,12.5811948776246 43.9495277404785,12.5815172195435 43.9462051391602,12.6001663208009 43.945140838623,12.6080541610718 43.9512062072753,12.6080541610718 43.9512062072753,12.6077127456665 43.951976776123,12.6127519607544 43.9586486816407,12.635027885437 43.958179473877,12.635027885437 43.958179473877,12.6400728225708 43.9575920104981,12.6427898406983 43.9593887329102,12.644136428833 43.9660301208497,12.636697769165 43.968578338623,12.6351766586304 43.9736518859864,12.6412019729614 43.9797744750977,12.6426820755004 43.9801254272461,12.6426820755004 43.9801254272461,12.6294946670532 43.9887580871583,12.6141967773438 43.9876823425293,12.6062297821046 43.9892883300781,12.6062297821046 43.9892883300781,12.5991163253785 43.9849815368652,12.5926866531373 43.9832992553712,12.5840806961061 43.9829139709473,12.5787811279297 43.9836120605469,12.5753107070923 43.9895935058595,12.5749082565309 43.9921684265138,12.5687656402589 43.9923973083497,12.5515251159668 43.987590789795,12.5471830368043 43.9889144897461,12.5402832031251 43.9933815002441,12.5147609710693 43.9932441711426,12.5143566131592 43.99227142334,12.5124673843385 43.9921951293946))0.0006POINT(12.566475027698612 43.96791839599611)
27802POLYGON((-0.142972841858864 48.801181793213,-0.131715148687249 48.8067970275879,-0.119830273091736 48.8008346557618,-0.120327740907669 48.7975349426271,-0.120327740907669 48.7975349426271,-0.123736239969674 48.782569885254,-0.123736239969674 48.782569885254,-0.13939626514906 48.7716522216797,-0.13939626514906 48.7716522216797,-0.163873344659692 48.7778205871582,-0.163873344659692 48.7778205871582,-0.142972841858864 48.801181793213))0.0006POINT(-0.13538049500091265 48.78799715909097)