nadm-h2o and h2o-gml enabling decision support by extending nadm for groundwater information...
TRANSCRIPT
NADM-H2O and H2O-GMLEnabling 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 groundwaterinformation 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•mySQLAccess
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
<xm
l/><x
ml/>
<xm
l/>
<xm
l/><x
ml/>
<xm
l/>
<xm
l/>
<xm
l/>
<xm
l/> Eric
I’m not a warehouse (but I’m still a data alligator)
OGC interoperability
client
Common
GML
Common
GML
Common GML
GSC WxS
WxSProv
Etc. WxS
internet
Translation
Translation
Translation
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)
NADMNadmC1::
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..*
CGIFeature
XSA::Site
XSA::Section
+ begin: Point+ end: Point+ length: Measure [0..1]
XBH::Borehole
+ collarDiameter: Measure
XCV::Log
tagsXSD = 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,ANNEEWHERE 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 ?