About this Dataset

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
Organization: State of New York
Last updated: 2020-11-12T03:59:37.651203
Tags: traffic-light, traffic-safety, traffic-signal, traffic-signs

Tables

Table 1

@usgov.state_of_new_york_traffic_control_device_inventory.table_1

457.13 kB
9,434 rows
14 columns

CREATE TABLE table_1 (
  "maintaining_region" VARCHAR,
  "owning_region" VARCHAR,
  "county" VARCHAR,
  "municipality" VARCHAR,
  "device_number" VARCHAR,
  "main_route" VARCHAR,
  "intersecting_route" VARCHAR,
  "location" VARCHAR,
  "device_type" VARCHAR,
  "device_purpose" VARCHAR,
  "device_priority" VARCHAR,
  "maintenance_responsibility" VARCHAR,
  "latitude_utm_y_meters" DOUBLE  -- Latitude (UTM Y [Meters]),
  "longitude_utm_x_meters" DOUBLE  -- Longitude (UTM X [Meters])
);