About this Dataset

Texas DOT (TxDOT) Work Zone Data Schema Version 2.0

This dataset provides lane closure occurrences within the Texas Department of Transportation (TxDOT) highway system in a tabular format. A continuously updating archive of the TxDOT 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 Work Zone Data Exchange (WZDx) Specification version 2.0.
Organization: Department of Transportation
Last updated: 2020-11-12T12:48:15.762448
Tags: highways, intelligent-transportation-systems-its, its-joint-program-office-jpo, lane-closure-dcmthcd, southwest-research-institute-swri, texas, texas-department-of-transportation-txdot, texas-dot-work-zone-data-txwzd, work-zone-data-exchange-wzdx, work-zones

Tables

Table 1

@usgov.dot_gov_texas_dot_txdot_work_zone_data.table_1

64.04 kB
2,180 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" VARCHAR,
  "ending_milepost" VARCHAR,
  "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" BIGINT,
  "vehicle_impact" VARCHAR,
  "workers_present" VARCHAR,
  "reduced_speed_limit" VARCHAR,
  "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
);