About this Dataset

Texas Commission On Environmental Quality - Operating Dry Cleaner Registrations

This dataset contains all operating Dry Cleaner Registrations in Texas that have a current and valid registration.

State law requires dry cleaning facilities and drop stations to register with TCEQ. Dry cleaning facilities and drop stations must renew their registration by August 1st of each year. The Dry Cleaners Registrations reflect self-reported registration information about whether a dry cleaning location is a facility or drop station, and whether they have opted out of the Dry Cleaning Environmental Remediation Fund. Distributors can find out whether to collect solvent fees from each registered facility as well as the registration status and delivery certificate expiration date of a location.
Organization: City of Austin
Last updated: 2024-01-25T10:43:49.961514
Tags: current, dry-cleaner-registration, occupational-licensing-registration-division, office-of-waste, olrd

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_8d4fa256.table_1

196.13 kB
1,458 rows
32 columns

CREATE TABLE table_1 (
  "registration_id" VARCHAR,
  "regulated_entity_number_rn" VARCHAR  -- Regulated Entity Number (RN),
  "regulated_entity_name" VARCHAR,
  "location_name" VARCHAR,
  "location_type" VARCHAR,
  "expiration_date" TIMESTAMP,
  "solvent_fee_status" VARCHAR,
  "location_address" VARCHAR,
  "location_address_line_2" VARCHAR,
  "location_city" VARCHAR,
  "location_state" VARCHAR,
  "location_zip_code" DOUBLE,
  "location_zip_code_extension" DOUBLE,
  "location_county" VARCHAR,
  "tceq_region_for_location" VARCHAR  -- TCEQ Region (for Location),
  "customer_number_cn" VARCHAR  -- Customer Number (CN),
  "customer_name" VARCHAR,
  "account_number" DOUBLE,
  "billing_address" VARCHAR,
  "billing_address_line_2" VARCHAR,
  "billing_state" VARCHAR,
  "billing_zip_code" DOUBLE,
  "billing_zip_code_extension" DOUBLE,
  "phone_area_code" DOUBLE,
  "phone_number" DOUBLE,
  "status_year" VARCHAR,
  "solvent_type" VARCHAR,
  "capacity_gallons" DOUBLE  -- Capacity (Gallons),
  "fund_eligibility" BOOLEAN,
  "gross_receipt_amount" VARCHAR,
  "outlet_number" DOUBLE,
  "location_coordinates_decimal_degrees" VARCHAR  -- Location Coordinates (Decimal Degrees)
);