About this Dataset

Traffic Circles

Displays traffic circles maintained by the Seattle Department of Transportation. Traffic circles are raised islands constructed at intersections of residential streets. Traffic circles provide separation of oncoming vehicles and cause motorists to decrease speed. The layer is limited to non-arterial neighborhood traffic circles and does not include arterial or non-arterial medians or islands.

Views: Link, adds recommended definition query for general use: 'CURRENT_STATUS IN(INSVC, PLNRECON, BLANK)'

Refresh Cycle: Daily

Feature Class: SDOT.V_TRAFCIRCLE
Organization: City of Seattle
Last updated: 2025-02-28T23:40:12.708273
Tags: common-data-layers, sdot, seattle-gis-open-data, traffic-circles, transportation

Tables

Table 1

@usgov.city_of_seattle_traffic_circles_c90ab.table_1

122.82 kB
1,072 rows
32 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "current_status" VARCHAR,
  "ownership" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "comptype" BIGINT,
  "current_status_date" VARCHAR,
  "install_date" VARCHAR,
  "install_purpose" VARCHAR,
  "intkey" BIGINT,
  "landscaping" VARCHAR,
  "maintained_by" VARCHAR,
  "maintenance_agreement" VARCHAR,
  "no_land_reason" VARCHAR,
  "overridecomment" VARCHAR,
  "overrideyn" VARCHAR,
  "ownership_date" VARCHAR,
  "sdot_initiated" VARCHAR,
  "sewer_access_cover" VARCHAR,
  "trcsize" BIGINT,
  "survey_monument" VARCHAR,
  "trcshape" VARCHAR,
  "unittype" VARCHAR,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);