CTPP

ctpp@listserv.transportation.org

5 participants
3069 discussions

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

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

by Elaine.Murakami＠dot.gov

Here are instructions that Mara Kaminowitz of Baltimore Met Council provided to the CTPP listserv in February, on the PL-94-171 files. Maybe Mara is also working on instructions for the new profile sheets! Also, I have attached some AFF2 instructions that Linda Clark of the Census Bureau Regional office in Seattle developed. Elaine From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Jason Gillow Sent: Thursday, May 12, 2011 10:07 AM 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/ <http://www2.census.gov/census_2010/> , under http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ <http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/> and http://www2.census.gov/census_2010/03-Demographic_Profile/ <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, 3 months

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

by Lisa Miller

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

[CTPP] 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, 3 months

[CTPP] 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, 3 months

[CTPP] "CTPP Data Access Software Basics"

by Weinberger

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

[CTPP] 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, 3 months

[CTPP] 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, 3 months

[CTPP] Census Urbanized Area NOTES

by Elaine.Murakami＠dot.gov

This is the same information that was in the attachment yesterday, however, some people told me they could not open the attachment. I have also reduced the spreadsheet file, so that it is now limited to those UA between 40,000 and 299,999 population. ---------------- April 19, 2011, Planning On the Web, UA Notes These notes are limited to the discussion about Census defined urban areas (urbanized areas with population 50,000 and above, and urban clusters with population 2,500 to 49,999). Urban Area Final Criteria Mike Ratcliffe, Census Bureau Geography, reported on the status of the final rules for delineating Urban Areas. He noted that the transportation community was a significant contributor of comments to the Federal Register notice on the proposed criteria ( http://edocket.access.gpo.gov/2010/2010-20808.htm <http://edocket.access.gpo.gov/2010/2010-20808.htm> ). All of the comments have been reviewed and draft criteria written. However, before the criteria are finalized and sent to the Office of Management of Budget (OMB) for posting to the Federal Register (FR), the Census Bureau's Statistical Areas Committee must meet and approve them. The Statistical Areas Committee is an internal Census Bureau Committee. So far the committee has been having difficulty finding a date on which to meet, causing delay. Mike hopes the FR notice with the final criteria will be out this summer. In the meantime, the Census Bureau staff has started to work on the technical process of identifying the Urban Areas under the assumption that the draft criteria will be approved. If the Statistical Areas Committee or OMB makes a change to the criteria, staff will have to revise the process. Mike then reported on some of the criteria that was submitted to the Statistical Areas Committee: Jump criteria - Maintain the 2.5 mile distance. Comments to the FR notice were about 50/50 on whether to return to the 1.5 mile distance from 1990 or keep the 2.5 mile from 2000. Comments to the FR notice also favored maintaining comparability to the 2000 Urban Areas so maintaining the 2.5 distance threshold is recommended. Impervious surface - Comments were overwhelming to use the impervious surface file. The impervious surface file would make sure that built up areas would be included in Urban Areas. It will have to be seen if this might impact jumps to capture more area. Merging or splitting adjacent Urbanized Areas. This topic had the most comments and the most questions. According to Mike, the proposed final criteria will call for using the Urbanized Areas from 2000 as a baseline and keep each as a separate Urbanized Area, even if an Urbanized Area touches or grows into another Urbanized Area using the 2010 Census population. They would remain separate as two Urbanized Areas even though their exact boundaries may change. Question: What if two separate Urbanized Areas are adjoining and one is above the TMA threshold and one is below the TMA boundary. Would FHWA say that both Urbanized Areas would be inside the TMA? Answer: Historically, FHWA has NOT merged Urbanized Areas, even if they are adjacent or touching, to make a combined TMA. FHWA has used the Census Bureau's list of Urbanized Areas with population 200,000 or above. This could possibly change under re-authorization. Question: Can someone predict if an Urbanized Area is likely to reach above the current TMA threshold of 200,000? Answer: The 2007-2009 ACS 3-year data include all urban areas of 20,000 or more. Using this data set provides a sense of which urban clusters might have over 50,000 people when redefined based on 2010 census counts, and thus are potential urbanized areas. A spreadsheet of this data is embedded here. What will be population thresholds for MPOs and TMAs under re-authorization? Harlan Miller, FHWA Office of Planning was on hand and noted that the administration's proposal is expected to be sent to Congress within a month from now (or even sooner). But, he cautioned that one could not anticipate what the House or Senate might include in their version of a transportation bill. Harlan said that for now, it is best to tell people that until we know otherwise, to use 50,000 as the threshold for MPOs, and 200,000 as the threshold for TMAs.

14 years, 3 months

Jump to page:

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