Usuário:Peter/Entrega2024-06grid: mudanças entre as edições

Usuário:Peter/Entrega2024-06grid (ver código-fonte)

170 bytes adicionados , 24 junho

2 384

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 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;
@@ Linha 76: / Linha 77: @@
            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
-   WHERE intlevel=70  -- !!
+   WHERE (10*(length(gid_vbit)-8)/2.0)::int =70  -- intlevel da cobertura do municipio
    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,
         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
     ON r.gid_vbit between t.coverbits and (t.coverbits||b'11111111111111111111111111111111111')
+;
   -- WHERE r.intlevel in (70,95,120,145,170,195)
   --       length(r.gid_vbit) in (22,27,32,37,42)
-;
 </syntaxhighlight>