Data Dictionary for INSPIRE Geology Theme

The geodatabase template for Geology implements the INSPIRE Geology and hydrogeology application schema within the Geology theme.

To view the geodatabase model diagram, please refer to GE_model.pdf and GEHG_model.pdf.


Feature Datasets and Feature Classes

GE - Feature Dataset

geBorehole
geDownholeGeometry
geFaultL
geFoldL
geGeomorphL
geGeomorphP
geGeomorphS
geMappedInterval
geUnitL
geUnitP
geUnitS
hgActiveWellP
hgAquicludeS
hgAquiferS
hgAquiferSystemS
hgAquitardS
hgGroundwaterbodyS
hgHyGeObjNaturalP


Tables

geCollectionAndMappedFeature
geCompositionPart
geEventAndFeature
geEventProcess
geFault
geFold
geGeologicCollection
geGeologicEvent
geGeomorph
geThematicClass
geThemeAndFeature
geUnit
hgAquiclude
hgAquifer
hgAquiferSystem
hgAquitard
hgAquitardAquifer
hgGwbd2ActiveWell
hgGwbdS_EMF
hgHGUnitGeStructure


Relationship Classes

geBorehole_CollectionAndMappedFeature
geBorehole_DownholeGeometry
geBorehole_MappedInterval
geCollection_CollectionAndMappedFeature
geEvent_EventAndFeature
geFault_EventAndFeature
geFault_FaultL
geFault_ThemeAndFeature
geFaultL_CollectionAndMappedFeature
geFold_EventAndFeature
geFold_FoldL
geFold_ThemeAndFeature
geFoldL_CollectionAndMappedFeature
geGeolEvent_eventProcess
geGeomorph_EventAndFeature
geGeomorph_geomorphL
geGeomorph_GeomorphP
geGeomorph_GeomorphS
geGeomorph_ThemeAndFeature
geGeomorphL_CollectionAndMappedFeature
geGeomorphP_CollectionAndMappedFeature
geGeomorphS_CollectionAndMappedFeature
geThematicClass_ThemeAndFeature
geUnit_Composition
geUnit_EventAndFeature
geUnit_geThemeAndFeature
geUnit_MappedInterval
geUnit_UnitL
geUnit_UnitP
geUnit_UnitS
geUnitL_CollectionAndMappedFeature
geUnitP_CollectionAndMappedFeature
geUnitS_CollectionAndMappedFeature
hgActiveWellP_Borehole
hgActiveWellP_Gwbd2ActiveWell
hgAqSys_HGUnitGeStructure
hgAqSystem_Aquifer
hgAquiclude_hgAquicludeS
hgAquiclude_HGUnitGeStructure
hgAquifer_activeWellP
hgAquifer_AquitardAquifer
hgAquifer_hgAquiferS
hgAquifer_hgObjNaturalP
hgAquifer_HGUnitGeStructure
hgAquiferSystem_aquiclude
hgAquiferSystem_aquifer
hgAquiferSystem_hgAquiferSystemS
hgAquitard_AquitardAquifer
hgAquitard_hgAquitardS
hgAquitard_HGUnitGeStructure
hgGwbdS_aqSystem
hgGwbdS_Gwbd2ActiveWell
hgGwbdS_GwbdS_EMF
hgGwbdS_HGObjNaturalP


Domains

hgActiveWellTypeValue
hgAqMediaTypeValue
hgAquiferTypeValue
hgConOfGroundwaterValue
hgHydroGeochemRockTypeValue
hgNaturalObjectTypeValue
hgStatusCodeTypeValue
hgWaterPersistenceValue
hgWaterSalinityValue
VoidReasonValue


GE - FeatureDataset

Name GE
Description This feature dataset contains feature classes for the Geology theme.

geBorehole - FeatureClass

Name geBorehole
ShapeType Point
FeatureType Simple
AliasName geBorehole
HasM false
HasZ false
Description A borehole is the generalized term for any narrow shaft drilled in the ground. It is a point feature class that contains information about the borehole such as purpose, length, and elevation. It relates to geDownholeGeometry for borehole Downhole Geometry, and it has a one-to-many relationship with geMappedInterval.

Field DataType UML Source Description
boreholeID Integer(4) _ Borehole identifier. The value must be unique within the table geBorehole. In other tables it references geBorehole.boreholeID.
downholeGeometry_void SmallInteger(2) GE.Geology.Borehole.downholeGeometry Please refer to the equivalent UML description in the INSPIRE documentation
elevation Integer(4) GE.Geology.Borehole.elevation Please refer to the equivalent UML description in the INSPIRE documentation
elevation_dimension SmallInteger(2) GE.Geology.Borehole Please refer to the equivalent UML description in the INSPIRE documentation
elevation_void SmallInteger(2) GE.Geology.Borehole.elevation Please refer to the equivalent UML description in the INSPIRE documentation
elevationCRS String(255) GE.Geology.Borehole.elevation Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.Borehole.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.Borehole.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.Borehole.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.Borehole.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
length Double(8) GE.Geology.Borehole.boreholeLength Please refer to the equivalent UML description in the INSPIRE documentation
length_uom String(50) GE.Geology.Borehole.boreholeLength Please refer to the equivalent UML description in the INSPIRE documentation
length_void SmallInteger(2) GE.Geology.Borehole.boreholeLength Please refer to the equivalent UML description in the INSPIRE documentation
mappedInterval_void SmallInteger(2) GE.Geology.Borehole.logElement Please refer to the equivalent UML description in the INSPIRE documentation
purpose_code String(255) GE.Geology.Borehole.purpose Please refer to the equivalent UML description in the INSPIRE documentation
purpose_label String(255) GE.Geology.Borehole.purpose Please refer to the equivalent UML description in the INSPIRE documentation
purpose_uri String(255) GE.Geology.Borehole.purpose Please refer to the equivalent UML description in the INSPIRE documentation
purpose_void SmallInteger(2) GE.Geology.Borehole.purpose Please refer to the equivalent UML description in the INSPIRE documentation


geDownholeGeometry - FeatureClass

Name geDownholeGeometry
ShapeType Polyline
FeatureType Simple
AliasName geDownholeGeometry
HasM false
HasZ true
Description The downhole geometry of the borehole, it is a polyline with Z values. It relates to geBorehole through geBorehole.boreholeID.

Field DataType UML Source Description
boreholeID Integer(4) GE.Geology.Borehole.downholeGeometry Borehole identifier. The value must be unique within the table geBorehole. In other tables, it references geBorehole.boreholeID.
downholeGeometryID Integer(4) GE.Geology.Borehole.downholeGeometry Identifier for downholeGeometry. The value must be unique within the table.


geFaultL - FeatureClass

Name geFaultL
ShapeType Polyline
FeatureType Simple
AliasName geFaultL
HasM false
HasZ false
Description Spatial representation of a GeologicFeature faults in polyline shape. A fault in geFault can be made up of many physical fault lines in geFaultL.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. it should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


geFoldL - FeatureClass

Name geFoldL
ShapeType Polyline
FeatureType Simple
AliasName geFoldL
HasM false
HasZ false
Description Spatial representation of a GeologicFeature folds in polyline shape. A fold in geFold can be made up of many physical fold lines in geFoldL.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, geUnitS, and it is the same as boreholeID in geBorehole. the mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


geGeomorphL - FeatureClass

Name geGeomorphL
ShapeType Polyline
FeatureType Simple
AliasName geGeomorphL
HasM false
HasZ false
Description Spatial representation of a GeologicFeature geomorphology in polyline shape. It relates to geGeomorph through featureID, and geGeologicCollection through collectionID.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, it is used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
collectionID Integer(4) _ Collection identifier. It is the primary key in geGeologicCollection. In other tables, it references geGeologicCollection.collectionID.


geGeomorphP - FeatureClass

