Waste Recovery Locations by US Government | Environmental and Climate Sciences

About this Dataset

Waste Recovery Locations

Locations where City residents are encouraged to drop off and dispose or recycle of unwanted materials. Information provided is subject to change. Please call ahead to confirm hours and that your specific item is still currently accepted. Non-City owned/operated locations listed are not an endorsement by the City of Pittsburgh.

NOTE: The data in this dataset has not updated since 2021 because of a broken data feed. We're working to fix it.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:51.519759
Tags: _etl, dispose, garbage, recycling, trash, waste

Tables

Waste Recovery Locations

@usgov.allegheny_county_city_of_pitts_waste_recovery_locations.waste_recovery_locations

38.58 KB
49 rows
46 columns


CREATE TABLE waste_recovery_locations (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "address_number" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "hours_of_operation" VARCHAR,
  "notes" VARCHAR,
  "phone_number" VARCHAR,
  "website" VARCHAR,
  "managed_by_city" VARCHAR,
  "accepts_alkaline_batteries" VARCHAR,
  "accepts_automotive_batteries" VARCHAR,
  "accepts_cfl_lightbulbs" VARCHAR,
  "accepts_clothing" VARCHAR,
  "accepts_collectibles" VARCHAR,
  "accepts_computers_and_peripherals" VARCHAR,
  "accepts_construction_and_demolition_waste" VARCHAR,
  "accepts_fluorescent_tube_lightbulbs" VARCHAR,
  "accepts_freon_appliances" VARCHAR,
  "accepts_household_chemicals_and_waste" VARCHAR,
  "accepts_household_recyclables" VARCHAR,
  "accepts_plastic_bags_and_films" VARCHAR,
  "accepts_prescription_medication" VARCHAR,
  "accepts_propane_tanks" VARCHAR,
  "accepts_rechargeable_batteries" VARCHAR,
  "accepts_scrap_metal" VARCHAR,
  "accepts_small_business_recyclables" VARCHAR,
  "accepts_tires" VARCHAR,
  "accepts_tvs_and_monitors" VARCHAR,
  "accepts_yard_debris" VARCHAR,
  "accepts_cell_phones" VARCHAR,
  "accepts_general_electronics" VARCHAR,
  "accepts_ink_and_toner" VARCHAR,
  "accepts_motor_oil" VARCHAR,
  "inactive" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "tract" BIGINT,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Waste Recovery Locations Data Dictionary

@usgov.allegheny_county_city_of_pitts_waste_recovery_locations.waste_recovery_locations_data_dictionary

3.73 KB
45 rows
3 columns


CREATE TABLE waste_recovery_locations_data_dictionary (
  "n__id" BIGINT,
  "id" VARCHAR,
  "type" VARCHAR
);