CTPP May 2011

ctpp@listserv.transportation.org

32 participants
27 discussions

Re: [CTPP] RE: private vehicle occupancy data from ACS

by Ed Christopher

Don't mind Steve--he is just giving a shameless plug for the NHTS ;-) In the ACS you can get a vehicle occupancy for people commuting to work. It takes a little work but you can calculate it from table B8301 (mode to work). The trick is what assumption do you use for the 5-6 people per car (maybe 5.5) cohort and the 7+ category. In 1990 we actually knew the factor and it was around 0.3xxx. Try a few numbers and see what you like, 7.2 people per car; 7.3, but I would not go over 7.5 Now for another shameless plug. One of the beauties of the CTPP tabulations is that there is a vehicle occupancy table for the work commuters. Unfortunately, with the 3-year CTPP it is only carried out to 1 decimal so everything is 1.1. I believe the 5-year tab due out sometime in 2013 will have 2 decimal places. Back to the NHTS, it's strength here is that it has all trip purposes. Polzin, Steve wrote: > there is no data on occupancy only household vehicle availability. The 2009 NHTS would have vehicle occupancy data. > > From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Jim Hubbell > Sent: Friday, May 20, 2011 4:35 PM > To: ctpp-news(a)chrispy.net > Subject: [CTPP] private vehicle occupancy data from ACS > > I'm trying to track down an estimate of private vehicle occupancy from the 2009 ACS 1-year estimates, and am having some difficulty finding the table that includes this calculation. Can anyone provide me with the ACS table number? Any help would be greatly appreciated. > > Thanks, > > Jim Hubbell > Transportation Planner II > Mid-America Regional Council > 600 Broadway, Suite 200 > Kansas City, MO 64105-1659 > 816.701.8319 voice > 816.421.7758 fax > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > 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

14 years, 2 months

Re: [CTPP] RE: private vehicle occupancy data from ACS

by wendell cox

