Entity_and_Attribute_Overview:
For USGS-defined attributes:
STAID = An 8- to 14-digit downstream order number for surface-water sites is usually used for the STAID. When downstream order is used, the first 8 to 14 positions of the field must contain digits. The remaining positions are blank. A STAID containing a latitude-longitude and sequence number may be assigned to sites where there is difficulty in assigning a meaningful downstream order number, or where data are obtained intermittently. In this case, positions 1-6 are coded with latitude, 7-13 are coded with longitude, and 14-15 are coded with a sequence number. A 15-digit STAID for a surface-water site most likely indicates a water-quality grab sample site, a surface-water site at which miscellaneous measurements were made, or a site with large open areas like a lake, reservoir, or bay.
SAMPL = Sample record number is the database record number individual to site, date, and time of sample collection.
MEDIM = Medium codes and the descriptions are:
0 = Not determined
9 = Surface water (Water on the surface of the earth stored or transported in rivers, streams, estuaries, lakes, ponds, swamps, glaciers or other aquatic areas. This code also may refer to water in urban drains and storm-sewer systems.)
SNAME = The station name for surface-water sites is the location description or local identifier. Example of a station name is North Canadian River near Harrah, OK.
For the following parameter codes, a value may be preceded by a remark. Example: < 0.5. Remarks and the descriptions are:
< = Less than. (Actual value is known to be less than the value shown.)
> = Greater than. (Actual value is known to be greater than the value shown.)
E = Estimated value. (Value is estimated.)
A = Average value. (Value is an average.)
V = Contamination. (Constituent was detected in both the environmental sample and the associated blanks.)
S = Most probable value.
Values listed for the following fields are reported to the nearest accuracy level of the measurement or analytical method:
P50470 2,4-D methyl ester, water, filtered, recoverable, micrograms per liter
P39732 2,4-D, water, filtered, recoverable, micrograms per liter
P39730 2,4-D, water, unfiltered, recoverable, micrograms per liter
P90593 2,4-DB, surrogate, Schedule 1304, water, unfiltered, percent recovery
P38746 2,4-DB, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P30219 2,4-DB, water, unfiltered, recoverable, micrograms per liter
P04040 2-Chloro-4-isopropylamino-6-amino-s-triazine, water, filtered, recoverable, micrograms per liter
P75981 2-Chloro-4-isopropylamino-6-amino-s-triazine, water, unfiltered, recoverable, micrograms per liter
P61029 Acetochlor ethanesulfonic acid, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P61030 Acetochlor oxanilic acid, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P49260 Acetochlor, water, filtered, recoverable, micrograms per liter
P50009 Alachlor ethanesulfonic acid, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P61031 Alachlor oxanilic acid, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P46342 Alachlor, water, filtered, recoverable, micrograms per liter
P77825 Alachlor, water, unfiltered, recoverable, micrograms per liter
P49313 Aldicarb sulfone, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82587 Aldicarb sulfone, water, unfiltered, recoverable, micrograms per liter
P49314 Aldicarb sulfoxide, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82586 Aldicarb sulfoxide, water, unfiltered, recoverable, micrograms per liter
P49312 Aldicarb, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82619 Aldicarb, water, unfiltered, recoverable, micrograms per liter
P39632 Atrazine, water, filtered, recoverable, micrograms per liter
P39630 Atrazine, water, unfiltered, recoverable, micrograms per liter
P61635 Azinphos-methyl oxygen analog, water, filtered, recoverable, micrograms per liter
P82686 Azinphos-methyl, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P39580 Azinphos-methyl, water, unfiltered, recoverable, micrograms per liter
P38711 Bentazon, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P04029 Bromacil, water, filtered, recoverable, micrograms per liter
P30234 Bromacil, water, unfiltered, recoverable, micrograms per liter
P49310 Carbaryl, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82680 Carbaryl, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P39750 Carbaryl, water, unfiltered, recoverable, micrograms per liter
P49309 Carbofuran, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82674 Carbofuran, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82615 Carbofuran, water, unfiltered, recoverable, micrograms per liter
P49306 Chlorothalonil, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P61636 Chlorpyrifos oxygen analog, water, filtered, recoverable, micrograms per liter
P38933 Chlorpyrifos, water, filtered, recoverable, micrograms per liter
P38932 Chlorpyrifos, water, unfiltered, recoverable, micrograms per liter
P81403 Chlorpyrifos, water, unfiltered, recoverable, micrograms per liter
P49305 Clopyralid, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P61595 lambda-Cyhalothrin, water, filtered, recoverable, micrograms per liter
P49304 Dacthal monoacid, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82682 DCPA, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P39770 DCPA, water, unfiltered, recoverable, micrograms per liter
P39572 Diazinon, water, filtered, recoverable, micrograms per liter
P39570 Diazinon, water, unfiltered, recoverable, micrograms per liter
P99223 Diazinon-d10, surrogate, Schedule 2002/9002, water, unfiltered, percent recovery
P91063 Diazinon-d10, surrogate, water, filtered (0.7 micron glass fiber filter), percent recovery
P38442 Dicamba, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82052 Dicamba, water, unfiltered, recoverable, micrograms per liter
P61588 Dimethenamid, water, filtered, recoverable, micrograms per liter
P49300 Diuron, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P61642 Endosulfan ether, water, filtered, recoverable, micrograms per liter
P34352 Endosulfan sulfate, water, filtered, recoverable, micrograms per liter
P61590 Endosulfan sulfate, water, filtered, recoverable, micrograms per liter
P34351 Endosulfan sulfate, water, unfiltered, recoverable, micrograms per liter
P49298 Esfenvalerate, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82672 Ethoprop, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P04025 Hexazinone, water, filtered, recoverable, micrograms per liter
P30264 Hexazinone, water, unfiltered, recoverable, micrograms per liter
P61695 Imidacloprid, water, filtered, recoverable, micrograms per liter
P39341 Lindane, water, filtered, recoverable, micrograms per liter
P39340 Lindane, water, unfiltered, recoverable, micrograms per liter
P39782 Lindane, water, unfiltered, recoverable, micrograms per liter
P39532 Malathion, water, filtered, recoverable, micrograms per liter
P39530 Malathion, water, unfiltered, recoverable, micrograms per liter
P50359 Metalaxyl, water, filtered, recoverable, micrograms per liter
P61596 Metalaxyl, water, filtered, recoverable, micrograms per liter
P04254 Metalaxyl, water, unfiltered, recoverable, micrograms per liter
P61043 Metolachlor ethanesulfonic acid, water, filtered (0.7 micron glass fiber filter), micrograms per liter
P61044 Metolachlor oxanilic acid, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P39415 Metolachlor, water, filtered, recoverable, micrograms per liter
P82612 Metolachlor, water, unfiltered, recoverable, micrograms per liter
P82630 Metribuzin, water, filtered, recoverable, micrograms per liter
P82611 Metribuzin, water, unfiltered, recoverable, micrograms per liter
P61697 Metsulfuron, water, filtered, recoverable, micrograms per liter
P82684 Napropamide, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P49293 Norflurazon, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82683 Pendimethalin, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P61668 Phosmet oxygen analog, water, filtered, recoverable, micrograms per liter
P61601 Phosmet, water, filtered, recoverable, micrograms per liter
P49291 Picloram, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P39720 Picloram, water, unfiltered, recoverable, micrograms per liter
P04037 Prometon, water, filtered, recoverable, micrograms per liter
P39056 Prometon, water, unfiltered, recoverable, micrograms per liter
P04036 Prometryn, water, filtered, recoverable, micrograms per liter
P39057 Prometryn, water, unfiltered, recoverable, micrograms per liter
P38535 Propazine, water, filtered, recoverable, micrograms per liter
P39024 Propazine, water, unfiltered, recoverable, micrograms per liter
P50471 Propiconazole, water, filtered, recoverable, micrograms per liter
P04035 Simazine, water, filtered, recoverable, micrograms per liter
P39025 Simazine, water, unfiltered, coulson conductivity, recoverable, micrograms per liter
P39055 Simazine, water, unfiltered, recoverable, micrograms per liter
P50337 Sulfometuron, water, filtered, recoverable, micrograms per liter
P82670 Tebuthiuron, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82665 Terbacil, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P04032 Terbacil, water, filtered, recoverable, micrograms per liter
P30311 Terbacil, water, unfiltered, recoverable, micrograms per liter
P82678 Triallate, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P49235 Triclopyr, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P82661 Trifluralin, water, filtered (0.7 micron glass fiber filter), recoverable, micrograms per liter
P39030 Trifluralin, water, unfiltered, recoverable, micrograms per liter
P82625 1,2-Dibromo-3-chloropropane, water, unfiltered, recoverable, micrograms per liter
P39733 2,4-D, suspended sediment, recoverable, micrograms per liter
P39573 Diazinon, suspended sediment, recoverable, micrograms per liter
P39342 Lindane, suspended sediment, recoverable, micrograms per liter
P39533 Malathion, suspended sediment, recoverable, micrograms per liter
P39731 2,4-D, bed sediment, recoverable, dry weight, micrograms per kilogram
P39631 Atrazine, bed sediment, recoverable, dry weight, micrograms per kilogram
P81404 Chlorpyrifos, bed sediment, recoverable, dry weight, micrograms per kilogram
P49324 DCPA, bed sediment smaller than 2 millimeters, wet sieved (native water), field, recoverable, dry weight, micrograms per kilogram
P39571 Diazinon, bed sediment, recoverable, dry weight, micrograms per kilogram
P38931 Dicamba, bed sediment, recoverable, dry weight, micrograms per kilogram
P34354 Endosulfan sulfate, bed sediment, recoverable, dry weight, micrograms per kilogram
P49345 Lindane, bed sediment smaller than 2 millimeters, wet sieved (native water), field, recoverable, dry weight, micrograms per kilogram
P39343 Lindane, bed sediment, recoverable, dry weight, micrograms per kilogram
P39531 Malathion, bed sediment, recoverable, dry weight, micrograms per kilogram
P39046 Simazine, bed sediment, recoverable, dry weight, micrograms per kilogram