Version 13 (modified by celine, 14 years ago) (diff) |
---|
back to first page..
back to Gis Structures
RHT Réseau Hydrographique Théorique
Integrating data into postgre (rht.shp and Attributs_RHT_fev_2011.txt)
select count(*) from rht.attributs_rht_fev_2011 ---114602 select count(*) from rht.rht ---114602
Create a view
ALTER TABLE rht.attributs_rht_fev_2011 RENAME COLUMN id_drain TO id_drainattr; CREATE VIEW rht_attribut AS SELECT * from rht.rht r left join rht.attributs_rht_fev_2011 a on r.id_drain=a.id_drainattr
I'll receive the new version rth version2 in few days.