Printed from https://fyi.org.nz./request/29936-please-elucidate-the-proper-interpretation-of-certain-supplied-data-series?unfold=1 on March 10, 2025 10:33

We don't know whether the most recent response to this request contains information or not – if you are Nicky McLean please sign in and let everyone know.

Please elucidate the proper interpretation of certain supplied data series.

Nicky McLean made this Official Information request to Electricity Authority

This request has an unknown status. We're waiting for Nicky McLean to read a recent response and update the status.

From: Nicky McLean

Dear Electricity Authority,
Via your organisation's web site https://www.emi.ea.govt.nz/Wholesale/Dat... there are links to seven sub-directories, each containing monthly data files offering half-hourly data on various aspects of electricity generation and consumption in most of New Zealand. Each file contains data for multiple data series, each identified by a sequence of code letters and digits. A straightforward check finds some 2,311 different name sequences across the various files, though some names appear in more than one sub-directory! Many of these names can be deciphered (hopefully correctly, a separate issue), but the problem here is that other name sequences are unintelligible.

My request therefore is for information that would elucidate the correct interpretation so that the data series may be placed into proper relationships with other data series. For instance, given names A1, A2, A3, and A it might be that A = (A1 + A2 + A3), or, the total "A" action is (A + A1 + A2 + A3), or, these are all variants of the single activity at A.
Instead of more hand-waving generalities, here are specifics on some two hundred and seventeen names whose interpretation is dark to me.
First, a collection of names for which every supplied datum is zero:
ATI2201.MRPL.LINE.DEF.X
GLN0332.NZST.PUNZ.NS01.X
KIN0112.POCO.MEEN.POCG011.X
KAW0111.HEDL.TODD.LF109.X
MAT1101.BOPD.CTCT.LF1.X
KOE1101.TOPE.MERX.GEN1.I
KOE1101.TOPE.MERX.GEN1.X
NMA0331.TPCO.MERX.PNL42.I
NMA0331.TPCO.MERX.PNL42.X
TWH0331.WAIK.MERX.555.I
TWH0331.WAIK.MERX.555.X
WIL0331.CKHK.MERX.MILL01.I
WIL0331.CKHK.MERX.MILL01.X
ASB0661.EASH.CNIR.H01.X
HWB1101.OTPO.GN.TPNZ.kWh.I.F
BRK0331.POCO.GN.TPNZ.kWh.I.F
CUL0661.MPOW.GN.TPNZ.kWh.I.F
WGN0331.POCO.GN.TPNZ.kWh.I.F
WPR0331.MPOW.GN.TPNZ.kWh.I.F
ALB0331.VECT.GN.TPNZ.kWh.I.F
HEN0331.VECT.GN.TPNZ.kWh.I.F
HEP0331.VECT.GN.TPNZ.kWh.I.F
SVL0331.VECT.GN.TPNZ.kWh.I.F
MPE1101.NPOW.GN.TPNZ.kWh.I.F
ARI1102.POCO.GN.TPNZ.kWh.I.F
NWD0661.ORON.GN.TPNZ.kWh.I.F
SDN0331.DUNE.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.I.F
MTO0331.NPOW.GN.TPNZ.kWh.I.F
Second, those whose maximum value is greater than zero but less than one:
ATI2201.MRPL.PLUS.DEF.X
ATI2201.MRPL.EDGE.DEF.X
ATI2201.MRPL.RAWE.DEF.X
MAT1101.BOPD.DEEP.DEF.X
ATI2201.MRPL.AGCL.DEF.X
MAT1101.BOPD.AGCL.DEF.X
MAT1101.BOPD.PION.DEF.X
MAT1101.BOPD.BCPL.DEF.X
MAT1101.BOPD.EDGE.DEF.X
WKM2201.TUAR.GBUG.DEF.X
ATI2201.MRPL.PRME.DEF.X
MAT1101.BOPD.PLUS.DEF.X
WKM2201.TUAR.EDGE.DEF.X
ATI2201.MRPL.YESP.DEF.X
ATI2201.MRPL.PRMH.DEF.X
WKM2201.TUAR.PRME.DEF.X
BPE0331.POCO.CTCT.POCG013.X
ATI2201.MRPL.EMHT.DEF.X
KAW0111.HEDL.PUNZ.LF3.I
KAW0111.HEDL.ELKI.LF3.I
ATI2201.MRPL.PPPP.DEF.X
Third, whose maximum value is one or more, but less than ten:
KAW0111.HEDL.MEEN.LF3.I
CUL0331.MPOW.GN.TPNZ.kWh.I.F
KAW0111.HEDL.PSNZ.LF3.I
ATI2201.MRPL.ECOS.DEF.X
KAW0111.HEDL.TODD.LF3.I
KAW0111.HEDL.TRUS.LF3.I
WKM2201.TUAR.EMHT.DEF.X
WKM2201.TUAR.ECOS.DEF.X
ATI2201.MRPL.SUPE.DEF.X
WKM2201.TUAR.OPHL.DEF.X
MAT1101.BOPD.TAOM.DEF.X
KAW0111.HEDL.ECOT.LF3.I
ATI2201.MRPL.OPHL.DEF.X
MAT1101.BOPD.SUPE.DEF.X
KAW0111.HEDL.MERI.LF3.I
PEN1101.VECT.GN.TPNZ.kWh.I.F
WKM2201.TUAR.SELS.DEF.X
MAT1101.BOPD.PPPP.DEF.X
MAT1101.BOPD.PRME.DEF.X
WKM2201.TUAR.SUPE.DEF.X
EDN0331.TPCO.GN.TPNZ.kWh.I.F
KAW0111.HEDL.GENE.LF3.I
ATI2201.MRPL.CLUB.DEF.X
WKM2201.TUAR.HNET.DEF.X
ATI2201.MRPL.HNET.DEF.X
MAT1101.BOPD.SIMP.DEF.X
ATI2201.MRPL.RERL.DEF.X
WKM2201.TUAR.YESP.DEF.X
ATI2201.MRPL.EDNZ.DEF.X
MAT1101.BOPD.OPHL.DEF.X
MAT1101.BOPD.HNET.DEF.X
MAT1101.BOPD.CLUB.DEF.X
ATI2201.MRPL.WISE.DEF.X
MAT1101.BOPD.PRMH.DEF.X
Fourth, whose maximum value is ten or more but less than a hundred:
MAT1101.BOPD.LODE.DEF.X
MAT1101.BOPD.SELS.DEF.X
WRK0331.HAWK.MEEN.R3M.I
BAL0331.OTPO.GN.TPNZ.kWh.I.F
MAT1101.BOPD.FOGY.DEF.X
KAW0111.HEDL.ECOT.LF3.X
WKM2201.TUAR.SIMP.DEF.X
WKM2201.TUAR.FLCK.DEF.X
MAT1101.BOPD.FLCK.DEF.X
ATI2201.MRPL.GBUG.DEF.X
HOR0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.FOGY.DEF.X
WRK0331.HAWK.GENE.R3M.X
MTO0331.NPOW.NPGL.G4.I
KAW0111.HEDL.SWCH.LF3.X
ATI2201.MRPL.FOGY.DEF.X
ATI2201.MRPL.FLCK.DEF.X
KAW0111.HEDL.PSNZ.LF3.X
WRK0331.HAWK.GENH.R3M.I
WRK0331.HAWK.MERI.R3M.I
WKM2201.TUAR.IDPL.DEF.X
ATI2201.MRPL.SELS.DEF.X
ATI2201.MRPL.SIMP.DEF.X
WRK0331.HAWK.CTCT.R3M.I
MAT1101.BOPD.GBUG.DEF.X
OAM0331.WATA.GN.TPNZ.kWh.I.F
KAW0111.HEDL.ELKI.LF3.X
MAT1101.BOPD.TASP.DEF.X
RDF0331.HAWK.TRUS.H3H.X
ATI2201.MRPL.IDPL.DEF.X
KAW0111.HEDL.GEOL.LF3.X
WKM2201.TUAR.ECOT.DEF.X
KAW0111.HEDL.GBUG.LF3.X
WKM2201.TUAR.ELKI.DEF.X
WKM2201.TUAR.SWCH.DEF.X
ATI2201.MRPL.GENH.DEF.X
SBK0661.MPOW.GN.TPNZ.kWh.I.F
WRK0331.HAWK.TODD.R3M.X
WKM2201.TUAR.RERL.DEF.X
WKM2201.TUAR.PSNZ.DEF.X
KAW0111.HEDL.MERI.LF3.X
ATI2201.MRPL.SWCH.DEF.X
ATI2201.MRPL.BOPE.DEF.X
ATI2201.MRPL.ECOT.DEF.X
MAT1101.BOPD.ECOT.DEF.X
MAT1101.BOPD.SWCH.DEF.X
Fifth, whose maximum value is a hundred or more but less than a thousand:
ATI2201.MRPL.PSNZ.DEF.X
KAW0111.HEDL.GENH.LF3.X
MAT1101.BOPD.GEOL.DEF.X
ATI2201.MRPL.EKCI.DEF.X
WKM2201.TUAR.GENH.DEF.X
TMU0111.WAIP.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EZYN.DEF.X
WKM2201.TUAR.PION.DEF.X
ATI2201.MRPL.ELKI.DEF.X
SVL0331.UNET.TRUS.RDVL.X
BRY0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EKCI.DEF.X
ATI2201.MRPL.PION.DEF.X
WKM2201.TUAR.PUNZ.DEF.X
WRK0331.HAWK.SIMP.R3M.X
MAT1101.BOPD.ELKI.DEF.X
SVL0331.UNET.CNIR.RDVL.X
ATI2201.MRPL.PUNZ.DEF.X
WRK0331.HAWK.MEEN.R3M.X
MAT1101.BOPD.PSNZ.DEF.X
KAW0111.HEDL.CTCT.LF3.X
ATI2201.MRPL.EZYN.DEF.X
WKM2201.TUAR.CTCS.DEF.X
ATI2201.MRPL.CTCS.DEF.X
KAW0111.HEDL.PUNZ.LF3.X
MAT1101.BOPD.CTCS.DEF.X
HWB0331.OTPO.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.X.F
WTK0111.WATA.GN.TPNZ.kWh.I.F
WRK0331.HAWK.MERI.R3M.X
WRK0331.HAWK.GENH.R3M.X
KAW0111.HEDL.EZYN.LF3.X
ATI2201.MRPL.GEOL.DEF.X
KAW0111.HEDL.GENE.LF3.X
WKM2201.TUAR.CNIR.DEF.X
MAT1101.BOPD.MERI.DEF.X
WRK0331.HAWK.TRUS.R3H.I
ATI2201.MRPL.CNIR.DEF.X
WPW0331.CHBP.GN.TPNZ.kWh.I.F
KAW0111.HEDL.MEEN.LF3.X
WKM2201.TUAR.GENE.DEF.X
KAW0111.HEDL.TRUS.LF3.X
TUI1101.EAST.GN.TPNZ.kWh.I.F
MAT1101.BOPD.CTCT.DEF.X
ISL0661.ORON.GN.TPNZ.kWh.I.F
MAT1101.BOPD.GENE.DEF.X
MAT1101.BOPD.PUNZ.DEF.X
WPG0331.TRPG.CNIR.DEF.X
RDF0331.HAWK.CTCT.H3H.X
MAT1101.BOPD.MERX.DEF.X
WPR0661.MPOW.GN.TPNZ.kWh.I.F
WPG0331.TRPG.TRUS.DEF.X
ATI2201.MRPL.TODD.DEF.X
Sixth, whose maximum value is more than a thousand
ATI2201.MRPL.GENE.DEF.X
MAT1101.BOPD.MEEN.DEF.X
KAW0111.HEDL.TODD.LF3.X
WKM2201.TUAR.MEEN.DEF.X
WKM2201.TUAR.GEOL.DEF.X
ATI2201.MRPL.NZSP.DEF.X
ATI2201.MRPL.MEEN.DEF.X
WRK0331.HAWK.CTCT.R3M.X
MAT1101.BOPD.CNIR.DEF.X
NPK0331.LINE.GN.TPNZ.kWh.I.F
SFD0331.POCO.GN.TPNZ.kWh.I.F
WKM2201.TUAR.NZSP.DEF.X
WKM2201.TUAR.TODD.DEF.X
WRK0331.HAWK.TRUS.R3N.I
MTO0331.NPOW.NPGL.G4.X
WKM2201.TUAR.CTCT.DEF.X
ATI2201.MRPL.CTCT.DEF.X
RDF0331.HAWK.TRUS.H3H.I
ATI2201.MRPL.MERX.DEF.X
WKM2201.TUAR.MERI.DEF.X
WKM2201.TUAR.MERX.DEF.X
WKM2201.TUAR.TRUS.DEF.X
EDG0331.HEDL.GN.TPNZ.kWh.I.F
ATI2201.MRPL.MERI.DEF.X
ATI2201.MRPL.KING.DEF.X
WKM2201.TUAR.KING.DEF.X
MAT1101.BOPD.GENH.DEF.X
MAT1101.BOPD.TODD.DEF.X
ATI2201.MRPL.TRUS.DEF.X
MAT1101.BOPD.TRUS.DEF.X
MAT1101.BOPD.BOPE.DEF.X
HLY0331.WAIK.GN.TPNZ.kWh.I.F
MAT1101.BOPD.EZYN.DEF.X
The greatest value in this group is 6102·527 (for the last), but the corresponding average is just 118·451. None of these series have negative values.

