PgHydro extends the PostGIS/PostgreSQL geospatial database to provide drainage network analysis functionality to help on water resources decision making.
PgHydro extends the PostGIS/PostgreSQL geospatial database to provide drainage network analysis functionality, supporting decision-making in Water Resources.
The master branch has the latest minor release. (6.6)
The develop branch has the next minor release. (6.7-dev)
PgHydro extends the PostGIS/PostgreSQL geospatial database to provide drainage network analysis functionality, supporting decision-making in Water Resources.
Hydrographic objects are all tables, constrains, procedures, queries, functions or views developed in PostGIS/PostgreSQL in order to build a consistent river network and calculates the correct direction of flow vector water, Otto Pfafstetter’s basin coding system, selection of upstream/downstream stretches, distance to the the mouth of the basin, upstream calculation area, river orders, basin levels, and other information to assist in decision making in water resources.
The pgh_raster extension uses the hydrological products derived from the Digital Elevation Model.
The pgh_hgm extension utilizes the pghydro and pgh_raster extensions to calculate hydrogeomorphological features using the digital elevation model and drainage line and area geometries.
Postgresql version 9.1+
PostGIS version 3.x
PostGIS Raster
1 - Download the last pghydro stable release file Source code (zip) from the site https://github.com/pghydro/pghydro/releases
2 - Unzip, copy and paste *.sql and *.control files to \PostgreSQL\x.x\share\extension
Postgresql 9.1+
createdb mydatabase
psql mydatabase -c "CREATE EXTENSION postgis"
psql mydatabase -c "CREATE EXTENSION postgis_raster"
psql mydatabase -c "CREATE EXTENSION pghydro"
psql mydatabase -c "CREATE EXTENSION pgh_raster"
psql mydatabase -c "CREATE EXTENSION pgh_hgm"
psql mydatabase -c "CREATE EXTENSION pgh_consistency"
psql mydatabase -c "CREATE EXTENSION pgh_output"
Youtube: https://www.youtube.com/channel/UCgkCUQ-i72bBY41a1bhVWyw
IMPORTANT : the changes are made in the current project, and will be saved only if you save the project.
Previous versions 6.2 and 6.4 still works with PostgreSQL 9-11 and PostGIS 2.x.
PGHYDRO (extension for PostgreSQL/PostGIS) works better with PgQGIS PgHydroTools Plugin (https://github.com/pghydro/pghydrotools).
Alexandre de Amorim Teixeira
PgHydro is Open Source, available under the GPLv2 license and is supported by a growing community of individuals, companies and organizations with an interest in management and decision making in water resources.