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 |
---|---|---|---|
36018 | POLYGON((6.24593162536627 46.8721618652345,6.25069332122803 46.873119354248,6.25695323944097 46.8821601867676,6.26635408401489 46.8841819763184,6.26947546005255 46.8905906677247,6.26947546005255 46.8905906677247,6.24461221694941 46.9113082885743,6.20260715484631 46.9292068481446,6.20260715484631 46.9292068481446,6.19951009750366 46.9271049499512,6.18681621551525 46.9288711547851,6.18471479415905 46.9262542724609,6.18471479415905 46.9262542724609,6.21594095230108 46.9156455993652,6.23034334182745 46.9064369201661,6.2353601455689 46.8968887329102,6.22539567947382 46.881462097168,6.22539567947382 46.881462097168,6.24593162536627 46.8721618652345)) | 0.0006 | POINT(6.2276056342655215 46.902939266628714) |
52472 | POLYGON((0.175702080130577 45.8988037109376,0.170250818133411 45.8898582458496,0.162340745329857 45.8863525390625,0.157876819372291 45.8770828247071,0.157876819372291 45.8770828247071,0.158641487360057 45.8705062866211,0.169855654239768 45.8641319274902,0.169855654239768 45.8641319274902,0.184779971838054 45.8678817749024,0.184779971838054 45.8678817749024,0.187548443675098 45.8778343200684,0.187548443675098 45.8778343200684,0.187119603157157 45.8907928466797,0.178158655762729 45.8936767578126,0.178158655762729 45.8936767578126,0.175702080130577 45.8988037109376)) | 0.0006 | POINT(0.1740329215924626 45.87983525594079) |
37812 | POLYGON((1.29890108108526 49.2975158691407,1.30335712432861 49.3016510009766,1.30335712432861 49.3016510009766,1.30463039875036 49.3118629455566,1.30086219310772 49.3181304931641,1.30086219310772 49.3181304931641,1.29645717144012 49.3219985961915,1.29645717144012 49.3219985961915,1.28744971752172 49.3215217590333,1.27727544307709 49.3279838562013,1.27727544307709 49.3279838562013,1.25530743598938 49.3214378356934,1.25530743598938 49.3214378356934,1.28867542743677 49.2965888977051,1.29890108108526 49.2975158691407)) | 0.0006 | POINT(1.2890125257628535 49.31499235970639) |
58831 | POLYGON((7.90625715255743 51.3750381469728,7.90582370758068 51.3766021728517,7.90343904495239 51.3778190612794,7.90235900878912 51.3801345825196,7.89845275878906 51.3817939758301,7.89948463439941 51.3828811645509,7.89635181427008 51.3853607177736,7.89685678482061 51.3863525390625,7.8908491134643 51.3902969360353,7.89353084564215 51.392490386963,7.89353084564215 51.392490386963,7.88770866394043 51.3921356201172,7.88617181777948 51.3903198242189,7.88104104995733 51.3919792175293,7.87726831436157 51.3912620544434,7.87153100967407 51.3969879150392,7.86955928802502 51.396484375,7.87089252471924 51.3953170776367,7.86986017227179 51.3949966430665,7.86787796020513 51.3961944580079,7.86481142044079 51.395206451416,7.86418914794928 51.3967781066895,7.84598064422619 51.3891105651855,7.84598064422619 51.3891105651855,7.84760761260981 51.3860969543457,7.85303831100464 51.3824806213379,7.85411930084234 51.3799514770508,7.84909868240368 51.3742103576661,7.84507083892822 51.3727149963379,7.83924770355236 51.3617362976075,7.83580827713013 51.3585510253906,7.83015584945684 51.3568382263185,7.82712554931641 51.3520698547364,7.81718921661383 51.3493843078614,7.81173896789551 51.34916305542,7.80423450469976 51.3467025756836,7.80344057083124 51.345287322998,7.79615497589111 51.3442573547364,7.79507255554205 51.3391990661621,7.79893779754639 51.3343200683594,7.79708480834961 51.3338088989258,7.79660654068005 51.3319244384767,7.78665685653698 51.3298034667969,7.78383493423456 51.3274612426758,7.7789826393128 51.3285903930664,7.77636384963984 51.32670211792,7.77597379684448 51.3233451843262,7.77274990081787 51.3183364868165,7.77274990081787 51.3183364868165,7.77447557449347 51.3146667480469,7.77306413650513 51.3110847473146,7.77393293380749 51.3095130920411,7.77730703353882 51.3080787658691,7.77742147445673 51.3063888549806,7.7804999351502 51.3070373535156,7.78491115570063 51.3055534362794,7.79989862442022 51.3059272766114,7.80330514907831 51.303924560547,7.805498123169 51.3013038635254,7.81940174102783 51.2951011657715,7.82592678070068 51.2979698181152,7.82677745819086 51.2964324951172,7.83050441741943 51.2987785339356,7.8344078063966 51.2978324890137,7.83522033691412 51.2986793518068,7.83781814575207 51.2982063293458,7.83939743041992 51.3006973266601,7.84007215499884 51.2999572753906,7.84462976455688 51.3033561706544,7.84462022781378 51.3055152893068,7.84678506851191 51.3055839538574,7.84754562377941 51.3008575439454,7.84853219985962 51.3011856079102,7.849277496338 51.2999610900879,7.85921382904058 51.3007431030273,7.8597493171693 51.2996635437012,7.8659925460816 51.300983428955,7.86848831176763 51.2982749938966,7.87089586257935 51.2983665466309,7.87193775177008 51.2941932678223,7.87615633010864 51.2950019836426,7.87536430358892 51.2927780151368,7.88049793243414 51.2933959960939,7.88161516189575 51.2919349670411,7.88639593124401 51.2914390563966,7.88629102706903 51.2902488708497,7.89133071899414 51.2910079956055,7.89761114120489 51.2896270751954,7.91343402862549 51.2921638488771,7.91343402862549 51.2921638488771,7.91815614700323 51.2970657348634,7.91474199295038 51.2998199462891,7.91711711883551 51.3017692565918,7.91648054122925 51.3031349182129,7.90393829345697 51.3034706115722,7.90043783187878 51.304931640625,7.90073490142817 51.3057746887207,7.90527629852301 51.3087844848633,7.91696691513062 51.3106002807618,7.92361640930187 51.3172912597656,7.93544006347656 51.3198623657227,7.93350648880016 51.3238792419433,7.92826128005993 51.3251876831055,7.93044710159313 51.3279800415038,7.93108129501343 51.3315620422363,7.93270874023449 51.3340721130372,7.93105173110973 51.3364677429199,7.92566108703619 51.3405990600586,7.91999530792242 51.3406448364258,7.91700220108038 51.3432693481445,7.91828584671021 51.3444786071777,7.91709423065191 51.3452148437501,7.91362953186041 51.3465003967286,7.91137552261358 51.3454322814941,7.90650939941412 51.3473510742188,7.90659952163702 51.3495750427247,7.91138410568243 51.3524360656739,7.91237449646002 51.3542480468751,7.90899085998535 51.3589363098146,7.90905094146734 51.362720489502,7.90658044815058 51.3631782531738,7.90559148788458 51.3684768676758,7.90766763687134 51.3729782104493,7.90625715255743 51.3750381469728)) | 0.0006 | POINT(7.863384122771011 51.33562348528608) |
39175 | POLYGON((4.12574720382702 44.0314674377443,4.13858222961431 44.0319557189941,4.14511013031 44.0277481079103,4.14511013031 44.0277481079103,4.13759422302257 44.0124702453613,4.13759422302257 44.0124702453613,4.11406278610229 44.0055961608887,4.11406278610229 44.0055961608887,4.11113309860241 44.0056343078613,4.11113309860241 44.0056343078613,4.10985136032104 44.0064201354981,4.10985136032104 44.0064201354981,4.10768938064575 44.0158119201661,4.10768938064575 44.0158119201661,4.11661052703857 44.0172348022462,4.11836051940929 44.0301513671876,4.11836051940929 44.0301513671876,4.12574720382702 44.0314674377443)) | 0.0006 | POINT(4.1216789974886225 44.016960144043026) |
36308 | POLYGON((5.80723619461065 47.6937294006348,5.82428598403931 47.6985321044922,5.82649087905895 47.7046394348146,5.82649087905895 47.7046394348146,5.85654115676886 47.7001991271973,5.87510824203491 47.7055549621583,5.87510824203491 47.7055549621583,5.87019300460827 47.6972885131837,5.87391567230236 47.6918563842773,5.87391567230236 47.6918563842773,5.86431312561035 47.6896591186525,5.85690355300898 47.6805839538575,5.85690355300898 47.6805839538575,5.8486700057984 47.6770019531251,5.82911443710339 47.6758995056152,5.8067479133606 47.6821746826172,5.8067479133606 47.6821746826172,5.80723619461065 47.6937294006348)) | 0.0006 | POINT(5.845805084004165 47.69187815049121) |
39848 | POLYGON((3.29156780242926 44.2059288024903,3.28765773773199 44.1998100280762,3.26418757438671 44.2002563476562,3.23926115036016 44.1906623840333,3.23926115036016 44.1906623840333,3.22631311416637 44.1905899047852,3.22631311416637 44.1905899047852,3.23116326332104 44.1958541870117,3.21921133995056 44.2045021057128,3.21921133995056 44.2045021057128,3.23054003715527 44.2303390502931,3.23054003715527 44.2303390502931,3.23077750206005 44.2333183288574,3.23077750206005 44.2333183288574,3.235090494156 44.2318344116212,3.2368690967561 44.235034942627,3.25005531311047 44.238624572754,3.26148295402527 44.2487487792969,3.27465891838074 44.2465934753419,3.29077458381647 44.2587471008301,3.29077458381647 44.2587471008301,3.31118535995489 44.2510795593262,3.32898855209351 44.2394485473634,3.32827997207647 44.2359886169434,3.315583229065 44.2311820983888,3.31094264984137 44.2250633239747,3.29690980911266 44.222484588623,3.29156780242926 44.2059288024903)) | 0.0006 | POINT(3.2629028956096016 44.223120371500684) |
30723 | POLYGON((-1.09299325942987 47.9875068664552,-1.07871377468103 47.9844093322754,-1.07871377468103 47.9844093322754,-1.07910513877869 47.9975051879884,-1.06926488876343 48.0050277709961,-1.06715083122248 48.0114212036134,-1.07828998565674 48.0176010131836,-1.08797502517695 48.0186614990235,-1.08797502517695 48.0186614990235,-1.11667740345001 48.03178024292,-1.13148927688599 48.0316963195801,-1.13148927688599 48.0316963195801,-1.13044488430023 48.0212440490724,-1.10845625400543 48.0065307617188,-1.10417044162745 48.0000953674318,-1.09431803226471 47.9976997375488,-1.09299325942987 47.9875068664552)) | 0.0006 | POINT(-1.0960767045616864 48.009121656417896) |
1405964 | POLYGON((-0.080025002360287 38.5961227416993,-0.084806002676487 38.6036300659181,-0.084022000432014 38.6062774658204,-0.078028000891209 38.6062889099121,-0.081050001084748 38.6201133728028,-0.076291002333164 38.625545501709,-0.077720001339912 38.6274070739747,-0.069288000464439 38.6384849548339,-0.061524998396521 38.6538848876953,-0.062801003456002 38.6580429077148,-0.059990998357534 38.6647033691406,-0.055810999125185 38.6595726013184,-0.046496000140849 38.6586685180664,-0.044344998896065 38.6609954833985,0.007304999977407 38.6376571655273,0.007046998944247 38.6347808837891,0.010157999582702 38.6328277587892,0.010573000647128 38.6315269470215,0.006250001024512 38.6298599243164,0.005971999839062 38.6281929016113,0.003749999916181 38.6301383972168,0.000971000001357 38.6301383972168,0.000417000002926 38.6279182434083,-0.004027000162694 38.6281929016113,-0.0045830002054 38.6298599243164,-0.005973000079393 38.6304168701172,-0.010417998768389 38.6273612976075,-0.015693999826851 38.6265258789064,-0.023194000124818 38.620418548584,-0.028194999322238 38.6187515258789,-0.031527001410723 38.6156959533692,-0.031250998377743 38.6140289306641,-0.032361000776291 38.6137504577637,-0.032361000776291 38.6126403808593,-0.035417001694441 38.6112518310548,-0.040415998548269 38.6037483215333,-0.043471999466362 38.6023597717286,-0.044027999043408 38.6009712219238,-0.045416001230478 38.6006927490235,-0.052639000117722 38.5934715270996,-0.05347299948329 38.5915260314943,-0.051807001233101 38.5901374816895,-0.052361000329199 38.5876388549806,-0.053750999271813 38.5868072509766,-0.053238000720626 38.5898628234863,-0.054304998368025 38.5901374816895,-0.055417001247406 38.58736038208,-0.057916998863163 38.5876388549806,-0.059583000838757 38.5859718322755,-0.062360998243093 38.5809707641601,-0.06347099691618 38.5766601562501,-0.074355997145176 38.5858726501465,-0.074139997363091 38.5886421203614,-0.080025002360287 38.5961227416993)) | 0.0006 | POINT(-0.040696377357987264 38.615889495273834) |
25521 | POLYGON((2.90109539031982 48.361053466797,2.89998865127558 48.3680686950684,2.93685293197638 48.3878860473633,2.93685293197638 48.3878860473633,2.93241214752209 48.3961067199707,2.93661236763012 48.3970642089844,2.93661236763012 48.3970642089844,2.92480802536005 48.4326934814454,2.92480802536005 48.4326934814454,2.91305565834045 48.4270896911622,2.90128803253168 48.43115234375,2.89529585838318 48.4261016845704,2.89529585838318 48.4261016845704,2.89162683486938 48.4158248901368,2.88218498229992 48.4075736999512,2.87799596786499 48.3902511596681,2.85687041282654 48.3799705505372,2.84643340110784 48.3790245056153,2.84643340110784 48.3790245056153,2.85810565948492 48.3676376342773,2.85621070861816 48.364414215088,2.85621070861816 48.364414215088,2.87769985198975 48.354866027832,2.87769985198975 48.354866027832,2.88752770423889 48.3545608520509,2.89126801490789 48.3606376647949,2.90109539031982 48.361053466797)) | 0.0006 | POINT(2.893894067177427 48.39015491192164) |