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


Ignore:
Timestamp:
Oct 5, 2011 11:46:18 AM (14 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Download and load RHT topology

    v10 v11  
    8888C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f noeudmer_polygon.sql  
    8989 
    90 Alter table noeudmer_polygon set schema rht; 
    9190alter table rht.noeudmer add column noeudmer boolean; 
     91update rht.noeudmer SET noeudmer='t' where noeudmer is null 
    9292update 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')); 
    9393}}}