Most of these name sequences do not identify the unit of measurement; those that do state KWH (in a half-hour) as in the penultimate example. Could it be that units are instead Megawatt-hours? This would cause small numbers to appear, though this would have no effect on the all-zero values. But if not, many of the values are being specified to a fraction of a watt-hour (as for the last example), something surely out-of-place in statistics on the national network where a kilowatt is a small thing. Given that this data collection is given the heading "Metered-Data", one wonders just what meters where are measuring this sort of value, and what it means.
Many name sequences include the text DEF - one could guess a meaning for this, but it would be better to have definite information in place of guesswork, and for the other name parts too.
Since this is all information that you publish, I hope that you also have information on the meaning that you can provide.

Yours faithfully,
Nicky McLean

Link to this

From: Info Electricity Authority
Electricity Authority

Kia ora,
Thankyou for your email, confirming we have received it. 
We will endeavour to respond to your query as soon as we can. 
Kind regards
Electricity Authority Te Mana Hiko
[1][IMG]
 
Level 7, AON Centre, 1 Willis Street
PO Box 10041, Wellington 6143, New Zealand
[2]www.ea.govt.nz
[3][IMG]  [4]linkedin-icon [5]YT-small
"The information contained in this transmission is confidential. It is
intended for the named addressee only. If you are not the named addressee
you may not copy, distribute or take any action in reliance upon this
transmission."

References

Visible links
1. http://www.ea.govt.nz/
2. http://www.ea.govt.nz/
3. https://twitter.com/ElectricityAuth
4. https://www.linkedin.com/company/1451242...
5. https://www.youtube.com/user/ElectricityNZ

Link to this

From: OIA
Electricity Authority

Kia ora Nicky,

Thank you for your request of 30 January 2025, under the Official Information Act 1982, for the following information:

- "Via your organisation's web site https://www.emi.ea.govt.nz/Wholesale/Dat... there are links to seven sub-directories, each containing monthly data files offering half-hourly data on various aspects of electricity generation and consumption in most of New Zealand. Each file contains data for multiple data series, each identified by a sequence of code letters and digits. A straightforward check finds some 2,311 different name sequences across the various files, though some names appear in more than one sub-directory! Many of these names can be deciphered (hopefully correctly, a separate issue), but the problem here is that other name sequences are unintelligible.

