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.
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 | geometryDieser 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:
| beliebig | Die simplifizierten Geodaten. |
| epsilon | float(5,4) | beliebig | Die Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone. |
| mittelpunkt | pointDieser 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:
| beliebig | Der geometrische Mittelpunkt des vereinfachten Polygons. |
Ausschnitt
| id_ort | geodaten | epsilon | mittelpunkt |
|---|---|---|---|
| 44074 | POLYGON((0.738691985607147 43.5462379455568,0.739507853984776 43.5481452941896,0.739507853984776 43.5481452941896,0.734236419201011 43.5528411865236,0.738260686397609 43.5584411621094,0.762613713741302 43.5617446899415,0.762613713741302 43.5617446899415,0.758121490478629 43.5696449279786,0.771316409111023 43.5687294006349,0.77479749917984 43.570899963379,0.784600138664302 43.5818557739257,0.7819806337356 43.5881195068361,0.7819806337356 43.5881195068361,0.755921900272483 43.6037445068361,0.755921900272483 43.6037445068361,0.747925996780452 43.6001205444337,0.711039066314754 43.6162910461426,0.711039066314754 43.6162910461426,0.68311786651617 43.6201438903809,0.682087242603359 43.6168289184571,0.693522214889583 43.6106910705568,0.694498300552368 43.5968856811525,0.689974367618674 43.5871200561524,0.677795886993465 43.5829734802247,0.674590766430015 43.5728416442871,0.674590766430015 43.5728416442871,0.684896767139378 43.5588912963868,0.68414801359188 43.5532150268556,0.69327270984644 43.5463523864747,0.69327270984644 43.5463523864747,0.705906808376312 43.556583404541,0.720458507537899 43.5485649108886,0.738691985607147 43.5462379455568)) | 0.0006 | POINT(0.7250690590590575 43.57672333717354) |
| 41305 | POLYGON((6.19049644470226 48.4491004943849,6.18542480468744 48.4440307617189,6.18951845169073 48.4343338012695,6.21387958526617 48.4297943115234,6.22430419921886 48.4226417541504,6.22430419921886 48.4226417541504,6.22764015197754 48.4249725341798,6.21872377395636 48.4324531555176,6.22639513015747 48.4399452209474,6.22639513015747 48.4399452209474,6.19049644470226 48.4491004943849)) | 0.0006 | POINT(6.212708187103317 48.433985900878966) |
| 63979 | POLYGON((14.0768613815308 53.0796852111817,14.0727396011353 53.0793151855469,14.0705966949464 53.0767097473146,14.069839477539 53.0682258605958,14.0664319992067 53.0648803710938,14.0682592391969 53.0610466003419,14.067500114441 53.0538520812988,14.0702962875367 53.0481452941895,14.0695247650147 53.0400581359864,14.0758790969849 53.0388641357421,14.0758790969849 53.0388641357421,14.0771389007569 53.0404090881348,14.1022119522095 53.0440902709962,14.1185770034791 53.050636291504,14.1168785095215 53.0523338317871,14.1167335510254 53.0534820556641,14.1177263259888 53.0535697937012,14.1177263259888 53.0535697937012,14.1192684173585 53.0574455261232,14.1208896636963 53.0586395263672,14.1361103057861 53.0611495971681,14.1311082839966 53.0646553039552,14.1210212707521 53.0666389465332,14.116192817688 53.069175720215,14.1082382202148 53.0714912414551,14.1041193008423 53.0717468261719,14.1007690429688 53.0706024169922,14.0973176956177 53.080909729004,14.0875453948975 53.081127166748,14.0768613815308 53.0796852111817)) | 0.0006 | POINT(14.096323473700206 53.060390340870875) |
| 48326 | POLYGON((-0.219109371304455 47.2825469970703,-0.224910229444504 47.2766189575195,-0.224910229444504 47.2766189575195,-0.236770391464177 47.2708740234375,-0.259562581777516 47.2832565307617,-0.269322037696838 47.2830543518067,-0.269322037696838 47.2830543518067,-0.283202737569809 47.2883186340332,-0.283202737569809 47.2883186340332,-0.274473875760975 47.2956657409669,-0.266450494527817 47.311378479004,-0.271348476409912 47.3121871948243,-0.288571029901448 47.3052673339844,-0.295981854200306 47.3098945617676,-0.295981854200306 47.3098945617676,-0.294687271118164 47.3127632141113,-0.3032046854496 47.3196296691895,-0.3032046854496 47.3196296691895,-0.298244565725213 47.3255920410156,-0.280535489320698 47.3324432373048,-0.274331718683243 47.3448028564454,-0.26419398188591 47.3446350097657,-0.26419398188591 47.3446350097657,-0.252953708171788 47.3400611877441,-0.24347481131548 47.3542823791505,-0.24347481131548 47.3542823791505,-0.212232813239098 47.33935546875,-0.212232813239098 47.33935546875,-0.228547334671021 47.3219299316407,-0.225077882409096 47.3082923889161,-0.233508273959103 47.2883720397949,-0.228374183177948 47.2829284667969,-0.219109371304455 47.2825469970703)) | 0.0006 | POINT(-0.26017477968705194 47.310935616493246) |
| 53327 | POLYGON((5.96774244308472 44.0745582580568,5.95838308334362 44.0761985778809,5.93511343002331 44.0733947753906,5.93511343002331 44.0733947753906,5.92907857894897 44.068042755127,5.93000030517589 44.0611915588379,5.92489194869995 44.0553665161133,5.92489194869995 44.0553665161133,5.92701292037964 44.0490036010742,5.91683101654064 44.041847229004,5.9184617996217 44.0385856628418,5.92249107360851 44.0365715026856,5.92728185653692 44.0360298156739,5.93216705322266 44.0445899963379,5.96058940887463 44.0583419799805,5.96799373626709 44.0539894104005,5.97543573379517 44.0410690307618,5.97543573379517 44.0410690307618,5.98584365844727 44.0466842651367,5.98584365844727 44.0466842651367,5.98360443115246 44.0628051757813,5.96774244308472 44.0745582580568)) | 0.0006 | POINT(5.946867011842325 44.05403736659463) |
| 1397804 | POLYGON((-3.85842800140381 39.6865425109864,-3.85966110229492 39.6874237060546,-3.87281394004816 39.6862449645996,-3.87281894683832 39.6876144409179,-3.8758590221405 39.6873855590821,-3.88619303703302 39.6937751770021,-3.89148902893066 39.6929435729981,-3.89173102378834 39.696346282959,-3.88661193847651 39.6974411010743,-3.88879299163813 39.7010269165039,-3.89894890785217 39.7043380737305,-3.90700602531427 39.7164802551271,-3.91417098045343 39.724624633789,-3.91175508499146 39.7282752990723,-3.91281700134266 39.7325630187988,-3.90521192550653 39.7301445007325,-3.90272092819208 39.7341842651367,-3.90069508552551 39.7417144775391,-3.90277290344233 39.7462272644044,-3.90176391601557 39.7476539611816,-3.89648509025574 39.7465400695801,-3.89127302169794 39.73876953125,-3.88184595108032 39.7372283935547,-3.88018703460688 39.7351150512695,-3.87246108055115 39.7323608398438,-3.86550688743591 39.7315368652344,-3.86801195144653 39.7246894836427,-3.85778307914734 39.7259178161621,-3.85417294502253 39.7207374572754,-3.84991788864136 39.7192726135254,-3.84944605827332 39.7130889892579,-3.84696197509754 39.7103309631348,-3.85341596603388 39.7068061828613,-3.85188508033752 39.6931381225587,-3.85417795181263 39.6899147033692,-3.85881996154779 39.6891136169434,-3.85842800140381 39.6865425109864)) | 0.0006 | POINT(-3.879850380950465 39.71493085225425) |
| 57304 | POLYGON((7.40682983398443 50.2596130371095,7.40347814559948 50.2586669921876,7.40274190902716 50.2596092224121,7.39600324630743 50.2572021484375,7.39572572708136 50.2577896118164,7.38845205307013 50.2566833496094,7.38751792907721 50.2578544616699,7.3837509155274 50.2561950683595,7.37963438034058 50.2604522705078,7.38621139526367 50.2631683349609,7.38606309890747 50.2658386230469,7.38253450393677 50.265022277832,7.37976741790783 50.2686233520509,7.37793684005749 50.2682571411132,7.37802362442028 50.2728805541992,7.38043832778925 50.2731246948243,7.37947845458984 50.2768020629884,7.38117790222174 50.2772331237794,7.38034105300903 50.2788429260253,7.38160848617565 50.2792282104493,7.38075447082531 50.2806625366211,7.38240957260126 50.2811317443847,7.38071584701538 50.2835807800294,7.38352060317993 50.2843055725098,7.38234186172491 50.286190032959,7.38234186172491 50.286190032959,7.38373279571528 50.2859840393067,7.38502359390253 50.2843170166016,7.39151763916021 50.2864379882812,7.39201450347912 50.2857246398926,7.3940453529359 50.2860488891602,7.3940453529359 50.2860488891602,7.39637660980219 50.284767150879,7.39909124374401 50.2854118347169,7.40000152587902 50.2835350036622,7.39436817169201 50.2820053100586,7.39575338363659 50.2797546386719,7.39906263351446 50.2802963256836,7.4003734588623 50.2795906066896,7.4013032913208 50.2772140502929,7.40430927276623 50.2778701782227,7.40491294860851 50.2755279541016,7.40732717514044 50.2749252319335,7.40802431106579 50.2728729248047,7.40802431106579 50.2728729248047,7.41032075881969 50.2706375122071,7.41158485412598 50.2712860107423,7.41487073898321 50.268310546875,7.40990209579473 50.2652435302734,7.4116063117981 50.2623863220216,7.406096458435 50.2605094909669,7.40682983398443 50.2596130371095)) | 0.0006 | POINT(7.3932056520499945 50.27362210142848) |
| 51110 | POLYGON((2.47274827957153 50.1072006225587,2.4658517837525 50.1030426025392,2.46134567260748 50.103973388672,2.46134567260748 50.103973388672,2.45778894424444 50.1127586364746,2.44613194465643 50.1174392700195,2.44613194465643 50.1174392700195,2.44999551773071 50.1244010925293,2.44999551773071 50.1244010925293,2.45504951477062 50.1311759948732,2.45504951477062 50.1311759948732,2.46939992904669 50.1336441040039,2.46939992904669 50.1336441040039,2.46464753150951 50.1245613098145,2.47441387176514 50.1135864257812,2.47274827957153 50.1072006225587)) | 0.0006 | POINT(2.4599530378977987 50.11882781982427) |
| 27688 | POLYGON((-0.327650189399719 48.6898460388184,-0.321562796831131 48.6815719604492,-0.321562796831131 48.6815719604492,-0.316925197839737 48.6761932373046,-0.316925197839737 48.6761932373046,-0.328646421432495 48.6653594970703,-0.352795958518925 48.6610908508301,-0.352795958518925 48.6610908508301,-0.371051788330078 48.6655807495118,-0.368209689855576 48.6746253967285,-0.368209689855576 48.6746253967285,-0.327650189399719 48.6898460388184)) | 0.0006 | POINT(-0.34057597138663914 48.673431743275025) |
| 45477 | POLYGON((1.35903477668762 44.505973815918,1.37222802639013 44.4987411499023,1.37222802639013 44.4987411499023,1.38582575321198 44.5076103210449,1.38815248012548 44.5138244628906,1.38815248012548 44.5138244628906,1.38085401058191 44.5252304077148,1.38085401058191 44.5252304077148,1.35931980609905 44.5264892578126,1.35931980609905 44.5264892578126,1.35277044773107 44.5180015563965,1.35903477668762 44.505973815918)) | 0.0006 | POINT(1.3726126930930738 44.51455965909091) |
