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 |
|---|---|---|---|
| 49477 | POLYGON((3.20203876495373 49.0932197570802,3.1998121738435 49.0802841186524,3.1998121738435 49.0802841186524,3.19075059890758 49.057903289795,3.18086624145519 49.0561447143555,3.18086624145519 49.0561447143555,3.18170833587641 49.0621681213379,3.18170833587641 49.0621681213379,3.16788148880005 49.0769004821778,3.1586811542511 49.0804100036622,3.1586811542511 49.0804100036622,3.15580821037292 49.0855026245117,3.16523027420055 49.0996589660646,3.16523027420055 49.0996589660646,3.17518043518072 49.0983238220216,3.18193387985229 49.1030807495117,3.18193387985229 49.1030807495117,3.19617342948914 49.1025695800782,3.19617342948914 49.1025695800782,3.19405746459961 49.0970344543458,3.20203876495373 49.0932197570802)) | 0.0006 | POINT(3.1807263970375486 49.08387584686286) |
| 67478 | POLYGON((8.64815330505365 48.9468154907228,8.6453361511231 48.9479713439942,8.64292812347418 48.9455757141114,8.64082527160645 48.9487686157227,8.6274242401123 48.950553894043,8.62457275390625 48.9536437988282,8.62278842926031 48.9531631469727,8.62152004241943 48.9566154479982,8.62003421783447 48.9561958312989,8.61949443817139 48.9570579528809,8.61486911773682 48.9562072753906,8.61638736724854 48.9533462524414,8.61165428161627 48.9521026611329,8.60804748535162 48.9475898742676,8.6001033782959 48.9460334777832,8.6001033782959 48.9460334777832,8.59672451019287 48.9458236694337,8.59540176391613 48.952018737793,8.58805942535406 48.9570388793946,8.58900547027594 48.9590225219728,8.58231639862061 48.9633712768555,8.57996749877941 48.9684944152831,8.57839965820312 48.9690895080566,8.57880210876471 48.9706611633301,8.57632350921631 48.9707832336425,8.57458686828625 48.9742507934571,8.58048152923584 48.9841423034668,8.58913040161144 48.9869995117188,8.58913040161144 48.9869995117188,8.59618282318121 48.9863548278809,8.59604740142828 48.9856300354005,8.60429954528809 48.9860877990723,8.61176872253418 48.9915580749513,8.62381267547619 48.9944152832032,8.62690162658691 48.9944229125977,8.63440895080572 48.991569519043,8.64231491088873 48.9900474548339,8.6474809646607 48.9908065795899,8.64760684967052 49.0023536682129,8.64961433410645 49.0036430358887,8.6535148620606 49.0032157897949,8.653977394104 49.0043640136719,8.65946292877192 49.0071907043458,8.6609468460083 49.0055694580079,8.6609468460083 49.0055694580079,8.66601657867432 49.0020599365235,8.66767692565924 48.9965019226075,8.67073917388916 48.9939765930176,8.67073917388916 48.9939765930176,8.66793823242193 48.9866905212403,8.66856670379644 48.9852600097657,8.68332099914562 48.9764137268067,8.69301414489746 48.9726486206055,8.69587421417236 48.9685211181641,8.69320297241217 48.963207244873,8.69070720672613 48.9634552001953,8.68917274475103 48.9624748229981,8.69021511077887 48.9586944580078,8.68649673461914 48.9584007263184,8.68416118621826 48.9551162719727,8.68416118621826 48.9551162719727,8.68182659149164 48.9554290771484,8.67996215820318 48.9534263610839,8.67563152313238 48.9537963867188,8.67370986938477 48.9529495239257,8.66601085662836 48.9542427062988,8.66220569610607 48.9573097229004,8.65420913696283 48.9560089111328,8.65039730072027 48.9545707702636,8.64998531341558 48.9528541564941,8.64853191375738 48.9526138305664,8.65057277679449 48.9492568969727,8.64809322357183 48.9483871459961,8.64815330505365 48.9468154907228)) | 0.0006 | POINT(8.638013682953321 48.9696236701861) |
| 64366 | POLYGON((13.6713714599611 52.2584686279297,13.6661348342897 52.2591094970704,13.6642818450927 52.2584190368653,13.6637687683106 52.2555007934571,13.6531839370728 52.2534904479982,13.6524343490602 52.2553482055664,13.6494941711427 52.257152557373,13.6470127105712 52.2556457519532,13.6417865753174 52.2547569274903,13.636815071106 52.2566680908203,13.6397590637208 52.2603988647462,13.6128082275392 52.2602005004883,13.6128082275392 52.2602005004883,13.6069841384889 52.2584800720214,13.6059865951538 52.2573547363282,13.6086606979371 52.2545127868652,13.6067752838134 52.251579284668,13.606960296631 52.2503776550294,13.6118354797363 52.2479858398438,13.6092748641968 52.2478523254395,13.605676651001 52.2497024536133,13.6046409606934 52.2516899108887,13.6062574386597 52.2547187805176,13.6049842834473 52.2566871643067,13.5886793136596 52.2531394958496,13.5923700332642 52.2449340820313,13.59796333313 52.2245254516602,13.6069898605346 52.219581604004,13.6146917343141 52.2056617736816,13.619161605835 52.2029190063477,13.6211061477662 52.1996803283693,13.6211061477662 52.1996803283693,13.6278581619263 52.1993255615235,13.6272382736206 52.1977691650391,13.6295166015626 52.1969413757325,13.6302995681762 52.1972541809081,13.6301822662355 52.1986389160157,13.6321096420288 52.1989288330078,13.6318244934082 52.2008514404297,13.6338787078858 52.2016258239747,13.6341934204101 52.198787689209,13.6355257034302 52.1972122192383,13.6396732330323 52.1967926025391,13.6432466506959 52.1948776245117,13.6456642150879 52.1979637145997,13.6470279693603 52.1978492736816,13.6487493515015 52.2025756835938,13.653660774231 52.2003135681152,13.6718168258668 52.1968154907227,13.6718168258668 52.1968154907227,13.6784477233887 52.2065162658692,13.6739959716797 52.2100982666017,13.6833677291871 52.2102012634278,13.6916723251343 52.2165603637696,13.6950025558472 52.2151565551758,13.6998567581177 52.2168540954591,13.7021198272706 52.2161102294922,13.7076520919801 52.2166213989258,13.7107620239258 52.2199478149415,13.711049079895 52.2215156555176,13.7074499130249 52.2224311828613,13.7068023681641 52.2242584228516,13.7015542984008 52.2238426208497,13.699767112732 52.2240676879883,13.6994314193726 52.2251243591309,13.6973972320557 52.2243385314941,13.6935691833497 52.2247314453126,13.6952867507935 52.2276649475098,13.6882581710815 52.236701965332,13.6877603530885 52.2392082214355,13.6860609054566 52.2392272949219,13.6861429214478 52.2412223815919,13.6810007095337 52.2412872314454,13.674334526062 52.2453346252441,13.6740121841431 52.2522201538087,13.6713714599611 52.2584686279297)) | 0.0006 | POINT(13.650917345682824 52.2278533935547) |
| 1388242 | POLYGON((-3.12608909606934 37.4650230407716,-3.13051795959461 37.4695243835449,-3.13859701156611 37.4720382690429,-3.13736701011652 37.4788932800294,-3.14107298851013 37.482837677002,-3.13972806930542 37.4834861755372,-3.14107894897461 37.4869384765625,-3.14493107795715 37.4898986816407,-3.15010190010071 37.4902076721193,-3.15452909469604 37.4868087768555,-3.15940594673151 37.4880409240723,-3.16335105895996 37.4868812561035,-3.17182707786554 37.4887428283691,-3.17051410675043 37.4982032775879,-3.1572430133819 37.5137939453126,-3.1551010608672 37.5228385925294,-3.14956498146057 37.5271339416504,-3.13790488243103 37.5322418212891,-3.13038301467884 37.5286102294922,-3.14475607872009 37.5513076782227,-3.15247511863703 37.5559844970703,-3.14977192878723 37.5684356689454,-3.15674400329578 37.5779609680177,-3.15251398086548 37.5750312805176,-3.14762306213379 37.575080871582,-3.14615702629084 37.573070526123,-3.14493608474731 37.5741539001466,-3.13841009140009 37.5726318359376,-3.13552308082575 37.5733375549317,-3.12155199050903 37.5684509277344,-3.11356806755066 37.5681037902832,-3.11020398139948 37.5663070678711,-3.10327792167658 37.5696907043458,-3.08654189109802 37.5608711242676,-3.07123494148254 37.5613403320313,-3.07170510292053 37.567668914795,-3.06614398956299 37.5787506103516,-3.06318807601929 37.5796089172364,-3.05596995353699 37.5741844177246,-3.05109906196589 37.5726737976074,-3.0428900718689 37.5729484558106,-3.0376660823822 37.5683097839355,-3.04053092002869 37.5680541992188,-3.04100489616394 37.566089630127,-3.0466210842132 37.5638160705567,-3.05035400390619 37.5578269958496,-3.05681490898132 37.5538864135742,-3.05302000045765 37.549976348877,-3.05438804626459 37.5486793518066,-3.05290389060968 37.5463104248047,-3.0550279617309 37.5406188964844,-3.05793595314026 37.5388717651368,-3.06010603904724 37.5342903137208,-3.0565459728241 37.5278472900391,-3.06070590019226 37.520320892334,-3.08283090591425 37.5229301452637,-3.08376097679138 37.5241813659669,-3.08869600296015 37.5240516662598,-3.09753894805908 37.5184631347657,-3.10008692741388 37.5205993652344,-3.1028950214386 37.5207405090333,-3.10380411148066 37.5166549682618,-3.09939408302307 37.5103416442871,-3.10088706016541 37.5090599060059,-3.09974002838135 37.5065383911134,-3.10929703712458 37.5041770935058,-3.11326694488525 37.4952964782715,-3.11219096183771 37.4879760742188,-3.1185998916626 37.484203338623,-3.11278605461115 37.477481842041,-3.12136507034302 37.4669036865234,-3.12403392791742 37.4668922424317,-3.12608909606934 37.4650230407716)) | 0.0006 | POINT(-3.1072276863786623 37.530154546101905) |
| 49480 | POLYGON((3.33247518539434 49.161720275879,3.33268570899969 49.1688766479492,3.33268570899969 49.1688766479492,3.33860421180731 49.1744422912599,3.36337852478033 49.1777153015138,3.37177038192749 49.181438446045,3.37177038192749 49.181438446045,3.37368869781494 49.1583900451661,3.37368869781494 49.1583900451661,3.37405538558966 49.1503410339356,3.37405538558966 49.1503410339356,3.35690474510199 49.1537208557129,3.34209513664257 49.1362419128419,3.34209513664257 49.1362419128419,3.32979893684393 49.1375961303711,3.32979893684393 49.1375961303711,3.33197736740112 49.1439628601074,3.32702279090893 49.1493263244629,3.33247518539434 49.161720275879)) | 0.0006 | POINT(3.349919517835032 49.15703646341965) |
| 12494 | POLYGON((13.8253889083862 42.317138671875,13.8087940216064 42.3336334228517,13.8080892562867 42.3472366333008,13.8026447296144 42.3608932495118,13.8026447296144 42.3608932495118,13.7958068847656 42.3616333007813,13.7836513519288 42.3755073547364,13.7735843658448 42.3685989379883,13.7664728164673 42.3650093078614,13.7664728164673 42.3650093078614,13.7701539993286 42.3624458312988,13.7664155960084 42.358211517334,13.7578306198121 42.3588905334473,13.7415037155151 42.3537750244141,13.731761932373 42.3474464416504,13.7280178070068 42.3439064025879,13.7280178070068 42.3439064025879,13.7418317794799 42.3458328247071,13.7481498718261 42.3480186462403,13.7642831802369 42.3412666320801,13.7660760879517 42.3383255004883,13.7675399780273 42.3298187255861,13.7689714431762 42.3267936706544,13.7726449966432 42.3225784301759,13.788166999817 42.3104782104492,13.7924976348878 42.3042144775391,13.7913208007814 42.2966537475587,13.7913208007814 42.2966537475587,13.7995223999025 42.3011093139648,13.8146905899048 42.3066062927247,13.821029663086 42.308277130127,13.8257198333741 42.3078994750978,13.8257198333741 42.3078994750978,13.8253889083862 42.317138671875)) | 0.0006 | POINT(13.77990112882676 42.33686551180758) |
| 34450 | POLYGON((5.28914642333996 48.510524749756,5.29572772979748 48.5083274841309,5.29572772979748 48.5083274841309,5.29604148864746 48.4987831115723,5.29604148864746 48.4987831115723,5.2766313552857 48.4836883544923,5.24962329864502 48.4748344421388,5.24962329864502 48.4748344421388,5.23722171783453 48.4744377136232,5.23722171783453 48.4744377136232,5.24228382110601 48.4804611206056,5.23305845260631 48.4927024841309,5.23380661010742 48.5029563903809,5.23380661010742 48.5029563903809,5.28914642333996 48.510524749756)) | 0.0006 | POINT(5.261854410171557 48.49186107090549) |
| 34379 | POLYGON((5.44686555862438 48.0156936645508,5.45360660552973 48.0111618041992,5.44673776626598 48.0062446594238,5.44284439086914 47.9965896606446,5.46028614044195 47.984245300293,5.46028614044195 47.984245300293,5.45300197601318 47.979850769043,5.40841054916388 47.9877319335938,5.40841054916388 47.9877319335938,5.39196443557751 48.006965637207,5.39196443557751 48.006965637207,5.40235519409191 48.0183486938476,5.4146866798402 48.0239219665528,5.4146866798402 48.0239219665528,5.43680095672613 48.0159759521485,5.44686555862438 48.0156936645508)) | 0.0006 | POINT(5.428860537211169 48.00330632527673) |
| 57567 | POLYGON((8.26063823699963 49.2113876342773,8.25973987579357 49.2110328674317,8.26211261749268 49.2083396911622,8.26072788238531 49.2065124511719,8.26177406311047 49.2053909301758,8.26076507568371 49.1987609863282,8.25988292694103 49.1983947753907,8.26032924652105 49.1852493286134,8.25856971740717 49.1849975585938,8.25932884216314 49.1813774108887,8.2574977874757 49.1811866760254,8.25947093963629 49.1730003356934,8.25947093963629 49.1730003356934,8.26198101043713 49.1733398437501,8.26264667510981 49.1713981628419,8.29517555236828 49.1752738952637,8.30607223510754 49.1740951538087,8.30607223510754 49.1740951538087,8.30965137481695 49.1820106506348,8.31189441680908 49.1846084594727,8.31239032745373 49.1869850158692,8.31932735443127 49.1838722229004,8.32165622711193 49.1839904785156,8.32138919830328 49.1853256225586,8.32271766662598 49.1860160827637,8.34159564971935 49.1856727600098,8.34159564971935 49.1856727600098,8.3428897857666 49.1915855407715,8.3450860977174 49.1960258483888,8.34993457794195 49.2012367248535,8.34834194183344 49.2027549743652,8.34477233886719 49.2018203735353,8.34342098236084 49.2031631469728,8.33976364135748 49.2035598754884,8.33976364135748 49.2035598754884,8.33765411376964 49.2037620544434,8.33619022369385 49.2051658630372,8.33242607116711 49.2045631408693,8.32412338256842 49.2059516906738,8.32165145874029 49.2053527832031,8.31347751617426 49.2090263366699,8.30163383483887 49.2094078063965,8.29575824737555 49.2111358642579,8.29511260986339 49.2120513916016,8.29009342193609 49.2124557495118,8.28691959381115 49.2109909057618,8.28691959381115 49.2109909057618,8.27933216094976 49.2107696533204,8.27161312103283 49.2125778198242,8.26063823699963 49.2113876342773)) | 0.0006 | POINT(8.300843920026571 49.19548766467042) |
| 73562 | POLYGON((17.0426387786865 43.2734718322755,17.0572605133057 43.282543182373,17.0681324005128 43.2932929992676,17.0893383026123 43.3086853027345,17.0893383026123 43.3086853027345,17.1031742095947 43.3066024780275,17.1090240478516 43.3038330078126,17.1252517700195 43.2987136840821,17.1296691894531 43.2947196960449,17.1296691894531 43.2947196960449,17.114616394043 43.2752532958985,17.1083354949952 43.2690734863281,17.090675354004 43.2602615356446,17.0822143554688 43.2583312988282,17.0634746551514 43.2519874572754,17.0634746551514 43.2519874572754,17.0631942749025 43.2537498474121,17.0607299804689 43.2562866210938,17.060417175293 43.260139465332,17.0590286254882 43.2629165649415,17.0568046569825 43.2637481689453,17.0562496185303 43.2668037414552,17.0543212890625 43.2691040039062,17.0501384735108 43.27152633667,17.0426387786865 43.2734718322755)) | 0.0006 | POINT(17.080298821131425 43.276518185933476) |