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 |
---|---|---|---|
21948 | POLYGON((-0.494230270385742 44.882423400879,-0.497064888477325 44.8768539428712,-0.497064888477325 44.8768539428712,-0.47509324550623 44.8710289001465,-0.472026407718602 44.8655014038085,-0.472026407718602 44.8655014038085,-0.459497690200749 44.8645401000976,-0.459497690200749 44.8645401000976,-0.449282079935074 44.8663635253907,-0.449282079935074 44.8663635253907,-0.451267033815327 44.8792686462403,-0.444012433290482 44.8913803100587,-0.444012433290482 44.8913803100587,-0.463506132364273 44.8980751037598,-0.463506132364273 44.8980751037598,-0.481625199317932 44.8837738037111,-0.494230270385742 44.882423400879)) | 0.0006 | POINT(-0.46706218831239 44.87762022018436) |
12602 | POLYGON((16.9082164764405 41.0124168395996,16.904779434204 41.0083961486816,16.904779434204 41.0083961486816,16.9075584411621 41.0080757141114,16.9114646911622 41.0009346008301,16.9119892120362 40.9969635009767,16.907777786255 40.9872970581055,16.9059143066406 40.9862022399903,16.900941848755 40.9855728149413,16.8979263305664 40.9865226745606,16.8868179321289 40.9821281433106,16.8891468048096 40.9729957580567,16.8885936737061 40.9702301025391,16.8846302032471 40.962963104248,16.8818225860596 40.9627838134766,16.8818225860596 40.9627838134766,16.8825778961182 40.9568557739258,16.88165473938 40.9477005004883,16.8886127471924 40.9117546081544,16.8910350799561 40.9051284790039,16.8988742828369 40.9064941406251,16.8957557678223 40.8937377929688,16.8979988098145 40.8741836547851,16.8979988098145 40.8741836547851,16.9051399230958 40.8738288879395,16.92488861084 40.8758621215821,16.9254188537597 40.8892669677734,16.9302120208741 40.8994178771974,16.9380702972412 40.9092750549317,16.9429435729982 40.9110603332521,16.9652633666993 40.9100875854492,16.9652633666993 40.9100875854492,16.9646396636964 40.9170150756837,16.967586517334 40.935131072998,16.9685516357422 40.9392738342286,16.9713726043702 40.9421463012695,16.9742908477784 40.9540328979493,16.9742908477784 40.9540328979493,16.9751567840577 40.956787109375,16.9716377258301 40.9707756042482,16.9654502868653 40.9792480468751,16.9615287780762 40.9816131591797,16.958595275879 40.9913291931153,16.958595275879 40.9913291931153,16.9554576873779 40.9945678710938,16.9412326812744 41.0029602050781,16.9412326812744 41.0029602050781,16.9211292266847 41.0082435607911,16.9137840270996 41.0126724243164,16.9137840270996 41.0126724243164,16.9082164764405 41.0124168395996)) | 0.0006 | POINT(16.924084129333547 40.95580757141116) |
51659 | POLYGON((3.07274055480957 49.9810523986818,3.07837343215937 49.9663734436036,3.07837343215937 49.9663734436036,3.07428121566784 49.9676399230958,3.06508374214178 49.9627685546876,3.06508374214178 49.9627685546876,3.04919528961176 49.9624176025391,3.04919528961176 49.9624176025391,3.04541540145874 49.9708099365235,3.05028080940247 49.9757652282714,3.05028080940247 49.9757652282714,3.06258845329279 49.9830627441407,3.06258845329279 49.9830627441407,3.07274055480957 49.9810523986818)) | 0.0006 | POINT(3.061806201934807 49.97079056959892) |
1402638 | MULTIPOLYGON(((-5.3810019493103 41.9506835937499,-5.38495683670038 41.9486618041993,-5.38712882995605 41.954200744629,-5.39280605316162 41.9550132751465,-5.38980007171631 41.9436836242677,-5.39509677886963 41.9423828125001,-5.40046215057367 41.9432716369629,-5.40308523178095 41.9453430175781,-5.40389394760132 41.9389381408693,-5.4067177772522 41.9351882934571,-5.40741491317749 41.937370300293,-5.43107318878174 41.9473342895508,-5.43726491928101 41.9471054077148,-5.43638086318964 41.9485664367676,-5.43856000900269 41.9525871276856,-5.4365148544311 41.95369720459,-5.43332195281982 41.9611206054689,-5.43817186355585 41.9673767089844,-5.43341112136829 41.9830589294434,-5.43105888366694 42.00244140625,-5.43627214431751 42.0090141296387,-5.44298982620239 42.0119438171387,-5.44769906997681 42.0107192993165,-5.44732999801636 42.0136413574219,-5.42148017883301 42.0306625366211,-5.42016887664795 42.0292129516603,-5.41196680068964 42.0304489135742,-5.41206312179565 42.0291786193847,-5.40859794616699 42.0289154052734,-5.39694309234619 42.0186576843263,-5.39360380172724 42.0114173889161,-5.393636226654 42.0058059692382,-5.38929605484003 42.0018348693848,-5.38475418090815 41.9898147583008,-5.38925504684448 41.9716949462891,-5.38283491134638 41.9642639160156,-5.38482904434204 41.9578514099121,-5.3810019493103 41.9506835937499)),((-5.35780096054071 42.0065307617189,-5.34746313095093 42.0042114257813,-5.34825420379639 41.9948196411133,-5.35423612594604 41.9959754943849,-5.35764789581299 41.9935722351074,-5.35923385620117 41.9950256347657,-5.3654470443725 41.9916572570801,-5.38271188735956 42.0039978027344,-5.38254308700562 42.0055923461915,-5.38025712966913 42.0077476501465,-5.37608623504639 42.008270263672,-5.36988019943237 42.0053977966309,-5.37203598022461 42.011432647705,-5.370765209198 42.0141944885254,-5.35446691513056 42.0084991455078,-5.35780096054071 42.0065307617189))) | 0.0006 | POINT(-5.406980855906264 41.980225997732106) |
40336 | POLYGON((1.81126511096949 45.0909309387208,1.81276559829712 45.0968971252443,1.81276559829712 45.0968971252443,1.80716979503637 45.1017456054688,1.80093419551861 45.1203727722169,1.80093419551861 45.1203727722169,1.78842473030096 45.1171493530274,1.77745556831366 45.1220664978028,1.77745556831366 45.1220664978028,1.77654814720154 45.1048278808595,1.77654814720154 45.1048278808595,1.77674341201777 45.1017150878907,1.79062581062323 45.0941848754882,1.79062581062323 45.0941848754882,1.79521203041077 45.089614868164,1.79521203041077 45.089614868164,1.80286729335791 45.0924720764161,1.81126511096949 45.0909309387208)) | 0.0006 | POINT(1.7937384142595505 45.103525947122066) |
1403024 | POLYGON((2.2675349712373 41.8044586181641,2.26666688919067 41.8081016540528,2.26938104629528 41.8128738403321,2.27403092384333 41.8154067993165,2.27215290069586 41.8206672668458,2.25919389724737 41.8168907165527,2.2423210144043 41.8214607238769,2.24188089370728 41.8299140930176,2.24682497978222 41.8397102355958,2.25944399833691 41.8369560241699,2.27576494216925 41.8241920471191,2.28258705139166 41.8230171203613,2.28702592849737 41.8257446289064,2.30939793586742 41.8274459838868,2.31460189819336 41.8311309814453,2.32166910171514 41.8327636718751,2.32521796226507 41.8321380615235,2.33795809745794 41.8223648071289,2.34487795829784 41.826831817627,2.3437650203706 41.8217315673829,2.34641194343567 41.8173713684083,2.34952306747442 41.8157234191896,2.35155797004711 41.8096961975098,2.35430598258978 41.8071441650391,2.36425304412847 41.8066711425782,2.36711096763611 41.8044281005859,2.37052297592163 41.8040885925294,2.37661910057079 41.805046081543,2.38269090652466 41.8087387084962,2.37210202217113 41.7970848083496,2.37154603004467 41.7944717407226,2.36354398727423 41.7915687561035,2.36246299743664 41.7898750305176,2.36759209632874 41.7831535339355,2.36591911315912 41.7788352966309,2.36411404609692 41.7783889770508,2.36579298973083 41.7702980041505,2.35624599456787 41.7656784057617,2.34454703330999 41.7630920410157,2.33410406112682 41.7638740539551,2.33210992813122 41.7720184326172,2.32815289497387 41.7759437561035,2.32945895195002 41.778907775879,2.32792091369629 41.7860183715821,2.3221869468689 41.7878150939942,2.31794500350952 41.7923545837403,2.30323290824884 41.7986335754395,2.29262208938604 41.7939567565919,2.28913903236401 41.7890701293946,2.27055096626293 41.7953109741212,2.26782894134527 41.7979469299318,2.2675349712373 41.8044586181641)) | 0.0006 | POINT(2.32067475131919 41.80386285220878) |
20288 | POLYGON((11.6812229156495 45.8428649902344,11.6692714691163 45.8330917358398,11.668984413147 45.8350105285645,11.6647863388063 45.8356971740723,11.6431789398194 45.8302421569825,11.6431789398194 45.8302421569825,11.6460723876954 45.8227844238282,11.6460723876954 45.8227844238282,11.677227973938 45.8196640014649,11.67826461792 45.8192901611329,11.6786909103394 45.81689453125,11.6809101104737 45.8154029846193,11.6922903060913 45.8124771118165,11.707745552063 45.8169555664063,11.7137184143067 45.820125579834,11.7137184143067 45.820125579834,11.6994743347167 45.8327598571778,11.6994743347167 45.8327598571778,11.6812229156495 45.8428649902344)) | 0.0006 | POINT(11.678015708923384 45.825509601169216) |
14098 | POLYGON((10.7064151763917 44.1991004943848,10.7010908126832 44.1944923400879,10.7010908126832 44.1944923400879,10.7052402496338 44.1921348571777,10.7052402496338 44.1921348571777,10.7219257354736 44.1966667175294,10.7265739440918 44.199432373047,10.7265729904175 44.2066688537598,10.729868888855 44.2171096801758,10.7868347167969 44.219066619873,10.8043909072877 44.2350273132324,10.7998151779175 44.2399826049805,10.7966403961183 44.2418251037598,10.7984018325806 44.2458114624023,10.8175354003907 44.2509574890137,10.8248510360718 44.2510108947755,10.8305311203003 44.2480316162111,10.8320569992065 44.2455101013183,10.8350200653077 44.2437362670898,10.8511667251588 44.2366790771484,10.8621788024902 44.2331542968751,10.8621788024902 44.2331542968751,10.8704395294191 44.2359390258789,10.8708534240723 44.2379035949707,10.8605241775513 44.2411422729493,10.8632497787476 44.2493476867676,10.8655748367311 44.250774383545,10.867943763733 44.2575607299805,10.8672513961793 44.2609939575196,10.8650846481324 44.2626228332521,10.8641929626466 44.2649040222169,10.8643856048585 44.2674598693848,10.8662080764771 44.2699317932128,10.8662080764771 44.2699317932128,10.8561859130859 44.2675666809083,10.8491077423097 44.2684555053712,10.8395214080811 44.2719841003419,10.8235158920288 44.273078918457,10.8174667358398 44.274356842041,10.8136577606202 44.2768096923829,10.8072080612183 44.2846832275392,10.7931785583497 44.2981109619141,10.7931785583497 44.2981109619141,10.7869100570679 44.2881164550782,10.7778663635254 44.2770767211913,10.7569799423218 44.2666397094727,10.7466115951539 44.2575187683107,10.7366104125977 44.2458305358887,10.7339382171631 44.2337646484376,10.7240476608276 44.2248191833497,10.7128839492799 44.208953857422,10.7109498977661 44.2031059265137,10.7064151763917 44.1991004943848)) | 0.0006 | POINT(10.799949150819096 44.24430142916169) |
44739 | POLYGON((0.691511392593327 43.1017608642579,0.678810775280112 43.1033744812013,0.675669848918972 43.1011657714845,0.675669848918972 43.1011657714845,0.663338422775325 43.1057929992676,0.661181986332053 43.1111373901367,0.653772532939854 43.1109237670898,0.653772532939854 43.1109237670898,0.646105825901031 43.119140625,0.640262007713318 43.1353187561036,0.64355510473257 43.141040802002,0.65267896652216 43.14119720459,0.65267896652216 43.14119720459,0.658009529113883 43.1361007690429,0.69010961055767 43.1393241882325,0.69010961055767 43.1393241882325,0.695004105567989 43.1154937744142,0.691511392593327 43.1017608642579)) | 0.0006 | POINT(0.6660141804639366 43.12084601907175) |
37029 | POLYGON((5.48689031600958 46.3628730773926,5.46526288986217 46.3452873229982,5.46526288986217 46.3452873229982,5.4407048225404 46.3468170166016,5.4407048225404 46.3468170166016,5.44573259353638 46.3609085083008,5.44573259353638 46.3609085083008,5.45550394058239 46.3713111877441,5.45550394058239 46.3713111877441,5.46218538284302 46.3679504394531,5.47232341766369 46.3719635009766,5.47232341766369 46.3719635009766,5.48112297058111 46.3708457946778,5.48689031600958 46.3628730773926)) | 0.0006 | POINT(5.460711845984904 46.36109572190508) |