pgh_output_en_au

pghydro : Australian English output pack 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_en_au;		# install by extension name, for the current active PG version

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

Create this extension with:

CREATE EXTENSION pgh_output_en_au CASCADE; -- requires plpgsql, postgis, pghydro

Usage

Sources: PGHydro README, pgh_output_en_au SQL

pgh_output_en_au provides an Australian-English PgHydro output schema. It creates localized export tables for drainage lines, drainage areas, and drainage points, plus a refresh function that populates them from the base PgHydro network.

Enable

CREATE EXTENSION postgis;
CREATE EXTENSION pghydro;
CREATE EXTENSION pgh_output_en_au;

Output Tables

The extension creates the pgh_output_en_au schema with tables including:

Refresh Output

SELECT pgh_output_en_au.pghfn_updateexporttables();

Run the refresh after recalculating or editing the source PgHydro objects.

Notes

Use this extension when the exported schema should expose Australian-English naming conventions while still being derived from the PgHydro drainage network.