Changes between Version 45 and Version 46 of CLC Join

Timestamp:

Jun 1, 2010 12:38:03 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -130 +130 @@
 Finally we use this dataset to extract data for a new table which will give one value per catchment id. Note that the gid is the gid of the ''' catchment ''' and the table will have to be joined to the ''' riversegments ''' table. We are not using percentage of cover but surface so that we will be able to calculate for any basin, for instance, the cumulated urban area for the whole catchment upstream from one riversegment.
 We have chosen to group the Corinne Land Cover variables as following
-         * urban.gid,
+
          * urban_11_13,
          * green_urban_14,
@@ -149 +149 @@
 DROP TABLE IF EXISTS clc.pourc_area;
 CREATE TABLE clc.pourc_area AS (
-SELECT urban.gid,
-        urban_11_13,
+SELECT   init.gid,
+         urban_11_13,
          green_urban_14,
          arable_land_21,