Changes between Version 40 and Version 41 of Cookbook CCM21_France

Timestamp:

May 25, 2012 1:25:00 PM (13 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_France

@@ -45 +45 @@
 Suppresion des lignes avec wso_id=291495 et 442529
 {{{
+#!sql
 delete from france.wso where wso_id=291495 or wso_id=442529;
 }}}
@@ -74 +75 @@
 
 {{{
+#!sql
 select * from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='Bretagne')--2115 lines
 }}}
@@ -148 +150 @@
 Creating table for each uga
 {{{
+#!sql
 ---Adour
 DROP TABLE IF EXISTS ccm21.riversegments_Adour;   
@@ -301 +304 @@
 Pour rivernodes pour la France
 {{{
+#!sql
 DROP TABLE IF EXISTS ccm21.rivernodes_france;   
 CREATE TABLE  ccm21.rivernodes_france AS
@@ -318 +322 @@
 '''POSE EMU EXTRACTION'''
 {{{
+#!sql
 ---Anglian River basin
 DROP TABLE IF EXISTS ccm21.riversegments_Anglian;