About this Dataset

Cityworks Workorders

Cityworks Workorders - All Categories. Cityworks is the Work Management system used by the District 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-30T19:27:24.374423
Tags: cityworks, construction, ddot, district-of-columbia, street-assets, transportation, washington-dc, work-management, work-orders

Tables

Table 1

@usgov.district_of_columbia_cityworks_workorders.table_1

154.25 MB
1,053,829 rows
62 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "workorderid" BIGINT,
  "projectid" DOUBLE,
  "description" VARCHAR,
  "status" VARCHAR,
  "initiateddate" TIMESTAMP,
  "workordercloseddate" TIMESTAMP,
  "actualstartdate" VARCHAR,
  "actualfinishdate" VARCHAR,
  "projectname" VARCHAR,
  "priority" DOUBLE,
  "sourceworkorderid" DOUBLE,
  "cycletype" VARCHAR,
  "scheduledate" VARCHAR,
  "workordercategory" VARCHAR,
  "unattached" VARCHAR,
  "workordercost" DOUBLE,
  "workorderlaborcost" DOUBLE,
  "workordermaterialcost" DOUBLE,
  "workorderequipmentcost" DOUBLE,
  "submittedto" VARCHAR,
  "submittedtodate" TIMESTAMP,
  "workcompletedby" VARCHAR,
  "workorderclosedby" VARCHAR,
  "iscanceled" VARCHAR,
  "canceledby" VARCHAR,
  "canceleddate" TIMESTAMP,
  "assetgroup" VARCHAR,
  "supervisor" VARCHAR,
  "requestedby" VARCHAR,
  "initiatedby" 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,
  "updatedate" TIMESTAMP,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "onsegx" DOUBLE,
  "onsegy" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "shape" VARCHAR,
  "globalid" VARCHAR
);