South Dakota Environmental Events Database

 
The Environmental Events database is now searchable on-line.  The DENR Environmental Events Database contains information on the spills and releases that are reported to the Ground Water Quality Program.  Each field in this database corresponds to specific facts on the reported release.  Below are field specific definitions and examples of typical field entries in the database.  If you have any questions concerning this legend of information or Database itself, please contact our office at (605) 773-3296.  The database will be updated daily.  To view and search the Environmental Events database  Click Here
 

Environmental Event Information

SITE NUMBER
This field refers to the assigned case number for the reported release. This number starts with the year the spill was reported, followed by a period, then a sequential number. There are no spaces between each of the numbers in the file number. Example: 89.001, 95.321, or 93.030.

 

SITE NAME
This field identifies the specific name of the site release. This field may or may not also be the name of the responsible party. Example: Chuck’s Standard, Dakota Minnesota and Eastern Roundhouse, John Doe Truck Accident.

 

EVENT ADDRESS
This field identifies the street address or the file address of the release

 

EVENT CITY
This field identifies the town or city nearest the release site. All names should be written out not abbreviated. Punctuation should be used only when necessary. Example: Mac’s Corner, St. Charles.

 

EVENT ZIP
This field is designed for the ZIP code where the release occurred

 

EVENT COUNTY
This field is designed for the county where the release occurred.

 

MICROFILM ROLL NUMBER
This field is designed for the micro film roll number related to the release

 

RESPONSIBLE PARTY
This field represents the person or company named by the department as being responsible for the contamination. This responsible party may be more that one person. The responsible party may be the tank owner or operator, the person who caused the release or the current property owner.

 

DATE REPORTED
This date represents the date the spill/release was first reported to DENR. This field will be entered as month/day/year (xx/xx/xx).

 

DATE SPILLED
This date represents the date that the spill/release occurred. If a date is unknown (i.e., UST releases), this field will be blank. This field will be entered as month/day/year (xx/xx/xx).

 

DATE CLOSED
This field represents the date that the closure letter or inactive letter was signed by DENR Supervision. This field will be entered as month/day/year (xx/xx/xx).

 

CLEAN LETTER
Pertains to clean closure only

 

REVIEWER
This field refers to the name of the person in the department currently assigned to handle the case

 

STATUS
This field indicates the status of the site:
"O" = open;
"C" = closed ;
"M" = monitoring;
"I" or "I2" = inactive;
NFA = No Further Action;

DOA # - Department of Agriculture number.
If the release involves agricultural chemicals, the SD Department of Agriculture case number will be entered here.

 

MATERIAL
This field represents the material(s) released or identified. Typical responses include: gasoline, diesel, petroleum (if mixed), waste oil, hydraulic oil, metals, atrazine, etc.

 

AMOUNT
This field refers to the quantity of the material spilled or released.

 

UNITS
This field refers to the amount in field 9 and contains the appropriate unit as reported in the Spill Report (i.e. gallons, pounds, barrels, etc.).

 

PRCF CATEGORY
Pertains to Petroleum Release Compensation Fund

 

PRCF NUMBER
Pertains to Petroleum Release Compensation Fund

 

CONSULTANT
When applicable, this field contains the name of the consulting firm that is currently handling the site.

 

SPILL CATEGORY
Petroleum, Chemical (Industrial), Ag(ricultural) Chemical, & Other
These fields identify the category or type of materials released. Depending on the material released, more than one category may be checked. For example, a transformer oil release may have both the petroleum (oil) and the chemical (PCB) categories checked. For a gasoline spill, just the petroleum category will be checked. For spills that do not fit into one or more of the other categories the "other" category will be checked (i.e. milk or whey). The desired field(s) will be marked by an "X".

 

PROPERTY TYPE
The type of property as reported at the time of the event.

Commercial
Agricultural

Residential

Public

Other
- See case file for information regarding the property type.
Unknown
- The property type was unknown at the time of the release

 

SITE TYPE
The type of site as determined by DENR at the time of the event.
ATP- A Governor's Abandoned Tank Project site.
BROWNSFIELD
- A federal Brownsfield site.
CERCLIS
- A site identified within EPA's Comprehensive Environmental Response, Compensation and Liability Information System
CLEAN SITE
- The report did not include a release into the environment.
COMBINED
- See case file for available information.
FED
- A federal facility.
LUST TRUST
 - Site will be investigated utilizing federal Leaking Underground Storage Tank funds.
NONAQUIFER
- The release had not impacted an aquifer at the time of the notification.
OIL FIELD
- The release occurred at an identified oil field.
SOURCE WATER
 - The release has impacted a surface water source.
OTHER
 - See case file for site type information.
UNKNOWN
- See case file for available information

 

SOURC TYPE
The source from which the event was reported to have occurred.
AST - Aboveground Storage tanks (tanks, lines, and pumps)
UST - Underground Storage tanks (tanks, lines, and pumps)
EQUIPMENT FAILURE
HANDLING
TRANSFORMER
DRUMS
VANDALISM
TRANSPORTATION
SUMP PUMP
COMBINED - See case file for source type information
OTHER - See case file for source type information
UNKNOWN - See case file for source type information

 

PRIOR REVIEWER(S)
This field refers to the name(s) of the person(s) who handled the case before it was assigned to the current reviewer.


 

Tank Information

TANKS REMOVED
The number and size of any underground storage tanks removed from the site will be entered in this field.

 

ABANDONED IN PLACE
This field shows if the tank was abandoned in plcae.

 

REGULATED TANK
This field shows if the tank was a regulated tank

 

DATE REMOVED
This field represents the date when the tank was removed from the site

 

ATP NUMBER
This field pertains to Abandoned Tank Project


 

Location Information

LOCATION
Legal survey of the release site

 

IMAGES EXIST
Pictures of the release site

 

LATITUDE
Latitude will be obtained as close to the contamination as possible

 

LONGITUDE
Longitude will be obtained as close to the contamination as possible

 


If you have any questions please contact Bob McDonald or Rick Lancaster at (605) 773-3296.