Version 3 (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='407528' where st_codecsp='05332023'; update bd_map.bdmap_ccm_gid SET gid='407528' 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='216980' where st_codecsp='03760112';