{"id":980,"date":"2014-03-14T23:42:59","date_gmt":"2014-03-15T03:42:59","guid":{"rendered":"http:\/\/commons.trincoll.edu\/dataviz\/?p=980"},"modified":"2014-03-14T23:42:59","modified_gmt":"2014-03-15T03:42:59","slug":"assignment-7","status":"publish","type":"post","link":"http:\/\/commons.trincoll.edu\/dataviz\/2014\/03\/14\/assignment-7\/","title":{"rendered":"Assignment 7"},"content":{"rendered":"<p>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.<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>We would like to integrate this map and its framework into the Park River Watershed website.<\/p>\n<p>&nbsp;<br \/>\n\n<!-- iframe plugin v.4.5 wordpress.org\/plugins\/iframe\/ -->\n<iframe width=\"600\" height=\"400\" scrolling=\"no\" frameborder=\"no\" src=\"https:\/\/www.google.com\/fusiontables\/embedviz?q=select+col12+from+1fRkNb4QPGecjNw--_NE2EMYABshfO0oQS4aO8pEj&#038;viz=MAP&#038;h=false&#038;lat=41.762490153344565&#038;lng=-72.69670399450683&#038;t=1&#038;z=12&#038;l=col12&#038;y=2&#038;tmplt=2&#038;hml=TWO_COL_LAT_LNG\" class=\"iframe-class\"><\/iframe>\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip; <a href=\"http:\/\/commons.trincoll.edu\/dataviz\/2014\/03\/14\/assignment-7\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Assignment 7<\/span><\/a><\/p>\n","protected":false},"author":671,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23,11],"tags":[],"_links":{"self":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/980"}],"collection":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/users\/671"}],"replies":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/comments?post=980"}],"version-history":[{"count":5,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/980\/revisions"}],"predecessor-version":[{"id":1002,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/980\/revisions\/1002"}],"wp:attachment":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/media?parent=980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/categories?post=980"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/tags?post=980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}