About this Dataset

Bicycle Racks

Displays bicycle racks maintained by the Seattle Department of Transportation.

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

Refresh Cycle: Daily

Feature Class: SDOT.V_BIKERACK
Organization: City of Seattle
Last updated: 2025-02-28T23:35:17.051977
Tags: bicycle-racks, common-data-layers, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_bicycle_racks.table_1

453 KB
4007 rows
32 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "distance" DOUBLE,
  "width" DOUBLE,
  "unittype" VARCHAR,
  "bike_facility" VARCHAR,
  "rack_capacity" BIGINT,
  "delineator_posts" VARCHAR,
  "finish_type" VARCHAR,
  "surface_type" VARCHAR,
  "install_date" VARCHAR,
  "mount_type" VARCHAR,
  "color" VARCHAR,
  "manufacturer" VARCHAR,
  "model_type" VARCHAR,
  "side" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);