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
57631POLYGON((6.13751554489147 50.0117225646973,6.13958024978638 50.0138473510742,6.14289093017572 50.0138931274415,6.14328527450573 50.015079498291,6.14722394943237 50.016357421875,6.15051364898693 50.0151138305665,6.15068387985241 50.0117378234864,6.15538454055792 50.0123329162599,6.15533542633057 50.0108909606934,6.1567058563233 50.0125617980958,6.1577610969544 50.011432647705,6.15938329696655 50.0137214660644,6.16393756866466 50.0166778564453,6.16521978378307 50.0162658691407,6.16521978378307 50.0162658691407,6.16085958480841 50.0098190307617,6.1625213623048 50.007251739502,6.15952348709112 50.002124786377,6.15952348709112 50.002124786377,6.15729236602795 50.0003814697266,6.15652990341187 49.9971084594727,6.15444374084473 49.9945526123046,6.15352249145508 49.9894218444825,6.15352249145508 49.9894218444825,6.15072822570812 49.9941864013672,6.14187526702892 49.9948768615723,6.13784122467047 49.9986724853516,6.13971138000488 50.0000610351564,6.1440196037293 49.9981079101563,6.14527893066412 49.9984130859375,6.14678001403814 50.0028495788574,6.1493935585022 50.0062980651855,6.14964437484753 50.0088806152344,6.14805555343634 50.0102233886719,6.14011621475225 50.0106086730958,6.13751554489147 50.0117225646973))0.0006POINT(6.151480688367628 50.00637959071571)
64824POLYGON((11.0958452224731 49.176986694336,11.0953102111817 49.1736717224122,11.0960006713868 49.1718063354493,11.0996122360229 49.1687812805176,11.0999650955201 49.1662406921388,11.0987634658815 49.1622467041016,11.0853900909424 49.1588821411134,11.0829086303712 49.1544418334962,11.0808572769164 49.1560173034668,11.0789709091187 49.1553802490234,11.0787010192871 49.1568832397461,11.0737047195434 49.1588325500489,11.0741958618164 49.157497406006,11.0692501068116 49.1532516479492,11.0692501068116 49.1532516479492,11.072338104248 49.1535339355469,11.0723667144776 49.152416229248,11.0699968338013 49.1526641845703,11.0707998275757 49.1497802734374,11.065791130066 49.1495170593262,11.064721107483 49.1482810974122,11.0624513626098 49.1500015258789,11.0623655319215 49.1473579406739,11.0549182891847 49.143653869629,11.0518531799317 49.1406211853028,11.0531301498414 49.1383743286133,11.0562009811402 49.1383590698242,11.0552005767823 49.1396217346191,11.0613403320314 49.1405448913574,11.0638952255249 49.1386070251466,11.0646076202394 49.1409149169922,11.0669670104982 49.1410675048828,11.0677556991578 49.1393547058107,11.0662384033204 49.1397285461427,11.0651874542237 49.1377563476564,11.0684795379639 49.1379203796387,11.068507194519 49.135597229004,11.0679903030396 49.1347808837891,11.0640230178833 49.1343421936036,11.0651464462281 49.1342658996582,11.0653533935548 49.1297149658204,11.0653533935548 49.1297149658204,11.0677471160889 49.1293067932129,11.0704898834229 49.1236534118653,11.0719747543336 49.1240043640137,11.072582244873 49.1232109069824,11.073079109192 49.1223793029786,11.0711917877197 49.1212539672852,11.0798740386964 49.1221923828125,11.0812273025513 49.1184349060059,11.0833530426025 49.1174430847169,11.0775032043457 49.11185836792,11.082242012024 49.1094512939454,11.0803394317627 49.1073036193849,11.08189868927 49.1070518493653,11.0817775726318 49.1061515808107,11.0869998931885 49.106330871582,11.0869398117066 49.1047668457031,11.0897722244263 49.1056251525878,11.0896873474121 49.104305267334,11.0934228897096 49.1028175354004,11.0934228897096 49.1028175354004,11.0955314636231 49.1015663146974,11.0933723449707 49.0997772216798,11.0961694717407 49.0977668762208,11.1081190109254 49.0960540771484,11.1144590377807 49.089382171631,11.1144590377807 49.089382171631,11.1186771392822 49.0893859863281,11.1197423934937 49.0880928039551,11.1223821640014 49.0878448486328,11.1230125427247 49.085792541504,11.1344089508057 49.0867729187012,11.1366147994995 49.0839347839355,11.1401405334473 49.0844192504883,11.1413774490358 49.0858230590821,11.1418657302857 49.0833816528321,11.1463298797608 49.0813331604004,11.1503438949586 49.0814971923828,11.1525068283082 49.0804595947266,11.158299446106 49.0824508666992,11.1585512161256 49.084888458252,11.1600532531739 49.0865707397462,11.1623783111572 49.0863037109375,11.1623783111572 49.0863037109375,11.163348197937 49.0871696472168,11.1610221862792 49.0903396606445,11.1614074707032 49.0934600830079,11.1627969741822 49.0938644409181,11.1628551483154 49.0901412963867,11.166117668152 49.0903282165528,11.1698284149171 49.0922393798828,11.1700353622438 49.0933532714844,11.1678485870361 49.0936813354493,11.1676731109619 49.0946960449219,11.1700668334962 49.0948715209961,11.1697645187379 49.0995178222657,11.167462348938 49.1024017333985,11.1686410903931 49.1044807434081,11.1673650741578 49.1063232421875,11.1720333099366 49.1089591979981,11.1716251373292 49.1101570129396,11.1675462722778 49.1114654541016,11.1681070327759 49.1143951416016,11.169882774353 49.115951538086,11.1675701141357 49.1171607971192,11.1684350967407 49.1192321777345,11.1673288345337 49.1195297241212,11.1681661605834 49.1205940246583,11.1673412322999 49.1214447021485,11.1703519821166 49.1230621337892,11.1706247329712 49.1249580383301,11.1699466705322 49.1264381408691,11.1672763824462 49.1256523132324,11.1657638549805 49.1272811889648,11.1685333251954 49.128345489502,11.1653022766114 49.1296234130859,11.1657752990724 49.1370239257812,11.1607484817505 49.1383399963379,11.1597051620484 49.1412506103516,11.1597051620484 49.1412506103516,11.1512718200685 49.1513023376465,11.150486946106 49.1540870666504,11.1473054885865 49.1582527160646,11.1470460891724 49.1613922119142,11.1508016586303 49.1622352600099,11.1553936004639 49.1569099426271,11.1636743545532 49.1547546386719,11.1637191772462 49.1619720458986,11.1525459289551 49.1643829345704,11.1532220840455 49.165683746338,11.1440906524659 49.163948059082,11.1453504562379 49.1659011840821,11.1412096023559 49.1659965515137,11.1511116027831 49.1678924560548,11.1509456634523 49.1688270568848,11.1541204452515 49.1699867248536,11.1537046432496 49.171443939209,11.157265663147 49.1735496520996,11.1480875015259 49.1745719909669,11.1376132965088 49.1772422790528,11.1376132965088 49.1772422790528,11.1270332336427 49.1792106628419,11.1262245178223 49.1760749816895,11.1114339828492 49.1771545410157,11.1032114028931 49.1757698059083,11.0958452224731 49.176986694336))0.0006POINT(11.118567728016508 49.128335456325594)
24886POLYGON((3.72899127006531 45.9141502380372,3.7213499546051 45.9227447509765,3.69401788711542 45.9307327270509,3.69401788711542 45.9307327270509,3.69464421272284 45.9169578552246,3.68458843231195 45.9092864990235,3.67726969718933 45.8973693847656,3.67726969718933 45.8973693847656,3.69433474540722 45.8913688659667,3.70158171653742 45.8791503906251,3.71552419662487 45.8705863952637,3.71552419662487 45.8705863952637,3.73408389091492 45.8712692260742,3.7438063621521 45.8781318664551,3.74562859535217 45.8841629028321,3.75437068939215 45.8860321044922,3.75437068939215 45.8860321044922,3.74023294448864 45.9077644348144,3.72899127006531 45.9141502380372))0.0006POINT(3.7150892814000667 45.8969126807319)
68465POLYGON((6.87492179870605 49.3271255493165,6.88011550903326 49.3289680480958,6.88222026824963 49.3312149047852,6.87997102737427 49.3334503173829,6.87964248657227 49.3356094360352,6.87585163116455 49.3374519348145,6.87206649780279 49.3441276550294,6.86795949935924 49.3437538146973,6.86270189285278 49.3469238281251,6.86388778686529 49.3481979370117,6.87011575698858 49.3462257385254,6.87413740158087 49.3460960388185,6.87650299072266 49.3474426269531,6.87701988220215 49.3462600708008,6.88142395019526 49.3474464416505,6.88402414321899 49.3498992919922,6.88921117782598 49.3502197265626,6.8889269828797 49.3508758544922,6.89068794250488 49.3512954711915,6.89036798477173 49.3520660400391,6.90370941162121 49.3554306030273,6.90902900695806 49.3580398559571,6.90731000900269 49.3600044250489,6.9089150428772 49.3602981567384,6.90902662277222 49.3612022399903,6.91200065612799 49.3612594604493,6.91279697418219 49.3603858947754,6.91587543487543 49.3629264831542,6.9185552597047 49.3634147644044,6.91967487335216 49.3667030334474,6.92170286178589 49.3681716918945,6.92170286178589 49.3681716918945,6.92767381668102 49.3666954040528,6.93131017684942 49.3676834106446,6.93201971054077 49.3753890991212,6.93522453308105 49.3755073547364,6.93625497817993 49.3725891113281,6.9377551078797 49.3724441528321,6.93828725814825 49.3740119934082,6.93712091445923 49.3767127990723,6.93988704681402 49.3773574829102,6.94076633453363 49.3762893676758,6.9442777633667 49.3776664733887,6.9442777633667 49.3776664733887,6.94984197616583 49.3734931945801,6.95615100860596 49.3737831115724,6.95856046676641 49.3708496093749,6.95834350585938 49.3689346313476,6.95677661895758 49.3677406311035,6.95744371414179 49.3669242858888,6.95619535446167 49.3659057617188,6.96266078948975 49.3595695495606,6.9636697769165 49.3595390319824,6.96455764770513 49.3566589355469,6.97015523910528 49.3559036254883,6.97819662094128 49.3588600158692,6.98072576522833 49.3574600219728,6.99199104309088 49.3591461181641,6.99738883972168 49.3581085205078,7.00014829635626 49.3590202331544,7.00014829635626 49.3590202331544,7.02239274978643 49.358757019043,7.02025175094616 49.3550071716309,7.01391792297369 49.3497772216797,7.0203738212586 49.3497161865234,7.0203738212586 49.3497161865234,7.01660919189464 49.3459358215333,7.01744604110712 49.3438987731934,7.01600408554083 49.3415489196778,7.01826190948498 49.3396835327149,7.01737546920788 49.3378448486328,7.01208305358887 49.3336715698242,7.00419092178356 49.3305892944337,7.00166702270519 49.3272171020508,7.00279712677013 49.326457977295,7.00231122970587 49.3236694335938,6.99955368042004 49.325023651123,6.99355506896978 49.3205680847169,6.99355506896978 49.3205680847169,6.98640823364269 49.3176994323732,6.98173427581787 49.3217048645021,6.98173427581787 49.3217048645021,6.97822666168219 49.3240699768066,6.97578191757208 49.3235893249513,6.97363328933727 49.3215141296388,6.96767902374273 49.320426940918,6.96624851226812 49.3232078552247,6.96229457855225 49.3246955871583,6.95770931243896 49.3233528137208,6.95048904418951 49.3267211914063,6.94138479232799 49.3251876831055,6.93619871139526 49.3218536376953,6.93413162231457 49.3241500854492,6.92339706420904 49.3278694152832,6.92365503311163 49.3308067321778,6.9218049049378 49.3311157226564,6.91180849075317 49.3304557800294,6.91176223754888 49.3284873962403,6.90697479248041 49.3278312683105,6.90137958526606 49.3250846862794,6.90137958526606 49.3250846862794,6.89648485183722 49.3258666992188,6.88900089263922 49.3249778747558,6.87492179870605 49.3271255493165))0.0006POINT(6.942173666167068 49.347074749400335)
14387POLYGON((13.5123271942139 46.3900451660156,13.5014448165894 46.3870582580568,13.480149269104 46.3778495788575,13.469108581543 46.3704299926758,13.469108581543 46.3704299926758,13.4158792495728 46.3731384277344,13.4089508056641 46.3788757324219,13.4003810882569 46.3834075927734,13.3800287246704 46.3890762329103,13.373140335083 46.3898315429689,13.3655967712402 46.38765335083,13.3623218536377 46.3845138549804,13.3599605560303 46.3838958740236,13.3406400680543 46.3846435546876,13.3180170059204 46.3899993896486,13.3106679916383 46.3950576782227,13.2972717285157 46.3941917419434,13.2949285507203 46.3904571533203,13.2906999588013 46.3893432617188,13.277042388916 46.3897933959962,13.277042388916 46.3897933959962,13.2621479034424 46.3968200683594,13.2575979232789 46.3959083557129,13.2415618896485 46.3974876403809,13.2415618896485 46.3974876403809,13.2426261901856 46.4044342041016,13.2471027374268 46.4043769836426,13.260298728943 46.4083557128906,13.2608518600464 46.4208335876466,13.2669773101807 46.4222030639649,13.272400856018 46.4189338684081,13.2732629776002 46.4196777343751,13.2781085968019 46.432342529297,13.2739925384523 46.4415016174316,13.2739582061768 46.4446640014649,13.2739582061768 46.4446640014649,13.2834405899049 46.4457702636719,13.3129673004151 46.4428215026855,13.333251953125 46.4380531311035,13.361457824707 46.4268531799317,13.3693170547485 46.4252014160156,13.4021711349487 46.4236106872559,13.4241256713868 46.42586517334,13.4322614669801 46.4307975769043,13.4344987869263 46.4367294311525,13.4344987869263 46.4367294311525,13.4430570602418 46.4337882995607,13.4647064208985 46.4193420410157,13.4726800918579 46.4175872802735,13.4795026779175 46.4183502197266,13.4795026779175 46.4183502197266,13.4910335540772 46.4139938354493,13.5001964569093 46.4120712280274,13.5123271942139 46.3900451660156))0.0006POINT(13.357543117595213 46.407643228207036)
38818POLYGON((2.37517142295837 43.4230003356934,2.36733150482178 43.4231796264648,2.36733150482178 43.4231796264648,2.35737633705151 43.400547027588,2.3688695430755 43.3898468017578,2.36778473854059 43.3762931823732,2.37356591224676 43.3709106445312,2.38279247283947 43.3695755004883,2.38279247283947 43.3695755004883,2.38309979438793 43.3696670532227,2.38309979438793 43.3696670532227,2.38895106315613 43.3749122619629,2.39808893203741 43.3761749267579,2.38020133972179 43.3960571289064,2.37517142295837 43.4230003356934))0.0006POINT(2.376889773777602 43.38804190499445)
13271POLYGON((15.8404912948609 37.9195823669435,15.8417177200317 37.9270477294922,15.8441324234009 37.9291534423829,15.8458490371704 37.9370155334473,15.8462867736816 37.9455337524415,15.8513803482056 37.9538536071778,15.8557491302491 37.9576644897461,15.8596754074097 37.9653968811035,15.8572425842286 37.9833145141602,15.8552408218384 37.9874038696288,15.8526010513307 37.9885292053223,15.8516387939454 37.991024017334,15.8538427352906 38.0044097900391,15.8496561050415 38.0077743530275,15.8469591140748 38.0178527832032,15.8531761169434 38.0352897644044,15.8605861663818 38.0386886596681,15.8605861663818 38.0386886596681,15.8634729385377 38.035385131836,15.8659715652466 38.0342597961426,15.8724279403688 38.0367240905762,15.8799228668214 38.035659790039,15.8837785720826 38.0331382751465,15.8958826065064 38.0315017700195,15.9045124053956 38.0317916870118,15.9069480895996 38.0300178527833,15.9069480895996 38.0300178527833,15.9044704437255 38.0228309631348,15.9045486450195 38.0117149353028,15.9326705932618 38.0088386535646,15.9326705932618 38.0088386535646,15.9225063323975 38.0011863708497,15.9176416397096 37.9911270141602,15.9070167541504 37.978931427002,15.9043197631835 37.9661331176758,15.9043197631835 37.9661331176758,15.9059000015259 37.9529991149902,15.901746749878 37.9344596862794,15.8989086151124 37.9270820617676,15.8989086151124 37.9270820617676,15.8951387405396 37.9268074035646,15.8934726715089 37.9276390075684,15.886251449585 37.9262504577638,15.8820819854736 37.9279174804688,15.8773622512817 37.927360534668,15.8762502670288 37.9259719848634,15.8734712600709 37.9262504577638,15.87180519104 37.9251403808594,15.8687486648561 37.9254150390624,15.8629169464112 37.9237518310547,15.8565282821656 37.9234733581543,15.8493061065674 37.9220848083496,15.8459711074829 37.9201393127443,15.8404912948609 37.9195823669435))0.0006POINT(15.8770115150596 37.97457130000282)
67809POLYGON((7.7740306854248 50.2492713928222,7.77890396118175 50.2473526000977,7.77890396118175 50.2473526000977,7.78674602508545 50.2454376220704,7.78674602508545 50.2454376220704,7.79249906539928 50.2454986572267,7.79738616943359 50.2484169006348,7.79875373840332 50.2483215332032,7.800127029419 50.2510643005372,7.80484580993658 50.252769470215,7.80463457107555 50.2540054321289,7.80073356628418 50.2559204101562,7.80284452438349 50.2570686340333,7.80254316329967 50.2579193115236,7.79899692535406 50.2585296630859,7.80143690109253 50.2605590820313,7.80143690109253 50.2605590820313,7.80270576477045 50.2619476318361,7.80135202407848 50.2644882202148,7.80347967147827 50.2658462524415,7.80349683761608 50.2682495117187,7.80349683761608 50.2682495117187,7.8033328056336 50.2723426818849,7.80212306976318 50.2713851928712,7.79958295822149 50.2715873718261,7.79958295822149 50.2715873718261,7.79878854751587 50.2702560424805,7.79690980911266 50.2701835632325,7.79687118530273 50.2677764892579,7.78866958618164 50.2665481567383,7.78858947753906 50.2653770446778,7.7809219360351 50.2631607055664,7.7809219360351 50.2631607055664,7.78197145462042 50.2607917785645,7.78077173233038 50.2599143981935,7.78011322021496 50.2572174072266,7.78082799911499 50.2560272216798,7.7794451713562 50.2537078857423,7.77650117874157 50.2541046142579,7.7740306854248 50.2492713928222))0.0006POINT(7.793385261144431 50.259215232653546)
21041POLYGON((7.4455246925354 48.1211090087892,7.43944358825695 48.1214637756348,7.43944358825695 48.1214637756348,7.42445516586309 48.1040267944336,7.42445516586309 48.1040267944336,7.44019269943237 48.1021919250488,7.44019269943237 48.1021919250488,7.45188140869152 48.1102867126465,7.45188140869152 48.1102867126465,7.4455246925354 48.1211090087892))0.0006POINT(7.439718935224808 48.11078304714628)
43587POLYGON((0.984636425971928 42.9625244140626,0.975698053836879 42.9631309509278,0.970121741294861 42.950969696045,0.970121741294861 42.950969696045,0.975517332553977 42.9391899108887,0.984088122844753 42.9321441650391,0.984088122844753 42.9321441650391,0.99921357631689 42.9575271606446,0.99921357631689 42.9575271606446,0.984636425971928 42.9625244140626))0.0006POINT(0.9825220770306436 42.9495697021485)