NCCA 2010 Sediment Indicator Status Metadata Revised 06.21.2016 "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. VARIABLE DESCRIPTION UID Unique Identifier for site and visit number SITE_ID Unique NCCA site identifier LON_DD Actual Longitude sampled (decimal degrees) LAT_DD Actual Latitude sampled (decimal degrees) ALBERS_X X-coordinate on Albers projection ALBERS_Y Y-coordinate on Albers projection COUNTRY Country in Which site is located. (All sites included in the assessment are in the United States) PSTL_CODE State in which sample collection site is located WTBDY_NM Waterbody name RSRC_CLASS Resource classification NCCA_REG Reporting region designations used in the National Coastal Condition Assessment Reports GREAT_LAKE Name of Great Lake within which the site is located (if applicable) NPSPARK Name of National Park within which site is located (if applicable) NEP_NM Name of National Estuary Program study area within which site is located area (if applicable) EPA_REG Identifies EPA Region within which the site is located STATUS_ALL Status of sampling at that site. TNT_ALL Target or not Target for sampling WGT_CATALL Category used to derive weight for assesment of all parameters except Great Lakes Human Health Fish Tissue Analysis WGT_SQMI10 Adjusted site weight. USE for all population estimates with the exception of Great Lakes Human Helath Fish Tissue estimates. Units are Square miles. STATUS_FT Status of Great Lakes Human Health Fish Tissue sampling at that site. TNT_FT Target or not Target for Great Lakes Human Health Fish Tissue sampling WGT_CAT_FT Category used to derive weight for assesment of Great Lakes Human Health Fish Tissue Analysis only WGT_SQMIFT Adjusted site weight for population estimates of Great Lakes Human Helath Fish Tissue estimates only. Units are Square miles. CNTRL_CORR_SURV Control-corrected Survival of Amphipods in Toxicity Tests ERL_TOT Num. Analytes with concentrations > ERL ERM_TOT Num. Analytes with concentrations > ERM LRM_STATUS LRM Status (based on pr_max) MERMQ Mean ERM-Q MERMQ_STATUS Mean ERM-Q Status MPECQ Mean PECQ value NCA_SCI_STATUS NCA Sediment Chemistry Index Status NCA_SQI_STATUS NCA Sediment Quality Index Status NCA_SQI_STATUS_NOTOC "NCA Sediment Quality Index Status, excluding TOC" NCA_TOX_STATUS NCA Sediment Toxicity Status NCCA_SCI_STATUS NCCA Sediment Chemistry Index Status NCCA_SQI_STATUS NCCA Sediment Quality Index Status PEC_STATUS Mean PECQ status PR_MAX Maximum probability of observing toxicity in the sample (LRM) SIG_TEST Significance of mean Test Survival compared to mean Control survival (Yes=test was sig. diff. from control; No=test was not sig. diff. from control) TOC Total Organic Carbon (%) TOC_STATUS NCA TOC Status TOC_UNITS Units - Total organic carbon NCCA_TOX_STATUS NCCA Sediment Toxicity Status ***Change LOG*** "Date: June 21, 2016: Filename changed from ncca2010_sediment_indicator_status.csv to ncca2010_sediment_indicator_status.06.21.2016.csv" "Date: June 21, 2016: Change to file ncca2010_sediment_indicator_status.06.21.2016.csv: assessment results and Good-Fair-Poor-Missing status updated. The report was published based upon these updated values so there is no change to the assessments published in the report."