• No results found

INSPIRE and environmental reporting

N/A
N/A
Protected

Academic year: 2021

Share "INSPIRE and environmental reporting"

Copied!
27
0
0

Loading.... (view fulltext now)

Full text

(1)

INSPIRE and environmental reporting

Practical examples from

Water Framework Directive (WFD), Flood Risk Directive (FRD) and INSPIRE

(2)

Content

INSPIRE and environmental reporting

Practical examples from WFD, FRD and INSPIRE

• Target

• Target

• Initial situation and challenges

• Quo vadis INSPIRE?

• Methodology of the solution:

INSPIRE.Insight

• INSPIRE: compliance of the duty OR additional

benefits?

(3)

Legal framework

• INSPIRE

(Directive 2007/2/EC)

- establishing an Infrastructure for Spatial Information

in the European Community

- Annex I Hydrography

• Water Framework Directive - WFD

(Directive 2000/60/EC)

- enhancement of the water quality

- ecological functioning of the surface waters

- usability of the ground water

• Flood Risk Directive – FRD

(Directive 2007/60/EC)

- reduce the risks and effects of floods

(4)

Initial situation

Z u st a n d FIS OWMN T h e m a ti ca l d a ta c o ll e ct io n s D a ta p re p a ra ti o n a n d In te rf a ce s WINSTYX SALKA B e ri c h ts -m e ss st e ll e n DA M e ss te ll e n Z u st a n d DA Fisch-DB Biologie-DB E E E E E Arbeits-gewässernetz BfG-Berichts-gewässernetz

verbindl. gepl. u. umgesetzte Maßnahmen (Landesdirektionen, Landkreise) Stoffbilanz W K -S ta m m d a te n W R R L-R a u m e in h e it e n I WAVE (Trinkwasser) DA E WEHR-DB Querbau-werks-DB (Ref. 45) DA E E FIS WrV DB Komm.-abwasser DA E

Schutzgebiete Externe Daten Industrie+ Landwirtschaft E E DA DA DA I Brauchwasser (Industrie+ Landwirtschaft) Sonst. Belastungen DA WGN-SAX-INFO Surface water Quality elements Monitoring Facility Status Chemistry Status Ecology

Groundwater Related objects

Related objects

Protected areas Waste water

Protected areas D a ta p ro v id in g Status Quantity Status Chemistry D a ta d e li v e ry Discharge Discharger

Withdrawal of water Inherited burden

Withdrawal of water Inherited burden Monitoring Facilities Quality elements I I I I I Damages E I I Reports Excel/Word Mappings Reports Shapefiles Tables Reports Excel/Word Mappings I I Physical water Groundwater body Water network

Surface water body

Catchment areas Reporting objects Activities Activities (planing+ realisation) Other damages

(5)
(6)
(7)
(8)
(9)

Quo vadis INSPIRE?

INSPIRE does not support the actual work of the

environmental offices.

Not even the environmental reporting is supported.

INSPIRE III

Not even the environmental reporting is supported.

INSPIRE data models do not help to organize the Theme

Crossed harmonization of the data management.

The kind of modelling is contrary to the working method.

The models are incomprehensible.

INSPIRE is an additional duty – without practical working

(10)

Solution

Central data model

Other applications ...

WFD

FRD

Internet / Intranet

Reporting

Central data model

INSPIRE.Insight

(11)

Solution

Data management

• Thematical overlap of one consistent data model

• Data model mirrors the operating mode of the

ecological system

• Structure is neither tailored to European reporting

commitments nor to INSPIRE

commitments nor to INSPIRE

• Content of data model can be upgraded by objects

and compounds at any time

(12)

Solution

Central data model

INSPIRE.Insight

Other applications ...

WFD

FRD

(13)
(14)
(15)

Solution

Central data model

INSPIRE.Insight

Other applications ...

(16)

Solutions offered

Solution for INSPIRE III

Included in a Theme Crossed approach

Consulting for data management

Data transformation and qualifying

(17)

„Additional benefits“

standardised

thematical data, geodata

PATCHWORK (Unstructured data)

Interoperable data structures

services

decision

support

simulation

prediction

management

information

(18)

Thanks for your

Thanks for your

