back to first page ..

data in ftp.marine.ie/acms

 --WRB
    insert into europe.wso(wso_id) 
    select distinct on (wso_id)  wso_id from ccm21.riversegments r
    join (SELECT the_geom 
        FROM european_wise2008.rbd_f1v3 As f where gid=39) as sub
    ON ST_Intersects(sub.the_geom,r.the_geom);
    UPDATE europe.wso set area='Western' where area IS NULL;

Calculating CorineLandCover_Ireland
INTEGRATING stations
INTEGRATING operation
INTEGRATING fish
Ireland layers
last change fish & operation
River width Ireland

to see the data

create table ccm21.temp_western as select * from ccm21.riversegments r join ccm21.resultmodel m on r.wso1_id=m.res_wso1_id where res_mod_id=10;
alter table ccm21.temp_western add  CONSTRAINT c_pk_gid_riversegments PRIMARY KEY (gid);
alter table ccm21.temp_western add CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2);
alter table ccm21.temp_western add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
 alter table ccm21.temp_western add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
 INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'ccm21', 'temp_western', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM ccm21.temp_western LIMIT 1;

New work in vilaine