Changes between Version 103 and Version 104 of CookBook join BDMAP_CCM v2

Timestamp:

Nov 12, 2010 5:19:30 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM v2

@@ -143 +143 @@
 -- On est obligé de faire la jointure avec le troncon amont autrement les troncons partant du cours principal se voient attribués
 -- des distances source qui sont celles de l'axe. Par contre il faut rajouter à tous les tronçons la longueur du tronçon.
+update hylcov_arc_dist2 set dist_source_max= 0 where dist_source_max=-1;
 update hylcov_arc_dist2 set dist_source_max= dist_source_max+length/1000;
 }}}
@@ -192 +193 @@
 {{{
 #!sql
-
-
-
-
 CREATE INDEX indexhylcov_arc_dist2 ON hylcov_arc_dist2
   USING GIST ( the_geom GIST_GEOMETRY_OPS );
@@ -313 +310 @@
 [[Image(source:data/Docs/trac/BDMAP/comp_dist_mer.jpeg,300px)]] 
 [[Image(source:data/Docs/trac/BDMAP/com_strahler.jpeg,300px)]] 
-{{{
+
 VERSION 3.0 
 {{{
@@ -368 +365 @@
 g+geom_point(aes(dist_sea,dist_sea_ccm,colour=pb_ratio_dist_sea))+geom_abline(slope=1,colour="red") +geom_abline(slope=1,intercept=1,colour="green") 
 #g+geom_point(aes(dist_sea,dist_sea_ccm,colour=pbratiosource))+geom_abline(slope=1,colour="red") +geom_abline(slope=1,intercept=1,colour="green") 
-
 g+geom_jitter(aes(x=strahler,y=strahler_ccm,colour=pbstrahler),alpha=0.3)
 g1<-
@@ -374 +370 @@
 g1+geom_point(aes(x=dist_source,y=dist_source_ccm),size=2,data=ccm_bd1,pch=1)
 }}}
+
 __Criteria have been used to select stations (v3)__ [[BR]]
 dist sea and strahler unchanged
 ccm_bd$pbratiosource<-(ratio_sources>1.3|ratio_sources<0.7) & !(ccm_bd$dist_source_ccm<20 & ccm_bd$dist_source<20) [[BR]]
+
+[[Image(source:data/Docs/trac/BDMAP/comp_dist_source_1.jpeg,300px)]] 
+[[Image(source:data/Docs/trac/BDMAP/comp_dist_source_2.jpeg,300px)]] 
 
 == 5. query to select the final data from  bd_map.bdmap_ccm2 ==