Changes between Version 50 and Version 51 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Feb 28, 2012 5:55:35 PM (13 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -279 +279 @@
 create table rht.proj3 as (
 select r.id_drain, id_bdcarth, id_bdcarth as idbdc, bdc.the_geom from rht.rhtvs2 r inner join rht.proj1 p on r.id_drain=p.id_drain join bd_carthage2011.troncon_hydrographique bdc 
-on st_intersects(bdc.the_geom,p.the_geom)); ----176730 ms
+on st_intersects(bdc.the_geom,p.the_geom) where nature !='Aqueduc, conduite forcée' and num_superp !=1); ----176730 ms
 comment on table rht.proj3 is 'Selection des id_bdcarthage à l''intérieur du buffer de 150m (proj1)';
 
@@ -286 +286 @@
 create table rht.proj4 as (
 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));
+on st_intersects(bdc.the_geom,p.the_geom) where nature !='Aqueduc, conduite forcée' and num_superp !=1);
 comment on table rht.proj4 is 'Selection des id_bdcarthage à l''extérieur du buffer de 150m (proj2) qui intersect avec st_exteriorring';