About this Dataset

Traffic Study Flow Counts

Displays traffic study flow count data maintained by Seattle Department of Transportation.

Users can utilize following definition query for traffic count study data for a particular year.

Note-ENTER YEAR is the particular year of interest.

Definition Query: STDY_YEAR=ENTER YEAR AND FLOWMAP = 'Y'

Refresh: Weekly
Organization: City of Seattle
Last updated: 2025-02-28T23:39:27.277054
Tags: flow-counts, sdot, seattle-gis-open-data, traffic-counts, traffic-study-data

Tables

Table 1

@usgov.city_of_seattle_traffic_study_flow_counts.table_1

7.31 MB
59765 rows
35 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "study_id" BIGINT,
  "title" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "actual_days" BIGINT,
  "intended_days" BIGINT,
  "study_length" BIGINT,
  "study_lane_code" VARCHAR,
  "study_dirflow" VARCHAR,
  "comments" VARCHAR,
  "study_adt" BIGINT,
  "study_awdt" BIGINT,
  "study_max8" BIGINT,
  "study_ampk" BIGINT,
  "study_pmpk" BIGINT,
  "seg_compkey" BIGINT,
  "unitid" BIGINT,
  "unitid2" BIGINT,
  "o_street" VARCHAR,
  "x_street" VARCHAR,
  "dir_from_cross_street" VARCHAR,
  "stdy_title_part" VARCHAR,
  "stdy_label" VARCHAR,
  "distance" DOUBLE,
  "stdy_year" BIGINT,
  "study_type" VARCHAR,
  "flowmap" VARCHAR,
  "hpms" VARCHAR,
  "screenline" VARCHAR,
  "one_hour_report_url" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "stdy_title_part_with_flow" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);