Changes between Version 41 and Version 42 of CookBook join RHT-BDMAP

Timestamp:

May 25, 2012 1:41:17 PM (13 years ago)

Author:

celine

Comment:

--

CookBook join RHT-BDMAP

@@ -10 +10 @@
 
 {{{
+#!sql
 -- creation de la table bdmap_rht, je rajoute un the_geom a la requete pour pouvoir voir la table dans Qgis  
 DROP TABLE IF EXISTS rht.bdmap_rht;
@@ -37 +38 @@
 
 {{{
+#!sql
 select count(*) from bd_map.stationsp2  --10193 lignes
 select count(*) from rht.rht  --114601 lignes
@@ -45 +47 @@
 
 {{{
+#!sql
 select count(*) from bd_map.bdmap_ccm_gid  --8188 lignes
 }}}
@@ -52 +55 @@
 
 {{{
-
+#!sql
 DROP table if exists rht.bdmap_rht_id;
 CREATE TABLE rht.bdmap_rht_id as (
@@ -97 +100 @@
 
 {{{
+#!sql
 select * from bdmap2009.station_bdmapv2_final where codehydro is null   ---440 lines
 select * from bdmap2009.station_bdmapv2_final where th_code is null   ---1 lines