About this Dataset

Existing Bike Facilities

Bicycle related street and off-street improvements which consist of markings and hardscape that are intended to improve the movement of bicycles through the city. Existing facilities include all infrastructure currently on the ground with the following categories: protected bike lanes, buffered bike lanes, painted bike lanes, climbing lanes, neighborhood greenways, miscellaneous off-street facilities, and shared roadway markings (sharrows). Planned facilities are taken from the current Seattle Bicycle Master Plan and are subject to change as projects within the city are evaluated for their feasibility.

Refresh Cycle: Daily Refresh

Feature Class (Multi-use Trails): TRANSPO.SNDSEG_PV

Feature Class (Existing and Planned Bike Facilities): SDOT.V_BikeFacilities
Organization: City of Seattle
Last updated: 2025-02-28T23:41:32.659683
Tags: bike, bike-facilities, bike-lanes, bike-master-plan, sdot, seattle-gis-open-data, trails, transportation

Tables

Table 1

@usgov.city_of_seattle_existing_bike_facilities_46a5a.table_1

275.67 kB
3,591 rows
57 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "category" VARCHAR,
  "material" VARCHAR,
  "style" VARCHAR,
  "model_type" VARCHAR,
  "asset_width" DOUBLE,
  "asset_height" BIGINT,
  "install_date" VARCHAR,
  "asblt" 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,
  "attachment_10" VARCHAR,
  "num_attachments" BIGINT,
  "comments" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "last_asset_verification_date" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "ownership" VARCHAR,
  "ownership_date" VARCHAR,
  "maintained_by" VARCHAR,
  "maintenance_agreement" VARCHAR,
  "maintenance_financial_resp" VARCHAR,
  "addby" VARCHAR,
  "adddttm" VARCHAR,
  "modby" VARCHAR,
  "moddttm" VARCHAR,
  "date_mvw_last_updated" VARCHAR,
  "color" VARCHAR,
  "mount_type" VARCHAR,
  "mount_material" VARCHAR,
  "expby" VARCHAR,
  "expdate" VARCHAR,
  "maint_grp_paint" VARCHAR,
  "maint_grp_plants" VARCHAR,
  "maint_grp_post" VARCHAR,
  "maint_grp_snow" VARCHAR,
  "maint_grp_sweep" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);