Usuário:Peter/Entrega2024-06grid: mudanças entre as edições
(Criou página com ' <pre> 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) ; </pre>') |
mSem resumo de edição |
||
Linha 4: | Linha 4: | ||
create table lixo_grid_br as SELECT gid_vbit, 10*hlevel as intlevel, geom | 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) | 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. | |||
</pre> | </pre> |
Edição das 13h20min de 24 de junho de 2024
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.