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 |
|---|---|---|---|
| 51863 | POLYGON((-1.01977694034576 45.8495864868165,-1.01209509372711 45.8459739685058,-1.00937235355377 45.8330154418946,-1.00079011917114 45.8299293518068,-1.00079011917114 45.8299293518068,-1.00473630428309 45.8237037658691,-1.01688408851618 45.8187370300293,-1.01951324939728 45.8088035583496,-1.02777528762817 45.8057670593262,-1.0739568471908 45.8309173583985,-1.0739568471908 45.8309173583985,-1.09675884246826 45.856575012207,-1.09675884246826 45.856575012207,-1.10604405403137 45.867057800293,-1.10794055461884 45.8704147338868,-1.10794055461884 45.8704147338868,-1.10375094413757 45.8743057250977,-1.10319495201111 45.8790283203126,-1.10236096382135 45.8793258666993,-1.10236096382135 45.8793258666993,-1.08842527866364 45.8771476745606,-1.07703840732569 45.8705062866211,-1.05247747898096 45.8679122924805,-1.03994846343994 45.8623275756836,-1.03994846343994 45.8623275756836,-1.0312123298645 45.8602256774903,-1.01977694034576 45.8495864868165)) | 0.0006 | POINT(-1.0583003209187256 45.85156734173119) |
| 64877 | POLYGON((11.9529905319214 47.8283882141114,11.9496898651124 47.8288726806641,11.9505596160889 47.8300285339355,11.9476385116578 47.8389587402344,11.9485731124878 47.839412689209,11.9462585449219 47.8410797119141,11.9461927413941 47.8424835205078,11.9461927413941 47.8424835205078,11.9496698379517 47.8435859680176,11.9518499374391 47.8471183776857,11.9551429748536 47.8473587036133,11.9552202224733 47.8463821411133,11.9596252441407 47.8459930419922,11.9608955383301 47.8447380065918,11.9621305465698 47.8470993041992,11.9640083312989 47.8460540771486,11.9650039672852 47.8474655151367,11.9672422409057 47.8478889465333,11.9623861312866 47.8497619628906,11.9631843566895 47.8556442260742,11.9603023529053 47.8561553955079,11.9607963562012 47.8581619262695,11.9615163803101 47.8581161499025,11.9625196456909 47.8636054992676,11.9647998809814 47.8666114807128,11.9693489074708 47.8668479919434,11.9701805114746 47.8687019348146,11.9765558242798 47.8710823059083,11.9775247573853 47.879981994629,11.9758720397949 47.8802909851075,11.9760141372681 47.8814773559571,11.977505683899 47.8821296691895,11.9778833389282 47.8836860656739,11.9795761108398 47.883544921875,11.980793952942 47.8921775817871,11.980793952942 47.8921775817871,11.9808101654054 47.8944816589355,11.9837398529053 47.8921051025391,11.9892854690552 47.8918495178223,11.9889554977418 47.8938446044922,11.9993934631348 47.8909950256349,12.0074958801271 47.8969230651857,12.0068082809449 47.8993453979492,12.008644104004 47.9003906250001,12.0105733871461 47.9033393859864,12.0086851119995 47.9052200317384,12.010368347168 47.9058876037599,12.011194229126 47.9074440002441,12.010898590088 47.9102058410645,12.0137310028076 47.9105949401856,12.0188074111939 47.9093132019044,12.0248823165894 47.9124412536621,12.0331563949585 47.9113502502442,12.0331563949585 47.9113502502442,12.0343475341797 47.9050521850585,12.0278491973878 47.9040184020996,12.0291919708253 47.8998832702637,12.0280408859254 47.900146484375,12.0274772644044 47.8990859985353,12.0256834030152 47.8996963500978,12.0253458023072 47.8988914489746,12.0300283432007 47.8984146118164,12.0294561386109 47.8967514038087,12.0277767181396 47.8960647583009,12.0326919555665 47.8937835693361,12.0302305221558 47.8918685913087,12.0361814498902 47.8910255432128,12.0382957458497 47.89306640625,12.0377464294434 47.8913116455078,12.0388793945312 47.8913688659669,12.0392112731934 47.8931999206544,12.0417346954346 47.8901901245117,12.0429849624634 47.8903350830079,12.042392730713 47.8883438110352,12.044722557068 47.8884811401367,12.0448827743531 47.8877639770508,12.0428314208985 47.8865547180176,12.0438060760497 47.8848991394044,12.0459136962892 47.8867263793946,12.047414779663 47.8838500976564,12.0522785186767 47.8836708068848,12.0498628616334 47.8782501220704,12.0478096008301 47.8779563903809,12.0513954162598 47.8754844665528,12.0495510101318 47.874252319336,12.0543851852418 47.870460510254,12.0543851852418 47.870460510254,12.0533132553102 47.8647155761719,12.0461750030517 47.8650169372559,12.043176651001 47.8631057739258,12.0405092239381 47.863224029541,12.0389957427979 47.8566665649414,12.0368309020997 47.8562126159669,12.0355939865112 47.8535308837892,12.0320806503296 47.8556060791017,12.0312728881836 47.854419708252,12.0332326889039 47.8487091064454,12.0245342254638 47.8492660522462,12.0214538574219 47.850212097168,12.0167350769043 47.8542022705079,12.0132198333741 47.8548011779785,12.0063228607178 47.8546104431152,12.0039854049683 47.8507843017579,12.0064420700074 47.8479194641113,12.0020780563355 47.8483238220215,12.0020637512208 47.84521484375,12.009340286255 47.8429832458496,12.0088825225831 47.8419075012208,12.0034666061403 47.841423034668,12.0037136077882 47.8393058776857,12.0062818527222 47.8390274047853,12.0061740875244 47.8376617431642,12.0099382400513 47.8376541137696,12.0103378295898 47.8384857177734,12.0275554656984 47.8377952575685,12.0282917022705 47.8284606933594,12.0245800018311 47.8218727111817,12.0307312011719 47.8193054199219,12.0307312011719 47.8193054199219,12.0153398513795 47.8218803405762,12.0148258209229 47.8235282897949,12.0106163024902 47.8221588134766,11.9997901916504 47.8228225708009,12.0000238418579 47.8241806030273,12.0019836425782 47.8245239257814,12.0023279190063 47.8276176452637,11.9948263168335 47.8271484375001,11.9821176528931 47.8287963867188,11.9796829223633 47.832260131836,11.974446296692 47.8325920104981,11.9748134613037 47.8339805603028,11.9733352661133 47.8341674804688,11.9686098098756 47.8336410522462,11.9674530029297 47.8315620422363,11.9630508422852 47.8296012878419,11.9581422805786 47.8304481506348,11.9584960937501 47.8286094665528,11.9529905319214 47.8283882141114)) | 0.0006 | POINT(12.003793667702814 47.86456340594885) |
| 52086 | POLYGON((-0.552471041679269 45.66752243042,-0.552140176296177 45.6669731140137,-0.552140176296177 45.6669731140137,-0.536466896533966 45.6381912231445,-0.538259327411652 45.6314544677736,-0.538259327411652 45.6314544677736,-0.532805502414703 45.6265258789062,-0.532805502414703 45.6265258789062,-0.514114797115326 45.6281661987305,-0.512266755104065 45.6312332153321,-0.512266755104065 45.6312332153321,-0.509009540081024 45.6378173828125,-0.499535918235779 45.6389770507812,-0.485925883054733 45.6534233093262,-0.471872508525848 45.6557960510255,-0.471872508525848 45.6557960510255,-0.464681088924408 45.6784782409669,-0.464681088924408 45.6784782409669,-0.466921746730804 45.6875610351562,-0.471306830644608 45.6885795593263,-0.471306830644608 45.6885795593263,-0.493989586830082 45.6665306091309,-0.514027655124607 45.676383972168,-0.514027655124607 45.676383972168,-0.521417796611729 45.672492980957,-0.532346904277802 45.6793441772462,-0.542194724082947 45.6797103881837,-0.542194724082947 45.6797103881837,-0.544855713844186 45.6752815246582,-0.544855713844186 45.6752815246582,-0.552471041679269 45.66752243042)) | 0.0006 | POINT(-0.5133673558632306 45.65969530741378) |
| 63841 | POLYGON((8.47954940795898 50.2164001464844,8.47772598266613 50.2160606384278,8.47541332244884 50.2137336730958,8.48670578002941 50.2091026306153,8.48093223571777 50.2073516845704,8.47516822814947 50.2083320617676,8.47523117065435 50.2052268981934,8.49002742767345 50.1969909667969,8.48728179931641 50.1956100463867,8.48736476898205 50.1946563720703,8.4899473190307 50.1932716369629,8.49268245697033 50.1886291503907,8.48941516876232 50.1873207092285,8.48551273345942 50.1881065368652,8.48050785064709 50.1845016479493,8.48267078399664 50.1814689636231,8.48050975799566 50.18021774292,8.48135471343994 50.1791229248048,8.4866447448731 50.1809654235841,8.48650550842279 50.1822471618653,8.48819160461437 50.1834754943847,8.49187755584717 50.1834869384766,8.49608230590815 50.180202484131,8.49753761291515 50.1772842407227,8.49669647216808 50.1753158569337,8.49747657775885 50.1747703552247,8.50251293182384 50.1739768981934,8.5048942565918 50.1720123291016,8.51394081115734 50.1681747436523,8.51394081115734 50.1681747436523,8.51948833465588 50.1675415039062,8.5193510055542 50.1658096313478,8.52413463592529 50.1636695861816,8.52851676940929 50.1660957336427,8.52839660644543 50.1679649353028,8.529221534729 50.1683578491211,8.53257751464855 50.1644821166993,8.5365505218507 50.1646385192871,8.5365505218507 50.1646385192871,8.53313350677502 50.1693153381349,8.53480052947998 50.1700019836426,8.53188800811773 50.1719589233398,8.5332870483399 50.1726760864259,8.53721427917486 50.1695747375488,8.54070949554449 50.1721343994141,8.54386520385748 50.1724166870118,8.54347705841064 50.1733283996583,8.54513263702387 50.1739578247071,8.54482078552246 50.1747093200684,8.54747676849365 50.1748809814454,8.54880523681652 50.1715469360351,8.55347442626959 50.1660537719727,8.5573987960816 50.1670455932618,8.5589971542359 50.1660118103028,8.56056976318365 50.1666145324708,8.56056976318365 50.1666145324708,8.55658817291265 50.1704101562499,8.56444835662847 50.1728286743165,8.56265068054211 50.1739578247071,8.56443691253656 50.1751518249512,8.55030250549322 50.1848373413087,8.55739498138428 50.1858863830567,8.55739498138428 50.1858863830567,8.55655288696283 50.1876068115234,8.55655288696283 50.1876068115234,8.55516529083258 50.1886291503907,8.55418586730968 50.1882324218751,8.55455303192144 50.1868171691895,8.54972743988048 50.1851959228516,8.54758644104004 50.1878166198732,8.54758644104004 50.1878166198732,8.54417991638195 50.1908531188966,8.54492664337153 50.1921272277833,8.54021644592291 50.195152282715,8.53936290740961 50.1947593688965,8.53602504730219 50.1968154907227,8.53464984893799 50.1961708068848,8.52552986145025 50.2026824951172,8.52392578125006 50.2018089294434,8.51291275024414 50.207576751709,8.5051326751709 50.2091712951661,8.4880886077882 50.2184410095215,8.47954940795898 50.2164001464844)) | 0.0006 | POINT(8.522375455716809 50.18307890543126) |
| 27521 | POLYGON((0.147519439458904 48.5023765563965,0.124556735158023 48.5140380859376,0.114079721272105 48.5072135925294,0.114079721272105 48.5072135925294,0.109621800482216 48.4937095642091,0.113804332911968 48.4875984191896,0.113804332911968 48.4875984191896,0.120799854397774 48.485481262207,0.120799854397774 48.485481262207,0.126595199108237 48.4911766052247,0.145364955067691 48.4961662292481,0.145364955067691 48.4961662292481,0.147519439458904 48.5023765563965)) | 0.0006 | POINT(0.12469924179220464 48.49618498484301) |
| 67960 | POLYGON((7.71044635772716 49.1302299499511,7.70962953567505 49.1358108520509,7.70787191390991 49.1398696899413,7.71057224273676 49.1437072753906,7.71132087707531 49.1471290588379,7.71375703811657 49.1491355895996,7.72155761718761 49.1525955200196,7.72269678115856 49.1540184020997,7.72247266769409 49.1576690673828,7.7302012443543 49.1645660400391,7.7302012443543 49.1645660400391,7.73111486434942 49.1658668518068,7.74113464355474 49.1704254150391,7.74152278900152 49.171558380127,7.74508666992188 49.1735725402832,7.75737285614014 49.1776924133302,7.76008415222162 49.180233001709,7.75970792770397 49.1817703247071,7.76124525070196 49.1817817687988,7.76137685775768 49.1809196472169,7.76310968399059 49.1815948486329,7.78607320785522 49.1805152893067,7.793369293213 49.1833534240723,7.79649448394781 49.1866264343262,7.80048608779919 49.1879348754882,7.80622959136969 49.1873817443848,7.80622959136969 49.1873817443848,7.8077068328858 49.1864967346191,7.80372428894054 49.1820907592774,7.80422735214228 49.1775131225587,7.80422735214228 49.1775131225587,7.80041360855114 49.1791763305664,7.7996392250061 49.1780509948732,7.80056333541864 49.1765060424805,7.79888629913336 49.1738471984864,7.80129003524786 49.1694145202637,7.80011463165278 49.1666297912599,7.80193567276001 49.1595993041993,7.7990612983703 49.1589736938477,7.80327320098883 49.1523704528809,7.80482912063599 49.1532630920411,7.80525207519537 49.1503562927247,7.80454015731817 49.148853302002,7.80876445770269 49.1474151611329,7.80771541595465 49.144329071045,7.80771541595465 49.144329071045,7.80154991149908 49.1370697021484,7.80173778533947 49.1270942687989,7.80173778533947 49.1270942687989,7.78798437118542 49.1246109008788,7.77236461639416 49.127498626709,7.76701354980469 49.127052307129,7.76880407333374 49.1230468750001,7.77232837677002 49.1220779418946,7.76224660873419 49.1187362670898,7.76178216934215 49.1170158386232,7.76432085037237 49.1160163879395,7.76340055465698 49.1153182983398,7.75841808319097 49.1149253845216,7.75319194793701 49.1130332946778,7.754312992096 49.1097106933595,7.754312992096 49.1097106933595,7.74987602233892 49.1101074218749,7.7422666549682 49.1084251403809,7.74074745178223 49.109100341797,7.74134826660162 49.1110572814942,7.73760557174677 49.1132087707521,7.73686504364019 49.1158447265625,7.73455047607433 49.1165161132813,7.73085641860962 49.115650177002,7.72770929336548 49.112907409668,7.72281742095947 49.1116714477539,7.72009086608887 49.1147270202638,7.71848440170282 49.1150016784668,7.71616601943975 49.1190567016603,7.71628141403198 49.1220512390137,7.71371412277222 49.1249465942384,7.71412324905407 49.1264152526855,7.71044635772716 49.1302299499511)) | 0.0006 | POINT(7.762490443694325 49.14642735016653) |
| 19301 | POLYGON((11.4533653259278 46.3350715637207,11.4558029174804 46.3358268737793,11.4597320556641 46.3417358398439,11.4602565765381 46.3470611572266,11.4630908966066 46.3508453369141,11.4660120010376 46.3525085449219,11.4736337661743 46.35262298584,11.4779539108278 46.3544578552247,11.4801788330079 46.3565139770508,11.479250907898 46.3632926940918,11.4779195785522 46.364818572998,11.4779195785522 46.364818572998,11.4741325378419 46.3662643432617,11.466157913208 46.3719177246093,11.4611892700195 46.3738784790039,11.4496641159058 46.37406539917,11.4414529800416 46.3730354309082,11.4210557937622 46.3798866271973,11.4036674499512 46.389575958252,11.3877573013306 46.3862266540528,11.3840627670288 46.3844223022462,11.3792448043823 46.3848838806153,11.3669900894165 46.3886947631837,11.365044593811 46.390625,11.3649778366089 46.3932991027833,11.3621492385864 46.3961486816406,11.3406267166138 46.4023513793946,11.3406267166138 46.4023513793946,11.3409061431885 46.3979415893555,11.3352117538453 46.3910026550294,11.3293428421021 46.3918609619141,11.3230028152466 46.3892631530762,11.3230028152466 46.3892631530762,11.3259372711183 46.3820953369141,11.3277893066407 46.3724441528321,11.3261890411377 46.3675270080567,11.3145475387573 46.3449325561524,11.3145475387573 46.3449325561524,11.3217306137085 46.3470001220703,11.3295307159424 46.3476676940918,11.3562889099122 46.3461494445801,11.3602466583253 46.3435935974121,11.3647718429565 46.3385391235351,11.373224258423 46.3341789245606,11.3779058456421 46.3333816528321,11.3843717575073 46.3344688415527,11.3931427001954 46.3312072753907,11.3813600540161 46.3273391723633,11.3813600540161 46.3273391723633,11.3900766372681 46.3243522644043,11.3979139328003 46.3286056518556,11.4031915664672 46.3278007507324,11.4058818817139 46.325870513916,11.4058818817139 46.325870513916,11.4132518768311 46.3252487182617,11.4132518768311 46.3252487182617,11.421522140503 46.3263092041017,11.4533653259278 46.3350715637207)) | 0.0006 | POINT(11.395952609547424 46.3590988694576) |
| 59791 | POLYGON((7.59803009033203 47.2555503845215,7.59868001937878 47.2600250244141,7.59631395339972 47.2686195373536,7.59631395339972 47.2686195373536,7.58423089981073 47.2766685485839,7.58423089981073 47.2766685485839,7.5948100090028 47.2789611816407,7.60228109359753 47.2788581848145,7.60424900054937 47.2775497436523,7.60705995559698 47.272388458252,7.60466194152838 47.2685661315919,7.60574817657465 47.265781402588,7.62183094024658 47.2661819458008,7.62569904327398 47.2673683166504,7.62836694717407 47.265754699707,7.62836694717407 47.265754699707,7.62919902801514 47.2617301940919,7.62919902801514 47.2617301940919,7.62855005264282 47.259880065918,7.62500286102295 47.2582397460939,7.62646818161011 47.2560920715332,7.6315650939942 47.2546119689941,7.63254404068005 47.2533950805665,7.63219785690308 47.2491836547852,7.6275401115418 47.24471282959,7.62877082824701 47.2385330200196,7.62877082824701 47.2385330200196,7.62195396423351 47.2382011413574,7.61951494216919 47.2364807128907,7.61951494216919 47.2364807128907,7.61214685440063 47.2421226501466,7.60531091690069 47.2459754943848,7.59909009933472 47.2480087280273,7.59909009933472 47.2480087280273,7.59761810302729 47.2512168884278,7.59803009033203 47.2555503845215)) | 0.0006 | POINT(7.613569191523983 47.25818437848775) |
| 43716 | POLYGON((2.73170399665838 44.0343208312989,2.71925473213207 44.0290145874024,2.71547675132763 44.0311546325684,2.7066485881806 44.0473403930665,2.70793747901928 44.0612525939943,2.69970536232006 44.0649375915527,2.69970536232006 44.0649375915527,2.69497942924511 44.0640335083007,2.68930029869085 44.0434150695801,2.67843461036682 44.0363998413086,2.66380763053894 44.0351295471191,2.66259026527416 44.030071258545,2.67038321495068 44.0263671875001,2.66820335388195 44.0237045288087,2.65851497650158 44.0231437683105,2.65148639678955 44.0139961242676,2.65148639678955 44.0139961242676,2.66928672790533 44.0025215148925,2.66547775268566 43.9929428100586,2.66547775268566 43.9929428100586,2.68386244773876 43.9957618713379,2.69691181182867 43.991756439209,2.70635843276978 43.9850234985353,2.71650695800793 43.992115020752,2.73506450653088 43.9931182861328,2.73583054542542 43.9999771118164,2.74777674674993 44.0051422119141,2.74777674674993 44.0051422119141,2.74898457527155 44.0083694458008,2.77565002441418 44.0102157592775,2.77533841133129 44.0228538513184,2.77533841133129 44.0228538513184,2.75856518745428 44.0192527770997,2.74483060836798 44.0198783874511,2.74050617218018 44.0328216552735,2.73170399665838 44.0343208312989)) | 0.0006 | POINT(2.707404647554742 44.02102584838869) |
| 40459 | POLYGON((1.89107632637035 45.5345077514649,1.89177858829504 45.5211563110352,1.88232374191296 45.5020904541016,1.88232374191296 45.5020904541016,1.87117147445679 45.4969444274902,1.8711621761322 45.4911003112794,1.8647975921632 45.4867668151857,1.8647975921632 45.4867668151857,1.88262224197388 45.4847106933594,1.88892459869396 45.4800567626953,1.89348769187939 45.4804077148439,1.89348769187939 45.4804077148439,1.89949440956121 45.4899559020997,1.91263914108276 45.4947700500489,1.91393315792084 45.505210876465,1.91684865951544 45.5080642700196,1.92622280120855 45.510108947754,1.9448996782304 45.5059356689454,1.95552432537079 45.5171127319336,1.95552432537079 45.5171127319336,1.95731115341187 45.5201911926269,1.94452702999121 45.5295829772949,1.9407731294632 45.5275573730469,1.93225574493414 45.5300788879396,1.93225574493414 45.5300788879396,1.92464005947124 45.5329666137696,1.89107632637035 45.5345077514649)) | 0.0006 | POINT(1.9090308776269191 45.50637435913094) |