ProTrack Project Polygon by US Government | Transportation and Logistics

About this Dataset

ProTrack Project Polygon

Rehabilitation projects for roadways, sidewalks, alleys and markings from ProTrack+. These polygons are selected from the Project Initiation polygons 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:28.362416
Tags: construction, dc, ddot, district-of-columbia, protrack, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_protrack_project_polygon.table_1

208.84 KB
1522 rows
38 columns


CREATE TABLE table_1 (
  "piid" BIGINT,
  "piidbi" VARCHAR,
  "piuniqueid" BIGINT,
  "solicitationnumber" VARCHAR,
  "contractnumber" VARCHAR,
  "taskorderrequestnumber" VARCHAR,
  "taskordernumber" VARCHAR,
  "worktype" VARCHAR,
  "projectname" VARCHAR,
  "projectstatus" BIGINT,
  "budgetyear" DOUBLE,
  "projectidentifier" VARCHAR,
  "estimatedstartdate" TIMESTAMP,
  "estimatedcompletiondate" TIMESTAMP,
  "actualstartdate" TIMESTAMP,
  "actualcompletiondate" TIMESTAMP,
  "percentcompleted" DOUBLE,
  "requesttype" BIGINT,
  "estimatedcost" DOUBLE,
  "actualcost" DOUBLE,
  "ward" VARCHAR,
  "smd" VARCHAR,
  "anc" VARCHAR,
  "createddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "dtaplastupdateddate" VARCHAR,
  "description" VARCHAR,
  "comments" VARCHAR,
  "gis_id" VARCHAR,
  "globalid_1" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);