Skip to content
PgHydro extends the PostGIS/PostgreSQL geospatial database to provide drainage network analysis functionality to help on water resources decision making.
PLpgSQL
Branch: master
Clone or download

Latest commit

Fetching latest commit…
Cannot retrieve the latest commit at this time.

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
sample_data
CNAME
Description.pdf
LICENSE
README.md
_config.yml
pgh_consistency--6.4.sql
pgh_consistency.control
pgh_output--6.4.sql
pgh_output.control
pghydro--6.4.sql
pghydro--6.4_README.txt
pghydro--6.4_tutorial.sql
pghydro.control

README.md

PGHYDRO - PostgreSQL/PostGIS extension for Water Resources Decision Making

PgHydro extends the PostGIS/PostgreSQL geospatial database to provide drainage network analysis functionality to support decision making in Water Resources.

STATUS

Branches

The master branch has the latest minor release. (6.4)

The develop branch has the next minor release. (6.5-dev)

INTRODUCTION

PgHydro extends the PostGIS/PostgreSQL geospatial database to provide drainage network analysis functionality to support 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.

REQUIREMENTS

Postgresql version 9.1+

PostGIS version 2.0+

INSTALLATION (v.6.4)

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 pghydro"
psql mydatabase -c "CREATE EXTENSION pgh_consistency"
psql mydatabase -c "CREATE EXTENSION pgh_output"

Tutorial (v.6.2)

Youtube: https://www.youtube.com/channel/UCgkCUQ-i72bBY41a1bhVWyw

Notes

IMPORTANT : the changes are made in the current project, and will be saved only if you save the project.

Authors

Alexandre de Amorim Teixeira

Licence

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.

You can’t perform that action at this time.