Changes between Version 11 and Version 12 of Download and load RHT topology

Timestamp:

Oct 5, 2011 2:32:46 PM (14 years ago)

Author:

celine

Comment:

--

Download and load RHT topology

@@ -91 +91 @@
 update rht.noeudmer SET noeudmer='t' where noeudmer is null
 update rht.noeudmer SET noeudmer='f' where id_drain in (select id_drain from rht.noeudmer n join rht.noeudmer_polygon p on st_contains(p.the_geom,n.the_geom) OR id_drain in ('215366','215406','215988','226746'));
+
+create table rht.fromnodetonode as (select taval.id_drain as id_drainaval, tamont.id_drain as id_drainamont from rht.rht_topology tamont join rht.rht_topology taval on tamont.tnode=taval.fnode);
+alter table rht.rht_topology add column nextdownid integer;
+update rht.rht_topology SET nextdownid=id_drainaval from rht.fromnodetonode ft where id_drain=ft.id_drainamont;
 }}}