Changes between Version 17 and Version 18 of Joining station BDMAP on CCM

Timestamp:

May 25, 2012 1:44:33 PM (13 years ago)

Author:

celine

Comment:

--

Joining station BDMAP on CCM

@@ -8 +8 @@
 
 {{{
+#!sql
 DROP table if exists bd_map.bdmap_ccm_gid;
 CREATE TABLE bd_map.bdmap_ccm_gid as (
@@ -31 +32 @@
 New update
 {{{
+#!sql
 update bd_map.bdmap_ccm_gid SET gid='262623' where st_codecsp='06690101';
 update bd_map.bdmap_ccm_gid SET gid='216980' where st_codecsp='03760112';
@@ -51 +53 @@
 Vérification pour connaître les points de pêches situés dans un cours d'eau artificielle (nature=3)
 {{{
+#!sql
 select * from bd_map.bdmap_ccm_final b inner join bd_map.hylcov_arc as h on h.id_trhyd=b.id_trhyd where nature = '3'  ---115 lines
 select * from bd_map.bdmap_ccm_final b inner join bd_map.hylcov_arc as h on h.id_trhyd=b.id_trhyd where etat = '3' 464 --- lines