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 |
---|---|---|---|
33993 | POLYGON((4.41540765762329 48.0621948242189,4.3944458961488 48.0727767944337,4.3944458961488 48.0727767944337,4.39277362823498 48.0796470642091,4.39277362823498 48.0796470642091,4.3944664001466 48.0857734680175,4.3944664001466 48.0857734680175,4.40882921218883 48.0833969116211,4.43223810195929 48.0862731933594,4.43223810195929 48.0862731933594,4.44877910614019 48.0854873657226,4.44877910614019 48.0854873657226,4.43761873245245 48.0529441833497,4.43761873245245 48.0529441833497,4.4350414276123 48.0573959350587,4.4350414276123 48.0573959350587,4.41540765762329 48.0621948242189)) | 0.0006 | POINT(4.418435215950083 48.07413673400884) |
52982 | POLYGON((0.265790313482341 46.3226013183594,0.269665122032279 46.2976112365724,0.269665122032279 46.2976112365724,0.209798783064002 46.3027992248535,0.209798783064002 46.3027992248535,0.19844605028635 46.3092079162599,0.19844605028635 46.3092079162599,0.209780856966972 46.3146209716797,0.211561188101768 46.3240814208984,0.211561188101768 46.3240814208984,0.235062971711272 46.339500427246,0.235062971711272 46.339500427246,0.256165474653301 46.3327331542969,0.26143395900732 46.3238945007325,0.265790313482341 46.3226013183594)) | 0.0006 | POINT(0.23158848817866257 46.31716074262349) |
39910 | POLYGON((3.80698990821838 44.7675819396973,3.78520131111156 44.7612838745118,3.76780009269726 44.7668609619142,3.76780009269726 44.7668609619142,3.76853942871099 44.7700996398926,3.76065182685863 44.7775192260743,3.76128339767456 44.7840118408204,3.75557184219372 44.7889251708985,3.75557184219372 44.7889251708985,3.76413536071789 44.8003807067871,3.76413536071789 44.8003807067871,3.76715779304504 44.8031692504883,3.77195191383373 44.8023147583009,3.79734897613531 44.7864875793457,3.80698990821838 44.7675819396973)) | 0.0006 | POINT(3.7710099390575667 44.78320012773792) |
55803 | POLYGON((5.37024879455578 45.2271308898926,5.37504243850708 45.2211532592774,5.37406444549572 45.2074546813965,5.37406444549572 45.2074546813965,5.38362693786627 45.2075653076172,5.39856529235851 45.1990394592285,5.40591764450073 45.2034835815429,5.41047859191906 45.2022781372071,5.42383766174328 45.1927185058594,5.42383766174328 45.1927185058594,5.42961740493774 45.1984672546387,5.42961740493774 45.1984672546387,5.44542407989508 45.1997985839845,5.44542407989508 45.1997985839845,5.4342560768128 45.222438812256,5.43693733215338 45.2327575683594,5.43693733215338 45.2327575683594,5.41820287704468 45.223804473877,5.39524555206305 45.2285690307618,5.39131450653076 45.2347068786621,5.38662528991699 45.2356643676759,5.38662528991699 45.2356643676759,5.37758016586315 45.2343330383301,5.37471246719372 45.22806930542,5.37024879455578 45.2271308898926)) | 0.0006 | POINT(5.4053418238958315 45.21526225407922) |
18016 | POLYGON((7.67712402343761 45.3564949035646,7.65806484222406 45.34672164917,7.65712785720831 45.3447494506837,7.64924001693737 45.3436851501465,7.64924001693737 45.3436851501465,7.64870786666881 45.3407135009766,7.64870786666881 45.3407135009766,7.66256618499762 45.3417091369629,7.66256618499762 45.3417091369629,7.66690921783447 45.3408050537109,7.66690921783447 45.3408050537109,7.67689609527594 45.3476524353028,7.67689609527594 45.3476524353028,7.67712402343761 45.3564949035646)) | 0.0006 | POINT(7.661611960484493 45.344392042893666) |
1398664 | POLYGON((-4.15028095245361 42.4151458740234,-4.14957189559931 42.4189910888672,-4.15433311462402 42.4313430786132,-4.15623807907104 42.4317741394044,-4.15140199661255 42.4385795593262,-4.15457677841187 42.439292907715,-4.153883934021 42.4439277648926,-4.14282321929932 42.4455642700196,-4.13550996780396 42.4445381164552,-4.12544012069696 42.447166442871,-4.11623001098633 42.4468612670899,-4.11587476730341 42.448802947998,-4.09639501571655 42.4384231567383,-4.08230113983149 42.4191856384278,-4.08728122711176 42.4118881225585,-4.10295391082764 42.4102630615235,-4.10429906845081 42.4086494445801,-4.12480020523066 42.4072952270509,-4.1324028968811 42.4077682495118,-4.13244390487671 42.4140396118164,-4.14691209793091 42.4163780212402,-4.15028095245361 42.4151458740234)) | 0.0006 | POINT(-4.129331157321 42.427898951939206) |
73275 | POLYGON((15.211033821106 45.9236145019532,15.211051940918 45.9271697998047,15.2059421539307 45.9271621704102,15.2059602737426 45.9307174682618,15.1906242370606 45.9307022094728,15.1855478286744 45.9378089904786,15.1753244400026 45.9377975463868,15.1702709197999 45.9484596252441,15.14986038208 45.9555473327637,15.1499156951904 45.9662132263184,15.1397113800048 45.9697608947753,15.1397857666016 45.9839820861817,15.1500120162965 45.9839935302734,15.1500692367554 45.9946594238281,15.1398448944092 45.9946479797364,15.1398239135743 45.9910926818849,15.1193761825563 45.9910697937013,15.114320755005 46.0017318725586,15.0990028381348 46.0052719116212,15.0990228652955 46.0088272094727,15.0939111709594 46.0088195800781,15.0888557434082 46.0194816589357,15.0837440490723 46.0194778442383,15.0837440490723 46.0194778442383,15.0735197067262 46.0194664001465,15.0734806060792 46.0123558044434,15.0632572174072 46.0123443603517,15.0632753372194 46.0158996582032,15.0479183197021 46.0123291015626,15.0478820800782 46.0052185058594,15.0274333953859 46.0051956176758,15.012077331543 46.0016250610352,15.0171318054199 45.9909629821777,15.0222444534303 45.9909667968751,15.0221872329711 45.9803009033204,15.0170745849609 45.980297088623,15.0170574188233 45.9767417907715,15.0068120956421 45.9731750488282,15.0067729949952 45.966064453125,14.9965305328369 45.9624977111818,14.991418838501 45.9624938964844,14.9760999679565 45.9660301208497,14.9761190414429 45.9695854187012,14.9556703567506 45.9695663452149,14.9557094573976 45.9766769409181,14.9301462173462 45.9766502380371,14.9300708770753 45.9624290466309,14.9096231460572 45.9624061584473,14.9096231460572 45.9624061584473,14.9095840454103 45.9552955627441,14.8993387222291 45.9517288208007,14.899320602417 45.9481735229492,14.883984565735 45.9481582641602,14.8839664459229 45.9446029663087,14.8737401962281 45.9445915222168,14.8684177398682 45.905475616455,14.8529682159424 45.8841247558594,14.8580408096313 45.8770217895508,14.8580207824708 45.873462677002,14.8631353378296 45.8734703063965,14.8630962371826 45.8663597106935,14.8733205795289 45.8663711547852,14.8733205795289 45.8663711547852,14.8886766433716 45.8699417114258,14.8886566162109 45.8663864135743,14.9039926528931 45.8664016723633,14.9039745330811 45.8628463745117,14.9090871810913 45.862850189209,14.9193286895753 45.8664169311525,14.9193496704103 45.8699722290039,14.9346857070923 45.8699913024903,14.9397230148315 45.8557739257814,14.9448347091675 45.8557777404786,14.9447584152223 45.8415565490724,14.954981803894 45.8415679931641,14.9549636840821 45.8380126953126,14.9702997207643 45.8380279541017,14.9754514694214 45.8451461791992,14.9958992004396 45.8451652526857,14.9958610534669 45.8380546569825,15.011197090149 45.8380699157715,15.0112171173096 45.841625213623,15.0163297653198 45.8416328430176,15.0163297653198 45.8416328430176,15.0164432525636 45.862964630127,15.0215578079224 45.8629684448243,15.0215940475464 45.8700828552247,15.0420427322388 45.8701019287109,15.0421018600464 45.8807678222657,15.0676622390748 45.8807945251465,15.0677194595337 45.8914642333984,15.077961921692 45.8950271606446,15.1034679412842 45.8843879699708,15.1085405349731 45.8772850036621,15.1238765716553 45.8773002624512,15.1238594055176 45.8737449645997,15.1238594055176 45.8737449645997,15.144287109375 45.8702087402344,15.1749439239503 45.8666877746583,15.1749620437623 45.8702430725098,15.1954488754273 45.8773765563965,15.1954879760743 45.8844871520997,15.2005996704102 45.8844909667969,15.2006387710572 45.8916015625001,15.2108812332154 45.8951683044435,15.2058258056642 45.9058303833008,15.2058439254761 45.9093856811523,15.2058830261231 45.9164962768555,15.211033821106 45.9236145019532)) | 0.0006 | POINT(15.035752181653665 45.9237578003495) |
55737 | POLYGON((5.83526897430431 45.4202308654786,5.83462762832636 45.4202003479005,5.83462762832636 45.4202003479005,5.81136083602911 45.4253807067872,5.81136083602911 45.4253807067872,5.79636240005505 45.4380645751954,5.78246212005621 45.441104888916,5.76338720321655 45.4392166137696,5.76069831848156 45.4363632202148,5.76069831848156 45.4363632202148,5.7576580047608 45.4349250793458,5.7576580047608 45.4349250793458,5.76748704910278 45.4274826049805,5.76720190048218 45.4140472412109,5.78285312652588 45.4059829711915,5.77608013153082 45.3968811035156,5.77607774734497 45.3865890502929,5.77607774734497 45.3865890502929,5.76758050918585 45.3679428100586,5.76758050918585 45.3679428100586,5.79173135757452 45.3792533874512,5.81133413314814 45.3813514709473,5.81133413314814 45.3813514709473,5.81582403182978 45.4013481140138,5.82753896713268 45.4161643981934,5.83526897430431 45.4202308654786)) | 0.0006 | POINT(5.7897948646545725 45.41141128540042) |
40660 | POLYGON((1.91485548019415 46.3583641052247,1.91935813426966 46.3628540039063,1.91274595260631 46.370906829834,1.91274595260631 46.370906829834,1.91001546382904 46.3701782226564,1.91001546382904 46.3701782226564,1.89151871204388 46.3616790771484,1.88303554058081 46.3541412353517,1.87448811531067 46.3523635864258,1.87448811531067 46.3523635864258,1.87923479080206 46.3530120849611,1.88086032867437 46.3434906005861,1.88558173179638 46.342800140381,1.89752185344702 46.3484535217286,1.90561366081238 46.3567543029785,1.91485548019415 46.3583641052247)) | 0.0006 | POINT(1.8968052864075167 46.357896423339916) |
68896 | POLYGON((12.7540712356567 51.1054992675782,12.7453937530519 51.1064071655273,12.74551486969 51.1079788208008,12.7436332702637 51.1075553894044,12.7419872283936 51.1063880920411,12.7417278289795 51.1047630310059,12.7394161224365 51.1048355102539,12.7377014160157 51.1012992858887,12.7382650375367 51.0959129333497,12.7382650375367 51.0959129333497,12.7344799041748 51.0965690612793,12.7254133224487 51.1027374267578,12.7225399017335 51.1033401489258,12.7204484939576 51.1026611328126,12.7052459716797 51.0905647277833,12.7052459716797 51.0905647277833,12.7044563293456 51.0898857116699,12.6997861862183 51.0938606262207,12.6939449310303 51.0969963073731,12.6929025650026 51.0985260009765,12.6774616241456 51.0939292907715,12.6719961166382 51.1017456054689,12.6727161407472 51.1073379516602,12.674898147583 51.1105575561523,12.6547803878785 51.1158180236816,12.6555223464966 51.1182327270508,12.6471729278566 51.1244544982911,12.6364765167237 51.1288375854493,12.6367626190187 51.1300735473633,12.6255197525025 51.1263542175294,12.6227569580078 51.126621246338,12.6195363998414 51.1306381225587,12.617753982544 51.13138961792,12.6146812438965 51.1289443969727,12.6066818237306 51.1335906982423,12.6040182113647 51.1366729736328,12.6061172485353 51.1390991210939,12.5996112823487 51.1429710388184,12.5919256210328 51.1410179138184,12.5916652679444 51.1390609741212,12.5852279663087 51.1378288269044,12.5847730636597 51.13916015625,12.5847730636597 51.13916015625,12.5843229293823 51.1405982971191,12.5764064788819 51.1424140930176,12.576195716858 51.144100189209,12.574439048767 51.1454544067383,12.5717658996582 51.1455001831055,12.5750913619996 51.1485099792481,12.5669755935669 51.1507148742676,12.5672941207885 51.1514320373536,12.5690927505494 51.1510047912598,12.5705070495607 51.1567115783692,12.5701637268068 51.1605339050294,12.5737447738647 51.1609191894531,12.573187828064 51.1641349792481,12.5751781463622 51.1670150756836,12.5738925933839 51.1734733581544,12.5782918930054 51.1738548278809,12.5767698287964 51.1775817871094,12.5851697921754 51.1755599975587,12.5833530426025 51.1794090270997,12.5833272933961 51.18265914917,12.5705671310425 51.1845664978028,12.5791778564454 51.18941116333,12.5777206420898 51.1923599243163,12.5777206420898 51.1923599243163,12.585467338562 51.1932601928712,12.5929651260377 51.1870765686036,12.5947246551514 51.1895484924318,12.6073980331422 51.1904258728027,12.6075792312622 51.1859321594239,12.6025428771973 51.1784896850586,12.6150407791138 51.1793518066407,12.6288862228395 51.1836547851562,12.6399593353272 51.1849403381348,12.6399593353272 51.1849403381348,12.6412601470948 51.1793327331543,12.6445350646974 51.1758346557617,12.6430730819703 51.1730270385743,12.6480731964112 51.1690940856934,12.6512413024902 51.168872833252,12.6557731628419 51.171184539795,12.6573429107666 51.1707687377931,12.6662349700928 51.1741485595704,12.6681327819825 51.1773643493653,12.6679887771607 51.1797866821289,12.6783885955811 51.1752815246583,12.6796741485596 51.1734046936035,12.682396888733 51.1719207763673,12.6870956420899 51.1710700988771,12.6880922317505 51.1694297790527,12.6949033737182 51.1693572998047,12.692973136902 51.1682052612305,12.6942729949951 51.1663246154785,12.695993423462 51.1666908264161,12.6964292526245 51.1698226928712,12.7018756866456 51.1696586608887,12.7001657485963 51.1716270446778,12.7102079391479 51.1714363098146,12.7088947296143 51.1742134094238,12.715389251709 51.1731910705566,12.7155132293702 51.1742782592773,12.7103681564331 51.1750679016114,12.7151174545289 51.175880432129,12.7222833633424 51.1748161315919,12.722409248352 51.1726722717285,12.7240886688233 51.1712608337403,12.725947380066 51.1721000671387,12.7242708206178 51.1729698181153,12.7269439697266 51.1752395629883,12.7322740554811 51.1735458374023,12.740044593811 51.173740386963,12.7365398406982 51.1684761047363,12.7338123321533 51.1680335998536,12.7350912094116 51.1633911132812,12.7350912094116 51.1633911132812,12.7308425903321 51.1575317382813,12.7307033538818 51.155834197998,12.7326068878175 51.1555366516114,12.7349224090577 51.1510276794435,12.7412824630737 51.1496543884278,12.7395401000977 51.1479606628419,12.7409381866456 51.1469802856445,12.7392473220825 51.1457519531251,12.7345237731934 51.1466255187989,12.7340898513794 51.1456336975098,12.7382535934448 51.1447448730469,12.736201286316 51.1431350708009,12.7333707809449 51.1429023742676,12.7358570098878 51.1392822265626,12.7152843475342 51.1342544555664,12.709496498108 51.1349868774414,12.7093353271484 51.1316108703613,12.7104806900024 51.1280441284181,12.7022895812989 51.1275520324708,12.7022304534912 51.1290283203126,12.6920366287233 51.1270256042482,12.6833667755128 51.1291198730469,12.6787595748902 51.1266708374024,12.6794166564943 51.1254425048828,12.6752557754517 51.1233406066895,12.6765460968019 51.1215782165528,12.6865062713624 51.117458343506,12.685604095459 51.1153068542481,12.6882429122925 51.1145668029786,12.6879768371583 51.1134719848633,12.690071105957 51.1133155822754,12.6903715133667 51.1121139526367,12.6935310363771 51.1132965087891,12.6950435638428 51.111125946045,12.6993417739869 51.1091918945314,12.700903892517 51.1110610961915,12.7035493850708 51.111656188965,12.7065505981446 51.1113204956055,12.7077388763427 51.110164642334,12.7115631103517 51.1102828979493,12.7137184143067 51.1137962341309,12.7223520278931 51.1140213012695,12.723804473877 51.1159629821778,12.7259435653687 51.1155433654786,12.7242660522461 51.1136703491212,12.7267446517945 51.1131706237793,12.7279539108276 51.1148147583008,12.7309446334838 51.1139717102051,12.7329750061036 51.1115951538087,12.7463216781616 51.1116981506348,12.7458257675171 51.1105995178224,12.750020980835 51.1101226806642,12.7505683898927 51.1084480285645,12.7540712356567 51.1054992675782)) | 0.0006 | POINT(12.674198021608278 51.142720996632306) |