Changes between Version 41 and Version 42 of CookBook join ROE_CCM


Ignore:
Timestamp:
Mar 23, 2010 12:12:29 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • CookBook join ROE_CCM

    v41 v42  
    165165== Some statistics about the dam projection == 
    166166We create a table of regions 
     167{{{ 
    167168DROP TABLE if exists france.region; 
    168169CREATE TABLE france.region as( 
    169170SELECT ST_Collect(the_geom) as the_geom,code_reg FROM france.departement GROUP BY code_reg); 
    170171Alter table france.region ADD column reg_id serial PRIMARY KEY; 
     172}}} 
    171173