160 likes | 342 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).
E N D
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 • ESRI • Oracle • PostGres • mySQLAccess Client Sk NGWD Pathways BC RésEau NB
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 <xml/> <xml/> <xml/> <xml/> <xml/> Eric <xml/> <xml/> <xml/> <xml/> I’m not a warehouse (but I’m still a data alligator)
GSC Translation WxS Common GML internet client Prov WxS Common GML Translation Common GML internet Etc. Translation WxS OGC interoperability
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)
XMML (O&M) CGI Feature XSA::Site XCV::Log tags +log XSA::Section XSD = XSDchoice 0..* + begin: Point + end: Point + length: Measure [0..1] XBH::Borehole + collarDiameter: Measure +hostedIn HydrogeologicUnit HydrogeologicProperty Water WaterWell Aquifer UndergroundWater WaterBudget WaterQuantity WaterReservoir WaterFlowProcess +quantity +discharge 1..* +recharge NadmC1:: NADM GeologicConcept NadmC1:: EarthMaterial PW_Property NadmC1:: NadmC1:: NadmC1:: GeologicUnit InorganicFluid GeologicProperty
NadmC1:: GeologicUnit +hostedIn HydrogeologicUnit Aquifer
Wrapper schematics (transformation) Client REQUEST=GetFeature&BBOX=-72,45,-71,46 WFS Wrapper SELECT NO,DOSSIER,ANNEE WHERE LONG83 > -72 AND LONG83 < -71…
Wrapper schematics (transformation) Client WFS Wrapper 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”