CTPP February 2012

ctpp@listserv.transportation.org

30 participants
18 discussions

[CTPP] 2000 Census Traffic Analysis Zones

by Messen

Would anybody know what the deal was with the 2000 Census Traffic Analysis Zones? I am working with CTPP 2000 Table 3 data. To do some spatial analysis, I turned to census boundary files for traffic analysis zones (http://www.census.gov/geo/www/cob/bdy_files.html). I quickly realized that 63 out 2639 zones for the Houston region are represented by 2+ non-adjacent polygons. Does this happen in other regions as well? Was this delineation done purposefully or perhaps these are simply errors stemming from TIGERLine 2000? Any input will be much appreciated. Thank you. Dmitry Messen H-GAC dmessen(a)h-gac.com

12 years, 2 months

[CTPP] FW: Dir. Robert M. Groves Requests Your Feedback for ACS Program Review

by Weinberger

From: U.S. Census Bureau [mailto:census(a)subscriptions.census.gov] Sent: Tuesday, February 21, 2012 2:10 PM To: Weinberger, Penelope Subject: Dir. Robert M. Groves Requests Your Feedback for ACS Program Review

12 years, 2 months

Re: [CTPP] Elaine's notes from the January conference: Federal Committee on Statistical Methodology

by Elaine.Murakami＠dot.gov

The people from Stats Netherlands said they got the data from the telecommunications provider, it is NOT a sample, for "all" data for a 2 week period, but they did not discuss HOW they negotiated the use of the dataset. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Krishnan Viswanathan Sent: Friday, February 17, 2012 12:21 PM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] Elaine's notes from the January conference: Federal Committee on Statistical Methodology Elaine Thanks for sharing this. One question - How did the Stats Netherlands people get access to the data from the cellphone providers? Maybe there are some lessons there about structuring the request and alleviating public fears that can be useful to data collection efforts here. Or did they select their sample and then approached the providers with explicit permission from this sample of the cellphone customers. In general, my impression is that overseas it is a bit easier for agencies to obtain data than here. Krishnan On Fri, Feb 17, 2012 at 2:41 PM, <Elaine.Murakami(a)dot.gov> wrote: I thought I would share my notes from this conference. FCSM is held every 2 years, and focuses on the many different surveys conducted by federal agencies. I have rarely attended, but this time, I gave a presentation about the Transportation Secure Data Center http://www.nrel.gov/vehiclesandfuels/secure_transportation_data.html , of which FHWA is the major sponsor. My attached notes do not cover my (and Evan Burton's) presentation. It is always interesting to see what people are trying, given that we have so many of the same problems: cell-phone only households, incentives, non-response, quality of response, disclosure avoidance, etc. So, even if this post is not specifically about CTPP, there are some tidbits related to ACS and census research at new university centers. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle) _______________________________________________ ctpp-news mailing list ctpp-news(a)ryoko.chrispy.net http://ryoko.chrispy.net/mailman/listinfo/ctpp-news -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311

12 years, 2 months

Re: [CTPP] Census/ACS data downloads

by Jonathan Lupton

