Feeder Vellmoor Distribution · control room Synthetic data Sun 02:00

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

meaningtestresultobservedexpected
assetscount_betweenpass1200between 1000.0 and 1200.0
assetsuniquepass{'duplicates': 0}feeder_id unique