1 / 19

PMA AC Regional database on Pollution

PMA AC Regional database on Pollution. Richard Lisovsky, Head of sector GIS MAPS, Department SIS, UkrSCES, Odessa, Ukraine. September 6-8, 2011 Istanbul, Turkey. Activities. Regulation of the use of the Black and Azov Sea basin environment;

yin
Download Presentation

PMA AC Regional database on Pollution

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. PMA AC Regional database on Pollution Richard Lisovsky, Head of sector GIS MAPS, Department SIS, UkrSCES, Odessa, Ukraine September 6-8, 2011 Istanbul, Turkey

  2. Activities • Regulation of the use of the Black and Azov Sea basin environment; • Development of the use of the Black and Azov Sea basin environment. Scientific problems of ecological expertise; • Monitoring of the environment; • Development of information systems; • Development and maintenance of data bases; • International obligations in the sphere of environmental protection; • Development of new methods and methodology of taking measurements.

  3. Technical capabilities of UkrSCES

  4. UkrSCES resources

  5. Proceeded activities with RDB • Create and maintain an on-line Regional Database on pollution and its impacts on the Black Sea ecosystem: • Created database structure • Filled out data for the Country, Sample type, Parameter group, Parameter, Quality, Unit, Biota type and Sediment type tables • Organize easy access to the Regional Database on pollution: • The user interface for access to RDB is now developing • 3. Organize Interactive Map Services (via www-access to UkrSCES Web Site): • Developed Interactive Cartographic Information System for accommodation of cartographic materials and environmental data based on open source UMN Mapserver software

  6. What steps are ready • Developed structure of Regional Database – tables, links, indexes • Developed web-interface of RDBP for public access, read, edit, update or import data • Developed security matrix for RDBP access – public, BSC members, data provider, AG members • Developed GIS mapserver application and integrated to database web-interface • Developed common user interface

  7. What steps are ready • RDB-P includes the information coming from every country in the BSC in a consistent reporting format AG PMA: • Organizations who provide monitoring • Place of sampling • Samples taken and their details • The methods used for sampling and analysis: Sample method, Analysis method • List of mandatory and additional pollutants to be monitored. • Concentrations of contaminants in the following samples: sea water, sediments, biota.

  8. Security matrix

  9. Client side Web browser Common structure of portal Vector & Raster Data Regional DB

  10. Data input process Regional Data Holder Regional Data Provider Approval DB Data check-out Data input Data approve QC maintenance is performed for data input control from errors and misprints based on a human or technical factor Regional DB

  11. General statistics

  12. Regional database main page

  13. Provider selection

  14. Metadada query result (example) Country, Name Organization, Address, Tel, Fax, Description, Site, Email, ContactPerson, ContactPersonEmail. And metadata for stations.

  15. Sample data query result (example)

  16. Data input example

  17. Not all data are presented in the format of PMA Reporting, • bringing to the desired format requires additional • time-consuming when writing. • The most common error in these data: X Sometimes the data is not tied to the type of sample, ie there is no certainty - that the data on water or on bottom sediments; X Do not specify a unit of measurement; • X There are errors in the coordinates of the station is located on the shore; Data obtained from the Secretariat for 2000-2005, 2006-2009.

  18. Developing now Excel data parser for automatic data import to database via user web-interface Mapserver GIS layers and navigation tools GIS map objects identification upon user request Preparations for migrating database and web-interface to dedicated server and set up test-production status Statistics visualization – map data, charts, tables Tools for export requested data in common formats – text files, excel files, ocean data view files

  19. Thanks for your attention! Any questions? www.sea.gov.ua

More Related