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 |
---|---|---|---|
14219 | POLYGON((10.4536428451539 44.6369132995605,10.448595046997 44.6389389038086,10.4467725753784 44.6495170593262,10.4443149566651 44.6531143188477,10.4371948242188 44.6589660644531,10.4407873153687 44.6671714782716,10.4416980743409 44.674903869629,10.4416980743409 44.674903869629,10.4422998428345 44.6778221130372,10.4486656188965 44.6811523437501,10.464319229126 44.6865768432618,10.4864959716796 44.7069396972657,10.493094444275 44.7087554931641,10.4982414245605 44.7139511108399,10.5031147003175 44.7232551574708,10.5031147003175 44.7232551574708,10.5082902908326 44.7262573242187,10.5082902908326 44.7262573242187,10.4973592758179 44.7047538757325,10.5026531219482 44.7005615234375,10.5093698501588 44.698184967041,10.5125637054444 44.6944007873536,10.5126905441284 44.6867713928223,10.506420135498 44.6814689636231,10.5087490081788 44.6785202026368,10.5139875411988 44.6750221252443,10.5139875411988 44.6750221252443,10.5122842788696 44.6715774536133,10.5147428512574 44.6622657775878,10.5102500915527 44.6562881469727,10.5102500915527 44.6562881469727,10.5078306198121 44.6548995971681,10.4853916168212 44.6537628173829,10.4732580184938 44.6541633605958,10.4614582061768 44.6467285156249,10.4541893005371 44.6393127441406,10.4536428451539 44.6369132995605)) | 0.0006 | POINT(10.483835167355041 44.678295665317165) |
44700 | POLYGON((0.657879590988216 42.8642616271973,0.65820366144186 42.8665351867676,0.65820366144186 42.8665351867676,0.650181591510886 42.87255859375,0.650181591510886 42.87255859375,0.630133628845272 42.8716773986816,0.630133628845272 42.8716773986816,0.615304410457611 42.8723907470704,0.615304410457611 42.8723907470704,0.613278567790985 42.8701972961426,0.613278567790985 42.8701972961426,0.615144610404968 42.8649673461915,0.615144610404968 42.8649673461915,0.624213993549347 42.8627014160157,0.657879590988216 42.8642616271973)) | 0.0006 | POINT(0.6318990375314806 42.86882972717289) |
52695 | POLYGON((-0.109593175351563 46.3065757751466,-0.10018240660429 46.3061828613281,-0.0919135734438896 46.3142547607422,-0.0824096873402596 46.314998626709,-0.0794219449161346 46.3206062316895,-0.0651325806974796 46.319766998291,-0.0651325806974796 46.319766998291,-0.0650706812739372 46.3263168334962,-0.0506835132837296 46.3286399841309,-0.0384533517062096 46.3393669128419,-0.0291546043007429 46.3413200378418,-0.0220062565057901 46.3501663208009,-0.0123269474133281 46.3492698669435,-0.0101270424201516 46.3523292541505,-0.0101270424201516 46.3523292541505,-0.0130457542836098 46.3623085021973,-0.0206343419849873 46.3667869567872,-0.0206343419849873 46.3667869567872,-0.0471928082405952 46.3514366149902,-0.0751951411365326 46.3578453063966,-0.0876518562434967 46.3636207580566,-0.0876518562434967 46.3636207580566,-0.103321686387062 46.3502807617188,-0.108235225081387 46.3369102478028,-0.11528413742775 46.3322906494141,-0.114852979779243 46.3254089355469,-0.114852979779243 46.3254089355469,-0.116720475256443 46.3113899230957,-0.109593175351563 46.3065757751466)) | 0.0006 | POINT(-0.06632174900728466 46.337713786533946) |
38582 | POLYGON((0.864125609397945 49.4240455627442,0.878054797649497 49.4275474548341,0.907411634922084 49.4242706298828,0.907411634922084 49.4242706298828,0.910403788089809 49.4340972900391,0.907524228096122 49.4472808837892,0.91050302982336 49.4499969482421,0.935240149497986 49.4542045593262,0.935240149497986 49.4542045593262,0.934740543365535 49.4566879272461,0.934740543365535 49.4566879272461,0.924999296665248 49.4793586730958,0.924999296665248 49.4793586730958,0.911768674850578 49.4745445251465,0.906974673271179 49.464527130127,0.898314595222587 49.4610786437989,0.864994287490958 49.4715805053711,0.864994287490958 49.4715805053711,0.857877612113953 49.4612503051757,0.857877612113953 49.4612503051757,0.864125609397945 49.4240455627442)) | 0.0006 | POINT(0.9019098222256303 49.45389118194582) |
25510 | POLYGON((3.39198637008673 48.8373756408692,3.37854385375977 48.8398628234864,3.35493540763855 48.8382835388184,3.35493540763855 48.8382835388184,3.34746909141552 48.8341865539552,3.34772849082947 48.8240585327148,3.34394025802607 48.8217124938965,3.32858610153193 48.8231582641602,3.32858610153193 48.8231582641602,3.32366275787348 48.8177223205567,3.3300096988678 48.8135223388671,3.32838416099548 48.8105392456055,3.32838416099548 48.8105392456055,3.34272933006287 48.8094558715821,3.35938763618475 48.7983551025391,3.35938763618475 48.7983551025391,3.368896484375 48.7973556518555,3.38902378082281 48.811004638672,3.38902378082281 48.811004638672,3.38919973373407 48.8163223266603,3.38919973373407 48.8163223266603,3.39600849151623 48.8288002014161,3.39039587974548 48.8342056274415,3.39198637008673 48.8373756408692)) | 0.0006 | POINT(3.3591480151466784 48.819721056067465) |
1406928 | POLYGON((-6.80607318878174 38.6579246520997,-6.79749393463135 38.663200378418,-6.78458309173584 38.6660766601563,-6.76225900650024 38.6783294677735,-6.74931097030634 38.6827735900879,-6.75006580352772 38.7077522277832,-6.73500680923456 38.7073440551758,-6.73653411865234 38.6971626281739,-6.73424577713013 38.6912002563478,-6.72602510452271 38.68803024292,-6.72177886962885 38.6786193847657,-6.72563791275024 38.653778076172,-6.73387908935547 38.6385917663575,-6.73307704925537 38.6287002563477,-6.7298789024353 38.628833770752,-6.73455190658569 38.6212654113771,-6.7425742149353 38.6130447387695,-6.75254821777344 38.6121215820313,-6.75309514999384 38.6029968261719,-6.75470399856562 38.6012802124024,-6.76249599456781 38.6003532409668,-6.76271009445185 38.6018524169922,-6.76652097702021 38.6016273498536,-6.76677608489985 38.5992698669434,-6.77264976501465 38.5998382568361,-6.79862499237055 38.590274810791,-6.80219602584827 38.5940055847169,-6.80910921096802 38.6138153076172,-6.80646991729736 38.6170883178711,-6.80695676803583 38.6280364990236,-6.80939817428589 38.6359634399414,-6.80695104598999 38.6391754150391,-6.80607318878174 38.6579246520997)) | 0.0006 | POINT(-6.7635681927203875 38.63876020908361) |
20123 | POLYGON((12.1863260269166 45.5858039855956,12.1850166320801 45.5819740295411,12.1773490905762 45.5775985717774,12.1673135757446 45.5746536254882,12.1623840332032 45.5751876831056,12.1625900268555 45.5802230834961,12.1549253463745 45.5866355895996,12.14723777771 45.5908355712892,12.1459312438966 45.5961112976074,12.130485534668 45.5971183776855,12.1256446838379 45.5986137390137,12.1240653991699 45.6008682250977,12.1245126724244 45.6063842773438,12.1225013732911 45.6105613708497,12.1140356063843 45.6149520874023,12.1094074249268 45.6151924133301,12.1091670989991 45.6080818176271,12.0934448242187 45.5992355346681,12.0934448242187 45.5992355346681,12.0883283615113 45.6006088256836,12.0874128341674 45.606357574463,12.0900783538819 45.6099548339844,12.0892829895021 45.6168212890625,12.0887842178345 45.6180114746094,12.0840454101564 45.6193008422852,12.0840454101564 45.6193008422852,12.0878152847291 45.6243591308594,12.0878152847291 45.6243591308594,12.0958375930786 45.6282463073731,12.1130380630494 45.6272621154785,12.1208896636963 45.6321334838868,12.1208896636963 45.6321334838868,12.1307926177979 45.6321144104005,12.1438646316529 45.6284179687501,12.1446437835694 45.6217002868652,12.1528081893921 45.6188354492188,12.161681175232 45.6176567077636,12.1654386520386 45.6185913085938,12.1652717590332 45.6233787536621,12.1725673675537 45.6232681274415,12.1749897003174 45.6193733215331,12.1749334335328 45.6170082092286,12.1822938919067 45.6151847839355,12.1822938919067 45.6151847839355,12.1918869018555 45.6149406433107,12.1918869018555 45.6149406433107,12.1922883987427 45.599422454834,12.1922883987427 45.599422454834,12.1864957809449 45.6053619384765,12.1836347579957 45.6055679321289,12.1823492050171 45.5891876220703,12.1849813461304 45.5858535766603,12.1863260269166 45.5858039855956)) | 0.0006 | POINT(12.140989175209667 45.608144760131864) |
19057 | POLYGON((10.934865951538 43.6584777832032,10.9286699295045 43.6527481079103,10.9120330810546 43.6407470703126,10.9031467437744 43.6373214721681,10.896863937378 43.6385688781739,10.887791633606 43.6374397277833,10.8772048950196 43.6250915527345,10.8755626678467 43.6221313476562,10.8759317398072 43.6207237243652,10.8759317398072 43.6207237243652,10.8957128524781 43.6193046569825,10.9175519943238 43.6154708862305,10.921820640564 43.6121788024903,10.9278268814088 43.6042861938477,10.9292421340943 43.5977897644043,10.9393682479859 43.5755500793458,10.9467840194702 43.5747222900391,10.9467840194702 43.5747222900391,10.9500427246094 43.5771064758301,10.9563169479371 43.5777015686036,10.9623308181763 43.5798416137696,10.9656505584717 43.5832862854003,10.9658355712891 43.5855522155763,10.9680318832399 43.5890884399415,10.9784450531006 43.5931015014648,10.9942646026612 43.583034515381,11.0005941390992 43.5774230957032,11.0005979537963 43.5759391784669,11.0005979537963 43.5759391784669,11.0046415328979 43.575496673584,11.0221872329712 43.583911895752,11.0286884307862 43.5912437438966,11.0254993438721 43.5995712280275,11.0254993438721 43.5995712280275,11.0206518173218 43.6009826660156,11.0151672363282 43.6070213317872,11.0092344284058 43.6163635253907,11.0089797973633 43.6247406005861,11.0130424499512 43.6298484802246,11.0106019973755 43.6369590759278,11.0071821212769 43.638484954834,10.9979801177979 43.6383781433107,10.9952831268312 43.6396751403809,10.9862070083619 43.6494331359864,10.9723978042603 43.6579627990723,10.9716596603394 43.6610717773438,10.9716596603394 43.6610717773438,10.9557886123657 43.6722412109376,10.9523754119874 43.6687164306641,10.9435853958131 43.6557655334472,10.9474811553956 43.6523666381837,10.944543838501 43.651653289795,10.9378166198732 43.6541595458984,10.934865951538 43.6584777832032)) | 0.0006 | POINT(10.960451989803712 43.61684345749194) |
19933 | POLYGON((11.9760560989379 45.4023628234863,11.9769906997681 45.4043464660645,11.9769906997681 45.4043464660645,11.9708766937256 45.4070892333985,11.9412488937379 45.4055366516114,11.9363059997559 45.4077835083008,11.9373846054077 45.4166564941407,11.9388790130616 45.4203758239747,11.9463434219361 45.4240455627443,11.9551372528076 45.4238014221192,11.9551372528076 45.4238014221192,11.9540576934814 45.4271202087402,11.9431762695312 45.4351615905762,11.9384584426881 45.4376068115235,11.9338016510011 45.4380607604981,11.9338016510011 45.4380607604981,11.9267120361329 45.4376831054689,11.9143362045288 45.4411964416505,11.8999128341674 45.4471321105958,11.8967056274415 45.4494285583496,11.8967542648316 45.4521293640137,11.8967542648316 45.4521293640137,11.8905181884766 45.4484596252443,11.8867969512939 45.4497261047364,11.8830909729004 45.4535369873046,11.8798017501832 45.4549865722657,11.8715114593507 45.455421447754,11.86283493042 45.4540748596191,11.8608551025391 45.4548606872559,11.8603086471558 45.4564590454102,11.8603086471558 45.4564590454102,11.8569288253785 45.4584159851074,11.8534317016602 45.4557762145996,11.8522930145263 45.4532203674318,11.8470430374146 45.4497871398927,11.8422403335572 45.4511680603027,11.8388051986694 45.4561042785644,11.8334598541261 45.4561309814454,11.8310909271241 45.4494361877441,11.8310909271241 45.4494361877441,11.8302078247071 45.4473800659181,11.8302078247071 45.4473800659181,11.8291664123535 45.4324264526367,11.8266134262085 45.4164199829102,11.8266134262085 45.4164199829102,11.8250570297241 45.4044380187988,11.8063182830812 45.3783912658692,11.8063182830812 45.3783912658692,11.8107805252076 45.3762664794923,11.8099517822267 45.3729476928712,11.8107786178589 45.3718452453613,11.837387084961 45.3579635620118,11.837387084961 45.3579635620118,11.8503904342651 45.3771171569825,11.8559923171998 45.3815956115723,11.8622436523439 45.3847541809083,11.8648567199707 45.3801078796387,11.8631772994996 45.3744049072266,11.8609199523926 45.371940612793,11.8627891540527 45.3644409179689,11.8711833953857 45.3579711914062,11.8875360488892 45.3519287109375,11.9006490707397 45.3442306518556,11.9208889007569 45.3409233093262,11.9208889007569 45.3409233093262,11.9209051132203 45.3471984863282,11.905475616455 45.3603286743164,11.8998546600342 45.3626708984376,11.9035234451295 45.3679656982422,11.9142799377441 45.3670806884767,11.9149618148804 45.3681716918946,11.914873123169 45.3736343383789,11.9074611663818 45.3780212402344,11.9096956253051 45.3817520141602,11.9122285842896 45.3843154907227,11.9183216094971 45.3840713500978,11.9230241775514 45.3821220397949,11.932625770569 45.3746566772462,11.9496755599976 45.3702507019044,11.9496755599976 45.3702507019044,11.9595975875856 45.3729438781738,11.9595975875856 45.3729438781738,11.960657119751 45.3765907287598,11.9561939239502 45.3776931762696,11.9610033035278 45.3937187194825,11.9634714126587 45.3987846374512,11.9760560989379 45.4023628234863)) | 0.0006 | POINT(11.8934143975724 45.40643084326459) |
1400684 | POLYGON((-6.58124113082886 41.2394180297853,-6.57112407684326 41.2390251159668,-6.57472705841064 41.2326736450196,-6.57365608215326 41.2305297851563,-6.57539892196655 41.2296905517579,-6.57371711730957 41.219638824463,-6.57002115249628 41.2181243896484,-6.57199907302851 41.2161178588868,-6.56959915161127 41.2134284973145,-6.57121515274048 41.2098274230957,-6.56707811355591 41.2065505981446,-6.56796884536743 41.2025527954102,-6.56456899642939 41.2007331848145,-6.56548500061035 41.1959037780762,-6.56330919265741 41.1902542114258,-6.56583595275873 41.1876525878907,-6.56925678253174 41.1874046325685,-6.57065677642817 41.1822357177734,-6.57677793502808 41.1764640808105,-6.57898902893061 41.1761322021484,-6.58449792861938 41.1659011840821,-6.61780309677113 41.1810035705566,-6.61578321456909 41.1875991821289,-6.61651992797846 41.1920852661134,-6.61376190185536 41.1961631774903,-6.60865020751953 41.1987838745118,-6.58809709548945 41.2247848510742,-6.58124113082886 41.2394180297853)) | 0.0006 | POINT(-6.58028662646255 41.20372885244869) |