CTPP February 2011

ctpp@listserv.transportation.org

30 participants
24 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, 3 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, 5 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, 5 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, 5 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, 5 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, 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 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.

14 years, 5 months

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

14 years, 5 months

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

14 years, 5 months

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