About this Dataset

Over Dimensional Vehicle Permits (ODVP)

The Over Dimensional Vehicle Permit (ODVP) is a web application used by trucking companies to apply for Daily Permits for over dimensional vehicles. Main permit record, one row per permit. For Permit Stipulation dataset, please follow this link.
Organization: City of New York
Last updated: 2020-11-10T17:01:52.800006
Tags: freight, permit, truck

Tables

Table 1

@usgov.city_of_new_york_over_dimensional_vehicle_permits_odvp.table_1

37.99 MB
337,402 rows
61 columns

CREATE TABLE table_1 (
  "permitid" BIGINT,
  "fullpermitno" VARCHAR,
  "fullapplicationno" VARCHAR,
  "applicationdate" VARCHAR,
  "issuedate" VARCHAR,
  "permitdate" VARCHAR,
  "permitdateto" VARCHAR,
  "permitallowedfrom" VARCHAR,
  "permitallowedto" VARCHAR,
  "permitservicecompany" VARCHAR,
  "permitteecompany" VARCHAR,
  "truckyear" BIGINT,
  "truckmake" VARCHAR,
  "truckstate" VARCHAR,
  "trailerlicno" VARCHAR,
  "traileryear" DOUBLE,
  "trailermake" VARCHAR,
  "trailerstate" VARCHAR,
  "overallwidth" DOUBLE,
  "overalllength" DOUBLE,
  "overallheight" DOUBLE,
  "trailerlength" DOUBLE,
  "totalgrossweight" BIGINT,
  "descriptionofload" VARCHAR,
  "loadheight" DOUBLE,
  "loadwidth" DOUBLE,
  "loadlength" DOUBLE,
  "loadweight" DOUBLE,
  "startstreetaddress" VARCHAR,
  "startcity" VARCHAR,
  "startstate" VARCHAR,
  "startzipcode" BIGINT,
  "startcountyline" VARCHAR,
  "endstreetaddress" VARCHAR,
  "endcity" VARCHAR,
  "endstate" VARCHAR,
  "endzipcode" BIGINT,
  "endcountyline" VARCHAR,
  "totalnumberofaxle" BIGINT,
  "steeringweight" BIGINT,
  "axle2weight" BIGINT,
  "axle2space" DOUBLE,
  "axle3weight" DOUBLE,
  "axle3space" DOUBLE,
  "axle4weight" DOUBLE,
  "axle4space" DOUBLE,
  "axle5weight" DOUBLE,
  "axle5space" DOUBLE,
  "axle6weight" DOUBLE,
  "axle6space" DOUBLE,
  "axle7weight" DOUBLE,
  "axle7space" DOUBLE,
  "axle8weight" DOUBLE,
  "axle8space" DOUBLE,
  "axle9weight" DOUBLE,
  "axle9space" DOUBLE,
  "axle10weight" DOUBLE,
  "axle10space" DOUBLE,
  "axle11weight" DOUBLE,
  "axle11space" DOUBLE,
  "wheelbase" DOUBLE
);