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 |
---|---|---|---|
1398594 | POLYGON((-4.62694978713984 40.4012451171876,-4.64434003829956 40.3962516784669,-4.64281320571899 40.4138488769532,-4.6441187858581 40.4167022705079,-4.65055084228516 40.4175109863282,-4.6562237739563 40.4147377014161,-4.66059017181391 40.4159545898438,-4.65947818756104 40.4186897277833,-4.66149091720581 40.4214439392091,-4.66132020950317 40.4255180358887,-4.66530799865723 40.429012298584,-4.68004989624023 40.4340248107911,-4.69749879837036 40.4330825805665,-4.70715808868408 40.4393081665038,-4.70492410659784 40.4531059265138,-4.71062707901001 40.4622459411622,-4.70546388626093 40.4693412780761,-4.71182489395142 40.4819755554199,-4.71695804595947 40.4852409362793,-4.71596193313587 40.486915588379,-4.71989393234253 40.4963150024415,-4.71961307525635 40.5001029968262,-4.71005916595459 40.5160789489746,-4.7212381362915 40.5188598632813,-4.72245311737061 40.5266342163087,-4.72059297561646 40.5361366271973,-4.72167778015137 40.5379066467286,-4.72430419921875 40.5376129150391,-4.72265577316284 40.5397033691407,-4.71803379058838 40.5403480529785,-4.71491098403931 40.5388259887696,-4.71484518051147 40.5362052917481,-4.7100138664245 40.5360870361329,-4.70460987091059 40.5255355834961,-4.69750595092773 40.5265541076661,-4.68333387374878 40.5334167480469,-4.66978502273554 40.4984550476075,-4.65483617782587 40.4797897338867,-4.62169218063349 40.421199798584,-4.62627410888666 40.4196128845215,-4.62091493606567 40.4055328369142,-4.62142419815063 40.4036369323731,-4.62694978713984 40.4012451171876)) | 0.0006 | POINT(-4.684864736738641 40.47120730082198) |
1404590 | POLYGON((0.665950000286216 40.9436912536622,0.662276029586792 40.9462394714355,0.657948017120304 40.957317352295,0.658939003944511 40.9625625610352,0.655921995639801 40.9644966125488,0.657620012760106 40.9670562744142,0.656445980071965 40.9692611694337,0.651522994041443 40.9713020324708,0.647458970546779 40.9859848022461,0.643459975719452 40.9871368408203,0.641094028949738 40.9933891296387,0.64292901754385 40.9966812133789,0.633818984031791 41.0030899047853,0.6432160139085 41.006217956543,0.64478600025177 41.0036659240723,0.651408970355988 41.0062637329102,0.654574990272636 41.021167755127,0.660974979400635 41.0321197509766,0.663399994373435 41.0406799316407,0.650822997093201 41.0487899780274,0.650789022445736 41.050724029541,0.657478988170624 41.0548896789552,0.648407995700893 41.0625267028808,0.650420010089988 41.063606262207,0.654116988182182 41.0620727539063,0.656527996063346 41.0647811889648,0.662865996360892 41.0690002441407,0.68453902006155 41.076515197754,0.697632014751434 41.1043434143066,0.712459981441498 41.1050643920899,0.720553994178886 41.1027030944825,0.732676029205322 41.1031684875488,0.737425982952232 41.0973014831543,0.749036014080048 41.0910530090333,0.751698017120418 41.0851745605469,0.760894000530186 41.0846710205079,0.764840006828251 41.0887107849121,0.765293002128544 41.0935401916504,0.767830014228878 41.0952033996582,0.770965993404445 41.0880317687989,0.770265996456203 41.083911895752,0.787180006504059 41.0779457092286,0.79186600446701 41.0708541870117,0.800921022892055 41.0698204040527,0.80580198764801 41.0659675598144,0.815536975860709 41.0670013427736,0.815654993057251 41.0712966918946,0.818978011608237 41.0715560913087,0.820441007614193 41.0746192932129,0.824562013149375 41.0773582458497,0.823159992694798 41.0841827392578,0.824468970298824 41.0870208740236,0.822018027305717 41.088092803955,0.820316016674099 41.0866088867189,0.826840996742362 41.0983810424805,0.830726981162968 41.0968017578125,0.843138992786464 41.0998077392579,0.850421011447963 41.094451904297,0.862546026706809 41.0927467346192,0.873072981834468 41.0839462280275,0.870929002761841 41.0822525024415,0.870503008365631 41.0784683227539,0.87244701385498 41.0763053894043,0.871295988559837 41.0755500793457,0.866163015365601 41.078525543213,0.868938982486839 41.0816078186035,0.869275987148342 41.0849494934083,0.864710986614341 41.0848197937013,0.862673997879142 41.0862159729004,0.858322978019714 41.0844688415527,0.856797993183136 41.0809707641602,0.851777017116603 41.0777549743653,0.854761004447937 41.0752487182617,0.853335976600761 41.0722541809081,0.856199026107731 41.0705375671386,0.856927990913448 41.0632896423339,0.855014026165122 41.0604400634766,0.853331983089447 41.0607719421388,0.852262973785457 41.0565414428711,0.843213975429478 41.0554008483887,0.843837022781315 41.0533981323243,0.83717900514597 41.0541076660156,0.835802972316799 41.0527229309083,0.817353010177555 41.0621910095215,0.805195987224636 41.0535850524902,0.796292006969509 41.0390319824219,0.78096699714672 41.0289611816407,0.786284029483795 41.0248336791993,0.782893002033347 41.0216941833497,0.784394979476929 41.0167922973634,0.778945028781891 41.0065231323243,0.778675973415488 40.9999313354492,0.774818003177643 40.9965019226075,0.776914000511169 40.9938659667969,0.776283025741691 40.9901123046876,0.781422972679252 40.9918518066407,0.792685985565186 40.972354888916,0.798561990261135 40.9685058593751,0.797976016998348 40.9663619995117,0.803376972675323 40.9530754089355,0.809988975524902 40.9474334716797,0.819473028182983 40.9429855346681,0.822252988815364 40.9430313110351,0.818987011909542 40.9407768249512,0.789361000061149 40.9387512207032,0.752780973911342 40.9322052001953,0.7396439909935 40.9390487670898,0.698916018009299 40.9440879821777,0.693319976329803 40.9425354003907,0.688996970653534 40.9436035156249,0.684804975986594 40.9408645629883,0.682228028774375 40.9403953552247,0.678816020488853 40.9448585510254,0.671891987323875 40.9459342956544,0.665950000286216 40.9436912536622)) | 0.0006 | POINT(0.7645538762996495 41.03519171999213) |
32136 | POLYGON((0.965293824672813 47.2208671569825,0.955526530742702 47.2229194641113,0.935705065727234 47.2203178405762,0.913273811340332 47.2022361755372,0.907341778278408 47.1930313110351,0.907341778278408 47.1930313110351,0.916489601135311 47.1867599487305,0.916489601135311 47.1867599487305,0.930098533630371 47.1897926330567,0.944313108921051 47.1866989135743,0.958063781261558 47.190559387207,0.972705483436698 47.1995811462403,0.972705483436698 47.1995811462403,0.974384307861385 47.2062301635742,0.965293824672813 47.2208671569825)) | 0.0006 | POINT(0.9406951921327342 47.19988332475938) |
1403136 | POLYGON((1.92069602012634 42.110824584961,1.91648697853094 42.1019134521486,1.91344904899597 42.1010818481446,1.9084600210191 42.0959854125978,1.90344798564905 42.0968284606935,1.89702498912811 42.0955085754396,1.89160299301147 42.0912055969238,1.87966299057018 42.0861854553224,1.88365995883942 42.0935249328614,1.88194394111645 42.0954246520996,1.88676702976227 42.0980987548829,1.88776099681866 42.1003150939941,1.87748801708227 42.1052398681641,1.87268900871271 42.1058769226074,1.86659395694738 42.1131210327149,1.87378895282757 42.1147079467775,1.88194000720978 42.1142501831055,1.88071596622473 42.1174812316894,1.87600004672998 42.1179695129395,1.87529397010815 42.1205825805665,1.86871397495281 42.1242027282715,1.86345398426056 42.1224555969238,1.85702896118164 42.1156234741212,1.84722197055817 42.1170425415039,1.83163499832148 42.1218223571778,1.8239170312882 42.1218070983887,1.7955219745636 42.1344146728516,1.78219604492193 42.1349563598633,1.77635896205896 42.142906188965,1.77793598175055 42.1471252441407,1.79561305046087 42.153045654297,1.80616700649261 42.1521759033204,1.8072110414505 42.1597023010254,1.8112930059433 42.1619758605957,1.82874703407293 42.1610832214356,1.83162999153149 42.1641387939453,1.84393703937542 42.1662025451661,1.84574198722851 42.1676445007324,1.84255397319794 42.1740646362305,1.84496998786926 42.1768341064454,1.84415602684021 42.1899490356446,1.85097301006329 42.1953239440918,1.85861504077906 42.1882400512696,1.86485099792475 42.1863822937012,1.87214195728313 42.1744766235352,1.86915397644049 42.1648864746093,1.87162697315227 42.1504745483399,1.88005900383001 42.1407089233398,1.89001500606548 42.1349029541017,1.8880660533905 42.1295623779298,1.8809939622879 42.1256790161133,1.89121305942547 42.1259727478028,1.89375197887415 42.1179885864258,1.89970302581793 42.1181449890137,1.90218698978435 42.1152572631837,1.90524804592127 42.1165237426758,1.92069602012634 42.110824584961)) | 0.0006 | POINT(1.8628584997994915 42.13160399028237) |
40498 | POLYGON((2.24221730232239 45.5985145568848,2.24333548545849 45.6143455505372,2.25878643989563 45.6209297180176,2.25878643989563 45.6209297180176,2.24234628677374 45.6322479248046,2.24234628677374 45.6322479248046,2.22467541694641 45.6282920837403,2.21747827529919 45.6325912475587,2.21747827529919 45.6325912475587,2.21107172966009 45.6236877441406,2.1970894336701 45.623218536377,2.17149114608765 45.6142692565918,2.17149114608765 45.6142692565918,2.17598319053661 45.6133499145509,2.18175816535955 45.6046104431153,2.18522071838379 45.5890045166016,2.18522071838379 45.5890045166016,2.18967771530163 45.5815505981445,2.19651103019726 45.5790328979492,2.19651103019726 45.5790328979492,2.20588922500622 45.5796394348145,2.20993304252636 45.5856323242188,2.2272367477417 45.5900459289551,2.2272367477417 45.5900459289551,2.24221730232239 45.5985145568848)) | 0.0006 | POINT(2.211657166481073 45.60704517364504) |
28962 | POLYGON((3.37689542770386 47.1393051147461,3.37939786911016 47.1292877197267,3.38726782798778 47.1211738586427,3.3880405426026 47.1075973510742,3.3750040531159 47.0893554687501,3.3750040531159 47.0893554687501,3.36155819892889 47.0854072570801,3.33252143859863 47.0856742858887,3.33252143859863 47.0856742858887,3.3229331970216 47.084758758545,3.31498599052424 47.0916557312011,3.31015944480896 47.0914001464844,3.31015944480896 47.0914001464844,3.30298280715948 47.1139183044435,3.28957748413097 47.1152305603028,3.28957748413097 47.1152305603028,3.28127193450922 47.1233978271486,3.25262641906744 47.1355133056641,3.2612583637237 47.1471328735352,3.2612583637237 47.1471328735352,3.26499509811407 47.1449012756348,3.28413248062139 47.1480979919435,3.29849028587347 47.1457023620605,3.29849028587347 47.1457023620605,3.31257128715527 47.141326904297,3.3292214870454 47.1280975341797,3.33806657791138 47.1312522888184,3.36062240600592 47.1504783630372,3.36062240600592 47.1504783630372,3.36455416679394 47.1444969177246,3.37689542770386 47.1393051147461)) | 0.0006 | POINT(3.323892275492393 47.120671208699584) |
1405980 | POLYGON((-0.163874000310784 38.5234718322753,-0.166804999113026 38.5243072509767,-0.167659997940063 38.5231590270997,-0.166492998599949 38.5272102355958,-0.169813007116318 38.5319862365723,-0.172756001353264 38.5312614440919,-0.1867659986018 38.5364112854005,-0.200731992721558 38.5445480346679,-0.208435997366905 38.5447082519532,-0.216961994767075 38.5508460998536,-0.227267995476723 38.5525588989257,-0.229570001363754 38.5577774047852,-0.236182004213276 38.5604019165039,-0.240713000297546 38.5601005554199,-0.244925007224083 38.5628051757814,-0.245654001831952 38.5749397277833,-0.240899994969311 38.5915031433107,-0.241120994090977 38.5947189331055,-0.233205005526429 38.6023330688476,-0.224464997649193 38.6080741882325,-0.216028004884663 38.6106910705566,-0.197641998529377 38.6080894470215,-0.186676993966046 38.6101684570313,-0.186557993292809 38.604949951172,-0.179483994841519 38.5956459045411,-0.179646000266075 38.5915222167969,-0.167170003056526 38.5829696655274,-0.158989995718002 38.5706367492676,-0.175058007240239 38.5609436035156,-0.163874000310784 38.5234718322753)) | 0.0006 | POINT(-0.20108803387342214 38.566853095745266) |
66161 | POLYGON((11.5006170272827 48.2530250549318,11.4698190689087 48.2553329467774,11.4690895080566 48.241497039795,11.4583930969238 48.2412719726564,11.4562711715698 48.2397994995117,11.4551019668579 48.2364082336427,11.4510583877563 48.2362823486329,11.4505729675292 48.2376365661621,11.4430103302003 48.2322883605957,11.4332561492919 48.2296295166017,11.4332561492919 48.2296295166017,11.4359073638917 48.2265663146973,11.4332742691041 48.2239189147949,11.4314231872559 48.2242393493652,11.4289684295655 48.2218589782715,11.4277458190918 48.2175903320313,11.4282989501954 48.2120056152344,11.4260540008545 48.2042121887206,11.4260540008545 48.2042121887206,11.4307718276978 48.204792022705,11.430947303772 48.2076568603516,11.4399890899659 48.2074012756349,11.4567003250122 48.2088356018066,11.4609498977661 48.2149734497071,11.4718923568726 48.2193145751954,11.4890623092651 48.2226867675781,11.4876623153687 48.2321243286134,11.4901475906373 48.2353134155274,11.4895238876344 48.2379341125489,11.4914865493776 48.2381553649903,11.4913539886475 48.2421531677247,11.4903163909912 48.2436599731445,11.4907140731812 48.2457275390625,11.4998178482056 48.248146057129,11.4998178482056 48.248146057129,11.5006170272827 48.2530250549318)) | 0.0006 | POINT(11.459123584202384 48.22926930018836) |
43450 | POLYGON((1.47549724578852 43.2169952392578,1.46874403953547 43.2095642089844,1.45205593109137 43.2122230529786,1.45205593109137 43.2122230529786,1.44187593460083 43.2015686035156,1.45042312145245 43.1905632019042,1.43802011013042 43.1881713867187,1.43802011013042 43.1881713867187,1.45156490802776 43.1709060668946,1.45156490802776 43.1709060668946,1.45549261569977 43.1711158752441,1.45549261569977 43.1711158752441,1.45696365833288 43.176784515381,1.46906220912945 43.1850357055665,1.46906220912945 43.1850357055665,1.47976005077362 43.1910438537598,1.48883140087139 43.1911544799805,1.49728262424475 43.1990280151368,1.49728262424475 43.1990280151368,1.49406778812408 43.201114654541,1.49406778812408 43.201114654541,1.48056769371033 43.2038116455078,1.47549724578852 43.2169952392578)) | 0.0006 | POINT(1.466261614452759 43.19257614829326) |
43255 | POLYGON((6.77692937850946 48.083839416504,6.78643321990972 48.0811805725099,6.81125164031994 48.0837860107422,6.83658552169805 48.081974029541,6.84209012985241 48.0912971496581,6.84209012985241 48.0912971496581,6.82309055328369 48.0959701538085,6.81679105758667 48.1122817993165,6.8120379447937 48.1135253906249,6.78359222412109 48.107048034668,6.78359222412109 48.107048034668,6.76932477951061 48.1057853698732,6.76689386367809 48.1028175354004,6.76689386367809 48.1028175354004,6.76770353317272 48.0971984863282,6.76770353317272 48.0971984863282,6.77692937850946 48.083839416504)) | 0.0006 | POINT(6.79706272482878 48.097191572189345) |