Skip to content

GENCONSETTRK

GENCONSETTRK assists in determining the correct version of a generic constraint set that has been invoked in GENCONSETINVOKE.

GENCONSETTRK data is public to all participants.

Source

Ad hoc updates occur to GENCONSETTRK.

Column Schema

EFFECTIVEDATE

Date this record becomes effective

SQL Type: DATE Polars Type: pl.Date()

This column is mandatory, and a primary key.

Example: 2026/09/01 00:00:00

Note that AEMO represents dates as datetimes with a midnight time component.

GENCONSETID

Unique ID for the Constraint Set

SQL Type: VARCHAR2(20) Polars Type: str

This column is mandatory, and a primary key.

Examples:

  • #BARKIPS1_DE
  • #DRYCGT1_DE
  • #DRYCGT2_DE
  • #MCINTYR1_E
  • #NSW1-QLD1_RAMP_I
  • #QPS5_DE
  • #R036713_RAMP
  • #R036714_RAMP
  • #R036715_RAMP
  • #R036716_RAMP

VERSIONNO

Version no of the record for the given effective date

SQL Type: NUMBER(3,0) Polars Type: pl.UInt16

This column is mandatory, and a primary key.

Examples: 1, 4

AUTHORISEDBY

The person who authorised the constraint set

SQL Type: VARCHAR2(15) Polars Type: str

This column is not mandatory.

Examples:

  • AASHFAQ
  • ABRAHAMY
  • AMULINGBAYAN
  • ANGROOM
  • ANL
  • BASHFORD
  • BATCH
  • BBLAKE
  • BCHHETRI
  • BOGDANV

AUTHORISEDDATE

The date and time of authorising the constraint set

Warning

Despite what the name suggests, this is a datetime, not a date.

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2026/09/01 02:06:54

COVERAGE

The region the constraint set is located in or a special grouping (e.g. CHIMERA)

SQL Type: VARCHAR2(64) Polars Type: str

This column is not mandatory.

Examples:

  • CONSTRAINT AUTO
  • FCAS - GLOBAL
  • INTER-REGIONAL
  • NEGATIVE RESIDUE
  • NET SUPP AGREEMENTS
  • NON-CONFORMANCE
  • NSW1
  • QLD1
  • QUICK
  • SA1

DESCRIPTION

Description of the constraint

SQL Type: VARCHAR2(256) Polars Type: str

This column is not mandatory.

Examples:

  • 65_66 OL FOR 051 outage
  • 0MW upper limit on Dundonnell WF, Golden Plains WF, Hawkesdale WF, Macarthur WF, Mortlake BESS, Mortlake PS, Ryan Corner WF and Stockyard Hill WF.
  • 0MW upper limit on Elaine WF, Moorabool WF, Mt Mercer WF, VBB BESS, Terang BESS, Berrybank 1 and 2 WF, Mortlake South WF, Oaklands Hill WF, Salt Creek WF, Mt Gelibrand WF
  • 0MW upper limit on Hallet PS, Hallet WF, Goyder South WF, Hornsdale WF, Hornsdale BESS, North Brown Hill WF, Bluff WF, Willogoleche WF
  • 0MW upper limit on IBR within North West Victoria (Bendigo-Ballarat-Red Cliffs 220kV area)
  • 0MW upper limit on IBR within South West NSW (Buronga to Wagga area)
  • 0MW upper limit on Snuggery PS, Canunda WF, Lake Bonney WF, Lake Bonney BESS, Mannum SF, Mannum BESS, Ladbroke PS, Tailem Bend SF 1 & 2, Tailem Bend BESS 2 & 3
  • 1000MW upper limit on Dundonnell WF, Golden Plains WF, Hawkesdale WF, Macarthur WF, Mortlake BESS, Mortlake PS, Ryan Corner WF and Stockyard Hill WF.
  • 1000MW upper limit on Hallet PS, Hallet WF, Goyder South WF, Hornsdale WF, Hornsdale BESS, North Brown Hill WF, Bluff WF, Willogoleche WF
  • 1000MW upper limit on IBR within North West Victoria (Bendigo-Ballarat-Red Cliffs 220kV area)

