Changes between Initial Version and Version 1 of PATE France

Timestamp:

Mar 30, 2012 5:29:21 PM (13 years ago)

Author:

celine

Comment:

--

PATE France

@@ +1 @@
+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
+}}}