Datenbank-Dokumentation

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.

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.
SpaltennameDatentypMögliche WerteBeschreibung
id_ortint(10) unsignedbeliebigFremdschlüssel, der auf die Tabelle `orte` verweist.
geodaten

geometry

Dieser 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:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDie simplifizierten Geodaten.
epsilonfloat(5,4)beliebigDie Toleranz beim Douglas-Peucker-Algorithmus bzw. -1 für Hexagone.
mittelpunkt

point

Dieser 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:

  • Auswahl von "GeomFromText" in der Spalte "Funktion"
  • Eingabe von 
    POINT(11.583720 48.135876)
    in der Spalte "Wert"
beliebigDer geometrische Mittelpunkt des vereinfachten Polygons.
Ausschnitt
id_ortgeodatenepsilonmittelpunkt
19194POLYGON((9.95729446411127 44.2443656921386,9.94780731201183 44.2532958984375,9.94780731201183 44.2532958984375,9.94257068634039 44.2548141479492,9.94684886932373 44.261547088623,9.94671154022222 44.2631340026856,9.93957138061518 44.2692947387695,9.92018699645996 44.2769432067872,9.91466426849365 44.2770881652833,9.90481567382812 44.2737274169922,9.90085124969482 44.2733612060547,9.89302158355713 44.2750244140625,9.8892240524292 44.2781982421876,9.87929439544683 44.2810363769532,9.87055587768555 44.2782325744629,9.86282157897955 44.274383544922,9.85545253753668 44.2690162658691,9.85545253753668 44.2690162658691,9.85555076599121 44.2645263671875,9.8573141098023 44.2583007812501,9.86214637756348 44.2521705627443,9.86103439331055 44.2404670715333,9.86001491546637 44.2383766174317,9.86752319335949 44.2288322448731,9.87637805938726 44.2248992919922,9.87637805938726 44.2248992919922,9.88267040252697 44.2229270935059,9.88520812988287 44.2210350036622,9.89223098754894 44.2087707519532,9.89223098754894 44.2087707519532,9.90952968597412 44.2107315063477,9.90952968597412 44.2107315063477,9.93795871734613 44.2261581420898,9.95256328582764 44.2305030822754,9.95565795898449 44.2291526794434,9.95565795898449 44.2291526794434,9.95729446411127 44.2443656921386))0.0006POINT(9.901792499754201 44.24878279368085)
37906POLYGON((1.49009215831757 49.3986816406251,1.49142956733698 49.3953475952149,1.51208364963531 49.3960494995117,1.51911413669592 49.3910598754882,1.53200554847723 49.395881652832,1.54202413558966 49.3937530517578,1.54202413558966 49.3937530517578,1.54633092880255 49.3973236083986,1.54633092880255 49.3973236083986,1.5439949035644 49.4093132019043,1.5439949035644 49.4093132019043,1.53416395187384 49.4212036132812,1.53416395187384 49.4212036132812,1.51211667060846 49.4125556945801,1.50547957420355 49.4000701904297,1.49009215831757 49.3986816406251))0.0006POINT(1.5263566096623946 49.40218887329104)
52744POLYGON((-0.325513064861241 46.292839050293,-0.341958999633732 46.2955856323243,-0.371094524860382 46.2953186035157,-0.371094524860382 46.2953186035157,-0.378824800252914 46.2756423950195,-0.392494916915894 46.2665634155274,-0.390725195407811 46.2633819580079,-0.390725195407811 46.2633819580079,-0.380773603916168 46.2634239196778,-0.346725255250931 46.2481002807618,-0.340573400258961 46.2424507141114,-0.325581431388798 46.2409248352052,-0.319597840309029 46.2352142333984,-0.309600800275803 46.2359199523926,-0.309600800275803 46.2359199523926,-0.31177914142603 46.2425155639649,-0.306327879428864 46.2548522949219,-0.30172494053835 46.2560844421387,-0.30172494053835 46.2560844421387,-0.329325616359654 46.2698173522949,-0.322322219610214 46.2743377685547,-0.318219482898598 46.2840576171875,-0.325513064861241 46.292839050293))0.0006POINT(-0.3402867533943509 46.26307886297056)
12914POLYGON((16.1420650482179 40.2613372802736,16.1167984008788 40.2638168334962,16.1167984008788 40.2638168334962,16.1182975769043 40.2704391479493,16.1178588867188 40.2737884521484,16.1113014221192 40.2929496765137,16.1063003540038 40.2979011535645,16.1050968170167 40.3004493713379,16.1198863983155 40.3182983398438,16.1242141723634 40.3202781677247,16.1242141723634 40.3202781677247,16.1285247802735 40.319664001465,16.1363067626953 40.3232498168946,16.1395301818848 40.3268737792969,16.1395301818848 40.3268737792969,16.1410121917725 40.3226852416993,16.1481132507325 40.3178138732911,16.1545791625977 40.3183441162111,16.1610164642334 40.3167953491212,16.1562366485596 40.3076896667481,16.1525993347168 40.2978706359863,16.1564044952393 40.2768669128419,16.1608753204347 40.2639045715333,16.1608753204347 40.2639045715333,16.1480255126954 40.2626914978028,16.1480255126954 40.2626914978028,16.1420650482179 40.2613372802736))0.0006POINT(16.135941798870423 40.295818182138376)
16689POLYGON((13.4170446395875 43.5199775695801,13.414701461792 43.5223617553711,13.4163293838502 43.5267868041992,13.4215898513795 43.5319213867188,13.4201078414917 43.5365715026855,13.4201078414917 43.5365715026855,13.4228830337524 43.5364646911622,13.435302734375 43.5452613830567,13.4461250305176 43.5477027893067,13.4558372497559 43.5395088195801,13.4615259170533 43.5371894836426,13.477562904358 43.5353050231934,13.477562904358 43.5353050231934,13.4743051528931 43.5296630859376,13.4703035354614 43.5253219604493,13.4644079208373 43.5211563110353,13.4582271575928 43.5182495117188,13.4460248947144 43.5171508789064,13.4170446395875 43.5199775695801))0.0006POINT(13.444441636403432 43.53124830457903)
1403304POLYGON((1.88467895984655 41.5790252685547,1.88161599636084 41.5714797973634,1.8784090280534 41.5690307617187,1.88101196289068 41.5618896484376,1.87896502017986 41.560001373291,1.87935698032385 41.5571174621582,1.87573099136358 41.5551109313965,1.87301504611975 41.5440177917481,1.88234305381775 41.5420341491699,1.89341294765472 41.5329475402832,1.89775002002727 41.5346946716309,1.90936899185192 41.5344619750978,1.91153597831737 41.5327186584473,1.91182100772863 41.5303230285645,1.89747905731207 41.5269927978516,1.89696800708771 41.5256080627443,1.89070498943335 41.5239143371581,1.88475894927973 41.524814605713,1.87678694725037 41.5226516723634,1.87414705753326 41.5248451232911,1.87070596218115 41.5244750976563,1.86726200580591 41.5198059082032,1.86063897609711 41.5151786804199,1.85876798629772 41.5175666809083,1.85494804382324 41.5162658691407,1.85410499572754 41.5198860168458,1.83998799324036 41.5249862670898,1.83818697929382 41.5281372070313,1.83085298538214 41.5324478149414,1.82687103748322 41.5389976501465,1.83060204982763 41.5427589416505,1.82974696159363 41.5444488525391,1.8335599899292 41.5459175109863,1.83236801624304 41.5484237670898,1.84606397151947 41.5693473815918,1.8603949546814 41.5738677978516,1.86058402061462 41.581024169922,1.85704696178442 41.583408355713,1.85182297229773 41.5909767150879,1.86338102817547 41.5923576354982,1.86745595932018 41.5909080505371,1.86852204799652 41.5889701843262,1.87646996974945 41.5900268554688,1.88247299194342 41.5858573913575,1.88651204109192 41.5861167907715,1.89091694355017 41.5812721252443,1.88467895984655 41.5790252685547))0.0006POINT(1.86956758343659 41.549719769021785)
31509POLYGON((2.2334103584289 46.7398910522461,2.23689699172974 46.7164115905762,2.22627782821661 46.6907882690431,2.22844123840343 46.6877212524415,2.22220969200134 46.6824378967286,2.22220969200134 46.6824378967286,2.2297866344453 46.6777458190919,2.25006294250488 46.6769332885742,2.25006294250488 46.6769332885742,2.2648425102235 46.684944152832,2.27362990379345 46.696128845215,2.28220677375793 46.6937713623047,2.28220677375793 46.6937713623047,2.28855490684521 46.7386627197267,2.28587341308594 46.7523422241212,2.28587341308594 46.7523422241212,2.26726984977722 46.7485046386719,2.26128840446484 46.7432975769044,2.24698162078869 46.743537902832,2.2334103584289 46.7398910522461))0.0006POINT(2.254636099464056 46.70940017700201)
13636POLYGON((14.4156513214112 40.9979667663575,14.4084854125977 41.0024719238282,14.3633441925049 41.0016822814941,14.3565464019775 41.0027770996094,14.3565464019775 41.0027770996094,14.3513946533203 41.0090370178223,14.3427791595459 41.014575958252,14.3425292968751 41.0193061828614,14.3425292968751 41.0193061828614,14.3546972274781 41.0228843688965,14.3591775894166 41.0255813598634,14.3592739105226 41.0389671325684,14.3546667099 41.0418167114259,14.3561458587646 41.0438194274903,14.3561458587646 41.0438194274903,14.3590278625489 41.0482940673829,14.3669881820679 41.0534896850586,14.3736295700074 41.055793762207,14.388768196106 41.0593414306642,14.3922090530396 41.0578765869141,14.3995018005372 41.0567321777344,14.3995018005372 41.0567321777344,14.4134969711305 41.056697845459,14.4134969711305 41.056697845459,14.4106760025026 41.0541229248047,14.4103469848633 41.0522193908693,14.4158039093018 41.0487747192383,14.4191513061524 41.0429801940919,14.4185609817506 41.0413780212402,14.4161348342895 41.04105758667,14.4165802001953 41.0378265380859,14.4201927185059 41.0328063964844,14.4308624267579 41.0273284912111,14.445206642151 41.0273513793945,14.445206642151 41.0273513793945,14.4503211975098 41.0245666503907,14.4461145401002 41.0198020935058,14.4408550262452 41.0196342468262,14.4373483657838 41.0172653198242,14.4364328384401 41.0129165649415,14.4387979507446 41.0102615356446,14.4387979507446 41.0102615356446,14.426926612854 41.0052757263185,14.4145431518555 41.0046768188477,14.4156513214112 40.9979667663575))0.0006POINT(14.39784986322582 41.03059777346528)
70354POLYGON((10.0670337677003 51.2877693176271,10.0659217834473 51.2885208129883,10.0681896209717 51.2885284423828,10.0701789855958 51.2905235290527,10.0672616958619 51.2910804748535,10.0618305206299 51.2902488708497,10.0558986663819 51.2938079833986,10.0565538406372 51.2958717346191,10.0491695404053 51.2996215820312,10.0501928329468 51.3006782531739,10.0522089004516 51.2999229431153,10.0539503097535 51.3008995056153,10.0587615966797 51.2990455627443,10.0687999725342 51.2976913452148,10.0696802139283 51.3010635375978,10.0593109130859 51.3062210083009,10.0527820587159 51.3059501647949,10.050353050232 51.3077507019044,10.0474691390991 51.3076057434083,10.0474691390991 51.3076057434083,10.0438079833984 51.3047561645508,10.0366058349609 51.305908203125,10.0398750305177 51.3033638000489,10.0423154830934 51.2989845275879,10.0350875854492 51.3027000427246,10.0287733078004 51.3012046813965,10.0298700332643 51.2992591857911,10.0285730361938 51.2983627319337,10.0296545028686 51.2950019836426,10.0292949676514 51.2923202514648,10.025094985962 51.2932739257812,10.0172071456909 51.2900733947755,10.0081224441528 51.2902450561523,10.0070457458497 51.2916603088379,10.0043411254883 51.2909584045411,10.0043411254883 51.2909584045411,9.99945545196545 51.2902526855469,9.99374961853039 51.2911262512207,9.98698425292969 51.2942657470703,9.98667240142822 51.2926445007324,9.98423767089855 51.2922744750978,9.98261547088634 51.2872200012208,9.98405647277838 51.2872085571289,9.98344802856445 51.2833366394044,9.98344802856445 51.2833366394044,9.99133205413813 51.2865562438965,9.99726104736322 51.2849082946778,10.0043315887451 51.2869834899903,10.010347366333 51.2834587097168,10.0199546813965 51.2827644348145,10.0205116271973 51.2817649841309,10.0239334106446 51.2820320129395,10.0299873352051 51.2778816223146,10.0414094924928 51.2803916931152,10.0492935180665 51.2776794433594,10.0516080856324 51.2775802612306,10.0537176132202 51.2789993286133,10.057276725769 51.2773666381837,10.057276725769 51.2773666381837,10.0710277557372 51.2810249328613,10.0696334838868 51.2844772338868,10.0696334838868 51.2844772338868,10.0670337677003 51.2877693176271))0.0006POINT(10.033648875451892 51.29188414542908)
1397544POLYGON((-3.19527888298029 40.478355407715,-3.2020440101623 40.4953880310059,-3.19888305664063 40.5039176940918,-3.20058107376099 40.5146942138672,-3.19942688941944 40.5166358947755,-3.1911039352417 40.5155944824218,-3.18570899963373 40.511028289795,-3.17637896537781 40.5090866088868,-3.17364096641541 40.5099639892579,-3.16644597053522 40.5064277648926,-3.158047914505 40.4932670593262,-3.15049195289606 40.4874305725099,-3.15440297126764 40.4795265197754,-3.15974497795105 40.4829597473145,-3.17492508888245 40.481414794922,-3.1881639957428 40.4818267822267,-3.19527888298029 40.478355407715))0.0006POINT(-3.179704353213282 40.497969865799)