\set ON_ERROR_STOP 1
ALTER TABLE layers ADD COLUMN keywords character varying(255);

update layers set keywords='reserve, coral, conservation' where id=900;
update layers set keywords='coral' where id=917;
update layers set keywords='IUCN, reserve, park, conservation' where id=896;
update layers set keywords='reserve, water, bird' where id=901;
update layers set keywords='bioregion, ecoregion, system' where id=20;
update layers set keywords='bioregion, ecoregion, system' where id=914;
update layers set keywords='bioregion, ecoregion, system, marine' where id=21;
update layers set keywords='adminisration, government, landcare, heritage, local' where id=916;
update layers set keywords='reserve, water, bird' where id=915;
update layers set keywords='farm, SLA, cereal, manage' where id=612;
update layers set keywords='farm, SLA, cereal, manage' where id=604;
update layers set keywords='farm, SLA, water, manage' where id=613;
update layers set keywords='farm, cereal, SLA, manage' where id=614;
update layers set keywords='farm, cereal, SLA, manage' where id=605;
update layers set keywords='farm, cereal, SLA, manage' where id=611;
update layers set keywords='farm, cereal, SLA, manage' where id=606;
update layers set keywords='GER, IBRA, ecoregion, bioregion' where id=902;
update layers set keywords='GER, administrate, manage' where id=903;
update layers set keywords='GER, manage, adminstrate, region, border, coast, hunter, Kosciuszko, slope, summit' where id=904;
update layers set keywords='GER, administrative, manage' where id=905;
update layers set keywords='GER, administrative, manage, region' where id=906;
update layers set keywords='GER, administrative, manage, region' where id=907;
update layers set keywords='GER, manage, adminstrate, region, border, coast, hunter, Kosciuszko, slope, summit, region' where id=908;
update layers set keywords='GER, region, administrate, region' where id=909;
update layers set keywords='GER, slope, summit, region' where id=910;
update layers set keywords='GER, slope, summit, manage, region' where id=911;
update layers set keywords='GER, slope, summit, manage, region' where id=912;
update layers set keywords='GER, region' where id=913;
update layers set keywords='landuse, manage' where id=678;
update layers set keywords='region, funds' where id=591;
update layers set keywords='threatened, bird' where id=682;
update layers set keywords='average, sample' where id=898;
update layers set keywords='diversity, occurrence, sample, average' where id=899;
update layers set keywords='endangered, vulnerable, critical' where id=681;
update layers set keywords='water, temperature, precipitation, rain' where id=747;
update layers set keywords='water, temperature, precipitation, rain' where id=668;
update layers set keywords='water, temperature, precipitation, rain' where id=767;
update layers set keywords='water, temperature, precipitation, rain' where id=720;
update layers set keywords='water, temperature, precipitation, rain' where id=671;
update layers set keywords='water, temperature, precipitation, rain, capacity' where id=722;
update layers set keywords='water, temperature, precipitation, rain, capacity' where id=731;
update layers set keywords='water, temperature, precipitation, rain, capacity' where id=751;
update layers set keywords='temperature, moisture' where id=728;
update layers set keywords='temperature, moisture' where id=746;
update layers set keywords='temperature, moisture' where id=743;
update layers set keywords='temperature, moisture' where id=742;
update layers set keywords='temperature, moisture' where id=749;
update layers set keywords='temperature, moisture' where id=744;
update layers set keywords='temperature, moisture' where id=738;
update layers set keywords='temperature, moisture' where id=757;
update layers set keywords='temperature, moisture' where id=733;
update layers set keywords='temperature, moisture' where id=732;
update layers set keywords='temperature, moisture' where id=724;
update layers set keywords='temperature, moisture' where id=735;
update layers set keywords='evaporation, rain, precipitation, temperature' where id=715;
update layers set keywords='evaporation, rain, precipitation, temperature' where id=719;
update layers set keywords='evaporation, rain, precipitation, temperature' where id=765;
update layers set keywords='rain' where id=598;
update layers set keywords='rain' where id=893;
update layers set keywords='rain' where id=734;
update layers set keywords='rain' where id=713;
update layers set keywords='rain' where id=772;
update layers set keywords='rain' where id=745;
update layers set keywords='rain' where id=594;
update layers set keywords='rain' where id=600;
update layers set keywords='rain' where id=863;
update layers set keywords='rain' where id=726;
update layers set keywords='rain' where id=872;
update layers set keywords='rain' where id=889;
update layers set keywords='rain' where id=718;
update layers set keywords='rain' where id=779;
update layers set keywords='rain' where id=754;
update layers set keywords='rain' where id=882;
update layers set keywords='rain' where id=750;
update layers set keywords='rain' where id=602;
update layers set keywords='rain' where id=758;
update layers set keywords='rain' where id=766;
update layers set keywords='rain' where id=593;
update layers set keywords='rain' where id=601;
update layers set keywords='rain' where id=764;
update layers set keywords='rain' where id=778;
update layers set keywords='rain' where id=595;
update layers set keywords='rain' where id=878;
update layers set keywords='rain' where id=711;
update layers set keywords='rain' where id=866;
update layers set keywords='rain' where id=886;
update layers set keywords='rain' where id=596;
update layers set keywords='rain' where id=599;
update layers set keywords='rain' where id=740;
update layers set keywords='rain' where id=712;
update layers set keywords='rain' where id=763;
update layers set keywords='rain' where id=788;
update layers set keywords='rain' where id=786;
update layers set keywords='rain' where id=791;
update layers set keywords='rain' where id=782;
update layers set keywords='rain' where id=794;
update layers set keywords='rain' where id=797;
update layers set keywords='rain' where id=798;
update layers set keywords='rain' where id=796;
update layers set keywords='solar, sun' where id=881;
update layers set keywords='solar, sun' where id=869;
update layers set keywords='solar, sun' where id=861;
update layers set keywords='solar, sun' where id=880;
update layers set keywords='solar, sun' where id=871;
update layers set keywords='solar, sun' where id=768;
update layers set keywords='solar, sun' where id=770;
update layers set keywords='solar, sun' where id=887;
update layers set keywords='solar, sun' where id=894;
update layers set keywords='solar, sun' where id=877;
update layers set keywords='day, daily, season, ratio' where id=883;
update layers set keywords='variation, mean, ratio' where id=892;
update layers set keywords='rain, precipitation' where id=870;
update layers set keywords='day, daily, max, ratio' where id=785;
update layers set keywords='precipitation, rain' where id=799;
update layers set keywords='diurnal, day, daily, season, ratio' where id=790;
update layers set keywords='range, mean, ratio' where id=783;
update layers set keywords='rain, precipitation' where id=784;
update layers set keywords='speed, distance' where id=860;
update layers set keywords='speed, distance' where id=854;
update layers set keywords='speed, distance' where id=857;
update layers set keywords='population, infrastructure, towns, service' where id=647;
update layers set keywords='water, runoff' where id=670;
update layers set keywords='water, runoff' where id=666;
update layers set keywords='water, runoff' where id=672;
update layers set keywords='CARS, marine' where id=802;
update layers set keywords='CARS, marine' where id=803;
update layers set keywords='CARS, marine' where id=804;
update layers set keywords='CARS, marine' where id=801;
update layers set keywords='CARS, marine' where id=800;
update layers set keywords='CARS, marine' where id=805;
update layers set keywords='nation, state, political' where id=922;
update layers set keywords='political' where id=22;
update layers set keywords='local, government, area, administate, region, state, territory' where id=23;
update layers set keywords='lithology, rock, outcrop, unit, stratigraph' where id=923;
update layers set keywords='soil, calcium, lithology' where id=829;
update layers set keywords='soil, primary, productivity, NPP' where id=837;
update layers set keywords='nutrient, soil, rock' where id=838;
update layers set keywords='soil, nutrient' where id=831;
update layers set keywords='soil, nutrient' where id=821;
update layers set keywords='soil, nutrient' where id=822;
update layers set keywords='soil, fertility, nitrogen, phosphorus, potassium' where id=843;
update layers set keywords='soil, fertility' where id=811;
update layers set keywords='soil, fertility' where id=828;
update layers set keywords='soil, fertility' where id=817;
update layers set keywords='soil,  sodium, water' where id=664;
update layers set keywords='evaporation, water, temperature' where id=755;
update layers set keywords='evaporation, water, temperature' where id=736;
update layers set keywords='evaporation, water, temperature' where id=771;
update layers set keywords='soil, permiability, saturation' where id=833;
update layers set keywords='soil, permiability, saturation' where id=842;
update layers set keywords='soil, water, saturation' where id=669;
update layers set keywords='soil, water, saturation' where id=667;
update layers set keywords='soil, water, saturation' where id=891;
update layers set keywords='soil, water, saturation' where id=873;
update layers set keywords='soil, water, saturation' where id=884;
update layers set keywords='soil, water, saturation' where id=865;
update layers set keywords='soil, water, saturation' where id=895;
update layers set keywords='soil, water, saturation' where id=864;
update layers set keywords='soil, water, saturation' where id=885;
update layers set keywords='soil, water, saturation, temperature' where id=868;
update layers set keywords='soil, structure, water' where id=825;
update layers set keywords='soil, slope, water' where id=826;
update layers set keywords='soil, capacity, water' where id=818;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=714;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=706;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=727;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=662;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=812;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=717;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=723;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=721;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=708;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=748;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=709;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=773;
update layers set keywords='soil, evaporation, temperature, rain, precipitation' where id=777;
update layers set keywords='soil, structure, porosity' where id=806;
update layers set keywords='soil, grain' where id=814;
update layers set keywords='erosion, stability, slope, friability' where id=661;
update layers set keywords='erosion, stability, slope, friability' where id=823;
update layers set keywords='erosion, stability, slope, friability' where id=597;
update layers set keywords='soil, horizon' where id=816;
update layers set keywords='soil, structure, porosity, grain' where id=841;
update layers set keywords='soil, grain' where id=845;
update layers set keywords='angle, direction' where id=680;
update layers set keywords='depth' where id=848;
update layers set keywords='height' where id=674;
update layers set keywords='elevation, height, difference' where id=827;
update layers set keywords='elevation, height, difference' where id=844;
update layers set keywords='angle' where id=836;