About this Dataset

Bridges

Displays bridges maintained by the Seattle Department of Transportation.

Views: Link, which adds the recommended filter for general use of the dataset: 'STATUS IN(INSVC, REMSCHD) OR STATUS is empty string'

Refresh Cycle: Daily

Feature Class: SDOT.V_BRIDGE
Organization: City of Seattle
Last updated: 2025-02-28T23:28:34.871991
Tags: bridges, common-data-layers, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_bridges_62756.table_1

94.53 kB
430 rows
40 columns

CREATE TABLE table_1 (
  "objectid" VARCHAR,
  "comptype" VARCHAR,
  "compkey" DOUBLE,
  "hansegkey" VARCHAR,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "brgunitid" VARCHAR,
  "unitdesc_brg" VARCHAR,
  "unitdesc_seg" VARCHAR,
  "instdate" VARCHAR,
  "expdate" VARCHAR,
  "status" VARCHAR,
  "statusdt" VARCHAR,
  "condition" VARCHAR,
  "conddt" VARCHAR,
  "own" VARCHAR,
  "lstverify" VARCHAR,
  "maintby" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "adddttm" VARCHAR,
  "moddttm" VARCHAR,
  "br_nbr" DOUBLE,
  "br_code" VARCHAR,
  "br_type" VARCHAR,
  "br_name" VARCHAR,
  "br_facilities" VARCHAR,
  "br_features" VARCHAR,
  "br_rating" DOUBLE,
  "br_inset" VARCHAR,
  "br_geo" VARCHAR,
  "br_owner" VARCHAR,
  "br_owner_name" VARCHAR,
  "geobasid" DOUBLE,
  "xgeobasid" DOUBLE,
  "gissegkey" DOUBLE,
  "earthquake_response_team" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);