Tell us if you have an app that uses a Census API
http://grahamimac.com/pointcontext/
Paste any point data into Point Context, and it presents a heatmap and provides basic Census data on the average neighborhood for your points.
I originally tried to use the API but found that for larger datasets I had to make way too many API calls to get all the tract data I needed. So I downloaded and stored the Census data in my own database.
The application that we made in Boston for the national day of civic hacking http://calvinmetcalf.github.io/CodeForBoston-Census/
edit:
I through together a version hosted on Openshift that allows deep linking to specific views.
I am working on analyzing CFPB Consumer Complaint database with help from census data to better understand what type of financial products consumers are having trouble with. Census data helps break down what type of consumers are having what type of issues.
We at the PaSDC are using the Census API to populate digital dashboards we are developing. We are developing topic driven boards - we have Income and Education at this point. With the API we will be able to develop more quickly. Check our site: http://pasdc.hbg.psu.edu/Data/PaSDCDashboards/tabid/2049/Default.aspx
Working with the Puget Sound Regional Council, I've modified my acs package for R to allow users to download data directly from the Census ACS API. See http://eglenn.scripts.mit.edu/citystate/2013/02/major-improvements-to-acs-r-sneak-peak-at-version-1-0/ for more info and user guide. Features and improvements include: * The package is now capable of downloading data directly from the new Census American Community ...more »
Working with the Puget Sound Regional Council, I've modified my acs package for R to allow users to download data directly from the Census ACS API. See http://eglenn.scripts.mit.edu/citystate/2013/02/major-improvements-to-acs-r-sneak-peak-at-version-1-0/ for more info and user guide.
Features and improvements include:
* The package is now capable of downloading data directly from the new Census American Community Survey API and importing into R (with proper statistical treatment of estimates and error, variable and geographic relabeling, and more), all through a single “acs.fetch()” function;
* The package includes a new “geo.make()” function to allow users to create their own custom geographies for organize and download data; and
* The package provides two special “lookup” tools to help filter through all the existing Census geographies (with the “geo.lookup()” function) and tables (with the “acs.lookup()” function) to find exactly what they want. These functions return new R “lookup” objects which can be saved, manipulated, and passed to acs.fetch() for downloading data.
(Still beta, but getting close -- any help/testing appreciated.)
« less full details »
Hey All,
just wanted show off my usage of the Census API.. I am using the census data to show off surrounding block census data around each address on real estate listings. Pretty cool. Thanks for Census Developer API for doing such a great job to make this possible. Check it out:
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 »
Earlier I mentioned the idea for a library that would take care of filling DOM elements with data. Yesterday I created a github repository for this and committed the beginnings of such a library. To see this library in action I created a couple of examples: http://pad.human.cornell.edu/Unlisted/ACS5API/Example.html This is a table with on the left an explanation of how the right cell is defined. http://pad.human.cornell.edu/Unlisted/ACS5API/Example1.html ...more »
Earlier I mentioned the idea for a library that would take care of filling DOM elements with data. Yesterday I created a github repository for this and committed the beginnings of such a library.
To see this library in action I created a couple of examples:
http://pad.human.cornell.edu/Unlisted/ACS5API/Example.html
This is a table with on the left an explanation of how the right cell is defined.
http://pad.human.cornell.edu/Unlisted/ACS5API/Example1.html
http://pad.human.cornell.edu/Unlisted/ACS5API/Example2.html
are essentially the same page, but differ in the definition of the default geography. I hope that that kind of shows one of the powers of having such a library available.
I had to learn some new skills and do not know much about github, but I would like to hear your comments and maybe interest in collaborating in further development.
The github repository is at: https://github.com/jkv3/ACS5API
« less full details »
Please continue to share how you're using the API.
http://desertbiz.biz/censussample.html
Uses JQPlot plugins. The hardest part was translating array elements. Wish list: remove the word "county" from the table cells...
By the way, I am still serious about applying for the telecommute job for the Census Bureau. When will the hiring manager be able to sift through the applications? : )
This is just something I wanted to be able to visualize for my own entertainment/enlightenment... but I think it turned out pretty well. Still working on showing the time series of contributions in a given ZIP.
http://acsmapper.appspot.com/D3 Given the dearth of other live examples, I felt like I should post something, though I haven't been able to do a lot of necessary cleanup and polish. It was nice to be able to pull something like this together with just a few hours of work via the Census API, though. For a given ACS sub-table (anything with an _002E or higher suffix), I'm calling the data for all US counties and dividing ...more »
http://acsmapper.appspot.com/D3
Given the dearth of other live examples, I felt like I should post something, though I haven't been able to do a lot of necessary cleanup and polish. It was nice to be able to pull something like this together with just a few hours of work via the Census API, though.
For a given ACS sub-table (anything with an _002E or higher suffix), I'm calling the data for all US counties and dividing those numbers into the applicable total (the _001E figures) for that topic. Which isn't a valid calculation for some of these tables, some some choices crash it entirely — and that's the cleanup I haven't done yet.
But it's still interesting to be able to page through all of this detailed data and spot the biggest concentrations of, say, people who bike to work (http://acsmapper.appspot.com/D3?acs_table=B08006_014E).
I'm really excited about the API, and interested to see what people do with it now that it's opened up.
« less full details »
http://pad.human.cornell.edu/Unlisted/api_json.html Please take a look at the source. What I tried to do is creating a web page using empty DOM elements and fill them later with Javascript and API calls. The Javascript loops through all elements with class='acs5' and I use the HTML5 data-* custom tags to define what value I would like to see in that element. The browser might throw a warning because I violate same-origin ...more »
http://pad.human.cornell.edu/Unlisted/api_json.html
Please take a look at the source.
What I tried to do is creating a web page using empty DOM elements and fill them later with Javascript and API calls. The Javascript loops through all elements with class='acs5' and I use the HTML5 data-* custom tags to define what value I would like to see in that element. The browser might throw a warning because I violate same-origin security check. I don't have a lot of experience with callback function and was not able to implement something similar with JSONP.
« less full details »
http://pad.human.cornell.edu/Unlisted/uncertaintymap_fullinfo_api_B17001.cfm
I had already created a thematic map application that gave information about the uncertainty surrounding ACS estimates (move your mouse over the counties). This website generates the map using API data requests. A future expansion will include parsing the variables XML file.
