Changes between Version 14 and Version 15 of Download and load RHT topology

Timestamp:

Oct 21, 2011 10:05:31 AM (14 years ago)

Author:

celine

Comment:

--

Download and load RHT topology

@@ -36 +36 @@
 ALTER TABLE rht.topologie_rht_sept2011 RENAME COLUMN id_drain TO id_draintopo;
 }}}
+
+
+== Integrating "noeuds" ==
+{{{
+--Celine
+d:
+cd D:\CelineJouanin\RHT_Estimkart
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27572 -c -g the_geom -W LATIN1 -I noeud_rhtot_3035.shp rht_noeud > rht_noeud.sql 
+(I can't convert this version into utf8 with notepad)
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f rht_noeud.sql 
+
+alter table rht_noeud set schema rht;
+
+CREATE INDEX indexnoeud
+ON rht.rht_noeud
+USING btree (node_id);
+}}}
+
+Topology de l'amont vers l'aval.
+
+
+
+= Problems =
+ 
+One id_drain without topology : id_drain=30000 [[BR]]
+Some problem with the downstream node see D:\!CelineJouanin\RHT_Estimkart\RHT problems  --> en cours de résolution avec Hervé [[BR]]
+{{{
+d:
+cd D:\CelineJouanin\EDA20RHT
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I noeudmer_polygon.shp noeudmer_polygon > noeudmer_polygon.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f noeudmer_polygon.sql 
+
+alter table rht.noeudmer add column noeudmer boolean;
+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;
+}}}