Changes between Version 59 and Version 60 of CookBook join BDMAP_CCM v2

Timestamp:

Nov 10, 2010 9:00:17 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM v2

@@ -248 +248 @@
 {{{
 #!sql
-
-}}}
-
+select b.st_codecsp, 
+b.distance_source as dist_source_bdcar,
+c.distance_source/1000 as dist_source_ccm,
+b.distance_mer as dist_sea_bdcar,
+c.cum_len_sea/1000 as dist_sea_ccm,
+b.strahler as strahler_bdcar,
+c.strahlerccm as strahler_ccm,
+b.distance as distproj_bdcar,
+c.distance as distproj_ccm,
+id_trhyd,
+gid,
+c.the_geom
+from bd_map.bd_map_bd_carthage b join bd_map.bdmap_ccm2 c on b.st_codecsp=c.st_codecsp;
+}}}
+