14 Aug
2012
14 Aug
'12
11:59 a.m.
So I'm once again befuddled by the way the API handles variable IDs.
I'm trying to retrieve data from table PCT20: "Group quarters population by group
quarters type" from SF1. However the SF1 does not seem to follow the same variable
formatting as the ACS 5-Year (it doesn't seem to use the _001E / _001M suffixes).
In the example queries, the table "P001: total population" is retrieved using
the ID 'P0010001'. Based on this I would've guessed that the 0001 designates
the variable within the table in the same way that _001E does. However using this same
style suffix on PCT20 results in an error.
Does anyone know how these IDs are constructed? I haven't been able to find a variable
list for SF1 that corresponds to this
one<http://www.census.gov/developers/data/2010acs5_variables.xml>ml>.
Thanks much,
Sam Ennis
14 Aug
14 Aug
12:25 p.m.
The SF1 variables are at http://www.census.gov/developers/data/sf1.xml
And I'm pretty sure those are Census 2010 variables, so there is no E's or
M's. They didn't estimate, they "counted", and because of that there is
no (or they won't tell us) the MOE.
Andrew
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Ennis, Samuel
Sent: Tuesday, August 14, 2012 1:00 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] SF1 API variable IDs
So I'm once again befuddled by the way the API handles variable IDs.
I'm trying to retrieve data from table PCT20: "Group quarters population by group
quarters type" from SF1. However the SF1 does not seem to follow the same variable
formatting as the ACS 5-Year (it doesn't seem to use the _001E / _001M suffixes).
In the example queries, the table "P001: total population" is retrieved using
the ID 'P0010001'. Based on this I would've guessed that the 0001 designates
the variable within the table in the same way that _001E does. However using this same
style suffix on PCT20 results in an error.
Does anyone know how these IDs are constructed? I haven't been able to find a variable
list for SF1 that corresponds to this
one<http://www.census.gov/developers/data/2010acs5_variables.xml>ml>.
Thanks much,
Sam Ennis
12:26 p.m.
Sam-
Decennial Census and ACS are separate programs, separate datasets.
(Decennial Census does not have "margins of error." Putatively, there is no
error ;-)
You can find a data dictionary for Census 2010 SF1 on Census's website
http://2010.census.gov/news/doc/sf1_table_matrix_section.doc
That document lists every table, every variable. And I'm pretty sure the variables,
definitions, formats in the API service conform to this data dictionary.
Hope that helps.
Good luck,
Todd Graham
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Ennis, Samuel
Sent: Tuesday, August 14, 2012 12:00 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] SF1 API variable IDs
So I'm once again befuddled by the way the API handles variable IDs.
I'm trying to retrieve data from table PCT20: "Group quarters population by group
quarters type" from SF1. However the SF1 does not seem to follow the same variable
formatting as the ACS 5-Year (it doesn't seem to use the _001E / _001M suffixes).
In the example queries, the table "P001: total population" is retrieved using
the ID 'P0010001'. Based on this I would've guessed that the 0001 designates
the variable within the table in the same way that _001E does. However using this same
style suffix on PCT20 results in an error.
Does anyone know how these IDs are constructed? I haven't been able to find a variable
list for SF1 that corresponds to this
one<http://www.census.gov/developers/data/2010acs5_variables.xml>ml>.
Thanks much,
Sam Ennis
________________________________
This email is intended to be read only by the intended recipient. This email may be
legally privileged or protected from disclosure by law. If you are not the intended
recipient, any dissemination of this email or any attachments is strictly prohibited, and
you should refrain from reading this email or examining any attachments. If you received
this email in error, please notify the sender immediately and delete this email and any
attachments.
27 Aug
27 Aug
9:51 a.m.
New subject: Income Data - Block Groups / Tracts
Good morning everyone. I need your help for a project our MPO has
recently started. We are updating the HSTP and wanted to include income
levels in our plan. We are a small MPO and so far have found that
nearly all of the income data has been suppressed for our region. This
includes both block groups and tracts in the American Community Survey
2006 -2010. I have found that numerous datasets have been suppressed.
It's frustrating that MPOs are required to use Census data, but in
smaller MPO regions the data is suppressed.
Does anyone have any suggestions or solutions?
Thanks.
Adam Aull
GIS Manager / DATS Director
City of Danville
17 W. Main St.
Danville, IL 61832
P: 217-431-2325
F: 217-431-2237
E: aaull(a)cityofdanville.org
10:26 a.m.
New subject: Income Data - Block Groups / Tracts
Adam,
I just checked, and I see what you mean. You need to know, however, that
the MOEs (margins of error, or sampling error) on individual income level
summaries -- e.g. $50,000 to $64,999 -- would be so high for individual
tracts that the data are really unusable. I recommend that you use median
income levels instead.
Patty Becker
On Mon, Aug 27, 2012 at 10:51 AM, Adam Aull <aaull(a)cityofdanville.org>wrote;wrote:
Good morning everyone. I need your help for a project
our MPO has
recently started. We are updating the HSTP and wanted to include income
levels in our plan. We are a small MPO and so far have found that nearly
all of the income data has been suppressed for our region. This includes
both block groups and tracts in the American Community Survey 2006 -2010.
I have found that numerous datasets have been suppressed. It’s frustrating
that MPOs are required to use Census data, but in smaller MPO regions the
data is suppressed.****
** **
Does anyone have any suggestions or solutions?****
** **
Thanks.****
** **
Adam Aull****
GIS Manager / DATS Director****
City of Danville****
17 W. Main St.****
Danville, IL 61832****
P: 217-431-2325****
F: 217-431-2237****
E: aaull(a)cityofdanville.org****
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
--
Patricia C. (Patty) Becker
APB Associates/Southeast Michigan Census Council (SEMCC)
28300 Franklin Rd, Southfield, MI 48034
office: 248-354-6520
home:248-355-2428
pbecker(a)umich.edu
12:13 p.m.
New subject: Income Data - Block Groups / Tracts
Adam- agreed. The ACS quite honestly fall short for the needs of even a big MPO. It's
the way of the future. Put your thinking cap on.
Nancy
Nancy Reger, AICP
Deputy Director, Transportation
MORPC
111 Liberty St. Ste. 100
Columbus, Ohio 43215
nreger(a)morpc.org
614-233-4154
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Patricia Becker
Sent: Monday, August 27, 2012 11:27 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Income Data - Block Groups / Tracts
Adam,
I just checked, and I see what you mean. You need to know, however, that the MOEs (margins
of error, or sampling error) on individual income level summaries -- e.g. $50,000 to
$64,999 -- would be so high for individual tracts that the data are really unusable. I
recommend that you use median income levels instead.
Patty Becker
On Mon, Aug 27, 2012 at 10:51 AM, Adam Aull
<aaull@cityofdanville.org<mailto:aaull@cityofdanville.org>> wrote:
Good morning everyone. I need your help for a project our MPO has recently started. We
are updating the HSTP and wanted to include income levels in our plan. We are a small MPO
and so far have found that nearly all of the income data has been suppressed for our
region. This includes both block groups and tracts in the American Community Survey 2006
-2010. I have found that numerous datasets have been suppressed. It's frustrating
that MPOs are required to use Census data, but in smaller MPO regions the data is
suppressed.
Does anyone have any suggestions or solutions?
Thanks.
Adam Aull
GIS Manager / DATS Director
City of Danville
17 W. Main St.
Danville, IL 61832
P: 217-431-2325<tel:217-431-2325>
F: 217-431-2237<tel:217-431-2237>
E: aaull@cityofdanville.org<mailto:aaull@cityofdanville.org>
_______________________________________________
ctpp-news mailing list
ctpp-news@ryoko.chrispy.net<mailto:ctpp-news@ryoko.chrispy.net>
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
--
Patricia C. (Patty) Becker
APB Associates/Southeast Michigan Census Council (SEMCC)
28300 Franklin Rd, Southfield, MI 48034
office: 248-354-6520
home:248-355-2428
pbecker@umich.edu<mailto:pbecker@umich.edu>
12:35 p.m.
New subject: Income Data - Block Groups / Tracts
The 2006-2010 CTPP includes many Tables with INCOME and they will not be suppressed. It
does not improve the quality of the data or reduce the MOE!
Tomorrow is the CTPP Oversight Board meeting and we will hear from the Census Bureau when
they REALLY expect to deliver the CTPP to AASHTO. As of today, the delivery date is May
2013.
Elaine Murakami
FHWA Office of Planning
206-220-4460 (in Seattle)
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Nancy Reger
Sent: Monday, August 27, 2012 10:14 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Income Data - Block Groups / Tracts
Adam- agreed. The ACS quite honestly fall short for the needs of even a big MPO. It's
the way of the future. Put your thinking cap on.
Nancy
Nancy Reger, AICP
Deputy Director, Transportation
MORPC
111 Liberty St. Ste. 100
Columbus, Ohio 43215
nreger@morpc.org<mailto:nreger@morpc.org>
614-233-4154
From: ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net>
[mailto:ctpp-news-bounces@chrispy.net]<mailto:[mailto:ctpp-news-bounces@chrispy.net]>
On Behalf Of Patricia Becker
Sent: Monday, August 27, 2012 11:27 AM
To: ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
Subject: Re: [CTPP] Income Data - Block Groups / Tracts
Adam,
I just checked, and I see what you mean. You need to know, however, that the MOEs (margins
of error, or sampling error) on individual income level summaries -- e.g. $50,000 to
$64,999 -- would be so high for individual tracts that the data are really unusable. I
recommend that you use median income levels instead.
Patty Becker
On Mon, Aug 27, 2012 at 10:51 AM, Adam Aull
<aaull@cityofdanville.org<mailto:aaull@cityofdanville.org>> wrote:
Good morning everyone. I need your help for a project our MPO has recently started. We
are updating the HSTP and wanted to include income levels in our plan. We are a small MPO
and so far have found that nearly all of the income data has been suppressed for our
region. This includes both block groups and tracts in the American Community Survey 2006
-2010. I have found that numerous datasets have been suppressed. It's frustrating
that MPOs are required to use Census data, but in smaller MPO regions the data is
suppressed.
Does anyone have any suggestions or solutions?
Thanks.
Adam Aull
GIS Manager / DATS Director
City of Danville
17 W. Main St.
Danville, IL 61832
P: 217-431-2325<tel:217-431-2325>
F: 217-431-2237<tel:217-431-2237>
E: aaull@cityofdanville.org<mailto:aaull@cityofdanville.org>
_______________________________________________
ctpp-news mailing list
ctpp-news@ryoko.chrispy.net<mailto:ctpp-news@ryoko.chrispy.net>
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
--
Patricia C. (Patty) Becker
APB Associates/Southeast Michigan Census Council (SEMCC)
28300 Franklin Rd, Southfield, MI 48034
office: 248-354-6520
home:248-355-2428
pbecker@umich.edu<mailto:pbecker@umich.edu>
4455
days inactive
4468
days old
6 comments
7 participants
participants (7)
-
Adam Aull -
Andrew Rohne -
Elaine.Murakami＠dot.gov -
Ennis, Samuel -
Graham, Todd -
Nancy Reger -
Patricia Becker