Name geGeomorphP
ShapeType Point
FeatureType Simple
AliasName geGeomorphP
HasM false
HasZ false
Description Spatial representation of a GeologicFeature geomorphology in point shape. It relates to geGeomorph through featureID, and geGeologicCollection through collectionID.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


geGeomorphS - FeatureClass

Name geGeomorphS
ShapeType Polygon
FeatureType Simple
AliasName geGeomorphS
HasM false
HasZ false
Description Spatial representation of a GeologicFeature – Geomorphology in point shape. It relates to geGeomorph through featureID, it related to geGeologicCollection through collectionID.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


geMappedInterval - FeatureClass

Name geMappedInterval
ShapeType Polyline
FeatureType Simple
AliasName geMappedInterval
HasM false
HasZ true
Description A special kind of mapped feature whose shape is a 1-D interval and uses the SRS of the containing borehole. It is a polyline shape type with Z values on. It also has attributes mappedIntervalBegin and mappedIntervalEnd to tell where the interval begins and ends.

Field DataType UML Source Description
boreholeID Integer(4) _ Borehole identifier. The value must be unique within the table geBorehole. In other tables, it references geBorehole.boreholeID.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
mappedInterval_uom String(50) GE.Geology.MappedInterval Please refer to the equivalent UML description in the INSPIRE documentation
mappedIntervalBegin Double(8) GE.Geology.MappedInterval Please refer to the equivalent UML description in the INSPIRE documentation
mappedIntervalEnd Double(8) GE.Geology.MappedInterval Please refer to the equivalent UML description in the INSPIRE documentation


geUnitL - FeatureClass

Name geUnitL
ShapeType Polyline
FeatureType Simple
AliasName geUnitL
HasM false
HasZ false
Description Spatial representation of geologic units in polyline shape. It relates to geUnit through FeatureID, and geGeologicCollection through collectionID.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


geUnitP - FeatureClass

Name geUnitP
ShapeType Point
FeatureType Simple
AliasName geUnitP
HasM false
HasZ false
Description Spatial representation of geologic units in point shape. It relates to geUnit through FeatureID and geGeologicCollection through collectionID.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


geUnitS - FeatureClass

Name geUnitS
ShapeType Polygon
FeatureType Simple
AliasName geUnitS
HasM false
HasZ false
Description Spatial representation of geologic units in polygon shape. It relates to geUnit through FeatureID and geGeologicCollection through collectionID.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit, it should be unique within the geology theme.
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


hgActiveWellP - FeatureClass

Name hgActiveWellP
ShapeType Point
FeatureType Simple
AliasName hgActiveWellP
HasM false
HasZ false
Description hgActiveWellP

Field DataType UML Source Description
aquifer_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.aquifer Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalObject.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
description String(255) GE.Hydrogeology.HydrogeologicalObject.description Please refer to the equivalent UML description in the INSPIRE documentation
description_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.description Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalObject.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
hgoName String(255) GE.Hydrogeology.HydrogeologicalObject.name Please refer to the equivalent UML description in the INSPIRE documentation
hgoName_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.name Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
statusCode_code String(50) GE.Hydrogeology.HydrogeologicalObjectManMade.statusCode Please refer to the equivalent UML description in the INSPIRE documentation
statusCode_label String(255) GE.Hydrogeology.HydrogeologicalObjectManMade.statusCode Please refer to the equivalent UML description in the INSPIRE documentation
statusCode_uri String(255) GE.Hydrogeology.HydrogeologicalObjectManMade.statusCode Please refer to the equivalent UML description in the INSPIRE documentation
statusCode_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObjectManMade.statusCode Please refer to the equivalent UML description in the INSPIRE documentation
validFrom Date(8) GE.Hydrogeology.HydrogeologicalObjectManMade.validFrom Please refer to the equivalent UML description in the INSPIRE documentation
validFrom_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObjectManMade.validFrom Please refer to the equivalent UML description in the INSPIRE documentation
validTo Date(8) GE.Hydrogeology.HydrogeologicalObjectManMade.validTo Please refer to the equivalent UML description in the INSPIRE documentation
validTo_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObjectManMade.validTo Please refer to the equivalent UML description in the INSPIRE documentation
activityType1 String(50) GE.Hydrogeology.ActiveWell.activityType Please refer to the equivalent UML description in the INSPIRE documentation
activityType2 String(50) GE.Hydrogeology.ActiveWell.activityType Please refer to the equivalent UML description in the INSPIRE documentation
activityType3 String(50) GE.Hydrogeology.ActiveWell.activityType Please refer to the equivalent UML description in the INSPIRE documentation
borehole_void SmallInteger(2) GE.Hydrogeology.ActiveWell.borehole Please refer to the equivalent UML description in the INSPIRE documentation
EMF_void SmallInteger(2) GE.Hydrogeology.ActiveWell.environmentalMonitoringFacility Please refer to the equivalent UML description in the INSPIRE documentation
groundWaterBody_void SmallInteger(2) GE.Hydrogeology.ActiveWell.groundWaterBody Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in data theme
rid1 Integer(4) _ It is a foreign key in the table, it references hgAquifer.IFCID
rid2 Integer(4) _ It is a foreign key in the table, it references geBorehole.boreholeID
rid3 Integer(4) _ It is a foreign key in the table, it references EnvironmentalMonitoringFacility.IFCID
activityType1_uri String(255) GE.Hydrogeology.ActiveWell.activityType Please refer to the equivalent UML description in the INSPIRE documentation
activityType2_uri String(255) GE.Hydrogeology.ActiveWell.activityType Please refer to the equivalent UML description in the INSPIRE documentation
activityType3_uri String(255) GE.Hydrogeology.ActiveWell.activityType Please refer to the equivalent UML description in the INSPIRE documentation


hgAquicludeS - FeatureClass

Name hgAquicludeS
ShapeType Polygon
FeatureType Simple
AliasName hgAquicludeS
HasM false
HasZ false
Description hgAquicludeS

Field DataType UML Source Description
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass
rid Integer(4) _ It is a foreign key in the table, it references hgAquiclude.ifcid
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


hgAquiferS - FeatureClass

Name hgAquiferS
ShapeType Polygon
FeatureType Simple
AliasName hgAquiferS
HasM false
HasZ false
Description hgAquiferS

Field DataType UML Source Description
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass
rid Integer(4) _ It is a foreign key in the table, it references hgAquifer.ifcid
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


hgAquiferSystemS - FeatureClass

Name hgAquiferSystemS
ShapeType Polygon
FeatureType Simple
AliasName hgAquiferSystemS
HasM false
HasZ false
Description hgAquiferSystemS

Field DataType UML Source Description
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass
rid Integer(4) _ It is a foreign key in the table, it references hgAquiferSystem.ifcid
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


hgAquitardS - FeatureClass

Name hgAquitardS
ShapeType Polygon
FeatureType Simple
AliasName hgAquitardS
HasM false
HasZ false
Description hgAquitardS

Field DataType UML Source Description
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass
rid Integer(4) _ It is a foreign key in the table, it references hgAquitard.ifcid
mappingFrame_code String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_label String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation
mappingFrame_uri String(255) GE.Geology.MappedFeature.mappingFrame Please refer to the equivalent UML description in the INSPIRE documentation


hgGroundwaterbodyS - FeatureClass

Name hgGroundwaterbodyS
ShapeType Polygon
FeatureType Simple
AliasName hgGroundwaterbodyS
HasM false
HasZ false
Description hgGroundwaterbodyS

