BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2024//speaker//XSHFUD
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-CBXZNQ@talks.staging.osgeo.org
DTSTART;TZID=-03:20241205T114500
DTEND;TZID=-03:20241205T121500
DESCRIPTION:In the planning and expansion of water supply schemes\, there n
 eeds to be detailed mapping and documentation of existing pipeline network
  and their assets. However this is usually not the case\, especially where
  the construction of these pipelines predates advances in mapping\, geoinf
 ormation and database where they in prior existed as drawing and engineeri
 ng plans. In order to migrate to a fully documented inventory\, digitalisa
 tion and management of a water supply network database to estimate demand 
 and supplies to plan expansion and population growth\, there needs to be a
 n inventory of existing scheme. Historically\, mapping has been done with 
 expensive mapping and survey equipment that can pose a challenge for small
  organisation’s budget\, making it difficult to have a complete mapping 
 inventory of its network.\nThis article presents a geographical informatio
 n system–based free and opensource software architecture for the mapping
  and inventory of urban water supply network. This architecture is especia
 lly useful where budget is tight and decision relating to meeting the wate
 r and sanitation-related Sustainable Development goals needs to be made. T
 he architecture consists of data management\, data collection\, data analy
 sis and project host environment tools and software.\nPostGresSQL with Pos
 tGIS was used for design and management of water supply network GIS databa
 se\, basing the creation and design of features and attributes on prior kn
 owledge of what exists on water supply networks. Features created are tran
 smission and distribution pipelines\, hydrants\, valves\, chambers\, junct
 ions\, leaks\, encroachments\, pumps\, pump stations\, reservoirs\, bulk f
 lowmeter\, treatment stations with attributes across that include diameter
 \, pipeline material\, operational status\, condition\, encroachment\, pho
 to\; sizes\, capacity\, models\, manufacturer etc. The PostGIS database wa
 s connected to a QGIS project environment where custom forms to were desig
 ned to capture attributes created in PostGIS. The QGIS project was linked 
 to an android based mobile app data collection software called Qfield\, ho
 sting custom forms designed in QGIS to capture the content of the water su
 pply features\, location and attributes. Using the form on Qfield\, the wa
 ter supply network is mapped and attributes captured and once data capture
  has been carried out using Qfield software\, data from field capture is s
 ynchronised to QGIS project and following edits to the data captured\, it 
 is updated to the PostGresSQL PostGIS database. QGIS software acting as th
 e project host environment also functions as the software for mapping\, vi
 sualising and analysis of data hosted and managed\nThe architecture presen
 ted is an opportunity for any organisation seeking a free and open source 
 GIS option in capturing and documenting and managing their water supply ne
 twork data. As one of the weaknesses\, is that data captured using Qfield 
 has the inherent horizontal and vertical accuracy acquired from android de
 vices which is less accuracy than that from a survey equipment. However\, 
 Qfield has the option of connecting to GNSS equipment by blue tooth\, inhe
 riting the sub cm horizontal and vertical accuracy it offers and thus impr
 oving locational and elevation information and still offering a higher acc
 uracy free open source option.
DTSTAMP:20260516T110652Z
LOCATION:Room I
SUMMARY:Free and Open source GIS architecture for low cost inventory mappin
 g of urban water supply network - Anthonia Onyeahialam
URL:https://talks.staging.osgeo.org/foss4g-2024/talk/CBXZNQ/
END:VEVENT
END:VCALENDAR