East Coast Greenway Route Planning System

Planned Route Map
Client:   East Coast Greenway

in 2017, we helped the East Coast Greenway create a major new interactive map and shared editing system, supported by a generous in-kind grant from CARTO.com. In 2018, we built on that foundation to support the Greenway staff's major efforts at planning the future of the 3,000+ mile-long nonmotorized path from Maine to Florida. To manage the routing, designation, project planning, fundraising, construction, and completion of a continent-scale trail is no small task.

 The East Coast Greenway is always two things: A current route shown on public maps and supported with events and outings and other interpretation, and an envisioned route, which is an ever-changing mix of potential rights of way, routes under negotiation, active construction projects, and completed work. Before we built this system, Greenway staff manually updated an extensive spreadsheet with the status of each segment of their trail, but the segments were identified only by name, with mileages attached but without a rigorous spatial data connection. As a result, tabular reporting was often out of sync with their map data, and it was a tedious process of using consumer routing services like Google Maps to try to calculate distances to include in their tracking table.

Because East Coast Greenway staff were already managing the public route in CARTO.com, it made sense for them to do the same with their envisioned route. This is a rare web project where we wrote virtually no custom code, outside of some database queries. We took advantage of CARTO's excellent data APIs combined with a set of Google Sheets to power a live-updated spatial and tabular dashboard that's always up to date with the Greenway's current GIS information.

The result is an extensive and powerful Google Sheets dashboard with national and state-by-state views, updated every few minutes from the source data on CARTO.com. We also have a simple web map made using CARTO's built-in map tools, and an automated system to make monthly snapshots of the envisioned route data, which feed into a variant dashboard where program staff can look at past snapshots to record change over time and share results with stakeholders, funders, and the larger Greenway community.

Focus:   Recreation  

Services:  Interactive Solutions, GIS Services, Data, Training and Support, Web Mapping 

Project Years: 2018

GreenInfo Network creates, analyzes, visualizes and communicates information in the public interest. We specialize in mapping and related technology for nonprofits and public agencies, focusing on using it for conservation, social equity, public health, environment and foundation grant making.
2201 Broadway, Suite M5
Oakland
CA
94612
United States of America