About this Dataset

City Of Pittsburgh Steps

A listing of all steps and stairways in the City of Pittsburgh
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:32.347816
Tags: _etl, guide-rails, rails, stairs, stairways, steps

Tables

City Of Pittsburgh Steps

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_steps.city_of_pittsburgh_steps

116.34 KB
1134 rows
26 columns


CREATE TABLE city_of_pittsburgh_steps (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "maintenance_responsibility" VARCHAR,
  "installed" TIMESTAMP,
  "material" VARCHAR,
  "length" DOUBLE,
  "number_of_steps" DOUBLE,
  "schools_count" DOUBLE,
  "school_score" DOUBLE,
  "total_population" DOUBLE,
  "transit_rider_count" DOUBLE,
  "transit_score" DOUBLE,
  "detour_score" DOUBLE,
  "overall_score" DOUBLE,
  "image" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "ward" BIGINT,
  "tract" BIGINT,
  "public_works_division" BIGINT,
  "pli_division" BIGINT,
  "police_zone" BIGINT,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

City Of Pittsburgh Steps Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_steps.city_of_pittsburgh_steps_data_dictionary

3.04 KB
17 rows
3 columns


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