Changes between Version 3 and Version 4 of Noeuds mer RHT

Timestamp:

Oct 19, 2011 6:15:35 PM (14 years ago)

Author:

cedric

Comment:

--

Noeuds mer RHT

@@ -9 +9 @@
 where id_drain in (select id_drain from rht.noeudmer where noeudmer); --1083
 }}}
+Identification des différentes zones, manche, Bretagne, Méditerranée, Golfe de Gascogne, Est France, Pyrénnées, pb topologie centre France.
+{{{
+alter table rht.noeudmer add column zonegeo character varying(30);
+update rht.noeudmer_polygon set location='pb topologie centre france' where location is null;
+update rht.noeudmer n set zonegeo=location from(
+Select location,id_drain from rht.noeudmer_polygon p
+join  rht.noeudmer n on st_intersects(p.the_geom,n.the_geom)) s
+where s.id_drain=n.id_drain; -- 1114
+update rht.noeudmer set zonegeo='Golfe de Gascogne' where zonegeo='Biscaye';
+select * from rht.noeudmer where zonegeo is null; -- zero lignes
+}}}