Changes between Version 36 and Version 37 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Oct 7, 2011 5:07:46 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -225 +225 @@
         group by id_bdcarth, distance, id_drain
         order by id_bdcarth ;  ---393393 lines
+
+--- Même requête mais en ne conservant que les id_drain qui n'ont pas id_bdcarth associé dans rht.rht_bdcarthage
+ select distinct on (id_bdcarth,id_drain) id_bdcarth, min(distance) as distance, id_drain from (
+                select r.id_drain,
+                id_bdcarth,
+                ST_Distance(r.the_geom,bdc.the_geom) as distance
+        from (select * from rht.rht where id_drain in(select id_drain from rht.rht except (select id_drain from rht.rht_bdcarthage))) as r join rht.rht_150 rht150 on r.id_drain=rht150.id_drain
+                        join    bd_carthage2011.troncon_hydrographique bdc on st_intersects(bdc.the_geom,rht150.the_geom)
+        where nature !='Aqueduc, conduite forcée' and num_superp !=1 ) as toto
+        group by id_bdcarth, distance, id_drain
+        order by id_bdcarth ;
 }}}