Work package 1: Project co-ordination

Deliverables:

• D1.1 – D1.9 Periodic reports (M3, M6, M9, M12, M15, M18, M21, M24, M27)
  The progress of the work and the project co-ordination will be monitored by trimester progress reports.

Description of work:

Task 1.1 Organization of the Project Co-ordination Committee (M1).
The Progress Co-ordination Committee (PCC) will monitor the work progress and manage the project’s activities. Each partner will be represented with one participant. The meetings of the PCC’s members will take place at a frequency (at least twice a month) that guarantees quality and consistency of communication and administration across the whole project.
Task 1.2 Organization of plenary meetings (M3, M6, M9, M12, M15, M18, M21, M24, M27).
Plenary meeting will be organized every three months. Each WP leader will report the work progress and determine the necessary actions in order to accomplish the scheduled tasks. The PCC will present the whole project progress and inform the participants about the preparation and distribution of all administrative reports of the project, e.g. periodic reporting.

Work package 2: Collection, clipping, categorization of various existing data, activities and services

Deliverables:

• D2.1 Data Categorization (M3) - Outcome from Task 2.1.
• D2.2 File of categorized Data (M12) - Outcome from Task 2.4.
• D2.3 Report of implementing WP2 (M12) - A report describing the activities carried out during WP2.

Description of work:

Task 2.1 Data categorization (M1-M3)
Identifying, scoping, prioritizing and selecting data categories that will be used to best describe the studyarea.
Task 2.2 Data collecting (M1-M12)
Identifying possible sources for data collection, for example local and central authorities, statistical agencies and private databases. Collecting data in primary forms.
Task 2.3 – Data evaluation and processing (M1-M12)
Data will be analyzed and evaluated. Alternative data sources will be used, whenever available and relevant, to cross-check the gathered information.
Task 2.4 – Data file creation (M4-M12)
In this task, the final form for the digital file containing the data is decided. Data evaluated and analysed are entered in the file. At the end of the WP2, the file with the gathered data is handed to the other partners for further processing.

Work package 3: Modeling and Design of DBMS

Deliverables:

• D3.1 Design report (M6) - A report presenting the overall detailed database model.

Description of work:

Task 3.1 – Conventional data modelling (M3-M4)
Leader: GNOSIS
The required data types, operations and data relationships will be determined for non-spatial data. An appropriate relational model will be formed and normalized and appropriate access structures will be defined.
Task 3.2 – Spatial and spatiotemporal data modelling (M3-M4)
Leader: UCG
The required data types, operations and data relationships will be determined for spatial and changing spatial data. Appropriate access structures that efficiently support spatial operations will be defined.
Task 3.3 – Conventional and Spatial data models integration (M5-M6)
Leader: UCG Contributors: GNOSIS
An overall physical model will be defined that will be able to represent data purely conventional, purely spatial, or mixed and that will provide the ability of the user to define and manipulate new data categories that are likely to appear during the system life.

Work package 4: Methodology for efficient processing of complex queries

Deliverables:

• D4.1 Report on user queries (M4) - A report presenting the outcome of Task 4.1
• D4.2 Report on suitable existing techniques (M5) -A report presenting the outcome Task 4.2
• D4.3 Report on integration with the underlying DBMS (M15) - A report presenting the outcome of Task 4.5
• D4.4 Research paper on calibration of existing techniques (M6) - A paper presenting the novel calibration / extension of techniques during Task 4.2
• D4.5 Research paper on design of novel techniques (M11) - A paper presenting the novel techniques developed during Task 4.3
• D4.4 Research paper on comparative evaluation of techniques (M14) -A paper presenting the novel comparative evaluation during Task 4.4

Description of work:

Task 4.1 – Determination of user queries (M4-M4)
The queries that may be asked by users of the system, as well as, the ability to deal with queries that will arise in the future will be exhaustively studied.
Task 4.2 – Selection and calibration of existing techniques (M5-M6)
Suitable existing indexing and query processing techniques will be determined. The ones that are suitable without modification and the ones that need to be calibrated / extended will be identified and the necessary modifications will be developed.
Task 4.3 – Design of novel techniques (M7-M11)
For those queries that existing, or modified techniques are not suitable or efficient, new indexing techniques and query processing algorithms will be designed.
Task 4.4 – Implementation and comparative evaluation of techniques (M12-M14)
Existing, modified and new techniques will be implemented and evaluated using synthetic and real data, as well as, analytic method, where possible. The winning structure / algorithm will be determined, in order to be embedded to the system.
Task 4.5 – Integration of proprietary techniques with the underlying DBMS (M15)
The techniques that combine acceptable I/O, CPU and overall performance for the anticipated scale of data with simplicity will be integrated with the existing system.

Work package 5: Development of Environmental Geographical Information System

