About this Dataset

Marked Crosswalks

Displays marked crosswalks maintained by the Seattle Department of Transportation.

View Layer: 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_CROSSWALKS
Organization: City of Seattle
Last updated: 2025-02-28T23:25:20.549990
Tags: common-data-layers, marked-crosswalks, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_marked_crosswalks_ba796.table_1

871.61 KB
6381 rows
62 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "distance" DOUBLE,
  "width" BIGINT,
  "unittype" VARCHAR,
  "old_id" VARCHAR,
  "approach" VARCHAR,
  "marking_type" VARCHAR,
  "school" VARCHAR,
  "midblock_crosswalk" VARCHAR,
  "install_date" VARCHAR,
  "color" VARCHAR,
  "comments" VARCHAR,
  "category" VARCHAR,
  "ownership_date" VARCHAR,
  "current_status_date" VARCHAR,
  "maintained_by" VARCHAR,
  "maintenance_agreement" VARCHAR,
  "curbspaceid" VARCHAR,
  "city_sector" VARCHAR,
  "nbrhood_district" VARCHAR,
  "maint_district" VARCHAR,
  "overridecomment" VARCHAR,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "crosswalk_control" VARCHAR,
  "material" VARCHAR,
  "onstreet" VARCHAR,
  "xstrlow" VARCHAR,
  "meas_from_low" VARCHAR,
  "disttolow" BIGINT,
  "stpoint" BIGINT,
  "xstrhi" VARCHAR,
  "meas_from_hi" VARCHAR,
  "disttohi" BIGINT,
  "offset" BIGINT,
  "side" VARCHAR,
  "measurement_origin" 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,
  "maintenance_group" VARCHAR,
  "num_attachments" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);