Environmental Event Information

Downloaded Spreadsheet Data

The following information pertains to the spreadsheet provided when search results are downloaded.

COLUMN A: gw_spills_id

DENR ENVIRONMENTAL EVENT - SITE IDENTIFICATION NUMBER
The cells in this column refer to the assigned DENR case number for the reported release. The typical case number begins with the year the spill was reported followed by a decimal and a sequential number. Examples: 89.001 or 2012.001. A “clean” case number begins with the year the case was reported and follows with a sequential number (no decimal). Examples: 99001 or 2012001. Sites that were submitted into the Abandoned Tank Program but were later withdrawn begin with the numbers 9999 followed by a decimal and a sequential number. Example: 9999.001. It is anticipated that 8888 will be added for Clandestine Drug Labs and 7777 will be added for Former Landfills. Each will be followed by a decimal and a sequential number.

COLUMN B: gw_spills_site_name

DENR ENVIRONMENTAL EVENT - SITE NAME
The cells in this column identify the assigned name of the case. This field will often be descriptive and may or may not also include the name of the responsible party, location, or other identifying information.

COLUMN C: gw_spills_resp_party

DENR ENVIRONMENTAL EVENT - RESPONSIBLE PARTY
The cells in this column identify the party named by the department as responsible for cleanup of the site. The responsible party may be the tank owner or operator, the person who caused the release, the current property owner, a past property owner, or a combination of responsible parties.

COLUMN D: gw_spills_county

DENR ENVIRONMENTAL EVENT - EVENT COUNTY
The cells in this column identify the county where the release occurred.

COLUMN E: gw_spills_street

DENR ENVIRONMENTAL EVENT - EVENT ADDRESS
The cells in this column identify the reported address or the estimated address of the release. It may be a roadway with a building number, the intersection of two roadways, the best estimated address, or another method of identification (facility name, building number, etc).

COLUMN F: gw_spills_city

DENR ENVIRONMENTAL EVENT - EVENT CITY
The cells in this column identify the town or city nearest to the release site. All names should be spelled out (not abbreviated). Note: The nearest city may be located outside of the county where the spill occurred.

COLUMN G: gw_spills_zip_code 

DENR ENVIRONMENTAL EVENT - EVENT ZIP
The cells in this column identify the ZIP code of the nearest city.

COLUMN H: gw_spills_spill_cat 

DENR ENVIRONMENTAL EVENT – CONTAMINANT TYPE CATEGORY
The cells in this column identify the suspected type of contamination.

The categories:

AGRI CHEM  (non-petroleum and/or regulated substances which were associated with agricultural operations);

CHEMICAL  (non-petroleum and/or regulated substances which were not associated with agricultural operations);

COMBINED (See Case File)  (includes multiple spill categories - additional information can be found in the case file);

OIL  (thick viscosity refined product and crude, can include cooking oils);

OTHER (See Case File)  (pertains to a product not categorized - additional information can be found in the case file); and

PETROLEUM  (thin viscosity refined products);

UNKNOWN (See Case File)  (the category either was not known at the time of the report or the case file does not identify the contaminant).

COLUMN I: gw_spills_sor_type 

DENR ENVIRONMENTAL EVENT – CONTAMINANT SOURCE CATEGORY
The cells in this column identify the suspected source of contamination.

The source types:
AST  (“Aboveground Storage Tank” and may include associated lines and pumps);

COMBINED (See Case File)   (includes multiple source types - additional information can be found in the case file);

DRUMS  (related to drum-type storage containers);

EQUIPMENT FAILURE  (related to an equipment failure and may include dispensing lines);

HANDLING  (related to operator or procedural error);

OTHER (See Case File)  (pertains to a product not categorized - additional information can be found in the case file);

PAST PRACTICES  (related to the historical use of a site that included formerly acceptable or otherwise non-regulated practices);

PIPELINE  (related to the movement of product through a pipeline);

SUMP PUMP  (related to sump water or the operation of a sump pump);

TRANSFORMER  (related to an electric power transmission device);

TRANSPORTATION  (related to transportation equipment or the transportation of substances);

UNKNOWN (See Case File)  (the category either was not known at the time of the report or the case file does not identify the contaminant);

UST  (“Underground Storage Tank” and may include associated lines and pumps); and

VANDALISM  (related to the illegal destruction of property).

COLUMN J: gw_spills_site_type 

DENR ENVIRONMENTAL EVENT – CASE SITE TYPE CATEGORY

The cells in this column identify the type of site.

The site types:
AQUIFER  (the site event is believed to have impacted an identified aquifer);

ATP  (the site is funded through the “Abandoned Tank Program” – a South Dakota program that assists with the removal of some underground storage tanks);

