wiki:Joining station BDMAP on CCM

Version 6 (modified by celine, 14 years ago) (diff)

--

back to first page ..

Some station must be reproject and the gid (or wso1_id) must be changed:

DROP table if exists bd_map.bdmap_ccm_gid
CREATE TABLE bd_map.bdmap_ccm_gid as (
select distinct on (st_codecsp) st_codecsp, gid from bd_map.bdmap_ccm_final
);
update bd_map.bdmap_ccm_gid SET gid='256428' where st_codecsp='06210010';
update bd_map.bdmap_ccm_gid SET gid='307291' where st_codecsp='05405071';
update bd_map.bdmap_ccm_gid SET gid='316023' where st_codecsp='05645242';
update bd_map.bdmap_ccm_gid SET gid='237651' where st_codecsp='05471015';
update bd_map.bdmap_ccm_gid SET gid='299119' where st_codecsp='05245023';
update bd_map.bdmap_ccm_gid SET gid='255384' where st_codecsp='03580002';
update bd_map.bdmap_ccm_gid SET gid='264627' where st_codecsp='03760112';
update bd_map.bdmap_ccm_gid SET gid='296658' where st_codecsp='05332023';
update bd_map.bdmap_ccm_gid SET gid='296658' where st_codecsp='05330018';
update bd_map.bdmap_ccm_gid SET gid='324566' where st_codecsp='06250227';
update bd_map.bdmap_ccm_gid SET gid='322161' where st_codecsp='05630038';
update bd_map.bdmap_ccm_gid SET gid='237651' where st_codecsp='05470066';
update bd_map.bdmap_ccm_gid SET gid='247847' where st_codecsp='03500175';
update bd_map.bdmap_ccm_gid SET gid='310676' where st_codecsp='06250317';
update bd_map.bdmap_ccm_gid SET gid='255384' where st_codecsp='03580002';
update bd_map.bdmap_ccm_gid SET gid='264627' where st_codecsp='03760112';

New update

update bd_map.bdmap_ccm_gid SET gid='262623' where st_codecsp='06690101';