This week Mary and I met to review the Schools in the Park Watershed excel sheet. From there we added columns with color and text ID. This shows the types of schools are which. We created categories that are relevant to nature or watershed research. In Google Fusion tables we were then able to change the point markers and colors to show differences among the schools of the area.
Next step will be to add the polygon layer of the watershed as well as the municipal boundary lines. There needs to be a little clean up done on the pop up boxes (URL links, taking out unnecessary data, etc.). I would like to add a legend as well to distinguish what each color means. Are the colors and markers seen in Google Fusion the only ones we can use? Are there any other ways to change the styles of these markers? Need an explanation on how the map works for the general public.
We were also wondering if there was an excel sheet of the private schools. Mary knows of some popular Environmental programs/schools that are private that would be nice to filter on the map as well.
We would like to integrate this map and its framework into the Park River Watershed website.
Shaina – Thanks for your progress memo, which I’ve forwarded to your partner organization. Here’s my comments and responses to your questions.
In assignment 6 and the one above, you’ve demonstrated your ability to create interactive maps with two layers, though you’ve had difficulty with fine-tuning and hosting these on the web, as have other students in our seminar.
Now we have better templates for 2-layer maps that display both points (such as schools) and polygons (any digitized boundary file). See sample and link to code at http://jackdougherty.github.io/FusionTable-Map-2-layers/
Also, we have a better method for hosting your code on GitHub, rather than Google Drive. See more at http://epress.trincoll.edu/dataviz/chapter/host-html-github/
Above, you asked about changing the appearance of point markers in Google Fusion Tables. There are five standard colors (red, blue, green, yellow, purple), but you can create more with these instructions: https://support.google.com/fusiontables/answer/2679986?hl=en
If you wish to display data values in your polygon map layer, you have many more colors, but writing the code to display this in the 2-layer template is still on my to-do list.
The list of public schools I provided comes from http://SmartChoices.trincoll.edu and is not intended to be a complete list for the region. If you want to add more public or private schools (aka diocesan or non-public), you can add them to the Google Fusion Table (or start a new table). But you would have to add them manually from the CT Dept of Education directory at http://www.csde.state.ct.us/public/csde/Connecticut%20State%20Department%20of%20Education4.htm?sdePNavCtr=|#45474
hope that helps
Jack