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 |
---|---|---|---|
62601 | POLYGON((7.71943521499634 52.9659576416017,7.71617794036871 52.9682426452637,7.72316074371332 52.9721450805664,7.71844196319591 52.9889297485352,7.71657514572144 53.0005149841309,7.71186590194714 53.0007438659669,7.71122169494629 53.0022048950196,7.71276617050177 53.0058822631836,7.71219062805181 53.008129119873,7.7146511077882 53.0091590881349,7.71445989608765 53.0103225708008,7.71243906021124 53.011703491211,7.71220779418945 53.0141258239747,7.71309566497808 53.0150756835938,7.71242904663092 53.0156326293945,7.71242904663092 53.0156326293945,7.7046999931336 53.0122947692871,7.70038604736339 53.0085601806641,7.69667720794683 53.0073051452636,7.69347953796398 53.0048027038575,7.68585824966431 53.0024604797364,7.68112230300903 53.0025939941407,7.68019628524792 53.0002708435059,7.67565822601318 52.9977989196777,7.67134332656866 52.9924621582032,7.66561651229858 52.9907112121581,7.66170024871832 52.9877586364747,7.66170024871832 52.9877586364747,7.68691253662109 52.9764404296876,7.69318199157715 52.9808769226075,7.69828653335577 52.9787330627441,7.69584989547724 52.9767265319825,7.70618057250982 52.9727096557617,7.71131420135504 52.9647750854493,7.70993518829346 52.9640769958497,7.71300697326666 52.9622421264648,7.71943521499634 52.9659576416017)) | 0.0006 | POINT(7.7007403638628205 52.993771129184324) |
13278 | POLYGON((16.2377548217773 38.2887115478517,16.2504615783691 38.2774925231934,16.2520313262941 38.2683982849122,16.2520313262941 38.2683982849122,16.2454986572267 38.2655296325684,16.2470626831054 38.262020111084,16.2465324401856 38.2604904174806,16.2325401306152 38.2521858215333,16.2054061889649 38.2540740966797,16.2054061889649 38.2540740966797,16.2006931304932 38.2586402893067,16.1883411407472 38.2616081237793,16.179271697998 38.2662391662598,16.1774196624756 38.2697067260742,16.1787853240967 38.274242401123,16.1769008636475 38.283489227295,16.1723003387451 38.2890052795411,16.169448852539 38.2901763916016,16.1628437042236 38.2983283996583,16.1638927459717 38.3016128540039,16.1631927490234 38.3050842285157,16.1581745147706 38.3088836669922,16.1543006896973 38.3104705810548,16.1488265991212 38.3107986450196,16.139232635498 38.3188705444337,16.1355075836183 38.3258361816406,16.1355075836183 38.3258361816406,16.1390380859376 38.3298950195313,16.1390380859376 38.3298950195313,16.1379127502441 38.325065612793,16.1384391784667 38.3236961364747,16.1464958190918 38.3181037902832,16.1676311492921 38.3137702941895,16.1754245758057 38.3105010986329,16.178617477417 38.3078918457031,16.1890659332276 38.293296813965,16.1981468200683 38.287868499756,16.2099437713624 38.2863769531251,16.2144622802734 38.2879295349121,16.2179279327392 38.2969245910645,16.2179279327392 38.2969245910645,16.2308101654052 38.2930641174316,16.2377548217773 38.2887115478517)) | 0.0006 | POINT(16.187624931335474 38.291700181506975) |
1401842 | POLYGON((-5.15612506866455 42.0836486816406,-5.15775394439697 42.0839080810547,-5.16448497772217 42.0763626098634,-5.16057586669922 42.0659065246583,-5.16530513763428 42.06205368042,-5.1794610023498 42.0586700439453,-5.18299293518061 42.0608978271486,-5.18281602859497 42.0630912780763,-5.20737600326538 42.0683670043945,-5.20968008041376 42.0675811767579,-5.21980381011963 42.0733680725099,-5.22307014465332 42.0789604187011,-5.24105215072626 42.0794906616211,-5.25076389312738 42.0836906433107,-5.25281715393061 42.0829734802246,-5.25725698471064 42.0891723632813,-5.25368785858149 42.0938987731934,-5.25823211669922 42.0992584228517,-5.2584810256958 42.1049156188965,-5.2611927986145 42.1070861816406,-5.26115608215332 42.1114463806152,-5.26355218887329 42.1139030456543,-5.25603294372553 42.1190757751465,-5.23866081237793 42.1197509765626,-5.22591400146484 42.1242752075195,-5.21997499465937 42.122257232666,-5.21572208404541 42.1265716552734,-5.2158470153808 42.1294250488281,-5.20191907882685 42.1199417114258,-5.19339990615839 42.1160125732423,-5.19354391098022 42.1124191284181,-5.18880319595337 42.1061592102051,-5.18903493881226 42.1040840148927,-5.18499183654779 42.1039733886719,-5.18134593963623 42.0998992919922,-5.17070388793945 42.0949401855469,-5.15612506866455 42.0836486816406)) | 0.0006 | POINT(-5.212320327758767 42.094651010301426) |
71211 | POLYGON((16.9380836486817 47.9533462524414,16.9077281951904 47.966609954834,16.9077281951904 47.966609954834,16.9188098907471 47.9750747680664,16.9188098907471 47.9750747680664,16.9311027526857 47.9709701538087,16.9402408599853 47.9722213745117,16.944969177246 47.9750747680664,16.9642925262452 47.9906272888184,16.9710731506348 47.9947166442872,16.9956073760986 47.9998931884766,17.0426483154297 48.022274017334,17.0426483154297 48.022274017334,17.0554218292237 48.0183448791504,17.0554218292237 48.0183448791504,17.0771255493165 47.9947547912599,17.0771255493165 47.9947547912599,17.0481071472168 47.9810142517091,17.0379447937011 47.9747924804688,16.996545791626 47.9321479797364,16.996545791626 47.9321479797364,16.9762401580811 47.9398307800294,16.9762401580811 47.9398307800294,16.9380836486817 47.9533462524414)) | 0.0006 | POINT(16.98784612572714 47.978727423626495) |
1390066 | POLYGON((-1.39953696727747 40.3140830993652,-1.40573000907892 40.314910888672,-1.41741704940785 40.3103790283203,-1.43336594104767 40.3088264465333,-1.43390595912928 40.3096961975097,-1.44590401649475 40.3074378967285,-1.45117294788355 40.3079872131347,-1.45417296886444 40.3153419494629,-1.46831703186035 40.3340530395508,-1.46464097499842 40.3457145690919,-1.45931696891773 40.3504447937012,-1.44787096977234 40.3530044555665,-1.44780695438379 40.3542633056641,-1.4413800239563 40.3567657470703,-1.42577505111689 40.3593330383301,-1.40492296218872 40.3562240600587,-1.40157496929157 40.3499221801758,-1.39994299411774 40.3377113342286,-1.39508402347553 40.3335723876954,-1.38791799545282 40.332447052002,-1.38439905643452 40.3294982910156,-1.38532698154449 40.3221588134767,-1.38939702510828 40.3188018798828,-1.39562594890594 40.3171501159668,-1.39953696727747 40.3140830993652)) | 0.0006 | POINT(-1.42252107461289 40.33082199096683) |
1407716 | POLYGON((-7.91593694686884 43.5661430358887,-7.91946697235107 43.556884765625,-7.92364692687983 43.5550155639648,-7.92435407638544 43.5527572631837,-7.93243789672852 43.551124572754,-7.94159317016602 43.5463752746583,-7.94518089294434 43.5489196777344,-7.95056819915766 43.5476226806641,-7.95234394073481 43.5485801696777,-7.95471382141113 43.5477600097656,-7.95550489425659 43.5447349548341,-7.95918989181513 43.5433502197266,-7.96656799316406 43.5451622009277,-7.97555685043335 43.5437088012695,-7.98032283782953 43.5417633056642,-7.98412418365479 43.5378952026368,-7.98444795608521 43.5344886779785,-8.00675106048578 43.5229263305664,-8.0135822296142 43.5324630737305,-8.01918411254877 43.5309486389161,-8.02867698669428 43.5352668762207,-8.02472496032715 43.5488891601563,-8.02803802490229 43.5546493530274,-8.02722454071045 43.5606269836426,-8.02085685729975 43.5657691955566,-8.01940059661865 43.5774192810059,-8.0137186050415 43.5772895812989,-8.0115966796875 43.5809745788575,-8.01202774047846 43.5855674743652,-8.01967906951904 43.5881919860841,-8.02835273742676 43.5881156921387,-8.03619575500483 43.5899124145508,-8.01894855499268 43.6008529663087,-8.00708198547363 43.5926513671876,-7.99513006210327 43.5978927612305,-7.98756790161133 43.5969123840333,-7.98210716247553 43.5921440124512,-7.97210216522217 43.5917358398439,-7.96425199508667 43.5875473022462,-7.9601411819458 43.59086227417,-7.93968105316162 43.5919532775879,-7.93320989608765 43.5896224975587,-7.92702007293695 43.591464996338,-7.92729187011719 43.5849380493164,-7.92584896087646 43.5824241638184,-7.92309093475342 43.5818786621094,-7.92155504226685 43.5710983276368,-7.91593694686884 43.5661430358887)) | 0.0006 | POINT(-7.975765877581637 43.56585693359377) |
18438 | POLYGON((9.55440521240234 39.6327629089357,9.54239273071295 39.6384658813477,9.52278518676769 39.6498718261719,9.54150199890148 39.6526336669922,9.54553604125977 39.6543006896974,9.54128456115723 39.6592750549318,9.53776359558105 39.672634124756,9.53999710083008 39.6780128479004,9.53985786437994 39.6825904846191,9.53699207305908 39.6919746398926,9.53611469268805 39.702175140381,9.5382223129273 39.7151222229005,9.52865505218506 39.7258186340333,9.52865505218506 39.7258186340333,9.53745937347418 39.7296257019044,9.54323196411133 39.7351226806641,9.55910682678228 39.7399826049805,9.57019424438482 39.7428588867188,9.57437419891363 39.7430610656738,9.5778951644898 39.7398910522461,9.5778951644898 39.7398910522461,9.59021663665766 39.7424316406251,9.59886074066162 39.7392692565918,9.61359119415295 39.735580444336,9.62303161621088 39.7394943237304,9.62303161621088 39.7394943237304,9.62816619873058 39.7316284179689,9.63117599487305 39.7238807678223,9.63267993927013 39.7224578857422,9.64752292633057 39.7220840454103,9.64752292633057 39.7220840454103,9.65716075897222 39.7228355407715,9.65847396850586 39.7246589660646,9.6687965393067 39.7280502319335,9.67541885375977 39.7271881103516,9.67541885375977 39.7271881103516,9.67402553558355 39.7198600769044,9.67652893066412 39.7176399230958,9.67735862731928 39.7109718322755,9.67125034332281 39.7068099975587,9.6718044281007 39.704303741455,9.67068958282471 39.7009735107421,9.66402816772467 39.7006950378418,9.66180801391613 39.6993064880372,9.66125011444086 39.6976394653321,9.6587486267091 39.6965293884277,9.6587486267091 39.6931991577148,9.66014003753668 39.6909713745118,9.66263771057129 39.689582824707,9.66180610656733 39.6865272521974,9.66374969482428 39.6845817565919,9.6645822525025 39.6818008422852,9.66180801391613 39.6779174804688,9.65986156463629 39.6718101501465,9.66125011444086 39.670696258545,9.65986156463629 39.6707000732422,9.66068935394293 39.6673622131348,9.65708255767822 39.6670837402344,9.65652656555176 39.66597366333,9.6551389694215 39.6662483215333,9.6512508392334 39.6643066406251,9.64958000183111 39.6601409912111,9.64875125885015 39.6543045043945,9.64708232879644 39.6520843505861,9.64846992492676 39.6495819091797,9.64875125885015 39.6449775695802,9.64875125885015 39.6449775695802,9.64490032196045 39.6440315246581,9.62622833251964 39.6476135253906,9.62701606750494 39.64457321167,9.625412940979 39.6374015808105,9.625412940979 39.6374015808105,9.62470245361339 39.6358718872071,9.62470245361339 39.6358718872071,9.61879825592047 39.6300010681153,9.60472297668468 39.6273651123047,9.59173679351818 39.6267395019532,9.59173679351818 39.6267395019532,9.58667278289789 39.6367111206055,9.56524181365972 39.6308708190917,9.55893135070806 39.6299972534181,9.55752086639404 39.6300315856934,9.55440521240234 39.6327629089357)) | 0.0006 | POINT(9.616989496277634 39.68574384363689) |
42361 | POLYGON((6.94356679916382 49.2137718200683,6.93405008316046 49.2123908996583,6.92196893692028 49.2023773193361,6.92196893692028 49.2023773193361,6.89428758621227 49.2101974487306,6.89428758621227 49.2101974487306,6.91512680053711 49.2191390991212,6.92114353179932 49.22172164917,6.9242954254151 49.2230758666992,6.93480539321905 49.2221298217773,6.94356679916382 49.2137718200683)) | 0.0006 | POINT(6.920550107955997 49.21373786926277) |
33755 | POLYGON((4.04429101943975 48.6609535217286,4.03018379211426 48.6596488952638,4.00169563293468 48.6638832092285,4.00169563293468 48.6638832092285,3.98421096801769 48.65193939209,3.97725558280945 48.6320915222168,3.980531692505 48.6294708251953,3.980531692505 48.6294708251953,3.99475049972534 48.6285896301271,3.98404574394237 48.6063423156738,3.98647379875183 48.5998535156251,3.98647379875183 48.5998535156251,4.0033102035523 48.6248741149903,4.05157518386852 48.6335449218751,4.05157518386852 48.6335449218751,4.06858491897589 48.6583366394044,4.06858491897589 48.6583366394044,4.04429101943975 48.6609535217286)) | 0.0006 | POINT(4.011515897863118 48.637330447926324) |
23513 | POLYGON((-0.325562357902527 43.2000808715821,-0.278875142335835 43.216365814209,-0.278875142335835 43.216365814209,-0.28693646192545 43.2247695922853,-0.28693646192545 43.2247695922853,-0.293040156364384 43.2279624938965,-0.293040156364384 43.2279624938965,-0.297188878059387 43.2223510742188,-0.309568583965302 43.2188301086426,-0.325509697198811 43.223949432373,-0.325509697198811 43.223949432373,-0.337441056966725 43.2090759277344,-0.336944609880447 43.2056007385255,-0.325562357902527 43.2000808715821)) | 0.0006 | POINT(-0.30580218480179594 43.218617952787) |