This dataset describes planned and completed traffic signal audits across the City of Mesa managed transportation system. A traffic signal audit is a formal examination of the number of signalized intersections maintained by the City of Mesa. They are checked for proper programming and operation on a quarterly basis by a formal internal team. The data recorded includes the date by which each intersection needed to be audited, as well as the date the audit was completed.
This dataset has the following 12 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Intersection Number | intersection_number | number | This is a number assigned to every signalized intersection in Mesa | 5900 4060 4350 6200 900 view top 100 |
| Intersection Name | intersection_name | text | This name is a description of both major roads meeting at an intersection | Broadway & Lindsay Main & Park-N-Ride Pepper & Center Broadway & Alma School McDowell & Greenfield view top 100 |
| Target Completion | target_completion | calendar_date | This date is the targeted date that an intersection needs to be inspected/audited by | 2023-12-31T00:00:00.000 2024-03-31T00:00:00.000 2023-09-30T00:00:00.000 2023-06-30T00:00:00.000 2018-03-31T00:00:00.000 view top 100 |
| Date Complete | date_complete | calendar_date | Date that the intersection audit was completed | 2022-09-28T00:00:00.000 2022-06-28T00:00:00.000 2022-08-25T00:00:00.000 2022-03-03T00:00:00.000 2022-11-21T00:00:00.000 view top 100 |
| Longitude | longitude | number | Signal Longitude | -111.71877484 -111.77057693 -111.6724559 -111.70127069 -111.73577035 view top 100 |
| Latitude | latitude | number | Signal Latitude | 33.45183102 33.4662656 33.47739971 33.45148413 33.46635717 view top 100 |
| Target Completion Year | target_completion_year | text | Year the targeted date that an intersection needs to be inspected/audited by | 2023 2018 2022 2019 2020 view top 100 |
| Target Completion Month | target_completion_month | text | Month the targeted date that an intersection needs to be inspected/audited by | Mar Jun Dec Sep view top 100 |
| Year Complete | year_complete | text | Year that the intersection audit was completed | 2023 2019 2018 2022 2020 view top 100 |
| Month Complete | month_complete | text | Month that the intersection audit was completed | Mar Jun Sep Dec Nov view top 100 |
| Met Target | met_target | checkbox | Flag to determine if the target completion date was met. This is based off of a calculation between target completion and date complete. If the target completion date is before or equal to the date completed, it has met the target | true false view top 100 |
| Location | geocoded_column | point | Signal Location | {"coordinates":[-111.71854197,33.48401817],"type":"Point"} {"coordinates":[-111.7893348,33.4590578],"type":"Point"} {"coordinates":[-111.77077423,33.4517988],"type":"Point"} {"coordinates":[-111.83975261,33.45144257],"type":"Point"} {"coordinates":[-111.73590403,33.46637123],"type":"Point"} view top 100 |