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 |
---|---|---|---|
73203 | POLYGON((9.70706748962414 47.2127914428712,9.72303199768061 47.2044944763184,9.72303199768061 47.2044944763184,9.7460441589356 47.2069892883301,9.7460441589356 47.2069892883301,9.75342464447033 47.2125091552734,9.75342464447033 47.2125091552734,9.7572603225708 47.2337684631348,9.7572603225708 47.2337684631348,9.7468690872193 47.2351989746094,9.7468690872193 47.2351989746094,9.74773406982433 47.223201751709,9.74716758728022 47.2200622558595,9.74394321441662 47.219524383545,9.7297534942627 47.2205619812013,9.7297534942627 47.2205619812013,9.70952606201178 47.2146339416505,9.70952606201178 47.2146339416505,9.70706748962414 47.2127914428712)) | 0.0006 | POINT(9.737651771969306 47.21843846639003) |
60167 | MULTIPOLYGON(((9.96376514434826 46.5731964111328,9.9645347595216 46.5783920288087,9.96105098724365 46.5838623046875,9.95826339721674 46.5860595703126,9.95169639587402 46.5875053405763,9.94650745391846 46.5899429321289,9.94335746765142 46.5936584472657,9.93621826171869 46.5981788635255,9.926423072815 46.5974922180176,9.92232704162609 46.5991783142089,9.92004013061529 46.6069564819336,9.9197244644165 46.6116180419923,9.9179191589356 46.6155548095703,9.90863132476807 46.6237297058107,9.90863132476807 46.6237297058107,9.9005212783814 46.6310119628907,9.9005212783814 46.6310119628907,9.89932346344 46.6260452270508,9.9083013534547 46.614097595215,9.91160297393799 46.6081428527831,9.91301345825207 46.602611541748,9.91074371337896 46.6002082824708,9.90618896484381 46.5978927612306,9.90371704101568 46.5976905822754,9.89984512329113 46.5992813110351,9.89984512329113 46.5992813110351,9.9054965972901 46.5933990478516,9.90995025634766 46.592067718506,9.91962909698486 46.591682434082,9.92917823791515 46.5854568481446,9.93979930877686 46.583667755127,9.94064044952398 46.5819816589357,9.9390926361084 46.5795516967774,9.93943119049078 46.5780868530275,9.95022773742676 46.5726280212403,9.95761871337891 46.5712318420411,9.96376514434826 46.5731964111328)),((9.98998546600347 46.5309448242189,9.99945545196545 46.5227546691895,10.014937400818 46.5270385742188,10.0173492431641 46.5259094238281,10.0208587646486 46.5215606689454,10.0202293395997 46.5190391540528,10.0094985961914 46.5132904052734,10.0055818557739 46.5100364685059,10.0060968399048 46.4972496032715,10.0091981887817 46.4927101135255,10.0076332092286 46.4892196655273,10.0073499679566 46.4832496643066,10.0073499679566 46.4832496643066,9.99679756164551 46.479419708252,9.98775291442877 46.4824295043946,9.9829998016358 46.4826774597168,9.98139190673839 46.4838218688965,9.98139190673839 46.4838218688965,9.98297882080078 46.4870567321777,9.98331546783459 46.4941291809082,9.98487281799328 46.4970893859864,9.98336696624756 46.5032920837402,9.9862756729126 46.5090789794922,9.98344707489014 46.5134277343751,9.98367881774897 46.5163764953614,9.98679733276373 46.5217094421388,9.9839763641358 46.5266952514649,9.98998546600347 46.5309448242189))) | 0.0006 | POINT(9.964520752788342 46.54608357525103) |
22936 | POLYGON((0.291106760501805 44.1328811645507,0.280145257711411 44.1207580566407,0.280145257711411 44.1207580566407,0.271072506904602 44.1100044250489,0.262489378452358 44.1075820922852,0.261707067489681 44.0947570800781,0.261707067489681 44.0947570800781,0.240776360034943 44.0720787048341,0.247029677033424 44.0592651367187,0.232810169458446 44.0460662841798,0.232810169458446 44.0460662841798,0.22996208071703 44.0527648925782,0.207823485136146 44.0652160644531,0.1940192282201 44.0622329711915,0.165930122137013 44.0639953613282,0.165930122137013 44.0639953613282,0.164162322878951 44.0776672363282,0.155571997165794 44.0805702209473,0.154451206326598 44.0939865112305,0.136731222271976 44.1098709106445,0.136731222271976 44.1098709106445,0.131909877061958 44.1189689636231,0.135797336697578 44.1241950988771,0.135797336697578 44.1241950988771,0.169479876756725 44.1227111816407,0.187385559081974 44.127223968506,0.191730409860725 44.13671875,0.215736448764801 44.1360511779785,0.215736448764801 44.1360511779785,0.237996220588684 44.1306457519531,0.251085668802318 44.1405220031739,0.263073951005879 44.1351737976075,0.291106760501805 44.1328811645507)) | 0.0006 | POINT(0.20965130673724458 44.100550055503895) |
63533 | POLYGON((10.6177816390992 53.4161834716797,10.6188640594482 53.4150428771974,10.61891746521 53.4124832153321,10.61891746521 53.4124832153321,10.6569356918336 53.4190788269044,10.6608819961548 53.4162902832032,10.6715488433837 53.4166717529298,10.6818027496339 53.4190826416016,10.6807384490967 53.4128036499024,10.6795816421509 53.4093513488771,10.6780872344971 53.4079246520997,10.6780872344971 53.4079246520997,10.6939191818237 53.4104003906251,10.6999492645264 53.4132843017578,10.6960763931275 53.4184417724609,10.7081222534179 53.4240722656251,10.7076244354249 53.4269409179688,10.7134313583375 53.4266357421874,10.7134313583375 53.4266357421874,10.7139854431152 53.4416236877441,10.7179069519044 53.4462013244629,10.7001876831055 53.4523658752442,10.7057332992554 53.4568786621094,10.7031230926513 53.4587898254395,10.7031230926513 53.4587898254395,10.6969594955445 53.4544219970704,10.6929731369019 53.4551391601563,10.6929731369019 53.4551391601563,10.6807718276978 53.4575843811036,10.6807718276978 53.4575843811036,10.6702213287353 53.4584770202637,10.6597690582275 53.4611740112305,10.6520423889161 53.4614753723145,10.6475582122803 53.4578170776368,10.6430530548096 53.4568519592286,10.6419801712037 53.455738067627,10.6349048614503 53.4560317993164,10.6349048614503 53.4560317993164,10.6347293853761 53.4544563293458,10.6323080062867 53.454803466797,10.6333208084106 53.4523468017579,10.6303215026856 53.4510955810547,10.6295528411865 53.4497642517091,10.6305694580078 53.4487762451172,10.6276321411132 53.4466667175294,10.6279134750367 53.4450492858887,10.6258344650269 53.4433631896973,10.6258344650269 53.4433631896973,10.6261835098267 53.4417228698731,10.628478050232 53.4419288635255,10.6293354034424 53.4409408569335,10.6260528564454 53.4406509399415,10.6244955062867 53.4391098022462,10.6257257461549 53.4376106262207,10.6239309310914 53.4366607666016,10.623607635498 53.4347114562989,10.6253957748413 53.4335899353027,10.6236820220947 53.4331169128419,10.6214056015015 53.4304809570312,10.6218395233155 53.429054260254,10.6207618713379 53.4279136657715,10.6227064132692 53.4258651733398,10.6183662414552 53.4253730773927,10.6201429367065 53.4202575683594,10.6177816390992 53.4161834716797)) | 0.0006 | POINT(10.655433878302613 53.43747687339785) |
22162 | POLYGON((-0.576725304126683 44.4686126708984,-0.558538377285004 44.4703636169435,-0.55169802904129 44.4830665588379,-0.544576942920685 44.4875297546388,-0.544576942920685 44.4875297546388,-0.545247912406865 44.4976196289062,-0.529973387718144 44.5185279846192,-0.525771796703225 44.5317192077637,-0.525771796703225 44.5317192077637,-0.566461980342865 44.546054840088,-0.566461980342865 44.546054840088,-0.601676225662231 44.5528602600098,-0.601676225662231 44.5528602600098,-0.605577647686005 44.5263442993165,-0.611944437026978 44.5175666809082,-0.611944437026978 44.5175666809082,-0.601826310157719 44.4983520507812,-0.583751976490021 44.4936866760254,-0.591108620166779 44.4705848693847,-0.591108620166779 44.4705848693847,-0.576725304126683 44.4686126708984)) | 0.0006 | POINT(-0.5718209475278627 44.508460235595734) |
48724 | POLYGON((-0.0921681895852089 47.9380950927734,-0.111843042075634 47.9508705139161,-0.111843042075634 47.9508705139161,-0.121566765010357 47.942741394043,-0.125883623957634 47.932746887207,-0.128671079874039 47.9297904968262,-0.132680222392025 47.9275550842286,-0.142440408468246 47.9251441955568,-0.147640556097031 47.9249305725099,-0.151887878775483 47.9269523620605,-0.156364545226097 47.9332733154296,-0.156034693121853 47.9437179565431,-0.159888222813549 47.9460754394531,-0.159888222813549 47.9460754394531,-0.177308604121095 47.9421539306641,-0.183095157146454 47.9371719360352,-0.192302197217941 47.9375953674316,-0.192302197217941 47.9375953674316,-0.200171381235066 47.9245109558106,-0.200171381235066 47.9245109558106,-0.195401147007885 47.9187316894532,-0.193192958831787 47.8994102478028,-0.189244225621223 47.8974456787109,-0.189244225621223 47.8974456787109,-0.155353054404202 47.8903656005859,-0.147290691733303 47.894416809082,-0.140815690159741 47.9038124084472,-0.13639318943018 47.905590057373,-0.12669250369072 47.9032707214355,-0.12669250369072 47.9032707214355,-0.119464881718159 47.9117965698243,-0.11799984425295 47.921516418457,-0.104131504893303 47.9249458312989,-0.100557886064053 47.9344177246093,-0.0921681895852089 47.9380950927734)) | 0.0006 | POINT(-0.14960663875233382 47.92437688042138) |
67706 | POLYGON((10.0826177597046 48.5426101684571,10.071120262146 48.5427398681641,10.0705652236938 48.545810699463,10.0663299560547 48.5468482971192,10.066484451294 48.5478286743163,10.063313484192 48.5479965209962,10.0634431838989 48.5516738891602,10.0603942871093 48.5517959594728,10.0598325729371 48.5540161132813,10.0561742782592 48.5541877746583,10.059024810791 48.5624923706056,10.0567493438721 48.5638923645021,10.0567493438721 48.5638923645021,10.0606546401978 48.5710220336915,10.0545663833618 48.5760231018066,10.0539674758912 48.5821990966797,10.0550241470338 48.5822410583497,10.0543336868287 48.5851974487306,10.0573596954347 48.5863037109376,10.0573596954347 48.5863037109376,10.0636777877809 48.5875091552734,10.0731830596925 48.5836486816407,10.0802850723267 48.5833892822266,10.0851230621338 48.5812110900879,10.0908126831055 48.5801467895508,10.0928030014038 48.5787544250489,10.0974969863892 48.5782585144043,10.0999603271485 48.5769233703613,10.1009302139283 48.5741310119629,10.103066444397 48.5735588073731,10.1038722991943 48.5720558166504,10.1038722991943 48.5720558166504,10.1030874252319 48.573314666748,10.1037321090699 48.5656471252443,10.100956916809 48.5654106140138,10.1001129150391 48.5609931945801,10.102279663086 48.5577278137208,10.1020412445069 48.5539207458497,10.1030426025391 48.5524406433107,10.1076154708862 48.5506591796876,10.1099843978882 48.5479812622071,10.0989351272584 48.5410346984864,10.0989351272584 48.5410346984864,10.0826177597046 48.5426101684571)) | 0.0006 | POINT(10.080276067866867 48.565043782078995) |
41241 | POLYGON((6.38384342193604 48.6215171813966,6.38453340530407 48.608253479004,6.38453340530407 48.608253479004,6.40115690231323 48.6089668273926,6.40115690231323 48.6089668273926,6.41425704956055 48.6189270019532,6.4111065864563 48.6251754760743,6.4111065864563 48.6251754760743,6.40362024307251 48.6299285888672,6.38974237442022 48.6255798339844,6.38974237442022 48.6255798339844,6.38384342193604 48.6215171813966)) | 0.0006 | POINT(6.397709022868795 48.61875672773886) |
1388088 | POLYGON((-4.47029590606684 37.9456291198731,-4.46853685379028 37.9567794799805,-4.47286891937256 37.9645195007325,-4.48360395431513 37.9719276428223,-4.49813079833973 37.975856781006,-4.50437402725214 37.9798583984376,-4.50634098052973 37.9836883544922,-4.50198078155518 37.9859466552734,-4.4966611862182 37.9841651916504,-4.48971509933466 37.9914627075195,-4.48215913772583 37.9900703430176,-4.46740913391113 37.9944038391113,-4.46466207504267 37.9942893981934,-4.46032285690302 37.9914169311523,-4.45443820953369 37.9846305847169,-4.45603799819935 37.983699798584,-4.44921684265137 37.976188659668,-4.43749523162842 37.9839820861817,-4.4190411567688 37.9711761474611,-4.41326093673706 37.9553222656251,-4.42455577850336 37.9490394592285,-4.4439268112182 37.9473342895509,-4.46260213851929 37.9484710693361,-4.47029590606684 37.9456291198731)) | 0.0006 | POINT(-4.466418991918115 37.97434168276583) |
32637 | POLYGON((1.2011821269989 47.4371337890626,1.17323791980749 47.4366073608398,1.16714680194866 47.4443550109863,1.16714680194866 47.4443550109863,1.16680514812469 47.4582138061523,1.15535092353826 47.4773864746095,1.15535092353826 47.4773864746095,1.16711342334747 47.4790725708008,1.16711342334747 47.4790725708008,1.21195852756512 47.4923858642579,1.21195852756512 47.4923858642579,1.23523032665253 47.4932823181153,1.23523032665253 47.4932823181153,1.23595130443579 47.4774551391602,1.23595130443579 47.4774551391602,1.23755502700811 47.4650535583497,1.23193895816809 47.4565925598145,1.23193895816809 47.4565925598145,1.21830093860626 47.4491271972657,1.21830093860626 47.4491271972657,1.2011821269989 47.4371337890626)) | 0.0006 | POINT(1.2012381315231775 47.46681613922124) |