2 391
edições
Linha 64: | Linha 64: | ||
-- alter table grid_br2.lixo_grid_br2caruaru alter column intlevel type int; | -- alter table grid_br2.lixo_grid_br2caruaru alter column intlevel type int; | ||
-- alter table grid_br2.lixo_grid_br2caruaru rename to poc_caruaru; | -- alter table grid_br2.lixo_grid_br2caruaru rename to poc_caruaru; | ||
ALTER TABLE grid_br2.poc_caruaru DROP COLUMN intlevel CASCADE; | |||
UPDATE grid_br2.poc_caruaru SET intLevel=(10*(length(gid_vbit)-8)/2.0)::int; | UPDATE grid_br2.poc_caruaru SET intLevel=(10*(length(gid_vbit)-8)/2.0)::int; | ||
Linha 76: | Linha 77: | ||
natcod.vbit_to_strstd(substring((ROW_NUMBER() OVER(ORDER BY gid_vbit))::bit(32),32-4),'32nvu') as idx_b32nvu | natcod.vbit_to_strstd(substring((ROW_NUMBER() OVER(ORDER BY gid_vbit))::bit(32),32-4),'32nvu') as idx_b32nvu | ||
FROM grid_br2.poc_caruaru | FROM grid_br2.poc_caruaru | ||
WHERE | WHERE (10*(length(gid_vbit)-8)/2.0)::int =70 -- intlevel da cobertura do municipio | ||
ORDER BY gid_vbit | ORDER BY gid_vbit | ||
) | ) | ||
SELECT natcod.vbit_to_hiddenbig(r.gid_vbit) as gid, | SELECT natcod.vbit_to_hiddenbig(r.gid_vbit) as gid, (10*(length(gid_vbit)-8)/2.0)::int as intlevel, | ||
r.*, natcod.vbit_to_str(substring(gid_vbit,5),'16h') as cod_b16h, | r.*, natcod.vbit_to_str(substring(gid_vbit,5),'16h') as cod_b16h, | ||
idx_b32nvu||COALESCE( natcod.vbit_to_strstd(substring(r.gid_vbit,22+1),'32nvu') , '' ) as cod_b32nvu | idx_b32nvu||COALESCE( natcod.vbit_to_strstd(substring(r.gid_vbit,22+1),'32nvu') , '' ) as cod_b32nvu | ||
FROM grid_br2.poc_caruaru r INNER JOIN t | FROM grid_br2.poc_caruaru r INNER JOIN t | ||
ON r.gid_vbit between t.coverbits and (t.coverbits||b'11111111111111111111111111111111111') | ON r.gid_vbit between t.coverbits and (t.coverbits||b'11111111111111111111111111111111111') | ||
; | |||
-- WHERE r.intlevel in (70,95,120,145,170,195) | -- WHERE r.intlevel in (70,95,120,145,170,195) | ||
-- length(r.gid_vbit) in (22,27,32,37,42) | -- length(r.gid_vbit) in (22,27,32,37,42) | ||
</syntaxhighlight> | </syntaxhighlight> |
edições