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.

Spaltenname	Datentyp	Mögliche Werte	Beschreibung
id_ort	int(10) unsigned	beliebig	Fremdschlü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"	beliebig	Die simplifizierten Geodaten.
epsilon	float(5,4)	beliebig	Die 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"	beliebig	Der geometrische Mittelpunkt des vereinfachten Polygons.

Ausschnitt

id_ort	geodaten	epsilon	mittelpunkt
13691	POLYGON((14.2990818023682 40.9295234680176,14.2993059158326 40.9256706237794,14.3080463409424 40.9104232788085,14.3154315948487 40.9045982360839,14.3195676803588 40.9024810791016,14.3275413513184 40.9049301147461,14.3303375244142 40.9017066955568,14.3316669464112 40.8982200622559,14.3316669464112 40.8982200622559,14.3353366851808 40.900318145752,14.3373098373414 40.907398223877,14.3361196517944 40.9118766784668,14.3384008407593 40.9152908325196,14.3457136154174 40.9218864440919,14.3557329177856 40.9240531921386,14.3557329177856 40.9240531921386,14.3624753952028 40.9315032958985,14.357502937317 40.9383697509766,14.357502937317 40.9383697509766,14.3522310256957 40.9356460571289,14.3499965667725 40.9407234191895,14.3500137329101 40.9424781799317,14.352237701416 40.942222595215,14.3513193130494 40.9439277648926,14.3470001220703 40.9470672607422,14.3433704376222 40.9478187561036,14.3179578781128 40.9477233886719,14.3126258850098 40.9418678283692,14.3080520629882 40.9429740905762,14.3045082092286 40.9458923339843,14.3045082092286 40.9458923339843,14.3069181442261 40.9402694702149,14.3019275665284 40.9348983764648,14.2992334365845 40.9311218261719,14.2990818023682 40.9295234680176))	0.0006	POINT(14.330775709713238 40.927041670855374)
1402664	POLYGON((-6.13437795639032 41.1903839111329,-6.14343500137323 41.1977806091309,-6.16416788101196 41.2076530456544,-6.17831516265863 41.2087211608887,-6.19290113449097 41.2151260375977,-6.18496513366699 41.2219009399414,-6.18197488784784 41.2283782958984,-6.17978715896606 41.2282791137696,-6.17466115951538 41.231761932373,-6.16383123397821 41.234058380127,-6.15382480621332 41.2418289184571,-6.14833307266224 41.2533874511719,-6.13979721069336 41.2617874145508,-6.12564182281494 41.2727813720704,-6.12464094161987 41.2720832824708,-6.12184476852406 41.2772903442383,-6.12610721588135 41.263298034668,-6.10584688186634 41.2392921447755,-6.10563278198237 41.2332649230957,-6.10181283950806 41.2248497009277,-6.10918903350824 41.2126121520997,-6.12102603912354 41.2037239074707,-6.12413692474365 41.202938079834,-6.12623214721674 41.1966209411621,-6.13437795639032 41.1903839111329))	0.0006	POINT(-6.143020133177402 41.229991753896115)
20947	POLYGON((7.12530136108398 47.6538124084473,7.12258100509655 47.6584777832031,7.12258100509655 47.6584777832031,7.11910390853888 47.6680374145508,7.11910390853888 47.6680374145508,7.12456464767456 47.6760101318359,7.12456464767456 47.6760101318359,7.13071250915527 47.6687278747559,7.13071250915527 47.6687278747559,7.14135932922369 47.6621856689454,7.16447114944469 47.6571083068848,7.16447114944469 47.6571083068848,7.14227247238159 47.6505889892579,7.14227247238159 47.6505889892579,7.12530136108398 47.6538124084473))	0.0006	POINT(7.133862291063626 47.66242136274069)
49817	POLYGON((3.40371489524841 49.8059082031249,3.4311306476593 49.7925682067872,3.4311306476593 49.7925682067872,3.43148255348217 49.7865753173829,3.42246842384338 49.7839202880861,3.42246842384338 49.7839202880861,3.4138462543487 49.7867431640626,3.4138462543487 49.7867431640626,3.4005720615387 49.7998809814454,3.40371489524841 49.8059082031249))	0.0006	POINT(3.4189622402191153 49.79098086886945)
48284	POLYGON((-0.916727900505009 47.4020729064942,-0.905760586261749 47.3911209106446,-0.906667172908669 47.3711547851564,-0.906667172908669 47.3711547851564,-0.839265227317753 47.3714637756347,-0.824896812438965 47.3614196777345,-0.810096144676208 47.3638801574707,-0.810096144676208 47.3638801574707,-0.81494635343546 47.3733215332031,-0.834960103034916 47.382682800293,-0.83401083946228 47.3885192871095,-0.83401083946228 47.3885192871095,-0.844053983688241 47.3934669494629,-0.844053983688241 47.3934669494629,-0.89209508895874 47.4054412841797,-0.916727900505009 47.4020729064942))	0.0006	POINT(-0.8545538902282259 47.38143768310552)
69072	POLYGON((14.2065467834473 50.9771842956543,14.2057962417604 50.978687286377,14.2078151702881 50.9798393249512,14.2076311111451 50.9814682006836,14.2148933410644 50.9848289489747,14.2144155502319 50.9863510131837,14.2163362503052 50.9876937866212,14.2222270965576 50.9878196716309,14.222532272339 50.9898452758789,14.2204504013063 50.9905891418458,14.2227249145508 50.9945602416993,14.2377815246581 50.9929161071778,14.2444648742676 50.9887008666992,14.2511777877808 50.9885749816895,14.255976676941 50.9872055053712,14.25852394104 50.9879875183105,14.25852394104 50.9879875183105,14.2631120681764 50.9864349365234,14.2628955841064 50.9853973388673,14.2761259078979 50.9827613830567,14.2794437408448 50.9809150695802,14.2822093963624 50.977725982666,14.2857751846313 50.9769973754884,14.2877264022828 50.9780044555664,14.2989006042481 50.9792175292969,14.3114080429078 50.9846649169922,14.3235540390015 50.9853630065918,14.3297281265259 50.9822006225586,14.3265581130981 50.9805908203126,14.3260583877563 50.9778213500977,14.3290700912476 50.9745445251465,14.3284235000611 50.9735069274902,14.3254776000977 50.9721641540527,14.3202085494995 50.9721221923828,14.316565513611 50.9732780456544,14.3129568099977 50.9722595214843,14.3086233139038 50.9681625366212,14.3052263259888 50.9672470092775,14.3025588989258 50.9653320312501,14.3065633773804 50.9628562927246,14.3169116973877 50.9606704711914,14.3172426223755 50.9579200744629,14.3107481002809 50.9552803039551,14.311707496643 50.9537620544434,14.3253679275513 50.9497184753418,14.3343219757081 50.948989868164,14.3392152786256 50.9498748779297,14.3457965850831 50.9485664367676,14.3474140167236 50.9480209350587,14.3465871810913 50.9469184875489,14.3493204116821 50.945140838623,14.3558835983276 50.9446563720703,14.3610696792604 50.9427185058594,14.3605222702027 50.9414482116699,14.3694753646851 50.9421768188477,14.369158744812 50.9394912719727,14.3731746673585 50.9382400512696,14.385887145996 50.940528869629,14.3873224258423 50.9418144226075,14.4009780883789 50.933277130127,14.3993892669678 50.9308242797853,14.4001302719117 50.9286193847656,14.4012794494629 50.9280395507812,14.4005126953126 50.9268836975098,14.4021434783936 50.9240722656251,14.3946714401246 50.9209823608398,14.3916177749633 50.9206771850587,14.3945302963257 50.9191398620605,14.3941488265992 50.9181518554688,14.3888759613037 50.9188652038575,14.3897047042847 50.9166603088378,14.3856430053712 50.916488647461,14.3867321014405 50.9145240783693,14.3860836029053 50.912223815918,14.3877592086793 50.9113006591797,14.387137413025 50.9101676940917,14.3883981704712 50.9095687866211,14.3886089324952 50.9081726074218,14.38724899292 50.9033279418946,14.386082649231 50.9028434753419,14.3880214691163 50.9011459350586,14.3876352310181 50.8990898132325,14.3752937316894 50.8978614807129,14.3741464614868 50.8962326049805,14.3627948760987 50.897647857666,14.3583812713623 50.8995666503907,14.356671333313 50.898365020752,14.354609489441 50.8984146118165,14.3521223068238 50.899341583252,14.3518838882447 50.9004249572755,14.3492736816406 50.9007263183593,14.3486299514771 50.9003601074219,14.349630355835 50.8991813659669,14.3485488891602 50.8974800109864,14.3503370285034 50.8956756591797,14.3482131958008 50.8925704956055,14.34397315979 50.8928031921388,14.336522102356 50.890209197998,14.3337621688844 50.8905982971192,14.3193645477295 50.8887405395508,14.3128547668458 50.8869972229004,14.3128547668458 50.8869972229004,14.3050537109375 50.8948745727539,14.3026390075684 50.8953170776368,14.297869682312 50.8986625671387,14.297176361084 50.9018554687501,14.298394203186 50.903678894043,14.2960653305054 50.9048271179199,14.2987546920778 50.9077415466309,14.29847240448 50.9098663330079,14.2941465377808 50.9115142822266,14.2917547225953 50.9138069152832,14.2915973663331 50.9151992797853,14.2878942489625 50.9173202514648,14.2869739532471 50.9214210510253,14.2813196182252 50.924446105957,14.2685384750367 50.928020477295,14.2681808471681 50.9318809509278,14.2667646408081 50.9339256286622,14.2643833160402 50.9348068237305,14.2561368942261 50.9338455200196,14.2537412643434 50.9310226440431,14.2511529922486 50.9305763244628,14.2477016448976 50.9284362792969,14.2422161102294 50.9281158447266,14.2396173477172 50.9259452819825,14.2297039031983 50.9255104064942,14.2217903137207 50.9263648986818,14.2190713882446 50.9255256652833,14.2172231674195 50.9264755249023,14.2155466079713 50.9295654296875,14.2107152938844 50.9285125732422,14.2051868438721 50.9308700561523,14.2015523910524 50.9292640686035,14.1984720230103 50.9297943115235,14.1943969726562 50.9289169311525,14.1900711059571 50.9293785095216,14.187659263611 50.9305992126465,14.1846342086793 50.9275054931641,14.1741580963136 50.9262580871582,14.1644611358644 50.92728805542,14.16224193573 50.9289703369141,14.16224193573 50.9289703369141,14.1584482192994 50.9356460571289,14.1622047424318 50.9368171691896,14.1634731292725 50.9386138916016,14.1631088256835 50.9401397705079,14.1631088256835 50.9401397705079,14.1690568923951 50.9423408508301,14.1758565902709 50.9417724609375,14.177514076233 50.9434318542481,14.1777572631837 50.9457855224609,14.1794347763063 50.9469833374024,14.1809568405151 50.9469375610352,14.1831684112548 50.9447937011718,14.1874179840088 50.9440727233888,14.192668914795 50.9460868835449,14.194483757019 50.9482803344727,14.1960449218751 50.9480171203614,14.1970825195312 50.9461822509766,14.1999206542968 50.9454689025879,14.2026147842407 50.9458084106445,14.2040109634399 50.9477615356446,14.2071065902711 50.9490242004396,14.2102508544922 50.9478530883789,14.2110557556153 50.9488258361817,14.2106218338013 50.9517784118652,14.2145643234253 50.953109741211,14.2128839492799 50.9547424316406,14.2134523391724 50.9554328918457,14.2211284637452 50.9550971984864,14.2230348587037 50.9569931030273,14.2279806137085 50.9580154418945,14.2252664566041 50.9593887329102,14.2266616821289 50.9620208740234,14.221594810486 50.9630470275879,14.2223663330079 50.9641304016114,14.2264814376832 50.9647483825684,14.2276515960694 50.9658164978028,14.2258501052856 50.9675407409669,14.2284832000732 50.967456817627,14.2261810302736 50.9702453613282,14.2229509353638 50.971420288086,14.2230367660522 50.9724884033203,14.2172412872315 50.9744110107422,14.2131099700928 50.9743270874025,14.2074251174928 50.9760398864746,14.2065467834473 50.9771842956543))	0.0006	POINT(14.280009096319052 50.94106362082742)
42212	POLYGON((6.42437791824341 48.8030166625978,6.41737461090099 48.7951316833496,6.39423370361339 48.7910842895508,6.39423370361339 48.7910842895508,6.38874387741083 48.7806091308594,6.38874387741083 48.7806091308594,6.3948740959168 48.7747611999512,6.3948740959168 48.7747611999512,6.4331102371217 48.7891006469726,6.4331102371217 48.7891006469726,6.42915487289429 48.8018798828124,6.42437791824341 48.8030166625978))	0.0006	POINT(6.408439202742193 48.7882853421298)
72175	POLYGON((14.7275705337524 48.2890853881837,14.7038612365723 48.2802391052247,14.6874046325684 48.2649154663087,14.6874046325684 48.2649154663087,14.6921443939208 48.2490272521974,14.6921443939208 48.2490272521974,14.7170314788819 48.2530021667482,14.7236728668214 48.2532424926758,14.728856086731 48.2513122558594,14.7469959259033 48.2413520812989,14.7469959259033 48.2413520812989,14.7626733779907 48.2394065856934,14.7626733779907 48.2394065856934,14.7707443237306 48.2439117431641,14.7833786010742 48.2382583618163,14.7854919433594 48.2401123046876,14.789137840271 48.246120452881,14.789137840271 48.246120452881,14.7645692825319 48.260326385498,14.7641105651856 48.2634735107422,14.7663574218751 48.2710304260254,14.7663574218751 48.2710304260254,14.7385349273682 48.3030281066895,14.7385349273682 48.3030281066895,14.7275705337524 48.2890853881837))	0.0006	POINT(14.743157664934822 48.25844685236618)
70937	POLYGON((11.2309484481812 50.3569869995117,11.228048324585 50.3533973693849,11.2275676727295 50.3511886596681,11.2261409759521 50.3507652282715,11.2264595031738 50.3468589782715,11.2191858291626 50.3447723388672,11.2163505554199 50.3459854125977,11.20880317688 50.343433380127,11.2000389099122 50.3372383117676,11.1989698410034 50.3336296081543,11.1950969696045 50.3293876647949,11.1870584487916 50.3256301879884,11.1831703186035 50.3221397399902,11.1801881790161 50.320957183838,11.1586933135986 50.3224868774414,11.1592884063721 50.3238220214844,11.1762542724609 50.3221549987793,11.1584854125977 50.3247108459473,11.1584854125977 50.3247108459473,11.1581773757936 50.3237762451172,11.1560888290406 50.3241844177247,11.1547746658325 50.3227043151855,11.1536331176759 50.3228302001953,11.151912689209 50.3210716247559,11.1432285308839 50.3190612792969,11.1348276138305 50.3140525817872,11.1317548751832 50.3080863952637,11.1317405700684 50.3038749694824,11.1331586837768 50.3001785278321,11.1376571655273 50.2997245788575,11.1402673721314 50.2948532104493,11.139726638794 50.2929649353027,11.1431970596315 50.2933769226074,11.1415567398071 50.2891921997071,11.1459226608278 50.2849578857422,11.1514787673951 50.2859878540038,11.1537675857545 50.2835426330567,11.1547966003418 50.2840843200684,11.1562299728393 50.2877578735352,11.1584796905519 50.2892036437988,11.160291671753 50.2861251831056,11.1655044555663 50.2823448181153,11.1718406677247 50.2835464477539,11.1773099899293 50.2810935974122,11.1837100982666 50.2808952331544,11.181022644043 50.2766189575196,11.1799697875978 50.2766494750976,11.1794080734253 50.2753906250001,11.1773014068604 50.2761917114258,11.1755304336548 50.2743911743164,11.1739702224733 50.2712783813478,11.1754875183107 50.2698287963867,11.1754875183107 50.2698287963867,11.182378768921 50.2703857421875,11.1871395111085 50.2695541381837,11.1886510849 50.2711486816406,11.1899433135987 50.2711868286133,11.1899433135987 50.2711868286133,11.1913442611695 50.2740707397462,11.1893939971923 50.2748222351075,11.1915273666382 50.2774391174317,11.1901998519898 50.278133392334,11.1900701522828 50.2814483642578,11.1939764022827 50.2857933044434,11.1939764022827 50.2857933044434,11.1899385452271 50.2862281799318,11.1875562667847 50.2877807617188,11.1874637603761 50.2888793945312,11.1839818954467 50.2899475097657,11.1878423690796 50.2936935424805,11.1923227310181 50.2936668395997,11.1921977996826 50.2947120666504,11.195489883423 50.2950859069824,11.1967964172364 50.29891204834,11.1953763961792 50.3016357421874,11.1955709457399 50.30672454834,11.2043600082399 50.3068389892578,11.2109012603761 50.3057746887207,11.2121686935425 50.3084793090821,11.2135515213013 50.3088417053223,11.2136592864991 50.3113327026368,11.2191619873047 50.3121795654297,11.2233877182007 50.3144302368164,11.2242345809936 50.3182868957521,11.2131452560425 50.3182106018067,11.220458984375 50.3241043090821,11.2224397659303 50.3267974853517,11.226879119873 50.3284797668457,11.227788925171 50.3300323486329,11.2358531951904 50.3288650512696,11.247218132019 50.3302307128907,11.2546415328981 50.3338088989259,11.2589540481567 50.3344917297364,11.261384010315 50.3317832946778,11.261384010315 50.3317832946778,11.262456893921 50.3354949951172,11.2613286972046 50.3379135131836,11.2613286972046 50.3379135131836,11.2604923248292 50.3392066955567,11.2576570510865 50.3403854370117,11.2584543228149 50.3418464660645,11.2570066452026 50.3427925109863,11.2568454742432 50.3450241088868,11.2598323822023 50.3474884033204,11.2570762634278 50.3482513427735,11.2608232498169 50.3509979248048,11.2607192993164 50.353229522705,11.2579889297486 50.3550148010254,11.2575683593751 50.3566169738771,11.2527961730957 50.3581771850587,11.2454214096069 50.3534660339355,11.2341842651367 50.3561668395997,11.2344970703126 50.3536720275879,11.2333745956422 50.3538513183595,11.2330045700074 50.3562622070313,11.2309484481812 50.3569869995117))	0.0006	POINT(11.199008311396096 50.31257964424466)
35220	POLYGON((9.30909538269043 41.832145690918,9.32705593109131 41.8358078002931,9.33633995056152 41.8438110351563,9.34885692596436 41.8483467102052,9.35409355163574 41.8542137145997,9.37732887268072 41.8660774230958,9.38671874999994 41.8663902282715,9.40226936340332 41.8587074279785,9.40208435058599 41.8593063354493,9.40208435058599 41.8593063354493,9.40375137329113 41.8601379394531,9.40541744232178 41.8579177856446,9.40513896942139 41.8562507629395,9.40291595458996 41.8565292358398,9.40208435058599 41.8556938171387,9.40291595458996 41.8548622131348,9.40152835845953 41.8531951904298,9.40097236633306 41.8498611450196,9.40458202362061 41.8423614501953,9.40319442749035 41.84041595459,9.40430355072021 41.8393058776856,9.40541744232178 41.8281936645509,9.40652656555181 41.8268051147462,9.40652656555181 41.8254165649414,9.40485954284668 41.8245849609376,9.40652656555181 41.8240280151368,9.40652656555181 41.8170852661133,9.40430355072021 41.8162498474122,9.40263843536388 41.8123626708986,9.40124988555914 41.8118057250978,9.40152835845953 41.8093070983887,9.39930629730225 41.8059730529786,9.39958190917974 41.8009719848633,9.3976402282716 41.7995834350587,9.39569377899176 41.8006935119629,9.3945837020874 41.7990264892579,9.39624977111828 41.7949028015138,9.3973598480224 41.7948608398437,9.39708423614513 41.7909736633301,9.39986228942871 41.7901382446289,9.4004163742066 41.7890281677247,9.4004163742066 41.7865295410156,9.3973598480224 41.783473968506,9.39902782440186 41.7823600769042,9.39902782440186 41.7809715270997,9.39847183227539 41.7779159545898,9.39597225189215 41.7768058776857,9.39569377899176 41.7748603820801,9.39652824401861 41.7736663818361,9.39652824401861 41.7736663818361,9.38152408599859 41.7666015625001,9.36300468444836 41.7650833129884,9.35283470153814 41.7764854431152,9.33724594116211 41.7841110229493,9.31490802764904 41.7804679870605,9.27739048004156 41.7942199707032,9.27243423461914 41.8077354431152,9.27243423461914 41.8077354431152,9.27724361419678 41.8136482238769,9.29390144348145 41.8195114135742,9.30909538269043 41.832145690918))	0.0006	POINT(9.380476029713986 41.816308085123744)

Tabelle polygone_vereinfacht(↩ zurück zur Übersicht)

geometry

point