About this Dataset

Beacon Assemblies

A beacon is a warning device to draw a vehicle operator’s attention to an associated message that is important to the safe operation of the vehicle on a specific stretch of roadway.

Displays beacon assemblies maintained by the Seattle Department of Transportation.

Views: Link, which adds the recommended filter for general use of the dataset: 'CURRENT_STATUS includes(INSVC, PLNRECON) OR CURRENT_STATUS is empty string'

Refresh Cycle:

Feature Class: SDOT.V_BEACON
Organization: City of Seattle
Last updated: 2025-02-28T23:19:40.131821
Tags: beacon-assemblies, common-data-layers, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_beacon_assemblies.table_1

95.42 KB
552 rows
45 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "distance" DOUBLE,
  "width" DOUBLE,
  "unittype" VARCHAR,
  "current_status_date" VARCHAR,
  "category" VARCHAR,
  "install_date" VARCHAR,
  "installer" VARCHAR,
  "electr_wire_loc" VARCHAR,
  "control_protocol_type" VARCHAR,
  "metered" VARCHAR,
  "last_pm_date" VARCHAR,
  "solar_install_date" VARCHAR,
  "hansen7id" VARCHAR,
  "disphousingcond" VARCHAR,
  "mount_type" VARCHAR,
  "crosswalk_tub" VARCHAR,
  "flashing" VARCHAR,
  "attachment_condition" VARCHAR,
  "pole_condition" VARCHAR,
  "support_install_date" VARCHAR,
  "span_condition" VARCHAR,
  "control_condition" VARCHAR,
  "control_type" VARCHAR,
  "modem_type" VARCHAR,
  "model_type" VARCHAR,
  "side" VARCHAR,
  "school_speed_camera" VARCHAR,
  "overridecomment" VARCHAR,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);