About this Dataset

Weigh In Motion

Weigh In Motion (WIM) devices are designed to capture and record the axle weights and gross vehicle weights as trucks drive over sensors at measurement sites. WIM devices are installed on: 1) 2023-present by Atlantic Avenue 2) 2019-2022 by Pearl Street For the data prior to 2024, refer to Weigh in Motion (Historical)
Organization: City of New York
Last updated: 2020-11-20T17:14:21.653908
Tags: axle, gross-vehicle-weight, gvw, overweight, trucks, weigh-in-motion, wim

Tables

Table 1

@usgov.city_of_new_york_weigh_in_motion.table_1

132.82 MB
14,330,834 rows
48 columns

CREATE TABLE table_1 (
  "direction" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour" BIGINT,
  "minute" BIGINT,
  "second" BIGINT,
  "lane" BIGINT,
  "class" BIGINT,
  "speed" DOUBLE,
  "num_axles" BIGINT,
  "gvw" DOUBLE,
  "wheelbase" DOUBLE,
  "wt1" DOUBLE,
  "spc1" DOUBLE,
  "wt2" BIGINT,
  "spc2" DOUBLE,
  "wt3" DOUBLE,
  "spc3" DOUBLE,
  "wt4" DOUBLE,
  "spc4" DOUBLE,
  "wt5" DOUBLE,
  "spc5" DOUBLE,
  "wt6" DOUBLE,
  "spc6" DOUBLE,
  "wt7" DOUBLE,
  "spc7" DOUBLE,
  "wt8" DOUBLE,
  "spc8" DOUBLE,
  "wt9" DOUBLE,
  "spc9" VARCHAR,
  "wt10" VARCHAR,
  "spc10" VARCHAR,
  "wt11" VARCHAR,
  "spc11" VARCHAR,
  "wt12" VARCHAR,
  "spc12" VARCHAR,
  "wt13" VARCHAR,
  "spc13" VARCHAR,
  "wt14" VARCHAR,
  "spc14" VARCHAR,
  "wt15" VARCHAR,
  "spc15" VARCHAR,
  "wt16" VARCHAR,
  "spc16" VARCHAR,
  "wt17" VARCHAR,
  "dirtravel" VARCHAR,
  "yearmonth" BIGINT
);