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

Create schema rhe;
Alter table rhe set schema rhe;
ALTER TABLE rhe.rhe DROP CONSTRAINT enforce_srid_the_geom;
UPDATE rhe.rhe SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE rhe.rhe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);

DROP INDEX IF EXISTS rhe.indexrhe;
CREATE INDEX indexrhe
ON rhe.rhe
USING btree (id_drainv2);

select count(*) from rhe.rhe ---65740 lines