Truck Size And Weight Enforcement Data
Department of Transportation
@usgov.dot_gov_truck_size_and_weight_enforcement_data
Department of Transportation
@usgov.dot_gov_truck_size_and_weight_enforcement_data
This dataset consists of truck size and weight enforcement data including number of trucks weighed, number of violations, and number of oversize/overweight permits, as reported by the States in their annual certification to FHWA.
Organization: Department of Transportation
Last updated: 2021-04-12T18:58:36.016268
Tags: citations, os-ow, os-ow-permits, oversize-overweight, truck, truck-size-and-weight, vehicle-size-and-weight, violation, weigh-in-motion, weigh-stations, weight, wim
CREATE TABLE table_1 (
"year" BIGINT,
"state" VARCHAR,
"vehicles_weighed_fixed_platform_scale" DOUBLE -- Vehicles Weighed (Fixed Platform Scale),
"vehicles_weighed_wim_scale" DOUBLE -- Vehicles Weighed (WIM Scale),
"vehicles_weighed_portable_scale" DOUBLE -- Vehicles Weighed (Portable Scale),
"vehicles_weighed_semi_portable_scale" DOUBLE -- Vehicles Weighed (Semi-portable Scale),
"oversize_violation_current_year" DOUBLE,
"overweight_violation_current_year" DOUBLE,
"non_divisible_trip_permits" BIGINT,
"non_divisible_annual_permits" DOUBLE,
"divisible_trip_permits" DOUBLE,
"divisible_annual_permits" DOUBLE
);Anyone who has the link will be able to view this.