spent a long time messing w/ regex before doing it the 'easy' way

fix_season4_treatments.sql

select treatments.name, count ( * ) as n 
from treatments join traits on treatments.id = traits.treatment_id 
where
	extract ( year from date ) = 2017 
	and extract ( month from date ) between 4 and 10 
	and checked > - 1 
group by treatments.name;

select treatments.name, count ( distinct site_id) as nsites 
from treatments join traits on treatments.id = traits.treatment_id 
where
	extract ( year from date ) = 2017 
	and extract ( month from date ) between 4 and 10 
	and checked > - 1 
group by treatments.name;

/-- no irrigation Aug 1-14 in Cols 5, 6, 7, 8, 12, 13, 14, 15 and 16\r\n* no irrigation Aug 15-30 in Cols 1, 2, 3, 4, 9, 10, and 11\r\n"


begin;
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 1$');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 2$');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 3$');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 4$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 5$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 6$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 7$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 8$');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 9$');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 10$');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 11$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 12$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 13$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 14$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 15$');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 16$');
commit;

rollback;
begin;
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 1 E');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 2 E');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 3 E');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 4 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 5 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 6 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 7 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 8 E');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 9 E');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 10 E');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 11 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 12 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 13 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 14 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 15 E');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 16 E');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 1 W');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 2 W');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 3 W');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 4 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 5 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 6 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 7 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 8 W');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 9 W');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 10 W');
update traits set treatment_id = 6000000026 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 11 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 12 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 13 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 14 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 15 W');
update traits set treatment_id = 6000000024 where site_id in (select id from sites where sitename like '%Season 4%' and sitename ~ 'Column 16 W');
commit;