API Technical Discussions

Feedback on multiple technical issues
(@gary00)

API Technical Discussions

Documentation needed

I am obviously overlooking something. There must be a better way to determine a "Concept"/"Variable Name" than trudging through the xml file.

Can someone please point me in the correct direction?

Thanks

Voting

1 vote
2 up votes
1 down votes
Active
(@elizabeth.duncan)

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 »

Voting

3 votes
3 up votes
0 down votes
Active
(@eitanbarazani)

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 »

Voting

0 votes
0 up votes
0 down votes
Active
(@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
(@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
(@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

API Technical Discussions

Population by Zip

Hoping someone can point me in the right direction. I'd like to query the population for a specific zip code. I'm hoping there's a way to do this without defining the two number state code in the query. Here's what my current query looks like... http://api.census.gov/data/2010/sf1?key=[myKey]&get=P0010001&for=zip+code+tabulation+area:[myZipCode]&for=state:*"; This works perfectly when I define the Zip Code and ...more »

Voting

2 votes
2 up votes
0 down votes
Active

API Technical Discussions

wildcarding geo values

this applies to block groups, but others as well ... '+county:*+tract:*' with acs5 is not set to operate with the * wildcarding (using the above selects the first BG in each county only) but would be immensely valuable if county and tract can accept wildcarding rather than specific values. For most users, looking up a tract code is infeasible and generally not desireable (multi tracts being the norm). Thank you and ...more »

Voting

2 votes
4 up votes
2 down votes
Active
(@rkosara)

API Technical Discussions

Data dictionary should be hierarchical

The XML format for the data dictionary is a great start, but it could be a lot better. In particular, the hierarchical structure of the variables is not mapped. Let's take P012B049: African American female 85 years and over. It's extremely tedious to tease apart that this is the combination of three variables: race, sex, and age group. One of the great features of XML is its hierarchical structure, which makes it easy ...more »

Voting

10 votes
10 up votes
0 down votes
Active