API Technical Discussions

Feedback on multiple technical issues

Campaign: API Technical Discussions

Access Micro-data for Blocks

I'm working on a school project with 2010 Census data. Currently, we are getting tract-level data using codes from http://api.census.gov/data/2010/sf1/variables.json to get data. For example, to find the white 65-year old males in a county's tracts, we make the API call: http://api.census.gov/data/2010/sf1?key=[key]&get=PCT012I068,NAME&for=tract:*&in=state:08+county:059 However, when making the same call at a block ...more »

Submitted by

Voting

3 votes
3 up votes
0 down votes
Active

Campaign: API Technical Discussions

How to decode the Variables?

I am looking at the examples of Request URL examples. I am wondering if the Variables follow any structure and if so were I can learn about it. In another words, can those variables be interpreted to what data is requested? If so, is there a document that describe it? Are the letters in the front has any significance/rules, and are the following digits follow any rules? P012D007, B02001_001E, PCT012A015 etc.... ...more »

Submitted by

Voting

0 votes
0 up votes
0 down votes
Active

Campaign: 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 »

Submitted by

Voting

5 votes
7 up votes
2 down votes
Active

Campaign: 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.

Submitted by

Voting

1 vote
1 up votes
0 down votes
Active

Campaign: 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?

Submitted by

Voting

-1 votes
0 up votes
1 down votes
Active

Campaign: 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 »

Submitted by

Voting

7 votes
7 up votes
0 down votes
Active

Campaign: 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 »

Submitted by

Voting

0 votes
0 up votes
0 down votes
Active