NCCA 2010 Water Quality Indicator Status Metadata "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. "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" UID Unique Identifier for site and visit number SITE_ID Unique NCCA site dentifier 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 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. CHLA Surface Chlorophylla (ug/L). Numerical values. CHLA_COND Chlorophyll a condition at the site CHLA_UNITS Units - Chlorophyll-a as ug/L in water sample DIN Surface Dissolved Inorganic Nitrogen (mg N/L). Numerical values. Not listed for Great Lakes sites. DIN_COND Surface Dissolved Inorganic Nitrogen Condition at the site DIN_UNITS mg N/L DIP Surface Dissolved Inorganic Phosphorus DIP_COND Surface Dissolved Inorganic Phosphorus condition at the site DIP_UNITS mg P/L DO Bottom Dissolved Oxygen (mg/L). Numerical values. DO_COND Bottom Dissolved Oxygen condition at the site DO_UNITS (mg/L) LIGHT_TRANS Light Transmissivity; percent of incident light transmitted through onemeter of water. Units: % at 1m depth. Calculated from coefficient of attenuation (Kd): LIGHT_TRANS = exp(-Kd)*100 SECCHI_FINAL Mean Secchi Depth; used in place of light transmissity in Great Lakes. Units : meters TRANS_COND "Ligh Transmissivity condition at the site, based upon LIGHT_TRANS in estuarine sites and SECCHI_FINAL at Great Lakes sites" CAT_WQI "Water Quality Index (WQI); Condition by category (Good, Fair, Poor, Missing). At marine sites, the WQI is ased on categorical condition of five component metrics at marine sites (Chla, DIN, DIP, TRansmissivity, & DO), the same protocol used in NCCR IV (pg 15). At Great Lake sites, the WQI is based on only four component metrics (Chla, TP, DO & Secchi), following same rules as at marine sites (NCCR IV pg 15)."