Transcript Slide 1

NRCan
Groundwater
Program
Geospatial Information
Interoperability in the Canadian
Groundwater Information Network
Boyan Brodaric
Eric Boisvert
Geological Survey of Canada
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
1
NRCan
Groundwater
Context
Program
Section 7.3: Improved
Access to Groundwater
Data and Information
 Web access to GW data
 National framework for
connecting GW databases
 Analysis and modeling
tools for decision-making
 Education, outreach and
aid to regional agencies
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
2
NRCan
Groundwater
GW data in Canada
Program
 Distributed, Uncoordinated
Federal depts, Provincial depts,
Municipalities, Watershed authorities
 Heterogeneous
Data content, structure, systems (sensors, dbs)
 Moderate volume
few aquifers (~30 key)
moderate number of water-well records (~1Ms)
much time-indexed data for readings
 Variable quality
Completeness, consistency, location
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
3
NRCan
Groundwater
GW data in Canada
Program
 Ontario & Quebec
heterogeneity in water-well data
Quebec lithology
Ontario lithology
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
4
NRCan
Groundwater
Approach
Program
 Groundwater Information Network
Collaboration of NRCan and 6 provinces (BC, AB, MB, ON, QC, NS)
Seamless access to GW information
Start with linked water well databases
 Principles
Distributed: data stays with owners
Seamless: acts as one virtual database
Multi-access: multiple portals, tools
Standards-based: use nat’l & int’l standards
e.g. Groundwater ML (GWML)
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
5
Approach: interoperability
NRCan
Groundwater
Program
 Overcome levels of heterogeneity
pragmatic
GW Practices (data usage)
semantic
GW Ontology (data content)
schema
GWML (data structure)
Hydrogeology
OpenGIS
syntax
GML (data language)
system
WFS, WMS,… (data systems)
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
6
NRCan
Groundwater
Approach
Program
 Groundwater Information Network
Applications
GIN Panorama:
3D, analysis
GML
WMS, WFS, (SOS)
GIN PX:
2D, download
GWML
Data Pipeline
Mediator
Standard web services
Standard
themes, layers,
lithology
GWML
GML-BC
GML-AB
GML-MB
GML-ON
GML-QC
GML-NS
NRCan
BC
AB
MB
ON
QC
NS
GML
WMS, WFS, (SOS)
Data
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
7
NRCan
Groundwater
Mediator architectures
Program
 translate query (globallocal)
 distribute query
 integrate results
 distribute results
 translate results (localglobal)
Wrapper
global
ON
“find all water wells with
unconsolidated materials”
<RockMaterial>
<geneticCategory>
<CGI_TermValue>
<value…>Sedimentary</value>
</CGI_TermValue>
</geneticCategory>
<lithology>
…
<name…>Sand</name>
</lithology>
sand
Mediator
local
global
Wrapper
clay
soil
QC
global
SABL
ARGL
TERR
local
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
8
NRCan
Groundwater
GIN Mediator architecture
 receive & translate query
 distribute query
 receive results
 translate & integrate results
 distribute results
Program
WFS/WMS
ON
“find all water wells with
unconsolidated material”
WFS/WMS
Mediator
global
sand
clay
soil
local
WFS/WMS
<RockMaterial>
<geneticCategory>
<CGI_TermValue>
<value…>Sedimentary</value>
</CGI_TermValue>
</geneticCategory>
<lithology>
…
<name…>Sand</name>
</lithology>
QC
local
SABL
ARGL
TERR
local
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
9
GIN translation of results
Lithology
ON
Sand
QC
Sand
syntactic
schematic
semantic
GIN simple lithology ontology
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
10
NRCan
Groundwater
Program
GWML
<lithology>
…
<name…>Sand</name>
</lithoogy>
NRCan
Groundwater
Semantics
Program
 GIN lithology ontology (subset of GeoSciML)
 language-neutral concepts (URN), multi-lingual terms, defs
- concept = urn:x-ngwd:vocabulary:gin:2c
- terms = “sand” (English), “sable” (French)
- definition =
 enables: multi-lingual query and data download
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
11
NRCan
Groundwater
Semantic mapping
Program
 Semantic mapping
