1 / 16

Enhancing Groundwater Information Interoperability Using NADM-H2O

Learn how NADM-H2O extends interoperability for groundwater data, addressing database challenges and future standards in decision support systems.

cmullis
Download Presentation

Enhancing Groundwater Information Interoperability Using NADM-H2O

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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)

  2. Importance of groundwaterinformation interoperability • NGWD (National Groundwater Database) • RésEau (Water information Network – EC) • PATHWAYS (decision making for sustainable development)

  3. 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

  4. Problem : Database structure • Most of data held in provinces • Different structures,syntax,purpose Québec New Brunswick

  5. 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

  6. 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)

  7. GSC Translation WxS Common GML internet client Prov WxS Common GML Translation Common GML internet Etc. Translation WxS OGC interoperability

  8. 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 !)

  9. H2O = NADM (Geology) • CGI (Observation model) • NGWD + PATHWAYS (ESS projects) • RésEau (Water quality – ongoing)

  10. 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

  11. NadmC1:: GeologicUnit +hostedIn HydrogeologicUnit Aquifer

  12. Wrapper schematics (transformation) Client REQUEST=GetFeature&BBOX=-72,45,-71,46 WFS Wrapper SELECT NO,DOSSIER,ANNEE WHERE LONG83 > -72 AND LONG83 < -71…

  13. Wrapper schematics (transformation) Client WFS Wrapper Serializer C#,Java,ASP.NET, ColdFusion or some guy typing really fast

  14. 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

  15. Future directions • National groundwater interchange standards • replace 1992 standard (no-so-standard) • Work on a translation mechanism • PATHWAYS “Query rewrite”

  16. Questions ?

More Related