What do the Colorado Farm to School Task Force and a Denver-based Community Navigator initiative have in common? Well, beyond the fact that they’re projects looking to make a big change in the world, they’re both initiatives that rely heavily on the idea of “place”. In our last blog in this series, we explored how mapping can help tell a powerful story and how GIS can help tell that story. But what do you do when you need a tool that is easy for your partners to use and apply on their own? Enter Google Fusion Tables. As the name implies, this web-based application makes it easy to merge (“fuse”) and analyze data with charts, graphs, and maps. In both projects, Fusion Tables allowed us and our partners to combine our existing information to produce actionable insights for the populations we serve.
From our experiences using Fusion Tables, we’ve found them to be…
- Versatile – effective for various tasks, including mapping and data management. Even better, it plays nice with other Google products like Google Sheets and Forms, which can be a significant benefit when working with community partners.
- Good for Collaboration – as long as your partners have a Google account, they can use or modify the data, charts, and maps.
- Relatively Easy-to-learn – if you feel comfortable navigating the internet and using basic spreadsheets, Fusion Tables are easy to use. However, administering and developing a new Fusion Table takes a bit more tech savvy.
- Limited in Comparison to Specialized Tools – while you can get a nice set of maps, Fusion Tables are much more limited than standard GIS software. Similarly, if you want better tables and charts, Excel and Tableau are the way to go.
Over the years, our partners in in the Colorado Farm-to-School Task Force have cataloged the various initiatives and projects they and their collaborators have developed. They realized that combining and geocoding could:
- Help them to address questions about how farm-to-school activities in Colorado have developed; and
- Help their local partners identify potential collaborators in their geographic area.
We needed an easy-to-use tool that would allow for quick updates to a master dataset as new data comes in, to share the resource across collaborators, and to produce maps nice enough to include on a poster presentation. Fusion Tables met these needs and – importantly – allowed us to collaborate without worrying about the problems of version control. On the down side, we were unable to include multiple layers of geographic information, a standard feature of most GIS software; however, we were able to come up with a work-around solution. In the end, the maps we produced using Fusion Tables uncovered patterns about how farm-to-school activities relate to other food systems activities in Colorado. With this information, our partners can see potential partnerships with other food systems actors and identify which regions are most in need of their attention.
Using Fusion Tables for our work with the Denver Foundation’s Basic Human Needs Project was driven by the need for a database system that could be updated and used by a large number of individual community navigators. Community navigation, which connects low-income people to local resources through a resident navigator, can be improved when navigators share information about local service providers. The challenge is that this information is constantly changing. As part of the initiative, the navigators initially assembled a list of all the providers they use, but they lacked a mechanism for keeping the information up-to-date.
Unlike some other tools we explored, navigators can update information in the shared Fusion Tables database in real-time. They go even go beyond basic content information to adding columns for a rating scheme or updates about upcoming events. Moreover, the map option improved on the original shared Excel spreadsheet, allowing navigators to sort by different types of service providers in different locations and print either a table view or a notecard view of their sorted list.
We also learned that some collaborators can easily embrace the Fusion Table approach, but others struggle with committing the time needed to maintain the data and make the tool worthwhile to all.. If collaboration is essential to your effort, as it was in ensuring community navigators have access to up-to-date information about local service providers, it is important to have a conversation with your partners’ about their willingness to learn this new software.
Want to Learn More?
There are many resources on the web for learning how to use fusion tables. A good place to start is Google’s official site. Searching the web, you’ll find that other people have used Fusion Tables for a variety of tasks, including to tell causal stories (e.g., the Guardian’s analysis of the role of poverty in sparking riots in England), to produce information-rich interactive maps (such as The Nature Conservancy’s maps), and to incorporate publicly available data into their project (like the The Montreal Gazette’s depiction of population density in Montreal metro area).