deliverable 2.2 geodatabase activities 2.2 and 2.3 deliverable 2.3
DESCRIPTION
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” - PowerPoint PPT PresentationTRANSCRIPT
Development of a common intraregional monitoring system for the environmental protection and preservation of the Black
Sea ECO-Satellite
GA2: Geodatabase development and GA2: Geodatabase development and data collectiondata collection
A2.2:“Collection and processing of current & historical data”A2.2:“Collection and processing of current & historical data”A2.3:“Design and creation of the geodatabase”A2.3:“Design and creation of the geodatabase”
A2.4:“Testing of system components and geodatabase in test A2.4:“Testing of system components and geodatabase in test sites”sites”
2nd Project Meeting22-24 October 2012
Tulcea, Romania
DELIVERABLE 2.2DELIVERABLE 2.2GeodatabaseGeodatabase
Activities 2.2 and 2.3Activities 2.2 and 2.3
DELIVERABLE 2.3DELIVERABLE 2.3Components Operation Report, evaluating the Components Operation Report, evaluating the
system components testingsystem components testingActivity 2.4Activity 2.4
Outline of the presentation
AA
BB
Part A -General Information
GA2 - Geodatabase development and data collectionPartners Involved: All apart from DAV & DAMT
Year 1
1 2 3 4 February 6 7 May 9 July 11 12
Activity 2: Collection and processing of current and historical data
Start
End
Preparation Activity 2
Execution Activity 2
Activity 3: Design and creation of the geodatabase
Start
End
Execution Activity 3
Deliverable 2.2: GeodatabaseResponsible for submission to LP: Aleksandrov and GrigoriadisDeadline for submission: 31/07/2012 (submitted on time)
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
Activity 2.2: Collection and processing of current and historical data (1/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)
Activity 2.2: Collection and processing of current and historical data (2/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)
Activity 2.2: Collection and processing of current and historical data (3/3)
according to the DOW document
WorkflowWorkflow
AUTh BEC DDNI OBIBSS
Collection of Project Data(tables, grids, shapefiles)
Design & Development of Geodatabase
Technical SpecificationsTechnical 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
Geodatabase CapabilitiesGeodatabase Capabilities
Update CapabilitiesOur database supports the update of existing tables in terms of data but not structure
Web CapabilitiesOur database may queried over the internet using the ArcGIS Server REST Services
Processing and search capabilitiesOur database supports search and query capabilities, but remote users will not have the capability of adding new data or altering/deleting existing data
Data Types & Data IntegrationData Types & Data Integration
GeodatabaseGeodatabase
Environmental Data
Environmental Data
Remote Sensing Data
Remote Sensing Data
Mean Sea Level and Bathymetry
Data
Mean Sea Level and Bathymetry
Data
Basic Cartographic
Basis
Basic Cartographic
Basis
Environmental Data
Environmental Data
Remote Sensing Data
Remote Sensing Data
Mean Sea Level and Bathymetry
Data
Mean Sea Level and Bathymetry
Data
Basic Cartographic
Basis
Basic Cartographic
Basis
All data referenced in a common Coordinate Reference System:
World Geodetic System 1984 (WGS84)
Converted to a webGIS compliant data format:
Shapefiles and Raster Images
Data CollectionData 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
Data CollectionData 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
Data CollectionData 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
Data CollectionData Collection
Partner AUTh: Data Contribution (4/8)
Location of pole and long-line mussel farms
Land cover map from SPOT 5 image classification acquired in August 2004
Data CollectionData Collection
Partner AUTh: Data Contribution (5/8)
Major changes of land cover map between 1994-2004 from SPOT
Land cover map from SPOT image classification acquired in August 1994
Data CollectionData Collection
Partner AUTh: Data Contribution (6/8)
Change of surface water level (low tide) within 10years, from 1994 to 2004
Seasonal change of surface water extents in 2005
Data CollectionData Collection
Partner AUTh: Data Contribution (7/8)
The habitats map updated from satellite images of 2004
Locations of in-situ vegetation identification
Data CollectionData Collection
Partner AUTh: Data Contribution (8/8)
Total Suspended Matter concentration in Thermaikos Gulf on the 22th of March 2010.
Data CollectionData 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
Data CollectionData Collection
Partner DDNI: Data Contribution (1/3)
Table of class limits for physiochemical parameters
Location of water quality monitoring stations (in situ measurements) (DDNI)
Physiochemical
Data CollectionData Collection
Partner DDNI: Data Contribution (2/3)
Grids of physiochemical parameters for specific datesEC, MTS, Ntotal, N-NH4, N-NO2, N-NO3, O2, Ptotal, SiO2, T,
Transparency
220 grids for different parameters over different monthly periods
EC for October 2005
Data CollectionData Collection
Partner DDNI: Data Contribution (3/3)
Fish species collection sites in Danube Delta (2009-2011)
Data CollectionData Collection
Partner OBIBSS: Data Contribution (1/4 )
Danube Delta Bivalves Population measurement stations
Danube Delta Hydrological parameters measurement stations
Data CollectionData Collection
Partner OBIBSS: Data Contribution (2/4 )
Danube Delta Chlorophyll measurement stations
Danube Delta Macrophytes measurement stations
Data CollectionData Collection
Partner OBIBSS: Data Contribution (3/4 )
Danube Delta Macrozoobenthos measurement stations
Danube Delta Meiobenthos measurement stations
Data CollectionData Collection
Partner OBIBSS: Data Contribution (4/4 )
Danube Delta Phytoplankton measurement stations
Danube Delta Zooplankton measurement stations
Data CollectionData Collection
Basic Cartographic Breadboard
Street and satellite imagery from ESRI
Part B - General Information
GA2 - Geodatabase development and data collectionPartners Involved: All apart from DAV & DAMT
Year 1 Year 2
6 7 8 9 June 10 11 12 1 November 3 4
Activity 4: Testing of system components and geodatabase in test sites
Start
End
Preparation Activity 2
Execution Activity 2
Deliverable 2.3: Components Operation Report, evaluating the system components testing (40 pages)
Responsible for submission to LP: Aleksandrov and GrigoriadisDeadline for submission: 30/11/2012
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
Activity 2.4: Testing of system components and geodatabase in test sites
according to the DOW document
WorkflowWorkflow
AUTh BEC DDNI OBIBSS
Collection of Test data
Validation and update of the data included in the Geodatabase (update where possible)
Collection of Test dataCollection 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.)
Geodatabase Validation and UpdateGeodatabase 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)
Partners Checklist for D2.3 (1/2)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.)
Partners Checklist for D2.3 (2/2)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
Please include any information on proprietary rights of the submitted data if there is a change
!
! Deadline for submitting your contribution15 November 2012
Thank you for your attentionThank you for your attention