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
20077POLYGON((12.6654281616212 45.7399253845214,12.6714515686035 45.7448692321778,12.6704816818237 45.7468757629395,12.6663904190065 45.7494621276855,12.6644420623779 45.7499618530273,12.6634902954103 45.7441902160645,12.6586675643921 45.7418441772462,12.6552772521973 45.74271774292,12.6475677490234 45.7483139038087,12.6535167694092 45.7521629333496,12.6631116867065 45.7565269470215,12.6650743484498 45.7624664306642,12.6650743484498 45.7624664306642,12.6649293899537 45.7649726867676,12.6678628921509 45.7695236206056,12.6569995880128 45.7790260314941,12.6564683914185 45.7892150878907,12.6576642990113 45.7922325134277,12.6576642990113 45.7922325134277,12.6533565521241 45.7937393188477,12.6465826034546 45.793384552002,12.6397562026978 45.7878952026367,12.6361589431764 45.7835960388183,12.633352279663 45.7833824157716,12.6295433044434 45.7837600708008,12.6271877288819 45.787425994873,12.6282253265381 45.7914543151855,12.6356220245361 45.7929000854492,12.6322135925293 45.7995719909669,12.6134881973267 45.8025588989259,12.5979166030885 45.79740524292,12.5979166030885 45.79740524292,12.5985584259033 45.7968673706055,12.5970659255983 45.7950820922853,12.5903825759889 45.7926101684571,12.5875310897828 45.7946166992188,12.5828676223755 45.7944946289063,12.5799188613892 45.7925148010255,12.5786514282228 45.7897415161134,12.5794095993043 45.7873649597169,12.5854520797729 45.7814865112305,12.5877914428712 45.7776412963867,12.5788631439209 45.7662582397462,12.5815982818604 45.7586135864258,12.5847206115723 45.757152557373,12.5925054550171 45.7504272460938,12.5925054550171 45.7504272460938,12.5965595245362 45.7502555847168,12.6118268966675 45.7433242797852,12.6094045639038 45.7366180419922,12.6094045639038 45.7366180419922,12.6436080932618 45.7378807067871,12.6448879241944 45.7247276306152,12.6477851867677 45.7248535156251,12.6563034057617 45.7312011718751,12.6613693237305 45.737174987793,12.6654281616212 45.7399253845214))0.0006POINT(12.628961682319686 45.768418175833595)
29458POLYGON((5.40384435653687 46.8895187377931,5.40059375762945 46.8828849792481,5.40403699874889 46.8690071105958,5.41523456573486 46.8618087768555,5.42516803741461 46.8598594665528,5.42516803741461 46.8598594665528,5.43077707290649 46.8502464294434,5.42104959487915 46.8426513671874,5.42031526565557 46.832389831543,5.41021728515631 46.8325843811036,5.41021728515631 46.8325843811036,5.38214302062988 46.8278427124023,5.38214302062988 46.8278427124023,5.3841609954834 46.8310470581055,5.37307596206671 46.8422737121583,5.37918710708624 46.8516845703125,5.37199878692633 46.8608322143555,5.35011959075939 46.8683815002442,5.34249925613403 46.8637695312501,5.34249925613403 46.8637695312501,5.33935260772711 46.8614654541016,5.32624006271374 46.8643608093262,5.32624006271374 46.8643608093262,5.31545019149786 46.8706321716309,5.33552074432379 46.8846664428711,5.33552074432379 46.8846664428711,5.34127378463745 46.8900985717775,5.35076999664318 46.8921279907227,5.3603372573852 46.8843383789063,5.37778329849243 46.8899879455567,5.37778329849243 46.8899879455567,5.38280105590826 46.8917427062989,5.38280105590826 46.8917427062989,5.39160251617443 46.8940734863282,5.39160251617443 46.8940734863282,5.40384435653687 46.8895187377931))0.0006POINT(5.377415098462832 46.86569039481031)
69254POLYGON((9.06250190734875 54.1020202636718,9.06227684020996 54.0982284545898,9.05806636810297 54.0943527221681,9.05327606201183 54.097755432129,9.04956340789789 54.0972709655762,9.0472412109375 54.093605041504,9.04140472412115 54.0931091308594,9.03496837615972 54.0936622619629,9.03474235534679 54.0949058532715,9.03387069702154 54.0949249267579,9.03361129760742 54.093132019043,9.03122425079351 54.0927619934081,8.99027824401867 54.0937919616699,8.9733676910401 54.0958442687988,8.96520423889172 54.0980606079102,8.96532249450695 54.104206085205,8.96664810180664 54.1052017211915,8.94194507598883 54.106918334961,8.94194507598883 54.106918334961,8.93972301483154 54.1095848083496,8.93861103057856 54.1143074035646,8.93250083923351 54.123821258545,8.93250083923351 54.123821258545,8.94417285919189 54.1257019042969,8.94906139373774 54.1275520324707,8.95289993286127 54.1309738159181,8.95120906829845 54.135051727295,8.95120906829845 54.135051727295,8.95518302917492 54.1372833251954,8.96670532226574 54.1389045715333,8.97568035125738 54.1390151977538,8.97858238220221 54.1400108337403,8.97858238220221 54.1400108337403,8.98201370239263 54.142936706543,8.9872341156007 54.144142150879,8.98076057434082 54.1498641967775,8.99333477020264 54.1495246887208,9.00024509429937 54.1509971618652,9.00378513336182 54.1496582031251,9.0066347122193 54.1433715820314,9.01167774200439 54.1420707702637,9.01264953613293 54.1356353759766,9.05420303344727 54.1408462524415,9.05420303344727 54.1408462524415,9.0570850372315 54.1347274780274,9.0570850372315 54.1347274780274,9.05823230743408 54.1315155029297,9.05494689941412 54.1314125061036,9.05306434631353 54.1255264282227,9.04486942291265 54.1254653930665,9.04424858093273 54.1239242553712,9.04143810272217 54.1233711242676,9.04015159606934 54.1207160949708,9.03906917572027 54.1210708618165,9.03657627105713 54.1156692504883,9.04199790954601 54.1158485412597,9.04204654693615 54.1071739196778,9.04363918304449 54.1070747375488,9.04389190673834 54.1059188842774,9.0499639511109 54.1021804809571,9.05436611175543 54.1003456115724,9.0551500320434 54.1024818420411,9.06250190734875 54.1020202636718))0.0006POINT(9.009332964497277 54.119303303380185)
24170POLYGON((3.50134921073914 45.3201332092285,3.51309084892279 45.3255729675294,3.51974177360546 45.3338203430177,3.52848529815674 45.3309516906739,3.54697394371033 45.3338890075684,3.54697394371033 45.3338890075684,3.54042673110962 45.3472747802736,3.54042673110962 45.3472747802736,3.53064274787909 45.348373413086,3.51100373268139 45.3680152893066,3.51596379280096 45.3738899230958,3.5153381824494 45.3808364868165,3.5153381824494 45.3808364868165,3.51058936119085 45.3799285888672,3.4886076450349 45.3866920471191,3.48078179359442 45.3831214904785,3.48078179359442 45.3831214904785,3.48011088371283 45.3705177307129,3.46675062179577 45.3723487854005,3.46474552154547 45.3693847656251,3.46474552154547 45.3693847656251,3.4796154499054 45.3604621887208,3.477202653885 45.3501968383789,3.4804151058197 45.3436203002931,3.4941704273225 45.3410835266114,3.4941704273225 45.3410835266114,3.49828243255627 45.3425788879396,3.50511264801025 45.338233947754,3.4991552829743 45.3259887695312,3.50134921073914 45.3201332092285))0.0006POINT(3.503137678935666 45.3545691391518)
62860MULTIPOLYGON(((12.5686111450195 54.3895263671875,12.5728387832642 54.389747619629,12.5781784057618 54.3883209228515,12.5792093276979 54.3920173645021,12.5812082290649 54.3941955566407,12.5753841400146 54.3959693908692,12.5739116668701 54.4024429321289,12.5727376937866 54.4033164978027,12.5667009353638 54.4048767089845,12.5607061386108 54.4034767150878,12.5610857009888 54.4132881164551,12.5783081054688 54.4175682067872,12.5818605422974 54.4199943542481,12.5954036712646 54.4257888793946,12.5926656723023 54.428077697754,12.5926656723023 54.428077697754,12.6150379180909 54.4284973144532,12.6150922775269 54.4308471679687,12.604124069214 54.4339866638183,12.606188774109 54.4361991882325,12.6073827743531 54.4357185363769,12.6101903915406 54.4367408752442,12.6114692687989 54.4367485046387,12.612723350525 54.4349822998047,12.6150732040405 54.4360923767089,12.6324367523193 54.4295959472657,12.6385946273804 54.428897857666,12.6385946273804 54.428897857666,12.6449947357177 54.4262733459473,12.644660949707 54.4251403808594,12.6397218704224 54.4241752624512,12.6397218704224 54.4241752624512,12.6369438171386 54.424861907959,12.6336116790771 54.4234733581544,12.6336116790771 54.4215278625489,12.6297225952149 54.4206962585449,12.6291666030884 54.419303894043,12.6230554580689 54.4201393127441,12.6219453811646 54.4190292358398,12.6175003051758 54.4179153442383,12.6169443130494 54.4168052673341,12.6186103820802 54.4162483215331,12.6180543899537 54.414306640625,12.6136121749879 54.4140281677246,12.6130561828614 54.4126396179199,12.6113901138306 54.4120826721191,12.6119441986085 54.4101371765138,12.6175003051758 54.4079170227051,12.6175003051758 54.407081604004,12.6102781295776 54.4093055725098,12.6030550003052 54.4090270996094,12.6008329391481 54.4079170227051,12.5874996185303 54.4076385498047,12.585277557373 54.4068069458007,12.5836124420167 54.4048614501954,12.57972240448 54.4048614501954,12.5769433975221 54.4034729003907,12.5763893127442 54.3993072509766,12.5786123275758 54.39652633667,12.5830564498902 54.3954162597656,12.5858335494995 54.3931961059571,12.5941667556763 54.3926391601563,12.5980548858643 54.3912506103516,12.5974988937378 54.3887481689453,12.5941667556763 54.3868064880372,12.593056678772 54.383472442627,12.5913877487183 54.3837509155273,12.5913877487183 54.387638092041,12.5869436264039 54.3890266418457,12.5825004577637 54.3893051147461,12.5813884735108 54.3881950378419,12.5769433975221 54.3879165649415,12.573055267334 54.3884735107423,12.5725011825563 54.3895835876465,12.5686111450195 54.3895263671875)),((12.6382865905762 54.423194885254,12.6441659927368 54.419231414795,12.6441659927368 54.419231414795,12.6458320617676 54.4168052673341,12.6452789306641 54.4156951904297,12.6402778625489 54.4170837402345,12.6413879394532 54.4179153442383,12.6402778625489 54.419303894043,12.6386098861695 54.4184722900391,12.639165878296 54.4159736633301,12.6369438171386 54.4156951904297,12.6358337402345 54.4170837402345,12.6363878250122 54.4204177856445,12.6347217559815 54.4209709167482,12.6347217559815 54.4218063354493,12.6382865905762 54.423194885254)))0.0006POINT(12.602000235968234 54.410496879238316)
38318POLYGON((0.196227431297359 49.5856895446778,0.187650412321091 49.5872344970704,0.187650412321091 49.5872344970704,0.187153682112807 49.6046218872071,0.187153682112807 49.6046218872071,0.205247879028377 49.6102714538575,0.205247879028377 49.6102714538575,0.216036766767445 49.6121406555176,0.216036766767445 49.6121406555176,0.223713248968124 49.6045379638672,0.223713248968124 49.6045379638672,0.209417462348938 49.5956954956056,0.199716076254788 49.5945014953613,0.196227431297359 49.5856895446778))0.0006POINT(0.20345884217667484 49.601038419283405)
51177POLYGON((2.08069849014288 49.7538719177247,2.09073805809021 49.7531661987305,2.11423993110657 49.7694854736328,2.11423993110657 49.7694854736328,2.12130427360546 49.7644691467285,2.12080883979809 49.7610054016113,2.12080883979809 49.7610054016113,2.11214756965643 49.7485694885255,2.08743548393255 49.7307243347168,2.08743548393255 49.7307243347168,2.06290388107305 49.7274284362792,2.06290388107305 49.7274284362792,2.06160736083984 49.7338790893555,2.05377960205078 49.7381019592285,2.05552291870129 49.7443161010742,2.05552291870129 49.7443161010742,2.06955456733704 49.7474098205568,2.08069849014288 49.7538719177247))0.0006POINT(2.08656776652622 49.747375712675215)
26618POLYGON((0.249734222888947 49.2734680175782,0.241234838962669 49.2696762084962,0.244612202048415 49.263313293457,0.240314245223999 49.2506294250488,0.240314245223999 49.2506294250488,0.251204520464 49.2450675964355,0.251204520464 49.2450675964355,0.283568799495697 49.2543296813965,0.286712080240363 49.2609405517579,0.281980335712433 49.2664985656739,0.281980335712433 49.2664985656739,0.249734222888947 49.2734680175782))0.0006POINT(0.25935094058517766 49.25873808427293)
30604POLYGON((-4.14031028747559 48.6183166503907,-4.12899160385126 48.6073532104492,-4.12001848220825 48.6056709289552,-4.12001848220825 48.6056709289552,-4.11891984939575 48.599006652832,-4.12646102905268 48.5950965881348,-4.1284646987915 48.5885276794435,-4.1187744140625 48.5820541381837,-4.11890316009516 48.5787048339845,-4.11890316009516 48.5787048339845,-4.13336849212646 48.5764808654786,-4.14036464691156 48.5715980529785,-4.14184188842762 48.5649795532228,-4.15627574920649 48.5620613098145,-4.16613054275513 48.5632705688476,-4.16613054275513 48.5632705688476,-4.16908740997314 48.567165374756,-4.16908740997314 48.567165374756,-4.16690731048584 48.5871963500977,-4.17004394531244 48.5937805175782,-4.17004394531244 48.5937805175782,-4.15797185897821 48.5997848510743,-4.14728116989136 48.6216735839844,-4.14728116989136 48.6216735839844,-4.14031028747559 48.6183166503907))0.0006POINT(-4.1433992187181845 48.58804114659634)
14375POLYGON((13.1508474349975 46.2182044982911,13.151201248169 46.2144355773927,13.1506671905518 46.2131271362305,13.14799118042 46.2117462158203,13.1443872451783 46.2059745788575,13.1397905349731 46.1942024230958,13.1403608322144 46.1916122436524,13.13401222229 46.1869812011719,13.1266489028932 46.1832885742187,13.1266489028932 46.1832885742187,13.1201267242432 46.1902236938477,13.1085653305054 46.1940917968751,13.1085653305054 46.1940917968751,13.0971717834472 46.1933822631837,13.0904903411866 46.1962318420411,13.0851602554321 46.2011947631837,13.0836820602417 46.2037963867188,13.0843076705933 46.2089004516602,13.0828819274902 46.2126388549806,13.0776491165162 46.2169609069824,13.0713558197021 46.2189865112305,13.0713558197021 46.2189865112305,13.0929441452028 46.245891571045,13.0929441452028 46.245891571045,13.0993366241456 46.2467460632324,13.1153526306152 46.2404022216797,13.1153526306152 46.2404022216797,13.1146163940431 46.2388229370117,13.1153182983399 46.2376174926759,13.1289501190186 46.2330665588379,13.1428022384644 46.2253379821777,13.1472425460816 46.2197494506836,13.1508474349975 46.2182044982911))0.0006POINT(13.1143352389336 46.21332108974461)