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
1406218POLYGON((0.163231998682079 40.5794143676758,0.14586499333393 40.5745849609375,0.128215000033435 40.5806121826173,0.122032001614571 40.5850830078125,0.1163389980793 40.5866088867188,0.10292199999094 40.5841255187989,0.078671999275741 40.5721282958985,0.06159599870449 40.5683059692383,0.054492000490427 40.5715637207032,0.053024001419544 40.5741233825684,0.047166999429464 40.5741539001465,0.033254999667463 40.5788612365723,0.027710000053162 40.5769691467285,0.019127000123376 40.5794219970704,0.012788999825773 40.5839920043946,0.002951998962146 40.5848655700684,0.003709000069648 40.5936050415038,0.005727999843771 40.5959281921387,0.010859999805803 40.5989265441895,0.017231000587344 40.599464416504,0.024155000224766 40.6047401428224,0.019585000351128 40.6105880737304,0.011043000034988 40.6140632629396,0.008945999667162 40.6223526000978,0.024678999558148 40.6268310546875,0.032267998904047 40.6370162963868,0.034664001315832 40.6373863220214,0.035599999129829 40.6474113464356,0.038841001689491 40.6500205993652,0.043857999146098 40.6495552062989,0.049571998417491 40.6456832885742,0.060862001031694 40.6443672180176,0.064055003225917 40.6472015380859,0.089725002646446 40.6502799987794,0.107767000794524 40.639476776123,0.119133003056049 40.6344757080078,0.139458000659943 40.636817932129,0.147119000554142 40.6297416687013,0.154315993189925 40.6276817321777,0.157571002841053 40.6137046813966,0.162696003913823 40.6149139404298,0.174455001950321 40.6103858947754,0.176689997315407 40.6042098999024,0.184109002351875 40.5994300842285,0.185874998569602 40.5955696105958,0.183570995926857 40.5928268432618,0.177359998226166 40.5899238586426,0.174659997224921 40.5840377807618,0.163231998682079 40.5794143676758))0.0006POINT(0.08311562483145939 40.60632149378461)
36823POLYGON((5.98261499404919 46.7888946533203,5.9960379600526 46.8072242736818,5.97836303710943 46.8120269775391,5.97477912902832 46.8184623718262,5.97477912902832 46.8184623718262,5.96433639526367 46.8202285766602,5.96433639526367 46.8202285766602,5.9642910957337 46.8050117492676,5.9642910957337 46.8050117492676,5.96247243881231 46.7935905456543,5.96247243881231 46.7935905456543,5.96146297454845 46.7794342041016,5.96146297454845 46.7794342041016,5.95766162872314 46.7667274475098,5.95766162872314 46.7667274475098,5.96604251861578 46.7677192687989,5.96604251861578 46.7677192687989,5.97087335586548 46.7680511474611,5.98180437088024 46.78226852417,5.98261499404919 46.7888946533203))0.0006POINT(5.969041372600405 46.79267441598997)
37652POLYGON((0.490051358938217 48.9285621643067,0.487741768360252 48.9246444702149,0.487741768360252 48.9246444702149,0.490204960107917 48.9185867309571,0.540471434593258 48.9177131652833,0.540471434593258 48.9177131652833,0.554534792900142 48.9214363098145,0.554534792900142 48.9214363098145,0.547623515129089 48.9258499145509,0.548253953456936 48.9289855957032,0.548253953456936 48.9289855957032,0.53990375995636 48.9444389343263,0.535558223724365 48.9462127685548,0.499999403953552 48.9454498291017,0.499999403953552 48.9454498291017,0.490051358938217 48.9285621643067))0.0006POINT(0.5243563016256151 48.92934061686207)
56358POLYGON((4.65940093994141 45.5433959960938,4.64470386505133 45.5405235290528,4.64470386505133 45.5405235290528,4.63268947601318 45.5342559814453,4.62131786346436 45.5187606811523,4.6113486289978 45.5186958312988,4.60401487350475 45.4985618591309,4.60401487350475 45.4985618591309,4.61262845993042 45.4930725097656,4.61262845993042 45.4930725097656,4.65060234069824 45.4971122741699,4.65060234069824 45.4971122741699,4.65390491485607 45.4996299743652,4.64955139160162 45.5164833068848,4.65078592300426 45.5299835205079,4.66164636611938 45.5366325378418,4.66533184051525 45.542839050293,4.66533184051525 45.542839050293,4.65940093994141 45.5433959960938))0.0006POINT(4.638622681299893 45.51900312635635)
55910POLYGON((5.62374782562256 45.6132698059081,5.62408828735357 45.6033782958985,5.63765573501598 45.5896263122558,5.63765573501598 45.5896263122558,5.6100754737854 45.5764846801758,5.6100754737854 45.5764846801758,5.60440969467163 45.5820503234863,5.58445549011236 45.5899696350099,5.58445549011236 45.5899696350099,5.59369039535534 45.5885047912598,5.5996675491333 45.6004829406739,5.60401105880737 45.6019592285156,5.6048474311828 45.605281829834,5.59216022491466 45.6095581054687,5.59216022491466 45.6095581054687,5.60786962509167 45.6168632507325,5.61491107940674 45.6254119873047,5.61491107940674 45.6254119873047,5.62374782562256 45.6132698059081))0.0006POINT(5.607824881871585 45.59966066148548)
13130POLYGON((16.3738021850587 39.4192390441895,16.3482570648194 39.4234542846679,16.3371753692627 39.4167823791504,16.3331604003906 39.4157981872559,16.3273849487305 39.416805267334,16.3195095062255 39.4205780029298,16.3145351409912 39.4216079711914,16.2805824279785 39.4104537963868,16.2748413085938 39.4115600585938,16.269952774048 39.4146957397461,16.2601203918458 39.4157485961915,16.2601203918458 39.4157485961915,16.2599544525148 39.4213562011718,16.2516975402833 39.4279251098633,16.2502861022949 39.4438514709473,16.2502861022949 39.4438514709473,16.2502956390381 39.4503364562989,16.2473068237305 39.4541015625001,16.2268753051758 39.4640998840333,16.2237815856934 39.4666099548341,16.2215366363527 39.4777984619142,16.2221851348877 39.4816246032715,16.2221851348877 39.4816246032715,16.2858600616455 39.47900390625,16.2858600616455 39.47900390625,16.2882709503175 39.4772834777833,16.2903633117676 39.4772453308106,16.3063373565674 39.4834098815919,16.3087959289551 39.4866905212402,16.3210163116456 39.4897956848145,16.3374214172363 39.4867477416993,16.3534126281738 39.471321105957,16.3680400848389 39.4590148925782,16.3717212677002 39.4507141113282,16.3727836608887 39.4438018798829,16.3730602264405 39.4382247924805,16.3705615997314 39.4221382141114,16.3738021850587 39.4192390441895))0.0006POINT(16.29619830363509 39.447568841882685)
37163POLYGON((6.98849582672119 47.4730377197265,6.9920325279237 47.4717979431152,6.99176406860346 47.4664192199708,6.99176406860346 47.4664192199708,6.97125720977789 47.4490852355958,6.97125720977789 47.4490852355958,6.95980215072632 47.4546318054199,6.94513130188 47.4533615112306,6.93596601486212 47.4557647705079,6.93596601486212 47.4557647705079,6.93833541870129 47.4731521606446,6.93833541870129 47.4731521606446,6.94267225265514 47.4849205017091,6.94267225265514 47.4849205017091,6.94537353515625 47.4872894287111,6.94912528991699 47.4856986999513,6.94912528991699 47.4856986999513,6.95244646072399 47.4849395751954,6.95244646072399 47.4849395751954,6.98849582672119 47.4730377197265))0.0006POINT(6.957577303836274 47.47053045975542)
13603POLYGON((14.2923460006714 41.1085853576661,14.2882719039918 41.1021041870117,14.2881231307984 41.1004981994629,14.2900981903076 41.0961685180665,14.2951078414918 41.0931625366211,14.2951078414918 41.0931625366211,14.2981367111207 41.0938301086426,14.2989225387574 41.0915832519532,14.3004007339479 41.080135345459,14.3001155853272 41.0700721740723,14.3001155853272 41.0700721740723,14.3120441436768 41.0640907287598,14.3120441436768 41.0640907287598,14.3168516159059 41.0675506591798,14.3219203948976 41.0771102905275,14.3212003707886 41.0844688415527,14.3100452423096 41.0970458984376,14.3028745651246 41.0962295532227,14.2972106933594 41.1001739501954,14.2950057983399 41.10701751709,14.2923460006714 41.1085853576661))0.0006POINT(14.30179715156562 41.0878576278687)
20255POLYGON((10.9616956710815 45.2953987121583,10.9346609115602 45.2924575805665,10.926633834839 45.2937889099121,10.926633834839 45.2937889099121,10.9281282424928 45.2897033691406,10.9246835708618 45.2870445251465,10.920503616333 45.2901229858398,10.9203195571899 45.2922401428224,10.9168596267701 45.2913513183595,10.9101114273072 45.2817726135253,10.9094753265382 45.2761192321777,10.9044981002808 45.2683372497559,10.8900604248048 45.2495040893555,10.8900604248048 45.2495040893555,10.8978433609009 45.2479858398438,10.8978433609009 45.2479858398438,10.9014577865602 45.2433547973633,10.9031019210817 45.2384033203125,10.9378051757812 45.2338600158693,10.9378051757812 45.2338600158693,10.9293832778932 45.237964630127,10.9283714294434 45.2411766052246,10.9292478561403 45.2452659606934,10.9381732940675 45.2469215393066,10.953727722168 45.2535247802735,10.9655666351318 45.2612609863282,10.9697942733764 45.2626190185547,10.9769163131715 45.2632637023927,10.9769163131715 45.2632637023927,10.9759321212769 45.2731285095215,10.9688968658448 45.2757492065431,10.9616956710815 45.2953987121583))0.0006POINT(10.930745401690146 45.265184587047976)
39010POLYGON((2.15456533432001 42.9133453369141,2.16721820831305 42.9166374206544,2.16885042190557 42.9197273254395,2.16564321517944 42.9359703063965,2.16787719726568 42.9449157714844,2.16787719726568 42.9449157714844,2.17765927314758 42.9509010314942,2.1941483020783 42.9537353515626,2.1941483020783 42.9537353515626,2.20058894157415 42.9501380920411,2.20058894157415 42.9501380920411,2.19650053977966 42.9438934326172,2.19897985458374 42.9372215270997,2.19617962837231 42.9237632751465,2.19617962837231 42.9237632751465,2.18294548988342 42.9206886291504,2.18436551094061 42.8980102539064,2.18436551094061 42.8980102539064,2.18075442314154 42.896469116211,2.18075442314154 42.896469116211,2.15495729446417 42.9099502563477,2.15456533432001 42.9133453369141))0.0006POINT(2.181673697062944 42.92773328508655)