attention!

M.O.S.S. Computer Grafik Systeme GmbH Hohenbrunner Weg 13 D-82024 Taufkirchen Telefon +49 89 66675-100 Telefax +49 89 66675-180 http://www.moss.de

www.inspire.moss.de

(19)

• The data sets have been collected manually.

Cross-border data flow has not been built up so

this activity has to be repeated every 6 years.

• Data of WFD reportings have been allocated

unstructured and incompatible. All data

structures have been built up according to the

reporting scheme.

WGN-SAX-INFO Zu st an d Surface water Quality elements Monitoring Facility Status Chemistry Status Ecology

Groundwater Related objects

Related objects

Protected areas Waste water

Protected areas FIS OWMN T he m a ti ca l d ata c o ll ect io n s D a ta p re p a ra tio n a nd In te rf a ce s WINSTYX SALKA D a ta p ro v id in g Status Quantity Status Chemistry D a ta d e liv ery Be ric hts -m e ss st elle n DA M ess te ll en Zu st an d DA Fisch-DB Biologie-DB Discharge Discharger

Withdrawal of water Inherited burden

Withdrawal of water Inherited burden

SMUL E E E E E Monitoring Facilities Quality elements I I I I I Arbeits-gewässernetz BfG-Berichts-gewässernetz

verbindl. gepl. u. umgesetzte Maßnahmen (Landesdirektionen, Landkreise) Stoffbilanz Damages W K-S ta m m da te n W R RL-R aum e in he iten I E WAVE (Trinkwasser) DA E I WEHR-DB Querbau-werks-DB (Ref. 45) DA E E I WasserBLIcK Reports Excel/Word Mappings Reports Shapefiles Tables FGG Reports Excel/Word Mappings FIS WrV DB Komm.-abwasser DA E I Schutzgebiete I Externe Daten Industrie+ Landwirtschaft E E DA DA DA I Brauchwasser (Industrie+ Landwirtschaft) Physical water Groundwater body Water network Surface water body

Catchment areas Reporting objects Activities Activities (planing+ realisation) Other damages Sonst. Belastungen DA

Initial situation

reporting scheme.

• Often the existing water network is not usable,

because sections have been composed on

cartographical aspects but not on natural

confluences, e.g. interrupt at bridges.

• Data sets of flood prevention concepts are

available but heterogeneous.

• A common administration of activities (planned

and realised) does not exist.

(20)

Architecture

WGN-SAX-INFO 2.0

Planing and realisation of the activities Activities (planing + realisation) Reporting Selections Reporting System administration Water management Monitoring

Platform for the publicity Administrator Publicity Versioning concept Data processing Experts Stoffbilanz …..

FIS OWMN WINSTYX SALKA

Fisch-DB Biologie-DB Stoffbilanz WAVE (Trinkwasser) WEHR-DB Querbau-werks-DB (Ref. 45) FIS WrV DB Komm.-abwasser

Schutzgebiete Externe Daten zu industriellen und landwirtschaftl. Einleitern Brauchwasser (Industrie+ Landwirtschaft) Sonst. Belastungen Experts (planing + realisation) administration publicity

ETL (Extract, Transform, Load)

Protocols Web-Interfaces Stoffbilanz FIS OWMN DB-View (SQL) DB-View (SQL) DB-View (SQL) Datei-system Web Service Web Service Web Service

(21)

Environmental data management

• Complexity of tasks, all time varying

requirements

• Charge and administration of environmental

Challenges

Atmosphere (air)

Biosphere (life)

Nature/Landscape

• Charge and administration of environmental

states at fixed points of time

• Compilation of obliging planning and processing

of planning scenarios

• New given periods, requirements and special

individual prospects

Nature/Landscape

Lithosphere (soil)

(22)

Target

• FRD – Article 9

- requires a close coordination of the assessment and

management of the activities for both directives

central information system for both directives

- common data collection

- common data collection

- common data processing

- common data providing

- common data delivery

Responsible party in Saxonia:

Saxonian State Office of Environment, Agriculture and

Geology

(23)

Architecture

WGN-SAX-INFO 2.0

Planing and realisation of the activities Activities (planing + realisation) Reporting Selections Reporting System administration Water management Monitoring

