Changes between Version 3 and Version 4 of River width Ireland

Timestamp:

Jul 14, 2011 10:21:41 PM (14 years ago)

Author:

cedric

Comment:

--

River width Ireland

@@ -13 +13 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\psql  -U postgres --dbname "eda2.0" -f "width_irl.sql"
 }}}
+-- détail adapté par Cédric
+{{{
+#!sql
+-- script adapaté du script de laurent
+CREATE TABLE wrbd.western_wso1
+(
+  id serial NOT NULL,
+  wso_id integer,
+  wso1_id integer,
+  area character varying(25),
+  CONSTRAINT wso1_pkey PRIMARY KEY (id)
+);
+--select distinct on (area) area from europe.wso1;
+insert into wrbd.western_wso1 select * from europe.wso1 where area='Western'; --915
+
+CREATE TABLE wrbd.ccm_river_segment_wrbb AS SELECT r.* FROM wrbd.western_wso1 w, ccm21.riversegments r WHERE r.wso1_id=w.wso1_id;
+}}}