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='';
}}}


#Problème de doublons
{{{
select gid, id_trhyd, dist_source_bdcar, dist_sea_bdcar, height, distproj_bdcar, nbdams, distproj_ccm, count(dist_source_bdcar) as Doublons from geobs2010.roe_ccm_500_final group by dist_source_bdcar, gid, id_trhyd, dist_sea_bdcar, height, distproj_bdcar, nbdams, distproj_ccm order by doublons
}}}

A vérifier : gid=298703, 293773, 266956, 272629
{{{
select * from geobs2010.roe_ccm_500_final where gid='298703'
}}}