About this Dataset

Traffic Counts By Study

This table provides location data and summary statistics of each traffic study. 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 detailed information. Data are binned in 15 minute and 60 minute bins in other tables.
Organization: City of Seattle
Last updated: 2024-12-16T22:35:47.096109
Tags: counts, traffic-counts

Tables

Table 1

@usgov.city_of_seattle_traffic_counts_by_study.table_1

5.58 MB
61,342 rows
31 columns

CREATE TABLE table_1 (
  "study_id" BIGINT,
  "title" VARCHAR,
  "non_standard_location_yn" VARCHAR,
  "nsl_id" DOUBLE,
  "compkey" DOUBLE,
  "unitid" DOUBLE,
  "unitid2" DOUBLE,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "actual_days" DOUBLE,
  "intended_days" BIGINT,
  "study_length" BIGINT,
  "lane_designation_code_id" BIGINT,
  "traffic_flow_dir_id" BIGINT,
  "comments" VARCHAR,
  "counter_id" VARCHAR,
  "counter_type_id" BIGINT,
  "counter_channel" VARCHAR,
  "counter_configuration" VARCHAR,
  "adt" DOUBLE,
  "awdt" DOUBLE,
  "max_eight" DOUBLE,
  "am_pk" DOUBLE,
  "pm_pk" DOUBLE,
  "study_days" BIGINT,
  "study_weekdays" BIGINT,
  "add_dttm" VARCHAR,
  "mod_dttm" VARCHAR,
  "record_timestamp" VARCHAR,
  "location_descr" VARCHAR,
  "dir_from_cross_street" VARCHAR
);