pgh_output

pghydro : Output and reporting objects for PgHydro

Overview

Packages

Source

pig build pkg pghydro;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

pig install pghydro;		# install via package name, for the active PG version
pig install pgh_output;		# install by extension name, for the current active PG version

pig install pgh_output -v 18;   # install for PG 18
pig install pgh_output -v 17;   # install for PG 17
pig install pgh_output -v 16;   # install for PG 16
pig install pgh_output -v 15;   # install for PG 15
pig install pgh_output -v 14;   # install for PG 14

Create this extension with:

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.