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
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
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
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>
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.
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