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 |
---|---|---|---|
28159 | POLYGON((4.63830566406256 47.2027282714845,4.62133216857916 47.2002639770509,4.6089820861817 47.2038955688478,4.6089820861817 47.2038955688478,4.59789466857916 47.1993827819825,4.59789466857916 47.1993827819825,4.60411453247082 47.1939659118653,4.60929107666021 47.1806488037109,4.60447072982794 47.1709098815919,4.60447072982794 47.1709098815919,4.6100287437439 47.1633758544922,4.6100287437439 47.1633758544922,4.61594009399425 47.1628074645996,4.61594009399425 47.1628074645996,4.61956071853649 47.1716918945312,4.61956071853649 47.1716918945312,4.63462495803833 47.180305480957,4.64129161834728 47.1927719116212,4.65126276016247 47.1931152343751,4.660059452057 47.1896476745607,4.660059452057 47.1896476745607,4.65903854370129 47.1920967102051,4.65903854370129 47.1920967102051,4.65079212188726 47.1967163085938,4.65079212188726 47.1967163085938,4.64228630065929 47.1963577270508,4.63830566406256 47.2027282714845)) | 0.0006 | POINT(4.62677089984608 47.18620021526636) |
34615 | POLYGON((4.15920782089239 48.7912750244141,4.16718006134045 48.7928619384767,4.17747926712042 48.7871589660645,4.17747926712042 48.7871589660645,4.17367219924932 48.7849197387695,4.18354606628424 48.7773666381837,4.20231533050548 48.7744712829591,4.20231533050548 48.7744712829591,4.15274858474731 48.7558631896973,4.12426280975342 48.7268295288087,4.12426280975342 48.7268295288087,4.10994482040405 48.7351036071778,4.10994482040405 48.7351036071778,4.09069633483898 48.7360916137695,4.0889368057251 48.7390937805176,4.09658050537115 48.7508087158203,4.09658050537115 48.7508087158203,4.11430835723888 48.76371383667,4.14953851699829 48.7774925231934,4.1538667678833 48.7836723327636,4.15125226974493 48.7867126464844,4.15920782089239 48.7912750244141)) | 0.0006 | POINT(4.143148535773916 48.76370511736194) |
58681 | POLYGON((6.34825086593628 50.507553100586,6.3442702293396 50.5062294006348,6.32953643798834 50.50537109375,6.32803344726568 50.5036849975586,6.32415151596075 50.5023727416993,6.31919336318975 50.4985542297364,6.31555604934692 50.4970436096191,6.31555604934692 50.4970436096191,6.31420135498047 50.4978141784668,6.31412124633789 50.4990272521973,6.30907535552979 50.5014114379883,6.29750394821173 50.4976119995118,6.28500509262091 50.498966217041,6.28151464462286 50.5032081604004,6.2747850418092 50.5023040771484,6.26994132995605 50.5045127868652,6.26181650161743 50.4988479614257,6.25460577011114 50.4994163513184,6.25464725494396 50.5014343261719,6.25173187255865 50.5034828186036,6.24136924743658 50.4989891052246,6.23071146011353 50.4974784851074,6.226631641388 50.494369506836,6.22461557388306 50.4949493408204,6.22004270553595 50.4987220764161,6.22258663177502 50.5005760192872,6.21989488601685 50.5052871704103,6.21678781509399 50.5065078735352,6.21319484710705 50.5130233764648,6.21020984649658 50.5131340026856,6.20911169052118 50.5147018432617,6.21258258819591 50.515567779541,6.20809364318853 50.5174140930177,6.20692586898798 50.5201568603517,6.205328464508 50.5209732055663,6.19220066070562 50.5210571289063,6.18966960906994 50.5247459411621,6.18723583221436 50.5263061523439,6.19214344024664 50.5308952331544,6.1952915191651 50.5309829711915,6.19546031951904 50.5302619934082,6.19699525833136 50.5310325622559,6.1985878944397 50.5351638793946,6.18981361389172 50.5390014648438,6.18864631652838 50.540309906006,6.18431520462036 50.5415725708007,6.17803239822393 50.5416069030762,6.17844247817993 50.5540161132812,6.17608356475836 50.5561180114747,6.17415428161621 50.5564765930176,6.1744122505188 50.5575141906738,6.18166446685791 50.5607948303223,6.18664216995239 50.5642089843751,6.18909072875988 50.5645103454591,6.18931245803833 50.5660934448243,6.19191551208496 50.5654869079591,6.20309877395636 50.5692939758302,6.20451021194452 50.5710334777833,6.20373153686529 50.5722656250001,6.20666456222546 50.5746994018555,6.2062520980835 50.5762596130371,6.20759344100946 50.5761413574219,6.21907424926769 50.5813789367676,6.22213411331182 50.5846023559571,6.22249746322638 50.5869789123536,6.22518062591558 50.5904579162599,6.2348198890686 50.5887565612794,6.24172115325928 50.593505859375,6.24508094787603 50.5930252075196,6.24960470199596 50.5982284545898,6.24751663208002 50.6028099060059,6.24850082397461 50.6046028137208,6.25996637344355 50.6098213195801,6.26171541214001 50.611614227295,6.26171541214001 50.611614227295,6.27364492416393 50.6068801879883,6.2744455337525 50.6036643981933,6.28126907348627 50.5978851318359,6.28218841552734 50.5955390930176,6.27924871444714 50.5951690673828,6.28301143646252 50.5919075012208,6.27476072311407 50.5871734619141,6.27729177474987 50.5782699584962,6.28138828277582 50.5747528076173,6.28485679626471 50.5737991333009,6.28417444229137 50.5708465576172,6.29190015792858 50.5686569213867,6.29610681533819 50.5662498474122,6.29858827590942 50.5635108947754,6.30886602401728 50.5631370544434,6.31057834625238 50.560604095459,6.30944776535046 50.558219909668,6.31426763534546 50.5600090026855,6.31818914413464 50.5470008850099,6.32250261306763 50.5451049804688,6.32284784317022 50.54789352417,6.32438325881964 50.5493888854981,6.32890224456787 50.5518531799317,6.33525133132946 50.5533065795899,6.33722352981579 50.5535583496095,6.33710718154913 50.5520019531251,6.34561538696289 50.5501747131348,6.33859729766851 50.5465431213379,6.33659076690685 50.5401611328126,6.33684825897222 50.5356750488281,6.33587503433233 50.5335845947266,6.34209966659546 50.5345039367676,6.35231733322149 50.5310478210449,6.35340070724487 50.5298347473146,6.35823249816906 50.5298728942871,6.35823249816906 50.5298728942871,6.36099576950079 50.5304412841797,6.36200094223022 50.5325050354005,6.36588048934948 50.5342025756836,6.37379169464123 50.5362091064454,6.37686824798595 50.5364379882812,6.37976694107061 50.5337104797363,6.37946701049816 50.5318145751954,6.37586402893066 50.5290565490724,6.36971950531006 50.5184173583985,6.35628318786615 50.5102043151855,6.34825086593628 50.507553100586)) | 0.0006 | POINT(6.269041010170967 50.5433358752038) |
57759 | POLYGON((6.71251058578503 50.0090675354004,6.71368551254284 50.0104560852052,6.70899534225464 50.0136871337891,6.70984029769909 50.0171051025391,6.7050600051881 50.0188293457031,6.70356082916265 50.0202636718751,6.70356082916265 50.0202636718751,6.70033168792736 50.0222892761232,6.70051765441895 50.0251312255859,6.69914627075207 50.0261344909668,6.69914627075207 50.0261344909668,6.69586515426636 50.027458190918,6.69366598129284 50.0268096923828,6.69035339355469 50.0286979675294,6.68543386459362 50.0283088684083,6.68419027328491 50.0295104980469,6.68335771560663 50.028564453125,6.6844544410705 50.0272750854493,6.68124818801886 50.0280151367188,6.67959594726574 50.0252647399903,6.67318153381342 50.0217552185059,6.67204904556269 50.0220947265626,6.67083644866943 50.019630432129,6.66812372207653 50.0185928344727,6.66812372207653 50.0185928344727,6.66395854949957 50.0171928405762,6.66439771652233 50.0152244567872,6.66215753555304 50.0161209106445,6.65709543228155 50.0114822387696,6.66004467010492 50.010627746582,6.65909576416021 50.0093955993652,6.66219282150269 50.0077552795411,6.65750122070307 50.0044136047363,6.65705633163458 50.0024909973145,6.65705633163458 50.0024909973145,6.65728282928472 49.9991836547852,6.65902042388927 49.9982681274415,6.66163682937622 49.999095916748,6.66281175613403 50.0025291442871,6.66465806961054 50.0019989013672,6.66465806961054 50.0019989013672,6.66593837738043 50.0041389465333,6.66820621490473 50.0042724609374,6.67110109329224 50.0066757202149,6.67657279968262 50.0038299560547,6.67790985107416 50.0064888000488,6.68381023406988 50.0073432922364,6.68829536437988 50.0065040588379,6.6938529014588 50.0086631774903,6.703544139862 50.0074005126954,6.71251058578503 50.0090675354004)) | 0.0006 | POINT(6.679733800888096 50.014310379028345) |
1402746 | POLYGON((-5.53990411758423 41.4622840881349,-5.54478597640991 41.4591407775879,-5.55227994918818 41.4581756591798,-5.57923698425287 41.4499893188478,-5.57810878753656 41.4465370178223,-5.59775114059448 41.4291191101074,-5.62716293334955 41.4460220336914,-5.63158893585199 41.4512405395508,-5.64272499084473 41.455192565918,-5.64481210708618 41.4626579284669,-5.63264417648315 41.4699516296387,-5.62975597381592 41.4734649658203,-5.63380908966064 41.4744720458984,-5.63718605041504 41.4780082702637,-5.63532018661493 41.4845695495607,-5.63075876235956 41.4852256774902,-5.63046121597284 41.4873123168946,-5.62685680389399 41.4876441955568,-5.60007095336908 41.4869232177735,-5.58662605285645 41.4831809997559,-5.58475923538197 41.4841156005861,-5.57761192321772 41.4793243408204,-5.56100177764887 41.4805412292481,-5.55626583099365 41.4761505126953,-5.5577540397644 41.4731903076172,-5.55583477020264 41.4706687927247,-5.55093908309937 41.4704322814942,-5.54618120193481 41.4660339355468,-5.54133701324463 41.4665031433105,-5.53990411758423 41.4622840881349)) | 0.0006 | POINT(-5.59357000219408 41.46889903627598) |
1401094 | POLYGON((-3.44645810127258 41.3439178466798,-3.44829988479614 41.340747833252,-3.4440770149231 41.3332138061524,-3.44423198699951 41.3295059204102,-3.44493603706354 41.320629119873,-3.44815397262573 41.3158798217775,-3.45556402206421 41.3160858154298,-3.45968389511103 41.3178863525391,-3.46463704109186 41.3252067565918,-3.46812391281122 41.3217277526857,-3.46521592140186 41.3208808898926,-3.46806693077087 41.3154563903809,-3.47187304496759 41.3147201538087,-3.48061394691456 41.3172607421874,-3.48226404190063 41.3222351074219,-3.50573897361755 41.3280792236329,-3.51473903656 41.3283996582032,-3.52658104896534 41.3311576843262,-3.5374710559845 41.3462677001953,-3.53931689262384 41.3454933166504,-3.53874301910395 41.3468933105469,-3.54027891159058 41.3473777770997,-3.52564907073963 41.3639755249025,-3.54854488372803 41.389549255371,-3.54495406150818 41.3905410766602,-3.54414391517639 41.3967399597168,-3.54503107070923 41.4057426452637,-3.54836106300348 41.4102325439454,-3.51278805732727 41.4178085327148,-3.50087690353394 41.4157180786133,-3.49736309051514 41.4099311828614,-3.47474503517145 41.4105682373047,-3.47439408302307 41.3936462402344,-3.47779893875116 41.3867111206055,-3.46591806411737 41.3724098205567,-3.46262001991272 41.3628158569337,-3.45943808555603 41.3593063354493,-3.44887399673462 41.3562850952149,-3.45052194595337 41.3545570373535,-3.44955801963806 41.349723815918,-3.45118999481201 41.3456192016603,-3.44645810127258 41.3439178466798)) | 0.0006 | POINT(-3.487264365684667 41.35416840343944) |
64781 | POLYGON((12.9006986618041 48.2579803466797,12.8971900939942 48.2597808837892,12.8988466262817 48.2630844116211,12.8942489624024 48.2665939331055,12.891809463501 48.2643623352051,12.8890829086304 48.2650756835938,12.8849897384644 48.2615280151367,12.8839511871338 48.2617797851562,12.8862943649293 48.2648048400879,12.8796863555908 48.2643890380859,12.8758459091187 48.265480041504,12.879981994629 48.267635345459,12.8796901702881 48.2711448669435,12.8773488998413 48.2720489501953,12.8761606216431 48.2711486816407,12.8754405975342 48.272144317627,12.8738164901734 48.2719917297363,12.87291431427 48.2708969116211,12.8696565628051 48.2717933654785,12.8646335601806 48.2743644714357,12.8635177612305 48.2775001525879,12.8621187210084 48.2772712707519,12.8595905303956 48.2790527343751,12.8572311401368 48.2790298461915,12.8551177978516 48.2773933410645,12.8538579940797 48.2780952453613,12.856393814087 48.2801208496094,12.8537435531616 48.281623840332,12.8564453125 48.2848396301271,12.8585100173951 48.2854537963868,12.8558969497681 48.2857589721679,12.8523235321044 48.289421081543,12.8503675460815 48.2890625,12.8503675460815 48.2890625,12.8486576080322 48.2899551391601,12.8496046066284 48.2907524108888,12.8436641693116 48.2955436706544,12.8402986526489 48.2952690124512,12.8384485244752 48.2968978881837,12.8301658630371 48.299343109131,12.8287715911866 48.3006324768067,12.824420928955 48.300724029541,12.8224563598633 48.3022117614747,12.8250322341918 48.3041076660156,12.8239164352418 48.3049583435059,12.8270645141602 48.3064155578614,12.8266878128053 48.3092918395997,12.8215913772582 48.3129882812501,12.8241167068481 48.3142051696778,12.8229427337646 48.3153266906739,12.8229427337646 48.3153266906739,12.8244781494142 48.3189811706544,12.8239336013794 48.3200263977051,12.8319835662842 48.3199920654297,12.832896232605 48.3221511840821,12.830701828003 48.3225212097168,12.8312892913819 48.3241081237794,12.828411102295 48.3296737670898,12.8290252685547 48.3306770324706,12.8339834213258 48.3316688537598,12.8258771896363 48.3351249694824,12.8254833221436 48.3401794433594,12.8329219818115 48.3411293029786,12.832462310791 48.3391151428223,12.8350067138671 48.3364524841309,12.8395118713379 48.3370056152345,12.8420896530153 48.3361587524414,12.8438415527344 48.3338737487794,12.8426475524903 48.3300552368164,12.8464479446411 48.3299751281738,12.8457078933716 48.3339576721191,12.8486394882203 48.3346061706544,12.8496122360229 48.333522796631,12.8496122360229 48.333522796631,12.8503389358522 48.330379486084,12.8486890792847 48.330307006836,12.8482236862184 48.3284721374512,12.8495025634765 48.3267250061035,12.8516035079957 48.3258171081544,12.8533744812013 48.3264541625977,12.8544607162476 48.323802947998,12.85622215271 48.3228416442872,12.8632135391236 48.3262977600098,12.8635778427125 48.324058532715,12.8625621795655 48.3214530944825,12.8652191162109 48.3222885131837,12.8743543624879 48.3195991516114,12.8744573593141 48.3181037902832,12.8735752105714 48.3174324035645,12.8757143020631 48.3173217773438,12.876223564148 48.3155937194825,12.8745098114014 48.315559387207,12.8743991851807 48.3143920898438,12.8765573501587 48.3143997192383,12.8771514892579 48.3119201660156,12.8798065185548 48.3107643127442,12.8796176910401 48.3099441528321,12.8827037811279 48.3071250915528,12.8874893188477 48.3065528869629,12.8857231140137 48.3057098388672,12.8867797851563 48.3049850463868,12.8890972137452 48.3055000305175,12.888526916504 48.3029327392578,12.8978176116944 48.3035125732422,12.8995742797852 48.3022155761719,12.9036855697632 48.3030166625977,12.9033765792846 48.3041381835938,12.9048166275026 48.3043670654297,12.9048166275026 48.3043670654297,12.9051809310913 48.3032608032228,12.908652305603 48.3031311035156,12.912733078003 48.3011093139649,12.9126386642457 48.2981071472168,12.9176111221315 48.2964248657228,12.9190607070923 48.2949142456054,12.9156665802003 48.293613433838,12.9152164459229 48.2929496765137,12.916392326355 48.2924652099609,12.9132652282716 48.2897377014161,12.9143514633179 48.2887954711915,12.9133062362671 48.2878265380861,12.9102630615235 48.2873382568359,12.9117288589478 48.2848052978515,12.9063091278076 48.2828521728517,12.9063272476197 48.2799224853516,12.9018602371217 48.2797851562501,12.9002542495729 48.2775344848634,12.9037733078003 48.27592086792,12.9013662338256 48.2738304138183,12.9136447906494 48.2719802856446,12.912031173706 48.2704048156738,12.9118223190308 48.2686195373536,12.9097700119019 48.267433166504,12.9105300903321 48.2659034729004,12.9085807800293 48.2667999267579,12.9080343246459 48.2658348083496,12.9093580245972 48.2650680541993,12.9076023101807 48.2636032104493,12.9076023101807 48.2636032104493,12.9066610336305 48.2644691467286,12.9054174423218 48.2635612487793,12.9029397964477 48.2638664245607,12.9026851654052 48.2608604431152,12.9006986618041 48.2579803466797)) | 0.0006 | POINT(12.870947664434288 48.297865914298114) |
1405894 | POLYGON((-0.286985993385201 38.7662544250489,-0.280880004167557 38.7642822265625,-0.255544990301132 38.7752838134767,-0.244642004370689 38.7755432128906,-0.241125002503338 38.7769775390626,-0.229849994182587 38.7788009643555,-0.220516994595528 38.7749328613282,-0.214985996484756 38.7749748229981,-0.212551996111756 38.7735252380371,-0.195640996098518 38.7700309753419,-0.209577992558479 38.7658882141113,-0.226750999689102 38.7583312988282,-0.23027199506754 38.7583351135254,-0.231732994318008 38.7550926208497,-0.23790700733656 38.7504348754883,-0.261079013347626 38.7449531555176,-0.264575004577637 38.7456283569336,-0.267489999532643 38.7491035461425,-0.275173008441811 38.7485885620118,-0.277547985315266 38.7505187988282,-0.281594008207207 38.750701904297,-0.285530000925007 38.7567024230958,-0.286985993385201 38.7662544250489)) | 0.0006 | POINT(-0.24690699915990677 38.762040224942346) |
62258 | POLYGON((11.2566604614259 52.9183616638185,11.262701034546 52.9199371337891,11.2633047103883 52.919303894043,11.2666053771973 52.9217376708986,11.2697525024415 52.928913116455,11.2739238739014 52.9351654052734,11.2851390838624 52.9442024230957,11.2871217727661 52.9526710510254,11.2911701202393 52.9521865844727,11.2922363281251 52.9529609680176,11.2967777252197 52.9516067504883,11.2967777252197 52.9516067504883,11.2980308532715 52.9513511657715,11.2989740371705 52.953884124756,11.2916793823243 52.9556312561035,11.2896671295167 52.9570350646973,11.2831344604493 52.9587249755861,11.2819948196411 52.9599380493164,11.283697128296 52.9627380371095,11.2857475280763 52.962474822998,11.2863531112671 52.9647636413574,11.2847671508789 52.9651412963868,11.2855491638185 52.9672851562501,11.2831010818483 52.9677963256837,11.2819347381592 52.9725952148438,11.2627782821655 52.9752159118653,11.255693435669 52.9787635803223,11.2477130889894 52.9780426025391,11.2501649856567 52.9757766723633,11.2459650039673 52.9733657836915,11.243637084961 52.9758987426759,11.243637084961 52.9758987426759,11.2407512664796 52.977466583252,11.2327947616578 52.9792175292969,11.2222642898561 52.9778556823731,11.20858001709 52.9806022644042,11.2072362899781 52.9822692871094,11.2034072875977 52.983169555664,11.1963520050049 52.9825897216798,11.2024202346803 52.981056213379,11.2019920349122 52.9784507751466,11.2103528976442 52.9759635925294,11.212589263916 52.9724006652831,11.2058610916139 52.9678993225098,11.204592704773 52.9649391174318,11.2029666900635 52.963809967041,11.1961784362793 52.9629669189453,11.1960897445679 52.9572830200195,11.1950426101685 52.9560585021973,11.1945877075196 52.9526367187501,11.2001323699952 52.9521293640138,11.1996850967407 52.9483184814453,11.2107849121094 52.9480667114259,11.2141590118409 52.9428138732911,11.2111234664918 52.9422645568847,11.2164115905762 52.9324073791504,11.2164115905762 52.9324073791504,11.2233057022096 52.9336051940919,11.2338857650757 52.9336166381836,11.2456750869751 52.9317054748536,11.244873046875 52.9297103881837,11.2477655410767 52.9251594543457,11.2531776428223 52.9191398620607,11.2566604614259 52.9183616638185)) | 0.0006 | POINT(11.245680006723612 52.95633261544365) |
35874 | POLYGON((6.73095369338989 47.3369255065919,6.72222805023199 47.3378486633302,6.72222805023199 47.3378486633302,6.72771835327154 47.3537025451661,6.72550487518311 47.3600196838378,6.72550487518311 47.3600196838378,6.73912048339855 47.364315032959,6.73912048339855 47.364315032959,6.74355220794678 47.3582496643068,6.75261306762695 47.3558197021485,6.73933839797968 47.3421440124512,6.73933839797968 47.3421440124512,6.73116493225092 47.339958190918,6.73095369338989 47.3369255065919)) | 0.0006 | POINT(6.733721989851749 47.350254645714436) |