INTRODUCTION


The AMRB inventory data has been input into the data manager DBASE IV, Version
2.0.  Four files were created to contain the data and aid in any manipulation
of the data that may be desired.  These files are summarized briefly here and
discussed more fully below: 

ALLFLD2.DBF contains field data collected for each sample by Pioneer Technical
Services;

ALLXRF2.DBF contains the analyses done by the field X-Ray Fluorescence
Spectrometer;

ALLLAB.DBF contains all laboratory analyses performed; and

ALLSITE.DBF contains basic information for each site.

The information from these four files can be easily combined with one another
using the LINK command in DBASE and using the variables, PA, LAB_ID, and
XRF_ID, and the corresponding variable in the other database files.  Natural
order for the files is ascending in order of PA number which is included with
each record in all of the databases.
 


ALLFLD2.DBF 

This file contains all the field data that was collected for each sample by
Pioneer Technical Services.  It also contains the information needed to link
the other files with this one as well as with each other.  Table 1 contains the
file structure and definition of variable names.  Table 2 contains a summary
of abbreviations used for variables where appropriate.

TABLE 1
Field  Field Name  Field Type  Width  Decimal  Description
1      PA          Character   10              PA number assigned by MDEQ/MWCB
2      SOURCE_ID   Character    8              Source ID assigned by Pioneer
3      QAQC        Character    5              Identifies field duplicates
                                                or blank samples for quality
                                                control purposes
4      LAB_ID      Character   15              Laboratory sample number
                                                assigned in the field by
                                                Pioneer and used by the
                                                laboratory.
5      TIME        Numeric      5     0        Time laboratory sample was
                                                collected.
6      XRF_ID      Character   17              Sample number assigned for
                                                field XRF analysis
7      SAMP_LOC    Character   45              Brief description of sample
                                                location
8      SAMP_TYPE   Character   6               Abbreviations for various sample
                                                types (see Table 2)
9      TAILS       Character   1               Identifies laboratory samples
                                                which included subsamples from
                                                surface tailings
10     VOLUME_YD3  Numeric    10      0        Estimated volume of source in
                                                cubic yards, listed under first
                                                subsample taken at the source
                                                area
11     AREA_FT2    Numeric    10      0        Estimated area of source in
                                                square feet, listed under first
                                                subsample taken at the source
                                                area
12     UNCAREA     Numeric    10      0        Estimate of uncovered/ 
                                                unvegetated area of source in
                                                square feet, listed under first
                                                subsample taken at the source
                                                area 
13     HVOL        Numeric     7      0        Volume assigned to each lab
                                                sample for scoring purposes
14     HAREA       Numeric     7      0        Area (uncovered/unvegetated)
                                                assigned to each lab sample for
                                                scoring purposes
15     PH_P        Numeric     5      2        Field pH  reading
16     RAD_MRHR    Numeric     5      3        Field radiation reading in MR/HR
17     FLOW_CFS    Numeric     7      3        Flow measurement in cubic
                                                feet/second
18     SC          Numeric     7      2        Field specific conductance
                                                reading in uS/cm
19     EH          Numeric     7      2        Field Eh measurement
20     TEMP_C      Numeric     4      1        Field temperature reading in
                                                degrees centigrade
21     ALKALINITY  Numeric     5      0        Field alkalinity in mg/L as CACO3
22     DEPTH_FT    Numeric     6      2        Depth to water if measurable
                                                (shafts, wells)


TABLE 2		

Field  Field Name  Abbreviation  Description
3      QAQC        DUP           Indicates a field duplicate
                   DUPA          Indicates second sample of field duplicate
                   BLANK         Sample submitted as field blank
8      SAMP_TYPE   AD            Water present in or flowing from an adit
                   BACK          Background soil sample taken at that site
                   BACKA         Background soil sample assigned to the site
                   BLANK         Sample submitted as field blank for quality
                                  control purposes
                   CONC          Possible mill concentrate
                   DSE           Downgradient sediment sample
                   DSW           Downgradient surface water sample
                   GW            Possible groundwater sample
                   MW            Sample from a monitoring well
                   RW            Sample from a residential well
                   SE            Sediment sample, generally onsite rather
                                  than upgradient or downgradient of site
                   SEEP          Sample at a seep
                   SH            Water in or flowing from a shaft
                   SLAG          Possible slag sample
                   SOIL          Soil from an area that could possibly
                                  identify a source or be a source, e.g.
                                  a toe of a leach pond
                   SPRING        Sample from a spring
                   SW            Surface water sample, generally onsite
                                  rather than upgradient or downgradient
                   TAILS         Sample of tailings
                   UNK           Sample of unknown substance
                   USE           Upgradient sediment sample
                   USW           Upgradient surface water sample
                   WR            Sample of waste rock material