LASTCHANGED

Last date and time record changed

For more information, see the dedicated documentation page.

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2026/09/01 02:06:54

MODIFICATIONS

Details of the changes made to this version of the constraint set

SQL Type: VARCHAR2(256) Polars Type: str

This column is not mandatory.

Examples:

  • Added I_6F_NS_150 and I_6F_SN_150 and UFLS, ROCOF and OFGS from NIL sets. CCR10268
  • Added FCAS zero equations, CCR10234
  • Added MW/inverter conversion capping limit for Broken Hill BESS and Limondale BESS. CCR10223
  • Added MW/inverter conversion capping limit for Broken Hill BESS, Darling Point BESS, Limondale BESS, Riverina 1 & 2 BESS. CCR10223
  • Added MW/inverter conversion capping limit for Darling Point BESS, Riverina 1 & 2 BESS. CCR10223
  • Added MW/inverter conversion capping limit for Limondale BESS. CCR10223
  • Added PEC-2 NRM constraints. CCR10276
  • Added inverter indication equation for Carwarp SF; CCR10253
  • Added new thermal constraints managing txfmr flow from 220 to 330kV. CCR10212
  • Added new thermal equation. CCR10230

OUTAGE

Detail of the plant that is not in service

SQL Type: VARCHAR2(256) Polars Type: str

This column is not mandatory.

Examples:

  • * No transmission outages
  • * discretionary upper limit for Laverton North Unit 1
  • * discretionary upper limit for Loy Yang A Unit 4
  • * discretionary upper limits for West Wyalong SF Generation
  • * discretionary upper limits for Woodlawn Generation
  • Dederang No.1 330/220kV transformer
  • Dederang No.2 330/220kV transformer
  • Dederang No.3 330/220kV transformer
  • * Discretionary upper limits for Hume VIC Generation
  • 051 (Lower Tumut to Wagga) 330kV line 0/S, Wagga-Yass 132kV split, 9R3 + 9R4 + 63 open, and with 2 Yass Transformer in service

SYSTEMNORMAL

Not used as of 2005 End of Year Release [was Flag to indicate if the constraint set is a system normal (1) or and an outage set (0)]

SQL Type: VARCHAR2(1) Polars Type: pl.Boolean

This column is unused.

Example: 0

New Data Timing

Ad hoc

Code Examples

Polars

Casting is enums, categoricals etc is not essential, but may speed up parsing. Swapping int for pl.UInt16, pl.Int32 would also speed up parsing. However some of the datatypes are inferred, so they may be wrong.

This code deduplicates for you. Deduplication is normally only required across multiple months.

This code assumes that all columns are present, which may not be true for older files.

import polars as pl
import polars.selectors as cs

# e.g. "2029/03/15 00:05:00"
dt_s_fmt = "%Y/%m/%d %H:%M:%S"

# Dates are represented as datetimes at midnight

d_fmt = "%Y/%m/%d 00:00:00"

csv_paths = ["SOMEFILE.CSV", "OTHERFILE.CSV"]

