Hawaii OSDS Technology Suitability Analysis

Project Wrap-Up Documentation

Author

Alemarie Ceria

Published

May 3, 2026

Objective

Build a parcel-level analysis for evaluating cesspool replacement technologies in Hawaiʻi.

Current scope

The current MPAT and technology screening outputs cover Maui, Oahu, and Kauai. Big Island, Lanai, Molokai, Niihau, and Kahoolawe are not yet included.

The Hawaii OSDS Technology Suitability Analysis Map (Pilot) web map is live for the current outputs.

Pipeline at a glance

graph LR
  A["<b>Source layers</b><br/>data/01_inputs/source/<br/><i>notebook 00</i>"]
  B["<b>Prepared layers</b><br/>data/01_inputs/prepared/<br/><i>notebook 01</i>"]
  C["<b>MPAT</b><br/>data/03_processed/mpat/<br/><i>notebook 02</i>"]
  D["<b>Parcel analysis points</b><br/>data/03_processed/<br/><i>notebook 02</i>"]
  E["<b>Technology screening</b><br/>data/03_processed/tech_screening/<br/><i>notebook 03</i>"]
  F["<b>HCPT_Matrix_v6.1.xlsx</b><br/>(editable source of truth)"]
  G["<b>YAML configs</b><br/>config/baseline/<br/><i>src/export_config.py</i>"]
  A --> B
  B --> C
  B --> D
  C --> E
  F -.-> G
  G --> E
Figure 1: Data flow from source layers through the four key endpoint notebooks. Solid arrows show data flow; the dashed arrow shows the configuration export from the editable Excel matrix to the runtime YAML files.

Key Endpoints

The analysis produced four outputs. Each has a dedicated methods page covering inputs, processing steps, outputs, and links to the relevant code and data.

1. Download Datasets

Fetches the source layers used in the analysis (parcels, hydrology, soils, building footprints, regulatory boundaries, cesspool inventory) into a staged source directory.

2. Prepare Input Data

Reprojects layers to the target CRS, mosaics rasters, and converts vector data to GeoPackage.

3. Build MPAT

Constructs the Master Parcel Attribute Table by joining the cesspool inventory with environmental and structural attributes at parcel resolution.

4. Screen Techs

Applies the suitability criteria defined in the configuration files and assigns recommended replacement technologies to each parcel.

Site map

  • Methods. Step-by-step documentation for each endpoint.
  • Results. Summary of the MPAT and the technology recommendations.
  • Resources. GitHub paths, shared-drive folders, and ArcGIS Online assets.
  • Slides. Presentation version of this material.