API Technical Discussions

Formatting of SF1 Table IDs?

I'm trying to look at tables from the SF1 and I've noticed they don't seem to follow a consistent format. The ACS ID consistently use tableID-underscore-variable number. For SF1 variables I was under the impression that it worked similarly, because in the examples, the query for total population (for which the table ID is 'P001') uses the ID 'P0010001' or what I thought was Table P001 plus cell ID 0001. However I'm trying ...more »

Submitted by (@samennis)

Voting

1 vote
1 up votes
0 down votes
Active

API Technical Discussions

Formatting of SF1 Table IDs?

I'm trying to look at tables from the SF1 and I've noticed they don't seem to follow a consistent format. The ACS ID consistently use tableID-underscore-variable number. For SF1 variables I was under the impression that it worked similarly, because in the examples, the query for total population (for which the table ID is 'P001') uses the ID 'P0010001' or what I thought was Table P001 plus cell ID 0001. However I'm trying ...more »

Submitted by (@samennis)

Voting

1 vote
1 up votes
0 down votes
Active

API Technical Discussions

Fields Missing from API

I can't find the following fields in the SF1 API:

 

P0020002 Total Urban Persons

P0020003 Total Rural Persons

 

Are only a subset of fields availible through this API?

Also it appears that I can only request up to 5 fields (seperated by commas) through the URL string. Is there a way to query more?

Submitted by (@rastor)

Voting

2 votes
2 up votes
0 down votes
Active

API Technical Discussions

ACS2010 sf1 table mapping

I am trying to make sense of the table name convention for the ACS data. Unlike the 2010 Census SF1 document (http://www.census.gov/prod/cen2010/doc/sf1.pdf), the tables listed in the 2010 ACS SF1 document (http://www2.census.gov/acs2010_5yr/summaryfile/ACS_2006-2010_SF_Tech_Doc.pdf) don't seem to correlate to the api. For example, an attempt to query: B07010: Geographical Mobility In The Past Year By Individual ...more »

Submitted by (@tyrauber)

Voting

2 votes
2 up votes
0 down votes
Active

API Technical Discussions

ACS2010 sf1 table mapping

I am trying to make sense of the table name convention for the ACS data. Unlike the 2010 Census SF1 document (http://www.census.gov/prod/cen2010/doc/sf1.pdf), the tables listed in the 2010 ACS SF1 document (http://www2.census.gov/acs2010_5yr/summaryfile/ACS_2006-2010_SF_Tech_Doc.pdf) don't seem to correlate to the api. For example, an attempt to query: B07010: Geographical Mobility In The Past Year By Individual ...more »

Submitted by (@tyrauber)

Voting

2 votes
2 up votes
0 down votes
Active

Census Geography

Gated Community Data

Working on our first mobile application in high-end gated communities. Anybody have any experience with simply obtaining accurate gated community numbers nationally? or locally?

Submitted by (@ecastro1)

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, H0240001 should be a stored as a big integer

In the 1990 sf1 data call, H0240001 (Spec Own-occ HUs:Agg Value) is currently returned as a regular integer. However, all the state values are the same - 2,147,483,647, which is the max value that can be stored in a regular integer, indicating that the variable should be stored as a big integer.

Submitted by (@egillingham)

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, H0240001 should be a stored as a big integer

In the 1990 sf1 data call, H0240001 (Spec Own-occ HUs:Agg Value) is currently returned as a regular integer. However, all the state values are the same - 2,147,483,647, which is the max value that can be stored in a regular integer, indicating that the variable should be stored as a big integer.

Submitted by (@egillingham)

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, missing variable Amer Ind/Esk/Aleut Males 12-13 yrs

In the first 1990 census table, there is no variable for Amer Ind/Esk/Aleut Males 12-13 yrs. In the age by race and gender group, the variables skip from P0120131 to P0120133, so presumably P0120132 is the missing age range. Using the variable in the data call results in an unknown variable error.

Submitted by (@egillingham)

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, missing variable Amer Ind/Esk/Aleut Males 12-13 yrs

In the first 1990 census table, there is no variable for Amer Ind/Esk/Aleut Males 12-13 yrs. In the age by race and gender group, the variables skip from P0120131 to P0120133, so presumably P0120132 is the missing age range. Using the variable in the data call results in an unknown variable error.

Submitted by (@egillingham)

Voting

0 votes
0 up votes
0 down votes
Active

Feature Requests

2000 County Subdivision SF1 and SF3

We are looking to pull county subdivision data for 2008-12, 2010 and 2000. Unfortunately, unlike the other two, 2000 county subdivision geography is not available for SF1 or SF3. We would love to have this data be made available through the API. http://api.census.gov/data/2000/sf1/geo.html http://api.census.gov/data/2000/sf3/geo.html Looking to have added: Summary Level:060 state-county-county subdivision Thanks, ...more »

Submitted by (@rkelly)

Voting

0 votes
0 up votes
0 down votes
Active

Feature Requests

2000 County Subdivision SF1 and SF3

We are looking to pull county subdivision data for 2008-12, 2010 and 2000. Unfortunately, unlike the other two, 2000 county subdivision geography is not available for SF1 or SF3. We would love to have this data be made available through the API. http://api.census.gov/data/2000/sf1/geo.html http://api.census.gov/data/2000/sf3/geo.html Looking to have added: Summary Level:060 state-county-county subdivision Thanks, ...more »

Submitted by (@rkelly)

Voting

0 votes
0 up votes
0 down votes
Active