Field DataType UML Source Description
activeWell_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.ActiveWell Please refer to the equivalent UML description in the INSPIRE documentation
appHorExt_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.approximateHorizontalExtend Please refer to the equivalent UML description in the INSPIRE documentation
aquiferSystem_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.aquiferSystem Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion Date(8) GE.Hydrogeology.GroundWaterBody.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
conOfGroundWaterBody String(50) GE.Hydrogeology.GroundWaterBody.conditionOfGroundWaterBody Please refer to the equivalent UML description in the INSPIRE documentation
EMF_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.observationWell Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Hydrogeology.GroundWaterBody.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
hyGeObjNatural_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.hydrogeologicalObjectNatural Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Hydrogeology.GroundWaterBody.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Hydrogeology.GroundWaterBody.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Hydrogeology.GroundWaterBody.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass
mineralization_code String(50) GE.Hydrogeology.GroundWaterBody.mineralization Please refer to the equivalent UML description in the INSPIRE documentation
mineralization_label String(255) GE.Hydrogeology.GroundWaterBody.mineralization Please refer to the equivalent UML description in the INSPIRE documentation
mineralization_uri String(255) GE.Hydrogeology.GroundWaterBody.mineralization Please refer to the equivalent UML description in the INSPIRE documentation
mineralization_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.mineralization Please refer to the equivalent UML description in the INSPIRE documentation
piezState_obsTime Date(8) GE.Hydrogeology.GroundWaterBody.piezometricState Please refer to the equivalent UML description in the INSPIRE documentation
piezState_void SmallInteger(2) GE.Hydrogeology.GroundWaterBody.piezometricState Please refer to the equivalent UML description in the INSPIRE documentation
conOfGroundWaterBody_uri String(255) GE.Hydrogeology.GroundWaterBody.conditionOfGroundWaterBody Please refer to the equivalent UML description in the INSPIRE documentation


hgHyGeObjNaturalP - FeatureClass

Name hgHyGeObjNaturalP
ShapeType Point
FeatureType Simple
AliasName hgHyGeObjNaturalP
HasM false
HasZ false
Description hgHyGeObjNaturalP

Field DataType UML Source Description
aquifer_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.aquifer Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalObject.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
description String(255) GE.Hydrogeology.HydrogeologicalObject.description Please refer to the equivalent UML description in the INSPIRE documentation
description_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.description Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalObject.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
hgoName String(255) GE.Hydrogeology.HydrogeologicalObject.name Please refer to the equivalent UML description in the INSPIRE documentation
hgoName_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.name Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObject.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
approxQuantityOfFlow Double(8) GE.Hydrogeology.HydrogeologicalObjectNatural.approximateQuantityOfFlow Please refer to the equivalent UML description in the INSPIRE documentation
approxQuantityOfFlow_from Double(8) GE.Hydrogeology.HydrogeologicalObjectNatural.approximateQuantityOfFlow Please refer to the equivalent UML description in the INSPIRE documentation
approxQuantityOfFlow_to Double(8) GE.Hydrogeology.HydrogeologicalObjectNatural.approximateQuantityOfFlow Please refer to the equivalent UML description in the INSPIRE documentation
approxQuantityOfFlow_uom String(50) GE.Hydrogeology.HydrogeologicalObjectNatural.approximateQuantityOfFlow Please refer to the equivalent UML description in the INSPIRE documentation
approxQuantityOfFlow_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObjectNatural.approximateQuantityOfFlow Please refer to the equivalent UML description in the INSPIRE documentation
groundWaterBody_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObjectNatural.groundWaterBody Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the data theme
naturalObjectType_code String(50) GE.Hydrogeology.HydrogeologicalObjectNatural.naturalObjectType Please refer to the equivalent UML description in the INSPIRE documentation
naturalObjectType_label String(255) GE.Hydrogeology.HydrogeologicalObjectNatural.naturalObjectType Please refer to the equivalent UML description in the INSPIRE documentation
naturalObjectType_uri String(255) GE.Hydrogeology.HydrogeologicalObjectNatural.naturalObjectType Please refer to the equivalent UML description in the INSPIRE documentation
rid1 Integer(4) _ It is a foreign key in the table, it references hgGroundwaterbodyS.ifcid
rid2 Integer(4) _ It is a foreign key in the table, it references hgAquifer.ifcid
waterPersistence_code String(50) GE.Hydrogeology.HydrogeologicalObjectNatural.waterPersistence Please refer to the equivalent UML description in the INSPIRE documentation
waterPersistence_label String(255) GE.Hydrogeology.HydrogeologicalObjectNatural.waterPersistence Please refer to the equivalent UML description in the INSPIRE documentation
waterPersistence_uri String(255) GE.Hydrogeology.HydrogeologicalObjectNatural.waterPersistence Please refer to the equivalent UML description in the INSPIRE documentation
waterPersistence_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalObjectNatural.waterPersistence Please refer to the equivalent UML description in the INSPIRE documentation



geCollectionAndMappedFeature - Table

Name geCollectionAndMappedFeature
AliasName geCollectionAndMappedFeature
Description This is an intermediary table that is used to model the relationship between geGeologicCollection and mapped features such as geGeomorphL, geGeoporphP, geGeomorphS, geFoldL, and geFaultL.

Field DataType UML Source Description
collectionID Integer(4) _ Collection identifier. It is the primary key in geGeologicCollection; in other tables, it references geGeologicCollection.collectionID.
FeatureClassName String(50) _ The name of FeatureClass that the mappedFeatureID belongs to
mappedFeatureID Integer(4) _ Identifier for the mapped feature. This field is used in multiple feature classes including geGeomorphP, geGeomorphL, geGeomorphS, geFoldL, geFaultL, geUnitP, geUnitL, and geUnitS, and it is the same as boreholeID in geBorehole. The mappedFeatureID should be unique within the geology theme.

geCompositionPart - Table

Name geCompositionPart
AliasName geCompositionPart
Description The composition of a geologic unit in terms of lithological constituents. It relates to geUnit through featureID.

Field DataType UML Source Description
partID Integer(4) _ Part identifier. The value must be unique within the table.
featureID Integer(4) _ Feature identifier for geologic features. it is used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
material_code String(255) GE.Geology.CompositionPart.material Please refer to the equivalent UML description in the INSPIRE documentation
material_label String(255) GE.Geology.CompositionPart.material Please refer to the equivalent UML description in the INSPIRE documentation
material_uri String(255) GE.Geology.CompositionPart.material Please refer to the equivalent UML description in the INSPIRE documentation
proportion_constraint String(255) GE.Geology.CompositionPart.proportion Please refer to the equivalent UML description in the INSPIRE documentation
proportion_uom String(50) GE.Geology.CompositionPart.proportion Please refer to the equivalent UML description in the INSPIRE documentation
proportion_valueH Double(8) GE.Geology.CompositionPart.proportion Please refer to the equivalent UML description in the INSPIRE documentation
proportion_valueL Double(8) GE.Geology.CompositionPart.proportion Please refer to the equivalent UML description in the INSPIRE documentation
proportion_void SmallInteger(2) GE.Geology.CompositionPart.proportion Please refer to the equivalent UML description in the INSPIRE documentation
role_code String(255) GE.Geology.CompositionPart.role Please refer to the equivalent UML description in the INSPIRE documentation
role_label String(255) GE.Geology.CompositionPart.role Please refer to the equivalent UML description in the INSPIRE documentation
role_uri String(255) GE.Geology.CompositionPart.role Please refer to the equivalent UML description in the INSPIRE documentation

geEventAndFeature - Table

Name geEventAndFeature
AliasName geEventAndFeature
Description This is an intermediary table that is used to model the relationship between geGeologicEvent and geologic features such as geGeomorph, geFold, and geUnit.

Field DataType UML Source Description
eventID Integer(4) _ Identifier for the geologic event. It is the primary key in geGeologicEvent. In other tables it references geGeologicEvent.eventID.
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.

geEventProcess - Table

Name geEventProcess
AliasName geEventProcess
Description geEventProcess

Field DataType UML Source Description
eventProcess_code String(255) GE.Geology.GeologicEvent.eventProcess Please refer to the equivalent UML description in the INSPIRE documentation
eventProcess_label String(255) GE.Geology.GeologicEvent.eventProcess Please refer to the equivalent UML description in the INSPIRE documentation
eventProcess_uri String(255) GE.Geology.GeologicEvent.eventProcess Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ unique identifier for geologic eventprocess.
rid Integer(4) _ reference geGeologicEvent.eventID

