Changes between Version 3 and Version 4 of PATE France

Timestamp:

Apr 2, 2012 10:30:22 AM (13 years ago)

Author:

cedric

Comment:

--

PATE France

@@ -33 +33 @@
 {{{
 #!sql
+--correction de la requete précédente pour utiliser la version roev2 en attendant la version v3 projettée
 update rht.pate_france set a_conserver=FALSE where stanom like '%Obso%'--61
+update rht.pate_france set the_geom=NULL;
+update rht.pate_france set the_geom=rhtvs2_roev2.the_geom from rht.rhtvs2_roev2 where rhtvs2_roev2.id_roe=pate_france.id_roe; --3310
+select * from rht.pate_france where the_geom is null; --198
+
+
+select count(*) from rht.pate_france; --3508
+-- je rajoute l'id_drain dans la table rht.pate_france
+alter table rht.pate_france add column id_drain integer;
+update rht.pate_france set id_drain=sub.id_drain from (
+select rhtvs2_roev2.id_drain, rhtvs2_roev2.id_roe from rht.pate_france join rht.rhtvs2_roev2 on rhtvs2_roev2.id_roe=pate_france.id_roe) sub
+where sub.id_roe=pate_france.id_roe; --3310
 }}}