NADM-H2O and H2O-GML

jellytrickInternet and Web Development

Nov 10, 2013 (3 years and 9 months ago)

76 views

NADM
-
H2O and H2O
-
GML

Enabling decision support by extending NADM for
groundwater information interoperability

Eric Boisvert (Geological Survey of Canada


Québec City)

Jean Brodeur (Geomatic Canada
-

Sherbrooke)

Boyan Brodaric (Geological Survey of Canada
-

Ottawa)

Importance of groundwater

information interoperability


NGWD (National Groundwater Database)


RésEau (Water information Network


EC)


PATHWAYS (decision making for sustainable
development)

National Groundwater Database


Catalog of databases


Network of databases (federal,provincial, etc.)

Qc

Sk

BC

NB


ESRI


Oracle


PostGres


mySQL

Access

NGWD

Client

Pathways

RésEau

Problem : Database structure


Most of data held in provinces


Different structures,syntax,purpose

Québec

New Brunswick

OGC standards


CGDI : Canadian Geospatial Data Infrastructure
(equivalent to USA’s NSDI)


WMS : Web Map Service


WFS : Web Feature Service


WCS : Web Coverage Service


WMC : Web Map Context


Wxx :
They keep coming


Commonality : XML

How people see me

Eric

I’m not a warehouse (but I’m still a data alligator)

OGC interoperability

client

GSC

W
x
S

W
x
S

Prov

Etc.

W
x
S

internet

internet

GML (Geographic Markup Language)


Building block


Provides common structures for all geographic
applications (geometries, projections, metadata)


Feature Model (from ISO)


GML alone is useless, just a pile of
lego

blocks


Just add your model ! (just add Water !)


H2O =

NADM (Geology)

+
CGI (Observation model)

+
NGWD + PATHWAYS (ESS projects)

+
RésEau (Water quality


ongoing)



NADM

NadmC1::

GeologicConcept

PW_Property

NadmC1::

GeologicProperty

NadmC1::

GeologicUnit

NadmC1::

EarthMaterial

NadmC1::

InorganicFluid

HydrogeologicProperty

HydrogeologicUnit

Water

Aquifer

WaterWell

WaterQuantity

UndergroundWater

WaterReservoir

WaterFlowProcess

WaterBudget

+hostedIn

+discharge

+recharge

+quantity

1..*

CGI

Feature

XSA::Site

XSA::Section

+

begin: Point

+

end: Point

+

length: Measure [0..1]

XBH::Borehole

+

collarDiameter: Measure

XCV::Log

tags

XSD = XSDchoice

0..*

+log

XMML

(O&M)

NadmC1::

GeologicUnit

HydrogeologicUnit

Aquifer

+hostedIn

Wrapper schematics (transformation)

Client

WFS

REQUEST=GetFeature&BBOX=
-
72,45,
-
71,46

Wrapper

SELECT NO,DOSSIER,ANNEE

WHERE LONG83 >
-
72 AND LONG83 <
-
71…

Client

WFS

Wrapper

Wrapper schematics (transformation)

Serializer

C#,Java,ASP.NET, ColdFusion

or some guy typing really fast

Issues


Matching the pieces


Scientific concept is one aspect, day to day
practice is another


Wrapping process


WFS filter (OGC Filter) can express complex
queries that must be translated into the local
schema

Get all wells that are deeper than 40 m and reach the
rock when this rock type is sandstone

Future directions


National groundwater interchange standards


replace 1992 standard (no
-
so
-
standard)


Work on a translation mechanism


PATHWAYS “Query rewrite”

Questions ?