Problem is that this is a gross vehicle count at the household level, and does not relate to commuting, so I don't think it solves the problem. The vehicle occupancy issue relates to work trips. Perhaps there is a vehicle count available elsewhere in ACS, though the suggestions advanced by others should get the number to a pretty good level of precision. Best, Wendell Cox On Sat, May 21, 2011 at 1:23 PM, Chu, Xuehao <xchu(a)cutr.usf.edu> wrote: > Table B25046 has a total vehicle count. > > > B25046. AGGREGATE NUMBER OF VEHICLES AVAILABLE BY TENURE - Universe: > OCCUPIED HOUSING UNITS > Data Set: 2009 American Community Survey 1-Year Estimates > Survey: American Community Survey > NOTE. Although the American Community Survey (ACS) produces population, > demographic and housing unit estimates, it is the Census Bureau's Population > Estimates Program that produces and disseminates the official estimates of > the population for the nation, states, counties, cities and towns and > estimates of housing units for states and counties. > For information on confidentiality protection, sampling error, nonsampling > error, and definitions, see Survey Methodology. > > Florida > > Estimate > Margin of Error > > Aggregate number of vehicles available: > 11,458,895 > +/-53,546 > > Owner occupied > 8,615,224 > +/-56,655 > > Renter occupied > 2,843,671 > +/-34,793 > > Source: U.S. Census Bureau, 2009 American Community Survey > > > > > ________________________________________ > From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] On > Behalf Of Alan [AlanPisarski(a)AlanPisarski.com] > Sent: Saturday, May 21, 2011 8:36 AM > To: ctpp-news(a)chrispy.net > Subject: RE: [CTPP] RE: private vehicle occupancy data from ACS > > Thanks Ed: I didn't want to have to correct Steve. Isn't there a total > vehicle count also somewhere in ACS? I recall using it to calc the top > category so that it all comes out right. > > -----Original Message----- > From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] > On Behalf Of Ed Christopher > Sent: Friday, May 20, 2011 6:06 PM > To: ctpp-news(a)chrispy.net > Subject: Re: [CTPP] RE: private vehicle occupancy data from ACS > > Don't mind Steve--he is just giving a shameless plug for the NHTS ;-) > > In the ACS you can get a vehicle occupancy for people commuting to work. > It takes a little work but you can calculate it from table B8301 (mode > to work). The trick is what assumption do you use for the 5-6 people > per car (maybe 5.5) cohort and the 7+ category. In 1990 we actually > knew the factor and it was around 0.3xxx. Try a few numbers and see > what you like, 7.2 people per car; 7.3, but I would not go over 7.5 > > Now for another shameless plug. One of the beauties of the CTPP > tabulations is that there is a vehicle occupancy table for the work > commuters. Unfortunately, with the 3-year CTPP it is only carried out > to 1 decimal so everything is 1.1. I believe the 5-year tab due out > sometime in 2013 will have 2 decimal places. > > Back to the NHTS, it's strength here is that it has all trip purposes. > > > Polzin, Steve wrote: > > there is no data on occupancy only household vehicle availability. The > 2009 NHTS would have vehicle occupancy data. > > > > From: ctpp-news-bounces(a)chrispy.net [mailto: > ctpp-news-bounces(a)chrispy.net] > On Behalf Of Jim Hubbell > > Sent: Friday, May 20, 2011 4:35 PM > > To: ctpp-news(a)chrispy.net > > Subject: [CTPP] private vehicle occupancy data from ACS > > > > I'm trying to track down an estimate of private vehicle occupancy from > the > 2009 ACS 1-year estimates, and am having some difficulty finding the table > that includes this calculation. Can anyone provide me with the ACS table > number? Any help would be greatly appreciated. > > > > Thanks, > > > > Jim Hubbell > > Transportation Planner II > > Mid-America Regional Council > > 600 Broadway, Suite 200 > > Kansas City, MO 64105-1659 > > 816.701.8319 voice > > 816.421.7758 fax > > > > > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > 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 > > > __________ Information from ESET Smart Security, version of virus signature > database 6140 (20110521) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > __________ Information from ESET Smart Security, version of virus signature > database 6140 (20110521) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > _______________________________________________ > 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 > -- -- Wendell Cox Demographia | Wendell Cox Consultancy - St. Louis Missouri-Illinois metropolitan region Visiting Professor, Conservatoire National des Arts et Metiers, Paris +1.618 632 8507 www.demographia.com | www.publicpurpose.com | www.rentalcartours.net Books & Publications WAR ON THE DREAM: How Anti-Sprawl Policy Threatens the Quality of Life http://www.demographia.com/wod1.pdf 7th ANNUAL DEMOGRAPHIA INTERNATIONAL HOUSING AFFORDABILITY SURVEY ( http://www.demographia.com/dhi.pdf) THE WAL-MART REVOLUTION: How Big-Box Stores Benefit Consumers, Workers, and the Economy By Richard Vedder & Wendell Cox

14 years, 2 months

[CTPP] private vehicle occupancy data from ACS

by Jim Hubbell

I'm trying to track down an estimate of private vehicle occupancy from the 2009 ACS 1-year estimates, and am having some difficulty finding the table that includes this calculation. Can anyone provide me with the ACS table number? Any help would be greatly appreciated. Thanks, Jim Hubbell Transportation Planner II Mid-America Regional Council 600 Broadway, Suite 200 Kansas City, MO 64105-1659 816.701.8319 voice 816.421.7758 fax

14 years, 2 months

[CTPP] Census population density calculations

by Elizabeth Hassett

