Attachment Figures 1 and 2.pdf
PDF 1 MB Posted
- Opportunity number
- G26AS00102
About this file
This document contains technical schematic illustrations and an entity relationship diagram describing the structure of a mine waste database system.
Figure 1 presents an entity relationship diagram for the Mine Waste Inventory database, which organizes information across five primary data tables: Points Feature Class, Polygons Feature Class, Resources Table, Geology Table, and References Table. The Points Feature Class stores site identifiers, site names, feature identifiers, feature names, and various descriptive attributes including feature type, commodity classification, state, county, geographic coordinates, land management information, mine name, mining district, and reclaimed or superfund designations. The Polygons Feature Class maintains similar identifying information with additional fields for feature type degree of certainty, location descriptions, remarks, and citation data. The Resources Table contains detailed inventory data including reported and calculated volumes with unit designations, tonnage factors, material types and amounts, grade classifications, and contained commodity amounts with associated units and resource codes. The Geology Table documents deposit types, commodities, ore minerals, gangue minerals, and supporting citation information. The References Table tracks citations, references, and data entry metadata. All tables are linked through Site ID and Feature ID fields, with maintained audit trails for data entry and update information.
Figure 2 illustrates the hierarchical relationship between mining sites and individual mine features, demonstrating that a site functions as a cluster containing multiple feature types including adits, mine dumps, open pits, ore stockpiles, and tailings facilities. Only mine waste features (mine dumps, ore stockpiles, tailings undifferentiated, and tailings ponds) are entered into the mine waste database, with each feature maintaining separate point and polygon records plus associated reference and resource table entries. The diagram indicates that when geology conditions are consistent across features within a site, a single geology record at the site level can document conditions for all four mine waste features, reducing data redundancy.
Attachment Figures 1 and 2.pdf
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Figure 1. Entity relation diagram showing the structure of the mine waste database.
Figure 2. Schematic illustration, not to any scale, showing the relationships between a site and mine features. The site is the cluster of features. As drawn, the site contains six features: one adit, one mine dump, one open pit, one ore stockpile, one tailings – undifferentiated, and one tailings – pond. Only the four mine waste features (i.e., one mine dump, one ore stockpile, one tailings – undifferentiated, and one tailings – pond) would be entered into the mine waste database. Each of those features would have their own point and polygon feature class records, as well as their associated records in the reference and resources tables. If the geology in the open pit and underground workings is similar, the geology records can be populated at the site level, and only one record is needed that documents the geology for all four mine waste features.
File details come from the government source that posted it. Updated .