Changes between Version 8 and Version 9 of Joining dams ROE on CCM

Timestamp:

Mar 16, 2011 2:27:45 PM (14 years ago)

Author:

celine

Comment:

--

Joining dams ROE on CCM

@@ -8 +8 @@
 select distinct on (ref_id) * from geobs2010.roe_ccm_500_final
 );
-update geobs2010.roe_ccm_500_final_gid SET gid=' ' where ref_id='';
+update geobs2010.roe_ccm_500_final_gid SET gid='266956' where ref_id='6186';
+update geobs2010.roe_ccm_500_final_gid SET gid='266956' where ref_id='6187';
+update geobs2010.roe_ccm_500_final_gid SET gid='266956' where ref_id='6188';
+update geobs2010.roe_ccm_500_final_gid SET gid='243685' where ref_id='7372';
+update geobs2010.roe_ccm_500_final_gid SET gid='243685' where ref_id='7371';
+update geobs2010.roe_ccm_500_final_gid SET gid='244061' where ref_id='7918';
+update geobs2010.roe_ccm_500_final_gid SET gid='235907' where ref_id='7908';
+update geobs2010.roe_ccm_500_final_gid SET gid='282306' where ref_id='15460';
 }}}