API Developers Forum

christian.c.borillo

Member since 10 months ago

Badges

• Newbie

2 ideas posted

5 comments 2 votes

41 points View the Leaderboard

christian.c.borillo is a member of:

• API Developers Forum

Activity Stream

Ideas contributed by christian.c.borillo

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  Bugs / Problems »

  Query string errors

  I have the following query strings for the sf1_2010.xml, sf1_2000.xml, and sf1_1990.xml respectively. All query strings are the same format, just different query values: 1) http://api.census.gov/data/2010/sf1?key=a8e19a47c9c91ffa82c63c0f383ebbe8d7b3fa55&get=P0070001,NAME&for=county:*&in=state:* 2) http://api.census.gov/data/2000/sf1?key=a8e19a47c9c91ffa82c63c0f383ebbe8d7b3fa55&get=EXTCITIN,NAME&for=county:*&in=state:* ...more »

  I have the following query strings for the sf1_2010.xml, sf1_2000.xml, and sf1_1990.xml respectively. All query strings are the same format, just different query values:

  1) http://api.census.gov/data/2010/sf1?key=a8e19a47c9c91ffa82c63c0f383ebbe8d7b3fa55&get=P0070001,NAME&for=county:*&in=state:*

  2) http://api.census.gov/data/2000/sf1?key=a8e19a47c9c91ffa82c63c0f383ebbe8d7b3fa55&get=EXTCITIN,NAME&for=county:*&in=state:*

  3) http://api.census.gov/data/1990/sf1?key=a8e19a47c9c91ffa82c63c0f383ebbe8d7b3fa55&get=CONCITCC,NAME&for=county:*&in=state:*

  Query string #1 works like a charm and returns me data. Query string #2 gives me the exception "There was an error while running your query. We've logged the error and we'll correct it ASAP. Sorry for the inconvenience." Finally, for Query string #3, I got the error ""error: error: unknown variable 'NAME'"

  These query strings were copied and pasted directly into the browsers url box. Interestingly, when I removed from Query string #3 the "NAME" token, I did get a result set, but data was lacking in one of the fields. A partial sample of the result set:

  [["CONCITCC","state","county"],

  ["","1","001"],

  ["","1","003"],

  ["","1","005"],

  You will notice that the first column is blank. Is there something I'm missing?

  Thanks.

  « less full details »

  3 comments for Idea: Query string errors

  Submitted by christian.c.borillo 1 month ago

• Vote up

  Feedback Score

  2

  +2

  -0

  Vote down
  This idea is active.
  Application Showcase »

  For the .NET Programmer

  I have a web app in C# - a simple query tool - that can now serialize the JSON result set for Decennial data into XML. By joining that Xml document to the Concepts metadata from the apivariables.xml, the app allows you to query for up to 4 datasets, and put criteria based on state and county, and to specify a minimum and maximum value filter for the result set. It will display the states and counties that match your ...more »

  I have a web app in C# - a simple query tool - that can now serialize the JSON result set for Decennial data into XML. By joining that Xml document to the Concepts metadata from the apivariables.xml, the app allows you to query for up to 4 datasets, and put criteria based on state and county, and to specify a minimum and maximum value filter for the result set. It will display the states and counties that match your criteria, and the description of the Concept of the dataset, plus a record count, and the sum of the records returned. I'm still trying to figure out how to turn this application into something more practical...currently I'm thinking that if a certain population (e.g. Lumbee) reaches a certain threshold in a particular geographic area (e.g. North Carolina), the data will be somehow mashed with data from the Google API to return the closest ethnic restaurants for that population. (Hey, I was hungry when I began this application and that was the first idea that popped into my head).

  The app can be downloaded from https://github.com/nickcamporillo/Census_Api and the file is Census_API_WebApp_01_28_2013.zip

  Also, please use your API key by going to the web.config file under the node "-censusApiContext - censusApiConfig - Settings" and enter your key there in the "Value" attribute. Thanks.

  « less full details »

  2 comments for Idea: For the .NET Programmer

  Submitted by christian.c.borillo 4 months ago

Displaying all 2 Ideas