About this Dataset

Texas Commission On Environmental Quality - Petroleum Storage Tank (PST) Delivery Certificates

Delivery certificates issued for Petroleum Storage Tanks (PSTs) which authorize petroleum deliveries. Information including facility numbers, owner information, and expiration dates are available for both registered and self-certified PSTs.
Organization: City of Austin
Last updated: 2023-08-25T23:05:36.224719
Tags: occupational-licensing-registration-division, office-of-waste

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_80ee98ba.table_1

3.36 MB
65,237 rows
27 columns

CREATE TABLE table_1 (
  "pst_facility_id" BIGINT,
  "regulated_entity_number" VARCHAR,
  "delivery_certificate_expiration_date" TIMESTAMP,
  "tank_number" VARCHAR,
  "tank_status" VARCHAR,
  "capacity_gallons" DOUBLE  -- Capacity (Gallons),
  "product_type" VARCHAR,
  "owner_name" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip_code" DOUBLE,
  "facility_zip_extension_4" DOUBLE  -- Facility Zip Extension (+4),
  "facility_county" VARCHAR,
  "facility_coordinates_decimal_degrees" VARCHAR  -- Facility Coordinates (Decimal Degrees),
  "tceq_region" VARCHAR,
  "ust_quantity" BIGINT,
  "customer_number" VARCHAR,
  "owner_mailing_address" VARCHAR,
  "owner_mailing_city" VARCHAR,
  "owner_mailing_state" VARCHAR,
  "owner_mailing_zip_code" DOUBLE,
  "owner_mailing_zip_extension" DOUBLE,
  "ust_regulation_date" VARCHAR,
  "ust_install_date" VARCHAR,
  "status_date" VARCHAR
);