select (soortnaam) from pruts.t1benthos where idparameter = 42544

select (soortnaam) from pruts.t0benthos where idparameter is null

insert into parameter_worms (aphiaid,scientificname,authority,status,aphiaid_accepted,kingdom,phylum,class,"order",family) values
	(919,'Cirratulidae','Checked by Taxonomic Editor','accepted',919,'Animalia','Annelida','Polychaeta','Terebellida','Cirratulidae')

insert into parameter (parameterdescription,foreignkey,referencetable) values
	('Cirratulidae',919,'parameter_worms')

select * from parameter_worms where phylum = 'Echinodermata'

update pruts.t2benthos s
set idlocation = l.idlocation
from location l
where st_within(l.thegeometry, st_buffer( st_transform(s.geom, 4326) , 8.1818181818181818181818181818182e-6))

update pruts.t2benthos set geom = st_transform(st_setsrid(st_point(wgs84_e,wgs84_n),4326),4326)

select distinct (soortnaam) from pruts.t2benthos where idparameter is null

update pruts.t1benthos set idparameter = 42550 where soortnaam = 'OPHIUROIDEA'

update pruts.t2benthos p
set idparameter = l.idparameter
from parameter l
where p.soortnaam = l.parameterdescription

update pruts.t2benthos set idparameter = 42555 where soortnaam = 'CIRRATULIDA'

select * from parameter where foreignkey = 105

select * from parameter_worms where aphiaid = 919

delete from parameter where idparameter = 42432

select (idparameter) from parameter where foreignkey = 234850

select * from parameter where parameterdescription = 'bivalvia'

insert into parameter_worms (aphiaid,scientificname,authority,status,aphiaid_accepted,kingdom,phylum,localname) values
	(1267,'Cnidaria','Checked by Taxonomic Editor: included in ERMS 1.1','accepted',1267,'Animalia','Cnidaria','Holtedier')