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
54273POLYGON((5.11734247207642 45.8806800842285,5.11225175857555 45.8868370056152,5.11225175857555 45.8868370056152,5.12949752807623 45.8931808471679,5.13939094543463 45.9007873535157,5.15393590927135 45.9028625488282,5.15393590927135 45.9028625488282,5.16567087173462 45.8928337097169,5.15958118438715 45.8763580322267,5.14713239669811 45.8656692504884,5.14713239669811 45.8656692504884,5.1321177482605 45.8795394897462,5.11734247207642 45.8806800842285))0.0006POINT(5.139186739921631 45.88617642720546)
16708POLYGON((13.6677598953247 42.9189987182618,13.6690969467163 42.9194869995117,13.6794624328614 42.9177551269531,13.6993293762206 42.9022483825684,13.6993293762206 42.9022483825684,13.6933336257935 42.8979225158693,13.6909294128417 42.8946723937989,13.6914291381836 42.8912734985352,13.6832733154297 42.8762893676759,13.6775207519531 42.8733024597169,13.6775207519531 42.8733024597169,13.6740293502808 42.8751640319825,13.6657123565673 42.8747673034668,13.6639366149903 42.8701934814454,13.6554927825929 42.8701095581055,13.6533660888672 42.8716278076172,13.6532220840455 42.8771133422852,13.6374883651734 42.8906478881836,13.6318922042847 42.8894233703613,13.6281433105469 42.8872718811036,13.621590614319 42.8865242004394,13.6183128356934 42.8947906494142,13.6183128356934 42.8947906494142,13.627184867859 42.8978614807129,13.6344299316406 42.9053573608398,13.6339902877808 42.9074859619141,13.6281738281251 42.9162940979004,13.6299457550049 42.9175338745117,13.6471662521363 42.9250946044923,13.6484880447388 42.9246330261232,13.6512718200683 42.9199943542481,13.6529064178467 42.9191932678223,13.6681509017944 42.9167480468751,13.6677598953247 42.9189987182618))0.0006POINT(13.656733108289332 42.89697334983137)
53139POLYGON((6.76368141174322 44.4715766906738,6.77940082550055 44.4967803955079,6.80551767349255 44.5061378479004,6.8189268112182 44.5019874572754,6.83274221420288 44.4921607971191,6.85167551040661 44.5017051696777,6.86133718490595 44.5024757385254,6.86082172393805 44.5048179626465,6.87673807144165 44.5113639831544,6.87673807144165 44.5113639831544,6.88308238983154 44.4981193542481,6.88308238983154 44.4981193542481,6.87208890914917 44.4904060363771,6.87102603912359 44.4907798767091,6.85901594161987 44.4797515869141,6.85653257370001 44.4730606079102,6.83363962173462 44.4593772888184,6.82437515258795 44.4468841552734,6.80793809890747 44.4337196350099,6.80793809890747 44.4337196350099,6.77864837646484 44.4422531127929,6.77864837646484 44.4422531127929,6.76774597167963 44.456657409668,6.76951217651379 44.46635055542,6.76368141174322 44.4715766906738))0.0006POINT(6.830035567283652 44.47965923945112)
62085POLYGON((7.89177036285395 52.3805122375489,7.88975000381481 52.3816223144531,7.88976144790649 52.3927154541016,7.88810586929327 52.4000587463379,7.88413000106823 52.404670715332,7.86867523193359 52.4087867736816,7.87153673172003 52.412956237793,7.87830877304083 52.4164390563965,7.87927007675177 52.418628692627,7.87294387817377 52.4318771362305,7.87145090103149 52.4328384399415,7.8712100982666 52.4353523254395,7.86736869812017 52.4337387084962,7.86482191085821 52.4366188049316,7.86994552612305 52.4381332397462,7.86841773986822 52.44234085083,7.86573982238775 52.4423065185547,7.8643040657044 52.4441833496094,7.86256504058849 52.4439582824708,7.86327981948858 52.4465866088868,7.86084938049328 52.4465484619141,7.86049175262463 52.4487953186036,7.86194419860834 52.4488258361816,7.86154413223278 52.4530792236329,7.86306524276739 52.4557914733887,7.84427595138561 52.4643592834473,7.84427595138561 52.4643592834473,7.84301567077648 52.4617500305177,7.8482990264892 52.4510459899903,7.84617805480968 52.4506263732911,7.83782672882091 52.4429244995118,7.83385896682745 52.4415588378907,7.83500337600714 52.440658569336,7.82673645019531 52.4335479736329,7.82384443283087 52.4329071044921,7.82397890090948 52.431266784668,7.81500339508062 52.4281196594239,7.81107854843151 52.4368438720704,7.80854272842402 52.4355430603027,7.80663108825678 52.4381904602051,7.79945659637463 52.4357528686525,7.79831457138056 52.4415283203125,7.79974985122686 52.4417610168458,7.80157041549683 52.4463462829589,7.78891515731823 52.4442672729493,7.78891515731823 52.4442672729493,7.78681230545044 52.4392127990723,7.78347730636591 52.4398918151855,7.78259611129772 52.4385719299316,7.77884721755987 52.4379463195802,7.778489112854 52.4361381530762,7.78505468368536 52.4350280761719,7.78218555450434 52.4283638000489,7.77923583984375 52.4267158508301,7.78458738327026 52.4258155822754,7.78104925155645 52.4237823486328,7.78368663787842 52.4233169555665,7.78143787384033 52.4218635559083,7.76489639282232 52.4191284179689,7.76696681976313 52.4158210754396,7.77090024948126 52.4164581298829,7.77380180358898 52.4120101928712,7.74837541580212 52.3919105529786,7.74837541580212 52.3919105529786,7.78344297409058 52.379596710205,7.78344297409058 52.379596710205,7.80555534362799 52.3718338012696,7.81351041793835 52.3709907531739,7.81351041793835 52.3709907531739,7.84303569793701 52.369026184082,7.87051200866694 52.3774986267089,7.8902792930603 52.3785820007325,7.89177036285395 52.3805122375489))0.0006POINT(7.827510919835877 52.42537487877741)
38505POLYGON((0.75535261631012 49.5673179626465,0.738073050975743 49.5786323547364,0.73303854465496 49.5874404907227,0.73303854465496 49.5874404907227,0.728397428989467 49.5879440307617,0.728397428989467 49.5879440307617,0.708270668983459 49.5790977478027,0.693642556667385 49.5787849426271,0.691342890262661 49.5758094787598,0.699803233146724 49.5678062438965,0.699803233146724 49.5678062438965,0.700583398342133 49.5645866394043,0.745782911777439 49.5617485046387,0.745782911777439 49.5617485046387,0.75535261631012 49.5673179626465))0.0006POINT(0.7215221013341916 49.57529340471542)
20293POLYGON((11.382025718689 45.5769577026367,11.3880062103273 45.5596046447754,11.3936710357665 45.563274383545,11.3936710357665 45.563274383545,11.4186363220215 45.5621719360352,11.4186363220215 45.5621719360352,11.4279937744141 45.5700035095215,11.4279937744141 45.5700035095215,11.4243154525756 45.5744476318361,11.4261636734009 45.5929565429687,11.4250822067261 45.5972404479982,11.4250822067261 45.5972404479982,11.4193248748779 45.6065406799318,11.4053869247438 45.6176719665527,11.4053869247438 45.6176719665527,11.3879079818726 45.6047363281251,11.3841447830201 45.6049156188965,11.381332397461 45.59481048584,11.3837127685546 45.5874519348145,11.3789463043214 45.5868873596192,11.3789463043214 45.5868873596192,11.382025718689 45.5769577026367))0.0006POINT(11.403636523655514 45.58556765601754)
1399180POLYGON((-3.39778804779053 41.7996711730958,-3.3878390789032 41.8064422607423,-3.3768630027771 41.8111267089844,-3.37343502044672 41.820110321045,-3.36737489700306 41.8277854919434,-3.37078189849848 41.8319625854493,-3.36525511741627 41.8360404968262,-3.36384201049805 41.8398017883301,-3.34732294082642 41.8563537597657,-3.33810400962824 41.8579750061036,-3.335870027542 41.8571243286133,-3.33339691162104 41.8680953979492,-3.32545495033253 41.8702049255372,-3.31506896018976 41.8849983215332,-3.30483794212341 41.8804321289063,-3.28950095176697 41.8764114379883,-3.28389000892639 41.8695068359376,-3.27896690368647 41.8679122924804,-3.28478789329529 41.851661682129,-3.28376197814936 41.8457298278809,-3.28893804550171 41.8424644470215,-3.28867197036743 41.8285675048829,-3.28458309173584 41.8272628784181,-3.28107094764704 41.8229026794434,-3.28480410575867 41.8145980834962,-3.28746604919428 41.815170288086,-3.29190802574158 41.8121223449706,-3.29384303092957 41.8087120056152,-3.29136991500854 41.8055381774903,-3.28664088249201 41.8053550720215,-3.28523898124689 41.8014106750489,-3.27531409263611 41.799903869629,-3.27531409263611 41.7943267822266,-3.28579497337336 41.7882499694825,-3.28349995613098 41.7782516479493,-3.27538394927979 41.7686767578126,-3.28699207305897 41.760139465332,-3.29609489440918 41.7619972229004,-3.30715489387512 41.7601585388184,-3.30961203575123 41.7510070800781,-3.32160711288446 41.749195098877,-3.32501196861267 41.7495231628419,-3.3267450332641 41.7517547607421,-3.32876205444336 41.7509727478028,-3.32962107658386 41.7546539306641,-3.33347296714783 41.7552375793458,-3.33923411369324 41.7528991699218,-3.34659600257868 41.7528839111329,-3.35833311080933 41.7548484802247,-3.36367607116694 41.7593460083009,-3.36743593215937 41.7667541503907,-3.37615895271296 41.7731552124023,-3.38484001159662 41.7780723571778,-3.40383005142206 41.7821502685547,-3.41164898872375 41.787525177002,-3.41107702255238 41.7902832031249,-3.40530395507807 41.7964477539063,-3.39778804779053 41.7996711730958))0.0006POINT(-3.3266174207653574 41.805471319901336)
35273POLYGON((8.92474269866938 42.5811653137206,8.9418220520019 42.5835609436036,8.94915103912365 42.5873527526856,8.94915103912365 42.5873527526856,8.94874763488775 42.5746803283691,8.95172119140625 42.5722694396973,8.95172119140625 42.5722694396973,8.94467353820801 42.5634498596191,8.94467544555675 42.5435066223145,8.96581459045404 42.5308685302736,8.96581459045404 42.5308685302736,8.96150207519537 42.5181350708008,8.9395866394043 42.5159454345704,8.9395866394043 42.5159454345704,8.93234825134272 42.5196571350098,8.93234825134272 42.5196571350098,8.93446063995361 42.5299949645997,8.92304325103771 42.540584564209,8.93030548095703 42.5530090332032,8.91708087921143 42.5715484619141,8.91708087921143 42.5715484619141,8.91883850097651 42.5745697021486,8.91883850097651 42.5745697021486,8.92474269866938 42.5811653137206))0.0006POINT(8.93926326088284 42.553587374479925)
24813POLYGON((2.73978352546703 45.8739662170411,2.754872083664 45.8727645874023,2.754872083664 45.8727645874023,2.76125049591076 45.8674583435059,2.77515888214123 45.8674697875977,2.77269864082336 45.8576393127441,2.7784242630006 45.8439826965333,2.7784242630006 45.8439826965333,2.77644157409668 45.8308830261232,2.75255918502819 45.8107261657715,2.75255918502819 45.8107261657715,2.73400449752813 45.8212814331055,2.73095560073853 45.831127166748,2.72156810760492 45.8330116271973,2.70784783363342 45.8429298400879,2.70784783363342 45.8429298400879,2.70802092552196 45.8516082763672,2.7144980430603 45.8550491333008,2.7144980430603 45.8550491333008,2.73744106292736 45.867774963379,2.73978352546703 45.8739662170411))0.0006POINT(2.7436863064766497 45.84765625000003)
49960POLYGON((3.43023371696478 49.2752799987794,3.41583323478704 49.2733612060548,3.41320466995245 49.2762489318848,3.41320466995245 49.2762489318848,3.40398693084728 49.2729530334473,3.39288020133978 49.2613487243653,3.38382363319408 49.2644081115723,3.38054609298717 49.274486541748,3.36869144439697 49.2805709838868,3.36869144439697 49.2805709838868,3.37025952339178 49.2635574340821,3.37025952339178 49.2635574340821,3.38014864921576 49.255958557129,3.40084385871887 49.2574195861818,3.40521049499523 49.255527496338,3.40925216674805 49.2456169128419,3.40925216674805 49.2456169128419,3.42052054405224 49.2466354370118,3.42052054405224 49.2466354370118,3.43645381927496 49.2634353637696,3.43048048019421 49.2686004638673,3.43023371696478 49.2752799987794))0.0006POINT(3.401157038552482 49.264192308698455)