跳转到主要内容

pgh_output_pt_br

Brazilian Portuguese output pack for PgHydro

pghydro : Brazilian Portuguese output pack for PgHydro

Overview

ID Extension Package Version Category License Language
1605 pgh_output_pt_br pghydro 6.6 GIS GPL-2.0 SQL
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
----d-- No No No Yes no no
Relationships
Schemas pgh_output_pt_br
Requires plpgsql postgis pghydro
See Also pgrouting postgis_raster pg_render pointcloud pg_xenophile icu_ext h3
Siblings pghydro pgh_raster pgh_hgm pgh_output pgh_output_en_au pgh_consistency

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT PIGSTY 6.6 18 17 16 15 14 pghydro plpgsql, postgis, pghydro
RPM PIGSTY 6.6 18 17 16 15 14 pghydro_$v postgis36_$v
DEB PIGSTY 6.6 18 17 16 15 14 postgresql-$v-pghydro postgresql-$v-postgis-3
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
el8.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
el9.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
el9.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
el10.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
el10.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
d12.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
d12.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
d13.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
d13.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
u22.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
u22.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
u24.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
u24.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
u26.x86_64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6
u26.aarch64 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6 PIGSTY 6.6

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_pt_br;		# install by extension name, for the current active PG version

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

Create this extension with:

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

Usage

Sources: PGHydro README, pgh_output_pt_br SQL

pgh_output_pt_br provides a Brazilian-Portuguese PgHydro output schema. It creates localized export tables for drainage-network products and a refresh function that populates them from the base PgHydro model.

Enable 

CREATE EXTENSION postgis;
CREATE EXTENSION pghydro;
CREATE EXTENSION pgh_output_pt_br;

Output Tables

The extension creates the pgh_output_pt_br schema with tables including:

Table Purpose
geoft_bho_trecho_drenagem Drainage-line export table
geoft_bho_area_drenagem Drainage-area export table
geoft_bho_curso_dagua Watercourse export table
geoft_bho_ponto_drenagem Drainage-point export table
geoft_bho_linha_costa Shoreline export table

Refresh Output 

SELECT pgh_output_pt_br.pghfn_updateexporttables();

Notes

Use this extension when exported PgHydro products need Brazilian-Portuguese object names. Regenerate the output after source drainage geometry, topology, or coding changes.