Monthly summary of electric energy used by all City facilities. Use is measured by (kWh) by facility. The data is sourced from internal utility billing systems (CIS) and external (Salt River Project Utility Bills). Although update job runs daily, the source data is updated monthly and is delayed by up to 30 days for the prior billing period.
This dataset has the following 21 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Row ID | row_id | text | Unique row identifier | 12377 118912 36146 53623 30543 view top 100 |
| Site Type | site_type | text | Grouping of sites based on major category (i.e. Building, Streetlights, Water Reclamation, Recreation, etc.)) | Other - Utility Traffic Signal Building Water Treatment & Distribution Street Lights view top 100 |
| Site Sub Type | site_sub_type | text | Sub grouping of site types (i.e. building sub type, Sprinkler, Park, Pump, Traffic Signals, etc.) | Sprinkler System Traffic Signal Temporary Power/Service Location Street Lights Water Transmission Pump view top 100 |
| Site | site | text | Name or description of the site | Falcon Field Fitch Park Parks Place East Wells Pump Sirrine Garage view top 100 |
| Category | category | text | Electric utility provider - City of Mesa (COM) or Salt River Project (SRP) Service Area | SRP COM view top 100 |
| Address | address | text | Site Address | 1 E MAIN ST 6030 S KENT 2155 S DOBSON RD 51 E MAIN ST 40 S SIRRINE view top 100 |
| Latitude | latitude | number | Latitude of site location | 33.414859 33.375207 33.306061 33.414847 33.414292 view top 100 |
| Longitude | longitude | number | Longitude of site location | -111.830636 -111.87899 -111.671284 -111.829887 -111.829161 view top 100 |
| Geolocation | geolocation | point | Geo location of site | {"coordinates":[-111.830636,33.414859],"type":"Point"} {"coordinates":[-111.671284,33.306061],"type":"Point"} {"coordinates":[-111.87899,33.375207],"type":"Point"} {"coordinates":[-111.829887,33.414847],"type":"Point"} {"coordinates":[-111.829161,33.414292],"type":"Point"} view top 100 |
| Premise Code Account Number | premise_code_account_number | text | City of Mesa Premise Code, or, SRP Account Number | 245763 102297 101711 106119 233679 view top 100 |
| EMS Flag | ems_flag | text | Does the site have an Energy Management System (EMS)? | No Yes view top 100 |
| EMS Install Date | ems_install_date | calendar_date | Date an EMS device installed | 2021-02-12T00:00:00.000 2020-10-31T00:00:00.000 2022-02-22T00:00:00.000 2022-06-22T00:00:00.000 2022-11-23T00:00:00.000 view top 100 |
| Month Date | month_date | calendar_date | Month and Year of billing cycle | 2023-12-01T00:00:00.000 2023-10-01T00:00:00.000 2023-11-01T00:00:00.000 2023-09-01T00:00:00.000 2023-08-01T00:00:00.000 view top 100 |
| Year | year | text | Year of Billing Cycle | 2023 2022 2021 2020 2019 view top 100 |
| Month | month | text | Month of billing cycle | Dec Nov Mar Apr Feb view top 100 |
| kWh | kwh | number | Number of kWh (kilowatt-hours) | 1 0 0.94 0.97 0.06 view top 100 |
| kWh Generated | kwh_generated | number | Number of kWh (kilowatt-hours) generated from solar | 0 38330.32 20602.76 16003.13 14026.45 view top 100 |
| kW | kw | number | The maximum usage of electricity during the entire billing period over a specific period of time, usually an hour | 0 0.3 0.4 0.2 0.5 view top 100 |
| Solar Flag | solar_flag | text | Indicator that site has solar generation | No Yes view top 100 |
| Solar Install Date | solar_install_date | calendar_date | Date of solar generation installation | 2015-09-01T00:00:00.000 2018-08-01T00:00:00.000 2018-12-01T00:00:00.000 2019-01-01T00:00:00.000 2015-10-01T00:00:00.000 view top 100 |
| Full Month | full_month | checkbox | true false view top 100 |