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 |
---|---|---|---|
33520 | POLYGON((4.99195957183844 49.4614639282227,4.97841835021978 49.4647979736329,4.96512508392334 49.4602241516113,4.95885133743286 49.4642524719238,4.95885133743286 49.4642524719238,4.95084762573254 49.4594383239746,4.95084762573254 49.4594383239746,4.93484592437744 49.4381065368652,4.9373927116394 49.4350738525392,4.9223394393922 49.4210700988771,4.9223394393922 49.4210700988771,4.9512290954591 49.4287567138672,4.96918916702271 49.4460334777833,4.97924661636364 49.4483146667481,4.97924661636364 49.4483146667481,4.98692989349371 49.4605216979981,4.99195957183844 49.4614639282227)) | 0.0006 | POINT(4.958603739738525 49.448820590972936) |
22218 | POLYGON((-1.19514000415802 45.0625114440919,-1.19434130191803 45.0683555603027,-1.10996901988983 45.0458221435547,-1.07876873016352 45.022933959961,-1.05388319492329 45.0231857299806,-1.02822828292847 45.0335845947266,-0.998321652412415 45.0315971374512,-0.998321652412415 45.0315971374512,-0.984132707118988 45.0235595703126,-0.978068470954895 45.0149688720704,-0.978068470954895 45.0149688720704,-0.9866526126861 45.0020141601564,-0.994359612464848 44.9739723205566,-0.989552199840489 44.9601516723633,-0.980671226978302 44.951499938965,-0.980671226978302 44.951499938965,-1.02430069446558 44.9452323913575,-1.04596209526062 44.9368553161622,-1.07295680046076 44.9072952270508,-1.07295680046076 44.9072952270508,-1.10845649242395 44.9206657409669,-1.21402704715729 44.9207916259767,-1.21402704715729 44.9207916259767,-1.20263803005219 44.9948616027833,-1.19902801513672 45.0354156494142,-1.19514000415802 45.0625114440919)) | 0.0006 | POINT(-1.0673401355743186 44.988057098388744) |
1401740 | POLYGON((-2.69527602195734 41.2456016540528,-2.70947504043573 41.2519912719728,-2.71399402618403 41.2611236572267,-2.71670007705683 41.275676727295,-2.73001909255976 41.2716751098632,-2.76087403297424 41.2740325927735,-2.75829911231995 41.2793121337891,-2.76277494430542 41.3126335144043,-2.76134610176081 41.311866760254,-2.74861907958973 41.3188743591308,-2.74110007286066 41.3194770812988,-2.72042798995972 41.3282012939454,-2.70844197273254 41.3201293945313,-2.70626091957092 41.3138275146484,-2.69497299194336 41.3188247680664,-2.691740989685 41.3172302246095,-2.69348001480103 41.3004531860353,-2.69976305961609 41.297721862793,-2.70325708389277 41.2884368896486,-2.70751309394836 41.2853050231933,-2.71113395690918 41.2791976928712,-2.71491098403925 41.2783508300781,-2.71184301376331 41.2753868103027,-2.70461297035206 41.2737121582032,-2.69447588920593 41.2844390869142,-2.68877601623524 41.2850914001466,-2.68455696105951 41.2832069396972,-2.68544602394104 41.2822303771974,-2.68164205551147 41.2786026000977,-2.66700506210321 41.2827186584473,-2.65633010864258 41.2827491760254,-2.65373611450195 41.2787322998046,-2.65040707588196 41.2784881591798,-2.6401228904723 41.2659454345703,-2.63624596595764 41.2655181884767,-2.63837504386902 41.2537155151368,-2.63043189048767 41.2419967651368,-2.62383008003229 41.2237434387207,-2.62912893295282 41.2152252197266,-2.63617801666254 41.2238197326661,-2.63462996482843 41.2319412231446,-2.64505100250238 41.2379302978516,-2.64594411849964 41.2402153015137,-2.65476202964783 41.2406616210938,-2.66924095153809 41.2371063232423,-2.69527602195734 41.2456016540528)) | 0.0006 | POINT(-2.689181174172259 41.27584711710616) |
69328 | POLYGON((10.7389240264893 53.7204971313478,10.7400751113892 53.720516204834,10.7410144805908 53.7233238220214,10.7432441711426 53.7237777709962,10.7427272796631 53.7262878417969,10.7464971542358 53.7284355163575,10.7492980957032 53.7333908081055,10.7474679946899 53.734058380127,10.7446870803832 53.7380256652832,10.7391023635865 53.7393112182617,10.7368869781495 53.7414817810059,10.7368869781495 53.7414817810059,10.7352561950685 53.7398300170898,10.7343521118165 53.7407417297363,10.731472015381 53.740592956543,10.731725692749 53.7399711608887,10.7193365097047 53.738395690918,10.7206325531007 53.7369918823242,10.7236642837524 53.7371826171875,10.7233228683472 53.7355232238769,10.7199096679689 53.7347297668458,10.7202844619752 53.7309837341309,10.7202844619752 53.7309837341309,10.7262811660766 53.7303504943849,10.7247514724732 53.7276496887208,10.7271728515626 53.7270164489747,10.7246704101564 53.7236328125,10.7389240264893 53.7204971313478)) | 0.0006 | POINT(10.732960312454841 53.73278384738501) |
1409296 | POLYGON((-2.94513988494867 43.4121627807617,-2.94430589675898 43.4154167175294,-2.94569396972656 43.4187507629395,-2.94847202301025 43.4184722900391,-2.94902801513672 43.4176406860352,-2.95319390296936 43.4176406860352,-2.95291590690613 43.420696258545,-2.95569396018982 43.4215278625489,-2.95485997200012 43.4240264892579,-2.95291590690613 43.4245834350587,-2.95374989509577 43.4276390075683,-2.95235991477966 43.4295845031738,-2.94763994216913 43.4298629760742,-2.9465279579162 43.431251525879,-2.94597196578979 43.4334716796875,-2.9473619461059 43.4343070983888,-2.94708395004267 43.4359703063965,-2.93569493293762 43.4343070983888,-2.93152904510498 43.4345817565919,-2.92902898788452 43.4362487792969,-2.92354488372803 43.4373626708985,-2.91576910018921 43.4295120239258,-2.90944409370422 43.4287567138672,-2.9112560749054 43.4229927062989,-2.91576600074762 43.4218139648439,-2.91681003570557 43.417911529541,-2.91487288475037 43.4163589477539,-2.92079210281372 43.4143905639648,-2.91933488845814 43.4129333496094,-2.93190288543701 43.4078788757325,-2.92431306838989 43.4036598205566,-2.92107200622553 43.3984069824219,-2.92548489570612 43.3952522277832,-2.92923402786249 43.389518737793,-2.93620610237116 43.3932228088379,-2.94369292259216 43.4018173217773,-2.94130611419672 43.4033851623536,-2.94491195678711 43.4055480957032,-2.94341206550598 43.4094619750977,-2.94513988494867 43.4121627807617)) | 0.0006 | POINT(-2.936622925293729 43.41867505587068) |
22091 | POLYGON((0.000908288406321844 44.625316619873,0.0322586148977848 44.6037216186524,0.0322586148977848 44.6037216186524,0.0248662643134594 44.5966072082521,0.0261576622725102 44.5907669067383,0.0261576622725102 44.5907669067383,0.020814558491054 44.5873794555665,0.020814558491054 44.5873794555665,-0.00529188849026241 44.5880508422852,-0.00529188849026241 44.5880508422852,-0.0181398577988148 44.5913772583009,-0.0190419629216194 44.5945663452149,-0.0190419629216194 44.5945663452149,-0.00978837814182043 44.6061630249023,-0.0137216737493873 44.6122703552247,-0.00851978640997686 44.6216201782227,-0.00851978640997686 44.6216201782227,-0.00449204677715898 44.62060546875,0.000908288406321844 44.625316619873)) | 0.0006 | POINT(0.004021499551754467 44.60136392381462) |
65217 | POLYGON((11.4882640838624 49.1807174682617,11.4918193817138 49.1787910461426,11.4902629852296 49.1764831542968,11.4904413223267 49.1744918823243,11.487208366394 49.1700401306153,11.4812421798705 49.1681060791016,11.4802608489991 49.169147491455,11.4704160690308 49.165958404541,11.4613285064698 49.1661033630371,11.4500246047973 49.1635169982911,11.44983959198 49.1589927673341,11.4488916397095 49.1589202880861,11.4493255615234 49.1565971374512,11.4459457397461 49.156265258789,11.4462118148805 49.1544532775878,11.4522142410279 49.1549453735352,11.452184677124 49.1520195007324,11.4484424591064 49.1514205932618,11.4494791030884 49.1469612121583,11.4466886520387 49.1445007324219,11.4457912445069 49.146297454834,11.4375963211061 49.1498336791992,11.439368247986 49.1467132568361,11.4306764602662 49.1531906127931,11.4228410720826 49.1529846191407,11.4115676879882 49.1536712646485,11.4115257263184 49.15433883667,11.4079751968384 49.1537017822266,11.4060134887696 49.1565856933594,11.406683921814 49.1586952209473,11.3938159942628 49.1592941284181,11.3936014175416 49.1617660522462,11.3820867538453 49.1636505126954,11.3820867538453 49.1636505126954,11.3783588409424 49.1645851135254,11.3784799575806 49.1689758300782,11.3801279067993 49.1690979003906,11.3807582855226 49.1735725402832,11.3820114135742 49.1730308532715,11.3826017379762 49.1745910644531,11.3842945098878 49.1741218566895,11.3858957290649 49.1761322021484,11.3834180831909 49.1772041320801,11.3841152191162 49.1792869567871,11.3823318481446 49.1793365478517,11.3845300674438 49.1802101135253,11.384331703186 49.1813697814941,11.3825750350952 49.1806030273438,11.38023853302 49.1841735839844,11.3800687789918 49.1861190795899,11.3774652481079 49.1863708496095,11.3781127929688 49.1887588500977,11.3755788803101 49.189022064209,11.3772201538085 49.1902236938476,11.376781463623 49.1910171508789,11.3804197311401 49.1925544738771,11.3802156448364 49.1949501037598,11.3766393661498 49.1945114135743,11.375005722046 49.1967544555664,11.377462387085 49.19974899292,11.3767518997194 49.2006912231446,11.3750009536743 49.2002906799316,11.3764142990112 49.2010078430176,11.3746347427368 49.2012825012208,11.3746767044067 49.2035827636719,11.3797521591187 49.2048835754395,11.381498336792 49.2042770385743,11.3812055587769 49.2024993896485,11.3918218612671 49.2059326171876,11.3931427001954 49.2046852111816,11.3957099914551 49.205997467041,11.3985185623168 49.204689025879,11.400806427002 49.2075157165527,11.400806427002 49.2075157165527,11.402759552002 49.2091445922852,11.4129362106324 49.2078475952149,11.4144639968873 49.2058944702148,11.4125652313233 49.204948425293,11.4159173965455 49.2007179260254,11.4168777465821 49.2014312744142,11.4191904067994 49.200294494629,11.4198656082154 49.2011909484863,11.4249601364137 49.1998176574708,11.4261722564697 49.1950225830078,11.4292984008788 49.1941566467285,11.4324283599854 49.1948776245118,11.4315958023072 49.1936988830568,11.4342107772828 49.1912384033203,11.4366798400879 49.1897430419922,11.4399137496948 49.1893196105958,11.4451341629029 49.1939353942871,11.4443378448487 49.19535446167,11.4465351104736 49.1967849731446,11.4465131759645 49.1984024047853,11.4455118179322 49.1987648010254,11.4468097686768 49.1993255615236,11.4480247497559 49.2020721435547,11.4479436874391 49.2068252563477,11.4543342590333 49.2072906494141,11.4592075347901 49.2087249755859,11.4743251800537 49.2086906433105,11.4777421951294 49.2079048156738,11.4777421951294 49.2079048156738,11.4760179519653 49.2075233459473,11.4766464233398 49.2033271789551,11.474404335022 49.2024307250976,11.4739265441895 49.2005004882814,11.4721622467042 49.2001724243164,11.4727602005005 49.1985206604003,11.4708089828492 49.1970291137696,11.4755630493165 49.1958961486816,11.4759016036987 49.1947898864747,11.4818258285523 49.1913909912109,11.4824209213257 49.1903533935548,11.4814424514772 49.1880378723145,11.4795074462891 49.1867256164551,11.481746673584 49.1861457824707,11.4815349578857 49.1845092773438,11.4837303161622 49.1844749450684,11.4855213165284 49.1861572265626,11.4855079650879 49.1794548034668,11.4882640838624 49.1807174682617)) | 0.0006 | POINT(11.42675477808175 49.1844028441374) |
24516 | POLYGON((2.52686619758617 45.6949195861816,2.52459692955011 45.688346862793,2.52868366241461 45.6821975708009,2.52868366241461 45.6821975708009,2.54302835464472 45.6906280517578,2.54302835464472 45.6906280517578,2.55144667625433 45.6935462951661,2.5516238212586 45.6970405578613,2.54155492782598 45.7041053771973,2.54604506492615 45.7176208496094,2.56348371505737 45.7297744750977,2.58702778816235 45.7124366760255,2.5883390903474 45.7055168151856,2.5883390903474 45.7055168151856,2.59453678131104 45.7104034423829,2.58787584304821 45.7228317260743,2.59140419960022 45.729030609131,2.59140419960022 45.729030609131,2.59285211563122 45.7349433898927,2.58279085159313 45.7407531738282,2.58279085159313 45.7407531738282,2.56516242027288 45.743595123291,2.55687093734741 45.7511100769044,2.55687093734741 45.7511100769044,2.54799509048462 45.7479858398439,2.54417634010326 45.7415771484375,2.53950548171997 45.7403221130371,2.53060507774347 45.7434463500976,2.5228152275086 45.7399826049806,2.52305483818049 45.733097076416,2.53530669212347 45.7181091308594,2.52686619758617 45.6949195861816)) | 0.0006 | POINT(2.5567343619562344 45.71975991033745) |
1404880 | POLYGON((-3.88532710075378 40.5744705200196,-3.88897800445557 40.5709266662598,-3.88703608512878 40.5661773681641,-3.88409996032709 40.5639190673828,-3.88506889343262 40.5612182617188,-3.87397599220276 40.557544708252,-3.863291978836 40.5349617004394,-3.85388398170471 40.5249137878418,-3.85363507270813 40.5201148986816,-3.85146093368525 40.5172653198243,-3.85372591018671 40.5123596191406,-3.85198307037354 40.5098571777345,-3.83649802207941 40.5063133239747,-3.83944511413569 40.4993171691895,-3.83437609672541 40.494041442871,-3.83330798149103 40.4857864379884,-3.83670091629028 40.4808044433594,-3.83665299415583 40.4750328063966,-3.89204311370844 40.4877891540528,-3.89508104324341 40.4907379150391,-3.90590310096741 40.4953384399415,-3.91041493415821 40.5016899108887,-3.92633509635925 40.4991035461425,-3.93324494361872 40.4995384216309,-3.93602800369257 40.5087738037109,-3.93980503082275 40.5079078674316,-3.93805408477778 40.5118637084962,-3.94056391715998 40.5124130249023,-3.94224095344538 40.5158767700196,-3.94007802009583 40.5181999206543,-3.93975901603699 40.529167175293,-3.94058394432062 40.5316467285156,-3.94696998596191 40.5357475280762,-3.94979000091553 40.5396156311036,-3.94543910026545 40.5510139465332,-3.9420769214629 40.5479583740235,-3.93599200248718 40.5486640930177,-3.9343740940094 40.5520210266114,-3.93219208717341 40.5505218505859,-3.93238592147827 40.552547454834,-3.93009090423578 40.5539283752442,-3.93187308311457 40.5599403381347,-3.92926788330067 40.5577201843262,-3.91977310180664 40.5577774047852,-3.90897703170776 40.564826965332,-3.90570688247681 40.5632019042969,-3.89524507522583 40.5678596496583,-3.89022707939148 40.5724411010742,-3.88532710075378 40.5744705200196)) | 0.0006 | POINT(-3.9012492597102817 40.530017852783224) |
41630 | POLYGON((5.04572010040278 48.857063293457,5.05538034439081 48.8572578430177,5.07153844833385 48.8494300842286,5.07153844833385 48.8494300842286,5.07328367233276 48.8436241149902,5.07328367233276 48.8436241149902,5.04968452453613 48.8268470764161,5.01619625091547 48.8332748413087,5.01619625091547 48.8332748413087,5.0087823867799 48.8396224975587,5.0087823867799 48.8396224975587,5.01065254211431 48.8467712402344,5.01065254211431 48.8467712402344,5.02039575576782 48.8470497131348,5.03574991226196 48.855567932129,5.04572010040278 48.857063293457)) | 0.0006 | POINT(5.037855815887471 48.84461542765305) |