back to first page..
back to CookBook Eda
back to RHT
see #79

Integrating new ROE_v2 data into RHT

Lambert_Conformal_Conic --> ETRS LAEA srid 3035 with ArcGis

d:
cd D:\CelineJouanin\ROE2011
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I ROE_v2_Project.shp roe_v2 > roe_v2.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f roe_v2.sql

create schema roe_v2;
alter table roe_v2 set schema roe_v2;

---Integrating pre_ice_v2.csv
See in ["CookBook export access"] to integrate the database into postgre from ACCESS (it's usefull when you got lots of variables in the table) This allows us to create the table quickly. 
alter table roe_geo_v2 set schema roe_v2;

---Integrating roe_geo_v2.csv
See ["CookBook export access"]
alter table pre_ice_v2 set schema roe_v2;

Integrating ROE data from Hervé into RHT

Changement du système de projection via ArcGis roe_snap50m_rht.shp from Hervé (Lambert II étendu) --> srid 3035 with roe_snap50m_rht_Project.shp

d:
cd D:\CelineJouanin\RHT_Estimkart
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I roe_snap50m_rht_Project.shp rht_roe > rht_roe.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f rht_roe.sql

alter table rht_roe set schema rht

Problème pas les identifiant roe (id_roe) dans la table

A FAIRE ! mais difficile de s'y retrouver

Transborder dams

FID	Shape *	id_trhyd	NATURE	TOPONYME	CANDIDAT	COTE	SITUATION	MER	barrage	Nom	wso_id correspondant	UGA	id_drain RHT
6297	Point	100007688	Source simple	9999			frontiere	358	23	Meuse	291130	MEUSE
493235	Point	150001278	Source simple	9999			frontiere	149	23	Meuse	/	MEUSE
494054	Point	250002088	Source simple	9999			frontiere	331	23	Meuse	291130	MEUSE
495249	Point	250003393	Source simple	9999			frontiere	593	12	Moselle	291110	RHIN
495588	Point	250003736	Source simple	9999			frontiere	586	17	Sarre	291110	RHIN
496464	Point	250004650	Embouchure	9999			frontiere	575	17	Sarre	291110	RHIN