BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2022//speaker//A9QEZF
BEGIN:VTIMEZONE
TZID:CET
BEGIN:STANDARD
DTSTART:20001029T040000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
TZNAME:CET
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000326T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
TZNAME:CEST
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-foss4g-2022-3P3PKQ@talks.staging.osgeo.org
DTSTART;TZID=CET:20220825T152000
DTEND;TZID=CET:20220825T152500
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 informati
 on system–based free and opensource software architecture for the mappin
 g and inventory of urban water supply network. This architecture is especi
 ally useful where budget is tight and decision relating to meeting the wat
 er and sanitation-related Sustainable Development goals needs to be made. 
 The architecture consists of data management\, data collection\, data anal
 ysis and project host environment tools and software. \nPostGresSQL with P
 ostGIS was used for design and management of water supply network GIS data
 base\, basing the creation and design of features and attributes on prior 
 knowledge of what exists on water supply networks. Features created are tr
 ansmission and distribution pipelines\, hydrants\, valves\, chambers\, jun
 ctions\, leaks\, encroachments\, pumps\, pump stations\, reservoirs\, bulk
  flowmeter\, treatment stations with attributes across that include diamet
 er\, pipeline material\, operational status\, condition\, encroachment\, p
 hoto\; sizes\, capacity\, models\, manufacturer etc. The PostGIS database 
 was connected to a QGIS project environment where custom forms to were des
 igned to capture attributes created in PostGIS. The QGIS project was linke
 d to an android based mobile app data collection software called Qfield\, 
 hosting custom forms designed in QGIS to capture the content of the water 
 supply features\, location and attributes. Using the form on Qfield\, the 
 water supply network is mapped and attributes captured and once data captu
 re has been carried out using Qfield software\, data from field capture is
  synchronised to QGIS project and following edits to the data captured\, i
 t is updated to the PostGresSQL PostGIS database. QGIS software acting as 
 the project host environment also functions as the software for mapping\, 
 visualising and analysis of data hosted and managed \nThe architecture pre
 sented is an opportunity for any organisation seeking a free and open sour
 ce GIS option in capturing and documenting and managing their water supply
  network data. As one of the weaknesses\, is that data captured using Qfie
 ld has the inherent horizontal and vertical accuracy acquired from android
  devices which is less accuracy than that from a survey equipment. However
 \, Qfield has the option of connecting to GNSS equipment by blue tooth\, i
 nheriting the sub cm horizontal and vertical accuracy it offers and thus i
 mproving locational and elevation information and still offering a higher 
 accuracy free open source option.
DTSTAMP:20260404T194834Z
LOCATION:General online
SUMMARY:Free and Open source GIS architecture for low cost inventory mappin
 g of urban water supply network - Anthonia Ijeoma Onyeahialam
URL:https://talks.staging.osgeo.org/foss4g-2022/talk/3P3PKQ/
END:VEVENT
END:VCALENDAR