Changes between Version 24 and Version 25 of CookBook join ROE_RHT

Timestamp:

Oct 27, 2011 5:21:16 PM (14 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -153 +153 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t rht.rht_bdcarthage_roev2 eda2.0_RHT> rht_bdcarthage_roev2.sql
 }}}
+
+
+A FINIR
+{{{
+select count(*) from roe_v2.pre_ice_v2 where hauteur_chute='-999'   ---31611 lines
+
+Ci-dessous la requête pour la jointure entre les différentes tables :
+SELECT 
+  rht_topology.id_drain, 
+  roe_geo_v2.idtrcart, 
+  roe_geo_v2.id_roe, 
+  pre_ice_v2.hauteur_chute, 
+  rht_topology.the_geom, 
+  rht_topology.fnode, 
+  rht_topology.tnode, 
+  rht_topology.length, 
+  rht_topology.nextdownid, 
+  rht_topology.noeudmer, 
+  rht_topology.cumnbbar, 
+  rht_topology.dmer, 
+  rht_topology.id_draintopo, 
+  pre_ice_v2.hauteur_terrain, 
+  pre_ice_v2.note_fr_anguille
+FROM 
+  rht.rht_topology, 
+  roe_v2.roe_geo_v2, 
+  roe_v2.pre_ice_v2, 
+  rht.rht_bdcarthage2
+WHERE 
+  roe_geo_v2.id_roe = pre_ice_v2.id_roe AND
+  rht_bdcarthage2.id_drain = rht_topology.id_drain AND
+  rht_bdcarthage2.id_bdcarth = cast(roe_geo_v2.idtrcart as bigint) ;  ---49212 lines
+}}}