ctpp-news August 2012

ctpp-news@mailman.chrispy.net

15 participants
6 discussions

Regional and Statewide Census Geodatabases

by John-Paul Hopman

We are looking for a pre-configured 2010 Census Geodatabase with both linework and data attached for at least the state of Indiana, if not also including the surrounding states. Although all of the data can be downloaded from the Census Bureau on an as needed basis, we would like a more permanent copy in-house for our GIS needs and publication to our regional GIS website. We are hoping to find something pre-built, rather then downloading and compiling everything ourselves. Any assistance in the endeavor is appreciated. John-Paul Hopman Michiana Area Council of Gov'ts

12 years

detailed age (block level) for population in quarters

by mkaminowitz＠baltometro.org

I have a request for detailed 2010 age data by block for the population in households (aka excluding group quarters). This data is available in SF1 and SF2 at the tract level but not block. It has to be blocks because I need to aggregate up to TAZ, and our TAZ's split tract and block group boundaries. Has anyone come across this data or found a way of estimating it? Group quarters also does not have detailed age groups so we can't just subtract. Mara Mara Kaminowitz, GISP 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.

12 years, 2 months

Re: [CTPP] comparing Census 2000 with 2006-2010 ACS results on Journey to Work

by Elaine.Murakami＠dot.gov

OOPS! I sent out the incorrect URL. The url I sent first was the one the IT people send to me for checking! Here is the correct link: http://www.fhwa.dot.gov/planning/census_issues/ctpp/data_products/2000-2010… Elaine From: Murakami, Elaine (FHWA) Sent: Monday, August 27, 2012 1:58 PM To: ctpp-news(a)chrispy.net Subject: comparing Census 2000 with 2006-2010 ACS results on Journey to Work FHWA has created CTPP profile sheets using ACS 2006-2010 and Census 2010 data (these profiles will be published in the near future). Top 30 counties and places (cities and CDPs) with highest increases in Public Transportation, Walk and Bike are extracted from the profile sheets and the lists are available in this link: http://fhwatest.fhwa.dot.gov/planning/census_issues/ctpp/data_products/2000… We limited the list to counties and places with 2010 Census population over 50,000. Because the ACS is a different survey, compared to the Census 2000 "long form", the results are not exactly comparable. But because trend analysis is important, we have developed these spreadsheets to give transportation planners a handy way to examine trends by including two time points and to look at the differences between Census 2000 results, and the 2006-2010 ACS. Differences to remember: 1. The 2006-2010 ACS is the compilation of survey over 60 months, and not a "point in time" like the decennial census. 2. Because the ACS covers all 12 months of the year, areas with seasonal population shifts, e.g. snowbirds, summer homes, and universities are likely to see the more differences than in other locations and reflect both the change is time, as well as change in survey methods. 3. ACS 5-year data are approximately one-half the sample size as the Census 2000 long form, therefore the MOE are much larger. The full list of counties and places with changes in Public Transportation, Walk and Bike can be found in Cambridge Systematics ftp site. ftp://ftp.camsys.com/clientsupport/CTPPdata/ , Username: 8305CTPP Password: 1900NJA >From your CTPP friends: Liang Long, Cambridge Systematics who is the CTPP Technical Support staff, and Elaine Murakami, FHWA Office of Planning

12 years, 2 months

comparing Census 2000 with 2006-2010 ACS results on Journey to Work

by Elaine.Murakami＠dot.gov

FHWA has created CTPP profile sheets using ACS 2006-2010 and Census 2010 data (these profiles will be published in the near future). Top 30 counties and places (cities and CDPs) with highest increases in Public Transportation, Walk and Bike are extracted from the profile sheets and the lists are available in this link: http://fhwatest.fhwa.dot.gov/planning/census_issues/ctpp/data_products/2000… We limited the list to counties and places with 2010 Census population over 50,000. Because the ACS is a different survey, compared to the Census 2000 "long form", the results are not exactly comparable. But because trend analysis is important, we have developed these spreadsheets to give transportation planners a handy way to examine trends by including two time points and to look at the differences between Census 2000 results, and the 2006-2010 ACS. Differences to remember: 1. The 2006-2010 ACS is the compilation of survey over 60 months, and not a "point in time" like the decennial census. 2. Because the ACS covers all 12 months of the year, areas with seasonal population shifts, e.g. snowbirds, summer homes, and universities are likely to see the more differences than in other locations and reflect both the change is time, as well as change in survey methods. 3. ACS 5-year data are approximately one-half the sample size as the Census 2000 long form, therefore the MOE are much larger. The full list of counties and places with changes in Public Transportation, Walk and Bike can be found in Cambridge Systematics ftp site. ftp://ftp.camsys.com/clientsupport/CTPPdata/ , Username: 8305CTPP Password: 1900NJA >From your CTPP friends: Liang Long, Cambridge Systematics who is the CTPP Technical Support staff, and Elaine Murakami, FHWA Office of Planning

12 years, 2 months

SF1 API variable IDs

by Ennis, Samuel

So I'm once again befuddled by the way the API handles variable IDs. I'm trying to retrieve data from table PCT20: "Group quarters population by group quarters type" from SF1. However the SF1 does not seem to follow the same variable formatting as the ACS 5-Year (it doesn't seem to use the _001E / _001M suffixes). In the example queries, the table "P001: total population" is retrieved using the ID 'P0010001'. Based on this I would've guessed that the 0001 designates the variable within the table in the same way that _001E does. However using this same style suffix on PCT20 results in an error. Does anyone know how these IDs are constructed? I haven't been able to find a variable list for SF1 that corresponds to this one<http://www.census.gov/developers/data/2010acs5_variables.xml>. Thanks much, Sam Ennis

12 years, 2 months

Phillip Cox/D04/Caltrans/CAGov is out of the office.

by Phillip Cox

I will be out of the office starting 08/21/2012 and will not return until 08/28/2012. Andrew Chin will be acting Branch Chief August 21 and 22. Derek Man will be acting Branch Chief August 23 through 27.

12 years, 2 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 August 2012