Skip to content

grid_ibge100km.sql

Peter edited this page Dec 18, 2021 · 1 revision
CREATE TABLE test_grade_level1 AS
  SELECT gid, pop, pop_fem_perc, iif(pop>0,round(100*dom_ocu/pop)::int,0::int) as dom_ocu_perc, grid_ibge.draw_cell(gid) geom
  FROM grid_ibge.censo2010_info
  WHERE grid_ibge.gid_to_level(gid)=1;
pg_dump -t  test_grade_level1 postgres://postgres@localhost/ibge | gzip  > test_grade_level1.sql.gz
Clone this wiki locally