About this Dataset

Occupancy Permits (via DDOT TOPs)

The District Department of Transportation has management and oversight responsibility for the use and occupancy of the public space. This data sets shows occupancy permits from DDOT's Transportation Online Permitting System. https://tops.ddot.dc.gov/
Organization: District of Columbia
Last updated: 2024-04-30T19:04:51.856829
Tags: ddot, district-of-columbia, occupancy, parking, permits, public-space, tops, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_occupancy_permits_via_ddot_tops.table_1

146.62 MB
820,949 rows
88 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "trackingnumber" BIGINT,
  "status" VARCHAR,
  "eventtypedescription" VARCHAR,
  "othereventtype" VARCHAR,
  "constructionpermitnumber" VARCHAR,
  "contractnumber" VARCHAR,
  "constructiontrackingnumber" DOUBLE,
  "permitnumber" VARCHAR,
  "sourcepermit" VARCHAR,
  "applicationdate" TIMESTAMP,
  "issuedate" TIMESTAMP,
  "lastapprovaldate" TIMESTAMP,
  "parkingstarttime" VARCHAR,
  "parkingendtime" VARCHAR,
  "effectivedate" TIMESTAMP,
  "expirationdate" TIMESTAMP,
  "readyforreviewdate" TIMESTAMP,
  "assigneddate" TIMESTAMP,
  "lastupdatedate" TIMESTAMP,
  "ewrnumber" VARCHAR,
  "totalpermitfee" DOUBLE,
  "technologyfee" DOUBLE,
  "inconvenientfee" DOUBLE,
  "worklocationfulladdress" VARCHAR,
  "totaldepositamount" DOUBLE,
  "totalmeterfee" DOUBLE,
  "ownername" VARCHAR,
  "applicantcompany" VARCHAR,
  "permitteename" VARCHAR,
  "curblanelength" DOUBLE,
  "curblanewidth" DOUBLE,
  "sidewalklength" DOUBLE,
  "sidewalkwidth" DOUBLE,
  "alleylength" DOUBLE,
  "alleywidth" DOUBLE,
  "frontyardlength" DOUBLE,
  "frontyardwidth" DOUBLE,
  "scelength" DOUBLE,
  "scewidth" DOUBLE,
  "bikelanelength" DOUBLE,
  "bikelanewidth" DOUBLE,
  "intersectionlength" DOUBLE,
  "intersectionwidth" DOUBLE,
  "travellane1length" DOUBLE,
  "travellane1width" DOUBLE,
  "travellane2length" DOUBLE,
  "travellane2width" DOUBLE,
  "travellane3length" DOUBLE,
  "travellane3width" DOUBLE,
  "travellane4length" DOUBLE,
  "travellane4width" DOUBLE,
  "locationid" BIGINT,
  "fiscalyear" BIGINT,
  "ward" DOUBLE,
  "quadrant" VARCHAR,
  "zipcode" DOUBLE,
  "anc" VARCHAR,
  "smd" VARCHAR,
  "neighborhoodclusters" VARCHAR,
  "neighborhoodnames" VARCHAR,
  "bid" VARCHAR,
  "awi" VARCHAR,
  "edz" VARCHAR,
  "nif" VARCHAR,
  "historicdistrict" VARCHAR,
  "zoning" VARCHAR,
  "pud" VARCHAR,
  "cfar" VARCHAR,
  "psa" DOUBLE,
  "pd" DOUBLE,
  "daystoassign" DOUBLE,
  "daystoapprove" DOUBLE,
  "daystoissue" DOUBLE,
  "statusdescription" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "onsegx" DOUBLE,
  "onsegy" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "streetsegid" DOUBLE,
  "isroadclosed" VARCHAR,
  "iscoveredwalkway" VARCHAR,
  "coveredwalkwaytype" VARCHAR,
  "globalid" VARCHAR
);