There are 10 such files in the database created for USGS Professional Paper P1652 which provide additional information about the field sites, the data collected at these field sites, the results from this data collection process, and descriptive information about the data and results. These files are: LocationMaster, Project, Sample, Result, Parameter, QualitativeResult, AnalyticMethod, SampleMedia, LabName, and FieldSiteMineSiteAssocs. These files are described in a metadata file called relational_db.html.
AMLI_Analysis_ID - unique, identifying number for each analysis_site; allows analysis sites to be related to the field sites that are grouped as that analysis site; a value of 5000 or greater indicates an analysis site which has multiple field sites grouped together; a value of less than 5000 indicates an analysis site which consists of a single field site No_Fsites - number of field sites comprising the analysis site Sitenumber1 - field SiteNumber of first field site included in analysis site Sitenumber2 - field SiteNumber of second field site included in analysis site, if there are two or more Sitenumber3 - field SiteNumber of third field site included in analysis site, if there are three or more Sitenumber4 - field SiteNumber of fourth field site included in analysis site, if there are four Longitude - longitude of analysis site location Latitude - latitude of analysis site location Elevation - elevation of analysis site in feet Township - township number and direction of analysis site Range - range number and direction of analysis site Section - section number of analysis site Lithology - rock type at analysis site Strat_Unit - geologic unit at analysis site Geol_Age - geologic age of rock at analysis site Subbasin - subbasin within the Boulder River watershed within which the analysis site is located; subbasins defined by project scientists based on usefullness for interpreting project dataLongitude and latitude values were calculated using the ArcInfo PROJECT command. Elevation was determined using the ArcInfo LATTICESPOT command and the ELEVATION grid (Database for the Abandoned Mine Lands Initiative, Boulder Watershed Study Area: Elevation (elevation.html)). Township, Range, and Section were added by doing a spatial overlay using the IDENTITY command with the PLSS coverage (Database for the Abandoned Mine Lands Initiative, Boulder Watershed Study Area: Public Land Survey System (plss.html)) as the identity coverage. Lithology, Strat_Unit, and Geol_Age were added using the IDENTITY command with the Boulder River watershed study GEOLOGY coverage as the identity coverage. Subbasin was added using the IDENTITY command with the SUBBASINS coverage (Database for the Abandoned Mine Lands Initiative, Boulder Watershed Study Area: Subbasins (subbasins.html)) as the identity coverage.