This file contains provisional data collected by the National Coastal Condition Assessment in 2020 and 2021. "Preliminary quality reviews of these data have been completed. However, they are not considered to be final until the National Coastal Condition Assessment 2020 & 21 Report is published. " Data may be updated at any time. The changelog for the associated file may be found below the column name definitions. End-users are responsible for reviewing the suitability of these data for their purposes. "Please bring any questions about the data to the attention of Hugh Sullivan, NCCA Lead at sullivan.hugh@epa.gov. " Station location information may be obtained from the Provisional NCCA 2020 SITEINFO File. The UID column may be used to merge NCCA 2020 data files with the SITEINFO file. The data have been reviewed and flagged as appropriate. Please see the NARS_FLAG and NARS_COMMENT columns and metadata for explanations. "For information about NCCA protocols, please check the NCCA 2020 Field Operations Manual, Site Evaluation Guidelines; Lab Operations Manual, and Quality Assurance Project Plan on the NCCA Website: https://www.epa.gov/national-aquatic-resource-surveys/manuals-used-national-aquatic-resource-surveys#National%20Coastal%20Condition%20Assessment" COLUMN_NAME LEGAL_VALUES DESCRIPTION ABSORBANCE Absorbance value ANALYTE "Analyte, either cylindrospermopsin algal toxin or total microcystin algal toxins" BATCH_ID Laboratory batch identification number CONDITION_CODE "Condition of sample upon arrival at lab; Legal values are: OK = Sample is in good condition, C = Sample container is cracked, L = Sample container is leaking, ML = Sample Label is missing, NF = Sample is not frozen (for samples shipped frozen), W = Sample is warm (for microcystin warm is > 8 deg C); Q = other quality concern not otherwise noted. see comment." CV_ABSORB "Calculated %CV of duplicate values of absorbance for a sample. Only calculated for TYPE=U (unknown), KC (kit control), NC (negative control). Enter %CV. Value is between 0 and 100%." DATE_ANALYZED Date sample analyzed by lab DATE_COL |01|02|03|04|05|06|07|08|09|10|11|26 Date sample or data were collected DATE_RECEIVED Date sample received by lab. DILUTION_FACTOR Dilution factor if sample needed to be diluted for analysis LAB Lab that conducted analysis LOCATION "Location of well in the ELISA kit plate (e.g., B5 would be the fifth well from the left in the second row B)" RL Lower reporting limit MATRIX "Material used for analysis (WATER, SEDIMENT, or TISSUE)" MDL Method detection limit NARS_FLAG NARS flag. ND = Nondetect; H = holding time issue (holding times for each analyte may be found in the Laboratory Operation Manual https://www.epa.gov/sites/default/files/2016-05/documents/ncca_2015_qapp_version_2.1.pdf); S = shipping issue; L = Less than reporting limit but above MDL; Q = other quality issue. See comment. NARS_COMMENT Comment explaining NARS_FLAG if applicable. NCCA_REG Northeast|Southeast|Gulf|West|Great Lakes| "National Coastal Condition Assessment Region. Northeast includes states ME, NH, MA, RI, CT, NY, NJ, MD, DE, and VA. Southeast includes NC, SC, GA, and east coast of FL. Gulf of Mexico includes the west coast of Florida, Alabama, Mississippi, Louisiana and Texas. West Coast includes Washington, Oregon and California. Great Lakes includes the US shore of all Great Lakes. No missing values allowed." PSTL_CODE "State (US) or province (Canada) two letter postal code for site sampled. 50 state postal codes plus AS, MP, GU, PR, VI for American Samoa, Commonwealth of Northern Marianas, Guam, Puerto Rico and Virgin Islands. No missing values allowed." PUBLICATION_DATE Date the dataset was published to the NARS site R2 R2 from curve fit to the average absorbance values for the standards. Value is between 0 and 1. RESULT Analytical result UNITS Result unit SAM_CODE Sample code (Regular/Lab duplicate/Lab split) SAMPLE_ID NCCA Sample ID SAMPLE_TYPE Code identifying sample type SITE_ID "NCCA Site ID for the study and year sampled. Preferred form is NCAnn_MM-xxxxx where nn is survey cycle year (04, 08, 13, 18, etc), MM is two letter state code, and xxxxx is between 10001 and 99999. No missing values allowed. No missing values allowed." STUDY Name of primary study site belongs to. A unique site may belong to multiple studies. No missing values allowed. UID Unique identifier for the site/visit VISIT_NO |1|2 Sequential visit an index period; Visit: 1 or 2 DESIGN_YR "Year in which site was designed to be visited. The NCCA 2020 Survey was designed to take place completely in 2020. However, due to covid travel restrictions, sampling continued into 2021 and 2022. 2022 samples have not been processed and will be published at a later date." UNIQUE_ID Unique site ID based on location that does not change fromyear to year. Does not depend on year sampled or any other factor. Form is NCA_ss_nnnnn where ss state and nnnnn is number that starts at 10001. No missing values allowed. Allows tracking of sites that are sampled in repeated surveys over time. FRESH_MARINE Is the sample collected from Great Lakes (F) site or Estuarine/Marine site (M)? KIT_ID Identification number of ELISA kit used to analyze sample SALINITY_8 "is the salinity of the site where the sample was collected greater than 8 parts per thousand (ppt)? Y = Yes, N = No. If Salinity is greater than 8 ppt, Cylindrospermopsin samples required dilution. See the NCCA Laboratory Operations Manual for details." SALINITY_3.5 "is the salinity of the site where the sample was collected greater than 3.5 parts per thousand (ppt)? Y = Yes, N = No. If Salinity is greater than 3.5 ppt, Microcystin samples require additional cleanup step before analysis. See the NCCA Laboratory Operations Manual for details." SALINITY Salinity of water at site where sample was collected. Units are parts per thousand (ppt). RESULT_SALINE "Analytical result adjusted for dilution or salinity cleanup step for cylindrospermopsin samples or microcystin samples, respectively." LAB_COMMENT Comment about sample analysis CHANGE LOG PROVISIONAL NCCA 20 & 21 ALGAL TOXIN DATA DATE ACTION 7/18/2022 Iniutial publication of provisional ALGAL TOXIN data to the National Aquatic Resource Surveys Data page.