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 |
---|---|---|---|
30514 | POLYGON((-3.62074756622309 48.1709785461427,-3.56483888626099 48.1857452392579,-3.56483888626099 48.1857452392579,-3.56666946411127 48.1900329589844,-3.56666946411127 48.1900329589844,-3.5812628269195 48.1994056701661,-3.58218145370483 48.2162628173829,-3.59168028831482 48.2244720458986,-3.58910322189331 48.2305488586426,-3.6007776260376 48.2415275573731,-3.6007776260376 48.2415275573731,-3.61275839805597 48.246940612793,-3.61275839805597 48.246940612793,-3.61775445938105 48.2478637695312,-3.62025189399714 48.2376251220704,-3.6330001354217 48.2318534851075,-3.6380984783172 48.2258796691895,-3.65345454216003 48.225700378418,-3.66175341606134 48.2178077697754,-3.66175341606134 48.2178077697754,-3.65050196647644 48.2069282531738,-3.6304302215575 48.2039451599122,-3.6247296333313 48.1943855285645,-3.62074756622309 48.1709785461427)) | 0.0006 | POINT(-3.6107300986414024 48.21651989480729) |
1389072 | POLYGON((-6.19772195816034 37.4968986511232,-6.20746517181391 37.5187187194824,-6.21461915969849 37.5254058837892,-6.21690320968622 37.5251350402833,-6.21714210510248 37.5320129394532,-6.22136306762695 37.5404129028321,-6.22821617126459 37.5529212951661,-6.23316717147821 37.5561904907227,-6.23465490341187 37.5594482421875,-6.23210477828979 37.5627975463868,-6.23189687728882 37.5692176818847,-6.22850990295404 37.5730781555176,-6.22970676422113 37.5811157226564,-6.22825717926025 37.5871734619141,-6.2319860458374 37.5932273864747,-6.23187685012817 37.6011657714843,-6.23497009277344 37.6061630249023,-6.24111223220825 37.6109580993653,-6.24647188186646 37.6217422485353,-6.25708198547363 37.6281318664552,-6.24895381927485 37.6298332214357,-6.23259687423706 37.6363563537597,-6.22861289978022 37.6317367553711,-6.22588491439819 37.6226196289063,-6.21666097640986 37.6133613586426,-6.20625686645496 37.6102828979493,-6.20536613464355 37.6116943359375,-6.20236921310425 37.6080818176271,-6.18200492858887 37.6019668579102,-6.17941284179688 37.6019821166992,-6.17576408386225 37.6064834594728,-6.17082595825195 37.6088600158693,-6.16585922241211 37.6095275878907,-6.15278577804565 37.6032447814942,-6.14688110351563 37.5961685180665,-6.14323902130121 37.5951652526855,-6.13713788986206 37.5960197448731,-6.13110208511353 37.5871353149415,-6.12930393218988 37.5723152160645,-6.12557983398438 37.5701370239258,-6.1230211257934 37.5712127685548,-6.11890697479248 37.5667915344238,-6.12176895141602 37.562370300293,-6.11932182312006 37.5607147216798,-6.1193418502807 37.5560569763183,-6.11591386795044 37.5528221130371,-6.11365604400629 37.5537300109864,-6.11255693435669 37.5523796081544,-6.11438989639282 37.5512237548828,-6.11428880691528 37.5485801696778,-6.10868501663202 37.5441665649414,-6.09861993789667 37.5246353149415,-6.09604883193964 37.5237579345703,-6.09134292602539 37.5182342529297,-6.09374284744263 37.5161323547364,-6.09257078170776 37.5124053955079,-6.08981609344482 37.5122528076173,-6.0910120010376 37.508903503418,-6.08623504638672 37.5060386657716,-6.08620977401728 37.5032310485839,-6.09802103042603 37.4973068237305,-6.10549592971802 37.4904708862305,-6.1098952293396 37.4839820861816,-6.10798311233521 37.4771041870118,-6.11254787445063 37.4740371704102,-6.11316299438471 37.4774284362794,-6.15311002731318 37.483699798584,-6.17506504058832 37.4962196350098,-6.17390203475952 37.5005226135255,-6.19539022445673 37.5005836486816,-6.19772195816034 37.4968986511232)) | 0.0006 | POINT(-6.1660549845014065 37.55831260681155) |
61633 | POLYGON((6.87502193450933 46.4654617309571,6.87260723114019 46.4646339416504,6.86551380157465 46.4654808044433,6.86551380157465 46.4654808044433,6.85499095916748 46.4683647155762,6.85457611083984 46.4742012023927,6.85457611083984 46.4742012023927,6.85937500000006 46.4798240661621,6.87290906906139 46.4862937927246,6.88653707504272 46.5016212463379,6.89506912231445 46.5069389343262,6.89582490921026 46.5101127624511,6.89991521835339 46.5124206542969,6.89991521835339 46.5124206542969,6.90303897857666 46.5141372680665,6.91070699691784 46.5134582519531,6.92466688156128 46.5086364746095,6.93453121185308 46.5028762817383,6.94071006774902 46.5023498535157,6.95125722885138 46.5038375854493,6.96196222305304 46.4978790283204,6.96196222305304 46.4978790283204,6.9594898223877 46.4966926574708,6.95320320129395 46.498348236084,6.94373893737787 46.4981803894044,6.9360399246217 46.4954414367676,6.92939281463623 46.4915542602539,6.92204189300537 46.489185333252,6.90458106994629 46.4902153015138,6.89916706085211 46.4879913330079,6.88970899581903 46.4876365661621,6.88807821273804 46.4865188598634,6.88782119750977 46.4851074218751,6.89243698120117 46.4747962951661,6.89231109619141 46.473331451416,6.88897705078131 46.471321105957,6.87731409072882 46.4686279296874,6.87340497970587 46.4665985107422,6.87502193450933 46.4654617309571)) | 0.0006 | POINT(6.902076018484041 46.489212036132855) |
39386 | POLYGON((4.29503440856934 43.7361183166504,4.27414751052868 43.7663612365724,4.25642967224132 43.7772598266602,4.2559704780578 43.7840576171875,4.2559704780578 43.7840576171875,4.24337673187256 43.7750396728517,4.24337673187256 43.7750396728517,4.24042940139776 43.7685585021973,4.24042940139776 43.7685585021973,4.26000452041632 43.7483901977539,4.26735019683844 43.7437438964845,4.28154230117798 43.7416610717775,4.28790521621715 43.7364730834962,4.28790521621715 43.7364730834962,4.29503440856934 43.7361183166504)) | 0.0006 | POINT(4.263562304633045 43.760128021240305) |
49853 | POLYGON((3.25478315353399 49.8215179443361,3.26508951187145 49.8220520019532,3.29165148735046 49.8118667602539,3.30116057395941 49.813991546631,3.30510449409496 49.811809539795,3.30510449409496 49.811809539795,3.31417226791388 49.8098373413087,3.31417226791388 49.8098373413087,3.30119276046764 49.8241729736329,3.30332756042492 49.8305702209474,3.30332756042492 49.8305702209474,3.2888395786286 49.8351058959961,3.27349615097057 49.8334350585938,3.25478315353399 49.8215179443361)) | 0.0006 | POINT(3.293955527819203 49.82050587580762) |
23740 | POLYGON((3.14333891868591 46.3245277404785,3.14567232131969 46.341667175293,3.16689777374273 46.3651237487794,3.15934014320374 46.3694381713867,3.15934014320374 46.3694381713867,3.15795922279358 46.3822631835938,3.13916993141174 46.3820343017578,3.1270923614502 46.3863182067871,3.1270923614502 46.3863182067871,3.11763095855724 46.3856163024902,3.10761022567749 46.3784484863281,3.0909152030946 46.3848114013672,3.0909152030946 46.3848114013672,3.08775663375854 46.3786849975587,3.10072255134583 46.3685607910157,3.10201096534723 46.3549346923829,3.09859895706177 46.3524093627931,3.09859895706177 46.3524093627931,3.08300757408148 46.3443984985353,3.08689332008362 46.3349952697755,3.11998844146729 46.333396911621,3.11974549293524 46.323356628418,3.13380265235907 46.3208122253419,3.13380265235907 46.3208122253419,3.14244723320013 46.3214950561524,3.14333891868591 46.3245277404785)) | 0.0006 | POINT(3.12161400794986 46.35788330078129) |
33114 | POLYGON((2.20524454116821 48.2785301208497,2.18762898445141 48.2757110595703,2.1735920906068 48.2854843139649,2.1586048603059 48.2868804931642,2.1586048603059 48.2868804931642,2.16158938407909 48.2984352111816,2.16158938407909 48.2984352111816,2.16190028190624 48.3026237487794,2.16190028190624 48.3026237487794,2.16902399063116 48.3126983642578,2.16902399063116 48.3126983642578,2.17083501815807 48.315040588379,2.17083501815807 48.315040588379,2.18148422241211 48.3137931823731,2.18148422241211 48.3137931823731,2.2117903232575 48.3113327026367,2.2169241905213 48.3116836547853,2.22288727760315 48.3170928955078,2.23804688453686 48.3163719177246,2.23804688453686 48.3163719177246,2.24821805953991 48.3154220581055,2.24515724182135 48.2983970642091,2.24515724182135 48.2983970642091,2.22999358177191 48.2840843200685,2.20524454116821 48.2785301208497)) | 0.0006 | POINT(2.194565117359239 48.302825927734425) |
51807 | POLYGON((-1.03772902488708 46.1614837646486,-1.0385257005691 46.1619033813478,-1.0385257005691 46.1619033813478,-1.03319871425623 46.1697502136231,-1.03743267059326 46.1745491027833,-1.03743267059326 46.1745491027833,-1.02882313728333 46.1721954345704,-1.01647770404816 46.1756973266602,-1.00599670410156 46.1713447570802,-1.00599670410156 46.1713447570802,-1.01547503471375 46.1600608825685,-1.02878487110138 46.1640815734864,-1.03772902488708 46.1614837646486)) | 0.0006 | POINT(-1.0270332197348142 46.16823863983166) |
1402964 | POLYGON((2.39889097213756 41.7523117065431,2.39404988288879 41.7490577697754,2.39070010185242 41.7493782043457,2.38806700706488 41.7515525817872,2.39087510108953 41.7543563842774,2.38953995704657 41.7566261291504,2.38488793373119 41.7557754516602,2.38252210617071 41.7595481872559,2.37523102760315 41.7601966857911,2.36884498596203 41.7544136047364,2.36325693130499 41.7541580200196,2.36158800125128 41.7510337829591,2.35790300369263 41.7518196105958,2.35219597816473 41.7456550598145,2.34571599960333 41.7488212585449,2.34604501724243 41.7526435852051,2.34093189239502 41.7552108764648,2.33410406112682 41.7638740539551,2.34454703330999 41.7630920410157,2.35624599456787 41.7656784057617,2.36579298973083 41.7702980041505,2.36411404609692 41.7783889770508,2.36591911315912 41.7788352966309,2.36759209632874 41.7831535339355,2.36246299743664 41.7898750305176,2.36354398727423 41.7915687561035,2.37154603004467 41.7944717407226,2.37210202217113 41.7970848083496,2.38269090652466 41.8087387084962,2.38821792602539 41.8050575256347,2.39627695083624 41.8057403564453,2.40378403663635 41.8018760681152,2.41040492057806 41.801628112793,2.41175889968878 41.8034172058106,2.42655110359198 41.8046264648438,2.43700289726269 41.8025817871094,2.44288110733038 41.7989692687988,2.44377207756042 41.7892150878907,2.43181109428406 41.7804756164551,2.42634105682373 41.7820854187012,2.41742706298839 41.7906188964845,2.40661501884466 41.7842140197755,2.40620207786566 41.7805976867677,2.40320301055914 41.7776985168458,2.40774488449102 41.7679481506348,2.39912104606634 41.7603340148926,2.40192389488232 41.7540817260742,2.39889097213756 41.7523117065431)) | 0.0006 | POINT(2.386020132835925 41.77401668467424) |
30568 | POLYGON((-3.95686101913441 48.3670043945312,-3.96134829521179 48.3605728149414,-3.96638917922974 48.3594436645508,-4.00210618972773 48.3661842346191,-4.04818153381348 48.3578109741212,-4.04818153381348 48.3578109741212,-4.02002048492432 48.3496246337892,-4.01197957992548 48.3373107910156,-4.01079273223871 48.3239593505859,-4.01079273223871 48.3239593505859,-3.99663925170898 48.3326034545899,-3.94636368751526 48.3398246765136,-3.94130039215082 48.3493804931641,-3.94914889335632 48.3584098815919,-3.94914889335632 48.3584098815919,-3.95686101913441 48.3670043945312)) | 0.0006 | POINT(-3.987950293223037 48.34948730468753) |