About this Dataset

Speed Reducer Tracking System (SRTS)

This dataset contains information regarding placements of speed humps and speed cushions within the five boroughs.

Speed humps are traffic calming devices intended to slow traffic speeds on low volume, low speed roads. Speed humps are 3–4 inches high and 14–20 feet wide, with a ramp length of 3–6 feet, depending on target speed. Speed cushions are either speed humps or speed tables that include wheel cutouts to allow large vehicles to pass unaffected, while reducing passenger car speeds. They can be offset to allow unimpeded passage by emergency vehicles and are typically used on key emergency response routes. Speed humps are generally installed on local residential (non-truck route, non-bus route locations), while speed cushions are generally installed on designated truck route locations and bus route locations.

The requests for speed hump/cushion come through Commissioner Correspondences or from other sources and entered manually into the Speed Reducer Tracking System. The Speed Reducer Tracking System then tracks the results of request to determine whether a speed hump/cushion is feasible for installation.
Organization: City of New York
Last updated: 2020-11-10T17:01:37.601044
Tags: bump, cushion, hump, reducer, speed

Tables

Table 1

@usgov.city_of_new_york_speed_reducer_tracking_system_srts.table_1

5.22 MB
56600 rows
43 columns


CREATE TABLE table_1 (
  "projectcode" VARCHAR,
  "groupowner" VARCHAR,
  "locationdescription" VARCHAR,
  "borough" VARCHAR,
  "projectstatus" VARCHAR,
  "nextstep" VARCHAR,
  "dateadded" VARCHAR,
  "bctsnum" VARCHAR,
  "ccunum" VARCHAR,
  "requestorletterreplydate" VARCHAR,
  "cbletterrequestdate" VARCHAR,
  "cbletterrecieveddate" VARCHAR,
  "oldsign" DOUBLE,
  "newsign" VARCHAR,
  "markingsdate" VARCHAR,
  "installationdate" VARCHAR,
  "secondstudycode" VARCHAR,
  "closeddate" VARCHAR,
  "speedcushion" VARCHAR,
  "requestdate" VARCHAR,
  "requestortype" VARCHAR,
  "segmentid" BIGINT,
  "onstreet" VARCHAR,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "geoboroughname" VARCHAR,
  "lionkey" BIGINT,
  "fromlatitude" DOUBLE,
  "fromlongitude" DOUBLE,
  "tolatitude" DOUBLE,
  "tolongitude" DOUBLE,
  "oft" DOUBLE,
  "cb" DOUBLE,
  "segmentstatus" VARCHAR,
  "segmentstatusdescription" VARCHAR,
  "denialreason" VARCHAR,
  "numsrproposed" DOUBLE,
  "trafficdirection" VARCHAR,
  "trafficdirectiondesc" VARCHAR,
  "oldsign1" VARCHAR,
  "newsign1" VARCHAR,
  "oldsign2" VARCHAR,
  "newsign2" VARCHAR
);