Ms. Gemignani: Thanks for the tips with AFF2. I tried, but failed. I'll share this with the list serve because it may be instructive to others. I'm probably missing something simple, but this may help reveal the (multiple) fallacies of AFF2. After selecting the county geography, I did as you said in the message below: I typed in "labor force age sex." This was great. I got a long list of 2010 ACS tables, but at least they resembled what I'm looking for. Then I typed in "2000 SF3" and got: "No tables, files or documents were found that match . blah blah." What am I doing wrong here? When I try scrolling through the multiple pages of results, I go through two pages of 2010 ACS. Then I run into 2009 ACS. How many dozens of pages must I scroll through to get Census 2000? I also can't help but use this as commentary on AFF2. I'm a data user with years of experience and training. If I can't easily find what I need, what hope does the general public have? Very little of Census 2000 is available in printed form. Will it become the "dark age" Census, that nobody can get to? Again, thanks for taking the time. I would like nothing more than to be able to make full use of AFF2. Jonathan Lupton From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Gemignani, Nancy Sent: Friday, February 17, 2012 1:22 PM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] Census/ACS data downloads Jonathan, Sounds like you have found the table and have a simple geography (counties). I would have downloaded the table as a csv file and open it in excel. Manipulate it there to remove the variables you don't want and calc the LFPR. Are you looking for something that will extract the exact cells (total pop and in LF) you need? You could use the "modify table" function in AFF but I agree - at this time that is kinda clunky and slow - because you can only make one change at a time. But to me AFF to Excel is much faster than DataFerrett for pulling a table for multiple geographies. I guess it is just what you are comfortable with. Using the info, Mara Kaminowitz from Baltimore sent out earlier this month, once you know the specific table you want, you can construct a direct link like this one which will pull table PCT 35 from 2000 SF3 for Arkansas statewide and all its counties: http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF3/PCT035/0400000US0 5.05000|0400000US05 BTW - this table is also available by race as table PCT079 in SF4. Its link to the data for Hispanics would look like this: http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF4/PCT079/0400000US0 5.05000|0400000US05/popgroup~400 I have found that that the text search feature has greatly improved in AFF2. I typed "labor force age sex" (219 results) then selected 2000 SF3 (1 result). Now pick your geography. A handful of clicks got me to the data. If you are not familiar with the tables in the census data files, the search is actually improving into a useful tool. Nancy Gemignani California State Census Data Center Demographic Research Unit (916) 327-0103 ext 2550 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Jonathan Lupton Sent: Friday, February 17, 2012 8:41 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] Census/ACS data downloads I much appreciate the efforts by Elaine Murakami and others to help with the AFF2 problem by providing the recent webinars in AFF2 and Data Ferret. I must reluctantly confess that I am still struggling, and would like to know how other members on the CTPP list serve are faring. Here are my conclusions at the moment: 1. AFF2 is useful for obtaining pre-organized data profiles (despite its clunky and counter-intuitive interface), but in my experience it's still hard - even with the benefit of some training - to really drill down into the kind of esoteric data I sometimes need. 2. Data Ferret is great for batches, like downloading a fair amount of data for multiple geographies (like all BGs in a county, etc.) but I'm having a hard time drilling down to the highly specific items I need. My latest troubles involve trying to get employment/labor force participation by age and sex for counties and/or my metro area from SF-3 in Census 2000. I have been able, with the help of Data Ferret, to obtain the table numbers (PCT 3500-PCT 3518), but Data Ferret can't seem to give me the figures I need in a single download, and multiple downloads are proving error-prone and troublesome. Searching the table numbers in AFF2 yields the typically useless results. My search of the Missouri State Data Center site, while much appreciated, hasn't yielded the results I need. My own State Data Center (Arkansas) has some useful profiles, but again not as specific as I need. Does anyone else have tips? I feel like I could use further webinars on Data Ferret or - just possibly - AFF2, although I'm deeply suspicious of trying to make anything useful out of AFF2, since results so far have been disappointing. The seminar on Data Ferret back in December was helpful, but didn't have a lot of in-depth training on large downloads, highly specific data needs, etc. I'm deep in 'flyover country,' and hence there's a lack of training and information exchange available. Surely others face the same issues. Does anyone else want more web-based training, too? Jonathan Lupton AICP Research Planner Metroplan Little Rock, Arkansas

12 years, 2 months

[CTPP] Elaine's notes from the January conference: Federal Committee on Statistical Methodology

by Elaine.Murakami＠dot.gov

I thought I would share my notes from this conference. FCSM is held every 2 years, and focuses on the many different surveys conducted by federal agencies. I have rarely attended, but this time, I gave a presentation about the Transportation Secure Data Center http://www.nrel.gov/vehiclesandfuels/secure_transportation_data.html , of which FHWA is the major sponsor. My attached notes do not cover my (and Evan Burton's) presentation. It is always interesting to see what people are trying, given that we have so many of the same problems: cell-phone only households, incentives, non-response, quality of response, disclosure avoidance, etc. So, even if this post is not specifically about CTPP, there are some tidbits related to ACS and census research at new university centers. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)

