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 |
|---|---|---|---|
| 34247 | POLYGON((5.86448001861572 47.9458770751953,5.88472652435308 47.9260482788086,5.88472652435308 47.9260482788086,5.89057493209839 47.9099349975587,5.89057493209839 47.9099349975587,5.88649415969854 47.9026336669922,5.88649415969854 47.9026336669922,5.88319015502941 47.9002494812012,5.86901283264172 47.9010810852052,5.85132741928106 47.9059257507324,5.84819364547724 47.903434753418,5.84819364547724 47.903434753418,5.83947467803961 47.9131927490236,5.83947467803961 47.9131927490236,5.84667539596552 47.9325599670411,5.86085319519049 47.9357986450195,5.86448001861572 47.9458770751953)) | 0.0006 | POINT(5.8671541810036025 47.9144988059998) |
| 51992 | POLYGON((-0.541334629058838 45.8279609680176,-0.545206427574158 45.8328323364258,-0.556262612342834 45.836711883545,-0.556262612342834 45.836711883545,-0.558010458946114 45.8570137023927,-0.560262560844421 45.8601226806642,-0.569696843624115 45.8607711791992,-0.569696843624115 45.8607711791992,-0.572134256362858 45.865535736084,-0.580391407012939 45.8661231994629,-0.580391407012939 45.8661231994629,-0.568809032440186 45.8769531250001,-0.568890511989594 45.8837928771973,-0.568890511989594 45.8837928771973,-0.54232728481287 45.8823738098146,-0.54232728481287 45.8823738098146,-0.528378009796029 45.8735466003419,-0.501343548297882 45.8786239624025,-0.501343548297882 45.8786239624025,-0.495285034179688 45.8697776794435,-0.515721678733826 45.8553810119629,-0.498949170112553 45.848834991455,-0.498949170112553 45.848834991455,-0.504678666591587 45.8393363952637,-0.523358166217804 45.8376083374024,-0.541334629058838 45.8279609680176)) | 0.0006 | POINT(-0.5419560670852434 45.86042129516606) |
| 19826 | POLYGON((12.3628797531128 46.0724906921387,12.3495407104493 46.0800819396973,12.329511642456 46.0829544067382,12.3234052658081 46.0831336975098,12.3162031173707 46.0816497802734,12.3105068206787 46.0787620544434,12.3037805557252 46.0772399902343,12.3037805557252 46.0772399902343,12.3053026199341 46.0912284851075,12.3053026199341 46.0912284851075,12.3074960708618 46.0943679809571,12.3195781707765 46.0990943908691,12.3290891647339 46.1070594787599,12.329478263855 46.1085891723633,12.3276433944702 46.1157073974611,12.3238897323608 46.1219444274903,12.3238897323608 46.1219444274903,12.3374309539795 46.1254119873047,12.3411931991577 46.1285438537598,12.34361743927 46.1326560974121,12.3431968688964 46.1332511901855,12.3483867645265 46.1360206604005,12.3587636947632 46.1339416503906,12.3749179840088 46.1222496032715,12.3770112991333 46.1217651367188,12.3770112991333 46.1217651367188,12.376932144165 46.120891571045,12.385046005249 46.1204643249512,12.3932476043701 46.1216621398926,12.4149551391602 46.116439819336,12.4188871383668 46.1115989685059,12.4146699905396 46.1063957214356,12.4108972549438 46.1037635803223,12.4090366363526 46.0979423522949,12.4158487319946 46.082347869873,12.4153165817261 46.0791854858398,12.4093961715698 46.0721015930176,12.4017019271851 46.0588569641113,12.4017019271851 46.0588569641113,12.4005031585693 46.0633201599122,12.3894367218018 46.0658798217774,12.3924903869629 46.072235107422,12.3771858215332 46.0765838623047,12.3682231903077 46.0772018432618,12.3628797531128 46.0724906921387)) | 0.0006 | POINT(12.360642823306016 46.09877386960118) |
| 55817 | POLYGON((5.80769300460815 45.0830307006837,5.78679418563854 45.0898361206055,5.77760601043707 45.0971565246582,5.77760601043707 45.0971565246582,5.78636646270752 45.100399017334,5.79687309265137 45.1161346435547,5.79687309265137 45.1161346435547,5.83291053771978 45.1088638305665,5.84736251831055 45.0916023254396,5.84736251831055 45.0916023254396,5.84348011016851 45.0897903442384,5.83487939834595 45.0919914245605,5.8243026733399 45.0855674743652,5.81532144546509 45.086784362793,5.80769300460815 45.0830307006837)) | 0.0006 | POINT(5.812530790056529 45.09614644731799) |
| 68382 | POLYGON((7.75994729995739 50.5530433654786,7.76492261886602 50.5530242919921,7.771562576294 50.5554962158203,7.771562576294 50.5554962158203,7.77027797698975 50.5591049194337,7.77189111709606 50.5644073486329,7.77189111709606 50.5644073486329,7.76638412475586 50.5630989074707,7.7528162002564 50.5628128051758,7.74534034729004 50.5637435913086,7.739426612854 50.5657424926759,7.73793125152594 50.5652122497559,7.73550653457642 50.5624618530274,7.73480176925671 50.559799194336,7.73248291015619 50.5581321716309,7.73248291015619 50.5581321716309,7.73459148406994 50.5576133728028,7.72852659225464 50.553337097168,7.72961854934687 50.55184173584,7.72961854934687 50.55184173584,7.73530101776129 50.5513381958008,7.7414236068725 50.5493698120118,7.74571657180786 50.5513458251953,7.75994729995739 50.5530433654786)) | 0.0006 | POINT(7.7480010571687385 50.55786099641223) |
| 45761 | POLYGON((1.51380085945129 44.6860160827637,1.5047985315324 44.6870765686035,1.50287556648266 44.693416595459,1.48969888687139 44.6909675598145,1.48969888687139 44.6909675598145,1.4860565662384 44.6846504211426,1.4860565662384 44.6846504211426,1.49382483959204 44.6749877929688,1.49382483959204 44.6749877929688,1.51561176776897 44.6675910949708,1.54282188415533 44.6478385925293,1.54282188415533 44.6478385925293,1.55137073993683 44.6504058837891,1.55615437030798 44.6596450805665,1.56406831741344 44.662467956543,1.56406831741344 44.662467956543,1.55737292766571 44.6716728210449,1.53500211238872 44.6846961975098,1.51641380786907 44.6831359863282,1.51380085945129 44.6860160827637)) | 0.0006 | POINT(1.52138640378657 44.673972681949046) |
| 1396798 | POLYGON((-2.09173989295959 40.6432876586915,-2.08412790298456 40.6352729797364,-2.07088398933411 40.6284828186035,-2.07682991027832 40.6225929260254,-2.08000993728626 40.6096839904786,-2.08905506134028 40.5946922302246,-2.0951039791106 40.593864440918,-2.09677696228027 40.5908699035645,-2.09911298751831 40.5902671813964,-2.10359191894531 40.5955352783203,-2.13076090812677 40.5964736938476,-2.14460492134089 40.6164512634277,-2.17026996612549 40.6298942565919,-2.16679692268366 40.632423400879,-2.16273808479309 40.6508140563965,-2.15686392784119 40.6587066650391,-2.13366889953613 40.655933380127,-2.12068510055536 40.6510162353515,-2.11113595962519 40.650447845459,-2.09173989295959 40.6432876586915)) | 0.0006 | POINT(-2.114987222771862 40.62351106342518) |
| 58872 | POLYGON((8.29630184173584 51.2760162353516,8.29584980010986 51.2743721008301,8.27727508544922 51.2694282531739,8.276777267456 51.2669448852538,8.2733907699585 51.2666549682618,8.27026844024653 51.2686309814454,8.26881408691401 51.2684402465821,8.26934623718256 51.2654342651367,8.27668476104742 51.2602348327637,8.27070426940918 51.2551612854005,8.27340984344488 51.2540893554688,8.27532005310059 51.2513542175294,8.27318859100347 51.2509346008301,8.27185821533214 51.2520599365234,8.27114963531494 51.2486114501954,8.26704502105719 51.2453994750977,8.26880836486822 51.2442283630372,8.26750278472895 51.2427711486818,8.26492691040039 51.242946624756,8.26201057434076 51.2457084655762,8.2599840164184 51.2434387207032,8.26226615905773 51.2416343688966,8.26096725463867 51.2403144836427,8.25656700134272 51.2426338195801,8.2577486038208 51.2448806762695,8.25662517547613 51.2470550537111,8.25987815856934 51.2491683959962,8.25748634338379 51.2502746582032,8.25347423553467 51.2454910278321,8.25470924377453 51.2445602416993,8.24905586242676 51.2410926818847,8.24637317657476 51.2417182922363,8.2457189559936 51.239128112793,8.24440860748302 51.2378997802736,8.24195480346685 51.2399864196777,8.24001312255854 51.2392196655274,8.23832225799572 51.2395591735841,8.23781490325933 51.2406349182129,8.23520755767828 51.2386665344238,8.234453201294 51.2395401000977,8.23154354095465 51.2391166687012,8.23023891448986 51.237663269043,8.23408794403082 51.2369422912598,8.23389339447016 51.2356452941895,8.22560405731195 51.2343406677247,8.22582244873053 51.2336006164552,8.22260093688976 51.2333946228028,8.22228145599365 51.2321166992188,8.21775913238525 51.2354393005371,8.21439266204845 51.2362365722656,8.21272087097168 51.2346649169923,8.21642780303961 51.2330627441407,8.21441459655756 51.229549407959,8.2147359848023 51.2285842895509,8.21215343475347 51.2273254394531,8.21298217773438 51.2259292602538,8.20056533813482 51.2248229980469,8.19658565521246 51.2224121093751,8.1975421905517 51.2193336486818,8.20197963714605 51.2157135009766,8.19805908203119 51.2158584594727,8.19378471374523 51.2110519409179,8.19501972198492 51.2075462341309,8.20131111145031 51.2038078308106,8.19936275482172 51.2003326416017,8.18752384185797 51.1921348571777,8.17913436889648 51.1900215148926,8.17580986022955 51.1877784729004,8.17023277282715 51.1873054504394,8.16810512542725 51.1854629516603,8.16729164123541 51.1803169250488,8.16526412963873 51.1776313781738,8.16056728363043 51.1770668029785,8.15136051177973 51.1733169555664,8.15136051177973 51.1733169555664,8.14945030212408 51.1717948913575,8.14930057525635 51.1691093444825,8.15020370483404 51.1679496765137,8.14730834960949 51.1676483154297,8.14791297912609 51.1664886474609,8.14953613281256 51.1667480468751,8.15033340454102 51.1653633117677,8.14627456665033 51.1647377014161,8.14761543273926 51.158893585205,8.13625717163092 51.1534156799316,8.1304550170899 51.145133972168,8.13020038604742 51.1434097290039,8.13536548614508 51.1425132751465,8.13569450378418 51.1414031982423,8.13947772979736 51.1411666870118,8.13919258117676 51.1405296325685,8.14352512359613 51.1397209167481,8.14455223083507 51.1386680603027,8.14634609222406 51.1405220031739,8.1518173217774 51.1421203613282,8.15280342102056 51.1408920288086,8.15581512451178 51.1406364440918,8.15567970275885 51.1397209167481,8.15798759460449 51.139907836914,8.16018962860107 51.1385803222656,8.16101551055908 51.1368141174316,8.16712188720714 51.1385803222656,8.170090675354 51.1413497924805,8.16760921478277 51.1473045349121,8.17362308502209 51.1478652954103,8.17563247680675 51.1449012756348,8.18094444274908 51.146842956543,8.18402099609381 51.1462707519531,8.18841361999517 51.1442871093751,8.19262599945074 51.1378822326661,8.19275951385509 51.136058807373,8.19052028656012 51.132553100586,8.19159889221203 51.1318893432618,8.19406986236567 51.1333389282227,8.19702148437506 51.1315383911133,8.19421672821051 51.1294822692872,8.19505119323736 51.1282424926759,8.19643020629877 51.1288108825684,8.19906139373791 51.1252975463868,8.19244194030773 51.1243591308594,8.19569301605236 51.1214065551757,8.19922065734875 51.1202087402345,8.20050048828136 51.1227760314942,8.20702552795422 51.1249046325685,8.20956802368175 51.1249275207521,8.21197891235357 51.1230010986328,8.21792602539062 51.1230621337891,8.21850013732922 51.1243019104004,8.22354793548595 51.1213989257814,8.22560119628912 51.1221237182618,8.22659873962414 51.1203155517578,8.22469520568853 51.1165351867677,8.22503471374517 51.1151695251466,8.22879600524908 51.1153259277344,8.23179721832287 51.1133842468262,8.23921012878412 51.1122131347657,8.2385892868042 51.1109733581544,8.23941898345959 51.1107330322265,8.24157619476318 51.1121177673341,8.23924350738537 51.1074218750001,8.23879528045654 51.1043395996094,8.23879528045654 51.1043395996094,8.24733066558838 51.1028442382813,8.25187587738037 51.0996360778809,8.25431156158459 51.0992240905762,8.27833080291754 51.1031036376953,8.29458332061773 51.1002120971681,8.30508804321295 51.1007537841798,8.30729007720953 51.0973930358887,8.31322383880627 51.095932006836,8.32697391510021 51.0962715148927,8.33032417297363 51.0946426391602,8.34027004241955 51.0925483703613,8.35403823852539 51.0964317321778,8.35879611969 51.1005210876464,8.35821437835705 51.1023101806642,8.36222076416021 51.1040153503418,8.36884021759045 51.104190826416,8.37297821044922 51.1083259582521,8.38008880615234 51.1113128662109,8.38040447235113 51.1163215637208,8.38352203369141 51.1185150146486,8.39042472839367 51.1206169128418,8.39436817169195 51.1267471313476,8.40070056915295 51.1293182373047,8.40175342559814 51.1311378479004,8.40432453155529 51.1325263977052,8.41160106658936 51.1333427429199,8.4177131652832 51.1363754272462,8.42379379272455 51.1379623413087,8.42714214324957 51.1412773132325,8.43360900878901 51.1424293518068,8.43742752075201 51.1418380737305,8.43742752075201 51.1418380737305,8.4407577514649 51.1444892883301,8.44705772399914 51.1459960937501,8.44847679138184 51.1485328674318,8.45244503021252 51.1490859985352,8.45637989044201 51.1510276794435,8.46173000335699 51.1588783264161,8.4699010848999 51.1628189086914,8.46859836578369 51.1628341674805,8.47133731842047 51.166633605957,8.46997356414795 51.16703414917,8.47045326232922 51.1724166870118,8.48111152648937 51.1745796203613,8.48854827880854 51.1747817993165,8.4864702224732 51.1784248352051,8.48233890533447 51.1802330017091,8.47837638854992 51.1850624084473,8.4728565216065 51.1864967346193,8.468186378479 51.1858787536622,8.46691608428949 51.1838302612305,8.46453762054443 51.1848220825196,8.45789527893061 51.184642791748,8.45316123962414 51.1826896667482,8.44872856140142 51.1912460327148,8.44749641418463 51.1909255981446,8.44194126129156 51.1996116638184,8.44149112701416 51.2022514343262,8.43491744995117 51.2030906677247,8.42408275604254 51.206298828125,8.43231296539301 51.2114753723146,8.43027877807612 51.2129974365234,8.43037509918224 51.2161254882813,8.43140792846691 51.2174606323243,8.43069744110107 51.2191047668458,8.41930294036865 51.2196426391601,8.42250919342047 51.2251472473145,8.42667102813715 51.227596282959,8.43889808654791 51.2314758300781,8.44224262237555 51.2355575561524,8.43800544738781 51.2415046691895,8.44176769256592 51.244270324707,8.44247817993158 51.2473068237305,8.44007873535168 51.2477226257325,8.43935489654535 51.2488441467286,8.43325805664062 51.2472801208497,8.43416118621832 51.2514533996582,8.4329948425293 51.2515487670898,8.43503189086925 51.2550773620605,8.43378067016602 51.2570648193359,8.42625522613525 51.2598304748535,8.42119789123541 51.2600021362305,8.42146778106695 51.2613372802735,8.43000030517572 51.2662048339844,8.43000030517572 51.2662048339844,8.41295433044445 51.2637062072754,8.40834903717047 51.2618064880372,8.4044589996339 51.2624816894532,8.40320873260498 51.2723083496094,8.40451812744146 51.2782249450684,8.40297508239752 51.2809371948243,8.39583683013927 51.2810401916504,8.39500522613531 51.2791442871093,8.39402008056646 51.2815399169922,8.38337421417231 51.2817878723145,8.37605571746838 51.2833137512207,8.37347984313959 51.28812789917,8.37347984313959 51.28812789917,8.36945724487305 51.2838592529298,8.36706447601318 51.2847061157227,8.36485099792492 51.282901763916,8.36126232147217 51.2829170227051,8.36250782012945 51.2811317443849,8.36794471740728 51.2790069580078,8.36738967895508 51.2739562988282,8.36373996734625 51.2706413269044,8.36067008972179 51.2703247070314,8.36170291900646 51.2659950256348,8.35094356536871 51.2610473632812,8.3520879745484 51.2592773437501,8.35105419158947 51.2592926025392,8.34979820251476 51.257308959961,8.35253334045416 51.2509307861328,8.3513298034668 51.250602722168,8.3434877395631 51.2545318603517,8.34287071228033 51.260051727295,8.34158325195318 51.2602806091309,8.33972644805908 51.2585639953614,8.33822250366211 51.2591285705567,8.33629894256597 51.2567176818849,8.32254600524914 51.2599906921387,8.32262611389172 51.2613334655762,8.3198823928833 51.2626152038575,8.32193183898926 51.2638664245606,8.31591606140137 51.2654838562013,8.31422042846685 51.2667579650879,8.31416702270508 51.2690963745117,8.30931758880621 51.2687721252441,8.31291580200201 51.2730865478516,8.3122549057008 51.2749214172363,8.30636405944824 51.2732620239258,8.2990837097168 51.276969909668,8.29630184173584 51.2760162353516)) | 0.0006 | POINT(8.298142384438655 51.196480034041585) |
| 52735 | POLYGON((-0.526094973087254 46.3496208190919,-0.523572146892548 46.3524818420411,-0.509874880313816 46.3500022888184,-0.511034309864044 46.3625793457031,-0.503490328788757 46.3665504455566,-0.498844087123871 46.3655662536621,-0.498844087123871 46.3655662536621,-0.492312431335449 46.3750038146973,-0.492312431335449 46.3750038146973,-0.495302706956863 46.3810348510743,-0.5157452821731 46.3914756774902,-0.5157452821731 46.3914756774902,-0.537800490856114 46.3864669799805,-0.537800490856114 46.3864669799805,-0.557285130023956 46.3640441894532,-0.557285130023956 46.3640441894532,-0.539754033088627 46.3581275939941,-0.526094973087254 46.3496208190919)) | 0.0006 | POINT(-0.5184175424715817 46.369735942167424) |
| 39296 | POLYGON((4.23793315887451 43.4970817565918,4.2393565177918 43.4937362670898,4.23161697387707 43.4809303283692,4.22975778579712 43.4598617553712,4.22975778579712 43.4598617553712,4.19847106933599 43.4640274047852,4.19569492340099 43.4654159545899,4.1920828819276 43.4651374816895,4.17763996124279 43.4690284729003,4.17291784286505 43.4693069458009,4.16930484771734 43.471248626709,4.16402721405035 43.4720840454102,4.16069507598888 43.4743041992188,4.15791606903082 43.4743041992188,4.15680599212646 43.4754180908203,4.14374923706055 43.4790267944337,4.13652896881115 43.4820823669434,4.13097190856928 43.485694885254,4.11986207962042 43.4968070983887,4.11319494247437 43.5081939697267,4.11513900756836 43.5093040466309,4.12347221374517 43.5106925964356,4.12430620193481 43.5201377868653,4.12263822555542 43.5206947326661,4.12319421768188 43.5220832824707,4.12708377838135 43.5237503051758,4.12958383560181 43.5226402282715,4.13458299636841 43.5226402282715,4.1348609924317 43.5234718322754,4.1381950378418 43.5245819091798,4.1381950378418 43.5262489318847,4.14097118377697 43.5293045043946,4.13875102996826 43.5326385498046,4.13513898849487 43.5351371765137,4.13375091552734 43.5351371765137,4.13347291946423 43.5379180908204,4.13041591644298 43.5426406860352,4.11791801452642 43.5493049621583,4.10130977630615 43.5548629760743,4.10130977630615 43.5548629760743,4.108711719513 43.5684394836426,4.108711719513 43.5684394836426,4.14092922210693 43.562427520752,4.16261196136486 43.5485115051271,4.17525672912603 43.5334625244141,4.18014574050898 43.5197982788087,4.2005186080932 43.5000457763672,4.21370601654058 43.495876312256,4.23793315887451 43.4970817565918)) | 0.0006 | POINT(4.154024312893586 43.509137630462675) |