search

terraref / data-paper

0 stars 1 forks source link

Make trait data from seasons 4 and 6 in BETYdb public #1

Closed dlebauer closed 4 years ago

dlebauer commented 4 years ago 
begin; 
update traits
set access_level = 4 
where
site_id in (select id from sites where (sitename like '%Season 4%' OR sitename like '%Season 4%Range 30%'))
and checked > -1;
commit;

to ensure we are holding back data that failed qaqc:

begin;
update traits
set access_level = 1 
where checked < 0;
commit;