Database for geochemical assessment of the urban environments: a spatially oriented approach

Environmental geochemical studies of urban territories involve heterogeneous information that can be most effectively processed within a unified database (DB). Since a significant portion of the accumulated data is georeferenced, geographic information technologies should be used at all stages of the researches. The purpose of this work is to consider the structure of the DB for information support of ecological and geochemical studies of different urban environments in Moscow within the framework of the Russian Science Foundation project No. 19-77-30004 "Integrated technology for environmental assessment of Moscow megacity based on chemical analysis of microparticle composition in the "atmosphere - snow - road dust - soil - surface water" system (Megacity)".

The project aims to develop technologies for the chemical analysis of the urban environments impacted by the pollutants coming from vehicles, industry, and construction sites, as well as the assessment of the environmental state of the megacity. Various components of the environment are analyzed at several spatial scales: for the entire Moscow city, for administrative districts, for drainage basins of two urban rivers (Moskva and its tributary Setun). The composition of pollutant emissions is characterized using monitoring aerosol data at the Meteorological Observatory of Lomonosov Moscow State University. Microparticles PM₁₀ and PM_2.5 are analyzed for the content of elemental carbon, ionic and organic compounds, as well as potentially toxic elements, under different meteorological conditions and seasonal variations. The fallout of aerosols during winter is determined by the chemical analysis of dissolved and solid fractions of snow samples and its comparison with a natural background. Water migration of pollutants is assessed by analyzing river flows (water and suspended/bottom sediments) at reference stations in the Moskva River basin. The ecological state of road dust and soils that accumulate pollutants is estimated in geochemical surveying. Finally, source apportionment is quantified using statistical methods of multivariate analysis.

The development of a DB with the integrated geographic information system (GIS) allows systematizing the spatial and non-spatial information accumulated in field works, chemical and analytical studies, and organizing effective data storage and processing along with providing geoinformation support for DB users. We created four DB subsystems designed for: (1) processing georeferenced data (GIS); (2) working with time series; (3) handling regulatory and reference information; (4) assessing pollution and environmental hazard with computational models. For Moscow megacity, GIS brings together two large blocks of information: spatial layers stored within the geodatabase and spreadsheets with the results of field studies and chemical analyses. The main functions of the GIS are geoprocessing, execution of non-spatial and spatial queries, data analysis (including exploratory spatial data analysis and modeling), visualization of the results.

The report will present subsystems of the DB and the interrelationships between them. The use of the database in practice will be considered on the example of assessing the pollution of road dust with benzo(a)pyrene, accounting for anthropogenic and natural factors.