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.

Spaltenname	Datentyp	Mögliche Werte	Beschreibung
id_ort	int(10) unsigned	beliebig	Fremdschlü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"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die 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"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
39704	POLYGON((3.14873313903809 43.810359954834,3.1528017520904 43.8123092651367,3.16175389289862 43.8095779418946,3.17722439765942 43.8014183044434,3.18682694435125 43.7781295776367,3.2058510780335 43.7773666381836,3.237624168396 43.7694549560547,3.237624168396 43.7694549560547,3.23772263526922 43.7632637023926,3.24687552452087 43.7493057250978,3.24687552452087 43.7493057250978,3.23713517189032 43.7413444519044,3.21398282051092 43.7367134094239,3.2054009437561 43.72811126709,3.18124771118175 43.7262802124023,3.16318202018743 43.7309074401855,3.16318202018743 43.7309074401855,3.16090559959423 43.7377433776857,3.16665506362921 43.7474250793458,3.1662154197694 43.7541923522949,3.15362811088568 43.7590713500977,3.1451451778413 43.7676048278809,3.14601206779491 43.7813529968262,3.14287662506104 43.7840385437012,3.12367606163031 43.7850227355958,3.12367606163031 43.7850227355958,3.1280570030213 43.7944335937501,3.12330508232117 43.8031120300294,3.14873313903809 43.810359954834))	0.0006	POINT(3.17800700664525 43.76725823538647)
47285	POLYGON((2.38516211509716 50.3367195129395,2.38600516319286 50.3389167785644,2.38600516319286 50.3389167785644,2.37590575218206 50.3444938659668,2.37052869796759 50.3526573181152,2.37052869796759 50.3526573181152,2.36177444458013 50.3547096252443,2.35773682594299 50.3632392883301,2.35773682594299 50.3632392883301,2.34452176094055 50.3595046997071,2.34452176094055 50.3595046997071,2.34543800354004 50.3462028503418,2.33755493164062 50.3417549133302,2.33755493164062 50.3417549133302,2.34276103973383 50.3341064453125,2.34276103973383 50.3341064453125,2.35027575492865 50.3344230651856,2.35027575492865 50.3344230651856,2.36227703094482 50.3404655456543,2.38516211509716 50.3367195129395))	0.0006	POINT(2.358385562896758 50.345884021959826)
23442	POLYGON((-0.379889726638737 43.3469352722169,-0.378708869218826 43.3194465637208,-0.378708869218826 43.3194465637208,-0.383104056119919 43.3203735351562,-0.406145274639016 43.3045921325685,-0.412862211465836 43.2960166931153,-0.412862211465836 43.2960166931153,-0.428219586610737 43.3017807006837,-0.435191959142685 43.3099594116212,-0.435191959142685 43.3099594116212,-0.401014298200607 43.3292083740235,-0.384249657392502 43.3549919128418,-0.384249657392502 43.3549919128418,-0.379981100559178 43.3550109863282,-0.379981100559178 43.3550109863282,-0.379889726638737 43.3469352722169))	0.0006	POINT(-0.39869070251780464 43.32491607666023)
52493	POLYGON((0.4430027306081 45.7900047302247,0.456985294818935 45.7920417785645,0.456985294818935 45.7920417785645,0.474503397941703 45.7852287292481,0.495539069175777 45.7703094482423,0.510250568389949 45.768383026123,0.512817978858891 45.7714042663574,0.512817978858891 45.7714042663574,0.519912600517216 45.7630653381348,0.519912600517216 45.7630653381348,0.504750013351497 45.7547836303712,0.499220520258064 45.7455787658692,0.499220520258064 45.7455787658692,0.45172968506813 45.7624816894532,0.45172968506813 45.7624816894532,0.457995921373424 45.7712097167969,0.442434251308555 45.7833709716797,0.4430027306081 45.7900047302247))	0.0006	POINT(0.48292988889361627 45.770143172320246)
19268	POLYGON((11.1720848083496 43.2411231994629,11.1714601516724 43.2477912902832,11.1675958633424 43.2523994445801,11.1579370498657 43.2582740783691,11.152458190918 43.2587203979493,11.1332426071168 43.2690467834473,11.1296300888061 43.2731933593751,11.1460599899293 43.2785758972169,11.1486082077026 43.2802505493165,11.1475744247437 43.2911529541017,11.1540670394897 43.302574157715,11.1607294082643 43.3103828430176,11.1728515625001 43.3180580139161,11.1771173477174 43.3180198669434,11.1839294433594 43.3198814392089,11.1988525390626 43.3271293640136,11.1988525390626 43.3271293640136,11.1970357894898 43.3283805847169,11.1964797973633 43.3300247192384,11.1998100280762 43.3399505615236,11.1947526931763 43.3461532592773,11.1654729843141 43.3550415039064,11.1539268493653 43.3509826660157,11.1341037750244 43.3492889404298,11.1341037750244 43.3492889404298,11.1326961517334 43.335548400879,11.1218872070312 43.3292961120606,11.1138820648194 43.3261642456055,11.102458000183 43.3268013000488,11.0842599868776 43.3305740356446,11.0805950164794 43.3316230773926,11.0791978836061 43.3332099914552,11.0870170593261 43.3484077453614,11.0832557678223 43.3535156250001,11.076581954956 43.3535652160645,11.0716314315797 43.3592643737794,11.0646381378175 43.3699188232423,11.0649309158325 43.3760185241699,11.0573740005494 43.3817710876465,11.0469617843628 43.3830566406251,11.035306930542 43.3796997070312,11.0136337280275 43.3775520324708,11.0136337280275 43.3775520324708,11.0140161514283 43.3652038574219,10.998691558838 43.345012664795,10.9919595718383 43.3432579040528,10.9730501174927 43.3452339172364,10.9708776474 43.3326377868653,10.9738607406616 43.3242034912109,10.9709692001343 43.3152122497559,10.9665250778198 43.3139228820802,10.9551181793213 43.3131294250489,10.9530429840089 43.3030242919922,10.9530429840089 43.3030242919922,10.9719381332397 43.2979087829591,10.9845924377441 43.2890014648438,10.9857540130616 43.2864532470703,10.9857540130616 43.2864532470703,11.0024738311767 43.2840538024902,11.0213832855225 43.2886085510254,11.0224437713623 43.2905082702636,11.0247163772583 43.2917480468749,11.0315914154053 43.2931098937989,11.0489130020142 43.2825736999512,11.0579214096069 43.282554626465,11.076024055481 43.2788887023926,11.0831546783447 43.2755088806153,11.0866727828979 43.2727966308594,11.0882253646852 43.2691764831543,11.1051416397095 43.2656059265137,11.1103105545043 43.2593803405763,11.1098909378053 43.2575492858887,11.1073923110962 43.2568855285646,11.1055774688721 43.2517662048341,11.1084938049317 43.247787475586,11.1169853210449 43.2429237365723,11.1177005767822 43.2394256591798,11.1177005767822 43.2394256591798,11.1287794113159 43.2385368347169,11.1366577148439 43.2345771789552,11.1489439010621 43.2334213256836,11.1579599380493 43.2362594604492,11.1565189361573 43.2404556274414,11.1587028503419 43.2478790283203,11.1655769348146 43.2458305358888,11.1720848083496 43.2411231994629))	0.0006	POINT(11.090867345473383 43.303614941765304)
63078	POLYGON((12.6796922683715 53.8943977355956,12.6795654296874 53.896411895752,12.6816186904908 53.8985252380372,12.6831588745118 53.8997917175293,12.6861782073976 53.8993186950685,12.6884164810181 53.9020652770996,12.6894531250001 53.9048233032227,12.6887722015381 53.9051933288575,12.691107749939 53.9086494445801,12.6904134750366 53.9099807739258,12.693024635315 53.9131546020509,12.683235168457 53.914924621582,12.6827983856201 53.9141159057618,12.690320968628 53.9123649597168,12.6883182525635 53.9109802246094,12.6814308166504 53.9120445251465,12.6703033447266 53.9202537536622,12.6693735122681 53.9199104309083,12.6693735122681 53.9199104309083,12.6602125167847 53.9190750122071,12.6600980758668 53.9180068969727,12.655198097229 53.916805267334,12.6549863815309 53.9177627563476,12.6369314193726 53.9100227355958,12.6373252868652 53.9059715270997,12.6386022567749 53.9050064086914,12.6301374435425 53.9055633544921,12.633638381958 53.9117660522462,12.6334772109985 53.9146728515626,12.631995201111 53.9167366027832,12.6182308197022 53.9141693115234,12.6092176437379 53.9175834655762,12.6040449142457 53.9214096069336,12.6006240844727 53.9227523803711,12.5839052200319 53.9208068847657,12.5768613815308 53.9224967956543,12.5728664398194 53.9252319335938,12.5673847198487 53.9264984130861,12.5673847198487 53.9264984130861,12.5664005279542 53.9237213134766,12.5619916915894 53.9232177734376,12.5591459274292 53.923885345459,12.5593338012696 53.9217453002931,12.5570611953736 53.9216651916505,12.5571136474609 53.923740386963,12.5536565780639 53.9237174987794,12.5536251068115 53.9217491149902,12.5500450134278 53.922031402588,12.5490665435792 53.9196853637695,12.5477085113526 53.9205780029298,12.5408420562745 53.9192810058595,12.543004989624 53.9183197021486,12.5449714660646 53.9138679504394,12.5449714660646 53.9138679504394,12.547911643982 53.9129486083986,12.5499105453491 53.9136962890626,12.5538482666017 53.9129638671876,12.5538244247438 53.9095611572265,12.5482349395752 53.9065895080568,12.5488624572754 53.9050407409669,12.5630035400392 53.9033050537109,12.5650596618652 53.9018440246581,12.5662946701051 53.8993682861329,12.5718259811403 53.8980293273925,12.5718259811403 53.8980293273925,12.5777368545532 53.9012336730958,12.5817298889161 53.9008827209472,12.5861406326295 53.9021759033203,12.5901603698732 53.9013671874999,12.5948019027711 53.9024353027344,12.5989065170288 53.902042388916,12.6010379791259 53.9015274047853,12.6031141281129 53.8994941711426,12.6032886505128 53.898120880127,12.6020240783691 53.8972816467285,12.6016674041749 53.8924407958984,12.6026887893677 53.8899612426758,12.6023483276367 53.8892135620117,12.5976867675782 53.8912963867188,12.5917415618898 53.8881874084473,12.5926065444946 53.8875160217286,12.5945787429811 53.8883476257324,12.6022844314575 53.8879013061524,12.6015806198121 53.8843460083009,12.6025133132935 53.8838195800781,12.6086940765381 53.8851776123047,12.6181583404542 53.8852539062501,12.6356744766236 53.8826179504395,12.6386470794679 53.8827438354492,12.6441831588745 53.8888969421387,12.6478338241578 53.8950424194337,12.6479940414429 53.8985900878907,12.6541547775269 53.8948707580567,12.6638650894166 53.894630432129,12.6670026779176 53.8962287902833,12.6796922683715 53.8943977355956))	0.0006	POINT(12.612042768378057 53.90696575767117)
72299	POLYGON((14.2649192810059 48.0490493774413,14.241138458252 48.0407485961915,14.2423496246338 48.0387535095215,14.2542982101442 48.0316925048828,14.2519321441651 48.0298728942872,14.2408676147462 48.0263633728028,14.2408676147462 48.0263633728028,14.2211017608644 48.0312423706055,14.2277660369873 48.0247039794922,14.2277660369873 48.0247039794922,14.1836738586426 48.0390968322754,14.1836738586426 48.0390968322754,14.1944789886476 48.0548553466797,14.1944789886476 48.0548553466797,14.2005853652955 48.0588569641114,14.2039766311646 48.0596313476563,14.2310695648194 48.054588317871,14.2310695648194 48.054588317871,14.2564163208008 48.0558166503907,14.2593154907227 48.0543212890626,14.2649192810059 48.0490493774413))	0.0006	POINT(14.227587270736763 48.042460060119645)
25217	POLYGON((2.85922765731823 48.3116149902344,2.84033632278437 48.3144073486328,2.8326075077058 48.3185462951661,2.8084380626679 48.3211898803712,2.8084380626679 48.3211898803712,2.81613326072693 48.3311347961426,2.81613326072693 48.3311347961426,2.84382963180548 48.3417625427246,2.84382963180548 48.3417625427246,2.85344409942627 48.3397331237794,2.87138152122503 48.3442459106446,2.87138152122503 48.3442459106446,2.8770735263825 48.3399124145509,2.86855959892279 48.3339118957519,2.86855959892279 48.3339118957519,2.87049579620367 48.3147583007812,2.86889839172369 48.3116264343262,2.85922765731823 48.3116149902344))	0.0006	POINT(2.8481627913082814 48.32912287992593)
53321	POLYGON((6.16552400588995 44.4144935607911,6.16403341293335 44.4112205505372,6.14978408813482 44.4115028381348,6.13776683807384 44.4064865112305,6.12356805801403 44.4060707092286,6.12356805801403 44.4060707092286,6.1179566383363 44.4004821777343,6.12480926513672 44.3875846862794,6.13656139373785 44.3765869140626,6.13656139373785 44.3765869140626,6.1549191474914 44.3730964660646,6.16927766799927 44.3749351501465,6.19319581985479 44.372974395752,6.20229434967041 44.375286102295,6.20229434967041 44.375286102295,6.18845415115356 44.3967247009278,6.17828893661505 44.4036598205566,6.17850685119635 44.4104461669922,6.16552400588995 44.4144935607911))	0.0006	POINT(6.1581869125366655 44.39330524868442)
68928	POLYGON((13.6250114440918 51.1584930419922,13.6223783493043 51.1587333679199,13.6153726577759 51.1533889770508,13.6089324951172 51.1508865356446,13.6100111007692 51.146266937256,13.5999670028687 51.1433792114258,13.5964765548707 51.1455535888672,13.5917053222656 51.1457176208497,13.590633392334 51.1519508361817,13.5694980621338 51.1432952880861,13.5630397796631 51.1447868347168,13.5575103759765 51.1484184265137,13.5506725311279 51.1474075317383,13.5456914901733 51.1485099792481,13.5413589477539 51.1501159667969,13.5424175262451 51.1509819030762,13.5402927398682 51.1519813537599,13.5402927398682 51.1519813537599,13.5394859313964 51.1512451171876,13.535638809204 51.1539306640626,13.5306510925294 51.1551666259765,13.5228490829468 51.1512641906738,13.5198078155517 51.1507301330566,13.5163459777833 51.1481361389161,13.5144500732422 51.1487083435059,13.5131139755249 51.1473197937012,13.5090045928956 51.1470909118652,13.5102710723876 51.1425743103028,13.5073213577271 51.140365600586,13.5030536651611 51.1429786682129,13.4990005493164 51.141170501709,13.5004768371583 51.1400985717773,13.5004768371583 51.1400985717773,13.504529953003 51.1379394531251,13.5216922760011 51.1339950561523,13.5370216369628 51.1244239807129,13.5433998107911 51.121753692627,13.5519704818725 51.1200180053712,13.5564050674438 51.12064743042,13.561303138733 51.1192054748536,13.5670680999756 51.1165962219238,13.5665178298951 51.1158599853517,13.576252937317 51.1099319458009,13.5870294570923 51.1069908142091,13.5915679931641 51.1047019958497,13.5915679931641 51.1047019958497,13.5926713943482 51.1055908203125,13.5850582122803 51.1171188354493,13.589605331421 51.1181526184083,13.5877342224122 51.1188316345214,13.5953941345215 51.1242599487306,13.5954570770264 51.1256256103516,13.600911140442 51.1305580139161,13.6030893325807 51.128257751465,13.6046447753906 51.1288299560548,13.6033239364624 51.1313323974609,13.613889694214 51.135410308838,13.617805480957 51.135108947754,13.6198720932006 51.1360359191895,13.6229619979858 51.1362228393555,13.6234521865845 51.1335144042969,13.6265678405762 51.1345138549806,13.6288480758668 51.1328620910645,13.6297998428346 51.1399650573732,13.6381311416627 51.1433448791504,13.6381311416627 51.1433448791504,13.6407194137574 51.1447792053222,13.6412534713746 51.146942138672,13.6470603942871 51.1485443115234,13.6545839309692 51.1534652709961,13.6553401947021 51.161808013916,13.6514015197755 51.1609687805177,13.6386585235596 51.1622848510742,13.6332569122316 51.161190032959,13.6323671340944 51.159049987793,13.6250114440918 51.1584930419922))	0.0006	POINT(13.578687032063835 51.139032084147146)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point