Upper Midwest Environmental Sciences Center
 |
| Home/ Overview/ Science Programs/ Data Library/ Products and Publications/States/ Rivers/Teachers and Students/ Links/ Contact/ Search |
Sediment-Contaminant Database: File Format Information
|
Field Name
|
Field
Size |
Look-up Table
|
Value Range/Default
|
|
| Data-Source Variables | ||||
| DATA SET NUMBER | 2 | 99 | 1-99 | |
| DATA SET NAME | 2 | Y | 99 | 1-99 |
| INSTITUTION PROVIDING DATA | 2 | Y | 99 | 1-99 |
| DATA CONTACT | 2 | Y | 99 | 1-99 |
| BIBLIOGRAPHIC REFERENCE(S) | 2 | Y | 99 | 1-99 |
| SAMPLING PURPOSE | 2 | Y | 99 | 1-99 |
| QUALITY-ASSURANCE INDEX | 1 | Y | 9 | 1-5 |
| NUMBER OF OBSERVATIONS IN DATA SET | 4 | 9999 | 1-9999 | |
| DATE OF ENTRY INTO DATABASE | 10 | MM/DD/YYYY | 06/30/1999-Current Date | |
| DISCLAIMER | 4 | c(4) | USGS | |
|
Field Name
|
Field
Size |
Look-up Table
|
Format
|
Value Range/Default
|
| Database Sample Variables | ||||
| DATA SET NUMBER | 2 | 99 | 1-99 | |
| DATABASE SAMPLE NUMBER | 3 | 999 | 1-999 | |
| ORIGINAL SAMPLE NUMBER | 20 | c(20) | - | |
| Site-Characteristics Variables | ||||
| RIVER | 2 | Y | 99 | 1-99 |
| NAVIGATION POOL | 2 | Y | 99 | 1-99 |
| STATE | 1 | Y | 9 | 1-7 |
| COUNTY | 50 | c(50) | - | |
| RIVER MILE | 5,1 | 999.9 | 0-900.0 | |
| RIVER MILE UNITS | 2 | Y | 99 | 10 |
| SITE COMMON NAME | 2 | Y | 99 | 1-99 |
| SAMPLE COORDINATES NORTHING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES NORTHING UNITS | 2 | Y | 99 | 15 |
| SAMPLE COORDINATES EASTING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES EASTING UNITS | 2 | Y | 99 | 15 |
| WATER DEPTH | 4,1 | 99.9 | 0-99.9 | |
| WATER DEPTH UNITS | 1 | Y | 9 | 9 |
| Methods Variables | ||||
| DATE OF COLLECTION | 10 | MM/DD/YYYY | 01/01/1950-Current Date | |
| SAMPLING DURATION | 3 | 999 | 0-999 | |
| SAMPLING DURATION UNITS | 2 | Y | 99 | 12 |
| SAMPLE TYPE | 2 | Y | 99 | 1-20 |
| 2 | Y | 99 | 1-20 | |
| UPPER DEPTH OF SAMPLE IN SEDIMENT PROFILE | 3 | 999 | 0-999 | |
| UPPER DEPTH OF SAMPLE IN SEDIMENT PROFILE UNITS | 1 | Y | 9 | 8 |
| LOWER DEPTH OF SAMPLE IN SEDIMENT PROFILE | 3 | 999 | 0-999 | |
| LOWER DEPTH OF SAMPLE IN SEDIMENT PROFILE UNITS | 1 | Y | 9 | 8 |
| DIGESTION METHOD FOR INORGANIC CONTAMINANTS | 1 | Y | 9 | 1-9 |
| Sediment Toxicity Variables | ||||
| SEDIMENT CODE | 1 | Y | 9 | 1-9 |
| TEST ORGANISM | 2 | Y | 99 | 1-20 |
| DURATION OF EXPOSURE | 3 | 999 | 0-999 | |
| DURATION OF EXPOSURE UNITS | 2 | Y | 99 | 12 |
| BIOLOGICAL RESPONSE | 2 | Y | 99 | 1-20 |
| BIOLOGICAL RESPONSE DQ | 1 | Y | 9 | 1-9 |
| Sediment-Characteristics Variables | ||||
| VOLATILE MATTER CONTENT | 5,2 | 99.99 | 0-99.99 | |
| VOLATILE MATTER CONTENT UNITS | 1 | Y | 9 | 1 |
| VOLATILE MATTER CONTENT DQ | 1 | Y | 9 | 1-9 |
| TOTAL CARBON | 5,2 | 99.99 | 0-99.99 | |
| TOTAL CARBON UNITS | 1 | Y | 9 | 1 |
| ORGANIC CARBON | 5,2 | 99.99 | 0-99.99 | |
| ORGANIC CARBON UNITS | 1 | Y | 9 | 1 |
| CARBONATE CARBON | 5,2 | 99.99 | 0-99.99 | |
| CARBONATE CARBON UNITS | 1 | Y | 9 | 1 |
| TOTAL NITROGEN | 5,2 | 99.99 | 0-99.99 | |
| TOTAL NITROGEN UNITS | 1 | Y | 9 | 1 |
| ACID-VOLATILE SULFIDE | 5,1 | 999.9 | 0-999.9 | |
| ACID-VOLATILE SULFIDE UNITS | 1 | Y | 9 | 6 |
| GRAVEL CONTENT | 2 | 99 | 0-99 | |
| GRAVEL CONTENT UNITS | 1 | Y | 9 | 1 |
| SAND CONTENT | 2 | 99 | 0-99 | |
| SAND CONTENT UNITS | 1 | Y | 9 | 1 |
| SILT CONTENT | 2 | 99 | 0-99 | |
| SILT CONTENT UNITS | 1 | Y | 9 | 1 |
| CLAY CONTENT | 2 | 99 | 0-99 | |
| CLAY CONTENT UNITS | 1 | Y | 9 | 1 |
| SILT + CLAY CONTENT | 2 | 99 | 0-99 | |
| SILT + CLAY CONTENT UNITS | 1 | Y | 9 | 1 |
| WATER CONTENT | 2 | 99 | 0-99 | |
| WATER CONTENT UNITS | 1 | Y | 9 | 1 |
| DENSITY | 4,2 | 9.99 | 0-9.99 | |
| DENSITY UNITS | 1 | Y | 9 | 2 |
| SIZE-FRACTION ANALYZED, INORGANIC CONTAMINANTS | 5,3 | 9.999 | 0-9.999 | |
| SIZE-FRACTION ANALYZED, INORGANIC CONTAMINANTS UNITS | 1 | Y | 9 | 7 |
| SIZE-FRACTION ANALYZED, ORGANIC CONTAMINANTS | 5,3 | 9.999 | 0-9.999 | |
| SIZE-FRACTION ANALYZED, ORGANIC CONTAMINANTS UNITS | 1 | Y | 9 | 7 |
| APPROXIMATE YEAR OF DEPOSITION | 4 | 9999 (or YYYY) | 1700-2050 | |
| APPROXIMATE YEAR OF DEPOSITION UNITS | 2 | Y | 99 | 11 |
| LIPID CONTENT | 3,1 | 9.9 | 0-9.9 | |
| LIPID CONTENT UNITS | 1 | Y | 9 | 1 |
|
Field Name
|
Field
Size |
Look-up Table
|
Format
|
Value Range/Default
|
| Inorganics: Metals, Metalloids, Nutrients, and Others | ||||
| DATA SET NUMBER | 2 | 99 | 1-99 | |
| DATABASE SAMPLE NUMBER | 3 | 999 | 1-999 | |
| RIVER | 2 | Y | 99 | 1-99 |
| NAVIGATION POOL | 2 | Y | 99 | 1-99 |
| RIVER MILE | 5,1 | 999.9 | 0-900.0 | |
| RIVER MILE UNITS | 2 | Y | 99 | 10 |
| SAMPLE COORDINATES NORTHING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES NORTHING UNITS | 2 | Y | 99 | 15 |
| SAMPLE COORDINATES EASTING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES EASTING UNITS | 2 | Y | 99 | 15 |
| SAMPLE TYPE | 2 | Y | 99 | 1-20 |
| AMMONIA-NITROGEN | 8,3 | 9999.999 | 0 - 9999.999 | |
| AMMONIA-NITROGEN UNITS | 1 | Y | 9 | 3 |
| AMMONIA-NITROGEN DQ | 2 | Y | 99 | 1-20 |
| UN-IONIZED AMMONIA-NITROGEN | 8,3 | 9999.999 | 0 - 9999.999 | |
| UN-IONIZED AMMONIA-NITROGEN UNITS | 2 | Y | 99 | 16 |
| UN-IONIZED AMMONIA-NITROGEN DQ | 2 | Y | 99 | 1-20 |
| TOTAL AMMONIA-NITROGEN | 8,3 | 9999.999 | 0 - 9999.999 | |
| TOTAL AMMONIA-NITROGEN UNITS | 1 | Y | 9 | 4 |
| TOTAL AMMONIA-NITROGEN DQ | 2 | Y | 99 | 1-20 |
| SILVER | 8,3 | 9999.999 | 0 - 9999.999 | |
| SILVER UNITS | 1 | Y | 9 | 3 |
| SILVER DQ | 2 | Y | 99 | 1-20 |
| ALUMINUM | 8,3 | 99999.999 | 0 - 99999.999 | |
| ALUMINUM UNITS | 1 | Y | 9 | 3 |
| ALUMINUM DQ | 2 | Y | 99 | 1-20 |
| ARSENIC | 8,3 | 9999.999 | 0 - 9999.999 | |
| ARSENIC UNITS | 1 | Y | 9 | 3 |
| ARSENIC DQ | 2 | Y | 99 | 1-20 |
| BARIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| BARIUM UNITS | 1 | Y | 9 | 3 |
| BARIUM DQ | 2 | Y | 99 | 1-20 |
| BERYLLIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| BERYLLIUM UNITS | 1 | Y | 9 | 3 |
| BERYLLIUM DQ | 2 | Y | 99 | 1-20 |
| CADMIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| CADMIUM UNITS | 1 | Y | 9 | 3 |
| CADMIUM DQ | 2 | Y | 99 | 1-20 |
| CHROMIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHROMIUM UNITS | 1 | Y | 9 | 3 |
| CHROMIUM DQ | 2 | Y | 99 | 1-20 |
| COPPER | 8,3 | 9999.999 | 0 - 9999.999 | |
| COPPER UNITS | 1 | Y | 9 | 3 |
| COPPER DQ | 2 | Y | 99 | 1-20 |
| IRON | 8,3 | 99999.999 | 0 - 99999.999 | |
| IRON UNITS | 1 | Y | 9 | 3 |
| IRON DQ | 2 | Y | 99 | 1-20 |
| MERCURY | 8,3 | 9999.999 | 0 - 9999.999 | |
| MERCURY UNITS | 1 | Y | 9 | 3 |
| MERCURY DQ | 2 | Y | 99 | 1-20 |
| METHYLMERCURY | 8,3 | 9999.999 | 0 - 9999.999 | |
| METHYLMERCURY UNITS | 1 | Y | 9 | 3 |
| METHYLMERCURY DQ | 2 | Y | 99 | 1-20 |
| MOLYBDENUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| MOLYBDENUM UNITS | 1 | Y | 9 | 3 |
| MOLYBDENUM DQ | 2 | Y | 99 | 1-20 |
| NICKEL | 8,3 | 9999.999 | 0 - 9999.999 | |
| NICKEL UNITS | 1 | Y | 9 | 3 |
| NICKEL DQ | 2 | Y | 99 | 1-20 |
| LEAD | 8,3 | 9999.999 | 0 - 9999.999 | |
| LEAD UNITS | 1 | Y | 9 | 3 |
| LEAD DQ | 2 | Y | 99 | 1-20 |
| MANGANESE | 8,3 | 99999.999 | 0 - 99999.999 | |
| MANGANESE UNITS | 1 | Y | 9 | 3 |
| MANGANESE DQ | 2 | Y | 99 | 1-20 |
| TOTAL PHOSPHORUS | 8,3 | 9999.999 | 0 - 9999.999 | |
| TOTAL PHOSPHORUS UNITS | 1 | Y | 9 | 3 |
| TOTAL PHOSPHORUS DQ | 2 | Y | 99 | 1-20 |
| SELENIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| SELENIUM UNITS | 1 | Y | 9 | 3 |
| SELENIUM DQ | 2 | Y | 99 | 1-20 |
| ANTIMONY | 8,3 | 9999.999 | 0 - 9999.999 | |
| ANTIMONY UNITS | 1 | Y | 9 | 3 |
| ANTIMONY DQ | 2 | Y | 99 | 1-20 |
| TIN | 8,3 | 9999.999 | 0 - 9999.999 | |
| TIN UNITS | 1 | Y | 9 | 3 |
| TIN DQ | 2 | Y | 99 | 1-20 |
| THALLIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| THALLIUM UNITS | 1 | Y | 9 | 3 |
| THALLIUM DQ | 2 | Y | 99 | 1-20 |
| VANADIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| VANADIUM UNITS | 1 | Y | 9 | 3 |
| VANADIUM DQ | 2 | Y | 99 | 1-20 |
| ZINC | 8,3 | 99999.999 | 0 - 99999.999 | |
| ZINC UNITS | 1 | Y | 9 | 3 |
| ZINC DQ | 2 | Y | 99 | 1-20 |
| POTASSIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| POTASSIUM UNITS | 1 | Y | 9 | 3 |
| POTASSIUM DQ | 2 | Y | 99 | 1-20 |
| CALCIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| CALCIUM UNITS | 1 | Y | 9 | 3 |
| CALCIUM DQ | 2 | Y | 99 | 1-20 |
| TITANIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| TITANIUM UNITS | 1 | Y | 9 | 3 |
| TITANIUM DQ | 2 | Y | 99 | 1-20 |
| BROMINE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BROMINE UNITS | 1 | Y | 9 | 3 |
| BROMINE DQ | 2 | Y | 99 | 1-20 |
| CYANIDE | 8,3 | 9999.999 | 0 - 9999.999 | |
| CYANIDE UNTIS | 1 | Y | 9 | 3 |
| CYANIDE DQ | 2 | Y | 99 | 1-20 |
| CYANIDE, AMENABLE | 8,3 | 9999.999 | 0 - 9999.999 | |
| CYANIDE, AMENABLE UNITS | 1 | Y | 9 | 3 |
| CYANIDE, AMENABLE DQ | 2 | Y | 99 | 1-20 |
| BORON | 8,3 | 9999.999 | 0 - 9999.999 | |
| BORON UNITS | 1 | Y | 9 | 3 |
| BORON DQ | 2 | Y | 99 | 1-20 |
| MAGNESIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| MAGNESIUM UNITS | 1 | Y | 9 | 3 |
| MAGNESIUM DQ | 2 | Y | 99 | 1-20 |
| STRONTIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| STRONTIUM UNITS | 1 | Y | 9 | 3 |
| STRONTIUM DQ | 2 | Y | 99 | 1-20 |
| LANTHANUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| LANTHANUM UNITS | 1 | Y | 9 | 3 |
| LANTHANUM DQ | 2 | Y | 99 | 1-20 |
| SODIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| SODIUM UNITS | 1 | Y | 9 | 3 |
| SODIUM DQ | 2 | Y | 99 | 1-20 |
| GOLD | 8,3 | 9999.999 | 0 - 9999.999 | |
| GOLD UNITS | 1 | Y | 9 | 3 |
| GOLD DQ | 2 | Y | 99 | 1-20 |
| BISMUTH | 8,3 | 9999.999 | 0 - 9999.999 | |
| BISMUTH UNITS | 1 | Y | 9 | 3 |
| BISMUTH DQ | 2 | Y | 99 | 1-20 |
| CERIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| CERIUM UNITS | 1 | Y | 9 | 3 |
| CERIUM DQ | 2 | Y | 99 | 1-20 |
| COBALT | 8,3 | 9999.999 | 0 - 9999.999 | |
| COBALT UNITS | 1 | Y | 9 | 3 |
| COBALT DQ | 2 | Y | 99 | 1-20 |
| GALLIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| GALLIUM UNITS | 1 | Y | 9 | 3 |
| GALLIUM DQ | 2 | Y | 99 | 1-20 |
| HOLMIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| HOLMIUM UNITS | 1 | Y | 9 | 3 |
| HOLMIUM DQ | 2 | Y | 99 | 1-20 |
| EUROPIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| EUROPIUM UNITS | 1 | Y | 9 | 3 |
| EUROPIUM DQ | 2 | Y | 99 | 1-20 |
| LITHIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| LITHIUM UNITS | 1 | Y | 9 | 3 |
| LITHIUM DQ | 2 | Y | 99 | 1-20 |
| NIOBIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| NIOBIUM UNITS | 1 | Y | 9 | 3 |
| NIOBIUM DQ | 2 | Y | 99 | 1-20 |
| NEODYMIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| NEODYMIUM UNITS | 1 | Y | 9 | 3 |
| NEODYMIUM DQ | 2 | Y | 99 | 1-20 |
| SCANDIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| SCANDIUM UNITS | 1 | Y | 9 | 3 |
| SCANDIUM DQ | 2 | Y | 99 | 1-20 |
| TANTALUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| TANTALUM UNITS | 1 | Y | 9 | 3 |
| TANTALUM DQ | 2 | Y | 99 | 1-20 |
| YTTRIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| YTTRIUM UNITS | 1 | Y | 9 | 3 |
| YTTRIUM DQ | 2 | Y | 99 | 1-20 |
| YTTERBIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| YTTERBIUM UNITS | 1 | Y | 9 | 3 |
| YTTERBIUM DQ | 2 | Y | 99 | 1-20 |
| URANIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| URANIUM UNITS | 1 | Y | 9 | 3 |
| URANIUM DQ | 2 | Y | 99 | 1-20 |
| THORIUM | 8,3 | 9999.999 | 0 - 9999.999 | |
| THORIUM UNITS | 1 | Y | 9 | 3 |
| THORIUM DQ | 2 | Y | 99 | 1-20 |
| SULFUR | 8,3 | 9999.999 | 0 - 9999.999 | |
| SULFUR UNITS | 1 | Y | 9 | 3 |
| SULFUR DQ | 2 | Y | 99 | 1-20 |
|
Field Name
|
Field
Size |
Look-up Table
|
Format
|
Value Range/Default
|
| Inorganics: Simultaneously Extracted Metals (SEM) | ||||
| DATA SET NUMBER | 2 | 99 | 1-99 | |
| DATABASE SAMPLE NUMBER | 3 | 999 | 1-999 | |
| RIVER | 2 | Y | 99 | 1-99 |
| NAVIGATION POOL | 2 | Y | 99 | 1-99 |
| RIVER MILE | 2 | Y | 99 | 10 |
| RIVER MILE UNITS | 5 | Y | c(5) | miles |
| SAMPLE COORDINATES NORTHING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES NORTHING UNITS | 2 | Y | 99 | 15 |
| SAMPLE COORDINATES EASTING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES EASTING UNITS | 2 | Y | 99 | 15 |
| SAMPLE TYPE | 2 | Y | 99 | 1-20 |
| CADMIUM-SEM | 8,3 | 9999.999 | 0 - 9999.999 | |
| CADMIUM-SEM UNITS | 1 | Y | 9 | 6 |
| CADMIUM-SEM DQ | 2 | Y | 99 | 1-20 |
| CHROMIUM-SEM | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHROMIUM-SEM UNITS | 1 | Y | 9 | 6 |
| CHROMIUM-SEM DQ | 2 | Y | 99 | 1-20 |
| COPPER-SEM | 8,3 | 9999.999 | 0 - 9999.999 | |
| COPPER-SEM UNITS | 1 | Y | 9 | 6 |
| COPPER-SEM DQ | 2 | Y | 99 | 1-20 |
| NICKEL-SEM | 8,3 | 9999.999 | 0 - 9999.999 | |
| NICKEL-SEM UNITS | 1 | Y | 9 | 6 |
| NICKEL-SEM DQ | 2 | Y | 99 | 1-20 |
| LEAD-SEM | 8,3 | 9999.999 | 0 - 9999.999 | |
| LEAD-SEM UNITS | 1 | Y | 9 | 6 |
| LEAD-SEM DQ | 2 | Y | 99 | 1-20 |
| ZINC-SEM | 8,3 | 9999.999 | 0 - 9999.999 | |
| ZINC-SEM UNITS | 1 | Y | 9 | 6 |
| ZINC-SEM DQ | 2 | Y | 99 | 1-20 |
| ARSENIC-SEM | 8,3 | 9999.999 | 0 - 9999.999 | |
| ARSENIC-SEM UNITS | 1 | Y | 9 | 6 |
| ARSENIC-SEM DQ | 2 | Y | 99 | 1-20 |
|
Field Name
|
Field
Size |
Look-up Table
|
Format
|
Value Range/Default
|
| Organics: Polynuclear Aromatic Hydrocarbons (PAHs) | ||||
| DATA SET NUMBER | 2 | 99 | 1-99 | |
| DATABASE SAMPLE NUMBER | 3 | 999 | 1-999 | |
| RIVER | 2 | Y | 99 | 1-99 |
| NAVIGATION POOL | 2 | Y | 99 | 1-99 |
| RIVER MILE | 5,1 | 999.9 | 0-900.0 | |
| RIVER MILE UNITS | 2 | Y | 99 | 10 |
| SAMPLE COORDINATES NORTHING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES NORTHING UNITS | 2 | Y | 99 | 15 |
| SAMPLE COORDINATES EASTING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES EASTING UNITS | 2 | Y | 99 | 15 |
| SAMPLE TYPE | 2 | Y | 99 | 1-20 |
| ACENAPHTHENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| ACENAPHTHENE UNITS | 1 | Y | 9 | 3 |
| ACENAPHTHENE DQ | 2 | Y | 99 | 1-20 |
| ACENAPHTHYLENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| ACENAPHTHYLENE UNITS | 1 | Y | 9 | 3 |
| ACENAPHTHYLENE DQ | 2 | Y | 99 | 1-20 |
| ANTHRACENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| ANTHRACENE UNITS | 1 | Y | 9 | 3 |
| ANTHRACENE DQ | 2 | Y | 99 | 1-20 |
| BENZ(A)ANTHRACENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BENZ(A)ANTHRACENE UNITS | 1 | Y | 9 | 3 |
| BENZ(A)ANTHRACENE DQ | 2 | Y | 99 | 1-20 |
| BENZO(B)FLUORANTHENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BENZO(B)FLUORANTHENE UNITS | 1 | Y | 9 | 3 |
| BENZO(B)FLUORANTHENE DQ | 2 | Y | 99 | 1-20 |
| BENZO(K)FLUORANTHENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BENZO(K)FLUORANTHENE UNITS | 1 | Y | 9 | 3 |
| BENZO(K)FLUORANTHENE DQ | 2 | Y | 99 | 1-20 |
| BENZO(G,H,I)PERYLENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BENZO(G,H,I)PERYLENE UNITS | 1 | Y | 9 | 3 |
| BENZO(G,H,I)PERYLENE DQ | 2 | Y | 99 | 1-20 |
| BENZO(A)PYRENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BENZO(A)PYRENE UNITS | 1 | Y | 9 | 3 |
| BENZO(A)PYRENE DQ | 2 | Y | 99 | 1-20 |
| BENZO(E)PYRENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BENZO(E)PYRENE UNITS | 1 | Y | 9 | 3 |
| BENZO(E)PYRENE DQ | 2 | Y | 99 | 1-20 |
| BIPHENYL | 8,3 | 9999.999 | 0 - 9999.999 | |
| BIPHENYL UNITS | 1 | Y | 9 | 3 |
| BIPHENYL DQ | 2 | Y | 99 | 1-20 |
| CHRYSENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHRYSENE UNITS | 1 | Y | 9 | 3 |
| CHRYSENE DQ | 2 | Y | 99 | 1-20 |
| DIBENZ(A,H)ANTHRACENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| DIBENZ(A,H)ANTHRACENE UNITS | 1 | Y | 9 | 3 |
| DIBENZ(A,H)ANTHRACENE DQ | 2 | Y | 99 | 1-20 |
| 2,6-DIMETHYLNAPHTHALENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| 2,6-DIMETHYLNAPHTHALENE UNITS | 1 | Y | 9 | 3 |
| 2,6-DIMETHYLNAPHTHALENE DQ | 2 | Y | 99 | 1-20 |
| FLUORANTHENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| FLUORANTHENE UNITS | 1 | Y | 9 | 3 |
| FLUORANTHENE DQ | 2 | Y | 99 | 1-20 |
| FLUORENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| FLUORENE UNITS | 1 | Y | 9 | 3 |
| FLUORENE DQ | 2 | Y | 99 | 1-20 |
| 1-METHYLPHENANTHRENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| 1-METHYLPHENANTHRENE UNITS | 1 | Y | 9 | 3 |
| 1-METHYLPHENANTHRENE DQ | 2 | Y | 99 | 1-20 |
| NAPHTHALENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| NAPHTHALENE UNITS | 1 | Y | 9 | 3 |
| NAPHTHALENE DQ | 2 | Y | 99 | 1-20 |
| PERYLENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| PERYLENE UNITS | 1 | Y | 9 | 3 |
| PERYLENE DQ | 2 | Y | 99 | 1-20 |
| PHENANTHRENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| PHENANTHRENE UNITS | 1 | Y | 9 | 3 |
| PHENANTHRENE DQ | 2 | Y | 99 | 1-20 |
| PYRENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| PYRENE UNITS | 1 | Y | 9 | 3 |
| PYRENE DQ | 2 | Y | 99 | 1-20 |
| INDENO(1,2,3,-CD)PYRENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| INDENO(1,2,3,-CD)PYRENE UNITS | 1 | Y | 9 | 3 |
| INDENO(1,2,3,-CD)PYRENE DQ | 2 | Y | 99 | 1-20 |
| 1,6,7-TRIMETHYL-NAPHTHALENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| 1,6,7-TRIMETHYL-NAPHTHALENE UNITS | 1 | Y | 9 | 3 |
| 1,6,7-TRIMETHYL-NAPHTHALENE DQ | 2 | Y | 99 | 1-20 |
| 1,2:5,6-DIBENZANTHRACENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| 1,2:5,6-DIBENZANTHRACENE UNITS | 1 | Y | 9 | 3 |
| 1,2:5,6-DIBENZANTHRACENE DQ | 2 | Y | 99 | 1-20 |
| DIBENZANTHRACENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| DIBENZANTHRACENE UNITS | 1 | Y | 9 | 3 |
| DIBENZANTHRACENE DQ | 2 | Y | 99 | 1-20 |
| 1,2-BENZANTHRACENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| 1,2-BENZANTHRACENE UNITS | 1 | Y | 9 | 3 |
| 1,2-BENZANTHRACENE DQ | 2 | Y | 99 | 1-20 |
| BENZANTHRACENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| BENZANTHRACENE UNITS | 1 | Y | 9 | 3 |
| BENZANTHRACENE DQ | 2 | Y | 99 | 1-20 |
| ACRIDINE | 8,3 | 9999.999 | 0 - 9999.999 | |
| ACRIDINE UNITS | 1 | Y | 9 | 3 |
| ACRIDINE DQ | 2 | Y | 99 | 1-20 |
| 2-CHLORONAPHTHALENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| 2-CHLORONAPHTHALENE UNITS | 1 | Y | 9 | 3 |
| 2-CHLORONAPHTHALENE DQ | 2 | Y | 99 | 1-20 |
| TOTAL PAHS | 8,3 | 9999.999 | 0 - 9999.999 | |
| TOTAL PAHS UNITS | 1 | Y | 9 | 3 |
| TOTAL PAHS DQ | 2 | Y | 99 | 1-20 |
|
Field Name
|
Field
Size |
Look-up Table
|
Format
|
Value Range/Default
|
| Organics: Organochlorine Insecticides | ||||
| DATA SET NUMBER | 2 | 99 | 1-99 | |
| DATABASE SAMPLE NUMBER | 3 | 999 | 1-999 | |
| RIVER | 2 | Y | 99 | 1-99 |
| NAVIGATION POOL | 2 | Y | 99 | 1-99 |
| RIVER MILE | 5,1 | 999.9 | 0-900.0 | |
| RIVER MILE UNITS | 2 | Y | 99 | 10 |
| SAMPLE COORDINATES NORTHING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES NORTHING UNITS | 2 | Y | 99 | 15 |
| SAMPLE COORDINATES EASTING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES EASTING UNITS | 2 | Y | 99 | 15 |
| SAMPLE TYPE | 2 | Y | 99 | 1-20 |
| ALDRIN | 8,3 | 9999.999 | 0 - 9999.999 | |
| ALDRIN UNITS | 1 | Y | 9 | 5 |
| ALDRIN DQ | 2 | Y | 99 | 1-20 |
| CHLORDANE, CIS | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHLORDANE, CIS UNITS | 1 | Y | 9 | 5 |
| CHLORDANE, CIS DQ | 2 | Y | 99 | 1-20 |
| CHLORDANE, TRANS | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHLORDANE, TRANS UNITS | 1 | Y | 9 | 5 |
| CHLORDANE, TRANS DQ | 2 | Y | 99 | 1-20 |
| O, P'-DDD | 8,3 | 9999.999 | 0 - 9999.999 | |
| O, P'-DDD UNITS | 1 | Y | 9 | 5 |
| O, P'-DDD DQ | 2 | Y | 99 | 1-20 |
| P, P'-DDD | 8,3 | 9999.999 | 0 - 9999.999 | |
| P, P'-DDD UNITS | 1 | Y | 9 | 5 |
| P, P'-DDD DQ | 2 | Y | 99 | 1-20 |
| O, P'-DDE | 8,3 | 9999.999 | 0 - 9999.999 | |
| O, P'-DDE UNITS | 1 | Y | 9 | 5 |
| O, P'-DDE DQ | 2 | Y | 99 | 1-20 |
| P, P'-DDE | 8,3 | 9999.999 | 0 - 9999.999 | |
| P, P'-DDE UNITS | 1 | Y | 9 | 5 |
| P, P'-DDE DQ | 2 | Y | 99 | 1-20 |
| O, P'-DDT | 8,3 | 9999.999 | 0 - 9999.999 | |
| O, P'-DDT UNITS | 1 | Y | 9 | 5 |
| O, P'-DDT DQ | 2 | Y | 99 | 1-20 |
| P, P'-DDT | 8,3 | 9999.999 | 0 - 9999.999 | |
| P, P'-DDT UNITS | 1 | Y | 9 | 5 |
| P, P'-DDT DQ | 2 | Y | 99 | 1-20 |
| DIELDRIN | 8,3 | 9999.999 | 0 - 9999.999 | |
| DIELDRIN UNITS | 1 | Y | 9 | 5 |
| DIELDRIN DQ | 2 | Y | 99 | 1-20 |
| DIETHYLHEXYPHTHALATE | 8,3 | 9999.999 | 0 - 9999.999 | |
| DIETHYLHEXYPHTHALATE UNITS | 1 | Y | 9 | 5 |
| DIETHYLHEXYPHTHALATE DQ | 2 | Y | 99 | 1-20 |
| ENDRIN | 8,3 | 9999.999 | 0 - 9999.999 | |
| ENDRIN UNITS | 1 | Y | 9 | 5 |
| ENDRIN DQ | 2 | Y | 99 | 1-20 |
| HEPTACHLOR | 8,3 | 9999.999 | 0 - 9999.999 | |
| HEPTACHLOR UNITS | 1 | Y | 9 | 5 |
| HEPTACHLOR DQ | 2 | Y | 99 | 1-20 |
| HEPTACHLOR EPOXIDE | 8,3 | 9999.999 | 0 - 9999.999 | |
| HEPTACHLOR EPOXIDE UNITS | 1 | Y | 9 | 5 |
| HEPTACHLOR EPOXIDE DQ | 2 | Y | 99 | 1-20 |
| HEXACHLOROCYCLOHEXANE, ALPHA | 8,3 | 9999.999 | 0 - 9999.999 | |
| HEXACHLOROCYCLOHEXANE, ALPHA UNITS | 1 | Y | 9 | 5 |
| HEXACHLOROCYCLOHEXANE, ALPHA DQ | 2 | Y | 99 | 1-20 |
| HEXACHLOROCYCLOHEXANE, BETA | 8,3 | 9999.999 | 0 - 9999.999 | |
| HEXACHLOROCYCLOHEXANE, BETA UNITS | 1 | Y | 9 | 5 |
| HEXACHLOROCYCLOHEXANE, BETA DQ | 2 | Y | 99 | 1-20 |
| HEXACHLOROCYCLOHEXANE, DELTA | 8,3 | 9999.999 | 0 - 9999.999 | |
| HEXACHLOROCYCLOHEXANE, DELTA UNITS | 1 | Y | 9 | 5 |
| HEXACHLOROCYCLOHEXANE, DELTA DQ | 2 | Y | 99 | 1-20 |
| HEXACHLOROCYCLOHEXANE, GAMMA (LINDANE) | 8,3 | 9999.999 | 0 - 9999.999 | |
| HEXACHLOROCYCLOHEXANE, GAMMA (LINDANE) UNITS | 1 | Y | 9 | 5 |
| HEXACHLOROCYCLOHEXANE, GAMMA (LINDANE) DQ | 2 | Y | 99 | 1-20 |
| HEXACHLOROCYCLOPENTADIENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| HEXACHLOROCYCLOPENTADIENE UNITS | 1 | Y | 9 | 5 |
| HEXACHLOROCYCLOPENTADIENE DQ | 2 | Y | 99 | 1-20 |
| O, P'-METHOXYCHLOR | 8,3 | 9999.999 | 0 - 9999.999 | |
| O, P'-METHOXYCHLOR UNITS | 1 | Y | 9 | 5 |
| O, P'-METHOXYCHLOR DQ | 2 | Y | 99 | 1-20 |
| P, P'-METHOXYCHLOR | 8,3 | 9999.999 | 0 - 9999.999 | |
| P, P'-METHOXYCHLOR UNITS | 1 | Y | 9 | 5 |
| P, P'-METHOXYCHLOR DQ | 2 | Y | 99 | 1-20 |
| MIREX | 8,3 | 9999.999 | 0 - 9999.999 | |
| MIREX UNITS | 1 | Y | 9 | 5 |
| MIREX DQ | 2 | Y | 99 | 1-20 |
| NONACHLOR, CIS | 8,3 | 9999.999 | 0 - 9999.999 | |
| NONACHLOR, CIS UNITS | 1 | Y | 9 | 5 |
| NONACHLOR, CIS DQ | 2 | Y | 99 | 1-20 |
| NONACHLOR, TRANS | 8,3 | 9999.999 | 0 - 9999.999 | |
| NONACHLOR, TRANS UNITS | 1 | Y | 9 | 5 |
| NONACHLOR, TRANS DQ | 2 | Y | 99 | 1-20 |
| OXYCHLORDANE | 8,3 | 9999.999 | 0 - 9999.999 | |
| OXYCHLORDANE UNITS | 1 | Y | 9 | 5 |
| OXYCHLORDANE DQ | 2 | Y | 99 | 1-20 |
| PENTACHLOROANISOLE | 8,3 | 9999.999 | 0 - 9999.999 | |
| PENTACHLOROANISOLE UNITS | 1 | Y | 9 | 5 |
| PENTACHLOROANISOLE DQ | 2 | Y | 99 | 1-20 |
| PERTHANE | 8,3 | 9999.999 | 0 - 9999.999 | |
| PERTHANE UNITS | 1 | Y | 9 | 5 |
| PERTHANE DQ | 2 | Y | 99 | 1-20 |
| TOXAPHENE | 8,3 | 9999.999 | 0 - 9999.999 | |
| TOXAPHENE UNITS | 1 | Y | 9 | 5 |
| TOXAPHENE DQ | 2 | Y | 99 | 1-20 |
| CHLORDANE | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHLORDANE UNITS | 1 | Y | 9 | 5 |
| CHLORDANE DQ | 2 | Y | 99 | 1-20 |
| CHLORDANE, TECHNICAL | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHLORDANE, TECHNICAL UNITS | 1 | Y | 9 | 5 |
| CHLORDANE, TECHNICAL DQ | 2 | Y | 99 | 1-20 |
| CHLORDANE, ALPHA | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHLORDANE, ALPHA UNITS | 1 | Y | 9 | 5 |
| CHLORDANE, ALPHA DQ | 2 | Y | 99 | 1-20 |
| CHLORDANE, GAMMA | 8,3 | 9999.999 | 0 - 9999.999 | |
| CHLORDANE, GAMMA UNITS | 1 | Y | 9 | 5 |
| CHLORDANE, GAMMA DQ | 2 | Y | 99 | 1-20 |
| ISODRIN | 8,3 | 9999.999 | 0 - 9999.999 | |
| ISODRIN UNITS | 1 | Y | 9 | 5 |
| ISODRIN DQ | 2 | Y | 99 | 1-20 |
| ENDRIN ALDEHYDE | 8,3 | 9999.999 | 0 - 9999.999 | |
| ENDRIN ALDEHYDE UNITS | 1 | Y | 9 | 5 |
| ENDRIN ALDEHYDE DQ | 2 | Y | 99 | 1-20 |
| ENDOSULFAN I | 8,3 | 9999.999 | 0 - 9999.999 | |
| ENDOSULFAN I UNITS | 1 | Y | 9 | 5 |
| ENDOSULFAN I DQ | 2 | Y | 99 | 1-20 |
| ENDOSULFAN II | 8,3 | 9999.999 | 0 - 9999.999 | |
| ENDOSULFAN II UNITS | 1 | Y | 9 | 5 |
| ENDOSULFAN II DQ | 2 | Y | 99 | 1-20 |
| ENDOSULFAN SULFATE | 8,3 | 9999.999 | 0 - 9999.999 | |
| ENDOSULFAN SULFATE UNITS | 1 | Y | 9 | 5 |
| ENDOSULFAN SULFATE DQ | 2 | Y | 99 | 1-20 |
|
Field Name
|
Field
Size |
Look-up
Table |
Format
|
Value Range/Default
|
| Organics: Insecticides | ||||
| DATA SET NUMBER | 2 | 99 | 1-99 | |
| DATABASE SAMPLE NUMBER | 3 | 999 | 1-999 | |
| RIVER | 2 | Y | 99 | 1-99 |
| NAVIGATION POOL | 2 | Y | 99 | 1-99 |
| RIVER MILE | 5,1 | 999.9 | 0-900.0 | |
| RIVER MILE UNITS | 2 | Y | 99 | 10 |
| SAMPLE COORDINATES NORTHING | 7 | 9999999 | 0-9999999 | |
| SAMPLE COORDINATES NORTHING UNITS | 2 | Y | ||
