Energy Resources - Aggregated PM Data
Department aggregated list of performance measures and metric tracker. Data reporting may have a 14-day lag. Includes the following performance measures: Accuracy of Switching Orders; 12kV Substation Capacity Available for Use; Response Times to Call Outs; Reliability – Number of Outages; Reliability – Outage Duration (SAIDI); Reliability – Outage Frequency (SAIFI); and Accuracy of Meters.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"citydata-mesaaz-gov/energy-resources-aggregated-pm-data-7fca-t4vy\".\"energy_resources_aggregated_pm_data\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.