Skip to content

Instantly share code, notes, and snippets.

@spara

spara/get_population_from_split_tracts.sql

Created April 26, 2012 19:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save spara/2502163 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save spara/2502163 to your computer and use it in GitHub Desktop.
Download ZIP
get split tracts
Raw
get_population_from_split_tracts.sql
SELECT tract00, tract10, pop10
FROM tract_relationship_2010
WHERE tract10 = '192200'
OR tract10 = '151302'
OR tract10 = '152201'
OR tract10 = '151301'
OR tract10 = '141101'
OR tract10 = '141404'
OR tract10 = '141102'
OR tract10 = '141403'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment