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
52467POLYGON((0.146514192223606 45.9405860900879,0.153883352875766 45.9401931762696,0.153883352875766 45.9401931762696,0.166728094220275 45.9267578125,0.166728094220275 45.9267578125,0.162753045559043 45.9169425964355,0.148173332214299 45.9162788391114,0.141435623169059 45.9112815856934,0.141435623169059 45.9112815856934,0.120362475514469 45.9155921936035,0.120362475514469 45.9155921936035,0.11929959058773 45.9292526245117,0.11929959058773 45.9292526245117,0.125829011201859 45.9377555847168,0.146514192223606 45.9405860900879))0.0006POINT(0.1419062752809575 45.92555127825057)
21871POLYGON((-0.601722240447998 45.1828651428223,-0.603169143199921 45.1823768615724,-0.603169143199921 45.1823768615724,-0.623025655746403 45.1648979187012,-0.623025655746403 45.1648979187012,-0.614285707473755 45.1584129333496,-0.614285707473755 45.1584129333496,-0.590407073497659 45.1652755737306,-0.590407073497659 45.1652755737306,-0.59553021192545 45.1777572631836,-0.601722240447998 45.1828651428223))0.0006POINT(-0.6059027612208924 45.17025489807135)
34921POLYGON((3.88638186454784 49.2625427246094,3.88359618186951 49.2651176452637,3.86479830741888 49.2656402587891,3.85818290710461 49.2701454162598,3.85818290710461 49.2701454162598,3.84565758705145 49.2788009643555,3.84718847274792 49.2816696166993,3.84718847274792 49.2816696166993,3.86097884178162 49.2779846191406,3.86097884178162 49.2779846191406,3.90586400032055 49.2784118652344,3.90586400032055 49.2784118652344,3.92522931098938 49.2778778076172,3.92522931098938 49.2778778076172,3.9243371486665 49.2671852111816,3.9243371486665 49.2671852111816,3.9146142005921 49.2689399719238,3.88638186454784 49.2625427246094))0.0006POINT(3.88462408851182 49.2733876845416)
58818POLYGON((7.49424266815191 51.2398147583009,7.50131225585932 51.2425003051759,7.50222492218018 51.244125366211,7.49687099456798 51.2487983703614,7.49396896362299 51.2486343383788,7.49307775497442 51.2501449584962,7.49516344070435 51.2506065368653,7.49507045745855 51.2518348693848,7.49605798721319 51.2525062561036,7.50293970108044 51.2527160644532,7.50322198867798 51.255973815918,7.50501251220709 51.2557640075685,7.50431442260742 51.2580909729004,7.50600767135631 51.2572746276857,7.51049995422358 51.2575607299806,7.51248216629023 51.2638473510743,7.51725292205811 51.2648696899414,7.51725292205811 51.2648696899414,7.52360296249401 51.2654876708985,7.52530288696289 51.2668075561523,7.52798461914074 51.2671585083008,7.52838516235357 51.2689628601074,7.52984571456909 51.2696838378907,7.53474950790405 51.2704353332521,7.53735685348511 51.2685050964357,7.54137420654297 51.2696495056153,7.54338026046753 51.2683601379396,7.54888153076178 51.2696418762208,7.54923105239862 51.2747192382814,7.55797863006603 51.2782440185547,7.55900812149059 51.2801055908203,7.5655946731568 51.2812881469727,7.56892395019537 51.2907905578614,7.57173824310308 51.2907981872559,7.57290077209473 51.2921676635742,7.57847833633434 51.2934341430665,7.5814347267152 51.2957305908204,7.58319282531738 51.2958641052246,7.58319282531738 51.2958641052246,7.59119033813488 51.2847557067872,7.60054683685308 51.2845993041993,7.60679769515997 51.2870407104493,7.61345243453974 51.2844123840332,7.61914491653454 51.2849960327149,7.62079429626476 51.2831802368164,7.61939573287964 51.2807502746583,7.63310050964355 51.2755317687989,7.63310050964355 51.2755317687989,7.63277196884155 51.2725067138672,7.63137483596813 51.2705116271973,7.63137483596813 51.2705116271973,7.61734247207647 51.2637634277344,7.61613321304333 51.2624473571778,7.61695623397827 51.2607650756837,7.61489820480347 51.2603988647462,7.61437845230108 51.2611351013184,7.59586524963385 51.2520332336426,7.58567094802868 51.250328063965,7.58598613739019 51.2492027282715,7.58110952377331 51.2469100952148,7.58437681198126 51.2426605224611,7.58322668075562 51.2433815002441,7.57690048217785 51.2422409057618,7.57486200332653 51.241138458252,7.57520532608038 51.2400207519532,7.56884098052973 51.240177154541,7.56504583358759 51.238494873047,7.55613040924072 51.2404174804689,7.55534362792969 51.2383613586426,7.55637025833136 51.2373313903809,7.55482387542736 51.2350425720215,7.55555772781383 51.2336578369141,7.55234193801886 51.231460571289,7.55637168884272 51.2296714782715,7.55944585800177 51.2298126220703,7.55873012542725 51.2241668701173,7.56428527832031 51.2229537963868,7.5652956962586 51.2219429016114,7.55883407592773 51.2205123901368,7.55883407592773 51.2205123901368,7.55416584014898 51.2213134765626,7.55290937423706 51.2225799560547,7.55338191986084 51.2243804931642,7.55183362960821 51.2246055603028,7.55179643630981 51.2265281677247,7.54884099960321 51.2283477783204,7.54986286163324 51.230308532715,7.54852867126476 51.2309875488282,7.54449415206903 51.2301635742188,7.54356861114496 51.2313995361329,7.54284238815319 51.2299766540528,7.54510593414312 51.2271003723145,7.54094505310059 51.2266883850098,7.54061412811291 51.2249145507813,7.53391361236584 51.2263107299804,7.53327846527111 51.2245941162109,7.52854442596441 51.2232856750489,7.52451086044317 51.2264595031738,7.52242565155029 51.225887298584,7.52214431762707 51.2242469787598,7.51617479324347 51.2227554321289,7.51400899887096 51.2238693237305,7.50824451446545 51.2229843139649,7.50713205337524 51.2209014892579,7.50333595275885 51.2223892211915,7.5026154518128 51.225757598877,7.50015497207642 51.228973388672,7.50084781646734 51.2364006042481,7.49651145935059 51.2373542785645,7.49424266815191 51.2398147583009))0.0006POINT(7.552150945051038 51.25064555876848)
68449POLYGON((6.7975487709046 49.4586639404297,6.79687547683716 49.4575424194337,6.79878664016735 49.457130432129,6.79655599594122 49.4543457031251,6.80093383789057 49.4534797668458,6.80190277099609 49.4502334594727,6.79761695861822 49.4491996765137,6.79563856124889 49.4470901489259,6.7951278686524 49.444766998291,6.79706764221197 49.4425430297853,6.79348850250256 49.4420318603516,6.79302120208746 49.4393234252929,6.79070615768438 49.4390754699707,6.78960132598871 49.436752319336,6.78609609603888 49.4367141723633,6.79507303237909 49.4326171875001,6.79515314102184 49.4286880493164,6.79651212692272 49.4271850585938,6.79493236541748 49.4203262329102,6.79554796218872 49.4173660278321,6.79868936538708 49.4158363342286,6.79868936538708 49.4158363342286,6.79126358032238 49.4081382751464,6.78723335266125 49.4061737060547,6.77840662002563 49.4034461975098,6.76338529586792 49.4018821716309,6.75817060470587 49.3995475769042,6.75426387786871 49.3958511352539,6.75009870529175 49.3945846557618,6.7465491294862 49.3951530456544,6.7465491294862 49.3951530456544,6.74319410324108 49.3962287902833,6.738437652588 49.3922958374024,6.73323488235468 49.3901939392091,6.72989749908453 49.3877143859864,6.71710681915295 49.3836822509766,6.71999835968018 49.3818321228027,6.71725749969494 49.3805503845215,6.71573686599743 49.3786621093749,6.708083152771 49.3768844604493,6.70869731903076 49.3752174377442,6.7008957862854 49.3737487792969,6.70068740844738 49.372371673584,6.69726657867437 49.3721923828125,6.69726657867437 49.3721923828125,6.69565010070812 49.3722305297852,6.69293498992926 49.3746337890626,6.69432449340826 49.3781547546388,6.69373035430908 49.381992340088,6.670892238617 49.389476776123,6.66195344924927 49.3989181518555,6.66195344924927 49.3989181518555,6.67172622680664 49.4002876281739,6.67385530471813 49.3983421325684,6.678297996521 49.3973236083986,6.68451261520397 49.3983154296874,6.68800926208496 49.3998146057129,6.68981313705456 49.4019546508789,6.6892523765564 49.4046669006349,6.69067716598505 49.4067153930664,6.69238615036005 49.4076194763184,6.6994361877442 49.4062728881837,6.70031499862671 49.4071998596191,6.70054817199713 49.4087867736817,6.69636774063105 49.412410736084,6.69577503204346 49.4146614074707,6.69879770278931 49.4178047180177,6.70165538787842 49.4166259765624,6.70417547225958 49.4184761047363,6.70616817474365 49.4221992492677,6.70951557159424 49.42440032959,6.71129179000854 49.4315147399903,6.71565818786621 49.4389381408692,6.72317314147955 49.4436454772949,6.72487688064587 49.4456825256349,6.72293996810919 49.4483718872071,6.7182703018189 49.4506568908693,6.71159219741821 49.4597511291504,6.70936346054089 49.4600105285644,6.70936346054089 49.4600105285644,6.71070337295532 49.4654350280762,6.71558523178112 49.4674911499025,6.72872400283819 49.4623908996583,6.7370109558106 49.4623527526855,6.73634910583502 49.4611053466797,6.74288606643682 49.4566955566406,6.74333572387701 49.4546661376954,6.74452543258667 49.454288482666,6.75363683700573 49.4556274414063,6.75459861755371 49.4544639587403,6.75859546661383 49.4544143676758,6.76864147186279 49.4616737365724,6.7834553718568 49.4645233154297,6.78716278076183 49.4630508422852,6.79244041442882 49.4625320434571,6.79330635070812 49.457950592041,6.79485416412348 49.4591979980469,6.7975487709046 49.4586639404297))0.0006POINT(6.738601138911345 49.42180503766562)
24205POLYGON((3.75980639457708 45.3147430419922,3.76298546791077 45.3269424438477,3.75161027908325 45.3315849304199,3.75161027908325 45.3315849304199,3.71402168273931 45.3203392028809,3.71402168273931 45.3203392028809,3.71652913093578 45.3138236999511,3.70281815528881 45.296314239502,3.70281815528881 45.296314239502,3.71395421028149 45.2861862182618,3.72287869453442 45.2848320007324,3.72287869453442 45.2848320007324,3.73468351364136 45.2813949584962,3.74425840377808 45.29158782959,3.74425840377808 45.29158782959,3.74766683578497 45.3088645935058,3.75980639457708 45.3147430419922))0.0006POINT(3.7316749989987 45.30507946014407)
33243POLYGON((4.82251739501959 49.5636329650879,4.80203628540045 49.5624618530274,4.77277898788458 49.5688362121583,4.76572990417492 49.5640029907228,4.75572443008429 49.562385559082,4.75572443008429 49.562385559082,4.75359296798712 49.564323425293,4.75359296798712 49.564323425293,4.7701845169068 49.5885848999024,4.75876712799072 49.6040153503417,4.76112413406366 49.6106338500977,4.75722980499273 49.6168823242189,4.73714876174938 49.6182861328125,4.73714876174938 49.6182861328125,4.75239992141735 49.6305961608887,4.75341463088989 49.6404418945313,4.75341463088989 49.6404418945313,4.77031230926514 49.646812438965,4.77529716491699 49.6528511047363,4.77529716491699 49.6528511047363,4.78184652328497 49.6477127075196,4.80240488052374 49.6469764709473,4.80896139144903 49.6417388916016,4.80896139144903 49.6417388916016,4.80137443542492 49.6369552612305,4.80509901046759 49.6303291320802,4.83570766448986 49.6105804443361,4.83570766448986 49.6105804443361,4.83066082000744 49.60986328125,4.83155059814464 49.5929450988771,4.83155059814464 49.5929450988771,4.82574510574352 49.5879516601562,4.83422279357916 49.5849113464357,4.83948183059692 49.5761756896972,4.83948183059692 49.5761756896972,4.82251739501959 49.5636329650879))0.0006POINT(4.788462652478959 49.60630329677043)
52514POLYGON((0.539723038673458 45.8532409667969,0.538468658924216 45.8599700927736,0.538468658924216 45.8599700927736,0.544522702693996 45.8653259277343,0.557730734348354 45.8696289062501,0.557730734348354 45.8696289062501,0.569395780563354 45.8610000610352,0.576661348342952 45.8655586242677,0.58730340003973 45.8598861694337,0.596684455871582 45.8600234985352,0.596684455871582 45.8600234985352,0.603387176990509 45.8553276062012,0.599578797817287 45.8462562561036,0.615685284137726 45.827335357666,0.615685284137726 45.827335357666,0.602985441684723 45.8298606872559,0.594191253185329 45.8282051086427,0.59086745977396 45.8222770690919,0.59086745977396 45.8222770690919,0.582613289356232 45.8330383300782,0.582613289356232 45.8330383300782,0.579499363899174 45.8388023376465,0.570405244827384 45.8410110473633,0.55192619562149 45.8382797241211,0.552821516990718 45.848316192627,0.548911154270172 45.8545036315919,0.539723038673458 45.8532409667969))0.0006POINT(0.5763620069394007 45.847312340369655)
19883POLYGON((11.7217407226562 45.2508659362794,11.7245826721192 45.2466049194336,11.720705986023 45.24467086792,11.7108058929443 45.2312965393066,11.7122173309327 45.2309684753419,11.7137794494628 45.2265892028809,11.7039480209351 45.2204513549804,11.6990404129029 45.220100402832,11.6990404129029 45.220100402832,11.6965312957764 45.2195472717286,11.6952800750734 45.2203140258789,11.6936388015747 45.2249259948732,11.6886997222902 45.2314682006837,11.6800203323365 45.2324562072754,11.671944618225 45.2352027893068,11.6724643707276 45.2381248474121,11.6535387039184 45.2472877502441,11.644097328186 45.245922088623,11.6355218887329 45.2605247497559,11.6351423263551 45.2625122070313,11.6351423263551 45.2625122070313,11.6358194351197 45.2683105468751,11.6358194351197 45.2683105468751,11.6640491485596 45.2665863037111,11.6743297576905 45.2729797363282,11.6767005920411 45.278118133545,11.6832704544069 45.2835998535156,11.6902341842652 45.285530090332,11.7035770416261 45.2869873046876,11.7053127288818 45.2851486206055,11.7053127288818 45.2851486206055,11.7058172225953 45.2839584350587,11.7058172225953 45.2839584350587,11.7072324752809 45.2834014892578,11.7074928283691 45.2819290161133,11.7017135620117 45.2770233154297,11.6965513229371 45.2676239013672,11.69739818573 45.2612915039062,11.7090978622437 45.247875213623,11.7134847640991 45.2477073669434,11.7217407226562 45.2508659362794))0.0006POINT(11.688172841072124 45.25469837188723)
1402902POLYGON((1.79263401031488 41.4738311767579,1.79790103435528 41.4672126770021,1.78739905357372 41.4671173095704,1.77992105484009 41.4634590148925,1.77742302417755 41.4647789001466,1.77430498600006 41.4630813598633,1.7761670351029 41.450813293457,1.76887905597692 41.4457397460938,1.75253498554224 41.4513359069825,1.74929404258734 41.4533348083497,1.75157499313366 41.4576950073242,1.74729299545299 41.4587020874024,1.74659299850475 41.4602699279785,1.75303399562847 41.4653625488282,1.74795401096355 41.4662742614747,1.74246799945843 41.4696578979492,1.74424803256989 41.4730339050293,1.73960101604473 41.4720268249513,1.73710703849792 41.4732856750489,1.74386703968054 41.4771919250488,1.73956894874584 41.4802894592285,1.73687899112707 41.480354309082,1.73296201229101 41.4836120605469,1.73342895507824 41.4855728149415,1.72868096828461 41.4874458312989,1.72626805305487 41.4921264648439,1.71718502044683 41.49764251709,1.71692097187042 41.5015945434571,1.71319198608398 41.4990577697754,1.70830595493328 41.5015525817872,1.70296394824987 41.5076408386231,1.70732796192169 41.5101737976075,1.71192800998682 41.5090026855469,1.72095501422888 41.5140686035157,1.71833598613745 41.5197334289551,1.72077298164379 41.5214347839355,1.71647405624395 41.5287055969238,1.71819102764141 41.5359916687012,1.71603500843059 41.5488395690919,1.71748197078711 41.5504264831542,1.71577203273779 41.5524787902833,1.71778297424322 41.5529174804688,1.72190105915075 41.5594444274902,1.72186195850378 41.5623359680176,1.71719694137579 41.5657615661622,1.7163759469986 41.5716209411621,1.71967899799347 41.5734939575196,1.71974301338201 41.5801162719727,1.73317599296581 41.5816612243653,1.73623001575476 41.5799522399903,1.73787796497345 41.5761032104492,1.74263894557964 41.5744819641113,1.74543297290808 41.5718536376954,1.74291694164282 41.5686264038087,1.74563801288616 41.5648422241211,1.74988698959351 41.5611724853517,1.7529109716416 41.561378479004,1.75572097301483 41.5593109130859,1.75462901592266 41.5555458068849,1.76071000099193 41.5412597656251,1.76041400432598 41.5365676879884,1.76548004150402 41.53426361084,1.78214299678802 41.5215225219728,1.78195595741272 41.5173606872559,1.78630495071423 41.512523651123,1.78273296356213 41.5102157592774,1.78017199039471 41.5052070617677,1.78419697284693 41.5021324157716,1.79263401031488 41.4738311767579))0.0006POINT(1.7433167327853383 41.512994429644436)