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 |
---|---|---|---|
12586 | POLYGON((13.5847549438478 42.6318054199218,13.5868034362792 42.6356124877929,13.5897903442383 42.6367225646973,13.6082973480225 42.6366386413575,13.6392240524291 42.6343727111816,13.6500854492188 42.6432571411133,13.6512622833252 42.6456375122071,13.6510887145996 42.6479721069337,13.676685333252 42.6529960632325,13.6758403778077 42.6635208129883,13.6674880981446 42.6678009033204,13.6639556884765 42.6674995422364,13.6596336364747 42.6641998291017,13.6515130996705 42.665641784668,13.6299505233766 42.6839332580568,13.60622215271 42.6977539062501,13.6102876663207 42.7004318237306,13.6102876663207 42.7004318237306,13.6200513839722 42.705005645752,13.6267566680909 42.7065544128419,13.630093574524 42.7001686096193,13.6400470733643 42.6990318298339,13.6490230560302 42.6994705200196,13.6525306701661 42.7037734985352,13.6520881652832 42.7046775817872,13.658172607422 42.7082786560059,13.6763639450074 42.7065734863281,13.6765727996827 42.7037200927734,13.6786365509034 42.7030868530275,13.7113809585572 42.7096710205078,13.7258234024048 42.7133712768555,13.7325191497804 42.7161941528321,13.7465219497682 42.712745666504,13.7643918991089 42.7143287658691,13.7699947357178 42.7169189453125,13.7720956802369 42.719337463379,13.7720956802369 42.719337463379,13.7742910385132 42.715721130371,13.7797384262085 42.7151489257812,13.7839164733887 42.7171745300293,13.7909736633301 42.7182388305664,13.8107700347901 42.7124481201173,13.8195199966431 42.7088661193848,13.8209934234619 42.7065505981446,13.8280363082887 42.7024421691896,13.8280363082887 42.7024421691896,13.8052453994752 42.6937065124512,13.7981081008912 42.6928138732911,13.7981081008912 42.6928138732911,13.7869997024537 42.6884002685548,13.7804231643676 42.6882858276367,13.7763099670411 42.6838645935059,13.7752742767335 42.6807212829589,13.7769899368286 42.6795234680177,13.7843742370607 42.6784629821777,13.7931756973267 42.6745262145997,13.7944622039795 42.6683425903321,13.7935934066774 42.6661987304688,13.7880458831788 42.6628456115723,13.7859411239625 42.6574821472168,13.7863683700561 42.6418075561524,13.7922077178955 42.6337203979492,13.8007221221925 42.6247634887695,13.8056011199952 42.6221351623536,13.8056011199952 42.6221351623536,13.7950420379639 42.6170806884767,13.779170036316 42.6138725280762,13.7761821746827 42.6120300292969,13.7761821746827 42.6120300292969,13.7714452743531 42.6092491149902,13.7671194076538 42.6091651916505,13.7517404556274 42.6131248474122,13.7517404556274 42.6131248474122,13.7318897247314 42.6186141967775,13.7190542221069 42.6161041259767,13.7082567214966 42.6081848144531,13.7075366973877 42.6005210876465,13.7120456695558 42.6000595092774,13.7120456695558 42.6000595092774,13.7077589035034 42.5975532531739,13.6899032592773 42.5950965881348,13.6354894638063 42.6205978393555,13.6252117156982 42.6170501708985,13.6214866638185 42.6130256652832,13.6180210113525 42.6115646362306,13.6060743331909 42.6104354858398,13.5966577529907 42.6112060546874,13.582278251648 42.6084327697753,13.582278251648 42.6084327697753,13.5843572616578 42.6160125732422,13.5836954116821 42.6296424865723,13.5847549438478 42.6318054199218)) | 0.0006 | POINT(13.7112617702275 42.662333268385694) |
16493 | POLYGON((9.50255393981939 46.085090637207,9.50478458404552 46.0928726196288,9.50478458404552 46.0928726196288,9.50374507904058 46.099464416504,9.50075435638422 46.1034469604493,9.50135707855225 46.1199798583984,9.49081516265875 46.1413917541505,9.49081516265875 46.1413917541505,9.48128986358643 46.1474685668945,9.48128986358643 46.1474685668945,9.47878932952892 46.1383018493653,9.48183917999268 46.1302413940431,9.48358345031744 46.1150703430177,9.48661041259777 46.1031417846681,9.48889446258545 46.1010627746583,9.47852039337164 46.0907096862793,9.47021293640131 46.0873603820801,9.47021293640131 46.0873603820801,9.45774459838879 46.0782699584962,9.45774459838879 46.0782699584962,9.47634887695324 46.0729713439941,9.49393081665045 46.0717506408693,9.49393081665045 46.0717506408693,9.50255393981939 46.085090637207)) | 0.0006 | POINT(9.48611097750461 46.104248212731456) |
58317 | POLYGON((7.9951167106629 49.4861145019531,7.99248838424683 49.4859123229982,7.98115348815912 49.4805030822754,7.97476434707647 49.4798393249513,7.96217918396002 49.4748840332032,7.95226287841797 49.4740753173828,7.95226287841797 49.4740753173828,7.95117807388306 49.4786224365234,7.95234632492065 49.4836730957032,7.95106315612793 49.48441696167,7.95106315612793 49.48441696167,7.94960165023809 49.4856643676757,7.95515727996826 49.4884986877441,7.96390867233282 49.4899635314941,7.96390867233282 49.4899635314941,7.97084236145025 49.4894905090333,7.97292947769165 49.4934082031251,7.99007081985479 49.4927635192872,7.99485254287731 49.4943389892579,7.99901199340832 49.4969749450685,8.00812339782721 49.4979515075685,8.01454162597668 49.5023803710938,8.01467323303223 49.5072975158693,8.02107334136957 49.5136909484864,8.02107334136957 49.5136909484864,8.03038597106934 49.5183334350586,8.03294563293457 49.5156097412109,8.03868675231939 49.5174255371094,8.03703594207769 49.5204772949219,8.04439449310308 49.5233840942384,8.04427337646496 49.5241355895996,8.04427337646496 49.5241355895996,8.04590988159191 49.5240898132325,8.06332015991211 49.531047821045,8.06927108764648 49.5307006835938,8.07835197448736 49.5324249267578,8.07938098907471 49.5309524536133,8.08375740051275 49.5321884155275,8.0873174667359 49.5276756286622,8.08954906463634 49.5281181335449,8.08954906463634 49.5281181335449,8.09153175354004 49.5258293151855,8.09125518798822 49.5233497619629,8.08157253265387 49.5190544128419,8.08157253265387 49.5190544128419,8.06973552703869 49.5142021179199,8.06973552703869 49.5142021179199,8.06437969207775 49.5162200927734,8.05805397033703 49.5163803100585,8.04988670349127 49.5122604370118,8.05095386505127 49.5149116516114,8.04922294616711 49.5146942138672,8.03336429595953 49.5066986083984,8.0305385589599 49.5037231445313,8.0276393890382 49.5035209655762,8.02222728729259 49.5013542175294,8.01700210571289 49.5010299682618,8.01328849792486 49.4977607727052,8.00395965576172 49.4940528869629,8.00324058532726 49.4926109313966,8.00393199920666 49.4892807006837,8.00393199920666 49.4892807006837,7.9951167106629 49.4861145019531)) | 0.0006 | POINT(8.02146893931978 49.50517580586098) |
51318 | POLYGON((1.94406092166912 49.7479057312012,1.94759106636053 49.7387619018556,1.94450819492346 49.7363090515137,1.94450819492346 49.7363090515137,1.94545185565954 49.7261695861817,1.9327028989793 49.7213401794434,1.9327028989793 49.7213401794434,1.93306601047522 49.7198791503907,1.93306601047522 49.7198791503907,1.94909155368816 49.7007980346681,1.94909155368816 49.7007980346681,1.97147023677826 49.7199401855469,1.97147023677826 49.7199401855469,1.96933460235607 49.7372131347657,1.9770587682724 49.7419853210449,1.9770587682724 49.7419853210449,1.97989273071295 49.7465820312501,1.97989273071295 49.7465820312501,1.96971726417547 49.7457504272462,1.96262443065655 49.7542991638185,1.96262443065655 49.7542991638185,1.95759272575384 49.7480392456055,1.95759272575384 49.7480392456055,1.94406092166912 49.7479057312012)) | 0.0006 | POINT(1.956181339595696 49.733658500339736) |
39611 | POLYGON((2.77622342109686 43.4387664794923,2.77836608886719 43.4594535827638,2.77451109886175 43.4692726135254,2.78744268417364 43.4798164367676,2.79442691802979 43.4926681518555,2.75917696952814 43.5027236938477,2.75079989433289 43.5191612243653,2.73566651344311 43.5273056030273,2.73566651344311 43.5273056030273,2.75562310218817 43.5333786010743,2.75094532966614 43.545524597168,2.75094532966614 43.545524597168,2.76144146919256 43.5497779846191,2.76588559150696 43.5581092834472,2.76588559150696 43.5581092834472,2.79392075538647 43.5511207580567,2.79392075538647 43.5511207580567,2.79311680793774 43.5476722717285,2.8029763698579 43.5401687622071,2.80642366409302 43.5301513671876,2.81489253044128 43.526912689209,2.82099318504345 43.5175018310547,2.84267115592951 43.5110397338868,2.84267115592951 43.5110397338868,2.85500741004944 43.5015716552734,2.86340498924255 43.4993362426758,2.86340498924255 43.4993362426758,2.86003255844122 43.4885520935059,2.86003255844122 43.4885520935059,2.85053277015686 43.4875144958497,2.82567715644848 43.4773292541504,2.82971429824835 43.4573631286622,2.80287504196178 43.4507751464845,2.79715204238903 43.4453506469727,2.78758406639105 43.4449157714844,2.77622342109686 43.4387664794923)) | 0.0006 | POINT(2.7985717364720366 43.50669206891744) |
39212 | POLYGON((4.19770193099987 44.0554389953614,4.19641828536993 44.0543403625489,4.19641828536993 44.0543403625489,4.18567514419556 44.0460929870606,4.18567514419556 44.0460929870606,4.18300151824951 44.0555725097657,4.17488288879406 44.0583267211914,4.17488288879406 44.0583267211914,4.16880798339844 44.0670127868652,4.17109870910656 44.0733795166015,4.17109870910656 44.0733795166015,4.17759513854986 44.0772094726562,4.18142652511608 44.0759162902833,4.18142652511608 44.0759162902833,4.1941580772401 44.0655975341797,4.19770193099987 44.0554389953614)) | 0.0006 | POINT(4.18268451690681 44.06246287027998) |
33861 | POLYGON((4.17182922363293 48.0875320434571,4.16622400283825 48.0934448242189,4.13813209533686 48.1083068847657,4.15960121154791 48.1277542114258,4.15960121154791 48.1277542114258,4.1646838188172 48.1442909240724,4.18370485305786 48.1482315063476,4.18561124801636 48.1546745300293,4.18221139907837 48.1572074890137,4.18782997131353 48.1624336242677,4.18782997131353 48.1624336242677,4.1963872909547 48.1637153625489,4.20017480850231 48.1693840026856,4.20017480850231 48.1693840026856,4.22526311874401 48.1640968322754,4.22526311874401 48.1640968322754,4.22385978698725 48.1609954833986,4.23305940628063 48.1603965759277,4.23473739624023 48.1573829650879,4.23396205902111 48.1477890014649,4.24501609802257 48.1415061950684,4.24501609802257 48.1415061950684,4.24979543685907 48.1355171203614,4.24855232238781 48.1289863586426,4.22960472106934 48.1269721984863,4.22201824188244 48.1226768493653,4.23231601715099 48.1152725219727,4.23105669021618 48.108497619629,4.23105669021618 48.108497619629,4.21760416030889 48.113121032715,4.20967197418213 48.1088638305665,4.20319080352795 48.0821037292482,4.19928646087641 48.079891204834,4.18944358825689 48.0805778503419,4.17182922363293 48.0875320434571)) | 0.0006 | POINT(4.2062873559840215 48.13309691934029) |
18280 | POLYGON((9.18009281158453 39.272617340088,9.17453289031982 39.2747268676758,9.15848255157482 39.2921028137208,9.14965915679926 39.3034934997559,9.14210510253912 39.3201904296876,9.13245105743408 39.3247261047364,9.13245105743408 39.3247261047364,9.13220977783209 39.3165359497071,9.12869358062744 39.3099937438965,9.12571334838867 39.3071365356445,9.11992740631104 39.3040275573731,9.11653518676752 39.2974243164062,9.1093664169311 39.2892303466797,9.10330104827881 39.2860260009766,9.09919643402105 39.2826042175293,9.09919643402105 39.2826042175293,9.0999870300293 39.2782783508301,9.1057014465332 39.2662582397462,9.10261154174799 39.2644653320313,9.10410118103033 39.2526054382325,9.10947227478033 39.2509040832521,9.11389827728283 39.2557678222657,9.11562919616694 39.2618865966798,9.11777877807623 39.2649650573731,9.12429809570312 39.2632675170898,9.12429809570312 39.2632675170898,9.12053585052496 39.2705039978028,9.11594295501715 39.2762489318849,9.1159982681275 39.2786293029785,9.11925220489502 39.2820854187012,9.12421226501459 39.2846565246583,9.13076496124273 39.2832756042481,9.14001655578613 39.2757911682129,9.14579010009777 39.2679901123048,9.15100479125982 39.2565765380859,9.1513671875 39.2525825500489,9.15057373046886 39.2500877380372,9.15454769134533 39.2468757629396,9.15454769134533 39.2468757629396,9.15646553039556 39.2452468872071,9.15995025634766 39.2462501525879,9.16906929016119 39.2512283325195,9.17866325378424 39.25830078125,9.18289661407482 39.2641258239746,9.18146133422852 39.2709693908691,9.18009281158453 39.272617340088)) | 0.0006 | POINT(9.13388334910078 39.27595850626631) |
27572 | POLYGON((-0.71037578582758 48.5728187561036,-0.721014022827148 48.5869407653809,-0.721014022827148 48.5869407653809,-0.70783257484436 48.6175804138184,-0.70783257484436 48.6175804138184,-0.687105476856175 48.6200637817384,-0.677015125751495 48.6179504394532,-0.651180088519993 48.6216011047363,-0.651180088519993 48.6216011047363,-0.639897108077946 48.6154098510742,-0.629847288131657 48.6142311096192,-0.626146495342198 48.6045303344727,-0.626146495342198 48.6045303344727,-0.646230816841125 48.6012573242188,-0.661125183105469 48.5915641784669,-0.670174956321659 48.5791091918945,-0.663923621177673 48.5735549926759,-0.668010592460632 48.5671997070313,-0.668010592460632 48.5671997070313,-0.684463798999786 48.5725250244141,-0.684463798999786 48.5725250244141,-0.681157350540161 48.5752944946288,-0.683057367801553 48.5822410583497,-0.694672286510411 48.6014289855958,-0.704902231693268 48.6001777648925,-0.712653040885868 48.5909652709961,-0.707695484161377 48.5742530822754,-0.707695484161377 48.5742530822754,-0.71037578582758 48.5728187561036)) | 0.0006 | POINT(-0.678386562636894 48.5937617165702) |
35895 | POLYGON((6.9764542579652 47.3620491027833,6.93669652938848 47.3577346801758,6.93669652938848 47.3577346801758,6.93525743484508 47.3575782775879,6.93525743484508 47.3575782775879,6.93657970428478 47.3479537963867,6.9598121643067 47.3453979492189,6.96212244033813 47.33699798584,6.96212244033813 47.33699798584,6.97116947174078 47.3374099731446,6.97492599487316 47.3354988098145,6.97399854660046 47.3292465209961,6.98256921768194 47.3289718627931,6.98256921768194 47.3289718627931,6.99433851242071 47.335506439209,7.01429557800304 47.3365936279297,7.03310060501099 47.3413848876954,7.03310060501099 47.3413848876954,7.03000783920288 47.3478775024415,7.02010488510138 47.3491744995118,7.00440406799322 47.3623466491699,6.98955011367798 47.363468170166,6.98955011367798 47.363468170166,6.9764542579652 47.3620491027833)) | 0.0006 | POINT(6.979768856712065 47.346144634744455) |