Name: Emergency Work Requests (via DDOT TOPs)
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

Emergency Work Requests (via DDOT TOPs)

This data sets shows emergency work requests from DDOT's Transportation Online Permitting System. https://tops.ddot.dc.gov/
Organization: District of Columbia
Last updated: 2024-04-30T19:04:52.010952
Tags: construction, ddot, district-of-columbia, emergency, tops, transportation, washington-dc, work, work-request

Tables

Table 1

@usgov.district_of_columbia_emergency_work_requests_via_ddot_tops.table_1

6.51 MB
79143 rows
29 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "constructiontrackingnumber" DOUBLE,
  "occupancytrackingnumber" DOUBLE,
  "starttime" VARCHAR,
  "emergencycause" VARCHAR,
  "emergencytypedesc" VARCHAR,
  "locationdescription" VARCHAR,
  "statusdesc" VARCHAR,
  "appliedbyfullname" VARCHAR,
  "applicationdate" TIMESTAMP,
  "cancelleddate" TIMESTAMP,
  "effectivedate" TIMESTAMP,
  "expirationdate" TIMESTAMP,
  "issueddate" VARCHAR,
  "lastupdatedate" TIMESTAMP,
  "applicantcompanyname" VARCHAR,
  "status" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);