geFault - Table

Name geFault
AliasName geFault
Description Brittle to ductile style structures along which displacement has occurred. These range from a simple, single planar brittle or ductile surface to a fault system comprised of tens of strands of both brittle and ductile nature.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
faultType_code String(50) GE.Geology.ShearDisplacementStructure.faultType Please refer to the equivalent UML description in the INSPIRE documentation
faultType_label String(50) GE.Geology.ShearDisplacementStructure.faultType Please refer to the equivalent UML description in the INSPIRE documentation
faultType_uri String(50) GE.Geology.ShearDisplacementStructure.faultType Please refer to the equivalent UML description in the INSPIRE documentation

geFold - Table

Name geFold
AliasName geFold
Description One or more systematically curved layers, surfaces, or lines in a rock body. A fold denotes a structure formed by the deformation of a geologic structure to form a structure that may be described by the translation of an abstract line (the fold axis) parallel to itself along some curvilinear path (the fold profile). Folds have a hinge zone (zone of maximum curvature along the surface) and limbs (parts of the deformed surface not in the hinge zone).

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
profileType_code String(255) GE.Geology.Fold.profileType Please refer to the equivalent UML description in the INSPIRE documentation
profileType_label String(255) GE.Geology.Fold.profileType Please refer to the equivalent UML description in the INSPIRE documentation
profileType_uri String(255) GE.Geology.Fold.profileType Please refer to the equivalent UML description in the INSPIRE documentation
profileType_void SmallInteger(2) GE.Geology.Fold.profileType Please refer to the equivalent UML description in the INSPIRE documentation

geGeologicCollection - Table

Name geGeologicCollection
AliasName geGeologicCollection
Description A collection of geological or geophysical objects. Geologic objects are commonly grouped into collections such as geological maps, thematic maps, or the required input to a geological model.

Field DataType UML Source Description
collectionID Integer(4) _ Collection identifier. It is the primary key in geGeologicCollection; in other tables, it references geGeologicCollection.collectionID.
beginLifespanVersion Date(8) GE.Geology.GeologicCollection.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Geology.GeologicCollection.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
boreholeMember_void SmallInteger(2) _ GE.Geology.GeologicCollection.boreholeMember Please refer to the equivalent UML description in the INSPIRE documentation
collectionName String(255) GE.Geology.GeologicCollection.name Please refer to the equivalent UML description in the INSPIRE documentation
collectionType_code String(255) GE.Geology.GeologicCollection.collectionType Please refer to the equivalent UML description in the INSPIRE documentation
collectionType_label String(255) GE.Geology.GeologicCollection.collectionType Please refer to the equivalent UML description in the INSPIRE documentation
collectionType_uri String(255) GE.Geology.GeologicCollection.collectionType Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Geology.GeologicCollection.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Geology.GeologicCollection.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
mapMember_void SmallInteger(2) GE.Geology.GeologicCollection.mapMember Please refer to the equivalent UML description in the INSPIRE documentation
reference String(2000) GE.Geology.GeologicCollection.reference Please refer to the equivalent UML description in the INSPIRE documentation
reference_void SmallInteger(2) GE.Geology.GeologicCollection.reference Please refer to the equivalent UML description in the INSPIRE documentation

geGeologicEvent - Table

Name geGeologicEvent
AliasName geGeologicEvent
Description An identifiable event during which one or more geological processes act to modify geological entities. A GeologicEvent should have a specified geologic age and process, and it may have a specified environment. An example might be a cratonic uplift event during which erosion, sedimentation, and volcanism all take place. A GeologicEvent age can represent an instant in time or an interval of time.

Field DataType UML Source Description
eventID Integer(4) _ Identifier for the geologic event, It is the primary key in geGeologicEvent; in other tables it references geGeologicEvent.eventID.
eventEnvironment_code String(255) GE.Geology.GeologicEvent.eventEnvironment Please refer to the equivalent UML description in the INSPIRE documentation
eventEnvironment_label String(255) GE.Geology.GeologicEvent.eventEnvironment Please refer to the equivalent UML description in the INSPIRE documentation
eventEnvironment_uri String(255) GE.Geology.GeologicEvent.eventEnvironment Please refer to the equivalent UML description in the INSPIRE documentation
eventEnvironment_void SmallInteger(2) GE.Geology.GeologicEvent.eventEnvironment Please refer to the equivalent UML description in the INSPIRE documentation
eventName String(255) GE.Geology.GeologicEvent.name Please refer to the equivalent UML description in the INSPIRE documentation
eventName_void SmallInteger(2) GE.Geology.GeologicEvent.name Please refer to the equivalent UML description in the INSPIRE documentation
eventProcess_void SmallInteger(2) GE.Geology.GeologicEvent.eventProcess Please refer to the equivalent UML description in the INSPIRE documentation
olderNamedAge_code String(255) GE.Geology.GeologicEvent.olderNamedAge Please refer to the equivalent UML description in the INSPIRE documentation
olderNamedAge_label String(255) GE.Geology.GeologicEvent.olderNamedAge Please refer to the equivalent UML description in the INSPIRE documentation
olderNamedAge_uri String(255) GE.Geology.GeologicEvent.olderNamedAge Please refer to the equivalent UML description in the INSPIRE documentation
olderNamedAge_void SmallInteger(2) GE.Geology.GeologicEvent.olderNamedAge Please refer to the equivalent UML description in the INSPIRE documentation
youngerNamedAge_code String(255) GE.Geology.GeologicEvent.youngerNamedAge Please refer to the equivalent UML description in the INSPIRE documentation
youngerNamedAge_label String(255) GE.Geology.GeologicEvent.youngerNamedAge Please refer to the equivalent UML description in the INSPIRE documentation
youngerNamedAge_uri String(255) GE.Geology.GeologicEvent.youngerNamedAge Please refer to the equivalent UML description in the INSPIRE documentation
youngerNamedAge_void SmallInteger(2) GE.Geology.GeologicEvent.youngerNamedAge Please refer to the equivalent UML description in the INSPIRE documentation

geGeomorph - Table

Name geGeomorph
AliasName geGeomorph
SubtypeFieldName Subtype
Description An abstract spatial object type describing the shape and nature of the Earth's land surface (i.e., a landform). These landforms may be created by natural Earth processes (e.g., river channel, beach, moraine, mountain) or through human (anthropogenic) activity (e.g., dredged channel, reclaimed land, mine waste dumps).

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
activity_code String(255) GE.Geology.NaturalGeomorphologicFeature.activity Please refer to the equivalent UML description in the INSPIRE documentation
activity_label String(255) GE.Geology.NaturalGeomorphologicFeature.activity Please refer to the equivalent UML description in the INSPIRE documentation
activity_uri String(255) GE.Geology.NaturalGeomorphologicFeature.activity Please refer to the equivalent UML description in the INSPIRE documentation
activity_void SmallInteger(2) GE.Geology.NaturalGeomorphologicFeature.activity Please refer to the equivalent UML description in the INSPIRE documentation
geomorphFeatureType_code String(255) GE.Geology.AnthropogenicGeomorphologicFeature.anthropogenicGeomorphologicFeatureType
GE.Geology.NaturalGeomorphologicFeature.naturalGeomorphologicFeatureType
Please refer to the equivalent UML description in the INSPIRE documentation
geomorphFeatureType_label String(255) GE.Geology.AnthropogenicGeomorphologicFeature.anthropogenicGeomorphologicFeatureType
GE.Geology.NaturalGeomorphologicFeature.naturalGeomorphologicFeatureType
Please refer to the equivalent UML description in the INSPIRE documentation
geomorphFeatureType_uri String(255) GE.Geology.AnthropogenicGeomorphologicFeature.anthropogenicGeomorphologicFeatureType
GE.Geology.NaturalGeomorphologicFeature.naturalGeomorphologicFeatureType
Please refer to the equivalent UML description in the INSPIRE documentation
Subtype SmallInteger(2) _ Subtype for NaturalGeomorphologicFeature and AnthropogenicGeomorphologicFeature

