/database/layers_prod_updates/019_update_keywords_190811.sql
SQL | 193 lines | 192 code | 1 blank | 0 comment | 0 complexity | 59fab808d2be31fd94a5dd208cdc313f MD5 | raw file
1\set ON_ERROR_STOP 1 2ALTER TABLE layers ADD COLUMN keywords character varying(255); 3 4update layers set keywords='reserve, coral, conservation' where id=900; 5update layers set keywords='coral' where id=917; 6update layers set keywords='IUCN, reserve, park, conservation' where id=896; 7update layers set keywords='reserve, water, bird' where id=901; 8update layers set keywords='bioregion, ecoregion, system' where id=20; 9update layers set keywords='bioregion, ecoregion, system' where id=914; 10update layers set keywords='bioregion, ecoregion, system, marine' where id=21; 11update layers set keywords='adminisration, government, landcare, heritage, local' where id=916; 12update layers set keywords='reserve, water, bird' where id=915; 13update layers set keywords='farm, SLA, cereal, manage' where id=612; 14update layers set keywords='farm, SLA, cereal, manage' where id=604; 15update layers set keywords='farm, SLA, water, manage' where id=613; 16update layers set keywords='farm, cereal, SLA, manage' where id=614; 17update layers set keywords='farm, cereal, SLA, manage' where id=605; 18update layers set keywords='farm, cereal, SLA, manage' where id=611; 19update layers set keywords='farm, cereal, SLA, manage' where id=606; 20update layers set keywords='GER, IBRA, ecoregion, bioregion' where id=902; 21update layers set keywords='GER, administrate, manage' where id=903; 22update layers set keywords='GER, manage, adminstrate, region, border, coast, hunter, Kosciuszko, slope, summit' where id=904; 23update layers set keywords='GER, administrative, manage' where id=905; 24update layers set keywords='GER, administrative, manage, region' where id=906; 25update layers set keywords='GER, administrative, manage, region' where id=907; 26update layers set keywords='GER, manage, adminstrate, region, border, coast, hunter, Kosciuszko, slope, summit, region' where id=908; 27update layers set keywords='GER, region, administrate, region' where id=909; 28update layers set keywords='GER, slope, summit, region' where id=910; 29update layers set keywords='GER, slope, summit, manage, region' where id=911; 30update layers set keywords='GER, slope, summit, manage, region' where id=912; 31update layers set keywords='GER, region' where id=913; 32update layers set keywords='landuse, manage' where id=678; 33update layers set keywords='region, funds' where id=591; 34update layers set keywords='threatened, bird' where id=682; 35update layers set keywords='average, sample' where id=898; 36update layers set keywords='diversity, occurrence, sample, average' where id=899; 37update layers set keywords='endangered, vulnerable, critical' where id=681; 38update layers set keywords='water, temperature, precipitation, rain' where id=747; 39update layers set keywords='water, temperature, precipitation, rain' where id=668; 40update layers set keywords='water, temperature, precipitation, rain' where id=767; 41update layers set keywords='water, temperature, precipitation, rain' where id=720; 42update layers set keywords='water, temperature, precipitation, rain' where id=671; 43update layers set keywords='water, temperature, precipitation, rain, capacity' where id=722; 44update layers set keywords='water, temperature, precipitation, rain, capacity' where id=731; 45update layers set keywords='water, temperature, precipitation, rain, capacity' where id=751; 46update layers set keywords='temperature, moisture' where id=728; 47update layers set keywords='temperature, moisture' where id=746; 48update layers set keywords='temperature, moisture' where id=743; 49update layers set keywords='temperature, moisture' where id=742; 50update layers set keywords='temperature, moisture' where id=749; 51update layers set keywords='temperature, moisture' where id=744; 52update layers set keywords='temperature, moisture' where id=738; 53update layers set keywords='temperature, moisture' where id=757; 54update layers set keywords='temperature, moisture' where id=733; 55update layers set keywords='temperature, moisture' where id=732; 56update layers set keywords='temperature, moisture' where id=724; 57update layers set keywords='temperature, moisture' where id=735; 58update layers set keywords='evaporation, rain, precipitation, temperature' where id=715; 59update layers set keywords='evaporation, rain, precipitation, temperature' where id=719; 60update layers set keywords='evaporation, rain, precipitation, temperature' where id=765; 61update layers set keywords='rain' where id=598; 62update layers set keywords='rain' where id=893; 63update layers set keywords='rain' where id=734; 64update layers set keywords='rain' where id=713; 65update layers set keywords='rain' where id=772; 66update layers set keywords='rain' where id=745; 67update layers set keywords='rain' where id=594; 68update layers set keywords='rain' where id=600; 69update layers set keywords='rain' where id=863; 70update layers set keywords='rain' where id=726; 71update layers set keywords='rain' where id=872; 72update layers set keywords='rain' where id=889; 73update layers set keywords='rain' where id=718; 74update layers set keywords='rain' where id=779; 75update layers set keywords='rain' where id=754; 76update layers set keywords='rain' where id=882; 77update layers set keywords='rain' where id=750; 78update layers set keywords='rain' where id=602; 79update layers set keywords='rain' where id=758; 80update layers set keywords='rain' where id=766; 81update layers set keywords='rain' where id=593; 82update layers set keywords='rain' where id=601; 83update layers set keywords='rain' where id=764; 84update layers set keywords='rain' where id=778; 85update layers set keywords='rain' where id=595; 86update layers set keywords='rain' where id=878; 87update layers set keywords='rain' where id=711; 88update layers set keywords='rain' where id=866; 89update layers set keywords='rain' where id=886; 90update layers set keywords='rain' where id=596; 91update layers set keywords='rain' where id=599; 92update layers set keywords='rain' where id=740; 93update layers set keywords='rain' where id=712; 94update layers set keywords='rain' where id=763; 95update layers set keywords='rain' where id=788; 96update layers set keywords='rain' where id=786; 97update layers set keywords='rain' where id=791; 98update layers set keywords='rain' where id=782; 99update layers set keywords='rain' where id=794; 100update layers set keywords='rain' where id=797; 101update layers set keywords='rain' where id=798; 102update layers set keywords='rain' where id=796; 103update layers set keywords='solar, sun' where id=881; 104update layers set keywords='solar, sun' where id=869; 105update layers set keywords='solar, sun' where id=861; 106update layers set keywords='solar, sun' where id=880; 107update layers set keywords='solar, sun' where id=871; 108update layers set keywords='solar, sun' where id=768; 109update layers set keywords='solar, sun' where id=770; 110update layers set keywords='solar, sun' where id=887; 111update layers set keywords='solar, sun' where id=894; 112update layers set keywords='solar, sun' where id=877; 113update layers set keywords='day, daily, season, ratio' where id=883; 114update layers set keywords='variation, mean, ratio' where id=892; 115update layers set keywords='rain, precipitation' where id=870; 116update layers set keywords='day, daily, max, ratio' where id=785; 117update layers set keywords='precipitation, rain' where id=799; 118update layers set keywords='diurnal, day, daily, season, ratio' where id=790; 119update layers set keywords='range, mean, ratio' where id=783; 120update layers set keywords='rain, precipitation' where id=784; 121update layers set keywords='speed, distance' where id=860; 122update layers set keywords='speed, distance' where id=854; 123update layers set keywords='speed, distance' where id=857; 124update layers set keywords='population, infrastructure, towns, service' where id=647; 125update layers set keywords='water, runoff' where id=670; 126update layers set keywords='water, runoff' where id=666; 127update layers set keywords='water, runoff' where id=672; 128update layers set keywords='CARS, marine' where id=802; 129update layers set keywords='CARS, marine' where id=803; 130update layers set keywords='CARS, marine' where id=804; 131update layers set keywords='CARS, marine' where id=801; 132update layers set keywords='CARS, marine' where id=800; 133update layers set keywords='CARS, marine' where id=805; 134update layers set keywords='nation, state, political' where id=922; 135update layers set keywords='political' where id=22; 136update layers set keywords='local, government, area, administate, region, state, territory' where id=23; 137update layers set keywords='lithology, rock, outcrop, unit, stratigraph' where id=923; 138update layers set keywords='soil, calcium, lithology' where id=829; 139update layers set keywords='soil, primary, productivity, NPP' where id=837; 140update layers set keywords='nutrient, soil, rock' where id=838; 141update layers set keywords='soil, nutrient' where id=831; 142update layers set keywords='soil, nutrient' where id=821; 143update layers set keywords='soil, nutrient' where id=822; 144update layers set keywords='soil, fertility, nitrogen, phosphorus, potassium' where id=843; 145update layers set keywords='soil, fertility' where id=811; 146update layers set keywords='soil, fertility' where id=828; 147update layers set keywords='soil, fertility' where id=817; 148update layers set keywords='soil, sodium, water' where id=664; 149update layers set keywords='evaporation, water, temperature' where id=755; 150update layers set keywords='evaporation, water, temperature' where id=736; 151update layers set keywords='evaporation, water, temperature' where id=771; 152update layers set keywords='soil, permiability, saturation' where id=833; 153update layers set keywords='soil, permiability, saturation' where id=842; 154update layers set keywords='soil, water, saturation' where id=669; 155update layers set keywords='soil, water, saturation' where id=667; 156update layers set keywords='soil, water, saturation' where id=891; 157update layers set keywords='soil, water, saturation' where id=873; 158update layers set keywords='soil, water, saturation' where id=884; 159update layers set keywords='soil, water, saturation' where id=865; 160update layers set keywords='soil, water, saturation' where id=895; 161update layers set keywords='soil, water, saturation' where id=864; 162update layers set keywords='soil, water, saturation' where id=885; 163update layers set keywords='soil, water, saturation, temperature' where id=868; 164update layers set keywords='soil, structure, water' where id=825; 165update layers set keywords='soil, slope, water' where id=826; 166update layers set keywords='soil, capacity, water' where id=818; 167update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=714; 168update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=706; 169update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=727; 170update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=662; 171update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=812; 172update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=717; 173update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=723; 174update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=721; 175update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=708; 176update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=748; 177update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=709; 178update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=773; 179update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=777; 180update layers set keywords='soil, structure, porosity' where id=806; 181update layers set keywords='soil, grain' where id=814; 182update layers set keywords='erosion, stability, slope, friability' where id=661; 183update layers set keywords='erosion, stability, slope, friability' where id=823; 184update layers set keywords='erosion, stability, slope, friability' where id=597; 185update layers set keywords='soil, horizon' where id=816; 186update layers set keywords='soil, structure, porosity, grain' where id=841; 187update layers set keywords='soil, grain' where id=845; 188update layers set keywords='angle, direction' where id=680; 189update layers set keywords='depth' where id=848; 190update layers set keywords='height' where id=674; 191update layers set keywords='elevation, height, difference' where id=827; 192update layers set keywords='elevation, height, difference' where id=844; 193update layers set keywords='angle' where id=836;