Water obstructions for Ireland

back to saving and loading the database with elvira?
back to top ..

create schema ireland;
comment on schema ireland is '2012 data from IFI and MI of yellow eel survey';

to change the projection system from irish national grid (29903) to ccm (3035)

#!sql

ALTER TABLE "Ireland".salmon_barriers DROP CONSTRAINT enforce_srid_the_geom;
UPDATE "Ireland".salmon_barriers SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE "Ireland".salmon_barriers ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);