9      TAILS       1             A surface subsample of tailings was included
                                  in the laboratory sample

The number of entries in this file is 5,558.


ALLXRF2.DBF
This file contains the analytical data which was collected in the field using
the portable  X-Ray Fluorescence Spectrometer (XRF), it also has the appropriate
flags as identified in the Data Validation and Evaluation  Report. Data
precision and accuracy within the XRF data and compared to the lab data is also
discussed in the Data Validation and Evaluation Report.  The natural order of
this file is ascending on PA number.  Table 3 lists the file structure and
variable names, Table 4 contains a summary of abbreviations used for variables. 

TABLE 3
Field  Field Name  Field Type  Width  Decimal  Description
1      PA          Character    6              PA number assigned by MDEQ/MWCB
2      XRF_ID      Character   20              Sample number assigned for
                                                field XRF analysis
3      XRFQA_ID    Character    6              Field duplicates for
                                                QA/QC purposes
4      XCRHI       Numeric      9     2        Chromium, mg/kg, based on
                                                measurements from the Fe-55
                                                source in the XRF
5      XFCRHI      Character    2              QA Flag for XCRHI value
6      XK          Numeric      9     2        Potassium, mg/kg
7      XFK         Character    2              QA Flag for XK
8      XCA         Numeric      9     2        Calcium, mg/kg
9      XFCA        Character    2              QA Flag for XCA
10     XTI         Numeric      9     2        Titanium, mg/kg
11     XFTI        Character    2              QA Flag for XFTI
12     XCRLO       Numeric      9     2        Chromium, mg/kg, based on
                                                measurements from the Cd-109
                                                source in the XRF
13     XFCRLO      Character    2              QA Flag for XFCRLO
14     XMN         Numeric      9     2        Manganese, mg/kg
15     XFMN        Character    2              QA Flag for XMN
16     XFE         Numeric      9     2        Iron, mg/kg
17     XFFE        Character    2              QA Flag for XFE
18     XCO         Numeric      9     2        Cobalt, mg/kg
19     XFCO        Character    2              QA Flag for XCO
20     XNI         Numeric      9     2        Nickel, mg/kg
21     XFNI        Character    2              QA Flag for XNI
22     XCU         Numeric      9     2        Copper, mg/kg
23     XFCU        Character    2              QA Flag for XCU
24     XZN         Numeric      9     2        Zinc, mg/kg
25     XFZN        Character    2              QA Flag for XZN
26     XAS         Numeric      9     2        Arsenic, mg/kg
27     XFAS        Character    2              QA Flag for XAS
28     XSE         Numeric      9     2        Selenium, mg/kg
29     XFSE        Character    2              QA Flag for XSE
30     XSR         Numeric      9     2        Strontium, mg/kg
31     XFSR        Character    2              QA Flag for XSR
32     XZR         Numeric      9     2        Zirconium, mg/kg
33     XFZR        Character    2              QA Flag for XZR
34     XHG         Numeric      9     2        Mercury, mg/kg
35     XFHG        Character    2              QA Flag for XHG
36     XMO         Numeric      9     2        Molybdenum, mg/kg
37     XFMO        Character    2              QA Flag for XMO
38     XPB         Numeric      9     2        Lead, mg/kg
39     XFPB        Character    2              QA Flag for XPB
40     XRB         Numeric      9     2        Rubidium, mg/kg
41     XFRB        Character    2              QA Flag for XRB
42     XCD         Numeric      9     2        Cadmium, mg/kg
43     XFCD        Character    2              QA Flag for XCD
44     XSN         Numeric      9     2        Tin, mg/kg
45     XFSN        Character    2              QA Flag for XSN
46     XSB         Numeric      9     2        Antimony, mg/kg
47     XFSB        Character    2              QA Flag for XSB
48     XBA         Numeric      9     2        Barium, mg/kg
49     XFBA        Character    2              QA Flag for XBA
50     XAG         Numeric      9     2        Silver, mg/kg
51     XFAG        Character    2              QA Flag for XAG
52     XU          Numeric      9     2        Uranium, mg/kg
53     XFU         Character    2              QA Flag for XU
54     XTH         Numeric      9     2        Thorium, mg/kg
55     XFTH        Character    2              QA Flag for XTH


TABLE 4
Field     Field Name  Abbreviation  Description
3         XRFQA_ID    DUP           Field Duplicate 
                      DUPA          Second sample in field duplicate
                      COMP          Sample run on first XRF 
                      COMPA         Second run of sample on second XRF for
                                     comparison of machines
                      SAME          Sample from same source area run
                                     a second time
