Database Description:
The PRB_STRAT_DB.mdb database contains five tables listed below:
DATA_SOURCE
The DATA_SOURCE table contains information related to the origin of each record in the database.
PRB_BASIN_AUX
Contains auxiliary information such as, basin scale maps and stratigraphic information related to the cross sections referenced in the PRB_CROSS_SECTION_LIST table.
PRB_CROSS_SECTION_APPENDIX
This table contains cross reference information about each well used to construct the cross sections listed in the PRB_CROSS_SECTION_LIST table.
PRB_CROSS_SECTION_ELEV
This table contains the top and bottom elevations (ft) for the sands and coals found in the PRB_CROSS_SECTION_LIST table.
PRB_CROSS_SECTION_LIST
This table contains a listing of each cross section and the wells that were used to create that cross section.
The following contains definitions of column headers in the database:
DATA_SOURCE
The point of origin for a given row of data
DATABASE_NAME
The name of the transactional database from which a given row of data was obtained
EFFECTIVE_DATE
The date the data was added to the database
PPDM_GUID
Global unique identifier used to enumerate a given row of data
REMARK
User comment pertaining to the rows origin
USER_NAME
The name of user who added the record
AUX_ID
Unique identifier for auxiliary information
TITLE
Name of the auxiliary file
FILE_NAME
File path to the named file
REMARK
A user comment pertaining to a given file
DATA_SOURCE
The point of origin for a given row of data
WELL_NUMBER
A set of positive integers assigned to a given well in order of its location, east to west or south to north, in a given cross section
WELL_LETTER
A set of western European alphanumeric characters assigned to a given well by cross section
WELL_ID
A unique identifier assigned to a given well
ORIGINAL_ELEV_FT
Elevation obtained from the Wyoming Oil and Gas Commission, recorded in feet above sea level
WELL_TYPE
Classification of the type of well
KEY_WELL
Indicates the cross sections on which the same well data was used
OPERATOR
The company responsible for the day to day operations of a well
WELL_NAME
The name by which the well is referred to
COUNTY
The county in which the well resides
STATE
The state in which the well resides
CROSS_SECTION
The cross section to which a given well has been assigned
LOG_TYPE
The type of well log found in the well and used in the cross section
SHORT_ID
A condensed version of the wells full identification number
LONGITUDE
Longitude obtained from the Wyoming Oil and Gas Conservation Commission
LATITUDE
Latitude obtained from the Wyoming Oil and Gas Conservation Commission
SPOT_ELEV_FT
Well ground level derived from the USGS National Map DEM 1/9 arc second at given well Latitude/Longitude location. First given in meters and then converted to feet above sea level for this study (values used for all analysis purposes)
CROSS_SECTION_ELEV_FT
Ground levels of wells derived from other sources in an attempt to fill in null values in the field (not used for any calculations or analysis, reference only)
ORIGINAL_ELEV_FT
Elevation in feet derived from original datasets and the Wyoming Oil and Gas Conservation Commission
FIGURE_NUMBER
The number by which a given figure can be cross referenced in the open file report
CONTACT_ELEV_FT
Elevation in feet of Inferred contact between the Fort Union and Wasatch Formations
SAND_ID
Number used to identify sands on the cross sections in this publication
COAL_ID
Number used to identify coalson the cross sections in this publication
COAL_NAME
The name by which a coal is referred to as named on the cross sections and in the report
TOP
Indicates the top elevation of the sand or coal picked from the cross sections
BOTTOM
Indicates the bottom elevation of the sand or coal picked from the cross sections
CROSS_SECTION
The cross section to which a given well has been assigned