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 |
---|---|---|---|
45381 | POLYGON((0.0825190991163822 43.4245758056641,0.0791588574648472 43.4318847656251,0.0791588574648472 43.4318847656251,0.0763598307968323 43.4376182556152,0.079691082239151 43.4396514892579,0.091458849608955 43.4434432983398,0.0995604991912842 43.4413108825684,0.0995604991912842 43.4413108825684,0.10086348652851 43.4394836425782,0.10086348652851 43.4394836425782,0.105164691805953 43.4252128601074,0.105164691805953 43.4252128601074,0.0932925418018726 43.4267196655274,0.0864446386695477 43.4238891601564,0.0864446386695477 43.4238891601564,0.0825190991163822 43.4245758056641)) | 0.0006 | POINT(0.09104705005889849 43.43303807576502) |
1398312 | POLYGON((-4.92470788955688 40.7224998474121,-4.92398118972778 40.7181930541992,-4.9281702041626 40.7139930725098,-4.9352650642395 40.7125244140626,-4.94038391113281 40.7065811157227,-4.94321012496948 40.7073249816896,-4.94617319107056 40.6977005004884,-4.94286823272705 40.6968002319335,-4.94804906845093 40.6954536437989,-4.95304203033442 40.6889648437501,-4.95977878570557 40.6886596679688,-4.96226406097412 40.6902046203614,-4.9606728553772 40.6953277587891,-4.96491384506226 40.695457458496,-4.96818494796742 40.7004699707031,-4.96428108215332 40.7060775756837,-4.96687889099115 40.707088470459,-4.97003078460693 40.7116889953614,-4.96667194366449 40.7129096984863,-4.96725702285767 40.7151679992677,-4.96621322631836 40.7142868041993,-4.96485090255737 40.7174377441406,-4.95771217346191 40.7210884094239,-4.96037721633905 40.7215194702149,-4.96208381652832 40.7255897521973,-4.96684312820429 40.7279930114746,-4.96855401992798 40.7298660278321,-4.96577596664429 40.7328033447267,-4.96235322952271 40.7452239990236,-4.95332479476923 40.7475738525391,-4.94603586196888 40.7458305358887,-4.9462571144104 40.7448654174804,-4.93642997741699 40.7465705871583,-4.93277597427362 40.7439002990723,-4.93674421310425 40.7346000671388,-4.9238400459289 40.7256126403809,-4.92470788955688 40.7224998474121)) | 0.0006 | POINT(-4.952415466308575 40.71688471900097) |
1409214 | POLYGON((-2.87830209732056 43.1910972595216,-2.87808799743652 43.1886749267579,-2.8811531066894 43.187702178955,-2.89060711860657 43.1920433044435,-2.89509010314941 43.1906967163086,-2.89954304695129 43.1914062500001,-2.89455389976496 43.1878509521484,-2.89679002761841 43.1829223632813,-2.89891695976252 43.1832733154297,-2.89996004104609 43.1856956481934,-2.90669107437128 43.1864929199219,-2.9159369468689 43.1909942626954,-2.92374610900873 43.1869125366212,-2.92746996879578 43.1891021728517,-2.92084193229675 43.1958618164063,-2.92947506904596 43.2015304565429,-2.93726992607105 43.1993942260743,-2.93426799774164 43.196445465088,-2.9397559165954 43.1975860595703,-2.95263600349415 43.2072792053223,-2.95688009262085 43.2126617431641,-2.94965004920959 43.2167320251465,-2.9453649520874 43.2167205810547,-2.92904210090637 43.2133369445801,-2.91050601005554 43.2188682556153,-2.90644502639765 43.22611618042,-2.91733002662647 43.2356491088868,-2.92118811607361 43.2418403625489,-2.91385388374323 43.2456703186036,-2.90145802497864 43.2329559326173,-2.90164709091187 43.2300643920899,-2.89786100387573 43.2262153625489,-2.89728903770447 43.2219276428223,-2.90028405189508 43.2210769653321,-2.89873909950256 43.2166709899903,-2.89441990852356 43.2151641845704,-2.88832306861872 43.2170219421388,-2.88658905029291 43.2158584594727,-2.882982969284 43.1961784362794,-2.87830209732056 43.1910972595216),(-2.90842700004578 43.1929588317872,-2.90660190582275 43.1946907043458,-2.91158199310303 43.1985359191896,-2.90995407104487 43.2012901306152,-2.91438102722162 43.20418548584,-2.91853094100952 43.2030715942383,-2.92089700698847 43.2001113891602,-2.91269898414612 43.1924324035646,-2.90842700004578 43.1929588317872)) | 0.0006 | POINT(-2.9101530569233884 43.206901962005006) |
62867 | POLYGON((13.4238214492799 54.4455108642579,13.4193782806396 54.4459075927734,13.4193782806396 54.4459075927734,13.4133481979371 54.4522209167481,13.4153451919556 54.4591293334961,13.415428161621 54.4650993347168,13.4133090972901 54.4706764221191,13.4114475250245 54.4707527160646,13.4075908660889 54.475513458252,13.4049291610718 54.4742546081543,13.3989171981812 54.4752273559571,13.3989171981812 54.4752273559571,13.3998517990112 54.4762687683106,13.3988485336304 54.4767112731933,13.4109258651734 54.4880256652832,13.4091682434083 54.4889526367188,13.4097175598145 54.4906845092775,13.4140043258667 54.4924545288085,13.420865058899 54.4889640808105,13.4206905364991 54.4863967895508,13.4262313842774 54.4848327636718,13.4264097213745 54.4840621948242,13.4308986663819 54.4847221374511,13.4322090148926 54.4893074035644,13.4322090148926 54.4893074035644,13.4402723312379 54.4879150390625,13.4430561065674 54.4862518310547,13.4441680908204 54.4845848083496,13.4441680908204 54.4806938171388,13.4458341598511 54.4801406860352,13.4458341598511 54.4784736633301,13.4486122131348 54.4762496948242,13.4480562210084 54.4743041992189,13.4508323669434 54.4731941223145,13.4530544281006 54.4734725952149,13.4536113739014 54.47513961792,13.4575014114379 54.4773597717285,13.4602766036988 54.4773597717285,13.4669456481934 54.4801406860352,13.4791660308837 54.4831962585449,13.4886112213135 54.4831962585449,13.495834350586 54.4795837402344,13.5002126693726 54.4798622131348,13.5006904602051 54.4788627624512,13.4900674819946 54.4771728515626,13.4838228225707 54.47371673584,13.4792909622192 54.4662132263185,13.4736852645875 54.4608535766602,13.4708414077759 54.4562835693359,13.4708013534546 54.454044342041,13.47203540802 54.4523696899415,13.4750204086304 54.4517478942871,13.4750204086304 54.4517478942871,13.4719552993774 54.4494018554688,13.4709749221802 54.4474334716796,13.4676103591918 54.4478302001953,13.4590587615966 54.4409866333008,13.4576530456544 54.441162109375,13.4581956863404 54.4443397521973,13.4602518081666 54.4470939636231,13.4654531478882 54.4480667114258,13.4598684310913 54.4520263671874,13.4534063339233 54.4482078552247,13.449776649475 54.4494590759277,13.4487514495849 54.4522514343263,13.4474182128907 54.4523735046387,13.4481973648072 54.4547271728516,13.4393558502197 54.4546432495118,13.4327211380005 54.4536743164063,13.4318504333497 54.4524383544922,13.4301729202272 54.4527206420899,13.4305047988891 54.4503593444825,13.4238214492799 54.4455108642579)) | 0.0006 | POINT(13.444643616676354 54.467631181081146) |
16249 | POLYGON((9.26851463317877 45.1098098754884,9.26432323455822 45.1129951477051,9.26187610626232 45.1195716857911,9.26237678527843 45.1210479736329,9.269687652588 45.1240196228028,9.269687652588 45.1240196228028,9.26286125183117 45.1267166137696,9.26286125183117 45.1267166137696,9.25871562957769 45.1264572143555,9.23838329315197 45.1371574401857,9.23838329315197 45.1371574401857,9.23039913177496 45.131233215332,9.2346010208131 45.120460510254,9.23436641693115 45.1127624511719,9.23058891296392 45.1088829040528,9.22776222229004 45.1074829101564,9.21638774871832 45.1074523925782,9.21638774871832 45.1074523925782,9.21476936340332 45.1060523986818,9.22091579437267 45.098659515381,9.22678470611572 45.0981788635254,9.22959804534912 45.0931053161622,9.22959804534912 45.0931053161622,9.23333358764648 45.0931243896485,9.23333358764648 45.0931243896485,9.24522113800055 45.1075248718262,9.24522113800055 45.1075248718262,9.25294017791748 45.1110496520997,9.25401210784912 45.1092758178711,9.25388526916504 45.1063041687011,9.26777076721191 45.1083145141602,9.26851463317877 45.1098098754884)) | 0.0006 | POINT(9.243727345620485 45.11247548749377) |
36489 | POLYGON((5.64002513885498 47.3123855590821,5.62817811965942 47.3168525695801,5.62467432022095 47.3148040771485,5.62467432022095 47.3148040771485,5.61216068267822 47.30424118042,5.60978651046759 47.2976303100587,5.60978651046759 47.2976303100587,5.60907888412481 47.2945022583007,5.61806488037115 47.2952461242676,5.62005805969244 47.2891502380372,5.62005805969244 47.2891502380372,5.63947343826294 47.2906646728517,5.63947343826294 47.2906646728517,5.63694763183599 47.3063583374023,5.64002513885498 47.3123855590821)) | 0.0006 | POINT(5.623745713915173 47.30100604466037) |
27694 | POLYGON((-0.290762513875904 48.7302474975587,-0.27193042635912 48.7174491882325,-0.27193042635912 48.7174491882325,-0.281347781419697 48.7157707214355,-0.290312200784683 48.7082023620605,-0.286329060792866 48.6965675354004,-0.286329060792866 48.6965675354004,-0.290691614151001 48.6915588378907,-0.290691614151001 48.6915588378907,-0.30507755279541 48.6889724731445,-0.321562796831131 48.6815719604492,-0.321562796831131 48.6815719604492,-0.327650189399719 48.6898460388184,-0.327650189399719 48.6898460388184,-0.332827925681954 48.7017402648926,-0.330600231885853 48.7045555114746,-0.337954759597778 48.712371826172,-0.337954759597778 48.712371826172,-0.331748634576741 48.717441558838,-0.290762513875904 48.7302474975587)) | 0.0006 | POINT(-0.3071007650149197 48.702403219122665) |
29062 | POLYGON((3.92839741706854 46.6332054138184,3.91587138175964 46.6431388854981,3.90653991699219 46.6441612243653,3.89056158065796 46.6281471252443,3.89056158065796 46.6281471252443,3.86490726470953 46.6308746337891,3.86490726470953 46.6308746337891,3.85518956184387 46.6405029296875,3.85518956184387 46.6405029296875,3.86162543296825 46.6489715576172,3.86522984504711 46.6675834655762,3.86522984504711 46.6675834655762,3.91145157814037 46.7016067504883,3.91145157814037 46.7016067504883,3.92930984497082 46.6980857849122,3.94136214256292 46.7070388793945,3.94136214256292 46.7070388793945,3.94168186187744 46.7035980224611,3.95276427268993 46.6966247558594,3.94793462753307 46.6876068115234,3.95437979698187 46.6783332824706,3.98103141784679 46.6696891784669,3.9825549125672 46.6664047241212,3.97520995140081 46.6623725891113,3.96524000167852 46.662925720215,3.9629881381988 46.6598472595215,3.9629881381988 46.6598472595215,3.95087003707891 46.654956817627,3.9441220760346 46.6459274291993,3.94241809844976 46.6358757019044,3.92839741706854 46.6332054138184)) | 0.0006 | POINT(3.922111042340649 46.66343599955245) |
62147 | POLYGON((8.99891948699957 52.45756149292,8.99599742889404 52.4586410522462,8.99749565124517 52.4619712829591,8.99562549591076 52.4675445556641,8.99850654602056 52.4680938720704,8.9952564239502 52.4729652404786,8.9948034286499 52.4771308898926,8.99279403686523 52.4773216247559,8.99567794799805 52.4796066284181,8.99346828460693 52.480926513672,8.98837280273443 52.4817428588867,8.98827838897711 52.4792861938477,8.98255634307867 52.4794960021974,8.97941493988043 52.4813270568848,8.97992134094233 52.4829063415528,8.97788333892828 52.4847946166992,8.9761953353883 52.4850158691406,8.97485446929937 52.483741760254,8.97627639770513 52.4834976196289,8.97559833526623 52.4822311401368,8.9705543518067 52.4832534790038,8.96722984313976 52.4817810058594,8.96493911743164 52.4832916259766,8.96596050262457 52.4870452880861,8.96009445190441 52.4918022155762,8.95726394653332 52.4970016479492,8.95447158813477 52.4967651367189,8.94779491424566 52.4984817504884,8.9430141448974 52.4982299804688,8.9430141448974 52.4982299804688,8.94580459594738 52.4950904846192,8.93844795227056 52.4933395385743,8.93758773803722 52.4911575317383,8.93854522705078 52.4905395507812,8.93340206146246 52.4864196777344,8.93058109283453 52.4849815368653,8.9259824752807 52.4872055053712,8.9226598739624 52.4832496643067,8.93519592285168 52.4805870056153,8.93323898315424 52.4790191650392,8.93356609344494 52.4763679504395,8.93089962005615 52.4763603210449,8.93105030059814 52.4747352600099,8.92859077453625 52.4728469848633,8.9290857315064 52.4720840454102,8.91783714294428 52.4674530029297,8.90715026855474 52.4614219665527,8.89162635803217 52.4597358703613,8.89162635803217 52.4597358703613,8.89190578460705 52.4565734863281,8.89330768585211 52.4565925598146,8.8944025039674 52.4546852111818,8.89486312866222 52.4508590698242,8.89926528930675 52.451286315918,8.90735530853283 52.4498367309571,8.90658760070806 52.4482460021974,8.92032527923595 52.445240020752,8.91902828216553 52.4364547729493,8.92260169982916 52.4358444213868,8.9233074188233 52.4343719482423,8.92564296722423 52.4337959289551,8.92557239532476 52.4284019470216,8.92147827148449 52.4292335510254,8.92134380340588 52.4304924011232,8.91748523712158 52.4301834106446,8.91638088226318 52.4289360046388,8.91502952575684 52.4296913146973,8.9083633422851 52.4292869567872,8.90703678131098 52.4280433654785,8.90721035003662 52.4169731140136,8.90798091888428 52.4079780578614,8.92028999328613 52.4085426330568,8.9229555130006 52.4044647216798,8.92068099975586 52.4040603637696,8.92151165008551 52.4030952453613,8.92151165008551 52.4030952453613,8.92391014099132 52.4018135070801,8.93374824523937 52.4014129638673,8.93757724761963 52.4020996093751,8.93520927429194 52.4046440124512,8.94413948059082 52.4083938598633,8.94606494903564 52.4135284423829,8.94447040557873 52.4132614135742,8.94377994537359 52.4153785705567,8.94225406646734 52.4152488708497,8.94112873077393 52.4163246154786,8.94656848907482 52.4172554016114,8.94704914093018 52.416130065918,8.95262145996094 52.4152641296386,8.95796203613281 52.4161605834961,8.95742893218994 52.4193115234376,8.96127319335943 52.4196128845216,8.96154308319097 52.4216156005861,8.96294593811029 52.4223327636719,8.9621925354005 52.4249954223633,8.96918773651129 52.4274253845216,8.97025108337414 52.4264373779297,8.9763555526734 52.4282264709472,8.97798633575445 52.4269943237304,8.98705577850342 52.432518005371,8.98339176177979 52.4333953857422,8.98262596130377 52.4368782043457,8.97917556762707 52.4362602233887,8.98009109497076 52.4382133483887,8.98329162597668 52.4393959045411,8.98672676086431 52.4455146789551,8.98513317108154 52.4456672668458,8.98520088195806 52.4469566345215,8.97841835021973 52.4507217407227,8.98725509643555 52.452033996582,8.9921178817749 52.4506072998048,8.99102115631104 52.4526519775391,8.99720954895025 52.455436706543,8.99891948699957 52.45756149292)) | 0.0006 | POINT(8.949406184981395 52.45097698785565) |
35839 | POLYGON((6.7687168121339 47.2824592590332,6.76169967651379 47.2832565307617,6.76078081130993 47.2809143066407,6.76078081130993 47.2809143066407,6.76175165176403 47.2775688171388,6.75517988204967 47.2724075317383,6.73488950729381 47.2632141113282,6.73488950729381 47.2632141113282,6.73336744308472 47.2599830627442,6.73336744308472 47.2599830627442,6.73473310470587 47.2516365051271,6.73877525329596 47.2509498596191,6.73877525329596 47.2509498596191,6.75182771682745 47.2551307678223,6.75182771682745 47.2551307678223,6.77238750457758 47.2724990844727,6.77238750457758 47.2724990844727,6.77823686599737 47.2799797058105,6.77823686599737 47.2799797058105,6.7687168121339 47.2824592590332)) | 0.0006 | POINT(6.753821649049519 47.26803528635129) |