Changes between Version 42 and Version 43 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Oct 25, 2011 4:23:04 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -170 +170 @@
         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
+        order by id_bdcarth ;  ---393737 lines
 CREATE INDEX indexrhtbdc
 ON rht.rht_bdcarthage
@@ -181 +181 @@
 select count(*) from bd_carthage2011.troncon_hydrographique  ---528422 lines
 select count(*) from rht.rht  ---114601 lines
-select count(*) from rht.rht_bdcarthage --- 393393 lines
+select count(*) from rht.rht_bdcarthage --- 393737 lines
 
 select id_drain from rht.rht_bdcarthage where id_drain not in select id_drain from rht.rht_bdcarthage;  ---
@@ -205 +205 @@
         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
-CREATE INDEX indexrhtbdc2
+        order by id_bdcarth ;  ---386254 lines
+CREATE INDEX indexrhtbdcb
 ON rht.rht_bdcarthage2
 USING btree (id_bdcarth);