Changes between Version 93 and Version 94 of CookBook join ROE_CCM

Timestamp:

May 26, 2010 2:33:56 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCM

@@ -175 +175 @@
 The final script is below
 {{{
+#!sql
 ALTER TABLE geobs2010.obstacle_referentiel ADD COLUMN goodproj boolean;
 UPDATE geobs2010.obstacle_referentiel set goodproj=FALSE ;
@@ -182 +183 @@
 We now have to use, and can display the dams left out in qgis
 {{{
+#!sql
 select * from geobs2010.obstacle_referentiel where goodproj=TRUE
 }}}
@@ -189 +191 @@
 We create a table of regions
 {{{
+#!sql
 DROP TABLE if exists france.region;
 CREATE TABLE france.region as(
@@ -200 +203 @@
 Calcul du pourcentage de barrages projetés par région.
 {{{
+#!sql
 DROP TABLE if exists geobs2010.pourcentageprojette;
 CREATE TABLE geobs2010.pourcentageprojette AS(
@@ -229 +233 @@
 the table is used in the loaddb method of BaseEdaCCMriversegmentsROE
 {{{
+#!sql
 SELECT sum(height) AS c_height,sum(score) AS c_score,sum(nbdams) AS nbdams,r.gid AS gid 
 FROM geobs2010.roe_ccm_300 j RIGHT JOIN ccm21.riversegments r