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 |
---|---|---|---|
22656 | POLYGON((-0.962374806404057 44.0467643737792,-0.9408940076828 44.0432815551758,-0.9408940076828 44.0432815551758,-0.993879735469818 43.9906234741211,-0.993879735469818 43.9906234741211,-1.01283288002014 44.0188751220703,-1.00703346729279 44.0317573547363,-1.0110381841659 44.0416145324706,-0.986013233661652 44.0503311157227,-0.962374806404057 44.0467643737792)) | 0.0006 | POINT(-0.9832044508721971 44.028572506374765) |
35874 | POLYGON((6.73095369338989 47.3369255065919,6.72222805023199 47.3378486633302,6.72222805023199 47.3378486633302,6.72771835327154 47.3537025451661,6.72550487518311 47.3600196838378,6.72550487518311 47.3600196838378,6.73912048339855 47.364315032959,6.73912048339855 47.364315032959,6.74355220794678 47.3582496643068,6.75261306762695 47.3558197021485,6.73933839797968 47.3421440124512,6.73933839797968 47.3421440124512,6.73116493225092 47.339958190918,6.73095369338989 47.3369255065919)) | 0.0006 | POINT(6.733721989851749 47.350254645714436) |
17035 | POLYGON((14.3475999832154 41.664421081543,14.3386039733887 41.6631507873535,14.3185119628907 41.6629066467286,14.3016595840454 41.6596450805664,14.2927322387696 41.6545677185058,14.2927322387696 41.6545677185058,14.2946882247925 41.6447143554689,14.2937517166138 41.6381797790527,14.2833776474 41.6338844299317,14.2833776474 41.6338844299317,14.2854909896852 41.6316719055177,14.2968788146974 41.6255264282227,14.304916381836 41.6226577758789,14.3219623565674 41.6248741149902,14.3259372711182 41.6234817504883,14.3259372711182 41.6234817504883,14.3474998474121 41.6242294311524,14.356658935547 41.6218414306642,14.3696203231813 41.6208686828613,14.3696203231813 41.6208686828613,14.3694553375245 41.6267509460449,14.3694553375245 41.6267509460449,14.367561340332 41.6277198791504,14.3662328720093 41.6308670043945,14.3653736114502 41.648796081543,14.3614082336426 41.6574859619142,14.3598318099976 41.658992767334,14.3598318099976 41.658992767334,14.3475999832154 41.664421081543)) | 0.0006 | POINT(14.331096717289572 41.63877786908834) |
64824 | POLYGON((11.0958452224731 49.176986694336,11.0953102111817 49.1736717224122,11.0960006713868 49.1718063354493,11.0996122360229 49.1687812805176,11.0999650955201 49.1662406921388,11.0987634658815 49.1622467041016,11.0853900909424 49.1588821411134,11.0829086303712 49.1544418334962,11.0808572769164 49.1560173034668,11.0789709091187 49.1553802490234,11.0787010192871 49.1568832397461,11.0737047195434 49.1588325500489,11.0741958618164 49.157497406006,11.0692501068116 49.1532516479492,11.0692501068116 49.1532516479492,11.072338104248 49.1535339355469,11.0723667144776 49.152416229248,11.0699968338013 49.1526641845703,11.0707998275757 49.1497802734374,11.065791130066 49.1495170593262,11.064721107483 49.1482810974122,11.0624513626098 49.1500015258789,11.0623655319215 49.1473579406739,11.0549182891847 49.143653869629,11.0518531799317 49.1406211853028,11.0531301498414 49.1383743286133,11.0562009811402 49.1383590698242,11.0552005767823 49.1396217346191,11.0613403320314 49.1405448913574,11.0638952255249 49.1386070251466,11.0646076202394 49.1409149169922,11.0669670104982 49.1410675048828,11.0677556991578 49.1393547058107,11.0662384033204 49.1397285461427,11.0651874542237 49.1377563476564,11.0684795379639 49.1379203796387,11.068507194519 49.135597229004,11.0679903030396 49.1347808837891,11.0640230178833 49.1343421936036,11.0651464462281 49.1342658996582,11.0653533935548 49.1297149658204,11.0653533935548 49.1297149658204,11.0677471160889 49.1293067932129,11.0704898834229 49.1236534118653,11.0719747543336 49.1240043640137,11.072582244873 49.1232109069824,11.073079109192 49.1223793029786,11.0711917877197 49.1212539672852,11.0798740386964 49.1221923828125,11.0812273025513 49.1184349060059,11.0833530426025 49.1174430847169,11.0775032043457 49.11185836792,11.082242012024 49.1094512939454,11.0803394317627 49.1073036193849,11.08189868927 49.1070518493653,11.0817775726318 49.1061515808107,11.0869998931885 49.106330871582,11.0869398117066 49.1047668457031,11.0897722244263 49.1056251525878,11.0896873474121 49.104305267334,11.0934228897096 49.1028175354004,11.0934228897096 49.1028175354004,11.0955314636231 49.1015663146974,11.0933723449707 49.0997772216798,11.0961694717407 49.0977668762208,11.1081190109254 49.0960540771484,11.1144590377807 49.089382171631,11.1144590377807 49.089382171631,11.1186771392822 49.0893859863281,11.1197423934937 49.0880928039551,11.1223821640014 49.0878448486328,11.1230125427247 49.085792541504,11.1344089508057 49.0867729187012,11.1366147994995 49.0839347839355,11.1401405334473 49.0844192504883,11.1413774490358 49.0858230590821,11.1418657302857 49.0833816528321,11.1463298797608 49.0813331604004,11.1503438949586 49.0814971923828,11.1525068283082 49.0804595947266,11.158299446106 49.0824508666992,11.1585512161256 49.084888458252,11.1600532531739 49.0865707397462,11.1623783111572 49.0863037109375,11.1623783111572 49.0863037109375,11.163348197937 49.0871696472168,11.1610221862792 49.0903396606445,11.1614074707032 49.0934600830079,11.1627969741822 49.0938644409181,11.1628551483154 49.0901412963867,11.166117668152 49.0903282165528,11.1698284149171 49.0922393798828,11.1700353622438 49.0933532714844,11.1678485870361 49.0936813354493,11.1676731109619 49.0946960449219,11.1700668334962 49.0948715209961,11.1697645187379 49.0995178222657,11.167462348938 49.1024017333985,11.1686410903931 49.1044807434081,11.1673650741578 49.1063232421875,11.1720333099366 49.1089591979981,11.1716251373292 49.1101570129396,11.1675462722778 49.1114654541016,11.1681070327759 49.1143951416016,11.169882774353 49.115951538086,11.1675701141357 49.1171607971192,11.1684350967407 49.1192321777345,11.1673288345337 49.1195297241212,11.1681661605834 49.1205940246583,11.1673412322999 49.1214447021485,11.1703519821166 49.1230621337892,11.1706247329712 49.1249580383301,11.1699466705322 49.1264381408691,11.1672763824462 49.1256523132324,11.1657638549805 49.1272811889648,11.1685333251954 49.128345489502,11.1653022766114 49.1296234130859,11.1657752990724 49.1370239257812,11.1607484817505 49.1383399963379,11.1597051620484 49.1412506103516,11.1597051620484 49.1412506103516,11.1512718200685 49.1513023376465,11.150486946106 49.1540870666504,11.1473054885865 49.1582527160646,11.1470460891724 49.1613922119142,11.1508016586303 49.1622352600099,11.1553936004639 49.1569099426271,11.1636743545532 49.1547546386719,11.1637191772462 49.1619720458986,11.1525459289551 49.1643829345704,11.1532220840455 49.165683746338,11.1440906524659 49.163948059082,11.1453504562379 49.1659011840821,11.1412096023559 49.1659965515137,11.1511116027831 49.1678924560548,11.1509456634523 49.1688270568848,11.1541204452515 49.1699867248536,11.1537046432496 49.171443939209,11.157265663147 49.1735496520996,11.1480875015259 49.1745719909669,11.1376132965088 49.1772422790528,11.1376132965088 49.1772422790528,11.1270332336427 49.1792106628419,11.1262245178223 49.1760749816895,11.1114339828492 49.1771545410157,11.1032114028931 49.1757698059083,11.0958452224731 49.176986694336)) | 0.0006 | POINT(11.118567728016508 49.128335456325594) |
64044 | POLYGON((14.4709539413452 51.6062316894532,14.4892807006836 51.6000366210938,14.4936189651489 51.6065864562988,14.5172672271729 51.6190605163575,14.5253334045411 51.6245346069337,14.5393581390382 51.6409721374512,14.5395488739015 51.6445541381837,14.5380067825317 51.6480140686036,14.5380067825317 51.6480140686036,14.5344085693361 51.64847946167,14.5212535858154 51.6538543701172,14.5101871490479 51.6538543701172,14.5101871490479 51.6538543701172,14.5010967254639 51.6530914306641,14.4901294708252 51.6505699157716,14.485034942627 51.6517677307129,14.4683656692506 51.6459426879883,14.4708490371704 51.6428565979004,14.4607067108155 51.6414070129396,14.4614009857178 51.6389312744141,14.4633531570435 51.6370735168457,14.4604225158691 51.6318206787109,14.4635782241821 51.6253089904786,14.4598627090455 51.6260299682618,14.4565658569337 51.6213836669922,14.4565658569337 51.6213836669922,14.4640712738037 51.6193122863771,14.4642972946168 51.6174011230469,14.4689874649048 51.6155853271486,14.4674034118653 51.6133422851562,14.4688663482667 51.6078529357911,14.4709539413452 51.6062316894532)) | 0.0006 | POINT(14.488998997596049 51.632551870038476) |
28010 | POLYGON((4.58034181594854 47.1113967895507,4.57527542114263 47.0919532775879,4.56668615341198 47.0840377807618,4.56668615341198 47.0840377807618,4.5491824150086 47.0878295898438,4.5396609306336 47.0983734130861,4.5396609306336 47.0983734130861,4.54424190521246 47.1045265197754,4.54089403152466 47.1110572814943,4.54379796981823 47.113899230957,4.55796480178833 47.117561340332,4.57025861740118 47.1120910644532,4.58034181594854 47.1113967895507)) | 0.0006 | POINT(4.556220928827982 47.101261456807514) |
22741 | POLYGON((0.865184605121613 44.2245941162111,0.840867638588065 44.2160224914551,0.83909201622015 44.2255058288574,0.83909201622015 44.2255058288574,0.820350944995994 44.2508239746094,0.820350944995994 44.2508239746094,0.830010712146816 44.2619400024415,0.843383371830043 44.2635078430176,0.843383371830043 44.2635078430176,0.857916951179448 44.24861907959,0.857916951179448 44.24861907959,0.857083678245601 44.242156982422,0.865872323513145 44.2396087646485,0.88548839092266 44.2482986450195,0.902680933475494 44.2437400817872,0.902680933475494 44.2437400817872,0.893839001655692 44.2410049438478,0.881891846656913 44.2302131652833,0.865184605121613 44.2245941162111)) | 0.0006 | POINT(0.8581714795695979 44.24267959594734) |
54756 | POLYGON((4.5848016738891 45.2440757751465,4.60531520843517 45.2533988952637,4.60530471801758 45.2636680603027,4.60530471801758 45.2636680603027,4.62807655334484 45.2521362304688,4.65951108932506 45.2681350708007,4.66858005523682 45.2656059265137,4.67761230468761 45.257625579834,4.68249368667597 45.257553100586,4.68249368667597 45.257553100586,4.68106985092163 45.2543029785157,4.69239139556885 45.2483711242677,4.69762420654303 45.2351417541504,4.69762420654303 45.2351417541504,4.69177722930908 45.2306442260743,4.6902003288269 45.2215194702149,4.6902003288269 45.2215194702149,4.66273641586298 45.2334518432617,4.65698051452648 45.2387771606445,4.63933277130133 45.2351303100587,4.62559461593634 45.2374114990236,4.61631155014044 45.2355461120606,4.61631155014044 45.2355461120606,4.60911512374878 45.2428016662598,4.60228443145752 45.2384567260743,4.58960390090942 45.2416915893555,4.58960390090942 45.2416915893555,4.5848016738891 45.2440757751465)) | 0.0006 | POINT(4.646231704288085 45.244835747612875) |
71627 | POLYGON((15.7360563278199 48.3872833251953,15.7195959091187 48.3962593078614,15.7394227981569 48.4012908935548,15.7394227981569 48.4012908935548,15.740219116211 48.4033813476564,15.7397804260255 48.4052429199219,15.7368268966675 48.4079208374024,15.715274810791 48.4154319763184,15.7114086151124 48.4177055358887,15.7110357284547 48.4201622009277,15.7146768569947 48.4275360107422,15.7152090072632 48.4309692382812,15.7136363983155 48.4350204467774,15.7074184417726 48.4441757202149,15.7074184417726 48.4441757202149,15.6681146621705 48.4484748840333,15.6681146621705 48.4484748840333,15.6798286437989 48.4345855712891,15.6822233200073 48.4304351806641,15.6815900802613 48.4258041381836,15.6767520904542 48.4113502502441,15.6767520904542 48.4113502502441,15.6797294616699 48.3986320495605,15.6829824447632 48.3938980102538,15.6903381347656 48.3913574218751,15.7305221557618 48.3821144104005,15.7305221557618 48.3821144104005,15.7360563278199 48.3872833251953)) | 0.0006 | POINT(15.707217499061937 48.41468288280348) |
71053 | POLYGON((11.2097005844117 50.9563179016114,11.2042675018311 50.9552955627442,11.2007761001588 50.9619369506837,11.2017650604248 50.9642181396486,11.2002124786378 50.9689407348633,11.1875133514405 50.9678039550782,11.1805686950684 50.9694252014161,11.180597305298 50.9665565490723,11.1769342422486 50.9674606323243,11.1769342422486 50.9674606323243,11.1777019500732 50.9604225158692,11.1790351867676 50.958106994629,11.1809587478638 50.9581489562989,11.1851320266724 50.9522857666016,11.1885051727296 50.9530563354492,11.1933593749999 50.9471092224122,11.1950120925903 50.9470977783203,11.1976108551025 50.9447174072266,11.2002744674684 50.9381217956544,11.1965484619142 50.9356079101564,11.1921844482423 50.9342231750488,11.1921453475953 50.9315948486329,11.1963205337525 50.922290802002,11.1963205337525 50.922290802002,11.197904586792 50.923469543457,11.1968870162964 50.926815032959,11.2074985504152 50.928092956543,11.2074985504152 50.928092956543,11.205955505371 50.9333724975586,11.201907157898 50.9415321350098,11.2067298889161 50.9421234130859,11.212522506714 50.9288711547852,11.212522506714 50.9288711547852,11.2207593917847 50.9302940368653,11.2207593917847 50.9302940368653,11.2179164886474 50.9425506591797,11.2152833938599 50.9454383850099,11.2127161026001 50.9452362060547,11.2117490768432 50.946258544922,11.2124490737914 50.9472885131836,11.2147827148438 50.947193145752,11.2127838134767 50.950553894043,11.2108058929444 50.9507102966309,11.2086105346679 50.9553527832032,11.2098817825317 50.955394744873,11.2097005844117 50.9563179016114)) | 0.0006 | POINT(11.200184504191125 50.94618437025286) |