Follow :
Google maps and Google fusion tables resources are phenomenal.  You can create maps with statistical analysis as well as with pin pointed address based identification with images.  Somewhat similar tool is Microsoft PowerBI and PowerMap tools. But it requires the latest Office product. You are authorized to get Office365 free due to your studentship with Northwestern University.  Go to  and sign in using the right upper corner pull down menu.  Choose Work/Schoo/University option.  It will allow you to download the full suite of Office365 that includes Excel.  PowerBI is an add on. However, this assignment is a showcase using Google maps and Google Fusion tables.

The R language has a long way to catch up with these tools for its ease and the diversity and the pin-pointed levels of detailed works you can accomplish with latest shape files. So, let us go with Google maps.

The assignment is about usage of county level maps, not more detailed than that.

Step1:  Identify counties with unemployment rate more than 10%, based on the latest numbers released by Bureau of Labor Statistics for December 2015. (50 points)

The following map is an example of counties with unemployment rate more than 10%. Some parts of Kentucky, Mississippi, California seem to be worst hit, according to the latest, DEC15, unemployment rates by counties.  The merged table and the associated map that I created, looks like the one in my blog:

The key learning site you need for your assignment is to use:  However, attending the special Thursday Sync session (18FEB16) would make this an easier piece to follow.

Download the BLS unemployment rates for December 2015 using the link, Download the text file, load it as "|" delimited file into Excel and remove all the other months and save only the DEC-15(P) data to create it as a Fusion table in your google account.  

Download the county level shape files from my directory,

Merge both these accounts using the merge details given here, with in your google account. Details of merge processes are given here: .  This link also has details on how to create the map in minutes.

Step2: Create a choropleth map(the second map in my link) using the "change feature styles"  on the left navigation panel using all the data, with out any filter (50 points)

Submit the these two sharable link as a one page submission, along with the top page with title page.



09/20/2016 10:34am

Google maps and Google fusion tables resources help for adding new maps using such tricks and the information is all time authentic because now it is big need to for every person to add their location using the google maps maker and your article is the best option for learning about it.

02/02/2017 8:26pm

I am currently looking for some article that will help me more with google maps. Luckily I found this. The information you've provided is very helpful. It's easy to follow. Now, after mastering the steps you gave I'll definitely share this to my friends to let them know how to create google maps. Thank you also for providing some source for us to understand more. This is a big help.

12/30/2016 11:24pm

Just stumbled across your blog and was instantly amazed with all the useful information that is on it. Great post, just what I was looking for and I am looking forward to reading your other posts soon!

01/03/2017 8:23pm

Advantageously, the article is really the best on this notable topic. I harmonize with your conclusions and will thirstily look forward to your approaching updates.

01/07/2017 8:11am

Pretty cool post. It’s really very nice and useful post. Thanks for sharing this with us! It’s my first visit.

01/10/2017 6:57am

The first time I came here, less than 10 seconds the display is perfectly open, and the loading is completed less than 20 seconds and to open the article only took about 7 seconds. So I think this is very fast! Incredible! Trying to maintain!

02/23/2017 2:43am

Google map is the most common application most of the internet users use in their daily life. It help you finding the right location without any confusion or errors. Thanks for your help to create maps with statistical analysis as well as with pin pointed address based identification with images.

This example shows as an optimized way to build your own cites trough the google maps. Well prepared info!

Comments are closed.