lf = (
    pl.concat(
        [
            pl.scan_csv(
                csv_path,  # must be unzipped beforehand
                skip_rows=1,  # skip the header
                infer_schema=False,  # much faster
            )
            .filter(cs.by_index(0) == "D")  # drop the footer
            .select(~cs.by_index(range(4)))  # drop metadata columns
            for csv_path in csv_paths
        ],
        how="diagonal_relaxed",
    )
    .with_columns(
        pl.col("AUTHORISEDDATE", "LASTCHANGED").str.strptime(pl.Datetime, dt_s_fmt),
        pl.col("EFFECTIVEDATE").str.strptime(pl.Date, d_fmt),
    )
    # Polars can't cast string straight to bool. Need to go via something else.
    .cast({"SYSTEMNORMAL": pl.UInt8})
    .cast(
        {
            "EFFECTIVEDATE": pl.Date(),
            "GENCONSETID": str,
            "VERSIONNO": int,  # or pl.UInt16
            "AUTHORISEDBY": str,
            "COVERAGE": str,
            "DESCRIPTION": str,
            "MODIFICATIONS": str,
            "OUTAGE": str,
            "SYSTEMNORMAL": pl.Boolean,
        }
    )
    # Drop deprecated/unused columns
    .drop("SYSTEMNORMAL")
    # Deduplicate
    # We want one row per ['EFFECTIVEDATE', 'GENCONSETID', 'VERSIONNO']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(subset=["EFFECTIVEDATE", "GENCONSETID", "VERSIONNO"], keep="last")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_GENCONSETTRK_FILE01_202609010000.zip

GENCONSETIDEFFECTIVEDATEVERSIONNODESCRIPTIONAUTHORISEDBYAUTHORISEDDATELASTCHANGEDSYSTEMNORMALCOVERAGEMODIFICATIONSOUTAGE
#R036713_RAMP2026/09/01 00:00:001Ramping Set for Q-CLBTX on 01/09/2026Batch2026/09/01 02:06:542026/09/01 02:06:540QLD1NEWOut = one of the Columboola 275/132 kV transformers(TX2 or TX3)
#R036714_RAMP2026/09/01 00:00:001Ramping Set for Q-CLBTX on 01/09/2026WSCHIE2026/09/01 03:10:342026/09/01 03:10:340QLD1NEWOut = one of the Columboola 275/132 kV transformers(TX2 or TX3)
#R036715_RAMP2026/09/01 00:00:001Ramping Set for Q-X_HATR_TWO on 01/09/2026WSCHIE2026/09/01 03:10:572026/09/01 03:10:570QLD1NEWOut= Any two 275kV feeders between S2 Halys to H18 Tarong (8868,8869,8870,8871)
#R036716_RAMP2026/09/01 00:00:001Ramping Set for Q-CLBTX on 01/09/2026JWRIGHT2026/09/01 07:14:022026/09/01 07:14:020QLD1NEWOut = one of the Columboola 275/132 kV transformers(TX2 or TX3)
CA_SYDS_59A889E52026/09/01 00:00:001MLTS-TGTS 220kV LineBATCH2026/09/01 08:12:552026/09/01 08:12:550CONSTRAINT AUTONewDEFAULT
I-TV_CLPS2026/09/01 00:00:001Out = Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Basslink limited to continuous ratingsANGROOM2026/09/01 08:44:392026/09/01 08:44:390INTER-REGIONALConstraints updated to reflect latest advice on continuous ratings. Limits advice 21/5/26. CCR10202Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Constraints to manage MW limits defined at receiving end.
V-X_BAELML_BAML_B1CB2026/09/01 00:00:001Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at MooraboolKNGUYEN22026/09/01 11:37:272026/09/01 11:37:280VIC1New. CCR10204Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at Moorabool
#SSE_PPCCGT_202026/09/01 00:00:001Minimum unit target for DUID PPCCGT required to provide system security for SSM Contract TS1_S00006 on 1/09/2026 12:35:00 AMBATCH2026/09/01 13:18:032026/09/01 13:18:030SA1NEWNone
#DRYCGT1_DE2026/09/01 00:00:001Direction - Energy - No Intervention PricingANL2026/09/01 00:00:002026/09/01 16:07:040QUICKNEWDEFAULT
#DRYCGT2_DE2026/09/01 00:00:001Direction - Energy - No Intervention PricingANL2026/09/01 00:00:002026/09/01 16:08:070QUICKNEWDEFAULT
#R036717_RAMP2026/09/01 00:00:001Ramping Set for V-MLTX_A2 on 01/09/2026MBHASKAR2026/09/01 19:36:492026/09/01 19:36:490VIC1NEWOut = Moorabool (MLTS) A2 500/220kV transformer O/S
...

CSETP.WORLDDVD_GENCONSETTRKAEMOPUBLIC2026/10/0915:36:39001791524199417MONTHLY_ARCHIVE001791524199417
IGENCONSETTRKNULL2GENCONSETIDEFFECTIVEDATEVERSIONNODESCRIPTIONAUTHORISEDBYAUTHORISEDDATELASTCHANGEDSYSTEMNORMALCOVERAGEMODIFICATIONSOUTAGE
DGENCONSETTRKNULL2#R036713_RAMP2026/09/01 00:00:001Ramping Set for Q-CLBTX on 01/09/2026Batch2026/09/01 02:06:542026/09/01 02:06:540QLD1NEWOut = one of the Columboola 275/132 kV transformers(TX2 or TX3)
DGENCONSETTRKNULL2#R036714_RAMP2026/09/01 00:00:001Ramping Set for Q-CLBTX on 01/09/2026WSCHIE2026/09/01 03:10:342026/09/01 03:10:340QLD1NEWOut = one of the Columboola 275/132 kV transformers(TX2 or TX3)
DGENCONSETTRKNULL2#R036715_RAMP2026/09/01 00:00:001Ramping Set for Q-X_HATR_TWO on 01/09/2026WSCHIE2026/09/01 03:10:572026/09/01 03:10:570QLD1NEWOut= Any two 275kV feeders between S2 Halys to H18 Tarong (8868,8869,8870,8871)
DGENCONSETTRKNULL2#R036716_RAMP2026/09/01 00:00:001Ramping Set for Q-CLBTX on 01/09/2026JWRIGHT2026/09/01 07:14:022026/09/01 07:14:020QLD1NEWOut = one of the Columboola 275/132 kV transformers(TX2 or TX3)
DGENCONSETTRKNULL2CA_SYDS_59A889E52026/09/01 00:00:001MLTS-TGTS 220kV LineBATCH2026/09/01 08:12:552026/09/01 08:12:550CONSTRAINT AUTONewDEFAULT
DGENCONSETTRKNULL2I-TV_CLPS2026/09/01 00:00:001Out = Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Basslink limited to continuous ratingsANGROOM2026/09/01 08:44:392026/09/01 08:44:390INTER-REGIONALConstraints updated to reflect latest advice on continuous ratings. Limits advice 21/5/26. CCR10202Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Constraints to manage MW limits defined at receiving end.
DGENCONSETTRKNULL2V-X_BAELML_BAML_B1CB2026/09/01 00:00:001Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at MooraboolKNGUYEN22026/09/01 11:37:272026/09/01 11:37:280VIC1New. CCR10204Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at Moorabool
DGENCONSETTRKNULL2#SSE_PPCCGT_202026/09/01 00:00:001Minimum unit target for DUID PPCCGT required to provide system security for SSM Contract TS1_S00006 on 1/09/2026 12:35:00 AMBATCH2026/09/01 13:18:032026/09/01 13:18:030SA1NEWNone
DGENCONSETTRKNULL2#DRYCGT1_DE2026/09/01 00:00:001Direction - Energy - No Intervention PricingANL2026/09/01 00:00:002026/09/01 16:07:040QUICKNEWDEFAULT
DGENCONSETTRKNULL2#DRYCGT2_DE2026/09/01 00:00:001Direction - Energy - No Intervention PricingANL2026/09/01 00:00:002026/09/01 16:08:070QUICKNEWDEFAULT
DGENCONSETTRKNULL2#R036717_RAMP2026/09/01 00:00:001Ramping Set for V-MLTX_A2 on 01/09/2026MBHASKAR2026/09/01 19:36:492026/09/01 19:36:490VIC1NEWOut = Moorabool (MLTS) A2 500/220kV transformer O/S
...
CEND OF REPORT920

GENCONSETID,EFFECTIVEDATE,VERSIONNO,DESCRIPTION,AUTHORISEDBY,AUTHORISEDDATE,LASTCHANGED,SYSTEMNORMAL,COVERAGE,MODIFICATIONS,OUTAGE
#R036713_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-CLBTX on 01/09/2026",Batch,"2026/09/01 02:06:54","2026/09/01 02:06:54",0,QLD1,NEW,"Out = one of the Columboola 275/132 kV transformers(TX2 or TX3)"
#R036714_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-CLBTX on 01/09/2026",WSCHIE,"2026/09/01 03:10:34","2026/09/01 03:10:34",0,QLD1,NEW,"Out = one of the Columboola 275/132 kV transformers(TX2 or TX3)"
#R036715_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-X_HATR_TWO on 01/09/2026",WSCHIE,"2026/09/01 03:10:57","2026/09/01 03:10:57",0,QLD1,NEW,"Out= Any two 275kV feeders between S2 Halys to H18 Tarong (8868,8869,8870,8871)"
#R036716_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-CLBTX on 01/09/2026",JWRIGHT,"2026/09/01 07:14:02","2026/09/01 07:14:02",0,QLD1,NEW,"Out = one of the Columboola 275/132 kV transformers(TX2 or TX3)"
CA_SYDS_59A889E5,"2026/09/01 00:00:00",1,"MLTS-TGTS 220kV Line",BATCH,"2026/09/01 08:12:55","2026/09/01 08:12:55",0,"CONSTRAINT AUTO",New,DEFAULT
I-TV_CLPS,"2026/09/01 00:00:00",1,"Out = Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Basslink limited to continuous ratings",ANGROOM,"2026/09/01 08:44:39","2026/09/01 08:44:39",0,INTER-REGIONAL,"Constraints updated to reflect latest advice on continuous ratings. Limits advice 21/5/26. CCR10202","Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Constraints to manage MW limits defined at receiving end."
V-X_BAELML_BAML_B1CB,"2026/09/01 00:00:00",1,"Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at Moorabool",KNGUYEN2,"2026/09/01 11:37:27","2026/09/01 11:37:28",0,VIC1,"New. CCR10204","Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at Moorabool"
#SSE_PPCCGT_20,"2026/09/01 00:00:00",1,"Minimum unit target for DUID PPCCGT required to provide system security for SSM Contract TS1_S00006 on 1/09/2026 12:35:00 AM",BATCH,"2026/09/01 13:18:03","2026/09/01 13:18:03",0,SA1,NEW,None
#DRYCGT1_DE,"2026/09/01 00:00:00",1,"Direction - Energy - No Intervention Pricing",ANL,"2026/09/01 00:00:00","2026/09/01 16:07:04",0,QUICK,NEW,DEFAULT
#DRYCGT2_DE,"2026/09/01 00:00:00",1,"Direction - Energy - No Intervention Pricing",ANL,"2026/09/01 00:00:00","2026/09/01 16:08:07",0,QUICK,NEW,DEFAULT
#R036717_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for V-MLTX_A2 on 01/09/2026",MBHASKAR,"2026/09/01 19:36:49","2026/09/01 19:36:49",0,VIC1,NEW,"Out = Moorabool (MLTS) A2 500/220kV transformer O/S"
...

C,SETP.WORLD,DVD_GENCONSETTRK,AEMO,PUBLIC,2026/10/09,15:36:39,001791524199417,MONTHLY_ARCHIVE,001791524199417
I,GENCONSETTRK,NULL,2,GENCONSETID,EFFECTIVEDATE,VERSIONNO,DESCRIPTION,AUTHORISEDBY,AUTHORISEDDATE,LASTCHANGED,SYSTEMNORMAL,COVERAGE,MODIFICATIONS,OUTAGE
D,GENCONSETTRK,NULL,2,#R036713_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-CLBTX on 01/09/2026",Batch,"2026/09/01 02:06:54","2026/09/01 02:06:54",0,QLD1,NEW,"Out = one of the Columboola 275/132 kV transformers(TX2 or TX3)"
D,GENCONSETTRK,NULL,2,#R036714_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-CLBTX on 01/09/2026",WSCHIE,"2026/09/01 03:10:34","2026/09/01 03:10:34",0,QLD1,NEW,"Out = one of the Columboola 275/132 kV transformers(TX2 or TX3)"
D,GENCONSETTRK,NULL,2,#R036715_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-X_HATR_TWO on 01/09/2026",WSCHIE,"2026/09/01 03:10:57","2026/09/01 03:10:57",0,QLD1,NEW,"Out= Any two 275kV feeders between S2 Halys to H18 Tarong (8868,8869,8870,8871)"
D,GENCONSETTRK,NULL,2,#R036716_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for Q-CLBTX on 01/09/2026",JWRIGHT,"2026/09/01 07:14:02","2026/09/01 07:14:02",0,QLD1,NEW,"Out = one of the Columboola 275/132 kV transformers(TX2 or TX3)"
D,GENCONSETTRK,NULL,2,CA_SYDS_59A889E5,"2026/09/01 00:00:00",1,"MLTS-TGTS 220kV Line",BATCH,"2026/09/01 08:12:55","2026/09/01 08:12:55",0,"CONSTRAINT AUTO",New,DEFAULT
D,GENCONSETTRK,NULL,2,I-TV_CLPS,"2026/09/01 00:00:00",1,"Out = Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Basslink limited to continuous ratings",ANGROOM,"2026/09/01 08:44:39","2026/09/01 08:44:39",0,INTER-REGIONAL,"Constraints updated to reflect latest advice on continuous ratings. Limits advice 21/5/26. CCR10202","Basslink Cable Load Prediction System (CLPS) dynamic rating data unavailable. Constraints to manage MW limits defined at receiving end."
D,GENCONSETTRK,NULL,2,V-X_BAELML_BAML_B1CB,"2026/09/01 00:00:00",1,"Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at Moorabool",KNGUYEN2,"2026/09/01 11:37:27","2026/09/01 11:37:28",0,VIC1,"New. CCR10204","Out = Ballarat to Elaine to Moorabool 220kV line and Moorabool to Ballarat No.1 line No.1 bus CB at Moorabool"
D,GENCONSETTRK,NULL,2,#SSE_PPCCGT_20,"2026/09/01 00:00:00",1,"Minimum unit target for DUID PPCCGT required to provide system security for SSM Contract TS1_S00006 on 1/09/2026 12:35:00 AM",BATCH,"2026/09/01 13:18:03","2026/09/01 13:18:03",0,SA1,NEW,None
D,GENCONSETTRK,NULL,2,#DRYCGT1_DE,"2026/09/01 00:00:00",1,"Direction - Energy - No Intervention Pricing",ANL,"2026/09/01 00:00:00","2026/09/01 16:07:04",0,QUICK,NEW,DEFAULT
D,GENCONSETTRK,NULL,2,#DRYCGT2_DE,"2026/09/01 00:00:00",1,"Direction - Energy - No Intervention Pricing",ANL,"2026/09/01 00:00:00","2026/09/01 16:08:07",0,QUICK,NEW,DEFAULT
D,GENCONSETTRK,NULL,2,#R036717_RAMP,"2026/09/01 00:00:00",1,"Ramping Set for V-MLTX_A2 on 01/09/2026",MBHASKAR,"2026/09/01 19:36:49","2026/09/01 19:36:49",0,VIC1,NEW,"Out = Moorabool (MLTS) A2 500/220kV transformer O/S"
...
C,"END OF REPORT",920

Availability

Visibility: Public

This table is in the public monthly MMSDM archive.

I have collated the list of all those files into one place, in this CSV metadata file. (Columns year, month, url, compressed_size in bytes).

The earliest available data is month 1 of 2015. The most recent available data is month 9 of 2026.

Every month in between has a file. (No gaps.)

Data Size

Each year of data is approximately 333 KB when zipped, 3 MB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

The transaction type is "insert", which means that you will usually not see duplicate data. If you do, you can deduplicate based on the primary keys, without sorting first. Rows from different files with the same primary keys should have the same values.

PDR Loader configuration is:

Report Name Report Subtype Version
GENCONSETTRK NULL 1
GENCONSETTRK NULL 2

This means that the CSV files start with metadata columns:

I,GENCONSETTRK,NULL,1,...
D,GENCONSETTRK,NULL,1,...

or

I,GENCONSETTRK,NULL,2,...
D,GENCONSETTRK,NULL,2,...

Indexes

This page as JSON (schema documented here, but may change)

Download a JSON Schema specification for this table.

Official AEMO schema documentation

Other Information

Package: GENERIC_CONSTRAINT