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 |
---|---|---|---|
49992 | POLYGON((3.27690911293041 49.3509597778321,3.27542424201971 49.346031188965,3.27542424201971 49.346031188965,3.29656362533569 49.3471832275392,3.31298565864563 49.3553390502931,3.31298565864563 49.3553390502931,3.31528234481806 49.3618698120118,3.3122296333313 49.3645553588867,3.29872798919683 49.3693084716798,3.28885078430176 49.3678588867188,3.28885078430176 49.3678588867188,3.27690911293041 49.3509597778321)) | 0.0006 | POINT(3.2958394614133173 49.3574849909003) |
67697 | MULTIPOLYGON(((9.96458911895752 48.5362663269044,9.96215248107916 48.5373992919922,9.95987415313721 48.5340614318848,9.95526027679455 48.5325813293458,9.95020389556885 48.5331230163575,9.94244384765631 48.5320854187011,9.93915367126471 48.5250282287597,9.93654823303228 48.5244483947755,9.93745231628424 48.5235176086426,9.93598270416265 48.5229606628418,9.9363164901734 48.5198783874511,9.93395137786865 48.5195426940918,9.93514156341558 48.5172729492189,9.92932987213146 48.5154266357422,9.92217254638672 48.5152473449708,9.91672134399414 48.5138702392578,9.91270637512213 48.5089302062989,9.91320705413824 48.5066680908203,9.91320705413824 48.5066680908203,9.91197395324713 48.5079536437989,9.90593242645275 48.5096054077149,9.90595912933355 48.507381439209,9.90453529357916 48.5087509155273,9.90040493011475 48.5078926086426,9.89995861053472 48.5100212097168,9.88984680175793 48.5102615356445,9.88966274261469 48.5119705200195,9.88404178619385 48.5134048461915,9.88488197326666 48.5143814086915,9.87890243530268 48.5142021179199,9.87591075897222 48.5216674804689,9.86622238159185 48.5192756652833,9.8614292144776 48.5225486755371,9.85163116455084 48.5223197937013,9.85149097442627 48.5237045288087,9.84589767456066 48.5239295959473,9.84512233734137 48.5251960754396,9.84282779693604 48.5246772766113,9.84146690368658 48.5262069702149,9.83419132232677 48.5266571044921,9.83419132232677 48.5266571044921,9.83329200744629 48.5310592651367,9.84072303771967 48.5321731567384,9.84321022033691 48.5415229797364,9.84881973266602 48.5423011779786,9.84881973266602 48.5423011779786,9.85345077514654 48.5403060913087,9.85492992401129 48.5411071777345,9.85597419738764 48.5399436950684,9.86347198486334 48.5392646789551,9.8652105331422 48.5419654846193,9.8679895401001 48.542808532715,9.8724946975708 48.5399742126465,9.87984848022472 48.5388031005861,9.880051612854 48.5398712158203,9.87314701080322 48.5408058166505,9.87733745574963 48.545093536377,9.87249088287365 48.5455322265624,9.87145805358892 48.5468482971192,9.87615966796875 48.5477447509766,9.87646961212158 48.5500144958496,9.87973880767834 48.5485382080079,9.88379955291759 48.5497856140138,9.88344383239752 48.5511131286622,9.88047885894781 48.5510253906251,9.87906646728516 48.5524291992188,9.88031387329102 48.5522651672364,9.88028144836431 48.5536766052246,9.88131332397467 48.5537109375001,9.8812074661256 48.5519104003907,9.88237190246588 48.5516319274903,9.88292980194092 48.5532417297364,9.88453674316401 48.5535926818849,9.88009452819819 48.5546493530275,9.8831720352174 48.5555381774903,9.88509273529047 48.5599975585939,9.88720321655279 48.5602264404296,9.87922763824457 48.5641937255861,9.87676048278814 48.5643501281738,9.8772020339967 48.5658454895019,9.87271213531506 48.5662765502931,9.87280654907221 48.5673561096193,9.8763256072998 48.568717956543,9.87583541870129 48.5699272155762,9.87792015075689 48.5700759887696,9.87882900238037 48.5679054260255,9.88286018371576 48.5684127807618,9.8866491317749 48.5720024108887,9.89664077758783 48.5704574584962,9.90657329559326 48.5704498291016,9.90866279602051 48.5713500976562,9.90927600860596 48.5732765197755,9.91109466552734 48.5730094909669,9.91143226623547 48.5709075927734,9.91999530792236 48.5698013305664,9.9273624420166 48.5724105834962,9.9293737411499 48.5788574218751,9.93690776824951 48.5801658630371,9.93566703796387 48.5819320678712,9.94064426422113 48.5852279663086,9.94164276123053 48.5844497680663,9.94194030761713 48.5856857299805,9.9437398910523 48.5847511291504,9.94669818878174 48.5856361389161,9.95437812805187 48.5824394226074,9.95437812805187 48.5824394226074,9.95451831817627 48.5808029174806,9.95633983612061 48.5803604125977,9.9586963653565 48.5817222595215,9.9605331420899 48.5798339843751,9.96047973632812 48.5736541748047,9.95708560943604 48.5717964172363,9.95393276214594 48.5737762451172,9.95551490783703 48.5692710876466,9.95442867279058 48.5669975280761,9.95640087127691 48.5638618469239,9.96085739135748 48.5627212524414,9.96099185943615 48.5604133605958,9.95814323425293 48.5570526123047,9.95074558258051 48.5572319030763,9.94616317749029 48.5587577819825,9.94726848602301 48.556812286377,9.94552135467529 48.556812286377,9.94412231445318 48.5547447204591,9.94733142852789 48.5536460876464,9.94653034210211 48.5514755249023,9.95178413391113 48.5503959655761,9.95502376556402 48.5464630126954,9.95985412597668 48.5456581115723,9.96146583557129 48.5444450378419,9.96515083312994 48.5455322265624,9.96625804901123 48.5433425903321,9.96903800964355 48.543025970459,9.96748161315918 48.5416679382324,9.96368885040283 48.541774749756,9.96458911895752 48.5362663269044)),((9.9472570419311 48.5614318847656,9.94691085815435 48.5608558654786,9.94913673400885 48.5593452453614,9.94632816314709 48.5596923828125,9.94490051269537 48.5613670349122,9.94495296478283 48.5627250671387,9.9472570419311 48.5614318847656))) | 0.0006 | POINT(9.907315012238806 48.54704197244364) |
26214 | POLYGON((-0.901604056358281 49.2676315307618,-0.906862199306431 49.2649574279785,-0.906862199306431 49.2649574279785,-0.911569714546204 49.2664604187012,-0.920779168605748 49.2634887695312,-0.92702317237854 49.2540855407715,-0.92578333616251 49.2406692504883,-0.92930144071579 49.2381248474122,-0.92930144071579 49.2381248474122,-0.935977220535221 49.242389678955,-0.94082635641098 49.241798400879,-0.94995790719986 49.2272796630859,-0.94995790719986 49.2272796630859,-0.959803700447026 49.2260932922364,-0.962591052055302 49.2289237976075,-0.961488127708435 49.2355155944824,-0.968876004218998 49.2400703430177,-0.967684566974583 49.2467498779297,-0.967684566974583 49.2467498779297,-0.949573636054993 49.2598304748536,-0.949573636054993 49.2598304748536,-0.946919977664891 49.2627182006836,-0.936981558799687 49.2615203857423,-0.926677167415619 49.2687072753907,-0.906134366989022 49.2695159912111,-0.906134366989022 49.2695159912111,-0.901604056358281 49.2676315307618)) | 0.0006 | POINT(-0.9363818787611076 49.25049957862272) |
14587 | POLYGON((13.8902873992921 41.6035156250001,13.8844051361084 41.5988082885742,13.8790521621705 41.5961837768555,13.8674049377441 41.5999755859375,13.8648519515992 41.5916442871094,13.8595895767212 41.5886497497559,13.8521947860718 41.5862350463867,13.8469333648682 41.5873413085937,13.8384456634521 41.5910682678223,13.8368358612061 41.5904388427734,13.8370542526245 41.5881080627442,13.8370542526245 41.5881080627442,13.8328266143799 41.5898551940919,13.8335189819335 41.5974044799806,13.8320178985597 41.5995674133301,13.8284091949462 41.6019630432129,13.8230209350585 41.6033554077148,13.8230209350585 41.6033554077148,13.8323812484741 41.6245727539062,13.8409442901612 41.6256637573243,13.8409442901612 41.6256637573243,13.8432741165162 41.6270179748536,13.8513956069947 41.6265029907227,13.8596572875977 41.6223793029785,13.8686361312866 41.6202468872071,13.8819999694825 41.6226959228516,13.8859786987305 41.6195831298828,13.8874883651733 41.6092948913575,13.8902873992921 41.6035156250001)) | 0.0006 | POINT(13.852129425321325 41.604614257812536) |
51004 | POLYGON((1.78372740745556 50.0650253295899,1.79648947715759 50.0723533630372,1.79648947715759 50.0723533630372,1.81038153171551 50.0685386657715,1.81131219863892 50.0621604919433,1.82424378395081 50.0580825805664,1.82994771003729 50.0527381896973,1.82994771003729 50.0527381896973,1.82476770877844 50.0474853515626,1.82751452922827 50.0384674072266,1.82751452922827 50.0384674072266,1.81993436813354 50.0363655090333,1.82026386260986 50.0335845947266,1.82026386260986 50.0335845947266,1.79886376857758 50.0285873413087,1.79886376857758 50.0285873413087,1.79425001144409 50.0279235839843,1.77491056919092 50.0359840393068,1.77491056919092 50.0359840393068,1.79028141498571 50.0564193725587,1.78372740745556 50.0650253295899)) | 0.0006 | POINT(1.8077439129352797 50.047271537780816) |
31405 | POLYGON((2.36763668060314 47.2479476928712,2.3712038993836 47.2470512390138,2.3712038993836 47.2470512390138,2.376380443573 47.2373199462891,2.38550949096674 47.234287261963,2.40161800384521 47.2168350219728,2.41154408454906 47.2153892517091,2.42616963386541 47.2180137634278,2.42616963386541 47.2180137634278,2.42450499534613 47.20316696167,2.42450499534613 47.20316696167,2.41683053970343 47.1908950805665,2.38284492492676 47.1888885498047,2.38284492492676 47.1888885498047,2.37497019767767 47.1857757568361,2.35929059982305 47.1894378662109,2.35929059982305 47.1894378662109,2.35411834716808 47.1978340148926,2.34538459777843 47.1958694458009,2.34153699874884 47.2015800476074,2.34153699874884 47.2015800476074,2.36763668060314 47.2479476928712)) | 0.0006 | POINT(2.38309973762154 47.21040144420812) |
12945 | POLYGON((15.7419767379761 40.9700736999512,15.745044708252 40.9766464233398,15.7473335266114 40.9867591857911,15.7471103668213 40.9889755249025,15.7451210021974 40.9907188415528,15.7447862625122 40.9927368164063,15.7475824356079 41.0016860961915,15.7464656829835 41.007797241211,15.7485189437866 41.0105934143068,15.7483949661256 41.0154838562012,15.7437000274659 41.0155525207521,15.7431955337524 41.0160942077637,15.7439022064209 41.01655960083,15.7439022064209 41.01655960083,15.7367858886719 41.0224533081055,15.7367858886719 41.0224533081055,15.730100631714 41.021484375,15.7241096496583 41.0194435119629,15.7147674560547 41.0146179199219,15.7005109786987 41.0037536621094,15.6981296539308 40.9989547729492,15.7011098861695 40.9973640441895,15.7024488449097 40.9935951232911,15.6966066360474 40.9908485412598,15.6903266906739 40.9906082153321,15.663519859314 40.9823951721193,15.6467590332032 40.9651985168458,15.6431474685669 40.9604148864747,15.6431474685669 40.9604148864747,15.6480674743652 40.9556045532228,15.6480674743652 40.9556045532228,15.649437904358 40.9548873901367,15.6513338088989 40.955478668213,15.6611127853394 40.961654663086,15.667055130005 40.9628105163574,15.6737403869629 40.9623947143555,15.693630218506 40.9667053222656,15.695541381836 40.969741821289,15.700813293457 40.9738426208496,15.7032699584962 40.9746398925782,15.7180213928224 40.9694023132325,15.7264852523805 40.9706687927247,15.7268743515016 40.9715232849122,15.7350397109985 40.9738006591797,15.7419767379761 40.9700736999512)) | 0.0006 | POINT(15.708267753774516 40.987022659995375) |
27998 | POLYGON((0.626354873180446 48.5860748291016,0.630188763141689 48.6068687438965,0.646060526371059 48.6208610534669,0.646060526371059 48.6208610534669,0.616322457790432 48.6136741638185,0.616322457790432 48.6136741638185,0.593994498252982 48.6081123352051,0.593994498252982 48.6081123352051,0.590037167072353 48.5985641479492,0.592662632465363 48.5922203063965,0.583224415779114 48.5847854614259,0.583224415779114 48.5847854614259,0.565646290779114 48.5757064819336,0.565646290779114 48.5757064819336,0.573831379413718 48.5676460266114,0.597901403904075 48.5643730163574,0.597901403904075 48.5643730163574,0.598779857158718 48.5644378662109,0.598779857158718 48.5644378662109,0.608793199062461 48.5827102661134,0.616374015808219 48.5869102478028,0.626354873180446 48.5860748291016)) | 0.0006 | POINT(0.6020048062007255 48.5897569202242) |
31589 | POLYGON((2.32315111160273 47.3568382263184,2.31934928894054 47.3432312011719,2.32716417312616 47.3231086730958,2.32162976264959 47.3136863708496,2.32636308670055 47.2930450439453,2.31782460212713 47.2766456604005,2.31782460212713 47.2766456604005,2.33642601966869 47.2604141235352,2.33459639549261 47.2501029968263,2.35331296920788 47.2450790405275,2.36763668060314 47.2479476928712,2.36763668060314 47.2479476928712,2.3712038993836 47.2470512390138,2.3712038993836 47.2470512390138,2.37116289138805 47.2505416870118,2.38674139976501 47.2595558166504,2.40419435501104 47.2800941467286,2.4401609897613 47.2791633605957,2.4401609897613 47.2791633605957,2.4456679821015 47.295467376709,2.4437780380249 47.3054771423339,2.4437780380249 47.3054771423339,2.4366459846496 47.3406181335449,2.43831372261053 47.3508605957032,2.43831372261053 47.3508605957032,2.41192555427563 47.3593902587891,2.40755820274364 47.3649597167969,2.40755820274364 47.3649597167969,2.39220547676086 47.3634300231935,2.3814160823822 47.3557395935059,2.36279535293585 47.3496627807617,2.32315111160273 47.3568382263184)) | 0.0006 | POINT(2.3808935534569993 47.30271665511597) |
55692 | POLYGON((5.60425329208385 45.3157501220704,5.59025621414179 45.3137855529786,5.58814859390259 45.3107452392579,5.59807252883917 45.3034172058106,5.59807252883917 45.3034172058106,5.58048963546764 45.2972831726074,5.54086542129528 45.297794342041,5.54086542129528 45.297794342041,5.5333080291748 45.3135032653809,5.53785753250122 45.326473236084,5.5302996635437 45.3344116210938,5.5302996635437 45.3344116210938,5.5474853515625 45.3454170227051,5.5474853515625 45.3454170227051,5.54956722259527 45.3426208496094,5.56438446044933 45.3492317199708,5.56438446044933 45.3492317199708,5.56851577758789 45.3476676940919,5.56851577758789 45.3476676940919,5.56495714187628 45.3414154052734,5.56733179092413 45.3383331298828,5.60425329208385 45.3157501220704)) | 0.0006 | POINT(5.562638850439206 45.32646615164625) |