ctpp-news March 2011

ctpp-news@mailman.chrispy.net

56 participants
45 discussions

2010 Data Release Watch

by Ed Christopher

Next week the Census Bureau is poised to release the local-level 2010 Census population counts for Alaska, Florida, Georgia, Kentucky, Minnesota, Montana, New Mexico, North Dakota and Tennessee. Based on a quick and cursory review that leaves only MI, SC, WV, NY, MA, NH,ME,RI and PR. http://2010.census.gov/2010census/data/ -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

13 years, 4 months

DataFerrett app by Census

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

13 years, 8 months

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

by Weinberger, Penelope

Hi All, Sorry for the late notice, CTPP data access software training is temporarily on hold. There will be no training tomorrow, but the training will be rescheduled and come on line soon. In the meantime you can review the webinar from March 3, it can be found at: http://fhwa.adobeconnect.com/p15478140/ It is my hope that training will be online in time for the April 14th previously scheduled session, however it will be with registration and VOIP. So watch this list for further notice, and keep sending me your questions. 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. From: Weinberger, Penelope Sent: Tuesday, February 15, 2011 2:24 PM To: (ctpp-news(a)chrispy.net); TMIP-L(a)LISTSERV.TAMU.EDU Subject: TRAINING OPPORTUNITY on using the CTPP based on three year ACS data 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.

13 years, 8 months

Atlas of Rural and Small-Town America

by Elaine.Murakami＠dot.gov

Another example of using ACS data, and combining it with other data These results are limited to county geography only. Elaine --------------- Thanks to FHWA Hawaii Division's Liz Fischer for sharing the interactive online data tool below. Brenda C. Kragh Social Science Analyst FHWA Office of Human Environment Atlas of Rural and Small-Town America This month's featured resource is the Atlas of Rural and Small-Town America <https://webmail3.dot.gov/exchweb/bin/redir.asp?URL=http://r20.rs6.net/t n.jsp?llr=jbzhuubab%26et=1104996167958%26s=7324%26e=001G9lMtrSlSr9GGlHth GNylZ_Y5pY_LxsQKDAskqCn_L_afUmGG-00xFBs_i6IqGySx2PZmb6n-XlPOcDzYplXPrtID 2te81D8xFgjFh20nvW9WXLfpxFWSMkah2B_CrHbTk5hAIacYt4=> [http://www.ers.usda.gov/data/ruralatlas/] , an interactive online data tool maintained by the Economic Research Service of the U.S. Department of Agriculture. The Atlas highlights the value of the U.S. Census Bureau's American Community Survey as a source of county data, aggregating data from several different federal sources. Through its interactive visual display, the Atlas assembles statistics on four broad categories of socioeconomic factors including demographics, jobs, agriculture indicators, and poverty trends. Users of this information-rich tool have the option to view county-level maps; view the entire country or zoom into specific regions, States, or county areas; view a selected socioeconomic indicator; view a pop-up window showing all the indicators for that county; print a version of the map or save the image in a graphics-file format that may be added to documents or presentations. A few clicks can provide a visual display of trends affecting transportation use, such as the percentage of persons over 65 living alone, retirement destinations projected to expand in the next ten years, and the shape of employment changes throughout the country.

13 years, 8 months

Important TAZ Participant Information - Program Commencement

by Weinberger, Penelope

Hi All, The TAZ Delineation program is fully deployed. If you are a primary contact you should have received an email with a subject line identical or very similar to: Important TAZ Participant Information - Program Commencement (your area). The email contains your unique set up file and a link to download software and geography. It also instructs you to call 301.763.1099 and ask to speak to a member of the GEO TAZ Team to receive your username and password to access the TAZ MTPS software. If you are a primary contact for TAZ delineation and have not received the email, call 301-763-1099 or email geo.taz.list(a)census.gov for more help. Happy Delineating! Penelope Weinberger CTPP Program Manager, AASHTO

13 years, 8 months

FactFinder 2

by Ed Christopher

