Changes between Version 6 and Version 7 of PATE France

Timestamp:

Oct 3, 2012 4:51:21 PM (13 years ago)

Author:

celine

Comment:

--

PATE France

@@ -56 +56 @@
 update rht.pate_france set id_drain=sub.id_drain from (
 select rhtvs2_roev3.id_drain, rhtvs2_roev3.id_roe from rht.pate_france join rht.rhtvs2_roev3 on rhtvs2_roev3.id_roe=pate_france.id_roe) sub
-where sub.id_roe=pate_france.id_roe; --3390 lignes
+where sub.id_roe=pate_france.id_roe; --3390 lines
 
 update rht.pate_france set the_geom=NULL;
@@ -112 +112 @@
 update rht.rhtvs2_roev3_nbdams set score=1;
 
-select * from roe_v3.obstacle where idtrcart is null  ---2960 lignes   etanom validé
+select * from roe_v3.obstacle where idtrcart is null  ---2960 lines   etanom validé
 select count(etatnom), etatnom from roe_v3.obstacle group by etatnom   --- 57745 (avant 54057) obstacles marqués comme validé.
 select * from rht.rhtvs2_roev3 where id_roe in (select id_roe from roe_v3.obstacle where idtrcart is null)  --- 1895 (avant 1710) obstacles