An optimisation algorithm for matching large scale databases on customers for improved characterisation of electricity consumption

Abstract

This paper presents a method that permits to match customer information from the French DSO Enedis and housing information from the French population census institute INSEE. Our method allows having a list of housings linked to each customer in order to add household and building information to customers. We show with our method improvements in predictions of aggregated load curve indicators compared to the traditional method that averages socio demographic indicators from housing information of the zone covered by measurements. Our results indicate that the proposed algorithm is able to capture efficiently the information of housings in some feeders. This permits to combine the databases of the DSO with external databases that exist from census or other processes. Enriching the information at the level of clients through the proposed automated way is a cost effective approach given the number of customers served by a DSO. This enhanced information can be then the basis to model, analyse and simulate demand in a bottom up approach which can be useful for planning purposes of the distribution networks.

An address-matching algorithm for household-scale databases to enhance electricity demand characterization

“…At such level, structural information could also be combined with nonaddress based matching algorithms, e.g. optimization algorithm for adding socio-economic information [13].…”

Long-term forecast of local electrical demand and evaluation of future impacts on the electricity distribution network

“…INSEE or MAJIC database need to be coupled with Enedis' database in order to simulate the current load curve of a substation or an electrical feeder. Mines Paris Tech therefore developed an efficient method for matching the INSEE and Enedis' residential customers[4]. The MAJIC/Enedis matching is easier than the INSEE/Enedis matching, as it's possible to compare addresses.…”