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 |
---|---|---|---|
40949 | POLYGON((0.711681544780731 45.7628555297853,0.695378899574337 45.7621192932129,0.695378899574337 45.7621192932129,0.666234970092887 45.7481956481934,0.666234970092887 45.7481956481934,0.665281057357788 45.7394027709962,0.665281057357788 45.7394027709962,0.67155563831335 45.7303314208984,0.685631990432853 45.7265586853028,0.695613086223602 45.7274932861328,0.707279205322266 45.7340202331543,0.71724450588232 45.733196258545,0.71724450588232 45.733196258545,0.722025156021175 45.7542266845704,0.722025156021175 45.7542266845704,0.713748514652309 45.7520980834961,0.710395753383693 45.7541275024413,0.711681544780731 45.7628555297853)) | 0.0006 | POINT(0.69577852417446 45.74480976777922) |
180748 | POLYGON((8.62680139731549 47.44265888907207,8.387035772315471 47.16168086253484,7.907504522315435 47.16168086253484,7.667738897315417 47.44265888907207,7.907504522315435 47.722137923849566,8.387035772315471 47.722137923849566,8.62680139731549 47.44265888907207)) | -1.0000 | POINT(8.147270147315453 47.44215922515216) |
45586 | POLYGON((1.12161755561829 44.48539352417,1.11720013618464 44.4756469726562,1.09832608699799 44.4725685119629,1.09423887729645 44.4744338989259,1.09423887729645 44.4744338989259,1.09189474582672 44.4678726196289,1.08317875862133 44.4649581909179,1.08409249782562 44.4580307006837,1.08409249782562 44.4580307006837,1.1030982732774 44.4476547241211,1.10878372192383 44.438144683838,1.11737346649176 44.4357070922852,1.11737346649176 44.4357070922852,1.13010907173162 44.4363174438478,1.14016723632812 44.4419288635255,1.14016723632812 44.4419288635255,1.14092814922333 44.4516639709474,1.12828218936926 44.4558258056641,1.12699413299572 44.4590377807617,1.12788426876062 44.4689865112305,1.13631713390356 44.4767646789551,1.13631713390356 44.4767646789551,1.12161755561829 44.48539352417)) | 0.0006 | POINT(1.1146670688282623 44.458990964022604) |
65190 | POLYGON((10.6973514556885 49.4362754821778,10.6916265487671 49.4327583312988,10.6867389678956 49.4314079284667,10.6729125976562 49.4298362731935,10.671732902527 49.4276809692382,10.6718463897706 49.4247665405275,10.6585359573364 49.4259605407715,10.6535482406616 49.4255485534668,10.64235496521 49.42240524292,10.638674736023 49.4230728149415,10.6375780105591 49.4251976013184,10.6352844238281 49.4238166809082,10.6349744796753 49.4214134216309,10.6331930160522 49.4205894470215,10.6291875839233 49.4231681823732,10.6312313079834 49.424415588379,10.6285772323608 49.4272499084473,10.6269617080688 49.4263725280762,10.623984336853 49.4270401000977,10.6180763244629 49.4303131103517,10.6136636734009 49.4306755065918,10.6127061843872 49.4285278320313,10.6133499145508 49.4265022277832,10.6108369827271 49.4252014160156,10.6106824874879 49.4239158630372,10.6093311309816 49.4239158630372,10.6112604141235 49.4223785400391,10.6059894561768 49.4233436584474,10.602222442627 49.4230346679688,10.6012859344482 49.4219131469728,10.5979967117309 49.4222640991212,10.5979967117309 49.4222640991212,10.5967807769775 49.4234962463379,10.5975179672241 49.426456451416,10.5992021560669 49.4272079467774,10.5979671478272 49.4305305480958,10.5958852767945 49.4307098388673,10.5973920822143 49.4326896667482,10.6123838424683 49.4318313598634,10.6130075454712 49.4331245422363,10.6110410690308 49.4359169006348,10.613060951233 49.4385223388673,10.6120443344116 49.4400978088379,10.618281364441 49.440673828125,10.6138725280762 49.444034576416,10.6131467819214 49.4456634521484,10.6139612197876 49.4458160400391,10.6139612197876 49.4458160400391,10.6209754943848 49.4478950500489,10.6211986541749 49.4489860534668,10.6182527542114 49.4514961242676,10.6228351593018 49.4521408081055,10.6227149963379 49.4535980224611,10.6160926818847 49.454029083252,10.6153764724731 49.4547309875488,10.6165637969971 49.4549446105958,10.6159524917603 49.4588394165039,10.6105833053589 49.458683013916,10.6110162734986 49.4607162475586,10.6130599975587 49.4613723754883,10.6141843795776 49.4641151428223,10.61217212677 49.4651679992675,10.615439414978 49.469482421875,10.615439414978 49.469482421875,10.6234493255615 49.4707984924317,10.6243982315065 49.4695739746094,10.6303567886353 49.4707450866699,10.6331319808961 49.4681396484375,10.6368227005005 49.4700355529786,10.6333484649659 49.4715042114259,10.634196281433 49.4737243652344,10.6384992599488 49.4723281860352,10.6378326416016 49.4756202697755,10.6393375396729 49.475456237793,10.6404733657837 49.476921081543,10.6449728012084 49.4764289855957,10.6446762084961 49.4743614196777,10.646842956543 49.4740066528321,10.6456775665283 49.4722366333008,10.653058052063 49.4707069396973,10.6533002853394 49.4685745239258,10.6579656600952 49.4686126708985,10.6583614349365 49.4714622497558,10.6639852523804 49.4689178466797,10.666787147522 49.4728927612304,10.6729278564454 49.4723777770997,10.6770906448365 49.4744567871094,10.6787042617798 49.4738616943359,10.6792631149292 49.4756965637207,10.6780405044556 49.4774436950684,10.6853113174438 49.4782257080078,10.6881093978882 49.4772682189942,10.6916999816895 49.4781608581543,10.6916999816895 49.4781608581543,10.6975955963135 49.4787864685059,10.6987581253052 49.47603225708,10.7007446289062 49.4758300781251,10.6980075836182 49.4748573303224,10.7008237838745 49.4716835021973,10.6956157684327 49.4705772399903,10.6967935562134 49.4684181213379,10.6949872970582 49.4688148498535,10.695598602295 49.4665374755861,10.6946048736573 49.4664154052734,10.6949682235718 49.4642562866212,10.6963491439819 49.4644050598144,10.6975126266479 49.4621276855469,10.6959714889528 49.4597892761232,10.6907272338868 49.4598007202149,10.6919641494751 49.4585456848145,10.6950254440309 49.4578323364258,10.6947889328003 49.4539985656739,10.6904220581055 49.4523696899415,10.6906232833863 49.4439849853516,10.6957750320435 49.4421424865723,10.6975135803224 49.4421386718751,10.6977109909057 49.4432983398439,10.6986494064332 49.4432983398439,10.6994342803955 49.4395980834962,10.6969823837281 49.4370841979982,10.6973514556885 49.4362754821778)) | 0.0006 | POINT(10.646677716573096 49.45052347183229) |
45626 | POLYGON((1.84765446186066 44.467514038086,1.83693385124201 44.4606208801271,1.83289086818701 44.4506378173829,1.81858777999889 44.4506378173829,1.81858777999889 44.4506378173829,1.81285738945013 44.4547920227051,1.81140410900127 44.4671173095703,1.81140410900127 44.4671173095703,1.81576323509228 44.4732894897462,1.82819414138788 44.4783554077148,1.82564508914948 44.4884719848633,1.80793857574463 44.4919586181641,1.79653704166424 44.4981460571288,1.79653704166424 44.4981460571288,1.81391334533697 44.5099182128907,1.84067809581757 44.5171203613282,1.8538260459901 44.5271224975587,1.8538260459901 44.5271224975587,1.863236784935 44.5341606140137,1.8785628080368 44.5185737609864,1.8785628080368 44.5185737609864,1.87181758880621 44.5141830444336,1.86157548427582 44.4873199462891,1.86157548427582 44.4873199462891,1.84075832366949 44.4794883728028,1.83967149257666 44.4760704040528,1.84765446186066 44.467514038086)) | 0.0006 | POINT(1.8353438377380848 44.48824677100553) |
58550 | POLYGON((7.2523279190064 50.4886741638184,7.24815511703491 50.4930686950684,7.24815511703491 50.4930686950684,7.25150442123419 50.4926147460938,7.25222921371466 50.4958038330078,7.25066804885876 50.4989738464355,7.25407123565674 50.4997901916504,7.25366497039795 50.5013732910156,7.25520658493053 50.502353668213,7.25028610229498 50.5087623596192,7.24768543243414 50.5106163024902,7.25388717651367 50.5128440856935,7.25675296783459 50.5161323547363,7.26184368133545 50.5166625976563,7.26083517074591 50.5257301330567,7.2615470886231 50.5279045104982,7.265618801117 50.5317535400391,7.2636017799378 50.533950805664,7.27790546417236 50.5392417907715,7.27657842636114 50.5418891906738,7.28465318679815 50.5436706542968,7.28465318679815 50.5436706542968,7.2916922569276 50.5296363830568,7.2916922569276 50.5296363830568,7.29946708679194 50.5159378051758,7.31217908859247 50.50301361084,7.31217908859247 50.50301361084,7.3202686309815 50.4958000183106,7.3202686309815 50.4958000183106,7.3149938583374 50.4913673400879,7.31750631332403 50.4884643554688,7.31704330444342 50.4876327514648,7.31189632415771 50.4850807189941,7.30789613723766 50.4865531921386,7.30449438095087 50.4850997924806,7.3034658432008 50.4836196899414,7.30090045928961 50.4850158691407,7.29762697219849 50.483341217041,7.29353761672979 50.4830741882325,7.29353761672979 50.4830741882325,7.29282760620123 50.4846458435058,7.28958129882807 50.482307434082,7.28640031814587 50.4813537597656,7.28057813644409 50.4808387756348,7.27634763717657 50.4824218750001,7.27094268798828 50.4809722900391,7.26962232589733 50.4821090698242,7.27341651916498 50.4850158691407,7.27590847015387 50.4857330322266,7.27363348007202 50.4888381958008,7.27254819870006 50.4884033203125,7.27254438400269 50.4894828796387,7.26436758041382 50.4911651611329,7.25798749923717 50.4888954162598,7.2523279190064 50.4886741638184)) | 0.0006 | POINT(7.279244131512152 50.50047952157482) |
33293 | POLYGON((4.36133861541748 49.7344779968261,4.36749792099005 49.7397842407227,4.38241481781006 49.7422370910645,4.3974871635437 49.7401771545411,4.40592622756958 49.7319145202637,4.41831398010248 49.7361717224122,4.41831398010248 49.7361717224122,4.42041301727306 49.7393569946289,4.41350269317633 49.7487182617188,4.40320301055914 49.7504043579101,4.39794111251825 49.7598342895508,4.39794111251825 49.7598342895508,4.38896417617804 49.7572059631348,4.37201642990112 49.7645416259766,4.36699867248547 49.7636642456055,4.36699867248547 49.7636642456055,4.36442327499395 49.7498092651368,4.34059858322144 49.7419242858886,4.33701658248901 49.73539352417,4.33701658248901 49.73539352417,4.36133861541748 49.7344779968261)) | 0.0006 | POINT(4.382916331291219 49.74653396606448) |
63105 | POLYGON((12.78835105896 53.9589042663574,12.7915029525756 53.9585609436035,12.7888031005861 53.9550437927247,12.7889709472657 53.9536094665528,12.787262916565 53.9532928466797,12.7955074310303 53.9527549743653,12.8057374954225 53.9445571899415,12.8076057434083 53.9424552917482,12.8090391159058 53.9368171691895,12.8115758895874 53.9345169067384,12.8136062622071 53.9299697875976,12.8121910095216 53.9307403564453,12.8094911575318 53.9300918579102,12.8113775253296 53.9257698059083,12.8044939041138 53.9291954040528,12.7958889007568 53.9274406433105,12.7958889007568 53.9274406433105,12.7855033874513 53.9242515563965,12.7844781875611 53.9261741638184,12.7800693511963 53.9268836975098,12.780143737793 53.9259948730469,12.7763090133668 53.9231338500977,12.7607831954957 53.9246673583984,12.7520713806153 53.921401977539,12.7490253448487 53.9252014160156,12.7438459396363 53.9204444885254,12.7399940490723 53.9207305908204,12.7325716018677 53.9226417541503,12.730767250061 53.9245681762696,12.7312421798707 53.9258003234864,12.7331256866456 53.9266128540039,12.7324190139771 53.9282531738281,12.7290925979614 53.9308013916016,12.7091531753539 53.9360542297363,12.7091531753539 53.9360542297363,12.711802482605 53.9420204162598,12.712290763855 53.9474029541016,12.7166891098024 53.9506034851075,12.7211990356445 53.9500198364258,12.719979286194 53.954761505127,12.7320222854615 53.9525032043458,12.7326955795289 53.9543342590332,12.7441368103027 53.9542236328125,12.7452926635743 53.9551277160645,12.7450103759766 53.9564971923828,12.749457359314 53.9586753845214,12.7618999481202 53.9605026245117,12.7667875289918 53.960334777832,12.7706117630006 53.9620513916016,12.7706117630006 53.9620513916016,12.7727727890016 53.9605484008789,12.772834777832 53.9594039916992,12.7835731506349 53.9549751281739,12.7869663238527 53.9589309692384,12.78835105896 53.9589042663574)) | 0.0006 | POINT(12.764697710673065 53.94103332802103) |
67117 | POLYGON((7.95643043518078 48.5520057678223,7.95530700683594 48.5499000549317,7.95297527313238 48.550178527832,7.95297527313238 48.550178527832,7.95188999176025 48.54838180542,7.95188999176025 48.54838180542,7.95348930358881 48.5478591918945,7.95284986495966 48.5432319641114,7.94720983505255 48.5435523986816,7.94720983505255 48.5435523986816,7.94668006896984 48.5422859191895,7.95055007934582 48.5418624877931,7.94425821304316 48.534969329834,7.95453500747692 48.5311851501465,7.95429420471203 48.5282745361329,7.95722436904913 48.5248069763185,7.96511220932001 48.5234107971192,7.96950149536133 48.5213012695314,7.96852111816412 48.5200996398926,7.97473621368414 48.5188102722169,7.9745569229126 48.5178260803223,7.9745569229126 48.5178260803223,7.98541259765625 48.517677307129,7.98683452606201 48.519515991211,7.99226951599121 48.5202255249023,7.99336385726929 48.5142135620118,7.9973149299621 48.5108375549317,8.0048332214356 48.5115661621095,8.018798828125 48.5048103332519,8.02709102630627 48.5062904357911,8.03074550628673 48.5052375793457,8.03074550628673 48.5052375793457,8.03323841094971 48.5081443786622,8.03440475463873 48.516960144043,8.03630638122559 48.5192527770997,8.03372383117676 48.5258903503419,8.02474117279058 48.5259399414062,8.02321052551264 48.5269966125488,8.02232646942139 48.5262641906739,8.0121641159057 48.5295372009278,8.01165103912359 48.5289764404297,8.01000785827637 48.5306396484376,8.00694370269787 48.5301666259766,8.00547981262207 48.5278015136718,8.00369453430187 48.5282859802246,8.00390911102306 48.5309791564941,8.00737285614025 48.5350265502931,8.00216102600103 48.5360145568848,8.00368309020996 48.5404281616211,7.99868917465204 48.5445442199707,7.99935245513916 48.546142578125,7.99710416793829 48.5466499328613,7.99863767623907 48.5495185852051,7.999827861786 48.5492935180665,8.00314140319824 48.5586891174317,8.00200748443598 48.5623092651368,8.00321865081793 48.5645942687989,8.00631999969482 48.5659866333008,8.00631999969482 48.5659866333008,8.01052093505871 48.5729103088378,8.00562191009521 48.5740776062012,8.00266170501715 48.5704574584962,7.99592828750616 48.5722122192384,7.99508619308477 48.5763130187989,7.99274921417231 48.579345703125,7.9933004379273 48.5803413391113,7.97892618179333 48.58650970459,7.97153711318975 48.5921020507812,7.96267938613892 48.6070289611818,7.96531152725231 48.6159019470215,7.96531152725231 48.6159019470215,7.96244096755981 48.6165084838867,7.96199798583984 48.6151161193848,7.9504218101502 48.6161804199219,7.9495148658753 48.6116409301758,7.95118951797497 48.607624053955,7.95031261444103 48.6038017272949,7.95031261444103 48.6038017272949,7.94415092468256 48.5905799865723,7.93858146667492 48.5920372009277,7.93858146667492 48.5920372009277,7.94620513916021 48.5790672302246,7.9465827941894 48.5730361938477,7.94928979873669 48.5663261413575,7.94992160797131 48.5608253479004,7.95285034179693 48.5608749389649,7.95643043518078 48.5520057678223)) | 0.0006 | POINT(7.982509175012313 48.550803162330816) |
64243 | POLYGON((14.0037355422975 52.565299987793,14.0054950714112 52.5634574890136,14.0126247406006 52.5600318908691,14.0374803543092 52.5582695007325,14.0374803543092 52.5582695007325,14.0419454574586 52.5476837158204,14.0497074127197 52.5425872802734,14.0471076965332 52.5413970947267,14.0325078964234 52.5293273925782,14.0231466293335 52.5193634033203,14.0231466293335 52.5193634033203,14.0157566070557 52.5213813781739,13.9548025131225 52.5275993347167,13.9330749511718 52.5285720825196,13.9318885803223 52.5306129455568,13.9325914382936 52.5317001342773,13.9262285232545 52.5372924804688,13.9167375564576 52.5433235168458,13.9117984771729 52.5445785522462,13.9117984771729 52.5445785522462,13.9119653701782 52.5459899902345,13.9331426620484 52.5491065979005,13.9395627975464 52.5515518188477,13.9504661560059 52.5474014282227,13.9621219635009 52.5401916503907,13.9659729003907 52.5435905456544,13.9747858047486 52.543743133545,13.9768962860107 52.5465812683106,13.9760570526124 52.5525207519531,13.9782772064209 52.5529518127443,13.9807538986207 52.5549850463867,13.9774522781372 52.5581169128417,13.9780988693238 52.5590324401857,13.9815988540649 52.5597801208497,13.9821033477784 52.5626525878906,13.9886674880983 52.5634803771973,13.9901533126832 52.5651054382325,13.9951763153077 52.5664253234864,13.9998655319215 52.5666961669922,14.0003881454467 52.5651321411133,14.0037355422975 52.565299987793)) | 0.0006 | POINT(13.979814028739971 52.54774312973026) |