About this Dataset

Cityworks Service Requests

Cityworks Service Requests - All Categories. Cityworks is the Work Management system used by the DC Department of Transportation to manage requests for service to District assets, such as alleys, curbs and gutters, roadways, sidewalks, signage, signals, streetlights, and trees.

Learn more at: https://ddot.dc.gov/service/work-order-management-system
Organization: District of Columbia
Last updated: 2024-04-30T18:49:45.979802
Tags: cityworks, ddot, district-of-columbia, service-requests, street-assets, transportation, washington-dc, work-management, work-orders

Tables

Table 1

@usgov.district_of_columbia_cityworks_service_requests.table_1

204.33 MB
1,418,175 rows
56 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "requestid" BIGINT,
  "workorderid" VARCHAR,
  "csrnumber" VARCHAR,
  "description" VARCHAR,
  "status" VARCHAR,
  "requestcategory" VARCHAR,
  "initiateddate" TIMESTAMP,
  "closeddate" TIMESTAMP,
  "inspectiondate" TIMESTAMP,
  "inspectioncomplete" VARCHAR,
  "submittedtodate" TIMESTAMP,
  "dispatchedtodate" TIMESTAMP,
  "canceleddate" TIMESTAMP,
  "priority" DOUBLE,
  "initiatedby" VARCHAR,
  "submittedto" VARCHAR,
  "dispatchedto" VARCHAR,
  "closedby" VARCHAR,
  "projectname" VARCHAR,
  "iscanceled" VARCHAR,
  "canceledby" VARCHAR,
  "address" VARCHAR,
  "fiscalyear" BIGINT,
  "ward" VARCHAR,
  "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,
  "daystoclose" BIGINT,
  "daystoinspect" DOUBLE,
  "updatedate" TIMESTAMP,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "onsegx" DOUBLE,
  "onsegy" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "lot" VARCHAR,
  "globalid" VARCHAR
);