back to first page[..][[BR]] {{{ #!sql --Anglian 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=200) as sub ON ST_Intersects(sub.the_geom,r.the_geom); UPDATE europe.wso set area='Anglian' where area IS NULL; --69 lines }}} ["Calculating CorineLandCover_Anglian"] [[BR]] = Projection = British national grid reference srid=27700 = Obstacle = In stourBarrierpriority.xls = River Width = see Laurent ["River width Anglian"] [[BR]]