SDOT Intersections by US Government | Transportation and Logistics

About this Dataset

SDOT Intersections

Displays the locations and attributes of SDOT intersections throughout the City. SDOT Intersections are used as reference when viewing nearby assets. Popup includes Street View of intersection.

Refresh Cycle: Daily Refresh
Organization: City of Seattle
Last updated: 2025-02-28T23:50:59.471570
Tags: intersections, sdot, seattle-gis-open-data, street-view, transportation

Tables

Table 1

@usgov.city_of_seattle_sdot_intersections.table_1

1.45 MB
15475 rows
17 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "intr_id" BIGINT,
  "gis_xcoord" DOUBLE,
  "gis_ycoord" DOUBLE,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "unitid" BIGINT,
  "subarea" VARCHAR,
  "unitdesc" VARCHAR,
  "arterialclasscd" DOUBLE,
  "se_anno_cad_data" VARCHAR,
  "signal_maint_dist" VARCHAR,
  "signal_type" VARCHAR,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);