API Developers Forum Browse Popular ideas

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 »

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 »

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 »

Can I use this API to create an easy way for users on my website to get their census tract number without using a map? I simply want the users to input their residential address into text fields. Hopefully this API will spit out their 10 digit census tract number after input. I would prefer NOT to redirect applicants to a 3rd party site.

I ultimately want to use the census tract number from the API to reconcile it with... more »

This app uses the American Community Survey data to provide users with a quick overview of the demographics, social, economic, and housing statistics of the geographic area that a user is passing through. The application uses a mobile phone’s GPS to determine the user’s geographic location and displays data based on the location. The application would display facts about the community from the Community Facts pages... more »

This app provides entrepreneurs granular data to help them choose the location for a new business based on local population characteristics and existing businesses.

In its first iteration, Startup will provide results based on a limited set of location-based criteria:
• Number of related businesses per capita
• Population
• Median income

Startup asks the user to enter a zip code, and to choose a business from a list... more »

IS there any webservice or feature which will give me the city value for the passed coordinates. Currently, the FCC API returns FIPS Code for the coordinates, is there a way to send this FIPS code and get the city value back, any ideas, thoughts will be highly appreciated.

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 »

Hello,
Just wanted to let you know that I've just published an android tablet app to the Google Play Store: CensusUS at https://play.google.com/store/apps/details?id=com.clcassidy.censusus.
The app uses the Census APIs combined with Google Maps v2. By tapping on the map and the navigation menus on the tablet, users are able to select locations at all levels of geography, from the national down to the tract level, and... more »

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 »

This ended up being much longer then I intended so I posted it as a gist over here https://gist.github.com/calvinmetcalf/5721819

tl;dr:
Don't be clever, take the conventions of other popular rest APIs as a guide, it's still better then 90% of government.

The application that we made in Boston for the national day of civic hacking http://calvinmetcalf.github.io/CodeForBoston-Census/

edit:
I through together a version hosted on Openshift that allows deep linking to specific views.
http://data-otp.rhcloud.com/

'for' and 'in' are reserved words in JavasSript avoiding these words in the parameter names would probably be a good idea, same thing with 'get' which could cause confusion with the http verb.

API keys are a barrier to entry, and are somewhat pointless for web apps where anyone can view source and grab a key

the api should simply ignore any parameter it doesn't understand instead of throwing an error. For example jquery will append _=randomNumber to prevent caching of jsonp by the browser. This feature breaks that.