Construction Permits (via DDOT TOPs) by US Government | Transportation and Logistics

About this Dataset

Construction Permits (via DDOT TOPs)

The dataset contains locations and attributes of above ground permits applied for and approved by the District Department of Transportation. They are newly occupied constructions and events. Examples include: moving truck, roll off debris container, moving storage container, construction staging area, mobile crane work zone, other reserved parking. The public space permit process is described on the DDOT website https://ddot.dc.gov.

These data are shared via an automated process where addresses are batch matched (geocoded) to the District's Master Address Repository. Users may find that some data points will contain 0,0 for X,Y coordinates resulting in inconsistent spatial locations. Addresses for these data points could not be automatically geocoded and will need to be manually geocoded to 'best fit' locations in DC. Use the MAR Geocoder to help complete this.
Organization: District of Columbia
Last updated: 2024-04-30T18:45:06.119194
Tags: cdw, construction, ddot, district-of-columbia, feeds, permit, public-space-permit, tops, transportation-online-permitting, washington-dc

Tables

Table 1

@usgov.district_of_columbia_construction_permits_via_ddot_tops.table_1

82.06 MB
380598 rows
75 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "trackingnumber" BIGINT,
  "permitnumber" VARCHAR,
  "intakedate" TIMESTAMP,
  "assigneddate" TIMESTAMP,
  "lastupdatedate" TIMESTAMP,
  "status" BIGINT,
  "applicationdate" TIMESTAMP,
  "lastapprovaldate" TIMESTAMP,
  "issuedate" TIMESTAMP,
  "effectivedate" TIMESTAMP,
  "expirationdate" TIMESTAMP,
  "sourcepermit" VARCHAR,
  "permittype" DOUBLE,
  "ewrnumber" VARCHAR,
  "worklocationfulladdress" VARCHAR,
  "totalfee" DOUBLE,
  "permitfee" DOUBLE,
  "technologyfee" DOUBLE,
  "inspectionnumber" VARCHAR,
  "inspectionamount" DOUBLE,
  "meteramount" DOUBLE,
  "wetutilitydepositamount" DOUBLE,
  "typedetailnames" VARCHAR,
  "isexcavation" BIGINT,
  "isfixture" BIGINT,
  "ispaving" BIGINT,
  "isoccupancy" BIGINT,
  "islandscaping" BIGINT,
  "isprojections" BIGINT,
  "ispsrental" BIGINT,
  "isoverheadwork" BIGINT,
  "isannualpermit" BIGINT,
  "ownername" VARCHAR,
  "applicantcompany" VARCHAR,
  "permitteename" VARCHAR,
  "contractorname" VARCHAR,
  "readyforreviewdate" TIMESTAMP,
  "fiscalyear" DOUBLE,
  "ward" DOUBLE,
  "quadrant" VARCHAR,
  "zipcode" VARCHAR,
  "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,
  "cpb" VARCHAR,
  "daystoassign" DOUBLE,
  "daystoapprove" DOUBLE,
  "daystoissue" DOUBLE,
  "workdetail" VARCHAR,
  "statusdescription" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "onsegx" DOUBLE,
  "onsegy" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "worklocationaddressid" BIGINT,
  "globalid" VARCHAR,
  "smallcellstreetlightid" VARCHAR,
  "cellinstallationstatus" VARCHAR,
  "cellinstallationdate" TIMESTAMP
);