Baselight

Texas Commission On Environmental Quality - Notices Of Enforcement (NOE)

City of Austin

@usgov.city_of_austin_texas_commission_on_environmental_quali_6ea984f0

Loading...
Loading...

About this Dataset

Texas Commission On Environmental Quality - Notices Of Enforcement (NOE)

Investigations resulting in a Notice of Enforcement (NOE) and the details associated with each violation. An investigation may be listed more than once if there were multiple violations associated to that investigation. Multiple violations may be due to identified noncompliance with different regulatory requirements (citations).
Organization: City of Austin
Last updated: 2023-08-25T23:27:27.336442
Tags: enforcement, investigations, oce, orders, program-support-environmental-assistance-division, violations

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_6ea984f0.table_1
  • 2.99 MB
  • 25618 rows
  • 26 columns
Loading...

CREATE TABLE table_1 (
  "regulated_entity_number" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "business_type" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip_code" DOUBLE,
  "physical_location" VARCHAR,
  "physical_city" VARCHAR,
  "physical_county" VARCHAR,
  "physical_zip_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "investigation_number" VARCHAR,
  "noe_date" VARCHAR,
  "tceq_docket_number_s_creation_dates" VARCHAR,
  "tceq_region_name" VARCHAR,
  "total_violation_count" BIGINT,
  "mailing_zip_code_extension" DOUBLE,
  "notice_of_enforcement_id" DOUBLE,
  "cat_a_violation_tracking_numbers" VARCHAR,
  "cat_a_violation_citations" VARCHAR,
  "cat_b_violation_tracking_numbers" VARCHAR,
  "cat_b_violation_citations" VARCHAR,
  "cat_c_violation_tracking_numbers" VARCHAR,
  "cat_c_violation_citations" VARCHAR
);

Share link

Anyone who has the link will be able to view this.