Match geoid from ACS table to Tiger block groups

income_join.sql

DROP TABLE IF EXISTS income_join;

CREATE TABLE 
	income_join 
AS (

	WITH table_b19013 AS (
		SELECT
			substring(geoid FROM 8 FOR 12) geoid,
			b19013001
		FROM 
			acs2012_5yr.b19013
		WHERE 
			length(substring(geoid FROM 8 FOR 12)) = 12
	)

	SELECT 
		bg.geoid,
		bg.the_geom,
		bg.namelsad,
		acs.b19013001 
	FROM 
		tiger2012.bg bg 
	LEFT OUTER JOIN 
		table_b19013 acs 
	ON 
		(bg.geoid = acs.geoid)
);