Changes between Initial Version and Version 1 of Station Hydro

Timestamp:

Mar 5, 2012 1:10:36 PM (13 years ago)

Author:

celine

Comment:

--

Station Hydro

@@ +1 @@
+back to first page[..][[BR]]
+back to ["RHT"], ["RHT PATE"], ["PATE Anguille"][[BR]]
+
+== Station hydrographique Banque HYDRO ==
+{{{
+#!sql
+---Creation du schéma Pate
+create schema pate;
+
+---Création de la table station_hydro pour récupérer ensuite les id_drain correspondants
+drop table if exists pate.station_hydro;
+create table pate.station_hydro (
+ nom character varying(80),
+ X_lambertII numeric,
+ Y_lambertII numeric,
+ code_station character varying(30),
+ nom_station character varying(80)
+);
+set client_encoding to 'latin1';
+copy pate.station_hydro from 'D:/CelineJouanin/PATE/Station_Hydro.csv' with csv header delimiter as ';' NULL AS 'NA';--20 lines
+
+select * from pate.station_hydro;  ---problèmes tous les noms ne sont pas écrits
+
+update pate.station_hydro set code_station='J9300610' where nom_station='Vilaine_(Rieux)';
+
+---Changement de projections
+---Lambert II étendut (srid 27572) --> srid 3035
+SELECT AddGeometryColumn('pate', 'station_hydro','the_geom', 3035,'POINT',2); 
+UPDATE pate.station_hydro SET the_geom=ST_Transform(PointFromText('POINT(' || x_lambertii || ' ' || y_lambertii || ')',27572),3035) ;
+}}}