Subtype Code Subtype Name Field Info
1 NaturalGeomorphologicFeature
2 AnthropogenicGeomorphologicFeature


geThematicClass - Table

Name geThematicClass
AliasName geThematicClass
Description Generic thematic classifier that enables the reclassification of geologic features with user-defined classes appropriate to thematic maps. This datatype allows geologic features to be classified against thematic classes. This provides a generic means of delivering geological thematic map data.

Field DataType UML Source Description
themeClassificationID Integer(4) _ ThemeClassification identifier. The value must be unique within the table.
themeClass_code String(255) GE.Geology.ThematicClass.themeClass Please refer to the equivalent UML description in the INSPIRE documentation
themeClass_label String(255) GE.Geology.ThematicClass.themeClass Please refer to the equivalent UML description in the INSPIRE documentation
themeClass_uri String(255) GE.Geology.ThematicClass.themeClass Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_code String(255) GE.Geology.ThematicClass.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_label String(255) GE.Geology.ThematicClass.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_uri String(255) GE.Geology.ThematicClass.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation

geThemeAndFeature - Table

Name geThemeAndFeature
AliasName geThemeAndFeature
Description This is an intermediary table that is used to model the relationship between geThematicClass and geologic features such as geGeomorph, geFold, and geUnit.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
themeClassificationID Integer(4) _ ThemeClassification identifier. The value must be unique within the table.

geUnit - Table

Name geUnit
AliasName geUnit
Description A volume of rock with distinct characteristics. It includes formal units (i.e., formally adopted and named in an official lexicon), informal units (i.e., named but not promoted to the lexicon), and unnamed units (i.e., recognisable and described and delineable in the field but not otherwise formalised). Spatial properties are only available through association with a MappedFeature.

Field DataType UML Source Description
featureID Integer(4) _ Feature identifier for geologic features, used in geGeomorph, geFold, geFault, and geUnit. It should be unique within the geology theme.
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
composition_void SmallInteger(2) GE.Geology.GeologicUnit.composition Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_code String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_label String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_uri String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation

hgAquiclude - Table

Name hgAquiclude
AliasName hgAquiclude
Description hgAquiclude

Field DataType UML Source Description
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
description String(255) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
description_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
geologicStructure_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.geologicStructure Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the data theme
rid1 Integer(4) _ It is a foreign key in the table, it references hgAquiferSystem.ifcid
geologicUnitType_code String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_label String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_uri String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
composition_void SmallInteger(2) GE.Geology.GeologicUnit.composition Please refer to the equivalent UML description in the INSPIRE documentation

hgAquifer - Table

Name hgAquifer
AliasName hgAquifer
Description hgAquifer

Field DataType UML Source Description
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
description String(255) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
description_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
geologicStructure_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.geologicStructure Please refer to the equivalent UML description in the INSPIRE documentation
aquiferSystem_void SmallInteger(2) GE.Hydrogeology.Aquifer.aquiferSystem Please refer to the equivalent UML description in the INSPIRE documentation
aquiferType String(50) GE.Hydrogeology.Aquifer.aquiferType Please refer to the equivalent UML description in the INSPIRE documentation
aquiferType_uri String(255) GE.Hydrogeology.Aquifer.aquiferType Please refer to the equivalent UML description in the INSPIRE documentation
aquitard_void SmallInteger(2) GE.Hydrogeology.Aquifer.aquitard Please refer to the equivalent UML description in the INSPIRE documentation
hgObj_void SmallInteger(2) GE.Hydrogeology.Aquifer.hydrogeologicalObject Please refer to the equivalent UML description in the INSPIRE documentation
hyGeochemRockType_code String(50) GE.Hydrogeology.Aquifer.hydroGeochemicalRockType Please refer to the equivalent UML description in the INSPIRE documentation
hyGeochemRockType_label String(50) GE.Hydrogeology.Aquifer.hydroGeochemicalRockType Please refer to the equivalent UML description in the INSPIRE documentation
hyGeochemRockType_uri String(255) GE.Hydrogeology.Aquifer.hydroGeochemicalRockType Please refer to the equivalent UML description in the INSPIRE documentation
hyGeochemRockType_void SmallInteger(2) GE.Hydrogeology.Aquifer.hydroGeochemicalRockType Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the data theme
isExploited SmallInteger(2) GE.Hydrogeology.Aquifer.isExploited Please refer to the equivalent UML description in the INSPIRE documentation
isExploited_void SmallInteger(2) GE.Hydrogeology.Aquifer.isExploited Please refer to the equivalent UML description in the INSPIRE documentation
isMainInSystem SmallInteger(2) GE.Hydrogeology.Aquifer.isMainInSystem Please refer to the equivalent UML description in the INSPIRE documentation
isMainInSystem_void SmallInteger(2) GE.Hydrogeology.Aquifer.isMainInSystem Please refer to the equivalent UML description in the INSPIRE documentation
mediaType_code String(50) GE.Hydrogeology.Aquifer.mediaType Please refer to the equivalent UML description in the INSPIRE documentation
mediaType_label String(255) GE.Hydrogeology.Aquifer.mediaType Please refer to the equivalent UML description in the INSPIRE documentation
mediaType_uri String(255) GE.Hydrogeology.Aquifer.mediaType Please refer to the equivalent UML description in the INSPIRE documentation
permeaCoef_from Double(8) GE.Hydrogeology.Aquifer.permeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
permeaCoef_to Double(8) GE.Hydrogeology.Aquifer.permeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
permeaCoef_uom String(255) GE.Hydrogeology.Aquifer.permeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
permeaCoef_value Double(8) GE.Hydrogeology.Aquifer.permeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
permeaCoef_void SmallInteger(2) GE.Hydrogeology.Aquifer.permeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
rid1 Integer(4) _ It is a foreign key in the table, it references hgAquiferSystem.ifcid
storaCoef_from Double(8) GE.Hydrogeology.Aquifer.storativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
storaCoef_to Double(8) GE.Hydrogeology.Aquifer.storativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
storaCoef_uom String(255) GE.Hydrogeology.Aquifer.storativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
storaCoef_value Double(8) GE.Hydrogeology.Aquifer.storativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
storaCoef_void SmallInteger(2) GE.Hydrogeology.Aquifer.storativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
VulnToPollution_from Double(8) GE.Hydrogeology.Aquifer.vulnerabilityToPollution Please refer to the equivalent UML description in the INSPIRE documentation
VulnToPollution_to Double(8) GE.Hydrogeology.Aquifer.vulnerabilityToPollution Please refer to the equivalent UML description in the INSPIRE documentation
VulnToPollution_uom String(255) GE.Hydrogeology.Aquifer.vulnerabilityToPollution Please refer to the equivalent UML description in the INSPIRE documentation
VulnToPollution_value Double(8) GE.Hydrogeology.Aquifer.vulnerabilityToPollution Please refer to the equivalent UML description in the INSPIRE documentation
VulnToPollution_void SmallInteger(2) GE.Hydrogeology.Aquifer.vulnerabilityToPollution Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_code String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_label String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_uri String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
composition_void SmallInteger(2) GE.Geology.GeologicUnit.composition Please refer to the equivalent UML description in the INSPIRE documentation

hgAquiferSystem - Table

Name hgAquiferSystem
AliasName hgAquiferSystem
Description hgAquiferSystem

