From a protected Access registry to controlled web reporting and integrated environmental GIS.
Belgrade LRIZ modernized a legacy pollution-source registry through SQL Server migration, a Blazor/ASP.NET Core reporting workflow, SSRS reporting and desktop/Web GIS integration.
Conceptual overview of the LRIZ modernization workflow.
Belgrade had operated LRIZ as a stand-alone Microsoft Access registry for annual pollution-source reporting. The Secretariat already maintained a wider environmental GIS, but the register was not integrated with it. The modernization therefore had to preserve institutional reporting logic while moving data, users, validation and analysis into a controlled server-based environment.
Move LRIZ to a server database, provide authenticated direct reporting and administrator review, preserve the institutional reporting model, strengthen consistency controls and connect the register to the Secretariat's reporting and desktop/Web GIS environment.
General data, air, water, soil and waste.
Table-level final-report statistic.
Parameterized and administratively extendable.
Word, PDF and Excel.
MapSoft reverse-engineered the protected Access database, created the SQL Server model and migrated the LRIZ records. The result was not a cosmetic redesign: it replaced a stand-alone database with a centrally managed application and data layer that could support authenticated reporting, review, structured outputs and spatial integration.
Implemented final-state environment recorded in the source: Microsoft SQL Server 2017/Express, Blazor + ASP.NET Core web application, SQL Server Reporting Services 2017, CadCorp SIS v9 desktop GIS, CadCorp GeognoSIS v9 GIS server and IIS/Windows Server hosting.
Authorized reporting entities enter annual data through structured forms. The application separates reporter work from Secretariat review, applies consistency checks and supports the submission, acceptance or return-for-correction lifecycle. Five reporting domains are documented: general data, air, water, soil and waste.
Reporter entry and Secretariat review are deliberately separated, with controlled status changes and validation in between.
The delivered reporting layer organized outputs into parameterized report groups and supported export. Administrators could maintain report definitions, while end users could filter results by relevant registry dimensions such as companies, facilities, municipalities and reporting years.
Annual form entry with structured selections and automatic consistency checks; submission; administrator review and accept/return; email status notification; parameterized reporting; thematic/spatial inspection and comparison with other environmental layers.
LRIZ spatial data were integrated into the Secretariat's CadCorp desktop and Web GIS environment. This connected registered pollution sources with thematic styling, spatial queries and comparison against other environmental layers, allowing tabular reporting and spatial analysis to work as one operational system.
The project combined data migration, application development, reporting, GIS integration, deployment, backup, training and contracted support. The technical scope is strongest as an end-to-end modernization reference rather than as a single software module.
Legacy Access data migrated to SQL Server 2017 with limited relational-model changes and separation of legacy/new data.
Authenticated Serbian-language application for direct reporting and administrator review.
Automatic consistency controls, statuses, administrator acceptance/return and email notifications.
Four parameterized report groups with Word/PDF/Excel export.
LRIZ spatial data, thematic styles, spatial queries, controls and comparison with other environmental layers.
Configured production components, automated daily database backup and completed training.
LRIZ changed from a stand-alone desktop database into an integrated operational information system with controlled web reporting, administrator validation, centralized server data, parameterized reporting and spatial comparison inside the Secretariat's environmental GIS. The system remains operational, as confirmed with the client in September 2026. Quantified time/cost savings and long-term adoption metrics are not established.
integratedA city-scale environmental decision-support system integrating measurements, spatial predictors, validated NO2 prediction models, desktop GIS workflows, Web GIS and reporting for environmental protection and spatial planning.
6328 measurementsNO2 measurements
View project →
softwareA nationwide environmental reporting platform modernizing Montenegro's Environmental Information System with role-based reporting workflows, data validation, dashboards, GIS/geoportal functions and EIONET-aligned metadata and exchange procedures.
10 modelsPriority ROD models
View project →
integratedA national-scale wetland inventory combining Earth Observation and geospatial processing, a standards-aware environmental data model and an operational Web GIS for visualization, editing, analysis, reporting and long-term change tracking.
National Republic of SerbiaNational coverage
View project →Talk to MapSoft about legacy-system modernization, data migration, authenticated business workflows, environmental reporting, spatial databases and desktop/Web GIS integration.