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
15690POLYGON((9.05251026153564 46.0077667236329,9.05278968811029 46.0049552917481,9.04094314575201 45.9981231689453,9.03365707397467 45.9953613281251,9.03365707397467 45.9953613281251,9.03546428680414 45.9902381896973,9.03937721252447 45.9920768737792,9.04504489898687 45.9920082092286,9.05166625976562 45.9901809692383,9.05597591400146 45.9875335693361,9.05597591400146 45.9875335693361,9.0704088211059 45.9882812500001,9.0704088211059 45.9882812500001,9.07553577423107 45.9937057495117,9.07553577423107 45.9937057495117,9.07800292968756 45.999568939209,9.07722187042248 46.0041313171387,9.05251026153564 46.0077667236329))0.0006POINT(9.05553974824796 45.99463608685667)
17008POLYGON((14.3694553375245 41.6267509460449,14.3696203231813 41.6208686828613,14.3696203231813 41.6208686828613,14.3758935928345 41.61869430542,14.3823451995851 41.6118850708009,14.388879776001 41.5998039245607,14.3894500732423 41.5952682495118,14.3894500732423 41.5952682495118,14.3952322006226 41.5966682434083,14.414779663086 41.5870895385743,14.429503440857 41.5814208984374,14.4367465972901 41.580177307129,14.4367465972901 41.580177307129,14.4434633255005 41.5804481506348,14.4499998092653 41.5847473144532,14.4487419128418 41.5873985290528,14.4587774276733 41.5909156799316,14.4744415283203 41.5929679870605,14.4865293502808 41.5908508300782,14.4930505752565 41.5913314819337,14.4930505752565 41.5913314819337,14.493260383606 41.5922775268556,14.5027055740358 41.5964965820312,14.5130167007447 41.5974502563476,14.5137424468994 41.6015968322754,14.5105962753295 41.6099205017091,14.5105962753295 41.6099205017091,14.4988355636598 41.6175231933594,14.4988355636598 41.6175231933594,14.4834651947023 41.6198120117188,14.4816999435424 41.6304893493653,14.4800596237183 41.6327590942383,14.4800596237183 41.6327590942383,14.4758949279786 41.6327514648438,14.4427108764648 41.642635345459,14.4281291961671 41.6382904052734,14.4281291961671 41.6382904052734,14.4242334365844 41.6357612609864,14.3984355926514 41.6316223144531,14.3759765625 41.6263046264648,14.3694553375245 41.6267509460449))0.0006POINT(14.445904016494808 41.60822792053226)
14531POLYGON((13.5447435379029 41.5214004516602,13.5444669723511 41.5133628845215,13.5480356216431 41.5118217468262,13.5444850921632 41.4997787475587,13.533254623413 41.4839782714844,13.5293521881104 41.4818077087402,13.5268993377687 41.4822616577148,13.5268993377687 41.4822616577148,13.5105237960815 41.4970130920411,13.4930143356324 41.507625579834,13.4876194000244 41.5067672729493,13.4876194000244 41.5067672729493,13.4917068481445 41.5201034545899,13.4917068481445 41.5201034545899,13.505075454712 41.5167274475098,13.5152635574342 41.5171127319337,13.5321645736694 41.5206298828125,13.5447435379029 41.5214004516602))0.0006POINT(13.518401819116962 41.505266077378245)
65616POLYGON((10.4264354705811 49.7784423828124,10.4280462265015 49.7789115905763,10.4287357330323 49.7824821472169,10.4196910858154 49.7903137207031,10.4226341247559 49.7923736572265,10.4225444793701 49.7961006164551,10.4225444793701 49.7961006164551,10.4180850982666 49.7949180603028,10.4122610092164 49.7953910827637,10.4111680984498 49.792995452881,10.4071521759034 49.7926521301269,10.4064064025879 49.7899780273438,10.4001579284669 49.7878761291505,10.3898344039918 49.7872009277345,10.3893337249757 49.7935256958008,10.3869705200195 49.7938461303712,10.3849887847901 49.7970390319824,10.3886003494263 49.8041839599611,10.3836193084718 49.8059616088867,10.3847417831421 49.8074188232423,10.3802871704102 49.8098907470704,10.376353263855 49.8096961975098,10.3713731765748 49.810905456543,10.3676481246949 49.8103790283204,10.3669214248657 49.8117294311524,10.3648366928101 49.8114471435546,10.3659811019897 49.81001663208,10.3579206466675 49.8091354370118,10.3594827651977 49.807201385498,10.354377746582 49.8082313537598,10.3541879653931 49.8065757751464,10.3488502502443 49.8065948486329,10.3489580154419 49.8075675964355,10.3468999862671 49.807716369629,10.3424263000488 49.8071174621583,10.3386735916138 49.8149681091308,10.3327474594116 49.8158950805664,10.3259639739991 49.815341949463,10.3210201263428 49.8138771057129,10.3198719024658 49.8122482299805,10.3147411346437 49.8123664855957,10.3160305023194 49.8098030090333,10.3148250579834 49.805248260498,10.3162727355956 49.8046836853027,10.3145885467529 49.8017311096192,10.311978340149 49.8009643554688,10.3103914260864 49.8015975952149,10.3105344772339 49.8004112243653,10.3001127243043 49.7998275756836,10.2986011505128 49.7989501953126,10.2970380783081 49.8070182800293,10.30433177948 49.8080673217773,10.3044033050538 49.8110160827637,10.3087911605836 49.812255859375,10.3127021789551 49.8112373352051,10.3130245208741 49.8140983581544,10.3087148666381 49.8138771057129,10.3057537078858 49.8174324035646,10.3042135238648 49.8166236877442,10.30299949646 49.8175201416017,10.3019609451295 49.8198280334473,10.3057174682617 49.8226890563965,10.3035697937012 49.8242874145508,10.3052072525025 49.8252410888672,10.3000469207765 49.8287315368652,10.3000469207765 49.8287315368652,10.2974481582643 49.8282356262208,10.2972021102906 49.8304901123048,10.2907552719117 49.8288421630859,10.2903289794922 49.8277626037598,10.2895460128784 49.8287506103517,10.2869606018066 49.8284225463867,10.2865619659424 49.8274765014648,10.284966468811 49.8295440673829,10.2769002914429 49.8293914794922,10.2761106491089 49.8258094787599,10.272855758667 49.8230781555176,10.2672939300537 49.8229942321777,10.2643918991089 49.8219985961914,10.2593927383423 49.8233718872071,10.2546358108522 49.8209877014161,10.2546358108522 49.8209877014161,10.2575387954712 49.8188972473145,10.25163936615 49.8168334960938,10.2517232894897 49.814136505127,10.2563734054565 49.8156471252442,10.2571439743042 49.8143997192383,10.2554540634156 49.8131904602051,10.2567291259766 49.8113288879396,10.2637596130372 49.812183380127,10.2672367095947 49.8118553161622,10.267840385437 49.8106346130371,10.2701053619385 49.8110427856446,10.2711954116821 49.8096885681152,10.2778253555299 49.8101692199708,10.2754821777344 49.8086967468262,10.2783832550049 49.8067054748536,10.2715349197388 49.8056945800782,10.2714395523071 49.8023834228516,10.2839603424073 49.7999496459962,10.2845449447632 49.7966842651368,10.2845449447632 49.7966842651368,10.2892608642579 49.7957687377931,10.2961664199829 49.7961578369142,10.2960376739502 49.7906074523926,10.2933444976807 49.789981842041,10.293405532837 49.7888031005859,10.2950172424317 49.7887611389161,10.2947435379028 49.7878265380859,10.2931728363038 49.7879371643066,10.2923955917359 49.7845726013184,10.2940225601197 49.7842140197755,10.2939443588257 49.7829818725587,10.3134078979493 49.7766990661621,10.3139305114747 49.7779693603516,10.3170671463013 49.7787475585938,10.3193902969361 49.7780685424804,10.3190622329711 49.7803535461426,10.3174333572387 49.7810096740724,10.3175134658815 49.7819633483888,10.3234376907349 49.780559539795,10.3234376907349 49.780559539795,10.3305053710938 49.7777519226075,10.3356294631959 49.778678894043,10.3492193222046 49.777889251709,10.3492193222046 49.777889251709,10.35080909729 49.7804183959961,10.3540458679199 49.7804222106935,10.3538856506348 49.7829513549805,10.3589668273927 49.7843437194825,10.3585996627808 49.7863121032716,10.3628644943238 49.7866325378419,10.3626642227173 49.7887115478517,10.3647069931031 49.7886772155762,10.3648653030396 49.7867240905763,10.367657661438 49.7868347167968,10.3678026199341 49.7848472595215,10.3709392547608 49.7863273620607,10.3727951049806 49.7831993103028,10.3758087158204 49.7837142944337,10.3754234313965 49.7822647094726,10.3786220550538 49.7813339233398,10.3873643875123 49.7798385620117,10.389183998108 49.7801666259765,10.3896121978761 49.7814331054688,10.395588874817 49.7801513671876,10.3974800109864 49.7794342041016,10.3979473114013 49.7755928039551,10.403027534485 49.7773170471192,10.4069061279298 49.7763214111329,10.407985687256 49.7784996032716,10.4115018844605 49.7776489257814,10.410795211792 49.7766494750977,10.4132690429688 49.7762718200684,10.4264354705811 49.7784423828124))0.0006POINT(10.331699067896094 49.800533938717535)
58628POLYGON((6.45801210403442 51.2478485107423,6.45128679275513 51.2441558837891,6.44330835342407 51.234977722168,6.43898439407349 51.2361602783204,6.43836593627935 51.23095703125,6.43339872360229 51.2309761047364,6.42675924301153 51.2260398864746,6.42689085006708 51.2240638732911,6.41435098648083 51.219337463379,6.37092971801758 51.2174530029297,6.36406803131109 51.2224159240723,6.35972118377691 51.2289581298829,6.34906387329107 51.2276077270509,6.34480285644537 51.2261581420898,6.3445081710816 51.2251319885254,6.33864498138433 51.2241020202638,6.33048725128185 51.2244873046876,6.33017110824585 51.2167167663574,6.33017110824585 51.2167167663574,6.32048988342297 51.2177772521974,6.31497240066534 51.2251319885254,6.31239557266247 51.2245903015137,6.30458879470825 51.2292251586914,6.30219030380243 51.2281951904298,6.30064249038708 51.229305267334,6.30255699157715 51.2327156066895,6.30130815505976 51.2333488464356,6.29951620101934 51.2326889038087,6.29289913177496 51.240550994873,6.29083967208862 51.2497406005861,6.2884192466737 51.2492027282715,6.28809738159191 51.2513122558594,6.28441429138184 51.250602722168,6.28275966644293 51.2548751831056,6.28468608856195 51.2550086975099,6.28561687469494 51.257080078125,6.28447008132946 51.2573699951173,6.28524065017712 51.2582092285156,6.27863502502447 51.2597656250001,6.27600812911993 51.2633552551271,6.27035474777233 51.2672004699708,6.26361083984386 51.2682075500488,6.26361083984386 51.2682075500488,6.26585388183599 51.2714691162111,6.26534891128551 51.2761840820313,6.26819324493408 51.2799453735352,6.2739024162293 51.278953552246,6.27578926086431 51.2832908630371,6.27840280532837 51.2856674194336,6.30717134475708 51.2788963317871,6.32503747940063 51.2789840698242,6.32081651687622 51.2856025695801,6.31479787826544 51.2857284545899,6.31395196914667 51.2882385253907,6.31396150589001 51.293197631836,6.31851530075085 51.2930603027345,6.32124805450445 51.2977905273439,6.31930398941046 51.2983055114747,6.32162761688244 51.3016891479492,6.32008695602417 51.3028221130372,6.32097101211559 51.3038558959962,6.31778669357305 51.3048858642579,6.32097959518444 51.3080368041993,6.31914567947393 51.3097114562989,6.31922960281383 51.3116340637208,6.31922960281383 51.3116340637208,6.32403373718273 51.3138313293457,6.33268022537237 51.3152122497559,6.33549642562866 51.3168258666993,6.34914112091076 51.3197174072267,6.35262107849132 51.3197212219238,6.35323333740246 51.3186721801758,6.36139631271362 51.3212852478028,6.37156867980963 51.3229942321778,6.37751436233515 51.3044624328613,6.38737535476685 51.3054389953613,6.38737535476685 51.3054389953613,6.3976550102235 51.3003692626953,6.40136766433722 51.2996788024902,6.40473318099976 51.2974128723145,6.40773057937633 51.2928314208986,6.41550970077515 51.2892189025879,6.42549610137934 51.2781867980958,6.42549610137934 51.2781867980958,6.41160726547241 51.2739295959473,6.43672227859508 51.2605285644532,6.45801210403442 51.2478485107423))0.0006POINT(6.338050631589718 51.26734254526541)
23765POLYGON((3.48675346374517 46.4704360961915,3.47088432312012 46.4785537719727,3.46477079391474 46.4953269958497,3.45733022689819 46.4989776611328,3.45733022689819 46.4989776611328,3.48588943481445 46.5153656005859,3.50008201599121 46.5126762390137,3.52908396720886 46.5148048400879,3.52908396720886 46.5148048400879,3.55776071548462 46.5116958618165,3.55913877487194 46.4947242736816,3.56585216522222 46.4782485961915,3.56585216522222 46.4782485961915,3.56739711761475 46.4713897705079,3.56739711761475 46.4713897705079,3.55829882621765 46.4687232971191,3.52436733245855 46.4733047485352,3.48675346374517 46.4704360961915))0.0006POINT(3.5204278020297934 46.4910381541533)
19337POLYGON((11.9270544052125 46.6905822753907,11.9206628799438 46.689510345459,11.9096288681031 46.684238433838,11.9090766906739 46.6780967712403,11.9079389572144 46.6758956909181,11.8922338485718 46.6516075134278,11.8826923370362 46.6400222778321,11.8826923370362 46.6400222778321,11.8875370025635 46.637523651123,11.8896780014039 46.6374969482422,11.8970985412598 46.6421432495118,11.9002399444581 46.6422233581544,11.9047889709473 46.6354217529297,11.9177770614624 46.6281623840333,11.9315242767334 46.6258277893068,11.9519300460817 46.6155395507812,11.9530382156372 46.6142120361328,11.9530382156372 46.6142120361328,11.9530382156372 46.6172981262206,11.9554471969604 46.6194343566895,11.9710388183594 46.6272583007814,11.9842729568481 46.6315383911133,11.9914140701295 46.6300277709961,11.9980058670043 46.6268501281738,12.0046024322509 46.6310768127441,12.0047798156739 46.633358001709,12.0013818740845 46.6401901245118,11.97975730896 46.6530113220215,11.9722042083741 46.6592292785646,11.9708757400514 46.6614875793458,11.9651889801025 46.6655311584474,11.9383974075318 46.6810722351074,11.9266481399537 46.6853065490723,11.9270544052125 46.6905822753907))0.0006POINT(11.940475261572669 46.645618438720746)
59678POLYGON((7.19950008392345 47.0513534545898,7.20116996765142 47.0545692443848,7.20819902420055 47.0570259094239,7.20917415618902 47.0600738525392,7.21340990066523 47.062255859375,7.21259498596191 47.0639762878419,7.21259498596191 47.0639762878419,7.20719480514526 47.0692405700684,7.20723581314098 47.0724868774413,7.21080207824713 47.0745773315431,7.21060705184948 47.0766906738281,7.21219587326061 47.0780906677247,7.22729778289789 47.0844993591309,7.22729778289789 47.0844993591309,7.22463083267212 47.0881690979005,7.22051000595098 47.0901527404785,7.2160120010376 47.0953369140626,7.20990991592413 47.0950202941895,7.20502901077276 47.0923690795898,7.20502901077276 47.0923690795898,7.2017297744751 47.0853004455567,7.18817615509039 47.0687065124512,7.18246507644665 47.0664138793945,7.17770385742193 47.0670127868653,7.17770385742193 47.0670127868653,7.1839909553529 47.0634193420411,7.1839909553529 47.0634193420411,7.18600320816046 47.0628662109376,7.19103002548218 47.0644416809082,7.19414615631109 47.0640029907227,7.19631385803234 47.0600090026855,7.19259405136108 47.0573921203613,7.1923937797547 47.0554313659668,7.19422578811657 47.0534248352051,7.19950008392345 47.0513534545898))0.0006POINT(7.202437134350097 47.070752536549314)
58366POLYGON((8.35017395019537 49.7443275451661,8.34322261810303 49.7449951171876,8.34267711639416 49.7469100952149,8.32195949554455 49.7492065429689,8.30256366729736 49.7465820312501,8.28653907775885 49.7462005615236,8.28653907775885 49.7462005615236,8.28659343719494 49.7477111816407,8.28794860839844 49.7478370666503,8.28730583190918 49.7491302490234,8.28730583190918 49.7491302490234,8.28599262237555 49.7528648376465,8.296220779419 49.7549018859863,8.29287719726562 49.7616844177247,8.29575347900391 49.7673950195312,8.30042839050287 49.7672691345216,8.30083656311041 49.7707710266113,8.30083656311041 49.7707710266113,8.30102729797369 49.7726554870605,8.30946159362793 49.7738990783692,8.3081455230714 49.7792358398438,8.31061458587646 49.7799491882325,8.30954837799078 49.781665802002,8.31202316284174 49.7822647094726,8.31241130828857 49.7831993103028,8.31241130828857 49.7831993103028,8.31563186645519 49.784206390381,8.31563186645519 49.784206390381,8.33577346801763 49.7836112976075,8.33610057830811 49.7852821350098,8.33995151519787 49.7840385437013,8.34006023406982 49.7829017639161,8.34820842742931 49.7832717895508,8.35454940795893 49.7818412780762,8.35454940795893 49.7818412780762,8.35001277923595 49.7791824340821,8.34927082061768 49.7771530151367,8.34905529022217 49.7717742919921,8.35086822509766 49.7716293334961,8.35017395019537 49.7443275451661))0.0006POINT(8.317207214159879 49.76797172350765)
73845POLYGON((13.7926177978516 45.351360321045,13.7837467193605 45.3551902770997,13.7591323852538 45.3548164367677,13.7482709884645 45.3569984436036,13.7405147552491 45.359832763672,13.7360134124756 45.3601150512695,13.7185888290406 45.3556289672853,13.7028532028199 45.3529930114747,13.6942911148071 45.3470497131348,13.6888122558594 45.3405685424806,13.6888122558594 45.3405685424806,13.701813697815 45.3322792053224,13.7085027694703 45.3293418884278,13.7103385925294 45.327522277832,13.7137031555176 45.3138122558594,13.711986541748 45.3061141967773,13.711986541748 45.3061141967773,13.745285987854 45.3069686889649,13.7489461898805 45.3054733276368,13.7525415420532 45.300449371338,13.7590894699097 45.2988815307617,13.7741212844848 45.2997550964355,13.7823762893677 45.302532196045,13.7823762893677 45.302532196045,13.781886100769 45.3114166259767,13.7833499908448 45.3173446655273,13.7815170288087 45.3246994018555,13.7842674255371 45.3327903747559,13.7842674255371 45.3327903747559,13.7917308807373 45.3427658081055,13.7926177978516 45.351360321045))0.0006POINT(13.745458030700714 45.32895685831712)