back to first page [..][[BR]]

data in  ftp.marine.ie/acms[[BR]]

{{{
#!sql
 --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"] [[BR]]
["INTEGRATING stations"] [[BR]]
["INTEGRATING operation"] [[BR]]
["INTEGRATING fish"] [[BR]]
["Ireland layers"][[BR]]
["last change fish & operation"] [[BR]]
["River width Ireland"][[BR]]

to see the data [[BR]]
{{{

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 ==