On-road Bicycle Pavement Markings by US Government | Transportation and Logistics

About this Dataset

On-road Bicycle Pavement Markings

A mile by mile breakdown of the on-street bicycle pavement markings installed within the City of Pittsburgh. These include bike lanes, shared lane markings (sharrows), and protected bike lanes.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:10:51.868842
Tags: bicycle, bicycling, bike, bike-lanes, infrastructure, lanes, markings, sharrows, streets, transportation

Tables

Bicycle Pavement Markings June 2016

@usgov.allegheny_county_city_of_pitts_on_road_bicycle_pavemen_a3998458.bicycle_pavement_markings_june_2016

11.41 KB
66 rows
11 columns


CREATE TABLE bicycle_pavement_markings_june_2016 (
  "project_id" BIGINT,
  "year_added" BIGINT,
  "street" VARCHAR,
  "cross_streets" VARCHAR,
  "type" VARCHAR,
  "protected_bike_lane" VARCHAR,
  "street_distance_miles" DOUBLE,
  "bike_lane_distance_miles" DOUBLE,
  "shared_lane_marking_distance_miles" DOUBLE,
  "removed_bike_lane" DOUBLE,
  "removed_sharrow" DOUBLE
);

Data Dictionary

@usgov.allegheny_county_city_of_pitts_on_road_bicycle_pavemen_a3998458.data_dictionary

3.66 KB
11 rows
3 columns


CREATE TABLE data_dictionary (
  "field" VARCHAR,
  "description" VARCHAR,
  "notes" VARCHAR
);