ctpp-news

ctpp-news@mailman.chrispy.net

2560 discussions

by Kevin Garcia

Hello Everybody, I've been following the steps to import the SF1 data into the Access table shell. Everything was working smoothly until I got to the 8th table to import, and then I got the following message: 'Cannot open database " . It may not be a database that your application recognizes, or the file may be corrupt.' (See screenshot below.) I tried importing the next table, and got the same result. Has anyone run into this problem? I'm at a loss because, as I said, everything was working fine previously. Any help is much appreciated. Thanks! [cid:image003.jpg@01CC66FD.0F351D80] Best wishes, Kevin J. Garcia Data Resources Planner Northwestern Indiana Regional Planning Commission (219) 763-6060 x 125 kgarcia(a)nirpc.org p.s. I used a program called Greenshot to capture the above image. It's like a much better "print screen". It's free and totally worth checking out: http://getgreenshot.org/downloads/. I share this with all my friends!

14 years, 9 months

Re: [CTPP] Re: AFF2 and its well-known faults

by mkaminowitz＠baltometro.org

Can data from third party distributors be trusted? I would like to break free of AFF2, in fact I have to since half the time the data won't download or the table is mysteriously unavailable. But I am concerned about relying on data that has been removed from the original source. If there were an error in a table the the Census corrected the data, would the correction carry over to these sites? Mara -----Original Message----- From: Graham, Todd [mailto:todd.graham@metc.state.mn.us] Sent: Thursday, August 25, 2011 05:36 PM To: ctpp-news(a)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 email: todd.graham(a)metc.state.mn.us in: www.linkedin.com/in/toddgraham web: http://www.metrocouncil.org/data/ ________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jonathan Lupton Sent: Wednesday, August 24, 2011 2:42 PM To: ctpp-news(a)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

14 years, 10 months

Re: [CTPP] RE: AFF2 and its well-known faults

by Patty Becker

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 ><<mailto:poverber@usatoday.com>poverber(a)usatoday.com> wrote: > ><http://Census.ire.org>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 arent 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>https://github.com/ireapps/census > > > >Paul Overberg > >USA TODAY > > > > > > > > > >From: ><mailto:ctpp-news-bounces@chrispy.net>ctpp-news-bounces(a)chrispy.net >[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Graham, Todd >Sent: Thursday, August 25, 2011 5:36 PM > >To: <mailto:ctpp-news@chrispy.net>ctpp-news(a)chrispy.net >Subject: [CTPP] Re: AFF2 and its well-known faults > > > >I know youre 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>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 youll see its easy and >allows output in SAS, or flat-file or other formats. > >· <http://nhgis.org>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>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. >Youll 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: <tel:651%2F602-1322>651/602-1322 >email: <mailto:todd.graham@metc.state.mn.us>todd.graham(a)metc.state.mn.us >in: <http://www.linkedin.com/in/toddgraham>www.linkedin.com/in/toddgraham >web: <http://www.metrocouncil.org/data/>http://www.metrocouncil.org/data/ >________________________ > > > >From: ><mailto:ctpp-news-bounces@chrispy.net>ctpp-news-bounces(a)chrispy.net >[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jonathan Lupton >Sent: Wednesday, August 24, 2011 2:42 PM >To: <mailto:ctpp-news@chrispy.net>ctpp-news(a)chrispy.net >Subject: [CTPP] BEA data vs AFF2 and its well-known faults > > > >I know its 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 BEAs 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 > ><tel:501-372-3300>501-372-3300 > > > > > >_______________________________________________ >ctpp-news mailing list ><mailto:ctpp-news@chrispy.net>ctpp-news(a)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 > ><http://www.demographia.com>www.demographia.com >| www.publicpurpose.com | <http://www.rentalcartours.net>www.rentalcartours.net > >Books & Publications >WAR ON THE DREAM: How Anti-Sprawl Policy Threatens the Quality of Life ><http://www.demographia.com/wod1.pdf>http://www.demographia.com/wod1.pdf > > >7th ANNUAL DEMOGRAPHIA INTERNATIONAL HOUSING >AFFORDABILITY SURVEY >(<http://www.demographia.com/dhi.pdf>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

14 years, 10 months

BEA data vs AFF2 and its well-known faults

by Jonathan Lupton

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

14 years, 10 months

Re: [CTPP] BEA data vs AFF2 and its well-known faults

by Gyanesh Lama

I couldn't agree more. Sometime I wonder what kind of thinking goes behind designing AFF2. Just because it's not commercial, does not needlessly have to be complex. It defeats its own purpose. >>> "Jonathan Lupton" <jlupton(a)metroplan.org> 08/24/2011 2:42 PM >>> 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

14 years, 10 months

Hints on using AFF2 for 2010 Census Summary File 1

by Elaine.Murakami＠dot.gov

Hi Everyone - Hope you are having a wonderful summer! Here is a small "helpful hints" document on using American FactFinder 2 with 2010 Census Summary File 1. Hope these 2 handouts are useful to you. Thank you to everyone who helped create and improve them: Linda Clark at the Seattle Regional Office of the Census Bureau, Ed Christopher from FHWA Resource Center, and Liang Long from Cambridge Systematics. You don't have to use Census Bureau's American FactFinder 2. There are other ways to get the Summary File 1 data. The August issue of the CTPP Status Report includes a link to instructions of using the Microsoft Access Table Shell, and the Missouri Census Data Center. We are expecting final approval of the August issue any day now. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

14 years, 10 months

REMINDER: Early bird registration rate for the TRB Census conference in October ends tomorrow, AUGUST 25

by Elaine.Murakami＠dot.gov

TRB Conference "Using Census Data for Transportation Applications" October 25- 27, 2011 at the Beckman Center in Irvine, CA http://www.cvent.com/events/using-census-data-for-transportation-applica tions-conference/event-summary-fecf178bb83a468d86c4d85de1a3bcbf.aspx Also, the hotel block is open until Sept 24, but they may run out of rooms, so an early reservation is recommended. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

14 years, 10 months

Census population density calculations

by Elizabeth Hassett

Hello all, I am finding discrepancies between population densities that I'm calculating in ArcGIS using Census 2010 population data and the TIGER geography shapefiles (in my case for the county and state level), and population density numbers posted on Census websites. The discrepancy is from the square mileage calculation, in particular. Does anyone know if this is because water bodies are subtracted from the total square mileage for the density calculation (or if there is another reason for the discrepancy)? Thank you, Elizabeth Elizabeth Hassett Syracuse Metropolitan Transportation Council 100 Clinton Square 126 N. Salina Street, Suite 100 Syracuse, NY 13202 ehassett(a)smtcmpo.org (P) 315-422-5716 (F) 315-422-7753

14 years, 10 months

Data on Disabled Populations

by Elizabeth Hassett

Hi all, I have not been able to find any data on disabled populations in either SF1 2010 or ACS 2009 5-year data, specifically at the block group and tract levels. Does anyone know if disabled data indeed has not been released within these geographies/datasets? If it has not, does anyone know a good alternative for disabled data? Thank you, Elizabeth Hassett Syracuse Metropolitan Transportation Council 100 Clinton Square 126 N. Salina Street, Suite 100 Syracuse, NY 13202 ehassett(a)smtcmpo.org (P) 315-422-5716 (F) 315-422-7753

14 years, 10 months

Re: [CTPP] RE: If you are interested in CB Urban Areas delineation

by michael.r.ratcliffe＠census.gov

14 years, 10 months

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

ctpp-news