About this Dataset

Envision Downtown: Public Space Public Life Survey

Pedestrian and Bicycle counts, Stationary Activity Counts, and Age and Gender counts for 16 locations in Downtown Pittsburgh. Data was collected over a weekday (7am - 8pm) and weekend day (7am - 8pm).
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:10:43.790051
Tags: age, bicycle-counts, bike-count, downtown, gender, ped-counts, pedestrian-counts, pspl, public-life, public-space, stationary-activity

Tables

Fall 2016 Age & Gender Counts

@usgov.allegheny_county_city_of_pitts_envision_downtown_publi_5da01fb6.fall_2016_age_gender_counts

15.21 kB
84 rows
20 columns

CREATE TABLE fall_2016_age_gender_counts (
  "city" VARCHAR,
  "street_plaza" VARCHAR,
  "counting_location" BIGINT,
  "sub_location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "day_of_week" VARCHAR,
  "season" VARCHAR,
  "yyyy_mm_dd" VARCHAR,
  "time_0_23" BIGINT  -- Time (0-23),
  "n_00_06_mw" VARCHAR  -- 00-06 MW,
  "n_07_14_mw" VARCHAR  -- 07-14 MW,
  "n_15_19_m" VARCHAR  -- 15-19 M,
  "n_15_19_w" VARCHAR  -- 15-19 W,
  "n_20_30_m" VARCHAR  -- 20-30 M,
  "n_20_30_w" VARCHAR  -- 20-30 W,
  "n_31_64_m" VARCHAR  -- 31-64 M,
  "n_31_64_w" VARCHAR  -- 31-64 W,
  "n_65_m" VARCHAR  -- 65+ M,
  "n_65_w" VARCHAR  -- 65+ W
);

Fall 2016 Stationary Activity Counts

@usgov.allegheny_county_city_of_pitts_envision_downtown_publi_5da01fb6.fall_2016_stationary_activity_counts

20.09 kB
308 rows
24 columns

CREATE TABLE fall_2016_stationary_activity_counts (
  "city" VARCHAR,
  "street_or_plaza" VARCHAR,
  "counting_location" BIGINT,
  "sub_location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "day_of_week" VARCHAR,
  "season" VARCHAR,
  "yyyy_mm_dd" VARCHAR,
  "area_sq_meters" BIGINT,
  "time_0_23" BIGINT  -- Time (0-23),
  "standing" VARCHAR,
  "waiting_transport" VARCHAR,
  "bench_seating" VARCHAR,
  "secondary_seating" VARCHAR,
  "cafe_seating" VARCHAR,
  "bring_your_own_seating" VARCHAR,
  "lying_down" VARCHAR,
  "children_playing" VARCHAR,
  "commercial_activity" VARCHAR,
  "cultural_activity" VARCHAR,
  "physical_activity" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "notes_optional" VARCHAR  -- Notes (optional)
);