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 |
|---|---|---|---|
| 49847 | POLYGON((3.33812260627747 49.9171371459961,3.33991718292248 49.9067001342774,3.33442234992992 49.8896560668945,3.33442234992992 49.8896560668945,3.32445144653332 49.8894424438478,3.31975650787359 49.8835678100586,3.31975650787359 49.8835678100586,3.30480861663824 49.8925628662109,3.28557562828075 49.8972091674805,3.28557562828075 49.8972091674805,3.28384757041931 49.9040756225587,3.29364156723017 49.9165420532226,3.29879546165466 49.917652130127,3.29879546165466 49.917652130127,3.30757069587713 49.914764404297,3.32658338546747 49.9249267578124,3.32658338546747 49.9249267578124,3.32953596115118 49.9188842773438,3.33812260627747 49.9171371459961)) | 0.0006 | POINT(3.314009017414561 49.90478515625001) |
| 21312 | POLYGON((0.619376003742332 44.8770217895508,0.61706763505947 44.8779792785646,0.61706763505947 44.8779792785646,0.594637811183929 44.8778305053712,0.582545340061188 44.887981414795,0.560295045375881 44.8841896057129,0.560295045375881 44.8841896057129,0.557756721973533 44.8842849731446,0.557756721973533 44.8842849731446,0.565560758113861 44.8641548156739,0.579602122306824 44.8616218566895,0.583996534347477 44.8557472229004,0.583996534347477 44.8557472229004,0.598455488681793 44.8673667907715,0.611849963665009 44.868709564209,0.619376003742332 44.8770217895508)) | 0.0006 | POINT(0.5860172907511773 44.873939259847056) |
| 49850 | POLYGON((3.28200268745434 49.874797821045,3.27531123161316 49.8789787292481,3.27656674385082 49.8849143981935,3.27656674385082 49.8849143981935,3.28074073791515 49.8904914855958,3.28545808792126 49.8911209106446,3.28557562828075 49.8972091674805,3.28557562828075 49.8972091674805,3.30480861663824 49.8925628662109,3.31975650787359 49.8835678100586,3.31975650787359 49.8835678100586,3.31053066253668 49.8639640808107,3.31053066253668 49.8639640808107,3.30578255653387 49.8624839782715,3.28200268745434 49.874797821045)) | 0.0006 | POINT(3.294211643082835 49.88212476457875) |
| 44200 | POLYGON((0.13701897859579 43.94624710083,0.141454756259918 43.9452857971193,0.153004869818801 43.9503593444825,0.163676157593841 43.9686279296876,0.161034524440709 43.9743499755861,0.161034524440709 43.9743499755861,0.152050659060592 43.9732093811035,0.138624876737708 43.9765968322754,0.140999749302978 43.9936408996583,0.126847431063709 44.0019264221193,0.126847431063709 44.0019264221193,0.127415299415702 43.9985809326173,0.107387967407817 43.9853820800782,0.107387967407817 43.9853820800782,0.11292955279356 43.9722633361817,0.125129908323345 43.9677200317383,0.13701897859579 43.94624710083)) | 0.0006 | POINT(0.13642779085791906 43.97599053382883) |
| 48150 | POLYGON((-0.552135884761753 47.4410896301269,-0.545431673526707 47.4289054870605,-0.530890345573312 47.4206352233888,-0.545394837856293 47.4181213378906,-0.545394837856293 47.4181213378906,-0.536859214305821 47.4052696228027,-0.526580929756051 47.4057998657227,-0.517183065414372 47.402759552002,-0.517183065414372 47.402759552002,-0.512342095375061 47.4026069641113,-0.512342095375061 47.4026069641113,-0.500204920768738 47.4120559692383,-0.498323231935444 47.4182052612305,-0.468860775232315 47.416717529297,-0.468860775232315 47.416717529297,-0.469010919332504 47.4229316711427,-0.476517856121063 47.4258766174316,-0.46969336271286 47.4336700439454,-0.46969336271286 47.4336700439454,-0.485240519046783 47.4415740966797,-0.499131679534912 47.4405364990235,-0.50944197177887 47.4476852416992,-0.50944197177887 47.4476852416992,-0.523117065429631 47.4504089355469,-0.533058166503906 47.4432296752931,-0.552135884761753 47.4410896301269)) | 0.0006 | POINT(-0.5088933849334467 47.42398559570316) |
| 13532 | POLYGON((14.8612041473389 41.4273910522462,14.8754682540894 41.4344863891602,14.8754682540894 41.4344863891602,14.8792734146119 41.4283638000488,14.8860769271851 41.4248504638672,14.8949537277222 41.4264068603516,14.8949537277222 41.4264068603516,14.8955011367799 41.421501159668,14.8981657028199 41.4156913757325,14.9004535675049 41.4059753417969,14.8953752517701 41.4025306701661,14.8862838745118 41.3817596435547,14.8800439834596 41.373348236084,14.8755540847779 41.3705825805665,14.8733654022217 41.3650093078614,14.8733654022217 41.3650093078614,14.8724994659423 41.3615684509278,14.8618593215944 41.3611221313476,14.853879928589 41.3578453063965,14.853879928589 41.3578453063965,14.849557876587 41.3553085327149,14.8392353057862 41.3392143249512,14.8393707275391 41.336856842041,14.8393707275391 41.336856842041,14.837347984314 41.333797454834,14.837347984314 41.333797454834,14.8333044052125 41.3350067138672,14.8233003616334 41.3404273986816,14.8233003616334 41.3404273986816,14.8196525573732 41.3454895019531,14.8189773559571 41.3689460754395,14.8212575912477 41.3747863769532,14.8168935775758 41.3824691772462,14.8147258758545 41.38436126709,14.8111934661865 41.3855705261231,14.8094730377198 41.3891410827637,14.8094730377198 41.3891410827637,14.8155164718628 41.3883590698243,14.8307714462281 41.3902931213379,14.8533735275269 41.4022407531738,14.8610210418701 41.417263031006,14.8625526428223 41.4230613708496,14.8612041473389 41.4273910522462)) | 0.0006 | POINT(14.853681973048687 41.38178561982657) |
| 1389446 | POLYGON((0.331602990627346 41.7265357971191,0.310054004192466 41.7269592285156,0.300909996032715 41.7233810424805,0.298135995864868 41.7205352783203,0.274812012910957 41.7292747497559,0.261038988828659 41.739112854004,0.259474992752189 41.7429122924805,0.261770009994564 41.7528419494629,0.249303996563071 41.7664909362794,0.247135996818542 41.7719116210939,0.257928013801575 41.7754859924318,0.268317997455597 41.7813491821289,0.256666988134384 41.7931632995606,0.251827001571712 41.7928504943847,0.247283995151633 41.8091506958009,0.259333997964973 41.8174629211425,0.272671997547263 41.8125,0.278961986303443 41.8171195983887,0.288035005331096 41.8168144226075,0.29056999087345 41.8197517395019,0.295046001672802 41.8183441162109,0.304185003042335 41.8204498291016,0.308414995670319 41.8231201171875,0.32368299365055 41.8213272094728,0.319269001483917 41.8185806274415,0.317586988210735 41.8123703002931,0.319858998060283 41.8015899658203,0.325264990329799 41.7965431213379,0.324802011251393 41.794548034668,0.337512999773082 41.7920722961427,0.341091006994247 41.7875556945801,0.3407239913941 41.7644691467285,0.344843000173682 41.7474632263183,0.358401000499839 41.734016418457,0.348554998636246 41.7291564941407,0.331602990627346 41.7265357971191)) | 0.0006 | POINT(0.296430683987538 41.77992030552459) |
| 31354 | POLYGON((2.08136892318726 46.9566459655762,2.08457040786749 46.9586334228516,2.08457040786749 46.9586334228516,2.09083938598633 46.9666900634766,2.08704495429993 46.9725189208986,2.09459233284002 46.9805679321289,2.09459233284002 46.9805679321289,2.1404755115509 46.9776420593262,2.1404755115509 46.9776420593262,2.13700795173651 46.9575271606445,2.13700795173651 46.9575271606445,2.12220597267145 46.9547386169434,2.10206151008617 46.9578285217285,2.08136892318726 46.9566459655762)) | 0.0006 | POINT(2.107447165709306 46.96593563373275) |
| 32104 | POLYGON((0.71393579244625 47.1308593749999,0.710380673408508 47.1396713256836,0.710380673408508 47.1396713256836,0.69137054681778 47.1354103088379,0.669195055961723 47.1430625915528,0.6498082280159 47.1450576782227,0.645655691623801 47.14310836792,0.645655691623801 47.14310836792,0.633371472358704 47.137264251709,0.609486401081085 47.1332511901855,0.592591106891632 47.1258850097657,0.584370136260986 47.1176261901855,0.584370136260986 47.1176261901855,0.58867442607891 47.1157951354981,0.586307108402252 47.1020736694336,0.5905135869981 47.0885353088379,0.585449755191803 47.0826377868653,0.585449755191803 47.0826377868653,0.592106819152832 47.0785522460939,0.592106819152832 47.0785522460939,0.604291260242519 47.0743713378907,0.604291260242519 47.0743713378907,0.6120663285256 47.0824966430665,0.625639915466422 47.0862808227539,0.64839190244669 47.0994911193848,0.65669983625412 47.0958938598634,0.65669983625412 47.0958938598634,0.679560005664882 47.109001159668,0.686432182788963 47.1176300048829,0.704460680484772 47.1240272521974,0.704460680484772 47.1240272521974,0.71393579244625 47.1308593749999)) | 0.0006 | POINT(0.636908831134954 47.11173777426448) |
| 68319 | POLYGON((7.84302186965948 50.4548416137695,7.84416294097906 50.4548568725586,7.84405469894415 50.4560241699219,7.84999132156378 50.4580345153809,7.84999132156378 50.4580345153809,7.85201787948614 50.458106994629,7.85229969024664 50.4631118774415,7.85474634170532 50.4654998779297,7.86032438278198 50.4646377563477,7.85963201522833 50.4624214172364,7.86069107055675 50.4623756408691,7.86069107055675 50.4623756408691,7.86358213424688 50.4591217041017,7.86372661590588 50.4575576782227,7.86772012710583 50.4557571411133,7.87258720397961 50.4572372436525,7.87813901901256 50.4573211669922,7.87838363647467 50.4562263488769,7.87942695617676 50.4562339782715,7.87938070297247 50.4530181884767,7.87938070297247 50.4530181884767,7.87874269485485 50.4508056640625,7.87625503540039 50.4488945007325,7.87297105789179 50.4483680725099,7.8741340637207 50.4457206726075,7.87119913101191 50.4455108642578,7.87435579299938 50.4442863464356,7.87158155441296 50.4429626464843,7.87231159210211 50.441577911377,7.86939668655407 50.4381790161134,7.87044382095331 50.4363479614258,7.86971807479858 50.4349632263184,7.87213850021374 50.4317588806153,7.87213850021374 50.4317588806153,7.86859893798834 50.4325408935547,7.86139535903936 50.4315490722656,7.8562207221986 50.4333305358886,7.85453939437866 50.4321479797364,7.85307168960566 50.4344253540039,7.85464143753057 50.4358406066895,7.8512110710144 50.4376792907716,7.8484549522401 50.4378051757814,7.84854030609137 50.4392852783204,7.84712362289434 50.4391593933106,7.84566831588751 50.4407119750977,7.84541273117071 50.4444732666017,7.8429589271546 50.4443817138672,7.8448424339295 50.4475898742677,7.8411593437196 50.4503784179689,7.84363746643072 50.4534301757814,7.84302186965948 50.4548416137695)) | 0.0006 | POINT(7.860936298370418 50.448033523559594) |