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 |
---|---|---|---|
69193 | POLYGON((9.09457778930675 54.2091522216797,9.08423995971685 54.2087211608888,9.07960414886469 54.2131614685059,9.07654857635504 54.2189102172853,9.07314682006842 54.2216835021974,9.06591892242426 54.2238082885743,9.06441879272472 54.2220497131349,9.06194400787354 54.2233963012695,9.06229400634766 54.2272453308105,9.04779720306396 54.2253074645997,9.04779720306396 54.2253074645997,9.04816246032715 54.2217483520509,9.05169391632091 54.2220115661622,9.05220603942877 54.2167892456056,9.04900932312017 54.216609954834,9.04922485351568 54.2134056091309,9.05257701873791 54.2135086059571,9.05263137817394 54.2118988037109,9.05263137817394 54.2118988037109,9.05127239227306 54.2094688415528,9.05127239227306 54.2094688415528,9.05534172058117 54.2110252380371,9.06027698516857 54.2114601135254,9.0602970123291 54.2058181762695,9.06353855133062 54.2087745666504,9.07051372528088 54.206340789795,9.07049560546875 54.2031860351563,9.08002090454107 54.2051734924316,9.08207416534424 54.2037582397462,9.0915470123291 54.2056579589844,9.09212303161632 54.2076263427735,9.09459686279303 54.2078514099121,9.09457778930675 54.2091522216797)) | 0.0006 | POINT(9.065306067466791 54.213819503784215) |
1396784 | POLYGON((-1.98582899570465 40.4762077331542,-2.00509691238403 40.4904975891114,-2.01308989524841 40.5029907226564,-2.02392196655262 40.5087776184083,-2.03147101402277 40.5108032226564,-2.03891706466675 40.5092811584473,-2.05253911018366 40.5250396728516,-2.04369401931763 40.5311279296876,-2.01520204544067 40.5400962829591,-1.99207997322077 40.5385818481446,-1.9870890378952 40.5399627685548,-1.98002398014069 40.5378646850587,-1.9679399728775 40.5273704528809,-1.95906698703766 40.5170211791993,-1.94899094104761 40.5002250671388,-1.94897699356079 40.4965591430664,-1.94262504577637 40.4958724975587,-1.94275999069214 40.4941177368165,-1.95054996013636 40.4902534484864,-1.97259199619293 40.4895133972169,-1.98582899570465 40.4762077331542)) | 0.0006 | POINT(-1.9901227951049605 40.51110820770272) |
53045 | POLYGON((0.285593032836971 46.4384841918945,0.29495465755474 46.4504928588868,0.303840637207088 46.4534759521485,0.303840637207088 46.4534759521485,0.312668651342449 46.4605674743652,0.306912302970943 46.4699478149415,0.308929026126918 46.4766426086426,0.317584663629646 46.4796409606934,0.317584663629646 46.4796409606934,0.327651590108928 46.4724884033203,0.336537420749607 46.4547576904297,0.350408762693519 46.4523239135743,0.357690900564194 46.4567260742188,0.357690900564194 46.4567260742188,0.365935951471442 46.4493141174316,0.390150487422943 46.44149017334,0.390150487422943 46.44149017334,0.39432966709137 46.4355773925782,0.39432966709137 46.4355773925782,0.389528065919933 46.4365196228027,0.363868236541862 46.4268226623535,0.340197712182942 46.4243354797363,0.340197712182942 46.4243354797363,0.327618539333457 46.4295196533203,0.317831039428711 46.4298210144043,0.308294177055473 46.4371910095216,0.298394352197647 46.4302558898926,0.293493926525059 46.430274963379,0.285593032836971 46.4384841918945)) | 0.0006 | POINT(0.33557885246621516 46.44742556980681) |
13731 | POLYGON((14.1202983856202 40.9044609069824,14.1430311203003 40.9055099487305,14.1477594375611 40.9071655273439,14.1547870635986 40.9118194580078,14.1547870635986 40.9118194580078,14.1604738235474 40.90625,14.1762619018554 40.9036903381348,14.2018814086914 40.9027786254884,14.2018814086914 40.9027786254884,14.2052164077759 40.8985214233399,14.2052164077759 40.8985214233399,14.2035436630249 40.8958015441896,14.2053565979003 40.8910636901855,14.203037261963 40.8862075805664,14.1774053573608 40.8755187988281,14.1667814254762 40.8729400634766,14.1565465927125 40.8686485290528,14.1565465927125 40.8686485290528,14.1561717987062 40.8702239990234,14.1594419479371 40.8836860656738,14.1551141738891 40.8964385986329,14.1469268798828 40.8989143371582,14.1389131546021 40.8962287902832,14.1245737075807 40.8979034423829,14.1207790374756 40.9020729064943,14.1202983856202 40.9044609069824)) | 0.0006 | POINT(14.1657093048096 40.894304504394576) |
39725 | POLYGON((4.00727367401134 43.6433029174805,3.98580861091619 43.6539306640626,3.98580861091619 43.6539306640626,3.99378395080566 43.6557273864747,3.99049353599554 43.6618347167969,3.99049353599554 43.6618347167969,3.9960350990296 43.6675872802735,4.00948619842535 43.6718521118165,4.01885604858404 43.6738014221192,4.02277278900152 43.6716651916504,4.02277278900152 43.6716651916504,4.02508354187023 43.6650047302247,4.03463935852056 43.6573448181152,4.03463935852056 43.6573448181152,4.03016662597656 43.6581420898437,4.02584266662598 43.6492309570312,4.01365232467663 43.6459426879882,4.01348447799694 43.6392593383788,4.01348447799694 43.6392593383788,4.00727367401134 43.6433029174805)) | 0.0006 | POINT(4.0112935618350996 43.65782426532948) |
49099 | POLYGON((-0.934229910373688 46.3601112365723,-0.941577553749028 46.3401222229005,-0.958678126335087 46.3233451843263,-0.933909475803262 46.312629699707,-0.915043354034424 46.3155326843263,-0.912085711955967 46.3127479553223,-0.912085711955967 46.3127479553223,-0.895424485206604 46.3168449401857,-0.886848092079106 46.3267059326173,-0.886848092079106 46.3267059326173,-0.888514161109924 46.3369522094727,-0.883947551250458 46.3468704223633,-0.883947551250458 46.3468704223633,-0.890893816947937 46.3511772155763,-0.897080659866333 46.3459167480469,-0.901978492736816 46.3459587097169,-0.915995180606842 46.355339050293,-0.934229910373688 46.3601112365723)) | 0.0006 | POINT(-0.9081816427847652 46.333916383631156) |
61140 | POLYGON((7.66053009033214 46.2373619079589,7.65242004394531 46.2408905029296,7.64939689636236 46.2447013854981,7.64939689636236 46.2447013854981,7.64940023422253 46.2475700378419,7.64940023422253 46.2475700378419,7.65388298034668 46.2532424926759,7.65785217285168 46.2542572021484,7.66136598587036 46.2573776245118,7.66320705413813 46.2603607177734,7.66370582580566 46.2648391723633,7.66654586792004 46.2682685852051,7.66665697097778 46.2731094360353,7.66503381729132 46.2779655456544,7.66551399230963 46.2948417663575,7.66912078857433 46.2983016967773,7.67533779144293 46.2975273132325,7.68100786209112 46.2988471984864,7.6865701675415 46.3016548156738,7.6897120475769 46.3019256591796,7.6897120475769 46.3019256591796,7.68603801727295 46.2969970703125,7.68470478057873 46.2901725769044,7.68470478057873 46.2901725769044,7.68480110168468 46.2881393432618,7.68351984024054 46.2871170043946,7.6839418411256 46.285499572754,7.6839418411256 46.285499572754,7.67891597747803 46.2845344543457,7.67572498321545 46.2826232910157,7.67666578292841 46.2733802795411,7.67820501327515 46.2705078125,7.67806911468517 46.2636451721193,7.67366695404064 46.2593727111817,7.67449903488165 46.255340576172,7.67039394378668 46.2513465881348,7.67070293426525 46.2475547790528,7.66254711151117 46.2415657043457,7.66053009033214 46.2373619079589)) | 0.0006 | POINT(7.670968758432543 46.27159761127676) |
60894 | POLYGON((9.03173637390137 46.2369804382324,9.04302978515625 46.2356414794922,9.05316257476807 46.235668182373,9.05316257476807 46.235668182373,9.05094623565668 46.2298698425294,9.05126094818115 46.2256011962892,9.05314254760748 46.2234649658204,9.07364845275879 46.2156791687012,9.07581901550293 46.2130928039552,9.08105373382574 46.2103919982911,9.08763027191156 46.2101364135743,9.09136295318604 46.2123489379883,9.09136295318604 46.2123489379883,9.11765098571783 46.201385498047,9.12778282165533 46.1916770935059,9.13013744354254 46.1863784790039,9.13745021820068 46.1824569702149,9.13745021820068 46.1824569702149,9.1305017471314 46.1813774108887,9.11008739471436 46.1815299987793,9.10317611694347 46.1842155456544,9.08276176452642 46.185359954834,9.07708072662359 46.1873741149903,9.07708072662359 46.1873741149903,9.06667518615734 46.1885833740236,9.06279087066656 46.1907768249513,9.05957221984869 46.1947593688965,9.05912590026867 46.2011299133301,9.05434703826899 46.2053337097168,9.04037380218506 46.2049064636232,9.03948116302496 46.2135581970215,9.03948116302496 46.2135581970215,9.03884410858166 46.2185020446777,9.03398132324224 46.2321510314943,9.03398132324224 46.2321510314943,9.03173637390137 46.2369804382324)) | 0.0006 | POINT(9.074203790937183 46.2069682529995) |
45663 | POLYGON((1.84052288532263 44.8079452514648,1.85181891918188 44.8184280395508,1.87508189678192 44.8083992004395,1.88404762744915 44.810417175293,1.88404762744915 44.810417175293,1.88417565822607 44.8097000122071,1.88417565822607 44.8097000122071,1.88609385490417 44.8029022216798,1.88005137443548 44.7900657653808,1.88066375255596 44.7866134643555,1.88864541053783 44.7825965881349,1.87838149070751 44.759677886963,1.87838149070751 44.759677886963,1.8718638420105 44.7614021301271,1.8718638420105 44.7614021301271,1.86674296855932 44.7671775817871,1.85319018363958 44.770450592041,1.8472558259964 44.7756805419922,1.83592355251307 44.761302947998,1.83592355251307 44.761302947998,1.82679533958446 44.7657165527345,1.82679533958446 44.7657165527345,1.82320833206177 44.7722434997559,1.81483840942377 44.7759361267091,1.81866025924688 44.7781448364257,1.81866025924688 44.7781448364257,1.83090066909796 44.7822456359863,1.83372616767883 44.7953605651857,1.82923853397381 44.796501159668,1.82923853397381 44.796501159668,1.84052288532263 44.8079452514648)) | 0.0006 | POINT(1.8543637752533466 44.78405901590988) |
67718 | POLYGON((9.70800781250006 48.4179573059083,9.70621776580822 48.420078277588,9.70174217224132 48.4219589233398,9.7028751373291 48.4204406738281,9.69112682342535 48.4242553710938,9.67979335784918 48.4242095947267,9.67898750305176 48.4271507263185,9.68350124359131 48.4278869628906,9.68736648559582 48.4302520751954,9.68625354766857 48.4321517944337,9.68908977508556 48.4322624206544,9.68908977508556 48.4322624206544,9.6884822845459 48.4354591369629,9.68938636779791 48.4396476745605,9.69251251220703 48.4385261535645,9.69400405883795 48.4423065185548,9.69797229766846 48.4418144226075,9.70012187957775 48.4442214965821,9.69520282745373 48.4458503723146,9.69498729705822 48.4491043090821,9.69315242767345 48.4497375488282,9.69081401824945 48.4562835693359,9.68689250946051 48.4579544067384,9.68676376342779 48.4624137878419,9.68556022644037 48.463249206543,9.68689346313477 48.4652366638184,9.68569087982183 48.4667663574218,9.67854595184332 48.4687271118164,9.67493534088129 48.4671363830567,9.66901302337646 48.4679107666015,9.67045879364014 48.4695854187012,9.66639423370367 48.4684562683106,9.66109657287598 48.4690551757812,9.65936851501476 48.4673614501953,9.6562328338623 48.4680557250978,9.65659046173096 48.4669342041017,9.65479373931885 48.4668312072755,9.65595054626476 48.4648437500001,9.64769077301025 48.4655075073243,9.6481208801269 48.4633445739747,9.64434814453136 48.46337890625,9.64498615264898 48.4600944519044,9.63931179046637 48.4606590270997,9.63869667053234 48.4579925537109,9.63620567321777 48.456642150879,9.62788963317877 48.4574966430665,9.62769794464123 48.4591827392578,9.62474822998041 48.4585571289062,9.61989307403576 48.4601554870607,9.61989307403576 48.4601554870607,9.62117195129389 48.4574432373047,9.6267929077149 48.453052520752,9.62663841247559 48.4495811462403,9.6297979354859 48.4467544555664,9.63216590881353 48.4427986145021,9.63218307495123 48.4395179748536,9.63526439666759 48.4349479675294,9.63620090484631 48.4278144836426,9.63877868652349 48.4244499206544,9.63674831390375 48.4185829162599,9.62946701049805 48.418270111084,9.62946701049805 48.418270111084,9.63058757781982 48.4162063598634,9.63777351379389 48.413646697998,9.63817596435547 48.4150161743165,9.64174938201916 48.4156684875489,9.64911079406744 48.4149665832521,9.65271949768066 48.4164161682129,9.65324878692638 48.4154663085938,9.65598106384272 48.4152793884278,9.65663146972656 48.4174804687501,9.66217517852789 48.4187355041505,9.66094493865967 48.4211730957031,9.66525650024425 48.4218330383302,9.66532611846924 48.4248657226562,9.66383457183849 48.4252128601075,9.66595554351818 48.4275856018066,9.66896343231207 48.4271049499512,9.67033767700201 48.4225654602052,9.67766761779785 48.4244918823243,9.67901515960699 48.4222526550293,9.68421936035168 48.4228553771973,9.68598079681396 48.41849899292,9.68962097167969 48.4189300537109,9.69963169097906 48.4163627624512,9.70513439178461 48.4185409545898,9.70800781250006 48.4179573059083)) | 0.0006 | POINT(9.664303125337154 48.440001642981265) |