back to first page[..][[BR]]

Integrate roe_pate_france.csv (from Virginie 23 mars 2012) into access data and export ODBC link

{{{
#!sql
alter table "PATE_France" rename to pate_france;
alter table pate_france set schema rht;

alter table rht.pate_france rename column "nomCart" to nomCart;
alter table rht.pate_france rename column "nomTopo" to nomTopo;
alter table rht.pate_france rename column "commNom" to commNom;
alter table rht.pate_france rename column "Id_ROE" to Id_ROE;
alter table rht.pate_france rename column "Nom" to Nom;
alter table rht.pate_france rename column "XL93" to XL93;
alter table rht.pate_france rename column "YL93" to YL93;
alter table rht.pate_france rename column "typeNom" to typeNom;
alter table rht.pate_france rename column "stypeNom" to stypeNom;
alter table rht.pate_france rename column "staNom" to staNom;
alter table rht.pate_france rename column  "deptNom" to deptNom;
alter table rht.pate_france rename column "note_fr_Anguille" to note_fr_Anguille;

alter table rht.pate_france add column a_conserver boolean default TRUE;


SELECT AddGeometryColumn ( 'rht','pate_france','the_geom',3035,'POINT',2);
update rht.pate_france set the_geom=obstacle.the_geom from roe_v3.obstacle
 where obstacle.id_roe=pate_france.id_roe; 

select count(*) from rht.pate_france where the_geom is null;  ---0
}}}

{{{
#!sql
update rht.pate_france set a_conserver=FALSE where stanom like '%Obso%'--61
}}}