12 years, 2 months

Re: [CTPP] Census/ACS data downloads

by Krishnan Viswanathan

Jonathan Here is some Perl code which you might find useful to extract the data you want. This code is written to obtain specific ACS data tables from tracts in multiple counties and put it all in a single file. The README tab describes the process in detail. You can modify it to fit your needs. Hope it helps. Krishnan On Fri, Feb 17, 2012 at 2:22 PM, Gemignani, Nancy < Nancy.Gemignani(a)dof.ca.gov> wrote: > Jonathan, Sounds like you have found the table and have a simple > geography (counties). I would have downloaded the table as a csv file and > open it in excel. Manipulate it there to remove the variables you don’t > want and calc the LFPR. **** > > ** ** > > Are you looking for something that will extract the exact cells (total pop > and in LF) you need? You could use the “modify table” function in AFF but > I agree – at this time that is kinda clunky and slow - because you can only > make one change at a time. But to me AFF to Excel is much faster than > DataFerrett for pulling a table for multiple geographies. I guess it is > just what you are comfortable with. **** > > ** ** > > Using the info, Mara Kaminowitz from Baltimore sent out earlier this > month, once you know the specific table you want, you can construct a > direct link like this one which will pull table PCT 35 from 2000 SF3 for > Arkansas statewide and all its counties:**** > > > http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF3/PCT035/0400000US… > **** > > ** ** > > BTW – this table is also available by race as table PCT079 in SF4. Its > link to the data for Hispanics would look like this:**** > > > http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF4/PCT079/0400000US… > **** > > ** ** > > I have found that that the text search feature has greatly improved in > AFF2. I typed “labor force age sex” (219 results) then selected 2000 SF3 ( > *1 result*). Now pick your geography. A handful of clicks got me to the > data. If you are not familiar with the tables in the census data files, > the search is actually improving into a useful tool. **** > > ** ** > > *Nancy Gemignani* > > California State Census Data Center**** > > Demographic Research Unit**** > > (916) 327-0103 ext 2550 **** > > ** ** > > *From:* ctpp-news-bounces(a)chrispy.net [mailto: > ctpp-news-bounces(a)chrispy.net] *On Behalf Of *Jonathan Lupton > *Sent:* Friday, February 17, 2012 8:41 AM > *To:* ctpp-news(a)chrispy.net > *Subject:* [CTPP] Census/ACS data downloads**** > > ** ** > > I much appreciate the efforts by Elaine Murakami and others to help with > the AFF2 problem by providing the recent webinars in AFF2 and Data Ferret. > I must reluctantly confess that I am still struggling, and would like to > know how other members on the CTPP list serve are faring. Here are my > conclusions at the moment:**** > > ** ** > > **1. **AFF2 is useful for obtaining pre-organized data profiles > (despite its clunky and counter-intuitive interface), but in my experience > it’s still hard – even with the benefit of some training – to really drill > down into the kind of esoteric data I sometimes need.**** > > **2. **Data Ferret is great for batches, like downloading a fair > amount of data for multiple geographies (like all BGs in a county, etc.) > but I’m having a hard time drilling down to the highly specific items I > need.**** > > ** ** > > My latest troubles involve trying to get employment/labor force > participation by age and sex for counties and/or my metro area from SF-3 in > Census 2000. I have been able, with the help of Data Ferret, to obtain the > table numbers (PCT 3500-PCT 3518), but Data Ferret can’t seem to give me > the figures I need in a single download, and multiple downloads are proving > error-prone and troublesome. Searching the table numbers in AFF2 yields the > typically useless results. My search of the Missouri State Data Center > site, while much appreciated, hasn’t yielded the results I need. My own > State Data Center (Arkansas) has some useful profiles, but again not as > specific as I need.**** > > ** ** > > Does anyone else have tips? **** > > ** ** > > I feel like I could use further webinars on Data Ferret or – just possibly > - AFF2, although I’m deeply suspicious of trying to make anything useful > out of AFF2, since results so far have been disappointing. The seminar on > Data Ferret back in December was helpful, but didn’t have a lot of in-depth > training on large downloads, highly specific data needs, etc.**** > > ** ** > > I’m deep in ‘flyover country,’ and hence there’s a lack of training and > information exchange available. Surely others face the same issues. Does > anyone else want more web-based training, too?**** > > ** ** > > Jonathan Lupton AICP**** > > Research Planner**** > > Metroplan**** > > Little Rock, Arkansas**** > > ** ** > > _______________________________________________ > ctpp-news mailing list > ctpp-news(a)ryoko.chrispy.net > http://ryoko.chrispy.net/mailman/listinfo/ctpp-news > > -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311

