About this Dataset

Texas Commission On Environmental Quality - Leaking Petroleum Storage Tank (LPST) Sites

List of Leaking Petroleum Storage Tank sites in Texas with associated PST Registration ID number(s), location information, the date each site was reported to the TCEQ, and the closure date (if closed).
Organization: City of Austin
Last updated: 2023-08-25T22:55:44.939427
Tags: office-of-waste, remediation-division

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_efa3a8e1.table_1

2.16 MB
29,633 rows
12 columns

CREATE TABLE table_1 (
  "lpst_id" BIGINT,
  "regulated_entity_number" VARCHAR,
  "pst_registration_id" VARCHAR,
  "site_name" VARCHAR,
  "site_address" VARCHAR,
  "site_location_description" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "zip_code" DOUBLE,
  "reported_date" TIMESTAMP,
  "closure_date" TIMESTAMP,
  "tceq_region" VARCHAR
);