Definitions / feeder_load
Feeder load
How hard each feeder is working: its peak head load in the period as a share of its rating.
assets · Head of Asset Management · version 1
Per feeder, the highest 15-minute head load in the period and that as a percentage of the rating; feeders at or above report_from_pct.
Latest change: First version.
SQL
SELECT f.id AS feeder_id, f.code, f.rating_amps, max(r.load_amps) AS peak_amps,
round(100.0 * max(r.load_amps) / f.rating_amps, 1) AS peak_pct
FROM feeder_readings r JOIN feeders f ON f.id = r.feeder_id
WHERE r."at" >= {period_start} AND r."at" < {period_end} AND r."at" <= {now}
GROUP BY f.id, f.code, f.rating_amps
HAVING round(100.0 * max(r.load_amps) / f.rating_amps, 1) >= {report_from_pct}
ORDER BY peak_pct DESC, f.id
Tests
| meaning | test | result | observed | expected |
|---|---|---|---|---|
| assets | count_between | pass | 1200 | between 1000.0 and 1200.0 |
| assets | unique | pass | {'duplicates': 0} | feeder_id unique |