Public Life Data - People Moving by US Government | Transportation and Logistics

About this Dataset

Public Life Data - People Moving

Provides data on people moving through space, including total number observed, gender breakdown, group size, and age groups.

The City of Seattle Department of Transportation (SDOT) is providing data from the public life studies it has conducted since 2017. These studies consist of measuring the number of people using public space and the types of activities present on select sidewalks across the city, as well as several parks and plazas. The data set is continually updated as SDOT and other parties conduct public life studies using Gehl Institute’s Public Life Data Protocol.

This dataset consists of four component spreadsheets and a GeoJSON file, which provide public life data as well as information about the study design and study locations:

1 Public Life Study: provides details on the different studies that have been conducted, including project information.
https://data.seattle.gov/Transportation/Public-Life-Data-Study/7qru-sdcp

2 Public Life Location: provides details on the sites selected for each study, including various attributes to allow for comparison across sites.
https://data.seattle.gov/Transportation/Public-Life-Data-Locations/fg6z-cn3y

3 Public Life People Moving: provides data on people moving through space, including total number observed, gender breakdown, group size, and age groups.

4 Public Life People Staying: provides data on people staying still in the space, including total number observed, demographic data, group size, postures, and activities.
https://data.seattle.gov/Transportation/Public-Life-Data-People-Staying/5mzj-4rtf

5 Public Life Geography: A GeoJSON file with polygons of every location studied.
https://data.seattle.gov/Transportation/Public-Life-Data-Geography/v4q3-5hvp

Please download and refer to the Public Life metadata document - in the attachment section below - for comprehensive information about all of the Public Life datasets.
Organization: City of Seattle
Last updated: 2024-12-16T22:22:25.656826
Tags: people-moving, public-life, public-space, sdot, sidewalks, streets, transportation

Tables

Table 1

@usgov.city_of_seattle_public_life_data_people_moving_a54a4.table_1

102.67 KB
2378 rows
43 columns


CREATE TABLE table_1 (
  "unique_moving_id" BIGINT,
  "study_id" VARCHAR,
  "location_id" VARCHAR,
  "moving_time_start" VARCHAR,
  "moving_time_end" VARCHAR,
  "moving_day_of_week" VARCHAR,
  "moving_time_of_day" VARCHAR,
  "moving_count_surveyor" VARCHAR,
  "moving_conditions" VARCHAR,
  "moving_microclimate" VARCHAR,
  "moving_temperature" DOUBLE,
  "moving_row_id" BIGINT,
  "moving_row_total" BIGINT,
  "moving_male" DOUBLE,
  "moving_male_mobility_assist" DOUBLE,
  "moving_female" DOUBLE,
  "moving_female_mobility_assist" DOUBLE,
  "moving_other_unsure" DOUBLE,
  "moving_other_unsure_mobility_assist" DOUBLE,
  "moving_total_mobility_assist" DOUBLE,
  "moving_groupsize_1" DOUBLE,
  "moving_groupsize_2" DOUBLE,
  "moving_groupsize_3" DOUBLE,
  "moving_groupsize_4" DOUBLE,
  "moving_groupsize_5" DOUBLE,
  "moving_groupsize_6" DOUBLE,
  "moving_groupsize_7" DOUBLE,
  "moving_groupsize_8" DOUBLE,
  "moving_groupsize_9" DOUBLE,
  "moving_groupsize_10" DOUBLE,
  "moving_0_4" DOUBLE,
  "moving_5_14" DOUBLE,
  "moving_15_24" DOUBLE,
  "moving_25_44" DOUBLE,
  "moving_45_64" DOUBLE,
  "moving_65" DOUBLE,
  "moving_25_64" DOUBLE,
  "moving_pedestrian" DOUBLE,
  "moving_micromobility" DOUBLE,
  "moving_bicycling" DOUBLE,
  "moving_motorized" DOUBLE,
  "moving_supported" DOUBLE,
  "moving_notes" VARCHAR
);