I must admit that every time I sit down and try to bolster my skills with the new FactFinder I find myself easily getting distracted and never getting anything accomplished. However, someday I hope to make it through all the tutorials and become as proficient with the new FactFinder as I am with the legacy version. Although it is not quite FactFinder, some colleagues turned me on to an interactive map done by the NY Times where you can begin to pull numbers from the 2010 Census. In less than 3 minutes and without going through any tutorials I was able to view the tract data for my home tract. Here is the link. http://projects.nytimes.com/census/2010/map?ref=nyregion -- Ed Christopher FHWA Resource Center Planning Team 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443 708-283-3534 (V) 708-574-8131 (C)

13 years, 8 months

TAZ User Guide

by Ed Christopher

If you will be creating your Census TAZs and/or TADs attached is the User Guide. It was just released by the Census Bureau and very soon folks will be notified directly by the Bureau that their TAZ materials are available. I would recommend that you take a look at the User Guide before hand to familiarize yourself with the software and most of all IF YOU HAVE TO GET SPECIAL RIGHTS TO LOAD SOFTWARE OF YOUR COMPUTER YOU BEGIN NOW TO TAKE THE NECESSARY STEPS TO OBTAIN ALL APPROVALS. Also to view a demonstration of the software our 2 hour webinar can be viewed from two different locations. http://fhwa.adobeconnect.com/p42996378/ http://ctpp.transportation.org/Pages/default.aspx -- Ed Christopher FHWA Resource Center Planning Team 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443 708-283-3534 (V) 708-574-8131 (C)

13 years, 9 months

Call for articles for CTPP Status Report Spring 2011 issue

by Liang.Long.CTR＠dot.gov

Hi, All If you have done any interesting analysis using CTPP 2006-2008 data or ACS data, we would like to include your work in our CTPP status report Spring 2011 issue. You just need to write up a short article about your work (one page or half an page will be enough) and give it to me. Articles will be due sometime at the end of April. CTPP status report is published on both FHWA CTPP and TRB Census subcommittee websites. Please click the following links to see previous issues. http://www.fhwa.dot.gov/ctpp/status.htm http://trbcensus.com/newsletters.html Please contact me if you are interested! Thanks in advance! Liang Long Federal Highway Administration Room 74-440 1200 New Jersey, SE Washington, DC 20590 tel 202 366 6971 fax 202 493 2198 e-mail liang.long(a)dot.gov <mailto:liang.long@dot.gov>

13 years, 9 months

RE: [CTPP] RE: how to use Census Redistricting Summary Files in Access

by Patty Becker

