etl gissub

CONNECT. TRANSFORM. AUTOMATE.

ETL GISSUB Alessandro da Silva Civil Engineer and GIS Analyst

Summary

1.  ABOUT PETROBRAS 2.  WHAT DOES GEODESY DEPARTMENT DO? 3.  SGO 4.  ETL 5.  GISSUB 6.  IN PROGRESS 7.  QUESTIONS

CONNECT. TRANSFORM. AUTOMATE.

PETROBRAS

PETROBRAS

EXPLORATION AND PRODUCTION

E&P SERVICES

SUBSEA SERVICES UNIT

GEODESY DIVISION

!  PETROBRAS in numbers: •  5th biggest energy company in the world; •  Daily Production: 2.021.000 barrels/day +/- 2%; •  Frota de navios : 242 (56 da Petrobras); •  Dutos: 30.067km (rígidos e flexíveis); •  15 Refineries and 27 plants; •  We are at 28 countries; •  90% of production is from subsea wells. •  12 Vessels installing pipelines 24/7.

GEODESY DEPARTMENT Positioning

Mapping

SGO

!  SGO is a system developed to process, store and share data related to subsea pipelines, equipments and platforms installed by Petrobras.

!  Used for planing and safe execution of all offshore operations, avoiding accidents in facilities and reflexes for people and enviroment.

!  Is CAD based – Started in 1995 (MicroStation).

!  18.500 access in May 2014.

!  Users in more than 300 vessels.

670m

ETL !  Why ETL?

•  Create GIS tools in CAD (Queries, Searchs, Attributes, Topology...) is an arduous task;

•  Keep a CAD based structure updated every day (44 dgn files in Campos Basin – 8 professionals);

•  Backup in DVDs; •  More than one UTM zone; •  Build a structure to GIS systems; •  Data Validation (Geometry, Topology, attributes); •  Interoperability; •  Good data to build good solutions; •  Have more than visualization.

ETL

!  What does the ETL do? •  Extracts data from CAD; •  Transform them, doing all validations and creating

geometries according to each element behavior; •  Loads them into a customized APDM (ArcGIS

Pipeline Data Model – World Standar) Oracle Spatial Database.

ETL

ETL !  Requirements

•  Treat each element (46) separately according to the engineering and connectivity rules (Anchors, Anchor Lines, Pipelines, Platforms, WCTs, Manifolds, Connectors...);

•  Treat Cell elements; •  Improve security; •  Remove Microlines; •  Update the Database every day; •  Leave nothing behind; •  Keep removed features (history); •  Report the errors.

ETL

!  Around 130 rules; !  Some Rules:

•  A regular Anchor connects to an Anchor Line; •  A regular connector is suppose to have at least two

pieces of pipelines; •  A WCT has always to be in a well head; •  A PLET always connects a steel pipeline to a flexible

one; •  There are no lines with less than 1 meter of length; •  Cathodic Protection, in SGO, just in steel pipelines.

ETL

DGN TO FFS - Workbench

Takes 90 minutes to run

ETL

DGN TO FFS Workbench

ETL

Anchor - Workbench

Takes 10 minutes to run

ETL Pipeline - Workbench

Takes 49 minutes to run

GISSUB

IN PROGRESS !  Geometric Network

IN PROGRESS !  Connection among elements – Geometric

Network

IN PROGRESS !  Connecting other databases

IN PROGRESS !  FME SERVER

Thank You!

!  Questions?

!  For more information: !  Alessandro da Silva

ale.silva.fototerra@petrobras.com.br !  Fototerra/Petrobras

CONNECT. TRANSFORM. AUTOMATE.