Hello all, I am finding discrepancies between population densities that I'm calculating in ArcGIS using Census 2010 population data and the TIGER geography shapefiles (in my case for the county and state level), and population density numbers posted on Census websites. The discrepancy is from the square mileage calculation, in particular. Does anyone know if this is because water bodies are subtracted from the total square mileage for the density calculation (or if there is another reason for the discrepancy)? Thank you, Elizabeth Elizabeth Hassett Syracuse Metropolitan Transportation Council 100 Clinton Square 126 N. Salina Street, Suite 100 Syracuse, NY 13202 ehassett(a)smtcmpo.org (P) 315-422-5716 (F) 315-422-7753 Elizabeth Hassett Syracuse Metropolitan Transportation Council 100 Clinton Square 126 N. Salina Street, Suite 100 Syracuse, NY 13202 ehassett(a)smtcmpo.org (P) 315-422-5716 (F) 315-422-7753

14 years, 2 months

[CTPP] Census population density calculations

by Elizabeth Hassett

14 years, 2 months

[CTPP] May CTPP Status Report (Newsletter)

by Ed Christopher

The May issue of the CTPP Status Report newsletter is now posted on the TRB Subcommittee on Census Data for Transportation Planning webpage at http://www.trbcensus.com/ In the newletter are articles addressing the TAZ Delineation process which should be well underway within the MPOs and States, the recently released 2006-2008 CTPP Data Access Software, and the use of the 2006-2008 CTPP data in Tulsa area among others. The direct link to the newsletter is http://www.trbcensus.com/newsltr/sr0511.pdf -- 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, 2 months

[CTPP] Still time to register for today's "CTPP Data Access Software Basics"

by Weinberger

There is still time and opportunity to participate in a live webinar of CTPP software basic as it is currently scheduled to be presented two more times, on Monday, May 16th at 3:30 eastern and Thursday, June 2nd at 2:00 pm eastern. To register for one of those, go to: CTPP Data Access Software Basics A guided tour through the CTPP Based on three year ACS, including software demo and Q&A Register for a session now by clicking a date below: Mon, May 16, 2011 3:30 PM - 4:30 PM EDT <https://www1.gotomeeting.com/register/999583609> Thu, Jun 2, 2011 2:00 PM - 3:00 PM EDT <https://www1.gotomeeting.com/register/899536416> Once registered you will receive an email confirming your registration with information you need to join the Webinar. System Requirements PC-based attendees Required: Windows(r) 7, Vista, XP or 2003 Server Macintosh(r)-based attendees Required: Mac OS(r) X 10.4.11 (Tiger(r)) or newer <http://img.gotomeeting.com/g2mimages/1x1.gif>

14 years, 2 months

[CTPP] RE: ctpp-news Digest, Vol 87, Issue 6

by Wade L. White

