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 |
---|---|---|---|
72307 | POLYGON((14.636531829834 47.8942451477052,14.6174278259278 47.8905143737793,14.5996065139772 47.8911590576172,14.5983200073243 47.8920135498047,14.5969285964967 47.895477294922,14.5949001312256 47.9111289978028,14.5885553359986 47.9207496643068,14.5793466567993 47.9283866882325,14.5635433197023 47.9361343383788,14.5620021820069 47.9388313293458,14.5621376037598 47.9457969665527,14.5580043792725 47.9505577087402,14.552227973938 47.9536476135254,14.5419178009034 47.9568328857422,14.5419178009034 47.9568328857422,14.5286798477173 47.969654083252,14.5281114578247 47.9722938537598,14.5301971435547 47.9768981933595,14.5350637435913 47.9817085266114,14.5461845397949 47.978916168213,14.5582904815674 47.9812965393066,14.5582904815674 47.9812965393066,14.6174020767213 47.9507598876954,14.6174020767213 47.9507598876954,14.651089668274 47.9433517456056,14.651089668274 47.9433517456056,14.671730041504 47.9360809326173,14.671730041504 47.9360809326173,14.6583118438721 47.9268569946289,14.6573896408081 47.9243316650391,14.6591281890869 47.9163894653321,14.6582431793214 47.9136199951173,14.636531829834 47.8942451477052)) | 0.0006 | POINT(14.593490689992958 47.93893611431127) |
24367 | POLYGON((3.77303576469416 45.1533775329591,3.78386116027838 45.1421813964844,3.77967762947094 45.1359710693359,3.77878618240368 45.1222114562989,3.77340292930614 45.1164741516113,3.77340292930614 45.1164741516113,3.76005649566662 45.1151008605957,3.74790310859692 45.1249351501466,3.73147630691534 45.1195945739747,3.73147630691534 45.1195945739747,3.72745490074163 45.1223487854004,3.72745490074163 45.1223487854004,3.7284176349641 45.1288795471192,3.74409079551697 45.1366653442384,3.74735641479487 45.1430282592773,3.74735641479487 45.1430282592773,3.75951647758484 45.1567955017091,3.77303576469416 45.1533775329591)) | 0.0006 | POINT(3.753807432511327 45.13052996467146) |
73375 | POLYGON((16.2933635711669 46.6038513183593,16.2933826446534 46.607406616211,16.2882709503175 46.6073989868165,16.2882709503175 46.6073989868165,16.2575969696045 46.6073684692383,16.2473335266114 46.6002464294434,16.2472953796387 46.5931358337402,16.2421836853028 46.5931282043457,16.2472190856934 46.5789146423341,16.2472000122071 46.5753555297852,16.2472000122071 46.5753555297852,16.2574253082275 46.575366973877,16.2574615478516 46.5824775695801,16.2727985382081 46.5824966430663,16.2728385925294 46.5896072387695,16.2779502868653 46.5896110534669,16.2831192016601 46.6002845764161,16.2933635711669 46.6038513183593)) | 0.0006 | POINT(16.265935897827188 46.59231791776773) |
39743 | POLYGON((3.85853838920593 43.8317604064943,3.84796190261847 43.8219070434571,3.84796190261847 43.8219070434571,3.83798599243164 43.8273468017578,3.83541774749756 43.8395881652833,3.83541774749756 43.8395881652833,3.8429634571076 43.850456237793,3.84303522109985 43.857006072998,3.83080959320068 43.8664245605468,3.83080959320068 43.8664245605468,3.83863019943243 43.8704032897949,3.84796071052563 43.8687477111817,3.85711574554443 43.8761634826661,3.90009212493902 43.8787269592285,3.9143569469453 43.8876533508302,3.91955423355097 43.8819732666016,3.91955423355097 43.8819732666016,3.9177298545838 43.8683280944825,3.92311143875128 43.8587875366212,3.92311143875128 43.8587875366212,3.91266202926636 43.8516845703126,3.91017031669622 43.8451652526855,3.89762926101696 43.8407669067383,3.89762926101696 43.8407669067383,3.88895487785334 43.8434562683105,3.8707377910614 43.8401565551758,3.85852766036999 43.8351860046388,3.85853838920593 43.8317604064943)) | 0.0006 | POINT(3.874386284086473 43.853745778401745) |
123575 | MULTIPOLYGON(((13.492102 46.525776,13.489314 46.521534,13.500194 46.509899,13.49212 46.505359,13.497107 46.501316,13.495524 46.473663,13.492179 46.466949,13.495327 46.455749,13.490282 46.438991,13.4961 46.427231,13.494174 46.422428,13.488776 46.423313,13.47774624824524 46.41797166271297,13.46373 46.418462,13.44222 46.433468,13.433523 46.435852,13.438919 46.4529,13.454868 46.458077,13.461124 46.464359,13.454456 46.476242,13.446659 46.472831,13.422659 46.477119,13.41569 46.472676,13.400184 46.473232,13.366648 46.489571,13.37188 46.498935,13.365645 46.502651,13.379779 46.516453,13.372556 46.526481,13.376404 46.532551,13.348055 46.554497,13.349786 46.560577,13.362872600555422 46.57006333652948,13.370678 46.567154,13.368392 46.573775,13.372237 46.579273,13.407812 46.571629,13.40765 46.561531,13.426581 46.5576,13.474722 46.557344,13.478388 46.560698,13.504249 46.566304,13.507123 46.56008,13.505386 46.555923,13.511512 46.55541,13.514921 46.548626,13.519883 46.546901,13.519883 46.546901,13.522061 46.538963,13.522061 46.538963,13.509882 46.535034,13.509882 46.535034,13.509434 46.52808,13.509434 46.52808,13.492102 46.525776,13.492102 46.525776,13.492102 46.525776)),((13.653583 46.16135,13.654669 46.151366,13.644543 46.137727,13.63308 46.13395,13.611302 46.116459,13.602479 46.113119,13.596323 46.11694,13.583491 46.110111,13.570431 46.108715,13.544647 46.093277,13.537933 46.093326,13.531592 46.099701,13.517565 46.094963,13.508963 46.099217,13.506424 46.095055,13.481633 46.110306,13.474611 46.109654,13.476979 46.112465,13.468566 46.116268,13.460174 46.125293,13.44981 46.129291,13.449880778789522 46.13001756350918,13.459867 46.135388,13.457925 46.140446,13.460748 46.145557,13.453141 46.151314,13.455126 46.153996,13.444779 46.15443,13.450872 46.156575,13.445561 46.163864,13.444432 46.173195,13.434183 46.186215,13.427964 46.185532,13.432964 46.189659,13.428845 46.190059,13.423357 46.206054,13.446257 46.212734,13.448232 46.216251,13.444043 46.22543,13.482322 46.224829,13.496927 46.221849,13.499408 46.219209,13.497221 46.217512,13.50293 46.21567,13.515465 46.214897,13.52907 46.218904,13.529461 46.212214,13.538915 46.213554,13.561926 46.20422,13.56699 46.185765,13.577893 46.185358,13.592083 46.1931,13.589854 46.188284,13.61272 46.189293,13.611555 46.185523,13.614582 46.184326,13.614582 46.184326,13.633614 46.191791,13.633614 46.191791,13.655316 46.186,13.655316 46.186,13.666694462299349 46.17404321108678,13.666694462299349 46.17404321108678,13.653583 46.16135,13.653583 46.16135)),((13.561725 45.871364,13.549566 45.863289,13.543611 45.867848,13.542118 45.885498,13.550211 45.886547,13.55113 45.892338,13.55693578720093 45.896323588087775,13.55319678783417 45.89894438310121,13.557815551757814 45.908802989642325,13.58694 45.918667,13.58351 45.911068,13.58747 45.912502,13.586429 45.909333,13.611451 45.907432,13.614066 45.907475,13.614066 45.907475,13.608925 45.899212,13.608925 45.899212,13.5961 45.895022,13.5961 45.895022,13.580768 45.871475,13.580768 45.871475,13.561725 45.871364,13.561725 45.871364)),((13.392552 46.269846,13.398423 46.253489,13.409995 46.240004,13.422866 46.234529,13.418513 46.228764,13.411354 46.227377,13.416657 46.222711,13.40911388397217 46.21554116139445,13.387602 46.210682,13.386185 46.215286,13.359216 46.223591,13.359096 46.233696,13.356358 46.22678,13.349795 46.22683,13.352639 46.218907,13.34751 46.215233,13.334362 46.212303,13.329644 46.208069,13.308659 46.206688,13.291527 46.199783,13.285414 46.191303,13.270127177238466 46.19253373054435,13.26616 46.186646,13.258542716503143 46.18541644315133,13.243393 46.195316,13.246063 46.20047,13.244513 46.208843,13.254546 46.216629,13.254851 46.222157,13.271268 46.224606,13.265688 46.240753,13.269791 46.243954,13.255244 46.253117,13.250897 46.252362,13.244629 46.260499,13.23604 46.261276,13.23561 46.264187,13.229911 46.255028,13.21633 46.256516,13.215586 46.251003,13.205261 46.249753,13.202507 46.244339,13.19679 46.242573,13.195663 46.234654,13.191375 46.234101,13.173874 46.239788,13.169875 46.237896,13.169919 46.240902,13.16211 46.242435,13.163467 46.246479,13.158673 46.248237,13.16123 46.257141,13.153329 46.261372,13.162612 46.269737,13.198533 46.28527,13.204235 46.297051,13.226804 46.296593,13.23657 46.302613,13.23994 46.314118,13.246446 46.316982,13.25172 46.3317,13.25484 46.332447,13.253854 46.335274,13.236878 46.339092,13.228683 46.349819,13.232 46.353752,13.23178 46.363404,13.250024 46.377926,13.244515 46.379844,13.247139 46.387195,13.28972 46.388462,13.293949 46.389576,13.298912 46.397335,13.307153 46.396206,13.317037 46.389118,13.339662 46.383758,13.360009 46.383117,13.364619 46.386772,13.37742 46.388417,13.401007 46.381897,13.414903 46.372257,13.482444 46.368999,13.468334 46.360621,13.452241 46.363085,13.438749 46.360005,13.43699 46.354308,13.449448 46.334831,13.448263 46.331132,13.443951 46.330276,13.43848 46.322099,13.425518 46.322521,13.41816 46.318219,13.415368 46.314747,13.418317 46.305822,13.406466 46.305713,13.40288 46.300137,13.375493 46.298233,13.375493 46.298233,13.380007 46.288939,13.380007 46.288939,13.38655 46.290708,13.38655 46.290708,13.392426 46.282443,13.392426 46.282443,13.392552 46.269846,13.392552 46.269846))) | 0.0020 | POINT(13.368877312335709 46.276407425445) |
54120 | POLYGON((5.66545295715338 45.8025779724122,5.65477943420416 45.8072547912597,5.6425838470459 45.8076210021974,5.6425838470459 45.8076210021974,5.65381813049322 45.7845802307129,5.64659690856934 45.7717475891114,5.64659690856934 45.7717475891114,5.6480860710144 45.7633361816406,5.6480860710144 45.7633361816406,5.65639352798456 45.7602119445801,5.65639352798456 45.7602119445801,5.65893936157227 45.7740631103516,5.66252040863043 45.7765007019044,5.66252040863043 45.7765007019044,5.6776146888734 45.7893142700196,5.66714191436768 45.7959442138672,5.66545295715338 45.8025779724122)) | 0.0006 | POINT(5.655631750822086 45.78203558921819) |
64546 | POLYGON((10.4774971008301 48.0952873229982,10.4740524291993 48.0945320129396,10.4753131866455 48.0889663696289,10.4725599288941 48.0886039733888,10.472604751587 48.0854263305665,10.4676942825319 48.0851631164552,10.4680690765381 48.0871582031251,10.466968536377 48.0870780944825,10.4664869308473 48.085620880127,10.462622642517 48.085693359375,10.4612817764283 48.0846939086915,10.4597387313844 48.0858421325684,10.4598331451415 48.0844497680665,10.454574584961 48.0844230651857,10.454574584961 48.0844230651857,10.4541835784913 48.0867042541505,10.4519929885865 48.085720062256,10.4476327896118 48.0899124145508,10.4442644119262 48.0903320312501,10.4445047378541 48.0915794372559,10.4417533874513 48.0920829772949,10.4421138763428 48.0936927795411,10.4389743804932 48.0936012268066,10.4386072158815 48.0974464416504,10.4402799606323 48.1014595031738,10.4414587020873 48.1028327941895,10.4431228637696 48.1025848388672,10.4453763961791 48.1044273376466,10.4450931549073 48.1051101684571,10.4483270645143 48.1057929992675,10.4468898773194 48.1067276000977,10.4463901519776 48.1093902587891,10.4438543319703 48.1091461181641,10.4406404495239 48.113998413086,10.4387474060059 48.1141395568849,10.4360828399659 48.1188774108887,10.4350090026856 48.1192169189454,10.4340982437134 48.1176528930665,10.4269151687622 48.1178016662599,10.4160442352296 48.1159400939941,10.4152746200563 48.1186561584473,10.4152746200563 48.1186561584473,10.4147062301636 48.1214332580566,10.4180240631105 48.1284370422364,10.4158697128297 48.131763458252,10.41685962677 48.1338233947755,10.4278440475464 48.1334953308105,10.4221343994141 48.1358833312989,10.4179725646973 48.1350898742676,10.4142370223999 48.1361122131349,10.4116668701172 48.1393013000489,10.4142990112305 48.139015197754,10.4176416397096 48.1402130126954,10.4145641326904 48.1414604187011,10.4155130386354 48.1437644958496,10.4145889282226 48.1451988220215,10.4179506301879 48.148250579834,10.4170618057252 48.1496887207032,10.4114341735839 48.1490020751953,10.410990715027 48.1499786376953,10.4156455993652 48.1508369445801,10.4254627227784 48.1553115844727,10.4245195388795 48.1566162109376,10.4269104003907 48.1572380065919,10.4264116287231 48.1582984924316,10.4295949935914 48.1594352722168,10.4339466094971 48.1601829528809,10.4376831054688 48.159637451172,10.4374446868896 48.1569671630861,10.445652961731 48.157627105713,10.4457054138184 48.1584358215331,10.4482450485229 48.1588325500488,10.4482450485229 48.1588325500488,10.4488534927369 48.154354095459,10.4514064788818 48.1546630859376,10.4509248733522 48.1525230407714,10.4525442123413 48.1448287963867,10.4515562057496 48.1385002136231,10.456099510193 48.1341323852539,10.45849609375 48.1304092407227,10.4614267349244 48.1225204467773,10.4668922424318 48.1206245422364,10.4675931930543 48.1174621582032,10.4701185226442 48.1149559020996,10.4705801010132 48.1110801696778,10.4737043380738 48.1072731018068,10.4718246459961 48.1041793823242,10.4725103378297 48.101261138916,10.4747343063354 48.0985107421875,10.4794282913208 48.0981025695801,10.4774971008301 48.0952873229982)) | 0.0006 | POINT(10.443047756618968 48.119848759969095) |
47455 | POLYGON((1.60420727729797 50.7990264892579,1.60409605503088 50.8031845092774,1.60921847820288 50.8043365478516,1.61774826049816 50.8010864257813,1.6272102594375 50.8014869689941,1.6272102594375 50.8014869689941,1.63180375099193 50.7997245788575,1.63329303264618 50.7861518859864,1.61459267139435 50.7698135375977,1.60797095298767 50.7463607788087,1.60797095298767 50.7463607788087,1.60102725029003 50.7417602539063,1.59527695178991 50.7490959167481,1.59527695178991 50.7490959167481,1.59527695178991 50.749584197998,1.594895362854 50.749584197998,1.594895362854 50.749584197998,1.59477066993725 50.7497444152833,1.59477066993725 50.7497444152833,1.59361100196844 50.7512512207031,1.59583294391638 50.7515258789064,1.59527695178991 50.7529182434083,1.60027694702148 50.754306793213,1.6008330583573 50.7570838928223,1.60416805744183 50.7634735107422,1.60527801513683 50.7637481689454,1.60638999938976 50.7670822143555,1.60638999938976 50.7695846557618,1.60527801513683 50.7701377868653,1.60638999938976 50.7709732055665,1.60527801513683 50.7715263366699,1.6058340072633 50.7756958007813,1.60416805744183 50.7765274047853,1.6046679019928 50.7818069458008,1.60249900817877 50.7845840454102,1.60305500030523 50.78763961792,1.6058340072633 50.7909736633301,1.6058340072633 50.7951393127443,1.60420727729797 50.7990264892579)) | 0.0006 | POINT(1.6054843977878577 50.77061030739236) |
55499 | POLYGON((6.34911298751842 46.3674049377443,6.34045171737677 46.3562850952148,6.32726860046398 46.352912902832,6.32726860046398 46.352912902832,6.31830692291265 46.3345794677734,6.31830692291265 46.3345794677734,6.32231330871588 46.3330650329591,6.33482742309582 46.3364334106446,6.33482742309582 46.3364334106446,6.34361267089844 46.334758758545,6.35245418548595 46.336986541748,6.36259078979492 46.3477745056153,6.34911298751842 46.3674049377443)) | 0.0006 | POINT(6.335945129394607 46.34367720286053) |
48563 | POLYGON((-0.842939078807831 48.1530990600587,-0.841294765472355 48.1471519470216,-0.847761511802616 48.1394653320312,-0.847761511802616 48.1394653320312,-0.838660895824376 48.1366615295411,-0.835564970970154 48.1268348693848,-0.822437047958374 48.1218910217286,-0.792803645133972 48.1231307983399,-0.792803645133972 48.1231307983399,-0.782491862773895 48.1341438293458,-0.784253656864166 48.1408920288087,-0.777384579181671 48.1498565673829,-0.777384579181671 48.1498565673829,-0.804270505905095 48.1581115722657,-0.829134523868561 48.1567459106446,-0.842939078807831 48.1530990600587)) | 0.0006 | POINT(-0.8144631187120884 48.14002914428718) |