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 |
---|---|---|---|
71431 | POLYGON((14.8440208435059 48.0149421691895,14.817964553833 47.9981231689453,14.8116083145143 47.9951553344727,14.8046913146973 47.9933128356934,14.7662982940674 47.9875907897949,14.752498626709 47.9846343994141,14.7467174530029 47.9877624511719,14.7388753890992 47.9951248168945,14.7388753890992 47.9951248168945,14.7350873947144 48.0046157836913,14.7351846694946 48.0078773498536,14.7555284500123 48.0248374938965,14.7555284500123 48.0248374938965,14.7660341262818 48.0264701843262,14.7660341262818 48.0264701843262,14.7837114334106 48.0096626281738,14.7907400131227 48.0061874389648,14.8004693984986 48.006950378418,14.8440208435059 48.0149421691895)) | 0.0006 | POINT(14.772770457797627 48.00498220655654) |
20746 | POLYGON((7.67323589324945 48.7335395812988,7.67186927795404 48.7340965270996,7.67186927795404 48.7340965270996,7.68654775619513 48.7364692687989,7.68713235855097 48.742977142334,7.68713235855097 48.742977142334,7.69461679458618 48.7513580322266,7.70372200012201 48.753963470459,7.70372200012201 48.753963470459,7.71402692794811 48.7493324279785,7.72089815139771 48.7519340515137,7.72089815139771 48.7519340515137,7.7367143630982 48.7460441589357,7.74766016006481 48.7517929077149,7.74766016006481 48.7517929077149,7.75844430923473 48.7437934875489,7.75844430923473 48.7437934875489,7.74153518676752 48.7262382507325,7.74423980712896 48.7161369323732,7.75422191619879 48.7137565612794,7.75538015365606 48.7103309631348,7.74717617034912 48.6864471435548,7.74717617034912 48.6864471435548,7.71929168701183 48.686149597168,7.71929168701183 48.686149597168,7.70870590209972 48.7003555297853,7.69533634185791 48.695484161377,7.6905283927918 48.6966552734375,7.6905283927918 48.6966552734375,7.67680788040161 48.7095680236817,7.67680788040161 48.7095680236817,7.67731475830089 48.7200889587403,7.67731475830089 48.7200889587403,7.68508863449097 48.7243156433107,7.68193769454962 48.7304840087891,7.67323589324945 48.7335395812988)) | 0.0006 | POINT(7.710665076119592 48.725393676757854) |
73259 | POLYGON((13.9832754135132 45.7694358825685,13.9680156707764 45.7836418151855,13.9526796340942 45.7836227416993,13.9476041793824 45.7907295227051,13.9322681427003 45.790714263916,13.9322881698608 45.7942695617677,13.91695022583 45.7942543029786,13.9169883728027 45.8013648986816,13.9067821502686 45.8049087524414,13.9068031311036 45.8084640502931,13.8914852142334 45.8120040893555,13.8914852142334 45.8120040893555,13.8915214538575 45.8191146850587,13.8812971115112 45.8191032409668,13.881356239319 45.8297691345215,13.881356239319 45.8297691345215,13.8814315795898 45.843994140625,13.8916559219361 45.8440017700195,13.896806716919 45.8511199951172,13.9121627807617 45.8546905517578,13.9122180938721 45.8653564453125,13.937801361084 45.868938446045,13.9378204345704 45.8724975585938,13.9480438232422 45.8725051879883,13.9480829238892 45.8796157836915,13.9531946182251 45.8796234130861,13.9583253860475 45.8831825256348,13.9940919876099 45.8796653747559,13.9940729141236 45.8761100769042,14.0093708038331 45.8690147399903,14.0093336105347 45.8619041442872,14.0042200088502 45.8619003295898,14.0041446685791 45.8476791381837,14.0092573165893 45.8476829528808,14.0092363357545 45.8441276550293,14.0398931503296 45.840602874756,14.0398931503296 45.840602874756,14.0398540496826 45.8334922790528,14.044927597046 45.826385498047,14.0500402450562 45.8263931274415,14.0500011444092 45.8192825317383,14.0551128387451 45.8192863464355,14.0550384521485 45.8050651550294,14.0499258041383 45.805061340332,14.0499076843261 45.8015060424805,14.03968334198 45.8014945983888,14.0395278930664 45.7730484008789,14.0293035507203 45.7730369567872,14.0292654037476 45.765926361084,14.0292654037476 45.765926361084,14.0190439224244 45.7659187316895,14.0139684677124 45.7730216979981,13.99351978302 45.7730026245118,13.9934988021852 45.7694473266602,13.9832754135132 45.7694358825685)) | 0.0006 | POINT(13.973242565437635 45.82269039860481) |
18177 | POLYGON((8.31826591491705 45.4038162231445,8.30922222137457 45.4044265747071,8.30754947662365 45.413356781006,8.30754947662365 45.413356781006,8.26449871063227 45.4238777160644,8.26449871063227 45.4238777160644,8.26320457458507 45.4120750427246,8.26382732391363 45.4051742553712,8.26791572570795 45.4025039672852,8.27353954315186 45.3871078491212,8.27286052703869 45.3827476501465,8.27286052703869 45.3827476501465,8.27587413787847 45.3799018859864,8.29532241821295 45.379192352295,8.29532241821295 45.379192352295,8.31610012054438 45.3784751892089,8.31610012054438 45.3784751892089,8.31898307800293 45.3850135803223,8.32363414764399 45.3905944824218,8.32088756561285 45.3988189697266,8.31801223754888 45.3985252380371,8.31644439697271 45.399642944336,8.31826591491705 45.4038162231445)) | 0.0006 | POINT(8.29465788060972 45.39649547230116) |
42847 | POLYGON((6.63395023345953 48.2397727966309,6.62482357025158 48.2315597534181,6.61521434783947 48.2314147949219,6.61521434783947 48.2314147949219,6.61495447158813 48.2315559387207,6.61495447158813 48.2315559387207,6.61062335968023 48.2413444519044,6.61179780960083 48.2616310119628,6.61179780960083 48.2616310119628,6.61997461318975 48.2634315490723,6.61997461318975 48.2634315490723,6.63362550735485 48.2581405639648,6.63362550735485 48.2581405639648,6.63833284378057 48.2563819885254,6.63833284378057 48.2563819885254,6.63395023345953 48.2397727966309)) | 0.0006 | POINT(6.622479756673237 48.24785257975261) |
18200 | POLYGON((7.99134492874146 45.8437728881835,8.00124359130859 45.8299789428712,7.99544906616211 45.8215065002443,7.99348497390758 45.8127021789551,7.99436712265026 45.8082656860353,7.99436712265026 45.8082656860353,8.00083065032959 45.8122634887696,8.01099109649664 45.815258026123,8.0203800201416 45.816764831543,8.03100490570068 45.814250946045,8.03501510620123 45.8096466064453,8.04345703125006 45.806739807129,8.04599761962902 45.8062934875488,8.05067253112799 45.8087692260743,8.05635261535656 45.8074569702149,8.05635261535656 45.8074569702149,8.05749416351318 45.8133735656738,8.05667304992681 45.8161697387695,8.05068016052252 45.8255958557129,8.03128337860107 45.8397674560546,8.03128337860107 45.8397674560546,8.00496101379395 45.8476524353028,7.99134492874146 45.8437728881835)) | 0.0006 | POINT(8.025167551907671 45.818714488636395) |
23096 | POLYGON((-1.3549535274505 43.2356452941895,-1.33669793605799 43.2325973510743,-1.33141255378723 43.2165222167969,-1.30198407173157 43.200294494629,-1.30198407173157 43.200294494629,-1.30814385414112 43.1849975585938,-1.30416905879963 43.1620674133301,-1.30416905879963 43.1620674133301,-1.30490612983698 43.1552810668946,-1.31425070762634 43.1477851867677,-1.31457805633545 43.134708404541,-1.32675361633301 43.1300964355469,-1.33232069015503 43.1210174560548,-1.33232069015503 43.1210174560548,-1.33699107170105 43.1217994689942,-1.35856258869165 43.1404151916504,-1.37692070007324 43.1391754150391,-1.39794111251831 43.1475448608398,-1.40750586986542 43.1553497314454,-1.40750586986542 43.1553497314454,-1.4028856754303 43.156078338623,-1.40470194816589 43.163387298584,-1.40199196338654 43.1668090820312,-1.401859998703 43.1784858703614,-1.39156901836395 43.1861190795898,-1.38494801521301 43.188289642334,-1.38370943069452 43.2219696044922,-1.38457202911371 43.2237510681152,-1.38304102420801 43.2262039184571,-1.3787246942519 43.2282142639161,-1.37864172458643 43.2323570251465,-1.37864172458643 43.2323570251465,-1.37858581542969 43.235149383545,-1.3706796169281 43.2324409484864,-1.3549535274505 43.2356452941895)) | 0.0006 | POINT(-1.3581948210211074 43.180459976196325) |
13038 | POLYGON((16.503942489624 38.9774513244629,16.4946212768556 38.9733924865724,16.4933910369874 38.9752998352052,16.4864482879639 38.9759483337402,16.4864482879639 38.9759483337402,16.4867763519287 38.9768981933595,16.4843273162842 38.981803894043,16.4812622070314 38.9859161376953,16.4682598114015 38.9847297668457,16.4658641815186 38.987705230713,16.464807510376 38.9903221130372,16.4650382995605 38.9931373596192,16.4680843353271 38.9946250915527,16.4718761444093 38.9942817687989,16.4735012054444 38.9991607666016,16.4727954864502 39.0002326965333,16.463872909546 39.0009307861329,16.4559745788575 38.9992713928223,16.444995880127 38.999969482422,16.4417915344239 39.0010108947755,16.4417915344239 39.0010108947755,16.4424419403077 39.004940032959,16.4364166259767 39.0103187561036,16.434066772461 39.0093231201173,16.4321174621583 39.0112457275392,16.4331912994385 39.0152511596681,16.4363136291504 39.0187530517578,16.4363136291504 39.0187530517578,16.4295578002931 39.0277252197266,16.4305095672607 39.0306663513184,16.4321727752687 39.0317268371583,16.4321727752687 39.0317268371583,16.4360504150392 39.0304069519044,16.4409370422364 39.0270118713378,16.4451446533204 39.0175895690919,16.4447574615479 39.0160636901856,16.4516696929932 39.0111122131348,16.475528717041 39.0056304931641,16.503942489624 38.9911689758301,16.503942489624 38.9774513244629)) | 0.0006 | POINT(16.458696805513878 39.00201181265028) |
50321 | POLYGON((1.92314255237585 49.5979690551759,1.90394496917736 49.6098937988281,1.90209591388714 49.6232681274415,1.89270985126507 49.6261482238769,1.89270985126507 49.6261482238769,1.89067959785473 49.629825592041,1.89067959785473 49.629825592041,1.89979493618011 49.6331596374513,1.90409791469585 49.6312217712403,1.90409791469585 49.6312217712403,1.91421234607697 49.6240158081055,1.93333053588867 49.6293525695802,1.93333053588867 49.6293525695802,1.94049108028418 49.6249656677247,1.94049108028418 49.6249656677247,1.94484448432922 49.6231613159181,1.94698560237885 49.6098365783692,1.94698560237885 49.6098365783692,1.92863821983349 49.6056137084962,1.92754280567181 49.5997962951661,1.92754280567181 49.5997962951661,1.92314255237585 49.5979690551759)) | 0.0006 | POINT(1.918492771330403 49.61997023082921) |
63356 | POLYGON((12.3767948150635 53.4997520446778,12.3739748001099 53.5014953613282,12.3732414245606 53.5090217590333,12.3667602539062 53.514762878418,12.3656330108644 53.517692565918,12.3662948608399 53.5187072753907,12.3704462051392 53.5191383361817,12.376669883728 53.5257148742675,12.3766784667968 53.5294265747071,12.3751850128175 53.5308341979982,12.3668022155763 53.531681060791,12.368130683899 53.5373573303222,12.3721933364868 53.5402717590332,12.3733940124512 53.5464668273927,12.3685483932495 53.5492706298828,12.3563833236695 53.5521240234376,12.3551826477052 53.5544090270997,12.3574199676514 53.5548400878906,12.3578109741211 53.5558891296387,12.3499593734741 53.558334350586,12.3493061065674 53.5618133544923,12.3530673980712 53.5682830810547,12.3523263931274 53.5721778869629,12.3495864868163 53.5755805969239,12.3459300994872 53.5769805908203,12.33948802948 53.5775108337403,12.3276214599611 53.5732536315918,12.3189544677734 53.5682067871094,12.3076963424682 53.5679931640625,12.3076963424682 53.5679931640625,12.3160781860352 53.5705757141113,12.3160734176637 53.5748252868653,12.3174705505371 53.5757484436035,12.3258161544799 53.5784950256349,12.3394708633424 53.5857162475586,12.3364667892457 53.5907936096191,12.3405017852783 53.5926208496094,12.3460760116578 53.5926094055177,12.348825454712 53.5940361022949,12.3535223007203 53.585792541504,12.3549928665162 53.5852050781251,12.3763971328736 53.5851974487305,12.3720035552979 53.5764198303224,12.3887119293214 53.5751228332519,12.392786026001 53.5718955993652,12.3910427093506 53.5689544677734,12.3986415863038 53.5673027038574,12.3986415863038 53.5673027038574,12.3973007202148 53.5642318725587,12.4287576675416 53.5626640319825,12.4415092468262 53.5597953796387,12.4545879364015 53.5595512390137,12.4545879364015 53.5595512390137,12.4567117691041 53.5580902099609,12.4571590423584 53.5559425354004,12.4545793533326 53.5505714416504,12.4521780014038 53.5495223999023,12.4592342376709 53.548007965088,12.4718141555786 53.5475044250488,12.4722585678101 53.544288635254,12.4830570220948 53.5304679870607,12.4830570220948 53.5304679870607,12.4812879562378 53.5303802490236,12.4809751510621 53.5288047790527,12.4747419357301 53.5274124145508,12.4748840332032 53.5265464782715,12.4725618362427 53.5269050598145,12.4662990570068 53.5295486450196,12.4652299880982 53.5316276550292,12.4608650207521 53.5331954956056,12.459587097168 53.5353202819824,12.4607868194581 53.5365142822266,12.4601402282715 53.5382347106934,12.4585123062135 53.5379447937012,12.4576282501221 53.5397720336914,12.4562559127809 53.5394630432129,12.4545927047729 53.5407295227052,12.4524955749511 53.5400695800782,12.4527511596681 53.5390319824219,12.4417953491212 53.5305061340332,12.4421749114991 53.5274963378907,12.4444942474366 53.5253753662111,12.4429378509522 53.5229339599611,12.4121084213258 53.5240554809571,12.411681175232 53.5197830200196,12.4060163497925 53.5189094543457,12.4054222106934 53.5135612487793,12.4143829345704 53.5122451782228,12.416527748108 53.5088691711426,12.416527748108 53.5088691711426,12.399754524231 53.5056228637695,12.3905315399171 53.5057449340821,12.3794260025024 53.5037918090821,12.3767948150635 53.4997520446778)) | 0.0006 | POINT(12.399923273312186 53.54651096302978) |