(@rkosara)

API Technical Discussions

Response format is unusual and hard to use

First, let me applaud the Census Bureau for doing this, it's an awesome project. I'm glad to see JSON as the response format for the API, but structure makes it really hard to use. I also haven't seen this list-of-lists format for individual records before. What would work much better would be one of the following: a) an array of objects. Within each object, each field name is a key, each value is the value associated ...more »

Voting

5 votes
7 up votes
2 down votes
Active
(@janvink)

Feature Requests

Skip a level in the geographic hierarchy and add GEOID

I am trying to make something for all block groups in a county and noticed that I have to make separate requests for each tract. A block group looks like: ?get=P0010001&for=block+group:*&in=state:2+county:170+tract:000101 but it would be nice if we could request: ?get=P0010001,GEOID&for=block+group:*&in=state:2+county:170 so without specifying the tract. The added GEOID (just like NAME) would make make each record unique. ...more »

Voting

15 votes
15 up votes
0 down votes
Active
(@phillipthomas)

Using Data

API Query Dissection

A dissection of the API query string for the Census API I have posted this in another topic, however it is hard to find. Host name, API sub-folder (this triggers our api to parse the following data). http://api.census.gov/data/ This portion refers to the DataSet/Instance pair (without both, it's difficult to determine what number you want back) 2010/sf1? This determines what variables to retrieve (required, ...more »

Voting

2 votes
2 up votes
0 down votes
Active
(@jporter)

Bugs / Problems

invalid json

For this particular api query to acs5 I receive invalid json. I confirmed this with jslint. I suspect one of the fields aren't escaping properly or something. http://api.census.gov/data/2012/acs5/profile?get=DP04_0088E,DP02_0100E,DP02_0104E,DP02_0105E,DP02_0106E,DP02_0107E,DP02_0108E,DP02_0109E,DP02_0111E,DP02_0112E,DP02_0113E,DP03_0019E,DP03_0020E,DP03_0021E,DP03_0022E,DP03_0023E,DP03_0024E,DP03_0025E,DP02_0090E,DP03_0004E,DP03_0005E,DP03_0006E&for=place:*&in=state:*&key={key} ...more »

Voting

1 vote
1 up votes
0 down votes
Active
(@buckles976)

API Technical Discussions

Median household income by Census Block or Census Block Group

I need so assistance in creating an API to pull Median Household Income based on a specific address or if that creates a geocoding problem, i have Lat/long coordinates already. My response from the call should be able to provide me with a dollar amount or a percent over national median household income. The result will be used in an equation. I have a key already.

Voting

1 vote
1 up votes
0 down votes
Active
(@percyd)

API Technical Discussions

is there a speed limit?

I wrote a python script to download all the census tract data for four different counties, parse it and save it as csv to upload to our database.

 

it works great! except that sometimes only the first and fourth queries return data.

 

Is there limit on how fast we can fire off queries to the API?

Voting

-1 votes
0 up votes
1 down votes
Active
(@david.john.maccormack)

API Technical Discussions

Maximum number of variables per request

Greetings, Though we have provided this infomation in a reply to an existing thread, we also wanted to create a "fresh" post to let everyone know that the maximum number of variables per request has been increased from 4 to 50. The documentation on www.census.gov/developers/ will be updated to reflect this information as well. Thank you to everyone who has provided feekback so far. We do take the feedback into account ...more »

Voting

7 votes
7 up votes
0 down votes
Active
(@percyd)

Bugs / Problems

more than four variables?

I can't seem to get more than four variables to return. When I run this query: http://api.census.gov/data/2010/acs5?key={key}&get=B08101_017E,B08101_017M,B08101_025E,B08101_025M,B08101_033E,B08101_033M,B08101_041E,B08101_041M&for=tract:*&in=state:41+county:005 I get an error like this: error: error: unknown variable 'B08101_033E,B08101_033M,B08101_041E,B08101_041M' When I run the query with only the first four variables ...more »

Voting

1 vote
1 up votes
0 down votes
Active
(@mail00)

Application Showcase

JQPlot and JQuery JSON chart sample (simple)

http://desertbiz.biz/censussample.html

 

Uses JQPlot plugins. The hardest part was translating array elements. Wish list: remove the word "county" from the table cells...

 

By the way, I am still serious about applying for the telecommute job for the Census Bureau. When will the hiring manager be able to sift through the applications? : )

Voting

1 vote
1 up votes
0 down votes
Active
(@alanj0)

Application Showcase

ACS Choropleth Maps

http://acsmapper.appspot.com/D3 Given the dearth of other live examples, I felt like I should post something, though I haven't been able to do a lot of necessary cleanup and polish. It was nice to be able to pull something like this together with just a few hours of work via the Census API, though. For a given ACS sub-table (anything with an _002E or higher suffix), I'm calling the data for all US counties and dividing ...more »

Voting

7 votes
7 up votes
0 down votes
Active
(@feng.gao)

Feature Requests

Variable Description APIs would be useful

As a developer, I think an API to describe and search for SF1 variables will be very useful. Sample API: http://thedataweb.rm.census.gov/data/2010/sf1/desc/(parameters) Usages: 1. http://thedataweb.rm.census.gov/data/2010/sf1/desc/all returns a JSON array of all SF1 variables and their descriptions. 2. http://thedataweb.rm.census.gov/data/2010/sf1/desc/P0010001 returns information about P0010001 (its name, concept, ...more »

Voting

11 votes
11 up votes
0 down votes
Active
(@lvanleir)

API Technical Discussions

General design and specific API questions

Hello everyone, This is a question requiring some general direction and also some technical help: I would like to automatically (daily, weekly?) upload ACS reports by county (all 3200+) into a database hosted locally. My boss wants it in MS Access (this is not up for debate, I have tried). From MS Access, we'd like to be able to extract the fields we need to populate a .xls file or any other format. Eventually, even ...more »

Voting

0 votes
0 up votes
0 down votes
Active

Application Showcase

EnergyZip.org

http://www.energyzip.org EnergyZip allows you to explore electricity usage across the five boroughs of New York City and compare your usage against predicted future use, to your neighbors and to the city. We invite you to enter your recent electricity usage and, from this data and the average seasonal modulation for US households, we predict what your electricity consumption will be for the rest of the year and how ...more »

Voting

6 votes
6 up votes
0 down votes
Active