My request therefore is for information that would elucidate the correct interpretation so that the data series may be placed into proper relationships with other data series. For instance, given names A1, A2, A3, and A it might be that A = (A1 + A2 + A3), or, the total "A" action is (A + A1 + A2 + A3), or, these are all variants of the single activity at A.
Instead of more hand-waving generalities, here are specifics on some two hundred and seventeen names whose interpretation is dark to me.
First, a collection of names for which every supplied datum is zero:
ATI2201.MRPL.LINE.DEF.X
GLN0332.NZST.PUNZ.NS01.X
KIN0112.POCO.MEEN.POCG011.X
KAW0111.HEDL.TODD.LF109.X
MAT1101.BOPD.CTCT.LF1.X
KOE1101.TOPE.MERX.GEN1.I
KOE1101.TOPE.MERX.GEN1.X
NMA0331.TPCO.MERX.PNL42.I
NMA0331.TPCO.MERX.PNL42.X
TWH0331.WAIK.MERX.555.I
TWH0331.WAIK.MERX.555.X
WIL0331.CKHK.MERX.MILL01.I
WIL0331.CKHK.MERX.MILL01.X
ASB0661.EASH.CNIR.H01.X
HWB1101.OTPO.GN.TPNZ.kWh.I.F
BRK0331.POCO.GN.TPNZ.kWh.I.F
CUL0661.MPOW.GN.TPNZ.kWh.I.F
WGN0331.POCO.GN.TPNZ.kWh.I.F
WPR0331.MPOW.GN.TPNZ.kWh.I.F
ALB0331.VECT.GN.TPNZ.kWh.I.F
HEN0331.VECT.GN.TPNZ.kWh.I.F
HEP0331.VECT.GN.TPNZ.kWh.I.F
SVL0331.VECT.GN.TPNZ.kWh.I.F
MPE1101.NPOW.GN.TPNZ.kWh.I.F
ARI1102.POCO.GN.TPNZ.kWh.I.F
NWD0661.ORON.GN.TPNZ.kWh.I.F
SDN0331.DUNE.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.I.F
MTO0331.NPOW.GN.TPNZ.kWh.I.F
Second, those whose maximum value is greater than zero but less than one:
ATI2201.MRPL.PLUS.DEF.X
ATI2201.MRPL.EDGE.DEF.X
ATI2201.MRPL.RAWE.DEF.X
MAT1101.BOPD.DEEP.DEF.X
ATI2201.MRPL.AGCL.DEF.X
MAT1101.BOPD.AGCL.DEF.X
MAT1101.BOPD.PION.DEF.X
MAT1101.BOPD.BCPL.DEF.X
MAT1101.BOPD.EDGE.DEF.X
WKM2201.TUAR.GBUG.DEF.X
ATI2201.MRPL.PRME.DEF.X
MAT1101.BOPD.PLUS.DEF.X
WKM2201.TUAR.EDGE.DEF.X
ATI2201.MRPL.YESP.DEF.X
ATI2201.MRPL.PRMH.DEF.X
WKM2201.TUAR.PRME.DEF.X
BPE0331.POCO.CTCT.POCG013.X
ATI2201.MRPL.EMHT.DEF.X
KAW0111.HEDL.PUNZ.LF3.I
KAW0111.HEDL.ELKI.LF3.I
ATI2201.MRPL.PPPP.DEF.X
Third, whose maximum value is one or more, but less than ten:
KAW0111.HEDL.MEEN.LF3.I
CUL0331.MPOW.GN.TPNZ.kWh.I.F
KAW0111.HEDL.PSNZ.LF3.I
ATI2201.MRPL.ECOS.DEF.X
KAW0111.HEDL.TODD.LF3.I
KAW0111.HEDL.TRUS.LF3.I
WKM2201.TUAR.EMHT.DEF.X
WKM2201.TUAR.ECOS.DEF.X
ATI2201.MRPL.SUPE.DEF.X
WKM2201.TUAR.OPHL.DEF.X
MAT1101.BOPD.TAOM.DEF.X
KAW0111.HEDL.ECOT.LF3.I
ATI2201.MRPL.OPHL.DEF.X
MAT1101.BOPD.SUPE.DEF.X
KAW0111.HEDL.MERI.LF3.I
PEN1101.VECT.GN.TPNZ.kWh.I.F
WKM2201.TUAR.SELS.DEF.X
MAT1101.BOPD.PPPP.DEF.X
MAT1101.BOPD.PRME.DEF.X
WKM2201.TUAR.SUPE.DEF.X
EDN0331.TPCO.GN.TPNZ.kWh.I.F
KAW0111.HEDL.GENE.LF3.I
ATI2201.MRPL.CLUB.DEF.X
WKM2201.TUAR.HNET.DEF.X
ATI2201.MRPL.HNET.DEF.X
MAT1101.BOPD.SIMP.DEF.X
ATI2201.MRPL.RERL.DEF.X
WKM2201.TUAR.YESP.DEF.X
ATI2201.MRPL.EDNZ.DEF.X
MAT1101.BOPD.OPHL.DEF.X
MAT1101.BOPD.HNET.DEF.X
MAT1101.BOPD.CLUB.DEF.X
ATI2201.MRPL.WISE.DEF.X
MAT1101.BOPD.PRMH.DEF.X
Fourth, whose maximum value is ten or more but less than a hundred:
MAT1101.BOPD.LODE.DEF.X
MAT1101.BOPD.SELS.DEF.X
WRK0331.HAWK.MEEN.R3M.I
BAL0331.OTPO.GN.TPNZ.kWh.I.F
MAT1101.BOPD.FOGY.DEF.X
KAW0111.HEDL.ECOT.LF3.X
WKM2201.TUAR.SIMP.DEF.X
WKM2201.TUAR.FLCK.DEF.X
MAT1101.BOPD.FLCK.DEF.X
ATI2201.MRPL.GBUG.DEF.X
HOR0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.FOGY.DEF.X
WRK0331.HAWK.GENE.R3M.X
MTO0331.NPOW.NPGL.G4.I
KAW0111.HEDL.SWCH.LF3.X
ATI2201.MRPL.FOGY.DEF.X
ATI2201.MRPL.FLCK.DEF.X
KAW0111.HEDL.PSNZ.LF3.X
WRK0331.HAWK.GENH.R3M.I
WRK0331.HAWK.MERI.R3M.I
WKM2201.TUAR.IDPL.DEF.X
ATI2201.MRPL.SELS.DEF.X
ATI2201.MRPL.SIMP.DEF.X
WRK0331.HAWK.CTCT.R3M.I
MAT1101.BOPD.GBUG.DEF.X
OAM0331.WATA.GN.TPNZ.kWh.I.F
KAW0111.HEDL.ELKI.LF3.X
MAT1101.BOPD.TASP.DEF.X
RDF0331.HAWK.TRUS.H3H.X
ATI2201.MRPL.IDPL.DEF.X
KAW0111.HEDL.GEOL.LF3.X
WKM2201.TUAR.ECOT.DEF.X
KAW0111.HEDL.GBUG.LF3.X
WKM2201.TUAR.ELKI.DEF.X
WKM2201.TUAR.SWCH.DEF.X
ATI2201.MRPL.GENH.DEF.X
SBK0661.MPOW.GN.TPNZ.kWh.I.F
WRK0331.HAWK.TODD.R3M.X
WKM2201.TUAR.RERL.DEF.X
WKM2201.TUAR.PSNZ.DEF.X
KAW0111.HEDL.MERI.LF3.X
ATI2201.MRPL.SWCH.DEF.X
ATI2201.MRPL.BOPE.DEF.X
ATI2201.MRPL.ECOT.DEF.X
MAT1101.BOPD.ECOT.DEF.X
MAT1101.BOPD.SWCH.DEF.X
Fifth, whose maximum value is a hundred or more but less than a thousand:
ATI2201.MRPL.PSNZ.DEF.X
KAW0111.HEDL.GENH.LF3.X
MAT1101.BOPD.GEOL.DEF.X
ATI2201.MRPL.EKCI.DEF.X
WKM2201.TUAR.GENH.DEF.X
TMU0111.WAIP.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EZYN.DEF.X
WKM2201.TUAR.PION.DEF.X
ATI2201.MRPL.ELKI.DEF.X
SVL0331.UNET.TRUS.RDVL.X
BRY0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EKCI.DEF.X
ATI2201.MRPL.PION.DEF.X
WKM2201.TUAR.PUNZ.DEF.X
WRK0331.HAWK.SIMP.R3M.X
MAT1101.BOPD.ELKI.DEF.X
SVL0331.UNET.CNIR.RDVL.X
ATI2201.MRPL.PUNZ.DEF.X
WRK0331.HAWK.MEEN.R3M.X
MAT1101.BOPD.PSNZ.DEF.X
KAW0111.HEDL.CTCT.LF3.X
ATI2201.MRPL.EZYN.DEF.X
WKM2201.TUAR.CTCS.DEF.X
ATI2201.MRPL.CTCS.DEF.X
KAW0111.HEDL.PUNZ.LF3.X
MAT1101.BOPD.CTCS.DEF.X
HWB0331.OTPO.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.X.F
WTK0111.WATA.GN.TPNZ.kWh.I.F
WRK0331.HAWK.MERI.R3M.X
WRK0331.HAWK.GENH.R3M.X
KAW0111.HEDL.EZYN.LF3.X
ATI2201.MRPL.GEOL.DEF.X
KAW0111.HEDL.GENE.LF3.X
WKM2201.TUAR.CNIR.DEF.X
MAT1101.BOPD.MERI.DEF.X
WRK0331.HAWK.TRUS.R3H.I
ATI2201.MRPL.CNIR.DEF.X
WPW0331.CHBP.GN.TPNZ.kWh.I.F
KAW0111.HEDL.MEEN.LF3.X
WKM2201.TUAR.GENE.DEF.X
KAW0111.HEDL.TRUS.LF3.X
TUI1101.EAST.GN.TPNZ.kWh.I.F
MAT1101.BOPD.CTCT.DEF.X
ISL0661.ORON.GN.TPNZ.kWh.I.F
MAT1101.BOPD.GENE.DEF.X
MAT1101.BOPD.PUNZ.DEF.X
WPG0331.TRPG.CNIR.DEF.X
RDF0331.HAWK.CTCT.H3H.X
MAT1101.BOPD.MERX.DEF.X
WPR0661.MPOW.GN.TPNZ.kWh.I.F
WPG0331.TRPG.TRUS.DEF.X
ATI2201.MRPL.TODD.DEF.X
Sixth, whose maximum value is more than a thousand ATI2201.MRPL.GENE.DEF.X MAT1101.BOPD.MEEN.DEF.X KAW0111.HEDL.TODD.LF3.X WKM2201.TUAR.MEEN.DEF.X WKM2201.TUAR.GEOL.DEF.X ATI2201.MRPL.NZSP.DEF.X ATI2201.MRPL.MEEN.DEF.X WRK0331.HAWK.CTCT.R3M.X MAT1101.BOPD.CNIR.DEF.X NPK0331.LINE.GN.TPNZ.kWh.I.F SFD0331.POCO.GN.TPNZ.kWh.I.F WKM2201.TUAR.NZSP.DEF.X WKM2201.TUAR.TODD.DEF.X WRK0331.HAWK.TRUS.R3N.I MTO0331.NPOW.NPGL.G4.X WKM2201.TUAR.CTCT.DEF.X ATI2201.MRPL.CTCT.DEF.X RDF0331.HAWK.TRUS.H3H.I ATI2201.MRPL.MERX.DEF.X WKM2201.TUAR.MERI.DEF.X WKM2201.TUAR.MERX.DEF.X WKM2201.TUAR.TRUS.DEF.X EDG0331.HEDL.GN.TPNZ.kWh.I.F ATI2201.MRPL.MERI.DEF.X ATI2201.MRPL.KING.DEF.X WKM2201.TUAR.KING.DEF.X MAT1101.BOPD.GENH.DEF.X MAT1101.BOPD.TODD.DEF.X ATI2201.MRPL.TRUS.DEF.X MAT1101.BOPD.TRUS.DEF.X MAT1101.BOPD.BOPE.DEF.X HLY0331.WAIK.GN.TPNZ.kWh.I.F MAT1101.BOPD.EZYN.DEF.X The greatest value in this group is 6102·527 (for the last), but the corresponding average is just 118·451. None of these series have negative values.

