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 |
---|---|---|---|
70634 | POLYGON((10.9098930358887 51.0487289428712,10.9071340560914 51.0483360290528,10.9061241149903 51.0503005981445,10.8998222351075 51.049617767334,10.8964424133302 51.059986114502,10.8817825317383 51.0568847656251,10.872462272644 51.0571403503419,10.872462272644 51.0571403503419,10.8724975585939 51.0544509887696,10.8700160980224 51.0530090332032,10.8704719543458 51.049285888672,10.8697280883789 51.0490722656251,10.8717765808106 51.04642868042,10.8695402145387 51.0452575683595,10.8723144531251 51.0387496948243,10.8712272644044 51.0384407043458,10.8714914321899 51.0340576171874,10.8695497512818 51.0338745117188,10.8701295852662 51.0296363830566,10.8627681732177 51.027931213379,10.8627681732177 51.027931213379,10.862985610962 51.0265426635743,10.862985610962 51.0265426635743,10.8698167800903 51.0280265808107,10.876651763916 51.0280838012696,10.8811836242677 51.0274314880372,10.8823213577271 51.0252418518066,10.8975839614868 51.0248832702637,10.9052801132203 51.0207290649414,10.9103174209596 51.0209617614747,10.9112205505371 51.0198326110841,10.9101219177247 51.0182266235351,10.9132461547852 51.015048980713,10.923836708069 51.0158119201661,10.9250535964966 51.0146560668945,10.9298877716065 51.0176239013673,10.9275484085084 51.0238227844239,10.9287080764772 51.0242767333986,10.9295682907105 51.0278205871583,10.9313840866089 51.0282287597657,10.9321594238282 51.029899597168,10.9364137649536 51.0304870605469,10.9364137649536 51.0304870605469,10.9310531616212 51.032527923584,10.9170923233033 51.0350799560547,10.9122819900514 51.0349464416504,10.914158821106 51.0405349731445,10.9117889404298 51.040454864502,10.9138040542603 51.0440177917482,10.9133644104004 51.0458755493163,10.911361694336 51.0454330444337,10.9098930358887 51.0487289428712)) | 0.0006 | POINT(10.897254831650729 51.03529013839427) |
1403910 | POLYGON((0.725071012973785 41.4165344238282,0.72310400009161 41.4183273315431,0.724416971206722 41.4224815368652,0.721487998962402 41.4323272705078,0.72334802150732 41.4405784606934,0.721288025379295 41.4420127868653,0.721230983734131 41.4475021362306,0.715304970741272 41.4575347900391,0.723686993122158 41.4703407287598,0.726271986961422 41.4702987670899,0.727869987487793 41.4683113098145,0.736468970775718 41.4685821533204,0.741321027278957 41.4651107788086,0.75460600852972 41.4638290405274,0.771220982074794 41.4670867919922,0.780062019825039 41.4653091430664,0.783490002155361 41.4680519104004,0.79355001449585 41.4568328857423,0.798041999340057 41.4476890563965,0.797173976898193 41.4459228515626,0.797403991222438 41.4427032470704,0.788277983665466 41.4421768188478,0.792925000190849 41.4387550354004,0.787980020046177 41.4356231689454,0.785260975360984 41.4300117492676,0.765348017215786 41.4444427490236,0.756254017353172 41.4326553344726,0.764219999313411 41.4224433898925,0.762486994266567 41.4214668273927,0.764997005462646 41.4178886413574,0.762610971927643 41.416561126709,0.752614021301383 41.4197349548341,0.733920991420746 41.4229621887208,0.725071012973785 41.4165344238282)) | 0.0006 | POINT(0.7552519982511778 41.443093617757214) |
22535 | POLYGON((-0.802942097187042 43.8434638977051,-0.807475864887238 43.8380889892579,-0.825057625770512 43.8417167663575,-0.825057625770512 43.8417167663575,-0.828241467475834 43.8582000732423,-0.83367216587061 43.8636054992677,-0.838395655155125 43.8640327453614,-0.845382153987828 43.85941696167,-0.869087934493905 43.8606605529785,-0.869087934493905 43.8606605529785,-0.8795028328895 43.8728218078613,-0.8795028328895 43.8728218078613,-0.864036500453949 43.8905258178711,-0.864036500453949 43.8905258178711,-0.855200648307743 43.8936233520508,-0.796303808689061 43.8958435058594,-0.796303808689061 43.8958435058594,-0.777666628360691 43.8857116699219,-0.77036273479456 43.8732070922852,-0.756783366203308 43.8710632324219,-0.756783366203308 43.8710632324219,-0.772061347961426 43.8632926940918,-0.794259786605835 43.8456230163575,-0.802942097187042 43.8434638977051)) | 0.0006 | POINT(-0.8220523777214958 43.86754475469178) |
1408888 | POLYGON((-2.05519700050348 42.1108474731446,-2.05214500427246 42.1086540222169,-2.04850697517395 42.1084518432617,-2.04211211204523 42.1115303039552,-2.03592205047607 42.1065444946289,-2.02631306648249 42.1029968261719,-2.02065205574036 42.1037750244141,-2.01421093940735 42.0995674133301,-2.0076539516449 42.0989456176758,-1.99969494342798 42.0943908691407,-1.98205494880671 42.0889930725098,-1.97410905361176 42.0799903869629,-1.97357797622681 42.0747528076172,-1.97725701332092 42.0639572143556,-1.97144305706013 42.0556945800782,-1.98132300376886 42.0500717163086,-1.98636198043823 42.041675567627,-1.99576997756952 42.0381507873535,-2.00749397277832 42.0363159179689,-2.01966500282282 42.0383644104004,-2.02638411521906 42.0374679565429,-2.0281069278717 42.0353202819824,-2.02616000175476 42.0337715148926,-2.0281069278717 42.0289268493653,-2.0337131023407 42.0257377624511,-2.03713011741638 42.0201644897461,-2.03852891921997 42.0202674865723,-2.03880000114441 42.0175857543946,-2.0423150062561 42.0159301757813,-2.04684805870045 42.0076026916505,-2.05353498458857 42.0052719116211,-2.06102705001831 42.0050048828126,-2.06247401237488 42.0010452270507,-2.07469701766968 41.9966163635254,-2.07982492446899 41.9960517883301,-2.08528304100037 41.9985389709473,-2.08351898193354 42.0035591125489,-2.08516311645508 42.0059852600098,-2.08323192596436 42.0093116760255,-2.08408904075611 42.0144157409669,-2.0716249942779 42.0193595886231,-2.06529808044434 42.025001525879,-2.06947302818298 42.0294380187989,-2.06132507324219 42.0323638916016,-2.05528092384333 42.0374908447266,-2.05279397964478 42.0405960083008,-2.05306100845331 42.0446510314941,-2.03924489021301 42.0385742187501,-2.03631401062012 42.0454940795898,-2.03983688354487 42.0489997863771,-2.05384993553156 42.0541152954102,-2.05572295188904 42.0573348999023,-2.05458092689508 42.0594635009766,-2.05689001083374 42.0602264404297,-2.05095100402826 42.0654373168946,-2.04928898811335 42.0690803527832,-2.0544331073761 42.0750770568848,-2.05516505241388 42.0786857604981,-2.05155396461481 42.0906867980958,-2.05519700050348 42.1108474731446)) | 0.0006 | POINT(-2.0389337317417984 42.04854784173482) |
46793 | POLYGON((3.2522280216217 50.5243034362794,3.25277376174932 50.5292396545411,3.25277376174932 50.5292396545411,3.26037502288824 50.5287284851074,3.26037502288824 50.5287284851074,3.28653144836426 50.5275764465332,3.28653144836426 50.5275764465332,3.32094979286194 50.5172576904297,3.32885837554932 50.508129119873,3.32885837554932 50.508129119873,3.29408288002026 50.5065727233886,3.29408288002026 50.5065727233886,3.27793669700634 50.5061874389649,3.25514912605297 50.5144767761231,3.2522280216217 50.5243034362794)) | 0.0006 | POINT(3.2822504724775534 50.51876558576312) |
30954 | POLYGON((-1.95848250389093 48.0839729309083,-1.93633413314819 48.0802345275878,-1.93633413314819 48.0802345275878,-1.92182326316833 48.0804557800293,-1.9187301397323 48.0778694152833,-1.92029130458826 48.0580787658693,-1.92029130458826 48.0580787658693,-1.90526747703547 48.0598030090333,-1.89449369907379 48.0669174194337,-1.87567436695099 48.0711326599121,-1.87567436695099 48.0711326599121,-1.90990185737604 48.0982627868653,-1.90990185737604 48.0982627868653,-1.90800178050995 48.1014251708985,-1.91702783107758 48.1132202148438,-1.91702783107758 48.1132202148438,-1.92553865909571 48.114974975586,-1.92653846740723 48.1210746765137,-1.92653846740723 48.1210746765137,-1.94498991966248 48.1188125610353,-1.96165812015522 48.1024589538575,-1.96660006046295 48.1027641296387,-1.96660006046295 48.1027641296387,-1.96803879737843 48.0934448242189,-1.96301174163818 48.0847740173341,-1.95848250389093 48.0839729309083)) | 0.0006 | POINT(-1.926990885734531 48.09097778320318) |
65751 | POLYGON((11.1213674545289 47.6591339111329,11.126877784729 47.66263961792,11.1245212554933 47.6655769348144,11.1250314712525 47.6671905517579,11.12428855896 47.6695022583008,11.1218156814575 47.6716079711914,11.1291303634645 47.6721191406251,11.1291303634645 47.6721191406251,11.1346292495727 47.6716079711914,11.1446390151978 47.6725730895997,11.1425580978394 47.6749877929689,11.1477050781251 47.6755294799805,11.1484718322754 47.6749305725097,11.1502418518067 47.6756553649903,11.1502523422241 47.6737518310547,11.1526784896852 47.6735496520997,11.1553964614869 47.6741256713867,11.1554899215698 47.6758155822754,11.1573934555054 47.6760177612305,11.1570882797241 47.6769218444825,11.1584300994873 47.6772232055665,11.1655187606812 47.6755142211915,11.1700353622438 47.6765670776367,11.1705284118653 47.6736602783204,11.1793079376221 47.6739349365234,11.1773557662965 47.675350189209,11.1763563156128 47.6775779724122,11.1840553283693 47.6780967712403,11.1868705749512 47.6767654418945,11.1879272460938 47.6809997558594,11.1919994354248 47.6804084777833,11.1916103363037 47.6853332519531,11.1923503875732 47.6858558654785,11.1945056915284 47.6859321594239,11.1954803466797 47.6834602355958,11.1980838775635 47.6824607849122,11.1975746154786 47.6866455078126,11.2000665664672 47.686882019043,11.1992511749268 47.6885223388673,11.2024192810058 47.6949424743653,11.2017717361451 47.6982650756837,11.2017717361451 47.6982650756837,11.2054567337037 47.6993980407715,11.2069683074952 47.6985549926758,11.2093515396119 47.700870513916,11.2110452651978 47.704460144043,11.2183752059937 47.7048263549805,11.2193241119386 47.7070999145508,11.2257308959962 47.7091751098633,11.2255420684815 47.7131462097169,11.2264957427979 47.7140121459962,11.2294073104858 47.7136573791504,11.2294073104858 47.7136573791504,11.2313919067383 47.7108726501465,11.2302465438843 47.7096443176269,11.2303600311279 47.7077865600587,11.2262239456177 47.7019653320312,11.2275714874268 47.7001991271973,11.2318086624145 47.6984825134278,11.2337627410889 47.6966171264648,11.2338972091675 47.6931304931642,11.2312288284303 47.689968109131,11.2328205108643 47.6886978149415,11.2339200973511 47.6892471313477,11.2357730865479 47.6849555969239,11.233346939087 47.6802024841309,11.2255907058716 47.6794090270997,11.2259197235107 47.6764144897461,11.2287769317628 47.6753082275391,11.2283115386962 47.6743927001954,11.2266921997071 47.6747016906739,11.2279863357545 47.6722030639648,11.2269735336304 47.6702423095704,11.2306785583496 47.6679725646973,11.2306785583496 47.6679725646973,11.2317075729371 47.6673889160156,11.2311439514161 47.6661720275879,11.233759880066 47.6640052795411,11.2270002365112 47.658016204834,11.2239618301392 47.659854888916,11.2152490615845 47.6598968505861,11.2154655456544 47.6586380004883,11.2114706039429 47.6549072265626,11.2122488021851 47.6527404785156,11.2118530273437 47.646240234375,11.2051534652709 47.6486549377441,11.2022924423217 47.6447830200196,11.2032403945923 47.6431427001954,11.2058401107789 47.6429023742676,11.2039079666138 47.6349258422853,11.1980829238892 47.6357345581054,11.198691368103 47.6364212036133,11.196785926819 47.6371002197266,11.1954708099365 47.6371536254883,11.1948127746582 47.635711669922,11.1938076019288 47.6361503601075,11.1936950683595 47.6376152038575,11.191743850708 47.6377983093262,11.1917085647584 47.6391105651855,11.1869707107545 47.6426620483398,11.1873340606689 47.643871307373,11.1772937774659 47.6404876708986,11.1772937774659 47.6404876708986,11.1748189926149 47.6398010253906,11.1745386123657 47.640682220459,11.1722259521484 47.638801574707,11.1653327941895 47.637191772461,11.1641397476197 47.6376266479493,11.1625165939332 47.6366043090821,11.1652269363404 47.6324539184571,11.1642885208129 47.6308784484863,11.1621246337891 47.6320190429688,11.1591548919679 47.63094329834,11.1564483642579 47.6281204223633,11.1545820236206 47.6226501464844,11.1545820236206 47.6226501464844,11.1508159637451 47.6226501464844,11.1426610946655 47.6268844604493,11.1459140777587 47.6296844482422,11.1425504684448 47.6308021545411,11.1429147720337 47.6321296691895,11.1384582519531 47.6350135803224,11.1342248916627 47.6344032287598,11.1307010650635 47.6366577148439,11.1322975158691 47.637767791748,11.1282653808595 47.6416168212892,11.1321859359742 47.6455421447755,11.1308679580688 47.647071838379,11.131597518921 47.6490631103517,11.1290416717529 47.6501274108886,11.1288537979127 47.6534576416017,11.126410484314 47.6569290161133,11.1226253509522 47.6573562622071,11.1232738494874 47.6582145690919,11.1213674545289 47.6591339111329)) | 0.0006 | POINT(11.18399006573125 47.66586292323783) |
59249 | POLYGON((7.85108613967907 47.5407218933106,7.84021997451782 47.5390968322755,7.83050584793097 47.5399169921876,7.83050584793097 47.5399169921876,7.82360506057751 47.5417327880859,7.8165540695191 47.5415153503419,7.8165540695191 47.5415153503419,7.81859397888195 47.5474662780763,7.81723403930675 47.5519981384278,7.81771278381353 47.5537834167482,7.81953716278076 47.5557136535644,7.82329177856451 47.5568122863771,7.82978487014771 47.5608406066896,7.83270978927612 47.5698432922363,7.83196020126348 47.571964263916,7.83310222625732 47.5774078369141,7.83163785934443 47.5805358886719,7.83608913421631 47.5834274291993,7.83561086654657 47.5891113281251,7.83561086654657 47.5891113281251,7.84756708145147 47.5894393920898,7.85994482040405 47.5943908691406,7.87232112884521 47.5956077575684,7.88742780685419 47.5947456359864,7.89423990249645 47.5922241210939,7.89773082733149 47.5895576477051,7.89773082733149 47.5895576477051,7.89252805709839 47.5864448547363,7.8879189491272 47.5805854797364,7.88043117523205 47.579128265381,7.87694787979132 47.5764656066896,7.87694787979132 47.5764656066896,7.87197113037109 47.5649490356446,7.86860179901123 47.5609054565431,7.86305284500116 47.5595207214357,7.85154390335083 47.5536689758301,7.85132598876953 47.547924041748,7.852942943573 47.5440330505372,7.85108613967907 47.5407218933106)) | 0.0006 | POINT(7.850081092432948 47.567053845054296) |
31103 | POLYGON((-3.39838314056396 47.8631057739258,-3.40084981918329 47.8530807495118,-3.39248251914967 47.8445472717285,-3.38801956176752 47.8230819702148,-3.38801956176752 47.8230819702148,-3.37346959114069 47.8259620666505,-3.36954522132874 47.8356018066407,-3.3555428981781 47.8400650024414,-3.34165334701538 47.8504257202149,-3.31621694564819 47.8508453369142,-3.31621694564819 47.8508453369142,-3.31719565391541 47.8569221496582,-3.31719565391541 47.8569221496582,-3.32619881629938 47.8598594665528,-3.33286595344532 47.8727684020996,-3.33543753623957 47.8894615173341,-3.33217334747309 47.8959579467773,-3.33217334747309 47.8959579467773,-3.35089778900141 47.9012985229492,-3.37796592712397 47.8909187316895,-3.38756775856012 47.8827018737793,-3.4024121761322 47.8853569030762,-3.4024121761322 47.8853569030762,-3.40389156341553 47.8683853149415,-3.39838314056396 47.8631057739258)) | 0.0006 | POINT(-3.360782802104915 47.86260461807254) |
68731 | POLYGON((14.2180118560792 51.1365814208985,14.2230215072632 51.1353149414064,14.225347518921 51.1330871582031,14.2291879653931 51.1318740844728,14.2408866882324 51.1322402954103,14.2465448379517 51.1296272277833,14.2498102188111 51.1292877197266,14.2595872879028 51.1306648254394,14.2730731964111 51.1278419494629,14.2730731964111 51.1278419494629,14.2757406234742 51.1294784545898,14.2760190963746 51.1384963989258,14.2810506820679 51.1429367065431,14.2843971252442 51.1444396972657,14.2874679565429 51.1422424316406,14.2892713546753 51.1457252502441,14.2874794006348 51.1464042663575,14.2865953445436 51.1490745544434,14.2875871658325 51.1510391235352,14.2866029739381 51.1563339233398,14.2866029739381 51.1563339233398,14.2849798202515 51.1571617126466,14.2839126586915 51.1612701416015,14.2802162170411 51.1614418029786,14.2804899215698 51.1597137451173,14.2760725021363 51.1603584289552,14.2755899429322 51.1616363525392,14.2706079483033 51.1637878417969,14.2718963623047 51.1658897399903,14.2738656997681 51.1657905578613,14.2740869522096 51.167263031006,14.2717914581299 51.1679306030275,14.2703313827515 51.1712913513183,14.2566547393799 51.1728057861329,14.2546520233154 51.1691589355469,14.2485475540161 51.1705627441407,14.2495393753052 51.1743049621583,14.2495393753052 51.1743049621583,14.2412929534912 51.1749458312988,14.2419691085815 51.1760406494141,14.2396965026855 51.1761169433595,14.2302379608154 51.1739845275879,14.2303352355956 51.1751976013184,14.2244663238526 51.174747467041,14.222505569458 51.1763763427734,14.2104072570801 51.1735000610352,14.2038507461548 51.1705436706543,14.2038507461548 51.1705436706543,14.2098064422607 51.1654815673828,14.2106533050538 51.1637153625488,14.213475227356 51.1621055603028,14.2129974365235 51.1575889587402,14.2137250900268 51.1539878845215,14.2162084579468 51.1501274108887,14.225079536438 51.1503677368165,14.2293691635132 51.1493911743165,14.2272634506226 51.1454772949219,14.2247886657716 51.1449890136719,14.2212600708009 51.1420745849609,14.2203521728516 51.1396903991699,14.217882156372 51.1392440795899,14.2180118560792 51.1365814208985)) | 0.0006 | POINT(14.249698466941988 51.15488158679403) |