back to first page..
back to Gis Structures

RHT Réseau Hydrographique Théorique

​http://www.cemagref.fr/le-cemagref/lorganisation/les-centres/lyon/ur-maly/laboratoire-dynamiques-indicateurs-et-modeles-en-ecohydrologie/logiciels/RHT

Integrating data into postgre (rht.shp and

--Celine
d:
cd D:\CelineJouanin\RHT_Estimkart
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27582 -c -g the_geom -W LATIN1 -I rht.shp rht > rht.sql 
We have to convert it into utf8 (as the database is posgis), in notepad, open the uga.sql file and convert it to utf8
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f rhtutf8.sql 

--Creation du schema rht
CREATE SCHEMA rht;
ALTER TABLE rht SET SCHEMA rht;

--Changement du type de projection :  (NTF_France_II_degrees  srid 27582) --> ETRS1989-LAEA (srid 3035)
ALTER TABLE rht.rht DROP CONSTRAINT enforce_srid_the_geom;
UPDATE rht.rht SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE rht.rht ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);

--Attribut Integrating (Attributs_RHT_fev_2011.csv)
copy rht.rht_attribut  from 'D:/CelineJouanin/RHT_Estimkart/Attributs_RHT_fev_2011.csv' with csv delimiter as ';' header;