BROWNFIELDS  (the site has been identified as a South Dakota Brownfields site and the site has been assessed and/or cleaned with Brownfields funding);

CERCLIS – (the site has been identified within EPA's Comprehensive Environmental Response, Compensation and Liability Information System);

CLANDESTINE DRUG LAB  (the site has been identified as pertaining to the the manufacture of illegal drugs);
CLEAN SITE  (the site report did not indicate or otherwise identify a release into the environment);
COMBINED (See Case File)   (includes multiple site types - additional information can be found in the case file);

FEDERAL  (the site is located within the confines of a federal property);

FORMER LANDFILL  (the site is a former landfill);

LUST TRUST  (the site investigation utilizes federal Leaking Underground Storage Tank funding);

NONAQUIFER  (the site event is not believed to have impacted an identified aquifer);

OIL FIELD  (the site is associated with an oilfield operation)
OTHER (See Case File)  (pertains to a site not categorized - additional information can be found in the case file);

RCRA  (the site pertains to the Resource Conservation and Recovery Act);

SOURCE WATER  (the site event is believed to have impacted a drinking water or surface water source);

UNKNOWN (See Case File)  (the site type either was not known at the time of the report or the case file does not identify the site type); and

WITHDRAWN ATP  (the site was intended to be addressed under the auspices of the Abandoned Tank Program but was withdrawn from consideration before activity commenced).

COLUMN K: gw_spills_proptype 

DENR ENVIRONMENTAL EVENT-  SITE PROPERTY TYPE CATEGORY

The cells in this column identify the property type as reported at the time of the event.

The property types:

AGRICULTURAL  (the property is typically utilized for the raising of crops or livestock);

BIOFACILITY  (the property is utilized for the processing or manufacturing of alternative fuel sources);

COMMERCIAL  (the property is utilized for commercial purposes or is believed to be located within a commercial zone);

INDUSTRIAL  (the property is not a biofacility but pertains to production, manufacturing, and/or processing of substances, or is believed to be located with an industrial zone);

OTHER (See Case File)  (pertains to a property not categorized - additional information can be found in the case file);

PUBLIC  (a government property (municipal, state, or federal) maintained for public use);

RESIDENTIAL  (the property is typically utilized as living quarters for people or is believed to be located within a residential zone ); and

UNKNOWN (See Case File)  (the site type either was not known at the time of the report or the case file does not identify the site type);Other - See case file for information regarding the property type.

COLUMN L: gw_spills_date_rep 

DENR ENVIRONMENTAL EVENT CASE - DATE REPORTED

This cell indicates the date the spill event or site condition was reported to the DENR Spills Team and assigned a case number. This field will be entered as month/day/year (xx/xx/xxxx).

COLUMN M: gw_spills_date_close 

DENR ENVIRONMENTAL EVENT CASE – DATE CLOSED

This cell indicates the date the DENR Ground Water Quality Program determined to cease requiring site activity, as related to the reported spill event or site condition. This field will be entered as month/day/year (xx/xx/xxxx).

COLUMN N: gw_spills_clean_ltr 

DENR ENVIRONMENTAL EVENT CASE - SPILL CLEAN CASE LETTER

(archaic)

This cell indicates the date the DENR Ground Water Quality Program issued a letter indicating the site as clean (in the event the site report did not indicate or otherwise identify a release into the environment). If completed, this field will be entered as month/day/year (xx/xx/xxxx).

COLUMN O: gw_spills_consult 

DENR ENVIRONMENTAL EVENT CASE – CASE CONSULTANT

This cell contains the name of the participating environmental consulting firm, if applicable.

COLUMN P: gw_spills_r1 

DENR ENVIRONMENTAL EVENT CASE – CASE REVIEWER #1

This cell contains the initials of the current (or last) DENR staff assigned as case reviewer.

COLUMN Q: gw_spills_acreage 

DENR ENVIRONMENTAL EVENT -  SITE ACREAGE (estimated)

This cell contains the estimated acreage of the site area, if noted. Primarily for South Dakota Brownfields sites.

COLUMN R: gw_spills_ag_no 

DENR ENVIRONMENTAL EVENT – RELATED SDDA CASE NUMBER

If the event pertains to the transport, use, or storage of an agricultural chemical the South Dakota Department of Agriculture (SDDA) will also initiate an investigation. This cell contains the related case number from the SDDA, if provided.

COLUMN S: gw_spills_instctrls 

DENR ENVIRONMENTAL EVENT – INSTITUTIONAL CONTROLS

This cell will indicate if “institutional controls” have been initiated for the site, if known. Primarily for South Dakota Brownfields sites.

COLUMN T: gw_spills_status 

DENR ENVIRONMENTAL EVENT – CASE STATUS

The cells in this column identify the current case status.

The case status types:

O = OPEN; the site is either being actively remediated or the final decision regarding the site has yet to be determined. The case file remains under the control of the reviewer.

C = CLOSED; the site has been remediated to state standards (some closures will be found that would now be determined for “No Further Action”). A copy of the case file should be available as a pdf image.

I or I2 = INACTIVE; (archaic) the site has not been remediated to state standards but was determined not to threaten known receptors or the health of persons at the time of determining case status (such cases are currently identified as “No Further Action”). A copy of the microfiche should be available as a pdf image.

M = MONITORING; ground water monitoring wells are routinely sampled for analysis. The case file remains under the control of the reviewer.

NFA = NO FURTHER ACTION; the site has not been remediated to state standards but was determined not to threaten known receptors or the health of persons at the time of determining case status. A copy of the case file should be available as a pdf image.

T = TRACKING; the case file was generated for tracking purposes only. No Ground Water Quality Program oversight. Some limited documentation may be available as a pdf image.

COLUMN U: gw_spills_date_spill 

DENR ENVIRONMENTAL EVENT CASE - DATE SPILLED

This cell indicates the date the spill event occurred (as reported to the DENR Spills Team). This field will be entered as month/day/year (xx/xx/xxxx).

COLUMN V: gw_spills_material 

DENR ENVIRONMENTAL EVENT CASE – MATERIAL

This cell identifies the material reported to have been released or found to be contaminating a site at the time of the initial report. Typical entries include: gasoline, diesel, petroleum, waste oil, hydraulic oil, metals, atrazine, etc.

COLUMN W: gw_spills_amount 

DENR ENVIRONMENTAL EVENT CASE – AMOUNT RELEASED/SPILLED

This cell quantifies the amount of material reported to have been released/spilled at the time of the initial report.

COLUMN X: gw_spills_units 

DENR ENVIRONMENTAL EVENT CASE – UNITS

This cell identifies the unit of measurement (as related to the amount released).

COLUMN Y: gw_spills_latitude 

DENR ENVIRONMENTAL EVENT CASE – LATITUDE

Site location information. This cell identifies the angular northerly distance of the event site from the equator and is expressed in decimal degrees, preferably to the 6th decimal place.

COLUMN Z: gw_spills_longitude 

DENR ENVIRONMENTAL EVENT CASE – LONGITUDE

Site location information. This cell identifies the angular westerly distance of the event site from the prime meridian and is expressed in decimal degrees, preferably to the 6th decimal place.

COLUMN AA: gw_spills_secq1 

DENR ENVIRONMENTAL EVENT CASE – FIRST QUARTER SECTION

Site location information. This cell (when annotated) identifies the first quarter section location within the whole section as related to the Graphical Federal and Township and Range System.

COLUMN AB: gw_spills_section 

DENR ENVIRONMENTAL EVENT CASE – SECTION

Site location information. This cell (when annotated) identifies the section number within the range as related to the Graphical Federal and Township and Range System.

COLUMN AC: gw_spills_township 

DENR ENVIRONMENTAL EVENT CASE – TOWNSHIP

Site location information. This cell (when annotated) identifies the township as related to the Graphical Federal and Township and Range System.

COLUMN AD: gw_spills_range 

DENR ENVIRONMENTAL EVENT CASE – RANGE

Site location information. This cell (when annotated) identifies the range number within the township as related to the Graphical Federal and Township and Range System.

COLUMN AE: gw_spills_atp_no 

DENR ENVIRONMENTAL EVENT CASE – ABANDONED TANK PROGRAM NUMBER

This cell identifies the case number assigned by the Abandoned Tank Program (when the environmental event case is also related to the removal of an underground petroleum storage tank in participation with the Governor’s Abandoned Tank Program).

COLUMN AF: gw_spills_tanksyank 

DENR ENVIRONMENTAL EVENT CASE – TANKS REMOVED

This cell identifies the number and size of storage tanks removed (when the environmental case is also related to the removal of an petroleum storage tanks and when the information is provided.)

COLUMN AG: gw_spills_removed 

DENR ENVIRONMENTAL EVENT CASE – DATE TANK(S) REMOVED

This cell indicates the date the tank removal occurred (as reported to the DENR Spills Team). This field will be entered as month/day/year (xx/xx/xxxx).

COLUMN AH: gw_spills_prcfnumber 

DENR ENVIRONMENTAL EVENT CASE – PETROLEUM RELEASE COMPENSATION FUND PROGRAM NUMBER

This cell identifies the case number assigned by the Petroleum Release Compensation Fund Program (when the responsible party of an environmental event case may also file a claim for reimbursement of costs to the Petroleum Release Compensation Fund Program).