12 years, 2 months

[CTPP] Census/ACS data downloads

by Jonathan Lupton

I much appreciate the efforts by Elaine Murakami and others to help with the AFF2 problem by providing the recent webinars in AFF2 and Data Ferret. I must reluctantly confess that I am still struggling, and would like to know how other members on the CTPP list serve are faring. Here are my conclusions at the moment: 1. AFF2 is useful for obtaining pre-organized data profiles (despite its clunky and counter-intuitive interface), but in my experience it's still hard - even with the benefit of some training - to really drill down into the kind of esoteric data I sometimes need. 2. Data Ferret is great for batches, like downloading a fair amount of data for multiple geographies (like all BGs in a county, etc.) but I'm having a hard time drilling down to the highly specific items I need. My latest troubles involve trying to get employment/labor force participation by age and sex for counties and/or my metro area from SF-3 in Census 2000. I have been able, with the help of Data Ferret, to obtain the table numbers (PCT 3500-PCT 3518), but Data Ferret can't seem to give me the figures I need in a single download, and multiple downloads are proving error-prone and troublesome. Searching the table numbers in AFF2 yields the typically useless results. My search of the Missouri State Data Center site, while much appreciated, hasn't yielded the results I need. My own State Data Center (Arkansas) has some useful profiles, but again not as specific as I need. Does anyone else have tips? I feel like I could use further webinars on Data Ferret or - just possibly - AFF2, although I'm deeply suspicious of trying to make anything useful out of AFF2, since results so far have been disappointing. The seminar on Data Ferret back in December was helpful, but didn't have a lot of in-depth training on large downloads, highly specific data needs, etc. I'm deep in 'flyover country,' and hence there's a lack of training and information exchange available. Surely others face the same issues. Does anyone else want more web-based training, too? Jonathan Lupton AICP Research Planner Metroplan Little Rock, Arkansas

12 years, 2 months

[CTPP] Census 2010 Urban Area Population Estimates

by John-Paul Hopman

The new urban area boundaries are not due out until the March / April timeframe. However, I heard this morning that the 2010 population estimates for the boundaries may have been released this week. Is there any truth to this and does anyone know where I might find the information? John-Paul Hopman

12 years, 2 months

[CTPP] Alternate source of disability data

by Ed Christopher

This link was sent along to Elaine and me via Anne Morris co-chair of the TRB Environmental Justice Committee from one of FHWA contacts. It is goes to data from the Social Security Administration and lists benefits by zip code, the number of individuals on Old-Age, Survivors, and Disability Insurance program and the number of Disabled workers. It might be helpful in trying to identify the disability needs for a particular zip code or state or for that matter the number of individuals over 65. http://www.ssa.gov/policy/docs/statcomps/oasdi_zip/2010/index.html If you download the whole report the notes on what the data is all about and where it comes from are right up front. Anyone have experience using this data source? Anyone have a sense of how it might line up with our traditional Census sources? Is it any good? -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

12 years, 2 months

Re: [CTPP] alternate source of disability data?

by mkaminowitz＠baltometro.org

This might be helpful to some folks. I couldn't find it before but I just re-found it. http://www.ssa.gov/policy/docs/statcomps/oasdi_zip/2010/index.html This gives Social Security benefits by zip code. "Disabled workers" is a category. If anyone out there has really small zip codes this could be a boon. :) 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 mkaminowitz(a)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

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 2012