Changes between Version 14 and Version 15 of europe.wso1

Timestamp:

Oct 3, 2011 11:41:02 AM (14 years ago)

Author:

celine

Comment:

--

europe.wso1

@@ -6 +6 @@
 Pour la France mettre : France (gid=11)+Andorre (gid=2) +Monaco (gid=27) ?[[BR]]
 {{{
+#!sql
 drop table  if exists europe.wso1;
      CREATE TABLE europe.wso1 (
@@ -24 +25 @@
 #TODO A finir la suite...
 {{{
-
+#!sql
 --WRB Western River Basin
     insert into europe.wso(wso_id, wso1_id) 
@@ -67 +68 @@
 
 {{{
+#!sql
 ---- Cas Espagne OK !!! ( avant beaucoup trop de segments retenus dans Spain_Atl --> area/zonegeo="Basque" maintenant)
 ---Basque
@@ -84 +86 @@
 
 {{{
+#!sql
 insert into europe.wso1(wso_id, wso1_id) 
     select distinct on (wso_id, wso1_id)  wso_id, wso1_id from ccm21.riversegments r where wso_id='342310'
@@ -113 +116 @@
 
 {{{
+#!sql
 ---Western
 delete from europe.wso1 where wso_id='84023'  (3wso1_id deleted)
@@ -124 +128 @@
 
 {{{
+#!sql
 ---France
 insert into europe.wso1(wso_id,wso1_id)
@@ -131 +136 @@
 
 {{{
+#!sql
 --- CREATE A VIEW of europe.wso1
 drop view if exists europe.e_wso1;