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 |
---|---|---|---|
20679 | POLYGON((7.35033512115479 48.6615676879883,7.35011339187633 48.66756439209,7.35011339187633 48.66756439209,7.34256219863903 48.6655616760255,7.34256219863903 48.6655616760255,7.3131475448609 48.6611251831054,7.3131475448609 48.6611251831054,7.31729125976562 48.6447868347169,7.32737398147577 48.6434211730958,7.33955574035656 48.6490135192871,7.33955574035656 48.6490135192871,7.34834909439098 48.6515960693359,7.35033512115479 48.6615676879883)) | 0.0006 | POINT(7.336175600687732 48.657325108846074) |
1401264 | POLYGON((-4.61106491088867 41.1519088745117,-4.62740182876581 41.148048400879,-4.64385890960693 41.1408615112305,-4.65219402313227 41.1391830444337,-4.65558290481562 41.1352195739746,-4.65598201751709 41.1278724670411,-4.65497207641602 41.1265182495117,-4.65927314758301 41.1246719360352,-4.66544723510742 41.1272010803223,-4.67962598800659 41.1268005371094,-4.70640611648554 41.1355209350586,-4.71156978607178 41.1352844238282,-4.7166228294372 41.1326408386231,-4.71985006332397 41.1348915100098,-4.72200393676758 41.1493148803712,-4.7212381362915 41.1569633483887,-4.7088508605957 41.1669120788574,-4.70224380493164 41.174503326416,-4.68434095382685 41.1806755065919,-4.68290996551508 41.1844596862793,-4.68046522140503 41.1857337951661,-4.66581678390503 41.1803245544434,-4.64359712600708 41.1680946350098,-4.63499116897577 41.1681098937989,-4.62765693664545 41.1707916259766,-4.62241983413691 41.160011291504,-4.61106491088867 41.1519088745117)) | 0.0006 | POINT(-4.671399483313905 41.15125069251432) |
35317 | POLYGON((9.20945358276367 42.5945777893066,9.20342063903809 42.6037139892579,9.17343139648449 42.61962890625,9.16973209381104 42.6294212341308,9.13352489471436 42.6458892822267,9.11908054351812 42.659767150879,9.1069908142091 42.6556358337403,9.1069908142091 42.6556358337403,9.09634590148926 42.6459197998046,9.09634590148926 42.6459197998046,9.10129356384289 42.6361503601074,9.1348352432251 42.6075820922851,9.1348352432251 42.6075820922851,9.13951301574713 42.5976448059083,9.16157245635981 42.59135055542,9.20945358276367 42.5945777893066)) | 0.0006 | POINT(9.139157740275099 42.62642796834312) |
58734 | POLYGON((7.11639451980597 51.0628318786622,7.10999917984009 51.0640869140626,7.10546302795416 51.0666961669922,7.10044431686407 51.0678825378419,7.10119581222546 51.0656242370605,7.09502983093262 51.065113067627,7.09107780456549 51.0673370361329,7.08880138397228 51.0660285949707,7.08263158798229 51.0671157836914,7.07990789413458 51.0656700134277,7.07255649566645 51.0691986083984,7.06870269775402 51.0679588317871,7.06474161148083 51.0729866027833,7.06233024597179 51.0735015869142,7.05799674987787 51.0771751403809,7.0719842910766 51.0894775390626,7.07312059402472 51.0911293029786,7.07273769378662 51.0949478149414,7.07431936264044 51.0969581604004,7.07431936264044 51.0969581604004,7.07873296737671 51.098789215088,7.0791158676148 51.0998001098634,7.0821642875672 51.0993957519532,7.08272266387951 51.1015167236329,7.08562803268444 51.1013069152832,7.08798694610601 51.099967956543,7.09260082244884 51.101806640625,7.09541273117071 51.1018905639649,7.10100173950207 51.1048698425294,7.1056609153747 51.1033782958985,7.11017417907721 51.1044540405273,7.11535215377813 51.1042709350586,7.11841773986816 51.1067657470703,7.1283597946167 51.1065826416016,7.12996530532848 51.1077194213867,7.13955831527721 51.1072196960449,7.14170455932617 51.1101760864258,7.14474010467529 51.1089630126954,7.15463209152216 51.1169929504395,7.15895986557013 51.1186943054199,7.15895986557013 51.1186943054199,7.15937042236328 51.1176605224609,7.16185569763189 51.1172180175781,7.16474723815929 51.1149291992187,7.16459655761724 51.1132354736328,7.16608381271357 51.1115074157715,7.16922426223766 51.1107940673828,7.16706037521362 51.1089477539063,7.16362667083752 51.1089477539063,7.16588306427013 51.1058311462403,7.1588215827943 51.1035690307618,7.15824127197266 51.1003189086915,7.1615977287293 51.0976142883302,7.16073608398443 51.0966682434083,7.16389274597168 51.0915718078613,7.16671848297125 51.0908622741699,7.16667699813848 51.0898513793946,7.16351985931396 51.0846443176271,7.1546716690064 51.0857887268068,7.15313625335705 51.0852661132813,7.1528749465943 51.0833396911622,7.14874124526978 51.0841484069824,7.14993000030518 51.0817527770997,7.14746475219727 51.0804481506349,7.1492223739624 51.0796775817872,7.14791965484619 51.0794944763185,7.14770030975353 51.0768051147461,7.14934921264648 51.0745658874513,7.14530324935924 51.0739707946778,7.14567804336554 51.0725517272949,7.13975715637207 51.0686416625977,7.13869285583496 51.0661697387696,7.13869285583496 51.0661697387696,7.13510036468506 51.0648612976074,7.12826871871948 51.0668067932129,7.12583351135254 51.0657005310059,7.12273740768433 51.066017150879,7.12264490127575 51.0651321411134,7.11639451980597 51.0628318786622)) | 0.0006 | POINT(7.124127919857364 51.08927452869906) |
63393 | POLYGON((12.8744249343872 53.974048614502,12.8922939300538 53.9714813232422,12.898907661438 53.9685363769531,12.9115591049195 53.9655342102052,12.9150428771973 53.9634971618652,12.9164485931396 53.9605598449708,12.9228944778442 53.9586448669435,12.9228944778442 53.9586448669435,12.9191093444825 53.9519805908203,12.9168767929077 53.9518432617188,12.9148979187012 53.9496879577638,12.9094228744507 53.9468460083008,12.9072551727294 53.9440307617188,12.9016799926758 53.94100189209,12.8991909027101 53.9331932067871,12.9031248092653 53.9288673400879,12.9013214111329 53.9215965270997,12.920099258423 53.9211235046387,12.9250936508179 53.919776916504,12.9272089004517 53.8977088928223,12.9331350326539 53.8972778320313,12.9331951141357 53.8959121704102,12.9293251037597 53.8931007385254,12.9175148010253 53.8927917480468,12.9158506393433 53.8915824890137,12.9051885604858 53.8886451721193,12.899115562439 53.8847427368165,12.8964052200317 53.8758735656739,12.8973407745362 53.8726997375488,12.8973407745362 53.8726997375488,12.8949947357179 53.8712615966797,12.8916234970094 53.8713531494141,12.8889150619508 53.869384765625,12.8904476165773 53.8662872314453,12.8879508972167 53.8662300109863,12.8860082626343 53.8654670715332,12.8854818344117 53.8642005920411,12.8832120895386 53.8638381958008,12.8818607330322 53.8652572631837,12.8806581497193 53.8649673461914,12.8808698654174 53.8616104125977,12.8895349502565 53.8565979003906,12.8902502059938 53.8544120788574,12.8870849609374 53.8524055480958,12.8879776000977 53.8517837524413,12.8874082565308 53.8508148193359,12.8887252807618 53.847412109375,12.8887252807618 53.847412109375,12.8871059417725 53.8453140258789,12.88436126709 53.8448791503907,12.8762159347535 53.8404617309571,12.8676395416261 53.8339385986329,12.8676395416261 53.8339385986329,12.8563041687012 53.8373146057129,12.8359432220459 53.8410186767579,12.8317098617555 53.8439712524414,12.8152189254762 53.8479499816895,12.8146390914918 53.848487854004,12.8162021636963 53.8504371643067,12.8107709884644 53.8537750244141,12.806778907776 53.8501739501954,12.7958583831787 53.8506164550782,12.793719291687 53.8555908203124,12.7873678207397 53.8573799133302,12.7847557067871 53.8571395874023,12.7839727401734 53.8593025207519,12.7858238220215 53.861255645752,12.7761402130127 53.8665084838867,12.7751951217651 53.8658790588379,12.7731513977051 53.8704109191895,12.7731513977051 53.8704109191895,12.7831125259401 53.8741836547852,12.7882623672486 53.8720588684083,12.7941684722901 53.8718757629396,12.7951688766481 53.8732528686524,12.8005590438843 53.8719367980957,12.8014879226685 53.8722457885742,12.80335521698 53.8767776489258,12.8027477264404 53.8779296875,12.7902927398682 53.8774032592773,12.7890405654908 53.8787460327149,12.7866535186768 53.8793296813964,12.785174369812 53.8810043334961,12.7862882614136 53.8830833435059,12.7832040786743 53.884033203125,12.7817907333374 53.8831939697267,12.7770166397096 53.8867073059083,12.7835903167725 53.8910789489747,12.7838258743286 53.8932495117188,12.7812404632568 53.8947257995606,12.7712402343751 53.8961143493652,12.7652378082277 53.8983001708986,12.7644491195679 53.9003906250001,12.7685127258302 53.9030303955079,12.7846393585206 53.9234580993652,12.7916841506958 53.9216384887695,12.8027133941651 53.9214706420899,12.7958889007568 53.9274406433105,12.7958889007568 53.9274406433105,12.8044939041138 53.9291954040528,12.8113775253296 53.9257698059083,12.8094911575318 53.9300918579102,12.8121910095216 53.9307403564453,12.8136062622071 53.9299697875976,12.8115758895874 53.9345169067384,12.8090391159058 53.9368171691895,12.8076057434083 53.9424552917482,12.8057374954225 53.9445571899415,12.7955074310303 53.9527549743653,12.787262916565 53.9532928466797,12.7889709472657 53.9536094665528,12.7888031005861 53.9550437927247,12.7915029525756 53.9585609436035,12.78835105896 53.9589042663574,12.78835105896 53.9589042663574,12.7899198532104 53.9611968994141,12.7967185974122 53.9666976928712,12.7961473464966 53.9717292785645,12.7983894348145 53.9737739562988,12.8003482818603 53.9730529785157,12.8062858581544 53.9812202453613,12.8082571029664 53.9810218811035,12.8099355697632 53.9821891784668,12.8159809112548 53.9880523681641,12.8099832534791 53.9913787841798,12.808277130127 53.994556427002,12.8125257492067 53.9967231750489,12.8108777999878 53.9975624084474,12.8085126876832 53.9964027404786,12.8021755218506 53.9982719421387,12.8030405044556 54.0004768371582,12.8086471557618 54.0049362182617,12.8086471557618 54.0049362182617,12.8105783462526 54.0031127929688,12.8280000686646 53.9968948364259,12.8308401107788 53.9941177368164,12.8331279754639 53.9941291809083,12.8341379165649 53.9924850463868,12.8408393859863 53.9889450073242,12.8477363586426 53.9814262390137,12.8556613922119 53.9763183593749,12.86305809021 53.9741363525391,12.8744249343872 53.974048614502)) | 0.0006 | POINT(12.837924681918755 53.91249162378447) |
46523 | POLYGON((3.38047218322765 50.2135848999024,3.37392139434809 50.217124938965,3.3604564666748 50.2148780822754,3.36247706413269 50.2176094055175,3.36247706413269 50.2176094055175,3.35766887664789 50.2184486389161,3.34561181068432 50.2132949829103,3.32656621932983 50.2154045104981,3.32656621932983 50.2154045104981,3.33792686462402 50.1919250488282,3.33792686462402 50.1919250488282,3.3433251380921 50.1855888366699,3.3433251380921 50.1855888366699,3.34641885757446 50.1860122680665,3.34641885757446 50.1860122680665,3.36554169654846 50.19624710083,3.38047218322765 50.2135848999024)) | 0.0006 | POINT(3.3510687947273388 50.20416617393498) |
58144 | POLYGON((7.03638029098516 49.7833595275879,7.0268664360047 49.7873535156251,7.02550888061535 49.7893676757812,7.02592611312878 49.7924156188966,7.02507400512701 49.7936058044433,7.02056121826178 49.79500579834,7.01446676254284 49.7940635681153,7.01183652877819 49.7923622131348,7.00752019882214 49.7925987243653,7.00752019882214 49.7925987243653,7.00585603713989 49.7921409606934,7.00422191619879 49.789577484131,7.00422191619879 49.789577484131,7.00748252868652 49.7868576049805,7.00710916519171 49.7800025939942,7.01106882095343 49.7776031494141,7.01150751113892 49.7752189636231,7.01150751113892 49.7752189636231,7.01603984832769 49.7712516784669,7.02170848846436 49.7713279724121,7.02417373657238 49.7727966308594,7.02685880661016 49.7764015197755,7.03210544586193 49.7771224975586,7.03638029098516 49.7833595275879)) | 0.0006 | POINT(7.016761841981372 49.7846882032312) |
17947 | POLYGON((7.83070278167725 45.4418907165528,7.83170509338373 45.4397506713868,7.83661508560186 45.4372787475587,7.84133577346807 45.4414176940917,7.85056304931641 45.4458427429199,7.85056304931641 45.4458427429199,7.85963582992548 45.4496726989746,7.85963582992548 45.4496726989746,7.86857318878185 45.4477424621582,7.86853313446039 45.4404296875,7.87070798873913 45.4351272583008,7.87681198120117 45.4297332763672,7.88120317459106 45.427646636963,7.88355016708385 45.4275894165038,7.88476276397716 45.4254493713379,7.88415384292614 45.4223709106446,7.88415384292614 45.4223709106446,7.85723590850836 45.4164695739746,7.85085678100586 45.4137496948243,7.85085678100586 45.4137496948243,7.84682798385626 45.4221725463868,7.83912181854259 45.4217185974122,7.82571792602539 45.4167861938477,7.82286500930798 45.4167022705079,7.82286500930798 45.4167022705079,7.8218989372254 45.4195480346681,7.82279682159435 45.4295272827148,7.83070278167725 45.4418907165528)) | 0.0006 | POINT(7.852749983469689 45.43025758531362) |
1400136 | POLYGON((-4.52361917495722 42.3736534118652,-4.52765083312988 42.3776245117188,-4.52580881118774 42.3788452148439,-4.52683877944946 42.3817062377931,-4.53956794738758 42.4030227661133,-4.54001998901367 42.4066009521484,-4.52835321426392 42.4205741882324,-4.52894115447998 42.4237556457521,-4.5309009552002 42.42435836792,-4.52887201309198 42.4254646301271,-4.5285758972168 42.4302787780763,-4.51331520080561 42.4290657043458,-4.50627183914185 42.4309310913087,-4.4880580902099 42.4297142028808,-4.48485803604126 42.4274559020996,-4.4810647964477 42.4274787902832,-4.47828722000116 42.4252014160157,-4.47738409042358 42.404842376709,-4.49454402923578 42.3987541198731,-4.50106716156006 42.3940887451173,-4.50451278686518 42.3878479003906,-4.50836896896362 42.3875541687013,-4.51040506362915 42.3777008056642,-4.51578092575073 42.3745040893554,-4.52361917495722 42.3736534118652)) | 0.0006 | POINT(-4.51221112410225 42.4058760007223) |
33714 | POLYGON((4.77226686477673 48.3246917724609,4.74269628524792 48.3563652038575,4.74269628524792 48.3563652038575,4.72191095352173 48.356632232666,4.71024847030645 48.3629760742189,4.69980716705334 48.362892150879,4.69980716705334 48.362892150879,4.71343612670893 48.3443374633789,4.71879863739014 48.316749572754,4.71879863739014 48.316749572754,4.72398614883417 48.3107604980469,4.73894453048717 48.3090324401856,4.73894453048717 48.3090324401856,4.7449107170105 48.3217582702637,4.76477384567272 48.3201599121094,4.77226686477673 48.3246917724609)) | 0.0006 | POINT(4.730135091145891 48.33542633056645) |