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 |
---|---|---|---|
23474 | POLYGON((-0.2272452116012 43.3745651245117,-0.238183200359231 43.3860168457031,-0.238183200359231 43.3860168457031,-0.245800480246544 43.3939018249512,-0.245800480246544 43.3939018249512,-0.254761874675694 43.3931999206544,-0.27321857213974 43.3840446472169,-0.27321857213974 43.3840446472169,-0.268498092889786 43.3748321533204,-0.268498092889786 43.3748321533204,-0.255543917417469 43.3653373718262,-0.246535733342171 43.3657875061036,-0.243815511465073 43.3685417175293,-0.234912768006211 43.3675842285157,-0.234912768006211 43.3675842285157,-0.2272452116012 43.3745651245117)) | 0.0006 | POINT(-0.24994189838564207 43.378679402669334) |
71624 | POLYGON((15.5626840591432 48.3941993713379,15.5635137557983 48.406120300293,15.562352180481 48.4107284545898,15.5587339401246 48.4121551513673,15.5406436920165 48.4135932922364,15.5350189208986 48.4148368835449,15.5324783325196 48.416805267334,15.5317001342774 48.4188690185548,15.532699584961 48.4219779968263,15.5352048873902 48.4246292114258,15.5352048873902 48.4246292114258,15.4855422973633 48.4325828552246,15.4855422973633 48.4325828552246,15.4694185256958 48.4258346557618,15.4694185256958 48.4258346557618,15.4949779510498 48.4095344543458,15.4949779510498 48.4095344543458,15.5156383514405 48.4051933288575,15.5360450744629 48.3876609802247,15.5360450744629 48.3876609802247,15.5626840591432 48.3941993713379)) | 0.0006 | POINT(15.523892021179233 48.41374816894537) |
45657 | POLYGON((1.98574066162115 44.6753196716309,1.97704505920422 44.6816596984864,1.97134709358221 44.6771774291993,1.97134709358221 44.6771774291993,1.97104740142828 44.6645698547363,1.98095405101782 44.6532363891602,1.97650825977331 44.6473083496094,1.97650825977331 44.6473083496094,1.99285173416138 44.6565856933595,1.99285173416138 44.6565856933595,1.98574066162115 44.6753196716309)) | 0.0006 | POINT(1.9796201348305271 44.66369285583501) |
1397844 | POLYGON((-4.23717021942133 39.4791450500489,-4.24198579788197 39.4779167175293,-4.24397611618042 39.4793205261231,-4.25679111480713 39.4807586669922,-4.27340888977051 39.479663848877,-4.2979159355163 39.4845390319825,-4.32054615020746 39.4834289550782,-4.32762479782104 39.4877090454103,-4.34475517272949 39.4901428222657,-4.34535884857178 39.4913635253906,-4.35946416854858 39.4955062866212,-4.37710523605347 39.4959983825685,-4.39518308639521 39.5021705627441,-4.4043288230896 39.5035667419434,-4.40916299819946 39.5062904357911,-4.42114686965937 39.5070304870607,-4.4245200157165 39.5093231201172,-4.42287015914911 39.5122337341308,-4.43198919296265 39.5190162658692,-4.4265460968017 39.5292625427246,-4.40066385269165 39.5272712707521,-4.38325595855713 39.5229759216309,-4.37874984741211 39.5280761718751,-4.37687921524042 39.5347633361816,-4.37464618682856 39.5358505249023,-4.37331914901728 39.5442085266114,-4.36471319198603 39.5510139465332,-4.3559889793396 39.5542526245118,-4.34159803390497 39.5642585754396,-4.34168195724482 39.5722694396974,-4.33792018890381 39.5781784057617,-4.32506322860712 39.5841369628907,-4.31281280517572 39.5964202880861,-4.30914306640625 39.5908241271972,-4.31155014038086 39.5900459289552,-4.3135781288147 39.5833396911622,-4.30382108688349 39.5765190124511,-4.29936122894276 39.5752105712891,-4.29683780670155 39.5722389221192,-4.2935647964477 39.5710220336915,-4.29196310043329 39.5730285644531,-4.28481292724609 39.5679626464844,-4.28405714035034 39.5610542297364,-4.28872013092035 39.5588760375976,-4.28985691070551 39.5561485290527,-4.29090309143066 39.5373001098634,-4.28070878982533 39.5289878845216,-4.27279090881342 39.5273895263673,-4.26258516311634 39.5297622680665,-4.26064491271973 39.526782989502,-4.25015878677368 39.5253562927247,-4.24707794189453 39.5214614868165,-4.23717021942133 39.4791450500489)) | 0.0006 | POINT(-4.328101506599978 39.53233410761912) |
24398 | POLYGON((4.45690059661871 45.2534523010254,4.44548130035406 45.2595443725587,4.43407583236694 45.2747039794922,4.41965484619141 45.2754020690919,4.41965484619141 45.2754020690919,4.39121007919323 45.2636184692383,4.3872208595277 45.2575721740723,4.37493515014648 45.261947631836,4.37118625640863 45.2598876953126,4.37118625640863 45.2598876953126,4.37549114227295 45.2586441040039,4.37752342224127 45.2490386962892,4.36629343032837 45.2433929443359,4.35711956024164 45.2435684204102,4.35711956024164 45.2435684204102,4.36077928543085 45.2378692626953,4.37053442001348 45.2369918823243,4.37820053100592 45.2325859069824,4.38108253479015 45.208953857422,4.38644027709967 45.2030982971192,4.38644027709967 45.2030982971192,4.39972925186152 45.1986274719238,4.41820049285889 45.2026977539064,4.43720912933355 45.2003288269042,4.44660377502441 45.2025489807129,4.46216630935675 45.2198905944825,4.47650146484375 45.221809387207,4.48132753372198 45.2159194946289,4.48132753372198 45.2159194946289,4.48606538772589 45.2167930603027,4.48891782760626 45.2234191894532,4.48313474655151 45.2364463806152,4.48313474655151 45.2364463806152,4.47924757003784 45.2379112243652,4.47924757003784 45.2379112243652,4.45690059661871 45.2534523010254)) | 0.0006 | POINT(4.4191812515259 45.23625422886443) |
62152 | POLYGON((9.58710479736334 47.2046890258789,9.58505058288574 47.2001953125001,9.58191776275635 47.1974220275879,9.58076572418213 47.196403503418,9.58035945892334 47.1960449218751,9.58035945892334 47.1960449218751,9.57529258728039 47.1988029479982,9.56925106048584 47.1992416381837,9.55970668792725 47.2031745910645,9.55948734283453 47.2038269042969,9.56541442871105 47.2056388854981,9.56155967712414 47.2114906311035,9.55220031738287 47.2102699279786,9.55106544494635 47.2081985473633,9.54923534393316 47.208164215088,9.54667472839367 47.2063903808593,9.5326652526856 47.2140083312989,9.53196525573742 47.2151832580567,9.53295707702631 47.2178001403809,9.53751945495617 47.2202529907228,9.53536987304688 47.2222633361818,9.53791522979736 47.2249565124513,9.54188823699951 47.2253189086914,9.54869937896729 47.2292098999024,9.54869937896729 47.2292098999024,9.55337429046642 47.2321014404298,9.55952167510986 47.2343559265137,9.56275177001964 47.233528137207,9.56275177001964 47.233528137207,9.55575847625744 47.2262878417969,9.56027889251709 47.223201751709,9.56800556182873 47.2205963134766,9.57537364959728 47.2170715332031,9.58035373687744 47.2121467590333,9.58710479736334 47.2046890258789)) | 0.0006 | POINT(9.559155716615614 47.2140299853157) |
50222 | POLYGON((2.07227849960327 49.4066963195801,2.06404471397411 49.4110374450684,2.06404471397411 49.4110374450684,2.03611707687378 49.3920402526856,2.03611707687378 49.3920402526856,2.04841589927679 49.3852767944337,2.04841589927679 49.3852767944337,2.05001902580273 49.384204864502,2.05001902580273 49.384204864502,2.05862236022961 49.3828315734863,2.05862236022961 49.3828315734863,2.06666612625122 49.3857269287109,2.07914042472845 49.3988838195801,2.07914042472845 49.3988838195801,2.07227849960327 49.4066963195801)) | 0.0006 | POINT(2.0579759734018164 49.392926624843085) |
49058 | POLYGON((0.121877804398537 48.3310356140138,0.114841729402656 48.3162879943848,0.114841729402656 48.3162879943848,0.100629940629062 48.3071899414063,0.101298272609768 48.3038749694825,0.101298272609768 48.3038749694825,0.0719392150641625 48.3044929504396,0.0719392150641625 48.3044929504396,0.063404433429298 48.3084678649903,0.063404433429298 48.3084678649903,0.048199102282581 48.3220977783204,0.0434881336988155 48.3355484008789,0.0434881336988155 48.3355484008789,0.0518129244446186 48.3424186706544,0.0518129244446186 48.3424186706544,0.0617251880467506 48.3433952331544,0.0674340426922981 48.337890625,0.0821553394198986 48.3363914489746,0.0888796970248222 48.3315162658692,0.099944822490329 48.3372688293458,0.099944822490329 48.3372688293458,0.110153228044624 48.3375205993653,0.121877804398537 48.3310356140138)) | 0.0006 | POINT(0.08065970021899403 48.32471622120258) |
16660 | POLYGON((13.0225849151611 43.5662117004395,13.0256118774414 43.567928314209,13.035535812378 43.5700531005859,13.0428943634034 43.5692100524902,13.058897972107 43.5767135620117,13.058897972107 43.5767135620117,13.0516319274902 43.5773887634277,13.0447692871095 43.5797462463379,13.0378780364991 43.58602142334,13.0398731231691 43.5912971496581,13.0353736877441 43.5970993041993,13.0297317504884 43.5991821289064,13.0214157104492 43.6000366210938,13.0214157104492 43.6000366210938,13.0194225311279 43.602222442627,13.0171909332277 43.6022834777833,13.0045204162598 43.5995597839355,13.0018520355224 43.5959663391114,13.0018520355224 43.5959663391114,13.0025806427002 43.5929756164552,13.0017080307007 43.5887451171875,12.9971113204957 43.5779342651368,13.0063962936401 43.5720329284667,13.0144939422607 43.5705337524415,13.0225849151611 43.5662117004395)) | 0.0006 | POINT(13.024735013643927 43.585660775502554) |
59492 | POLYGON((7.57568407058722 47.1083793640137,7.56998586654669 47.1029739379884,7.56569576263439 47.1015129089356,7.56368589401245 47.0993003845215,7.56368589401245 47.0993003845215,7.56450605392467 47.0975761413574,7.56450605392467 47.0975761413574,7.56732416152954 47.0972595214845,7.57712793350231 47.0914878845215,7.58388090133661 47.0867385864259,7.58656406402599 47.0833320617676,7.58656406402599 47.0833320617676,7.59933900833141 47.0742378234864,7.60389614105219 47.0731506347657,7.60389614105219 47.0731506347657,7.60799503326416 47.0742874145508,7.62410211563105 47.0682945251465,7.62948799133312 47.0679969787599,7.63596200942999 47.0733909606934,7.63345384597778 47.0772895812989,7.63920307159424 47.0814895629883,7.63782691955572 47.0878562927246,7.63782691955572 47.0878562927246,7.63777685165405 47.0923156738282,7.63777685165405 47.0923156738282,7.62668085098272 47.0872192382812,7.62115621566778 47.0872993469238,7.61562681198126 47.0893096923828,7.5972900390625 47.0874366760255,7.59000205993652 47.0925025939942,7.58795881271374 47.0956916809082,7.58490276336681 47.0972938537598,7.58326578140264 47.1002388000488,7.57808780670172 47.1043090820314,7.57568407058722 47.1083793640137)) | 0.0006 | POINT(7.599491904763658 47.0886383056641) |