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 |
---|---|---|---|
55026 | POLYGON((4.83483409881597 44.6581459045411,4.85008430480968 44.6561088562013,4.85008430480968 44.6561088562013,4.84032297134405 44.6461868286133,4.84032297134405 44.6461868286133,4.84572362899792 44.6300582885743,4.84384489059448 44.6165733337403,4.84384489059448 44.6165733337403,4.83123111724848 44.6253089904785,4.81413221359247 44.6217651367188,4.81413221359247 44.6217651367188,4.80733060836803 44.629467010498,4.80659008026129 44.6386299133301,4.80659008026129 44.6386299133301,4.81370019912725 44.6467514038086,4.81577682495123 44.6563987731934,4.81577682495123 44.6563987731934,4.82800674438488 44.6549797058107,4.83483409881597 44.6581459045411)) | 0.0006 | POINT(4.827907164891608 44.63977983262808) |
70750 | POLYGON((11.6824531555177 50.8637809753419,11.6810169219971 50.8648948669434,11.6812849044801 50.8670234680177,11.6840162277222 50.8676452636719,11.6850185394287 50.8695755004883,11.6845340728761 50.8706512451172,11.6829967498779 50.8706245422364,11.6826019287109 50.8741111755372,11.6826019287109 50.8741111755372,11.6817874908448 50.8756217956544,11.6776905059814 50.8750495910646,11.6756010055541 50.8767738342286,11.6736907958984 50.8765945434571,11.6711215972901 50.8813171386719,11.6688013076783 50.8835182189941,11.665301322937 50.8840751647949,11.6647424697876 50.8850250244141,11.6619358062745 50.8842964172363,11.6619358062745 50.8842964172363,11.6640739440919 50.881072998047,11.6551904678345 50.8795967102052,11.6551904678345 50.8795967102052,11.6571063995361 50.8754272460938,11.6537599563599 50.8710365295411,11.6569633483887 50.8682594299316,11.6606340408325 50.8669929504395,11.658242225647 50.8634185791016,11.654767036438 50.8616371154786,11.6553564071655 50.861083984375,11.6520528793334 50.8568801879883,11.656042098999 50.8583602905275,11.6570377349855 50.8603706359864,11.6618776321412 50.8614501953125,11.6620597839357 50.8596420288087,11.663857460022 50.8581809997559,11.6636571884156 50.8570251464845,11.661548614502 50.8562622070314,11.661548614502 50.8562622070314,11.6628961563111 50.8544235229492,11.6652994155884 50.8550186157227,11.6652994155884 50.8550186157227,11.668885231018 50.8568649291992,11.6738452911378 50.8618621826172,11.6824531555177 50.8637809753419)) | 0.0006 | POINT(11.667356380196535 50.86848210179534) |
43081 | POLYGON((5.88443994522095 48.3105697631836,5.86779594421398 48.3060569763185,5.86779594421398 48.3060569763185,5.86882209777843 48.3035850524902,5.86882209777843 48.3035850524902,5.87790298461914 48.3052978515626,5.88126850128185 48.3029212951661,5.87956714630138 48.2967414855957,5.88209962844854 48.2939529418945,5.89182281494146 48.2931213378907,5.8935599327088 48.2869186401367,5.8935599327088 48.2869186401367,5.89798164367687 48.2853965759278,5.89492225646978 48.2790641784669,5.90229034423834 48.2705535888672,5.9166312217713 48.2733268737793,5.92759418487555 48.2800750732422,5.92759418487555 48.2800750732422,5.92121315002447 48.2890663146974,5.92203092575073 48.298942565918,5.91349172592169 48.3021583557129,5.90829992294323 48.3112640380861,5.90829992294323 48.3112640380861,5.88443994522095 48.3105697631836)) | 0.0006 | POINT(5.895556802335064 48.294648377791745) |
14474 | POLYGON((13.6549263000488 46.1464767456054,13.6433992385865 46.1357612609863,13.6053924560546 46.1106491088867,13.6053924560546 46.1106491088867,13.6019697189332 46.1159629821778,13.5972766876221 46.1178283691407,13.5969772338868 46.1163635253906,13.5844459533692 46.1110000610351,13.5780296325683 46.1094741821288,13.5713863372802 46.1096000671387,13.5713863372802 46.1096000671387,13.5591354370118 46.1239395141603,13.5719957351685 46.1305618286133,13.5783786773682 46.1426277160645,13.5811290740966 46.1453895568849,13.5811290740966 46.1453895568849,13.5823774337768 46.1462249755861,13.5807523727418 46.1485290527345,13.5814514160157 46.1505165100099,13.5842447280883 46.1511344909669,13.5874891281129 46.1488609313964,13.5919294357299 46.1489143371582,13.5965385437012 46.1540031433105,13.6057300567628 46.1530914306642,13.6187009811402 46.1481819152833,13.6216440200806 46.1485023498535,13.6249723434448 46.1510810852051,13.6251630783081 46.1522445678711,13.6324443817139 46.1542320251465,13.6324243545533 46.1508293151855,13.6416835784913 46.1492156982422,13.6452131271363 46.1515617370605,13.6496753692628 46.1518096923828,13.6527137756348 46.149845123291,13.6549263000488 46.1464767456054)) | 0.0006 | POINT(13.604044072768291 46.13794270683739) |
24812 | POLYGON((2.75255918502819 45.8107261657715,2.73400449752813 45.8212814331055,2.73095560073853 45.831127166748,2.72156810760492 45.8330116271973,2.70784783363342 45.8429298400879,2.70784783363342 45.8429298400879,2.68016314506531 45.8400459289552,2.68016314506531 45.8400459289552,2.67435383796703 45.82674407959,2.67435383796703 45.82674407959,2.68871498107922 45.8085861206055,2.67916798591625 45.7962341308595,2.68380808830267 45.7862777709962,2.68380808830267 45.7862777709962,2.68701767921448 45.7763710021973,2.69436287879938 45.7722320556642,2.70233869552612 45.7798156738282,2.71971774101257 45.7839126586914,2.72965168952948 45.7764549255372,2.72965168952948 45.7764549255372,2.74515461921703 45.7940940856933,2.75939035415655 45.7915344238281,2.774727344513 45.7995338439942,2.774727344513 45.7995338439942,2.76141953468323 45.8104934692383,2.75255918502819 45.8107261657715)) | 0.0006 | POINT(2.715099029541057 45.806135711669974) |
24025 | POLYGON((2.40134477615368 45.104763031006,2.39829397201549 45.1176948547364,2.40896987915033 45.1279563903809,2.40838456153875 45.133975982666,2.40838456153875 45.133975982666,2.38741207122808 45.1428222656249,2.368726015091 45.1458053588868,2.368726015091 45.1458053588868,2.35563826560985 45.1442565917969,2.35364818572998 45.1414070129395,2.35364818572998 45.1414070129395,2.35725879669201 45.1316871643066,2.36427593231213 45.1276206970216,2.36273288726818 45.1145896911622,2.36273288726818 45.1145896911622,2.36838316917419 45.1018562316896,2.36838316917419 45.1018562316896,2.40134477615368 45.104763031006)) | 0.0006 | POINT(2.376290784162692 45.12776879703302) |
26221 | POLYGON((-0.741905808448735 49.2847862243652,-0.735783278942051 49.2815475463868,-0.745126664638406 49.2747611999513,-0.745126664638406 49.2747611999513,-0.742734014987889 49.2660408020019,-0.742734014987889 49.2660408020019,-0.766698181629124 49.264072418213,-0.770054459571782 49.2663421630859,-0.770054459571782 49.2663421630859,-0.770647168159428 49.2769088745118,-0.770647168159428 49.2769088745118,-0.741905808448735 49.2847862243652)) | 0.0006 | POINT(-0.7546828985213563 49.27259202436971) |
61989 | MULTIPOLYGON(((9.27088737487787 53.1654205322266,9.27284145355225 53.1668663024903,9.27290153503424 53.1681518554689,9.27944755554211 53.1718978881837,9.28137016296398 53.1741371154786,9.28039073944092 53.1824684143067,9.28126907348638 53.1850776672363,9.28126907348638 53.1850776672363,9.27801609039301 53.1846237182617,9.27340888977056 53.1877784729004,9.26577568054199 53.1845550537111,9.26626110076904 53.1832733154297,9.25924110412603 53.1833114624023,9.25912284851074 53.1843147277832,9.25599956512451 53.1846961975098,9.25179958343517 53.1828918457031,9.25013065338146 53.1831626892089,9.25021266937262 53.1850509643555,9.24845790863037 53.1856918334962,9.24493312835705 53.1854286193849,9.24322032928467 53.1872558593749,9.24093723297125 53.1864852905275,9.24055576324469 53.1893692016602,9.23720741271984 53.1902503967285,9.23354339599621 53.1896286010743,9.2341737747193 53.1911354064943,9.2322940826416 53.1914291381837,9.22634792327881 53.1910438537598,9.22654533386236 53.1925125122071,9.22882652282721 53.1923103332519,9.2295379638673 53.1951599121094,9.22666549682617 53.1971702575684,9.22618579864513 53.1992683410645,9.22506237030029 53.1993026733398,9.22513675689709 53.1966972351074,9.2267417907716 53.1955718994141,9.22518539428717 53.1945114135742,9.22166061401367 53.194736480713,9.22042560577398 53.1934547424316,9.21918106079102 53.194034576416,9.22239875793457 53.1961555480957,9.21868896484369 53.1990242004395,9.21859264373779 53.2039985656738,9.22077369689953 53.2096595764161,9.22362232208252 53.2128562927247,9.22362232208252 53.2128562927247,9.2222957611084 53.2131958007812,9.21938991546642 53.2109298706055,9.20953655242926 53.2118721008301,9.20958042144775 53.2103500366211,9.19986534118658 53.2110214233399,9.19964885711681 53.2097167968751,9.19524097442633 53.2093734741212,9.19366836547852 53.2110900878907,9.18829441070562 53.207748413086,9.18403625488281 53.1946296691895,9.18403625488281 53.1946296691895,9.19090747833263 53.1931877136231,9.19197654724121 53.1920433044434,9.18705749511719 53.1908836364747,9.17571258544933 53.1844749450685,9.17571258544933 53.1844749450685,9.18246078491217 53.1830291748048,9.17794990539551 53.1797523498535,9.17995357513428 53.1777954101563,9.18293476104731 53.1781692504883,9.18453598022467 53.1799736022949,9.18558025360107 53.178409576416,9.19459056854248 53.1728820800782,9.19536495208752 53.1707763671876,9.19536495208752 53.1707763671876,9.19884300231934 53.1695022583009,9.20699691772461 53.1700057983399,9.21028709411621 53.1720886230469,9.21405887603765 53.1689529418945,9.21570873260492 53.1652221679688,9.21805000305181 53.1644287109375,9.23111343383795 53.1616973876953,9.2300939559936 53.1634712219239,9.23209571838379 53.1651039123535,9.24225425720226 53.163387298584,9.24456310272217 53.162654876709,9.2443265914917 53.1615180969239,9.26228523254395 53.1558914184571,9.26428508758556 53.156551361084,9.26367092132563 53.1586875915528,9.26966476440441 53.1615562438966,9.26857471466059 53.16316986084,9.27088737487787 53.1654205322266)),((9.16728496551514 53.1771125793457,9.16627407073975 53.176399230957,9.1657657623291 53.1734008789062,9.16190147399908 53.1715698242189,9.16152095794683 53.172275543213,9.15533542633068 53.1723632812501,9.15493202209478 53.1712875366211,9.15366268157959 53.1713943481446,9.15355014801031 53.172462463379,9.14726734161371 53.1725845336914,9.14496517181402 53.1691093444824,9.14496517181402 53.1691093444824,9.15293693542486 53.1672019958496,9.16862583160406 53.172332763672,9.16974353790295 53.1714744567872,9.17259120941168 53.1718292236328,9.1725578308106 53.17293548584,9.17495918273931 53.1736793518066,9.17004394531244 53.1783905029297,9.16728496551514 53.1771125793457))) | 0.0006 | POINT(9.225577757419128 53.18492969786402) |
49546 | POLYGON((3.33354997634893 49.6094474792481,3.34269809722912 49.6063575744629,3.34269809722912 49.6063575744629,3.33117485046398 49.5992469787597,3.3331928253175 49.5927505493165,3.34306097030645 49.590316772461,3.34372043609619 49.583511352539,3.35120582580566 49.5786094665528,3.35656714439403 49.5784492492677,3.3635563850404 49.583740234375,3.3681886196137 49.58207321167,3.3681886196137 49.58207321167,3.35383319854742 49.5627746582031,3.35383319854742 49.5627746582031,3.34405612945568 49.5634956359864,3.33175396919256 49.5583801269531,3.33175396919256 49.5583801269531,3.31465077400219 49.553825378418,3.31047272682196 49.555103302002,3.31047272682196 49.555103302002,3.30496478080744 49.560401916504,3.30728244781494 49.5667495727539,3.30041003227234 49.5706024169922,3.30041003227234 49.5706024169922,3.30751538276678 49.5825920104981,3.29606461524969 49.5886764526367,3.29606461524969 49.5886764526367,3.30516171455395 49.5912246704102,3.33354997634893 49.6094474792481)) | 0.0006 | POINT(3.330232220036703 49.5779391697475) |
15953 | POLYGON((9.59319210052496 45.3405113220216,9.58658123016363 45.340518951416,9.58553314208984 45.3378944396973,9.58242034912104 45.3355178833008,9.5752420425415 45.3329887390137,9.56135654449469 45.3335952758789,9.55938625335699 45.3344421386719,9.55722713470459 45.3367500305176,9.55798053741455 45.3417015075684,9.55798053741455 45.3417015075684,9.56440544128429 45.3432655334473,9.56546497344976 45.3496322631836,9.56417179107666 45.3536643981935,9.56515979766857 45.3585014343262,9.56910133361811 45.3678779602051,9.56910133361811 45.3678779602051,9.57317924499523 45.366512298584,9.57317924499523 45.366512298584,9.58892440795904 45.357219696045,9.58892440795904 45.357219696045,9.5976991653443 45.3408546447755,9.5976991653443 45.3408546447755,9.59319210052496 45.3405113220216)) | 0.0006 | POINT(9.574268644506317 45.34752793745566) |