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 |
|---|---|---|---|
| 63782 | POLYGON((8.55652809143066 50.5357971191407,8.56271648406988 50.5377922058106,8.56243419647211 50.5401725769043,8.56703758239757 50.5419235229493,8.56782531738287 50.5409736633301,8.57173824310303 50.5429992675782,8.57668113708496 50.5399322509766,8.58423328399653 50.542091369629,8.58689212799078 50.542018890381,8.58681011199963 50.544017791748,8.59175395965588 50.5450630187989,8.58858394622808 50.5479888916016,8.59923839569086 50.5503234863282,8.60073852539062 50.5499076843262,8.60523986816418 50.5531883239747,8.60403347015387 50.5540237426758,8.6081886291505 50.5560874938965,8.61114406585705 50.5588188171388,8.61210346221924 50.5616607666016,8.61568641662598 50.561809539795,8.61890697479248 50.5650138854981,8.61890697479248 50.5650138854981,8.6160011291505 50.570140838623,8.6087379455567 50.5697708129884,8.60571861267096 50.5713844299318,8.60571861267096 50.5713844299318,8.60240173339855 50.5712776184082,8.59656143188488 50.5692825317383,8.59584712982183 50.5680732727051,8.58732318878174 50.569522857666,8.58689975738531 50.5708770751954,8.58954429626476 50.5732612609864,8.58844375610352 50.5746116638185,8.58346176147461 50.5740852355958,8.58106994628906 50.5713920593263,8.57754611969 50.570827484131,8.57497406005859 50.5642776489257,8.57074356079107 50.5640830993653,8.57020664215082 50.5603103637695,8.5555791854859 50.5562934875489,8.55218029022217 50.5568199157715,8.55443859100342 50.5579032897949,8.55270767211925 50.5607833862306,8.55344676971447 50.5651054382325,8.55113983154297 50.5665321350098,8.54925060272228 50.5732154846192,8.54293060302734 50.5739364624024,8.53990554809582 50.5770263671876,8.53696155548096 50.577663421631,8.54024505615229 50.5833969116211,8.53770351409923 50.5846672058106,8.53618717193609 50.5884590148926,8.53353881835949 50.5909347534181,8.5365133285523 50.5972137451173,8.5341157913208 50.6010856628419,8.53647136688244 50.6015853881837,8.5356502532959 50.6026000976564,8.537184715271 50.6041183471681,8.53630924224854 50.6081466674804,8.53470516204834 50.6096229553223,8.53809261322033 50.6124954223634,8.53638267517084 50.6144752502443,8.54329490661621 50.6169662475586,8.54862022399902 50.6171646118164,8.54710292816162 50.6203079223634,8.54710292816162 50.6203079223634,8.53598022460943 50.6203460693359,8.53522586822515 50.6153984069825,8.53345012664789 50.6162605285645,8.53216457366955 50.6229248046876,8.52182674407965 50.6268272399903,8.51907444000256 50.6303443908693,8.51907444000256 50.6303443908693,8.51668739318848 50.6302299499512,8.51305866241466 50.6283683776856,8.51030063629162 50.629005432129,8.50752258300787 50.6314430236817,8.50062370300299 50.6319274902345,8.49670886993408 50.6308059692384,8.49121093749994 50.6247138977051,8.48550415039057 50.6333656311036,8.47962284088135 50.6325759887695,8.47725296020508 50.6333656311036,8.47725296020508 50.6333656311036,8.47625160217285 50.630672454834,8.47892284393311 50.6278114318848,8.47722053527832 50.6161270141603,8.47953128814703 50.6150436401367,8.48457813262945 50.6151313781738,8.48361778259283 50.6124496459962,8.48361110687256 50.6057243347169,8.481508255005 50.6049690246583,8.4824647903443 50.6011428833008,8.47963809967041 50.5958709716797,8.48002910614008 50.5940170288087,8.47828483581549 50.5902061462403,8.4795875549317 50.5885276794434,8.47940826416016 50.5851402282716,8.48457145690924 50.5834197998047,8.4835929870606 50.5805397033693,8.48219013214106 50.5809478759766,8.47796154022217 50.5796852111816,8.47498321533214 50.5802268981934,8.47001075744635 50.5765686035157,8.45915126800531 50.576976776123,8.45845603942877 50.5754013061523,8.45658111572271 50.575294494629,8.45658111572271 50.575294494629,8.46036052703869 50.5709609985352,8.45849704742432 50.5702514648438,8.45772647857666 50.5671882629396,8.45585632324224 50.5656776428224,8.45729637146002 50.5611763000488,8.46016597747803 50.5565986633301,8.45207309722906 50.555233001709,8.44705963134771 50.557113647461,8.44430160522467 50.5555801391602,8.4475154876709 50.5518836975098,8.44842147827148 50.5476417541504,8.44617938995361 50.5472145080566,8.44891834259039 50.5427474975586,8.44490242004406 50.5399551391602,8.44578552246105 50.5333366394043,8.44674301147461 50.5314636230468,8.4486169815064 50.5309295654297,8.44869327545177 50.5291786193848,8.44869327545177 50.5291786193848,8.45587348937994 50.5300064086914,8.46156406402594 50.5325927734376,8.46647930145275 50.5335502624512,8.46654033660889 50.529556274414,8.47252464294434 50.5243949890137,8.47570323944092 50.5201148986816,8.4778785705567 50.5204048156739,8.48056793212891 50.518280029297,8.4788179397583 50.5176315307618,8.4817218780517 50.5151062011719,8.48014259338385 50.5078430175781,8.48341464996332 50.5079154968261,8.48941612243664 50.5101547241211,8.48941612243664 50.5101547241211,8.49089336395275 50.5122337341309,8.49429035186773 50.5100517272949,8.49794101715088 50.5104942321778,8.50549983978266 50.5149612426758,8.50944805145264 50.5160751342773,8.51344680786127 50.5203094482422,8.51924419403082 50.5244522094727,8.52379703521734 50.5259704589844,8.52936172485357 50.5252647399902,8.53424930572515 50.5265617370607,8.53469181060802 50.5284690856935,8.54247379302984 50.530113220215,8.53678321838385 50.5334815979004,8.54015827178949 50.5361862182618,8.54281997680658 50.5346832275392,8.54948711395264 50.5353164672852,8.55214309692394 50.5366516113281,8.55652809143066 50.5357971191407)) | 0.0006 | POINT(8.521596546414568 50.569057609461545) |
| 1397250 | POLYGON((-1.92094004154194 40.6634178161622,-1.92577600479126 40.6664009094238,-1.92601501941675 40.6692504882813,-1.93267500400538 40.6670875549318,-1.9399950504303 40.6694412231446,-1.93216001987457 40.6749267578125,-1.93564903736115 40.6779518127443,-1.93300497531885 40.6812057495117,-1.93274104595179 40.6889152526855,-1.93962597846985 40.7047882080079,-1.94188904762262 40.7053298950196,-1.94507801532745 40.7035560607911,-1.94570195674885 40.7060585021973,-1.94337296485901 40.7095336914064,-1.94691002368927 40.7111511230469,-1.94719696044922 40.7170906066896,-1.93317198753357 40.7308769226074,-1.93018603324884 40.7302932739258,-1.92659902572632 40.7316398620605,-1.91956305503845 40.7295188903809,-1.91700601577759 40.7259445190431,-1.90662705898285 40.7204971313477,-1.88906395435328 40.7228622436524,-1.88240194320673 40.7176628112794,-1.87717795372004 40.7157440185547,-1.87073898315424 40.7191162109374,-1.8668400049209 40.7256088256836,-1.8532919883728 40.7133331298829,-1.84928798675537 40.7072105407715,-1.84843802452087 40.7015724182129,-1.86789703369129 40.7002716064453,-1.87962794303894 40.6895484924317,-1.88866496086121 40.6878051757814,-1.8951940536499 40.6844100952148,-1.89896905422205 40.6764717102052,-1.90827703475941 40.6650772094728,-1.92094004154194 40.6634178161622)) | 0.0006 | POINT(-1.911048756705359 40.70032140943744) |
| 36185 | POLYGON((6.50104570388794 47.7658920288087,6.47941398620611 47.7581596374512,6.47674512863171 47.7520751953124,6.47674512863171 47.7520751953124,6.48495864868175 47.7485694885254,6.49235486984264 47.7401580810547,6.50626993179333 47.7381019592285,6.50626993179333 47.7381019592285,6.52408933639532 47.7439918518066,6.52408933639532 47.7439918518066,6.51544904708874 47.747055053711,6.52850818634033 47.7695426940918,6.52850818634033 47.7695426940918,6.50550556182867 47.7725334167482,6.50550556182867 47.7725334167482,6.50104570388794 47.7658920288087)) | 0.0006 | POINT(6.503697236379059 47.75415496826172) |
| 27020 | POLYGON((-1.37494325637812 48.4592628479004,-1.34653294086456 48.4731178283693,-1.34847676753992 48.4798927307129,-1.34141492843628 48.4892082214355,-1.34141492843628 48.4892082214355,-1.37322652339935 48.4984741210938,-1.38574743270868 48.5091018676757,-1.38554406166077 48.5125045776368,-1.37694585323334 48.516227722168,-1.37694585323334 48.516227722168,-1.38926804065699 48.5260467529298,-1.38926804065699 48.5260467529298,-1.40353119373322 48.5138664245606,-1.40353119373322 48.5138664245606,-1.41202664375294 48.5052452087402,-1.41261601448053 48.4985542297363,-1.3966064453125 48.4807891845704,-1.37729334831232 48.4793128967285,-1.37494325637812 48.4592628479004)) | 0.0006 | POINT(-1.3797407481405195 48.49927520751956) |
| 62155 | MULTIPOLYGON(((9.55747222900391 47.1640968322755,9.55337905883789 47.1654853820801,9.53714370727539 47.1654243469239,9.52591228485113 47.1673011779786,9.52408218383795 47.1649322509766,9.52145099639904 47.1645088195802,9.52181339263916 47.160041809082,9.51533699035645 47.1586112976074,9.51006603240967 47.1608543395997,9.50827980041504 47.1666450500488,9.50869846344 47.1687202453613,9.49741268157965 47.1698379516602,9.49848079681396 47.1655120849611,9.5092887878418 47.1590576171876,9.50841045379644 47.157886505127,9.50991439819342 47.1569213867188,9.51226711273193 47.1506805419923,9.51688575744629 47.1465225219727,9.51320743560785 47.145420074463,9.51234626770025 47.1473693847657,9.50619029998774 47.1529655456544,9.50175380706787 47.1529846191406,9.50898265838629 47.1454582214355,9.51131343841553 47.139144897461,9.51131343841553 47.139144897461,9.50835704803467 47.1426467895509,9.5041589736939 47.1454963684082,9.5041589736939 47.1454963684082,9.49271869659424 47.161346435547,9.48702430725103 47.177101135254,9.48669147491461 47.1847648620605,9.48955249786383 47.1953697204591,9.48955249786383 47.1953697204591,9.49316883087164 47.1936645507812,9.49610042572027 47.1898880004883,9.50650882720959 47.196231842041,9.50650882720959 47.196231842041,9.50890636444092 47.1912231445313,9.51389884948725 47.1851615905762,9.52198886871338 47.18558883667,9.51889038085932 47.1957130432129,9.51889038085932 47.1957130432129,9.52740192413324 47.195240020752,9.52740192413324 47.195240020752,9.52826023101801 47.1940536499023,9.53793716430664 47.1894073486328,9.53916835784918 47.1913146972656,9.53496837615978 47.1943283081056,9.53496837615978 47.1943283081056,9.54160976409912 47.1941909790039,9.54160976409912 47.1941909790039,9.5483541488648 47.1951446533203,9.55231952667242 47.1931037902833,9.55231952667242 47.1931037902833,9.55328369140625 47.192741394043,9.55328369140625 47.192741394043,9.54588985443121 47.1905326843262,9.54374122619623 47.1909751892091,9.54036045074469 47.1860656738282,9.54469585418713 47.182689666748,9.54512023925787 47.1785888671875,9.55149459838873 47.1774711608888,9.55316066741955 47.1788406372071,9.55739593505871 47.1786613464355,9.56806087493908 47.1739044189454,9.56204986572266 47.1684532165528,9.56204986572266 47.1684532165528,9.55747222900391 47.1640968322755)),((9.52395153045654 47.1792793273926,9.52569007873535 47.1790847778321,9.52735233306885 47.1768531799317,9.52948379516596 47.1760902404786,9.5317554473877 47.1781196594238,9.52468776702887 47.1812858581544,9.52395153045654 47.1792793273926)),((9.53591060638428 47.1855010986329,9.53713989257818 47.1858482360841,9.53693866729731 47.1869544982911,9.53409481048595 47.1878089904785,9.53369426727295 47.1867179870606,9.53591060638428 47.1855010986329)),((9.54913043975841 47.181339263916,9.55044746398926 47.1812210083008,9.55088710784923 47.180233001709,9.5545854568482 47.1810111999512,9.5530042648316 47.1825065612793,9.54796314239513 47.1834335327149,9.54791069030762 47.181999206543,9.54913043975841 47.181339263916)),((9.62360191345215 47.1127014160157,9.6218576431275 47.1109352111816,9.61303424835216 47.1127090454103,9.60184955596924 47.1129302978515,9.59553146362305 47.110652923584,9.59553146362305 47.110652923584,9.58593654632574 47.1123924255372,9.58593654632574 47.1123924255372,9.58665466308594 47.1182289123535,9.58931541442877 47.1233825683595,9.58949661254888 47.1262550354004,9.5791597366333 47.1281242370605,9.56996345520025 47.1337432861328,9.57291030883795 47.1378631591798,9.5748462677002 47.1373481750489,9.57567882537842 47.1395111083985,9.5817956924439 47.143768310547,9.58324432373047 47.1474685668945,9.58324432373047 47.1474685668945,9.5952787399292 47.143856048584,9.59912109375006 47.1436347961426,9.60168266296387 47.1419143676757,9.60168266296387 47.1419143676757,9.59620475769049 47.1368255615234,9.5894603729248 47.1352882385255,9.59417915344244 47.130802154541,9.6027946472168 47.1308784484864,9.60561752319336 47.1290550231934,9.61169815063471 47.1287651062012,9.61169815063471 47.1287651062012,9.61398410797125 47.1221427917482,9.62321281433105 47.1195526123048,9.62541198730474 47.1186294555665,9.62527656555181 47.11771774292,9.62527656555181 47.11771774292,9.62199592590332 47.1137809753417,9.62360191345215 47.1127014160157)),((9.61285495758062 47.0795745849609,9.60683536529552 47.0858078002931,9.6053199768067 47.0893669128417,9.6053199768067 47.0893669128417,9.5893497467041 47.0922698974611,9.5893497467041 47.0922698974611,9.59067058563244 47.0896530151367,9.58942794799805 47.0873107910157,9.58985137939447 47.0860748291016,9.59450626373291 47.0766563415527,9.59753036499035 47.0726966857911,9.59475612640392 47.0705680847169,9.59741592407227 47.069133758545,9.6004848480224 47.0653953552246,9.60690307617193 47.0614547729492,9.60690307617193 47.0614547729492,9.60852813720714 47.0617294311524,9.60852813720714 47.0617294311524,9.60769653320318 47.062385559082,9.61185455322266 47.0750045776367,9.61285495758062 47.0795745849609))) | 0.0006 | POINT(9.5563379725845 47.14560341071702) |
| 36151 | POLYGON((6.6959338188172 47.783531188965,6.68107175827032 47.784938812256,6.66086864471436 47.7740211486817,6.64550065994268 47.7746429443359,6.64550065994268 47.7746429443359,6.618076324463 47.7677993774415,6.61722135543835 47.7613220214844,6.61722135543835 47.7613220214844,6.62211036682129 47.761100769043,6.62932491302496 47.7526588439942,6.63898658752453 47.7526931762695,6.64160537719727 47.739616394043,6.64160537719727 47.739616394043,6.68684864044189 47.7373275756837,6.68684864044189 47.7373275756837,6.69787788391119 47.7484321594239,6.71649074554449 47.7549667358398,6.72994136810314 47.7657661437988,6.72994136810314 47.7657661437988,6.72872304916393 47.7720336914063,6.72872304916393 47.7720336914063,6.71388721466059 47.779884338379,6.6959338188172 47.783531188965)) | 0.0006 | POINT(6.6715595071966565 47.76188382235444) |
| 1407346 | POLYGON((-6.53280210494995 40.2726097106934,-6.53296709060663 40.2743797302247,-6.54092311859131 40.279972076416,-6.54421377182007 40.2898063659669,-6.55606079101557 40.2907829284669,-6.55947685241699 40.2958030700684,-6.55590581893915 40.3041801452637,-6.55662393569946 40.3064079284669,-6.56463098526001 40.3146209716797,-6.56029605865479 40.3290557861328,-6.53616905212397 40.3472518920899,-6.51626300811768 40.3542442321778,-6.50705480575556 40.3374214172363,-6.482253074646 40.3126564025879,-6.46394491195673 40.3018035888672,-6.45619201660151 40.3043060302734,-6.45667505264282 40.3006172180176,-6.46228790283197 40.2972259521484,-6.46407508850092 40.2884788513185,-6.46876287460327 40.2812576293946,-6.47476911544794 40.2770690917969,-6.48460817337036 40.2628135681152,-6.50583076477045 40.267864227295,-6.5084609985351 40.2668647766114,-6.51874494552607 40.2667961120605,-6.53280210494995 40.2726097106934)) | 0.0006 | POINT(-6.512399692535371 40.29697158813481) |
| 1407412 | POLYGON((-6.52970504760742 39.544460296631,-6.53076505661005 39.5394401550294,-6.53381013870239 39.5379829406738,-6.53502511978144 39.5318870544433,-6.53379201889038 39.5275650024415,-6.52834415435791 39.5219726562501,-6.5262770652771 39.5153617858887,-6.52958202362061 39.5121726989747,-6.52875185012817 39.509822845459,-6.52178716659546 39.5091400146484,-6.51946496963501 39.5034255981445,-6.5050840377807 39.4900627136232,-6.50507020950317 39.4837875366211,-6.50788688659668 39.4767036437989,-6.50469207763672 39.4739074707032,-6.51556301116943 39.4712562561035,-6.52152490615845 39.4747200012207,-6.52428483963007 39.4693069458008,-6.53441095352173 39.4758071899415,-6.54070901870728 39.4766960144044,-6.54194593429565 39.4781723022462,-6.54892015457148 39.4656372070313,-6.56189298629761 39.4622879028321,-6.56810617446894 39.4626617431641,-6.57357597351074 39.4589653015138,-6.57856512069702 39.4579124450684,-6.57696485519409 39.4536819458008,-6.5778288841247 39.450122833252,-6.58089685440058 39.44926071167,-6.58121395111078 39.4524765014648,-6.58470106124878 39.449993133545,-6.58818817138666 39.4514160156251,-6.59948492050165 39.4517173767091,-6.60174417495728 39.4489059448243,-6.61807584762573 39.4506225585938,-6.61846780776972 39.4548454284668,-6.62076282501221 39.4536209106445,-6.62310409545893 39.4550590515137,-6.62337493896479 39.4578208923341,-6.62000703811646 39.4587516784669,-6.62016391754145 39.4608726501466,-6.6281361579895 39.4705047607423,-6.62697601318359 39.4808273315431,-6.6368842124939 39.4833717346192,-6.63659000396729 39.4848403930665,-6.63939285278315 39.4866828918456,-6.6371030807494 39.4920310974121,-6.64550304412842 39.4941635131837,-6.64899015426636 39.4926109313965,-6.64709186553955 39.4965515136719,-6.64839792251587 39.5008430480957,-6.64533710479731 39.5010108947754,-6.64299917221069 39.5054168701173,-6.6487398147583 39.509147644043,-6.6426568031311 39.515796661377,-6.6402859687804 39.5269584655762,-6.6320338249206 39.5355033874511,-6.62954711914063 39.5442466735841,-6.62819576263428 39.5640678405763,-6.62375593185419 39.5735473632814,-6.61040687561035 39.591480255127,-6.60714578628529 39.5936889648438,-6.59793615341181 39.5948028564454,-6.58730602264399 39.5984001159669,-6.57040596008295 39.6106986999512,-6.56427478790278 39.6038131713868,-6.56778287887562 39.5941162109376,-6.55652093887329 39.5804100036622,-6.55717992782593 39.5764427185059,-6.55141592025751 39.5702323913574,-6.55801916122437 39.5698432922363,-6.54944705963135 39.559482574463,-6.55210685729969 39.556640625,-6.54699182510376 39.5517349243165,-6.55003309249872 39.5508918762208,-6.55002784729004 39.549659729004,-6.54443693161011 39.546802520752,-6.52970504760742 39.544460296631)) | 0.0006 | POINT(-6.579669754226461 39.507630484444775) |
| 29995 | POLYGON((3.4348545074464 48.2338447570801,3.40530800819403 48.2376670837403,3.37582349777222 48.2337951660157,3.37582349777222 48.2337951660157,3.37720537185669 48.2274017333984,3.36830496788036 48.2198028564453,3.37268400192261 48.2107086181641,3.37268400192261 48.2107086181641,3.41216659545904 48.2138977050781,3.42332482337952 48.2202835083009,3.42332482337952 48.2202835083009,3.43468332290661 48.2228775024414,3.43468332290661 48.2228775024414,3.4348545074464 48.2338447570801)) | 0.0006 | POINT(3.4008362109844956 48.22368797889126) |
| 51655 | POLYGON((3.12365484237671 49.9472007751465,3.10476469993586 49.9403305053712,3.10019397735607 49.9305686950684,3.09148931503302 49.9264068603517,3.09148931503302 49.9264068603517,3.10497927665705 49.9229583740235,3.11762022972113 49.9139633178712,3.11762022972113 49.9139633178712,3.12366747856146 49.9180183410645,3.12366747856146 49.9180183410645,3.13787865638744 49.9358596801758,3.13787865638744 49.9358596801758,3.12365484237671 49.9472007751465)) | 0.0006 | POINT(3.114575346310982 49.92746289571133) |