Dataset: Weigh In Motion

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

126.67 MB
14330834 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
);