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 |
|---|---|---|---|
| 180856 | POLYGON((7.12316513061535 48.5135917663574,7.12939929962164 48.5015106201174,7.12545394897472 48.4996032714845,7.10541105270391 48.5003547668458,7.09425115585333 48.5061988830566,7.09100294113165 48.5008773803714,7.09366273880016 48.4892807006836,7.11881113052368 48.4837188720704,7.11681699752808 48.4733314514161,7.10428953170782 48.4541625976564,7.1062183380127 48.4440231323245,7.10938358306885 48.4387969970705,7.10115861892706 48.4354133605959,7.09568691253668 48.4265327453614,7.09580373764038 48.4049530029298,7.08498477935791 48.3978843688967,7.10369205474854 48.3879852294921,7.10664224624639 48.3760643005371,7.10082244873047 48.3737449645999,7.07596445083624 48.3525848388674,7.1059713363648 48.3441047668459,7.1171236038208 48.3341331481935,7.1413192749024 48.3320198059082,7.16278839111328 48.3367881774902,7.16953659057617 48.3423080444338,7.18347835540783 48.3383293151857,7.17899084091198 48.3286209106446,7.19037246704102 48.32292175293,7.19828224182123 48.3104782104493,7.19828224182123 48.3104782104493,7.21835899353039 48.3108901977542,7.21835899353039 48.3108901977542,7.24523687362671 48.3033409118653,7.25955486297607 48.3052024841311,7.27433347702026 48.3050765991211,7.28221988677979 48.2966003417972,7.29079961776733 48.2938385009768,7.29049301147461 48.290740966797,7.29994869232183 48.2828559875488,7.29209136962891 48.2740745544434,7.29385995864868 48.2707672119143,7.30879211425787 48.2685127258301,7.33398294448858 48.2725105285645,7.32289791107189 48.2632675170898,7.31428718566895 48.2624359130861,7.3131475448609 48.2521438598636,7.32537555694574 48.2454490661623,7.35151195526123 48.2474555969239,7.39873695373529 48.2322959899904,7.40907335281383 48.2244491577149,7.41431808471685 48.2249107360842,7.43546581268316 48.2178649902344,7.44478702545172 48.2167816162112,7.45058631896984 48.211681365967,7.47694349288952 48.2035369873048,7.47353935241705 48.1977348327636,7.47013950347906 48.1601753234863,7.52033424377447 48.1494979858399,7.51535129547125 48.1331329345706,7.51859474182135 48.1277656555177,7.55255746841436 48.1219329833984,7.57787322998053 48.1212882995607,7.57787322998053 48.1212882995607,7.58227920532221 48.1260643005371,7.59431552886969 48.1312828063965,7.59877586364746 48.1355781555177,7.60049247741699 48.1407318115235,7.59890747070324 48.1527824401855,7.6006031036377 48.1577186584474,7.62951898574835 48.1837043762209,7.64411830902111 48.2072715759277,7.66569900512701 48.2204780578613,7.68071317672735 48.2572669982912,7.68071317672735 48.2572669982912,7.6892399787904 48.2807922363281,7.6897697448731 48.2950668334964,7.69356870651245 48.3017234802248,7.70621585845947 48.310214996338,7.7370805740357 48.3196105957034,7.74463844299322 48.3278121948244,7.74517393112188 48.3351097106934,7.73187208175665 48.3763771057129,7.73164033889776 48.3917045593261,7.73580360412598 48.4039459228516,7.76503753662121 48.4566116333011,7.76694822311413 48.4871292114261,7.76820087432867 48.4896621704102,7.77146959304821 48.4924621582032,7.795090675354 48.5018310546878,7.8039436340332 48.5112152099609,7.80610942840582 48.5163841247559,7.80658960342419 48.5235443115236,7.8030571937561 48.5369720458984,7.80557298660284 48.550308227539,7.80535793304443 48.5610733032229,7.8002500534057 48.5786666870118,7.80214118957514 48.5888442993164,7.83032321929943 48.6198692321779,7.8380393981933 48.6388587951663,7.84199619293213 48.6437339782715,7.88997602462769 48.6625976562501,7.95963096618652 48.7185821533203,7.95963096618652 48.7185821533203,7.96698093414307 48.7262802124024,7.96715497970575 48.7467269897464,7.96890830993664 48.7537078857424,7.97200584411621 48.7581214904785,7.98256731033331 48.7611045837403,8.00148105621338 48.7588462829593,8.01433372497553 48.7610206604004,8.01972389221203 48.7646255493165,8.02355194091797 48.7697029113772,8.0258026123048 48.7821617126465,8.03027915954596 48.7873725891116,8.04155731201178 48.7907524108888,8.05886650085455 48.7889175415038,8.06837272644043 48.790756225586,8.08413505554194 48.7998390197757,8.09431457519531 48.808345794678,8.10382843017572 48.8201217651368,8.1107606887818 48.8420639038087,8.12763023376459 48.8761138916017,8.14655017852783 48.9022903442385,8.17919540405279 48.9345893859863,8.19639301300055 48.9565010070802,8.20289325714123 48.9597930908204,8.23263263702398 48.9665718078614,8.23263263702398 48.9665718078614,8.22665405273449 48.9740104675294,8.22328186035156 48.9758071899417,8.21512889862061 48.9751930236818,8.20779228210449 48.9701042175295,8.19948101043701 48.9668960571291,8.19539165496832 48.9690513610841,8.19745254516602 48.9726028442383,8.19593906402599 48.973430633545,8.196201324463 48.976245880127,8.19439315795898 48.9771308898926,8.18882369995117 48.9765319824219,8.18469429016119 48.9784736633301,8.18061351776123 48.9775886535646,8.17255783081066 48.9790229797365,8.17056465148931 48.9789505004883,8.1699037551881 48.9764518737794,8.16086006164562 48.9785766601565,8.15264225006115 48.9770889282227,8.13990211486828 48.9784507751467,8.13103389740002 48.9831771850588,8.12806510925293 48.9826278686524,8.12380123138439 48.9863662719728,8.11953067779541 48.9847869873048,8.11530780792242 48.9869270324708,8.10816955566418 48.9864311218262,8.10634613037109 48.9890785217286,8.0876836776734 48.9898185729983,8.08551788330072 48.9932022094727,8.07066059112555 48.9959640502932,8.06840705871576 48.9993171691895,8.06840705871576 48.9993171691895,8.06494331359875 48.999984741211,8.06392574310314 49.0055351257326,8.05735969543457 49.0074195861816,8.04946327209478 49.0141029357912,8.04569816589361 49.0138206481934,8.03101921081549 49.0188674926758,8.02280521392817 49.0180854797363,8.01911067962658 49.0215187072753,8.01777458190912 49.0204620361328,8.01316928863531 49.0213012695315,8.01325416564953 49.0238761901858,8.01072692871105 49.025703430176,8.00808525085449 49.0247039794924,7.99548673629755 49.0290794372559,7.98897361755365 49.0286941528322,7.98330974578869 49.0260314941408,7.97478914260864 49.0267982482911,7.97521018981945 49.0296096801759,7.97254800796509 49.0308570861816,7.97378492355358 49.0320320129396,7.97201871871943 49.0358924865725,7.9668488502503 49.0363998413088,7.96652555465698 49.0415420532229,7.95686197280884 49.0430564880372,7.95736885070812 49.0448760986328,7.9490180015564 49.0471954345705,7.94962930679321 49.0485877990724,7.94531583786005 49.0496597290039,7.94513845443726 49.0554046630861,7.94070291519171 49.0541992187503,7.93865251541143 49.0567817687989,7.93175172805798 49.0580520629883,7.9311575889588 49.0542869567874,7.92647790908813 49.0498504638672,7.92304229736328 49.0436668395998,7.9131121635437 49.0401153564453,7.91383171081543 49.041561126709,7.91073799133301 49.0435256958009,7.91068983078014 49.0451049804689,7.91068983078014 49.0451049804689,7.90254163742065 49.0445442199708,7.88913154602051 49.0490417480472,7.88128042221075 49.0460433959961,7.88031101226801 49.0437278747561,7.87445974349987 49.0405464172366,7.8668260574342 49.0329170227054,7.85465383529674 49.0354804992677,7.85218906402594 49.0377464294434,7.84986066818232 49.0440101623536,7.8457083702088 49.0425872802734,7.84234333038336 49.045520782471,7.83051300048822 49.0472755432129,7.8259415626527 49.0521888732913,7.81263160705561 49.0571060180664,7.81048345565807 49.0612564086917,7.79440259933472 49.0656852722169,7.78943347930903 49.0587234497071,7.780016899109 49.0583152770997,7.77435255050659 49.0547027587893,7.76926565170288 49.047576904297,7.76108741760265 49.0455169677734,7.75666284561152 49.045478820801,7.75154304504406 49.047863006592,7.74695920944208 49.0463638305667,7.74074554443359 49.0473060607912,7.73698329925548 49.044345855713,7.73227024078381 49.0439605712892,7.7314271926881 49.0555305480957,7.72709703445435 49.0549468994143,7.72116804122925 49.0512695312502,7.71771621704102 49.0539016723633,7.70823955535894 49.0524787902832,7.70563077926636 49.0561485290528,7.69804573059082 49.0558776855469,7.69594812393194 49.0577964782717,7.69245052337646 49.0541191101075,7.69736623764038 49.0518531799316,7.69762182235718 49.0497016906741,7.68094825744635 49.04895401001,7.67471647262573 49.0449676513674,7.63539266586304 49.054008483887,7.63539266586304 49.054008483887,7.63929414749151 49.0481147766116,7.62623929977417 49.0337219238284,7.60643386840826 49.0200271606446,7.60831975936901 49.0104255676272,7.58873701095575 48.9910469055176,7.59233570098883 48.9848442077638,7.58239173889172 48.9726600646975,7.58355903625483 48.9660415649415,7.57992601394659 48.9616127014161,7.55335664749157 48.9422149658204,7.55684661865234 48.9363250732425,7.5365138053894 48.9336395263675,7.52778673171997 48.9419059753419,7.51319074630749 48.9432487487794,7.48701953887945 48.9500617980959,7.47793865203857 48.9614791870118,7.45780658721924 48.9629402160646,7.45163106918346 48.9679718017581,7.42924642562872 48.9608573913574,7.40451097488398 48.9582023620605,7.39231252670299 48.9527168273926,7.37991762161261 48.9511985778809,7.35909605026251 48.9564704895019,7.34336709976202 48.9484291076663,7.33356142044073 48.9482460021975,7.32685279846191 48.9433822631839,7.3064603805542 48.9533576965333,7.30547475814825 48.9566421508791,7.29020261764526 48.9565162658693,7.29328775405884 48.9648895263672,7.29043292999279 48.9670906066895,7.29392671585089 48.9726181030275,7.23798799514776 48.9876518249514,7.20931148529053 48.9800872802734,7.19584703445446 48.9937705993655,7.18621301651001 48.9937667846679,7.17424011230469 49.0063667297364,7.16145801544212 49.0022888183595,7.16039180755627 49.0055503845215,7.12995100021385 49.0053596496582,7.12193441390991 49.0233306884765,7.11604976654053 49.031303405762,7.11947727203363 49.0372161865237,7.106357574463 49.0453453063966,7.10197305679316 49.0610809326173,7.10321807861339 49.0643539428711,7.1133065223695 49.0647468566895,7.11505889892589 49.0705909729004,7.10529565811169 49.0725936889648,7.09934234619146 49.0778923034669,7.08911561965954 49.0703887939454,7.07475423812878 49.0721282958987,7.07103204727173 49.0697517395021,7.06860017776489 49.0633888244631,7.07866001129145 49.0503616333009,7.05491256713867 49.030628204346,7.04942607879644 49.0178756713869,7.05235099792486 49.0087013244632,7.04684782028204 48.9999084472658,7.03829717636108 48.9958953857424,7.03168725967402 48.9863662719728,7.03765869140625 48.9766006469726,7.03662395477295 48.9731445312501,7.02762794494629 48.9696655273438,7.03221940994263 48.956050872803,6.99251699447643 48.9605293273926,6.97741031646729 48.9330558776857,6.96597528457647 48.9266586303713,6.95655488967907 48.9274826049807,6.94727039337164 48.934955596924,6.94440174102806 48.9347991943362,6.94146776199341 48.9245758056641,6.95506715774536 48.9199600219727,6.96357965469372 48.9072418212893,6.95737981796265 48.8941574096683,6.9723043441773 48.8907470703126,6.98797369003302 48.8913688659669,7.04496288299561 48.8726348876954,7.05500984191906 48.8649177551269,7.05054426193237 48.85892868042,7.07925224304205 48.8638954162598,7.09414577484137 48.8628807067871,7.09877252578747 48.8542137145999,7.08838033676153 48.8483924865723,7.05206346511841 48.8468818664553,7.05381965637213 48.8359718322756,7.04711723327631 48.8206367492679,7.05243444442755 48.8148384094241,7.07156801223766 48.8152122497561,7.08504056930548 48.8119087219238,7.08795833587641 48.8061714172363,7.06678295135504 48.7993278503418,7.06905889511131 48.7930374145508,7.07924413681025 48.7862854003908,7.08553600311291 48.7916183471681,7.12679958343512 48.8011512756348,7.123206615448 48.8105316162109,7.12983465194702 48.8157081604003,7.13980913162231 48.8174972534183,7.14736080169683 48.8222503662112,7.14211750030518 48.8355560302737,7.14885425567633 48.8445968627931,7.17350816726696 48.8420181274416,7.17695808410645 48.8474349975589,7.1849036216737 48.8503723144533,7.19408750534058 48.8390197753907,7.18719863891607 48.834281921387,7.20342826843267 48.8269577026369,7.21198225021368 48.8261337280275,7.21999120712292 48.8190879821778,7.217748641968 48.8281097412112,7.22712135314941 48.8284606933594,7.24533033370977 48.8168907165529,7.25810480117798 48.8221740722659,7.26246070861822 48.8185691833496,7.25033283233648 48.8148498535156,7.24523496627813 48.8100318908693,7.2577428817749 48.8040657043458,7.26085090637207 48.7975502014163,7.27014589309687 48.8025054931641,7.2908987998963 48.7939071655275,7.29069471359253 48.7862968444827,7.30858278274542 48.7678794860842,7.31333971023554 48.7672386169436,7.29243612289429 48.7519874572755,7.28688430786133 48.7313423156739,7.26611661911005 48.7109832763674,7.2647261619569 48.7004585266114,7.2601342201234 48.6947135925294,7.25046443939203 48.69543838501,7.24226140975958 48.6921081542971,7.25723600387579 48.6728477478027,7.26169586181652 48.6715011596682,7.26627588272106 48.6623001098635,7.304355621338 48.6602096557619,7.28071594238287 48.637218475342,7.26728582382214 48.6318702697756,7.27677679061895 48.6242904663087,7.25665426254278 48.5999298095705,7.26513862609869 48.5917167663575,7.25628185272211 48.5886764526369,7.2202725410462 48.554683685303,7.21657133102417 48.5523643493652,7.20136070251471 48.5527038574219,7.19325447082525 48.5492439270021,7.18710088729864 48.5372734069826,7.16791009902954 48.5275955200196,7.15285062789917 48.5306091308595,7.13800096511847 48.5284004211426,7.11554050445557 48.5366668701174,7.09159421920771 48.5298156738282,7.07936000823986 48.536418914795,7.07936000823986 48.536418914795,7.0653853416444 48.5243034362795,7.08071660995495 48.5125617980958,7.08343791961681 48.5154800415041,7.10373067855846 48.5173263549805,7.12316513061535 48.5135917663574)) | 0.0010 | POINT(7.532111915511723 48.77068795630683) |
| 38645 | POLYGON((0.998328685760498 49.6019096374513,0.984848618507499 49.5982513427734,0.981176316738129 49.6005477905273,0.983177185058594 49.6069984436036,0.983177185058594 49.6069984436036,0.967788696289119 49.6096076965332,0.945067346096153 49.6184120178223,0.945067346096153 49.6184120178223,0.944986939430294 49.6059188842774,0.954203128814754 49.5992317199708,0.954203128814754 49.5992317199708,0.970840454101619 49.5929565429688,0.970840454101619 49.5929565429688,0.980691909790153 49.5938758850099,0.988171696662903 49.5893363952636,0.99798154830944 49.589183807373,0.99798154830944 49.589183807373,1.00803077220922 49.5967559814454,1.00803077220922 49.5967559814454,0.998328685760498 49.6019096374513)) | 0.0006 | POINT(0.9770838806504292 49.60034340306336) |
| 40392 | POLYGON((1.79370296001434 45.4454650878907,1.79024028778076 45.4470214843751,1.78171873092663 45.4418029785157,1.78171873092663 45.4418029785157,1.76844823360449 45.4443054199219,1.76620173454285 45.4417686462403,1.76620173454285 45.4417686462403,1.77716052532202 45.4129104614257,1.77716052532202 45.4129104614257,1.77891457080847 45.4098930358888,1.79561471939093 45.4068298339844,1.79519498348247 45.3972892761231,1.79519498348247 45.3972892761231,1.80436670780188 45.3993606567382,1.80436670780188 45.3993606567382,1.81455886363995 45.4249649047852,1.79267513751984 45.4421272277833,1.79370296001434 45.4454650878907)) | 0.0006 | POINT(1.787261184524146 45.42393359015973) |
| 39037 | POLYGON((3.1250212192536 43.1957168579102,3.11424994468695 43.1764144897461,3.08097743988048 43.1743965148926,3.05557107925415 43.1835517883301,3.0579936504364 43.1969680786133,3.06485795974737 43.2004470825195,3.06485795974737 43.2004470825195,3.08663892745966 43.1962127685547,3.0989413261413 43.2008247375489,3.1108582019807 43.1958198547364,3.1250212192536 43.1957168579102)) | 0.0006 | POINT(3.085996770858798 43.19207992553713) |
| 31660 | POLYGON((1.26126086711895 48.0482177734376,1.2425309419632 48.0507469177247,1.23081624507904 48.0598335266113,1.23081624507904 48.0598335266113,1.23208427429205 48.0632705688477,1.25086390972137 48.0695457458497,1.26642918586737 48.0707588195801,1.2741504907608 48.0835456848145,1.2741504907608 48.0835456848145,1.28919243812561 48.0736656188965,1.31377828121185 48.0683403015137,1.31377828121185 48.0683403015137,1.29446113109589 48.0510406494141,1.29446113109589 48.0510406494141,1.27333509922039 48.0439109802247,1.26126086711895 48.0482177734376)) | 0.0006 | POINT(1.2694739341736065 48.06304244995121) |
| 44957 | POLYGON((1.50573134422314 43.6696929931641,1.52255797386175 43.6546974182129,1.52255797386175 43.6546974182129,1.53505218029034 43.6522636413575,1.53505218029034 43.6522636413575,1.54471659660345 43.6567878723145,1.54471659660345 43.6567878723145,1.5296386480332 43.6734237670898,1.51222634315491 43.6745338439942,1.50573134422314 43.6696929931641)) | 0.0006 | POINT(1.5280277596580367 43.66057205200199) |
| 26039 | POLYGON((1.66404771804815 48.9948768615723,1.6543350219726 48.982032775879,1.6543350219726 48.982032775879,1.6637945175172 48.9696464538574,1.6637945175172 48.9696464538574,1.66596388816828 48.9702835083009,1.66596388816828 48.9702835083009,1.6862199306488 48.9784927368165,1.6862199306488 48.9784927368165,1.70255184173595 48.9892387390138,1.70255184173595 48.9892387390138,1.66404771804815 48.9948768615723)) | 0.0006 | POINT(1.6736161925576192 48.97947866266432) |
| 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) |
| 33827 | POLYGON((4.12874698638927 48.5152740478516,4.12895345687872 48.5349464416503,4.11999320983892 48.5371932983398,4.11999320983892 48.5371932983398,4.12552309036255 48.5448875427246,4.13273954391479 48.5471572875977,4.13273954391479 48.5471572875977,4.14315128326422 48.5474090576173,4.15990543365479 48.5397529602051,4.15990543365479 48.5397529602051,4.15595817565912 48.5094184875488,4.15595817565912 48.5094184875488,4.12906312942511 48.5066986083985,4.12906312942511 48.5066986083985,4.12874698638927 48.5152740478516)) | 0.0006 | POINT(4.137263842991445 48.53021131243026) |
| 61197 | POLYGON((7.50199699401867 46.2788925170898,7.48438215255749 46.2734069824219,7.47731876373291 46.2738418579103,7.47731876373291 46.2738418579103,7.478835105896 46.2762145996094,7.47906684875488 46.2805709838867,7.4731960296632 46.2815742492677,7.47115421295177 46.2828521728515,7.46569395065308 46.2939987182618,7.46647500991821 46.2961578369142,7.47088623046881 46.2982292175293,7.47141122817987 46.3006820678712,7.47380304336542 46.3039360046387,7.47378110885631 46.3081436157227,7.47707986831671 46.3106613159181,7.47707986831671 46.3106613159181,7.48259115219116 46.3008575439454,7.48998880386353 46.2928276062013,7.49261808395391 46.2861480712891,7.49598979949963 46.2827835083008,7.50072908401501 46.2808685302735,7.50199699401867 46.2788925170898)) | 0.0006 | POINT(7.480066481090771 46.28986431303484) |
