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


Ignore:
Timestamp:
Oct 21, 2011 10:02:26 AM (14 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Download and load RHT topology

    v13 v14  
    3636ALTER TABLE rht.topologie_rht_sept2011 RENAME COLUMN id_drain TO id_draintopo; 
    3737}}} 
    38  
    39  
    40 == Integrating "noeuds" == 
    41 {{{ 
    42 --Celine 
    43 d: 
    44 cd D:\CelineJouanin\RHT_Estimkart 
    45 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  
    46 (I can't convert this version into utf8 with notepad) 
    47 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f rht_noeud.sql  
    48  
    49 alter table rht_noeud set schema rht; 
    50  
    51 CREATE INDEX indexnoeud 
    52 ON rht.rht_noeud 
    53 USING btree (node_id); 
    54 }}} 
    55  
    56 Topology de l'amont vers l'aval. 
    57  
    58  
    59  
    60 = Problems = 
    61   
    62 One id_drain without topology : id_drain=30000 [[BR]] 
    63 Some problem with the downstream node see D:\!CelineJouanin\RHT_Estimkart\RHT problems  --> en cours de résolution avec Hervé [[BR]] 
    64 {{{ 
    65 d: 
    66 cd D:\CelineJouanin\EDA20RHT 
    67 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  
    68 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f noeudmer_polygon.sql  
    69  
    70 alter table rht.noeudmer add column noeudmer boolean; 
    71 update rht.noeudmer SET noeudmer='t' where noeudmer is null 
    72 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')); 
    73  
    74 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); 
    75 alter table rht.rht_topology add column nextdownid integer; 
    76 update rht.rht_topology SET nextdownid=id_drainaval from rht.fromnodetonode ft where id_drain=ft.id_drainamont; 
    77 }}}