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

= 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 Attributs_RHT_fev_2011.txt) ==
["Download and load RHT"] [[BR]]
{{{
select count(*) from rht.rht ---114601 lignes
select count(*) from rht.attributs_rht_fev_2011 ---114600 lignes  --nb de lignes différent !! A voir
}}}

== Create a view ==
{{{
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"]

== Joining RHT_ROE ==
["CookBook join ROE_RHT"]