Vote up to Idea For the .NET Programmer Vote down to Idea For the .NET Programmer

Rank 54

Idea#69

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 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.

Comment

Submitted by 1 year ago

Comments (2)

  1. Moderator

    Would you find it useful for the API call to allow a value filter?

    1 year ago
    1. christian.c.borillo Idea Submitter

      For performance issues, I may ask to filter based on the minimum and maximum numeric values of the JSON result set, but that's the only area where I think filtering would be useful. For other filtering criteria, I have no need, since I'm using LINQ and LAMBDA expressions in .NET to do filtering for me. My filtering requirements may be based on one or more variables, and the combinations on which I do the filtering may vary.

      1 year ago

Vote Activity Show

Events

  1. The idea was posted
    1 year ago