Changes between Version 2 and Version 3 of Calculating CorineLandCover_Anglian

Timestamp:

Mar 1, 2011 8:58:08 AM (14 years ago)

Author:

celine

Comment:

--

Calculating CorineLandCover_Anglian

@@ -17 +17 @@
         
        -- AND substring(code_00 from 1 for 1)='1'
-       )  AS intersected; --2h30 min
+       )  AS intersected; --4h49 min
 ALTER TABLE clc.clipped_anglian ADD column id serial PRIMARY KEY;
 alter table clc.clipped_anglian add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
@@ -37 +37 @@
                                  clc.clipped_anglian
                                 ) As f 
-GROUP BY gid,code_00);--171 s
+GROUP BY gid,code_00);--2.765 s
 ALTER TABLE clc.clipped_anglian1 add column id serial PRIMARY KEY;
 alter table clc.clipped_anglian1 add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
@@ -121 +121 @@
                         substring(code_00 from 1 for 2)='52'
                         GROUP BY gid) AS marine_water
-                        on marine_water.gid =init.gid); --375 ms
+                        on marine_water.gid =init.gid); --437 ms
 ALTER TABLE clc.surf_area_anglian ADD CONSTRAINT c_pk_gid_surf_area_anglian PRIMARY KEY (gid);
 SELECT * FROM clc.surf_area_anglian;
@@ -173 +173 @@
 JOIN ccm21.catchments c ON c.gid=p.gid
 JOIN ccm21.riversegments r on r.wso1_id=c.wso1_id
-);
+);  --7.609 s
 }}}