12 May
2011
12 May
'11
2:21 p.m.
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@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