About this Dataset

Maricopa County Regional Work Zone Data Exchange (WZDx) V1.1 Feed Sample

The WZDx Specification enables infrastructure owners and operators (IOOs) to make harmonized work zone data available for third party use. The intent is to make travel on public roads safer and more efficient through ubiquitous access to data on work zone activity. Specifically, the project aims to get data on work zones into vehicles to help automated driving systems (ADS) and human drivers navigate more safely. MCDOT leads the effort to aggregate and collect work zone data from the AZTech Regional Partners. A continuously updating archive of the WZDx feed data can be found at ITS WorkZone Data Sandbox. The live feed is currently compliant with WZDx specification version 1.1.
Organization: Department of Transportation
Last updated: 2020-11-12T13:00:50.923959
Tags: arizona, arizona-department-of-transportation-adot, arterial, automobiles, avondale, bicycles-pedestrians, chandler, construction-feeds, freeway, freight, gilbert, glendale, goodyear, intelligent-transportation-systems-its, its-joint-program-office-jpo, lane-restrictions, maricopa-county-department-of-transportation-mcdot, mesa, multi-modal-intelligent-traffic-signal-system-mmitss, phoenix, public-transit, research-statistics, road-conditions, road-maintenance, roadway-bridges, scottsdale, tempe, transit, trucking-motorcoaches, work-zone-data-exchange-wzdx

Tables

Table 1

@usgov.dot_gov_maricopa_county_regional_work_zone_exchange_wz_5bf1ae31.table_1

63.01 KB
163 rows
50 columns


CREATE TABLE table_1 (
  "header_metadataurl" VARCHAR,
  "header_timestampupdate" VARCHAR,
  "header_versionno" BIGINT,
  "roadrestrictions" VARCHAR,
  "beginlocation_crossstreet" VARCHAR,
  "beginlocation_latitude_est" DOUBLE,
  "beginlocation_latitude_ver" DOUBLE,
  "beginlocation_longitude_est" DOUBLE,
  "beginlocation_longitude_ver" DOUBLE,
  "beginlocation_milepost_est" VARCHAR,
  "beginlocation_milepost_ver" VARCHAR,
  "beginlocation_roaddirection" VARCHAR,
  "beginlocation_roadname" VARCHAR,
  "beginlocation_roadnum" VARCHAR,
  "closedlanes" VARCHAR,
  "closedshoulders" VARCHAR,
  "description" VARCHAR,
  "enddatetime_cancelled" VARCHAR,
  "enddatetime_est" VARCHAR,
  "enddatetime_ver" VARCHAR,
  "enddatetime_timeconfidencelevel" VARCHAR,
  "endlocation_crossstreet" VARCHAR,
  "endlocation_latitude_est" DOUBLE,
  "endlocation_latitude_ver" DOUBLE,
  "endlocation_longitude_est" DOUBLE,
  "endlocation_longitude_ver" DOUBLE,
  "endlocation_milepost_est" VARCHAR,
  "endlocation_milepost_ver" VARCHAR,
  "identifier" VARCHAR,
  "issuingorganization" VARCHAR,
  "openlanes" VARCHAR,
  "reducedspdposted" DOUBLE,
  "startdatetime_cancelled" VARCHAR,
  "startdatetime_est" VARCHAR,
  "startdatetime_ver" VARCHAR,
  "startdatetime_timeconfidencelevel" VARCHAR,
  "subidentifier" VARCHAR,
  "timestampeventcreation" VARCHAR,
  "timestampeventupdate" VARCHAR,
  "totallanes" DOUBLE,
  "workerspresent" VARCHAR,
  "wz_status" VARCHAR,
  "startdatetime" VARCHAR,
  "enddatetime" VARCHAR,
  "beginlocation_latitude" DOUBLE,
  "beginlocation_longitude" DOUBLE,
  "endlocation_latitude" DOUBLE,
  "endlocation_longitude" DOUBLE,
  "beginlocation" VARCHAR,
  "endlocation" VARCHAR
);