Field DataType UML Source Description
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
description String(255) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
description_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
geologicStructure_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.geologicStructure Please refer to the equivalent UML description in the INSPIRE documentation
aquiclude_void SmallInteger(2) GE.Hydrogeology.AquiferSystem.aquiclude Please refer to the equivalent UML description in the INSPIRE documentation
aquifer_void SmallInteger(2) GE.Hydrogeology.AquiferSystem.aquifer Please refer to the equivalent UML description in the INSPIRE documentation
aquitard_void SmallInteger(2) GE.Hydrogeology.AquiferSystem.aquitard Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the data theme
isLayered SmallInteger(2) GE.Hydrogeology.AquiferSystem.isLayered Please refer to the equivalent UML description in the INSPIRE documentation
isLayered_void SmallInteger(2) GE.Hydrogeology.AquiferSystem.isLayered Please refer to the equivalent UML description in the INSPIRE documentation
rid1 Integer(4) _ It is a foreign key in the table, it references hgGroundwaterbodyS.ifcid
geologicUnitType_code String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_label String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_uri String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
composition_void SmallInteger(2) GE.Geology.GeologicUnit.composition Please refer to the equivalent UML description in the INSPIRE documentation

hgAquitard - Table

Name hgAquitard
AliasName hgAquitard
Description hgAquitard

Field DataType UML Source Description
featureName String(255) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
featureName_void SmallInteger(2) GE.Geology.GeologicFeature.name Please refer to the equivalent UML description in the INSPIRE documentation
geologicHistory_void SmallInteger(2) GE.Geology.GeologicFeature.geologicHistory Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(2) GE.Geology.GeologicFeature.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
themeClassification_void SmallInteger(2) GE.Geology.GeologicFeature.themeClassification Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiDepth_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateDepth Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_from Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_to Double(8) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_uom String(50) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
approxiThickness_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.approximateThickness Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
description String(255) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
description_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.description Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
geologicStructure_void SmallInteger(2) GE.Hydrogeology.HydrogeologicalUnit.geologicStructure Please refer to the equivalent UML description in the INSPIRE documentation
approxiPermCoeff_from Double(8) GE.Hydrogeology.Aquitard.approximatePermeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiPermCoeff_to Double(8) GE.Hydrogeology.Aquitard.approximatePermeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiPermCoeff_uom String(255) GE.Hydrogeology.Aquitard.approximatePermeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiPermCoeff_value Double(8) GE.Hydrogeology.Aquitard.approximatePermeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiPermCoeff_void SmallInteger(2) GE.Hydrogeology.Aquitard.approximatePermeabilityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiStorCoeff_from Double(8) GE.Hydrogeology.Aquitard.approximateStorativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiStorCoeff_to Double(8) GE.Hydrogeology.Aquitard.approximateStorativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiStorCoeff_uom String(255) GE.Hydrogeology.Aquitard.approximateStorativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiStorCoeff_value Double(8) GE.Hydrogeology.Aquitard.approximateStorativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
approxiStorCoeff_void SmallInteger(2) GE.Hydrogeology.Aquitard.approximateStorativityCoefficient Please refer to the equivalent UML description in the INSPIRE documentation
aquifer_void SmallInteger(2) Aquitard.aquifer Please refer to the equivalent UML description in the INSPIRE documentation
aquiferSystem_void SmallInteger(2) Aquitard.aquiferSystem Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the data theme
rid1 Integer(4) _ It is a foreign key in the table, it references hgAquiferSystem.ifcid
geologicUnitType_code String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_label String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
geologicUnitType_uri String(255) GE.Geology.GeologicUnit.geologicUnitType Please refer to the equivalent UML description in the INSPIRE documentation
composition_void SmallInteger(2) GE.Geology.GeologicUnit.composition Please refer to the equivalent UML description in the INSPIRE documentation

hgAquitardAquifer - Table

Name hgAquitardAquifer
AliasName hgAquitardAquifer
Description hgAquitardAquifer

Field DataType UML Source Description
rid1 Integer(4) _ It is a foreign key in the table, it references hgAquitard.ifcid
rid2 Integer(4) _ It is a foreign key in the table, it references hgAquifer.ifcid

hgGwbd2ActiveWell - Table

Name hgGwbd2ActiveWell
AliasName hgGwbd2ActiveWell
Description hgGwbd2ActiveWell

Field DataType UML Source Description
rid1 Integer(4) _ It is a foreign key in the table, it references hgGroundwaterbodyS.ifcid
rid2 Integer(4) _ It is a foreign key in the table, it references hgActiveWellP.ifcid

hgGwbdS_EMF - Table

Name hgGwbdS_EMF
AliasName hgGwbdS_EMF
Description hgGwbdS_EMF

Field DataType UML Source Description
rid1 Integer(4) _ It is a foreign key in the table, it references hgGroundwaterbodyS.ifcid
rid2 Integer(4) _ It is a foreign key in the table, it references EnvironmentalMonitoringFacility.ifcid

hgHGUnitGeStructure - Table

Name hgHGUnitGeStructure
AliasName hgHGUnitGeStructure
Description hgHGUnitGeStructure

Field DataType UML Source Description
rid1 Integer(4) _ It is a foreign key in the table, it references geFold.featureID, etc.
rid2 Integer(4) _ It is a foreign key in the table, it references hgAquitard.ifcid, hgAquiclude.ifcid, hgAquiferSystem.ifcid, hgAquifer.ifcid

geBorehole_CollectionAndMappedFeature - RelationshipClass

Name geBorehole_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toBorehole
Description This relationship class defines the relationship between geBorehole and geCollectionAndMappedFeature, with a feature in geBorehole being a member of geCollectionAndMappedFeature.

Origin Class Name Origin Primary Key Origin Foreign Key
geBorehole boreholeID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geBorehole_DownholeGeometry - RelationshipClass

Name geBorehole_DownholeGeometry
Cardinality OneToOne
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geBorehole and DownholeGeometry. A feature in DownholeGeometry belongs to a feature in geBorehole.

Origin Class Name Origin Primary Key Origin Foreign Key
geBorehole boreholeID boreholeID

Destination Class Name Destination Primary Key Destination Foreign Key
geDownholeGeometry

geBorehole_MappedInterval - RelationshipClass

Name geBorehole_MappedInterval
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel contains
BackwardPathLabel logElement
Description This relationship class defines the relationship between geBorehole and MappedInterval, with a feature in geBorehole containing feature in MappedInterval.

Origin Class Name Origin Primary Key Origin Foreign Key
geBorehole boreholeID boreholeID

Destination Class Name Destination Primary Key Destination Foreign Key
geMappedInterval

geFaultL_CollectionAndMappedFeature - RelationshipClass

Name geFaultL_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toFaultL
Description This relationship class defines the relationship between geBorehole and geCollectionAndMappedFeature, with a feature in geBorehole being a member of geCollectionAndMappedFeature.

Origin Class Name Origin Primary Key Origin Foreign Key
geFaultL mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geFoldL_CollectionAndMappedFeature - RelationshipClass

Name geFoldL_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toFoldL
Description This relationship class defines the relationship between geFoldL and geCollectionAndMappedFeature. A geFoldL feature can be in multiple geological collections.

Origin Class Name Origin Primary Key Origin Foreign Key
geFoldL mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geGeomorphL_CollectionAndMappedFeature - RelationshipClass

Name geGeomorphL_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toGeomorphL
Description This relationship class defines the relationship between geGeomorphL and geCollectionAndMappedFeature. A geGeomorphL feature can be in multiple geological collections.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorphL mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geGeomorphP_CollectionAndMappedFeature - RelationshipClass

Name geGeomorphP_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toGeomorphP
Description This relationship class defines the relationship between geGeomorphP and geCollectionAndMappedFeature. A geGeomorphP feature can be in multiple geological collections.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorphP mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geGeomorphS_CollectionAndMappedFeature - RelationshipClass

