About this Dataset

Massachusetts Department Of Transportation (MassDOT) Work Zone Data Exchange (WZDx) V2.0 Feed Sample

This dataset provides information on work zones in the state of Massachusetts in a tabular format and is updated daily based on the live MassDOT Work Zone Data Exchange (WZDx) Feed. A continuously updating archive of the MassDOT WZDx feed data can be found at ITS WorkZone Raw Data Sandbox and the ITS WorkZone Semi-Processed Data Sandbox. The live feed is currently compliant with the WZDx Specification v2.0.
Organization: Department of Transportation
Last updated: 2020-11-12T13:02:13.622513
Tags: intelligent-transportation-systems-its, its-joint-program-office-jpo, massachusetts, massachusetts-department-of-transportation-massdot, smart-work-zones-manager-swzm, smart-work-zones-swz, work-zone-data-exchange-wzdx, work-zones

Tables

Table 1

@usgov.dot_gov_massachusetts_department_of_transportation_mas_f87a3bd0.table_1

30.83 kB
11 rows
31 columns

CREATE TABLE table_1 (
  "road_event_feed_info_feed_update_date" VARCHAR,
  "road_event_feed_info_version" BIGINT,
  "road_event_id" VARCHAR,
  "subidentifier" VARCHAR,
  "road_name" VARCHAR,
  "road_number" VARCHAR,
  "direction" VARCHAR,
  "beginning_cross_street" VARCHAR,
  "ending_cross_street" VARCHAR,
  "beginning_milepost" DOUBLE,
  "ending_milepost" DOUBLE,
  "beginning_accuracy" VARCHAR,
  "ending_accuracy" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "start_date_accuracy" VARCHAR,
  "end_date_accuracy" VARCHAR,
  "event_status" VARCHAR,
  "total_num_lanes" DOUBLE,
  "vehicle_impact" VARCHAR,
  "workers_present" VARCHAR,
  "reduced_speed_limit" DOUBLE,
  "restrictions" VARCHAR,
  "description" VARCHAR,
  "issuing_organization" VARCHAR,
  "creation_date" VARCHAR,
  "update_date" VARCHAR,
  "types_of_work" VARCHAR,
  "lanes" VARCHAR,
  "geometry_linestring" VARCHAR,
  "geometry_multipoint" VARCHAR
);