About this Dataset

Texas Commission On Environmental Quality - Supplemental Environmental Projects

This is data represented in the Annual Enforcement Report, pursuant to Texas Water Code Section 5.126, and published each December following the end of the fiscal year.
Supplemental Environmental Projects (SEPs) are environmentally beneficial projects that a respondent agrees to undertake in settlement of an enforcement action. Dollars directed to TCEQ-approved environmental projects may be used to offset assessed penalties in enforcement actions.
Organization: City of Austin
Last updated: 2023-08-25T22:19:28.647514
Tags: annual-enforcement-report, enforcement-division, oce, office-of-compliance-and-enforcement

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_66906351.table_1

137.06 kB
1,472 rows
29 columns

CREATE TABLE table_1 (
  "program" VARCHAR,
  "case_no" BIGINT  -- Case No.,
  "customer_name" VARCHAR,
  "order_date" TIMESTAMP,
  "penalty_assessed" BIGINT,
  "penalty_deferred" BIGINT,
  "payable_amount" BIGINT,
  "sep_costs_total" BIGINT,
  "sep_offset_total" BIGINT,
  "type_1" VARCHAR,
  "sep_project_1" VARCHAR,
  "sep_cost_1" BIGINT,
  "sep_offset_1" BIGINT,
  "type_2" VARCHAR,
  "sep_project_2" VARCHAR,
  "sep_cost_2" DOUBLE,
  "sep_offset_2" DOUBLE,
  "type_3" VARCHAR,
  "sep_project_3" VARCHAR,
  "sep_cost_3" DOUBLE,
  "sep_offset_3" DOUBLE,
  "type_4" VARCHAR,
  "sep_project_4" VARCHAR,
  "sep_cost_4" VARCHAR,
  "sep_offset_4" VARCHAR,
  "type_5" VARCHAR,
  "sep_project_5" VARCHAR,
  "sep_cost_5" VARCHAR,
  "sep_offset_5" VARCHAR
);