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 |
---|---|---|---|
56842 | POLYGON((6.07856607437139 45.699188232422,6.04823684692383 45.7007522583008,6.01851367950439 45.6969375610352,6.01851367950439 45.6969375610352,6.03201484680181 45.7149772644043,6.03440809249889 45.7250595092774,6.03440809249889 45.7250595092774,6.04225301742559 45.7392578124999,6.04225301742559 45.7392578124999,6.05023574829113 45.7481803894043,6.05507993698126 45.749195098877,6.07700538635254 45.7409477233887,6.09613275527948 45.7428207397462,6.09613275527948 45.7428207397462,6.09717321395874 45.7336006164552,6.09717321395874 45.7336006164552,6.095859527588 45.7239303588868,6.10385036468512 45.7202758789063,6.10385036468512 45.7202758789063,6.10241222381597 45.71390914917,6.08608627319342 45.7076606750489,6.07856607437139 45.699188232422)) | 0.0006 | POINT(6.067150433858275 45.724506923130626) |
51498 | POLYGON((2.76352000236517 49.6592597961426,2.74958920478832 49.6603927612305,2.74958920478832 49.6603927612305,2.73208260536205 49.6489868164062,2.72705507278442 49.6496772766114,2.72705507278442 49.6496772766114,2.73335719108593 49.6407508850098,2.72520971298218 49.6247253417969,2.72520971298218 49.6247253417969,2.74435210227972 49.6252021789551,2.75755500793468 49.6209678649903,2.75755500793468 49.6209678649903,2.74804639816296 49.6278686523438,2.7587938308717 49.6428794860841,2.75545740127563 49.6518745422364,2.7603521347047 49.6529006958009,2.76352000236517 49.6592597961426)) | 0.0006 | POINT(2.7446737289429413 49.64132809638981) |
24014 | POLYGON((2.30103993415838 45.1972236633302,2.29390430450445 45.2015380859376,2.29502844810492 45.2083320617677,2.29074645042419 45.2145004272462,2.27653002738947 45.2124481201171,2.26787590980535 45.2147140502931,2.26787590980535 45.2147140502931,2.27789998054504 45.2217674255372,2.27778363227856 45.2356872558595,2.28538131713862 45.2484588623048,2.29427218437201 45.25101852417,2.29893922805792 45.2499160766602,2.30390930175787 45.243911743164,2.31814813613897 45.2459106445313,2.31814813613897 45.2459106445313,2.3333878517152 45.2282447814941,2.35291123390203 45.217140197754,2.36749505996704 45.2152137756347,2.36986184120184 45.212085723877,2.36130499839794 45.1994934082031,2.33534622192377 45.18900680542,2.33534622192377 45.18900680542,2.32941341400152 45.1942100524903,2.30103993415838 45.1972236633302)) | 0.0006 | POINT(2.310980423637095 45.219584921132025) |
1389818 | POLYGON((-0.663528978824615 40.8318023681642,-0.665351986885071 40.8386764526368,-0.671665012836456 40.8419265747071,-0.672527015209141 40.8505477905273,-0.666916012763977 40.8586654663087,-0.665664970874786 40.867919921875,-0.657518982887268 40.8741569519044,-0.654209971427917 40.886890411377,-0.656076014041901 40.8979148864747,-0.635598003864288 40.9092445373535,-0.642660975456124 40.9203147888184,-0.6423100233078 40.9255218505859,-0.633997976779938 40.9344749450684,-0.629674971103668 40.9367828369141,-0.62742102146143 40.936393737793,-0.624872982501984 40.9402236938477,-0.611101984977722 40.9390296936036,-0.605014026164895 40.9411659240724,-0.593783020973092 40.9482345581055,-0.586885988712311 40.9421997070313,-0.58950001001358 40.9287986755372,-0.584134995937291 40.9120483398438,-0.586344003677311 40.9078521728516,-0.598968029022217 40.9008293151855,-0.602433979511261 40.9011917114258,-0.60800701379776 40.8954162597656,-0.613120973110199 40.8931427001954,-0.613382995128575 40.8894729614258,-0.611638009548187 40.8885269165039,-0.609763979911747 40.8822479248047,-0.600933015346527 40.870750427246,-0.60340499877924 40.8699645996095,-0.600470006465912 40.8583106994629,-0.605540990829411 40.856185913086,-0.608563005924225 40.8493270874025,-0.607218027114811 40.8428344726563,-0.609224021434784 40.8375625610351,-0.615119993686562 40.8282279968262,-0.643371999263763 40.8333892822266,-0.646691024303379 40.8308105468751,-0.663528978824615 40.8318023681642)) | 0.0006 | POINT(-0.6241152748465282 40.88747444152836) |
1389404 | POLYGON((-0.057921998202744 41.9796600341798,-0.070267997682038 41.9828033447266,-0.084555998444557 41.9820861816407,-0.083939999341908 41.9860229492188,-0.086157999932766 41.9887351989746,-0.078555002808514 41.9987754821778,-0.076319001614991 41.9985618591309,-0.076935999095383 42.0008506774903,-0.072246000170708 42.0044479370118,-0.067883998155537 42.0055274963378,-0.059565000236034 42.0047912597657,-0.056389998644534 42.0003242492677,-0.043979998677855 42.0000228881837,-0.03855099901557 41.9981079101563,-0.037648998200837 41.9998741149903,-0.032466001808586 41.9994354248047,-0.031109999865294 42.0005722045899,-0.015057998709381 41.9932289123536,-0.020291000604573 41.992042541504,-0.019995000213271 41.9875068664551,-0.031207999214473 41.9854621887208,-0.034329999238253 41.9803199768068,-0.040003001689854 41.9795837402344,-0.040901001542807 41.9766082763673,-0.057921998202744 41.9796600341798)) | 0.0006 | POINT(-0.05234504137960283 41.99272298812872) |
69132 | POLYGON((12.764931678772 50.8786735534669,12.7659034729004 50.8778991699219,12.7649049758912 50.8772583007814,12.7662353515626 50.876522064209,12.7529125213624 50.8681945800782,12.7542390823365 50.8673782348633,12.7509069442749 50.8652458190919,12.7453756332397 50.8761978149415,12.7381963729859 50.873950958252,12.7314939498903 50.8756904602051,12.7272071838379 50.8752975463868,12.7209186553956 50.8797645568848,12.7181539535523 50.878791809082,12.7124271392822 50.8819274902344,12.7130136489868 50.8837776184083,12.7097806930541 50.8855323791505,12.7074575424194 50.8896446228028,12.7072668075562 50.8922233581544,12.7022066116333 50.895362854004,12.7023038864137 50.8974113464355,12.6994771957398 50.899040222168,12.6992588043212 50.9001426696778,12.7012643814087 50.9004096984864,12.7013282775879 50.901767730713,12.7082071304321 50.9021339416505,12.7082071304321 50.9021339416505,12.7118587493897 50.9028816223146,12.7184314727784 50.9016151428223,12.7268829345703 50.9032974243165,12.7318534851075 50.9080810546876,12.7406749725342 50.9055976867675,12.7406749725342 50.9055976867675,12.742907524109 50.9020080566407,12.7411909103395 50.8950576782227,12.7444629669189 50.8897171020508,12.7474622726441 50.8875732421874,12.7521419525148 50.8895797729493,12.7579107284547 50.8838233947755,12.7620573043823 50.8827705383301,12.7620573043823 50.8827705383301,12.764931678772 50.8786735534669)) | 0.0006 | POINT(12.73135366439823 50.88856859207157) |
21082 | POLYGON((7.23590278625488 48.0260810852051,7.27911043167109 48.0149726867677,7.29337882995605 48.0181655883789,7.29337882995605 48.0181655883789,7.28115606307989 48.0259819030762,7.28115606307989 48.0259819030762,7.24764966964727 48.0284843444825,7.24117946624756 48.0332527160645,7.2421116828919 48.0364990234375,7.2421116828919 48.0364990234375,7.23556375503546 48.0369529724121,7.23556375503546 48.0369529724121,7.23318243026733 48.0337219238282,7.23318243026733 48.0337219238282,7.23590278625488 48.0260810852051)) | 0.0006 | POINT(7.255330562591576 48.0289595467704) |
14954 | POLYGON((7.89321184158325 43.9541473388673,7.89858913421625 43.9574890136719,7.90222692489635 43.9582366943359,7.90937423706049 43.9571533203126,7.91682291030884 43.9538192749023,7.93806314468389 43.9591369628906,7.93806314468389 43.9591369628906,7.94332790374762 43.9664001464844,7.95179510116583 43.9747276306152,7.95465421676647 43.9744338989258,7.97193098068232 43.977321624756,7.97193098068232 43.977321624756,7.96989917755127 43.9852294921876,7.96989917755127 43.9852294921876,7.96882390975946 43.9846992492676,7.94906187057501 43.9890594482423,7.94341611862177 43.9917793273927,7.93724918365484 43.9985466003418,7.93724918365484 43.9985466003418,7.93351316452026 43.9996452331544,7.93351316452026 43.9996452331544,7.93854808807367 43.9885826110841,7.94100713729858 43.9778594970703,7.919349193573 43.9774856567383,7.90836000442505 43.9799308776856,7.90378999710083 43.9823608398439,7.90267515182501 43.9840469360352,7.90371417999268 43.9858512878419,7.90368986129772 43.9885330200195,7.8975181579591 43.9953155517579,7.88820505142212 44.0012588500978,7.88808488845825 44.0056686401367,7.88808488845825 44.0056686401367,7.88166809082031 44.0046768188478,7.87511777877819 44.0021629333496,7.86674976348877 43.9936828613281,7.86252021789556 43.9879646301271,7.86252021789556 43.9879646301271,7.87214803695684 43.9825057983399,7.87615919113171 43.9701118469238,7.88604879379278 43.9550437927246,7.88905620574957 43.9521408081055,7.88905620574957 43.9521408081055,7.89321184158325 43.9541473388673)) | 0.0006 | POINT(7.9157368970472 43.980527035025716) |
1403962 | POLYGON((0.748561978340092 42.4782104492189,0.748341023921967 42.4816398620605,0.751569986343497 42.4837760925294,0.749387025833187 42.4906005859376,0.743668973445892 42.4954528808594,0.740244984626827 42.4958000183106,0.741782009601707 42.4981079101563,0.739073991775513 42.4996299743653,0.745674014091549 42.5068321228027,0.757427990436497 42.505771636963,0.760399997234344 42.513526916504,0.76509702205658 42.5188026428223,0.76818501949316 42.5300521850587,0.764630019664821 42.5324821472169,0.77434998750698 42.5436973571778,0.793727993965263 42.5483512878417,0.79119801521307 42.5556221008301,0.792068004608268 42.5623779296874,0.797128021717072 42.564868927002,0.797297000885123 42.5690422058106,0.793096005916709 42.5732765197754,0.793470025062675 42.5790481567383,0.797291994094962 42.5813827514649,0.802326977253017 42.5906639099122,0.820044994354305 42.5956459045411,0.825372993946019 42.5940895080568,0.823484003543911 42.6000633239746,0.825717985630149 42.6056671142578,0.831257998943329 42.6091651916505,0.839873015880642 42.6091346740723,0.8458349704743 42.6154747009278,0.8563609719277 42.6212615966798,0.867484986782017 42.6229553222657,0.873816013336238 42.6263275146484,0.877710998058376 42.632495880127,0.881873011589164 42.6313819885254,0.884607970714626 42.6279296875001,0.895237982273102 42.6261367797852,0.896416008472556 42.6239013671876,0.8941850066185 42.6149177551269,0.891236007213649 42.6124076843263,0.912090003490505 42.6067008972169,0.918007016182059 42.5934143066407,0.9378719925881 42.5895423889161,0.938398003578243 42.5861320495605,0.942551016807556 42.5810546875001,0.958226025104636 42.5794677734376,0.968824028968811 42.5744667053224,0.972508013248557 42.552261352539,0.968410015106315 42.5515937805175,0.964748978614921 42.546875,0.961674988269806 42.5460357666016,0.95842498540884 42.5404586791992,0.953477025032157 42.5388641357423,0.9574289917947 42.5316429138184,0.951817989349422 42.5266418457032,0.945657014846802 42.5241317749024,0.94317501783371 42.5251197814941,0.941870987415314 42.5223808288575,0.944289982318878 42.5182647705079,0.932932972908134 42.5176658630371,0.929171979427394 42.515724182129,0.927532970905418 42.5117073059083,0.923856973648071 42.5099639892578,0.919767975807304 42.5025672912599,0.919925987720546 42.4973030090332,0.924992024898586 42.4923400878907,0.921177029609623 42.485206604004,0.895039975643158 42.4802017211914,0.889874994754848 42.4765853881836,0.885661005973816 42.4664802551271,0.879675984382629 42.459156036377,0.866196990013236 42.4610443115236,0.861159980297089 42.4554786682129,0.852909982204551 42.4541549682618,0.83680301904684 42.4606208801269,0.829021990299282 42.462043762207,0.826645016670341 42.4597511291504,0.8150830268861 42.4569702148438,0.802411019802094 42.4641838073732,0.77534598112112 42.4662742614747,0.766575992107335 42.4606018066407,0.75788098573679 42.4648590087892,0.754032015800419 42.4724655151368,0.748561978340092 42.4782104492189)) | 0.0006 | POINT(0.8549957254103739 42.53757585797993) |
50240 | POLYGON((1.84422469139105 49.2089424133301,1.82780814170837 49.1969871520996,1.83800947666168 49.1893272399903,1.8490736484527 49.1704902648926,1.8490736484527 49.1704902648926,1.87449693679821 49.1742897033691,1.87449693679821 49.1742897033691,1.87511074543005 49.1807518005372,1.86816537380219 49.1853904724121,1.87156558036804 49.1942672729492,1.87156558036804 49.1942672729492,1.84422469139105 49.2089424133301)) | 0.0006 | POINT(1.8585082509301125 49.18540850552647) |