BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2024//speaker//VUUG7N
BEGIN:VTIMEZONE
TZID:-03
BEGIN:STANDARD
DTSTART:20000101T000000
RRULE:FREQ=YEARLY;BYMONTH=1
TZNAME:-03
TZOFFSETFROM:-0300
TZOFFSETTO:-0300
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-foss4g-2024-7KQX7F@talks.staging.osgeo.org
DTSTART;TZID=-03:20241204T154500
DTEND;TZID=-03:20241204T161500
DESCRIPTION:The PostgreSQL extension for Hydrographic Applications Project 
 (PgHydro) represents the first innovation of intelligence as an extension 
 of spatial database management systems for use in water resources manageme
 nt that uses the sub-catchment network model and the logic elements presen
 t in the Pfafstetter basin coding system. PgHydro aims for an add-on imple
 mentation of a spatial database management system performed by a series of
  tables\, queries\, functions\, or views that can be used individually to 
 assist in water resources decision-making. These objects are the hydrograp
 hy core of the intelligence system developed using free open-source softwa
 re that can be used by anyone dealing with water resources management. To 
 this end\, this new conceptual model was implemented in the object-relatio
 nal spatial database management system PostgreSQL/PostGIS\, respecting the
  integrity constraints related to the geometry of the mapped objects. Thes
 e user-defined constraints respect the logical objects based on the Pfafst
 etter basin coding system and integrity constraints linked to the spatial 
 relationships between objects\, which follow the ISO SQL/MM specifications
 . The main advantage of using the pghydro extension is the possibility to 
 process large datasets and complex queries using a simpler hydrography mod
 el and the tools and languages already available in spatial database manag
 ement systems that work as a framework for the future development of new e
 xtensions related to water resources.\nThe pghydro functionalities can be 
 run using a GUI developed in a QGIS plugin called PgHydro Tools. After the
  physical implementation of the pgHydro Scheme in the spatial database man
 agement system\, the construction of the Pfafsteter hydrography dataset is
  started using the hydrography objects that make up the pgHydro Tools. The
  construction of this base is divided into seven stages: 1) Creation of th
 e spatial database and creation of the pghydro extension\; 2) insertion of
  the drainage lines and the drainage areas in the spatial database\; 3) ve
 rification of the consistency of the drainage network geometries and topol
 ogies\; 4) verification of the consistency of the drainage areas geometrie
 s and topologies\; 5) verification of the consistency of topology between 
 the drainage network and the drainage areas\; 6) Pfafstetter basin coding 
 and other information\, finally\; 7) export of the final Pfafstetter hydro
 graphy dataset. Optional steps are the systematization of river names and 
 the management of the multiuser edition.\nLast year\, the pgh_raster was d
 eveloped\, which allows the insertion of the digital elevation model and p
 roducts derived from it\, such as drainage direction and flow accumulation
 . Functions allow retrieving the downstream or upstream pixel given a posi
 tion as well as the elevation profile along a given specific geometry.\nAn
 other extension developed for pghydro was the pgh_hgm\, a hydrogeomorphome
 tric extension used to calculate information such as minimum and maximum e
 levation\, slope\, concentration time\, time travel\, and others related t
 o drainage geometry and digital elevation. The pghydro project is official
 ly and widely used by the National Water and Sanitation Agency of Brazil a
 s a reference for the Brazilian Water Resources Management.
DTSTAMP:20260516T141048Z
LOCATION:Room V
SUMMARY:State of PgHydro - Hydrographic Extension for PostgreSQL/PostGIS - 
 Alexandre de Amorim Teixeira
URL:https://talks.staging.osgeo.org/foss4g-2024/talk/7KQX7F/
END:VEVENT
END:VCALENDAR