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 |
---|---|---|---|
21112 | POLYGON((7.25331020355236 47.9356079101562,7.24099969863897 47.944507598877,7.24099969863897 47.944507598877,7.21386766433722 47.9513053894042,7.20916748046875 47.9504013061525,7.20669460296637 47.9440917968751,7.20669460296637 47.9440917968751,7.20625877380371 47.9328498840332,7.20625877380371 47.9328498840332,7.2147159576416 47.9290771484374,7.23453664779669 47.9311027526855,7.24723768234259 47.9250946044922,7.24723768234259 47.9250946044922,7.26046800613415 47.929714202881,7.26046800613415 47.929714202881,7.25331020355236 47.9356079101562)) | 0.0006 | POINT(7.229927698771212 47.93666737874352) |
73191 | POLYGON((9.656572341919 47.2375831604004,9.63679790496838 47.2246093750001,9.63679790496838 47.2246093750001,9.60305023193359 47.2287826538087,9.60305023193359 47.2287826538087,9.62750720977795 47.2489662170411,9.62750720977795 47.2489662170411,9.63898849487305 47.2551879882814,9.64593982696539 47.250717163086,9.65423583984381 47.2507286071777,9.65600395202637 47.2479782104492,9.656572341919 47.2375831604004)) | 0.0006 | POINT(9.635131922635223 47.240628329190415) |
61916 | MULTIPOLYGON(((9.7720766067506 53.543384552002,9.76544189453131 53.5411148071289,9.77152252197271 53.5310668945313,9.76999568939215 53.5294494628906,9.77376651763916 53.5276489257813,9.77490615844738 53.5260620117188,9.77406406402594 53.524829864502,9.77626323699945 53.5250701904297,9.7783203125 53.5194625854493,9.77726078033453 53.5180778503419,9.77408695220959 53.5192337036133,9.77492332458502 53.5206108093262,9.7715854644776 53.5227546691895,9.76902675628668 53.5197219848633,9.76371479034435 53.5083389282227,9.76886081695562 53.5052795410156,9.76886081695562 53.5052795410156,9.76940059661871 53.5045738220215,9.76525497436523 53.4948234558105,9.74692535400396 53.4961891174316,9.7436790466308 53.4924850463867,9.73965072631847 53.4929351806641,9.73807239532476 53.490966796875,9.73807239532476 53.490966796875,9.71407508850092 53.4922256469728,9.71460247039801 53.4930572509766,9.71363639831543 53.4934883117675,9.71562004089361 53.4944915771486,9.68764400482189 53.5027008056642,9.68207359313976 53.4942207336427,9.65254878997814 53.5017242431642,9.64532566070568 53.5040130615236,9.64342689514166 53.5056838989258,9.62967205047613 53.5091857910157,9.62967205047613 53.5091857910157,9.63361644744873 53.5113906860352,9.6372442245484 53.5155868530274,9.63814449310303 53.5169982910157,9.63715553283703 53.5201034545898,9.63853931427008 53.5224838256837,9.64605426788324 53.5245208740234,9.64767551422113 53.5272560119629,9.64657688140869 53.5300827026368,9.652419090271 53.5313377380372,9.65400123596191 53.5330390930176,9.65036678314215 53.5339050292969,9.65036678314215 53.5339050292969,9.65725708007818 53.5426788330079,9.64922904968267 53.5437469482421,9.64563179016113 53.5460014343262,9.64544582366949 53.5493774414063,9.64128589630121 53.5562210083008,9.64202976226812 53.5586967468263,9.64494800567627 53.5618705749512,9.63211059570318 53.5622673034669,9.61909198760992 53.565269470215,9.61477947235107 53.5671653747559,9.61201286315924 53.5656280517579,9.61201286315924 53.5656280517579,9.61295127868652 53.5677566528321,9.61295127868652 53.5677566528321,9.61418151855474 53.5688591003418,9.62094116210932 53.5667686462402,9.62910366058361 53.5677452087402,9.6335382461549 53.5656280517579,9.63675022125256 53.5658302307129,9.63696193695068 53.5665664672852,9.63511276245129 53.5675392150879,9.62940788269049 53.56840133667,9.62820911407476 53.5694732666017,9.62876796722412 53.5709495544434,9.63366985321045 53.5711822509767,9.63366985321045 53.5711822509767,9.63695716857922 53.5714035034179,9.64963245391857 53.5678253173828,9.65999507904064 53.5596199035646,9.66775035858149 53.555778503418,9.6693840026856 53.5539588928223,9.68495082855236 53.5478515625001,9.69272422790533 53.5495910644532,9.69383907318115 53.547634124756,9.69846916198742 53.5458145141603,9.70910263061535 53.5451087951661,9.71062564849854 53.5457267761232,9.71028137207037 53.5488967895507,9.71122550964361 53.5504264831544,9.7179594039917 53.5515289306642,9.72088050842297 53.5513000488282,9.72061252594 53.5500221252442,9.72280311584484 53.5498771667481,9.72316741943354 53.5510864257813,9.72692012786877 53.5504493713379,9.72808742523205 53.5489654541016,9.72729873657227 53.5451469421388,9.72801113128668 53.5443382263184,9.73597908020031 53.5455207824708,9.74256134033209 53.5480537414551,9.74865436553949 53.5470352172852,9.76608848571777 53.5466346740723,9.7720766067506 53.543384552002)),((9.6766290664674 53.5627250671386,9.69494533538818 53.5614967346192,9.70277976989746 53.5589752197267,9.72694873809814 53.5586547851562,9.73581790924072 53.5563354492187,9.74276924133306 53.5575561523438,9.77323246002197 53.5553054809571,9.77901172637939 53.5546112060546,9.78330612182629 53.5511207580566,9.77434635162354 53.5497360229493,9.77315998077398 53.550521850586,9.77879524230957 53.5510597229005,9.78075408935558 53.5521583557129,9.77917957305903 53.5533638000489,9.77333450317388 53.5536956787109,9.76901340484619 53.5531158447266,9.76628303527843 53.5512390136719,9.76193904876709 53.5519943237305,9.7593269348144 53.551197052002,9.7522611618042 53.5532035827637,9.74376869201672 53.5530090332032,9.73860645294189 53.5556640625001,9.69942188262951 53.5585517883301,9.69435787200922 53.5602798461915,9.68966197967541 53.559898376465,9.68908500671392 53.558464050293,9.68711185455334 53.5574264526368,9.67745494842541 53.5565299987794,9.66294097900391 53.5642127990724,9.6766290664674 53.5627250671386))) | 0.0006 | POINT(9.692277476718626 53.53731508472033) |
67502 | POLYGON((7.7559580802918 48.1088066101075,7.75710201263428 48.1077995300294,7.75732421875 48.1028518676758,7.76273965835571 48.1003761291504,7.75984477996826 48.0939979553223,7.75472497940075 48.0863609313965,7.75551033020025 48.0845527648926,7.75767135620123 48.0843200683595,7.75767135620123 48.0843200683595,7.76809978485113 48.0863075256349,7.76974725723272 48.087345123291,7.77730703353882 48.0858688354492,7.77704381942755 48.0845603942872,7.77907896041876 48.0824699401857,7.78285217285156 48.0824546813965,7.78234624862671 48.080192565918,7.78604745864874 48.0802574157715,7.78615379333502 48.0827140808105,7.78446817398071 48.0857696533204,7.78987693786621 48.0841445922851,7.78987693786621 48.0841445922851,7.7920494079591 48.0851097106934,7.79466533660894 48.0841674804688,7.79707193374634 48.0845947265625,7.79707193374634 48.0845947265625,7.79532718658453 48.086540222168,7.80088949203486 48.08890914917,7.8016300201416 48.0900955200195,7.80095863342297 48.0908355712891,7.80412578582764 48.0935592651367,7.80431509017939 48.0975723266602,7.80746316909801 48.0984764099122,7.81406641006464 48.0970115661622,7.8173656463623 48.0935783386232,7.82415914535517 48.0925178527833,7.83389472961431 48.0930099487305,7.84300994873053 48.0895957946777,7.84300994873053 48.0895957946777,7.8466148376466 48.0937042236328,7.84210443496698 48.1006469726563,7.84283351898205 48.1018142700196,7.84191036224377 48.1032485961914,7.84732103347784 48.1077613830566,7.84461879730225 48.1110420227051,7.84204435348516 48.1119613647462,7.84348630905151 48.1141624450685,7.8424587249757 48.1152267456056,7.83852195739746 48.1179008483887,7.83324146270758 48.1182708740236,7.82899379730225 48.1212692260743,7.82866859436035 48.1227989196777,7.82995653152472 48.1240730285646,7.81679058074957 48.128490447998,7.81780004501343 48.135856628418,7.82090663909923 48.1380348205566,7.82276344299316 48.1409606933595,7.82181072235102 48.1421699523927,7.82467603683466 48.1440925598146,7.82683515548706 48.1486320495606,7.83393287658697 48.153835296631,7.83442497253429 48.1507148742676,7.83655261993403 48.1501464843749,7.83632230758673 48.149440765381,7.83905220031744 48.1474266052246,7.84150075912487 48.147388458252,7.84233045578009 48.1457176208496,7.84768295288092 48.1486549377443,7.84940147399902 48.1516799926758,7.85382699966442 48.1541252136231,7.85854053497314 48.1522178649903,7.85892915725719 48.1554985046387,7.85727834701544 48.1574478149414,7.86127948760992 48.1595497131349,7.86284112930304 48.1587600708008,7.87089109420788 48.1595726013185,7.87089109420788 48.1595726013185,7.87243604660034 48.163372039795,7.87243604660034 48.163372039795,7.86996221542364 48.1631126403809,7.86696290969843 48.164390563965,7.86319684982311 48.1624031066896,7.85202598571772 48.1621055603027,7.85203695297241 48.1636543273926,7.85002803802496 48.1655044555665,7.8503351211549 48.169532775879,7.84913396835333 48.1711158752442,7.84552669525158 48.1724128723145,7.84341049194336 48.1754913330079,7.84000539779663 48.1755332946778,7.83739948272711 48.1729888916017,7.83282423019415 48.1715545654297,7.83064222335815 48.1716194152832,7.83246517181396 48.1742095947266,7.82623767852778 48.1744651794433,7.82511472702038 48.1728515625,7.82366466522228 48.1730613708497,7.82193279266363 48.1752204895019,7.82193279266363 48.1752204895019,7.81558561325085 48.1737251281738,7.81558561325085 48.1737251281738,7.81622028350836 48.1717109680176,7.81347465515148 48.1705169677736,7.81906652450573 48.1666259765626,7.82054662704473 48.1631507873536,7.81958961486822 48.1572723388672,7.8211870193482 48.1555938720704,7.81855010986328 48.1536598205568,7.81379318237316 48.1523818969728,7.80861186981213 48.1544570922852,7.80255270004284 48.1546249389649,7.80119228363043 48.153205871582,7.79658174514765 48.153434753418,7.79266309738159 48.1523399353027,7.78883647918701 48.1500587463379,7.78721809387218 48.1508827209473,7.78374814987194 48.1489601135254,7.78262138366699 48.1494102478028,7.77823448181152 48.1446342468262,7.77759361267101 48.1426124572753,7.774573802948 48.1415634155273,7.774573802948 48.1415634155273,7.77687597274786 48.1373672485351,7.7735161781311 48.1327590942384,7.77139472961437 48.1319961547853,7.77119874954218 48.130443572998,7.76933956146246 48.1302909851075,7.76973390579224 48.1285095214844,7.76973390579224 48.1285095214844,7.77094125747681 48.1273345947266,7.77010822296148 48.1263694763185,7.77625274658209 48.1226539611817,7.77770233154297 48.1207351684571,7.77620601654058 48.1157264709473,7.76904630661022 48.1113624572754,7.76785707473761 48.1083488464356,7.76245594024664 48.1086196899414,7.76006507873541 48.1105461120607,7.7559580802918 48.1088066101075)) | 0.0006 | POINT(7.812097037795728 48.13010309038372) |
31360 | POLYGON((2.70374369621277 47.2625732421876,2.71520519256597 47.248405456543,2.73612093925476 47.2349395751954,2.73612093925476 47.2349395751954,2.73249316215521 47.2175827026368,2.73249316215521 47.2175827026368,2.71210575103765 47.2149085998535,2.67163658142101 47.1994323730469,2.67163658142101 47.1994323730469,2.65492796897894 47.2075309753419,2.65492796897894 47.2075309753419,2.64563131332403 47.2149467468262,2.63711428642267 47.2337532043456,2.63711428642267 47.2337532043456,2.68252229690557 47.248462677002,2.6928210258485 47.2485466003419,2.69958424568171 47.2614631652832,2.69958424568171 47.2614631652832,2.70374369621277 47.2625732421876)) | 0.0006 | POINT(2.6897657579846164 47.23040262858076) |
71258 | POLYGON((16.164400100708 47.4201126098633,16.1696662902833 47.421745300293,16.1696662902833 47.421745300293,16.2060070037841 47.4243659973145,16.2060070037841 47.4243659973145,16.2104244232178 47.4119338989258,16.2104244232178 47.4119338989258,16.2150135040284 47.3960762023925,16.2156219482422 47.3903579711915,16.2135334014894 47.3867835998535,16.2058143615723 47.3799743652344,16.2048530578613 47.3773651123047,16.2068271636964 47.3721656799317,16.2149753570557 47.359001159668,16.2149753570557 47.359001159668,16.2224121093751 47.3112754821778,16.2224121093751 47.3112754821778,16.2198638916016 47.3080482482911,16.2147312164307 47.3058433532716,16.1857376098633 47.3038291931153,16.1795253753662 47.3060836791993,16.1684360504151 47.3143730163575,16.1684360504151 47.3143730163575,16.1709728240967 47.3237648010255,16.1702327728272 47.3281745910644,16.1477489471436 47.3571357727052,16.1477489471436 47.3571357727052,16.1556911468506 47.3604621887207,16.1556911468506 47.3604621887207,16.1791343688965 47.3815231323242,16.1837844848633 47.3881378173829,16.1809597015381 47.3955841064454,16.164400100708 47.4201126098633)) | 0.0006 | POINT(16.190679013729127 47.36513781547552) |
33879 | POLYGON((4.11608123779303 48.1299476623536,4.09746551513672 48.1158409118653,4.09746551513672 48.1158409118653,4.08592748641973 48.1200599670411,4.08592748641973 48.1200599670411,4.08393907547003 48.126636505127,4.0941886901856 48.1523170471193,4.0941886901856 48.1523170471193,4.10250854492193 48.1611137390136,4.09997081756603 48.1677780151368,4.10612821578985 48.1772232055663,4.10612821578985 48.1772232055663,4.10686588287354 48.1803207397461,4.11528301239014 48.1825981140137,4.11870241165161 48.1775817871095,4.11870241165161 48.1775817871095,4.1146035194397 48.1714363098145,4.11765956878662 48.1651916503907,4.11198234558111 48.1319198608399,4.11608123779303 48.1299476623536)) | 0.0006 | POINT(4.103879928588903 48.15278886493889) |
1405558 | POLYGON((-1.1990259885788 42.8877906799317,-1.19447195529932 42.8810081481934,-1.20135498046869 42.8734169006348,-1.20222103595734 42.8667335510254,-1.2129670381546 42.8677024841309,-1.21945595741261 42.865505218506,-1.23516404628748 42.8671760559083,-1.23704600334167 42.8805770874023,-1.23933005332947 42.8838005065919,-1.2345689535141 42.8910102844239,-1.24024796485901 42.8941497802735,-1.23965597152699 42.8968620300293,-1.23086702823639 42.9031448364258,-1.22462499141687 42.9047050476074,-1.22469103336329 42.9096488952637,-1.2217760086059 42.9078865051269,-1.22190999984736 42.9006996154785,-1.22283101081842 42.8993186950684,-1.22407603263855 42.9007987976075,-1.22646200656891 42.8999977111817,-1.22639799118042 42.8987960815431,-1.23028600215912 42.897346496582,-1.2248500585556 42.8912925720214,-1.22048997879028 42.8908920288087,-1.21572899818415 42.8950119018554,-1.21968102455139 42.9015121459961,-1.21702396869659 42.904930114746,-1.21358704566944 42.9051284790038,-1.21281003952015 42.9095726013185,-1.20881903171539 42.9111404418946,-1.20970296859736 42.9094352722168,-1.20004200935358 42.9084091186523,-1.19332098960876 42.9108352661134,-1.17612695693964 42.9267768859863,-1.15996098518372 42.9371910095215,-1.15287101268768 42.9300270080566,-1.15111994743347 42.9246864318848,-1.15516400337214 42.9184913635254,-1.15702998638147 42.9191703796387,-1.1680999994278 42.9152793884278,-1.16976594924927 42.9136390686035,-1.16786301136017 42.9129066467285,-1.16962504386902 42.9092330932618,-1.1679220199585 42.9076309204102,-1.17042005062103 42.9030952453614,-1.17539298534393 42.8997726440431,-1.18007504940033 42.9000778198243,-1.18623495101923 42.8980255126954,-1.18521201610565 42.8953437805176,-1.1990259885788 42.8877906799317)) | 0.0006 | POINT(-1.202823921125736 42.9005629091847) |
33009 | POLYGON((2.27316308021545 47.7696762084961,2.24799108505249 47.736026763916,2.23967814445496 47.7323265075685,2.23967814445496 47.7323265075685,2.22951126098633 47.7332763671876,2.22552132606518 47.7434234619141,2.22799801826477 47.7502326965333,2.21681666374218 47.7573051452638,2.21681666374218 47.7573051452638,2.22385334968578 47.7809638977052,2.22116637229925 47.791187286377,2.22786712646479 47.8006744384767,2.22462749481207 47.8213081359864,2.22462749481207 47.8213081359864,2.23564291000366 47.8201484680176,2.23564291000366 47.8201484680176,2.25061869621283 47.8034210205078,2.27105593681347 47.7890129089355,2.27316308021545 47.7696762084961)) | 0.0006 | POINT(2.235126482115893 47.77555953131789) |
70818 | POLYGON((11.8190650939941 50.6322937011719,11.8203649520875 50.6302452087403,11.8209762573243 50.6318397521974,11.8250179290771 50.631175994873,11.8260488510132 50.6301002502442,11.8237895965577 50.6297569274903,11.8226051330567 50.6278800964355,11.8255023956298 50.6272888183594,11.8255023956298 50.6272888183594,11.8299856185914 50.6282463073732,11.8322315216064 50.6256370544434,11.8336563110351 50.6259727478027,11.8337593078613 50.6236305236818,11.8307495117189 50.6217689514161,11.8332080841065 50.6206588745118,11.838815689087 50.6208839416504,11.8385496139526 50.6184921264648,11.8323421478271 50.6177253723146,11.8314361572266 50.6190223693848,11.8293724060058 50.6186141967775,11.830418586731 50.6170845031739,11.8298025131227 50.6153182983399,11.8380756378175 50.6078605651855,11.8406000137329 50.6090927124023,11.8421487808228 50.6073722839356,11.8449077606201 50.6084022521974,11.8457841873168 50.6078948974611,11.8428182601929 50.606086730957,11.8413963317871 50.6038360595704,11.8446769714355 50.6043281555176,11.8457708358765 50.6035156250001,11.8429765701294 50.6012420654298,11.8515462875367 50.5939331054688,11.8536653518677 50.5933799743652,11.8539781570436 50.5914840698243,11.8512010574341 50.5898170471192,11.8522062301637 50.5879058837892,11.8522062301637 50.5879058837892,11.8572826385498 50.5865135192871,11.8608493804932 50.5890998840333,11.8650522232056 50.5843887329102,11.8678970336915 50.5874252319337,11.8655891418458 50.5892333984376,11.8664999008179 50.5908889770508,11.8685913085938 50.5889282226562,11.8686800003051 50.5909881591797,11.8713598251344 50.5922241210938,11.8725557327271 50.5910873413087,11.8748292922974 50.591480255127,11.8738298416137 50.5925827026368,11.8798294067383 50.5956344604493,11.8798294067383 50.5956344604493,11.8806390762329 50.59672164917,11.8778886795044 50.5979232788087,11.8746490478517 50.5964164733886,11.8740043640136 50.5970726013184,11.8776645660401 50.600383758545,11.8740663528442 50.600643157959,11.8719558715821 50.6043586730958,11.8734693527222 50.6048545837402,11.8718099594116 50.607105255127,11.872748374939 50.6087150573731,11.8756532669068 50.608455657959,11.8772468566894 50.610206604004,11.8782606124878 50.6086120605469,11.8815574645997 50.6096267700196,11.879753112793 50.6136589050294,11.881986618042 50.613166809082,11.881986618042 50.613166809082,11.8829078674318 50.6151237487793,11.8768253326416 50.6179962158204,11.8659934997558 50.6195640563965,11.8647022247315 50.6218376159668,11.8585081100465 50.6185035705568,11.8541679382324 50.6210174560547,11.8509635925293 50.6207504272461,11.8470840454102 50.6265373229982,11.8445119857788 50.6256484985353,11.843457221985 50.6278190612794,11.8403224945068 50.6265525817871,11.8374891281129 50.6283950805664,11.834969520569 50.6278648376466,11.8381967544556 50.6304016113282,11.8374624252319 50.6329193115236,11.839168548584 50.6336822509767,11.8348274230958 50.6337890625001,11.8348274230958 50.6337890625001,11.8336410522462 50.6338653564454,11.8315143585206 50.6371994018555,11.8298120498658 50.6370506286621,11.8284606933595 50.6387939453126,11.8273172378541 50.6383934020996,11.8288726806642 50.6363487243653,11.8277015686035 50.6359748840333,11.8284282684327 50.6341590881349,11.8266944885253 50.6339073181153,11.8249607086182 50.635627746582,11.8181552886963 50.6341590881349,11.8190650939941 50.6322937011719)) | 0.0006 | POINT(11.849460387716519 50.61387603136961) |