About this Dataset

Texas Commission On Environmental Quality - NOR Facilities

Notices of Registration (NOR) Facilities.

This file contains the basic information for a site including the registration number, registration type, company name, mailing address, site location, and other notification information.
Organization: City of Austin
Last updated: 2024-08-25T11:51:24.642430
Tags: facilities, nor, occupational-licensing-registration-division, office-of-waste, oow

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_617b4957.table_1

3.68 MB
41,846 rows
46 columns

CREATE TABLE table_1 (
  "solid_waste_registration_number" VARCHAR,
  "regulated_entity_number" VARCHAR,
  "epa_id_number" VARCHAR,
  "tceq_hazardous_waste_permit_number" DOUBLE,
  "industrial_waste_permit_number" DOUBLE,
  "municipal_waste_permit_number" VARCHAR,
  "facility_site_name" VARCHAR,
  "facility_status" VARCHAR,
  "physical_location_description" VARCHAR,
  "physical_location_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "country" VARCHAR,
  "tceq_region_number" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "primary_naics_code" DOUBLE,
  "land_type" VARCHAR,
  "registration_initial_notification_date" VARCHAR,
  "registration_last_amendment_date" VARCHAR,
  "registration_s_status_change_date" VARCHAR,
  "report_through_steers" BOOLEAN,
  "generator_of_industrial_hazardous_waste" BOOLEAN,
  "generator_type" VARCHAR,
  "hazardous_waste_generator_category" VARCHAR,
  "reverse_distributor_of_hazardous_pharmaceutical_waste" BOOLEAN,
  "reverse_distributor_begin_date" TIMESTAMP,
  "reverse_distributor_end_date" VARCHAR,
  "annual_waste_summary" BOOLEAN,
  "receiver_of_industrial_hazardous_waste" BOOLEAN,
  "receiver_facility_category" VARCHAR,
  "monthly_waste_receipt_summary" BOOLEAN,
  "transporter_of_industrial_hazardous_waste" BOOLEAN,
  "transports_waste_for_hire" BOOLEAN,
  "self_transports_waste" BOOLEAN,
  "transports_industrial_class_1_waste" DOUBLE,
  "transports_hazardous_waste" DOUBLE,
  "transfer_facility" BOOLEAN,
  "healthcare_provider_facility" BOOLEAN,
  "healthcare_opt_in_date" TIMESTAMP,
  "healthcare_withdraw_date" TIMESTAMP,
  "recycler_facility" BOOLEAN,
  "hazardous_waste_permit_status_code" VARCHAR,
  "coordinates_county_centroid" VARCHAR  -- Coordinates (County Centroid)
);