Changes between Version 70 and Version 71 of CookBook join BDMAP_CCM v2

Timestamp:

Nov 11, 2010 8:32:05 AM (14 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM v2

@@ -257 +257 @@
 REQUEST WITH SELECTION OF CORRECT CRITERIA FOR DISTANCE SEA, DISTANCE SOURCE, STRAHLER RANK
 */
+drop table if exists bd_map.bdmap_ccm_full;
+create table bd_map.bdmap_ccm_full as ( 
 select * from (
         select b.st_codecsp, 
@@ -278 +280 @@
 WHERE dist_source_ratio is TRUE
 AND dist_sea_ratio is TRUE
-AND strahler_diff is TRUE --10783 lines this is with repeated stations but selection has removed ~ 3000 lines
+AND strahler_diff is TRUE); --10783 lines this is with repeated stations but selection has removed ~ 3000 lines
 /*
 FINAL REQUEST