back to first page..
back to RHT

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);