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 |
---|---|---|---|
1403374 | POLYGON((1.53683996200573 41.3853874206544,1.53111696243298 41.3876838684083,1.51888203620922 41.3888206481935,1.51188802719122 41.3943557739258,1.50931203365326 41.3944625854493,1.50521898269659 41.3914642333984,1.49486899375927 41.3899612426758,1.4847140312196 41.3824462890626,1.47855305671692 41.3818664550782,1.47752094268805 41.3830032348634,1.47306299209606 41.3807830810547,1.4803290367127 41.3878669738771,1.48248004913336 41.3986320495605,1.4901900291444 41.4015083312988,1.48502600193035 41.4135246276855,1.48178994655609 41.4167137145997,1.48381805419916 41.4222145080568,1.4771009683609 41.4234924316406,1.47511804103863 41.4294776916505,1.47770798206329 41.4331703186035,1.48336195945745 41.4303245544434,1.4911979436875 41.4353523254395,1.49522495269787 41.4356346130371,1.50298297405243 41.428108215332,1.51074099540716 41.4345588684083,1.52246499061596 41.4383125305176,1.5355180501939 41.4400024414063,1.54144597053534 41.4397468566896,1.54560303688055 41.4374351501465,1.54628205299372 41.4339637756348,1.54313194751734 41.4306678771973,1.54404199123383 41.4246826171875,1.54001200199127 41.4171714782715,1.53310203552252 41.4113845825196,1.53804302215588 41.4072875976562,1.54236698150646 41.4073600769044,1.54208195209503 41.4022483825684,1.53624498844147 41.3888473510742,1.53683996200573 41.3853874206544)) | 0.0006 | POINT(1.5091943678103543 41.41131380984661) |
1390902 | POLYGON((-3.89703202247614 43.2315063476563,-3.90202093124384 43.2349433898927,-3.9053258895874 43.2353591918946,-3.90962910652155 43.2481117248536,-3.92210507392883 43.2617416381837,-3.92377090454102 43.2660064697266,-3.92492699623102 43.2739295959473,-3.92299199104303 43.2796897888184,-3.92449808120728 43.2831268310548,-3.91058397293079 43.2880897521973,-3.89075303077698 43.2849311828614,-3.86682891845703 43.2857818603517,-3.86480307579035 43.2836380004883,-3.85417294502253 43.2806739807129,-3.84589695930481 43.2828712463378,-3.83793210983276 43.2826766967774,-3.83953905105579 43.2803230285645,-3.83810710906982 43.2784080505372,-3.8428161144256 43.2731399536133,-3.84695291519165 43.2718582153321,-3.84788489341736 43.2662773132324,-3.84546208381647 43.2612991333008,-3.84505891799921 43.25345993042,-3.8427140712738 43.2512855529786,-3.84234690666193 43.2479057312012,-3.85416793823242 43.24422454834,-3.8681919574737 43.2446670532227,-3.89703202247614 43.2315063476563)) | 0.0006 | POINT(-3.8746857025004857 43.265775044759174) |
64443 | POLYGON((11.372826576233 47.7244567871094,11.3653697967529 47.7186851501465,11.3676710128785 47.7152900695801,11.3672885894776 47.7115364074708,11.3714513778688 47.7078170776368,11.3713531494141 47.7062721252441,11.3640222549439 47.7019767761232,11.3562860488892 47.7007331848145,11.3547945022584 47.7000045776367,11.3550596237183 47.6974678039551,11.3440799713134 47.6936988830567,11.3440799713134 47.6936988830567,11.3423128128052 47.6931190490723,11.334379196167 47.6962242126465,11.3304824829103 47.6993408203126,11.3203506469728 47.704402923584,11.3223724365235 47.7068824768067,11.3238162994386 47.7112159729004,11.3239526748658 47.7135581970215,11.3220882415771 47.7153015136719,11.3055562973022 47.7091598510742,11.3055562973022 47.7091598510742,11.3061876296998 47.7162284851075,11.3054924011231 47.7189941406251,11.3075609207153 47.7205467224121,11.3082332611085 47.7228469848634,11.3104486465455 47.7225723266602,11.3112373352051 47.72123336792,11.312557220459 47.7222442626954,11.3168325424195 47.719581604004,11.3198070526123 47.7190933227539,11.3211650848389 47.7198448181153,11.3167915344239 47.7227439880372,11.3193197250367 47.7253189086915,11.3179302215576 47.7265625,11.318717956543 47.727294921875,11.3179168701171 47.7278480529786,11.3186740875245 47.7287254333496,11.320074081421 47.7283325195313,11.3218441009523 47.7327270507813,11.3178396224977 47.7341918945312,11.3180780410768 47.7358551025392,11.3165330886841 47.7361755371094,11.3161401748658 47.7374267578125,11.3161401748658 47.7374267578125,11.3263597488404 47.7378578186036,11.329137802124 47.7394943237304,11.3311290740967 47.7382240295411,11.3343114852905 47.7381782531739,11.3347854614258 47.7370491027833,11.3366050720215 47.7374954223633,11.3364133834839 47.7387924194336,11.3374996185302 47.7391853332521,11.3432331085206 47.7392768859864,11.3446998596191 47.7405014038086,11.3493709564209 47.7395133972169,11.3535747528076 47.7412185668945,11.3535747528076 47.7412185668945,11.361294746399 47.7398605346681,11.3648900985718 47.7378578186036,11.3711013793946 47.7382621765137,11.3722562789918 47.7347412109375,11.3708419799805 47.7282218933106,11.3736448287965 47.7290267944336,11.3736448287965 47.7290267944336,11.3753042221069 47.7285423278809,11.372826576233 47.7244567871094)) | 0.0006 | POINT(11.336277961730998 47.72283883528277) |
36700 | POLYGON((5.45227003097546 47.1662673950196,5.46492242813116 47.162223815918,5.48775148391724 47.1635551452638,5.48775148391724 47.1635551452638,5.49760961532598 47.1830444335938,5.49760961532598 47.1830444335938,5.49500226974499 47.1846466064453,5.49500226974499 47.1846466064453,5.48317527771002 47.1903266906738,5.45924282073986 47.1893844604493,5.45254755020153 47.1938133239747,5.45254755020153 47.1938133239747,5.45891571044916 47.1819343566895,5.45227003097546 47.1662673950196)) | 0.0006 | POINT(5.475719085106548 47.180019672100414) |
30620 | POLYGON((-3.94372487068176 48.3837928771973,-3.94837188720703 48.3855056762695,-3.97131133079523 48.3766059875489,-3.98156666755676 48.3755302429199,-4.00718688964844 48.3877868652345,-4.0143780708313 48.4010009765625,-4.0251441001891 48.4087715148926,-4.0258584022522 48.4122772216797,-4.02303171157837 48.415283203125,-4.00918960571289 48.4201316833496,-4.00810527801508 48.4235916137696,-4.01231622695923 48.4257545471192,-4.01231622695923 48.4257545471192,-4.01060867309565 48.4290161132812,-3.98172497749329 48.4357070922852,-3.98012042045593 48.4425125122071,-3.9700195789336 48.4500541687013,-3.9700195789336 48.4500541687013,-3.96174669265747 48.4428634643556,-3.94949245452881 48.441047668457,-3.94949245452881 48.441047668457,-3.93040728569025 48.4291343688965,-3.91783332824701 48.4026489257814,-3.91783332824701 48.4026489257814,-3.9195020198822 48.4018287658691,-3.9195020198822 48.4018287658691,-3.94372487068176 48.3837928771973)) | 0.0006 | POINT(-3.975415541575479 48.415853060208875) |
56532 | POLYGON((4.48108816146856 45.6601066589356,4.47341060638428 45.6578216552734,4.45711278915411 45.6622276306153,4.45711278915411 45.6622276306153,4.45721340179443 45.6655502319337,4.44105815887451 45.6770629882814,4.44105815887451 45.6770629882814,4.44852161407465 45.6853675842285,4.44610214233404 45.6881752014161,4.44610214233404 45.6881752014161,4.45852088928234 45.6991004943847,4.45852088928234 45.6991004943847,4.4656167030335 45.6952514648438,4.47403812408447 45.7026023864746,4.47858095169067 45.7028121948243,4.47858095169067 45.7028121948243,4.48632955551147 45.6945838928223,4.50380992889404 45.6894531250001,4.50380992889404 45.6894531250001,4.50771284103399 45.6794128417969,4.50668668746954 45.6690864562989,4.5023012161256 45.6674804687501,4.5023012161256 45.6674804687501,4.48108816146856 45.6601066589356)) | 0.0006 | POINT(4.472851732502849 45.681843799093556) |
68853 | POLYGON((14.6979684829712 50.8874931335449,14.7043628692628 50.8918762207032,14.7055778503419 50.8934898376465,14.7052907943727 50.8956718444824,14.7087583541871 50.8985481262207,14.7232866287231 50.9042663574219,14.7213973999023 50.9052734375001,14.7223854064943 50.9062614440919,14.7223854064943 50.9062614440919,14.7176027297974 50.910888671875,14.7174835205079 50.9136619567871,14.7234001159668 50.9177360534669,14.7220039367677 50.919002532959,14.7314310073853 50.9204444885255,14.7290525436403 50.9239120483399,14.7241115570069 50.9232063293457,14.714075088501 50.931079864502,14.714075088501 50.931079864502,14.7122459411622 50.9329299926759,14.7064323425293 50.9351844787598,14.7064323425293 50.9351844787598,14.6944265365602 50.9298515319824,14.6854286193847 50.9296989440919,14.6793804168701 50.9257164001465,14.6731004714966 50.9237518310548,14.6637744903566 50.9240608215333,14.6550188064576 50.9275550842285,14.6517724990846 50.9266510009767,14.6517724990846 50.9266510009767,14.6561145782471 50.9254608154297,14.6594686508179 50.922950744629,14.6704120635987 50.9206504821778,14.6725330352784 50.9172744750978,14.6735048294067 50.9082641601563,14.676248550415 50.9050216674805,14.6810493469238 50.9037208557129,14.6833953857423 50.9008064270021,14.6883888244629 50.8997611999512,14.6861982345581 50.8972816467286,14.6881446838379 50.8962631225587,14.6858730316162 50.8949317932129,14.688892364502 50.8919219970704,14.6979684829712 50.8874931335449)) | 0.0006 | POINT(14.695110888708253 50.91384996686667) |
41050 | POLYGON((5.9876275062561 49.2096176147462,5.98594856262218 49.201473236084,5.97877168655401 49.1948585510255,5.97877168655401 49.1948585510255,5.97399187088024 49.1941032409669,5.96730852127087 49.1986770629883,5.96878528594976 49.2050361633301,5.96304273605352 49.217197418213,5.96304273605352 49.217197418213,5.96408319473278 49.2219314575195,5.96408319473278 49.2219314575195,5.96862459182739 49.2225646972657,5.97169780731201 49.2311058044435,5.976158618927 49.2319946289062,5.976158618927 49.2319946289062,5.97828435897839 49.2216796875001,5.9876275062561 49.2096176147462)) | 0.0006 | POINT(5.972898811101973 49.213513851165835) |
63018 | POLYGON((14.0542907714844 53.7114639282227,14.0564422607423 53.7105102539062,14.0566883087159 53.7073097229004,14.0593128204346 53.7050056457519,14.0617809295654 53.7042121887208,14.059380531311 53.7020416259767,14.062629699707 53.7005119323731,14.0619897842408 53.6945381164551,14.0619897842408 53.6945381164551,14.0531702041627 53.6949195861816,14.0504951477051 53.695571899414,14.0482044219971 53.6979751586915,14.0449075698853 53.6978797912598,14.0447235107422 53.6954231262208,14.0483942031861 53.6950912475587,14.0454835891725 53.6945190429688,14.045283317566 53.6909332275392,14.0434064865112 53.6905937194825,14.0385007858276 53.6863212585449,14.0313138961793 53.6778793334961,14.0339994430543 53.6726913452148,14.0377731323243 53.6719703674318,14.0350542068481 53.6697731018066,14.0344142913819 53.6674156188966,14.0325613021852 53.667652130127,14.0303344726564 53.6621322631837,14.0252246856691 53.6617698669434,14.0240268707276 53.660816192627,13.986879348755 53.6536293029786,13.986879348755 53.6536293029786,13.9837093353273 53.6600151062012,13.9767179489136 53.6670989990236,13.9737424850465 53.6738662719727,13.9653348922731 53.6725273132325,13.963436126709 53.6774215698243,13.9526100158693 53.6897506713868,13.9526100158693 53.6897506713868,13.9532880783082 53.6916122436523,13.9602794647218 53.6926307678223,13.9564828872681 53.6999855041504,13.9959650039673 53.705623626709,13.9990215301513 53.7089538574219,13.9986085891723 53.7117347717285,13.9986085891723 53.7117347717285,14.002516746521 53.7122650146485,14.0001678466798 53.7143554687501,13.9936447143555 53.7163925170898,13.9946517944337 53.718360900879,14.0024366378784 53.7229614257813,14.0033102035522 53.7257232666016,14.0117588043213 53.7251625061036,14.017056465149 53.7282218933107,14.0224037170411 53.7273979187012,14.0283794403077 53.7245826721192,14.0290880203248 53.7237777709962,14.0285377502441 53.7222213745118,14.0315914154054 53.7211723327638,14.0314912796021 53.7191848754884,14.0325937271119 53.718002319336,14.0396518707276 53.7199516296387,14.0408430099488 53.7157630920411,14.0461921691895 53.7155380249025,14.0542907714844 53.7114639282227)) | 0.0006 | POINT(14.020036543569313 53.69697515426146) |
19201 | POLYGON((10.6319112777711 43.5742340087891,10.6424751281738 43.5719833374023,10.6529979705811 43.5682563781738,10.6579084396362 43.5581207275391,10.6581659317018 43.554874420166,10.6615772247315 43.5528717041016,10.6705131530762 43.5563774108888,10.6817321777344 43.5644798278809,10.6901416778565 43.5732002258301,10.6901416778565 43.5732002258301,10.6891794204712 43.578426361084,10.6924705505372 43.582302093506,10.7224321365356 43.5814590454103,10.7224321365356 43.5814590454103,10.7005596160889 43.597297668457,10.6980943679811 43.6025581359863,10.6850662231445 43.6125450134278,10.6850662231445 43.6125450134278,10.681601524353 43.6109504699707,10.6794128417969 43.6111259460449,10.6755838394165 43.612892150879,10.6746616363525 43.6149406433105,10.6724681854248 43.61625289917,10.6624221801758 43.6164321899414,10.6608238220215 43.6137466430664,10.6608238220215 43.6137466430664,10.6676273345948 43.6141891479493,10.6678924560546 43.6063041687013,10.6578254699708 43.5952529907227,10.654751777649 43.5938453674317,10.6367673873902 43.5939254760742,10.6331644058229 43.5915527343751,10.6331644058229 43.5915527343751,10.6350469589233 43.5871543884277,10.632080078125 43.5777244567872,10.6319112777711 43.5742340087891)) | 0.0006 | POINT(10.669113813127819 43.590222276960134) |