The MR geodatabase template implements the INSPIRE mineral resources application schema within the Mineral Resource data theme.
To view the geodatabase model diagram, please refer to
MR_model1.pdf and MR_model2.pdf.
This document only provides ArcGIS geodatabase specific implementation details. For original description of each fields, please refer to the equivalent UML description in the Mineral Resources (MR) section of INSPIRE documentation. While creating the ArcGIS for INSPIRE geodatabase templates implementation of the INSPIRE UML, some general guidelines about identifiers, code lists, flattening of INSPIRE data types, attribute definitions, relationships, etc. are developed and followed, those information is available at here (to be updated).
Feature Datasets and Feature Classes
MR - Feature DatasetTables
mrCommodityRelationship Classes
mrCommodityMeas_CommodityDomains
ValueQualifierCodeMR - FeatureDataset
Name | MR |
Description | This feature dataset contains the feature classes for the INSPIRE Mineral Resources data theme. |
mrMineralOccurrenceL - FeatureClass
Name | mrMineralOccurrenceL |
ShapeType | Polyline |
FeatureType | Simple |
HasM | false |
HasZ | false |
Description | This feature class contains line type spatial features of mineral occurrence. |
Field | DataType (Length) | UML Source | Description |
mappingFrame_code | String(255) | ge.Geology.MappedFeature.mappingFrame | Code for mappingFrame. EXAMPLE: baseOfQuaternary |
mappingFrame_label | String(255) | ge.Geology.MappedFeature.mappingFrame | Label for mappingFrame. EXAMPLE: base of quaternary |
mappingFrame_uri | String(255) | ge.Geology.MappedFeature.mappingFrame | Uri for mappingFrame. EXAMPLE: http://inspire.ec.europa.eu/codelist/MappingFrameValue/baseOfQuaternary |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMineralOccurrence.IFCID |
mrMineralOccurrenceP - FeatureClass
Name | mrMineralOccurrenceP |
ShapeType | Point |
FeatureType | Simple |
HasM | false |
HasZ | false |
Description | This feature class contains point type spatial features of mineral occurrence. |
Field | DataType (Length) | UML Source | Description |
mappingFrame_code | String(255) | ge.Geology.MappedFeature.mappingFrame | Code for mappingFrame. EXAMPLE: baseOfQuaternary |
mappingFrame_label | String(255) | ge.Geology.MappedFeature.mappingFrame | Label for mappingFrame. EXAMPLE: base of quaternary |
mappingFrame_uri | String(255) | ge.Geology.MappedFeature.mappingFrame | Uri for mappingFrame. EXAMPLE: http://inspire.ec.europa.eu/codelist/MappingFrameValue/baseOfQuaternary |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme. |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMineralOccurrence.IFCID |
mrMineralOccurrenceS - FeatureClass
Name | mrMineralOccurrenceS |
ShapeType | Polygon |
FeatureType | Simple |
HasM | false |
HasZ | false |
Description | This feature class contains polygon type spatial features of mineral occurrence. |
Field | DataType (Length) | UML Source | Description |
mappingFrame_code | String(255) | ge.Geology.MappedFeature.mappingFrame | Code for mappingFrame. EXAMPLE: baseOfQuaternary |
mappingFrame_label | String(255) | ge.Geology.MappedFeature.mappingFrame | Label for mappingFrame. EXAMPLE: base of quaternary |
mappingFrame_uri | String(255) | ge.Geology.MappedFeature.mappingFrame | Uri for mappingFrame. EXAMPLE: http://inspire.ec.europa.eu/codelist/MappingFrameValue/baseOfQuaternary |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMineralOccurrence.IFCID |
mrMiningFeatureOccurrenceL - FeatureClass
Name | mrMiningFeatureOccurrenceL |
ShapeType | Polyline |
FeatureType | Simple |
SubtypeFieldName | SubtypeCode |
HasM | false |
HasZ | false |
Description | This feature class contains line type spatial features of mining feature occurrence. |
Field | DataType (Length) | UML Source | Description |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme. |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMine.IFCID |
SubtypeCode | SmallInteger(2) | _ | 1 - for Mine spatial features, 2 - for MiningActivity spatial features |
Subtype Code | Subtype Name | Field Info |
1 | mrMineL | |
2 | mrMiningActivitiesL |
mrMiningFeatureOccurrenceP - FeatureClass
Name | mrMiningFeatureOccurrenceP |
ShapeType | Point |
FeatureType | Simple |
SubtypeFieldName | SubtypeCode |
HasM | false |
HasZ | false |
Description | This feature class contains point type spatial features of mining feature occurrence. |
Field | DataType (Length) | UML Source | Description |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme. |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMine.IFCID |
SubtypeCode | SmallInteger(2) | _ | 1 - for Mine spatial features, 2 - for MiningActivity spatial features |
Subtype Code | Subtype Name | Field Info |
1 | mrMineP | |
2 | mrMiningActivitiesP |
mrMiningFeatureOccurrenceS - FeatureClass
Name | mrMiningFeatureOccurrenceS |
ShapeType | Polygon |
FeatureType | Simple |
SubtypeFieldName | SubtypeCode |
HasM | false |
HasZ | false |
Description | This feature class contains polygon type spatial features of mining feature occurrence. |
Field | DataType (Length) | UML Source | Description |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme. |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMine.IFCID |
SubtypeCode | SmallInteger(2) | _ | 1 - for Mine spatial features, 2 - for MiningActivity spatial features |
Subtype Code | Subtype Name | Field Info |
1 | mrMineS | |
2 | mrMiningActivitiesS |
mrCommodity - Table
Name | mrCommodity |
Description | This table contains information from INSPIRE UML MR.MineralResources.Commodity. |
Field | DataType (Length) | UML Source | Description |
commodity_code | String(255) | MR.MineralResources.Commodity.commodity | Please refer to the equivalent UML description in the INSPIRE documentation |
commodity_label | String(255) | MR.MineralResources.Commodity.commodity | Please refer to the equivalent UML description in the INSPIRE documentation |
commodity_symbolSize | SmallInteger(2) | _ | It is the symbol size used for commodity features |
commodity_uri | String(255) | MR.MineralResources.Commodity.commodity | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityImportance_code | String(255) | MR.MineralResources.Commodity.commodityImportance | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityImportance_label | String(255) | MR.MineralResources.Commodity.commodityImportance | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityImportance_uri | String(255) | MR.MineralResources.Commodity.commodityImportance | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityImportance_void | SmallInteger(2) | MR.MineralResources.Commodity.commodityImportance | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityRank | Integer(0) | MR.MineralResources.Commodity.commodityRank | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityRank_void | SmallInteger(2) | MR.MineralResources.Commodity.commodityRank | Please refer to the equivalent UML description in the INSPIRE documentation |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table |
RID1 | Integer(4) | _ | It is a foreign key in the table, it references mrMineralOccurrence.IFCID |
RID2 | Integer(4) | _ | It is a foreign key in the table, it references mrCommodityMeasure.IFCID |
mrCommodityMeasure - Table
Name | mrCommodityMeasure |
Description | This table contains information from INSPIRE UML MR.MineralResources.CommodityMeasure. |
Field | DataType (Length) | UML Source | Description |
commodityAmount_high | Double(8) | MR.MineralResources.CommodityMeasure.commodityAmount.value | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityAmount_low | Double(8) | MR.MineralResources.CommodityMeasure.commodityAmount.value | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityAmount_uom | String(255) | MR.MineralResources.CommodityMeasure.commodityAmount.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
commodityAmount_void | SmallInteger(2) | MR.MineralResources.CommodityMeasure.commodityAmount | Please refer to the equivalent UML description in the INSPIRE documentation |
cutOffGrade_low | Double(8) | MR.MineralResources.CommodityMeasure.cutOffGrade.value | The lowest concentration of a mineralized material that qualifies as ore in a given deposit (adapted from Neuendorf, 2005). |
cutOffGrade_high | Double(8) | MR.MineralResources.CommodityMeasure.cutOffGrade.value | The lowest concentration of a mineralized material that qualifies as ore in a given deposit (adapted from Neuendorf, 2005). |
cutOffGrade_uom | String(255) | MR.MineralResources.CommodityMeasure.cutOffGrade.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
cutOffGrade_void | SmallInteger(2) | MR.MineralResources.CommodityMeasure.cutOffGrade | Please refer to the equivalent UML description in the INSPIRE documentation |
grade_high | Double(8) | MR.MineralResources.CommodityMeasure.grade.value | Please refer to the equivalent UML description in the INSPIRE documentation |
grade_low | Double(8) | MR.MineralResources.CommodityMeasure.grade.value | Please refer to the equivalent UML description in the INSPIRE documentation |
grade_uom | String(255) | MR.MineralResources.CommodityMeasure.grade.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
grade_void | SmallInteger(2) | MR.MineralResources.CommodityMeasure | Please refer to the equivalent UML description in the INSPIRE documentation |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrOreMeasure.IFCID |
mrExplorationActivity - Table
Name | mrExplorationActivity |
Description | This table contains information from INSPIRE UML MR.MineralResources.ExplorationActivity. |
Field | DataType (Length) | UML Source | Description |
activityDuration_end | Date(8) | MR.MineralResources.ExplorationActivity.activityDuration | Please refer to the equivalent UML description in the INSPIRE documentation |
activityDuration_start | Date(8) | MR.MineralResources.ExplorationActivity.activityDuration | Please refer to the equivalent UML description in the INSPIRE documentation |
activityType_code | String(255) | MR.MineralResources.ExplorationActivity.activityType | Please refer to the equivalent UML description in the INSPIRE documentation |
activityType_label | String(255) | MR.MineralResources.ExplorationActivity.activityType | Please refer to the equivalent UML description in the INSPIRE documentation |
activityType_uri | String(255) | MR.MineralResources.ExplorationActivity.activityType | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_1_code | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_1_label | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_1_uri | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_2_code | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_2_label | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_2_uri | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_3_code | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_3_label | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationResult_3_uri | String(255) | MR.MineralResources.ExplorationActivity.explorationResult | Please refer to the equivalent UML description in the INSPIRE documentation |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMineralOccurrence.IFCID |
mrMine - Table
Name | mrMine |
Description | This table contains information from INSPIRE UML MR.MineralResources.Mine. |
Field | DataType (Length) | UML Source | Description |
id_localId | String(255) | MR.MineralResources.MiningFeature.inspireId | A local identifier assigned by the data provider. The local identifier is unique within the namespace, that is no other spatial object carries the same unique identifier. NOTE: It is the responsibility of the data provider to guarantee uniqueness of the local identifier within the namespace. |
id_namespace | String(255) | MR.MineralResources.MiningFeature.inspireId | Namespace that uniquely identifies the data source of the spatial object. NOTE: The namespace value will be owned by the data provider of the spatial object and will be registered in the INSPIRE External Object Identifier Namespaces Register. |
id_versionId | String(255) | MR.MineralResources.MiningFeature.inspireId | The identifier of the particular version of the spatial object with a maximum length of 25 characters. If the specification of a spatial object type with an external object identifier includes life cycle information, the version identifier is used to distinguish between the different versions of a spatial object. Within the set of all versions of a spatial object, the version identifier is unique. NOTE: The maximum length has been selected to allow for time stamps based on ISO 8601, for example, 2007-02-12T12:12:12+05:30 as the version identifier. |
id_versionId_void | String(50) | MR.MineralResources.MiningFeature.inspireId | This field indicates whether the property in field id_versionId is NIL. If the field id_versionId_void is NULL, then the property is not NIL, and the value in field id_versionId applies. If the value is 0, the property is NIL with no additional information about the reason for the NIL value. If the value is 1, the property is NIL with a reason of Unknown. If the value is 2, the property is NIL with a reason of Unpopulated. |
beginLifespanVersion | Date(8) | MR.MineralResources.Mine.beginLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
beginLifespanVersion_void | SmallInteger(0) | MR.MineralResources.Mine.beginLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
endDate | Date(8) | MR.MineralResources.Mine.endDate | Please refer to the equivalent UML description in the INSPIRE documentation |
endDate_void | SmallInteger(2) | MR.MineralResources.Mine.endDate | Please refer to the equivalent UML description in the INSPIRE documentation |
endLifespanVersion | Date(8) | MR.MineralResources.Mine.endLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
endLifespanVersion_void | SmallInteger(2) | MR.MineralResources.Mine.endLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme. |
minename_1 | String(255) | MR.MineralResources.Mine.mineName.mineName | Please refer to the equivalent UML description in the INSPIRE documentation |
minename_1_isPreferred | SmallInteger(2) | MR.MineralResources.Mine.mineName.isPreferred | Please refer to the equivalent UML description in the INSPIRE documentation |
minename_2 | String(255) | MR.MineralResources.Mine.mineName.mineName | Please refer to the equivalent UML description in the INSPIRE documentation |
minename_2_isPreferred | SmallInteger(2) | MR.MineralResources.Mine.mineName.isPreferred | Please refer to the equivalent UML description in the INSPIRE documentation |
minename_3 | String(255) | MR.MineralResources.Mine.mineName.mineName | Please refer to the equivalent UML description in the INSPIRE documentation |
minename_3_isPreferred | SmallInteger(2) | MR.MineralResources.Mine.mineName.isPreferred | Please refer to the equivalent UML description in the INSPIRE documentation |
miningActivity_void | SmallInteger(2) | _ | This field defines if the mining activity of the mine is void. if this field is populated, then there is no need for related record in the mrMiningActivity table |
relatedMine_void | SmallInteger(2) | _ | This field defines if the related mine of the mine is void. if this field is populated, then there is no need for related record in the mrMiningActivity table |
sourceReference | String(4000) | MR.MineralResources.Mine.sourceReference | Please refer to the equivalent UML description in the INSPIRE documentation. It can be a URI link (such as "http://...") to the source referenced. |
sourceReference_void | SmallInteger(2) | MR.MineralResources.Mine.sourceReference | Please refer to the equivalent UML description in the INSPIRE documentation |
startDate | Date(8) | MR.MineralResources.Mine.startDate | Please refer to the equivalent UML description in the INSPIRE documentation |
startDate_void | SmallInteger(2) | MR.MineralResources.Mine.startDate | Please refer to the equivalent UML description in the INSPIRE documentation |
status_code | String(255) | MR.MineralResources.Mine.status | Please refer to the equivalent UML description in the INSPIRE documentation |
status_label | String(255) | MR.MineralResources.Mine.status | Please refer to the equivalent UML description in the INSPIRE documentation |
status_uri | String(255) | MR.MineralResources.Mine.status | Please refer to the equivalent UML description in the INSPIRE documentation |
mrMineralDepositModel - Table
Name | mrMineralDepositModel |
Description | This table contains information from INSPIRE UML MR.MineralResources.MineralDepositModel. |
Field | DataType (Length) | UML Source | Description |
IFCID | Integer(4) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Identifier, the value must be unique in the table |
mineralDepositGroup_1_code | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_1_label | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_1_uri | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_2_code | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_2_label | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_2_uri | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_3_code | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_3_label | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositGroup_3_uri | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositGroup | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_1_code | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_1_label | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_1_uri | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_2_code | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_2_label | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_2_uri | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_3_code | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_3_label | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_3_uri | String(255) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mineralDepositType_void | SmallInteger(2) | MR.MineralResources.MineralDepositModel.mineralDepositType | Please refer to the equivalent UML description in the INSPIRE documentation |
mrMineralOccurrence - Table
Name | mrMineralOccurrence |
Description | This table contains information from INSPIRE UML MR.MineralResources.MineralOccurrence as well as information inherited from GE.Geology.GeologicFeature, MR.MineralResources.EarthResource, etc. |
Field | DataType (Length) | UML Source | Description |
featureName | String(255) | GE.Geology.GeologicFeature.name | This field is inherited from GE.Geology.GeologicFeature.name |
featureName_void | SmallInteger(2) | GE.Geology.GeologicFeature.name | This field is inherited from GE.Geology.GeologicFeature.name |
geologicHistory_void | SmallInteger(2) | GE.Geology.GeologicEvent.geologicHistory | This field defines if the geological history information is void, if this field is populated, then there is no need for related record in the geEventAndFeature and geGeologicEvent table |
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.ThematicClass.themeClass | This field defines if the theme Classification information is void, if this field is populated, then there is no need for related record in the geThemeAndFeature and geThematicClass table |
beginLifespanVersion | Date(0) | MR.MineralResources.EarthResource.beginLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
beginLifespanVersion_void | SmallInteger(2) | MR.MineralResources.EarthResource.beginLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
classification_void | SmallInteger(2) | MR.MineralResources.MineralDepositModel.classification | This field defines if the MineralDepositModel classification information is void, if this field is populated, then there is no need for related record in the mrMineralDepositModel table |
dim_area_high | Double(8) | MR.MineralResources.EarthResource.dimension.area.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_area_low | Double(8) | MR.MineralResources.EarthResource.dimension.area.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_area_uom | String(255) | MR.MineralResources.EarthResource.dimension.area | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_area_void | SmallInteger(2) | MR.MineralResources.EarthResource.dimension.area | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_high | Double(8) | MR.MineralResources.EarthResource.dimension.depth.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_low | Double(8) | MR.MineralResources.EarthResource.dimension.depth.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_uom | String(255) | MR.MineralResources.EarthResource.dimension.depth | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_void | SmallInteger(2) | MR.MineralResources.EarthResource.dimension.depth | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_high | Double(8) | MR.MineralResources.EarthResource.dimension.length.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_low | Double(8) | MR.MineralResources.EarthResource.dimension.length.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_uom | String(255) | MR.MineralResources.EarthResource.dimension.length | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_void | SmallInteger(2) | MR.MineralResources.EarthResource.dimension.length | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_void | String(255) | MR.MineralResources.EarthResource.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_high | Double(8) | MR.MineralResources.EarthResource.dimension.width.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_low | Double(8) | MR.MineralResources.EarthResource.dimension.width.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_uom | String(255) | MR.MineralResources.EarthResource.dimension.width | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_void | SmallInteger(2) | MR.MineralResources.EarthResource.dimension.width | Please refer to the equivalent UML description in the INSPIRE documentation |
endLifespanversion | Date(0) | MR.MineralResources.EarthResource.endLifespanversion | Please refer to the equivalent UML description in the INSPIRE documentation |
endLifespanversion_void | SmallInteger(2) | MR.MineralResources.EarthResource.endLifespanversion | Please refer to the equivalent UML description in the INSPIRE documentation |
exp1_value | String(255) | MR.MineralResources.EarthResource.expression | Please refer to the equivalent UML description in the INSPIRE documentation |
exp2_value | String(255) | MR.MineralResources.EarthResource.expression | Please refer to the equivalent UML description in the INSPIRE documentation |
exp3_value | String(255) | MR.MineralResources.EarthResource.expression | Please refer to the equivalent UML description in the INSPIRE documentation |
explorationActivity_void | SmallInteger(2) | MR.MineralResources.ExplorationActivity.explorationHistory | This field defines if exploration activity information is void, if this field is populated, then there is no need for related record in the mrExplorationActivity table |
expression_void | SmallInteger(2) | MR.MineralResources.EarthResource.expression | Please refer to the equivalent UML description in the INSPIRE documentation |
form_void | SmallInteger(2) | MR.MineralResources.EarthResource.form | Please refer to the equivalent UML description in the INSPIRE documentation |
form1_value | String(255) | MR.MineralResources.EarthResource.form | Please refer to the equivalent UML description in the INSPIRE documentation |
form3_value | String(255) | MR.MineralResources.EarthResource.form | Please refer to the equivalent UML description in the INSPIRE documentation |
form2_value | String(255) | MR.MineralResources.EarthResource.form | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_cgivector_mag_high | double(8) | MR.MineralResources.EarthResource.linearOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_cgivector_mag_low | double(8) | MR.MineralResources.EarthResource.linearOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_cgivector_mag_uom | String(255) | MR.MineralResources.EarthResource.linearOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_directed_code | String(255) | MR.MineralResources.EarthResource.linearOrientation.directed | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_directed_label | String(255) | MR.MineralResources.EarthResource.linearOrientation.directed | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_directed_uri | String(255) | MR.MineralResources.EarthResource.linearOrientation.directed | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_directed_void | SmallInteger(2) | MR.MineralResources.EarthResource.linearOrientation.directed | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dMethod_code | String(255) | MR.MineralResources.EarthResource.linearOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dMethod_label | String(255) | MR.MineralResources.EarthResource.linearOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dMethod_uri | String(255) | MR.MineralResources.EarthResource.linearOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dMethod_void | SmallInteger(2) | MR.MineralResources.EarthResource.linearOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dOri_qualifier | String(255) | MR.MineralResources.EarthResource.linearOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dOri_value_code | String(255) | MR.MineralResources.EarthResource.linearOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dOri_value_label | String(255) | MR.MineralResources.EarthResource.linearOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dOri_value_uri | String(255) | MR.MineralResources.EarthResource.linearOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_dOri_void | SmallInteger(2) | MR.MineralResources.EarthResource.linearOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_plunge_high | Double(8) | MR.MineralResources.EarthResource.linearOrientation.plunge | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_plunge_low | Double(8) | MR.MineralResources.EarthResource.linearOrientation.plunge | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_plunge_uom | String(255) | MR.MineralResources.EarthResource.linearOrientation.plunge | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_plunge_void | SmallInteger(2) | MR.MineralResources.EarthResource.linearOrientation.plunge | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_trend_high | Double(8) | MR.MineralResources.EarthResource.linearOrientation.trend | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_trend_low | Double(8) | MR.MineralResources.EarthResource.linearOrientation.trend | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_trend_uom | String(255) | MR.MineralResources.EarthResource.linearOrientation.trend | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_trend_void | SmallInteger(2) | MR.MineralResources.EarthResource.linearOrientation.trend | Please refer to the equivalent UML description in the INSPIRE documentation |
linearO_void | SmallInteger(2) | MR.MineralResources.EarthResource.linearOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
miningActivity_void | SmallInteger(2) | MR.MineralResources.MiningActivity.resourceExtraction | This field defines if mining activity information is void, if this field is populated, then there is no need for related record in the mrMiningActivity table |
oreMeasure_void | SmallInteger(2) | MR.MineralResources.OreMeasure.oreAmount | This field defines if ore measure information is void, if this field is populated, then there is no need for related record in the mrOreMeasure table |
planarO_azimuth_high | Double(8) | MR.MineralResources.EarthResource.planarOrientation.azimuth | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_azimuth_low | Double(8) | MR.MineralResources.EarthResource.planarOrientation.azimuth | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_azimuth_uom | String(255) | MR.MineralResources.EarthResource.planarOrientation.azimuth | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_azimuth_void | SmallInteger(2) | MR.MineralResources.EarthResource.planarOrientation.azimuth | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_convention_code | String(255) | MR.MineralResources.EarthResource.planarOrientation.convention | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_convention_label | String(50) | MR.MineralResources.EarthResource.planarOrientation.convention | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_convention_uri | String(50) | MR.MineralResources.EarthResource.planarOrientation.convention | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dip_high | Double(8) | MR.MineralResources.EarthResource.planarOrientation.dip | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dip_low | Double(8) | MR.MineralResources.EarthResource.planarOrientation.dip | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dip_uom | String(255) | MR.MineralResources.EarthResource.planarOrientation.dip | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dip_void | SmallInteger(2) | MR.MineralResources.EarthResource.planarOrientation.dip | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dMethod_code | String(255) | MR.MineralResources.EarthResource.planarOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dMethod_label | String(255) | MR.MineralResources.EarthResource.planarOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dMethod_uri | String(255) | MR.MineralResources.EarthResource.planarOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dMethod_void | SmallInteger(2) | MR.MineralResources.EarthResource.planarOrientation.determinationMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dOri_qualifier | String(255) | MR.MineralResources.EarthResource.planarOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dOri_value_code | String(255) | MR.MineralResources.EarthResource.planarOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dOri_value_label | String(255) | MR.MineralResources.EarthResource.planarOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dOri_value_uri | String(255) | MR.MineralResources.EarthResource.planarOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_dOri_void | SmallInteger(2) | MR.MineralResources.EarthResource.planarOrientation.descriptiveOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_polarity_code | String(255) | MR.MineralResources.EarthResource.planarOrientation.polarity | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_polarity_label | String(50) | MR.MineralResources.EarthResource.planarOrientation.polarity | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_polarity_uri | String(50) | MR.MineralResources.EarthResource.planarOrientation.polarity | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_polarity_void | SmallInteger(2) | MR.MineralResources.EarthResource.planarOrientation.polarity | Please refer to the equivalent UML description in the INSPIRE documentation |
planarO_void | SmallInteger(2) | MR.MineralResources.EarthResource.planarOrientation | Please refer to the equivalent UML description in the INSPIRE documentation |
shape_void | SmallInteger(2) | MR.MineralResources.EarthResource.shape | Please refer to the equivalent UML description in the INSPIRE documentation |
shape1_value | String(255) | MR.MineralResources.EarthResource.shape | Please refer to the equivalent UML description in the INSPIRE documentation |
shape2_value | String(255) | MR.MineralResources.EarthResource.shape | Please refer to the equivalent UML description in the INSPIRE documentation |
shape3_value | String(255) | MR.MineralResources.EarthResource.shape | Please refer to the equivalent UML description in the INSPIRE documentation |
sourceReference | String(4000) | MR.MineralResources.EarthResource.sourceReference | Please refer to the equivalent UML description in the INSPIRE documentation. It can be a URI link (such as "http://...") to the source referenced. |
sourceReference_void | SmallInteger(2) | MR.MineralResources.EarthResource.sourceReference | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_1_code | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_1_label | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_1_uri | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_2_code | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_2_label | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_2_uri | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_3_code | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_3_label | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_3_uri | String(255) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
endusePotential_void | SmallInteger(2) | MR.MineralResources.MineralOccurrence.endusePotential | Please refer to the equivalent UML description in the INSPIRE documentation |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme. |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMineralDepositModel.IFCID |
type_code | String(255) | MR.MineralResources.MineralOccurrence.type | Please refer to the equivalent UML description in the INSPIRE documentation |
type_label | String(255) | MR.MineralResources.MineralOccurrence.type | Please refer to the equivalent UML description in the INSPIRE documentation |
type_uri | String(255) | MR.MineralResources.MineralOccurrence.type | Please refer to the equivalent UML description in the INSPIRE documentation |
mrMiningActivity - Table
Name | mrMiningActivity |
Description | This table contains information from INSPIRE UML MR.MineralResources.MiningActivity as well as information inherited from MR.MineralResources.MiningFeature, etc. |
Field | DataType (Length) | UML Source | Description |
id_localId | String(255) | MR.MineralResources.MiningFeature.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_namespace | String(255) | MR.MineralResources.MiningFeature.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId | String(255) | MR.MineralResources.MiningFeature.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId_void | String(50) | MR.MineralResources.MiningFeature.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
activityDuration_end | Date(8) | MR.MineralResources.MiningActivity.activityDuration | Please refer to the equivalent UML description in the INSPIRE documentation |
activityDuration_start | Date(8) | MR.MineralResources.MiningActivity.activityDuration | Please refer to the equivalent UML description in the INSPIRE documentation |
activityType_code | String(255) | MR.MineralResources.MiningActivity.activityType | Please refer to the equivalent UML description in the INSPIRE documentation |
activityType_label | String(255) | MR.MineralResources.MiningActivity.activityType | Please refer to the equivalent UML description in the INSPIRE documentation |
activityType_uri | String(255) | MR.MineralResources.MiningActivity.activityType | Please refer to the equivalent UML description in the INSPIRE documentation |
earthResource_void | SmallInteger(2) | MR.MineralResources.EarthResource.deposit | This field defines whether earth resource information is void, if this field is populated, then there is no need for related record in the mrMineralOccurrence table |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table, and unique throughout Mineral Resource and Geology Theme. |
mine_void | SmallInteger(2) | MR.MineralResources.Mine.associatedMine | This field defines whether related mine information is void. |
oreProcessed_uom | String(255) | MR.MineralResources.MiningActivity.oreProcessed | Please refer to the equivalent UML description in the INSPIRE documentation |
oreProcessed_value | Integer(4) | MR.MineralResources.MiningActivity.oreProcessed | Please refer to the equivalent UML description in the INSPIRE documentation |
oreProcessed_void | SmallInteger(2) | MR.MineralResources.MiningActivity.oreProcessed | Please refer to the equivalent UML description in the INSPIRE documentation |
processingType_code | String(255) | MR.MineralResources.MiningActivity.processingType | Please refer to the equivalent UML description in the INSPIRE documentation |
processingType_label | String(255) | MR.MineralResources.MiningActivity.processingType | Please refer to the equivalent UML description in the INSPIRE documentation |
processingType_uri | String(255) | MR.MineralResources.MiningActivity.processingType | Please refer to the equivalent UML description in the INSPIRE documentation |
RID1 | Integer(4) | _ | It is a foreign key in the table, it references mrMine.IFCID |
RID2 | Integer(4) | _ | It is a foreign key in the table, it references mrMineralOccurrence.IFCID |
mrOreMeasure - Table
Name | mrOreMeasure |
SubtypeFieldName | subtypeCode |
Description | This table contains information from INSPIRE UML MR.MineralResources.OreMeasure. |
Field | DataType (Length) | UML Source | Description |
category_code | String(255) | MR.MineralResources.OreMeasure.Resource.category MR.MineralResources.OreMeasure.Reserve.category |
Please refer to the equivalent UML description in the INSPIRE documentation For subtypeCode 1 (resource), it is the resource category value code For subtypeCode 2 (reserve), it is the reserve category value code For subtypeCode 3 (endowment), this field is not used |
category_label | String(255) | MR.MineralResources.OreMeasure.Resource.category MR.MineralResources.OreMeasure.Reserve.category |
Please refer to the equivalent UML description in the INSPIRE documentation For subtypeCode 1 (resource), it is the resource category value label For subtypeCode 2 (reserve), it is the reserve category value label For subtypeCode 3 (endowment), this field is not used |
category_uri | String(255) | MR.MineralResources.OreMeasure.Resource.category MR.MineralResources.OreMeasure.Reserve.category |
Please refer to the equivalent UML description in the INSPIRE documentation For subtypeCode 1 (resource), it is the resource category value uri For subtypeCode 2 (reserve), it is the reserve category value uri For subtypeCode 3 (endowment), this field is not used |
classificationMethodUsed_code | String(255) | MR.MineralResources.OreMeasure.classificationMethodUsed | Please refer to the equivalent UML description in the INSPIRE documentation |
classificationMethodUsed_label | String(255) | MR.MineralResources.OreMeasure.classificationMethodUsed | Please refer to the equivalent UML description in the INSPIRE documentation |
classificationMethodUsed_uri | String(255) | MR.MineralResources.OreMeasure.classificationMethodUsed | Please refer to the equivalent UML description in the INSPIRE documentation |
date_ | Date(8) | MR.MineralResources.OreMeasure.date | Please refer to the equivalent UML description in the INSPIRE documentation Populate this field if it is a instant of date |
dateFrom | Date(8) | MR.MineralResources.OreMeasure.date | Please refer to the equivalent UML description in the INSPIRE documentation Populate this field if it is date period |
dateTo | Date(8) | MR.MineralResources.OreMeasure.date | Please refer to the equivalent UML description in the INSPIRE documentation Populate this field if it is date period |
dim_area_high | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_area_low | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_area_uom | String(255) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_area_void | SmallInteger(2) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_high | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_low | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_uom | String(255) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_depth_void | SmallInteger(2) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_high | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_low | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_uom | String(255) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_length_void | SmallInteger(2) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_void | SmallInteger(2) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_high | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_low | Double(8) | MR.MineralResources.OreMeasure.dimension.value | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_uom | String(255) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
dim_width_void | SmallInteger(2) | MR.MineralResources.OreMeasure.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
IFCID | Integer(4) | _ | Identifier, the value must be unique in the table |
includesReserves | SmallInteger(2) | MR.MineralResources.OreMeasure.Resource.includesReserves MR.MineralResources.OreMeasure.Endowment.includesReserves |
Please refer to the equivalent UML description in the INSPIRE documentation For subtypeCode 1 (resource), it is the resource include reserves option For subtypeCode 2 (reserve), this field is not used For subtypeCode 3 (endowment), it is the endowment include reserves option Boolean value should be 0 (no) or 1 (yes) |
includesReserves_void | SmallInteger(2) | MR.MineralResources.OreMeasure.Resource.includesReserves MR.MineralResources.OreMeasure.Endowment.includesReserves |
Please refer to the equivalent UML description in the INSPIRE documentation For subtypeCode 1 (resource), it is the resource include reserves option For subtypeCode 2 (reserve), this field is not used For subtypeCode 3 (endowment), it is the endowment include reserves option |
includesResources | SmallInteger(2) | MR.MineralResources.OreMeasure.Endowment.includesResources | Please refer to the equivalent UML description in the INSPIRE documentation For subtypeCode 1 (resource), this field is not used For subtypeCode 2 (reserve), this field is not used For subtypeCode 3 (endowment), it is the endowment include resources option Boolean value should be 0 (no) or 1 (yes) |
includesResources_void | SmallInteger(2) | MR.MineralResources.OreMeasure.Endowment.includesResources | Please refer to the equivalent UML description in the INSPIRE documentation For subtypeCode 1 (resource), this field is not used For subtypeCode 2 (reserve), this field is not used For subtypeCode 3 (endowment), it is the endowment include resources option |
ore_high | Double(255) | MR.MineralResources.OreMeasure.ore | Please refer to the equivalent UML description in the INSPIRE documentation |
ore_low | Double(8) | MR.MineralResources.OreMeasure.ore | Please refer to the equivalent UML description in the INSPIRE documentation |
ore_uom | String(255) | MR.MineralResources.OreMeasure.ore | Please refer to the equivalent UML description in the INSPIRE documentation |
proposedExtractionMethod | String(255) | MR.MineralResources.OreMeasure.proposedExtractionMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
proposedExtractionMethod_void | SmallInteger(2) | MR.MineralResources.OreMeasure.proposedExtractionMethod | Please refer to the equivalent UML description in the INSPIRE documentation |
RID | Integer(4) | _ | It is a foreign key in the table, it references mrMineralOccurrence.IFCID |
sourceReference | String(4000) | MR.MineralResources.OreMeasure.sourceReference | Please refer to the equivalent UML description in the INSPIRE documentation. It can be a URI link (such as "http://...") to the source referenced. |
subtypeCode | SmallInteger(2) | _ | 1 - Resource, 2 - Reserve, 3 - Endowment |
Subtype Code | Subtype Name | Field Info | |
1 | Resource |
Field:includesReserves_void Domain:VoidReasonValue DefaultValue: |
|
2 | Reserve | ||
3 | Endowment |
Field:includesReserves_void Domain:VoidReasonValue DefaultValue: |
Field:includesResources_void Domain:VoidReasonValue DefaultValue: |
mrRelatedMine - Table
Name | mrRelatedMine |
Description | This table contains information from INSPIRE UML MR.MineralResources.Mine.relatedMine. |
Field | DataType (Length) | UML Source | Description |
ID1 | Integer(4) | _ | It is a foreign key in the table, it references mrMine.IFCID |
ID2 | Integer(4) | _ | It is a foreign key in the table, it references mrMine.IFCID, it is the identifier for related mine |
mrCommodityMeas_Commodity - RelationshipClass
Name | mrCommodityMeas_Commodity |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | measures |
BackwardPathLabel | has |
Description | This relationship class defines the relationship between mrCommodityMeasure and mrCommodity. A commodity measure can be applied to one or many commodities. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrCommodityMeasure | IFCID | RID2 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrCommodity |
mrEarthResource_Commodity - RelationshipClass
Name | mrEarthResource_Commodity |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | commodityDescription |
BackwardPathLabel | originatedFrom |
Description | This relationship class defines the relationship between mrMineralOccurrence (EarthResource) and mrCommodity. A feature in mrMineralOccurrence can contain one or many commodities. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralOccurrence | IFCID | RID1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrCommodity |
mrErthRes_ExplorationAct - RelationshipClass
Name | mrErthRes_ExplorationAct |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasExplorationHistory |
BackwardPathLabel | of |
Description | This relationship class defines the relationship between mrMineralOccurrence (EarthResource) and mrExplorationActivity. A feature in mrMineralOccurrence can contain one or more features in mrExplorationActivity. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralOccurrence | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrExplorationActivity |
mrErthRes_MineralOccL - RelationshipClass
Name | mrErthRes_MineralOccL |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | has |
Description | This relationship class defines the relationship between mrMineralOccurrence (EarthResource) and mrMineralOccurrenceL. A feature in mrMineralOccurrence can have zero or more features in mrMineralOccurrenceL. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralOccurrence | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMineralOccurrenceL |
mrErthRes_MineralOccP - RelationshipClass
Name | mrErthRes_MineralOccP |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | has |
Description | This relationship class defines the relationship between mrMineralOccurrence (EarthResource) and mrMineralOccurrenceP. A feature in mrMineralOccurrence can have zero or more features in mrMineralOccurrenceP. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralOccurrence | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMineralOccurrenceP |
mrErthRes_MineralOccS - RelationshipClass
Name | mrErthRes_MineralOccS |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | OccursAt |
BackwardPathLabel | has |
Description | This relationship class defines the relationship between mrMineralOccurrence (EarthResource) and mrMineralOccurrenceS. A feature in mrMineralOccurrence can have zero or more features in mrMineralOccurrenceS. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralOccurrence | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMineralOccurrenceS |
mrEarthResource_OreMeasure - RelationshipClass
Name | mrEarthResource_OreMeasure |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | oreAmount |
BackwardPathLabel | originateFrom |
Description | This relationship class defines the relationship between mrMineralOccurrence (EarthResource) and mrOreMeasure. A feature in mrMineralOccurrence can have zero or more features in mrOreMeasure. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralOccurrence | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrOreMeasure |
mrMine_MiningActivity - RelationshipClass
Name | mrMine_MiningActivity |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | relatedActivity |
BackwardPathLabel | associatedMine |
Description | This relationship class defines the relationship between mrMine and mrMiningActivity. A feature in mrMine can have zero or more features in mrMiningActivity. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMine | IFCID | RID1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningActivity |
mrMine_MinFeatOccL - RelationshipClass
Name | mrMine_MinFeatOccL |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | belongsTo |
Description | This relationship class defines the relationship between mrMine and mrMiningFeatureOccurrenceL. A feature in mrMine can have zero to many mrMiningFeatureOccurrenceL feature(s), and a mrMiningFeatureOccurrenceL feature is always associated with a feature in mrMine. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMine | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningFeatureOccurrenceL |
mrMine_MinFeatOccP - RelationshipClass
Name | mrMine_MinFeatOccP |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | belongsTo |
Description | This relationship class defines the relationship between mrMine and mrMiningFeatureOccurrenceP. A feature in mrMine can have zero to many mrMiningFeatureOccurrenceP feature(s), and a mrMiningFeatureOccurrenceP feature is always associated with a feature in mrMine. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMine | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningFeatureOccurrenceP |
mrMine_MinFeatOccS - RelationshipClass
Name | mrMine_MinFeatOccS |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | belongsTo |
Description | This relationship class defines the relationship between mrMine and mrMiningFeatureOccurrenceS. A feature in mrMine can have zero to many mrMiningFeatureOccurrenceS feature(s), and a mrMiningFeatureOccurrenceS feature is always associated with a feature in mrMine. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMine | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningFeatureOccurrenceS |
mrMine_RelatedMine - RelationshipClass
Name | mrMine_RelatedMine |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | relatedTo |
BackwardPathLabel | relatedFrom |
Description | This relationship class defines the relationship between mrMine and mrRelatedMine. A feature in mrMine can have zero to many mrRelatedMine feature(s), and a mrRelatedMine feature is always associated with a feature in mrMine. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMine | IFCID | ID1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrRelatedMine |
mrMineralDepModel_ErthRes - RelationshipClass
Name | mrMineralDepModel_ErthRes |
Cardinality | OneToOne |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | model |
BackwardPathLabel | classification |
Description | This relationship class defines the relationship between mrMineralDepositModel and mrMineralOccurrence. A feature in mrMineralOccurrence can have one mrMineralDepositModel. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralDepositModel | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMineralOccurrence |
mrMinAct_ErthRes - RelationshipClass
Name | mrMinAct_ErthRes |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | extractedBy |
BackwardPathLabel | extracts |
Description | This relationship class defines the relationship between mrMineralOccurrence and mrMiningActivity. A feature in mrMineralOccurrence can have one to many mrMiningActivity. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMineralOccurrence | IFCID | RID2 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningActivity |
mrMinAct_MinFeatOccL - RelationshipClass
Name | mrMinAct_MinFeatOccL |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | belongsTo |
Description | This relationship class defines the relationship between mrMiningActivity and mrMiningFeatureOccurrenceL. A feature in mrMiningActivity can have zero to many mrMiningFeatureOccurrenceL with SubtypeCode=2. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMiningActivity | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningFeatureOccurrenceL |
mrMinAct_MinFeatOccP - RelationshipClass
Name | mrMinAct_MinFeatOccP |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | belongsTo |
Description | This relationship class defines the relationship between mrMiningActivity and mrMiningFeatureOccurrenceP. A feature in mrMiningActivity can have zero to many mrMiningFeatureOccurrenceP with SubtypeCode=2. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMiningActivity | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningFeatureOccurrenceP |
mrMinAct_MinFeatOccS - RelationshipClass
Name | mrMinAct_MinFeatOccS |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | occursAt |
BackwardPathLabel | belongsTo |
Description | This relationship class defines the relationship between mrMiningActivity and mrMiningFeatureOccurrenceS. A feature in mrMiningActivity can have zero to many mrMiningFeatureOccurrenceS with SubtypeCode=2. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrMiningActivity | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrMiningFeatureOccurrenceS |
mrOreMeas_CommodityMeas - RelationshipClass
Name | mrOreMeas_CommodityMeas |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | to |
BackwardPathLabel | from |
Description | This relationship class defines the relationship between mrOreMeasure and mrCommodityMeasure. A feature in mrOreMeasure can have zero to many mrCommodityMeasure. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
mrOreMeasure | IFCID | RID |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
mrCommodityMeasure |
ValueQualifierCode - Domain
DomainName | ValueQualifierCode |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
Always | Always |
approximate | Approximate |
common | Common |
greaterThan | Greater Than |
lessThan | Less Than |
never | Never |
rare | Rare |
sometimes | Sometimes |
VoidReasonValue - Domain
DomainName | VoidReasonValue |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
0 | No reason given |
1 | Unknown |
2 | Unpopulated |
3 | Withheld |