Traffic Control Device Inventory

The New York State Department of Transportation (NYSDOT) traffic control devices data set is a list of all of the traffic devices that are either owned or maintained by NYSDOT. The devices included are of various types such as traffic signals, street lights, beacons, flashers, navigational lights, Intelligent Transportation Systems (ITS), etc. Devices in the 5 boroughs of New York City are not owned or maintained by NYSDOT and therefore not represented in this dataset

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 \"ny-gov/traffic-control-device-inventory-8fht-3ajj\".\"traffic_control_device_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.