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
Since I have seen a lot questions about this I thought I would post my
personal notes. If your state hasn't come out yet I strongly suggest
downloading a different state and practicing. Once you get the method down,
it will be easy to repeat.
These instructions are for Access 2003 but I think they are similar for
You will need the following documents. Download them to your computer and
keep them close at all times.
0FILE_STRUCTURE.pdf found at
0GEOID_Construction_for_Matching.pdf found at
pl94-171_tech_doc.pdf found at
1. Go to
download the access document that matches your MS Access version, either
PL2010_Access.accdb or PL2010_Access2003.mdb.
2. In the same directory, go to the folder your state is in and download
everything in the folder.
3. Unzip the files.
4. Open the PDF called 0FILE_STRUCTURE.pdf. Read the first page, it has
useful information. The go to the section marked "For Access Users" on page
2. FOLLOW THESE INSTRUCTIONS EXACTLY.
5. After the tables are imported into Access, you should have the two data
tables and the geography table automatically joined by the LOGRECNO field.
>From here, you can use queries to extract tables on a single geography and
on the topics of your choice. Start a new query in design view. I recommend
starting all queries by adding the entire geography table until you get a
feel for which fields you don't need.
6. SUMLEV is the field that will let you extract a particular geography,
such as tracts or counties. You can find a full listing of SUMLEVs under
Chapter 4 of pl94-171_tech_doc.pdf. So if you want a table that has all the
census tracts in your state, type "140" under the Criteria field of the
SUMLEV column in your query design.
7. The other two tables list your data fields. The table names are given in
the back of 0FILE_STRUCTURE.pdf.
8. Export the query to the format of your choice - Excel, dbf, txt, ect.
Note that only the newest Excel program will handle more than 65,000
9. If you are using the data in GIS, you will need to construct a GEOID
field to match the one in the shapefile. The file
0GEOID_Construction_for_Matching.pdf provides formulas for doing this.
Concatenate the fields found in the geography half of your exported table
into a GEOID field.
10. Analyze! Analyze! Analyze!
TIP: Compare the number of records in your shapefile with the numbers of
records in your exported table to make sure the table was extracted
Hopefully these steps make things less confusing, not more. Good luck!
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Baltimore, MD 21230
410-732-0500 ext. 1030
This message may contain legally privileged and confidential information
that is intended only for the use of the recipient(s) named above. If you
are not an intended recipient, taking any action based on the contents of
this message is strictly prohibited. Please immediately notify the sender if
you have received this message in error.
Next week the Census Bureau will release local 2010 Census Data
for Alabama, Colorado, Hawaii, Missouri, Nevada, Oregon,
Utah and Washington.
To see a list of states of that are out and to follow future releases go
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
Post PL94-171 reflections:
I thought I'd share a few observations now that PL 94-171 data for my state
(Arkansas) has been released.
1. Don't count on the Census Bureau to keep you up to date. I got on
their e-mail list to receive notification the minute the new census figures
were released for my state. No luck. We were all stranded at home (snow day
- 8 inches of pretty powder, daytime high 25, a major event in Arkansas)
when my boss called me from his home to say the press was calling asking for
feedback about the census figures. Moral of the story: check FactFinder2 for
your state on an hourly basis the week your state is due. Our figures have
been out for 24 hours now and they still haven't let me know, although I did
get a pointless e-mail yesterday afternoon about the 2009 ACS.
2. FactFinder2 is shaky, but not entirely useless. I managed to get
all the really vital stuff down - population by race for cities (including
CDPs) and counties in our region. Using FF2, however, was a bit like playing
"Space Invaders." (I'm showing my age here) There were times when I zapped
the aliens and got my data, and other times when the data search blew up in
my face, with a curious "dead end" situation where it was entirely locked up
and the only way to continue my search was to quit my session and start over
from scratch (and I mean all the way - getting out of FF2 and back in wasn't
enough; I had to end my Firefox session and start over). The moral of the
story: just keep trying, FF2 can't stop you if you're determined enough.
3. The Map Widget from the Census 2010 web site. In case you didn't
know, you can download a cute little census 2010 widget, customized to your
state, from the Census 2010 web site. But it won't give you notification
either. The map widget didn't show Arkansas population by county yesterday
afternoon, although it's finally showing it this morning. If you haven't
already done so, you can get the map widget here:
I recommend playing with FactFinder2 as much as you can in advance, but it's
a strange product, with all kinds of redundancies that are probably designed
to make it user-friendly, but in reality add to a new user's confusion. I
found trial-and-error more useful for my emergency than trying to learn it
methodically - there just wasn't time, plus it's pretty counter-intuitive.
If you can get training from your SDC or regional census office, that sounds
like a great idea. I could say more about FF2, but such honesty wouldn't be
Jonathan Lupton AICP
Little Rock AR 72201
The CTPP team is pleased to bring you online training on the new Census
Transportation Planning Products (CTPP) based on 3 year ACS and data
The first webinar session is at 3:00 pm eastern on Thursday, February
Drop in with your Voice Over IP (VOIP) connection and learn how the
software works, what functionality the data has, and other topics of
interest. Chat your questions and comments. No registration required.
Login at: http://fhwa.adobeconnect.com/ctpp1
On Thursday from 3:00 pm - 4:00 pm Eastern:
Questions about this notice, contact:
CTPP Program Manager
It's just as bad to not make a plan as to blindly follow the one you
Coming out this week
Vermont, Maryland, Indiana, Iowa and Arkansas
Coming out next week
Illinois, Oklahoma, South Dakota and Texas
New Jersey, Virginia, Louisiana, Mississippi
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
Question and a comment.
Will the Census Bureau produce a "Demographic Profile #1" this spring, for all places in the US? In spring 2001 (April/May/June, 2001), the Census Bureau produced a one-page profile based on Census 2000 short form data, kind of like highlights from the SF1 (not all of the details of SF1, data reported for places, counties, etc., not tracts, block groups or blocks.) This was an "intermediate" product between the release of the PL 94-171 files (February, March 2001) and the SF-1 files (summer 2001).
One NEW table from the PL 94-171 is a housing units table (total, occupied, vacant units). This is great! This will allow city planners a very early opportunity to assess the quality of the short form data for their community.
I am looking for guidance on how to combine median income values for several census tracts into a single value and associated margin of error. I recall seeing something about this topic in an ACS document but cannot locate the information at this time. Any help would be appreciated.
Planning Information Manager
Cambridge Community Development Dept.
Cambridge, MA. 02139
617/349-4656 FAX 617/349-4669 TTY 617/349-4621
email => ccook(a)cambridgema.gov
web site => <http://www.cambridgema.gov/~CDD/>
The Madison Area Transportation Planning Board, the MPO for the Madison, WI Area, is seeking a transportation planner/modeler. The general responsibilities are listed below:
Transportation Planner/Modeler: Responsible professional urban and regional transportation planning work supporting the Metropolitan Planning Organization (MPO) for the Madison area. The position is responsible for the operation and maintenance of a regional travel demand forecast model for generating traffic and transit use forecasts; preparing socioeconomic data forecasts and assembling and analyzing data for transportation planning and modeling purposes; providing assistance with the preparation of multi-modal transportation plans, reports and studies; providing assistance with the annual update to the Transportation Improvement Program; and assistance in providing staff support to the MPO policy board and MPO advisory committees. Work is performed under general supervision.
The following is a link to the job announcement on the City of Madison Human Resources' website. The City staffs the MPO. Please direct any questions to City HR.
Bill Schaefer, Transportation Planning Manager
Madison Area Transportation Planning Board - An MPO
121 S. Pinckney St., #400
Madison, WI 53703
PH: (608) 266-9115
FAX: (608) 261-9967