About this Dataset

City Of Pittsburgh Speed Humps

Speed humps installed by the City of Pittsburgh to slow down traffic

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:06:10.904103
Tags: _etl, right-of-way, speed-bumps, speed-humps, streets, traffic, transportation

Tables

Speed Humps

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_speed_humps.speed_humps

17.28 kB
79 rows
17 columns

CREATE TABLE speed_humps (
  "n__id" BIGINT  -- Id,
  "id" BIGINT,
  "hump_id" BIGINT,
  "locator_address_number" DOUBLE,
  "locator_street" VARCHAR,
  "pavement" BIGINT,
  "speed_hump_material" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" BIGINT,
  "ward" BIGINT,
  "tract" BIGINT,
  "public_works_division" BIGINT,
  "pli_division" BIGINT,
  "police_zone" BIGINT,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);