13 Jul
2011
13 Jul
'11
11:50 a.m.
Would anyone like to volunteer to test out these directions and then
report back to the CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWi
thSummaryFile1.pdf
Sometimes when I send an email, the link gets broken. The full link
ends in "....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is
pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of
boxes) and selected "tracts" and then I selected Table H 12 and got a
comma-delimited file, which I read into excel. You have to select BOTH
the geography fields in the LEFT box as well as the table (variable)
fields in the RIGHT box. If you forget to select the geography fields,
you will get the table variables without any corresponding geography,
which is not very useful. Ask me how I know. J
Finally, I thought that when the Census released the Summary File 1
files on the ftp site that it meant the data would also be in AFF2, but
apparently this is not true. There are "quick tables" in AFF2, and
these may satisfy your needs, but it is not the full set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
13 Jul
13 Jul
5:33 p.m.
More frustration with AFF2! So, the answer is ALL the Summary File 1
tables ARE available in AFF2. The mistake I made in my earlier email
was that I clicked on "Summary File 1" in the text box with the
magnifying glass in the center of the page, and that choice ONLY gave me
the Quick Tables.
To get to ALL the Summary File 1 tables, select TOPICS in the blue box
on the left side of the page, then go to "+ Datasets" still on the LEFT
side of the page, and then select "Summary File 1" and you will have 5
pages to find the specific table you are looking for. (Only some
states have been released so far)
Thank you to Linda Clark at the Seattle Regional Office of the Census
Bureau for helping me!
Elaine
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, July 13, 2011 9:51 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access
Would anyone like to volunteer to test out these directions and then
report back to the CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWi
thSummaryFile1.pdf
Sometimes when I send an email, the link gets broken. The full link
ends in "....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is
pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of
boxes) and selected "tracts" and then I selected Table H 12 and got a
comma-delimited file, which I read into excel. You have to select BOTH
the geography fields in the LEFT box as well as the table (variable)
fields in the RIGHT box. If you forget to select the geography fields,
you will get the table variables without any corresponding geography,
which is not very useful. Ask me how I know. J
Finally, I thought that when the Census released the Summary File 1
files on the ftp site that it meant the data would also be in AFF2, but
apparently this is not true. There are "quick tables" in AFF2, and
these may satisfy your needs, but it is not the full set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
14 Jul
14 Jul
11:29 a.m.
Hi I did the MS ACCESS Directions and it worked and was easy.
I did the HI example (except I chose a different table than the example) and I guess with
interruptions it still was fairly brief; e.g. less than half hour.
Judy Clark
Modeling and Forecasting Manager
City of Bellevue
(425) 452-7858
www.bellevuewa.gov<http://www.bellevuewa.gov>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, July 13, 2011 9:51 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access
Would anyone like to volunteer to test out these directions and then report back to the
CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWithS…
Sometimes when I send an email, the link gets broken. The full link ends in
"....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of boxes) and selected
"tracts" and then I selected Table H 12 and got a comma-delimited file, which I
read into excel. You have to select BOTH the geography fields in the LEFT box as well as
the table (variable) fields in the RIGHT box. If you forget to select the geography
fields, you will get the table variables without any corresponding geography, which is
not very useful. Ask me how I know. :)
Finally, I thought that when the Census released the Summary File 1 files on the ftp site
that it meant the data would also be in AFF2, but apparently this is not true. There are
"quick tables" in AFF2, and these may satisfy your needs, but it is not the full
set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
12:46 p.m.
Hi, Elaine
I was using the Census 2010 SF1 ftp instruction that you provided below to get total
population for the NC at block group level. The instructions are well documented and very
clear. It took me about one hour to follow each step and get data I want. (I skipped Step
F though)
But you probably need basic Access knowledge to better understand procedures. And one
improvement I could thought of is to give some examples for audience practicing and users
will know better what they are actually doing.
Liang Long
Federal Highway Administration
Room 74-440
1200 New Jersey, SE
Washington, DC 20590
tel 202 366 6971
fax 202 493 2198
e-mail liang.long(a)dot.gov <mailto:liang.long@dot.gov>
________________________________
From: ctpp-news-bounces(a)chrispy.net on behalf of Elaine.Murakami(a)dot.gov
Sent: Wed 7/13/2011 12:50 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access
Would anyone like to volunteer to test out these directions and then report back to the
CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWithS…
Sometimes when I send an email, the link gets broken. The full link ends in
"....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of boxes) and selected
"tracts" and then I selected Table H 12 and got a comma-delimited file, which I
read into excel. You have to select BOTH the geography fields in the LEFT box as well as
the table (variable) fields in the RIGHT box. If you forget to select the geography
fields, you will get the table variables without any corresponding geography, which is
not very useful. Ask me how I know. J
Finally, I thought that when the Census released the Summary File 1 files on the ftp site
that it meant the data would also be in AFF2, but apparently this is not true. There are
"quick tables" in AFF2, and these may satisfy your needs, but it is not the full
set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
2:51 p.m.
If someone has Access experience can help, I would love to know how to
delete all the HI records from three tables I imported for testing
purposes of the great Access instructions.
I need to get the data out of there before KY's comes out and I don't
use Access much.
Thanks
Linda J.
*********************************
Linda J. Johnson
C.A.R. Coordinator
www.kentucky.com/greenspot page editor
Lexington Herald-Leader
(859) 231-3338
mailto:ljohnson1@herald-leader.com <mailto:ljohnson1@herald-leader.com>
*********************************
In the interests of the environment, please do not print out this email.
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
JClark(a)bellevuewa.gov
Sent: Thursday, July 14, 2011 12:29 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] RE: Directions on importing Summary File 1 into MS
Access
Hi I did the MS ACCESS Directions and it worked and was easy.
I did the HI example (except I chose a different table than the example)
and I guess with interruptions it still was fairly brief; e.g. less than
half hour.
Judy Clark
Modeling and Forecasting Manager
City of Bellevue
(425) 452-7858
www.bellevuewa.gov <http://www.bellevuewa.gov>
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, July 13, 2011 9:51 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access
Would anyone like to volunteer to test out these directions and then
report back to the CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWi
thSummaryFile1.pdf
Sometimes when I send an email, the link gets broken. The full link
ends in "....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is
pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of
boxes) and selected "tracts" and then I selected Table H 12 and got a
comma-delimited file, which I read into excel. You have to select BOTH
the geography fields in the LEFT box as well as the table (variable)
fields in the RIGHT box. If you forget to select the geography fields,
you will get the table variables without any corresponding geography,
which is not very useful. Ask me how I know. J
Finally, I thought that when the Census released the Summary File 1
files on the ftp site that it meant the data would also be in AFF2, but
apparently this is not true. There are "quick tables" in AFF2, and
these may satisfy your needs, but it is not the full set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
3:46 p.m.
The fast and easy way, delete the Access file and download the empty shell again. :)
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Johnson, Linda - Lexington
Sent: Thursday, July 14, 2011 12:52 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] RE: Directions on importing Summary File 1 into MS Access
If someone has Access experience can help, I would love to know how to delete all the HI
records from three tables I imported for testing purposes of the great Access
instructions.
I need to get the data out of there before KY's comes out and I don't use Access
much.
Thanks
Linda J.
*********************************
Linda J. Johnson
C.A.R. Coordinator
www.kentucky.com/greenspot page editor
Lexington Herald-Leader
(859) 231-3338
mailto:ljohnson1@herald-leader.com
*********************************
In the interests of the environment, please do not print out this email.
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
JClark(a)bellevuewa.gov
Sent: Thursday, July 14, 2011 12:29 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] RE: Directions on importing Summary File 1 into MS Access
Hi I did the MS ACCESS Directions and it worked and was easy.
I did the HI example (except I chose a different table than the example) and I guess with
interruptions it still was fairly brief; e.g. less than half hour.
Judy Clark
Modeling and Forecasting Manager
City of Bellevue
(425) 452-7858
www.bellevuewa.gov<http://www.bellevuewa.gov>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, July 13, 2011 9:51 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access
Would anyone like to volunteer to test out these directions and then report back to the
CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWithS…
Sometimes when I send an email, the link gets broken. The full link ends in
"....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of boxes) and selected
"tracts" and then I selected Table H 12 and got a comma-delimited file, which I
read into excel. You have to select BOTH the geography fields in the LEFT box as well as
the table (variable) fields in the RIGHT box. If you forget to select the geography
fields, you will get the table variables without any corresponding geography, which is
not very useful. Ask me how I know. :)
Finally, I thought that when the Census released the Summary File 1 files on the ftp site
that it meant the data would also be in AFF2, but apparently this is not true. There are
"quick tables" in AFF2, and these may satisfy your needs, but it is not the full
set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
3:49 p.m.
Hi, Linda
You can right click the Query name that you created for those three testing tables and
then hit "delete". The table you created will be gone.
Liang Long
Federal Highway Administration
Room 74-440
1200 New Jersey, SE
Washington, DC 20590
tel 202 366 6971
fax 202 493 2198
e-mail liang.long(a)dot.gov <mailto:liang.long@dot.gov>
________________________________
From: ctpp-news-bounces(a)chrispy.net on behalf of Johnson, Linda - Lexington
Sent: Thu 7/14/2011 3:51 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] RE: Directions on importing Summary File 1 into MS Access
If someone has Access experience can help, I would love to know how to delete all the HI
records from three tables I imported for testing purposes of the great Access
instructions.
I need to get the data out of there before KY's comes out and I don't use Access
much.
Thanks
Linda J.
*********************************
Linda J. Johnson
C.A.R. Coordinator
www.kentucky.com/greenspot page editor
Lexington Herald-Leader
(859) 231-3338
mailto:ljohnson1@herald-leader.com <mailto:ljohnson1@herald-leader.com>
*********************************
In the interests of the environment, please do not print out this email.
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
JClark(a)bellevuewa.gov
Sent: Thursday, July 14, 2011 12:29 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] RE: Directions on importing Summary File 1 into MS Access
Hi I did the MS ACCESS Directions and it worked and was easy.
I did the HI example (except I chose a different table than the example) and I guess with
interruptions it still was fairly brief; e.g. less than half hour.
Judy Clark
Modeling and Forecasting Manager
City of Bellevue
(425) 452-7858
www.bellevuewa.gov <http://www.bellevuewa.gov/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, July 13, 2011 9:51 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access
Would anyone like to volunteer to test out these directions and then report back to the
CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWithS…
Sometimes when I send an email, the link gets broken. The full link ends in
"....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of boxes) and selected
"tracts" and then I selected Table H 12 and got a comma-delimited file, which I
read into excel. You have to select BOTH the geography fields in the LEFT box as well as
the table (variable) fields in the RIGHT box. If you forget to select the geography
fields, you will get the table variables without any corresponding geography, which is
not very useful. Ask me how I know. J
Finally, I thought that when the Census released the Summary File 1 files on the ftp site
that it meant the data would also be in AFF2, but apparently this is not true. There are
"quick tables" in AFF2, and these may satisfy your needs, but it is not the full
set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
3:54 p.m.
thanks
*********************************
Linda J. Johnson
C.A.R. Coordinator
www.kentucky.com/greenspot page editor
Lexington Herald-Leader
(859) 231-3338
mailto:ljohnson1@herald-leader.com <mailto:ljohnson1@herald-leader.com>
*********************************
In the interests of the environment, please do not print out this email.
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jami Garrison
Sent: Thursday, July 14, 2011 4:47 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] RE: Directions on importing Summary File 1 into MS
Access
The fast and easy way, delete the Access file and download the empty
shell again. J
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Johnson, Linda -
Lexington
Sent: Thursday, July 14, 2011 12:52 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] RE: Directions on importing Summary File 1 into MS
Access
If someone has Access experience can help, I would love to know how to
delete all the HI records from three tables I imported for testing
purposes of the great Access instructions.
I need to get the data out of there before KY's comes out and I don't
use Access much.
Thanks
Linda J.
*********************************
Linda J. Johnson
C.A.R. Coordinator
www.kentucky.com/greenspot page editor
Lexington Herald-Leader
(859) 231-3338
mailto:ljohnson1@herald-leader.com
*********************************
In the interests of the environment, please do not print out this email.
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
JClark(a)bellevuewa.gov
Sent: Thursday, July 14, 2011 12:29 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] RE: Directions on importing Summary File 1 into MS
Access
Hi I did the MS ACCESS Directions and it worked and was easy.
I did the HI example (except I chose a different table than the example)
and I guess with interruptions it still was fairly brief; e.g. less than
half hour.
Judy Clark
Modeling and Forecasting Manager
City of Bellevue
(425) 452-7858
www.bellevuewa.gov <http://www.bellevuewa.gov>
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, July 13, 2011 9:51 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access
Would anyone like to volunteer to test out these directions and then
report back to the CTPP listserv on how well it worked?
http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWi
thSummaryFile1.pdf
Sometimes when I send an email, the link gets broken. The full link
ends in "....pdf"
In the meantime, I am testing out the data access system at the Missouri
data extractor (Dexter/uexplore) to look at Summary File 1. It is
pretty easy, so far.
http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010
on this page, select the FIRST LINE "Datasets.html" then I selected
Colorado.
I chose counties in Denver 08031 using the FILTER (first set of
boxes) and selected "tracts" and then I selected Table H 12 and got a
comma-delimited file, which I read into excel. You have to select BOTH
the geography fields in the LEFT box as well as the table (variable)
fields in the RIGHT box. If you forget to select the geography fields,
you will get the table variables without any corresponding geography,
which is not very useful. Ask me how I know. J
Finally, I thought that when the Census released the Summary File 1
files on the ftp site that it meant the data would also be in AFF2, but
apparently this is not true. There are "quick tables" in AFF2, and
these may satisfy your needs, but it is not the full set.
Elaine Murakami
FHWA Office of Planning
206-220-4460
4669
days inactive
4670
days old
7 comments
5 participants
participants (5)
-
Elaine.Murakami＠dot.gov -
Jami Garrison -
JClark＠bellevuewa.gov -
Johnson, Linda - Lexington -
Liang.Long.CTR＠dot.gov