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

Introduction. 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.

Contribution:

Gorbanev S.A. — the concept and design;

Novikova Yu.A., Fedorov V.N. — the concept and design, writing text;

Kovshov A.A., Tikhonova N.A. — collection and processing of material;

Rakova V.V., Bolsunovskaia M.V. — editing, approval of the final version of the article, responsibility for the integrity of all parts of the article. 

Conflict of interest. The authors declare no conflict of interest.

Acknowledgment. The study had no sponsorship.