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
68832POLYGON((13.1118230819703 50.7540702819825,13.1112337112427 50.7521553039551,13.1127119064332 50.7516899108887,13.1128520965577 50.7501411437988,13.1145830154419 50.7501296997071,13.1141843795776 50.7490921020507,13.1127338409425 50.7487907409669,13.1133575439453 50.7465095520021,13.1180696487427 50.7455024719239,13.1226358413697 50.7426719665528,13.1230421066285 50.7405624389648,13.126805305481 50.7401084899903,13.127776145935 50.7384681701661,13.1239652633668 50.7395782470703,13.1234674453735 50.7388000488281,13.1268768310547 50.7378654479981,13.1307516098023 50.7346076965333,13.130226135254 50.7330894470215,13.132387161255 50.731674194336,13.128589630127 50.7297325134277,13.1294527053833 50.7289505004883,13.1248397827149 50.7273864746094,13.1305551528931 50.7218208312989,13.1287708282472 50.7216262817382,13.1286935806275 50.7202491760254,13.121371269226 50.7201843261719,13.1114358901978 50.7169952392579,13.1022901535035 50.7170295715333,13.1037921905519 50.7157363891602,13.101417541504 50.7163848876954,13.101417541504 50.7163848876954,13.1051244735718 50.7134284973145,13.1072063446045 50.7133827209473,13.1086521148682 50.7085494995118,13.1120185852052 50.7063751220703,13.1161708831787 50.7070999145509,13.1164817810059 50.7050704956055,13.119812965393 50.7063179016113,13.1255273818969 50.7000274658204,13.1214046478273 50.6985664367676,13.122184753418 50.6968002319337,13.122184753418 50.6968002319337,13.123748779297 50.695125579834,13.128960609436 50.6930274963379,13.1349840164185 50.6947631835938,13.1394214630128 50.698299407959,13.1448926925659 50.6980323791505,13.1466541290284 50.7028503417969,13.150839805603 50.7066535949706,13.1488018035889 50.710205078125,13.145778656006 50.7106590270996,13.1493082046509 50.714641571045,13.150463104248 50.7184867858886,13.1518936157227 50.7194519042969,13.1517877578736 50.7213363647462,13.1551742553712 50.7232742309571,13.1530380249023 50.7238655090332,13.1542224884033 50.7289772033691,13.155728340149 50.7305107116699,13.1593494415283 50.7310752868652,13.1574735641479 50.7327575683594,13.1576414108276 50.7349662780762,13.1525764465333 50.7357063293457,13.147541999817 50.7389907836913,13.1476202011108 50.7433738708497,13.1540088653564 50.7454147338868,13.1554832458497 50.7511253356934,13.1572360992432 50.7520027160646,13.1572360992432 50.7520027160646,13.1472549438476 50.7534294128418,13.1444158554077 50.7526664733887,13.143367767334 50.7547149658204,13.1377868652344 50.757667541504,13.1357231140137 50.7605895996094,13.1326560974121 50.7567939758302,13.1256160736085 50.7620964050294,13.1241922378539 50.7602462768555,13.1198282241821 50.7626571655273,13.1190328598022 50.7613906860352,13.1216506958009 50.7604827880861,13.1203632354737 50.7582969665528,13.1174192428589 50.7594451904297,13.1118230819703 50.7540702819825))0.0006POINT(13.130488418951305 50.730469029124215)
55176POLYGON((5.189356327057 45.1639556884767,5.18845081329346 45.1707382202148,5.1757836341859 45.1812744140626,5.16977357864374 45.194435119629,5.16977357864374 45.194435119629,5.15934896469128 45.1828079223633,5.14082145690924 45.1786003112793,5.14082145690924 45.1786003112793,5.13334608078009 45.1696166992188,5.13695573806768 45.1634521484375,5.13091373443604 45.1542625427247,5.13395643234264 45.1206054687501,5.13395643234264 45.1206054687501,5.14825296401989 45.1208534240723,5.16472244262695 45.1285705566406,5.17915630340588 45.1309623718262,5.18827438354498 45.1282196044922,5.18827438354498 45.1282196044922,5.18965148925781 45.1409530639648,5.1839275360108 45.149829864502,5.19073247909557 45.1542472839356,5.189356327057 45.1639556884767))0.0006POINT(5.163630962371884 45.15501167660671)
36129POLYGON((6.58804750442516 47.6532707214356,6.59716844558716 47.6673011779785,6.59716844558716 47.6673011779785,6.59950304031378 47.667308807373,6.59950304031378 47.667308807373,6.60988330841076 47.6571044921875,6.60988330841076 47.6571044921875,6.59357118606579 47.6515350341798,6.59357118606579 47.6515350341798,6.58804750442516 47.6532707214356))0.0006POINT(6.598699940575571 47.65997441609702)
20877POLYGON((7.99003028869629 48.9310073852538,7.98055839538586 48.9128036499024,7.98055839538586 48.9128036499024,7.97098684310924 48.915210723877,7.97098684310924 48.915210723877,7.96089172363287 48.9203071594239,7.96089172363287 48.9203071594239,7.95287418365484 48.9239807128906,7.95025825500494 48.9302520751953,7.9592137336731 48.9326667785645,7.96376514434809 48.9419479370117,7.96376514434809 48.9419479370117,7.99003028869629 48.9310073852538))0.0006POINT(7.967065056165107 48.92487049102785)
35608POLYGON((5.96400690078735 47.3372001647949,5.96356010437006 47.3372650146484,5.96356010437006 47.3372650146484,5.94294881820673 47.3413047790528,5.94176912307745 47.3442001342774,5.94176912307745 47.3442001342774,5.93858337402355 47.342414855957,5.92670392990112 47.3447608947753,5.92670392990112 47.3447608947753,5.92520952224731 47.3382568359376,5.93066263198847 47.3289146423341,5.92644119262701 47.3270721435548,5.92644119262701 47.3270721435548,5.92198419570917 47.3186988830566,5.92730903625494 47.3104324340821,5.92730903625494 47.3104324340821,5.94481658935553 47.311824798584,5.94481658935553 47.311824798584,5.96400690078735 47.3372001647949))0.0006POINT(5.938033077451934 47.33099450005429)
53670POLYGON((5.60648965835577 44.5666542053224,5.60714769363409 44.5683517456055,5.60714769363409 44.5683517456055,5.61613321304333 44.5569686889649,5.6347446441651 44.555446624756,5.64978647232061 44.5632286071778,5.65290594100964 44.5695571899415,5.65290594100964 44.5695571899415,5.66973018646246 44.5749244689941,5.67855215072643 44.5728111267089,5.68763256073009 44.5745468139649,5.69380617141729 44.5697746276855,5.69380617141729 44.5697746276855,5.69519519805908 44.5595436096192,5.70673418045055 44.5448036193848,5.70673418045055 44.5448036193848,5.68863248825079 44.54052734375,5.67247009277349 44.5284805297852,5.64632606506348 44.520076751709,5.64632606506348 44.520076751709,5.62765312194836 44.5343589782715,5.61498689651489 44.5327758789063,5.61498689651489 44.5327758789063,5.59724903106695 44.5432739257813,5.59724903106695 44.5432739257813,5.60648965835577 44.5666542053224))0.0006POINT(5.650613269805972 44.5529887390137)
48008POLYGON((-1.75043261051172 46.9303703308106,-1.74312651157379 46.9218406677247,-1.74542272090906 46.9189033508301,-1.74542272090906 46.9189033508301,-1.73625862598414 46.9115257263184,-1.73625862598414 46.9115257263184,-1.71686971187592 46.9145317077637,-1.71132779121399 46.91996383667,-1.69759488105774 46.9237174987794,-1.69511461257935 46.9297180175782,-1.68899154663075 46.9351692199708,-1.67975735664368 46.9378662109375,-1.67984485626215 46.9413070678711,-1.67984485626215 46.9413070678711,-1.68659901618952 46.946144104004,-1.68671929836273 46.952995300293,-1.67973530292511 46.9652748107911,-1.67973530292511 46.9652748107911,-1.69091856479639 46.9688873291017,-1.69091856479639 46.9688873291017,-1.71126902103424 46.969871520996,-1.73000299930567 46.9751014709474,-1.73531591892237 46.9808349609376,-1.73531591892237 46.9808349609376,-1.74363970756525 46.9647254943848,-1.75367391109467 46.9573326110841,-1.7428365945816 46.9465866088868,-1.75043261051172 46.9303703308106))0.0006POINT(-1.7138128722155204 46.944422262686324)
1398668POLYGON((-4.05616807937622 42.2806396484376,-4.0558128356933 42.2934684753419,-4.04682588577271 42.2936058044434,-4.03814697265619 42.3020324707031,-4.02983283996571 42.3010902404786,-4.02592897415161 42.3035049438478,-4.01953077316278 42.3024673461914,-4.01708984374994 42.3045883178712,-4.01582813262939 42.3150634765626,-4.01065587997437 42.3210639953613,-4.00630092620838 42.3226242065429,-4.00294780731195 42.3316268920898,-3.99156594276423 42.3395385742189,-3.98507499694819 42.34135055542,-3.98212599754333 42.344467163086,-3.97741699218744 42.3446235656739,-3.97448897361755 42.338966369629,-3.96143102645868 42.3360595703126,-3.95397591590881 42.3318786621094,-3.95049595832825 42.3167800903321,-3.95514988899231 42.3139953613282,-3.94939804077148 42.3099060058594,-3.95571494102472 42.3080444335938,-3.96292901039124 42.3028335571289,-3.96488904952997 42.2882614135743,-3.97624802589417 42.2854537963867,-3.99794101715082 42.2881584167482,-4.01635217666626 42.282901763916,-4.02668285369867 42.2782516479493,-4.03270721435541 42.2712707519532,-4.03688716888422 42.270450592041,-4.04067897796631 42.2716140747071,-4.05300521850586 42.2808151245118,-4.05616807937622 42.2806396484376))0.0006POINT(-4.002128131461833 42.30658779722276)
58095POLYGON((6.71515321731567 50.0704421997071,6.71902084350586 50.0714378356934,6.72404050827038 50.0706291198731,6.73048448562622 50.0651206970215,6.73341083526617 50.0589561462402,6.73926162719727 50.0548896789552,6.74638175964355 50.0520973205566,6.75243473052984 50.0511054992675,6.7602939605714 50.0476150512695,6.7602939605714 50.0476150512695,6.76219892501837 50.0428047180176,6.75894021987921 50.0374908447266,6.75944852828985 50.0354804992676,6.75717735290539 50.0339546203613,6.75694751739513 50.0308494567872,6.75189971923839 50.0287208557129,6.75189971923839 50.0287208557129,6.75142192840576 50.0291023254395,6.75142192840576 50.0291023254395,6.74642515182495 50.0337562561035,6.73737525939947 50.0363845825195,6.73264789581305 50.0397262573243,6.7252397537232 50.0415802001954,6.72027206420904 50.0386238098145,6.71879911422735 50.0392036437989,6.71700239181524 50.0425262451172,6.71700239181524 50.0425262451172,6.7182993888855 50.0434494018555,6.71802043914806 50.0453643798829,6.70937395095831 50.0528144836425,6.70516777038574 50.055061340332,6.70339488983154 50.0575561523438,6.69846439361578 50.0594139099122,6.69795179367071 50.0638084411622,6.6950244903565 50.0680084228516,6.69721603393566 50.0729560852051,6.69488525390619 50.0761756896973,6.69742250442505 50.0815315246583,6.69742250442505 50.0815315246583,6.70043802261364 50.0791969299316,6.70026540756231 50.0766410827638,6.70373153686535 50.0718307495117,6.71515321731567 50.0704421997071))0.0006POINT(6.726999385016357 50.05204291570755)
35926POLYGON((6.68922185897827 47.1492156982422,6.70426750183111 47.1653175354004,6.70426750183111 47.1653175354004,6.691330909729 47.1695709228515,6.68681859970098 47.168327331543,6.67834854125988 47.165065765381,6.67188882827759 47.1561851501465,6.67188882827759 47.1561851501465,6.68922185897827 47.1492156982422))0.0006POINT(6.687254071235691 47.16189813613893)