Google Fusion Table- Number of Coal Plants in Each State (Searchable by State)

Posted on

I was able to use the layer wizard to allow users to look at specific states using a search bar. This will be helpful if the user wishes to look at a smaller scale of map by state, instead of the entire country comparatively. This can also be done if you were to use a disease outbreak map, similar to the one I mentioned in the last post. With an outbreak map, the layer wizard could be used to create a search bar that would allow the user to search for specific outbreaks on a map…so the creator could have multiple disease outbreaks on one map.


// >0″,
from: “1EcVjHVW1MhqOS_OgeVbldAzZxbKOt_3weRLIMcog”
map: map,
styleId: 2,
templateId: 2
function changeMap_0() {
var whereClause;
var searchString = document.getElementById(‘search-string_0’).value.replace(/’/g, “\\'”);
if (searchString != ‘–Select–‘) {
whereClause = “‘name’ = ‘” + searchString + “‘”;
query: {
select: “col2>>0”,
from: “1EcVjHVW1MhqOS_OgeVbldAzZxbKOt_3weRLIMcog”,
where: whereClause
google.maps.event.addDomListener(window, ‘load’, initialize);

// ]]>



Updated Map: Part 2

Posted on

In building on the map I created last week, I was able to use HTML code to include a legend to the map I created through the Layer Wizard. I still want to add several features, but it is definitely an improvement from the very first map I made. Eventually I would like a drop down menu so viewers can switch through the years. Right now, the map displays data from 2013, but if you click on one of the school’s, you can see the percentage of students who are proficient from 2007-2013. Switching between years would allow viewers to see how each school has progressed over time.

Assignment 5: Updates on A4 of Park Watershed Schools

Posted on

Using Google Fusion Wizard, I was able to combine the point layer of the schools and the polygon layer of the watershed together. I will have to play around with the colors of the points as well as the watershed for my final map. I would also like to be able to show the schools in the watershed alone and take out the other schools. But the map below is starting to look more to how I would like my final map to look like.

Now that I can add layers to point maps, I would like to add more to my final map. For example, it would be nice to include boundary lines of the municipalities, parks/nature centers/libraries, impaired water systems, etc. My next step is to search for other shape files with the above details in either the Trinity GIS folders or by downloading them.

Update to last week’s maps

Posted on

The maps below are an updated version of last week’s maps, using the Google Fusion Tables Layer Wizard. The maps are a combination of polygons and points, and shows the four Hartford school zones superimposed on the point map. The Layer Wizard is somewhat limiting as it does not offer an easy solution to include a legend. There is a help section that provides the html code for legends, but never having worked with coding before, I am slow to figure it out.

***Maps to come — Issue with hosting HTML on Google Drive