About this Dataset

Annual Overweight Load (AOL) Permits

The Annual Overweight Load Permits (AOL) is a web application used by trucking companies to apply for Annual Permits for Overweight vehicles. Self-Propelled Cranes and Bulk Milk transport are special categories of overweight vehicles.

For the related Annual Overweight Load (AOL) Permits Stipulations dataset, please refer to https://data.cityofnewyork.us/d/9ibi-dfnm
Organization: City of New York
Last updated: 2020-11-10T17:06:29.646230
Tags: annual-overweight-load, aol, freight, permit, truck

Tables

Table 1

@usgov.city_of_new_york_annual_overweight_load_aol_permits.table_1

349.01 kB
3,673 rows
88 columns

CREATE TABLE table_1 (
  "permitid" BIGINT,
  "permitapplication" VARCHAR,
  "fullpermitno" VARCHAR,
  "fullapplicationno" VARCHAR,
  "applicationdate" VARCHAR,
  "issuedate" VARCHAR,
  "permitfromdate" VARCHAR,
  "permittodate" VARCHAR,
  "applicationtypename" VARCHAR,
  "applicationtypeother" VARCHAR,
  "oldpermitno" VARCHAR,
  "oldexpirationdate" VARCHAR,
  "oldgrossvehicleweight" DOUBLE,
  "permitservicecompany" VARCHAR,
  "permitteecompany" VARCHAR,
  "industrytypename" VARCHAR,
  "industrytypeother" VARCHAR,
  "leasecompanyname" VARCHAR,
  "leaseexpirationdate" DOUBLE,
  "year" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "state" VARCHAR,
  "cdno" VARCHAR,
  "serialno" VARCHAR,
  "manufacturergvwr" DOUBLE,
  "registeredgvwr" DOUBLE,
  "vehicletype" VARCHAR,
  "vehicletypeother" VARCHAR,
  "permittype" VARCHAR,
  "overallwidth" DOUBLE,
  "overalllength" DOUBLE,
  "overallheight" DOUBLE,
  "totalnoofaxle" DOUBLE,
  "wheelbase" DOUBLE,
  "loadindescription" VARCHAR,
  "loadinwidth" DOUBLE,
  "loadinheight" DOUBLE,
  "loadinlength" DOUBLE,
  "loadinweight" DOUBLE,
  "loadoutdescription" VARCHAR,
  "loadoutwidth" DOUBLE,
  "loadoutheight" DOUBLE,
  "loadoutlength" DOUBLE,
  "loadoutweight" DOUBLE,
  "steeringweight" DOUBLE,
  "steeringnooftires" DOUBLE,
  "steeringloadrating" DOUBLE,
  "axle2weight" DOUBLE,
  "axle2space" DOUBLE,
  "axle2nooftires" DOUBLE,
  "axle2loadrating" DOUBLE,
  "axle3weight" DOUBLE,
  "axle3space" DOUBLE,
  "axle3nooftires" DOUBLE,
  "axle3loadrating" DOUBLE,
  "axle4weight" DOUBLE,
  "axle4space" DOUBLE,
  "axle4nooftires" DOUBLE,
  "axle4loadrating" DOUBLE,
  "axle5weight" DOUBLE,
  "axle5space" DOUBLE,
  "axle5nooftires" DOUBLE,
  "axle5loadrating" DOUBLE,
  "axle6weight" DOUBLE,
  "axle6space" DOUBLE,
  "axle6nooftires" DOUBLE,
  "axle6loadrating" DOUBLE,
  "axle7weight" DOUBLE,
  "axle7space" DOUBLE,
  "axle7nooftires" VARCHAR,
  "axle7loadrating" VARCHAR,
  "axle8weight" VARCHAR,
  "axle8space" VARCHAR,
  "axle8nooftires" VARCHAR,
  "axle8loadrating" VARCHAR,
  "axle9weight" VARCHAR,
  "axle9space" VARCHAR,
  "axle9nooftires" VARCHAR,
  "axle9loadrating" VARCHAR,
  "axle10weight" VARCHAR,
  "axle10space" VARCHAR,
  "axle10nooftires" VARCHAR,
  "axle10loadrating" VARCHAR,
  "axle11weight" VARCHAR,
  "axle11space" VARCHAR,
  "axle11nooftires" VARCHAR,
  "axle11loadrating" VARCHAR
);