Changes between Version 71 and Version 72 of Ireland clc

Timestamp:

May 17, 2012 9:04:36 PM (13 years ago)

Author:

cedric

Comment:

--

Ireland clc

@@ -639 +639 @@
 al --verbose eda2
 }}}
+The gid's are needed to work the ccm21.upstream(_gid) function. Here is how we integrate them in the table
+{{{
+#!sql
+alter table clc.surf_area_ireland_final add column gid integer;
+alter table clc.surf_area_ireland_final add constraint c_uk_gid unique(gid);
+update clc.surf_area_ireland_final set gid=riversegments.gid
+from ccm21.riversegments where riversegments.wso1_id=surf_area_ireland_final.wso1_id; --9064
+
+select count(*) from clc.surf_area_ireland_final; --10035
+}}}