This dataset contains the necessary information to compute the average cost of a utility locate in the Mesa and/or Magma Service Areas (see Service Area maps). A utility locate involves identification of all underground utilities prior to excavation in a specified area. A utility locate is initiated, usually by a homeowner or excavator, by calling 811 or contacting Arizona’s 811 center’s website and providing the address, county and nearest cross street of where they’re planning to dig, as well as the type of project they’re completing and the exact area on the property they’re planning to dig. 811 then contacts the city’s utilities so they can mark the presence of any underground utilities in the proposed project area. Utility locates can contribute to increased safety to people and property and can eliminate unexpected costs due to accidental damage of buried utilities. A locate can be initiated by either a homeowner or an excavator. Data being reported may have a 14 day lag.
This dataset has the following 14 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Row ID | row_id | text | This is a unique identifier for each record in the dataset. | 71 118 123 8 75 view top 100 |
| Year | year | text | Fiscal Year that the 811 locate was responded to by City of Mesa locate personnel. | 2023 2021 2012 2013 2014 view top 100 |
| Month | month | text | The accounting period in a Fiscal year in which the 811 locate occurred, based on 12 accounting periods. | October November December January July view top 100 |
| Date | date | calendar_date | The day of the month based on the accounting period and calendar year on which the 811 locate occurred. | 2023-03-01T00:00:00.000 2023-01-01T00:00:00.000 2023-02-01T00:00:00.000 2019-11-01T00:00:00.000 2014-07-01T00:00:00.000 view top 100 |
| Total Locates | total_locates | number | Total number of locates in the Mesa and Magma Service Areas. A “Locate” would be considered any response by City of Mesa personnel, either electronic, painting the location of underground utilities or speaking with the excavator. | 21196 17643 20977 18087 17192 view top 100 |
| Mesa Locates | mesa_locates | number | Total number of locates requested by an excavator or homeowner in the Mesa Service Area only. https://www.mesaaz.gov/residents/energy/service-area-maps | 20859 18976 30588 16630 30372 view top 100 |
| Magma Locates | magma_locates | number | Total number of locates requested by an excavator or homeowner in the Magma Service Area only. https://www.mesaaz.gov/residents/energy/service-area-maps | 505 662 1659 1872 1227 view top 100 |
| Total Damages | total_damages | number | Sourced fromTotal number of damages in the Mesa and Magma Service Areas. A “damage” would be anytime an excavator unintentionally or intentionally hits an underground utility while excavating. the Damage Prevention dataset - see dataset description | 5 4 7 3 8 view top 100 |
| Total Hits Per 1000 Locates | total_hits_per_1000_locates | text | Total damages for month multiplied by 1000 then divided total number of locates for current month. Used to establish a baseline widely used in the locate industry. | view top 100 |
| 12 Month Rolling Average | _12_month_rolling_average | text | 12-month rolling average of the average cost per locate in both the Magma and Mesa Service Areas. | view top 100 |
| Costs Mesa S179 | costs_mesa_s179 | number | Sum of the locate costs for current month for the Mesa Service Area. Costs may include, Wages, benefits, marking paint to complete locates, locating equipment repair, tools, Fees for 811 membership, etc. | 93849.43 91365 111773.48 86707.28 61370.29 view top 100 |
| Costs Magma S180 | costs_magma_s180 | number | Sum of the locate costs for the current month for the Magma Service Area. Costs may include, Wages, benefits, marking paint to complete locates, locating equipment repair, tools, Fees for 811 membership, etc. | 6596.49 6348.63 6118.78 4843.26 9413.38 view top 100 |
| Average Cost Per Mesa Locate | average_cost_per_mesa_locate | number | Total locating costs in the Mesa Service Area divided by the number of utility locates requested by excavators in the Mesa Service Area. | 6.93972269735137 3.49951098650323 4.76717542840546 6.52833928252722 4.51611712622107 view top 100 |
| Average Cost Per Magma Locate | average_cost_per_magma_locate | number | Total locating costs in the Magma Service Area divided by the number of utility locates requested by excavators in the Magma Service Area. | 13.196045751634 1.35428143712575 10.0626804123711 10.0260231660232 4.67197817189632 view top 100 |