Changes between Version 44 and Version 45 of CookBook join BDMAP_CCM v2

Timestamp:

Nov 10, 2010 4:34:27 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM v2

@@ -41 +41 @@
 
 == 2. getting distance sea and distance source for bd_carthage ==
-Les identifiants des noeuds de dataEDAcommun\amorce_mer\bassin final\source\dataEDAcommun\amorce_mer\bassin final\source\troncon_parcouru_source.txt ne correspondent probablement plus aux nouveaux identifiants des noeuds. 
-Je regarde ce qu'avait stocké laurent...
+Below after some search, but we have to trust the last data in the bd_carthage
 {{{
 load(paste(datawd,"/dataEDAcommun/chainage/parcours_source/noeud&troncon_final.RData",sep="")) 
@@ -175 +174 @@
 == 4. include distance source constraint when doing the projection ==
 
-ideally it should be a two step process, first projection to be used ["CookBook join BDMAP_CCM"][[BR]]
-Then within those dams selecting those with conflicting distances...
-
-First an analysis of the distance source from 
-
+Below this table does not only select minimum distance but all ccm segments which are within a 300 m distance from the electrofishing station. [[BR]]
+ 
+{{{
 DROP TABLE IF EXISTS bd_map.bdmap_ccm2;
 CREATE TABLE bd_map.bdmap_ccm2 as (
@@ -190 +187 @@
 );
 alter table bd_map.bdmap_ccm2 add column id serial;
+}}}
 
+The table from the request joining bd_map.bd_map_bd_carthage with the bd_map.bdmap_ccm2 is exported there
 
+We are trying to see if distance_source distance_sea and strahler are consistent between bd_carthage and ccm
+