Google Fusion tables resources are phenomenal.
Every researcher or BI developer could benefit by this powerful tool.
What fascinated me is that Google already perfected the mapping algorithms, and has the most popular richest repository of mapping assets.
One may wonder, why bother. After all the county maps, the most often used version of mapping is made into pulp by R developers.
I love R and I recommend R system, for lots of its wonderful functionality. However, I would say, R has a long way to go, to own or translate the Google map functionality.
Perhaps you may want to just see all the counties with unemployment rate below 3%, a number considered to be full employment, or just counties that exceed unemployment rate more than 10%. This is an example of counties with more than 10%. Some parts of Kentucky, Mississippi, California seem to be worst hit.
The beauty of google maps and fusion tables is that
- you are in the league of the best practices of the world and hence no worries about missing counties, old shape files, …
- you are using the full functionality of google map (zoom/real time data possibilities)
- your map works can tap into deeper levels of tiger files at all levels of census.gov data availability.
The key learning site you need to use are:
To bring together the shape files in one bundle in the right way for fusion tables to work, use the link http://www.poynter.org/2011/how-to-map-data-onto-counties-districts-using-shpescape/141788/
Have fun. It is a liberating feeling. Phew! Maps have been in my radar for a long time. Waiting to identify the one that is needed at the foundation level so that the foundation best practices permeates at all levels of functionality is all the worth.
To complete the notes, I also want to bring the following to your attention – ggmap tutorial. This is a great one, as long as you do not need the dynamic zooming facility.
Also, if you want to work with all types of census.gov shape files, it may be argued that you can do that with ggmap. I find google maps and fusion tables more standardized and easier.
The quick start (cheat sheet) ggmap guide is this two page pdf. https://www.nceas.ucsb.edu/~frazier/RSpatialGuides/ggmap/ggmapCheatsheet.pdf
Here is another blogger who uses ggmap with well articulated application.
More country level maps: https://www.students.ncl.ac.uk/keith.newman/r/maps-in-r#countries