Assorted  XF***       no data       Sample was below the reliable
                                     detection limit of the XRF
                      $             Unvalidated data, standard deviation
                                     data was not available for review
                      *             Data between 3X and 10X the standard
                                     deviation and indicates estimated
                                     concentrations

The number of enteries in this file is 3,926.


ALLLAB.DBF
This database contains all laboratory analytical results from the samples
submitted.  Appropriate flags have been included with each result.  The process
of flagging data and the data flag meanings are discussed in the Data Validation
and Evaluation Report.  The laboratory preformed random duplicate runs on the
acid-base accounting analyses, these are identified in the LABQA_ID.  This
file's natural order is ascending by PA number.  The file structure and
variables for LABDATA.DBF are presented in Table 5.  Table 6 contains
abbreviated definitions of possible flag entries and LABQA_ID enteries.

TABLE 5	
Field  Field Name  Field Type  Width  Decimal  Description
1      PA          Character    6              PA number assigned by MDEQ/MWCB
2      SITENAME    Character   20              Mine site name
3      BATCH_ID    Character    5              Assigned by lab, sample batch
                                                number
4      LABSAMPLE   Character    7              Assigned by lab, their sample
                                                identification number
5      LAB_ID      Character   15              Sample number assigned in the
                                                field by Pioneer when
                                                collecting the sample
6      AG          Numeric      9     3        Silver, mg/kg (solids), ug/L
                                                (water)
7      FAG         Character    3              QA Flag for AG
8      AS          Numeric      9     2        Arsenic, mg/kg (solids), ug/L
                                                (water)
9      FAS         Character    3              QA Flag for AS
10     BA          Numeric      9     2        Barium, mg/kg (solids), ug/L
                                                (water)
11     FBA         Character    3              QA Flag for BA
12     CD          Numeric     10     3        Cadmium, mg/kg (solids), ug/L
                                                (water)
13     FCD         Character    3              QA Flag for CD
14     CO          Numeric      9     2        Cobalt, mg/kg (solids), ug/L
                                                (water)
15     FCO         Character    3              QA Flag for CO
16     CR          Numeric      9     2        Chromium, mg/kg (solids), ug/L
                                                (water)
17     FCR         Character    3              QA Flag for CR
18     CU          Numeric      9     2        Copper, mg/kg (solids), ug/L
                                                (water)
19     FCU         Character    3              QA Flag for CU
20     FE          Numeric     10     1        Iron, mg/kg (solids), ug/L
                                                (water)
21     FFE         Character    3              QA Flag for FE
22     HG          Numeric     10     4        Mercury, mg/kg (solids), ug/L
                                                (water)
23     FHG         Character    3              QA Flag for HG
24     MN          Numeric     10     2        Manganese, mg/kg (solids), ug/L
                                                (water)
25     FMN         Character    3              QA Flag for MN
26     NI          Numeric      9     2        Nickel, mg/kg (solids), ug/L
                                                (water)
27     FNI         Character    3              QA Flag for NI
28     PB          Numeric      9     2        Lead, mg/kg (solids), ug/L
                                                (water)
29     FPB         Character    3              QA Flag for PB
30     SB          Numeric      9     2        Antimony, mg/kg (solids), ug/L
                                                (water)
31     FSB         Character    3              QA Flag for SB
32     ZN          Numeric      9     2        Zinc, mg/kg (solids), ug/L
                                                (water)
33     FZN         Character    3              QA Flag for ZN
34     CN          Numeric      9     3        Cyanide, mg/kg (solids), ug/L
                                                (water)
35     FCN         Character    4              QA Flag for CN
36     FHARDNESS   Character    1              QA Flag for HARDNESS
37     HARDNESS    Numeric      9     1        Hardness, mg/L as CACO3
38     MISC        Numeric      9     2        Analytical results from MISCNAME
39     MISCNAME    Character   15              Miscellaneous analytical
                                                results, run on only one or
                                                two samples
40     LABQA_ID    Numeric      5              Identifier for Laboratory
                                                Duplicate of Acid Base
                                                Accounting Analysis
41     FTSULFUR    Character    1              QA Flag for TSULFUR
42     TSULFUR     Numeric      7     2        Total Sulfur, %
43     TSULFURABA  Numeric      7     2        Total Sulfur Acid Base, t/1000t
44     NEUTPOT     Numeric      7     2        Neutralization Potential, t/1000t
45     TSULABAPOT  Numeric      8     2        Total Sulfur Acid Base
                                                Potential t/1000t
