About this Dataset

ProTrack Project Initiation Point

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

Tables

Table 1

@usgov.district_of_columbia_protrack_project_initiation_point.table_1

307.82 KB
2033 rows
37 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "piid" BIGINT,
  "piidbi" VARCHAR,
  "uniqueid" DOUBLE,
  "projectname" VARCHAR,
  "worktype" VARCHAR,
  "description" VARCHAR,
  "comments" VARCHAR,
  "routename" VARCHAR,
  "routeid" VARCHAR,
  "measure" DOUBLE,
  "intersectionname" VARCHAR,
  "intersectionid" DOUBLE,
  "functionalclass" DOUBLE,
  "estimatedstartdate" TIMESTAMP,
  "estimatedcompletiondate" TIMESTAMP,
  "estimatedcost" DOUBLE,
  "condition" VARCHAR,
  "ward" VARCHAR,
  "isnhs" DOUBLE,
  "budgetyear" DOUBLE,
  "projectidentifier" VARCHAR,
  "createddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "isselected" BIGINT,
  "smd" VARCHAR,
  "anc" VARCHAR,
  "status" VARCHAR,
  "gis_id" VARCHAR,
  "globalid_1" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);