I’ve written python scripts to process and load ACS data into a PostGIS database, and know someone who has done similar for the SF1 data. I’ve been planning on cleaning up my python for the ACS and make it available under an open source license (probably Apache 2). I’ll see if my colleagues who did the SF1 load (and then shared it with me) are willing to do the same.




Nathaniel (Nate) Roth

GIS Programmer

Information Center for the Environment

Department of Environmental Science & Policy

University of California, Davis

1 Shields Ave

Davis, CA 95616




From: John-Paul Hopman [mailto:jhopman@macog.com]
Sent: Tuesday, July 31, 2012 12:18 PM
To: CTPP News
Subject: Re: [CTPP] Regional and Statewide Census Geodatabases


We have been referred to the demographic profile geodatabases before and made need to take a second look. However we were hoping to keep everything in a single central geodatabase, if one already existed, preferably with more then just the basic demographic tables.


Thank-you for the feedback and links though.


John-Paul Hopman




 >>  Geography Division, Census Bureau released TIGER/Line shapefiles and
 >>  geodatabase files with linework and 2010 Census demographic profile data.
 >>  See our TIGER Products page at http://www.census.gov/geo/www/tiger/ and
 >>  specifically http://www.census.gov/geo/www/tiger/tgrshp2010/2010DP1.html
 >>  ______________________________________
 >>  Michael R. Ratcliffe
 >>  Assistant Division Chief, Geocartographic Products and Criteria
 >>  Geography Division
 >>  U.S. Census Bureau
 >>  4600 Silver Hill Road/ MS-7400
 >>  Washington, DC 20233-7400
 >>  301-763-8977
 >>  michael.r.ratcliffe@census.gov
 >>  -----ctpp-news-bounces@chrispy.net wrote: -----
 >>  To: CTPP News <ctpp-news@chrispy.net>
 >>  From: John-Paul Hopman
 >>  Sent by: ctpp-news-bounces@chrispy.net
 >>  Date: 07/31/2012 12:18PM
 >>  Subject: [CTPP] Regional and Statewide Census Geodatabases
 >>  We are looking for a pre-configured 2010 Census Geodatabase with both
 >>  linework and data attached for at least the state of Indiana, if not also
 >>  including the surrounding states. Although all of the data can be
 >>  downloaded from the Census Bureau on an as needed basis, we would like a
 >>  more permanent copy in-house for our GIS needs and publication to our
 >>  regional GIS website.
 >>  We are hoping to find something pre-built, rather then downloading and
 >>  compiling everything ourselves. Any assistance in the endeavor is
 >>  appreciated.
 >>  John-Paul Hopman
 >>  Michiana Area Council of Gov'ts
 >>  _______________________________________________
 >>  ctpp-news mailing list
 >>  ctpp-news@ryoko.chrispy.net
 >>  http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
 >>  _______________________________________________
 >>  ctpp-news mailing list
 >>  ctpp-news@ryoko.chrispy.net
 >>  http://ryoko.chrispy.net/mailman/listinfo/ctpp-news