Changes between Version 11 and Version 12 of WRBD

Timestamp:

Dec 1, 2010 3:59:35 PM (14 years ago)

Author:

celine

Comment:

--

WRBD

@@ -212 +212 @@
 }}}
 
+Station WRBD (Western River Basin District)
+{{{
+CREATE SCHEMA wrbd;
+
+drop table if exists wrbd.station_st;
+create table wrbd.station_st ( 
+        st_foliono character varying(50),
+        st_id character varying(10),
+        st_district character varying(30),
+        st_catchment character varying(15),
+        st_river character varying(40),
+        st_sitetributary character(5),
+        st_eastings numeric,
+        st_northing numeric,
+        st_location text,
+        st_x numeric,
+        st_y numeric
+        );
+alter table wrbd.station_st add constraint  pk_st_id primary key (st_id);
+set client_encoding to 'latin1';
+copy wrbd.station_st  from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Station_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';' header; 
+-- projection sur le SRID 3035
+SELECT AddGeometryColumn('wrbd', 'station_st','the_geom', 3035,'POINT',2); 
+UPDATE wrbd.station_st   SET the_geom=ST_Transform(PointFromText('POINT(' || st_x || ' ' || st_y || ')',29901),3035);
+ALTER TABLE wrbd.station_st SET WITH OIDS;
+
+--srid =29903 or srid=29901
+
+CREATE INDEX indexstation_st ON wrbd.station_st
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+}}}
+
 {{{
 d: