Changes between Version 9 and Version 10 of Noeuds mer RHT

Timestamp:

Oct 20, 2011 8:45:10 PM (14 years ago)

Author:

cedric

Comment:

--

Noeuds mer RHT

@@ -1 +1 @@
 == Noeuds mer RHT ==
+=== Noeuds mer ===
+{{{
+#!sql
+select * from rht.rht r left join rht.topologie_rht_sept2011 t on r.id_drain=t.id_draintopo where id_draintopo is null;    --- 1 lines
 
-Céline je ne retrouve pas tes scripts pour les noeuds mer... Ce serait bien de les coller ici.
+drop table if exists rht.rht_topology;
+CREATE table rht.rht_topology AS select * from rht.rht r inner join rht.topologie_rht_sept2011 t on t.id_draintopo=r.id_drain;
+CREATE INDEX indextopo ON rht.rht_topology USING btree (id_draintopo);
+CREATE INDEX indextopogeom ON rht.rht_topology
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+
+COMMENT ON table rht.rht_topology IS 'Joining between rht and topologie_rht_sept2011 to see it on Qgis';
+
+drop table if exists rht.noeudmer;
+create table rht.noeudmer as select * from rht.rht_topology where tnode not in (select fnode from rht.topologie_rht_sept2011);
+CREATE INDEX indexmer ON rht.noeudmer USING btree (id_drain);
+CREATE INDEX indexmergeom ON rht.noeudmer USING GIST ( the_geom GIST_GEOMETRY_OPS );
+COMMENT ON table rht.noeudmer IS 'Table test to know the downstream node from the sea';
+
+select count(*) from rht.noeudmer; --- 1114 lines
+}}}
 
 Intégration des noeuds mer dans la table rht_topology.