Jason: We have put together the Census redistricting data and the 2010 block data for some key variables. Drop me an e-mail and I'll give you the access code to our FTP site so that you can download most states (including Ohio). There are two types of files there- PDF files by state that have county-level totals of a couple of key 2010 Census totals and zipped 2010 Census Block shape files. The block files have a naming convention like Census2010-XX-Blocks.zip where XX would be a two letter designation of the state. The Census 2010 redistricting data variables that were joined to the TIGER 2010 Block data are defined as follows: POPTOTAL- total population (permanent population + group quarters population) HHTOTAL- total dwelling units (occupied + seasonal + vacant) HHOCC- permanently occupied dwelling units (total less seasonal and vacant) HHVAC- not permanently occupied dwelling units (vacant + seasonal) POPOCDU- total population (permanent + group quarters) / permanent occupied dwelling units HGHFLAG- record has a value if the number of persons/occupied dwelling is greater than 5 (look for group quarters here) LOWFLAG- record has a value if the number of persons/occupied dwelling units is less than 1 (should never happen) PCTPRMOCC- percent of dwelling units occupied by permanent residents POP1WHT- permanent + group quarters population reporting one race that is white POP1BLK- permanent + group quarters population reporting one race that is black POP1NAMR- permanent + group quarters population reporting one race that is Native American or similar POPOTHR- permanent + group quarters population reporting some other racial composition (2+ races, Asian, etc.) POPLATIN- permanent + group quarters population reporting to be of Hispanic descent/affinity POPNLATN- permanent + group quarters population NOT reporting to be of Hispanic descent/affinity PCTBLACK- percent of permanent + group quarters population reporting to be a single race as black PCTLATIN- percent of permanent + group quarters population reporting to be a single descent as Hispanic POPOVR18- permanent + group quarters population reporting to 18+ years of age POPUDR18- permanent + group quarters population reporting to under 18 years of age We have processed states where requests have come in or where we know folks that might benefit from the data. If there is a state or a variable of interest that is missing let us know and we will do our best to accommodate. For technical documentation on the data that are available, see http://www.census.gov/rdo/data/2010_census_redistricting_data_pl_94-171_summ ary_files.html. Regards, Wade L. White, AICP President Click Here to Download My Updated VCard File Whitehouse Group 40 East Joyce Lane Arnold, MD 21012 Office Number: +1.202.241.2008 Fax Number: +1.866.846.5875 Mobile Number: +1.202.247.7833 Email Address: wwhite(a)wgianalytics.com Website: http://www.wgianalytics.com Mobile Website: http://mobile.wgianalytics.com ...solutions for a dynamic world This electronic mail communication may contain privileged, confidential, and/or proprietary information which is the property of Whitehouse Group Inc. If you are not the intended recipient or an authorized agent of the intended recipient please delete this communication and notify the sender that you have received it in error. -----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: Thursday, May 12, 2011 2:48 PM To: ctpp-news(a)chrispy.net Subject: ctpp-news Digest, Vol 87, Issue 6 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. RE: RE: Question on 2010 Census data and linking to the Access file (Jason Gillow) 2. RE: Question on 2010 Census data and linking to the Access file (Lisa Miller) ---------------------------------------------------------------------- Message: 1 Date: Thu, 12 May 2011 14:22:00 -0400 From: Jason Gillow <jason.gillow(a)ovrdc.org> Subject: RE: [CTPP] RE: Question on 2010 Census data and linking to the Access file To: "ctpp-news(a)chrispy.net" <ctpp-news(a)chrispy.net> Message-ID: <1E187DE1809CB240AB86E91AE244EA122FD6C2F128(a)Lychee.dsl.scoca-k12.org> Content-Type: text/plain; charset="us-ascii" No I have Excel and Access 2007 and OpenOffice Jason Gillow Research/Planning Specialist II Ohio Valley Regional Development Commission 9329 St Rt 220 E, Suite A Waverly, OH 45690 Phone: 740-947-2853 or 800-223-7491 (In Ohio) Fax: 740-947-3468 www.ovrdc.org Email: jgillow(a)ovrdc.org From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Graham, Todd Sent: Thursday, May 12, 2011 1:52 PM To: 'ctpp-news(a)chrispy.net' Subject: [CTPP] RE: Question on 2010 Census data and linking to the Access file Do you have SAS in your shop? I can provide you my SAS code for loading, compiling and merging the Redistricting, the AGQ, and the DPSF. Can't offer any help on the Access. Good luck. ________________________ Todd Graham Principal Forecaster and Project Manager Metropolitan Council 390 Robert Street North Saint Paul, MN 55101 ph: 651/602-1322 email: todd.graham(a)metc.state.mn.us<mailto:todd.graham(a)metc.state.mn.us> web: http://www.metrocouncil.org/data/ ________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Jason Gillow Sent: Thursday, May 12, 2011 12:07 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Question on 2010 Census data and linking to the Access file Hello all I was wondering if anyone had a chance to figure out how to import the 2010 Redistricting data or the new 2010 demographic profile information into the Access files on the http://www2.census.gov/census_2010/ , under http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and http://www2.census.gov/census_2010/03-Demographic_Profile/ . I have been confused about this process myself. Does anyone know of any good guides to help? Any ideas or suggestions? I have been using the new American FactFinder 2 too, but that has been a slow and confusing process too. Thank you Jason Jason Gillow Research/Planning Specialist II Ohio Valley Regional Development Commission 9329 St Rt 220 E, Suite A Waverly, OH 45690 Phone 740-947-2853 or 800-223-7491 (In Ohio) and Fax 740-947-3468 Website: www.ovrdc.org<http://www.ovrdc.org> E-mail- jgillow(a)ovrdc.org

