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 |
---|---|---|---|
55560 | POLYGON((5.94013166427618 44.8739891052246,5.91606855392456 44.8781127929688,5.88621568679821 44.8788642883301,5.88621568679821 44.8788642883301,5.87772035598761 44.8716011047364,5.87772035598761 44.8716011047364,5.89054059982305 44.8614807128907,5.89054059982305 44.8614807128907,5.92887067794805 44.8648300170899,5.93541383743286 44.8600959777832,5.93541383743286 44.8600959777832,5.95122623443598 44.859920501709,5.95122623443598 44.859920501709,5.95199871063244 44.8630447387695,5.95199871063244 44.8630447387695,5.94013166427618 44.8739891052246)) | 0.0006 | POINT(5.918086783091272 44.867129770914744) |
19684 | POLYGON((12.8889608383178 42.7335357666016,12.8847627639771 42.7360000610352,12.8758697509766 42.7338256835939,12.8645267486573 42.740089416504,12.857759475708 42.7496681213379,12.844165802002 42.7601013183594,12.8347311019898 42.7709922790527,12.834789276123 42.7781028747559,12.8280897140503 42.7868690490723,12.8280897140503 42.7868690490723,12.8241834640504 42.7828750610352,12.8210983276367 42.7749824523926,12.8042688369752 42.7493400573732,12.8020143508911 42.738826751709,12.8064975738525 42.7287635803224,12.8149700164795 42.7243576049805,12.8149700164795 42.7243576049805,12.8386240005494 42.7230262756349,12.8415660858155 42.7219924926759,12.8465623855592 42.7145500183105,12.8464603424073 42.7100830078126,12.8434152603151 42.704216003418,12.8466310501099 42.695583343506,12.8490867614746 42.6937408447267,12.8549337387086 42.6948318481446,12.8740034103393 42.6873016357421,12.8938131332398 42.6735801696778,12.8928136825562 42.6648635864258,12.8928136825562 42.6648635864258,12.9159708023071 42.6732559204102,12.9219779968262 42.673553466797,12.9243211746216 42.6779594421387,12.9243402481079 42.6817321777345,12.9243402481079 42.6817321777345,12.9211587905884 42.6834297180176,12.9192543029785 42.6889877319337,12.8997497558594 42.702693939209,12.8870639801026 42.7185821533203,12.8894815444947 42.7250633239747,12.8889608383178 42.7335357666016)) | 0.0006 | POINT(12.86354179871391 42.71936357938331) |
60867 | POLYGON((9.1441278457641 47.533332824707,9.13936805725109 47.5293235778809,9.13233089447027 47.526710510254,9.12663745880138 47.5265388488769,9.11483287811279 47.5293579101562,9.10266494750977 47.5278968811035,9.10155963897705 47.5230178833008,9.10333633422863 47.5198707580566,9.10382556915283 47.5111351013184,9.10382556915283 47.5111351013184,9.11098766326899 47.5147056579589,9.11631679534918 47.5135688781738,9.11774730682379 47.5124626159668,9.11793231964111 47.5108757019044,9.11474418640137 47.5069885253906,9.11645984649664 47.505786895752,9.12895202636724 47.5098876953125,9.1351108551026 47.5025482177736,9.13450336456293 47.4992828369141,9.13766479492188 47.4968872070312,9.14584064483648 47.4983825683595,9.14939498901367 47.5008506774902,9.1502952575683 47.5028839111329,9.1502952575683 47.5028839111329,9.15270328521723 47.5077056884767,9.15712261199963 47.5118293762208,9.16473388671875 47.5159378051759,9.16380119323736 47.5173568725587,9.15925884246826 47.5182685852051,9.15771675109863 47.5195274353027,9.15506744384771 47.5243721008301,9.15638256072992 47.5278434753419,9.15478134155279 47.5326728820801,9.15478134155279 47.5326728820801,9.1441278457641 47.533332824707)) | 0.0006 | POINT(9.134561875287245 47.51542652354524) |
52866 | POLYGON((0.253718644380683 46.8131103515625,0.258599728345985 46.8123435974122,0.258599728345985 46.8123435974122,0.271352291107121 46.8230819702149,0.280337810516414 46.8260612487794,0.294885188341254 46.8128356933594,0.314726412296238 46.8107147216797,0.318934589624462 46.8126525878907,0.325744330882969 46.8291511535646,0.325744330882969 46.8291511535646,0.317982345819587 46.8435554504395,0.317982345819587 46.8435554504395,0.309568285942134 46.8443069458008,0.309568285942134 46.8443069458008,0.311091542244014 46.8273773193361,0.291980385780448 46.8271102905274,0.294110536575374 46.8438529968263,0.300661414861793 46.8491439819335,0.300661414861793 46.8491439819335,0.292963236570358 46.8570861816407,0.274254411459026 46.8606185913086,0.250735789537373 46.8716468811036,0.250735789537373 46.8716468811036,0.23064644634735 46.8668212890626,0.23064644634735 46.8668212890626,0.224181190133208 46.8625144958497,0.224181190133208 46.8625144958497,0.236155375838223 46.8512878417969,0.243233174085674 46.8345298767091,0.23677387833601 46.8291282653809,0.23677387833601 46.8291282653809,0.253718644380683 46.8131103515625)) | 0.0006 | POINT(0.2770171102978099 46.839275606216965) |
44650 | POLYGON((0.724809587001914 43.20707321167,0.74301552772522 43.2155914306642,0.760382413864193 43.214153289795,0.760382413864193 43.214153289795,0.767643213272152 43.2220611572266,0.761194050312042 43.2344703674316,0.761194050312042 43.2344703674316,0.744442284107265 43.2326087951661,0.744442284107265 43.2326087951661,0.719274401664791 43.2273025512695,0.719274401664791 43.2273025512695,0.71063643693924 43.2192115783691,0.71063643693924 43.2192115783691,0.724809587001914 43.20707321167)) | 0.0006 | POINT(0.7405636539826421 43.22309376643258) |
18746 | POLYGON((14.193627357483 37.3949775695801,14.1824884414673 37.3991622924806,14.1751766204835 37.3945846557618,14.1758031845094 37.3865699768067,14.1748733520509 37.3816452026367,14.1691637039185 37.3770713806153,14.1665201187135 37.376106262207,14.1608858108522 37.3769760131837,14.1546030044556 37.3793182373048,14.1509475708008 37.3668022155763,14.1525268554688 37.3620185852051,14.148988723755 37.3562774658203,14.1459302902222 37.3543357849122,14.1444482803345 37.35445022583,14.1426658630371 37.3582878112793,14.1387948989869 37.3591232299804,14.1302022933961 37.3561668395996,14.1285753250122 37.3553009033204,14.127926826477 37.3527336120605,14.1286449432374 37.3463859558107,14.1286449432374 37.3463859558107,14.133716583252 37.3362655639648,14.133716583252 37.3362655639648,14.1440410614014 37.3350143432618,14.1560707092286 37.3268280029297,14.1678514480591 37.3250885009766,14.1947078704833 37.3329086303712,14.2081594467163 37.3350028991699,14.2165613174438 37.3373222351074,14.2197961807251 37.33890914917,14.2317514419557 37.3487129211427,14.2317514419557 37.3487129211427,14.2325925827026 37.3525428771972,14.2368755340576 37.361156463623,14.2445497512818 37.3625869750977,14.2467889785767 37.3611869812012,14.2487831115724 37.3616561889648,14.2549190521241 37.3669433593749,14.2556324005128 37.3690910339357,14.2533349990844 37.3696365356445,14.2474508285522 37.3684730529786,14.2416286468505 37.3713188171387,14.2442140579224 37.3770866394044,14.2476177215576 37.3810386657715,14.2481098175049 37.385051727295,14.2416801452637 37.3965301513672,14.2273378372192 37.4017753601074,14.2271518707276 37.3921279907226,14.2241716384888 37.3897552490235,14.2160091400147 37.3882751464845,14.1945638656616 37.3927116394044,14.193627357483 37.3949775695801)) | 0.0006 | POINT(14.192019107295055 37.3644050149357) |
61804 | POLYGON((8.85003662109375 47.4598617553712,8.84421920776367 47.4641761779785,8.83553695678722 47.4655609130861,8.82907581329357 47.4650688171388,8.82021522521978 47.4689292907714,8.80123615264904 47.4691581726074,8.796540260315 47.4731254577636,8.796540260315 47.4731254577636,8.79818820953369 47.4767837524415,8.81008529663086 47.4808731079102,8.81020641326899 47.4833412170411,8.80732631683355 47.4866600036622,8.80813884735107 47.4889106750489,8.80813884735107 47.4889106750489,8.82096958160412 47.4924850463867,8.82096958160412 47.4924850463867,8.82294273376471 47.4923782348633,8.82625961303711 47.490234375,8.83252143859863 47.484172821045,8.84078025817865 47.4828262329102,8.84382724761969 47.4785041809082,8.84837436676031 47.4752998352051,8.85397052764893 47.4727439880371,8.85844230651861 47.471950531006,8.85922622680675 47.4674644470215,8.86179828643799 47.4660873413087,8.8622083663941 47.4644088745118,8.85896015167242 47.459888458252,8.85896015167242 47.459888458252,8.85734272003185 47.4610214233398,8.85363197326672 47.4590072631837,8.85003662109375 47.4598617553712)) | 0.0006 | POINT(8.832150643871723 47.47468813004035) |
68414 | POLYGON((7.9323663711549 50.5650138854981,7.93006753921514 50.5676918029786,7.92941570281982 50.5712165832521,7.92357921600347 50.5754585266113,7.92357921600347 50.5754585266113,7.9229788780213 50.5762519836426,7.92024087905884 50.5755004882814,7.91256427764898 50.5723533630372,7.91256427764898 50.5723533630372,7.91066789627081 50.5714225769042,7.91205930709845 50.5705451965333,7.9104433059693 50.5667915344239,7.91610908508306 50.5655593872071,7.91559457778942 50.5633583068849,7.90907907485968 50.5590095520021,7.8985996246339 50.5603942871094,7.89580059051525 50.5583686828614,7.89613342285151 50.5574645996094,7.89613342285151 50.5574645996094,7.90077543258673 50.5568504333497,7.90541172027594 50.5547943115234,7.90665245056158 50.5533180236816,7.91248369216919 50.5526390075684,7.91225862503057 50.5536422729492,7.91476869583136 50.5547714233398,7.91892290115351 50.5529823303223,7.91892290115351 50.5529823303223,7.92200517654419 50.5539779663085,7.92487573623669 50.5567779541017,7.92606163024902 50.5597915649415,7.92830467224115 50.560474395752,7.92673015594482 50.5641746520996,7.9323663711549 50.5650138854981)) | 0.0006 | POINT(7.9151922017336265 50.56277668476109) |
1389732 | POLYGON((0.104111000895614 40.9006271362305,0.107614003121853 40.8983879089356,0.110137000679913 40.8919105529786,0.102502003312111 40.8834762573243,0.089078001678047 40.8759841918946,0.086257003247852 40.8661079406738,0.084650002419949 40.8649978637696,0.078248001635188 40.8671073913575,0.072743996977806 40.8653526306152,0.065471000969524 40.865562438965,0.051686998456773 40.8617248535157,0.048957999795789 40.8622550964355,0.045471001416502 40.8666725158691,0.029394000768775 40.8778305053711,0.02394700050354 40.8846015930176,0.028332000598255 40.8979797363282,0.042474001645985 40.9048194885254,0.052848998457193 40.9012336730957,0.058977998793239 40.9007797241212,0.064396999776477 40.8976097106934,0.080487996339912 40.8951988220216,0.102266997099036 40.8980026245118,0.104111000895614 40.9006271362305)) | 0.0006 | POINT(0.06954790948133331 40.88310102982959) |
30535 | POLYGON((-3.72382926940918 48.1243896484374,-3.72017145156855 48.1189727783204,-3.73248553276062 48.1129493713379,-3.72969770431519 48.1028327941895,-3.73297262191772 48.0962677001954,-3.73297262191772 48.0962677001954,-3.73972034454346 48.091148376465,-3.76457047462452 48.086769104004,-3.78844928741455 48.0739212036133,-3.79326939582819 48.0679168701173,-3.79147934913635 48.0578765869141,-3.79655289649963 48.0584602355958,-3.79655289649963 48.0584602355958,-3.79655575752253 48.0647621154786,-3.80980443954456 48.0665626525879,-3.80980443954456 48.0665626525879,-3.80942845344543 48.0734672546387,-3.83556056022638 48.1028137207032,-3.83556056022638 48.1028137207032,-3.81868648529047 48.1101875305175,-3.80837202072144 48.1107292175294,-3.78901481628412 48.1219100952148,-3.76378560066223 48.1246109008789,-3.76378560066223 48.1246109008789,-3.74621009826649 48.1295738220215,-3.72382926940918 48.1243896484374)) | 0.0006 | POINT(-3.777171707153285 48.09379348754887) |