LAV: local terms mapped to global concepts
mapping specification: XML file (moving to OWL)
conflates equivalent and subclass mapping, ignores disjoint and overlap
 ON ‘sand’ mapping
<map:rule
<map:rule
<map:rule
<map:rule
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
local="Sand" />
local="sand" />
local="sadn" />
local="sad" />
<map:rule
<map:rule
<map:rule
<map:rule
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
local="Fine Sand" />
local="medium fine sand" />
local="Medium Sand" />
local="Coarse Sand" />
<map:rule
<map:rule
<map:rule
<map:rule
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
global="urn:x-ngwd:vocabulary:gin:2c"
local="Sandy" />
local="Ssandy" />
local="sand silt" />
local="Quicksand" />
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
12
NRCan
Groundwater
Schema mapping
Program
 Schema mapping
LAV: local schema mapped to global schema
mapping specification: modified GWML data file
<gsml:lithology>
<gsml:ControlledConcept>
<gsml:identifier>ont:geostratumlog/ont:GeologyStratum/ont:material_1</gsml:identifier>
<gsml:identifier>ont:geostratumlog/ont:GeologyStratum/ont:material_2</gsml:identifier>
<gsml:identifier>ont:geostratumlog/ont:GeologyStratum/ont:material_3</gsml:identifier>
</gsml:ControlledConcept>
</gsml:lithology>
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
13
NRCan
Groundwater
GWML example
Program
standard
structure
standard
<gsml:lithology>
content
<gsml:ControlledConcept gml:id="gin.cc.2d-2">
<gsml:identifier codeSpace="urn:ietf:rfc:2141">urn:x-ngwd:vocabulary:gin:2d-2"</gsml:identifier>
<gsml:name codeSpace="urn:x-ngwd:classifierScheme:GIN:Lithology:2008" xml:lang="fr">Argile</gsml:name>
<gsml:name codeSpace="urn:x-ngwd:classifierScheme:GIN:Lithology:2008" xml:lang="eng">Clay</gsml:name>
<gml:description>A naturally occurring material composed primarily of fine-grained minerals.
It is generally plastic at appropriate water contents and will harden when
dried of fired (Neuendorf et al. 2005)</gml:description>
</gsml:lithology>
<gsml:material>
<gsml:UnconsolidatedMaterial>
<gsml:consolidationDegree>
<gsml:CGI_TermValue>
<gsml:value codeSpace="urn:cgi:classifierScheme:BGS:consolidationTerms">UNCONSOLIDATED</gsml:value>
</gsml:CGI_TermValue>
</gsml:consolidationDegree>
<gsml:physicalProperty>
<gwml:HydrogeologicDescription>
<gwml:hydraulicConductivity>
<gsml:CGI_NumericValue>
<gsml:qualifier>approximate</gsml:qualifier>
<gsml:principalValue uom="y_K_md-1">0.001</gsml:principalValue>
</gsml:CGI_NumericValue>
</gwml:hydraulicConductivity>
</gwml:HydrogeologicDescription>
</gsml:physicalProperty>
</gsml:UnconsolidatedMaterial>
</gsml:material>
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
14
NRCan
Groundwater
GWML scope
Program
wells observations
reservoirs
water water properties water budget ,aquifers
class Aquifers
class Groundw aterProperty
class Water
«DataType»
WaterPropertyDescription
«Type»
EarthMaterial::EarthMaterial
+
class WaterWell
+
+
color: CGI_Te rmValue [0..*]
«DataType»
«DataType»
GeologicUnit::PhysicalDescription
GeologicFeature
Borehole::BoreholeDetails
+physicalProperty
«FeatureTyp...
GeologicUnit::
GeologicUnit
metadata: MD_M etadata [0..1]
validityTime: TM_GeometricPrimitive [0..1]
«FeatureType»
«FeatureType»
samplingManifold::
SamplingPoint
+containedUnit
1
+part
process::Process
«DataType»
GeologicUnit::
Geologic UnitPart
«DataType»
0..*
GeologicUnit
+components
«Type»
qualityTopic:
CGI_Term
+
compositionCategory: ControlledConcept [0..1]
+
«Type»
WaterCompositionComponent«DataType»
WellConstruction:: +construction +
+
0..*
+
+
+
0..1 +
wellPurpose: WellUse [0..*]
wellStatus: CGI_Term
waterUse: CGI_Term [0..*]
wellDepth: CGI_Numeric
wellType: CGI_Term
referenceElevation: Measurement
WellConstruction
1. .* «estimatedProperty»
+ concentration: CGI_Numeric
Water
«estimatedProperty»
+ qualityAssessme nt: CGI_Value
waterType: WaterType
+indexData
«DataType»
Citation and responsible party information::
WaterPropertyDescription
CI_ResponsibleParty
«DataType»
{n}
0..*
+contact
Hydrogeologic Properties::
«Type»
BiologicComponent
«ObjectType»
AtmosphericWater
«Type»
Colloidal Component
Biomas sWater
Surfac eWater
UndergroundWater
+ saturation: CGI_Term [0..1]
«ObjectType»
DistributionWater
«FeatureTyp...
Aquiclude
ISO 19136 Annex D.3::
+ mediaType: Aq uiferMediaType
«Type»
AnyFeature
«Type»
Dissolv edComponent
+«ObjectType»
organism: Organism «ObjectType»
+ colloid: ControlledConcept
«Type»
«FeatureType»
Aquifer
«FeatureType»
+
EarthMaterial
«Type»
Salinity
+
mineralName: ControlledConcept [1..*]
«Type»
Sa lt
+
+
salinitySource: ControlledConcept [0..*]
«Type»
Groundw ater
chemicalFormula: CGI_Term [0..1]
«ObjectType»
TensionWater
suspendedMaterial: ControlledConcept
0..*
+
«FeatureType»
+
«FeatureType»
«FeatureType»
+dissolved «Enumeratio...
0. .1
GeologicFeature::MappedFeature
+
Unconfine
dAquifer
ConfinedAquifer
AquiferMediaType
«Union»
+metadata +
+ observationMethod: CGI_TermValue [1..*]
+ confinementLevel: CGI_Value
SolutionComponent
+
«enum»
+ positionalAccuracy: CGI_Value
0..1 +
porous ControlledConcept
+ dissolvedChemical:
+
fractured
+ dissolvedSalt:
Salt
constraints
+
mixed
{self.metadata.hierarchyLevel=(feature or dataset or series)}
+
{self.shape contained in samplingFrame.shape}
+
«FeatureTyp...
ArtesianAquifer
+
Interoperability in GIN
+
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
0..1
0..*
WaterPropertyDescription
«DataType»
Hydrogeologic Properties::
Metadata entity set information::MD_Metadata
WaterQualityDescription
+mappedInterval
«Type»
EarthMateri al::Mineral
WaterQuantityDescription
+ contactInfo[0..1]:
CI_Contact
+ individualName[0..1]: CharacterString
«estimatedProperty»
+ organisationName[0..1]: CharacterString
+ piezometricSurface: CV_Coverage [1..*]
+ positionName[0..1]: CharacterString
+ specificYield: CGI_Numeric [0..1]
role: CI_RoleCode
+ +transmissivity:
CGI_Numeric [0..1]
+waterQuality
+metadata
SuspendedComponent
0..*
+ volume: CGI_Numeric [0..1]
+groundwaterAccessFeature
«FeatureTyp...
Aquitard
«DataType»
«estimatedProperty»
+ capacity:WellBoreholeDetails
CGI_ Numeric [0..1]
+ hydraulicConductivity: CGI_Numeric [0..1]
+ drillingFluid:
CGI_Term
[0..1]
+ storativity:
CGI_Numeric
[0..1]
«FeatureType»
WaterWell +waterQuantity
«FeatureType»
HydroStratigraphicUnit1..*
«DataType»
WaterCompositi onDescription
Hydrogeologic Properties::
HydrogeologicDescription
0..*
+member
+ constrain: Geo logicConstrain
+
«FeatureTyp...
AquiferSystem
«DataType»
«estimatedProperty»
+wellDevelopment
«FeatureType»
+ proportion: CGI_Value WaterAgeDescription
HydrogeologicUnit
«estimatedProperty»
«estimatedProperty» «FeatureTyp...
+ piezometricSurface: CV_Coverage [1..*]
+ periodOfResidence: TM _PeriodDuration [0..1]
WellField
+ specificYield: CGI_Numeric [0..1]
+ waterAge: GeologicEvent [0..1]
+ transmissivity: CGI_Numeric [0..1]
«DataType»
+partOf
+ volume: CGI_Numeric [0..1]
HydrogeologicUnitPart
«Type» WaterQualityDescription
EarthMaterial::
+ normComplianceResul t: CGI_Term [0..1]
InorganicFluid
+ normDocumentation: CI_Citation [0..1]
«DataType»
Qualitativ eQual ityDescription
+ position: GM_Point
0..*
+ role: ScopedName
«DataType»
WaterQuantityDescription
«estimatedProperty»
+ dateOfDrilling:
TM_CalDate
+ density: CGI_ Numeric [0..1]
+ 0..*
driller: CI_ResponsibleParty [0..1]
+ magneticSusceptibility: CGI_Value [0..1]
+ drillingMethod:
BoreholeDrillingMethodCode
+ permeability:
CGI_Value [0..1]
+ inclinationType:
= vertical
+ porosity: BoreholeInclinationCode
CGI_Value [0..1]
+ nominalDiameter: Measure [0..1]
+ operator: CI_ResponsibleParty [0..1]
+ startPoint: BoreholeStartPointCode
+ coredInterval: GM_Envelope [0..*]
+ coreCustodian: CI_ResponsibleParty
[0..1]
«Type»
15
{n}
+ normComplianceResul t: CGI_Term [0..1]
characterSet[0..1]:
MD_CharacterSetCode
= "utf8" [0..1]
+ normDocumentation:
CI_Citation
contact[1..*]: CI_ResponsibleParty
dataSet[0..1]: CharacterString
dateStam p: Date
fileIdentifier[0..1]: CharacterString
hierarchyLevel[0..*]: M D_ScopeCode = "dataset"
hierarchyLevelName[0..*]: CharacterString
language[0..1]: CharacterString
locale[0..*]: PT_Locale
metadataStandardName[0..1]: CharacterString
metadataStandardVersion[0..1]: CharacterString
parentIdentifier[0..1]: CharacterString
NRCan
Groundwater
GWML lineage
Program
 parts of GWML extend GeoSciML, O&M
