 FROM '/Users/hugh.saalmans/Downloads/2016 census mesh block counts.csv' WITH (FORMAT CSV, HEADER);
 
 
--- Get address counts per MB
+-- Get meshblock address counts per MB -- 1 min
 WITH counts AS (
 	SELECT mb_2016_code,
 		   count(*) AS address_count

  WHERE mb.mb_2016_code = counts.mb_2016_code
;

SELECT * FROM testing.mb_2016_counts
WHERE person > 0
limit 100;

    person integer,
	address_count integer,
    state smallint,
    geom geometry(MultiPolygon, 4283),
    CONSTRAINT abs_2011_mb_pk PRIMARY KEY (mb_2016_code)
);