Deliverables:

• D5.1 Requirements, framework and guidelines (M8) - Outcome of Task 5.1 specifies the framework on how the EGIS is approached: the technical and socio-technical foundations and policy-level selections of standards and prior assets, and an inventory of items to be considered in the actual EGIS/Pilot production.
• D5.2 Consolidated EGIS v1.0 for post-project use (M12) - Outcome of Task 5.5 is the consolidation of all relevant project inputs to the EGIS framework, including all re-usable or re-purposable open source applications, all standards and interface definitions, all area-specific client/backend-―translators, and all relevant documentation.

Description of work:

Task 5.1 Technical and Open Innovation Requirements for the framework (M7-M8)
Identifying, scoping, prioritizing and selecting requirements and existing assets that are to be used as the basis for EGIS and its architecture. Definitions between general GIS, domain-specific and area-specific modules is made. Extra care is taken to ensure APIs are open, based on best agile, open, internet standards, and further exploitable by 3rd party developers.
Task 5.2 Production of System for pilots and first EGIS v0.1 (M9)
Collecting and consolidating of assets from D5.1, and packaging, creation and documenting of the hardware and software framework (definitions, examples and documents) for the general EGIS and guidelines for domain-specific GIS generation in environmental issues.
Task 5.3 – Environmental framework and core EGIS (M10)
Environmental-specific GIS interfaces, architectures, components and other assets are identified, selected and packaged. These include at least prior requirement work in WP 3.
Task 5.4 – Dissemination to project partners and technical support of piloting work packages (M11)
In this task, the work package leader proactively disseminates the produced material to the WP6, WP7 and WP8 partners‘ relevant personnel in an effective way. This exploits the project outcomes and developer environments delivered in work package 10. GNOSIS also gives support during the WP6, WP7 and WP8 activities, including technical help as well as possible fixes and changes to the components themselves.
Task 5.5 Consolidation of outputs from other WPs to EGIS v1.0 (M12)
Consolidation and packing of all relevant project results into a single joint package that is easily further exploitable by the developers.

Work package 6: Migration of existing data and interface with other systems

Deliverables:

• D6.1 Migration Data Plan (M17) - The outcome of Task 6.1 is the migration data plan.
• D6.2 Developed Interfaces (M18) -Various interfaces (web, mobile, etc) is the output of Task 6.2

Description of work:

Lead pilot system is used for validating the EGIS, enlarging it by open source applications, and exploiting it in a live large-scale pilot system. After the implementation this WP will undertake all steps necessary import - data transfer and migration, so that each system be brought to full operational status by focusing on creating automatic mechanisms of import - transport and data migration, since the state of application data in each environmental entity will be finalized on WP 2
Task 6.1 – Data Migration (M13-M17)
This task deals with the data migration and on the job-testing of the developed services in EGIS v1.0. After the implementation and during migration, feedback from DEPODATH and stakeholders will be taken into consideration for adapting and applying the required changes.
The EGIS will integrate available environmental data into useful applications for target group. It will incorporate environmental information on multiple levels such as location, context, situation etc.
The work developed in this task can be considered a beta-testing of the system and applications to be finally delivered. This will be demonstrated and the feedback from users and stakeholders will be documented as part of D8.1. The first version of this deliverable will report the work from this task.
SubTask 6.1.1 – Methodology and Requirements of Migration (M13)
Approach of methodology developed for migration, setting out the tasks deliverables and milestones and the organization needed on the part of the WP and the project. Special consideration given to the identified risks, the methods and tools for transport :

• Identification of objects (entities) of precession (entities) and the environment of each entity.
• Definition of information of each entity ie data evaluation and receiving, cleaning rules, cleaning the data transformations required, etc.
• Data sources (by functional area)
• Data volumes (by functional area)

SubTask 6.1.2 – Data migration and verification (M14-M17)
This subtask includes :

• The creation of transition plans, controls, procedures and manual data entry in the final environment.
• The installation of transition and control of the final operating environment.
• The performance of export and migration of data per functional area.
• Performing manual processes.
• The manual data entry.
• Carrying out checks on the data and use the software or applications of the new system.

Task 6.2 – Open source technologies identifying, assessment and interfacing (M18)
Identification of open source technologies already in use in standards and/or with potential application in pilots and especially :

• Assessment of technologies (operational risk, socio-economic user acceptance, value creation over the information, systems dynamic evolvement) across the different standards and functionalities
• EGIS specification of interfacing requirements for the different technologies
• Introduction of partners‘ prior more experimental technologies to EGIS

Work package 7: Mapping Geographic Data

Deliverables: 

• D7.1 Integrated Environmental Geographic Information System (M20) - The outcome of Task 7.3.

Description of work:

