NCCA 2010 Sediment Chemistry Metadata for Assessed and Not_Assessed files. Revised 06.21.2016 "“’Assessed’ data were used to develop the Good, Fair and Poor ratings in the report. ”" ‘Not_Assessed’ data were not used to develop the ratings. "For questions about these data, please contact Hugh Sullivan at sullivan.hugh@epa.gov or use the Contact Us link on the webpage: http://www.epa.gov/national-aquatic-resource-surveys/forms/national-aquatic-resource-surveys-contact-us" "It is the responsibility of the end data user to become familiar with the QA codes used in the NCCA 2010 assessment (NCCA_QA_Codes.csv) and review the ""QA_CODES"" column in each dataset to determine whether the data meet quality objectives for specific uses." Location information for each site is contained in the SITEINFO File. Use UID as key column for merging data. Sediment Chemistry metadata Variable Definition UID Unique identifier for the site/visit SITE_ID Site identifier DATE_COL Date the site visit occurred STATE State where the site is located VISIT_NO "Sequential visit in each year. ALL ASSESSED visits are Visit 1, so the VISIT_NO column is removed from the ASSESSMENT file." PARAMETER Code for parameter analyzed PARAMETER_NAME Name of parameter analyzed PARAMETER_CAT Analyte Category CAS_NO CAS Number RESULT Value of parameter UNITS Units of measure BATCH_ID Laboratory Batch ID MDL Parameter Method Detection Limit RL Reporting Limit MRL Parameter Minimum Reporting Limit PQL Practical quantitation limit DATE_ANALYZED Date sample analyzed HOLDING_TIME # days between sample collection and analysis LAB_SAMPLE_ID Lab internal sample ID SAMPLE_ID NCCA assigned Sample ID METHOD Laboratory method QA_CODES Sample Qualifier code ** Change Log** "Date: June 21, 2016. Change to File Name: PREVIOUS FILE NAME: ASSESSED_NCCA2010_SEDIMENT CHEMISTRY.csv. NEW FILE NAME: ASSESSED_NCCA2010_SEDIMENT CHEMISTRY.REVISED.06.21.2016.csv." "Date: June 21, 2016. Change to Data in ASSESSED_NCCA2010_SEDIMENT_CHEMISTRY.REVISED.06.21.2016: Duplicate records for numerous sites were removed. Contaminant concentrations for several parameters at several sites were corrected. This change does not affect the results of the assessment." "Date: June 21, 2016. Change to File Name: PREVIOUS FILE NAME: NOTASSESSED_NCCA2010_SEDIMENT_CHEMISTRY.csv. NEW FILE NAME: NOTASSESSED_NCCA2010_SEDIMENT_CHEMISTRY.REVISED.06.21.2016.csv" "Date: June 21, 2016. Change to Data in NOTASSESSED_NCCA2010_SEDIMENT_CHEMISTRY.REVISED.06.21.2016.csv: Duplicate data at some sites removed. Contaminant concentrations for several parameters at several sites were corrected."