GeologicUnit
class Gw ml_main
class Gw ml_main
«FeatureTyp...
Geologi cUnit::
GeologicUnit
0..*
+
1
GeologicUnit
«FeatureType»
HydrogeologicUnit::
HydroStratigraphicUnit
«FeatureType»
Hydrogeologic Unit::Aquifer
mediaType: Aq uiferMediaType
role: ScopedName
«DataType»
HydrogeologicUnit::
HydrogeologicUnitPart
+
class Gw Observ ations
+
«FeatureType»
observ ation::Observ ation
«T ype»
EarthMaterial::
Inorgan icFluid
«DataType»
GeologicUnit::PhysicalDescription
«T ype»
Water::Water
«estimatedProperty»
+ density: CGI_ Numeric [0..1]
+ magneticSusceptibility: CGI_Value [0..1]
+ porosity: CGI_Value [0..1]
+ permeability: CGI_Value [0..1]
«estimatedProperty»
+ proportion: CGI_Value
+containedUnit
«FeatureType»
HydrogeologicUnit::
HydrogeologicUnit
class MaterialProperty
Observation
EarthMaterial
«DataType»
Geologi cUnit::
Geologic UnitPart
+part
GeologicFeature
+
EarthMaterial PhysicalDescription
waterT ype: WaterT ype
+
+
+
+
+
metadata: MD_Metadata [0..1]
samplingTime: TM_Object
resultTime: TM_Object [0..1]
parameter: Any [0..*]
resultQuality: DQ_Element [0..1]
constrain: Geo logicConstrain
«T ype»
Water::
Undergro undWater
«T ype»
Water::
Ground w ater
«FeatureType»
observ ationSpecializations::
Measur ement
«Type»
HydrogeologicDescription
«estimatedProperty»
+ hydraulicConductivity: CGI_Numeric [0..1]
+ storativity: CGI_Numeric [0..1]
+ capacity: CGI_ Numeric [0..1]
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
16
«FeatureType»
WaterQuantity::WaterLev el
+
elevation: CGI_Value
NRCan
Groundwater
GIN Example
Program
 Performance (4 provs)
