Most journalists wouldn't know a placefp code from a ham sandwich but I'll log the "geos within substate geo" idea in our feature requests. If you have the codes for tracts you want, you could download all MI tracts and link to just those you want in a database or Google Fusion Tables. Paul From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Patty Becker Sent: Friday, August 26, 2011 5:45 PM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] RE: AFF2 and its well-known faults I just took a look at the ire site. It does not appear to allow selection of a subset beneath the state level -- e.g., in my case, all the tracts in the City of Detroit. It would be helpful if the user could specify a placefp code beneath the state level. At 05:28 PM 8/26/2011, you wrote: Simplicity? Would be no easier to use if it were in Greek. On Fri, Aug 26, 2011 at 8:23 PM, Overberg, Paul <poverber@usatoday.com<mailto:poverber@usatoday.com>> wrote: Census.ire.org<http://Census.ire.org> only allows single-table downloads via bulk download (geo within geo), but its table browser allows download of many tables at once for one or a few geos. The table browser also shows descriptive column headings via a toggle to show or hide the table browser. Descriptive labels aren't included in the download file. Two other key features: -- It lets you look at a table for multiple levels of geography, so you can inspect side-by-side (for instance) a table for 4 tracts, 2 cities, a metro and a state. Then you can download just those geos for that table. -- Finally, both bulk download and table browser automatically link equivalent Census 2000 SF1 and Census 2010 SF1 tables for most geos and calculates the change and % change. We designed it for journalists, so data mavens should enjoy its simplicity. We welcome your feedback. Code is posted: https://github.com/ireapps/census Paul Overberg USA TODAY From: ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net> [ mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Graham, Todd Sent: Thursday, August 25, 2011 5:36 PM To: ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net> Subject: [CTPP] Re: AFF2 and its well-known faults I know you're frustrated with AFF2. I no longer recommend it to anyone. So if you need Census 2010 summary tabulations, here are best online alternatives to AFF2 (my picks): * http://mcdc.missouri.edu/pub/data/sf12010/Datasets.html if you need many tables for a large number of locations (for example, all Census Tracts in Minnesota). User interface looks complex the first time - but you'll see it's easy - and allows output in SAS, or flat-file or other formats. * http://nhgis.org if you need a few tables (a few topics) for a large number of locations + you want ArcGIS shapefile too. * http://census.ire.org/data/bulkdata.html if you just need one table (1 at a time) for a large number of locations. This is the quickest to navigate. The drawback is: this site does not provide descriptive column headings/labels. You'll need SF1 documentation to decipher and re-label the column headings it provides. ________________________ Todd Graham Principal Forecaster and Project Manager Metropolitan Council 390 Robert Street North Saint Paul, MN 55101 ph: 651/602-1322<tel:651%2F602-1322> email: todd.graham@metc.state.mn.us<mailto:todd.graham@metc.state.mn.us> in: www.linkedin.com/in/toddgraham<http://www.linkedin.com/in/toddgraham> web: http://www.metrocouncil.org/data/ ________________________ From: ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net> [ mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jonathan Lupton Sent: Wednesday, August 24, 2011 2:42 PM To: ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net> Subject: [CTPP] BEA data vs AFF2 and its well-known faults I know it's a lost cause to expect the Census Bureau to see reason and dump AFF2, which sometime this fall will become their only portal for census and ACS data. But anyone who believes a data searching and downloading product has to require tutorials and special training, or has to be clunky, needlessly complex, visually confusing, and counter-intuitive should visit the BEA's new web site, and try downloading economic data for his/her local area. The steps are quick, the icons are clear and intuitive, and you can get to some pretty complex stuff in a series of steps that leaves you feeling smart. By comparison, speaking only for myself, I always come away from AFF2 either feeling dumb, or like a shoplifter who actually got away with something useful, despite the risks I had to take and the danger of complete failure. However, I do appreciate the efforts of Elaine and others to provide tips and data-downloading alternatives to AFF2 - thanks! Jonathan Lupton AICP Research Planner Metroplan Little Rock AR 501-372-3300<tel:501-372-3300> _______________________________________________ ctpp-news mailing list ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net> http://www.chrispy.net/mailman/listinfo/ctpp-news -- -- Wendell Cox Demographia | Wendell Cox Consultancy - St. Louis Missouri-Illinois metropolitan region Visiting Professor, Conservatoire National des Arts et Metiers, Paris +1.618 632 8507 www.demographia.com<http://www.demographia.com> | www.publicpurpose.com<http://www.publicpurpose.com/> | www.rentalcartours.net<http://www.rentalcartours.net> Books & Publications WAR ON THE DREAM: How Anti-Sprawl Policy Threatens the Quality of Life http://www.demographia.com/wod1.pdf 7th ANNUAL DEMOGRAPHIA INTERNATIONAL HOUSING AFFORDABILITY SURVEY ( http://www.demographia.com/dhi.pdf) THE WAL-MART REVOLUTION: How Big-Box Stores Benefit Consumers, Workers, and the Economy By Richard Vedder & Wendell Cox _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news ------------------------------------------------------------------------------------------------- Patricia C. (Patty) Becker 248/354-6520 APB Associates/SEMCC FAX 248/354-6645 28300 Franklin Road Home 248/355-2428 Southfield, MI 48034 pbecker(a)umich.edu