Survey Database Structure

Each Studio Survey database adheres to the following default schemas, although survey data folders can appear at multiple levels within the tree, depending on their assigned data scope.

Data is added to the database using Add to Database.

  • Declines (underground scenarios)
  • #Decline Name#
    • Areas
      Contains one or more area folders.
      • #Area Name 1#
        Contains all data relating to a particular underground mine area.
        • Levels
          Contains one or more level folders
          • #Level Name 1#
            Contains all data relating to an underground mine area.
            • Stopes
              Contains one or more stope folders
              • #Stope Name 1#
                Contains all data relating to particular stope.
    • Reports
      • Development Summary
        Contains the results of published Development Summary reports.
      • Stope Summary
        Contains the results published Stope Summary reports.
      • Memo
        Contains the results of published Memo reports.
    • Survey Jobs
      Contains the results of survey data processed by the SIM Module.
  • Pits (open pit scenarios)
    • #Pit Name#
      • Areas
        • #Area Name 1#
          Contains all data relating to a particular open pit mine area.
          • Benches
            Contains a table containing crest and toe elevations (and names) for each bench in the project. This is used to create per-bench information in output reports.
          • Blasts
            Contains a collection of data categorized by a unique blast ID. This will include generated blast volumes and an associated plot PDF file:
            • #BLAST ID#
              • Reports
          • Designed Pit Surfaces
            Contains designed surface data, as added to the database with the [Design Surfaces] data type specification. Used in Design Compliance EOM reports. Organized with date folders.
          • End of Period Pit Surfaces
            Contains end-of-period surfaces (e.g. as generated by Studio OP). Used in Plan Compliance EOM reports. Organized with date folders.
          • Natural Pit Surfaces
            Contains one or more natural surface files representing the unmined area. Used in Pit Actual EOM reports.
            • #SURFACE NAME#
          • Pit Blast Bottom Surfaces
            Contains 3D contact surface data that will be used to constrain a blast volume, if it intercepts it above the defined reference level and within the established blast boundary.
            • #REFERENCE NAME#
          • Pit Excavation Boundaries
            Contains one or more pit perimeter strings for the current area. Used (optionally) in Pit Actual, Plan Compliance and Design Compliance EOM reports.
            • #BOUNDARY NAME#
          • Reports
            • Compliance to Design
              Contains the 3D volumes and outline strings generated by the Design Compliance reporting tool, plus a summary table containing volume overmine/undermine calculations per bench. Organized with date folders.
            • Compliance to Plan
              Contains 3D volumes and outline strings generated by the Plan Compliance reporting tool, plus a summary table containing volume overmine/undermine calculations per bench. Organized with date folders.
            • EOM Pit
              Contains 3D volumes and outline strings generated by the Pit Actual reporting tool, plus a summary table containing volume calculations per bench for the mined solids. Organized with date folders.
          • Surveyed Pit Surfaces
            Contains surveyed pit surface data (as-mined) for a specific date. Pit Actual, Plan Compliance and Design Compliance EOM reports. Organized with date folders.
  • ROMS (open pit scenarios)
    • #ROM Name#
      • Reports
        • EOM ROM

          Contains output stockpile volumes and strings generated by the ROM reporting tool, plus an output volume calculation table containing summary volume information for each stockpile (as defined by a stockpile boundary string attribute value). Organized with date folders.
      • ROM Base Surfaces

        Contains ROM surface data to be used when calculating stockpile volumes using the ROM reporting tool. Organized with date folders.
      • ROM Stockpile Boundaries

        Contains strings representing stockpile boundaries for a given survey date. Used by the ROM reporting tool. Organized with date folders.
      • ROM Stockpile Surfaces

        Contains surveyed stockpile surface data for a given survey date. Used by the ROM reporting tool. Organized with date folders.
  • Settings
    • Blast
    • Compliance to Design

      • Plot Templates

        Plot templates used by the Design Compliance reporting tool are stored here.

    • Compliance to Plan
      • Plot Templates

        Plot templates used by the Plan Compliance reporting tool are stored here.
    • EOM
      • Excel Templates

        The Excel Template used by the Publish Report tool is stored here.
    • EOM Pit
      • Plot Templates

        Plot templates used by the Pit Actual reporting tool are stored here.
    • EOM ROM
      • Plot Templates

        Plot templates used by the ROM reporting tool are stored here.
  • Surveyors
    • #Surveyor Name#

Note: Database data file names will be in the format name_[pit]_[area] or name_[pit]_[rom] where the name element is either the default name, or the Reference Name used when adding the data to the database.

Related Information and Activities