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

Timestamp:

Feb 28, 2012 4:56:16 PM (13 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -266 +266 @@
 create table rht.rhtvs2_bdcarth as (
 select id_drain, id_bdcarth from rht.table1 t1 join rht.table2 t2 on t1.id_bdcarth=t2.id_bdcarth and t1.id_drain=t2.id_drain);
-}}}
+
+---------------------------------------
+create table rht.proj1 as (
+select id_drain, st_buffer(the_geom,150) as the_geom from rht.rhtvs2);
+
+create table rht.proj2 as (
+select id_drain, st_exteriorring(st_buffer(the_geom,150)) as the_geom from rht.rhtvs2);  ---105044 ms
+
+select * from bd_carthage2011.troncon_hydrographique limit 2
+
+drop table if exists rht.proj3;
+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
+
+comment on table rht.proj4 is 'Selection des id_bdcarthage à l''extérieur du buffer de 150m (proj1) qui intersect avec st_exteriorint'
+
+drop table if exists rht.proj4;
+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));
+}}}