Skip to content

STPASA_INTERCONNECTORSOLN

STPASA_INTERCONNECTORSOLN shows the results of the capacity evaluation for Interconnectors, including the calculated limits for the interval.

STPASA_INTERCONNECTORSOLN is public so is available to all participants.

Source

STPASA_INTERCONNECTORSOLN is updated each STPASA run (i.e. every 2 hours).

Volume

Rows per day: 576

Mb per month: 4

Column Schema

INTERCONNECTORID

Interconnector Identifier

SQL Type: VARCHAR2(10) Polars Type: pl.Categorical

This column is mandatory, and a primary key.

Examples:

  • N-Q-MNSP1
  • NSW1-QLD1
  • T-V-MNSP1
  • V-S-MNSP1
  • V-SA
  • VIC1-NSW1

INTERVAL_DATETIME

The unique identifier for the interval within this study

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

This column is mandatory, and a primary key.

Example: 2026/09/05 01:30:00

RUN_DATETIME

Unique Timestamp Identifier for this study

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

This column is mandatory, and a primary key.

Example: 2026/09/03 02:00:00

RUNTYPE

Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. Note that the STPASA RELIABILITY_LRC and OUTAGE_LRC Run Types are discontinued from 31 July 2025, with only the LOR Run Type reported.

The SQL type is VARCHAR2(20). This is actually a factor/enum, with values:

  • RELIABILITY_LRC

  • OUTAGE_LRC

  • LOR

This column is mandatory, and a primary key.

STUDYREGIONID

Primary Region for LP Solve (or MARKET if none).

SQL Type: VARCHAR2(20) Polars Type: pl.Categorical

This column is mandatory, and a primary key.

Examples:

  • NSW1
  • QLD1
  • SA1
  • TAS1
  • VIC1

CALCULATEDEXPORTLIMIT

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit

