Changes between Version 33 and Version 34 of BDCarthage2011 into eda2.0_RHT

Timestamp:

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

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -212 +212 @@
  USING btree
  (id_drain);
+
+
+/------Requête effectuée avec Cédric le 7/10/2011
+ 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('309179','309116','309047','309048')) 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 ;  ---393393 lines
 }}}