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 |
|---|---|---|---|
| 44396 | POLYGON((-0.173358082771301 43.6728668212891,-0.180293947458267 43.668628692627,-0.180293947458267 43.668628692627,-0.188159838318768 43.6710891723634,-0.200937971472683 43.6701927185059,-0.200937971472683 43.6701927185059,-0.203549370169583 43.6767349243165,-0.203549370169583 43.6767349243165,-0.192317694425583 43.6822509765626,-0.174792498350143 43.6808395385742,-0.17084313929081 43.6792068481446,-0.173358082771301 43.6728668212891)) | 0.0006 | POINT(-0.18809398466887917 43.67430600253026) |
| 53900 | POLYGON((6.44595003128063 43.2698554992677,6.41829919815063 43.2700500488281,6.4056010246278 43.2659645080566,6.39871644973755 43.2697753906251,6.39871644973755 43.2697753906251,6.40512752532953 43.2750549316407,6.45296907424932 43.2786254882812,6.49875164031982 43.289981842041,6.52496004104614 43.3053398132325,6.52496004104614 43.3053398132325,6.55736160278326 43.2991065979004,6.57118844985962 43.3019943237306,6.57118844985962 43.3019943237306,6.58200788497936 43.3080444335938,6.59566164016735 43.3100776672364,6.62064409255981 43.2959709167481,6.62064409255981 43.2959709167481,6.61819505691534 43.2940292358398,6.61513900756842 43.294303894043,6.61319494247442 43.2915267944337,6.61125087738043 43.2915267944337,6.60791683197021 43.2890281677246,6.60680389404297 43.289306640625,6.60652923583996 43.2881927490235,6.60402822494501 43.2881927490235,6.60319423675543 43.2868041992188,6.60041618347162 43.285972595215,6.60097217559809 43.2848625183106,6.59819412231451 43.2840270996094,6.59513998031622 43.2845840454102,6.59402799606323 43.2831954956055,6.59208297729498 43.283748626709,6.58680486679077 43.2806930541992,6.58458280563366 43.2776374816895,6.58319520950323 43.2776374816895,6.58402681350719 43.2734718322755,6.58569478988659 43.2729148864747,6.58569478988659 43.2698593139648,6.58664560317993 43.2695846557618,6.58664560317993 43.2695846557618,6.56818962097162 43.2663078308105,6.56055021286022 43.2575263977051,6.54717493057262 43.2541961669922,6.53338479995722 43.2563209533693,6.50200653076183 43.2717323303223,6.48779678344738 43.2727241516114,6.47062683105469 43.2673263549804,6.47062683105469 43.2673263549804,6.46344375610352 43.271022796631,6.44595003128063 43.2698554992677)) | 0.0006 | POINT(6.549937228767274 43.281797759387) |
| 59674 | POLYGON((7.22979307174688 47.0932540893556,7.22729778289789 47.0844993591309,7.22729778289789 47.0844993591309,7.22850799560558 47.0821723937988,7.23517894744873 47.0775680541993,7.24047183990479 47.0764045715331,7.24047183990479 47.0764045715331,7.2503662109375 47.080322265625,7.25823879241955 47.0776672363281,7.26064395904541 47.0720405578613,7.26064395904541 47.0720405578613,7.26628494262695 47.0818481445312,7.26628494262695 47.0818481445312,7.2596230506897 47.0832061767578,7.2535800933839 47.0873222351074,7.24522876739513 47.0905113220214,7.2387061119079 47.0952377319336,7.2387061119079 47.0952377319336,7.23500108718872 47.0937614440917,7.23306179046642 47.0943984985353,7.22979307174688 47.0932540893556)) | 0.0006 | POINT(7.2447694540024 47.084012222290035) |
| 63573 | POLYGON((9.79600524902355 51.0811729431153,9.8001823425293 51.0807876586913,9.81190872192394 51.0827522277833,9.81724643707275 51.0850448608398,9.82308578491211 51.0843048095704,9.82175922393799 51.0822525024415,9.82175922393799 51.0822525024415,9.82441234588629 51.08251953125,9.82642555236816 51.0845031738282,9.83388614654541 51.0852851867676,9.83298492431652 51.0913162231445,9.83584499359142 51.0921134948732,9.83691501617432 51.0942344665527,9.84430313110357 51.0961570739746,9.84947586059576 51.0961799621582,9.85057640075684 51.0931053161621,9.85657119750988 51.0946083068847,9.85544967651362 51.0981826782227,9.85571479797369 51.1037521362305,9.86002445220947 51.1082878112794,9.86421108245855 51.1094589233398,9.87149620056164 51.1089782714845,9.87719440460216 51.1080703735352,9.89068603515625 51.1037712097167,9.89492988586426 51.1048698425294,9.90406608581549 51.1001853942871,9.90780067443859 51.100872039795,9.90860271453869 51.1085662841797,9.9125804901123 51.1116180419922,9.92499637603754 51.1120414733887,9.92917156219488 51.1142387390138,9.93412303924566 51.1138305664062,9.94235420227062 51.1151657104492,9.94326400756842 51.1180419921875,9.94326400756842 51.1180419921875,9.94616889953625 51.1225624084473,9.95226478576672 51.1256866455079,9.9543657302857 51.1294479370117,9.95693778991711 51.1296043395997,9.96162509918207 51.1335487365723,9.96159934997559 51.1406021118165,9.95714378356945 51.1485710144044,9.95734882354736 51.150634765625,9.95454692840582 51.1529045104981,9.95131015777582 51.1519889831544,9.94580745697021 51.1539001464844,9.94206619262695 51.1568679809571,9.92962646484381 51.1585731506348,9.92268085479736 51.162467956543,9.92095756530762 51.1652221679689,9.91813182830822 51.1657600402831,9.9117889404298 51.1694145202637,9.9117889404298 51.1694145202637,9.91086101531988 51.1703643798829,9.90976715087891 51.1685791015625,9.90153408050537 51.1699829101563,9.90333843231201 51.1721534729004,9.8982515335083 51.1770210266113,9.88949394226074 51.1778755187989,9.88841724395763 51.1792373657227,9.88663864135748 51.1794891357422,9.88133907318115 51.1786346435546,9.88394546508795 51.1828422546387,9.8762378692627 51.1832771301271,9.87083911895758 51.1854705810548,9.86541748046886 51.1862335205079,9.86596679687506 51.1847877502443,9.8708229064942 51.1845703125,9.87479305267328 51.1821365356446,9.86988735198975 51.1818199157715,9.86465644836431 51.1832313537598,9.86178588867199 51.1858520507814,9.85998344421392 51.1857261657716,9.85793495178223 51.1837730407715,9.85455608367926 51.1868476867676,9.85196495056158 51.1857910156251,9.85505771636963 51.1827125549318,9.85359191894543 51.1811027526856,9.84845829010021 51.1816749572754,9.85024261474609 51.1850776672363,9.84655952453619 51.1853637695312,9.84724330902105 51.1866378784179,9.8444385528565 51.1885185241699,9.8444385528565 51.1885185241699,9.84169292449945 51.1873054504394,9.83905124664312 51.1837997436523,9.83135890960693 51.18212890625,9.82915687561041 51.1799850463867,9.82438755035406 51.1791572570801,9.81858730316162 51.1745223999024,9.81743907928478 51.1747055053712,9.81768989562988 51.173267364502,9.82113933563232 51.1732444763184,9.82254600524902 51.1719741821289,9.81533718109131 51.1687927246094,9.80769824981695 51.1676216125489,9.80883216857922 51.1644973754884,9.81178760528559 51.1639671325684,9.81340503692633 51.1620330810546,9.80834484100342 51.1588172912598,9.80854034423834 51.1562538146973,9.80236434936529 51.1530761718749,9.8012495040893 51.1511192321777,9.79922580719 51.1515655517578,9.79585361480724 51.1503219604493,9.79224967956549 51.1502990722657,9.78635311126709 51.1458015441895,9.78085899353033 51.1458740234375,9.77763271331793 51.1472930908204,9.77327060699469 51.1462860107422,9.77327060699469 51.1462860107422,9.77543830871593 51.1449127197266,9.77467536926281 51.1433639526367,9.77738571167004 51.137477874756,9.77639579772949 51.1321525573732,9.77988243103033 51.1231307983398,9.78093719482433 51.1150665283204,9.77880954742437 51.1121673583985,9.77962303161621 51.1094818115235,9.77491569519049 51.1043663024902,9.77612876892101 51.1026191711425,9.77474594116222 51.1005516052246,9.774889945984 51.0932121276856,9.77752304077154 51.0893020629883,9.77517318725586 51.0860786437988,9.77753257751465 51.0831565856935,9.77753257751465 51.0831565856935,9.78334903717041 51.0821037292481,9.79284286499035 51.0824508666993,9.79600524902355 51.0811729431153)) | 0.0006 | POINT(9.853294572164883 51.14033942998842) |
| 1406286 | POLYGON((-0.235921993851662 39.8610382080078,-0.197174996137619 39.8989181518556,-0.193503007292691 39.8954849243165,-0.169661000370979 39.895923614502,-0.166170999407768 39.8900833129883,-0.157236993312836 39.8844223022462,-0.150628000497761 39.8825492858887,-0.144311994314194 39.876937866211,-0.142324998974743 39.8718948364258,-0.137288004159871 39.8667716979982,-0.097084000706673 39.8421096801757,-0.101805999875069 39.8337516784669,-0.105972997844219 39.830696105957,-0.112083002924919 39.8226394653321,-0.119584001600742 39.8159713745118,-0.12347199767828 39.8090286254883,-0.153651997446957 39.8209915161133,-0.164100006222725 39.8095207214356,-0.172062993049622 39.8136138916016,-0.171226993203106 39.8160820007324,-0.174264997243881 39.8168678283691,-0.17233599722374 39.8319702148439,-0.206909000873566 39.8550415039064,-0.213477000594082 39.8553695678712,-0.215933993458748 39.8607597351074,-0.223009005188885 39.8624420166016,-0.226668998598996 39.8606681823732,-0.235921993851662 39.8610382080078),(-0.180250003933793 39.8678894042969,-0.187463000416642 39.8704490661621,-0.196279004216137 39.8772773742677,-0.200956001877671 39.8775978088379,-0.209659993648472 39.8731307983399,-0.215160995721817 39.8645439147949,-0.212856993079185 39.8622703552246,-0.204151004552784 39.8625297546387,-0.197849005460739 39.8599357604982,-0.196005001664048 39.8572998046876,-0.196606993675232 39.8520317077637,-0.18928000330925 39.8505401611328,-0.181354999542236 39.8531417846681,-0.173766002058983 39.8512725830078,-0.171966999769211 39.8532180786133,-0.176433995366096 39.8557510375977,-0.169652000069618 39.860939025879,-0.180250003933793 39.8678894042969)) | 0.0006 | POINT(-0.1614443122723543 39.84987854337836) |
| 28159 | POLYGON((4.63830566406256 47.2027282714845,4.62133216857916 47.2002639770509,4.6089820861817 47.2038955688478,4.6089820861817 47.2038955688478,4.59789466857916 47.1993827819825,4.59789466857916 47.1993827819825,4.60411453247082 47.1939659118653,4.60929107666021 47.1806488037109,4.60447072982794 47.1709098815919,4.60447072982794 47.1709098815919,4.6100287437439 47.1633758544922,4.6100287437439 47.1633758544922,4.61594009399425 47.1628074645996,4.61594009399425 47.1628074645996,4.61956071853649 47.1716918945312,4.61956071853649 47.1716918945312,4.63462495803833 47.180305480957,4.64129161834728 47.1927719116212,4.65126276016247 47.1931152343751,4.660059452057 47.1896476745607,4.660059452057 47.1896476745607,4.65903854370129 47.1920967102051,4.65903854370129 47.1920967102051,4.65079212188726 47.1967163085938,4.65079212188726 47.1967163085938,4.64228630065929 47.1963577270508,4.63830566406256 47.2027282714845)) | 0.0006 | POINT(4.62677089984608 47.18620021526636) |
| 1390602 | POLYGON((-1.90786004066467 41.6211051940919,-1.90028095245361 41.6263542175293,-1.89783596992493 41.6324195861818,-1.8787549734115 41.6410522460938,-1.87392103672022 41.6379890441895,-1.85892903804779 41.6615371704101,-1.83452796936035 41.6606521606446,-1.82908797264099 41.6626052856446,-1.81305396556849 41.6605682373048,-1.81074094772333 41.6556968688966,-1.80534195899952 41.651481628418,-1.79555499553675 41.6521987915039,-1.79882097244263 41.640480041504,-1.79720294475544 41.6325874328614,-1.80355000495905 41.6199188232423,-1.8138250112533 41.616008758545,-1.81597602367401 41.6170768737794,-1.81817603111267 41.6162872314454,-1.8198029994964 41.6139297485352,-1.82650995254517 41.6113204956056,-1.83077704906458 41.6124076843263,-1.8354040384292 41.6113281250001,-1.84371101856232 41.6145553588868,-1.84892094135284 41.6144943237305,-1.85691905021667 41.6183738708496,-1.86766195297241 41.6162796020509,-1.88120996952057 41.6212425231934,-1.90786004066467 41.6211051940919)) | 0.0006 | POINT(-1.8394206585707191 41.631109308313505) |
| 56178 | POLYGON((3.91322517395031 45.6835670471192,3.91057181358332 45.6863021850587,3.89696383476257 45.6846351623535,3.88661313056946 45.6913642883301,3.88661313056946 45.6913642883301,3.8778309822082 45.6918106079102,3.84534502029425 45.6841430664062,3.8240220546723 45.6698036193848,3.81508135795599 45.6575317382813,3.80542850494396 45.6560516357423,3.80542850494396 45.6560516357423,3.81772089004522 45.646697998047,3.82070326805115 45.6374092102051,3.82070326805115 45.6374092102051,3.85447645187384 45.6356544494629,3.87149500846857 45.6427879333497,3.87996602058416 45.6547546386718,3.89308953285217 45.6587219238282,3.90172839164745 45.6671524047851,3.91045308113104 45.6704788208008,3.9148464202882 45.6767196655273,3.91322517395031 45.6835670471192)) | 0.0006 | POINT(3.864395516259368 45.66573388235913) |
| 52619 | POLYGON((-0.185159459710121 46.1643562316895,-0.201585337519646 46.1571159362793,-0.206312358379364 46.1514587402344,-0.185506939888 46.1424293518066,-0.185506939888 46.1424293518066,-0.197430863976422 46.1356849670411,-0.197430863976422 46.1356849670411,-0.199569314718246 46.1314544677734,-0.199569314718246 46.1314544677734,-0.204072445631027 46.1217727661133,-0.212444961071014 46.1204452514649,-0.212444961071014 46.1204452514649,-0.228627920150757 46.1254386901855,-0.239088863134384 46.1157951354981,-0.239088863134384 46.1157951354981,-0.245450660586357 46.1192817687989,-0.246871963143349 46.1253433227539,-0.254511803388482 46.1284942626954,-0.254511803388482 46.1284942626954,-0.237655982375031 46.1334648132324,-0.235110223293248 46.1430549621583,-0.243118017911854 46.1462593078614,-0.243118017911854 46.1462593078614,-0.234556034207344 46.1604804992677,-0.22643773257721 46.162036895752,-0.22643773257721 46.162036895752,-0.211758404970169 46.1667327880859,-0.211758404970169 46.1667327880859,-0.208420857787075 46.1644477844239,-0.185159459710121 46.1643562316895)) | 0.0006 | POINT(-0.2197778291743063 46.14016828865844) |
| 68659 | POLYGON((11.6875066757203 51.3280754089355,11.6830081939698 51.3268623352051,11.6844491958619 51.3242568969727,11.6801195144654 51.3228416442872,11.678484916687 51.3218040466309,11.678924560547 51.3210449218751,11.6754713058472 51.3202171325685,11.6754713058472 51.3202171325685,11.6711616516114 51.3303108215333,11.6733522415162 51.3306121826173,11.6650924682617 51.3476104736329,11.6580924987792 51.346347808838,11.651948928833 51.350025177002,11.6529073715211 51.3510246276855,11.6517925262452 51.3524208068848,11.6503944396973 51.3516693115234,11.6474628448487 51.3562507629396,11.6378068923951 51.3615646362305,11.6378068923951 51.3615646362305,11.636770248413 51.3626251220704,11.6486368179322 51.3658866882324,11.6486368179322 51.3658866882324,11.6598348617555 51.3676109313965,11.6627702713013 51.37113571167,11.6783323287964 51.3703155517578,11.6766376495362 51.3737602233887,11.6830434799195 51.3740539550782,11.6827211380004 51.3749580383302,11.7069787979127 51.3756484985353,11.7205057144166 51.3777198791504,11.7205057144166 51.3777198791504,11.723687171936 51.3713912963868,11.7273578643799 51.3672485351564,11.7273578643799 51.3672485351564,11.7161779403687 51.3652153015138,11.7047548294068 51.3604278564453,11.7061519622804 51.3589096069336,11.6993885040284 51.358009338379,11.6992053985597 51.3532142639161,11.7022132873535 51.3445816040039,11.7012281417847 51.3442497253419,11.7019701004028 51.3418579101564,11.7008094787597 51.3414382934571,11.7015733718873 51.3398551940919,11.699541091919 51.339614868164,11.6996908187867 51.337085723877,11.6979160308838 51.3368072509766,11.699239730835 51.3346672058106,11.6978530883788 51.3343582153321,11.6970558166504 51.3324165344239,11.6916465759277 51.3304557800294,11.6892910003662 51.3282089233398,11.6875066757203 51.3280754089355)) | 0.0006 | POINT(11.683668044897265 51.3494096902701) |