About this Dataset

ProTrack Project Line

Rehabilitation projects for roadways, sidewalks, alleys and markings from ProTrack+. These polylines are selected from the Project Initiation polylines and are associated with Solicitation Number and/or Contract Number. As the District Department of Transportation (DDOT) works to meet the goals of quality roadways, it has taken into account road quality assessment and community requests allowing the department to first address the streets that are in greatest need and highest priority to the community. Keeping DC roads in good condition provides maximum benefit to the traveling public by enhancing the safety of the roadway and improving the ride comfort of the road surface. View our weekly construction update to find out where DDOT crews are scheduled to be working over the coming days.
Organization: District of Columbia
Last updated: 2024-04-30T19:13:44.397254
Tags: construction, dc, ddot, district-of-columbia, protrack, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_protrack_project_line.table_1

2.82 MB
19164 rows
46 columns


CREATE TABLE table_1 (
  "piid" BIGINT,
  "piidbi" VARCHAR,
  "piuniqueid" BIGINT,
  "solicitationnumber" VARCHAR,
  "contractnumber" VARCHAR,
  "taskorderrequestnumber" VARCHAR,
  "taskordernumber" VARCHAR,
  "worktype" VARCHAR,
  "projectname" VARCHAR,
  "projectstatus" DOUBLE,
  "budgetyear" DOUBLE,
  "projectidentifier" VARCHAR,
  "estimatedstartdate" TIMESTAMP,
  "estimatedcompletiondate" TIMESTAMP,
  "actualstartdate" VARCHAR,
  "actualcompletiondate" TIMESTAMP,
  "percentcompleted" DOUBLE,
  "requesttype" BIGINT,
  "routename" VARCHAR,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "routeid" VARCHAR,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "miles" DOUBLE,
  "functionalclass" DOUBLE,
  "estimatedcost" DOUBLE,
  "actualcost" DOUBLE,
  "ward" VARCHAR,
  "smd" VARCHAR,
  "anc" VARCHAR,
  "isnhs" DOUBLE,
  "side" DOUBLE,
  "createddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "dtaplastupdateddate" VARCHAR,
  "description" VARCHAR,
  "comments" VARCHAR,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid_1" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "shapelen" BIGINT
);