46     FSULFSUL    Character    1              QA Flag for SULFSUL
47     SULFSUL     Numeric      7     2        Sulfate Sulfur, %
48     FPYRSUL     Character    1              QA Flag for PYRSUL
49     PYRSUL      Numeric      7     2        Pyritic Sulfur, %
50     FORGSUL     Character    1              QA Flag for ORGSUL
51     ORGSUL      Numeric      7     2        Organic Sulfur, %
52     PYRSULABA   Numeric      8     2        Pyritic Sulfur Acid Base, t/1000t
53     PYRSULABAP  Numeric      8     2        Pyritic Sulfur Acid Base
                                                Potential, t/1000t
54     LIMEREQSOB  Numeric      8     2        Lime Requirement - Sobec method,
                                                t/1000t
55     POTACIDITY  Numeric      8     2        Potential Acidity 
56     LIMEREQDOL  Numeric      8     2        Lime Requirement - Dollhopf
                                                method, t/1000t
57     FDISSOLIDS  Character    3              QA Flag for DISSOLIDS
58     DISSOLIDS   Numeric      7     0        Total Dissolved Solids, mg/L
59     FCHLORIDE   Character    3              QA Flag for CHLORIDE
60     CHLORIDE    Numeric      7     1        Chloride, mg/L
61     FSULFATE    Character    3              QA Flag for SULFATE
62     SULFATE     Numeric      7              Sulfate, mg/L
63     FNITRATE    Character    3              QA Flag for NITRATE
64     NITRATE     Numeric      8     2        Nitrite and Nitrate-N, mg/L
65     TH228       Numeric      5     1        Thorium 228, pCi/L
66     ETH228      Numeric      4     1        +- Thorium 228, pCi/L
67     TH230       Numeric      5     1        Thorium 230, pCi/L
68     ETH230      Numeric      4     1        +- Thorium 230, pCi/L
69     TH232       Numeric      5     1        Thorium 232, pCi/L
70     ETH232      Numeric      4     1        +- Thorium 232, pCi/L
71     U234        Numeric      5     1        Uranium 234, pCi/L
72     EU234       Numeric      4     1        +- Uranium 234, pCi/L
73     U235        Numeric      5     1        Uranium 235, pCi/L
74     EU235       Numeric      4     1        +- Uranium 235, pCi/L
75     U238        Numeric      5     1        Uranium 238, pCi/L
76     EU238       Numeric      4     1        +- Uranium 238, pCi/L

TABLE 6 
Field     Field Name  Abbreviation  DESCRIPTION 
Assorted  F**         U             Below the laboratory detection limit
                      J             Estimated quantity
                      R             Data has been rejected; unusable
                      UJ            Not detected, associated value is an
                                     estimate and may be inaccurate
                      X             Data outlier based on statistical analysis
                                     of the entire data set
                      NR            Not Requested
                      <	            Quantity was determined to be less than
                                     value listed for the analysis
37        LABQA_ID    DUP           First sample of laboratory duplicate
                                     for ABA analyses
                      DUPA          Second sample of laboratory duplicate for
                                     ABA analyses, contains identical values as
                                     DUP for all elements except those in the
                                     ABA analyses.

The number of enteries in this file is 2,172.


ALLSITE.DBF

This file contains general information for each site inventoried.  This file
can be linked to the other files by linking with the variable PA.  Table 7
contains the file structure and definition of variable names.  

TABLE 7
Field  Field Name  Field Type  Width  Decimal  Description
1      PA          Character   10              PA number assigned by MDEQ/MWCB
2      SITE        Character   30              Mine site name
3      DISTRICT    Character   18              Mining District as identified
                                                by MDEQ/MWCB
4      COUNTY      Character   15              County that site is located
                                                within 
5      COMPANY     Character    8              Company performing the
                                                Inventory of the site
6      DATE        Date         8              Date that the site was
                                                inventoried. 
7      MAJOR_BAS   Character   25              USGS Drainage Basin that the
                                                site is located within.
8      SUB_BASIN   Character   25              Sub-basin unit of the USGS Basin
                                                that the site is located within.
9      THIRD_BAS   Character   25              Additional, smaller basin unit
                                                that the site is located within.
10     AIMSS       Numeric      9     2        AIMSS Human Health and
                                                Environmental score for
                                                the site.
11     WROCK_VOL   Numeric     10     0        Estimated total volume of waste
                                                rock material at the site
                                                (includes placer waste
                                                and slag).  
12     TAILS_VOL   Numeric     10     0        Estimated total volume of mill
                                                tailings material at the site 
13     NORTH_UTM   Numeric     10     0        UTM Northing coordinate for
                                                site location. 
14     EAST_UTM    Numeric     10     0        UTM Easting coordinate for
                                                site location. 
    
The number of enteries in this file is 350.
 
