Texas Commission On Environmental Quality - Notices Of Enforcement (NOE)
City of Austin
@usgov.city_of_austin_texas_commission_on_environmental_quali_6ea984f0
City of Austin
@usgov.city_of_austin_texas_commission_on_environmental_quali_6ea984f0
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
);
Anyone who has the link will be able to view this.