Dataset: Boston Public Works Active Work Zones

About this Dataset

Boston Public Works Active Work Zones

The Boston Department of Public Works' Construction Inspection Unit (CIU) produces a daily report on all active utility and private sector construction projects taking place in the City, Monday through Friday.

It also lists all resurfacing and reconstruction projects. Emergency work that is identified outside of normal business hours is made available on the following day's report. This is a legacy dataset containing active construction sites, with details such as neighborhood, reason for work, and estimated date of completion.

Tables

Boston Active Work Zones

@kaggle.patrickdrew_boston_public_works_active_work_zones.boston_active_work_zones

40.58 KB
689 rows
22 columns


CREATE TABLE boston_active_work_zones (
  "n__id" BIGINT,
  "construction_notes" VARCHAR,
  "from" VARCHAR,
  "district" VARCHAR,
  "permit" VARCHAR,
  "work_schedule" VARCHAR,
  "contractor" VARCHAR,
  "trench_length" DOUBLE,
  "to" VARCHAR,
  "roadway_plates_in_use" DOUBLE,
  "address_1" DOUBLE,
  "address_2" DOUBLE,
  "status" VARCHAR,
  "expirationdate" TIMESTAMP,
  "intersection" VARCHAR,
  "permittee" VARCHAR,
  "sidewalk_plates_in_use" DOUBLE,
  "project_category" VARCHAR,
  "estimated_completion_date" TIMESTAMP,
  "numberofworkzones" DOUBLE,
  "neighborhood" VARCHAR,
  "street" VARCHAR
);