Context Navigation

back to first page..
back to Gis Structures
Go to Estimkart?

RHT Réseau Hydrographique Théorique

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

Integrating data into postgre (rht.shp and Attributs_RHT_fev_2011.txt)

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

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)