(@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
(@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
(@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

Using Data

Obtaining census tract numbers

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 »

Voting

0 votes
0 up votes
0 down votes
(@jeffrey.p.mchugh)

Application Ideas

Tell Me About this Area

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 »

Voting

6 votes
6 up votes
0 down votes
(@devin.vail)

Application Ideas

Startup

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 »

Voting

17 votes
17 up votes
0 down votes

Feature Requests

City value from coordinates

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.

Voting

1 vote
1 up votes
0 down votes
(@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
(@claudia.cassidy)

Application Showcase

New Android App Census US

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 »

Voting

4 votes
4 up votes
0 down votes

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