back to first page[..][[BR]]
back to ["CookBook Eda"][[BR]]
back to ["RHT"][[BR]]
see #79 [[BR]]

== Integrating new ROE data 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[[BR]]

{{{
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
}}}

[[Color(,#3849ce,Problème pas les identifiant roe (id_roe) dans la table)]] [[BR]]

A FAIRE ! mais difficile de s'y retrouver [[BR]]
== 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||||