Conceptual Approach to Building a Database of Information System "Monitoring Of Concentration of Pollutants Substances by Automobile Transport"

Abstract

The article discusses aspects of building a database of information system "Modeling of the influence of traffic flow on the emissions of polluting substances in atmospheric air of Voronezh". The database is realized with the help of technical means of dynamic information model of the territory, reflecting spatial and temporal structure, condition, and relationship between the individual elements of the simulated ecosystem. The presence of baseline information on the environmental parameters characterizing the components included in the atmospheric air, allows to provide ecologists with the results of processing of experimental data and give recommendations for elimination of emissions of polluting substances by motor automobile transport into atmosphere. The reporting database is a set of relational tables in MySQL database format, where each individual observation (measurement or setting of abundance of the pollutant in a particular sample of atmospheric air) is informationally associated with specification of location coordinates and characteristics of sampling sites (geographical aspect), as well as the date of expedition (time aspect). A generalized information model of the database consists of the following tables: information about the streets and districts of the city; the original data on the different types of transport and intensity of their movement in different parts of the city; output of pollutants: substance, mass, and concentration on certain streets and districts of the city; constant data about automotive pollutants (CH,SO,Pb, and others); other constant data, which are necessary for correct operation of the information system. The relevance of this topic is explained by increasing number of motor vehicles in the city of Voronezh and the solution to the problem of its impact on the quality of urban environment and public health.