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 |
---|---|---|---|
51365 | POLYGON((2.30528402328491 50.0255508422852,2.33472561836254 50.0237731933594,2.33937740325939 50.0187797546387,2.33937740325939 50.0187797546387,2.35318231582642 50.0228500366212,2.36427688598638 50.0342330932617,2.37280654907232 50.0300750732422,2.38684439659119 50.0349769592286,2.38684439659119 50.0349769592286,2.39081406593323 50.0400199890138,2.39081406593323 50.0400199890138,2.3820915222168 50.0485610961914,2.3820915222168 50.0485610961914,2.36383581161505 50.0605773925781,2.34911942482 50.0581817626954,2.34412622451794 50.0678100585938,2.34412622451794 50.0678100585938,2.32564449310314 50.0567512512208,2.32678842544556 50.0504264831544,2.31242060661327 50.0473556518556,2.31242060661327 50.0473556518556,2.29929614067083 50.0341300964355,2.30528402328491 50.0255508422852)) | 0.0006 | POINT(2.350286733020491 50.04143437472262) |
38424 | POLYGON((0.338975757360458 49.5408287048341,0.363722980022487 49.5400390625,0.38063615560543 49.5449104309082,0.38063615560543 49.5449104309082,0.383931934833583 49.5556297302246,0.383931934833583 49.5556297302246,0.369813501834926 49.5643882751465,0.350429832935447 49.5671043395997,0.350429832935447 49.5671043395997,0.345990896224976 49.5620422363282,0.345990896224976 49.5620422363282,0.338124781847114 49.5551185607911,0.338124781847114 49.5551185607911,0.338975757360458 49.5408287048341)) | 0.0006 | POINT(0.3592876493931516 49.55498974139879) |
1409232 | POLYGON((-2.86662411689758 43.2311782836915,-2.87668800354004 43.223445892334,-2.87583994865417 43.2216720581055,-2.87981295585632 43.2178611755371,-2.88658905029291 43.2158584594727,-2.88832306861872 43.2170219421388,-2.89441990852356 43.2151641845704,-2.89873909950256 43.2166709899903,-2.90028405189508 43.2210769653321,-2.89728903770447 43.2219276428223,-2.89786100387573 43.2262153625489,-2.90164709091187 43.2300643920899,-2.90145802497864 43.2329559326173,-2.91385388374323 43.2456703186036,-2.90522098541254 43.2454299926758,-2.90130996704102 43.2413978576661,-2.89564609527588 43.2399711608887,-2.89066410064697 43.2436523437501,-2.88455104827875 43.2452201843262,-2.8765149116515 43.2420158386232,-2.87616205215448 43.2397384643555,-2.87197995185846 43.2374267578125,-2.86662411689758 43.2311782836915)) | 0.0006 | POINT(-2.890067198059749 43.23052891817966) |
42355 | POLYGON((6.72608375549316 49.0976104736329,6.72447872161865 49.100830078125,6.73604822158808 49.11185836792,6.75107192993164 49.1125602722168,6.7601752281189 49.1157493591309,6.7614417076112 49.1190299987793,6.7614417076112 49.1190299987793,6.76643848419195 49.1181526184083,6.77089023590094 49.1120567321778,6.788980960846 49.1061325073242,6.788980960846 49.1061325073242,6.79041290283214 49.1002159118653,6.80310297012335 49.0915718078613,6.80310297012335 49.0915718078613,6.81275320053101 49.0798416137695,6.81275320053101 49.0798416137695,6.78242349624639 49.070770263672,6.78242349624639 49.070770263672,6.76754188537609 49.074131011963,6.76921463012695 49.0879020690918,6.75711202621466 49.094123840332,6.72379493713379 49.088077545166,6.72379493713379 49.088077545166,6.72608375549316 49.0976104736329)) | 0.0006 | POINT(6.768020111581593 49.09721905252211) |
24530 | POLYGON((2.7685227394104 45.6181449890137,2.72831153869635 45.6354980468749,2.72053909301763 45.6317329406739,2.71638441085827 45.6334609985352,2.71413421630865 45.6416931152344,2.71413421630865 45.6416931152344,2.7227196693421 45.6448402404786,2.72356295585632 45.6481933593751,2.72362923622137 45.6683731079102,2.71511006355291 45.6765823364258,2.72008562088013 45.6858863830568,2.72008562088013 45.6858863830568,2.72501873970037 45.6860084533691,2.72501873970037 45.6860084533691,2.73343682289124 45.6774291992189,2.74733257293701 45.6809997558594,2.76072621345526 45.6763343811036,2.76861166954052 45.6429176330567,2.77756094932568 45.6266174316407,2.78679442405712 45.6184349060059,2.78679442405712 45.6184349060059,2.7685227394104 45.6181449890137)) | 0.0006 | POINT(2.7380244731903622 45.65357953026186) |
33601 | POLYGON((4.69237375259411 49.3597373962402,4.67294883728033 49.3452377319337,4.67294883728033 49.3452377319337,4.67332553863525 49.3390274047852,4.66536903381348 49.3312530517579,4.66772937774658 49.325107574463,4.66772937774658 49.325107574463,4.67666721344 49.3203430175781,4.67666721344 49.3203430175781,4.68603801727301 49.3217391967774,4.69256162643433 49.3264694213867,4.71636295318615 49.3302764892578,4.71636295318615 49.3302764892578,4.71977138519298 49.3310127258301,4.71977138519298 49.3310127258301,4.7379612922669 49.3343582153321,4.74151229858398 49.3364372253418,4.73859596252441 49.3389053344727,4.73859596252441 49.3389053344727,4.72894763946533 49.3416900634766,4.72359943389893 49.347583770752,4.70798635482788 49.3482093811036,4.69764852523804 49.3598365783693,4.69237375259411 49.3597373962402)) | 0.0006 | POINT(4.701368477033571 49.33600467184319) |
14614 | POLYGON((13.1177444458008 41.3296928405763,13.0627689361573 41.2873268127442,13.061770439148 41.2860984802246,13.0639686584474 41.2834777832032,13.0639686584474 41.2834777832032,13.0681066513062 41.2731437683105,13.0674266815187 41.2634048461915,13.0699825286865 41.2503890991212,13.0718603134156 41.2453918457031,13.0600252151489 41.2440872192383,13.0532808303834 41.2473564147949,13.0459928512574 41.2492752075196,13.0356950759888 41.2483406066895,13.0356950759888 41.2483406066895,13.0356950759888 41.2506942749023,13.0343065261841 41.2518043518066,13.0334720611572 41.2559738159181,13.0318059921266 41.2576370239258,13.0301380157472 41.2637481689454,13.0181951522828 41.2851371765137,13.0148611068725 41.2890281677247,13.0140266418456 41.2920837402343,13.0106954574585 41.295696258545,13.0084733963014 41.3004150390626,13.0043058395386 41.3048629760742,13.0020837783815 41.3098602294922,12.9987497329712 41.3126373291017,12.9943046569825 41.3198623657227,12.9859733581542 41.3295822143555,12.972915649414 41.3423614501954,12.9693059921265 41.3470840454102,12.9570827484131 41.3573608398438,12.9345827102662 41.3729171752931,12.9156980514527 41.3840293884278,12.9156980514527 41.3840293884278,12.9213237762452 41.3874282836915,12.9488716125489 41.3891181945801,12.970898628235 41.3919067382813,12.9932794570923 41.4092864990235,13.0009794235231 41.4266128540039,13.0009794235231 41.4266128540039,13.0271472930908 41.4120712280273,13.0433702468873 41.4061241149903,13.0526924133302 41.3999404907227,13.0577650070191 41.3938941955566,13.0839462280273 41.3796615600586,13.0956020355225 41.3678817749024,13.1001157760621 41.3557205200196,13.1071090698243 41.3499374389648,13.1177444458008 41.3296928405763)) | 0.0006 | POINT(13.023770137709064 41.321281744509356) |
20465 | POLYGON((7.26992130279552 48.4620971679688,7.28031778335571 48.4620132446289,7.28614568710339 48.4676856994629,7.2819590568543 48.4842758178712,7.29064464569092 48.4925422668458,7.29201650619501 48.4992027282715,7.29201650619501 48.4992027282715,7.30701065063488 48.5010299682618,7.3229484558106 48.5096855163575,7.33312416076654 48.5084495544434,7.33431148529058 48.5051002502442,7.33431148529058 48.5051002502442,7.33696174621582 48.4930458068848,7.33696174621582 48.4930458068848,7.32715082168579 48.4912796020508,7.32061481475824 48.4859771728517,7.32100915908825 48.4662590026857,7.32100915908825 48.4662590026857,7.31586599349976 48.4671363830567,7.29720401763927 48.4609413146972,7.28503608703625 48.4458045959473,7.28503608703625 48.4458045959473,7.2782621383667 48.452579498291,7.2782621383667 48.452579498291,7.26992130279552 48.4620971679688)) | 0.0006 | POINT(7.305337568124173 48.47987906138105) |
73512 | POLYGON((18.7815322875978 45.0068511962891,18.7800979614258 45.0094451904298,18.7867393493653 45.0128707885743,18.8226013183594 45.0161056518555,18.8291778564454 45.0173912048341,18.8322868347169 45.0190010070801,18.8331241607666 45.0217056274413,18.8328552246093 45.0324325561523,18.8274726867676 45.0504150390626,18.8282680511475 45.05375289917,18.8304004669191 45.0554351806642,18.8348217010499 45.0560722351075,18.8404006958008 45.0553207397461,18.8482265472413 45.051513671875,18.8662395477295 45.0466308593751,18.8662395477295 45.0466308593751,18.8705348968507 45.0399398803712,18.8773746490479 45.0190773010255,18.8825302124024 45.0079689025879,18.8822231292724 45.0000495910646,18.8765869140625 44.9882698059082,18.8762092590333 44.981544494629,18.877950668335 44.9786338806153,18.884412765503 44.9742698669435,18.8916416168214 44.9610023498535,18.8956565856935 44.9585800170898,18.9038696289062 44.9561653137208,18.9207687377931 44.9591064453126,18.9275646209718 44.9591636657715,18.9322605133058 44.9578323364258,18.9401950836182 44.9531440734863,18.9445877075196 44.9478073120118,18.947322845459 44.9410896301271,18.9537506103517 44.9357337951661,18.9600124359132 44.9332923889161,18.9790744781494 44.9312477111816,18.9972362518311 44.9266166687013,19.0034561157227 44.923023223877,19.008638381958 44.9150619506837,19.008638381958 44.9150619506837,18.9903316497804 44.9064140319824,19.0331630706788 44.8700523376465,19.0100002288818 44.8644065856935,18.9896697998047 44.8613815307618,18.9122791290283 44.8623123168945,18.9122791290283 44.8623123168945,18.9053287506104 44.8753128051758,18.8984527587892 44.8823204040528,18.8921871185303 44.8858070373535,18.8874759674072 44.8902626037598,18.8766536712648 44.8962516784669,18.8694248199463 44.9078979492188,18.8559589385987 44.9138298034669,18.840841293335 44.9176330566406,18.8232288360596 44.9158592224122,18.8210010528565 44.9134635925292,18.8198776245118 44.9040412902833,18.8099784851075 44.8923873901367,18.8099784851075 44.8923873901367,18.8010330200195 44.8970031738281,18.7905960083008 44.8999214172363,18.7778644561768 44.90824508667,18.7617301940919 44.9164123535157,18.7557201385499 44.9259986877443,18.7596015930176 44.9351501464844,18.7553138732911 44.9427795410156,18.7450218200683 44.9461593627931,18.7499523162842 44.9544067382812,18.7751312255859 44.9473648071289,18.7869262695312 44.9466094970703,18.7959346771241 44.950839996338,18.7900848388673 44.9608840942383,18.782060623169 44.9693794250488,18.7766780853272 44.9767150878906,18.7747631072999 44.9844284057618,18.7800140380861 44.9926338195801,18.7875900268555 44.9975814819337,18.7924194335937 45.0022735595703,18.7815322875978 45.0068511962891)) | 0.0006 | POINT(18.861275990804078 44.95620996524129) |
1388938 | POLYGON((-4.82317876815785 37.0984916687011,-4.82765293121338 37.0917739868164,-4.90823221206665 37.1146774291993,-4.90317487716675 37.1388130187989,-4.91188812255859 37.1441040039063,-4.92454385757441 37.1485862731934,-4.93571615219116 37.1562385559083,-4.94252920150757 37.1576118469238,-4.94134616851807 37.1668624877929,-4.93965911865229 37.167781829834,-4.93946790695185 37.1757240295411,-4.93266487121576 37.1743850708008,-4.92502498626709 37.1706886291504,-4.92178916931147 37.1750297546387,-4.9186840057373 37.1738662719728,-4.91706800460804 37.1749649047852,-4.90770292282099 37.1747627258302,-4.90497779846191 37.1818885803223,-4.90304708480835 37.1776847839355,-4.90389680862421 37.1752510070801,-4.89597511291504 37.1673545837402,-4.89644718170166 37.1632995605469,-4.90016412734974 37.1597328186035,-4.89748191833485 37.1560554504396,-4.88971185684204 37.1550788879396,-4.88074588775629 37.1631622314454,-4.87536478042597 37.1582183837891,-4.85656404495239 37.1735916137695,-4.86004877090454 37.175594329834,-4.85575294494629 37.1782379150391,-4.85669612884521 37.1840744018555,-4.8589391708374 37.1841278076172,-4.85876417160028 37.1907348632813,-4.85356521606434 37.1937141418457,-4.85372877120966 37.1986122131349,-4.846930027008 37.1988639831543,-4.8432240486145 37.2012634277344,-4.82577085494989 37.2007331848145,-4.81908178329468 37.1975250244142,-4.822181224823 37.1957778930665,-4.8192090988158 37.1920814514161,-4.82728910446167 37.1869735717774,-4.82216119766235 37.1798858642578,-4.81446218490601 37.1805992126465,-4.81154918670649 37.1751289367677,-4.80626106262207 37.1711807250977,-4.80396413803101 37.1734886169434,-4.79908180236816 37.1723365783691,-4.80107879638666 37.1605682373046,-4.7961277961731 37.1545715332032,-4.79405212402338 37.1535186767578,-4.79177522659296 37.1543579101563,-4.79099988937378 37.1601562500001,-4.78554010391235 37.1568298339844,-4.82317876815785 37.0984916687011)) | 0.0006 | POINT(-4.8656099019226895 37.168641055071824) |