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 |
|---|---|---|---|
| 59748 | POLYGON((7.75888204574596 46.8184471130372,7.75986099243164 46.8226737976075,7.75770616531383 46.8249397277833,7.75015687942511 46.8255386352539,7.74515104293829 46.8285598754883,7.73906612396246 46.82719039917,7.73906612396246 46.82719039917,7.73835086822515 46.8316993713379,7.73665904998785 46.8330688476564,7.72499895095825 46.8323554992676,7.72070693969738 46.8363189697267,7.71440076828014 46.836799621582,7.71440076828014 46.836799621582,7.71385478973383 46.8428649902344,7.71460676193249 46.8447303771973,7.72289085388178 46.8450050354005,7.72586011886608 46.8470039367676,7.72248077392584 46.8522834777831,7.72273015975964 46.8587265014648,7.71965694427502 46.8635139465333,7.71981716156017 46.8646087646484,7.71981716156017 46.8646087646484,7.72033882141113 46.86820602417,7.7141370773316 46.8781623840333,7.71419095993042 46.8803100585938,7.71669816970837 46.8823471069336,7.72921323776239 46.8882560729981,7.7358450889588 46.8901405334473,7.7358450889588 46.8901405334473,7.73790216445929 46.8877983093262,7.74812602996832 46.8838195800782,7.74812602996832 46.8838195800782,7.74670219421398 46.8798255920411,7.75065994262707 46.8737182617189,7.7636771202088 46.8721389770508,7.76438093185436 46.8711013793945,7.76311683654791 46.8693885803223,7.76345205307018 46.8680877685547,7.77217578887945 46.865535736084,7.77544403076172 46.8656005859375,7.77913188934326 46.8674430847169,7.78074598312384 46.8670883178711,7.78081417083746 46.8650436401368,7.77776098251343 46.8613166809082,7.77774286270147 46.8561248779297,7.77966022491466 46.853328704834,7.78374910354626 46.8504180908204,7.78302097320568 46.847381591797,7.784495830536 46.8428611755372,7.78876304626465 46.8388748168945,7.79128599166876 46.8324508666993,7.79776096343994 46.8272933959962,7.80810880661016 46.8220558166504,7.81027889251703 46.8175582885743,7.81069993972784 46.8133392333984,7.81246185302734 46.8116455078126,7.81685018539434 46.8102226257325,7.82311010360712 46.8115768432617,7.82311010360712 46.8115768432617,7.82608222961431 46.8112564086915,7.82810306549072 46.8099746704102,7.82814788818365 46.8057975769043,7.82814788818365 46.8057975769043,7.82373380661016 46.8035163879395,7.81514978408819 46.804573059082,7.80798482894897 46.8034362792969,7.80047178268438 46.8038139343263,7.79217290878307 46.8032455444337,7.78353977203375 46.8010635375978,7.77998304367071 46.8014678955078,7.77610921859741 46.8045234680176,7.77610921859741 46.8045234680176,7.76856803894049 46.8077964782716,7.7650809288026 46.8109169006348,7.7643718719483 46.8165550231934,7.75888204574596 46.8184471130372)) | 0.0006 | POINT(7.764726149241184 46.84092244466147) |
| 1388562 | POLYGON((-7.08714294433588 37.3911285400392,-7.13754415512079 37.3988037109374,-7.14516305923462 37.4258003234863,-7.14328718185425 37.4394607543945,-7.13504981994629 37.4417114257812,-7.12940502166748 37.4495315551757,-7.12575101852411 37.4628372192384,-7.12367105484009 37.4650344848633,-7.12590408325195 37.4725799560548,-7.12397384643549 37.4732208251953,-7.12282085418701 37.47713470459,-7.11591005325317 37.4762039184571,-7.11279010772705 37.4776382446289,-7.10794687271118 37.475067138672,-7.10152721405024 37.4750480651855,-7.10005903244019 37.4731979370117,-7.09419012069702 37.4721412658691,-7.0932240486145 37.4699668884278,-7.08959293365479 37.4730033874512,-7.08715915679926 37.4731407165527,-7.0829291343689 37.4680938720703,-7.08367919921875 37.4658813476564,-7.08148193359375 37.4641113281251,-7.07031202316284 37.4614868164063,-7.06500291824341 37.4630737304687,-7.05822801589966 37.4584960937499,-7.05468797683716 37.4583129882812,-7.04479885101307 37.4295043945312,-7.06097412109375 37.4215087890625,-7.07177686691278 37.4141235351563,-7.08068799972534 37.3936767578125,-7.08714294433588 37.3911285400392)) | 0.0006 | POINT(-7.098602310303702 37.453578087591374) |
| 47539 | POLYGON((1.94050574302679 50.8796844482422,1.94183504581446 50.8698196411134,1.91519892215734 50.8480224609376,1.91519892215734 50.8480224609376,1.89283382892609 50.8563842773438,1.89283382892609 50.8563842773438,1.90822827816004 50.8771209716797,1.91854274272924 50.877540588379,1.91882586479193 50.8808364868165,1.91882586479193 50.8808364868165,1.94050574302679 50.8796844482422)) | 0.0006 | POINT(1.9162829041481249 50.86746520996102) |
| 45778 | POLYGON((1.45452523231512 44.8517112731934,1.4591212272644 44.8452301025392,1.4591212272644 44.8452301025392,1.46074795722967 44.8385238647462,1.46074795722967 44.8385238647462,1.44760692119598 44.8418617248536,1.43990206718445 44.8381004333497,1.42629551887524 44.8403930664063,1.4130140542984 44.8441314697265,1.40286231040966 44.8508110046387,1.40286231040966 44.8508110046387,1.40557813644415 44.8630599975586,1.409291625023 44.8647270202637,1.409291625023 44.8647270202637,1.42062854766846 44.8587265014649,1.4393196105957 44.8590660095216,1.45452523231512 44.8517112731934)) | 0.0006 | POINT(1.4319322705269348 44.849727153778126) |
| 1398602 | POLYGON((-4.77132892608643 40.3443794250489,-4.76780605316151 40.3379783630371,-4.76148319244385 40.3374824523926,-4.75770378112793 40.3330001831055,-4.75096702575678 40.328742980957,-4.75089883804316 40.3187980651857,-4.74406623840332 40.3043441772462,-4.745940208435 40.2971420288087,-4.74268007278442 40.2957267761232,-4.73981809616089 40.2901191711426,-4.73609781265253 40.288158416748,-4.73234176635737 40.2816009521484,-4.73238611221308 40.2782135009766,-4.7273850440979 40.2735404968262,-4.72849512100214 40.2705268859864,-4.73207092285156 40.2709236145021,-4.74251890182489 40.2752876281739,-4.75321483612049 40.2640991210938,-4.7610821723938 40.2609443664551,-4.77800893783569 40.2656135559083,-4.78157186508173 40.2673797607422,-4.78322219848633 40.2702255249024,-4.78876209259033 40.2720680236818,-4.80414390563965 40.2751007080078,-4.80646705627436 40.2841339111329,-4.80249595642078 40.2891960144044,-4.8084077835083 40.2969703674316,-4.80476379394531 40.3129959106446,-4.80281496047968 40.3149642944336,-4.80488681793213 40.3220291137695,-4.80400705337519 40.3274230957032,-4.7998251914978 40.3299369812012,-4.78903818130487 40.332447052002,-4.78618717193604 40.3367958068848,-4.78073310852045 40.3406829833986,-4.77132892608643 40.3443794250489)) | 0.0006 | POINT(-4.768674891335591 40.29968490600591) |
| 56775 | POLYGON((6.4441900253297 45.8313827514648,6.45321798324585 45.8196754455566,6.45035696029663 45.8097953796387,6.46963739395142 45.7995223999023,6.4873943328858 45.7942085266114,6.4873943328858 45.7942085266114,6.48535060882574 45.7834739685059,6.48535060882574 45.7834739685059,6.48643064498901 45.7767066955568,6.48154544830328 45.7670516967775,6.46597290039074 45.7538909912111,6.46879482269298 45.7475700378418,6.48367214202892 45.738899230957,6.48367214202892 45.738899230957,6.48462963104248 45.7379570007325,6.48462963104248 45.7379570007325,6.45925903320318 45.7365303039551,6.43754625320435 45.7276611328125,6.43754625320435 45.7276611328125,6.4252109527589 45.7335891723633,6.41900396347052 45.742691040039,6.39440965652466 45.7415237426759,6.38029527664185 45.745002746582,6.37044191360485 45.7529335021973,6.37044191360485 45.7529335021973,6.37463521957397 45.7627754211427,6.36330938339239 45.7679519653321,6.39326333999634 45.7849006652833,6.39326333999634 45.7849006652833,6.42011690139776 45.8022613525391,6.42011690139776 45.8022613525391,6.42455911636358 45.8038558959962,6.43215608596807 45.8203392028809,6.4441900253297 45.8313827514648)) | 0.0006 | POINT(6.439933791305128 45.769831686308926) |
| 58341 | POLYGON((8.08607006073004 49.8018264770508,8.0839672088623 49.8016090393068,8.08465290069591 49.7998695373536,8.08066463470465 49.7998199462891,8.08066463470465 49.7998199462891,8.06868553161615 49.7990951538086,8.06878566741943 49.7976951599122,8.06878566741943 49.7976951599122,8.06371784210199 49.7991523742676,8.06134986877436 49.7965278625488,8.05038166046143 49.8010330200196,8.05076503753673 49.8017005920411,8.03969097137451 49.804988861084,8.03812599182129 49.8078269958497,8.03086662292486 49.8085861206054,8.02671813964849 49.8145370483398,8.02671813964849 49.8145370483398,8.03902912139898 49.8185844421388,8.04747200012207 49.8167419433595,8.04722595214844 49.8185462951661,8.05181980133057 49.8201217651368,8.05074405670172 49.8223686218263,8.05585670471191 49.8241348266602,8.05432987213135 49.8262252807618,8.06338405609125 49.8298416137696,8.06733417510981 49.8277091979982,8.07270526885986 49.8290748596193,8.07270526885986 49.8290748596193,8.07495498657227 49.8272438049316,8.07495498657227 49.8272438049316,8.08369255065924 49.817409515381,8.08609390258795 49.8177947998047,8.09162616729736 49.8162460327148,8.09717273712164 49.8121871948243,8.09658241271984 49.8114814758302,8.09935092926025 49.81010055542,8.09935092926025 49.81010055542,8.08612823486328 49.8086128234864,8.08728122711182 49.8050842285157,8.08514308929443 49.8047294616699,8.08607006073004 49.8018264770508)) | 0.0006 | POINT(8.067388725280779 49.811924457550106) |
| 65319 | POLYGON((9.09507274627691 49.8742790222169,9.09199810028082 49.8746643066407,9.0911340713501 49.8779754638673,9.08939647674572 49.8792762756348,9.07562351226818 49.8802452087402,9.07450199127192 49.88187789917,9.07293605804438 49.8816146850587,9.06674289703369 49.8778038024903,9.06401634216309 49.8730812072754,9.05534648895264 49.8697319030762,9.05639076232922 49.8669815063477,9.05473518371582 49.8655929565431,9.05008029937756 49.8663139343262,9.05008029937756 49.8663139343262,9.04606533050537 49.8664855957032,9.04345798492432 49.8679122924805,9.04208946228033 49.8664093017578,9.0383119583131 49.8656463623047,9.03658199310308 49.8672790527345,9.03333568573009 49.8664665222167,9.03404331207287 49.8620986938477,9.03404331207287 49.8620986938477,9.03378677368164 49.8604431152345,9.03825283050537 49.8575019836425,9.04370498657227 49.8555412292482,9.04244804382324 49.8528747558594,9.04311275482183 49.8503341674806,9.0416345596314 49.8495445251465,9.04077053070068 49.8474769592286,9.03608036041265 49.8465042114259,9.03608036041265 49.8465042114259,9.03765201568615 49.8425636291504,9.04144287109386 49.8400840759278,9.04322814941406 49.8440589904786,9.04543972015392 49.842269897461,9.04919147491466 49.8424148559571,9.05313777923584 49.8458023071289,9.05951595306402 49.8470268249512,9.06066036224371 49.8450622558594,9.05479717254644 49.8429527282716,9.05346298217773 49.8412666320802,9.05419063568127 49.8405914306642,9.05283927917492 49.8400039672853,9.05387020111078 49.8390998840333,9.0584077835083 49.8413887023926,9.0597972869873 49.8407211303712,9.05836963653576 49.839729309082,9.05923843383795 49.8387413024903,9.05622768402105 49.8346176147462,9.05804729461676 49.8325920104981,9.06395721435558 49.8317604064941,9.07021427154547 49.833251953125,9.07128429412853 49.8362922668458,9.08473110198986 49.8475074768067,9.08473110198986 49.8475074768067,9.08853340148931 49.8478698730468,9.08979511260992 49.8447341918946,9.09001350402832 49.8458099365234,9.10203456878668 49.8487014770508,9.11398506164562 49.8540840148926,9.1160249710083 49.8533363342285,9.1176290512085 49.8579902648926,9.1176290512085 49.8579902648926,9.11920166015631 49.8603935241699,9.11460304260254 49.8610572814942,9.11470890045177 49.8626670837402,9.11325454711925 49.8648262023926,9.10760688781744 49.8661079406738,9.10535717010504 49.8697090148925,9.10674095153809 49.8713989257812,9.10391330718994 49.8728675842286,9.10524177551264 49.8731727600098,9.10450744628912 49.8749427795411,9.10450744628912 49.8749427795411,9.09997940063477 49.8764381408691,9.09871101379406 49.8745841979981,9.09507274627691 49.8742790222169)) | 0.0006 | POINT(9.069345637371718 49.85681323001263) |
| 72900 | POLYGON((11.1660594940186 47.1463890075685,11.162470817566 47.1023101806641,11.162470817566 47.1023101806641,11.1864681243896 47.109001159668,11.225601196289 47.1334381103516,11.225601196289 47.1334381103516,11.2386322021484 47.1663475036622,11.2418031692505 47.1781044006348,11.2418718338014 47.1857643127442,11.2404136657715 47.1931152343751,11.2268962860107 47.2133140563966,11.2277374267578 47.2187728881837,11.2328338623046 47.2233428955079,11.2328338623046 47.2233428955079,11.2195110321045 47.2269630432129,11.211350440979 47.227783203125,11.1505422592164 47.221778869629,11.1505422592164 47.221778869629,11.1760454177857 47.203727722168,11.1809310913087 47.1984977722168,11.1845264434815 47.1912765502931,11.1841478347778 47.1862983703613,11.1806726455688 47.1823654174805,11.175129890442 47.1798133850098,11.1611557006836 47.1763954162598,11.1537275314332 47.170783996582,11.1488914489746 47.1640739440919,11.1491394042969 47.1605300903321,11.1525678634645 47.1563568115236,11.1660594940186 47.1463890075685)) | 0.0006 | POINT(11.192778455800045 47.17922118614466) |
| 68093 | POLYGON((6.69329595565802 49.6929092407227,6.69462585449224 49.7006034851075,6.69462585449224 49.7006034851075,6.70574426651001 49.6982460021972,6.71258687973022 49.6955032348633,6.72651195526129 49.6985359191895,6.72651195526129 49.6985359191895,6.72770833969122 49.6949996948243,6.72455072402965 49.6931343078613,6.72510910034174 49.6918754577637,6.72925233840942 49.689525604248,6.72914695739757 49.6852455139161,6.73007917404175 49.6829338073732,6.72886610031139 49.680892944336,6.72909212112427 49.6778640747071,6.72653341293335 49.6759872436525,6.71872711181635 49.6760520935059,6.71872711181635 49.6760520935059,6.71473932266235 49.6771430969239,6.70649480819714 49.6757316589355,6.70775842666637 49.6792144775392,6.70950603485107 49.6802291870117,6.70498657226557 49.6830863952637,6.70286655426037 49.6815834045411,6.70154571533214 49.6825447082521,6.69949054718023 49.6814079284669,6.6993455886842 49.6852989196777,6.6993455886842 49.6852989196777,6.69329595565802 49.6929092407227)) | 0.0006 | POINT(6.713849084717928 49.6864656720843) |
