Thanks for the offer, I'd be happy to have the password.

Michael Harmon

-----Original Message-----
From: ctpp-news-bounces@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@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@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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net]

On Behalf Of ctpp-news-request@chrispy.net

Sent: Thursday, May 12, 2011 2:48 PM

To: ctpp-news@chrispy.net

Subject: ctpp-news Digest, Vol 87, Issue 6

Send ctpp-news mailing list submissions to

ctpp-news@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@chrispy.net

You can reach the person managing the list at

ctpp-news-owner@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@ovrdc.org>

Subject: RE: [CTPP] RE: Question on 2010 Census data and linking to

the Access file

To: "ctpp-news@chrispy.net" <ctpp-news@chrispy.net>

Message-ID:

<1E187DE1809CB240AB86E91AE244EA122FD6C2F128@Lychee.dsl.scoca-k12.org>

Content-Type: text/plain; charset="us-ascii"

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@ovrdc.org

From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net]

On Behalf Of Graham, Todd

Sent: Thursday, May 12, 2011 1:52 PM

To: 'ctpp-news@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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net]

On Behalf Of Jason Gillow

Sent: Thursday, May 12, 2011 12:07 PM

To: ctpp-news@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@ovrdc.org

-------------- next part --------------

An HTML attachment was scrubbed...

URL:

http://ryoko.chrispy.net/pipermail/ctpp-news/attachments/20110512/fa6062ff/a

ttachment-0001.html

------------------------------

Message: 2

Date: Thu, 12 May 2011 13:18:35 -0500

From: Lisa Miller <lmiller@bistateonline.org>

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

Access file

To: "'ctpp-news@chrispy.net'" <ctpp-news@chrispy.net>

Message-ID:

<10944FCCFB81634396900F888219A937012DE50B387F@is-exchange.rico.local>

Content-Type: text/plain; charset="us-ascii"

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