Re: [CTPP] Census/ACS data downloads

Hi everyone, In the past, Caliper has provided voluminous Census data with a set of "Table choosers" with each copy of our TransCAD and Maptitude software. These data were provided in addition to a much smaller set of "profile" data that we felt was very useful for transportation planning. Lately, we have been thinking about whether or not to take the Table chooser approach with the new ACS data. We would be interested in feedback about your potential interest in this and whether it would address the problems that folks are having with Census downloads. Howard Howard Slavin, Ph.D. President Caliper Corporation 617-527-4700 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Mike Harmon Sent: Friday, February 17, 2012 12:26 PM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] Census/ACS data downloads I agree with Jonathan about AFF2. I have participated in many webinars (all very well done) but even so I still have a very difficult time doing searches of any kind. AFF1 was so easy to use and I wish it was still there. Michael Harmon Census Program Coordinator San Luis Obispo Council of Governments San Luis Obispo, California From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jonathan Lupton Sent: Friday, February 17, 2012 8:41 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] Census/ACS data downloads I much appreciate the efforts by Elaine Murakami and others to help with the AFF2 problem by providing the recent webinars in AFF2 and Data Ferret. I must reluctantly confess that I am still struggling, and would like to know how other members on the CTPP list serve are faring. Here are my conclusions at the moment: 1. AFF2 is useful for obtaining pre-organized data profiles (despite its clunky and counter-intuitive interface), but in my experience it's still hard - even with the benefit of some training - to really drill down into the kind of esoteric data I sometimes need. 2. Data Ferret is great for batches, like downloading a fair amount of data for multiple geographies (like all BGs in a county, etc.) but I'm having a hard time drilling down to the highly specific items I need. My latest troubles involve trying to get employment/labor force participation by age and sex for counties and/or my metro area from SF-3 in Census 2000. I have been able, with the help of Data Ferret, to obtain the table numbers (PCT 3500-PCT 3518), but Data Ferret can't seem to give me the figures I need in a single download, and multiple downloads are proving error-prone and troublesome. Searching the table numbers in AFF2 yields the typically useless results. My search of the Missouri State Data Center site, while much appreciated, hasn't yielded the results I need. My own State Data Center (Arkansas) has some useful profiles, but again not as specific as I need. Does anyone else have tips? I feel like I could use further webinars on Data Ferret or - just possibly - AFF2, although I'm deeply suspicious of trying to make anything useful out of AFF2, since results so far have been disappointing. The seminar on Data Ferret back in December was helpful, but didn't have a lot of in-depth training on large downloads, highly specific data needs, etc. I'm deep in 'flyover country,' and hence there's a lack of training and information exchange available. Surely others face the same issues. Does anyone else want more web-based training, too? Jonathan Lupton AICP Research Planner Metroplan Little Rock, Arkansas