About this Dataset

Massachusetts Department Of Transportation (MassDOT) Work Zone Data Exchange (WZDx) V3.1 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. This live feed is currently compliant with the WZDx Specification v3.1.
Organization: Department of Transportation
Last updated: 2021-06-21T13:16:22.238169
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_165cadea.table_1

42.64 kB
8 rows
49 columns

CREATE TABLE table_1 (
  "road_event_feed_info_update_date" VARCHAR,
  "road_event_feed_info_version" DOUBLE,
  "road_event_id" VARCHAR,
  "event_type" VARCHAR,
  "road_names" 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" VARCHAR,
  "vehicle_impact" VARCHAR,
  "workers_present" VARCHAR,
  "reduced_speed_limit" BIGINT,
  "restrictions" VARCHAR,
  "description" VARCHAR,
  "creation_date" VARCHAR,
  "update_date" VARCHAR,
  "types_of_work" VARCHAR,
  "lanes" VARCHAR,
  "geometry_linestring" VARCHAR,
  "geometry_multipoint" VARCHAR,
  "relationship_first" VARCHAR,
  "relationship_next" VARCHAR,
  "relationship_parents" VARCHAR,
  "relationship_children" VARCHAR,
  "road_event_feed_info_publisher" VARCHAR,
  "road_event_feed_info_update_frequency" VARCHAR,
  "road_event_feed_info_contact_name" VARCHAR,
  "road_event_feed_info_contact_email" VARCHAR,
  "data_source_id" VARCHAR,
  "data_source_organization_name" VARCHAR,
  "data_source_location_method" VARCHAR,
  "data_source_contact_name" VARCHAR,
  "data_source_contact_email" VARCHAR,
  "data_source_update_date" VARCHAR,
  "data_source_update_frequency" VARCHAR,
  "data_source_location_verify_method" VARCHAR,
  "data_source_lrs_type" VARCHAR,
  "data_source_lrs_url" VARCHAR,
  "feed_bbox" VARCHAR,
  "road_event_bbox" VARCHAR
);