Changes between Version 25 and Version 26 of CookBook join ROE_RHT

Timestamp:

Nov 2, 2011 10:15:13 AM (13 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -132 +132 @@
 select geo.*, bdc.*, roe.the_geom, roe.nom, roe.typecd, roe.typenom, roe.stypecd, roe.stypenom, roe.stanom, roe.etatcd, roe.source from roe_v2.roe_geo_v2 as geo
 join  roe_v2.roe_v2 as roe on roe.id_roe=geo.id_roe
-join rht.rht_bdcarthage2 bdc on bdc.id_bdcarth=cast(geo.idtrcart as integer); ---49399 lines
+join rht.rht_bdcarthage2 bdc on bdc.id_bdcarth=cast(geo.idtrcart as integer); ---49212 lines
 CREATE INDEX indexrhtbdcroe
 ON rht.rht_bdcarthage_roev2
@@ -186 +186 @@
   rht_bdcarthage2.id_bdcarth = cast(roe_geo_v2.idtrcart as bigint) ;  ---49212 lines
 }}}
+
+New version de rht_bdcarthage_roev2 avec données pre_ice_v2
+{{{
+drop table if exists rht.rht_bdcarthage_roev2;
+create table rht.rht_bdcarthage_roev2 as
+select geo.*, bdc.*, roe.the_geom, roe.nom, roe.typecd, roe.typenom, roe.stypecd, roe.stypenom, roe.stanom, roe.etatcd, roe.source,
+ice.etatnom as etatnomice, ice.hauteur_terrain, ice.hauteur_chute, ice.note_fr_anguille from roe_v2.roe_geo_v2 as geo
+join  roe_v2.roe_v2 as roe on roe.id_roe=geo.id_roe
+join rht.rht_bdcarthage2 bdc on bdc.id_bdcarth=cast(geo.idtrcart as integer)
+join roe_v2.pre_ice_v2 as ice on roe.id_roe=ice.id_roe; ---49212 lines
+}}}