Replace US Census data

[andrewxhill]

The current census data is boundaries only but the really interesting data is the actually population and demographics of the census areas. we should replace the dataset there

[pramsey]

The interesting bit is in the "summary files". This is SF1 (summary file 1) download area http://www2.census.gov/census_2010/04-Summary_File_1/

There are also SF2-SF4 as well, though I believe much of what we laypeople consider "interesting" is in SF1 primarily. Wrangling summary file data is an art apparently. Every time I've approached it I've given up and found some 3rd party who already did the work for the small area I was interested in. Getting a nationwide coverage may involve biting the bullet and working directly with the SF data.

[andrewxhill]

Let's do it, the value add here would be huge.

We should look at providing all the regional breakdowns also, since we
still don't have filtering toils
On Apr 28, 2015 8:47 AM, "Paul Ramsey" notifications@github.com wrote:

The interesting bit is in the "summary files". This is SF1 (summary file

1. download area http://www2.census.gov/census_2010/04-Summary_File_1/

There are also SF2-SF4 as well, though I believe much of what we laypeople
consider "interesting" is in SF1 primarily. Wrangling summary file data is
an art apparently. Every time I've approached it I've given up and found
some 3rd party who already did the work for the small area I was interested
in. Getting a nationwide coverage may involve biting the bullet and working
directly with the SF data.

—
Reply to this email directly or view it on GitHub
#132 (comment)
.

[andrewxhill]

https://www.census.gov/geo/maps-data/data/tiger-data.html

http://www.census.gov/popest/data/counties/totals/2014/files/CO-EST2014-alldata.csv

https://www.census.gov/geo/maps-data/data/tiger-data.html

[vhamer]

So what needs to be done to add those to Common Data?

On Wed, Apr 29, 2015 at 7:54 AM, Andrew W. Hill notifications@github.com
wrote:

https://www.census.gov/geo/maps-data/data/tiger-data.html

http://www.census.gov/popest/data/counties/totals/2014/files/CO-EST2014-alldata.csv

https://www.census.gov/geo/maps-data/data/tiger-data.html

—
Reply to this email directly or view it on GitHub
#132 (comment)
.

Vanessa Hamer
Operations & Marketplace Director
CartoDB http://cartodb.com | vhamer@cartodb.com
919.389.7768 | skype: vhamer