About this Dataset

Speed Humps

Speed humps which are in street paved mounds used in low volume arterial streets and on non-arterial streets that have been designated as emergency fire routes. The purpose of these assets is to slow down cars, which improves safety and encourages the use of other modes of transportation. Spacing is designed to allow wider-axle emergency vehicles to pass through without slowing down.

Displays speed humps maintained by the Seattle Department of Transportation.

Views: Link, adds recommended definition query for general use: 'CURRENT_STATUS =INSVC'

Refresh Cycle: Daily

Feature Class: SDOT.V_SpeedHump
Organization: City of Seattle
Last updated: 2025-02-28T23:28:14.670240
Tags: common-data-layers, sdot, seattle-gis-open-data, speed-humps, transportation

Tables

Table 1

@usgov.city_of_seattle_speed_humps.table_1

55.46 kB
137 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,
  "asset_height" BIGINT,
  "asset_width" BIGINT,
  "install_date" VARCHAR,
  "asblt" VARCHAR,
  "maintained_by" VARCHAR,
  "maintenance_financial_resp" VARCHAR,
  "maintenance_agreement" VARCHAR,
  "comments" VARCHAR,
  "dirfromxst" VARCHAR,
  "disttohigh" BIGINT,
  "disttolow" BIGINT,
  "side" VARCHAR,
  "onstreet" VARCHAR,
  "xstrhigh" VARCHAR,
  "xstrlow" VARCHAR,
  "meas_from_high" VARCHAR,
  "meas_from_low" VARCHAR,
  "measurement_origin" VARCHAR,
  "log_comment_1" VARCHAR,
  "log_comment_2" VARCHAR,
  "log_comment_3" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" 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,
  "num_attachments" BIGINT,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "last_verify_date" VARCHAR,
  "ownership" VARCHAR,
  "ownership_date" VARCHAR,
  "adddttm" VARCHAR,
  "moddttm" VARCHAR,
  "date_mvw_last_updated" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);