Changes between Version 11 and Version 12 of Meuse dbeel

Timestamp:

Jun 5, 2014 3:15:40 PM (11 years ago)

Author:

cedric

Comment:

--

Meuse dbeel

@@ -530 +530 @@
 DROP TABLE IF EXISTS belge.observation_places;
 create table belge.observation_places as(
-select *  from dbeel.observation_places where op_gis_systemname='SPW' or op_gis_layername='OBSTACLES'); -- 8751 lignes (563 pour stations et 8188 obstacles)
+select *  from dbeel.observation_places where op_gis_systemname='SPW' or op_gis_layername='OBSTACLES'); 
 
 DROP TABLE IF EXISTS belge.meuse_operations_ccm_500;
@@ -537 +537 @@
                SELECT op_id, gid , wso1_id, CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1)) as distance,s.the_geom 
                FROM belge.observation_places As s
-               INNER JOIN  ccm21.riversegments r ON ST_DWithin(r.the_geom, s.the_geom,500) --6443 lignes (beaucoup d'exclus sont des obstacles en dehors du CCM)
+               INNER JOIN  ccm21.riversegments r ON ST_DWithin(r.the_geom, s.the_geom,500) (beaucoup d'exclus sont des obstacles en dehors du CCM)
                WHERE s.the_geom IS NOT NULL
                ) AS sub 
@@ -566 +566 @@
                SELECT op_id, gid , wso1_id,op_gis_layername, CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1)) as distance,s.the_geom 
                FROM dbeel.observation_places As s
-               INNER JOIN  ccm21.riversegments r ON ST_DWithin(r.the_geom, s.the_geom,500)  --76406 observations sur 92286
+               INNER JOIN  ccm21.riversegments r ON ST_DWithin(r.the_geom, s.the_geom,500)  --69931 observations sur 87204 lignes
                WHERE s.the_geom IS NOT NULL
                ) AS sub