Has anyone had success using this web based tool from Census? We are using IE v 8 with popup-blocker turned off . Still the application is not loading. Here's the mail-out from Census:
The U.S Census Bureau announces the release of a new tool for accessing the 2005-2009 ACS 5-Year Summary File. The Census Bureau's DataFerrett web application<http://links.govdelivery.com:80/track?type=click&enid=bWFpbGluZ2lkPTExOTcwN…> now houses the summary file and provides additional methods for users to define and extract a subset of the estimates. The DataFerrett interface is easy to use and packages the data in six different file formats, including SAS, SPSS, and Stata.
For more information about the 2005-2009 ACS 5-Year Summary Files, please visit the Summary File Data and Documentation<http://links.govdelivery.com:80/track?type=click&enid=bWFpbGluZ2lkPTExOTcwN…> page on the ACS web site.
American Community Survey staff
Harun Rashid, AICP
Senior GIS Planner
BCD Council of Governments
1362 McMillan Avenue, Suite 100
North Charleston, SC 29405
We have released updates for every table that contains decimal places
because we were showing incorrect Margins of Error (MOE) values for
these. This was due to a rounding problem that converted any value less
than 1 to 0, and also left incorrect numbers in any decimals for numbers
greater than one.
For example, look at table 12230. Previously all the MOE values were
CTPP Program Manager
It's just as bad to not make a plan as to blindly follow the one you
Hi Everyone -
For TAZ participants: The Census Bureau Geography Division asked me to
let you know that you will not be able to download or upload files for
the TAZ delineation process if the government is shutdown tonight (April
For Census data users: Shutting down the CB computers also means that
www.census.gov will fail to function.
("No comment" to those of you trying to use AFF2 ;-) )
I've been trying to take a look at some of the ACS block group data just to see what they look like for our region and I see that there are a lot of variables that don't have data at the block group level. A whole lot. Does anyone know, is the Census planning on expanding the number of variables available at this level in the future, or are these variables just a casualty of the small sample sizes?
Miami Valley Regional Planning Commission
One South Main Street, Suite 260
Dayton, Ohio 45402
Does anybody on the list serve have anything good to say about American
I want something incredibly simple - total housing units for the United, and
occupied housing units, in 2010. When I go into this clunky,
counter-intuitive product, it either takes me to housing data from past
census estimates, or wants to give me Census 2000 housing figures.
Okay, so I decided to try for one of those simple 2010 profiles. You can get
them for the states. But what about the country? Can't find it. Am I
supposed to add up the housing data for all 50 states?
I don't doubt there is an answer buried somewhere in this system, but I'm in
a hurry (who isn't, in the modern world) trying to develop some US
comparison data for a report. And, as usual, AFF2 lets you down when you
need it. Message to Census Bureau: please, please dump the useless thing
and just put the data we need in the "old reliable" AFF.
Jonathan Lupton AICP
Little Rock AR
My name is Megan Cogburn and I am a Community Planner with the North Carolina Department of Transportation. My group is a part of the Project Development and Environmental Analysis branch and we are responsible for completing all of the NEPA documentation for bridge and highway projects statewide. Specifically, we prepare technical reports assessing potential project impacts on the human environment from the local/urban planning perspective.
We currently use decennial Census data for our demographic analyses, however we are thinking of switching to use American Community Survey data to make our reports more current and since the American Community Survey has now replaced the traditional decennial Census long-form. However, it has come to our attention that ACS data is only available at the block group level for 5 Year Estimates (and not annually). Moreover, certain tables that were available for the 2000 Census are not available in the ACS 5 Year Estimates (such as household type by relationship, sex by employment status, and poverty status). Another glaring issue is that ACS 5 Year Estimates were just released in 2010, so there is no previous data to make historical comparisons.
So, my question for the listserv is how other organizations are moving forward given the discrepancies between the two datasets. My group is trying to figure out where to get missing data, how to make historical comparisons, and also the best way to retrieve ACS 5-Year Estimates. A huge drawback for us is that we use block group data for multiple variables and this is only available for the 5 year estimates. In order to retrieve summary file data for block groups you have to use an Excel macro retrieval file that takes an extremely long time, download a massive file from their FTP site, or use the not so user friendly Data Ferret platform.
Megan Cogburn, MCRP
Community Planner | Human Environment Unit
NCDOT Project Development & Environmental Analysis
p: (919) 707-6062
f: (919) 212-5785
Email correspondence to and from this sender is subject to the N.C. Public Records Law and may be disclosed to third parties.
I'm working on a North Carolina Statewide Transportation Model (NCSTM)
for NCDOT. I've just completed the development of the Statewide Model
Zones (SMZs) using the recently released 2010 census block geography and
have populated the SMZs with total population and households from the
PL94-171 data. I'm now looking to use the block group data from the ACS
5 Year Summary File to supplement what I have from PL94-171.
Not too surprising, the ACS data is based on 2000 block group geography,
which is different than the 2010 block group geography. When should we
expect any ACS data to be released that conforms to the 2010 census
Todd A. Steiss, AICP, GISP
121 West Trade Street, Suite 1950
Charlotte, NC 28202
Email: steiss(a)pbworld.com <mailto:email@example.com>
NOTICE: This communication and any attachments ("this message") may contain confidential information for the sole use of the intended recipient(s). Any unauthorized use, disclosure, viewing, copying, alteration, dissemination or distribution of, or reliance on this message is strictly prohibited. If you have received this message in error, or you are not an authorized recipient, please notify the sender immediately by replying to this message, delete this message and all copies from your e-mail system and destroy any printed copies.
Here is something that the California State Data Center shared with the
SDC listserv. I have permission from Nancy to share with CTPP!
Subject: ACS Median Calculator
We thought we would share our article on calculating a median from
aggregated range data and the Excel calculator. This example uses
household income but the concepts could be used for any range data.
The formula for calculating the MOE comes from the ACS PUMS Accuracy
statement which would also be the source for the Design factor which you
should check for your state or any other variable.
California State Data Center
Demographic Research Unit
(916) 327-0103 ext 2550
I can't respond re other organizations. However, I'm most interested
in the list of tables you find missing from the ACS data. This is
another example of why user input is desperately needed in that
arena. However, I'm pretty sure that poverty status and sex by
employment status actually are there; at least, they've been there in
the 1 year and 3 year releases.
If you need historical comparisons, I think you have to compare ACS
05-10 with Census 2000.
You should note that long-form data from 2000 were also available
only at block group level and higher (in fact, long form data have
never been available at the block level, or at least not since before
1960). So you're not losing anything there. You should be able to get
household type by relationship from the 2010 SF1 file, due out this
summer. That's a short form item.
Please be aware that block group data carry extremely high margins of
error (sampling errors). This was also true in the long-form data
from the census, but the MOEs were not published so no one really noticed.
Hope this helps some.
At 03:57 PM 4/6/2011, you wrote:
>My name is Megan Cogburn and I am a Community Planner with the North
>Carolina Department of Transportation. My group is a part of the
>Project Development and Environmental Analysis branch and we are
>responsible for completing all of the NEPA documentation for bridge
>and highway projects statewide. Specifically, we prepare technical
>reports assessing potential project impacts on the human environment
>from the local/urban planning perspective.
>We currently use decennial Census data for our demographic analyses,
>however we are thinking of switching to use American Community
>Survey data to make our reports more current and since the American
>Community Survey has now replaced the traditional decennial Census
>long-form. However, it has come to our attention that ACS data is
>only available at the block group level for 5 Year Estimates (and
>not annually). Moreover, certain tables that were available for the
>2000 Census are not available in the ACS 5 Year Estimates (such as
>household type by relationship, sex by employment status, and
>poverty status). Another glaring issue is that ACS 5 Year Estimates
>were just released in 2010, so there is no previous data to make
>So, my question for the listserv is how other organizations are
>moving forward given the discrepancies between the two datasets. My
>group is trying to figure out where to get missing data, how to make
>historical comparisons, and also the best way to retrieve ACS 5-Year
>Estimates. A huge drawback for us is that we use block group data
>for multiple variables and this is only available for the 5 year
>estimates. In order to retrieve summary file data for block groups
>you have to use an Excel macro retrieval file that takes an
>extremely long time, download a massive file from their FTP site, or
>use the not so user friendly Data Ferret platform.
>Megan Cogburn, MCRP
>Community Planner | Human Environment Unit
>NCDOT Project Development & Environmental Analysis
>p: (919) 707-6062
>f: (919) 212-5785
>Email correspondence to and from this sender is subject to the N.C.
>Public Records Law and may be disclosed to third parties.
>ctpp-news mailing list
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
Dear TAZ delineation participants:
The question of what will happen IF there is a federal government
shutdown after April 8 has arisen. We hope that this situation will be
Census Bureau Geography staff will NOT be available to provide
Census Bureau servers will be shutdown, so file downloads will be NOT
be available, so my recommendation is that if you haven't downloaded
your files yet, you should do it immediately!
The timeframe for submission of TAZ files will NOT be extended.
The Census Bureau Geography team working on TAZ delineation is at
301-763-1099. Email address geo.taz.list(a)census.gov
FHWA staff will NOT be furloughed, although other people at USDOT will
FHWA Office of Planning
In the event of a federal government shutdown and furlough of Census
staff, TAZ Program participants can continue to work on their
but there will be no technical or programmatic support by the Census
during the furlough. In addition, the current plan is that all servers
will be shutdown for the period of the furlough; so TAZ Program
participants will not be able to download files or upload (submit)
We currently do not anticipate a change in the schedule for delivery of
CTPP; therefore, in order to ensure timely delivery of TAZ geography to
Census Bureau divisions responsible for tabulating, reviewing, and
disseminating CTPP data, Geography Division cannot change its schedule
the TAZ Program.
Geographic Standards & Criteria Branch
U.S. Census Bureau