About this Dataset

ProTrack Project Initiation Polygon

Rehabilitation projects for roadways, sidewalks, alleys and markings from ProTrack+. When approved this polygon 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:43.872505
Tags: construction, dc, ddot, district-of-columbia, protrack, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_protrack_project_initiation_polygon.table_1

239.52 KB
1919 rows
30 columns


CREATE TABLE table_1 (
  "uniqueid" DOUBLE,
  "piid" BIGINT,
  "piidbi" VARCHAR,
  "projectname" VARCHAR,
  "worktype" VARCHAR,
  "description" VARCHAR,
  "comments" VARCHAR,
  "estimatedstartdate" TIMESTAMP,
  "estimatedcompletiondate" TIMESTAMP,
  "estimatedcost" DOUBLE,
  "condition" VARCHAR,
  "budgetyear" DOUBLE,
  "ward" VARCHAR,
  "projectidentifier" VARCHAR,
  "createddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "isselected" BIGINT,
  "smd" VARCHAR,
  "anc" VARCHAR,
  "status" VARCHAR,
  "gis_id" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT,
  "globalid_1" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR
);