back to first page[..][[BR]]
back to ["Gis Structures"][[BR]]
Go to ["Estimkart"] [[BR]]

= RHT Réseau Hydrographique Théorique =

http://www.irstea.fr/rht [[BR]]
Archive à décompresser avec Powerarchiver : http://www.powerarchiver.com/fr

["Description RHT"][[BR]]

== Integrating data into postgre (rht.shp and Attributs_RHT_fev_2011.txt) ==
["Download and load RHT"] [[BR]]
{{{
#!sql
select count(*) from rht.rht ---114601 lines
select count(*) from rht.attributs_rht_fev_2011 ---114600 lines  --nb de lignes différent !! A voir
}}}

== Integrating the topology into Postgre ==
["Download and load RHT topology"][[BR]]

== Create a view ==
{{{
#!sql
ALTER TABLE rht.attributs_rht_fev_2011 RENAME COLUMN id_drain TO id_drainattr;
CREATE VIEW rht.rht_attribut AS SELECT * from rht.rht r left join rht.attributs_rht_fev_2011 a on r.id_drain=a.id_drainattr

select * from rht.rht_attribut where id_drainattr is null  --un id_drain sans attribut (correspond au lac léman)
}}}

== Joining RHT-BDMAP ==
["CookBook join RHT-BDMAP"]

== Joining RHT-UGA ==
["CookBook RHT_UGA"][[BR]]
["CookBook BDCarthage_UGA"]

== Joining RHT-ROE ==
["CookBook join ROE_RHT"]

== Joining RHT-Corine Land Cover ==
["CookBook join Corine Land Cover-RHT"]

== Verification with BDCarthage and RHT ==
To verify roe projection on rht [[BR]]
["BDCarthage2011 into eda2.0_RHT"][[BR]]
["Verification BDCarthage-ROE"]




== Noeuds mer ==
["Noeuds mer RHT"] [[BR]]
["parcours RHT"] [[BR]]

["Noeud - parcours RHT"] Integration d'une nouvelle topologie et calcul des parcours, distance mer
[[BR]]

== Surface en eau ==
["Surface en eau"][[BR]]

== Parcours source ==
["Parcours source RHT"] [[BR]]
== Largeur ==
["River width RHT"][[BR]]

== Module by month ==
["Module RHT"][[BR]]

== RHE ==
["RHE"]

== ["Comment on table-RHT database"] ==
== Export shape - Backup schema ==
["Export shape RHT"][[BR]]
["Backup schema RHT"][[BR]]
["Export table RHT"][[BR]]


== Model Results ==
["Model Results"]