Name geGeomorphS_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toGeomorphS
Description This relationship class defines the relationship between geGeomorphS and geCollectionAndMappedFeature. A geGeomorphS feature can be in multiple geological collections.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorphS mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geUnitL_CollectionAndMappedFeature - RelationshipClass

Name geUnitL_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toUnitL
Description This relationship class defines the relationship between geUnitL and geCollectionAndMappedFeature. A geUnitL feature can be in multiple geological collections.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnitL mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geUnitP_CollectionAndMappedFeature - RelationshipClass

Name geUnitP_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toUnitP
Description This relationship class defines the relationship between geUnitP and geCollectionAndMappedFeature. A geUnitP feature can be in multiple geological collections.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnitP mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geUnitS_CollectionAndMappedFeature - RelationshipClass

Name geUnitS_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toUnitS
Description This relationship class defines the relationship between geUnitS and geCollectionAndMappedFeature. A geUnitS feature can be in multiple geological collections.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnitS mappedFeatureID mappedFeatureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

hgActiveWellP_Borehole - RelationshipClass

Name hgActiveWellP_Borehole
Cardinality OneToOne
IsAttributed false
IsComposite false
ForwardPathLabel boreholeID
BackwardPathLabel rid2
Description This relationship class defines the relationship between geBorehole and hgActiveWellP.

Origin Class Name Origin Primary Key Origin Foreign Key
geBorehole boreholeID rid2

Destination Class Name Destination Primary Key Destination Foreign Key
hgActiveWellP

hgActiveWellP_Gwbd2ActiveWell - RelationshipClass

Name hgActiveWellP_Gwbd2ActiveWell
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid2
Description This relationship class defines the relationship between hgActiveWellP and hgGwbd2ActiveWell.

Origin Class Name Origin Primary Key Origin Foreign Key
hgActiveWellP ifcid rid2

Destination Class Name Destination Primary Key Destination Foreign Key
hgGwbd2ActiveWell

hgGwbdS_aqSystem - RelationshipClass

Name hgGwbdS_aqSystem
Cardinality OneToOne
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgGroundwaterbodyS and hgAquiferSystem.

Origin Class Name Origin Primary Key Origin Foreign Key
hgGroundwaterbodyS ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquiferSystem

hgGwbdS_Gwbd2ActiveWell - RelationshipClass

Name hgGwbdS_Gwbd2ActiveWell
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgGroundwaterbodyS and hgGwbd2ActiveWell.

Origin Class Name Origin Primary Key Origin Foreign Key
hgGroundwaterbodyS ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgGwbd2ActiveWell

hgGwbdS_GwbdS_EMF - RelationshipClass

Name hgGwbdS_GwbdS_EMF
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgGroundwaterbodyS and hgGwbdS_EMF.

Origin Class Name Origin Primary Key Origin Foreign Key
hgGroundwaterbodyS ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgGwbdS_EMF

hgGwbdS_HGObjNaturalP - RelationshipClass

Name hgGwbdS_HGObjNaturalP
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgGroundwaterbodyS and hgHyGeObjNaturalP.

Origin Class Name Origin Primary Key Origin Foreign Key
hgGroundwaterbodyS ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgHyGeObjNaturalP

geCollection_CollectionAndMappedFeature - RelationshipClass

Name geCollection_CollectionAndMappedFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel contains
BackwardPathLabel toCollection
Description This relationship class defines the relationship between geGeologicCollection and geCollectionAndMappedFeature, a feature in geCollection can contain many mapped features.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeologicCollection collectionID collectionID

Destination Class Name Destination Primary Key Destination Foreign Key
geCollectionAndMappedFeature

geEvent_EventAndFeature - RelationshipClass

Name geEvent_EventAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel affects
BackwardPathLabel toEvent
Description This relationship class defines the relationship between geGeologicEvent and geEventAndFeature. A geologic event can affect many geologic features.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeologicEvent eventID eventID

Destination Class Name Destination Primary Key Destination Foreign Key
geEventAndFeature

geFault_EventAndFeature - RelationshipClass

Name geFault_EventAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel affectedBy
BackwardPathLabel toFault
Description This relationship class defines the relationship between geFault and geEventAndFeature. A fault feature can be affected by multiple geologic events.

Origin Class Name Origin Primary Key Origin Foreign Key
geFault featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geEventAndFeature

geFault_FaultL - RelationshipClass

Name geFault_FaultL
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel partOf
Description This relationship class defines the relationship between geFault and geFaultL. A feature in geFault can have many features in geFaultL.

Origin Class Name Origin Primary Key Origin Foreign Key
geFault featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geFaultL

geFault_ThemeAndFeature - RelationshipClass

Name geFault_ThemeAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toFault
Description This relationship class defines the relationship between geFault and geThemeAndFeature. A geFault feature can be in multiple themes.

Origin Class Name Origin Primary Key Origin Foreign Key
geFault featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geThemeAndFeature

geFold_EventAndFeature - RelationshipClass

Name geFold_EventAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel affectedBy
BackwardPathLabel toFold
Description This relationship class defines the relationship between geFold and geEventAndFeature. A fold feature can be affected by multiple geologic events.

Origin Class Name Origin Primary Key Origin Foreign Key
geFold featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geEventAndFeature

geFold_FoldL - RelationshipClass

Name geFold_FoldL
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel partOf
Description This relationship class defines the relationship between geFold and geFoldL. A feature in geFault can have one or many features in geFoldL.

Origin Class Name Origin Primary Key Origin Foreign Key
geFold featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geFoldL

geFold_ThemeAndFeature - RelationshipClass

Name geFold_ThemeAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toFold
Description This relationship class defines the relationship between geFold and geThemeAndFeature. A geFold feature can be in multiple themes.

Origin Class Name Origin Primary Key Origin Foreign Key
geFold featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geThemeAndFeature

geGeolEvent_eventProcess - RelationshipClass

Name geGeolEvent_eventProcess
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel eventID
BackwardPathLabel rid
Description This relationship class defines the relationship between geGeologicEvent and geEventProcess.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeologicEvent eventID rid

Destination Class Name Destination Primary Key Destination Foreign Key
geEventProcess

geGeomorph_EventAndFeature - RelationshipClass

Name geGeomorph_EventAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel affectedBy
BackwardPathLabel toGeomorph
Description This relationship class defines the relationship between geGeomorph and geEventAndFeature. A geomorphology feature can be affected by multiple geologic events.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorph featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geEventAndFeature

geGeomorph_geomorphL - RelationshipClass

Name geGeomorph_geomorphL
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geGeomorph and geGeomorphL. A feature in geGeomorph can have one or many features in geGeomorphL.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorph featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geGeomorphL

geGeomorph_GeomorphP - RelationshipClass

Name geGeomorph_GeomorphP
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geGeomorph and geGeomorphP. A feature in geGeomorph can have one or many features in geGeomorphP.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorph featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geGeomorphP

geGeomorph_GeomorphS - RelationshipClass

Name geGeomorph_GeomorphS
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geGeomorph and geGeomorphS. A feature in geGeomorph can have one or many features in geGeomorphS.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorph featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geGeomorphS

geGeomorph_ThemeAndFeature - RelationshipClass

Name geGeomorph_ThemeAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toGeomorph
Description This relationship class defines the relationship between geGeomorph and geThemeAndFeature. A geomorphology feature can be in multiple themes.

Origin Class Name Origin Primary Key Origin Foreign Key
geGeomorph featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geThemeAndFeature

geThematicClass_ThemeAndFeature - RelationshipClass

Name geThematicClass_ThemeAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel contains
BackwardPathLabel toThematicClass
Description This relationship class defines the relationship between geThematicClass and geThemeAndFeature. A thematic class can have many features.

Origin Class Name Origin Primary Key Origin Foreign Key
geThematicClass themeClassificationID themeClassificationID

Destination Class Name Destination Primary Key Destination Foreign Key
geThemeAndFeature

geUnit_Composition - RelationshipClass

