ctpp-news May 2011

ctpp-news@mailman.chrispy.net

32 participants
19 discussions

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, 9 months

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, 9 months

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

by Weinberger, Penelope

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, 9 months

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@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@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@metc.state.mn.us> web: http://www.metrocouncil.org/data/ ________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@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, 9 months

Question on 2010 Census data and linking to the Access file

by Jason Gillow

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 E-mail- jgillow(a)ovrdc.org

14 years, 9 months

Urbanized Area Delineation Question

by Mike Conger

Our agency is attempting to get a jump on determining what potential changes may occur to our urbanized area based on the new census data and the proposed 2010 Census Urban Area criteria. I'm sure that we're not the only ones out there doing this. We are initially just looking at the most basic criteria involving the population density requirements, but we have already run into an issue that we need clarification on with regards to what should be used as the starting geographic "container". Specifically, section 1, Identification of Initial Urban Area Cores, of the proposed criteria (Federal Register, Vol. 75, No. 163, August 24, 2010) is causing some confusion. That section outlines a series of steps that must be followed in the process to define urban areas. The first step calls for the identification of census tracts that have land area less than three square miles and a population density of at least 1,000 people per square mile. Stated next in the criteria: "If a qualifying census tract does not exist, then one or more contiguous census blocks that have a population density of at least 1,000 people per square mile are identified and aggregated." Then it is stated, "This aggregation of continuous census tracts or census blocks, as appropriate, would be known as the initial urban area core." Our question: What is the starting geography within which we look for qualifying census tracts? Within a county? A metropolitan statistical area? A combined statistical area? Key to the second and third statements is the use of the words, "IF" and "OR." "IF" no qualifying tracts are found, then look for qualifying blocks. The initial urban area core is an aggregation of continuous census tracts OR census blocks. Since the initial core identified in step one is either tracts OR blocks, not both, we need to know the geographic container within which we look for qualifying tracts or blocks. As a side question - is anyone aware of software/GIS scripts already available out there capable of running a 2010 urbanized area delineation analysis? I do realize that since the criteria have not yet been finalized it is very unlikely that any are available - at least from commercial vendors. Any help would be appreciated, thanks, Mike CongerMichael D. Conger, P.E. Senior Transportation Engineer Knoxville Regional TPO 400 Main Street, Suite 403 Knoxville, TN 37902Ph: 865-215-3813 Fax:865-215-2068

14 years, 9 months

"CTPP Data Access Software Basics"

by Weinberger, Penelope

Hi All, If you haven't had a chance to participate in the CTPP software basic training webinar, or you would like to review after having participated in one, the Webinar from April 14th is now available to view at: http://ctpp.transportation.org/Pages/webinardirectory.aspx where you can access the webinar and download the supporting and presentation materials. 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® 7, Vista, XP or 2003 Server Macintosh®-based attendees Required: Mac OS® X 10.4.11 (Tiger®) or newer <http://img.gotomeeting.com/g2mimages/1x1.gif>

14 years, 10 months

AUTO: Out of the Office (returning 05/10/2011)

by michele.h.lowe＠census.gov

I am out of the office until 05/10/2011. Please call our main number (301-763-3030) if you need assistance before I return next Tuesday (5/10). Thanks. Note: This is an automated response to your message "[CTPP] Census Vacant Structure Determination" sent on 4/26/2011 9:41:02 AM. This is the only notification you will receive while this person is away.

14 years, 10 months

looking for journey to work data newer than 2000

by Nancy Reger

Does anyone know a source for journey to work data for small geographies (any geography really) post 2000 census? Nancy Reger, AICP Deputy Director, Transportation Mid Ohio Regional Planning Commission 111 Liberty St, Ste 100, Columbus OH 43215 P: (614) 233-4154 /E: nreger(a)morpc.org

14 years, 10 months

2026

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-news May 2011