pgh_output

Overview

Version

Build

You can build the RPM / DEB packages for pghydro using pig build:

pig build pkg pghydro         # build RPM / DEB packages

Install

You can install pghydro directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install pghydro;          # Install for current active PG version

pig ext install -y pghydro -v 18  # PG 18
pig ext install -y pghydro -v 17  # PG 17
pig ext install -y pghydro -v 16  # PG 16
pig ext install -y pghydro -v 15  # PG 15
pig ext install -y pghydro -v 14  # PG 14

dnf install -y pghydro_18       # PG 18
dnf install -y pghydro_17       # PG 17
dnf install -y pghydro_16       # PG 16
dnf install -y pghydro_15       # PG 15
dnf install -y pghydro_14       # PG 14

apt install -y postgresql-18-pghydro   # PG 18
apt install -y postgresql-17-pghydro   # PG 17
apt install -y postgresql-16-pghydro   # PG 16
apt install -y postgresql-15-pghydro   # PG 15
apt install -y postgresql-14-pghydro   # PG 14

Create Extension:

CREATE EXTENSION pgh_output CASCADE;  -- requires: plpgsql, postgis, pghydro

Usage

Sources: PGHydro README, pgh_output SQL

pgh_output creates export tables for PgHydro drainage-network products. It materializes drainage lines, drainage areas, watercourses, drainage points, and shorelines in a schema intended for downstream reporting or GIS exchange.

Enable

CREATE EXTENSION postgis;
CREATE EXTENSION pghydro;
CREATE EXTENSION pgh_output;

Export Tables

The extension creates the pgh_output schema with tables including:

Refresh Output

SELECT pgh_output.pghfn_updateexporttables();

Run the refresh function after loading or recalculating the base PgHydro network.

Notes

Validate the PgHydro network first with consistency checks when possible. The export tables are derived products and should be regenerated after upstream drainage geometry, topology, or coding changes.