Lead Pilot integrates the EGIS, enlarges it by geographic data mapping and exploits it in a live large-scale pilot.
After the implementation this WP will undertake all steps necessary import - data transfer and migration, so that each system be brought to full operational status by focusing on creating automatic mechanisms of import - transport and data migration, since the state of application data in each environmental entity will be finalized on WP 2
Task 7.1 – Mapping Geographic Data (M14-M18)
This task deals with the geographic data mapping and on the job-testing of the developed services in EGIS
v1.0. After the data migration, contribution from DEPODATH and stakeholders is important for adapting and applying the required geographic mapping.
The EGIS will integrate available environmental mapping data into useful applications for targeted groups. It will incorporate environmental information on multiple geo-levels.
The work developed in this task can still be considered a beta-testing of the system and applications to be finally delivered. This will be demonstrated and the feedback from users and stakeholders will be documented as part of D8.1. The first version of this deliverable will report the work from this task.
Task 7.2 – Dissemination to project partners and technical support of piloting work packages (M19)
In this task, the work package leader proactively disseminates the produced material to the WP8 partners relevant personnel in an effective way. This exploits the project outcomes and developer environments delivered in work package 10. GNOSIS also gives support during the WP8 activities, including technical help as well as possible fixes and changes to the components themselves.
Task 7.3 Consolidation of outputs from other WPs to EGIS v1.1 (M20)
Consolidation and packing of all relevant project results into a single joint package that is easily further exploitable by developers.

Work package 8: Checking and testing of operation

Deliverables:

• D8.1 Report of checking and testing (M21) -A report describing the activities carried out during the WP.

Description of work:

Task 8.1 Checking and testing of operation (M21)
In this work package the leader checks and tests the operation of the Integrated Environmental Geographic Information System, the outcome of WP7.
Having in mind the information gathered in WP1, the system is checked for data continuity (mirror checking, missing links), for user-friendliness, for editing errors. Other aspects are studied as well, such as properties available (e.g. printing) and the processing of complex queries.

Work package 9: System evaluation

Deliverables:

• D9.1 Evaluation report (M22) - A report containing the results of Tasks 9.1 and 9.2.

Description of work:

Task 9.1 – Development of a questionnaire (M22)
A questionnaire will be formed to assess the usability of the system.
Task 9.2 – Results summarization and assessment (M22)
The questionnaire will be distributed to interested TCG members and the system prototype will be evaluated functionality wise.

Work package 10: Revision and sustainability of the system

Deliverables:

• D10.1 Revised GIS (M) -The outcome of Task 10.1 is the installed fully operational EGIS.
• D10.2 Sustainability Study (M) - The outcome of Task 10.2 is a sustainability study.
• D10.3 Documentation of System Use (M) - The outcome of Task 10.1 describing the EGIS operation.

Description of work:

Task 10.1 – Revision of the System (M23-M25)
Reviewing the existing EGIS against the deliverable of WP9 Evaluation Report. The observations, comments and suggestions of TCG will be incorporated and adopted in consultation
with all partners, in order to obtain the final form of the system.
Task 10.2 – Sustainability of the System (M26-M27)
To ensure the sustainability of the project, a sustainability study will be prepared which will identify and analyze all the parameters that make and substantiate the viability of the system, in order to attract and involve organizations and companies that will ensure self-financing of the project within a reasonable time. A Business Plan for the exploitation of the EGIS will be elaborated and it will be explored how intellectual property rights ownership and user rights will be protected and managed during the productive use of the EGIS.

Work package 11: Dissemination and Impact

Deliverables: 

• D11.1 Web page (initial M15, updates up to M27) – The output of Task 11.2
• D11.2 Workshops / meetings (during M15-M27) – The result of Task 11.3
• D11.3 Printed material (M17) – Prepared during Task 11.1 and extended during Task 11.3

Description of work:

Task 11.1 – Dissemination plan (M13-M14)
Leader: UCG. Contributors:All partners.
WP leader will create a common dissemination strategy and plan including partner dissemination guidelines with the help of other partners, and all partners will take part in dissemination as is planned. The dissemination strategy for the project is likely to have several phases. The first phase will be to communicate with partners, and other interested parties about the aims and activities of the project.
Task 11.2 – Web site development (M15-M27)
A website and associated social media channels presenting the project goals, services, progress and events will be created. The target of these electronic tools is to promote the project and to create a community of interested groups and potential users of the EGIS and further to develop a network across the organizations providing links between existing networks of developers and SMEs, and using the principles of open data to develop engagement across regional boundaries.
Task 11.3 – Organization of dissemination events (M17-M27)
A range of events, workshops, seminars, which the project will undertake working with the targeted groups, SMEs and other key partners will be organized. During these events, printed material related to the project outputs and the functionality of the EGIS will be dispensed.