Traffic Circles by US Government | Transportation and Logistics

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

119.94 KB
1072 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
);