SQL Type: NUMBER(12,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: -27.59, 24.44, 0, 975

CALCULATEDIMPORTLIMIT

Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow.

SQL Type: NUMBER(12,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: -2.83, 25.76, 0, -1379

CAPACITYMARGINALVALUE

Capacity adequacy assessment marginal value, 0 if not binding

SQL Type: NUMBER(12,2) Polars Type: pl.Float64

This column is not mandatory.

Example: 0

CAPACITYMWFLOW

Interconnector loading level (MW) that can be reached in case of capacity scarcity in neighbouring regions subject to network and energy constraints

SQL Type: NUMBER(12,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: -7.54, 6.82, 0, 456

CAPACITYVIOLATIONDEGREE

Capacity adequacy assessment violation degree for interconnector capacity; 0 if not violating

SQL Type: NUMBER(12,2) Polars Type: pl.Float64

This column is not mandatory.

Example: 0

EXPORTLIMITCONSTRAINTID

ID of the constraint that sets the Interconnector Export Limit

SQL Type: VARCHAR2(20) Polars Type: pl.Categorical

This column is not mandatory.

Examples:

  • I_6F_NS_150
  • I_6F_SN_150
  • N::N_CNCW_2
  • N::Q_BWMP_LDTW
  • N::Q_BWMP_TNT
  • N>>NIL_33_34
  • N>>NIL_39
  • N>>NIL_83_84_OPEN
  • N>NIL_LSDU
  • N>Q-NIL_757_758

IMPORTLIMITCONSTRAINTID

ID of the constraint that sets the Interconnector Import Limit

SQL Type: VARCHAR2(20) Polars Type: pl.Categorical

This column is not mandatory.

Examples:

  • I_6F_NS_150
  • N::V_DDMS
  • N::V_DDSM_MSDD
  • N>967_96L_89_S
  • N>>9W7_9W2_965
  • N>>NIL_23_22
  • N>>NIL_39
  • N>>NIL_86_85_S
  • N>>NIL_8U_86_S
  • N>>NIL_964_84_S

LASTCHANGED

Last changed date of this record

For more information, see the dedicated documentation page.

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

This column is not mandatory.

Example: 2026/09/03 02:08:47

New Data Timing

After each STPASA run (every 2 hours)

Code Examples

Polars

This table is so large that you should explicitly enumerate and cast every column, which will speed things up and prevents some errors. Although some of the datatypes are inferred, so they may be wrong. In particular, UInt16 vs UInt8 vs Int16 etc. If you get errors, you can swap these for just int.

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"

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("INTERVAL_DATETIME", "RUN_DATETIME", "LASTCHANGED").str.strptime(
            pl.Datetime, dt_s_fmt
        ),
    )
    .cast(
        {
            "INTERCONNECTORID": pl.Categorical,
            "RUNTYPE": pl.Enum(["RELIABILITY_LRC", "OUTAGE_LRC", "LOR"]),
            "STUDYREGIONID": pl.Categorical,
            "CALCULATEDEXPORTLIMIT": pl.Float64,
            "CALCULATEDIMPORTLIMIT": pl.Float64,
            "CAPACITYMARGINALVALUE": pl.Float64,
            "CAPACITYMWFLOW": pl.Float64,
            "CAPACITYVIOLATIONDEGREE": pl.Float64,
            "EXPORTLIMITCONSTRAINTID": pl.Categorical,
            "IMPORTLIMITCONSTRAINTID": pl.Categorical,
        }
    )
    # Deduplicate
    # These files are so large that this step may cause your laptop to run out of memory.
    # We want one row per ['INTERCONNECTORID', 'INTERVAL_DATETIME', 'RUN_DATETIME', 'RUNTYPE', 'STUDYREGIONID']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(
        subset=[
            "INTERCONNECTORID",
            "INTERVAL_DATETIME",
            "RUN_DATETIME",
            "RUNTYPE",
            "STUDYREGIONID",
        ],
        keep="last",
    )
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_STPASA_INTERCONNECTORSOLN_FILE01_202609010000.zip

RUN_DATETIMEINTERVAL_DATETIMEINTERCONNECTORIDCAPACITYMWFLOWCAPACITYMARGINALVALUECAPACITYVIOLATIONDEGREECALCULATEDEXPORTLIMITCALCULATEDIMPORTLIMITLASTCHANGEDRUNTYPEEXPORTLIMITCONSTRAINTIDIMPORTLIMITCONSTRAINTIDSTUDYREGIONID
2026/09/03 02:00:002026/09/08 00:30:00NSW1-QLD1000708.42-13792026/09/03 02:08:47LORN::Q_BWMP_TNTQ>N-NIL_8L_8MTAS1
2026/09/03 02:00:002026/09/08 00:30:00T-V-MNSP1-43800456-4382026/09/03 02:08:47LORTVBL_NIL_DYNVTBL_NILTAS1
2026/09/03 02:00:002026/09/08 00:30:00V-S-MNSP1000163.45-87.732026/09/03 02:08:47LORS>NIL_NWRB2_NWRB1S>>MW2MW3_RBNW1TAS1
2026/09/03 02:00:002026/09/08 00:30:00V-SA000645.05-7002026/09/03 02:08:47LORVS_HEY_600_TESTS:V_700_HY_TESTTAS1
2026/09/03 02:00:002026/09/08 00:30:00VIC1-NSW10001397.0902026/09/03 02:08:47LORV^^N_BADP_1N^^V_BADP_1TAS1
2026/09/03 02:00:002026/09/08 01:00:00N-Q-MNSP100087.1-1972026/09/03 02:08:47LORN>NIL_LSDUN_NIL_TE_BTAS1
2026/09/03 02:00:002026/09/08 01:00:00NSW1-QLD1000708.42-13792026/09/03 02:08:47LORN::Q_BWMP_TNTQ>N-NIL_8L_8MTAS1
2026/09/03 02:00:002026/09/08 01:00:00T-V-MNSP1-43800456-4382026/09/03 02:08:47LORTVBL_NIL_DYNVTBL_NILTAS1
2026/09/03 02:00:002026/09/08 01:00:00V-S-MNSP1000165.3-85.522026/09/03 02:08:47LORS>NIL_NWRB2_NWRB1S>>MW2MW3_RBNW1TAS1
2026/09/03 02:00:002026/09/08 01:00:00V-SA000646.62-7002026/09/03 02:08:47LORVS_HEY_600_TESTS:V_700_HY_TESTTAS1
2026/09/03 02:00:002026/09/08 01:00:00VIC1-NSW10001406.2302026/09/03 02:08:47LORV^^N_BADP_1N^^V_BADP_1TAS1
...

CSETP.WORLDDVD_STPASA_INTERCONNECTORSOLNAEMOPUBLIC2026/10/0916:34:19001791527659885MONTHLY_ARCHIVE001791527659885
ISTPASAINTERCONNECTORSOLN3RUN_DATETIMEINTERVAL_DATETIMEINTERCONNECTORIDCAPACITYMWFLOWCAPACITYMARGINALVALUECAPACITYVIOLATIONDEGREECALCULATEDEXPORTLIMITCALCULATEDIMPORTLIMITLASTCHANGEDRUNTYPEEXPORTLIMITCONSTRAINTIDIMPORTLIMITCONSTRAINTIDSTUDYREGIONID
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 00:30:00NSW1-QLD1000708.42-13792026/09/03 02:08:47LORN::Q_BWMP_TNTQ>N-NIL_8L_8MTAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 00:30:00T-V-MNSP1-43800456-4382026/09/03 02:08:47LORTVBL_NIL_DYNVTBL_NILTAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 00:30:00V-S-MNSP1000163.45-87.732026/09/03 02:08:47LORS>NIL_NWRB2_NWRB1S>>MW2MW3_RBNW1TAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 00:30:00V-SA000645.05-7002026/09/03 02:08:47LORVS_HEY_600_TESTS:V_700_HY_TESTTAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 00:30:00VIC1-NSW10001397.0902026/09/03 02:08:47LORV^^N_BADP_1N^^V_BADP_1TAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 01:00:00N-Q-MNSP100087.1-1972026/09/03 02:08:47LORN>NIL_LSDUN_NIL_TE_BTAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 01:00:00NSW1-QLD1000708.42-13792026/09/03 02:08:47LORN::Q_BWMP_TNTQ>N-NIL_8L_8MTAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 01:00:00T-V-MNSP1-43800456-4382026/09/03 02:08:47LORTVBL_NIL_DYNVTBL_NILTAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 01:00:00V-S-MNSP1000165.3-85.522026/09/03 02:08:47LORS>NIL_NWRB2_NWRB1S>>MW2MW3_RBNW1TAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 01:00:00V-SA000646.62-7002026/09/03 02:08:47LORVS_HEY_600_TESTS:V_700_HY_TESTTAS1
DSTPASAINTERCONNECTORSOLN32026/09/03 02:00:002026/09/08 01:00:00VIC1-NSW10001406.2302026/09/03 02:08:47LORV^^N_BADP_1N^^V_BADP_1TAS1
...
CEND OF REPORT1003

RUN_DATETIME,INTERVAL_DATETIME,INTERCONNECTORID,CAPACITYMWFLOW,CAPACITYMARGINALVALUE,CAPACITYVIOLATIONDEGREE,CALCULATEDEXPORTLIMIT,CALCULATEDIMPORTLIMIT,LASTCHANGED,RUNTYPE,EXPORTLIMITCONSTRAINTID,IMPORTLIMITCONSTRAINTID,STUDYREGIONID
"2026/09/03 02:00:00","2026/09/08 00:30:00",NSW1-QLD1,0,0,0,708.42,-1379,"2026/09/03 02:08:47",LOR,N::Q_BWMP_TNT,Q>N-NIL_8L_8M,TAS1
"2026/09/03 02:00:00","2026/09/08 00:30:00",T-V-MNSP1,-438,0,0,456,-438,"2026/09/03 02:08:47",LOR,TVBL_NIL_DYN,VTBL_NIL,TAS1
"2026/09/03 02:00:00","2026/09/08 00:30:00",V-S-MNSP1,0,0,0,163.45,-87.73,"2026/09/03 02:08:47",LOR,S>NIL_NWRB2_NWRB1,S>>MW2MW3_RBNW1,TAS1
"2026/09/03 02:00:00","2026/09/08 00:30:00",V-SA,0,0,0,645.05,-700,"2026/09/03 02:08:47",LOR,VS_HEY_600_TEST,S:V_700_HY_TEST,TAS1
"2026/09/03 02:00:00","2026/09/08 00:30:00",VIC1-NSW1,0,0,0,1397.09,0,"2026/09/03 02:08:47",LOR,V^^N_BADP_1,N^^V_BADP_1,TAS1
"2026/09/03 02:00:00","2026/09/08 01:00:00",N-Q-MNSP1,0,0,0,87.1,-197,"2026/09/03 02:08:47",LOR,N>NIL_LSDU,N_NIL_TE_B,TAS1
"2026/09/03 02:00:00","2026/09/08 01:00:00",NSW1-QLD1,0,0,0,708.42,-1379,"2026/09/03 02:08:47",LOR,N::Q_BWMP_TNT,Q>N-NIL_8L_8M,TAS1
"2026/09/03 02:00:00","2026/09/08 01:00:00",T-V-MNSP1,-438,0,0,456,-438,"2026/09/03 02:08:47",LOR,TVBL_NIL_DYN,VTBL_NIL,TAS1
"2026/09/03 02:00:00","2026/09/08 01:00:00",V-S-MNSP1,0,0,0,165.3,-85.52,"2026/09/03 02:08:47",LOR,S>NIL_NWRB2_NWRB1,S>>MW2MW3_RBNW1,TAS1
"2026/09/03 02:00:00","2026/09/08 01:00:00",V-SA,0,0,0,646.62,-700,"2026/09/03 02:08:47",LOR,VS_HEY_600_TEST,S:V_700_HY_TEST,TAS1
"2026/09/03 02:00:00","2026/09/08 01:00:00",VIC1-NSW1,0,0,0,1406.23,0,"2026/09/03 02:08:47",LOR,V^^N_BADP_1,N^^V_BADP_1,TAS1
...

C,SETP.WORLD,DVD_STPASA_INTERCONNECTORSOLN,AEMO,PUBLIC,2026/10/09,16:34:19,001791527659885,MONTHLY_ARCHIVE,001791527659885
I,STPASA,INTERCONNECTORSOLN,3,RUN_DATETIME,INTERVAL_DATETIME,INTERCONNECTORID,CAPACITYMWFLOW,CAPACITYMARGINALVALUE,CAPACITYVIOLATIONDEGREE,CALCULATEDEXPORTLIMIT,CALCULATEDIMPORTLIMIT,LASTCHANGED,RUNTYPE,EXPORTLIMITCONSTRAINTID,IMPORTLIMITCONSTRAINTID,STUDYREGIONID
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 00:30:00",NSW1-QLD1,0,0,0,708.42,-1379,"2026/09/03 02:08:47",LOR,N::Q_BWMP_TNT,Q>N-NIL_8L_8M,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 00:30:00",T-V-MNSP1,-438,0,0,456,-438,"2026/09/03 02:08:47",LOR,TVBL_NIL_DYN,VTBL_NIL,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 00:30:00",V-S-MNSP1,0,0,0,163.45,-87.73,"2026/09/03 02:08:47",LOR,S>NIL_NWRB2_NWRB1,S>>MW2MW3_RBNW1,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 00:30:00",V-SA,0,0,0,645.05,-700,"2026/09/03 02:08:47",LOR,VS_HEY_600_TEST,S:V_700_HY_TEST,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 00:30:00",VIC1-NSW1,0,0,0,1397.09,0,"2026/09/03 02:08:47",LOR,V^^N_BADP_1,N^^V_BADP_1,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 01:00:00",N-Q-MNSP1,0,0,0,87.1,-197,"2026/09/03 02:08:47",LOR,N>NIL_LSDU,N_NIL_TE_B,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 01:00:00",NSW1-QLD1,0,0,0,708.42,-1379,"2026/09/03 02:08:47",LOR,N::Q_BWMP_TNT,Q>N-NIL_8L_8M,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 01:00:00",T-V-MNSP1,-438,0,0,456,-438,"2026/09/03 02:08:47",LOR,TVBL_NIL_DYN,VTBL_NIL,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 01:00:00",V-S-MNSP1,0,0,0,165.3,-85.52,"2026/09/03 02:08:47",LOR,S>NIL_NWRB2_NWRB1,S>>MW2MW3_RBNW1,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 01:00:00",V-SA,0,0,0,646.62,-700,"2026/09/03 02:08:47",LOR,VS_HEY_600_TEST,S:V_700_HY_TEST,TAS1
D,STPASA,INTERCONNECTORSOLN,3,"2026/09/03 02:00:00","2026/09/08 01:00:00",VIC1-NSW1,0,0,0,1406.23,0,"2026/09/03 02:08:47",LOR,V^^N_BADP_1,N^^V_BADP_1,TAS1
...
C,"END OF REPORT",1003

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 998 MB when zipped, 10 GB as unzipped CSV.

Tip

This table is large. Simply calling pd.read_csv() might fill up all the memory on your laptop. (As a rule of thumb, you need double the amount of memory as the size of the CSV.) You will need to think hard about memory optimisation. e.g. consider using Polars instead of Pandas, and selecting only the columns you care about.

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
STPASA INTERCONNECTORSOLN 3

This means that the CSV files start with metadata columns:

I,STPASA,INTERCONNECTORSOLN,3,...
D,STPASA,INTERCONNECTORSOLN,3,...

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: STPASA_SOLUTION