Establishing a Geo-Database for Drinking Water and Its Delivery and Storage Components with an Object-Based Approach

Infrastructure facilities that serve the city as a whole and should be considered as a whole should be built in an orderly and planned manner, just as cities are. Infrastructure facilities become obsolete over time. Aging infrastructure facilities may become unserviceable over time. When the need for maintenance and repair arises, it is mandatory to renew or replace infrastructure facilities. In this case, necessary maintenance/repair and renovation works should be completed as soon as possible. These infrastructure facilities may not be transferred to maps in the digital environment and may often be managed with person-oriented information, not institutional. There is a problem for decision makers, namely, that the construction, maintenance, repair and governance of infrastructure facilities cannot be carried out systematically, on time and effectively. The only way to provide such a service is through the combined use of today’s informatics, Geographical Information System (GIS) and Global Navigation Satellite System (GNSS) technologies, unlike the classical methods of the past. The aim of the study is to effectively manage the scarce resource of drinking water and its facilities, which are an important component of infrastructure facilities, with a method that uses current mapping technologies and informatics facilities. Especially after Infrastructure for Spatial Information (INSPIRE) and the transformation of Land Administration Domain Model (LADM) to the International Organization for Standardization (ISO) standard, Turkish National Geographic Information System (TNGIS) studies and many academic studies carried out in Türkiye have been modelled with Unified Modelling Language (UML) diagrams in accordance with LADM. Similarly, within the scope of this study, UML diagrams were prepared, and then a GIS database was established. Thanks to field workers, chiefs, engineers and others working on water pipelines, all necessary data, classic, as-built and digital, were gathered. These were collected in different ways in order to conduct spatial and non-spatial analysis in the study area of Trabzon. The most important result from the study is that the entire drinking water infrastructure of Trabzon has been transferred to the system in a structure that allows spatial queries, ensuring that damage detection on water components, maintenance and repair processes are carried out in the shortest time and at the lowest cost. The investigation and application of a sensor-integrated GIS-aided system, making it possible to control and monitor the use of lost and illegal water to be controlled as well as inform consumers who will be affected by possible maintenance and repair, is recommended.