Investigation of spatial data infrastructure design for infrastructure activities: The Case of Konya Metropolitan Municipality

Today, as the rate of urbanization continues to increase, new models are required for cities to remain sustainable and livable environments. The smart city model aims to make city administrations more functional by utilizing advanced technologies. Urban Information Systems (UIS) collect, evaluate, organize and share data from smart cities. These systems are in constant interaction with local governments and make it possible to offer quick solutions to meet the needs of people living in the city. The coordination of smart cities and UIS enables local governments to adopt a rational approach to decision-making and thus to utilize resources more efficiently. For this reason, the coordination of local governments with innovative systems is essential for increasing living standards. Infrastructure activities in cities are of great importance in terms of meeting the needs of people in their daily lives. Infrastructure networks need to be managed smoothly in terms of fast, coordinated and planned realization of works such as construction, rehabilitation and repair of faults, effective and efficient use of resources, and normal daily life. It is not possible to transfer the graphic and attribute information of infrastructure networks to the database, to associate them with each other, to make queries and analyzes with traditional methods. In order to manage existing and newly constructed network lines in a planned, fast and accurate manner, institutions should establish infrastructure information systems within their organizations. Infrastructure information systems (IIS), aim to reach solutions in the areas of sharing the infrastructure status of institutions with each other, keeping up-to-date records of future planning, construction, rehabilitation, fault repair, etc., and fast and effective elimination of problems occurring in infrastructure networks. With the IIS, it is possible to manage, update and store rapidly changing data, monitor instant data changes and display, query and analyze millions of data from a single location. Standards regulating the collection, management, sharing and use of spatial data have been set for institutions and organizations using IIS. These standards have been developed to ensure that the data are compatible, easily accessible, shareable and collaborative. These standards have been developed and accepted by national organizations such as Turkey National Geographic Information System (TUCBS) and Turkey Determination of Urban Information Systems Standards (TRKBIS) projects, and international organizations such as International Organization for Standardization (ISO), Open Geographic Consortium (OGC) and European Union's INSPIRE (Infrastructure for Spatial Information in Europe) Directive. In this research, the infrastructure information in the inventory of the Geographical Information System (KOSKIGIS) used by Konya Water and Sewerage Administration (KOSKI), an organization affiliated to Konya Metropolitan Municipality, was used. The attribute information of the infrastructure data created on the Oracle database used by KOSKI GIS was compared with TUCBS standards, and additions or corrections were made in case of deficiencies or incompatibilities. The connection information of the drinking water and wastewater infrastructure data created in the Oracle database was entered and the layers created were published on Geoserver. Within the scope of displaying the published layers of the infrastructures on the Web Map Service (WMS), the styles in the form of Layer Style Descriptor (SLD) published in line with TUCBS standards were matched with the layers and made available for sharing on Geoserver. Finally, the data entered according to TUCBS standards were checked for matching in WMS and Web Feature Service (WFS) Services. The study is expected to serve as a guide for public institutions and organizations providing infrastructure services to obtain information about the national and international standards to be followed when including their spatial data in infrastructure information systems, ensuring coordination between institutions, interoperability and data sharing in common standards.