Skip to content

Instantly share code, notes, and snippets.

@wboykinm

wboykinm/income.log

Created July 2, 2014 15:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wboykinm/bb44358965dceb519104 to your computer and use it in GitHub Desktop.
Save wboykinm/bb44358965dceb519104 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
income.log
census=# CREATE TABLE income_join AS (SELECT bg.geoid,bg.the_geom,bg.namelsad,acs.b19001001 FROM tiger2012.bg bg LEFT OUTER JOIN acs2012_5yr.b19001 acs ON (bg.geoid = acs.geoid));
SELECT 220740
census=# SELECT count(*) FROM income_join WHERE b19001001 IS NOT NULL;
count
-------
0
(1 row)
@JoeGermuska
Copy link

try this:

CREATE TABLE income_join AS (SELECT bg.geoid,bg.the_geom,bg.namelsad,acs.b19001001 FROM tiger2012.bg bg LEFT OUTER JOIN acs2012_5yr.b19001 acs ON (bg.geoid = substr(acs.geoid,8))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment