--benthos aantal
update pruts.t1benthos set value = aantal where soortnaam is not null;
update pruts.t1benthos set value = 0 where idparameter = 42543;
update pruts.t1benthos set value = null where soortnaam = null;
update pruts.t1benthos set idmethod = 49 where soortnaam is not null;
update pruts.t1benthos set idobservation_type = 16 where soortnaam is not null;
update pruts.t1benthos set idunit = 18 where soortnaam is not null;
update pruts.t1benthos set quality = 1 where soortnaam is not null;

insert into observation 
 (idmethod,idunit,date,value,idlocation,idparameter,idobservation_type,idsample,idquality,remark)
select
 i.idmethod
,i.idunit
,i.date
,i.value
,i.idlocation
,i.idparameter
,i.idobservation_type
,i.locid
,i.quality
,i.kwaliteit_determinatie
FROM
 pruts.t1benthos i where soortnaam is not null and value is not null and date = '20081015' or date = '20081020';

--benthos Natgewicht
update pruts.t1benthos set value = natgewicht_mg where soortnaam is not null;
update pruts.t1benthos set value = 0 where natgewicht_mg = null;
update pruts.t1benthos set value = null where idparameter = 42543;
update pruts.t1benthos set idobservation_type = 4 where soortnaam is not null;
update pruts.t1benthos set idunit = 33 where soortnaam is not null;
update pruts.t1benthos set quality = 1;
update pruts.t1benthos set idmethod = 0 where quality = 1;

insert into observation 
 (idmethod,idunit,date,value,idlocation,idparameter,idobservation_type,idsample,idquality,remark)
select
 i.idmethod
,i.idunit
,i.date
,i.value
,i.idlocation
,i.idparameter
,i.idobservation_type
,i.locid
,i.quality
,i.kwaliteit_determinatie
FROM
 pruts.t1benthos i where natgewicht_mg is not null and value is not null and date = '20081015' or date = '20081020';


--benthos Asvrij drooggewicht
update pruts.t1benthos set value = asvrdrooggewicht_mg where soortnaam is not null;
update pruts.t1benthos set value = 0 where idparameter = 42543;
update pruts.t1benthos set value = null where asvrdrooggewicht_mg = null;
update pruts.t1benthos set idobservation_type = 5 where soortnaam is not null;
update pruts.t1benthos set idunit = 33 where soortnaam is not null;
update pruts.t1benthos set quality = 1;
update pruts.t1benthos set idmethod = 0 where quality =1;

insert into observation 
 (idmethod,idunit,date,value,idlocation,idparameter,idobservation_type,idsample,idquality,remark)
select
 i.idmethod
,i.idunit
,i.date
,i.value
,i.idlocation
,i.idparameter
,i.idobservation_type
,i.locid
,i.quality
,i.kwaliteit_determinatie
FROM
 pruts.t1benthos i where asvrdrooggewicht_mg is not null and value is not null and date = '20081015' or date = '20081020';

--benthos Dichtheid
update pruts.t1benthos set value = dichtheid where dichtheid is not null;
update pruts.t1benthos set value = null where dichtheid is null;
update pruts.t1benthos set idmethod = 43 where dichtheid is not null;
update pruts.t1benthos set idobservation_type = 3 where dichtheid is not null;
update pruts.t1benthos set idunit = 4 where dichtheid is not null;
update pruts.t1benthos set quality = 1 where dichtheid is not null;

insert into observation 
 (idmethod,idunit,date,value,idlocation,idparameter,idobservation_type,idsample,idquality,remark)
select
 i.idmethod
,i.idunit
,i.date
,i.value
,i.idlocation
,i.idparameter
,i.idobservation_type
,i.locid
,i.quality
,i.kwaliteit_determinatie
FROM
 pruts.t1benthos i where dichtheid is not null and value is not null and date = '20081015' or date = '20081020';

--benthos Massa
update pruts.t1benthos set value = massa_mg_m2 where massa_mg_m2 is not null;
update pruts.t1benthos set value = null where massa_mg_m2 is null;
update pruts.t1benthos set idmethod = 0 where massa_mg_m2 is not null;
update pruts.t1benthos set idobservation_type = 13 where massa_mg_m2 is not null;
update pruts.t1benthos set idunit = 6 where massa_mg_m2 is not null;
update pruts.t1benthos set quality = 1 where massa_mg_m2 is not null;

insert into observation 
 (idmethod,idunit,date,value,idlocation,idparameter,idobservation_type,idsample,idquality,remark)
select
 i.idmethod
,i.idunit
,i.date
,i.value
,i.idlocation
,i.idparameter
,i.idobservation_type
,i.locid
,i.quality
,i.kwaliteit_determinatie
FROM
 pruts.t1benthos i where massa_mg_m2 is not null and value is not null and date = '20081015' or date = '20081020';

--benthos Biomassa
update pruts.t1benthos set value = biomassa_mg_m2 where biomassa_mg_m2 is not null;
update pruts.t1benthos set value = null where biomassa_mg_m2 is null;
update pruts.t1benthos set idmethod = 0 where biomassa_mg_m2 is not null;
update pruts.t1benthos set idobservation_type = 34 where biomassa_mg_m2 is not null;
update pruts.t1benthos set idunit = 6 where biomassa_mg_m2 is not null;
update pruts.t1benthos set quality = 1 where biomassa_mg_m2 is not null;

insert into observation 
 (idmethod,idunit,date,value,idlocation,idparameter,idobservation_type,idsample,idquality,remark)
select
 i.idmethod
,i.idunit
,i.date
,i.value
,i.idlocation
,i.idparameter
,i.idobservation_type
,i.locid
,i.quality
,i.kwaliteit_determinatie
FROM
 pruts.t1benthos i where biomassa_mg_m2 is not null and value is not null and date = '20081015' or date = '20081020';