Platform for the publicity Administrator Publicity Versioning concept Data processing Experts Stoffbilanz …..

FIS OWMN WINSTYX SALKA

Fisch-DB Biologie-DB Stoffbilanz WAVE (Trinkwasser) WEHR-DB Querbau-werks-DB (Ref. 45) FIS WrV DB Komm.-abwasser

Schutzgebiete Externe Daten zu industriellen und landwirtschaftl. Einleitern Brauchwasser (Industrie+ Landwirtschaft) Sonst. Belastungen Experts (planing + realisation) administration publicity

ETL (Extract, Transform, Load)

Protocols Web-Interfaces Stoffbilanz FIS OWMN DB-View (SQL) DB-View (SQL) DB-View (SQL) Datei-system Web Service Web Service Web Service

(24)
(25)
(26)

Architecture

WGN-SAX-INFO 2.0

Planing and realisation of the activities Activities (planing + realisation) Reporting Selections Reporting System administration Water management Monitoring

Platform for the publicity Administrator Publicity Versioning concept Data processing Experts Stoffbilanz …..

FIS OWMN WINSTYX SALKA

Fisch-DB Biologie-DB Stoffbilanz WAVE (Trinkwasser) WEHR-DB Querbau-werks-DB (Ref. 45) FIS WrV DB Komm.-abwasser

Schutzgebiete Externe Daten zu industriellen und landwirtschaftl. Einleitern Brauchwasser (Industrie+ Landwirtschaft) Sonst. Belastungen Experts (planing + realisation) administration publicity

ETL (Extract, Transform, Load)

Protocols Web-Interfaces Stoffbilanz FIS OWMN DB-View (SQL) DB-View (SQL) DB-View (SQL) Datei-system Web Service Web Service Web Service

(27)

Architecture

WGN-SAX-INFO 2.0

Planing and realisation of the activities Activities (planing + realisation) Reporting Selections Reporting System administration Water management Monitoring

Platform for the publicity Administrator Publicity Versioning concept Data processing Experts Stoffbilanz …..

FIS OWMN WINSTYX SALKA

Fisch-DB Biologie-DB Stoffbilanz WAVE (Trinkwasser) WEHR-DB Querbau-werks-DB (Ref. 45) FIS WrV DB Komm.-abwasser

Schutzgebiete Externe Daten zu industriellen und landwirtschaftl. Einleitern Brauchwasser (Industrie+ Landwirtschaft) Sonst. Belastungen Experts (planing + realisation) administration publicity

ETL (Extract, Transform, Load)

Protocols Web-Interfaces Stoffbilanz FIS OWMN DB-View (SQL) DB-View (SQL) DB-View (SQL) Datei-system Web Service Web Service Web Service

References

Related documents

With Maximizer CRM’s wizard-driven dashboards, library of Excel Reports and more than 175 out-of-the-box Crystal Reports ®1 and Microsoft ® SQL Server Reporting Services

Design Reports using Reporting Services Design Reports by using Report Builder Implement Excel Pivot Tables and Charts Use Excel as a Data Mining Client. Review Microsoft

Microsoft Excel and PowerPivot for Excel are suitable options for business reporting – particularly if collaboration is required when authoring/sharing reports, but the Report

Microsoft Excel, PowerPoint, and Word files can become live repositories of scorecards, reports, charts, Pivot Tables, and Pivot Charts, all of which are always linked back

I. Navigating in the Reports Module ... Accessing the Reports Module... Navigating Across Folders ... Accessing MS Excel or PDF Versions of Reports ... Modifying Reports ...

Lesson 7: Reporting on Excel Data with Crystal Reports Topic 7A: Create a Report Based on Excel Data Topic 7B: Modify a Report Generated from Excel Data Topic 7C: Update Data in

Power BI • Power BI Desktop • Microsoft Excel • Mobile reports • Paginated reports DELIVER CLOUD PIN PAGINATED REPORT ITEMS SQL Server Reporting Services • Power BI Desktop

Reporting to the Business Systems Manager, the AX Reporting Developer (AXRD) will be responsible for development, optimisation and maintenance of SSRS, Excel and X++ reports for