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 |
---|---|---|---|
34487 | POLYGON((4.98987150192272 48.4481811523438,4.98044538497919 48.4410667419435,4.97648906707764 48.4319000244141,4.97648906707764 48.4319000244141,4.98810338974005 48.41219329834,4.98810338974005 48.41219329834,4.99529266357422 48.4075012207031,4.99416828155529 48.4042282104492,4.99416828155529 48.4042282104492,5.00089502334606 48.4012794494629,5.00895071029663 48.4030685424805,5.00895071029663 48.4030685424805,5.0139732360841 48.4159774780275,5.02745580673229 48.430103302002,5.0197105407716 48.4386329650878,5.03915977478033 48.4379386901856,5.03915977478033 48.4379386901856,5.02280092239386 48.4489822387696,5.01331806182861 48.4493408203126,5.01295232772833 48.452507019043,5.01295232772833 48.452507019043,5.00363254547131 48.4514656066895,5.00363254547131 48.4514656066895,5.00167369842529 48.4490623474122,4.98987150192272 48.4481811523438)) | 0.0006 | POINT(5.004681209723212 48.42986377080285) |
50466 | POLYGON((2.39245796203619 49.5789184570314,2.39432621002203 49.5845794677735,2.40276932716381 49.5859718322754,2.40276932716381 49.5859718322754,2.40098786354065 49.5917587280273,2.42184019088739 49.6060218811036,2.41836214065557 49.611541748047,2.41836214065557 49.611541748047,2.40431332588201 49.607780456543,2.37420392036438 49.58544921875,2.37420392036438 49.58544921875,2.3832569122315 49.5786285400391,2.39245796203619 49.5789184570314)) | 0.0006 | POINT(2.3989877700806077 49.592801094055226) |
47894 | POLYGON((-1.25393271446222 47.5428733825684,-1.25182509422302 47.544158935547,-1.25182509422302 47.544158935547,-1.22957098484034 47.5361633300781,-1.22698271274567 47.5258255004884,-1.20743405818939 47.5155372619629,-1.18900322914118 47.5095672607422,-1.16324388980865 47.5093650817871,-1.14354348182667 47.5051078796387,-1.14354348182667 47.5051078796387,-1.15583276748652 47.5049057006836,-1.15583276748652 47.5049057006836,-1.20043361186976 47.5038375854493,-1.22488641738886 47.5077285766603,-1.24480104446411 47.5068702697755,-1.24480104446411 47.5068702697755,-1.27082431316376 47.5168609619142,-1.26853930950165 47.5332336425782,-1.25393271446222 47.5428733825684)) | 0.0006 | POINT(-1.2126031120617848 47.5179487864177) |
38709 | POLYGON((2.616055727005 43.1461906433106,2.55410146713268 43.1629257202149,2.55410146713268 43.1629257202149,2.56793856620789 43.1709518432618,2.57148408889776 43.1767692565919,2.58621788024897 43.1839752197265,2.58621788024897 43.1839752197265,2.60219192504877 43.1722717285157,2.60599970817566 43.1527214050294,2.616055727005 43.1461906433106)) | 0.0006 | POINT(2.5827009677887087 43.16807852851024) |
26484 | POLYGON((-0.195148274302369 48.9670867919922,-0.192629545926991 48.9741477966309,-0.192629545926991 48.9741477966309,-0.212538838386536 48.9773139953613,-0.238591015338898 48.9877357482911,-0.253621459007149 48.9890747070313,-0.253621459007149 48.9890747070313,-0.269720792770329 48.9908714294434,-0.269720792770329 48.9908714294434,-0.272221058607101 48.9864921569825,-0.272221058607101 48.9864921569825,-0.27269583940506 48.9831733703613,-0.264341801404953 48.9797019958497,-0.264341801404953 48.9797019958497,-0.22534416615963 48.9730453491212,-0.224186405539513 48.9698104858399,-0.224186405539513 48.9698104858399,-0.195148274302369 48.9670867919922)) | 0.0006 | POINT(-0.24104472118262144 48.98050308227545) |
1408772 | POLYGON((-2.66973090171814 42.19291305542,-2.66900205612183 42.1863098144531,-2.66439604759211 42.1804351806641,-2.68054604530329 42.1833801269531,-2.71194505691528 42.1832733154297,-2.73390293121338 42.1857147216797,-2.74044609069819 42.1847915649415,-2.76817393302917 42.1889419555664,-2.75932192802429 42.1919326782228,-2.74969696998596 42.1972503662111,-2.74621891975403 42.2037162780762,-2.74121189117432 42.2077522277832,-2.72622394561762 42.2025184631349,-2.70974397659302 42.2040977478027,-2.68775200843811 42.1979103088379,-2.68274092674255 42.1950759887695,-2.67577290534967 42.1956329345703,-2.66973090171814 42.19291305542)) | 0.0006 | POINT(-2.712754502015939 42.1930380428539) |
1390748 | MULTIPOLYGON(((-3.49938201904297 43.2507171630861,-3.52083611488337 43.2485580444337,-3.55802202224731 43.2497062683105,-3.55732488632202 43.2462615966797,-3.56835293769831 43.2466926574707,-3.57984495162964 43.2491760253907,-3.58917093276978 43.2556571960449,-3.5862989425658 43.2631988525391,-3.58612608909596 43.279842376709,-3.59767889976496 43.2890815734864,-3.59560489654541 43.2950286865234,-3.60505199432367 43.2968521118165,-3.61360597610468 43.2953720092773,-3.61909198760986 43.291561126709,-3.64176702499378 43.2922477722168,-3.64706301689142 43.2965850830079,-3.64918303489685 43.3011016845703,-3.64355397224421 43.3039436340333,-3.64238190650934 43.3072280883789,-3.63693904876698 43.3104171752931,-3.62812209129333 43.322135925293,-3.61591196060175 43.3307495117188,-3.60823392868036 43.335075378418,-3.58829808235168 43.3390083312988,-3.57437992095947 43.34375,-3.57038903236389 43.3417625427247,-3.57201600074762 43.3325691223145,-3.56877708435059 43.3292808532715,-3.5677769184112 43.3236846923829,-3.5631821155547 43.3217697143555,-3.55991792678822 43.318141937256,-3.55350708961481 43.316993713379,-3.55621910095209 43.3114624023438,-3.50668692588806 43.3013153076172,-3.49037289619446 43.3006858825684,-3.48563909530634 43.3025169372558,-3.47922611236567 43.3022003173829,-3.47366404533375 43.3036270141602,-3.47765302658075 43.2995948791504,-3.48157095909119 43.2898559570313,-3.47409510612488 43.2780380249023,-3.47513008117676 43.2748184204102,-3.49938201904297 43.2507171630861)),((-3.65739488601685 43.2346572875978,-3.66919207572931 43.2334175109864,-3.67648506164545 43.2381286621095,-3.68676590919495 43.241081237793,-3.69057893753052 43.2385902404786,-3.70129799842823 43.2388153076172,-3.71264791488647 43.2552490234376,-3.70748591423029 43.2595405578614,-3.69756007194513 43.2621421813965,-3.68323588371277 43.2603302001953,-3.6764760017395 43.2540855407715,-3.66750502586365 43.2550086975099,-3.66204190254211 43.2533683776855,-3.66103196144104 43.2500152587891,-3.65294098854065 43.2420654296876,-3.66109108924866 43.2384071350099,-3.65739488601685 43.2346572875978))) | 0.0006 | POINT(-3.5785218494494977 43.29212207930891) |
47773 | POLYGON((2.32985973358154 50.6944618225098,2.33422851562506 50.7006072998048,2.33257007598877 50.7105598449708,2.35074019432068 50.7174644470215,2.35564780235302 50.7161293029786,2.35564780235302 50.7161293029786,2.36637258529669 50.7096786499023,2.36637258529669 50.7096786499023,2.36637473106396 50.7094955444337,2.36637473106396 50.7094955444337,2.33403682708752 50.6895065307618,2.33403682708752 50.6895065307618,2.32985973358154 50.6944618225098)) | 0.0006 | POINT(2.3493552009265355 50.70605945587164) |
64981 | POLYGON((13.097776412964 49.0094642639161,13.1043033599854 49.0074577331543,13.1159467697144 49.0067253112794,13.1159467697144 49.0067253112794,13.1163806915284 49.0043754577637,13.1193304061891 49.001750946045,13.121789932251 49.0019531250001,13.1283483505248 49.0050926208497,13.1286354064943 49.0033340454102,13.1310253143311 49.0035095214844,13.1389951705933 48.9998931884766,13.1534242630006 49.0000190734863,13.1546182632447 48.9965553283691,13.1591615676881 48.9925193786621,13.1676368713379 48.9929389953613,13.167781829834 48.9975433349611,13.1698236465454 48.9995918273926,13.1733512878418 48.9998245239259,13.1813488006591 48.9965362548829,13.1826105117798 48.9970817565919,13.1871910095216 49.0049285888672,13.1883287429811 49.0054664611818,13.1942472457885 49.0039024353028,13.1942472457885 49.0039024353028,13.1995220184326 49.0028228759766,13.200345993042 48.9992027282714,13.2025184631348 48.9954872131348,13.2062940597534 48.9952583312988,13.2080593109131 48.9918518066406,13.2078828811646 48.9891815185546,13.204719543457 48.9898529052735,13.2048025131227 48.9874114990236,13.2070283889772 48.984432220459,13.21204662323 48.98099899292,13.21204662323 48.98099899292,13.2050380706787 48.9808616638185,13.2044620513917 48.979362487793,13.1970529556274 48.9769515991212,13.1975193023682 48.9725646972657,13.199125289917 48.9714469909669,13.192144393921 48.9740028381349,13.1895236968995 48.9780158996583,13.1809730529785 48.975440979004,13.179602622986 48.9763717651368,13.1798686981201 48.9789505004883,13.1791181564332 48.9797248840333,13.1779518127442 48.9786529541017,13.1740064620973 48.9787750244141,13.1713514328002 48.9769935607911,13.1707220077515 48.975498199463,13.1719980239869 48.9738388061524,13.1710271835328 48.971851348877,13.176537513733 48.966682434082,13.1762847900391 48.9648437500001,13.1755208969116 48.9631309509278,13.1729707717896 48.9634895324708,13.1727600097657 48.962387084961,13.164849281311 48.962703704834,13.1644430160522 48.9617691040039,13.1658172607422 48.9596748352052,13.1626567840576 48.9553871154785,13.1617774963379 48.952320098877,13.1594686508179 48.9526519775391,13.1602153778076 48.9511108398438,13.1589527130127 48.9485206604004,13.1614389419556 48.9470558166504,13.1617488861084 48.9453468322754,13.1607341766357 48.9432830810547,13.1669683456421 48.9413795471193,13.1625347137452 48.940258026123,13.156460762024 48.9413146972656,13.1539974212647 48.9402732849121,13.1541852951049 48.9384689331055,13.1526432037353 48.9384956359864,13.1502943038941 48.9365272521973,13.1502943038941 48.9365272521973,13.1485080718994 48.937084197998,13.1444597244264 48.9349822998048,13.149079322815 48.9315338134767,13.1491775512695 48.9290847778321,13.148196220398 48.927677154541,13.1454315185547 48.9277687072754,13.1405143737793 48.9253120422364,13.1393747329712 48.9261589050293,13.1361083984376 48.9246177673339,13.1361083984376 48.9246177673339,13.1244869232179 48.9271507263184,13.1228904724122 48.928680419922,13.1177225112915 48.9268264770508,13.114743232727 48.927791595459,13.1136360168457 48.932399749756,13.1091537475586 48.9361228942871,13.1094360351564 48.9349250793456,13.1056270599365 48.9332695007324,13.1005640029907 48.9338569641114,13.097999572754 48.93510055542,13.0991477966309 48.9378547668458,13.0977544784546 48.9381523132325,13.0896282196045 48.9375305175781,13.082070350647 48.9400253295898,13.0740089416504 48.9379463195802,13.0688352584839 48.9380111694337,13.0646371841432 48.940258026123,13.0645122528077 48.942539215088,13.0595350265504 48.9463424682618,13.0575914382935 48.9509315490724,13.0527763366699 48.9521102905274,13.0527763366699 48.9521102905274,13.0544452667236 48.9555206298829,13.0563135147095 48.9570083618164,13.0615730285645 48.957992553711,13.0658550262452 48.9575729370117,13.0672616958619 48.9626960754395,13.0670356750488 48.9664268493652,13.0707130432129 48.966953277588,13.073211669922 48.9658699035645,13.073769569397 48.9671173095703,13.0568552017211 48.9703674316406,13.054835319519 48.967830657959,13.0514860153199 48.9673042297364,13.053204536438 48.9716415405273,13.0516386032104 48.9743385314942,13.0560216903688 48.9778404235839,13.053957939148 48.9830589294434,13.0472984313965 48.9879913330079,13.0478010177612 48.9897460937501,13.0478010177612 48.9897460937501,13.0520896911622 48.990421295166,13.0589094161988 48.9887886047364,13.0643501281739 48.9913368225099,13.0689535140992 48.9948730468751,13.072759628296 48.994915008545,13.075719833374 48.9968147277833,13.0790567398071 48.9943313598632,13.0843915939331 48.993278503418,13.0854625701904 48.9958877563477,13.087809562683 48.997573852539,13.0944185256959 48.9989051818848,13.0968608856201 49.0005645751954,13.0937128067017 49.007423400879,13.097776412964 49.0094642639161)) | 0.0006 | POINT(13.131747293472321 48.96894577571325) |
59756 | POLYGON((7.73906612396246 46.82719039917,7.72720813751232 46.8261756896973,7.72230577468872 46.823341369629,7.72320890426641 46.8211097717286,7.7328572273255 46.8142051696777,7.73368692398066 46.8114776611329,7.73368692398066 46.8114776611329,7.73123502731329 46.810905456543,7.73123502731329 46.810905456543,7.72244787216187 46.8125114440919,7.71554088592541 46.8115615844726,7.71167707443243 46.813591003418,7.70848321914679 46.8137512207032,7.70073986053467 46.8085289001465,7.69596815109253 46.8075942993164,7.6926097869873 46.8049011230469,7.68202877044683 46.8031082153321,7.68202877044683 46.8031082153321,7.67954111099243 46.8064765930177,7.6733517646789 46.8072013854981,7.66888284683228 46.8100700378419,7.6617431640625 46.8086128234863,7.64782619476318 46.8092384338379,7.64782619476318 46.8092384338379,7.65156412124639 46.8122138977052,7.65365982055664 46.8163490295411,7.65636491775518 46.8185768127441,7.65720701217657 46.8236236572266,7.65922498703009 46.825309753418,7.65922498703009 46.825309753418,7.67098712921137 46.8252182006837,7.68046712875372 46.8316116333008,7.68046712875372 46.8316116333008,7.68698787689215 46.8324279785157,7.69231414794928 46.8343315124513,7.70310401916515 46.8345832824707,7.71440076828014 46.836799621582,7.71440076828014 46.836799621582,7.72070693969738 46.8363189697267,7.72499895095825 46.8323554992676,7.73665904998785 46.8330688476564,7.73835086822515 46.8316993713379,7.73906612396246 46.82719039917)) | 0.0006 | POINT(7.696816103799041 46.81915455772768) |