This is pretty cool, but it seems there is a limit to pulling 5 fields at a time. I got a key and was just playing around a little, and thought I'd pull the race variables (P006) for a few counties. Using:
http://thedataweb.rm.census.gov/data/2010/sf1?key={YOUR_KEY_HERE}&get=P0060001,P0060002,P0060003,P0060004,P0060005&for=county:025,017,061,165&in=state:39Yields a few results. However, using:
http://thedataweb.rm.census.gov/data/2010/sf1?key={YOUR_KEY_HERE}&get=P0060001,P0060002,P0060003,P0060004,P0060005,P0060006&for=county:025,017,061,165&in=state:39Yields an error screen with "error: error: unknown variable 'P0060005,P0060006'"
I can do another query with: http://thedataweb.rm.census.gov/data/2010/sf1?key={YOUR_KEY_HERE}&get=P0060005,P0060006,P0060007,NAME&for=county:025,017,061,165&in=state:39 And get the last few results. This appears to be a limitation we'd have to program around (although if I am incorrect and I'm doing something incorrectly, please let me know!). Andrew RohneOKI Regional Councilwww.oki.org From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Krishnan Viswanathan
Sent: Friday, July 13, 2012 5:56 PM
To: ctpp-news@chrispy.net
Subject: Re: [CTPP] Census API watch
I have been using it and found it easier to use than AFF2. There is an XML file that shows the available tables (I have been using the 5 year ACS) and I have been doing it the dumb way - enter the required table and geog that i want in my browser address bar (along with my API key) and it spits out the table as a CSV file. I have not written any front end UI or anything, but for me knowing what table I want and at what geog, i found it far easier to use than AFF2.
Krishnan
On Fri, Jul 13, 2012 at 5:28 PM, Ed Christopher <edc@berwyned.com> wrote:
This just came out from the Census Bureau PR shop. It looks like the
API will be out in July. I know this is causing a lot of excitement in
our community and Elaine Murakami has talked about putting a webinar
together on APIs. If anyone in our community has some API experience
and would like to help with a webinar feel free to let me, or Elaine
(Elaine.Murakami@dot.gov) know.
-----------------
Census Application Programming Interface (API) — The Census Bureau is
releasing its first-ever API. This online service provides the building
blocks for developers to design online and mobile apps, such as
interactive maps, charts and databases, using a variety of Census Bureau
statistics. The API provides statistics down to the neighborhood level
(tracts and block groups) from the 2010 Census Summary File 1 and the
2006-2010 American Community Survey. With these two datasets available
in the form of an API, database editors and other developers have easier
access to a wide variety of timely, localized information, including
population totals, age, sex, race, Hispanic origin, home ownership,
education, income, employment, commuting and occupation. The API is
currently undergoing beta testing and is scheduled for public release in
July. More information about the API can be found at
<http://www.census.gov/developers/>.
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
_______________________________________________
ctpp-news mailing list
ctpp-news@ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311