search

CartoDB / data-services

CARTO internal geocoder PostgreSQL extension
25 stars 11 forks source link

Replace US Census data #132

Open andrewxhill opened 9 years ago

andrewxhill commented 9 years ago

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 commented 9 years ago

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 commented 9 years ago

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 https://github.com/CartoDB/data-services/issues/132#issuecomment-97049931 .

andrewxhill commented 9 years ago

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 commented 9 years ago

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 https://github.com/CartoDB/data-services/issues/132#issuecomment-97400386 .

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