Piscataqua Watershed Data Explorer

The Piscataqua Watershed Data Explorer is an interactive data explorer for accessing, visualizing, and downloading water quality data in the Piscataqua River watershed. The data explorer provides direct access to the Piscataqua Region Estuaries Partnership (PREP) water quality database, which represents the most comprehensive collection of environmental data for the watersheds of coastal New Hampshire, containing the results from monitoring activities and projects carried out by multiple organizations, including the University of New Hampshire, New Hampshire Department of Environmental Services, and PREP.

In collaboration with FB Environmental, the data explorer was designed for users to quickly find and download raw water quality data as well as perform basic time-series comparisons between two or more parameters and sites.

The website is a single-page application (SPA) developed using Vue, Vuetify, Leaflet, Highcharts. Water quality data are fetched directly from a PostgreSQL database using a PostgREST API. The database, which was developed and maintained by PREP, follows the ODM2 schema for environmental data.

The web application source code is publicly available on Github at walkerjeffd/prep-data-explorer.