50 wells = 3 secs
500 wells = 16 secs
5000 wells = 134 secs (2:14 min)
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
17
GIN Main Site: www.gw-info.net
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
18
NRCan
Groundwater
Program
NRCan
Groundwater
GIN PX Portal
<gsml:lithology>
Program
GWML
<gsml:ControlledConcept gml:id="gin.cc.2d-2">
<gsml:identifier codeSpace="urn:ietf:rfc:2141">urn:xngwd:vocabulary:gin:2d-2"</gsml:identifier>
<gsml:name codeSpace="urn:xngwd:classifierScheme:GIN:Lithology:2008" xml:lang="fr">Argile</gsml:name>
<gsml:name codeSpace="urn:xngwd:classifierScheme:GIN:Lithology:2008"
xml:lang="eng">Clay</gsml:name>
<gml:description>A naturally occurring material composed primarily
of fine-grained minerals.
It is generally plastic at appropriate
water contents and will harden when
dried of fired (Neuendorf et al.
2005)</gml:description>
</gsml:lithology>
<gsml:material>
<gsml:UnconsolidatedMaterial>
<gsml:consolidationDegree>
<gsml:CGI_TermValue>
<gsml:value
codeSpace="urn:cgi:classifierScheme:BGS:consolidationTerms">UNCONSOLI
DATED</gsml:value>
</gsml:CGI_TermValue>
</gsml:consolidationDegree>
<gsml:physicalProperty>
<gwml:HydrogeologicDescription>
<gwml:hydraulicConductivity>
<gsml:CGI_NumericValue>
<gsml:qualifier>approximate</gsml:qualifier>
<gsml:principalValue uom="y_K_md1">0.001</gsml:principalValue>
</gsml:CGI_NumericValue>
</gwml:hydraulicConductivity>
</gwml:HydrogeologicDescription>
</gsml:physicalProperty>
</gsml:UnconsolidatedMaterial>
</gsml:material>
Google Earth
Excel
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
19
GIN Panorama portal
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
20
NRCan
Groundwater
Program
NRCan
Groundwater
Next Steps
Program
 More geographic coverage
other Canadian partners
 Higher quality data
time-indexed data: water levels, flow rates, quality
 More types of data
aquifers, geology, 3D,…
 More tools
3D Modeling,…
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
21
NRCan
Groundwater
Conclusions
Program
 Hydrogeologic data interoperability achieved
for water well information
 Dynamic mediation effective and efficient
modest data volumes are realistic within wait-times
 GIN is live since March 2009
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
22
NRCan
Groundwater
URLs
Program
 Groundwater Information Network (GIN)
www.gw-info.net
 Groundwater Markup Language (GWML)
http://ngwd-bdnes.cits.rncan.gc.ca/gwml
Thank you!
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
23
NRCan
Groundwater
Program
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
24
Mediator implementation
 Open source
Cocoon, Java, SAX, XML, XSLT
 Re-usable
Customizable: plug and play data sources and mappings
 Efficient
Multi-threaded, parallel, cached data stream
 Tested
GIN, GeoSciML Testbed, OneGeology
 Freely available
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
25
NRCan
Groundwater
Program
NRCan
Groundwater
GIN demo
Program
demo
Interoperability in GIN
B. Brodaric, E.Boisvert
OGC TC Meeting, Boston, June 22, 2009
26