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 |
---|---|---|---|
51564 | POLYGON((2.83336758613586 49.7870292663575,2.84121322631836 49.7987556457519,2.82715082168579 49.8116912841797,2.82715082168579 49.8116912841797,2.81158757209789 49.8041114807129,2.81158757209789 49.8041114807129,2.82260060310375 49.7866249084473,2.82260060310375 49.7866249084473,2.83336758613586 49.7870292663575)) | 0.0006 | POINT(2.8246573507786357 49.798830032348654) |
1402650 | POLYGON((-5.30995988845825 41.5740127563477,-5.31835794448853 41.5737800598145,-5.32258605957031 41.5655708312989,-5.33916902542109 41.5501937866211,-5.33876991271973 41.555103302002,-5.34525012969971 41.5562057495118,-5.35858678817749 41.5619201660157,-5.36354398727411 41.5676994323731,-5.35674619674683 41.5891494750977,-5.34395503997803 41.603630065918,-5.33537912368774 41.6054191589355,-5.32782077789301 41.6051025390625,-5.32244920730591 41.5901527404785,-5.32264280319208 41.5858535766602,-5.31130409240723 41.5780906677246,-5.31266307830811 41.5768241882325,-5.30995988845825 41.5740127563477)) | 0.0006 | POINT(-5.33307400345801 41.577419281005895) |
34461 | POLYGON((5.30562400817877 48.5159225463868,5.29572772979748 48.5083274841309,5.29572772979748 48.5083274841309,5.29604148864746 48.4987831115723,5.29604148864746 48.4987831115723,5.30705595016491 48.4918098449708,5.30740356445318 48.4849472045898,5.30740356445318 48.4849472045898,5.31213665008545 48.4860496520997,5.32662439346319 48.476921081543,5.32662439346319 48.476921081543,5.336998462677 48.4755287170411,5.34947013854986 48.4819869995118,5.34947013854986 48.4819869995118,5.32737064361572 48.5093231201172,5.3168621063233 48.5084495544434,5.30562400817877 48.5159225463868)) | 0.0006 | POINT(5.316036403179218 48.49306344985966) |
73442 | POLYGON((15.9118862152101 45.5772056579591,15.9102220535278 45.5726051330568,15.9053411483765 45.5650939941407,15.8950214385986 45.5558357238771,15.8918838500978 45.5464744567872,15.8868694305421 45.5375366210938,15.8868694305421 45.5375366210938,15.8777542114259 45.5370216369629,15.8641738891602 45.5338821411133,15.8587770462037 45.5344848632813,15.8549451828004 45.5361557006836,15.8529949188232 45.5386619567872,15.8529243469238 45.5409927368165,15.8551549911499 45.5473480224611,15.8538246154786 45.5517044067384,15.8448066711426 45.5546493530273,15.8338813781738 45.5546722412109,15.822551727295 45.5520210266114,15.8117475509644 45.5468330383301,15.8084020614624 45.543514251709,15.8054819107056 45.5350761413574,15.801869392395 45.5320320129395,15.7909717559815 45.5303535461426,15.7820434570314 45.5270614624024,15.7731075286865 45.5264167785645,15.7731075286865 45.5264167785645,15.773708343506 45.5396194458008,15.7721481323242 45.5420379638671,15.7688131332398 45.5431518554689,15.7641105651856 45.5426445007325,15.7600460052491 45.5450172424316,15.7518949508668 45.5515441894532,15.7446279525758 45.5594253540039,15.7313241958619 45.5646972656251,15.7199878692627 45.5725097656251,15.7199878692627 45.5725097656251,15.7273588180543 45.5739517211914,15.7325401306153 45.5763015747071,15.7363929748535 45.579933166504,15.7399053573608 45.585304260254,15.7385749816895 45.591968536377,15.738265991211 45.6076507568359,15.7397365570068 45.6087455749512,15.7397365570068 45.6087455749512,15.7457323074342 45.6073417663575,15.7528667449951 45.6087837219239,15.7694454193115 45.6202850341797,15.7761859893798 45.6233139038086,15.7904577255249 45.6400375366212,15.7972106933594 45.6448402404786,15.804835319519 45.6478729248048,15.8092927932739 45.6508598327637,15.8146286010743 45.6574058532715,15.8151330947876 45.662940979004,15.814359664917 45.6670684814454,15.8085002899171 45.679141998291,15.8085002899171 45.679141998291,15.8365259170533 45.6689605712891,15.8586530685425 45.6629180908204,15.8795623779297 45.6448631286622,15.8866271972656 45.6420555114747,15.8890218734742 45.6401863098145,15.8895559310914 45.6370162963867,15.8860168457031 45.6316642761231,15.8873739242554 45.6279182434083,15.8941001892091 45.6242561340333,15.904396057129 45.6226196289063,15.904396057129 45.6226196289063,15.9053287506103 45.6186523437501,15.9069652557373 45.6168479919435,15.9180030822754 45.6145324707031,15.9204540252687 45.6124420166016,15.9212360382081 45.6098937988282,15.9208698272706 45.5891990661622,15.9197063446046 45.5866088867189,15.9118862152101 45.5772056579591)) | 0.0006 | POINT(15.824556210835821 45.58759511311851) |
21253 | POLYGON((7.02586889266968 47.7788314819336,7.03601646423351 47.7689552307128,7.03601646423351 47.7689552307128,7.02983903884893 47.7498855590821,7.02983903884893 47.7498855590821,7.02285337448126 47.7470970153809,7.02285337448126 47.7470970153809,7.00372648239136 47.7573242187501,7.00388956069958 47.7607345581055,7.02586889266968 47.7788314819336)) | 0.0006 | POINT(7.0234336323208915 47.758751763237875) |
31361 | POLYGON((2.70606255531322 47.3101043701173,2.66835069656383 47.3189392089844,2.65157437324518 47.3316574096681,2.64685249328619 47.3328666687012,2.64322662353521 47.3304901123047,2.64322662353521 47.3304901123047,2.62934064865118 47.3279609680177,2.61345386505138 47.3111267089844,2.60554075241089 47.3071861267089,2.6009783744812 47.297752380371,2.6009783744812 47.297752380371,2.60955905914301 47.2951698303222,2.60955905914301 47.2951698303222,2.61997151374823 47.2954216003418,2.65860748291016 47.2855682373047,2.67923140525824 47.2837257385253,2.69293975830078 47.2879486083985,2.69927740097046 47.2974014282227,2.7132728099823 47.3008651733398,2.7132728099823 47.3008651733398,2.70606255531322 47.3101043701173)) | 0.0006 | POINT(2.6502638339996585 47.306923103332515) |
68513 | POLYGON((11.3299055099488 52.771827697754,11.3291101455689 52.7689399719238,11.3255834579468 52.7682418823242,11.3164176940919 52.7680168151856,11.2981805801392 52.7719955444337,11.2979478836061 52.7697601318359,11.2844133377076 52.7706832885743,11.2832908630371 52.7692527770997,11.2821712493898 52.7637481689454,11.2782888412476 52.7603836059571,11.2628593444825 52.7656059265138,11.2515048980713 52.7674407958986,11.2450256347657 52.7673988342285,11.2450256347657 52.7673988342285,11.244408607483 52.7712860107422,11.2332706451415 52.7737464904786,11.2327442169189 52.7760086059571,11.225254058838 52.7785606384278,11.2063608169555 52.7709388732911,11.2049617767334 52.772632598877,11.2058649063111 52.7731437683105,11.1970977783204 52.7754211425782,11.1953783035278 52.7738609313965,11.1909008026123 52.7749671936036,11.1896448135377 52.7781105041504,11.1838541030883 52.7824783325196,11.1840572357178 52.7869911193849,11.1822776794434 52.7899246215821,11.1695222854615 52.7879791259766,11.1702508926393 52.7861328125001,11.1622009277344 52.7853240966798,11.1609754562379 52.78670501709,11.1592979431153 52.7865333557129,11.1592979431153 52.7865333557129,11.1573219299317 52.7873191833497,11.1550397872926 52.786476135254,11.1549606323243 52.7850914001464,11.1493587493897 52.784366607666,11.145959854126 52.7851867675781,11.145399093628 52.7874183654785,11.1430549621583 52.7863349914551,11.1297855377198 52.7960319519043,11.127387046814 52.7995338439943,11.1181049346924 52.7998504638673,11.1213684082032 52.8051681518556,11.118860244751 52.8094253540039,11.114691734314 52.8083763122559,11.1005811691284 52.8084640502929,11.0983657836913 52.8036727905275,11.100157737732 52.800148010254,11.0892724990845 52.7970085144044,11.082449913025 52.7971611022949,11.0819282531738 52.7946891784668,11.0723476409913 52.7959671020508,11.0685281753541 52.7872352600098,11.0685281753541 52.7872352600098,11.0633583068849 52.7865867614747,11.056555747986 52.7868957519532,11.0568189620973 52.7878036499025,11.0518741607665 52.7873687744141,11.0518350601197 52.7901649475098,11.055513381958 52.7901306152345,11.0543699264528 52.7936401367188,11.0531349182129 52.7933044433594,11.0518732070923 52.7944602966309,11.0538673400879 52.7985343933106,11.0386552810669 52.797981262207,11.0267734527588 52.8018188476562,11.0239992141724 52.8055458068848,11.026083946228 52.8099784851075,11.0234308242797 52.8127517700196,11.0238161087037 52.8152198791505,11.0229454040527 52.8156394958496,11.0201177597047 52.8124694824218,11.0120801925659 52.8103523254395,10.992169380188 52.8105239868165,10.9919748306274 52.8089981079103,10.9885368347169 52.8086585998536,10.9887247085571 52.8075714111328,10.9847478866578 52.8048820495607,10.9793376922607 52.8053359985352,10.9794616699219 52.8071937561036,10.9810228347778 52.8088531494141,10.9807071685792 52.809913635254,10.9615278244019 52.8091163635255,10.9637413024903 52.8121490478516,10.9625902175904 52.8142471313477,10.9606466293334 52.8142166137695,10.9605417251587 52.8155746459961,10.9549837112427 52.8148422241212,10.9447431564331 52.8176574707031,10.9447431564331 52.8176574707031,10.9443550109863 52.8219680786134,10.9412841796876 52.8280830383301,10.941583633423 52.8313179016113,10.9399318695069 52.8323860168458,10.9204282760621 52.8311958312989,10.9120740890504 52.831657409668,10.9121904373169 52.8330307006837,10.9056987762451 52.8422775268555,10.9065008163452 52.8553123474121,10.9065008163452 52.8553123474121,10.9147109985352 52.853385925293,10.9256944656372 52.8541297912599,10.9296989440918 52.8535232543945,10.9296989440918 52.8535232543945,10.9326896667482 52.8540725708008,10.9396333694458 52.8533363342286,10.9417705535889 52.8546752929688,10.9578132629395 52.8677711486817,10.957715034485 52.8698043823243,10.9643115997316 52.87260055542,10.9643154144288 52.8743896484376,10.9678955078126 52.875717163086,10.9680824279786 52.8793220520019,10.9740924835205 52.8774299621582,10.9762363433838 52.878631591797,10.978814125061 52.8781509399415,10.985507965088 52.8820343017579,10.9900970458984 52.8881874084473,10.9887847900391 52.8922157287598,10.9890537261963 52.8990516662598,10.9935617446899 52.9035263061524,10.9925727844239 52.9064559936525,10.9925727844239 52.9064559936525,10.9947919845582 52.907096862793,10.998049736023 52.9103660583497,11.000491142273 52.911262512207,11.0062828063965 52.9116439819335,11.0130767822267 52.9098892211915,11.0130767822267 52.9098892211915,11.0282545089721 52.9119415283204,11.0354747772217 52.911590576172,11.0390491485597 52.9133987426758,11.0650491714478 52.9094047546388,11.0787477493287 52.9129638671876,11.0911808013915 52.9129600524903,11.0911808013915 52.9129600524903,11.0986757278442 52.9128761291505,11.0960083007813 52.9091873168945,11.0931873321534 52.899471282959,11.1070880889893 52.8961296081543,11.1131486892701 52.8957214355469,11.1389064788819 52.8983421325685,11.1546669006348 52.9018669128418,11.1558666229249 52.905128479004,11.1552581787109 52.9062118530274,11.1562814712525 52.9060516357422,11.1562814712525 52.9060516357422,11.1810159683228 52.9015007019043,11.2206449508668 52.8976669311525,11.219168663025 52.8926811218262,11.224528312683 52.8913345336915,11.2306270599366 52.8913497924805,11.2306270599366 52.8913497924805,11.2357635498047 52.8886146545411,11.2379589080811 52.8844032287598,11.2379436492919 52.8806076049805,11.2411260604859 52.8790168762208,11.2672386169435 52.8801422119142,11.2708015441895 52.8814888000489,11.2709283828736 52.883373260498,11.2765693664552 52.8875312805176,11.2832746505737 52.8877449035645,11.2862186431885 52.8887557983398,11.2886123657227 52.887996673584,11.2906618118287 52.8891258239747,11.2920236587524 52.8887443542481,11.2911586761474 52.8878669738771,11.294213294983 52.8871345520019,11.2948770523071 52.8820190429688,11.2941493988038 52.8809089660645,11.294638633728 52.8792495727539,11.2935495376587 52.8790016174316,11.2954111099244 52.8749084472657,11.3142499923707 52.8782348632814,11.3142499923707 52.8782348632814,11.3163833618163 52.8738479614259,11.3152923583984 52.8734970092773,11.3164682388306 52.8662948608398,11.3162221908569 52.8577461242677,11.3142471313478 52.852912902832,11.3149681091309 52.8412094116212,11.3406744003296 52.8358192443849,11.3415937423707 52.8327331542969,11.3429174423218 52.8329315185547,11.3444585800171 52.8302383422852,11.3447742462159 52.8281021118163,11.3415899276733 52.8268852233887,11.3397789001465 52.8245429992677,11.3399734497071 52.8213996887207,11.3388719558716 52.8204650878907,11.3410749435425 52.8160591125488,11.3358335494996 52.815040588379,11.3294296264649 52.8100090026856,11.3162517547608 52.807601928711,11.3147935867309 52.8025588989258,11.3116188049317 52.788631439209,11.3252906799316 52.7836494445801,11.327467918396 52.7786979675294,11.3291692733765 52.7776794433594,11.3299055099488 52.771827697754)) | 0.0006 | POINT(11.131121516820834 52.83428383822466) |
33958 | POLYGON((4.58252048492426 48.1094894409181,4.59028339385986 48.1142349243165,4.62617921829218 48.1189498901368,4.62617921829218 48.1189498901368,4.62780427932745 48.1254501342774,4.62253999710094 48.1313209533693,4.6229882240296 48.138038635254,4.61567163467407 48.1428184509277,4.61567163467407 48.1428184509277,4.58575391769415 48.1706924438478,4.57264947891241 48.1761245727539,4.54264020919805 48.1787948608398,4.54264020919805 48.1787948608398,4.53325843811041 48.1680450439454,4.53392505645763 48.1618194580078,4.53392505645763 48.1618194580078,4.54901599884045 48.1479682922363,4.55349493026745 48.1269493103028,4.56023025512707 48.1214942932129,4.56226539611828 48.1116752624513,4.56226539611828 48.1116752624513,4.58252048492426 48.1094894409181)) | 0.0006 | POINT(4.5791382108416405 48.14085351853149) |
22359 | POLYGON((-0.0177994202822447 44.9476432800293,-0.04276392608881 44.9533882141113,-0.04276392608881 44.9533882141113,-0.0454741902649403 44.9546928405762,-0.0454741902649403 44.9546928405762,-0.0488015674054054 44.960105895996,-0.0488015674054054 44.960105895996,-0.0300470739602474 44.9735336303712,-0.016455851495266 44.9724235534668,-0.016455851495266 44.9724235534668,-0.00426850002253332 44.9671859741211,-0.00426850002253332 44.9671859741211,-0.00216732197435476 44.9578170776367,-0.00952543318271637 44.9497451782228,-0.0177994202822447 44.9476432800293)) | 0.0006 | POINT(-0.026790522853819523 44.96030943734305) |
22453 | POLYGON((-0.941564023494664 43.7580604553223,-0.943142414093018 43.7609405517579,-0.935431957244873 43.768123626709,-0.923248827457371 43.7686767578126,-0.923248827457371 43.7686767578126,-0.91514664888382 43.7709159851075,-0.895109593868256 43.7655181884767,-0.895109593868256 43.7655181884767,-0.900170505046844 43.7600669860841,-0.902667522430363 43.74711227417,-0.902667522430363 43.74711227417,-0.904641330242157 43.7441673278809,-0.904641330242157 43.7441673278809,-0.908931016921997 43.7454719543457,-0.915513753890991 43.740692138672,-0.933937668800354 43.7413444519044,-0.933937668800354 43.7413444519044,-0.935356855392399 43.7536621093751,-0.941564023494664 43.7580604553223)) | 0.0006 | POINT(-0.9174703922536449 43.75508732265904) |