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 |
---|---|---|---|
69913 | POLYGON((9.24571418762213 54.7592239379883,9.25013351440435 54.759880065918,9.26199436187738 54.7667083740236,9.27056694030762 54.7810440063476,9.27036952972412 54.7841110229492,9.27382755279535 54.7869529724122,9.26984214782721 54.7883872985839,9.26524353027344 54.7943267822266,9.25983047485352 54.7977561950684,9.24682426452648 54.8021545410157,9.24682426452648 54.8021545410157,9.24555969238293 54.8052406311036,9.25008106231684 54.8097152709961,9.25008106231684 54.8097152709961,9.2651824951173 54.8107948303223,9.26991081237804 54.8121643066406,9.2733297348023 54.8117561340333,9.28404998779308 54.8096122741699,9.28609085083019 54.8044738769532,9.29477691650385 54.801872253418,9.29539394378662 54.8032913208008,9.29204177856445 54.8061447143555,9.29348564147955 54.8089828491212,9.329345703125 54.8055686950684,9.33033275604242 54.8041343688965,9.34360980987549 54.8002471923829,9.34539604187017 54.8021774291993,9.34539604187017 54.8021774291993,9.34657669067377 54.8020896911622,9.35011386871332 54.7936782836914,9.35675048828136 54.7865753173828,9.35877609252924 54.7810935974122,9.35877609252924 54.7810935974122,9.35758781433111 54.7808494567872,9.35722064971935 54.779483795166,9.36594772338873 54.7715950012206,9.36790466308594 54.768337249756,9.36748123168951 54.7666778564454,9.37098407745373 54.7611160278321,9.37327861785889 54.7600135803223,9.37192821502686 54.7588653564454,9.376877784729 54.7565460205079,9.37901496887207 54.7532005310059,9.43792152404785 54.7536354064943,9.45237541198736 54.7520484924317,9.45237541198736 54.7520484924317,9.45161628723139 54.7513771057128,9.45161628723139 54.7513771057128,9.44971847534191 54.749683380127,9.44642543792725 54.7316703796387,9.44504070281988 54.7306289672853,9.44342422485363 54.7313690185547,9.43413257598871 54.7314338684083,9.43269443511974 54.7251052856446,9.40700531005859 54.7291297912598,9.40636730194097 54.7346343994142,9.38870525360102 54.7291412353517,9.37422561645502 54.7230911254883,9.37794303894043 54.716194152832,9.37947273254406 54.711067199707,9.37499809265148 54.7061958312988,9.36950302124023 54.7024040222168,9.36950302124023 54.7024040222168,9.36814975738531 54.7014350891113,9.36814975738531 54.7014350891113,9.3679780960083 54.7061424255372,9.35566234588634 54.7122344970703,9.33805656433105 54.7126045227052,9.33583831787109 54.7104034423829,9.31370162963873 54.7132072448732,9.30294895172125 54.7135276794434,9.30294895172125 54.7135276794434,9.30490016937256 54.7207717895507,9.29669094085693 54.7226676940919,9.29728507995605 54.7257804870607,9.28148937225353 54.7250366210938,9.28159427642834 54.7294883728027,9.28387546539312 54.7294387817383,9.28400897979748 54.7361793518066,9.27709484100353 54.7365722656251,9.27757263183605 54.7383003234864,9.27757263183605 54.7383003234864,9.2776308059693 54.7492218017578,9.27268981933594 54.759147644043,9.2647275924682 54.7554244995118,9.25967502594006 54.7541389465333,9.2486400604248 54.7552680969239,9.24712467193598 54.7561492919922,9.24571418762213 54.7592239379883)) | 0.0006 | POINT(9.331199147484552 54.758670763535946) |
51138 | POLYGON((2.23080706596375 50.2106285095215,2.22692346572876 50.2028656005859,2.23356080055237 50.1988029479981,2.23356080055237 50.1988029479981,2.23035478591925 50.1961860656739,2.21051001548767 50.1939888000488,2.19907450675964 50.1829032897949,2.19907450675964 50.1829032897949,2.19044065475475 50.1840591430665,2.18877506256115 50.1867599487306,2.18877506256115 50.1867599487306,2.19561123847967 50.1984329223634,2.18773651123053 50.2096786499025,2.18773651123053 50.2096786499025,2.19948959350597 50.2124137878419,2.19990777969366 50.2151756286621,2.19990777969366 50.2151756286621,2.22442102432251 50.2173614501953,2.22442102432251 50.2173614501953,2.22274613380432 50.208854675293,2.23080706596375 50.2106285095215)) | 0.0006 | POINT(2.208691716194193 50.201439666748094) |
53987 | POLYGON((5.44529294967657 43.6800956726075,5.45386314392101 43.7096023559571,5.46518754959106 43.7146377563477,5.46518754959106 43.7146377563477,5.45333003997814 43.7293128967286,5.44403982162476 43.7283515930176,5.43692302703857 43.732650756836,5.4278936386109 43.7328605651855,5.4278936386109 43.7328605651855,5.4217419624328 43.7174682617187,5.39605760574352 43.7102584838867,5.38812589645397 43.7021865844728,5.38812589645397 43.7021865844728,5.41271400451666 43.69291305542,5.41271400451666 43.69291305542,5.44529294967657 43.6800956726075)) | 0.0006 | POINT(5.429272715250702 43.71286239624029) |
38843 | POLYGON((2.55823040008551 42.9796257019043,2.53469109535217 42.9869079589845,2.53469109535217 42.9869079589845,2.51457118988037 42.9728622436523,2.51457118988037 42.9728622436523,2.50359225273127 42.9505996704102,2.50359225273127 42.9505996704102,2.52726435661316 42.9392204284668,2.52726435661316 42.9392204284668,2.5494401454925 42.9569892883301,2.55858802795416 42.9728622436523,2.55823040008551 42.9796257019043)) | 0.0006 | POINT(2.5296814875169193 42.96442343971948) |
13575 | POLYGON((14.4878625869752 41.209571838379,14.5003538131715 41.2153358459473,14.5309286117554 41.2253303527833,14.5326404571533 41.2289390563965,14.5326404571533 41.2289390563965,14.5304756164551 41.2284774780274,14.5248231887819 41.2314224243163,14.5229930877686 41.233699798584,14.5295963287354 41.2372665405274,14.5295963287354 41.2372665405274,14.5274219512941 41.2460441589355,14.5274219512941 41.2460441589355,14.4972658157349 41.2606773376466,14.4862842559814 41.2573585510254,14.4736318588257 41.2499313354492,14.4720706939698 41.2480354309083,14.4720706939698 41.2480354309083,14.4742441177368 41.2300987243653,14.4706392288209 41.2243385314941,14.4685077667236 41.2237701416017,14.4685077667236 41.2237701416017,14.4718980789185 41.2221908569337,14.4865722656251 41.2189788818361,14.4887123107911 41.2124557495118,14.4878625869752 41.209571838379)) | 0.0006 | POINT(14.500298301378933 41.23283243179326) |
55615 | POLYGON((5.77422618865978 44.9101181030275,5.73818874359131 44.9136047363281,5.73818874359131 44.9136047363281,5.74667739868164 44.9398918151856,5.74667739868164 44.9398918151856,5.76807975769043 44.944839477539,5.78109455108648 44.9363861083985,5.78109455108648 44.9363861083985,5.78215551376348 44.9135475158692,5.77422618865978 44.9101181030275)) | 0.0006 | POINT(5.761820316314728 44.927585601806676) |
27765 | POLYGON((-0.481831014156342 48.7148361206055,-0.471625536680108 48.695167541504,-0.479852199554387 48.6714630126953,-0.493822634220123 48.6614379882813,-0.493822634220123 48.6614379882813,-0.486707717180252 48.6595039367675,-0.486707717180252 48.6595039367675,-0.441727221012059 48.6480102539062,-0.441727221012059 48.6480102539062,-0.440190047025567 48.6547966003418,-0.429462283849716 48.6625785827637,-0.421918243169671 48.6754379272461,-0.39226329326624 48.6898002624513,-0.39226329326624 48.6898002624513,-0.389433175325337 48.6927070617676,-0.393302977085114 48.7095756530762,-0.407027125358582 48.7145576477051,-0.422495216131153 48.7153854370118,-0.422495216131153 48.7153854370118,-0.437575340270996 48.7165107727052,-0.437575340270996 48.7165107727052,-0.442548990249634 48.7166252136231,-0.446891963481846 48.7259445190431,-0.462106853723526 48.734172821045,-0.462106853723526 48.734172821045,-0.475425958633423 48.7316436767579,-0.475425958633423 48.7316436767579,-0.473502576351166 48.7223739624023,-0.481831014156342 48.7148361206055)) | 0.0006 | POINT(-0.44649409289867903 48.69532121930807) |
1407430 | POLYGON((-6.46561813354492 39.6273918151857,-6.4854969978332 39.6242599487306,-6.4891619682312 39.6218757629396,-6.49834203720093 39.6237983703614,-6.52033090591425 39.6141433715821,-6.52292490005487 39.6149673461914,-6.53177022933954 39.6118965148926,-6.53924322128296 39.6157150268554,-6.55061197280884 39.614860534668,-6.56055498123163 39.6177635192871,-6.56441211700439 39.6162109375001,-6.57162523269653 39.6171989440918,-6.58453416824341 39.6303825378419,-6.6019082069397 39.6428604125977,-6.60038089752197 39.6542739868164,-6.60687685012812 39.6606559753418,-6.60453796386719 39.668571472168,-6.60797309875483 39.6727333068848,-6.60596513748169 39.6744842529297,-6.60581016540527 39.6822586059571,-6.60379981994629 39.6848449707032,-6.59990501403809 39.6859397888185,-6.59619903564447 39.693328857422,-6.59901618957514 39.6964149475098,-6.59728813171381 39.6997261047363,-6.59799480438227 39.7043457031251,-6.60256195068359 39.7062835693361,-6.60227298736572 39.7135162353517,-6.60648202896118 39.7152938842773,-6.60423707962025 39.7212257385255,-6.59535789489746 39.7278785705567,-6.59314918518066 39.7333984374999,-6.58675384521479 39.7309036254884,-6.58279991149897 39.7266120910646,-6.56412696838379 39.7343215942384,-6.56208896636957 39.7355346679688,-6.56165885925293 39.7389564514161,-6.555823802948 39.7393760681153,-6.55652093887329 39.742733001709,-6.54579591751099 39.7408638000489,-6.54471302032465 39.7429313659669,-6.54784202575684 39.7459716796876,-6.54746580123896 39.7497711181642,-6.54388093948364 39.7501373291017,-6.54521179199219 39.7549438476562,-6.52257585525507 39.7611618041993,-6.50605392456055 39.7623748779298,-6.48978090286249 39.7579193115235,-6.48333597183222 39.7583198547363,-6.4796347618103 39.7601356506349,-6.46496391296387 39.7614936828614,-6.45203876495356 39.7648963928223,-6.44355583190912 39.7705268859863,-6.44128084182739 39.7679901123047,-6.44232797622675 39.7632026672364,-6.43562889099115 39.7540969848633,-6.43322706222534 39.7315788269042,-6.43816804885859 39.7270011901855,-6.4263391494751 39.716407775879,-6.41558218002319 39.7184715270996,-6.40964889526362 39.7171058654785,-6.40638113021851 39.7132911682129,-6.40800380706781 39.6943855285644,-6.4095630645752 39.6931228637696,-6.41764879226685 39.6788597106934,-6.42693901062012 39.6778831481934,-6.42596578598022 39.6801376342775,-6.42797422409046 39.6815986633302,-6.42572021484375 39.6822090148926,-6.42580223083496 39.6841049194337,-6.42786407470697 39.6850624084473,-6.43447780609131 39.6815872192383,-6.43463087081903 39.6788177490236,-6.44630718231201 39.6832008361816,-6.44779109954828 39.6815910339357,-6.45121192932129 39.6856918334962,-6.45479393005371 39.6841163635254,-6.45810604095459 39.6867332458497,-6.46155023574829 39.6865844726563,-6.45434284210205 39.6715850830079,-6.44466400146479 39.6630096435546,-6.43688011169428 39.6487464904786,-6.44048118591309 39.6482734680176,-6.44815778732294 39.6395683288575,-6.46561813354492 39.6273918151857)) | 0.0006 | POINT(-6.510243171737283 39.69552857535229) |
1404720 | POLYGON((-3.79908204078669 40.8498344421388,-3.79830002784723 40.851978302002,-3.81806206703186 40.8623695373536,-3.81467604637146 40.8656730651857,-3.81446599960321 40.870979309082,-3.81073498725891 40.8774299621583,-3.80851292610168 40.8858833312989,-3.8095109462738 40.8880310058594,-3.80595803260803 40.8904724121094,-3.79839611053455 40.9014320373536,-3.78868699073786 40.9066352844239,-3.78479409217834 40.9117584228515,-3.78675198554987 40.9135475158693,-3.77278995513905 40.9249534606935,-3.76186990737915 40.9277954101563,-3.74275994300837 40.9393386840821,-3.73681807518005 40.9412879943848,-3.73442697525024 40.9400329589844,-3.73471903800964 40.9362831115723,-3.72539305686951 40.9351196289063,-3.72390198707581 40.9268951416016,-3.72055888175959 40.9241485595703,-3.71699905395508 40.9168319702149,-3.71861004829407 40.9054260253907,-3.71591210365295 40.8963432312013,-3.69986605644226 40.8878555297853,-3.69584107398987 40.8808555603028,-3.70228195190424 40.8782043457031,-3.71238303184509 40.8772239685059,-3.7228860855102 40.8739318847657,-3.73606395721436 40.8753890991211,-3.73925709724426 40.8777198791504,-3.74092507362366 40.8741073608399,-3.75191497802734 40.8678817749023,-3.75625491142267 40.8674774169923,-3.7584929466247 40.8692092895509,-3.76132798194874 40.8691444396973,-3.76195502281189 40.8708610534668,-3.76770305633545 40.8671646118164,-3.77155399322498 40.8687705993652,-3.77690291404724 40.8645553588868,-3.77665996551514 40.8609619140626,-3.7845320701598 40.8563690185547,-3.78599500656122 40.8506469726563,-3.7905170917511 40.8467636108398,-3.79247903823853 40.8482704162598,-3.79692602157587 40.8480224609376,-3.79908204078669 40.8498344421388)) | 0.0006 | POINT(-3.7622427788186297 40.88663547597038) |
15842 | POLYGON((9.43907642364513 45.9236373901368,9.43566131591803 45.9256401062013,9.429352760315 45.927059173584,9.39245700836176 45.923683166504,9.39245700836176 45.923683166504,9.39585876464855 45.9161567687988,9.39585876464855 45.9161567687988,9.39871120452875 45.9091682434082,9.396471977234 45.9080276489259,9.39408397674561 45.9048881530763,9.39752197265631 45.9034576416017,9.39752197265631 45.9034576416017,9.39875984191906 45.9068412780762,9.40294456481934 45.9027366638184,9.40707492828375 45.8945884704591,9.42025184631353 45.8866539001465,9.42889022827154 45.8836441040038,9.43477725982677 45.8851051330566,9.44405174255382 45.8813362121583,9.44405174255382 45.8813362121583,9.45098686218262 45.9007225036621,9.45098686218262 45.9007225036621,9.45013046264643 45.903175354004,9.43940734863281 45.9116325378418,9.43737411499023 45.9154701232911,9.44019508361816 45.9216346740724,9.43907642364513 45.9236373901368)) | 0.0006 | POINT(9.41980446301978 45.906177520751996) |