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 |
---|---|---|---|
26969 | POLYGON((-1.41310644149775 48.7979316711427,-1.40091061592102 48.7972106933594,-1.40091061592102 48.7972106933594,-1.38907468318934 48.8148384094239,-1.38907468318934 48.8148384094239,-1.39006233215321 48.817008972168,-1.39006233215321 48.817008972168,-1.39914238452906 48.8190650939942,-1.40826785564417 48.816806793213,-1.41310644149775 48.7979316711427)) | 0.0006 | POINT(-1.3978457715775687 48.81021330091694) |
38358 | POLYGON((0.506717681884879 49.6755523681641,0.510375797748566 49.6743927001954,0.510375797748566 49.6743927001954,0.489773035049495 49.6668243408204,0.48404324054718 49.6616516113282,0.48404324054718 49.6616516113282,0.465975522995052 49.6609611511231,0.465975522995052 49.6609611511231,0.470462083816585 49.6741638183594,0.470462083816585 49.6741638183594,0.479736864566917 49.6855659484864,0.479736864566917 49.6855659484864,0.481761187315101 49.6827239990234,0.491338431835231 49.6826591491699,0.506717681884879 49.6755523681641)) | 0.0006 | POINT(0.4850555253880933 49.67294502258306) |
14714 | POLYGON((13.0522403717042 41.9519309997558,13.0549392700195 41.9365196228027,13.0531969070435 41.9335556030273,13.0525779724121 41.9289054870605,13.0537109375001 41.9273872375488,13.0537109375001 41.9273872375488,13.0488681793212 41.9248085021974,13.0434627532959 41.9233093261719,13.0303630828858 41.9238433837891,13.0279922485353 41.9245071411134,13.0218124389648 41.9301376342773,13.0218124389648 41.9301376342773,13.019341468811 41.9371032714845,13.019341468811 41.9371032714845,13.0392169952393 41.9520912170411,13.0519638061524 41.9578170776368,13.0519638061524 41.9578170776368,13.0522403717042 41.9519309997558)) | 0.0006 | POINT(13.040971475489021 41.93555068969731) |
62489 | POLYGON((6.81630086898815 52.6486167907715,6.79696750640869 52.6113090515138,6.793610572815 52.6107292175294,6.79144811630249 52.6080207824708,6.78911113739019 52.6069488525391,6.79364061355591 52.6050300598146,6.79392337799072 52.6074295043945,6.79289817810059 52.608470916748,6.79755973815924 52.6057434082031,6.79970979690557 52.6069259643555,6.79964876174927 52.6053886413575,6.79607295989996 52.6036834716797,6.81103658676147 52.5977821350099,6.81765699386597 52.5986289978028,6.82278490066523 52.5722923278809,6.82278490066523 52.5722923278809,6.80800819396984 52.5718955993652,6.80697298049932 52.5716514587403,6.80809164047253 52.5685157775879,6.79861879348766 52.5686531066895,6.77855157852184 52.5617256164552,6.76804304122925 52.5615158081055,6.76804304122925 52.5615158081055,6.7666215896607 52.5615119934083,6.7666215896607 52.5615119934083,6.76671504974377 52.5635032653809,6.71871280670177 52.5886840820314,6.72014141082764 52.5934448242189,6.72157764434814 52.5948371887208,6.72073364257818 52.5979881286621,6.72368478775036 52.6031799316407,6.72441244125366 52.6084671020508,6.7271399497987 52.6150512695312,6.72470283508301 52.6188812255859,6.71854162216198 52.6223106384278,6.71428775787359 52.6267738342286,6.71008634567272 52.6273193359375,6.71132230758667 52.6282844543458,6.71132230758667 52.6282844543458,6.71756315231318 52.631031036377,6.72618675231939 52.6332550048829,6.73074245452881 52.6375427246095,6.74199199676519 52.6453247070314,6.75264453887939 52.6481323242188,6.75380659103399 52.6478462219239,6.75200653076178 52.6470527648926,6.75351810455322 52.6458435058594,6.75886011123663 52.6488380432129,6.76795530319214 52.6468620300293,6.77228784561152 52.6501388549806,6.77742910385132 52.6516151428223,6.79012489318848 52.6526908874513,6.79404830932623 52.6507225036622,6.80297231674189 52.6519393920899,6.80580425262451 52.6512260437012,6.80818700790417 52.6491279602051,6.81630086898815 52.6486167907715)) | 0.0006 | POINT(6.76828995772774 52.61185693740847) |
1401960 | POLYGON((-5.02352523803711 41.5587348937989,-5.02525901794428 41.5570983886719,-5.02992010116571 41.5569267272949,-5.02965497970581 41.5557975769043,-5.03182983398438 41.5566520690919,-5.03573608398438 41.553565979004,-5.03541898727406 41.5514984130859,-5.03897476196289 41.5508880615236,-5.0395717620849 41.5493087768555,-5.04229116439819 41.5507202148437,-5.04440593719482 41.54935836792,-5.04279518127436 41.5465431213379,-5.0474100112915 41.5465736389161,-5.04624080657959 41.5425338745117,-5.05273389816284 41.5431594848633,-5.05499315261829 41.5399208068849,-5.05371379852289 41.538501739502,-5.05977916717529 41.5377731323242,-5.06174802780151 41.5351791381837,-5.07605886459345 41.5355682373047,-5.10210895538324 41.5134468078613,-5.12247085571283 41.499568939209,-5.12814378738403 41.5031051635743,-5.12185096740717 41.5110206604004,-5.11599111557007 41.5235824584962,-5.11195993423456 41.5259513854981,-5.11001586914063 41.5317878723145,-5.11331605911255 41.5344657897949,-5.11141681671143 41.5376472473144,-5.11177301406855 41.551139831543,-5.11696195602417 41.5573501586915,-5.11694622039784 41.5605125427247,-5.12142276763916 41.5620956420899,-5.12021207809448 41.5665550231934,-5.11822986602778 41.5682334899902,-5.11702823638916 41.5667228698731,-5.11374187469482 41.5703887939453,-5.10890102386469 41.5708885192871,-5.1032371520995 41.5741081237793,-5.10139083862299 41.573413848877,-5.09670305252075 41.5764198303223,-5.08273887634277 41.578987121582,-5.07795715332026 41.5816764831544,-5.07591485977167 41.5868759155274,-5.06378078460693 41.5912094116211,-5.05031585693359 41.5944366455078,-5.04980516433716 41.5980339050294,-5.0482759475708 41.6005096435547,-5.02794408798218 41.6033821105958,-5.0252251625061 41.6012687683106,-5.02578592300415 41.5999984741212,-5.02900600433344 41.5993995666505,-5.03001594543451 41.5967979431152,-5.03472423553461 41.5934829711914,-5.0407252311706 41.5916557312012,-5.03965377807617 41.5908126831055,-5.04697179794306 41.5843467712403,-5.04478883743275 41.5832252502443,-5.04567098617542 41.5818939208985,-5.04047203063965 41.572566986084,-5.03184604644775 41.5648384094239,-5.02791213989258 41.5663490295411,-5.02352523803711 41.5587348937989)) | 0.0006 | POINT(-5.067667968811497 41.56123315134358) |
27162 | POLYGON((-1.35909581184387 49.5612449645997,-1.34082520008081 49.5685348510743,-1.34082520008081 49.5685348510743,-1.33291709423065 49.5641975402832,-1.3079160451889 49.5600547790528,-1.3079160451889 49.5600547790528,-1.3079160451889 49.5526390075684,-1.30778551101679 49.5526390075684,-1.30778551101679 49.5526390075684,-1.30777287483215 49.5457191467285,-1.3439216613769 49.5398902893068,-1.3439216613769 49.5398902893068,-1.34221458435059 49.543254852295,-1.35909581184387 49.5612449645997)) | 0.0006 | POINT(-1.3269856342902278 49.55456102811381) |
35037 | POLYGON((4.79915857315063 48.6243019104004,4.78619670867926 48.6063919067383,4.80229473114008 48.5983238220215,4.80229473114008 48.5983238220215,4.8296623229981 48.6124801635742,4.8296623229981 48.6124801635742,4.82492876052862 48.6137161254883,4.8185863494873 48.6264343261719,4.79915857315063 48.6243019104004)) | 0.0006 | POINT(4.811598062515271 48.61155652999878) |
65327 | POLYGON((9.26610946655273 49.9278297424318,9.26134300231945 49.9283447265626,9.25710201263433 49.9252662658691,9.24719142913824 49.9268684387208,9.24719142913824 49.9268684387208,9.247223854065 49.9240722656251,9.24989891052257 49.9214553833009,9.2479124069215 49.9196243286133,9.2479124069215 49.9196243286133,9.24746608734125 49.9175491333008,9.25081157684326 49.9143295288087,9.25328826904303 49.913932800293,9.25560283660889 49.9117546081544,9.26035881042492 49.9121208190918,9.25580692291265 49.9060974121094,9.25435733795177 49.902400970459,9.25513172149664 49.9004821777345,9.25409698486334 49.8985176086425,9.2594776153565 49.898910522461,9.27058982849127 49.9023170471193,9.28087329864508 49.9005889892579,9.28087329864508 49.9005889892579,9.28176116943371 49.9034614562989,9.27994346618658 49.9058723449708,9.28000926971436 49.909839630127,9.28125476837164 49.9112396240234,9.27417659759521 49.9133872985839,9.26610946655273 49.9278297424318)) | 0.0006 | POINT(9.26102832511625 49.912716477005624) |
68044 | POLYGON((6.94154930114752 49.677402496338,6.9342360496521 49.6827659606935,6.92952394485474 49.6884078979493,6.93456888198853 49.6913032531739,6.93223428726196 49.6941146850587,6.93542194366461 49.6958618164062,6.93876075744635 49.7013511657715,6.94226074218744 49.7037696838378,6.94126844406128 49.7078704833984,6.9467453956604 49.7117919921876,6.9504122734071 49.7177581787111,6.94912624359131 49.7200965881348,6.95352172851557 49.72416305542,6.95352172851557 49.72416305542,6.96079635620123 49.7219963073731,6.96271753311163 49.722583770752,6.96271753311163 49.722583770752,6.96710252761847 49.7232933044434,6.96750354766857 49.7214393615723,6.97275304794317 49.7178916931152,6.97442102432262 49.7136611938477,6.96943998336798 49.7077522277833,6.96617031097418 49.7061767578125,6.96539592742931 49.7050971984864,6.9660902023316 49.7015419006348,6.96423625946056 49.6997642517089,6.96483469009394 49.6941261291504,6.97117614746099 49.6919288635255,6.97146272659296 49.6908760070801,6.97146272659296 49.6908760070801,6.96095848083496 49.6872406005861,6.96031999588013 49.6883659362793,6.95869731903088 49.6881523132324,6.95586347579967 49.6857490539551,6.94991016387945 49.6889762878419,6.9478063583374 49.6876296997071,6.94688272476208 49.6855087280275,6.94986677169805 49.6842880249023,6.9511914253236 49.6817474365234,6.94154930114752 49.677402496338)) | 0.0006 | POINT(6.9549468969687815 49.70128377278649) |
14434 | POLYGON((12.9301347732544 46.6099815368653,12.9677486419678 46.6049194335938,12.9707412719727 46.6040992736818,12.9844799041749 46.601360321045,12.9910898208618 46.6016845703126,12.9978723526002 46.6047668457032,13.0046033859254 46.6027946472169,13.0093269348145 46.6018714904785,13.0109462738038 46.6021919250489,13.0109462738038 46.6021919250489,13.0213041305542 46.604248046875,13.0266838073731 46.5995521545411,13.0266838073731 46.5995521545411,13.0280942916871 46.5983200073242,13.0335683822632 46.5969238281251,13.0467710494996 46.5963172912597,13.0575542449951 46.5983467102051,13.0568256378174 46.5939178466798,13.0542211532593 46.5882682800294,13.0585346221924 46.5851554870606,13.0639410018921 46.5843200683594,13.0639410018921 46.5843200683594,13.0540399551392 46.5747032165528,13.0476016998291 46.5621566772462,13.0476016998291 46.5621566772462,13.0497417449951 46.5606269836427,13.0473442077638 46.5554924011232,13.04584980011 46.5560684204102,13.0440692901612 46.5594863891602,13.0441513061524 46.5611991882325,13.041997909546 46.5612335205079,13.0360431671144 46.5588340759278,13.0303287506105 46.551628112793,13.0306673049927 46.5386734008789,13.034670829773 46.5231285095215,13.0395603179932 46.51517868042,13.0429992675782 46.5140037536622,13.0401315689087 46.5075912475586,13.0401315689087 46.5075912475586,13.0356855392457 46.5090713500977,13.0304336547852 46.5094032287598,13.0241184234619 46.5063781738282,13.0028448104858 46.5016975402833,13.0028448104858 46.5016975402833,12.9989032745361 46.5175285339357,13.0002546310424 46.5216178894043,13.0002546310424 46.5216178894043,13.0087356567384 46.5242805480957,13.0131711959839 46.5302124023439,13.0113716125488 46.5381355285646,13.0060176849366 46.5398712158204,13.0018587112427 46.5423927307129,12.9929056167603 46.5498046875001,12.9922370910646 46.5527381896973,12.9869241714478 46.5556678771974,12.968810081482 46.5642204284669,12.9630346298218 46.5651092529298,12.9603157043458 46.5641937255859,12.9562702178956 46.5653381347656,12.953335762024 46.5673484802246,12.953335762024 46.5673484802246,12.9464044570924 46.5677719116212,12.9314775466919 46.5657119750976,12.9282236099244 46.5661735534669,12.9269056320191 46.5685615539551,12.9258556365967 46.575553894043,12.9141216278076 46.5752220153809,12.9072494506837 46.5688285827638,12.9072494506837 46.5688285827638,12.8925323486329 46.5726013183594,12.8925323486329 46.5726013183594,12.8914823532105 46.5799026489258,12.8914823532105 46.5799026489258,12.8994865417481 46.585880279541,12.8982801437378 46.5934829711915,12.8918466567994 46.5991325378419,12.8894176483155 46.607307434082,12.8894176483155 46.607307434082,12.8901224136354 46.6073532104492,12.9301347732544 46.6099815368653)) | 0.0006 | POINT(12.991274616386367 46.56598296346546) |