1 / 35

DELIVERABLE 2.2 Geodatabase Activities 2.2 and 2.3 DELIVERABLE 2.3

Development of a common intraregional monitoring system for the environmental protection and preservation of the Black Sea ECO-Satellite GA2: Geodatabase development and data collection A2.2:“Collection and processing of current & historical data”

nita
Download Presentation

DELIVERABLE 2.2 Geodatabase Activities 2.2 and 2.3 DELIVERABLE 2.3

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. Development of a common intraregional monitoring system for the environmental protection and preservation of the Black Sea ECO-Satellite GA2: Geodatabase development and data collection A2.2:“Collection and processing of current & historical data” A2.3:“Design and creation of the geodatabase” A2.4:“Testing of system components and geodatabase in test sites” 2nd Project Meeting 22-24 October 2012 Tulcea, Romania

  2. Outline of the presentation DELIVERABLE 2.2 Geodatabase Activities 2.2 and 2.3 DELIVERABLE 2.3 Components Operation Report, evaluating the system components testing Activity 2.4 A B

  3. Part A -General Information GA2 -Geodatabase development and data collection Partners Involved: All apart from DAV & DAMT Deliverable 2.2: Geodatabase Responsible for submission to LP: Aleksandrov and Grigoriadis Deadline for submission: 31/07/2012 (submitted on time)

  4. Activity 2.2: Collection and processing of current and historical data (1/3) according to the DOW document • Data collection (following the requirements of the protocol and data availability): • Collect historical data (Axios and northern part of the Danube marine region) • Acquire new data • Satellite and in situ data collection for wetland parameters using remote sensing • Satellite and in situ data collection for sea level monitoring and mapping sea bed morphometry • Telemetry and in situ data collection for monitoring marine quality and ecosystem parameters

  5. Activity 2.2: Collection and processing of current and historical data (2/3) according to the DOW document • Process data for wetland parameters using remote sensing (outputs according to the protocol): • Habitat maps • Water surface and inundated vegetation maps (at high and low water level) (from Landsat 5, MODIS, ASAR) • Indicators describing the state of the ecosystem (landscape metrics or NDVI time series)

  6. Activity 2.2: Collection and processing of current and historical data (3/3) according to the DOW document • Process data for sea level monitoring and mapping sea bed morphometry: • … maps • Process data for monitoring marine quality and ecosystem parameters: • Time series analysis (if available in test sites) • maps • Chl-a (from MERIS or MODIS), TSM (from MERIS), SST (from MODIS)

  7. Workflow AUTh BEC DDNI OBIBSS Collection of Project Data (tables, grids, shapefiles) Design & Development of Geodatabase

  8. Technical Specifications • Microsoft SQL-Server • Efficient • Minimum downtime • Single-file database • ESRI ArcGIS Server v10 – ArcSDE • Allows data re-projection • Easy import of Shapefiles • Easy import of tables (XLS) • ArcMap is used to define how the data will appear on the web-GIS • ArcGIS Server exposes data using REST Services, which are easy to consume

  9. Geodatabase Capabilities • Update Capabilities • Our database supports the update of existing tables in terms of data but not structure • Web Capabilities • Our database may queried over the internet using the ArcGIS Server REST Services • Processing and search capabilities • Our database supports search and query capabilities, but remote users will not have the capability of adding new data or altering/deleting existing data

  10. Geodatabase Environmental Data Remote Sensing Data Mean Sea Level and Bathymetry Data Basic Cartographic Basis Data Types & Data Integration Environmental Data Remote Sensing Data Mean Sea Level and Bathymetry Data Basic Cartographic Basis All data referenced in a common Coordinate Reference System: Converted to a webGIS compliant data format: World Geodetic System 1984 (WGS84) Shapefiles and Raster Images

  11. Data Collection Partner AUTh: Data Contribution (1/8) • Mean Sea Level Models • - Resolutions 1 arcmin and 5 arcmin • Tide Gauge Stations • - Station List • - Measurements • Digital Topography and Bathymetry Models • - Resolutions 30 arcsec, 5 arcmin

  12. Data Collection Partner AUTh: Data Contribution (2/8) • Chlorophyll-a concentration • - For Thermaikos Gulf (29/3/2010) • Outline of the watershed of rivers Axios-Loudias-Aliakmon

  13. Data Collection Partner AUTh: Data Contribution (3/8) • Outline of the protected area according to the European Natura 2000 Network (version 28 for Greece) • Outline of the protected area according to the Ramsar Convention for Wetlands of International Importance

  14. Data Collection Partner AUTh: Data Contribution (4/8) • Land cover map from SPOT 5 image classification acquired in August 2004 • Location of pole and long-line mussel farms

  15. Data Collection Partner AUTh: Data Contribution (5/8) • Land cover map from SPOT image classification acquired in August 1994 • Major changes of land cover map between 1994-2004 from SPOT

  16. Data Collection Partner AUTh: Data Contribution (6/8) • Seasonal change of surface water extents in 2005 • Change of surface water level (low tide) within 10years, from 1994 to 2004

  17. Data Collection Partner AUTh: Data Contribution (7/8) • Locations of in-situ vegetation identification • The habitats map updated from satellite images of 2004

  18. Data Collection Partner AUTh: Data Contribution (8/8) • Total Suspended Matter concentration in Thermaikos Gulf on the 22th of March 2010.

  19. Data Collection Partner BEC: Data Contribution • Location of water quality monitoring stations (in situ measurements) (Ministry of Agriculture) Physiochemical • Location of water quality monitoring (in situ measurements) (BEC) Physiochemical, Phytoplankton, Macrophytes – Angiosperms, Invertebrates

  20. Data Collection Partner DDNI: Data Contribution (1/3) • Location of water quality monitoring stations (in situ measurements) (DDNI) Physiochemical • Table of class limits for physiochemical parameters

  21. Data Collection Partner DDNI: Data Contribution (2/3) • Grids of physiochemical parameters for specific dates EC, MTS, Ntotal, N-NH4, N-NO2, N-NO3, O2, Ptotal, SiO2, T, Transparency EC for October 2005 220 grids for different parameters over different monthly periods

  22. Data Collection Partner DDNI: Data Contribution (3/3) • Fish species collection sites in Danube Delta (2009-2011)

  23. Data Collection Partner OBIBSS: Data Contribution (1/4 ) • Danube Delta Bivalves Population measurement stations • Danube Delta Hydrological parameters measurement stations

  24. Data Collection Partner OBIBSS: Data Contribution (2/4 ) • Danube Delta Chlorophyll measurement stations • Danube Delta Macrophytes measurement stations

  25. Data Collection Partner OBIBSS: Data Contribution (3/4 ) • Danube Delta Macrozoobenthos measurement stations • Danube Delta Meiobenthos measurement stations

  26. Data Collection Partner OBIBSS: Data Contribution (4/4 ) • Danube Delta Phytoplankton measurement stations • Danube Delta Zooplankton measurement stations

  27. Data Collection Basic Cartographic Breadboard • Street and satellite imagery from ESRI

  28. Part B - General Information GA2 -Geodatabase development and data collection Partners Involved: All apart from DAV & DAMT Deliverable 2.3: Components Operation Report, evaluating the system components testing (40 pages) Responsible for submission to LP: Aleksandrov and Grigoriadis Deadline for submission: 30/11/2012

  29. Activity 2.4: Testing of system components and geodatabase in test sites according to the DOW document • Evaluation of the geodatabase and the system components in the test sites under real situations: • Level of functionality? • Test the update capabilities of the geodatabase. • Test the usage of the geodatabase’s data into the sites. • Test the queries options of the geodatabase. • Error and bug report • Functionality report

  30. Workflow AUTh BEC DDNI OBIBSS Collection of Test data Validation and update of the data included in the Geodatabase (update where possible)

  31. Collection of Test data • Data not already included in the geodatabase • Data acquired from in-situ measurements or other sources for our test-sites • It is preferable that new data are compatible with existing data included in the Geodatabase • (format, units, quantities, etc.)

  32. Geodatabase Validation and Update • Comparisons of existing data in the Geodatabase with the newly collected data or data originating from other sources • Update of the Geodatabase through a web-interface that will be developed • (only for compatible data and for certain types)

  33. Partners Checklist for D2.3 (1/2) • Collect data • Process data • Perform validation (e.g. comparisons) of data that were incorporated into the geodatabase • Upload the processed data to the project FTP • Inform the responsible persons for submission • Submit a document containing a detailed description of a) the data, b) the processing and c) the validation (statistics, figures, etc.)

  34. Partners Checklist for D2.3 (2/2) • After all partners submit their contribution, these will be incorporated into the Deliverable, which will be circulated for review Deadline for submitting your contribution 15 November 2012 ! Please include any information on proprietary rights of the submitted data if there is a change !

  35. Thank you for your attention

More Related