Changes between Version 20 and Version 21 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Sep 29, 2011 10:29:54 AM (14 years ago)

Author:

cedric

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -160 +160 @@
 AND nature !='Aqueduc, conduite forcée' and num_superp !=1 order by id_bdcarth;  ---400 lines 359ms
 
+-- essai5
+
+select distinct on (id_bdcarth) id_bdcarth, min(distance) as distance, id_drain from (
+        select id_drain,
+        id_bdcarth,
+        ST_Distance(r.the_geom,bdc.the_geom) as distance
+from rht.rht_bv r, bd_carthage2011.troncon_bv bdc where r.the_geom && bdc.the_geom
+AND nature !='Aqueduc, conduite forcée' and num_superp !=1 ) as toto
+group by id_bdcarth, distance, id_drain
+order by id_bdcarth ;  ---400 lines 
 
 }}}