Annual Public Space Rental Permits by US Government | Transportation and Logistics

About this Dataset

Annual Public Space Rental Permits

Annual Public Space Rental Permits
Organization: District of Columbia
Last updated: 2024-04-30T17:26:33.294705
Tags: ddot, district-of-columbia, livedataset, permits, public-space, rental, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_annual_public_space_rental_permits.table_1

527.5 KB
3180 rows
59 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "trackingnumber" BIGINT,
  "status" VARCHAR,
  "eventtypedescription" VARCHAR,
  "constructionpermitnumber" VARCHAR,
  "contractnumber" VARCHAR,
  "constructiontrackingnumber" DOUBLE,
  "permitnumber" VARCHAR,
  "sourcepermit" VARCHAR,
  "applicationdate" TIMESTAMP,
  "issuedate" TIMESTAMP,
  "parkingstarttime" VARCHAR,
  "parkingendtime" VARCHAR,
  "effectivedate" TIMESTAMP,
  "expirationdate" TIMESTAMP,
  "lastupdatedate" TIMESTAMP,
  "ewrnumber" VARCHAR,
  "totalpermitfee" DOUBLE,
  "technologyfee" DOUBLE,
  "inconvenientfee" DOUBLE,
  "worklocationfulladdress" VARCHAR,
  "totalmeterfee" DOUBLE,
  "totalcarspace" DOUBLE,
  "ownername" VARCHAR,
  "applicantcompany" VARCHAR,
  "permitteename" VARCHAR,
  "readyforreviewdate" TIMESTAMP,
  "assigneddate" TIMESTAMP,
  "lastapprovaldate" TIMESTAMP,
  "fiscalyear" BIGINT,
  "ward" BIGINT,
  "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
);