We just got Michigan today, and I'm really confused. I downloaded the files from the web site, and I think I understand the 3 different files OK. If I could get them into FoxPro (which I use instead of Access) I'd be fine getting them merged. My problem is that WinZip (version 15.0) won't allow me to rename the .pl to .txt. Tells me that it's a read only file. I can't do anything with mi2010geo.pl -- can't read it in any software. Help! (And why does the bureau do this to us???) Patty Becker At 05:44 PM 3/21/2011, you wrote: >I had a similar problem. > >When you rename the files make sure that you can see the pl >extension, otherwise Windows will name it scgeo2010.csv.pl. Access >also seems to prefer .txt to .csv. > >Dan Estersohn >Arbitron Inc. > > >-----Original Message----- >From: ctpp-news-bounces(a)chrispy.net on behalf of Harun Rashid >Sent: Mon 3/21/2011 3:33 PM >To: ctpp-news(a)chrispy.net >Subject: [CTPP] RE: how to use Census Redistricting Summary Files in Access > >In following Mara Kaminowitz's work steps, I'm stuck with >instructions in the Census document - '0FILE_STRUCTURE'. I am >referring to page 2, instructions under 'For Access Users' - >a. using Access 2007 in Windows XP >b. Step 3 of Part 1 says 'Unzip the PL files you wish to load into >Access and rename the file extension to csv' - after extracting with >WinZip, I simply renamed these files to add .csv at end. File types >remain 'PL file', as shown in Windows explorer >c. Instructions in Part 2 seem to prepared for 2003 versions. When I >try to follow similar steps in 2007, the files renamed in previous >step are not recognized > >Any help will be appreciated. > >Harun > >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 > >-----Original Message----- >From: ctpp-news-bounces(a)chrispy.net >[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of >ctpp-news-request(a)chrispy.net >Sent: Friday, February 18, 2011 10:02 AM >To: ctpp-news(a)chrispy.net >Subject: ctpp-news Digest, Vol 84, Issue 24 > >Send ctpp-news mailing list submissions to > ctpp-news(a)chrispy.net > >To subscribe or unsubscribe via the World Wide Web, visit > http://www.chrispy.net/mailman/listinfo/ctpp-news >or, via email, send a message with subject or body 'help' to > ctpp-news-request(a)chrispy.net > >You can reach the person managing the list at > ctpp-news-owner(a)chrispy.net > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of ctpp-news digest..." > > >Today's Topics: > > 1. How to use the Census Redistricting Summary File in Access > (Mara Kaminowitz) > 2. Re: How to use the Census Redistricting Summary File in > Access (Ed Christopher) > 3. Re: 2010 Population Data Release (Ed Christopher) > 4. Re: 2010 Population Data Release (wendell cox) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Fri, 18 Feb 2011 09:06:31 -0500 >From: "Mara Kaminowitz" <mkaminowitz(a)baltometro.org> >Subject: [CTPP] How to use the Census Redistricting Summary File in > Access >To: <ctpp-news(a)chrispy.net> >Message-ID: <E7C1057941BA4C6AB416BCA0737364B2(a)bmc.net> >Content-Type: text/plain; charset="us-ascii" > >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. > > >

13 years, 9 months

Declined: [CTPP] CUTR Webcast-American Community Survey Statistical Analyzer March 24 at Noon (EDT)

by Michael Poer

BEGIN:VCALENDAR PRODID:-//Microsoft Corporation//Outlook 14.0 MIMEDIR//EN VERSION:2.0 METHOD:REPLY X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VTIMEZONE TZID:Central Standard Time BEGIN:STANDARD DTSTART:16011104T020000 RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=11 TZOFFSETFROM:-0500 TZOFFSETTO:-0600 END:STANDARD BEGIN:DAYLIGHT DTSTART:16010311T020000 RRULE:FREQ=YEARLY;BYDAY=2SU;BYMONTH=3 TZOFFSETFROM:-0600 TZOFFSETTO:-0500 END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT ATTENDEE;PARTSTAT=DECLINED:mailto:mpoer@outlooktower.org CLASS:PUBLIC COMMENT:\n CREATED:20110322T211124Z DTEND;TZID="Central Standard Time":20110324T120000 DTSTAMP:20110322T211124Z DTSTART;TZID="Central Standard Time":20110324T110000 LAST-MODIFIED:20110322T211124Z LOCATION:Webinar PRIORITY:5 SEQUENCE:0 SUMMARY;LANGUAGE=en-us:Declined: [CTPP] CUTR Webcast-American Community Sur vey Statistical Analyzer March 24 at Noon (EDT) TRANSP:OPAQUE UID:040000008200E00074C5B7101A82E00800000000D0D8ABF47DE8CB01000000000000000 0100000009C37BAD714E7CD48A2F03065970744A7 X-ALT-DESC;FMTTYPE=text/html:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//E N">\n<HTML>\n<HEAD>\n<META NAME="Generator" CONTENT="MS Exchange Server ve rsion 08.01.0240.003">\n<TITLE></TITLE>\n</HEAD>\n<BODY>\n\n\n<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>\n\n</ BODY>\n</HTML> X-MICROSOFT-CDO-BUSYSTATUS:BUSY X-MICROSOFT-CDO-IMPORTANCE:1 X-MS-OLK-AUTOFILLLOCATION:FALSE X-MS-OLK-CONFTYPE:0 END:VEVENT END:VCALENDAR

13 years, 9 months

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