About this Dataset

Curb Ramps

Curb ramps provide access to the sidewalk system at street crossings and are usually located at intersections. Curb ramps may also be located mid-block.

Displays curb ramps 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_CURBRAMPS
Organization: City of Seattle
Last updated: 2025-02-28T23:49:44.928766
Tags: common-data-layers, curb-ramps, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_curb_ramps_e4f68.table_1

7.37 MB
45679 rows
55 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "segkey" DOUBLE,
  "sw_unitid" VARCHAR,
  "sw_stside" VARCHAR,
  "sw_compkey" DOUBLE,
  "category" VARCHAR,
  "assessment_date" VARCHAR,
  "condition" VARCHAR,
  "direction" VARCHAR,
  "install_date" VARCHAR,
  "installer" VARCHAR,
  "style" VARCHAR,
  "ramp_width" DOUBLE,
  "verification_date" VARCHAR,
  "mef" VARCHAR,
  "overridecomment" VARCHAR,
  "current_status_date" VARCHAR,
  "compkey" DOUBLE,
  "comptype" DOUBLE,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "int_compkey" DOUBLE,
  "int_unitid" VARCHAR,
  "int_unitdesc" VARCHAR,
  "secondary_sidewalk" VARCHAR,
  "detwarn_exists" VARCHAR,
  "detwarn_color" VARCHAR,
  "detwarn_material" VARCHAR,
  "detwarn_mount_type" VARCHAR,
  "orientation" VARCHAR,
  "asblt" VARCHAR,
  "old_ramp_id" VARCHAR,
  "ada_compliant" VARCHAR,
  "adddttm" VARCHAR,
  "moddttm" VARCHAR,
  "expdate" VARCHAR,
  "num_attachments" DOUBLE,
  "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,
  "globalid" VARCHAR,
  "date_mvw_last_updated" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);