City Of Pittsburgh Intersection Markings by US Government | Transportation and Logistics

About this Dataset

City Of Pittsburgh Intersection Markings

Intersection markings including crosswalk and stop line locations and information.

NOTE: The data in this dataset has not updated since 2021 (or 2018, in the case of the crosswalks data) 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:58.224715
Tags: _etl, crossings, crosswalks, intersection, markings, pedestrians, transportation, travel

Tables

City Of Pittsburgh Markings Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_inte_32402abf.city_of_pittsburgh_markings_data_dictionary

2.96 KB
14 rows
3 columns


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

City Of Pittsburgh Crosswalks

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_inte_32402abf.city_of_pittsburgh_crosswalks

197.32 KB
4648 rows
15 columns


CREATE TABLE city_of_pittsburgh_crosswalks (
  "n__id" BIGINT,
  "id" BIGINT,
  "type" VARCHAR,
  "street" 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
);