Changes between Version 38 and Version 39 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Oct 7, 2011 5:25:04 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -236 +236 @@
         group by id_bdcarth, distance, id_drain
         order by id_bdcarth ;
+
+
+--- Comparaison des longeurs des segements
+select length(r.the_geom)-length(bd.the_geom)as diff, length(r.the_geom), length(bd.the_geom), rbd.id_drain, rbd.id_bdcarth from rht.rht_bdcarthage rbd join rht.rht r on rbd.id_drain=r.id_drain
+ join bd_carthage2011.troncon_hydrographique bd on bd.id_bdcarth=rbd.id_bdcarth order by diff;
+---Comparaison des longueurs id_drain et de la somme des longeurs des id_bdcarth associés
+
 }}}