Changes between Version 22 and Version 23 of Cookbook CCM21_France

Timestamp:

Jul 27, 2010 2:40:44 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -95 +95 @@
 FROM ccm21.catchments_Bretagne LIMIT 1;
 }}}
+A view of france riversegments ?
+-- View: ccm21.riversegmentsfrance
+
+-- DROP VIEW ccm21.riversegmentsfrance;
+{{{
+CREATE OR REPLACE VIEW ccm21.riversegmentsfrance AS 
+ SELECT rs.gid, rs.wso1_id, rs.wso_id, rs.rvr_id, rs.fromnode, rs.tonode, rs.strahler, rs.pfafstette, rs.nextdownid, rs.longpath, rs.maindrain_, rs.maindrain1, rs.length, rs.cum_len, rs.pixels_100, rs.catchment_, rs.cont_pixel, rs.drain_km2, rs.alt_gradie, rs.burned, rs.confidence, rs."window", rs.shape_leng, rs.the_geom, rs.cum_len_sea
+   FROM ccm21.riversegments rs
+  WHERE (rs.wso_id IN ( SELECT wso.wso_id
+           FROM france.wso
+          WHERE wso.area::text = 'France'::text))
+  ORDER BY rs.gid;
+
+ALTER TABLE ccm21.riversegmentsfrance OWNER TO postgres;
+}}}