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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/speed-reducer-tracking-system-srts-9n6h-pt9g\".\"speed_reducer_tracking_system_srts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.