About this Dataset

Traffic Count Studies By Hour Bins

This table provides the traffic studies in hourly bins and some statistics. The SDOT Traffic Counts group runs studies across the city to collect traffic volumes. Most studies are done with pneumatic tubes, but some come from video systems as well. Use the field study_id to match it with other tables for more information.
Organization: City of Seattle
Last updated: 2024-12-16T22:26:55.707132
Tags: counts, traffic-counts

Tables

Table 1

@usgov.city_of_seattle_traffic_count_studies_by_hour_bins.table_1

35.56 MB
429,373 rows
42 columns

CREATE TABLE table_1 (
  "statistic_id" BIGINT,
  "study_id" BIGINT,
  "weekday" BIGINT,
  "holiday_yn" VARCHAR,
  "total" BIGINT,
  "hr01_total" BIGINT,
  "hr02_total" BIGINT,
  "hr03_total" BIGINT,
  "hr04_total" BIGINT,
  "hr05_total" BIGINT,
  "hr06_total" BIGINT,
  "hr07_total" BIGINT,
  "hr08_total" BIGINT,
  "hr09_total" BIGINT,
  "hr10_total" BIGINT,
  "hr11_total" BIGINT,
  "hr12_total" BIGINT,
  "hr13_total" BIGINT,
  "hr14_total" BIGINT,
  "hr15_total" BIGINT,
  "hr16_total" BIGINT,
  "hr17_total" BIGINT,
  "hr18_total" BIGINT,
  "hr19_total" BIGINT,
  "hr20_total" BIGINT,
  "hr21_total" BIGINT,
  "hr22_total" BIGINT,
  "hr23_total" BIGINT,
  "hr24_total" BIGINT,
  "am_pk_vol" BIGINT,
  "am_pk_hour" VARCHAR,
  "am_pk_fac" DOUBLE,
  "am_15_high" VARCHAR,
  "pm_pk_vol" BIGINT,
  "pm_pk_hour" VARCHAR,
  "pm_pk_fac" DOUBLE,
  "pm_15_high" VARCHAR,
  "max_8_vol" BIGINT,
  "max_8_time" VARCHAR,
  "max_8_fac" DOUBLE,
  "add_dttm" VARCHAR,
  "mod_dttm" VARCHAR
);