CC BY
64
Вестник^ВГУИЖ/Proceedings of VSUET ISSN 2226-910X E-ISSN 2310-1202
DOI: http://doi.org/1Q.2Q914/231Q-1202-2Q19-4-263-267_Краткое сообщение/Short message_
УДК 210_Open Access Available online at vestnik-vsuet.ru
Разработка и применение современных геоинформационных систем для мониторинга экологического состояния объектов
Игорь А. Хаустов 1 haustov_ia@mail.ru © 0000-0002-8897-5763
Сергей С. Рылёв 1 rozopt@mail.ru 0000-0002-0402-25IX
_Елена Н. Ковалева 1 kovaleva.lena@gmail.com 0000-0002-8558-4724
1 Воронежский государственный университет инженерных технологий, пр-т Революции, 19, г. Воронеж, 394036, Россия Аннотация. Представлены результаты применения геоинформационных систем для проведения экологического аудита, который позволяет осуществлять мониторинг экологической обстановки на объектах пищевой и химической промышленности и обеспечивать экологическую безопасность рассматриваемой природной и промышленной территории. Предложена математическая модель, выполняющая контроль состояния объектов окружающей среды. Для классификации результатов измерения параметров состояния почвы проведен вычислительный эксперимент, выполненный в среде Matlab. Результаты выполненного анализа и построенные на их основе электронные картограммы использованы для прогнозирования расположения точек с превышением паразитологических показателей в почве. С помощью созданной нейронной сети произведена оценка состояния почвы в различных районах города Воронежа и проведено сравнение результатов с аналогичными показателями, измеренными в 2017 г. Данные взяты из информационного бюллетеня «Оценка влияния факторов среды обитания на здоровье населения Воронежской области по показателям социально-гигиенического мониторинга». Информация подготовлена Управлением Роспотребнадзора по Воронежской области. Исследование проводилось на кафедре информационных и управляющих систем Воронежского государственного университета инженерных технологий. Геоинформационные системы построены с помощью программного продукта MapInfo. Функциональность их использования заключается в моделировании экологической ситуации на объектах и информировании о текущих показателях с помощью картографии. Таким образом, приведенный геоинформационный метод исследования позволяет осуществлять прогноз показателей выброса вредных веществ в окружающую среду и может быть использован контролирующими службами государственных органов для контроля экологического состояния рассматриваемой территории.
Ключевые слова: экологический аудит, геоинформационные системы, моделирование нейронных сетей, программное и аппаратное обеспечение, картография
Development and application of modern geographic information _systems for monitoring the environmental status of objects_
Igor A. Khaustov 1 haustov_ia@mail.ru © 0000-0002-8897-5763
Sergey S. Rylev 1 rozopt@mail.ru 0000-0002-0402-25IX
_Elena N. Kovaleva 1 kovaleva.lena@gmail.com 0000-0002-8558-4724
1 Voronezh State University of Engineering Technologies, Revolution Av., 19 Voronezh, 394036, Russia_
Abstract. The article presents the results of the application of geographic information systems for environmental auditing, which allows you to monitor the ecological situation on the objects, food and chemical industries and to ensure environmental safety of natural and industrial areas. The authors propose a mathematical model that performs monitoring of environmental objects. The computational experiment is performed in Matlab for classifying the soil measurement conditions. The results of the analysis and the electronic cartograms constructed on their basis are used to predict the location of the points exceeding the parasitological indices in the soil. The assessment of the condition of the soil in different districts of the Voronezh city is made with the help of the created neural networks. The results are compared with the same indicators, measured in 2017. Data is taken from the information Bulletin «Evaluation of the influence of environmental factors on the health of the population of the Voronezh region on indicators of socio-hygienic monitoring». Information was prepared by the Office of Rospotrebnadzor in the Voronezh region. A study cited in the article was conducted at the Department of information and control systems of the Voronezh state University of engineering technologies. Geographic information system was built with the help of MapInfo software product. It can be used to simulate the environmental situation and to inform about its current state with the help of cartography. Thus, the geoinformation research method reviewed in this article allows predicting the emission of harmful substances into the environment and it can be used by regulatory agencies of the state authorities to control the environmental state of the territory.
Keywords: environmental audit, geographic information systems, neural network modeling, software and hardware, cartography
Introduction
The geoinformation method of studying the environmental situation involves the analysis of the entire spectrum of available information in relation to a specific geographical point or object. Spatial
geoinformation includes geographical information about the study area, objects located on it and occurring natural and anthropogenic phenomena [1]. Geoinformation assumes the monitoring data of these objects and phenomena distributed over time.
Для цитирования
Хаустов И.А., Рылёв С.С., Ковалева Е.Н. Разработка и применение современных геоинформационных систем для мониторинга экологического состояния объектов // Вестник ВГУИТ. 2019. Т. 81. № 4. С. 263-267. doi:10.20914/2310-1202-2019-4-263-267
For citation
Khaustov I.A., Rylev S.S., Kovaleva E.N. Development and application of modern geographic information systems for monitoring the environmental status of objects. Vestnik VGUIT [Proceedings of VSUET]. 2019. vol. 81. no. 4. pp. 263-267. (in Russian). doi:10.20914/2310-1202-2019-4-263-267
© 2019, Хаустов И.А. и др. / Khaustov I.A.. et al.
This is an open access article distributed under the terms of the Creative Commons Attribution 4.0 International License
Kfiaustov I.A.. et aC. Proceedings of VSUET, 2019, voC. 81, no. It is necessary for creating models and predicting the implementation of a particular scenario of changing environmental conditions. Non-spatial geoinformation consists of regulatory documentation, general data specific to the class of objects under consideration, phenomena, etc. Environmental audit through the geoinformation method of research solves the following tasks [2] :
• monitoring the ecological situation of natural and man-made emergencies, assessing man-made environmental impacts and their consequences, ensuring the environmental safety of the territory in question (from local to global level);
• territorial and sectoral planning and management of the placement of industrial, transport, agricultural, energy facilities;
• control of living conditions of the population, health care and recreation;
• mapping (integrated and industry-specific): creating thematic maps and atlases, updating maps, quick mapping;
• integration and interaction of information resources.
Thus, environmental audit using geographic information systems (GIS) performs two functions: informing about objects and the state of the environment and modeling. As a result of the environmental audit study using GIS, managerial decisions are made whose purpose is to stabilize and improve the environmental situation in the territory under consideration.
Materials and methods
The results of environmental studies are operational data of three types: ascertaining (measured parameters characterizing the ecological situation at the time of the survey), evaluative (results of processing measurements and deriving from them an assessment of the environmental situation), forecasting (predicting the development of the ecological situation for a certain period of time). mainly dynamic models based on the creation of digital maps are applied through GIS [3]. Any modern GIS contains a set of tools for analyzing spatial attribute information. GIS queries can be set both with a simple mouse click on the object, and with the help of advanced analytical tools. Along with the tools of the standard Structured Query Language (SQL), the analytical capabilities of GIS give the user powerful and customizable tools for processing and managing information [4]. To build maps, we used MapInfo products:
MapInfo Professional - a fully functional geographic information system;
MapBasic - a programming environment for MapInfo Professional;
MapInfo SpatialWare - spatial information management technology in SQL Server / Informix database;
MapInfo MapX - application developer library;
MapXtreme - Mapping application development software for Intranet or the Internet.
263-267 post@vestnik-vsuet.ru
In addition to the functions traditional for a DBMS, MapInfo Professional GIS allows collecting, storing, and displaying, editing and processing cartographic data stored in a database, taking into account the spatial relationships of objects [5].
Data sources are:
Exchange vector formats for CAD and geographic information systems: AutoCAD (DXF, DWG), raster maps in GIF, JPEG, TIFF, PCX, BMP, PSD formats. We also display data obtained using GPS devices.
Excel and text files, in which, in addition to attribute information, the coordinates of point objects can be stored.
MapInfo GIS can act as a «map client» when working with such well-known DBMSs as Oracle and DB2, because it supports an effective mechanism for interacting with them through the ODBC protocol. Moreover, access to data from Oracle DBMS is also possible through the internal interface (OCI) of this database. In one session, data of different formats can be used simultaneously.
The built-in SQL query language, thanks to geographical expansion, allows organizing selections taking into account the spatial relationships of objects, such as remoteness, nesting, overlap, intersections, area of objects, etc. Database queries can be saved as templates for future use [6]. MapInfo has the ability to search and map objects to a map by coordinates, address, or index system, which we used to: represent data such as a map and a list. In the Maps window, tools for editing and creating cartographic objects, scaling, changing projections and other functions of working with the map are available [7]. Attributive information associated with cartographic objects is stored in the form of tables, data from which can be represented in the form of graphs and diagrams of various types [8]. The Legends window displays the legend of objects on the map and thematic layers. The Report window provides tools for scaling, prototyping, as well as saving templates for multi-sheet maps. Working with MapInfo, you can generate and print reports with map fragments, lists, charts, and labels. MapInfo uses standard operating system drivers for printing.
Geoinformational ecological modeling of the state of the environment on the basis of GIS allowed us to get answers to the questions: «How would the ecological situation be if there weren't any economic activity in the territory under consideration?» and «How will the situation change when this object is added to the study area?», «Does this compensate for the anthropogenic pressure on the environment or will a synergistic effect manifest itself?»
Systematic control of the level of pollution of the surface layer of atmospheric air is carried out at 5 control points, the quality of drinking water - at 18 control points, soil - at 21 control points [9].
Results
According to microbiological indicators (bacteria of the Escherichia coli group and Entero-coccus index), the soil did not meet the standards at 14 monitoring points out of 21, and for parasito-logical indicators at 2 monitoring points (Figure 1).
. 4 PP.
XaycmoB MIß. u dp. Becmnu^BTy^T, 2019, T. 81, №. 4, C 263-267
Figure 1. Monitoring JJUllilo U f control with excess of standards of parasitological indicators in the soil (according to data for 2017)
To classify the results of soil measurements, a computational experiment was performed in the Matlab environment (Figure 2).
post@vestnik-vsuet. ru
The assessment of the condition of the soil in different districts of the Voronezh city was made with the help of the created neural networks.
Using a neural network, software and hardware, the state of the soil was classified in various areas of the city of Voronezh according to 2017.
Then, the average daily maximum permissible concentration of excess in atmospheric air was recorded for 5 of the 14 controlled substances (nitrogen dioxide, sulfur dioxide, carbon monoxide, phenol, formaldehyde).
Data was taken from the information Bulletin «Evaluation of the influence of environmental factors on the health of the population of the Voronezh region on indicators of socio-hygienic monitoring». Information was prepared by the Office of Rospo-trebnadzor in the Voronezh region. A study cited in the article was conducted at the Department of information and control systems of the Voronezh state.
A mathematical model is proposed that performs an environmental audit of environmental objects.
Figure 3 shows the result of predicting the location of points with excess parasitological parameters in the soil.
Obviously, a similar method of environmental audit using geoinformation research and cartography can be used at various enterprises in the food and chemical industries to monitor indicators of the emission of harmful substances into water, air and soil, as well as by controlling services of state bodies for monitoring the environmental condition of the region [10].
a
Figure 1
File Edit View insert Tools Desktop Window Help
D ¿3 d i vy? ® e s. ■ s □ m «j
°o ® o°8 * o
ilo
Figure 2. Neural network training
Figure 3. Classification of a sample by a neural network by indicators
Conclusions
The results of the analysis and electronic car-tograms can be used to justify and implement environmental management decisions.
Khaustov I.A.. et aC. Proceedings of VSUET, 2019, vol. 81, no. 4, Thus, the GIS performs two functions: informing about the state of the environment and modeling the current state of objects with the help of cartography.
As a result of informational electronic audit using GIS, managerial decisions are made, the purpose of which is to stabilize and improve the environmental situation in the territory under consideration.
GIS MapInfo offers great opportunities for developers of geographic information software. Using modern methods of interaction between Windows applications you can integrate the MapInfo Maps window into programs written in Delphi, Visual Basic, C ++, PowerBuilder, etc. Using MapInfo and the MapBasic development environment everyone can create specific applications for solving specific application problems [11].
. 263-267 post@vestnik-vsuet.ru
Since the system «environment - sources of anthropogenic load» is constantly changing, GIS displays the dynamics of toxic stress growth, as well as measures to improve the state of the environmental situation.
It is advisable to use the proposed concept in organizations operating in the field of environmental monitoring, audit and management decisions to minimize and eliminate technological impacts [12].
This approach can also be used as part of the overall quality management system at enterprises to solve the following tasks: forecasting the impact of anthropogenic activities on the environment and timely changes in the technological cycle, equipment modernization in order to prevent the deterioration of the state of negative responses from the natural and tecnogenic complex.
Литература
1 Журкин И.Г., Шайтура С.В. Геоинформационные системы. М.: «КУДИЦ-ПРЕСС», 2009. 272 с.
2 Лурье И.К. Геоинформационное картографирование. Методы геоинформатики и цифровой обработки космических снимков: учебник. М.: КДУ, 2008. 424 с.
3 Информационные технологии и вычислительные системы: Обработка информации и анализ данных. Программная инженерия. Математическое моделирование. Прикладные аспекты информатики; под ред. С.В. Емельяноваю М.: Ленанд, 2015. 104 с.
4 Остроух А.В., Николаев А.Б. Интеллектуальные информационные системы и технологии: монография. СПб.: Лань, 2019. 308 с.
5 ДеМерс М.Н. Географические информационные системы. Основы: пер. с англ. М.: Дата+, 1999. 290 с.
6 Информационные системы и технологии; под ред. Тельнова Ю.Ф. М.: Юнити, 2017. 544 с.
7 Drosou M., Jagadish H.V., Pitoura E., Stoyanovich Ju. Diversity in big data: A review // Big data. 2017. V. 5 № 2. P. 73-84.
8 Montali M., Rivkin A. Model checking Petri nets with names using data-centric dynamic systems // Formal Aspects of Computing. 2016. V. 28 № 4. P. 615-641.
9 Kurolap S.A., Klepikov О. V., Vinogradov P.M., Prozhorina T.I. Integral assessment and GIS mapping of Voronezh // Сборник материалов Международного научно-практического семинара по медицинской географии и экологии человека 13-16 августа 2015 года. Владимир. 2015. C. 18.
10 Куролап С.А., Клепиков О.В., Виноградов П.М., Прожорина Т.И. и др. Геоинформационное картографирование состояния окружающей среды промышленного города (опыт практической реализации на примере города Воронежа) // Оценка и геоинформационное картографирование медико-экологической ситуации на территории города Воронежа: сборник научных статей. 2019. C. 6-54.
11 Хаустов И.А., Ковалева Е.Н. Применение геоинформационных систем в логистике предприятий // Материалы LVII отчетной научной конференции преподавателей и научных сотрудников ВГУИТ за 2018 год: в 3ч. Часть 2. 2019. C. 79-80.
12 Тихомиров С.Г., Авцинов И.А., Туровский Я.А., Суровцев А.С. и др. Программно-аппаратный комплекс для управления биотехнологическими системами с использованием интеллектуальных информационных технологий // Вестник Воронежского государственного университета. Серия: Системный анализ и информационные технологии. 2019. № 3. С. 158-165.
References
1 Zhurkin I.G., Shaitura S.V. Geoinformation systems. Moscow, «KUDITS-PRESS», 2009. 324 p. (in Russian).
2 Lurie I.K. Geoinformation mapping. Methods of geoinformatics and digital processing of satellite images: a textbook. Moscow, KDU, 2008. 424 p. (in Russian).
3 Information technology and computing systems: Information processing and data analysis. Software Engineering Mathematical modeling. Applied aspects of computer science; Ed. by S.V. Emelyanov. Moscow, Lenand, 2015. 104 p. (in Russian).
4 Ostroukh A.V., Nikolaev A.B. Intelligent Information Systems and Technologies: monograph. St. Petersburg, Lan, 2019. 308 p. (in Russian).
5 DeMers M.N. Geographic Information Systems. The basics. Mosow, Date +, 1999. 290 p. (in Russian).
6 Information systems and technologies; Ed. Telnova Y.F. Moscow, Unity, 2017. 554 p. (in Russian).
7 Drosou M., Jagadish H.V., Pitoura E., Stoyanovich Ju. Diversity in big data: A review. Big data. 2017. vol. 5 no 2. pp. 73-84.
8 Montali M., Rivkin A. Model checking Petri nets with names using data-centric dynamic systems. Formal Aspects of Computing. 2016. vol. 28 no. 4. pp. 615-641.
9 Kurolap S.A., Klepikov O.V., Vinogradov P.M., Prozhorina T.I. Integral assessment and GIS mapping of Voronezh. The collection of materials of the International scientific-practical seminar on medical geography and human ecology. Vladimir, 2015. pp. 18. (in Russian).
Хаустов И.А и др. ВесткикВТУИШ, 2019, Т. 81, №. 4, С. 263-267
posi@vesinik-vsuet. ru
10 Kurolap S.A., Klepikov O.V., Vinogradov P.M., Prozhorina T.I. et al. Geoinformation mapping of the state of the environment of an industrial city (practical experience on the example of the city of Voronezh). Assessment and geoinformation mapping of the medical and environmental situation on the territory of the city of Voronezh: Collection of Scientific Articles. 2019. pp. 6-54. (in Russian).
11 Khaustov I.A., Kovaleva E.N. The use of geographic information systems in the logistics of enterprises. Materials of the LVII report of the scientific conference of teachers and researchers of VGUIT for 2018: at 3 h. Part 2. 2019. pp. 79-80. (in Russian).
12 Tikhomirov S.G., Avtsinov I.A., Turovsky Y.A., Surovtsev A.S. et al. Hardware-software complex for managing biotechnological systems using intelligent information technologies. Bulletin of Voronezh State University. Series: System Analysis and Information Technology. 2019. no. 3. pp. 158-165. (in Russian).
Сведения об авторах Игорь А. Хаустов д.т.н., доцент, кафедра информационных и управляющих систем, Воронежский государственный университет инженерных технологий, пр-т Революции, 19, г. Воронеж, 394036, Россия, haustov_ia@mail.ru
https://orcid.org/0000-0002-8897-5763 Сергей С. Рылёв к.т.н., доцент, кафедра информационных и управляющих систем, Воронежский государственный университет инженерных технологий, пр-т Революции, 19, г. Воронеж, 394036, Россия, rozopt@mail.ru
https://orcid.org/0000-0002-0402-251X Елена Н. Ковалева к.т.н., доцент, кафедра высшей математики и информационных технологий, Воронежский государственный университет инженерных технологий, пр-т Революции, 19, г. Воронеж, 394036, Россия, kovaleva.lena@gmail.com https://orcid.org/0000-0002-8558-4724 Вклад авторов Все авторы в равной степени принимали участие в написании рукописи и несут ответственность за плагиат Конфликт интересов Авторы заявляют об отсутствии конфликта интересов.
Information about authors Igor A. Khaustov Dr. Sci. (Engin.), associate professor, information and control systems department, Voronezh State University of Engineering Technologies, Revolution Av., 19 Voronezh, 394036, Russia, haustov_ia@mail.ru
https://orcid.org/0000-0002-8897-5763 Sergey S. Rylev Cand. Sci. (Engin.), associate professor, information and control systems department, Voronezh State University of Engineering Technologies, Revolution Av., 19 Voronezh, 394036, Russia, rozopt@mail.ru
https://orcid.org/0000-0002-0402-251X Elena N. Kovaleva Cand. Sci. (Engin.), associate professor, Department of Higher Mathematics and Information Technology, Voronezh State University of Engineering Technologies, Revolution Av., 19 Voronezh, 394036, Russia, kovaleva.lena@gmail.com https://orcid.org/0000-0002-8558-4724 Contribution
All authors are equally involved in the writing of the manuscript and are responsible for plagiarism
Conflict of interest The authors declare no conflict of interest.
Поступила 21/10/2019_После редакции 04/11/2019_Принята в печать 13/11/2019
Received 21/10/2019_Accepted in revised 04/11/2019_Accepted 13/11/2019
