Changes between Version 4 and Version 5 of Noeud - parcours RHT

Timestamp:

Jan 4, 2012 3:52:12 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -14 +14 @@
 ALTER TABLE rhtvs2 SET SCHEMA rht;
 
+-- Rename column
 ALTER TABLE rht.rhtvs2 RENAME COLUMN fnode_ TO fnode;
 ALTER TABLE rht.rhtvs2 RENAME COLUMN tnode_ TO tnode;
+
+-- Change type
+alter table rht.rhtvs2 alter column id_drain type integer;
+alter table rht.rhtvs2 alter column fnode type integer;
+alter table rht.rhtvs2 alter column tnode type integer;
 
 -- Constraints
@@ -38 +44 @@
 CREATE INDEX indexmer ON rht.noeudmervs2 USING btree (id_drain);
 CREATE INDEX indexmergeom ON rht.noeudmervs2 USING GIST ( the_geom GIST_GEOMETRY_OPS );
-COMMENT ON table rht.noeudmervs2 IS 'Table test to know the downstream node from the sea';
+COMMENT ON table rht.noeudmervs2 IS 'Table noeudmervs2 to know the downstream node from the sea';
 
-select count(*) from rht.noeudmervs2; --- 1114 lines
+select count(*) from rht.noeudmervs2; ---1082 noeudmer  (version 1: 1114)
 
 Intégration des noeuds mer dans la table rhtvs2.
 
 alter table rht.rhtvs2 add column noeudmer boolean default FALSE;
-update rht.rhtvs2 set noeudmer=TRUE
-where id_drain in (select id_drain from rht.noeudmervs2 where noeudmer); --1083
+update rht.rhtvs2 set noeudmer=TRUE where id_drain in (select id_drain from rht.noeudmervs2); --1082 noeudmer
+}}}
 
 Identification des différentes zones, manche, Bretagne, Méditerranée, Golfe de Gascogne, Est France, Pyrénnées, pb topologie centre France.