Most of these name sequences do not identify the unit of measurement; those that do state KWH (in a half-hour) as in the penultimate example. Could it be that units are instead Megawatt-hours? This would cause small numbers to appear, though this would have no effect on the all-zero values. But if not, many of the values are being specified to a fraction of a watt-hour (as for the last example), something surely out-of-place in statistics on the national network where a kilowatt is a small thing. Given that this data collection is given the heading "Metered-Data", one wonders just what meters where are measuring this sort of value, and what it means.
Many name sequences include the text DEF - one could guess a meaning for this, but it would be better to have definite information in place of guesswork, and for the other name parts too.
Since this is all information that you publish, I hope that you also have information on the meaning that you can provide."

We will endeavour to respond to your request as soon as possible and in any event no later than 28 February, being 20 working days after the day your request was received.

If we are unable to respond to your request by then, we will notify you of an extension of that timeframe.

If you have any queries, please feel free to contact me by emailing [email address].

Kind regards,

Tessa Ballinger (she/her)
Advisor - Communications and Ministerial

Level 7, AON Centre, 1 Willis Street
PO Box 10041, Wellington 6143, New Zealand
http://www.ea.govt.nz/

-----Original Message-----
From: Info Electricity Authority <[email address]>
Sent: Friday, 31 January 2025 9:01 am
To: OIA <[email address]>
Subject: FW: [External] Official Information request - Please elucidate the proper interpretation of certain supplied data series.

Morning,

This Official Information request came through to the infobox - that is the only thing I can work out about this email !

Thanks,
Beth