14 years, 2 months

RE: [CTPP] RE: Question on 2010 Census data and linking to the Access file

by Colson

I found the following document on the Census website on using Access to extract data. Hope it helps. http://www.census.gov/rdo/pdf/0HowToUseMicrosoftAccessShells.pdf Thanks. Regina. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Lisa Miller Sent: Thursday, May 12, 2011 2:19 PM To: 'ctpp-news(a)chrispy.net' Subject: [CTPP] RE: Question on 2010 Census data and linking to the Access file Jason, I used the detailed instructions on the Census' website for the state-wide, block-level redistricting data and it worked like a charm (surprisingly!) I'll see if I can find the link. Lisa J. Miller Data/Graphics/GIS Manager Bi-State Regional Commission 1504 Third Avenue, PO Box 3368 Rock Island, IL 61204-3368 309.793-6302 ext. 133 www.bistateonline.org Visit our new data portal website for the Greater Quad Cities Region, http://www.GreaterQCRegion.org<http://www.greaterqcregion.org/> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Jason Gillow Sent: Thursday, May 12, 2011 12:07 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Question on 2010 Census data and linking to the Access file Hello all I was wondering if anyone had a chance to figure out how to import the 2010 Redistricting data or the new 2010 demographic profile information into the Access files on the http://www2.census.gov/census_2010/ , under http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and http://www2.census.gov/census_2010/03-Demographic_Profile/ . I have been confused about this process myself. Does anyone know of any good guides to help? Any ideas or suggestions? I have been using the new American FactFinder 2 too, but that has been a slow and confusing process too. Thank you Jason Jason Gillow Research/Planning Specialist II Ohio Valley Regional Development Commission 9329 St Rt 220 E, Suite A Waverly, OH 45690 Phone 740-947-2853 or 800-223-7491 (In Ohio) and Fax 740-947-3468 Website: www.ovrdc.org<http://www.ovrdc.org> E-mail- jgillow(a)ovrdc.org

14 years, 2 months

[CTPP] RE: Question on 2010 Census data and linking to the Access file

by Graham

Do you have SAS in your shop? I can provide you my SAS code for loading, compiling and merging the Redistricting, the AGQ, and the DPSF. Can't offer any help on the Access. Good luck. ________________________ Todd Graham Principal Forecaster and Project Manager Metropolitan Council 390 Robert Street North Saint Paul, MN 55101 ph: 651/602-1322 email: todd.graham(a)metc.state.mn.us<mailto:todd.graham(a)metc.state.mn.us> web: http://www.metrocouncil.org/data/ ________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Jason Gillow Sent: Thursday, May 12, 2011 12:07 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Question on 2010 Census data and linking to the Access file Hello all I was wondering if anyone had a chance to figure out how to import the 2010 Redistricting data or the new 2010 demographic profile information into the Access files on the http://www2.census.gov/census_2010/ , under http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and http://www2.census.gov/census_2010/03-Demographic_Profile/ . I have been confused about this process myself. Does anyone know of any good guides to help? Any ideas or suggestions? I have been using the new American FactFinder 2 too, but that has been a slow and confusing process too. Thank you Jason Jason Gillow Research/Planning Specialist II Ohio Valley Regional Development Commission 9329 St Rt 220 E, Suite A Waverly, OH 45690 Phone 740-947-2853 or 800-223-7491 (In Ohio) and Fax 740-947-3468 Website: www.ovrdc.org<http://www.ovrdc.org> E-mail- jgillow(a)ovrdc.org

14 years, 2 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 May 2011