BEGIN:VCALENDAR VERSION:2.0 PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-europe-2025//talk//EDTY9 C 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-europe-2025-EDTY9C@talks.staging.osgeo.org DTSTART;TZID=CET:20250716T150000 DTEND;TZID=CET:20250716T153000 DESCRIPTION:Geospatial data represents a critical tool for decision-making processes. The United Nations has recognized the importance of geospatial data through its global goals. The issue of energy is of particular signif icance for the development of the global community and the establishment o f the smart city concept. Therefore\, special attention should be given to managing the processes of electricity production and distribution\, with a particular focus on designing\, simulating the power distribution networ k and managing electricity losses during transmission.\nThe planning of th e distribution network is an essential element of urban planning and must be comprehensively assessed to improve decision-making procedures as demon strated in the study by Zheng et al. in China in 2012. Villacres et al. st ated that in electrical distribution system planning\, wire length is a ke y parameter for calculating voltage loss and related power losses. Thus\, an adequate network topology structure is necessary to execute algorithms and obtain data on losses. For visualization and proper analysis\, appropr iate open-source technologies can be used. La Guardia et al. provide an ex ample of real-time data integration into a 3D geospatial web-based visuali zation platform developed with open-source technology. Amović et al. prop ose executing process parallelization algorithms to speed up system perfor mance.\nIn 2019\, the Republic of Srpska implemented the project "Developm ent of a Utility Cadastre Model\," establishing an appropriate framework b ased on the Utility Network Inspire Directive model. "Elektrokrajina a.d." is a power distribution company supplying half of the consumers in the Re public of Srpska. The aim of this research is to present a study of the sy stem for planning\, managing and evaluating the LV/MV power network based on the 2D/3D WebGIS ELMAP system\, which acts as a decision-making tool.\n The goal of using these tools is to optimize electricity consumption\, ide ntify zones and time periods indicating electricity usage patterns leading to the optimization of scheduling and renewal of certain infrastructure e lements\, redefining the topology of the power network\, identifying zones for new transformer station construction and defining new transformer ser vice areas. To efficiently establish such a system it is necessary to addr ess the integration problem of large amounts of 2D/3D data on one side and semi-structured real-time data on the other. These data for power consupt ion and losses are obtained through other system components via sensor rea dings. \nELMAP is the central unit of the power distribution information s ystem. It acquires and structure structured\, semi-structured\, and unstru ctured data from other components of this information system into the ELMA P model. For these purposes\, specific procedures have been developed to s tructure data extracted from SAP\, Stone\, Asset Management\, and MdM syst ems\, as well as integrate data obtained through geodetic and LiDAR survey ing of the power infrastructure. Given the vast amounts of data involved\, process parallelization algorithms have been developed. At the PostgreSQL level\, serial queries have been implemented\, significantly increasing t ransaction execution speed in the system compared to traditional methods.\ nExisting geospatial data has been generated through digitization from exi sting plans or orthophotos. The primary issue with these data is their top ological inconsistency. There is no clearly defined geospatial hierarchy o f the network in terms of the topological definition of the medium-voltage and low-voltage networks\, nor the structuring of power lines\, branches\ , and segments\, as well as their connections to transformer stations\, po les\, and metering points. Since the medium-voltage and low-voltage networ ks operate at different voltage levels\, a dedicated algorithm has been de veloped to track network topology and voltage changes at transformer stati ons.\nThe position of electricity meters in the low-voltage network is det ermined based on GPS data from a mobile application. The meter is position ed within or touching a building (OSM Buildings are used). These meter pos itions have subsequently been used as a control mechanism for future meter readings. For system management\, an algorithm for determining meter read ing routes was developed. The spatial distribution of meters and the road network topology extracted from OSM served as the basis for developing an optimization algorithm for field meter reading routes. For this purpose\, the pgRouting environment was implemented to determine the shortest distan ce\, utilizing the All Pairs Shortest Path and Johnson’s Algorithm for f inding the shortest path for reading a group of meters.\nThe ELMAP system model was established as an extended package of the Inspire Directive mode l (Utility Network – Electricity) to provide an appropriate platform cap able of communicating with other system components. The system is designed as a service-oriented three-layer architecture using PostgreSQL with Post GIS extensions as the DBMS\, while communication occurs via WFS services a nd API modules with other system units. The system provides an appropriate administrative and user platform for data management.\nTo adequately anal yze losses in the existing infrastructure network\, data on voltage change s at the transformer service area and power line levels are used\, express ed through algorithms that provide parameters such as SAIFI\, SAIDI\, and peak power\, indicating network losses. To spatially identify critical poi nts in the infrastructure regarding network overloads and peak consumption periods system can suggest optimization measures and potential changes to transformer service zones. \nFor 3D structuring and analysis\, geospatial data sources include DEM data for terrain topography representation\, OSM buildings and roads for object and road representation\, integrated throu gh the MAPBOX environment via appropriate API services. Additionally\, dat a on poles\, transformer stations\, transformer positions\, and power line s for the medium-voltage network\, as well as poles\, power lines\, and me ters for the low-voltage network\, are utilized.\nFor 3D visualization\, t he MAPBOX environment was used\, where all infrastructure elements were cr eated as assets in GLB format. Given the need for visualizing large amount s of 3D data and models\, all elements were structured as 3D Tiles\, enabl ing fast and efficient 3D visualization and analysis of these data.\nThe a ccuracy assessment of the structured network topology was conducted by con trolling digitized system elements by comparing to data gained terrestrial measurement and calculating RMSE parameters. DTSTAMP:20260527T064157Z LOCATION:PA01 (Quarticle) SUMMARY:Implementation of a 2D/3D WebGIS for Electricity Network Management System - Mladen Amović URL:https://talks.staging.osgeo.org/foss4g-europe-2025/talk/EDTY9C/ END:VEVENT END:VCALENDAR