Traffic Signal Assemblies by US Government | Transportation and Logistics

About this Dataset

Traffic Signal Assemblies

A traffic signal controls the movement of vehicles, pedestrians and bicyclists, minimizes conflicts, and optimizes the flow of traffic throughout the street network. This dataset is also referenced as Accessible Pedestrian Signals.

Displays traffic signal assemblies maintained by the Seattle Department of Transportation.

Views: Link, adds recommended definition query for general use: 'CURRENT_STATUS IN(INSVC, PLNRECON) OR CURRENT_STATUS is empty string'

Refresh Cycle: Daily

Feature Class: SDOT.V_SIGNALS
Organization: City of Seattle
Last updated: 2025-02-28T23:39:49.255361
Tags: common-data-layers, sdot, seattle-gis-open-data, traffic-signal-assemblies, transportation

Tables

Table 1

@usgov.city_of_seattle_traffic_signal_assemblies.table_1

304.88 KB
1250 rows
97 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc" VARCHAR,
  "moddttm" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "comptype" BIGINT,
  "description" VARCHAR,
  "segkey" BIGINT,
  "intkey" BIGINT,
  "int_unitid" VARCHAR,
  "signal_type" VARCHAR,
  "signal_maint_dist" VARCHAR,
  "install_date" VARCHAR,
  "addby" VARCHAR,
  "adddttm" VARCHAR,
  "ownership" VARCHAR,
  "current_status_date" VARCHAR,
  "arterial_class" DOUBLE,
  "maint_agree" VARCHAR,
  "maint_by" VARCHAR,
  "int_signal_type_cd" VARCHAR,
  "overridecomment" VARCHAR,
  "pedaudiodeviceyn" VARCHAR,
  "pedsignalyn" VARCHAR,
  "ph_modeltype" VARCHAR,
  "pp_modeltype" VARCHAR,
  "pp_quantity" VARCHAR,
  "pedhdfirstinstalldt" VARCHAR,
  "ph_quantity" VARCHAR,
  "pedaudioinstalldt" VARCHAR,
  "bikesignalhdyn" VARCHAR,
  "asblt" VARCHAR,
  "halfsignalyn" VARCHAR,
  "meteredyn" VARCHAR,
  "ltturnsignalyn" VARCHAR,
  "ltprotectedpermyn" VARCHAR,
  "ltprotectedyn" VARCHAR,
  "rtturnsignalyn" VARCHAR,
  "rtprotectedpermyn" VARCHAR,
  "rtprotectedyn" VARCHAR,
  "ltfirstinstalldt" VARCHAR,
  "ltremovedt" VARCHAR,
  "rtfirstinstalldt" VARCHAR,
  "rtremovedt" VARCHAR,
  "detdevstopbaryn" VARCHAR,
  "detdevadvancedyn" VARCHAR,
  "detdevsystemyn" VARCHAR,
  "cabmodeltypecd" VARCHAR,
  "comconntypecd" VARCHAR,
  "syscontroltypecd" VARCHAR,
  "mmumodeltypecd" VARCHAR,
  "pe_modeltype" VARCHAR,
  "pi_modeltype" VARCHAR,
  "installercd" VARCHAR,
  "sigassservicept" VARCHAR,
  "jointownershipyn" VARCHAR,
  "vh_quantity" VARCHAR,
  "vh_modeltype" VARCHAR,
  "louveredvisoryn" VARCHAR,
  "optpgmedhdsyn" VARCHAR,
  "cablastpmdt" VARCHAR,
  "detmoduletypecd" VARCHAR,
  "ccimodeltypecd" VARCHAR,
  "ethernetsftwrrevlvl" VARCHAR,
  "ccisftwrrevlvl" VARCHAR,
  "mmuserialnbr" VARCHAR,
  "co_softwrrev" VARCHAR,
  "co_installdt" VARCHAR,
  "co_removaldt" VARCHAR,
  "co_serialnbr" VARCHAR,
  "co_modeltype" VARCHAR,
  "mmumancd" VARCHAR,
  "mmuinstalldt" VARCHAR,
  "volts" BIGINT,
  "amps" BIGINT,
  "groundresistance" BIGINT,
  "multiintersectionsyn" VARCHAR,
  "addtlintdesc" VARCHAR,
  "lastsignaloptdt" VARCHAR,
  "lampinggroupcd" VARCHAR,
  "attachment_1" VARCHAR,
  "attachment_2" VARCHAR,
  "attachment_3" VARCHAR,
  "attachment_4" VARCHAR,
  "attachment_5" VARCHAR,
  "attachment_6" VARCHAR,
  "attachment_7" VARCHAR,
  "attachment_8" VARCHAR,
  "attachment_9" VARCHAR,
  "pedpshinstalldt" VARCHAR,
  "num_attachments" BIGINT
);