Groundwater & IDDE Data Management, City of Bainbridge Island

To support long term growth planning and development of the island, the City of Bainbridge Island (COBI) needed to collect physical and groundwater data for a groundwater model that would set the stage for urban planning efforts. COBI also required improved tracking of Illicit Discharge and Detection (IDDE) to meet a tight grant-funding deadline and be in compliance with its Phase II National Pollution Discharge and Elimination System (NPDES) permit.
To meet data collection and management goals for the groundwater model, Aspect developed a custom database to collect field and electronic data in a single repository that allows holistic review, analysis, and reporting. COBI completed the hand off of all the required data to US Geological Survey for their modeling pursuits, as well as setting a new bar in reporting to citizens. To meet COBI’s NPDES requirements and the grant funding deadline, Aspect developed a custom database to track all of their cases digitally, allowing the city to quickly and accurately calculate the annual statistics required for government reporting.  COBI met the funding deadline now has the tools necessary to report on the cost, effort, quantity, and types of Illicit Discharges that occur on the island at any time.

Data Management and Mapping for Port of Bellingham GP West Site RI/FS

Aspect is conducting a RI/FS and planning for interim actions to support probable mixed-use redevelopment of the key property (GP West site) in the Port of Bellingham’s revitalized Waterfront District.  As a critical part of the work at this complex site, Aspect has developed and is currently maintaining custom environmental chemistry and GIS databases for the ongoing soil and groundwater data collection effort. Aside from storing, QA/QC-ing, analyzing and reporting data as part of the study, Aspect compiled and loaded vast amounts of historic data into the database from previous environmental work at the site. Aspect has developed these database tools and innovative, dynamic GIS figures to leverage complex query outputs into easy-to-use and readily-updatable map products. This project involves interfacing with labs, data validators, surveyors, field staff, regulators, and project managers to ensure that the demanding project data needs and reporting requirements are managed smoothly and efficiently.

Port of Seattle Stormwater Services

Aspect has assisted the Port of Seattle in complying with mapping, SWPPP, O&M, best management practices, and records-keeping requirements of their Phase I Municipal NPDES Permit.

Our work has included the following:

  • Developing and maintaining a geodatabase mapping the stormwater conveyance system for all Seaport facilities. Coordinated initial mapping of stormwater system. Updated GIS system as new information is learned or system is modified by construction.
  • Coordinating development of a web mapping application to share stormwater mapping data within the Port.
  • Custom database application development to track Port leases to determine relevance to stormwater management.
  • Planning and design of a temporary stormwater collection and treatment system.
  • Participating in development of Operation and Maintenance Manual for stormwater system. Updated O&M manual to include new City of Seattle requirements in 2010.
  • Developing and maintaining a stormwater records keeping data base.
  • Developing SWPPPs for all Seaport operated facilities. Developed SWPPP template for use by Port tenants. Assisted a few port tenants in completing SWPPP template.
  • Overhauling recreational and commercial vessel BMPs.
  • Managed laboratory and field water quality monitoring data and submitted final data to Ecology’s database EIM.
  • Conducting a planning exercise for Industrial Stormwater General Permit.
  • Assisting with outfall inspections.

Environmental Database/Web Map Integration

Aspect provided technical assistance to the Port of Seattle’s Aviation Environmental Department with the integration of two mission-critical databases into the Port’s GeoCortex web-mapping application. Aspect worked with Port Project Managers and Data Managers to develop automatically-updated, concise snapshots of environmental chemistry data that can be viewed and queried in the web map user interface. Aspect also integrated site-level narrative information to produce beautifully-formatted, easy-to-use PDF site summary reports with clickable, hyperlinked bibliographies that are immediately available to web map users. The map interface provides the Aviation Environmental department with the ability to easily explore huge amounts of current and historic environmental site information, vastly improving the access to these valuable databases.