SDOT Drawbridge Status by US Government | Demographics and Population Studies

About this Dataset

SDOT Drawbridge Status

SDOT manages several drawbridges/movable bridges in the City. Their status is monitored automatically and recorded in this table. Please note this data is not checked before publishing and may contain errors or omissions. For example, sometimes a bridge must be moved a few times to get it fully settled and that may show in the data as multiple openings/closings, when in reality it was one bridge event. The sensors may fail and a bridge will still open/close and not be recorded in this dataset.
Organization: City of Seattle
Last updated: 2025-01-24T23:20:51.245950
Tags: counts

Tables

Table 1

@usgov.city_of_seattle_sdot_drawbridge_status.table_1

65.98 KB
3392 rows
8 columns


CREATE TABLE table_1 (
  "entity_type" VARCHAR,
  "entity_name" VARCHAR,
  "entity_id" BIGINT,
  "open_date_time" VARCHAR,
  "close_date_time" VARCHAR,
  "minutes_open" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);