12 May
2011
12 May
'11
2:20 p.m.
We loaded it into Access 2007 and set up SQL queries and relates to create various tables.
Relate the tables on the LOGRECNO and use the technical documentation from the census to
determine what summary leavel (SUMLEV) you need and what fields you want.
For example, for Arizona counties, a table with the basic race, ethnicity and housing
counts we related AZGeo2010 to the following tables on LOGRECNO: AZ00012010 and AZ00022010
; then used the following SQL query to create the table:
SELECT Azgeo2010.NAME, Azgeo2010.SUMLEV, Sum(Az000012010.P0010001) AS TOT_POP,
Az000012010.P0010003 AS WHITE,
FROM (Azgeo2010 INNER JOIN Az000012010 ON Azgeo2010.LOGRECNO = Az000012010.LOGRECNO) INNER
JOIN Az000022010 ON Azgeo2010.LOGRECNO = Az000022010.LOGRECNO
GROUP BY Azgeo2010.NAME, Azgeo2010.SUMLEV, Az000012010.P0010003, Az000012010.P0010004,
Az000012010.P0010005, Az000012010.P0010006, Az000012010.P0010007, Az000012010.P0010008,
Az000012010.P0010009, Az000012010.P0020005, Az000022010.P0030001, Az000022010.H0010001,
Az000022010.H0010002, Az000022010.H0010003
HAVING (((Azgeo2010.SUMLEV)='050'));
Have fun,
Jami
=============================
Jami Garrison, GISP
Socioeconomic Research Program Manager
Maricopa Association of Governments
302 N 1st Ave, Ste 300
Phoenix, AZ 85003
(602) 452-5006
jgarrison(a)azmag.gov
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Hary Prawiranata
Sent: Thursday, May 12, 2011 11:29 AM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] RE: Question on 2010 Census data and linking to the Accessfile
Please post your SAS code here for everyone, we can learn the logic and
rewrite it for other db.
Thanks,
Hary
-----Original Message-----
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
Accessfile
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@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/
<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
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news