Open AccessAspects Concerning the Development of the MEMDUR System
Author(s) -
Gabriel Gorghiu,
Cătălin Ristea,
Carmen Leane Nicolescu
Publication year - 2010
Publication title -
bulletin of university of agricultural sciences and veterinary medicine cluj-napoca. agriculture
Language(s) - English
Resource type - Journals
eISSN - 1843-5386
pISSN - 1843-5246
DOI - 10.15835/buasvmcn-agr:5179
Subject(s) - database , spatial database , computer science , sql , pollution , representation (politics) , sql server , pollutant , workspace , spatial analysis , data mining , environmental science , remote sensing , artificial intelligence , geography , ecology , chemistry , organic chemistry , politics , political science , robot , law , biology
. The MEMDUR system has been created and developed with the aim to offer an image of the air pollution in the area of Targoviste city. A spatial database and a mathematical model represent the core structure of the system. The spatial database was designed in SQL Server. Using GeoMedia, the spatial entities were defined taking into account the global coordinate system. The data, collected from different sources, are imported into the GeoMedia workspace and then exported to SQL Server database, generating a geometric entity, automatically. The mathematical model provides an analyze of the pollution status for CO, NO, NO2, SO2 and PM10 dusts, comparing their values with the hourly maximum admitted concentrations. For establishing the areas were the level of pollution generated by the stationary pollution sources is at maximum level, the model incorporates source-related and meteorological factors. Once the pollutant concentration in the DTM points was determined, it is possible to show different forms of concentration distribution on the areas of interest. Spatial queries can be made between the areas with concentrations in a given interval and in the entities of interest. There is presented a simulation of a hypothetical situation of a pollution accident to demonstrate the model efficiency, the visual representation of the pollutant concentration and the used symbols, which show the movement gradient of the pollutant. The on-line web publishing system was performed using GeoMedia WebMap application. The system interface offers the possibility to open and consult the designed database and visualize a graphical representation of the area of interest and the technical attributes of the objects or events registered in the critical points.