Projects

Power data migration for regions of Tarnów and Jelenia Góra

Power Data Migration for Tauron S.A. was implemented as part of the Integrated Network Property Management System at Tauron S.A. GISonLine completed the process of data migration in two branches of the company: Tarnów and Jelenia Góra. The migration process of electrical power data was a key element of the new GIS system implementation based on ESRI solutions. The existing system in these company branches was based on Smallworld solutions and data migration involved  transfering the entire data on the company’s distribution assets to the new environment, keeping all data, analytical and operational capabilities of the system.

The biggest challenge turned out to be the differences in the data model of both systems, in the so-called two “worlds”: topographic ( map layout 1965 or 1992) and schematic (device schemes in Cartesian layout), data volume and a very short lead time.

We have developed an original methodology for migrating using ETL class software (Extract, Transform and Load) that allows the use of sofisticated converters and guarantees repeatability of the process.

Tauron S.A. – Power data migration for regions of Tarnów and Jelenia Góra
01.
Scope
  • two branches of Tauron S.A. Tarnów and Jelenia Góra
  • 33 000 kilometres of network
  • 8 000 power stations
  • 300 000 poles
  • 180 000 joints
02.
Challenges
  • Differences between GE and ESRI – two “worlds”: topographic (maps in 1965 and 1992 CS) and schema (devices schemes in Cartesian)
  • Differences in data models
03.
Technology
  • ESRI (ArcGIS Desktop10.0, ArcSDE)
  • GE Smallworld
  • Safe Software – FME
  • Python
  • .Net
Gallery of implementation
Related projects
Implementation Services
PKP Energetyka S.A. – Field and document-based network inventory of distribution assets
Utility asset and audit services
Detection of underground infrastructure in Bad Bevensen
Implementation Services
System Integration in PKP Energetyka
GIS Professional Services
Energa Operator S.A. – Migration of electrical power data
Utility asset and audit services
MV Network Inventory along Podłęże-Bochnia railway line
Utility asset and audit services
PilotMaker – Inspections of power grids technical condition
GIS Professional Services
Fiber Optic Network cataloguing for the purposes of the Information Society Development Program of the Podlasie Voivodeship
Utility asset and audit services
Tauron Dystrybucja S.A. – Marking and inventory of MV poles and Transformer Stations
GIS Professional Services
Office of the Marshal of Świętokrzyskie Voivodeship – Delivery of Thematic Databases of Local Government Investments and Ecological Initiatives