PageRenderTime 28ms CodeModel.GetById 1ms app.highlight 24ms RepoModel.GetById 1ms app.codeStats 0ms

/database/layers_prod_updates/019_update_keywords_190811.sql

http://alageospatialportal.googlecode.com/
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;