Next Day Actual Generation – Part 2

Published on July 22, 2025

To get more value from the Next Day Actual Generation (NGAD) table we need to join it with generation metadata in order to pick up valuable data attributes that are not available in the native NGAD data files.

I located the site metadata file here:

https://aemo.com.au/-/media/files/electricity/nem/participant_information/nem-registration-and-exemption-list.ashx?la=en

It’s an MS Excel workbook with multiple sheets inside. Locate the “PU and Scheduled Loads” sheet. Use this to build a metadata table.

This example join gives the NGAD table the metadata. Joining the “actual_generation” and “duid_metadata” tables. This now allows us to see the maximum generation capability (max_cap_gen_mw) associated with the generation site (duid)

SELECT
  ag.ndag_interval_datetime,
  ag.duid,
  ag.mwh_reading,
  dm.max_cap_gen_mw
FROM actual_generation ag
JOIN duid_metadata dm ON ag.duid = dm.duid
where ag.duid = 'PORTWF'
;
Output… 
 ndag_interval_datetime |  duid  | mwh_reading | max_cap_gen_mw
------------------------+--------+-------------+----------------
 2024-10-11 06:25:00+11 | PORTWF |   72.199997 |            148
 2024-10-11 06:30:00+11 | PORTWF |   72.400002 |            148
 2024-10-11 06:35:00+11 | PORTWF |   75.599998 |            148
 2024-10-11 06:40:00+11 | PORTWF |   83.699997 |            148
 2024-10-11 06:45:00+11 | PORTWF |   87.699997 |            148
 2024-10-11 06:50:00+11 | PORTWF |   78.800003 |            148
 2024-10-11 06:55:00+11 | PORTWF |        76.5 |            148
 2024-10-11 07:00:00+11 | PORTWF |   79.300003 |            148
 2024-10-11 07:05:00+11 | PORTWF |   80.199997 |            148
 2024-10-11 07:10:00+11 | PORTWF |        83.0 |            148
 2024-10-11 07:15:00+11 | PORTWF |   72.199997 |            148
...
...

Previous

Next