Interactive mapping of urban tree benefits using Google Fusion Tables and API technologies

Geographic Information Systems (GIS) and web-based GIS platforms are typically used by large organizations and government agencies for the purpose of data storage, query, analysis, and spatial data mapping. Google Fusion Tables, however, provides cloud-based computing services for data management and easy user collaboration through the Google Maps interface. Fusion Tables are oriented towards smaller organizations that previously were unable to publish data online due to limitations of database knowledge, high cost of start-up, and restrictions on implementation. In this research project, we assess the functionality and limitations of Fusion Tables and associated API as a spatial data management system by programming an interactive web-based mapping platform, the CityTrees.ca Project, designed to showcase the benefits of trees growing on the campus of Ryerson University, Toronto. Specifically, Fusion Tables functionality, such as data storage and manipulation, is used to build a query interface (both attribute and spatial) that permits users of CityTrees.ca to search for and map trees by species, diameter, height, and location. We found that Fusion Tables performed well as a storage medium for our campus tree data, which could easily be explored through our creation of a JavaScript-enabled query tool. Our project provides a unique roadmap for small to medium-sized urban forestry organizations and environmental non-profits seeking to create interactive mapping applications where data privacy and advanced spatial analysis are not fundamental.