About this Dataset

Vehicle Classification Counts (2011-2024)

Vehicle classification counts collected by DOT for New York Metropolitan Transportation Council (NYMTC) to validate the New York Best Practice Model (NYBPM). For NYBPM screenline locations where data has been collected within the last three years are not considered for data collection for the present year. DOT collects data on at least 10% of the total NYBPM screenline locations.
Organization: City of New York
Last updated: 2020-11-10T17:01:27.118412
Tags: traffic-volume-vehicle-classification-counts-screenline-nymtc-lion

Tables

Table 1

@usgov.city_of_new_york_vehicle_classification_counts_2014_2019.table_1

683.34 KB
22034 rows
32 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "segmentid" BIGINT,
  "roadway_name" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR,
  "direction" VARCHAR,
  "date" TIMESTAMP,
  "veh_class_type" VARCHAR,
  "n_12_00_1_00_am" DOUBLE,
  "n_1_00_2_00am" DOUBLE,
  "n_2_00_3_00am" DOUBLE,
  "n_3_00_4_00am" DOUBLE,
  "n_4_00_5_00am" DOUBLE,
  "n_5_00_6_00am" DOUBLE,
  "n_6_00_7_00am" DOUBLE,
  "n_7_00_8_00am" DOUBLE,
  "n_8_00_9_00am" DOUBLE,
  "n_9_00_10_00am" DOUBLE,
  "n_10_00_11_00am" DOUBLE,
  "n_11_00_12_00pm" DOUBLE,
  "n_12_00_1_00pm" DOUBLE,
  "n_1_00_2_00pm" DOUBLE,
  "n_2_00_3_00pm" DOUBLE,
  "n_3_00_4_00pm" DOUBLE,
  "n_4_00_5_00pm" DOUBLE,
  "n_5_00_6_00pm" DOUBLE,
  "n_6_00_7_00pm" DOUBLE,
  "n_7_00_8_00pm" DOUBLE,
  "n_8_00_9_00pm" DOUBLE,
  "n_9_00_10_00pm" DOUBLE,
  "n_10_00_11_00pm" DOUBLE,
  "n_11_00_12_00am" DOUBLE
);