Changes between Version 40 and Version 41 of CookBook join ROE_CCM

Timestamp:

Mar 23, 2010 12:12:04 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCM

@@ -164 +164 @@
 
 == Some statistics about the dam projection ==
+We create a table of regions
+DROP TABLE if exists france.region;
+CREATE TABLE france.region as(
+SELECT ST_Collect(the_geom) as the_geom,code_reg FROM france.departement GROUP BY code_reg);
+Alter table france.region ADD column reg_id serial PRIMARY KEY;