ctpp-news

ctpp-news@mailman.chrispy.net

2560 discussions

CTPP Data access software archived training from March 3

by Elaine.Murakami＠dot.gov

The 2006-2008 CTPP data are available on the AASHTO CTPP website. Similar to other ACS 3-year tabulations, these data are restricted to geographic units with Counties and Places with 20,000 population and over. This means that the results are like "swiss cheese," that is, very holey. For example, if you have 6 counties in your planning area, but only 4 counties have population over 20,000, then the results will not include the other 2 counties. The same thing happens when looking at Place (City and Census Designated Place) values. For residence tabulations, you might consider using Census 2000 PUMAs since they have a complete geographic coverage. But, workplace PUMAs are not really PUMAs for this round of CTPP, as the small area workplace allocation is not yet completed. Nonetheless, we hope these data will provide some utility! As a starting point, you may want to examine some residence tables (Part 1) for tables such as means of transportation to work by household income. To use the data, you may want to first look at the on-line tutorials: http://ctpp.transportation.org/Pages/3yrdas.aspx There is a small tutorial on the CTPP, but you may also want to look at the tutorials on the overall Web Data Server, especially the one on "dimensions". The CTPP software built by Beyond 2020 is a customized version of their Web Data Server. You may want to watch and listen to the session from yesterday (March 3) http://fhwa.adobeconnect.com/p15478140/ <http://fhwa.adobeconnect.com/p15478140/> This was the first attempt at a training session on using the software. Penelope Weinberger at AASHTO plans to schedule additional sessions. For additional assistance, please contact Ms. Liang Long, CTPP Technical Support liang.long(a)dot.gov 202-366-6971

15 years

(no subject)

by Ed Christopher

Next week Arizona, California, Connecticut, Idaho, Ohio, Pennsylvania and Wisconsin will be shipped. To see what is out so far go to http://2010.census.gov/2010census/data/ -- Ed Christopher FHWA Resource Center Planning Team 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443 708-283-3534 (V) 708-574-8131 (C)

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 next webinar session is at 3:00 pm eastern on Thursday, March 3. (Yes, that's tomorrow.) 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 If you do not have a headset a call-in number will be provided. See you there! On Thursday from 3:00 pm - 4:00 pm Eastern: 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

2000 vs 2010 Municipal Boundaries

by Delchamps, April

Hi All: I am confused as to whether the 2010 Redistricting data for localities/municipalities is based on 2000 US Census boundaries/limits or new boundaries/limits (i.e. 2010 boundaries/limits). My confusion is partly due to the USAtoday.com census tool. If you look up localities/municipalities on USAtoday.com and at the bottom is a hot link "about this data." In this pop-up, it says the following about population..... Comparisons between 2000 and 2010: For states, counties and localities, boundary changes were not considered. If a city annexed land, for instance, the comparison matches the population in the 2000 boundary with the population in the 2010 boundary. No comparison is made for areas that are substantially new or the product of a merger or consolidation. I understood this to be saying that the 2000 vs. 2010 percent comparison and the 2010 population count is based on the 2000 US Census locality/municipality boundary. Now I am exploring AF2 and I want to ensure I understand what boundary, 2000 or 2010, the population count refers to before doing additional analysis. Can anyone confirm that the Redistricting data just released for 2010 population counts for municipalities/localities is based on 2000 or 2010 municipal/local boundaries? Because of annexations and other issues/changes some boundary changes are now different in multiple municipalities in Montgomery MPO. Thank you for your help. April Delchamps Transportation Planner Planning and Development Department Transportation Planning Division City of Montgomery/MPO 495 Molton St Montgomery, AL 36104 Phone (334) 241-2734 Fax (334) 241-2326 adelchamps(a)montgomeryal.gov MPO website: www.montgomerympo.org City of Montgomery website: http://www.montgomeryal.gov/depts/planning/transportation.aspx -----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 25, 2011 11:57 AM To: ctpp-news(a)chrispy.net Subject: ctpp-news Digest, Vol 84, Issue 27 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. CTPP Mid Program Report (Weinberger, Penelope) 2. Public Transportation and GIS Conference (Catala, Martin) ---------------------------------------------------------------------- Message: 1 Date: Fri, 25 Feb 2011 12:30:18 -0500 From: "Weinberger, Penelope" <pweinberger(a)aashto.org> Subject: [CTPP] CTPP Mid Program Report To: <ctpp-news(a)chrispy.net> Message-ID: <94A99461953E3341B89642B00D5C0B7D0721D562(a)AASHTO-MAIL.aashto.local> Content-Type: text/plain; charset="us-ascii" 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

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

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