APPENDIX C. Metadata for srsedchem.dbf (srsedchem.met) Identification_Information: Citation: Citation_Information: Originator: Stephen E. Box Originator: John C. Wallis Publication_Date: 2001 Title: Surficial geology along the Spokane River, Washington and its relationship to the metal content of sediments (Idaho-Washington stateline to Latah Creek confluence). Edition: 1.0 Geospatial_Data_Presentation_Form: MS Excel DBF4 Table Series_Information: Series_Name: Open-File Report Issue_Identification: OF01-XXX Publication_Information: Publication_Place: Menlo Park, CA Publisher: U.S. Geological Survey Online_Linkage: http://geopubs.wr.usgs.gov/open-file/of02-126 Description: Abstract: The Spokane River flows westward into eastern Washington out of the northern end of Lake Coeur d’Alene in northern Idaho (figure 1). The river and lake lie downstream of the Coeur d’Alene mining district, where over 56 million metric tonnes of metal-enriched tailings were disposed into the Coeur d’Alene River between 1886 and 1968 (Long, 1998). Geochemical analyses of riverine sediments in the Spokane River by the Washington Dept of Ecology (Johnson, 1999), the US Geological Survey (Grosbois and others, 2001; Box and others, in prep.) and an EPA contractor (URS Greiner, 2000, 2001) have indicated that Spokane River sediments are variably enriched in metals derived from those tailings. In this report we present a surficial geologic map (plates 1 through 8) of the unconsolidated deposits within and along the Spokane River in eastern Washington between the Idaho stateline and the confluence with Latah Creek about 20 miles downstream. Existing sample datasets for sediments and soils in and along the Spokane River are also located on the map and the surficial geologic unit that was sampled is noted. This work was undertaken in cooperation with the Washington Department of Ecology and the Environmental Protection Agency. Purpose: The data were prepared in cooperation with the Department of Ecology and the Environmental Protection Agency to aid in the interpretation of the distribution, sources, and transport processes of metal-enriched sediment in and along the Spokane River. These agencies are evaluating the relative metal enrichment in the riverine sediments due to concerns of potential health impacts to humans, waterfowl, and aquatic organisms. Supplemental _Information: The digital surficial geologic map of the Spokane River and its margins in Washington between the Idaho stateline and the confluence of Latah Creek was compiled on a base of 1:12,000 scale Digital Orthophoto Quarter Quadrangles (DOQQs) from field maps prepared on 1:3,000 scale paper printouts of the DOQQs in August and September of 2000. The units are defined by the lithologic character of the surficial sediment and by their geomorphological settings. The dBase dataset (srsedchem.dbf)discussed in this Metadata contain analytical geochemistry data and sediment sample locations projected in UTM zone 11, North American Datum of 1927 (NAD27). The Metadata for this Open-File report consists of two separate Metadata files. Appendix B (srgeounits.met) discusses the ArcView shape file srgeounits.shp. The sample geochemistry table (srsedchem.dbf) in dBase4 format is described here in Appendix C. Time_Period_of_Content: Time_Period_Information: Multiple_Dates/Times: Single_Date/Time: Calendar_Date: 1999 Single_Date/Time: Calendar_Date: 2000 Currentness_Reference: publication date Status: Progress: Complete Maintenance_and_Update_Frequency: None planned Spatial_Domain: Bounding_Coordinates: West_Bounding_Coordinate: -117 30 00 East_Bounding_Coordinate: -117 00 00 North_Bounding_Coordinate: 47 45 00 South_Bounding_Coordinate: 47 35 00 Keywords: Theme: Theme_Keyword_Thesaurus: none Theme_Keyword: Geology Theme_Keyword: Surficial Theme_Keyword: Quaternary Theme_Keyword: Metals Theme_Keyword: Geochemistry Theme_Keyword: Mining Theme_Keyword: Environment Theme_Keyword: Sediment Theme_Keyword: River Theme_Keyword: Aquifer Theme_Keyword: Pollution Theme_Keyword: EPA Theme_Keyword: USGS Theme_Keyword: URS Greiner Theme_Keyword: Lead Theme_Keyword: Zinc Theme_Keyword: RI/FS Theme_Keyword: Superfund Place: Place_Keyword_Thesaurus: none Place_Keyword: USA Place_Keyword: Washington Place_Keyword: Spokane Place_Keyword: Spokane County Place_Keyword: Spokane River Place_Keyword: Liberty Lake Place_Keyword: Green Acres Place_Keyword: Spokane NE Place_Keyword: Spokane NW Place_Keyword: Idaho Place_Keyword: Coeur d' Alene Place_Keyword: Coeur d' Alene Lake Access_Constraints: This digital dataset is not to be used or displayed at any scale larger than 1:12,000 (e.g., 1: 6,000). Use_Constraints: Any hardcopies utilizing this data set shall clearly indicate its source. If the users have modified the data in any way, they are obliged to describe the types of modifications they have performed. The user specifically agrees not to misrepresent this data set, nor to imply that changes they made were approved by the U.S. Geological Survey. Point_of_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: Stephen E. Box Contact_Organization: U.S. Geological Survey Contact_Position: Geologist Contact_Address: Address_Type: mailing and physical address Address: 904 W. Riverside Ave., Rm 202 City: Spokane State_or_Province: WA Postal_Code: 99201 Country: USA Contact_Voice_Telephone: 509-368-3106 Contact_Facsimile_Telephone: 509-368-3199 Contact_Electronic_Mail_Address: sbox@usgs.gov Hours_of_Service: 9 - 5 Pacific Time Zone Native_Data_Set_Environment: MS Excel 2000 for Windows NT Data_Quality_Information: Attribute_Accuracy: Attribute_Accuracy_Report: Attribute accuracy of geospatial data was verified by manual comparison of the source field data with hardcopy printouts, and on screen evaluations. 100% of tabulated data for lead (Pb) and zinc (Zn) was verified between digital tables and the hardcopy sources from which they were derived. Logical_Consistency_Report: Point data is given in UTM NAD27 Positional_Accuracy: Horizontal_Positional_Accuracy: Horizontal_Positional_Accuracy_Report: Sample location data came from several sources, and were tested by comparing source data to how they plotted on DRGs and DOQQs. Some data point locations, from source materials, were modified after on- screen evaluations showed errors in their plotted locations. After verbal discussions and written communications with the authors of the source data, our data now reflect the most accurate geospatial data we are able to produce. These data are therefore considered to be accurate to within +/- 25 meters depending on distinctiveness of the site and/or its distance from features both on the ground and on field maps. Lineage: Source_Information: Source_Citation: Citation_Information: Originator: U.S. Geological Survey Publication_Date: 1997 Title: Digital Raster Graphic (DRG) Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: Spokane West Issue_Identification: 47117f1 (1973), 47117f2 (1986), 47117f3 (1986), 47117f4 (1986). Publication_Information: Publication_Place: Reston, VA Publisher: U.S. Geological Survey Online_Linkage: Source_Scale_Denominator: 24000 Type_of_Source_Media: CD-ROM Source_Time_Period_of_Content: Time_Period_Information: Range_of_Dates/Times: Beginning_Date: 1973 Ending_Date: 1986 Source_Currentness_Reference: ground condition Source_Citation_Abbreviation: DRG Source_Contribution: DRG's were used in conjunction with DOQQ's to verify all sample site locations that were identified in this report. They were also used to correct some of the source data (point locations) that may have been originally in error. Source_Information: Source_Citation: Citation_Information: Originator: U.S. Geological Survey Publication_Date: 1992 and 1995 Title: Digital Orthophoto Quarter Quadrangles (DOQQ) Geospatial_Data_Presentation_Form: remote-sensing image Series_Information: Series_Name: None Issue_Identification: 47117F11 (1992), 47117F12( 1992), 47117F13 (1992), 47117F14 (1992), 47117F21 (1995), 47117F22 (1995), 47117F23 (1995), 47117F24 (1995), 47117F31 (1995), 47117F32 (1995), 47117F33 (1995), 47117F34 (1995), 47117F41 (1995), 47117F42 (1995), 47117F43 (1995), 47117F44 (1995). Publication_Information: Publication_Place: Reston, VA Publisher: U.S. Geological Survey Online_Linkage: Source_Scale_Denominator: 12000 Type_of_Source_Media: online Source_Time_Period_of_Content: Time_Period_Information: Range_of_Dates/Times: Beginning_Date: 5/22/1992 Ending_Date: 7/16/1995 Source_Currentness_Reference: ground condition Source_Citation_Abbreviation: DOQQ Source_Contribution: DOQQ's were used in conjunction with DRG's to verify all sample site locations that were identified in this report. They were also used to correct some of the source data (point locations) that may have been originally in error. Source_Information: Source_Citation: Citation_Information: Publication_Date: Unpublished Material Originator: USGS Title: none Geospatial_Data_Presentation_Form: Document with tabular data. Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Multiple_Dates/Times: Single_Date/Time: Calendar_Date: 1998 Single_Date/Time: Calendar_Date: 1999 Source_Citation_Abbreviation: USGS-99 Source_Contribution: Written communication from Art Horowitz(USGS) containing sample site geochemistry and sample locations from Spokane River channel. These data were used to compile the database (srsedchem.dbf). Source_Information: Source_Citation: Citation_Information: Originator: URS Greiner, Inc. Publication_Date: 2000 Title: Draft Final Screening Level Human Health Risk Assessment for Nonresidential Receptors Spokane River, Washington. Coeur d'Alene Basin RI/FS. Geospatial_Data_Presentation_Form: Document with tabular data. Series_Information: Series_Name: Coeur d'Alene Basin RI/FS Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1999 Source_Citation_Abbreviation: URS-99 Source_Contribution: These data were used to compile a database (srsedchem.dbf) contain sediment sample locations and geochemistry from the Spokane River. Source_Information: Source_Citation: Citation_Information: Originator: URS Greiner Publication_Date: Unpublished Material Title: none Geospatial_Data_Presentation_Form: Document with tabular data. Other_Citation_Details: written communication from URS Greiner. Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 2000 Source_Citation_Abbreviation: URS-00 Source_Contribution: These field notes were used to compile the database (srsedchem.dbf) containing sediment sample locations and geochemistry from the Spokane River. Source_Information: Source_Citation: Citation_Information: Originator: URS Greiner, Inc. Publication_Date: 2001 Title: Draft Field Sampling Plan Addendum 18 - Fall 2000 Field Screening of Sediment in Spokane River Depositional Areas. Coeur d'Alene Basin RI/FS. Geospatial_Data_Presentation_Form: Document with tabular data. Series_Information: Series_Name: Coeur d'Alene Basin RI/FS Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 2000 Source_Citation_Abbreviation: URS-01 Source_Contribution: These data were used to compile the database (srsedchem.dbf) containing sediment sample locations and geochemistry from the Spokane River. Process_Step: Process_Description: This table (srsedchem.dbf) was originally compiled in MS excel 2000. It was then converted to dBase4 format and imported to ArcView 3.1 as an Event Theme. This dBase4 table contains data from USGS-99, URS-99, URS-00, and URS-01, data sources. Point locations are presented in UTM zone 11 North American Datum of 1927 (NAD27). To verify sample site coordinates we plotted sample sites onto DRGs and/or DOQQs in ArcView 3.1. Some plotted locations did not match field descriptions or locations noted in source field notes or sketch maps. In some cases we were able to correct misfit locations by matching them to the locations noted on the original field maps. In other cases we moved misfit sample locations to an area that closely matched the description in the field notes of our source materials. These data are therefore considered to be accurate to within +/-10 meters depending on distinctiveness of the site and/or its distance from features both on the ground and on field maps. Some of the geospatial source material was provided in geographic projection. These data had to be converted from latitude/longitude to UTM NAD27 using an ArcView script addxycoo.ave or an MS Excel Lat/Lon to UTM27 conversion table (written communication). Process_Step: Process_Description: Process_Date: 2001 Process_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: Stephen E. Box Contact_Organization: U.S. Geological Survey Contact_Position: Geologist Contact_Address: Address_Type: mailing and physical address Address: 904 W. Riverside Ave., Rm 202 City: Spokane State_or_Province: WA Postal_Code: 99201 Country: USA Contact_Voice_Telephone: 509-368-3106 Contact_Facsimile_Telephone: 509-368-3199 Contact_Electronic_Mail_Address: sbox@usgs.gov Hours_of_Service: 9 - 5 Pacific Time Zone Spatial_Data_Organization_Information: Direct_Spatial_Reference_Method: Point Point_and_Vector_Object_Information: SDTS_Terms_Description: SDTS_Point_and_Vector_Object_Type: Entity point Point_and_Vector_Object_Count: 350 Spatial_Reference_Information: Horizontal_Coordinate_System_Definition: Planar: Grid_Coordinate_System: Grid_Coordinate_System_Name: Universal Transverse Mercator Universal_Transverse_Mercator: UTM_zone_Number: 11 Transverse_Mercator: Scale_Factor_at_Central_Meridian: 0.999600 Longitude_of_Central_Meridian: -117.000000 Latitude_of_Projection_Origin: 0.000000 False_Easting: 500000.000000 False_Northing: 0.000000 Planar_Coordinate_Information: Planar_Coordinate_Encoding_Method: Row and column Coordinate_Representation: Abscissa_Resolution: Ordinate_Resolution: Planar_Distance_Units: Meters Geodetic_Model: Horizontal_Datum_Name: North American Datum of 1927 Ellipsoid_Name: Clarke 1866 Semi-major_Axis: 6378206.4000000 Denominator_of_Flattening_Ratio: 294.98 Entity_and_Attribute_Information: Detailed_Description: Entity_Type: Entity_Type_Label: srsedchem.dbf Entity_Type_Definition: This dBase4 table contains sample point locations (UTM NAD27) and geochemical analyses. Entity_Type_Defintion_Source: User defined Entity_and_Attribute_Detail_Citation: Attribute: Attribute_Label: SAMPLE_ID Attribute_Definition: Sample identifier Attribute_Definition_Source: from source reference Attribute: Attribute_Label: GRAINSIZE Attribute_Definition: Size fraction of analyzed sample (<2000 microns (um), <500 um, 175 um, or <63 um). Attribute_Definition_Source: from source reference. Attribute: Attribute_Label: DATASET Attribute_Definition: Source of sample data USGS-99, URS-99, URS-00, URS-01. Attribute_Definition_Source: user defined Attribute: Attribute_Label: UTM27E Attribute_Definition: location of sample (UTM East, zone 11 NAD 27) Attribute_Definition_Source: computed Attribute: Attribute_Label: UTM27N Attribute_Definition: location of sample (UTM North, zone 11 NAD 27) Attribute_Definition_Source: computed Attribute: Attribute_Label: MAP_UNIT Attribute_Definition: Surficial geologic map unit of sediment sample. Can be one of the following units: Qsc Sand, sloping channel flank deposit Qsf Sand, floodplain bench deposit Qgpf Gravel, fine pebble (2-20 mm) Qgpc Gravel, coarse pebble (20-64 mm) Qgcf Gravel, fine cobble (64-125 mm) Qgcc1 Gravel, coarse cobble and boulder (>125 mm), with little fines Qgcc2 Gravel, coarse cobble and boulder (>125 mm), with patches of sand Qgcc3 Gravel, coarse cobble and boulder (>125 mm), with patches of silt Qcrc Cobble riffle in low-flow channel Qcrb Boulder riffle in low-flow channel Qcpb Low-flow channel pool with emergent boulders Qcp Low-flow channel pool Qci Channel bed beneath impounded reservoirs Qcb Channel, scoured bedrock Qts1 Sand and gravel deposits of the first (lowest) terrace Qts2 Sand and gravel deposits of the second terrace Qts3 Sand and gravel deposits of the third terrace Qaf Artificial fill rock Attribute_Definition_Source: user defined Attribute: Attribute_Label: PB_PPM Attribute_Definition: The amount of lead detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: from source reference. Attribute: Attribute_Label: ZN_PPM Attribute_Definition: The amount of zinc detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: from source reference. Attribute: Attribute_Label: AS_PPM Attribute_Definition: The amount of arsenic detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: from source reference. Attribute: Attribute_Label: CD_PPM Attribute_Definition: The amount of cadmium detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: FE_% Attribute_Definition: The amount of iron detected in sample in percent (%) by weight Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: HG_PPM Attribute_Definition: The amount of mercury detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: MN_PPM Attribute_Definition: The amount of manganese detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: SB_PPM Attribute_Definition: The amount of antimony detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: Lab results Attribute: Attribute_Label: AL_% Attribute_Definition: The amount of aluminum detected in sample in percent (%) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: AG_PPM Attribute_Definition: The amount of silver detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: BA_PPM Attribute_Definition: The amount of barium detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: BE_PPM Attribute_Definition: The amount of beryllium detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: C_TOT_% Attribute_Definition: The total amount of carbon detected in sample in percent (%) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: TOC_% Attribute_Definition: The total amount of organic carbon detected in sample in percent (%) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: CO_PPM Attribute_Definition: The amount of cobalt detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: CR_PPM Attribute_Definition: The amount of chromium detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: CU_PPM Attribute_Definition: The amount of copper detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: NI_PPM Attribute_Definition: The amount of nickel detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: P_PPM Attribute_Definition: The amount of phosphorus detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: S_TOT_% Attribute_Definition: The total amount of sulfur detected in sample in percent (%) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: SE_PPM Attribute_Definition: The amount of selenium detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: SR_PPM Attribute_Definition: The amount of strontium detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: TI_% Attribute_Definition: The amount of titanium detected in sample in percent (%) by weight. Attribute_Definition_Source: From source reference. Attribute: Attribute_Label: V_PPM Attribute_Definition: The amount of vanadium detected in sample in parts per million (ppm) by weight. Attribute_Definition_Source: From source reference. Distribution_Information: Distributor: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey Contact_Instructions: This report is only available in an electronic format at the following URL= http://geopubs.wr.usgs.gov/OF 02-126 or via anonymous FTP from geopubs.wr.usgs.gov, in the directory pub/OF 02-126 Resource_Description: Open-File Report OF 02-126 Distribution_Liability: The U.S. Geological Survey (USGS) provides these data "as is". The USGS makes no guarantee or warranty concerning the accuracy of the information contained in the data set. The USGS further makes no warranties, either expressed or implied as to any other matter whatsoever, including, without limitation, the condition of the product, or its fitness for any particular purpose. The burden for determining fitness for use lies entirely with the user. Although this data has been processed successfully on computers at the USGS, no warranty, expressed or implied, is made by the USGS regarding the use of this data on any other system, nor does the fact of distribution constitute or imply any such warranty. In no event shall the USGS have any liability whatsoever for payment of any consequential, incidental, indirect, special, or tort damages of any kind, including but not limited to, any loss of profits arising out of use or reliance on the geographic data or arising out of the delivery, installation, operation, or support by the USGS. Metadata_Reference_Information: Metadata_Date: 20020320 Metadata_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: John C. Wallis Contact_Organization: U.S. Geological Survey Contact_Position: Contractor Contact_Address: Address_Type: mailing and physical address Address: 904 W. Riverside Ave., Rm 202 City: Spokane State_or_Province: WA Postal_Code: 99201 Country: USA Contact_Voice_Telephone: 509-368-3108 Contact_Facsimile_Telephone: 509-368-3199 Contact_Electronic_Mail_Address: jwallis@usgs.gov Hours_of_Service: 8:00 - 4:00 Pacific Time Zone Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata_Standard_Version: FGDC-STD-001-1998 Metadata_Acccess_Constraints: none Metadata_Use_Constraints: none