Name geUnit_Composition
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel composedOf
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geUnit and geCompositionPart.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnit featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geCompositionPart

geUnit_EventAndFeature - RelationshipClass

Name geUnit_EventAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel affectedBy
BackwardPathLabel toUnit
Description This relationship class defines the relationship between geUnit and geEventAndFeature. A geologic unit feature can be affected by multiple geologic events.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnit featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geEventAndFeature

geUnit_geThemeAndFeature - RelationshipClass

Name geUnit_geThemeAndFeature
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel memberOf
BackwardPathLabel toUnit
Description This relationship class defines the relationship between geUnit and geThemeAndFeature. A geologic unit feature can be in multiple themes.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnit featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geThemeAndFeature

geUnit_MappedInterval - RelationshipClass

Name geUnit_MappedInterval
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel occursAt
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geUnit and geMappedInterval. A feature in geUnit can occur at a MappedInterval.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnit featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geMappedInterval

geUnit_UnitL - RelationshipClass

Name geUnit_UnitL
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geUnit and geUnitL. A feature in geUnit has one or many geUnitL.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnit featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geUnitL

geUnit_UnitP - RelationshipClass

Name geUnit_UnitP
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geUnit and geUnitP. A feature in geUnit has one or many geUnitP.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnit featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geUnitP

geUnit_UnitS - RelationshipClass

Name geUnit_UnitS
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel has
BackwardPathLabel belongsTo
Description This relationship class defines the relationship between geUnit and geUnitS. A feature in geUnit has one or many geUnitS.

Origin Class Name Origin Primary Key Origin Foreign Key
geUnit featureID featureID

Destination Class Name Destination Primary Key Destination Foreign Key
geUnitS

hgAqSys_HGUnitGeStructure - RelationshipClass

Name hgAqSys_HGUnitGeStructure
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquiferSystem and hgHGUnitGeStructure.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquiferSystem ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgHGUnitGeStructure

hgAqSystem_Aquifer - RelationshipClass

Name hgAqSystem_Aquifer
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquiferSystem and hgAquitard.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquiferSystem ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquitard

hgAquiclude_hgAquicludeS - RelationshipClass

Name hgAquiclude_hgAquicludeS
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid
Description This relationship class defines the relationship between hgAquiclude and hgAquicludeS.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquiclude ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquicludeS

hgAquiclude_HGUnitGeStructure - RelationshipClass

Name hgAquiclude_HGUnitGeStructure
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquiclude and hgHGUnitGeStructure.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquiclude ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgHGUnitGeStructure

hgAquifer_activeWellP - RelationshipClass

Name hgAquifer_activeWellP
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel isExploited
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquifer and hgActiveWellP.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquifer ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgActiveWellP

hgAquifer_AquitardAquifer - RelationshipClass

Name hgAquifer_AquitardAquifer
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid2
Description This relationship class defines the relationship between hgAquifer and hgAquitardAquifer.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquifer ifcid rid2

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquitardAquifer

hgAquifer_hgAquiferS - RelationshipClass

Name hgAquifer_hgAquiferS
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid
Description This relationship class defines the relationship between hgAquifer and hgAquiferS.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquifer ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquiferS

hgAquifer_hgObjNaturalP - RelationshipClass

Name hgAquifer_hgObjNaturalP
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid2
Description This relationship class defines the relationship between hgAquifer and hgHyGeObjNaturalP.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquifer ifcid rid2

Destination Class Name Destination Primary Key Destination Foreign Key
hgHyGeObjNaturalP

hgAquifer_HGUnitGeStructure - RelationshipClass

Name hgAquifer_HGUnitGeStructure
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquifer and hgHGUnitGeStructure.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquifer ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgHGUnitGeStructure

hgAquiferSystem_aquiclude - RelationshipClass

Name hgAquiferSystem_aquiclude
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquiferSystem and hgAquiclude.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquiferSystem ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquiclude

hgAquiferSystem_aquifer - RelationshipClass

Name hgAquiferSystem_aquifer
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquiferSystem and hgAquifer.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquiferSystem ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquifer

hgAquiferSystem_hgAquiferSystemS - RelationshipClass

Name hgAquiferSystem_hgAquiferSystemS
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid
Description This relationship class defines the relationship between hgAquiferSystem and hgAquiferSystemS.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquiferSystem ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquiferSystemS

hgAquitard_AquitardAquifer - RelationshipClass

Name hgAquitard_AquitardAquifer
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquitard and hgAquitardAquifer.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquitard ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquitardAquifer

hgAquitard_hgAquitardS - RelationshipClass

Name hgAquitard_hgAquitardS
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid
Description This relationship class defines the relationship between hgAquitard and hgAquitardS.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquitard ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
hgAquitardS

hgAquitard_HGUnitGeStructure - RelationshipClass

Name hgAquitard_HGUnitGeStructure
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel ifcid
BackwardPathLabel rid1
Description This relationship class defines the relationship between hgAquitard and hgHGUnitGeStructure.

Origin Class Name Origin Primary Key Origin Foreign Key
hgAquitard ifcid rid1

Destination Class Name Destination Primary Key Destination Foreign Key
hgHGUnitGeStructure

hgActiveWellTypeValue - Domain

DomainName hgActiveWellTypeValue
FieldType String
Domain Type CodedValue

Code Name
decontamination decontamination
dewatering dewatering
disposal disposal
exploitation exploitation
observation observation
Other Other
recharge recharge
thermal thermal
water exploratory water exploratory
water supply water supply
withdrawal withdrawal


hgAqMediaTypeValue - Domain

DomainName hgAqMediaTypeValue
FieldType String
Domain Type CodedValue

Code Name
compound compound
fractured fractured
karstic karstic
karstic and fractured karstic and fractured
other other
porous porous
porous and fractured porous and fractured


hgAquiferTypeValue - Domain

DomainName hgAquiferTypeValue
FieldType String
Domain Type CodedValue

Code Name
confined artesian confined artesian
confined subartesian confined subartesian
unconfined unconfined


hgConOfGroundwaterValue - Domain

DomainName hgConOfGroundwaterValue
FieldType String
Domain Type CodedValue

Code Name
lightly modified lightly modified
modified modified
natural natural
strongly modified strongly modified
unknown unknown


hgHydroGeochemRockTypeValue - Domain

DomainName hgHydroGeochemRockTypeValue
FieldType String
Domain Type CodedValue

Code Name
carbonatic carbonatic
chloridic chloridic
organic organic
silicatic silicatic
sulfatic sulfatic


hgNaturalObjectTypeValue - Domain

DomainName hgNaturalObjectTypeValue
FieldType String
Domain Type CodedValue

Code Name
fen fen
not specified not specified
other other
seep seep
spring spring
swallow hole swallow hole


hgStatusCodeTypeValue - Domain

DomainName hgStatusCodeTypeValue
FieldType String
Domain Type CodedValue

Code Name
abandoned abandoned
abandoneddry abandoneddry
abandonedinsufficientwater abandonedinsufficientwater
abandonedpoorwaterquality abandonedpoorwaterquality
deepened deepened
new new
not in use not in use
reconditioned reconditioned
standby standby
unfinished unfinished
unknown unknown


hgWaterPersistenceValue - Domain

DomainName hgWaterPersistenceValue
FieldType String
Domain Type CodedValue

Code Name
ephemeral ephemeral
intermittent intermittent
not specified not specified
perennial perennial
seasonal seasonal


hgWaterSalinityValue - Domain

DomainName hgWaterSalinityValue
FieldType String
Domain Type CodedValue

Code Name
acratopegae acratopegae
brackish water brackish water
brine water brine water
fresh water fresh water
saline water saline water
salt water salt water
ultra fresh water ultra fresh water


VoidReasonValue - Domain

DomainName VoidReasonValue
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 No reason given
1 Unknown
2 Unpopulated
3 Withheld