Changes between Initial Version and Version 1 of RHE

Timestamp:

Sep 23, 2011 5:44:34 PM (14 years ago)

Author:

celine

Comment:

--

RHE

@@ +1 @@
+back to first page[..][[BR]]
+back to ["RHT"][[BR]]
+
+= RHE Réseau Hydrographique Etendu =
+Lambert II
+{{{
+d:
+cd D:\CelineJouanin\RHT_Estimkart\rhe
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27582 -c -g the_geom -W LATIN1 -I Rhe.shp RHE > RHE.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f RHE.sql
+}}}
+
+{{{
+Alter table rhe set schema rht;
+ALTER TABLE rht.rhe DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE rht.rhe SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE rht.rhe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+}}}