Datenbank-Dokumentation

Tabelle polygone_vereinfacht

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
36394POLYGON((5.94899797439587 47.4501419067382,5.94676399230963 47.4469451904297,5.95522689819342 47.4381217956544,5.95791482925426 47.4206848144532,5.94874477386475 47.4043159484863,5.94874477386475 47.4043159484863,5.925609111786 47.4014854431153,5.91621255874634 47.403377532959,5.9103360176087 47.3980293273926,5.9103360176087 47.3980293273926,5.90675592422485 47.3990478515625,5.90675592422485 47.3990478515625,5.89515638351452 47.4080581665039,5.89328098297119 47.4138679504395,5.89328098297119 47.4138679504395,5.89305448532104 47.4172973632814,5.89305448532104 47.4172973632814,5.89931297302246 47.4304275512696,5.89354228973389 47.4435272216797,5.89354228973389 47.4435272216797,5.90750551223766 47.4473381042482,5.91728019714361 47.4466361999512,5.93396949768072 47.4594306945801,5.93396949768072 47.4594306945801,5.94899797439587 47.4501419067382))0.0006POINT(5.917889515558919 47.42351039250695)
42580POLYGON((6.89836931228638 48.6657447814943,6.90230655670172 48.6565628051758,6.92018461227417 48.6462669372559,6.92018461227417 48.6462669372559,6.90004539489757 48.6377334594727,6.88945817947393 48.6269302368165,6.88945817947393 48.6269302368165,6.88452196121227 48.6325416564942,6.88606405258184 48.649269104004,6.89468765258789 48.6573905944825,6.89556503295904 48.6640510559083,6.89556503295904 48.6640510559083,6.89836931228638 48.6657447814943))0.0006POINT(6.898034214973497 48.647811571757074)
1390650POLYGON((-1.68212294578552 41.7578468322754,-1.6903909444809 41.7552566528321,-1.70432400703419 41.741325378418,-1.71544599533081 41.7382926940919,-1.72073602676392 41.7299385070801,-1.72730898857111 41.7251930236816,-1.7306159734726 41.7251472473144,-1.73200404644007 41.7231025695801,-1.74400997161865 41.7251777648926,-1.76104402542114 41.7183303833009,-1.78428494930262 41.7284660339356,-1.78771305084223 41.7341384887696,-1.79787802696228 41.7326164245605,-1.80915200710291 41.736671447754,-1.80261600017542 41.7512283325195,-1.82108402252192 41.7661018371583,-1.82491505146027 41.7736434936525,-1.82526397705072 41.778377532959,-1.82030403614039 41.7790641784669,-1.81379497051239 41.7823486328126,-1.81073200702662 41.7813682556153,-1.79617297649384 41.785858154297,-1.79887402057642 41.7811126708986,-1.7970780134201 41.7806053161622,-1.79040205478657 41.7842369079591,-1.76450002193445 41.7870063781738,-1.75477004051203 41.7917366027832,-1.74764502048492 41.7904510498048,-1.73538100719441 41.7911834716798,-1.72806298732752 41.7887687683106,-1.72251999378204 41.7891044616699,-1.7031379938125 41.7857894897462,-1.6994279623031 41.7830009460449,-1.69804894924158 41.7744979858398,-1.68274903297424 41.782413482666,-1.68471598625183 41.7739715576172,-1.68349504470825 41.7701835632324,-1.68740594387054 41.7624816894531,-1.68212294578552 41.7578468322754))0.0006POINT(-1.752108633518185 41.762790479158134)
20537POLYGON((7.59648752212536 48.3219451904298,7.59047365188604 48.3231811523438,7.59047365188604 48.3231811523438,7.59884834289551 48.3412208557129,7.59884834289551 48.3412208557129,7.60108137130743 48.346508026123,7.60922050476069 48.347282409668,7.60922050476069 48.347282409668,7.61037874221813 48.3439903259278,7.62429904937756 48.3402481079103,7.64020347595221 48.3276100158693,7.64020347595221 48.3276100158693,7.63223743438732 48.3214073181153,7.63223743438732 48.3214073181153,7.61926221847528 48.325538635254,7.60621261596685 48.3211250305177,7.59648752212536 48.3219451904298))0.0006POINT(7.6124805212021345 48.33254742622383)
69735MULTIPOLYGON(((9.95001029968267 54.4125061035157,9.9456138610841 54.4133033752442,9.94238376617432 54.4178123474121,9.94313907623291 54.4189376831055,9.94394302368158 54.4186820983888,9.94394302368158 54.4186820983888,9.9482355117799 54.4176673889161,9.95001029968267 54.4125061035157)),((9.87215995788574 54.3701591491699,9.87006568908703 54.3671951293945,9.87363910675049 54.3625602722169,9.87211990356451 54.3623733520507,9.87180423736572 54.360855102539,9.87029838562017 54.3597259521484,9.87029838562017 54.3597259521484,9.89247417449951 54.352741241455,9.89247417449951 54.352741241455,9.91473102569586 54.346004486084,9.91473102569586 54.346004486084,9.91576099395752 54.3471145629882,9.91281700134283 54.3477210998536,9.91404438018799 54.3489646911621,9.91574001312267 54.348648071289,9.9213695526123 54.3505973815919,9.9191102981568 54.3517456054688,9.92132949829107 54.3536033630372,9.9227170944215 54.3532333374023,9.9248743057251 54.3563041687012,9.93136501312262 54.3572044372559,9.92992782592779 54.3589591979981,9.93269729614252 54.3634147644042,9.93164062499994 54.3665885925294,9.93831348419189 54.3665657043458,9.93831348419189 54.3665657043458,9.93726921081554 54.3688697814942,9.9393825531007 54.3718605041504,9.93829250335688 54.3752479553222,9.93661499023432 54.37650680542,9.94526290893566 54.3785209655762,9.95733833312994 54.3857002258302,9.96333789825445 54.3905563354493,9.96164321899425 54.3956871032715,9.96164321899425 54.3956871032715,9.96140289306635 54.3964042663575,9.96285629272461 54.3970642089845,9.96277236938482 54.3988418579102,9.95597457885737 54.3998374938966,9.95350170135498 54.4042701721191,9.94995498657232 54.4036521911622,9.95370388031017 54.4077377319337,9.9504194259643 54.4106559753419,9.9504194259643 54.4106559753419,9.94221210479748 54.4120750427246,9.93417549133295 54.4098930358887,9.92523479461664 54.4109573364259,9.90781593322765 54.4038734436035,9.9021196365357 54.4040794372559,9.9021196365357 54.4040794372559,9.90137100219738 54.4014472961426,9.89665508270264 54.3976097106934,9.89509963989269 54.3944129943848,9.89193153381353 54.3932418823243,9.88297080993647 54.3925590515138,9.88139533996582 54.3909072875977,9.88320922851557 54.3824348449708,9.88736343383789 54.3769760131837,9.88798522949219 54.3710823059082,9.88443279266357 54.3700218200684,9.87215995788574 54.3701591491699)))0.0006POINT(9.91908119763638 54.377978856035284)
46316POLYGON((2.02791523933416 43.6478424072265,2.02620196342474 43.6575012207032,2.01426267623901 43.6490707397462,2.00496339797974 43.6486358642578,2.00168681144714 43.6510543823243,2.00168681144714 43.6510543823243,1.98968994617456 43.6468582153321,1.96784102916723 43.6517639160157,1.96784102916723 43.6517639160157,1.96751546859741 43.648509979248,1.95671260356914 43.6428756713868,1.95673716068279 43.6238136291504,1.95673716068279 43.6238136291504,1.99625778198242 43.6135864257813,1.99625778198242 43.6135864257813,2.01603078842169 43.6312446594239,2.0160861015321 43.6345291137695,2.0160861015321 43.6345291137695,2.02791523933416 43.6478424072265))0.0006POINT(1.993361658520212 43.64011298285593)
23568POLYGON((-0.363549202680531 43.4573364257812,-0.356796145439148 43.4648933410645,-0.356796145439148 43.4648933410645,-0.347631722688675 43.460376739502,-0.347631722688675 43.460376739502,-0.335816085338536 43.4561576843262,-0.330382287502232 43.4506988525391,-0.330382287502232 43.4506988525391,-0.332538306713047 43.4339447021485,-0.332538306713047 43.4339447021485,-0.345839738845768 43.4361724853516,-0.360092759132385 43.4447288513184,-0.360092759132385 43.4447288513184,-0.363549202680531 43.4573364257812))0.0006POINT(-0.346160574601216 43.450688582200314)
39576POLYGON((3.30310773849499 43.4750556945801,3.31992912292492 43.4785690307618,3.32070040702814 43.4817428588867,3.32070040702814 43.4817428588867,3.307770729065 43.4991531372071,3.29948806762707 43.4963874816895,3.29063534736639 43.4980697631837,3.28840804100037 43.4951133728028,3.28840804100037 43.4951133728028,3.29278898239136 43.4889831542969,3.2934725284577 43.475227355957,3.2934725284577 43.475227355957,3.29618787765509 43.4771270751954,3.30310773849499 43.4750556945801))0.0006POINT(3.3011592168074797 43.485962500939046)
1389012POLYGON((-5.2059650421142 36.3856925964357,-5.20708417892456 36.3856925964357,-5.20791578292841 36.3837509155273,-5.20930576324457 36.383472442627,-5.21097183227533 36.3798599243165,-5.2173609733581 36.3793067932129,-5.22192621231073 36.3737144470215,-5.22767591476435 36.3744010925294,-5.24507522583008 36.3841590881349,-5.24751377105713 36.3840789794923,-5.25302886962885 36.3878479003907,-5.25554704666132 36.3873977661133,-5.25874090194702 36.3894653320313,-5.26467990875244 36.382511138916,-5.26858186721796 36.3817863464356,-5.27056217193604 36.383586883545,-5.27543306350708 36.383186340332,-5.27591609954828 36.376392364502,-5.28049898147583 36.3703651428223,-5.28988313674915 36.3646430969239,-5.29582691192627 36.357967376709,-5.30418586730957 36.341423034668,-5.31386804580677 36.333553314209,-5.31542015075684 36.3287582397462,-5.31993293762201 36.3250999450684,-5.32285308837885 36.3321990966798,-5.31535720825195 36.3408813476563,-5.3150057792663 36.3433685302735,-5.32054376602161 36.3460540771485,-5.32589292526239 36.3576393127443,-5.33474302291864 36.3700370788575,-5.33388090133667 36.3788719177246,-5.33628797531122 36.382942199707,-5.33481788635248 36.3949050903321,-5.33806085586542 36.3978309631348,-5.34700489044184 36.4186782836914,-5.3571310043335 36.4238662719727,-5.35786485671991 36.4319076538087,-5.35530281066895 36.4338226318361,-5.3523969650268 36.4384536743163,-5.33401584625238 36.4537467956544,-5.31881380081177 36.463264465332,-5.31454706192017 36.471046447754,-5.30982112884521 36.4749832153321,-5.30408191680903 36.47562789917,-5.29309797286982 36.4846420288086,-5.28827619552612 36.5005531311035,-5.28446292877197 36.5029640197755,-5.28138780593866 36.5092926025391,-5.27775478363037 36.5083541870118,-5.27666091918945 36.5114555358887,-5.27853918075556 36.5130424499512,-5.27806997299189 36.5198554992676,-5.27563095092768 36.5174179077148,-5.27213001251215 36.5180053710938,-5.27094078063953 36.5204505920411,-5.26790285110474 36.5204315185548,-5.26492786407471 36.5165100097656,-5.26584911346436 36.5147171020509,-5.26364088058472 36.5159492492677,-5.25473785400391 36.515480041504,-5.25227499008179 36.5141105651855,-5.24227094650257 36.5179862976075,-5.24074697494507 36.5162315368652,-5.23585796356195 36.5155258178711,-5.22787904739374 36.5075302124023,-5.22637510299683 36.5029525756836,-5.21993780136108 36.4961051940919,-5.21313714981073 36.4936332702638,-5.2053108215332 36.4794120788574,-5.20939302444447 36.467945098877,-5.21096992492676 36.452693939209,-5.21952295303339 36.4298934936523,-5.2167592048645 36.4095726013184,-5.2059650421142 36.3856925964357))0.0006POINT(-5.275483382714726 36.43149937810127)
31916POLYGON((1.44403803348547 48.7408294677736,1.43101322650921 48.7370338439942,1.41547954082495 48.7254486083984,1.41547954082495 48.7254486083984,1.41906464099884 48.7161674499512,1.41906464099884 48.7161674499512,1.43793964385998 48.7146224975587,1.44118082523357 48.7121582031251,1.44118082523357 48.7121582031251,1.44550824165344 48.7106285095215,1.45444965362555 48.7130317687989,1.45444965362555 48.7130317687989,1.46490645408642 48.7207946777345,1.46490645408642 48.7207946777345,1.46715688705439 48.7325973510743,1.46715688705439 48.7325973510743,1.45763671398157 48.7330894470216,1.44884765148174 48.7405471801758,1.44403803348547 48.7408294677736))0.0006POINT(1.4438588619232697 48.72317483690057)