CTPP

ctpp@listserv.transportation.org

5 participants
3069 discussions

[CTPP] TAZ delineation training session from February 25.

by Elaine.Murakami＠dot.gov

Hi Everyone - some of you are NOT involved in TAZ delineation, so you can just DELETE this email! But, in case you are involved, and were not able to attend the webinars that we held on 2/25 and 2/28, here is a link to the recorded session. http://fhwa.adobeconnect.com/p11971019/ <http://fhwa.adobeconnect.com/p11971019/> This session will be archived and posted on the AASHTO CTPP webpage TAZ area: http://ctpp.transportation.org/Pages/taz.aspx in the near future, as it will not live on the FHWA NHI site for very long. The Census Bureau Geography Division expects the TAZ software to be final by March 16, but the geographic files for all of the nation may not be available at that time, which is why the term "rolling" release has been used. Since the Census Bureau Geography Division says that the 90-day turn-around time is FIRM, you will need to start working on this ASAP! But please note, TAZ delineation is not mandatory for CTPP. You can use census tracts (default) or census block groups as your small tabulation geography for CTPP. We will update the FAQs for TAZ delineation (currently posted on both the AASHTO page and the FHWA page http://www.fhwa.dot.gov/ctpp/tazfaq.htm ) based on the questions and answers from the sessions held on 2/25 and 2/28. If you are interested in using 2010 Census Block Equivalency Files as a starting point, the instructions are posted on the FHWA page: http://www.fhwa.dot.gov/ctpp/tazmtps.htm Elaine Murakami FHWA Office of Planning 206-220-4460

14 years, 5 months

[CTPP] (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)

14 years, 5 months

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

by Weinberger

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.

14 years, 5 months

[CTPP] 2000 vs 2010 Municipal Boundaries

by Delchamps

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(a)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.

14 years, 5 months

[CTPP] CTPP Mid Program Report

by Weinberger

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.

14 years, 5 months

RE: [CTPP] How to use the Census Redistricting Summary File in Access

by Howard Slavin

Nathan, Dave, and others, Caliper will be providing the state redistricting data in our format to TransCAD users shortly after it is released. Howard Howard Slavin, Ph.D. President Caliper Corporation _____ From: Erlbaum, Nathan (DOT) [mailto:nerlbaum(a)dot.state.ny.us] To: ctpp-news(a)chrispy.net [mailto:ctpp-news(a)chrispy.net] Sent: Fri, 18 Feb 2011 16:26:46 -0500 Subject: RE: [CTPP] How to use the Census Redistricting Summary File in Access The real question in my mind about this is why the Census Bureau can't be this helpful ---------------------------------------------------------- Nathan Erlbaum Associate Transportation Analyst Office of Policy, Planning & Performance New York State Department of Transportation 50 Wolf Road, 6th Floor Albany, New York 12232 (Tel) 518.457.2967 (Fax) 518.457.4944 (E-mail) nerlbaum(a)dot.state.ny.us (Web) www.nysdot.gov -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Ed Christopher Sent: Friday, February 18, 2011 9:51 AM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] How to use the Census Redistricting Summary File in Access Mara--Thanks for taking the time and putting this post together. Mara Kaminowitz wrote: > 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(a)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. > > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > ctpp-news mailing list > ctpp-news(a)chrispy.net > http://www.chrispy.net/mailman/listinfo/ctpp-news -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443 _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news

14 years, 6 months

RE: [CTPP] How to use the Census Redistricting Summary File in Access

by pbecker＠umich.edu

I think they're afraid to make promises that they may not be able to keep. I just expect Michigan to be at or near the end, because we have no redistricting pressure to speak of, and because we have so many governments. New England and mid-Atlantic states fall near the end because of this, except for NJ, I guess, because of their odd year elections. Patty Becker Quoting "Erlbaum, Nathan (DOT)" <nerlbaum(a)dot.state.ny.us>: > The real question in my mind about this is why the Census Bureau > can't be this helpful > > ---------------------------------------------------------- > Nathan Erlbaum > Associate Transportation Analyst > Office of Policy, Planning & Performance > New York State Department of Transportation > 50 Wolf Road, 6th Floor > Albany, New York 12232 > > (Tel) 518.457.2967 > (Fax) 518.457.4944 > (E-mail) nerlbaum(a)dot.state.ny.us > (Web) www.nysdot.gov > > > -----Original Message----- > From: ctpp-news-bounces(a)chrispy.net > [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Ed Christopher > Sent: Friday, February 18, 2011 9:51 AM > To: ctpp-news(a)chrispy.net > Subject: Re: [CTPP] How to use the Census Redistricting Summary File > in Access > > Mara--Thanks for taking the time and putting this post together. > > Mara Kaminowitz wrote: >> 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(a)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. >> >> >> >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> ctpp-news mailing list >> ctpp-news(a)chrispy.net >> http://www.chrispy.net/mailman/listinfo/ctpp-news > > -- > Ed Christopher > 708-283-3534 (V) > 708-574-8131 (cell) > > FHWA RC-TST-PLN > 4749 Lincoln Mall Drive, Suite 600 > Matteson, IL 60443 > > _______________________________________________ > ctpp-news mailing list > ctpp-news(a)chrispy.net > http://www.chrispy.net/mailman/listinfo/ctpp-news > > > > _______________________________________________ > ctpp-news mailing list > ctpp-news(a)chrispy.net > http://www.chrispy.net/mailman/listinfo/ctpp-news > > >

14 years, 6 months

[CTPP] 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(a)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.

14 years, 6 months

[CTPP] 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

14 years, 6 months

[CTPP] 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

14 years, 6 months

Jump to page:

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