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=P… Yields a few results. However, using: http://thedataweb.rm.census.gov/data/2010/sf1?key={YOUR_KEY_HERE}&get=P… Yields 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=P… 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 Rohne OKI Regional Council www.oki.org From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Krishnan Viswanathan Sent: Friday, July 13, 2012 5:56 PM To: ctpp-news(a)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<mailto: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<mailto: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<tel:708-283-3534> (V) 708-574-8131<tel: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<mailto:ctpp-news@ryoko.chrispy.net> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311