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
65145POLYGON((12.354884147644 49.7133178710938,12.3574790954591 49.7150955200196,12.3601903915406 49.7155799865724,12.3598852157593 49.7173500061035,12.3625001907348 49.7199783325196,12.3702659606935 49.7229843139648,12.3710584640503 49.7265434265137,12.3830270767212 49.7329216003419,12.3866472244263 49.7384529113771,12.3932723999023 49.7384452819825,12.3970642089845 49.7395820617677,12.4045419692993 49.7449378967286,12.4045419692993 49.7449378967286,12.4063653945923 49.7394828796387,12.4126005172729 49.7356758117676,12.4127902984619 49.7325172424318,12.4257116317749 49.7304649353028,12.4287776947022 49.7243690490722,12.4289712905883 49.7209281921388,12.4332542419434 49.7180290222169,12.4328088760376 49.715950012207,12.4350643157959 49.7140579223633,12.440279006958 49.7057800292968,12.4428863525391 49.7037010192872,12.4528160095215 49.7012100219727,12.4574546813964 49.7020568847657,12.4630422592164 49.6995086669922,12.4809217453003 49.6950302124024,12.4839954376221 49.6938705444337,12.4854393005372 49.6915054321289,12.4852209091187 49.6878852844239,12.4852209091187 49.6878852844239,12.4644975662233 49.6904830932618,12.465657234192 49.6872062683105,12.4682397842408 49.687271118164,12.4681901931763 49.6860733032228,12.4645519256591 49.6852989196777,12.4645442962648 49.6844444274903,12.458779335022 49.6862411499024,12.4592399597168 49.6839561462402,12.4605522155762 49.6835250854492,12.4589500427247 49.682746887207,12.4593896865845 49.68119430542,12.4559650421143 49.6807022094727,12.4549188613892 49.6766738891602,12.4549188613892 49.6766738891602,12.4527225494385 49.6765518188478,12.4517288208008 49.674633026123,12.4493627548218 49.6737442016602,12.4462909698487 49.6739082336426,12.4432430267334 49.6763801574708,12.4404373168945 49.6772918701172,12.4350433349609 49.6752586364747,12.4305210113525 49.675220489502,12.4283494949341 49.6739883422852,12.4290161132813 49.6770896911621,12.4255132675171 49.6748390197754,12.4258098602296 49.6773872375489,12.4219799041749 49.6821517944336,12.4224386215209 49.6842231750489,12.4207181930543 49.6835403442383,12.4200496673585 49.6848297119141,12.4177961349487 49.6833038330078,12.4112892150878 49.6839447021485,12.4047403335571 49.6828460693361,12.4022006988526 49.6814155578614,12.3977766036987 49.6807250976563,12.3956899642945 49.678882598877,12.3945741653442 49.6791267395021,12.3953409194947 49.6809921264648,12.392388343811 49.6819458007812,12.3924741744996 49.6834144592285,12.3872680664063 49.6843566894532,12.3881788253785 49.6873817443848,12.3869123458862 49.6883392333985,12.3868255615234 49.6875305175781,12.3832960128784 49.6873893737793,12.3815259933471 49.6857566833497,12.383521080017 49.6850128173828,12.3825016021729 49.6837844848634,12.3794622421266 49.6837196350099,12.3794622421266 49.6837196350099,12.376898765564 49.6841506958008,12.3780059814453 49.6851387023926,12.375714302063 49.6868133544922,12.3726663589479 49.6869087219239,12.372296333313 49.685474395752,12.3708696365358 49.686019897461,12.3715333938599 49.6873970031738,12.3654088973998 49.6857795715333,12.3604898452758 49.6898269653321,12.3588018417359 49.6884956359864,12.3541650772096 49.6898498535157,12.3490266799927 49.6889801025392,12.350178718567 49.6904106140138,12.3550109863282 49.6926918029786,12.355661392212 49.6940841674806,12.3530960083008 49.6941070556642,12.3541202545167 49.6958274841309,12.3487939834595 49.6944122314454,12.3462219238281 49.6946334838868,12.3463602066041 49.6967620849611,12.3540029525757 49.6981506347656,12.3573541641236 49.700481414795,12.3659811019897 49.7014732360841,12.3698463439942 49.703441619873,12.3606557846069 49.7090034484864,12.3534774780273 49.7067718505859,12.351266860962 49.7084465026856,12.3517837524415 49.7103271484376,12.3541822433472 49.7113227844239,12.354884147644 49.7133178710938))0.0006POINT(12.406105359395372 49.69553454287419)
56460POLYGON((5.06031036376953 45.7077903747559,5.07785320281994 45.6966514587402,5.09165573120112 45.6955299377441,5.10428094863903 45.6982955932617,5.10428094863903 45.6982955932617,5.13137197494501 45.7050895690919,5.14015960693371 45.7022666931153,5.14898777008068 45.7044868469238,5.15399646759045 45.6997222900392,5.15399646759045 45.6997222900392,5.15924358367926 45.7152519226075,5.15924358367926 45.7152519226075,5.1463294029237 45.7197952270507,5.13374948501598 45.7333946228028,5.13374948501598 45.7333946228028,5.12667989730841 45.7375526428223,5.09452676773071 45.7394523620606,5.09452676773071 45.7394523620606,5.0566258430481 45.7321434020996,5.0566258430481 45.7321434020996,5.06027460098267 45.718906402588,5.06027460098267 45.718906402588,5.05750465393066 45.7101287841797,5.06031036376953 45.7077903747559))0.0006POINT(5.10896730422979 45.71537498805837)
62591MULTIPOLYGON(((7.40519237518322 52.374080657959,7.39176225662231 52.3877449035646,7.3981609344483 52.389217376709,7.39726066589367 52.3900833129883,7.40260601043701 52.3903961181641,7.40409469604504 52.3936805725099,7.40314960479748 52.3939285278321,7.40338516235352 52.3963661193849,7.3948740959168 52.3966140747071,7.39481973648077 52.3979377746582,7.3983931541444 52.4014472961426,7.39326572418219 52.407283782959,7.39327287673945 52.4086723327637,7.40019655227673 52.4077339172364,7.4025926589967 52.4092712402344,7.40884160995478 52.406795501709,7.41444110870356 52.4097023010255,7.41106176376348 52.4098320007325,7.40863513946539 52.4133262634278,7.39642667770386 52.410026550293,7.39143371582026 52.4129180908203,7.38807535171503 52.4118843078613,7.38667058944714 52.4127426147461,7.38333606719982 52.4125175476075,7.38230276107794 52.4117088317872,7.37701559066778 52.4161987304688,7.3777117729187 52.4185104370118,7.37630414962769 52.4203033447267,7.37630414962769 52.4203033447267,7.38390827178966 52.4216690063477,7.38763904571539 52.420524597168,7.39253759384161 52.4210090637207,7.39571619033819 52.426067352295,7.40145349502569 52.4249382019044,7.40437078475958 52.4266166687012,7.40882062911993 52.4261474609376,7.40987968444836 52.4268035888671,7.4101996421814 52.4302864074708,7.41141223907471 52.4312400817872,7.41111612319958 52.4328536987306,7.413890361786 52.434440612793,7.4139461517334 52.4374847412109,7.419267654419 52.4383239746094,7.419267654419 52.4383239746094,7.43496561050426 52.4418144226074,7.45878076553345 52.4436607360841,7.45878076553345 52.4436607360841,7.46028470993036 52.4414710998536,7.45865345001232 52.441162109375,7.45827293396002 52.4387893676759,7.46416807174683 52.4389038085938,7.4606556892395 52.4375915527344,7.45734071731573 52.4343643188477,7.4596667289735 52.4331779479982,7.45642662048334 52.4319877624513,7.45957803726208 52.4286994934083,7.45992755889898 52.424934387207,7.46820259094238 52.4112968444824,7.46742200851452 52.4107589721681,7.47149801254267 52.4089431762696,7.47356557846081 52.4101333618165,7.47775888442993 52.4052429199218,7.47839403152466 52.4024620056153,7.49096727371216 52.4025535583497,7.49082994461065 52.3989257812501,7.49444484710693 52.3988838195801,7.49790096282959 52.3961639404297,7.49866342544567 52.3959655761719,7.50170373916626 52.4003410339357,7.50469779968256 52.3986091613771,7.50489616394043 52.396957397461,7.50782299041759 52.3987426757814,7.51068639755243 52.3972816467286,7.51068639755243 52.3972816467286,7.51461410522461 52.3837814331055,7.51461410522461 52.3837814331055,7.50845813751232 52.3816833496094,7.50202846527111 52.3843574523925,7.49696540832514 52.3848457336426,7.49881982803345 52.3876914978028,7.50138044357294 52.3870162963868,7.50412178039556 52.3904685974121,7.5012788772583 52.3911895751953,7.49955415725719 52.3890304565429,7.49493598937988 52.3902740478516,7.49330759048473 52.3878517150879,7.49169540405273 52.3880958557129,7.49004554748547 52.3854103088379,7.48342227935791 52.3863067626954,7.48169755935675 52.3839492797852,7.4776811599732 52.3830833435059,7.47184658050543 52.3849678039551,7.48452091217052 52.3909568786622,7.48281717300426 52.3922729492187,7.4873299598695 52.3944206237794,7.48356723785412 52.3953285217286,7.47305583953863 52.3914489746094,7.46812057495123 52.3907928466797,7.45796966552746 52.3927612304688,7.45324754714972 52.3938102722169,7.4580979347229 52.3970336914064,7.44904136657715 52.4038963317872,7.44317102432257 52.4001922607422,7.4390859603883 52.4041595458984,7.43427705764776 52.4024429321289,7.42843723297131 52.4026184082031,7.42776775360107 52.4014282226562,7.43178272247326 52.3996315002441,7.42968463897716 52.3955764770508,7.42933225631725 52.3927574157714,7.42515134811413 52.3935546875001,7.4227352142334 52.3898162841797,7.42158699035656 52.3900375366211,7.4200496673584 52.3882141113282,7.41872549057007 52.388641357422,7.4170322418214 52.3873748779297,7.41745853424072 52.3858795166016,7.41659641265881 52.3851470947266,7.41320896148676 52.3847808837892,7.42087936401379 52.3745040893556,7.40519237518322 52.374080657959)),((7.42671346664429 52.3482780456544,7.41520404815668 52.3580551147462,7.41897201538097 52.3599243164063,7.41897201538097 52.3599243164063,7.42620372772228 52.3545722961427,7.42671346664429 52.3482780456544)))0.0006POINT(7.442423870757268 52.40472035670696)
47525POLYGON((1.78380918502819 50.6468544006348,1.77664697170269 50.6418647766113,1.76617956161499 50.6404876708985,1.75196146965021 50.6503448486328,1.75196146965021 50.6503448486328,1.7535030841828 50.6564826965333,1.77145111560833 50.6609687805176,1.77201092243195 50.6640625,1.77201092243195 50.6640625,1.7762097120285 50.6632766723633,1.77773785591125 50.6579322814942,1.77773785591125 50.6579322814942,1.78380918502819 50.6468544006348))0.0006POINT(1.7692683438460266 50.65455118815106)
26157POLYGON((1.96138167381298 48.8518905639648,1.9217113256455 48.8583221435548,1.9217113256455 48.8583221435548,1.92907643318176 48.8673820495607,1.94578993320471 48.8754920959473,1.94990599155432 48.8816604614258,1.94990599155432 48.8816604614258,1.95773732662201 48.8698844909667,1.96970188617706 48.8639602661133,1.96907341480255 48.8605918884277,1.96907341480255 48.8605918884277,1.96138167381298 48.8518905639648))0.0006POINT(1.949551701545751 48.86634167757904)
1408770POLYGON((-2.51484107971191 42.1549606323242,-2.51777696609497 42.1571731567383,-2.52522301673878 42.1730995178223,-2.52990388870239 42.1784858703614,-2.52917695045466 42.1851921081542,-2.53206896781921 42.1870956420899,-2.54145693778992 42.1850967407226,-2.54409909248346 42.1865043640138,-2.53858804702759 42.190040588379,-2.53299188613892 42.1998519897461,-2.53492307662964 42.2008781433105,-2.53350305557245 42.2061576843263,-2.53486108779896 42.2076835632325,-2.52080988883972 42.212257385254,-2.51356911659235 42.2117118835449,-2.51262998580927 42.2078552246094,-2.50616502761841 42.2058906555176,-2.49814701080322 42.1950111389161,-2.49765396118164 42.1930274963379,-2.50157690048218 42.1899566650391,-2.50194597244263 42.1863365173339,-2.50608706474299 42.1802215576172,-2.50799894332886 42.1660919189453,-2.51484107971191 42.1549606323242))0.0006POINT(-2.5206955619480054 42.189590454101584)
19844POLYGON((12.2697649002076 46.4506835937501,12.2824563980104 46.4388809204102,12.2824563980104 46.4388809204102,12.2929849624634 46.4462127685547,12.3045349121095 46.4505233764648,12.3214731216431 46.4487800598145,12.3227920532227 46.4481391906738,12.3241281509399 46.4444808959962,12.323899269104 46.4360198974609,12.3335065841675 46.4253616333008,12.3385715484619 46.4226303100587,12.3443660736085 46.421615600586,12.3627395629884 46.4023361206055,12.3627395629884 46.4023361206055,12.3708066940309 46.4017219543458,12.3742790222169 46.4046516418457,12.3756141662599 46.4073028564454,12.3751401901246 46.4097404479982,12.376377105713 46.4106025695801,12.3795499801636 46.4111938476564,12.3844499588013 46.408374786377,12.3999671936036 46.3896789550781,12.3970394134521 46.3854713439942,12.4020166397096 46.3724441528321,12.4099760055542 46.3603744506837,12.4126596450806 46.3579635620118,12.4183712005616 46.3557395935059,12.4183712005616 46.3557395935059,12.4296712875366 46.3524703979492,12.4502315521241 46.3611450195313,12.4639368057251 46.3701438903809,12.4615192413331 46.3813056945802,12.4575548171998 46.3864936828614,12.4560413360597 46.3925514221192,12.4560413360597 46.3925514221192,12.4494304656983 46.3983230590821,12.4428205490113 46.4059562683107,12.4433536529541 46.409252166748,12.4467449188233 46.4157829284669,12.4399614334106 46.4245910644531,12.4110326766968 46.4355010986328,12.3926029205322 46.4389038085938,12.3926029205322 46.4389038085938,12.3891592025757 46.4352188110353,12.3867559432983 46.434253692627,12.3748197555543 46.4386825561523,12.375512123108 46.4439926147462,12.3699598312378 46.4512748718262,12.3589172363282 46.4573974609375,12.3373136520386 46.458911895752,12.335831642151 46.4623565673828,12.3246393203735 46.4733848571778,12.320363998413 46.4733467102051,12.2875328063965 46.4661407470703,12.2720727920533 46.4589805603028,12.2697649002076 46.4506835937501))0.0006POINT(12.376135566017899 46.41755814985798)
21259POLYGON((7.07139682769787 47.7612152099611,7.06605434417725 47.7455291748047,7.06605434417725 47.7455291748047,7.05428504943848 47.7408294677734,7.05428504943848 47.7408294677734,7.02983903884893 47.7498855590821,7.02983903884893 47.7498855590821,7.03601646423351 47.7689552307128,7.03601646423351 47.7689552307128,7.06202840805054 47.7608833312989,7.07139682769787 47.7612152099611))0.0006POINT(7.050581502914476 47.753249740600594)
46906POLYGON((3.29242849349981 50.2822685241699,3.29717326164251 50.276554107666,3.28643178939819 50.2650680541992,3.28264689445496 50.2520027160645,3.28264689445496 50.2520027160645,3.28713488578802 50.2531700134278,3.28906512260443 50.2503280639648,3.28906512260443 50.2503280639648,3.29585504531866 50.2547645568849,3.30483889579784 50.2535667419434,3.30483889579784 50.2535667419434,3.30970478057861 50.266025543213,3.32449460029602 50.2743377685548,3.32449460029602 50.2743377685548,3.33184719085693 50.2781639099122,3.33184719085693 50.2781639099122,3.33654475212097 50.2913475036622,3.3500292301178 50.301742553711,3.3500292301178 50.301742553711,3.34670042991644 50.306941986084,3.34670042991644 50.306941986084,3.33058738708502 50.3019523620605,3.33058738708502 50.3019523620605,3.3309304714204 50.298683166504,3.28549146652227 50.2970275878907,3.28549146652227 50.2970275878907,3.29818201065075 50.2908287048341,3.29949378967285 50.2874832153321,3.29242849349981 50.2822685241699))0.0006POINT(3.3116172041212217 50.27851145608089)
54203POLYGON((5.79585027694702 45.8297996520996,5.80110931396484 45.8457946777344,5.80110931396484 45.8457946777344,5.80752515792847 45.8606414794922,5.80752515792847 45.8606414794922,5.81515407562267 45.8772010803224,5.81515407562267 45.8772010803224,5.77687406539917 45.8819770812989,5.75985479354864 45.8888893127441,5.75985479354864 45.8888893127441,5.75814342498785 45.8840866088867,5.75814342498785 45.8840866088867,5.75719881057751 45.8814506530761,5.75719881057751 45.8814506530761,5.76939678192144 45.8659057617187,5.76406955719006 45.8345108032227,5.76406955719006 45.8345108032227,5.76315927505505 45.825080871582,5.76315927505505 45.825080871582,5.76664924621582 45.8242530822754,5.76664924621582 45.8242530822754,5.77514266967779 45.8222084045411,5.78606033325201 45.8263359069824,5.78693437576294 45.8232231140138,5.78693437576294 45.8232231140138,5.79585027694702 45.8297996520996))0.0006POINT(5.778516807556205 45.85265960693362)