Changes between Version 41 and Version 42 of CookBook join ROE_CCM
- Timestamp:
- Mar 23, 2010 12:12:29 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join ROE_CCM
v41 v42 165 165 == Some statistics about the dam projection == 166 166 We create a table of regions 167 {{{ 167 168 DROP TABLE if exists france.region; 168 169 CREATE TABLE france.region as( 169 170 SELECT ST_Collect(the_geom) as the_geom,code_reg FROM france.departement GROUP BY code_reg); 170 171 Alter table france.region ADD column reg_id serial PRIMARY KEY; 172 }}} 171 173