Changes between Version 48 and Version 49 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Feb 28, 2012 5:40:58 PM (13 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -287 +287 @@
 select r.id_drain, id_bdcarth, id_bdcarth as idbdc, bdc.the_geom from rht.rhtvs2 r inner join rht.proj2 p on r.id_drain=p.id_drain join bd_carthage2011.troncon_hydrographique bdc 
 on st_intersects(bdc.the_geom,p.the_geom));
-}}}
+
+create table rht.proj5 as (
+select t1.id_drain, t1.id_bdcarth, t1.the_geom from rht.proj3 t1 join rht.proj4 t2 on t1.id_bdcarth=t2.id_bdcarth and t1.id_drain=t2.id_drain);
+}}}