Changes between Initial Version and Version 1 of Joining dams ROE on CCM

Timestamp:

Mar 9, 2011 11:19:29 AM (14 years ago)

Author:

celine

Comment:

--

Joining dams ROE on CCM

@@ +1 @@
+back to first page [..][[BR]]
+
+Some dams must be reproject and the gid (or wso1_id) must be changed:[[BR]]
+
+{{{
+DROP table if exists geobs2010.roe_ccm_500_final_gid;
+CREATE TABLE geobs2010.roe_ccm_500_final_gid as (
+select distinct on (ref_id) * from geobs2010.roe_ccm_500_final
+);
+update geobs2010.roe_ccm_500_final_gid SET gid=' ' where ref_id='';
+}}}