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
13 May
13 May
10:51 a.m.
New subject: ctpp-news Digest, Vol 87, Issue 6
Thanks for the offer, I'd be happy to have the password.
Michael Harmon
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Wade L. White
Sent: Thursday, May 12, 2011 12:21 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] RE: ctpp-news Digest, Vol 87, Issue 6
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
4975
days inactive
4976
days old
1 comments
2 participants
participants (2)
-
Mike Harmon -
Wade L. White