-----Original Message-----
From: Nicky McLean <[FOI #29936 email]>
Sent: Thursday, 30 January 2025 10:25 pm
To: Info Electricity Authority <[email address]>
Subject: [External] Official Information request - Please elucidate the proper interpretation of certain supplied data series.

Please be careful with this email as it has bypassed our usual Junk Email checks

Dear Electricity Authority,
Via your organisation's web site https://www.emi.ea.govt.nz/Wholesale/Dat... there are links to seven sub-directories, each containing monthly data files offering half-hourly data on various aspects of electricity generation and consumption in most of New Zealand. Each file contains data for multiple data series, each identified by a sequence of code letters and digits. A straightforward check finds some 2,311 different name sequences across the various files, though some names appear in more than one sub-directory! Many of these names can be deciphered (hopefully correctly, a separate issue), but the problem here is that other name sequences are unintelligible.

My request therefore is for information that would elucidate the correct interpretation so that the data series may be placed into proper relationships with other data series. For instance, given names A1, A2, A3, and A it might be that A = (A1 + A2 + A3), or, the total "A" action is (A + A1 + A2 + A3), or, these are all variants of the single activity at A.
Instead of more hand-waving generalities, here are specifics on some two hundred and seventeen names whose interpretation is dark to me.
First, a collection of names for which every supplied datum is zero:
ATI2201.MRPL.LINE.DEF.X
GLN0332.NZST.PUNZ.NS01.X
KIN0112.POCO.MEEN.POCG011.X
KAW0111.HEDL.TODD.LF109.X
MAT1101.BOPD.CTCT.LF1.X
KOE1101.TOPE.MERX.GEN1.I
KOE1101.TOPE.MERX.GEN1.X
NMA0331.TPCO.MERX.PNL42.I
NMA0331.TPCO.MERX.PNL42.X
TWH0331.WAIK.MERX.555.I
TWH0331.WAIK.MERX.555.X
WIL0331.CKHK.MERX.MILL01.I
WIL0331.CKHK.MERX.MILL01.X
ASB0661.EASH.CNIR.H01.X
HWB1101.OTPO.GN.TPNZ.kWh.I.F
BRK0331.POCO.GN.TPNZ.kWh.I.F
CUL0661.MPOW.GN.TPNZ.kWh.I.F
WGN0331.POCO.GN.TPNZ.kWh.I.F
WPR0331.MPOW.GN.TPNZ.kWh.I.F
ALB0331.VECT.GN.TPNZ.kWh.I.F
HEN0331.VECT.GN.TPNZ.kWh.I.F
HEP0331.VECT.GN.TPNZ.kWh.I.F
SVL0331.VECT.GN.TPNZ.kWh.I.F
MPE1101.NPOW.GN.TPNZ.kWh.I.F
ARI1102.POCO.GN.TPNZ.kWh.I.F
NWD0661.ORON.GN.TPNZ.kWh.I.F
SDN0331.DUNE.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.I.F
MTO0331.NPOW.GN.TPNZ.kWh.I.F
Second, those whose maximum value is greater than zero but less than one:
ATI2201.MRPL.PLUS.DEF.X
ATI2201.MRPL.EDGE.DEF.X
ATI2201.MRPL.RAWE.DEF.X
MAT1101.BOPD.DEEP.DEF.X
ATI2201.MRPL.AGCL.DEF.X
MAT1101.BOPD.AGCL.DEF.X
MAT1101.BOPD.PION.DEF.X
MAT1101.BOPD.BCPL.DEF.X
MAT1101.BOPD.EDGE.DEF.X
WKM2201.TUAR.GBUG.DEF.X
ATI2201.MRPL.PRME.DEF.X
MAT1101.BOPD.PLUS.DEF.X
WKM2201.TUAR.EDGE.DEF.X
ATI2201.MRPL.YESP.DEF.X
ATI2201.MRPL.PRMH.DEF.X
WKM2201.TUAR.PRME.DEF.X
BPE0331.POCO.CTCT.POCG013.X
ATI2201.MRPL.EMHT.DEF.X
KAW0111.HEDL.PUNZ.LF3.I
KAW0111.HEDL.ELKI.LF3.I
ATI2201.MRPL.PPPP.DEF.X
Third, whose maximum value is one or more, but less than ten:
KAW0111.HEDL.MEEN.LF3.I
CUL0331.MPOW.GN.TPNZ.kWh.I.F
KAW0111.HEDL.PSNZ.LF3.I
ATI2201.MRPL.ECOS.DEF.X
KAW0111.HEDL.TODD.LF3.I
KAW0111.HEDL.TRUS.LF3.I
WKM2201.TUAR.EMHT.DEF.X
WKM2201.TUAR.ECOS.DEF.X
ATI2201.MRPL.SUPE.DEF.X
WKM2201.TUAR.OPHL.DEF.X
MAT1101.BOPD.TAOM.DEF.X
KAW0111.HEDL.ECOT.LF3.I
ATI2201.MRPL.OPHL.DEF.X
MAT1101.BOPD.SUPE.DEF.X
KAW0111.HEDL.MERI.LF3.I
PEN1101.VECT.GN.TPNZ.kWh.I.F
WKM2201.TUAR.SELS.DEF.X
MAT1101.BOPD.PPPP.DEF.X
MAT1101.BOPD.PRME.DEF.X
WKM2201.TUAR.SUPE.DEF.X
EDN0331.TPCO.GN.TPNZ.kWh.I.F
KAW0111.HEDL.GENE.LF3.I
ATI2201.MRPL.CLUB.DEF.X
WKM2201.TUAR.HNET.DEF.X
ATI2201.MRPL.HNET.DEF.X
MAT1101.BOPD.SIMP.DEF.X
ATI2201.MRPL.RERL.DEF.X
WKM2201.TUAR.YESP.DEF.X
ATI2201.MRPL.EDNZ.DEF.X
MAT1101.BOPD.OPHL.DEF.X
MAT1101.BOPD.HNET.DEF.X
MAT1101.BOPD.CLUB.DEF.X
ATI2201.MRPL.WISE.DEF.X
MAT1101.BOPD.PRMH.DEF.X
Fourth, whose maximum value is ten or more but less than a hundred:
MAT1101.BOPD.LODE.DEF.X
MAT1101.BOPD.SELS.DEF.X
WRK0331.HAWK.MEEN.R3M.I
BAL0331.OTPO.GN.TPNZ.kWh.I.F
MAT1101.BOPD.FOGY.DEF.X
KAW0111.HEDL.ECOT.LF3.X
WKM2201.TUAR.SIMP.DEF.X
WKM2201.TUAR.FLCK.DEF.X
MAT1101.BOPD.FLCK.DEF.X
ATI2201.MRPL.GBUG.DEF.X
HOR0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.FOGY.DEF.X
WRK0331.HAWK.GENE.R3M.X
MTO0331.NPOW.NPGL.G4.I
KAW0111.HEDL.SWCH.LF3.X
ATI2201.MRPL.FOGY.DEF.X
ATI2201.MRPL.FLCK.DEF.X
KAW0111.HEDL.PSNZ.LF3.X
WRK0331.HAWK.GENH.R3M.I
WRK0331.HAWK.MERI.R3M.I
WKM2201.TUAR.IDPL.DEF.X
ATI2201.MRPL.SELS.DEF.X
ATI2201.MRPL.SIMP.DEF.X
WRK0331.HAWK.CTCT.R3M.I
MAT1101.BOPD.GBUG.DEF.X
OAM0331.WATA.GN.TPNZ.kWh.I.F
KAW0111.HEDL.ELKI.LF3.X
MAT1101.BOPD.TASP.DEF.X
RDF0331.HAWK.TRUS.H3H.X
ATI2201.MRPL.IDPL.DEF.X
KAW0111.HEDL.GEOL.LF3.X
WKM2201.TUAR.ECOT.DEF.X
KAW0111.HEDL.GBUG.LF3.X
WKM2201.TUAR.ELKI.DEF.X
WKM2201.TUAR.SWCH.DEF.X
ATI2201.MRPL.GENH.DEF.X
SBK0661.MPOW.GN.TPNZ.kWh.I.F
WRK0331.HAWK.TODD.R3M.X
WKM2201.TUAR.RERL.DEF.X
WKM2201.TUAR.PSNZ.DEF.X
KAW0111.HEDL.MERI.LF3.X
ATI2201.MRPL.SWCH.DEF.X
ATI2201.MRPL.BOPE.DEF.X
ATI2201.MRPL.ECOT.DEF.X
MAT1101.BOPD.ECOT.DEF.X
MAT1101.BOPD.SWCH.DEF.X
Fifth, whose maximum value is a hundred or more but less than a thousand:
ATI2201.MRPL.PSNZ.DEF.X
KAW0111.HEDL.GENH.LF3.X
MAT1101.BOPD.GEOL.DEF.X
ATI2201.MRPL.EKCI.DEF.X
WKM2201.TUAR.GENH.DEF.X
TMU0111.WAIP.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EZYN.DEF.X
WKM2201.TUAR.PION.DEF.X
ATI2201.MRPL.ELKI.DEF.X
SVL0331.UNET.TRUS.RDVL.X
BRY0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EKCI.DEF.X
ATI2201.MRPL.PION.DEF.X
WKM2201.TUAR.PUNZ.DEF.X
WRK0331.HAWK.SIMP.R3M.X
MAT1101.BOPD.ELKI.DEF.X
SVL0331.UNET.CNIR.RDVL.X
ATI2201.MRPL.PUNZ.DEF.X
WRK0331.HAWK.MEEN.R3M.X
MAT1101.BOPD.PSNZ.DEF.X
KAW0111.HEDL.CTCT.LF3.X
ATI2201.MRPL.EZYN.DEF.X
WKM2201.TUAR.CTCS.DEF.X
ATI2201.MRPL.CTCS.DEF.X
KAW0111.HEDL.PUNZ.LF3.X
MAT1101.BOPD.CTCS.DEF.X
HWB0331.OTPO.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.X.F
WTK0111.WATA.GN.TPNZ.kWh.I.F
WRK0331.HAWK.MERI.R3M.X
WRK0331.HAWK.GENH.R3M.X
KAW0111.HEDL.EZYN.LF3.X
ATI2201.MRPL.GEOL.DEF.X
KAW0111.HEDL.GENE.LF3.X
WKM2201.TUAR.CNIR.DEF.X
MAT1101.BOPD.MERI.DEF.X
WRK0331.HAWK.TRUS.R3H.I
ATI2201.MRPL.CNIR.DEF.X
WPW0331.CHBP.GN.TPNZ.kWh.I.F
KAW0111.HEDL.MEEN.LF3.X
WKM2201.TUAR.GENE.DEF.X
KAW0111.HEDL.TRUS.LF3.X
TUI1101.EAST.GN.TPNZ.kWh.I.F
MAT1101.BOPD.CTCT.DEF.X
ISL0661.ORON.GN.TPNZ.kWh.I.F
MAT1101.BOPD.GENE.DEF.X
MAT1101.BOPD.PUNZ.DEF.X
WPG0331.TRPG.CNIR.DEF.X
RDF0331.HAWK.CTCT.H3H.X
MAT1101.BOPD.MERX.DEF.X
WPR0661.MPOW.GN.TPNZ.kWh.I.F
WPG0331.TRPG.TRUS.DEF.X
ATI2201.MRPL.TODD.DEF.X
Sixth, whose maximum value is more than a thousand ATI2201.MRPL.GENE.DEF.X MAT1101.BOPD.MEEN.DEF.X KAW0111.HEDL.TODD.LF3.X WKM2201.TUAR.MEEN.DEF.X WKM2201.TUAR.GEOL.DEF.X ATI2201.MRPL.NZSP.DEF.X ATI2201.MRPL.MEEN.DEF.X WRK0331.HAWK.CTCT.R3M.X MAT1101.BOPD.CNIR.DEF.X NPK0331.LINE.GN.TPNZ.kWh.I.F SFD0331.POCO.GN.TPNZ.kWh.I.F WKM2201.TUAR.NZSP.DEF.X WKM2201.TUAR.TODD.DEF.X WRK0331.HAWK.TRUS.R3N.I MTO0331.NPOW.NPGL.G4.X WKM2201.TUAR.CTCT.DEF.X ATI2201.MRPL.CTCT.DEF.X RDF0331.HAWK.TRUS.H3H.I ATI2201.MRPL.MERX.DEF.X WKM2201.TUAR.MERI.DEF.X WKM2201.TUAR.MERX.DEF.X WKM2201.TUAR.TRUS.DEF.X EDG0331.HEDL.GN.TPNZ.kWh.I.F ATI2201.MRPL.MERI.DEF.X ATI2201.MRPL.KING.DEF.X WKM2201.TUAR.KING.DEF.X MAT1101.BOPD.GENH.DEF.X MAT1101.BOPD.TODD.DEF.X ATI2201.MRPL.TRUS.DEF.X MAT1101.BOPD.TRUS.DEF.X MAT1101.BOPD.BOPE.DEF.X HLY0331.WAIK.GN.TPNZ.kWh.I.F MAT1101.BOPD.EZYN.DEF.X The greatest value in this group is 6102·527 (for the last), but the corresponding average is just 118·451. None of these series have negative values.

Most of these name sequences do not identify the unit of measurement; those that do state KWH (in a half-hour) as in the penultimate example. Could it be that units are instead Megawatt-hours? This would cause small numbers to appear, though this would have no effect on the all-zero values. But if not, many of the values are being specified to a fraction of a watt-hour (as for the last example), something surely out-of-place in statistics on the national network where a kilowatt is a small thing. Given that this data collection is given the heading "Metered-Data", one wonders just what meters where are measuring this sort of value, and what it means.
Many name sequences include the text DEF - one could guess a meaning for this, but it would be better to have definite information in place of guesswork, and for the other name parts too.
Since this is all information that you publish, I hope that you also have information on the meaning that you can provide.

Yours faithfully,
Nicky McLean

-------------------------------------------------------------------

This is an Official Information request made via the FYI website.

Please use this email address for all replies to this request:
[FOI #29936 email]

Is [Electricity Authority request email] the wrong address for Official Information requests to Electricity Authority? If so, please contact us using this form:
https://fyi.org.nz/change_request/new?bo...

Disclaimer: This message and any reply that you make will be published on the internet. Our privacy and copyright policies:
https://fyi.org.nz/help/officers

If you find this service useful as an Official Information officer, please ask your web manager to link to us from your organisation's OIA or LGOIMA page.

-------------------------------------------------------------------

"The information contained in this transmission is confidential. It is intended for the named addressee only. If you are not the named addressee you may not copy, distribute or take any action in reliance upon this transmission."

hide quoted sections

Link to this

From: OIA
Electricity Authority

Attachment Letter to Nicky Mclean 28 Feb 2025.pdf
189K Download View as HTML

Kia ora Nicky,

Thank you for your request of 30 January 2025, under the Official Information Act 1982.

Please find attached the Authority's response. If you have any questions regarding our response, please don't hesitate to contact me.

Kind regards,

Tessa Ballinger (she/her)
Advisor - Communications and Ministerial

Level 7, AON Centre, 1 Willis Street
PO Box 10041, Wellington 6143, New Zealand
http://www.ea.govt.nz/

-----Original Message-----
From: Nicky McLean <[FOI #29936 email]>
Sent: Thursday, 30 January 2025 10:25 pm
To: Info Electricity Authority <[email address]>
Subject: [External] Official Information request - Please elucidate the proper interpretation of certain supplied data series.

Please be careful with this email as it has bypassed our usual Junk Email checks

Dear Electricity Authority,
Via your organisation's web site https://www.emi.ea.govt.nz/Wholesale/Dat... there are links to seven sub-directories, each containing monthly data files offering half-hourly data on various aspects of electricity generation and consumption in most of New Zealand. Each file contains data for multiple data series, each identified by a sequence of code letters and digits. A straightforward check finds some 2,311 different name sequences across the various files, though some names appear in more than one sub-directory! Many of these names can be deciphered (hopefully correctly, a separate issue), but the problem here is that other name sequences are unintelligible.

My request therefore is for information that would elucidate the correct interpretation so that the data series may be placed into proper relationships with other data series. For instance, given names A1, A2, A3, and A it might be that A = (A1 + A2 + A3), or, the total "A" action is (A + A1 + A2 + A3), or, these are all variants of the single activity at A.
Instead of more hand-waving generalities, here are specifics on some two hundred and seventeen names whose interpretation is dark to me.
First, a collection of names for which every supplied datum is zero:
ATI2201.MRPL.LINE.DEF.X
GLN0332.NZST.PUNZ.NS01.X
KIN0112.POCO.MEEN.POCG011.X
KAW0111.HEDL.TODD.LF109.X
MAT1101.BOPD.CTCT.LF1.X
KOE1101.TOPE.MERX.GEN1.I
KOE1101.TOPE.MERX.GEN1.X
NMA0331.TPCO.MERX.PNL42.I
NMA0331.TPCO.MERX.PNL42.X
TWH0331.WAIK.MERX.555.I
TWH0331.WAIK.MERX.555.X
WIL0331.CKHK.MERX.MILL01.I
WIL0331.CKHK.MERX.MILL01.X
ASB0661.EASH.CNIR.H01.X
HWB1101.OTPO.GN.TPNZ.kWh.I.F
BRK0331.POCO.GN.TPNZ.kWh.I.F
CUL0661.MPOW.GN.TPNZ.kWh.I.F
WGN0331.POCO.GN.TPNZ.kWh.I.F
WPR0331.MPOW.GN.TPNZ.kWh.I.F
ALB0331.VECT.GN.TPNZ.kWh.I.F
HEN0331.VECT.GN.TPNZ.kWh.I.F
HEP0331.VECT.GN.TPNZ.kWh.I.F
SVL0331.VECT.GN.TPNZ.kWh.I.F
MPE1101.NPOW.GN.TPNZ.kWh.I.F
ARI1102.POCO.GN.TPNZ.kWh.I.F
NWD0661.ORON.GN.TPNZ.kWh.I.F
SDN0331.DUNE.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.I.F
MTO0331.NPOW.GN.TPNZ.kWh.I.F
Second, those whose maximum value is greater than zero but less than one:
ATI2201.MRPL.PLUS.DEF.X
ATI2201.MRPL.EDGE.DEF.X
ATI2201.MRPL.RAWE.DEF.X
MAT1101.BOPD.DEEP.DEF.X
ATI2201.MRPL.AGCL.DEF.X
MAT1101.BOPD.AGCL.DEF.X
MAT1101.BOPD.PION.DEF.X
MAT1101.BOPD.BCPL.DEF.X
MAT1101.BOPD.EDGE.DEF.X
WKM2201.TUAR.GBUG.DEF.X
ATI2201.MRPL.PRME.DEF.X
MAT1101.BOPD.PLUS.DEF.X
WKM2201.TUAR.EDGE.DEF.X
ATI2201.MRPL.YESP.DEF.X
ATI2201.MRPL.PRMH.DEF.X
WKM2201.TUAR.PRME.DEF.X
BPE0331.POCO.CTCT.POCG013.X
ATI2201.MRPL.EMHT.DEF.X
KAW0111.HEDL.PUNZ.LF3.I
KAW0111.HEDL.ELKI.LF3.I
ATI2201.MRPL.PPPP.DEF.X
Third, whose maximum value is one or more, but less than ten:
KAW0111.HEDL.MEEN.LF3.I
CUL0331.MPOW.GN.TPNZ.kWh.I.F
KAW0111.HEDL.PSNZ.LF3.I
ATI2201.MRPL.ECOS.DEF.X
KAW0111.HEDL.TODD.LF3.I
KAW0111.HEDL.TRUS.LF3.I
WKM2201.TUAR.EMHT.DEF.X
WKM2201.TUAR.ECOS.DEF.X
ATI2201.MRPL.SUPE.DEF.X
WKM2201.TUAR.OPHL.DEF.X
MAT1101.BOPD.TAOM.DEF.X
KAW0111.HEDL.ECOT.LF3.I
ATI2201.MRPL.OPHL.DEF.X
MAT1101.BOPD.SUPE.DEF.X
KAW0111.HEDL.MERI.LF3.I
PEN1101.VECT.GN.TPNZ.kWh.I.F
WKM2201.TUAR.SELS.DEF.X
MAT1101.BOPD.PPPP.DEF.X
MAT1101.BOPD.PRME.DEF.X
WKM2201.TUAR.SUPE.DEF.X
EDN0331.TPCO.GN.TPNZ.kWh.I.F
KAW0111.HEDL.GENE.LF3.I
ATI2201.MRPL.CLUB.DEF.X
WKM2201.TUAR.HNET.DEF.X
ATI2201.MRPL.HNET.DEF.X
MAT1101.BOPD.SIMP.DEF.X
ATI2201.MRPL.RERL.DEF.X
WKM2201.TUAR.YESP.DEF.X
ATI2201.MRPL.EDNZ.DEF.X
MAT1101.BOPD.OPHL.DEF.X
MAT1101.BOPD.HNET.DEF.X
MAT1101.BOPD.CLUB.DEF.X
ATI2201.MRPL.WISE.DEF.X
MAT1101.BOPD.PRMH.DEF.X
Fourth, whose maximum value is ten or more but less than a hundred:
MAT1101.BOPD.LODE.DEF.X
MAT1101.BOPD.SELS.DEF.X
WRK0331.HAWK.MEEN.R3M.I
BAL0331.OTPO.GN.TPNZ.kWh.I.F
MAT1101.BOPD.FOGY.DEF.X
KAW0111.HEDL.ECOT.LF3.X
WKM2201.TUAR.SIMP.DEF.X
WKM2201.TUAR.FLCK.DEF.X
MAT1101.BOPD.FLCK.DEF.X
ATI2201.MRPL.GBUG.DEF.X
HOR0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.FOGY.DEF.X
WRK0331.HAWK.GENE.R3M.X
MTO0331.NPOW.NPGL.G4.I
KAW0111.HEDL.SWCH.LF3.X
ATI2201.MRPL.FOGY.DEF.X
ATI2201.MRPL.FLCK.DEF.X
KAW0111.HEDL.PSNZ.LF3.X
WRK0331.HAWK.GENH.R3M.I
WRK0331.HAWK.MERI.R3M.I
WKM2201.TUAR.IDPL.DEF.X
ATI2201.MRPL.SELS.DEF.X
ATI2201.MRPL.SIMP.DEF.X
WRK0331.HAWK.CTCT.R3M.I
MAT1101.BOPD.GBUG.DEF.X
OAM0331.WATA.GN.TPNZ.kWh.I.F
KAW0111.HEDL.ELKI.LF3.X
MAT1101.BOPD.TASP.DEF.X
RDF0331.HAWK.TRUS.H3H.X
ATI2201.MRPL.IDPL.DEF.X
KAW0111.HEDL.GEOL.LF3.X
WKM2201.TUAR.ECOT.DEF.X
KAW0111.HEDL.GBUG.LF3.X
WKM2201.TUAR.ELKI.DEF.X
WKM2201.TUAR.SWCH.DEF.X
ATI2201.MRPL.GENH.DEF.X
SBK0661.MPOW.GN.TPNZ.kWh.I.F
WRK0331.HAWK.TODD.R3M.X
WKM2201.TUAR.RERL.DEF.X
WKM2201.TUAR.PSNZ.DEF.X
KAW0111.HEDL.MERI.LF3.X
ATI2201.MRPL.SWCH.DEF.X
ATI2201.MRPL.BOPE.DEF.X
ATI2201.MRPL.ECOT.DEF.X
MAT1101.BOPD.ECOT.DEF.X
MAT1101.BOPD.SWCH.DEF.X
Fifth, whose maximum value is a hundred or more but less than a thousand:
ATI2201.MRPL.PSNZ.DEF.X
KAW0111.HEDL.GENH.LF3.X
MAT1101.BOPD.GEOL.DEF.X
ATI2201.MRPL.EKCI.DEF.X
WKM2201.TUAR.GENH.DEF.X
TMU0111.WAIP.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EZYN.DEF.X
WKM2201.TUAR.PION.DEF.X
ATI2201.MRPL.ELKI.DEF.X
SVL0331.UNET.TRUS.RDVL.X
BRY0661.ORON.GN.TPNZ.kWh.I.F
WKM2201.TUAR.EKCI.DEF.X
ATI2201.MRPL.PION.DEF.X
WKM2201.TUAR.PUNZ.DEF.X
WRK0331.HAWK.SIMP.R3M.X
MAT1101.BOPD.ELKI.DEF.X
SVL0331.UNET.CNIR.RDVL.X
ATI2201.MRPL.PUNZ.DEF.X
WRK0331.HAWK.MEEN.R3M.X
MAT1101.BOPD.PSNZ.DEF.X
KAW0111.HEDL.CTCT.LF3.X
ATI2201.MRPL.EZYN.DEF.X
WKM2201.TUAR.CTCS.DEF.X
ATI2201.MRPL.CTCS.DEF.X
KAW0111.HEDL.PUNZ.LF3.X
MAT1101.BOPD.CTCS.DEF.X
HWB0331.OTPO.GN.TPNZ.kWh.I.F
BRB0331.MERI.GG.MERI.kWh.X.F
WTK0111.WATA.GN.TPNZ.kWh.I.F
WRK0331.HAWK.MERI.R3M.X
WRK0331.HAWK.GENH.R3M.X
KAW0111.HEDL.EZYN.LF3.X
ATI2201.MRPL.GEOL.DEF.X
KAW0111.HEDL.GENE.LF3.X
WKM2201.TUAR.CNIR.DEF.X
MAT1101.BOPD.MERI.DEF.X
WRK0331.HAWK.TRUS.R3H.I
ATI2201.MRPL.CNIR.DEF.X
WPW0331.CHBP.GN.TPNZ.kWh.I.F
KAW0111.HEDL.MEEN.LF3.X
WKM2201.TUAR.GENE.DEF.X
KAW0111.HEDL.TRUS.LF3.X
TUI1101.EAST.GN.TPNZ.kWh.I.F
MAT1101.BOPD.CTCT.DEF.X
ISL0661.ORON.GN.TPNZ.kWh.I.F
MAT1101.BOPD.GENE.DEF.X
MAT1101.BOPD.PUNZ.DEF.X
WPG0331.TRPG.CNIR.DEF.X
RDF0331.HAWK.CTCT.H3H.X
MAT1101.BOPD.MERX.DEF.X
WPR0661.MPOW.GN.TPNZ.kWh.I.F
WPG0331.TRPG.TRUS.DEF.X
ATI2201.MRPL.TODD.DEF.X
Sixth, whose maximum value is more than a thousand ATI2201.MRPL.GENE.DEF.X MAT1101.BOPD.MEEN.DEF.X KAW0111.HEDL.TODD.LF3.X WKM2201.TUAR.MEEN.DEF.X WKM2201.TUAR.GEOL.DEF.X ATI2201.MRPL.NZSP.DEF.X ATI2201.MRPL.MEEN.DEF.X WRK0331.HAWK.CTCT.R3M.X MAT1101.BOPD.CNIR.DEF.X NPK0331.LINE.GN.TPNZ.kWh.I.F SFD0331.POCO.GN.TPNZ.kWh.I.F WKM2201.TUAR.NZSP.DEF.X WKM2201.TUAR.TODD.DEF.X WRK0331.HAWK.TRUS.R3N.I MTO0331.NPOW.NPGL.G4.X WKM2201.TUAR.CTCT.DEF.X ATI2201.MRPL.CTCT.DEF.X RDF0331.HAWK.TRUS.H3H.I ATI2201.MRPL.MERX.DEF.X WKM2201.TUAR.MERI.DEF.X WKM2201.TUAR.MERX.DEF.X WKM2201.TUAR.TRUS.DEF.X EDG0331.HEDL.GN.TPNZ.kWh.I.F ATI2201.MRPL.MERI.DEF.X ATI2201.MRPL.KING.DEF.X WKM2201.TUAR.KING.DEF.X MAT1101.BOPD.GENH.DEF.X MAT1101.BOPD.TODD.DEF.X ATI2201.MRPL.TRUS.DEF.X MAT1101.BOPD.TRUS.DEF.X MAT1101.BOPD.BOPE.DEF.X HLY0331.WAIK.GN.TPNZ.kWh.I.F MAT1101.BOPD.EZYN.DEF.X The greatest value in this group is 6102·527 (for the last), but the corresponding average is just 118·451. None of these series have negative values.

Most of these name sequences do not identify the unit of measurement; those that do state KWH (in a half-hour) as in the penultimate example. Could it be that units are instead Megawatt-hours? This would cause small numbers to appear, though this would have no effect on the all-zero values. But if not, many of the values are being specified to a fraction of a watt-hour (as for the last example), something surely out-of-place in statistics on the national network where a kilowatt is a small thing. Given that this data collection is given the heading "Metered-Data", one wonders just what meters where are measuring this sort of value, and what it means.
Many name sequences include the text DEF - one could guess a meaning for this, but it would be better to have definite information in place of guesswork, and for the other name parts too.
Since this is all information that you publish, I hope that you also have information on the meaning that you can provide.

Yours faithfully,
Nicky McLean

-------------------------------------------------------------------

This is an Official Information request made via the FYI website.

Please use this email address for all replies to this request:
[FOI #29936 email]

Is [Electricity Authority request email] the wrong address for Official Information requests to Electricity Authority? If so, please contact us using this form:
https://fyi.org.nz/change_request/new?bo...

Disclaimer: This message and any reply that you make will be published on the internet. Our privacy and copyright policies:
https://fyi.org.nz/help/officers

If you find this service useful as an Official Information officer, please ask your web manager to link to us from your organisation's OIA or LGOIMA page.

-------------------------------------------------------------------

"The information contained in this transmission is confidential. It is intended for the named addressee only. If you are not the named addressee you may not copy, distribute or take any action in reliance upon this transmission."

hide quoted sections

Link to this

From: Nicky McLean

Salve, Tessa.
Thank you for the response from Airihi Mahuika, which arrived on the last day of the twenty working days allowance. Perhaps the nice colours took a long time to arrange. The third from last line (in Appendix A) declared DEF to stand for DEFault loss code, which means that various speculative and unproductive interpretations can be suppressed, however "should translate to Grid Connected" is not much help, because (aside from the worrying "should"), what isn't connected to the grid?
The schedule of information concerning the meaning of the various codes used in the various data file collections (Embedded, Unit_level, etc.) covers interpretations already made (for the many hundreds of intelligible data series) but it is a little troubling to see repeatedly "Always F = Unknown/Unused/Final?" - surely this should be well understood, so why the alternatives, why the question mark? And codes other than "F" have been encountered too, so their meaning is even less clear.
The Generation_MD data collection contains non-trivial mistakes that have already been described. Further, assigning a fuel type for Huntly is difficult, because the main generation (the four steam turbines, now three) involves burning coal OR natural gas, not just coal so the statement "usefully identify separate fuel types per unit, eg. Huntly" is not so useful, even though a correct attribution over the years would be of interest.
And despite the assertion "always KWh", here and there the original data occasionally employ other units (disregarding "reactive"), but, your organisation seems always to have assumed that the units are KWh (even if the source data actually states otherwise) and therefore asserts that the units are always KWh, and so errors result. I can supply examples, but your organisation declares no interest in these data.

The main point of my request was that despite employing the usual guesswork/interpretation of the various name fields (much as described in Appendix A), many data series names are unintelligible, such as those I explicitly listed. That is, although applying the interpretative suggestions such as Appendix A offers, I cannot relate them to any identifiable entity in the actual world of electricity generation and consumption at actual places, especially when the values being supplied are strange as well. For example, what might be a likely new solar PV farm has data showing generation at night yet not during the day, while consumption is the other way around. Perhaps the codes are wrong? Then, data for the following month were quite different. There has also been excited news media talk about the solar farm's generation manifesting at a distant retirement home (or, being deemed to be thus), so the metering data reflecting this (if they do) might indeed be strange.
Thus, I was hoping for clear descriptions of what these data series represent, but it seems that your organisation has no idea, merely receiving data supplied at the whims of some more puissant data holder, and has no interest in asking them to explain anything. Would they (whoever they are) respond to my queries? Or claim also that they have no knowledge of nor use for the data they supply?
Would your intended new and more wonderful data handling system and its data be fully understood and well organised? The existing situation suggests otherwise.

Your .pdf response as seen at my end offers an e-mail of oix#xx.xxt.nz (read the # as an at-sign) and the link address associated with that text (which is shown in the document underlined and in blue) is mailto:xxx#xx.xxxx.xx Possibly, this is due to some organisational ploy by the FYI website to defend us from spammers and the like.

Vale, Tessa.

Yours sincerely,
Nicky McLean

Link to this

From: OIA
Electricity Authority

Kia ora,
Thank you for contacting us. 

If you are making a request under the Official Information Act 1982, you
can except an official acknowledgement email. If you do not hear from us
within 5 working days, please contact us by calling +64 4 460 8860.

If this is a general enquiry, please email [Electricity Authority request email].

Ngā mihi,

Electricity Authority
Te Mana Hiko
 
Level 7, AON Centre, 1 Willis Street
PO Box 10041, Wellington 6143, New Zealand
[1]www.ea.govt.nz
"The information contained in this transmission is confidential. It is
intended for the named addressee only. If you are not the named addressee
you may not copy, distribute or take any action in reliance upon this
transmission."

References

Visible links
1. http://www.ea.govt.nz/

Link to this

We don't know whether the most recent response to this request contains information or not – if you are Nicky McLean please sign in and let everyone know.

Things to do with this request

Anyone:
Electricity Authority only: