New dataset on EMI – Data on metering configurations

  • 3.3K Views
  • Last post 28 October 2019
Matthew Keir posted this 02 October 2016

Agents, third parties, and new entrant retailers have asked for information about metering configurations at ICPs throughout the country. These parties are investing in systems and processes, and it’s helpful for them to know all of the options up front rather than discovering each unique configuration one-by-one as they engage with consumers or use the ICP connection data API.

We’ve released a file detailing unique metering configurations at ICPs and the number of ICPs with each configuration. This information is provided at meter register level for any active meter in the registry at any installation at active ICPs. The register information is provided as a space delimited list with energy flow direction, register content code, and period of availability. More information can be found in the registry functional specification.

The file will be updated and released with other retail reports each month. As with all files in the datasets folders, they are also accessible via our FTP site.

  • Liked by
  • jofajafa
  • JessielGonzalez
Order by: Standard | Newest | Votes
msouness posted this 28 October 2019

Relocated meter register conversation to new discussion

 

  • Liked by
  • Matthew Keir
  • jofajafa
msouness posted this 01 October 2019

Great to see significant improvement of register content codes:

  56 I Flow non- EG (or 730x)

  374 I flow EG with less than 24h

  148 X flow EG24

  70 X flow non uncontrolled with 24h

  161 0h registers

However IN24 is still substantial at 316,902 registers.

  • Liked by
  • jofajafa
jofajafa posted this 20 June 2019

"Anyone have a good reason for the content code EG20 to be in Registry?"

It's disappointing that not only has the morass of legacy CC/POA combinations - many combinations of which as Malcolm has demonstrated are nonsensical - not been tidied up, but there apparently are no validation rules to limit the creation of new redundant combinations.

  • Liked by
  • msouness
msouness posted this 19 June 2019

Anyone have a good reason for the content code EG20 to be in Registry?  

msouness posted this 23 October 2018

Just been working through some serial number missmatches - found some Exponents. One MEP had three exponents as serial numbers, but are now fixed in registry.

Matthew Keir posted this 11 October 2018

Hi Malcolm,

Thanks for the note.

Just to be clear where this conversion issue is occurring - are you suggesting MEPs are populating the registry with serial numbers after opening in excel, and that what is causing this issue?

We're still pushing for improvements to reduce incompatible meter configuration information.

Matthew

 

 

 

  • Liked by
  • msouness
msouness posted this 11 October 2018

It may pay for some of the MEP's to take a look through their serial numbers to identify data type conversion to exponents due to excel's treatment of large integers.  

2.61E+11 (IN), 2.62E+11 (IN)

msouness posted this 24 August 2018

Interesting to see there are

138 residential ICPs with "X" flow EG meter registers

107 residential ICPs with "I" flow UN meter registers

 

 

Matthew Keir posted this 28 February 2018

Sorry - the heading I used may mean you missed it. See point two in the "Changes to datasets on EMI – NSP table, metering configurations, market structure and shape files" discussion.

msouness posted this 28 February 2018

- found it 

https://www.emi.ea.govt.nz/Retail/Datasets/MarketStructure/ICPandMeteringDetails

 

msouness posted this 28 February 2018

Hi Matt,

Is there a new location for the meter configuration dataset?

  • Liked by
  • jofajafa
Matthew Keir posted this 25 October 2017

Hi Clive,

Thank you for making us aware of this. The September files are now available.

We had a small issue occur in our data warehouse that happened to coincide with the automated processing that runs after the 10th business day each month. We hadn’t realised this had impacted any published files. This issue impacted all the monthly files published in retail datasets, not only the metering configurations file.

One of the reasons EMI exists is to support users to provide informed consultation responses. It’s great to hear that you’re making use of this information in this way.

To be clear, the files are published after the 10th business day - this is not always the 15th of each month.

Cheers,

Matthew

 

  • Liked by
  • jofajafa
  • Clive Gifford
Clive Gifford posted this 25 October 2017

Can one of the Authority staff please explain why there is no October update of the metering configurations file published yet.

Has this been delayed or postponed, perhaps wishing to avoid the effects of "garbage in, garbage out" as alluded to in the submission I made concerning register content codes, including thousands of non-existent meters and their associated register content codes, at least on TLC's network?

As of today, 26 October 2017, the last update was on 15 September. I understood an update was published on the 15th of each month.

Thanks.

  • Liked by
  • jofajafa
msouness posted this 08 October 2017

It’s certainly time for some consolidation of register content codes and hours of availability. How many networks cut different tariff rates for different hours of availability for controlled load registers?

  • Liked by
  • jofajafa
jofajafa posted this 29 September 2017

Thanks Nicole, we have submitted. I've taken the Metering Configurations file and reworked it to provide some insights.

Show more posts
Close