Usuário:Peter/Entrega2024-06grid

De Documentação
< Usuário:Peter
Revisão de 13h20min de 24 de junho de 2024 por Peter (discussão | contribs)

create table lixo_grid_br as  SELECT gid_vbit, 10*hlevel as intlevel,  geom
  FROM osmc.grid_generate_all_levels(5, 'BR', '{0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,fT,fY,fP,fN}', 18, 0.005, 0.00000005)
  WHERE ST_intersects(geom, (select st_transform(geom,952019) from grid_br.isoadmin_l0)) 
; -- sem interseção 31725 linhas, com 17430. Em 5 minutos

create table lixo_grid_br as  SELECT gid_vbit, 10*hlevel as intlevel,  geom
  FROM osmc.grid_generate_all_levels(8.5, 'BR', '{0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,fT,fY,fP,fN}', 18, 0.005, 0.00000005)
  WHERE ST_intersects(geom, (select st_transform(geom,952019) from grid_br.isoadmin_l0)) 
; -- em minutos.