As part of data quality improvement program the main goals were the registration of the laying date of the dis-tribution cables of the low voltage network. STEDIN B.V.
Stedin – a subsidiary of Eneco Holding – operates and maintain a significant public utility network database in the Netherlands, including gas network, high-, medium-, and low voltage electric network, district-heating and telecommunication network.

The main purpose of the project was to register the laying date of the distribution cables of the low voltage network and also the way how it was determined. An important role in the project was also to create audit trail log for the whole procedure containing the pro-cess steps, used data and also the decisions that were taken. The project aim was to bring up network quality and providing high quality data.
In this project we had to complete the following subtasks:

  • creating a database to the graphical files of the main line’s network and house connection in Microstation/Oracle environment,
  • creating the database of the main line’s network and house connection from source data
  • providing analyses and statistics
  • making reports of the results

14.6% of the processed electric network belonged to the house connection network, the rest were the main lines. The processing was done with different methods. The main line network was displayed on registry maps in Microstation environment. The data of the house connections were stored in two different, consumer address based databases. The databases could be connected to the address related coordinates of the topological map (Dutch base map: GBKN). The database of the electricity network in Microstation environment and Oracle system was created with the help of the Geometria developed software.

During the determination of the laying date we completed the below tasks:

  • creating Oracle database from alphanumeric and graphic data
  • automatic and manual connection of alphanumeric and graphic data of substations and switching stations
  • creating network topology, correcting graphical errors
  • quality enhancement and completion of alphanumeric data,
  • projection of substation and switching station data on the main line network, network tracing
  • projection of house connection data on the power lines with automatic and manual graphical methods
  • network tracing for the house connection network was completed separately, using a different rule set
  • every laying date that was determined this way was displayed on the map
  • every network tracing and laying date determination (inheritance) method and data was stored in a predefined, complex structured log file. With the help of the log files the source of the determined laying date can be tracked

To achieve proper results, the automatic processing in Oracle used a predefined rule set and multilevel iteration. The alphanumeric and graphic changes were stored in separate ‘history’ tables. The result of the final iteration also contained the id number of the applied rule. The project started in April 2010 and finished in October 2010.


  • STEDIN fulfilled the regulation of the Dutch Council of Energy in data expansion/enhancement
  • The product supports the data clean-ing in the later migration process


  • 253 440 line segments, 11 198,369 km of network processed
  • 195 096 active line segment laying dates registered
  • 253 810 line objects processed
  • 539 918 house connection data projected