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 |
|---|---|---|---|
| 38836 | POLYGON((2.62371277809154 42.9190788269044,2.59344649314892 42.9130783081056,2.59344649314892 42.9130783081056,2.58639669418329 42.9288902282715,2.56944870948803 42.9336433410644,2.56944870948803 42.9336433410644,2.58174896240234 42.945499420166,2.58174896240234 42.945499420166,2.60169577598583 42.9375877380372,2.60169577598583 42.9375877380372,2.61691737174993 42.9308815002442,2.62371277809154 42.9190788269044)) | 0.0006 | POINT(2.5927006114613644 42.93076983365151) |
| 55749 | POLYGON((5.30656719207775 45.2325172424318,5.3413662910462 45.2105140686036,5.34454536437988 45.2006454467773,5.34454536437988 45.2006454467773,5.31133127212536 45.1961059570312,5.31133127212536 45.1961059570312,5.29996013641357 45.2018280029297,5.30640649795538 45.2317085266114,5.30640649795538 45.2317085266114,5.30656719207775 45.2325172424318)) | 0.0006 | POINT(5.319162209828751 45.21130879720054) |
| 57152 | POLYGON((7.56538152694714 50.1533126831055,7.56469392776489 50.1530952453614,7.56469392776489 50.1530952453614,7.56461906433105 50.1518249511719,7.56672239303583 50.1513481140137,7.56283569335943 50.1494026184083,7.56369924545294 50.1488113403321,7.56150245666504 50.1471786499023,7.55974292755138 50.1430282592774,7.55369853973389 50.1406478881835,7.55462217330938 50.1386451721191,7.55292701721197 50.138427734375,7.55047941207897 50.1361083984375,7.54738092422497 50.1365966796876,7.54617071151728 50.1355552673341,7.54733467102051 50.1337509155275,7.54733467102051 50.1337509155275,7.55363702774054 50.1348953247071,7.55424928665167 50.1286697387695,7.5571808815003 50.1279335021974,7.55721998214733 50.1261787414551,7.55721998214733 50.1261787414551,7.55700159072876 50.1236152648926,7.56231498718262 50.1215019226074,7.56231498718262 50.1215019226074,7.56625366210943 50.1250610351562,7.59486150741577 50.1354179382324,7.59486150741577 50.1354179382324,7.59573221206676 50.1378898620605,7.58960247039801 50.140739440918,7.58411073684692 50.1409606933594,7.58272981643688 50.1426734924316,7.58129787445074 50.1424903869629,7.58129787445074 50.1424903869629,7.57810449600231 50.1424713134766,7.57826614379877 50.1471061706543,7.58113813400269 50.1487655639649,7.57718801498413 50.1507148742676,7.576904296875 50.1521301269531,7.57395553588873 50.1508674621582,7.57176876068121 50.1531333923341,7.56538152694714 50.1533126831055)) | 0.0006 | POINT(7.566903684197442 50.14008256865713) |
| 1401258 | POLYGON((-4.48390483856201 41.3667945861816,-4.51518201827997 41.3940849304199,-4.51586818695068 41.40140914917,-4.51423788070679 41.4059791564942,-4.51640319824219 41.4085159301758,-4.51452493667603 41.4096145629883,-4.50170516967773 41.4108543395996,-4.49994611740112 41.4139289855957,-4.49505519866932 41.4114990234375,-4.49522590637207 41.4099998474122,-4.48357486724854 41.409107208252,-4.48462104797358 41.4103622436523,-4.48267221450806 41.4119720458985,-4.46806287765497 41.4130706787109,-4.46572399139404 41.4144325256347,-4.46584701538086 41.4166297912598,-4.45064592361445 41.3970603942872,-4.45399808883667 41.3875541687012,-4.458092212677 41.3866157531738,-4.4528341293335 41.3841972351075,-4.45163917541493 41.3804550170898,-4.46098184585566 41.372501373291,-4.46716880798334 41.3706207275392,-4.47706985473633 41.3696060180665,-4.48390483856201 41.3667945861816)) | 0.0006 | POINT(-4.4822910626729096 41.398202737172475) |
| 58758 | POLYGON((8.1983852386474 50.8338699340821,8.19363307952892 50.8305168151856,8.18766689300543 50.828426361084,8.18054103851318 50.8225402832031,8.18055057525635 50.8200759887695,8.17392253875732 50.8173294067384,8.17494678497314 50.8161735534668,8.17082214355469 50.8083038330079,8.16580677032471 50.8034744262695,8.1424732208252 50.7946510314941,8.13836193084722 50.7902793884278,8.12924766540533 50.7891044616699,8.12924766540533 50.7891044616699,8.12910556793213 50.7901000976562,8.12105941772472 50.7899475097656,8.11972236633295 50.7922897338868,8.11839675903332 50.792636871338,8.11907100677485 50.7939910888672,8.11680603027338 50.794116973877,8.11624526977545 50.7928619384766,8.10678100585943 50.7929649353028,8.10675525665289 50.7901458740234,8.10404586791998 50.7911796569824,8.10060691833496 50.7909469604493,8.1003627777099 50.7890625000001,8.09705543518066 50.789363861084,8.08741474151611 50.7963981628419,8.07836055755621 50.7973251342775,8.07730388641363 50.7957916259767,8.07921218872076 50.7945976257324,8.07921218872076 50.7945976257324,8.07670783996588 50.7933311462403,8.05663204193121 50.7977714538575,8.04816150665289 50.795970916748,8.04691123962414 50.7975997924805,8.04941368103039 50.7980957031251,8.04913902282721 50.8003387451172,8.04386520385742 50.8068809509278,8.04681110382086 50.8108329772949,8.0495777130127 50.8125381469727,8.04931640625 50.8151969909668,8.04712677001959 50.8156204223634,8.04712677001959 50.8156204223634,8.05149555206293 50.8166732788086,8.05173015594488 50.82320022583,8.04990482330322 50.8238716125489,8.05336093902588 50.8297576904298,8.05140590667725 50.8304557800293,8.05085372924816 50.8347396850585,8.05252075195307 50.8352050781251,8.04918479919445 50.8410606384278,8.053147315979 50.8432960510254,8.05247306823725 50.8444976806641,8.05038356781017 50.8442077636719,8.05036354064947 50.8451271057128,8.05180358886719 50.8450584411622,8.04944133758551 50.8472595214844,8.04510879516607 50.8482475280762,8.04824733734137 50.8518333435059,8.0505828857423 50.8512344360352,8.05175304412847 50.8519706726075,8.05050659179693 50.8532142639161,8.05176067352301 50.8574905395508,8.05512905120861 50.8543014526368,8.05552387237549 50.8562469482423,8.05881404876709 50.8572502136231,8.05892276763922 50.8589630126953,8.06094837188726 50.8599510192872,8.06718635559088 50.8611526489258,8.06944561004639 50.8598327636719,8.08278179168701 50.8621368408204,8.08102893829357 50.8662948608399,8.08643054962158 50.8672103881836,8.08671379089361 50.8658561706544,8.09174156188976 50.8660049438478,8.09298324584967 50.8675804138185,8.09222507476801 50.8684806823731,8.10122489929205 50.8721771240234,8.10517024993896 50.8704338073731,8.11632061004639 50.8729934692383,8.12338352203369 50.8725967407227,8.12731456756603 50.8750381469727,8.12756443023682 50.8779411315917,8.12756443023682 50.8779411315917,8.13490200042719 50.8735542297363,8.14192771911615 50.8750114440919,8.14000511169445 50.8714065551758,8.1490268707276 50.8654479980468,8.1436061859132 50.860424041748,8.14630222320562 50.8602561950684,8.14759349822992 50.8577880859376,8.14746570587158 50.8549652099609,8.14503097534185 50.8547554016114,8.14542770385748 50.8539352416993,8.14908123016369 50.8545303344728,8.14971923828131 50.8531570434571,8.15604496002203 50.8557434082031,8.16122722625738 50.855640411377,8.16237640380871 50.8542785644532,8.16876792907721 50.8558540344238,8.17063236236572 50.8538475036622,8.17793273925787 50.8511772155763,8.19009876251226 50.8507537841796,8.19153594970714 50.8492546081544,8.19584560394293 50.8483963012696,8.20143604278564 50.8454895019532,8.19859886169434 50.8439102172852,8.1975421905517 50.8408279418946,8.19585514068604 50.8390769958496,8.19647026062023 50.8387756347656,8.19415950775152 50.8362426757814,8.1983852386474 50.8338699340821)) | 0.0006 | POINT(8.108260996706885 50.83365091547237) |
| 15017 | POLYGON((9.69587326049805 44.2429885864258,9.68648147583008 44.2461547851564,9.68648147583008 44.2461547851564,9.682695388794 44.2457656860353,9.67620086669933 44.2418708801271,9.67387676239014 44.2368431091309,9.66795253753668 44.2336730957032,9.66133499145508 44.2305030822754,9.65371990203863 44.2290077209473,9.64867115020763 44.2240753173828,9.64770793914789 44.2219047546387,9.64769744873047 44.2151908874511,9.64935398101818 44.2113914489746,9.64935398101818 44.2113914489746,9.64969635009777 44.2092094421387,9.65166187286383 44.2071304321289,9.6623859405517 44.209300994873,9.67478084564215 44.2054557800292,9.66914081573486 44.1969299316407,9.67043304443365 44.1923065185547,9.67043304443365 44.1923065185547,9.68218803405762 44.1957664489746,9.69378662109386 44.2031631469727,9.69915294647222 44.2051124572754,9.71732330322266 44.2072563171387,9.73203563690186 44.201114654541,9.73203563690186 44.201114654541,9.74627971649181 44.2103500366211,9.75570011138922 44.2146224975587,9.75570011138922 44.2146224975587,9.75424385070806 44.2205467224121,9.75424385070806 44.2205467224121,9.75652408599865 44.2235946655274,9.75355625152588 44.2263221740723,9.75071620941168 44.2274017333985,9.74370002746582 44.2229843139649,9.73502254486084 44.2217979431153,9.72748279571528 44.2232933044434,9.72507858276373 44.2243461608886,9.7244148254394 44.228271484375,9.70899391174322 44.2397003173828,9.69587326049805 44.2429885864258)) | 0.0006 | POINT(9.698149076322267 44.21906057218228) |
| 67256 | POLYGON((8.58913040161144 48.9869995117188,8.59618282318121 48.9863548278809,8.59604740142828 48.9856300354005,8.60429954528809 48.9860877990723,8.61176872253418 48.9915580749513,8.62381267547619 48.9944152832032,8.62690162658691 48.9944229125977,8.63440895080572 48.991569519043,8.64231491088873 48.9900474548339,8.6474809646607 48.9908065795899,8.64760684967052 49.0023536682129,8.64961433410645 49.0036430358887,8.6535148620606 49.0032157897949,8.653977394104 49.0043640136719,8.65946292877192 49.0071907043458,8.6609468460083 49.0055694580079,8.6609468460083 49.0055694580079,8.6597146987915 49.013500213623,8.65586566925055 49.0168838500977,8.65322971343994 49.0146255493165,8.65052223205561 49.0142478942872,8.65662097930914 49.0085449218751,8.65046691894543 49.0085258483888,8.64752769470226 49.0067214965821,8.64327716827398 49.0084228515626,8.64224052429194 49.0122756958008,8.64085578918457 49.0120086669922,8.63858604431164 49.0190963745118,8.63876342773443 49.0216026306153,8.63568878173834 49.0211563110352,8.63539505004888 49.0227432250978,8.63499927520752 49.0262641906739,8.64518356323254 49.0282592773439,8.6389207839967 49.0292358398437,8.63958740234386 49.0311164855957,8.63958740234386 49.0311164855957,8.63508224487316 49.035800933838,8.62573528289806 49.0354652404785,8.61881351470959 49.0494842529297,8.61163902282721 49.0579376220704,8.60549259185785 49.0607032775879,8.60549259185785 49.0607032775879,8.59538364410395 49.0591011047363,8.59449577331554 49.0604248046876,8.59285736083996 49.0599594116211,8.59285736083996 49.0599594116211,8.59497928619396 49.0572052001954,8.59463977813726 49.0505409240723,8.58400535583507 49.0466880798339,8.582995414734 49.0445556640625,8.57629013061529 49.0438385009766,8.55388545989996 49.0370178222657,8.54877281188959 49.0300903320313,8.5434188842774 49.0281600952148,8.5434188842774 49.0281600952148,8.54854774475098 49.0244903564453,8.55234050750732 49.0159187316895,8.55767631530767 49.0088844299318,8.56436920166021 49.0088195800782,8.56694507598883 49.0064659118652,8.57783317565918 49.0039978027344,8.57773780822754 49.006462097168,8.58403205871582 49.0052757263185,8.58199024200439 49.0009040832521,8.59352397918695 48.9990043640136,8.59613895416254 48.9972038269044,8.5998210906983 48.9917373657227,8.59774684906012 48.9905662536622,8.59835433959961 48.989616394043,8.59624385833752 48.9889259338379,8.59520626068115 48.987102508545,8.59261417388922 48.98734664917,8.59118461608887 48.9904632568361,8.58762359619146 48.9878425598145,8.58762359619146 48.9878425598145,8.58913040161144 48.9869995117188)) | 0.0006 | POINT(8.611376800537153 49.01547749837242) |
| 56228 | POLYGON((3.90945625305176 46.2079277038575,3.90970468521118 46.1908569335939,3.89653420448315 46.176815032959,3.89826273918163 46.1636276245118,3.8884704113006 46.1559791564941,3.8884704113006 46.1559791564941,3.87566089630133 46.1515121459962,3.86601376533508 46.1519165039063,3.86601376533508 46.1519165039063,3.86766672134411 46.1654853820801,3.85420560836803 46.1749801635743,3.85220646858221 46.1881446838378,3.84210181236273 46.1954765319825,3.84210181236273 46.1954765319825,3.84918546676641 46.1998825073242,3.87673258781444 46.2048072814941,3.88986778259289 46.2141761779786,3.88986778259289 46.2141761779786,3.89013242721558 46.2144889831543,3.89013242721558 46.2144889831543,3.90945625305176 46.2079277038575)) | 0.0006 | POINT(3.877139401435899 46.18440570831304) |
| 57573 | POLYGON((6.36930656433105 50.0007057189943,6.37256479263317 50.001335144043,6.37227582931519 50.0028839111329,6.3795919418335 50.004608154297,6.38043785095221 50.007740020752,6.3839755058288 50.0066146850586,6.38628101348883 50.0072746276855,6.38628101348883 50.0072746276855,6.38526725769037 50.0084800720215,6.38349962234508 50.0077438354492,6.38147830963146 50.0087966918946,6.38527059555054 50.0090370178223,6.38861513137817 50.0105056762696,6.40122604370129 50.0084266662598,6.40122604370129 50.0084266662598,6.39853525161737 50.0100173950195,6.40060567855841 50.011962890625,6.39948749542242 50.0126991271973,6.38832998275757 50.0165214538575,6.3813333511352 50.015926361084,6.37716913223272 50.017692565918,6.37777376174932 50.0192298889161,6.37467098236084 50.0218696594239,6.3716187477113 50.0264511108398,6.3687825202943 50.0251312255859,6.36441326141352 50.0253524780274,6.36506891250605 50.0271339416504,6.36351346969616 50.0297279357911,6.3611302375794 50.0297851562501,6.3611302375794 50.0297851562501,6.35744667053228 50.0290374755861,6.35397052764887 50.0267219543457,6.35397052764887 50.0267219543457,6.35484790802008 50.0250053405762,6.35059690475458 50.0210037231446,6.35404729843151 50.0208930969239,6.35440731048584 50.0199775695802,6.3578510284425 50.0207443237305,6.35583829879766 50.0178489685059,6.35101556777954 50.0167121887208,6.35136365890509 50.0151290893556,6.35500383377081 50.0154037475586,6.35156679153437 50.0117034912111,6.35156679153437 50.0117034912111,6.35518741607677 50.0105895996094,6.35556173324585 50.0089836120605,6.35740947723389 50.0075721740724,6.35563611984264 50.0062637329102,6.35554504394543 50.0027923583984,6.36085319519037 50.0011672973634,6.35927772521973 50.0006027221681,6.36320924758905 49.9984817504883,6.36411714553844 50.0010566711426,6.36930656433105 50.0007057189943)) | 0.0006 | POINT(6.3696443539745715 50.01387275839754) |
| 12290 | POLYGON((14.3280239105226 42.2697219848633,14.3075952529908 42.239128112793,14.3059787750245 42.2373275756837,14.2999687194824 42.2350158691407,14.2999687194824 42.2350158691407,14.2786445617676 42.2441444396973,14.2788600921631 42.2530174255372,14.2805509567261 42.2577362060548,14.2822561264039 42.2580986022949,14.2822561264039 42.2580986022949,14.2866106033326 42.2610969543458,14.2956104278565 42.2727546691895,14.2966098785402 42.274471282959,14.2969846725464 42.2790336608886,14.3055429458619 42.2803955078126,14.3103685379029 42.2793312072754,14.3134355545045 42.2817153930665,14.3134355545045 42.2817153930665,14.313482284546 42.277500152588,14.3155412673951 42.2742614746094,14.3280239105226 42.2697219848633)) | 0.0006 | POINT(14.299586248397892 42.2624790191651) |