In order to understand how crime or criminal elements are embedded within different communities, it may be useful to combine neighborhood crime data with ACS demographic and housing data. There are hotspots in most cities that could be objectively analyzed to reveal patterns which may be disrupted by governmental policy. That is, if the data clearly points to consistent reliable trends.
To help local governments better plan for disaster recovery for their residents, it would helpful to know which areas contained high risk/vulnerable individuals. These individuals might include the elderly, small children, disabled individuals, those who are language isolated, and those who do not have access to a vehicle. Creation of heat maps, or other visualizations of these populations can help emergency management ...more »
To help local governments better plan for disaster recovery for their residents, it would helpful to know which areas contained high risk/vulnerable individuals. These individuals might include the elderly, small children, disabled individuals, those who are language isolated, and those who do not have access to a vehicle. Creation of heat maps, or other visualizations of these populations can help emergency management offices across the country better prepare to minimize the possible loss of life and human suffering in the event of a natural or man-made hazard that can affect their community.
« less full details »
Filter local meetups by various variables within the ACS 5-year data down to the block-group (enabled by zooming into the geographic area). By mashing these two APIs (http://www.meetup.com/meetup_api/, http://www.census.gov/developers/data/) together, community builders can identify groups and leadership/influencers that exist within areas of interest. Hopefully enabling a sort of distributed knowledge management system. ...more »
Filter local meetups by various variables within the ACS 5-year data down to the block-group (enabled by zooming into the geographic area).
By mashing these two APIs (http://www.meetup.com/meetup_api/, http://www.census.gov/developers/data/) together, community builders can identify groups and leadership/influencers that exist within areas of interest. Hopefully enabling a sort of distributed knowledge management system.
In this example application, it is assumed the community builder is a proponent of ‘Asset Based Community Development’ and is seeking to find groups upon which to build to improve communities that have high rates of poverty.
I welcome any collaborators to make this rough concept better by making it your own.
« less full details »
Create an interactive map showing subgroups of Hispanic populations (Cubans, Dominicans, Guatemalans, Mexicans, Puerto Ricans, and Salvadorans) at the tract level for Los Angeles county using TAB10 and ACS 5 year data. A dot of varying size, based on the population in each tract, could be placed in the centroid on the polygon (tract) giving a visualization of the proportion of that subgroups population in the tract (e.g. ...more »
Create an interactive map showing subgroups of Hispanic populations (Cubans, Dominicans, Guatemalans, Mexicans, Puerto Ricans, and Salvadorans) at the tract level for Los Angeles county using TAB10 and ACS 5 year data. A dot of varying size, based on the population in each tract, could be placed in the centroid on the polygon (tract) giving a visualization of the proportion of that subgroups population in the tract (e.g. 1,000 Mexicans would have a bigger dot/representation than 500 Dominicans, etc in a given tract). You could also select each tract or dot and be given the breakdown of each subgroup's population. Zoom capabilities could be warranted to focus on certain areas for the end user, as well as capabilities of creating a user-friendly, cartographically correct output in pdf format.
« less full details »
I am trying to make sense of the table name convention for the ACS data. Unlike the 2010 Census SF1 document (http://www.census.gov/prod/cen2010/doc/sf1.pdf), the tables listed in the 2010 ACS SF1 document (http://www2.census.gov/acs2010_5yr/summaryfile/ACS_2006-2010_SF_Tech_Doc.pdf) don't seem to correlate to the api. For example, an attempt to query: B07010: Geographical Mobility In The Past Year By Individual ...more »
I am trying to make sense of the table name convention for the ACS data.
Unlike the 2010 Census SF1 document (http://www.census.gov/prod/cen2010/doc/sf1.pdf), the tables listed in the 2010 ACS SF1 document (http://www2.census.gov/acs2010_5yr/summaryfile/ACS_2006-2010_SF_Tech_Doc.pdf) don't seem to correlate to the api.
For example, an attempt to query:
B07010: Geographical Mobility In The Past Year By Individual Income In The Past 12 Months For Current Residence In The United States
Results in the error: 'Invalid API key or request'
In looking at api examples for the ACS endpoints, you use table names like B00001_001E, which are not listed with in the ACS sf1 documentation. As an example, B02001_00E is listed as Total Population, but according to the ACS SF1 document the table number for Total Population is B01003.
Is there logic or a mapping of the ACS SF1 table names to the required API SF1 table names?
Any help would be greatly appreciated.
------------------------------------------------------------------
EDIT:
Updating for the sake of posterity. A listing of the api field names can be found here:
Census SF1:
http://www.census.gov/developers/data/sf1.xml
ACS SF1:
http://www.census.gov/developers/data/acs_5yr_2010_var.xml
It appears that with the ACS datapoints, the table name is converted to field names to take into account Estimates and Margins of Error.
Reference the XML instead of the SF1 PDFs when accessing the API.
« less full details »
I can't seem to get more than four variables to return. When I run this query: http://api.census.gov/data/2010/acs5?key={key}&get=B08101_017E,B08101_017M,B08101_025E,B08101_025M,B08101_033E,B08101_033M,B08101_041E,B08101_041M&for=tract:*&in=state:41+county:005 I get an error like this: error: error: unknown variable 'B08101_033E,B08101_033M,B08101_041E,B08101_041M' When I run the query with only the first four variables ...more »
I can't seem to get more than four variables to return.
When I run this query:
http://api.census.gov/data/2010/acs5?key={key}&get=B08101_017E,B08101_017M,B08101_025E,B08101_025M,B08101_033E,B08101_033M,B08101_041E,B08101_041M&for=tract:*&in=state:41+county:005
I get an error like this:
error: error: unknown variable 'B08101_033E,B08101_033M,B08101_041E,B08101_041M'
When I run the query with only the first four variables (B08101_017E,B08101_017M,B08101_025E,B08101_025M) it works!
When I run the query with the LAST four variables (B08101_033E,B08101_033M,B08101_041E,B08101_041M) it works.
If I switch the order of the variables, it always errors out with the last four variables being "unknown"
Is this a known problem? I saw somewhere else on the discussion board where someone mentioned using nine variables...
Thanks! Looking forward to using the API to update our database with the new ACS data on Dec 6th!!!
« less full details »
A fun app that imports a users foursquare / facebook places, mashes them up with ACS data to give the user a demographic profile of the places they frequent. Maybe add some social factors to show wherein the socio-economic spectrum they seem to identify. Maybe turn it into a geocaching app that helps users identify other places that they might 'like'. Like a pandora of locations. The location genome project XD ...more »
A fun app that imports a users foursquare / facebook places, mashes them up with ACS data to give the user a demographic profile of the places they frequent.
Maybe add some social factors to show wherein the socio-economic spectrum they seem to identify.
Maybe turn it into a geocaching app that helps users identify other places that they might 'like'. Like a pandora of locations. The location genome project XD
« less full details »
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/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.
