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

== 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[[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||||