Skip to content

Instantly share code, notes, and snippets.

@wboykinm

wboykinm/census.sql

Created July 2, 2014 13:46
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/5a78efd323fe0eb3e70c to your computer and use it in GitHub Desktop.
Save wboykinm/5a78efd323fe0eb3e70c to your computer and use it in GitHub Desktop.
Download ZIP
#joinproblemz
Raw
census.sql
census=# SELECT DISTINCT geoid FROM acs2012_5yr.b19001 ORDER BY geoid DESC LIMIT 10;;
geoid
----------------
97000US7200030
97000US5699997
97000US5606240
97000US5606090
97000US5605830
97000US5605820
97000US5605762
97000US5605700
97000US5605695
97000US5605690
(10 rows)
census=# SELECT DISTINCT geoid FROM tiger2012.bg ORDER BY geoid DESC LIMIT 10;;
geoid
--------------
780309900000
780309612002
780309612001
780309611002
780309611001
780309610005
780309610004
780309610003
780309610002
780309610001
(10 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment