Changes between Version 58 and Version 59 of Noeud - parcours RHT

Timestamp:

Jan 24, 2012 12:05:52 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -503 +503 @@
 }}}
 
+
+== ERS_FULL ==
+{{{
+#!sql
+DROP TABLE IF EXISTS bdmap2009.ers_full_france;
+CREATE TABLE bdmap2009.ers_full_france
+(
+  id_drain integer,
+  st_id character varying(8),
+  op_cd__moyenprospection integer,
+  ef_fishingmethod integer,
+  ef_nbpas character varying(10),
+  annee numeric
+ );
+copy bdmap2009.ers_full_france from 'D:/CelineJouanin/workspace/EDAData/dataEDArht/ers_full_France.csv' with csv header delimiter as ';'  ---23312 lignes
+
+SELECT AddGeometryColumn ( 'bdmap2009','ers_full_france','the_geom',3035,'POINT',2);
+update bdmap2009.ers_full_france set the_geom=sub.the_geom from (
+select st_codecsp, id_drain, the_geom from bdmap2009.bdmap_rhtvs2 ) as sub
+where sub.id_drain=ers_full_france.id_drain;   ---23312 lignes modifiées
+}}}