NCCA 2010 Sediment Toxicity Metadata for Assessed and Not_Assessed files.						

“’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.”

Open as tab delimited text file.						
"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 Toxicity metadata						
						
						
"The table below defines the variables in the Sediment Toxicity Data files. And ""X"" in a column indicates that the variable is found in that file."						
						
	SEDIMENT_TOXICITY_CONTROL_SUMMARY	SEDIMENT_TOXICITY_CONTROL_RESULTS	SEDIMENT_TOXICITY_RESULTS	SEDIMENT_TOXICITY_SUMMARY	VARIABLE	DEFINITION
			X	X	UID	Unique identifier for the site/visit
			X	X	SITE_ID	Site identifier
			X	X	DATE_COL	Date the site visit occurred
			X	X	STATE	State where the site is located
			X	X	SAMPYEAR	Year the sample was collected 
			X	X	SAMPLE_CAT	"Sample category (P)rimary, (D)uplicate,(F)ield Blank"
	X	X	X	X	QA_CODE	Lab QA code
				X	CNTRL_CORR_SURV	Control corrected survival
	X	X		X	CONTROL_ID	Lab control ID
				X	MEAN_NSURV	Mean number of surviving organisms
	X			X	MEAN_PSURV	Mean percent of surviving organisms
	X			X	SD_NSURV	Std. deviation number of surviving organisms
				X	SD_PSURV	Std. deviation percent of surviving organisms
			X	X	QA_COMMENT	Additional QA comments
		X	X		REP	Lab replicate number
			X		NUM_SURVIVAL	number of organisms surviving in replicate at the end of the test.
			X		PER_SURVIVAL	Percent of organisms remaining at the end of the test out of initial load
	X				VARIABLE	Legal values: MEAN_PSURV; SD_PSURV; ORGANISM
	X				VALUE	Values assigned to each variable in the associated CONTROL_ID
	X				MEAN_ALERT	"Alert (Y/N) if the MEAN_PSURVCONT falls below threshold (85% Hyalella, 90% Leptocheirus)"
	X				TEST_FLAG	Flag/Comment provided by the submitting laboratory
	X	X			LAB_COMMENT	Lab comment
		X			PARAMETER	NUM_SURVIVAL or PER_SURVIVAL
		X			RESULT	Value of associated parameter
		X			REP_ALERT	Alert (Y/N) if the PER_SURVIVAL for any replicate falls below the threshold (85%)