ctpp-news February 2011

ctpp-news@mailman.chrispy.net

30 participants
20 discussions

by Harun Rashid

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. Regards, American Community Survey staff Harun Rashid, AICP Senior GIS Planner BCD Council of Governments 1362 McMillan Avenue, Suite 100 North Charleston, SC 29405 T: 843.529.0400 F: 843.529.0305 www.bcdcog.org

14 years, 10 months

CTPP Mid Program Report

by Weinberger, Penelope

Hi All, The CTPP is proud to direct you to our Mid-Program report. Please take a look at this snapshot of the CTPP Program from our Mid-point in late 2010. The report is a downloadable PDF and available at: http://ctpp.transportation.org/Documents/CTPPMid-ProgReportFinal.pdf Penelope Weinberger CTPP Program Manager AASHTO 202-624-3556 http://ctpp.transportation.org/Pages/default.aspx <http://ctpp.transportation.org/Pages/default.aspx> It's just as bad to not make a plan as to blindly follow the one you already have.

15 years

How to use the Census Redistricting Summary File in Access

by Mara Kaminowitz

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 Access 2007. You will need the following documents. Download them to your computer and keep them close at all times. 0FILE_STRUCTURE.pdf found at http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0FILE_ST RUCTURE.pdf 0GEOID_Construction_for_Matching.pdf found at http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0GEOID_C onstruction_for_Matching.pdf pl94-171_tech_doc.pdf found at http://www.census.gov/prod/cen2010/doc/pl94-171.pdf 1. Go to http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and 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 columns. 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 correctly. Hopefully these steps make things less confusing, not more. Good luck! Mara Mara Kaminowitz GIS Analyst ......................................................................... Baltimore Metropolitan Council Offices at McHenry Row 1500 Whetstone Way Suite 300 Baltimore, MD 21230 410-732-0500 ext. 1030 <mailto:mkaminowitz@baltometro.org> mkaminowitz(a)baltometro.org <http://www.baltometro.org/> www.baltometro.org _____ Confidentiality Statement 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.

15 years

2010 Population Data Release

by Ed Christopher

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 to http://2010.census.gov/news/press-kits/redistricting.html -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

15 years

Census 2010 release

by Jonathan Lupton

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: http://2010.census.gov/2010census/data/ 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 appropriate here. Jonathan Lupton AICP Research Planner Metroplan Little Rock AR 72201 501-372-3300

15 years

TRAINING OPPORTUNITY on using the CTPP based on three year ACS data

by Weinberger, Penelope

Hi All, 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 access software. The first webinar session is at 3:00 pm eastern on Thursday, February 17. 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: February 17 March 3 March 17 March 31 April 14 Questions about this notice, contact: Penelope Weinberger CTPP Program Manager AASHTO 202-624-3556 http://ctpp.transportation.org/Pages/default.aspx <http://ctpp.transportation.org/Pages/default.aspx> It's just as bad to not make a plan as to blindly follow the one you already have.

15 years

2010 Local Population Data watch

by Ed Christopher

Coming out this week Vermont, Maryland, Indiana, Iowa and Arkansas Coming out next week Illinois, Oklahoma, South Dakota and Texas Already out New Jersey, Virginia, Louisiana, Mississippi -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

15 years

Interim 2010 product between PL 941171 and SF1

by Charles Purvis

Hello: Question and a comment. Question: 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). Comment: 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. take care, Chuck Purvis Hayward, California

15 years

How to Combine Median Values for Mutliple Areas

by Cook, Cliff

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. Cliff Cook ----------------------------------------------------------------------------- Clifford Cook Planning Information Manager Cambridge Community Development Dept. 344 Broadway 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/>

15 years

Job announcement for Madison, WI MPO Planner/Modeler

by Schaefer, William

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. http://www.cityofmadison.com/employment/employmentListingDetails.cfm?Id=588 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 Email: wschaefer(a)cityofmadison.com www.MadisonAreaMPO.org

15 years

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 February 2011