About this Dataset

Texas Commission On Environmental Quality - Aggregate Production Operations

An Aggregate Production Operation (APO) refers to any site where aggregates are being (or have been) removed or extracted from the earth, including the entire area of extraction, stripped areas, haulage ramps, and the land on which plant processing for the raw materials is located. Rock quarries, gravel pits, borrow pits, and other commercial APOs are required to register with TCEQ and undergo recurring inspections. APOs are included with their location, material type, permit number, and other information.
Organization: City of Austin
Last updated: 2023-08-25T22:25:16.714991
Tags: occupational-licensing-registration-division, office-of-waste, olrd, oow

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_2ab26d1a.table_1

211.33 kB
1,009 rows
24 columns

CREATE TABLE table_1 (
  "registration" VARCHAR,
  "registration_status" VARCHAR,
  "customer_number" VARCHAR,
  "customer_name" VARCHAR,
  "regulated_entity" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "site_name" VARCHAR,
  "county" VARCHAR,
  "site_latitude" DOUBLE,
  "site_longitude" DOUBLE,
  "site_address_description" VARCHAR,
  "city" VARCHAR,
  "zip_code" DOUBLE,
  "organization_name" VARCHAR,
  "mailing_address" VARCHAR,
  "registration_start_date" TIMESTAMP,
  "last_application_submitted_date" TIMESTAMP,
  "last_application_type" VARCHAR,
  "last_application_status" VARCHAR,
  "last_application_status_date" TIMESTAMP,
  "current_expiration_date" TIMESTAMP,
  "material_type" VARCHAR,
  "area_disturbed_acres" BIGINT  -- Area Disturbed (Acres),
  "coordinates_decimal_degrees" VARCHAR  -- Coordinates (Decimal Degrees)
);