Issues of creating an information system for analysis of environmental factors in the Russian Arctic

Abstract

Intriduction. To solve the problems of collecting data on sanitary and epidemiological well-being it is necessary to automate and digitalize processes. Analysis of foreign experience shows the feasibility of developing domestic specialized software products that could be more consistent with the tasks of social and hygienic monitoring (SGM) with a comprehensive analysis of health indicators or environmental factors of the population in the context of macroregions over a long period of time. The purpose of the study was to develop a software product for automating the process of combining large amounts of data on environmental factors with the formation of a combined database. Materials and methods. The results of studies of environmental factors carried out by the Russian Federal Service for Surveillance on Consumer Rights Protection and Human Wellbeing (Rospotrebnadzor) within the framework of the SGM for the period from 2007 to 2019 in the context of individual municipalities of the constituent entities of the Russian Federation that are part of the Russian Arctic have been studied. Results. To solve the problem of forming a combined database from separate files in the MS Office Excel format, a software product (SP) in Python 3.6 has been developed that automates the processes of creating a database from a large number of separate files, which are characterized by a common structure. The SP was tested on the example of the analysis of the results of the SGM in the context of municipalities of the subjects of the Russian Arctic for 2019. The approbation showed the correct performance of the program, which was confirmed by the results obtained manually. The average time it took to create a merged database from 60 source files was 7 minutes. Conclusion. The created SP allows you to automatically combine a large number of separate Excel files containing in a standardized form data on the factors of the population’s habitat, collected as part of the SGM maintenance, with the formation of a combined database. The software can be used by the institutions of Rospotrebnadzor in the formation of combined databases in the context of any territories of the constituent entities of the Russian Federation for practical and scientific problems.

Choosing Data Clustering Tools For GIS-Based Visualization Of Disease Incidence In The Population

“…The above methods allow grouping polygonal objects on the map (municipalities, towns) considering the similarity criteria for the values of the selected indicator, which simplifies the visualization of the indicator distribution and the degree of its severity on the map. These tools are present in the standard set of desktop versions of the ArcMap geoinformation system and are additionally implemented in the Geoportal mapping application built based on ArcGIS for Server Advanced Enterprise v.11 [11].…”

“…However, geographic information systems are widely used in analyzing the incidence of noncommunicable diseases [9], as well as in assessing the state of sanitary and epidemiological wellbeing of the entire population. In particular, the Geoportal of Sanitary and Epidemiological Welfare of the Population of the Arctic Zone of the Russian Federation, developed by the Northwest Research Center for Hygiene and Public Health, is a tool for a comprehensive assessment of the state of the living environment and health in the population of the Russian Arctic [10,11].…”