Tuesday, October 9, 2012

Table Created using Google Fusion Tables

Here is the link to the table: http://tinyurl.com/9qrgwcr 

Please click on the link, where you will find a data table.  Click on "Visualize" and click on "Map."

The map was created using Google Fusion Tables, which can be found while exploring "More" options on google.com.

My assignment was to create a diagram using hohli.com.

I thought about creating a Red/Blue State map for the upcoming election.  

After creating a simple pie chart on hohli (i.e. red, blue, swing states), there wasn't much else to do on hohli.  I searched on google to try to find a way to create an interactive map.

I came across this: http://tinyurl.com/8jocqdj

In it, the instructor Kathryn Hurley walks us through creating a world-wide map that highlights world-wide coffee production rates.  After following her tutorial, I could not figure out how create a state-by-state affiliation by color.  I know there's a way, because there are plenty of maps out there.  I'll save that battle for another day, for the steps required veered me off to an entirely different path from Ms. Hurley's tutorial.

Instead, I gathered information online, and found a CSV file offering information on earthquakes the past 7 days.  I took the following steps.

Install Google Drive and have a google account.

           Looked up CSV File for  Worldwide M+1 Earthquakes the past 7 days.
Found data.gov/safety: https://www.data.gov/communities/node/7861/data_tools/58511
2.     Downloaded CSV File.  Because it was a text, I converted it into a CSV file via Excel, by first importing the .txt file then saving it as a .csv file.
3.     Open docs.google.com.  Save your CSV file by clicking “Create” …”More”… “Fusion Table.” Chose your file and upload it into your Google Drive.

Once saved, you are able to click on the table.  There is the option: "Visualize" where your CSV data will integrate itself into a map.  From there, you can customize it, and even merge other data into the very same map, increasing information into whatever information you are trying to come across.


  1. To tell you the truth I had the same problems with my assign infographic software. I had a headache and I just couldn't continue on, but I believe the more you do it, the better you will become. Therefore, DON'T GIVE UP!

  2. Hi do you have a camera and audio that I can use for the interview project?

    1. I'll be on campus tomorrow. Do you want to meet up there? I'll take my camera and audio recorder.

    2. best oresentation so far even thoough theres only been two

  3. Hey Alejandro: my main thoughts are on just visually cleaning up your blog entry. It's kinda all over the map. Try to get it all in the same font, same size, etc.

    Your account is systematic and careful; I like that - even if you keep finding difficult challenges. It's good work. We don't have to be perfect to report on what we find.

    Keep it up and try to come up with a really compelling infographic. How about a chart comparing a bunch of electronic music production programs? Price? Compatible systems? Features? Potential? Main devotees/users? Samples produced by those programs? Demo showing the software in use? Reviews of other writers and sites? Samples for visitors to try their hands at the program?