About this Dataset

ProTrack Project Initiation Line

Rehabilitation projects for roadways, sidewalks, alleys and markings from ProTrack+. When approved this polyline can be selected in project solicitation phase to associate it with a Solicitation Number and/or Contract Number. All project locations must be added during initiation. 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:47.364728
Tags: construction, dc, ddot, district-of-columbia, protrack, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_protrack_project_initiation_line.table_1

2.53 MB
18,399 rows
39 columns

CREATE TABLE table_1 (
  "piid" BIGINT,
  "piidbi" VARCHAR,
  "uniqueid" DOUBLE,
  "projectname" VARCHAR,
  "worktype" VARCHAR,
  "description" VARCHAR,
  "comments" VARCHAR,
  "routename" VARCHAR,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "routeid" VARCHAR,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "miles" DOUBLE,
  "functionalclass" DOUBLE,
  "estimatedstartdate" TIMESTAMP,
  "estimatedcompletiondate" TIMESTAMP,
  "estimatedcost" DOUBLE,
  "condition" VARCHAR,
  "ward" VARCHAR,
  "isnhs" DOUBLE,
  "side" DOUBLE,
  "budgetyear" DOUBLE,
  "projectidentifier" VARCHAR,
  "smd" VARCHAR,
  "anc" VARCHAR,
  "status" VARCHAR,
  "isselected" BIGINT,
  "createddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "gis_id" VARCHAR,
  "globalid_1" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "shapelen" BIGINT
);