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 |
---|---|---|---|
67604 | POLYGON((9.59676647186291 47.6351242065431,9.59459400177002 47.6339454650879,9.59560966491705 47.6329383850099,9.59404182434093 47.6307334899902,9.59634876251226 47.6288757324219,9.59418106079102 47.6267013549805,9.5925989151001 47.6223373413087,9.58533573150635 47.6197967529297,9.5837192535401 47.6130256652833,9.5697927474975 47.6044425964356,9.55523490905773 47.5867042541504,9.55523490905773 47.5867042541504,9.55395698547369 47.5875434875489,9.55595207214361 47.5901756286622,9.55344581604015 47.590660095215,9.5540571212768 47.5892791748047,9.55325317382812 47.5882148742676,9.55133342742926 47.5895538330079,9.55007076263433 47.5886421203614,9.55312061309826 47.5875015258789,9.55097198486328 47.5873374938966,9.54266357421881 47.5946006774903,9.53664970397949 47.5971450805665,9.53322410583496 47.6018142700195,9.52999877929688 47.6030044555665,9.52777004241949 47.606876373291,9.52818012237543 47.6090126037598,9.52653598785412 47.6135978698731,9.5274591445924 47.6153411865234,9.5274591445924 47.6153411865234,9.53003597259527 47.6160812377929,9.53219890594482 47.6148872375488,9.52975463867199 47.6134910583497,9.53120517730719 47.6119956970215,9.53600120544445 47.614112854004,9.53753757476812 47.6157608032227,9.53682136535656 47.6184425354005,9.54161071777344 47.6223487854004,9.54809284210211 47.6163139343263,9.56519603729248 47.6418495178223,9.56519603729248 47.6418495178223,9.58407402038569 47.6385726928712,9.5881032943725 47.6421051025391,9.59676647186291 47.6351242065431)) | 0.0006 | POINT(9.55570671170261 47.61127400952721) |
50947 | POLYGON((1.97735977172852 50.1937141418458,1.96020877361309 50.1984939575195,1.95888841152197 50.201473236084,1.95888841152197 50.201473236084,1.9714896678924 50.2155075073243,1.97156953811646 50.2219200134278,1.98681282997137 50.2302894592286,1.98681282997137 50.2302894592286,1.99531900882721 50.2340850830079,1.99915730953222 50.2318534851075,2.00524330139166 50.2227783203126,2.00242614746088 50.216567993164,2.01201868057257 50.2141342163086,2.01201868057257 50.2141342163086,2.00909161567688 50.2027931213379,2.00909161567688 50.2027931213379,2.00040721893311 50.2011528015138,1.99164521694195 50.1942901611328,1.99164521694195 50.1942901611328,1.97735977172852 50.1937141418458)) | 0.0006 | POINT(1.9894786445718438 50.211685983758265) |
1404968 | POLYGON((-3.80006909370422 40.1757049560546,-3.79557394981379 40.1890678405762,-3.79436588287354 40.1903495788574,-3.7911660671233 40.189998626709,-3.79007911682118 40.1954307556153,-3.78628396987915 40.1944236755372,-3.78580808639521 40.1968574523926,-3.7830638885498 40.1972885131836,-3.78307104110712 40.2020645141602,-3.78131389617914 40.2034568786621,-3.7776050567627 40.2029838562012,-3.77958798408503 40.2097816467285,-3.77528500556946 40.208667755127,-3.77404308319086 40.2099189758302,-3.76506590843201 40.2069244384766,-3.75911498069757 40.2075233459473,-3.75595808029169 40.21089553833,-3.7450749874115 40.2012519836426,-3.73979496955866 40.2049789428712,-3.73685503005981 40.2113227844238,-3.73324704170221 40.2111854553223,-3.71394896507263 40.2055587768555,-3.69984102249146 40.1990928649902,-3.7086820602417 40.1792182922364,-3.69940090179438 40.1652870178224,-3.69986200332636 40.1610565185547,-3.71332192420959 40.1467475891114,-3.71805191040039 40.1465377807617,-3.72056794166565 40.1479644775391,-3.72357392311096 40.1471176147461,-3.74502992629994 40.1326560974122,-3.7717781066894 40.1395874023438,-3.77233409881586 40.1420974731446,-3.77812504768366 40.1475830078126,-3.77889990806574 40.1558303833009,-3.78421497344965 40.1627159118653,-3.80006909370422 40.1757049560546)) | 0.0006 | POINT(-3.7572238842645924 40.18330913119849) |
44104 | POLYGON((-0.158874213695469 43.8460197448731,-0.167769521474838 43.848445892334,-0.167769521474838 43.848445892334,-0.185723334550858 43.8668899536133,-0.185723334550858 43.8668899536133,-0.193995684385243 43.8816871643067,-0.201230615377426 43.885467529297,-0.201230615377426 43.885467529297,-0.192261561751309 43.8847465515137,-0.192261561751309 43.8847465515137,-0.168750733137131 43.8872146606445,-0.135003432631493 43.8672790527344,-0.135003432631493 43.8672790527344,-0.137564986944142 43.8592948913574,-0.137564986944142 43.8592948913574,-0.146511524915695 43.8596954345704,-0.158874213695469 43.8460197448731)) | 0.0006 | POINT(-0.16920244134960435 43.868679046630895) |
1397228 | POLYGON((-1.8994270563125 40.9321098327637,-1.90702295303339 40.9325256347657,-1.91506600379932 40.9258537292481,-1.91408205032349 40.9235649108887,-1.92390704154968 40.9189491271973,-1.9398449659347 40.9218864440919,-1.95183801651001 40.9256629943848,-1.95888304710388 40.9317016601563,-1.95998096466064 40.9312324523926,-1.96366202831268 40.9351844787598,-1.96159505844116 40.9495849609375,-1.96148097515106 40.959846496582,-1.9519469738006 40.9638862609864,-1.92201805114735 40.9708786010742,-1.91937398910522 40.9660987854004,-1.91014301776886 40.9587326049805,-1.90506100654596 40.9498405456543,-1.89154601097096 40.9388732910156,-1.88384199142456 40.9378242492676,-1.88415205478657 40.933494567871,-1.88899099826813 40.9319038391113,-1.8994270563125 40.9321098327637)) | 0.0006 | POINT(-1.9244697264262243 40.939982641310934) |
54708 | POLYGON((4.53600406646729 44.787784576416,4.51463127136236 44.7792358398439,4.51463127136236 44.7792358398439,4.5210075378418 44.7644348144531,4.51251029968262 44.7577133178712,4.51251029968262 44.7577133178712,4.51310300827026 44.742172241211,4.5309853553772 44.7413864135742,4.5309853553772 44.7413864135742,4.55574417114258 44.7480659484864,4.55574417114258 44.7480659484864,4.5475573539735 44.7600593566896,4.53192996978771 44.772388458252,4.53851747512823 44.7849006652833,4.53600406646729 44.787784576416)) | 0.0006 | POINT(4.529704400471308 44.76175308227546) |
19118 | POLYGON((10.8071460723878 42.9610824584962,10.824013710022 42.9597854614258,10.8418483734131 42.9637603759766,10.8545379638672 42.9641571044922,10.8545379638672 42.9641571044922,10.8495502471924 42.9527854919434,10.8466596603395 42.9504203796386,10.8472042083741 42.9460601806641,10.8578701019287 42.9367752075196,10.8665952682496 42.9327087402344,10.8731470108032 42.9248924255371,10.8769359588623 42.9185371398927,10.8892517089844 42.9062042236329,10.8826341629028 42.8839454650879,10.8848133087158 42.8754806518555,10.8896484375001 42.8690376281738,10.8896484375001 42.8690376281738,10.8882083892823 42.8667907714843,10.8800973892212 42.8625221252441,10.8405046463013 42.8515777587891,10.7751379013062 42.8444747924804,10.7751379013062 42.8444747924804,10.7751379013062 42.8490295410157,10.7712497711182 42.8512496948243,10.7720842361451 42.8529167175294,10.7740278244019 42.8534736633302,10.7740278244019 42.8576393127442,10.7726383209228 42.8587493896486,10.767915725708 42.8595848083497,10.7712497711182 42.8654174804689,10.7711915969848 42.8668060302734,10.7695837020874 42.8673629760742,10.7687501907349 42.8690261840821,10.7720842361451 42.8723716735841,10.7723598480224 42.8737487792969,10.7734718322754 42.8737487792969,10.776526451111 42.8768043518066,10.776526451111 42.8801383972169,10.7787513732911 42.8806953430176,10.7804174423218 42.8837509155275,10.7843046188354 42.8845825195312,10.7851390838622 42.8854179382324,10.7848606109619 42.8870849609376,10.7862491607666 42.8884735107423,10.7848606109619 42.8943061828614,10.7806949615479 42.9009704589844,10.7748603820801 42.9081954956055,10.7718057632447 42.910587310791,10.7718057632447 42.910587310791,10.791820526123 42.9268455505372,10.80149269104 42.9383544921875,10.8071460723878 42.9610824584962)) | 0.0006 | POINT(10.810412107729476 42.89365858190204) |
58665 | POLYGON((7.70979261398321 52.1368484497071,7.70792722702026 52.1305770874025,7.70987129211426 52.1099739074708,7.71150159835821 52.1098518371583,7.71468782424932 52.113426208496,7.71921300888062 52.1102104187012,7.73184967041027 52.1061935424805,7.73519897460938 52.1022720336915,7.73846483230602 52.1004600524903,7.7467560768128 52.0984230041505,7.7510976791383 52.0995216369629,7.75574016571051 52.0983047485353,7.75574016571051 52.0983047485353,7.76080942153931 52.0970039367676,7.79546499252325 52.1040802001953,7.79868841171259 52.1037254333497,7.8164634704591 52.0938148498536,7.83019113540644 52.0934638977052,7.84992647171032 52.0945701599122,7.84992647171032 52.0945701599122,7.84900045394897 52.1009063720704,7.83728313446045 52.1039924621582,7.83902549743664 52.1087379455568,7.84220123291016 52.1123046875,7.84390211105358 52.1160545349121,7.84390211105358 52.1160545349121,7.81428241729736 52.1271286010743,7.81542062759405 52.1276588439941,7.81508636474609 52.1288719177247,7.80819749832159 52.1303520202637,7.80007028579712 52.1373863220215,7.79136657714855 52.1366577148439,7.78507661819469 52.1376533508301,7.78141975402832 52.1393394470215,7.78196954727179 52.1414108276368,7.78131532669062 52.1430282592773,7.78477573394775 52.1480102539062,7.7775182723999 52.15336227417,7.77940845489508 52.1546401977539,7.77784872055054 52.1580848693848,7.77578973770142 52.1599578857421,7.77105474472046 52.1598777770996,7.75898742675776 52.1665458679199,7.75776195526123 52.1706619262695,7.7497377395631 52.1710510253906,7.75318574905401 52.1742897033692,7.75169706344616 52.1754188537598,7.74447107315063 52.1750793457031,7.74415683746338 52.172077178955,7.72265243530268 52.1780204772949,7.72265243530268 52.1780204772949,7.71591758728033 52.1777839660646,7.71549558639521 52.1784591674804,7.70050764083857 52.176254272461,7.70050764083857 52.176254272461,7.71296358108526 52.153045654297,7.71264505386364 52.1458740234375,7.70979261398321 52.1368484497071)) | 0.0006 | POINT(7.769273097055033 52.133436905710354) |
20779 | POLYGON((7.50645923614508 48.7965774536133,7.51140069961548 48.791130065918,7.51140069961548 48.791130065918,7.51221942901617 48.7805862426758,7.51221942901617 48.7805862426758,7.50411605834961 48.7794075012208,7.50411605834961 48.7794075012208,7.49147176742565 48.7837371826173,7.49147176742565 48.7837371826173,7.48949766159058 48.7866134643556,7.49485826492315 48.7951850891114,7.48714351654064 48.8031349182129,7.48714351654064 48.8031349182129,7.4922389984132 48.8052940368653,7.4922389984132 48.8052940368653,7.50645923614508 48.7965774536133)) | 0.0006 | POINT(7.499199740092021 48.79099706014004) |
66198 | POLYGON((12.6912260055543 49.1358108520509,12.6875886917115 49.1369552612306,12.6831912994386 49.1400909423828,12.6826124191285 49.1430511474611,12.6790046691895 49.1433486938477,12.6770420074463 49.1460494995118,12.6836452484131 49.1476860046387,12.6816215515137 49.1493530273439,12.6803541183473 49.1489181518555,12.6793632507325 49.1515922546386,12.6769552230836 49.152027130127,12.6706609725953 49.1575660705566,12.6715087890626 49.1581268310548,12.6693143844606 49.1602745056153,12.6718845367432 49.1615829467775,12.6730251312255 49.1604080200196,12.6753549575807 49.1655197143555,12.6578683853149 49.1743164062501,12.659507751465 49.1805839538574,12.6634740829469 49.1827125549316,12.6632652282714 49.1835632324219,12.6600360870361 49.1841011047364,12.6595449447632 49.1829299926759,12.6511154174806 49.1856956481935,12.6487798690797 49.185028076172,12.6487798690797 49.185028076172,12.6479969024658 49.1831817626953,12.642560005188 49.1794586181641,12.6416625976562 49.1768684387208,12.6373119354249 49.1774826049805,12.637360572815 49.1754913330079,12.6329307556152 49.1746406555177,12.6298017501832 49.1724777221679,12.6238203048706 49.1731567382813,12.6237030029297 49.1718521118165,12.6207809448243 49.1696319580078,12.627366065979 49.1633186340333,12.6265811920165 49.1626205444336,12.6279411315919 49.1576728820802,12.6254034042358 49.1564445495606,12.6292915344239 49.1559486389161,12.629626274109 49.151424407959,12.6343116760254 49.1478691101075,12.6376447677613 49.1466178894044,12.6397733688354 49.1442108154298,12.6392707824707 49.1430702209473,12.6322708129882 49.1414108276367,12.6313543319702 49.1405372619628,12.6331748962402 49.1395416259766,12.6309461593629 49.137523651123,12.6280241012574 49.1387481689453,12.6274919509888 49.1378669738769,12.6255073547363 49.1379585266114,12.621590614319 49.1306114196777,12.6169004440308 49.1305923461915,12.6152811050416 49.1296234130859,12.6135864257812 49.1306877136231,12.6142711639405 49.1325378417969,12.6058235168458 49.1344261169433,12.6029205322266 49.1332473754883,12.60200214386 49.1310691833497,12.6028728485107 49.1296577453613,12.6024990081787 49.1267242431641,12.6008853912354 49.1246299743653,12.5960559844972 49.1242446899414,12.5960559844972 49.1242446899414,12.590392112732 49.1220664978027,12.5882844924928 49.1224250793457,12.5881881713868 49.1207923889161,12.580828666687 49.1218185424805,12.5771322250366 49.1190719604492,12.5794725418091 49.118019104004,12.5814771652222 49.1130065917969,12.5876760482788 49.1105422973633,12.5821294784546 49.1017646789552,12.583028793335 49.1006774902344,12.5844440460205 49.1010818481446,12.5840015411378 49.1019439697266,12.5887498855591 49.1021003723145,12.5896968841553 49.100227355957,12.5891275405885 49.0991134643555,12.5891275405885 49.0991134643555,12.5917444229127 49.0984725952148,12.5942592620849 49.100528717041,12.6014060974122 49.101963043213,12.6019201278686 49.1011695861817,12.5984764099121 49.0992012023926,12.6016654968262 49.0978546142579,12.6069030761718 49.0994758605958,12.6097259521486 49.09761428833,12.6132469177247 49.0991554260254,12.6158933639528 49.0988731384278,12.6166515350342 49.0967903137208,12.6182203292846 49.0956993103028,12.6182203292846 49.0956993103028,12.6194849014283 49.0976638793946,12.6221218109131 49.0987205505372,12.6215400695801 49.1017074584962,12.6203718185425 49.1028747558594,12.6221408843995 49.1047668457031,12.6259994506836 49.1049423217775,12.6291437149048 49.1022834777833,12.6312141418456 49.1019935607911,12.6357374191285 49.1032562255859,12.6426515579225 49.1030960083008,12.6425437927247 49.1006774902344,12.6490688323975 49.1001052856446,12.6527967453003 49.1056289672852,12.6508827209473 49.1060523986816,12.652533531189 49.10746383667,12.6507425308229 49.1096649169922,12.6529903411866 49.1099700927734,12.6672105789185 49.1067619323732,12.6773099899293 49.1015663146974,12.6831169128418 49.1020812988282,12.6823768615723 49.1029853820801,12.6837415695191 49.1034278869629,12.6857290267945 49.1014213562013,12.6857290267945 49.1014213562013,12.6957483291627 49.1031837463379,12.6958255767822 49.1048851013184,12.6978645324708 49.1054191589357,12.7002229690552 49.1045341491699,12.7063179016114 49.1044502258302,12.7030639648438 49.1070365905762,12.7059707641602 49.1085624694825,12.708342552185 49.1085777282715,12.7126960754395 49.1114425659179,12.7126960754395 49.1114425659179,12.714550971985 49.1139259338379,12.7127485275269 49.1131782531739,12.7085685729981 49.1142501831056,12.7018690109253 49.1204948425294,12.7007102966309 49.1239547729493,12.6980915069581 49.1254653930665,12.6965198516846 49.1249732971192,12.6944227218628 49.1273880004883,12.6929922103882 49.1273002624512,12.6912260055543 49.1358108520509)) | 0.0006 | POINT(12.642028041507922 49.12912249910661) |