Changes between Version 32 and Version 33 of WRBD

Timestamp:

Dec 3, 2010 10:36:33 AM (14 years ago)

Author:

celine

Comment:

--

WRBD

@@ -248 +248 @@
 }}}
 
+{{{
+DROP TABLE IF EXISTS wrbd.station_ccm_500;
+CREATE TABLE wrbd.station_ccm_500 as (
+        SELECT distinct on (st_id ) st_id , gid, wso1_id, min(distance) as distance, the_geom FROM (
+               SELECT st_id, gid , wso1_id, CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1)) as distance,s.the_geom 
+               FROM wrbd.station_st As s
+               INNER JOIN  ccm21.riversegments r ON ST_DWithin(r.the_geom, s.the_geom,500)
+               WHERE s.the_geom IS NOT NULL
+               ORDER BY st_id) AS sub 
+        GROUP BY st_id, gid, wso1_id,  distance,the_geom
+);
+alter table wrbd.station_ccm_500 add column id serial;
+-- mise à jour de la table geometry_columns
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'wrbd', 'station_ccm_500', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM wrbd.station_ccm_500 LIMIT 1;
+}}}
 
 {{{