Download - Upstream Leases
Upstream Leases
© Upstream Information Management- GiS Team
Upstream GIS Group
European User Conference - ESRI 2011
Mercedes del RíoAgatha Arauzo
Index
• Background
• Repsol Upstream
• Portfolio Management
• Data
• Information Quality Management
• Coordinates Reference System Management
© Upstream Information Management- GiS Team
• Coordinates Reference System Management
• Upstream Leases Application
• Technology
• Architecture
• Components
• Conclusions
• Future2
Repsol E&P
• The upstream oil sector is a term used to refer to the searching for and the recovery and production of crude oil and natural gas. The upstream oil sector is also known as the exploration and production (E&P) sector. (Wikipedia)
• Includes the searching for potential oil & gas fields, drilling exploratory wells, and operating the wells to bring the crude oil & natural gas to the surface
• Exploration Focussed
© Upstream Information Management- GiS Team
• Exploration Focussed
• Increase Profitability by Optimizing Existing Assets
3
Key Areas Exploration Development Identify Future Growth Areas
Asset / Portfolio Management Risk Identification & Reduction Investment
• Portfolio as main core of E&P
• Repsol Portfolio dept. manages our assets helped by three applications:
Portfolio Management 1
LOPLOP(Opportunity Book)(Opportunity Book)
ULUL(Upstream leases)(Upstream leases)
BAPEBAPE(Exploration portfolio)(Exploration portfolio)
© Upstream Information Management- GiS Team
• Lease data was mainly used and exploited by the departments of Portfolio and Planning
• Previously, lease management based in data types:
• Portfolio Madrid: management and update of the alphanumeric data, e.g. stage dates, commitments, acreage, partners, operator, etc,
• DSI Argentina: update of the geographical data, coordinates that draw the lease polygon according to its CRS.
4
• The need of updating UL application came end of the 2009
• Integrated management of our assets
• Management from Madrid
• “Data Quality” guaranty: validation & verification (errors and abnormalities)
Portfolio Management 2
© Upstream Information Management- GiS Team
abnormalities)
• Obsolete technology: ArcIMS + ArcSDE 9.2. + Oracle 8
• New functionality
• Strict control of CRS to guarantee good positioning and consistency with other applications data
5
• Data Validation, Verification & QC
• Data Revision
• Contact with BU for data validation and approval for correction
• Use of a data model for validation and data loading
• Introduction of master tables in the new application
•
Data Quality Management
© Upstream Information Management- GiS Team
• Countries ISO 3166-1, Companies, Basins
• Data interoperability and consistency with other applications
• Development of a data reception procedure workflow
• Lease Geographic boundary representation – awareness
• Data definition – to avoid terminology ambiguity
• CRS Management
6
• Development and implementation of a Coordinate Reference System (CRS) master so all upstream applications use the same CRS definitions and transformation parameter values
• It follows the OGP (Oil &Gas Producers) recommendations by using the standard libraries defined in the EPSG
CRS Management
© Upstream Information Management- GiS Team
by using the standard libraries defined in the EPSG dataset
• UL and EPSG dataset connexion via API
• Transformation from a local CRS to WGS 84 using ArcGIS server engine
7
EPSG Dataset --- no la mostrare lo explico
• The EPSG Geodetic Parameter Dataset, abbreviated to the EPSG Dataset , is a repository of parameters required to:
• define a coordinate reference system (CRS), which ensures that coordinates describe position unambiguously.
• define transformations and conversions that allow coordinates to be changed from one CRS to another CRS. Transformations and conversions are collectively called coordinate operations.
• The EPSG Dataset is maintained by the OGP Geomatic’s Committee's Geodetic Subcommittee. It conforms to ISO 19111 – Spatial referencing by coordinates. It is distributed in three ways:
© Upstream Information Management- GiS Team
distributed in three ways:
• the EPSG Registry , in full the EPSG Geodetic Parameter Registry, a web-based delivery platform in which the data is held in GML using the CRS entities described in ISO 19136.
• the EPSG Database , in full the EPSG Geodetic Parameter Database, a relational database structure where the entities which form the components of CRS’s and coordinate operations are in separate tables, distributed as an MS Access database;
• in a relational data model as SQL scripts which enable a user to create an Oracle, MySQL, PostgreSQL or other relational database and populate that database with the EPSG Dataset;
Surveying and Positioning Guidance Note Number 7, part 1
Upstream Leases Application - Technology
• Difficulty to make a worldwide layer for leases
• Geographic data loaded in local CRS depending on the country or zone
• No original coordinates stored
• Complex data loading
© Upstream Information Management- GiS Team
• Complex data loading
• GIS data managed by specialist group
• Old style ArcIMS basemap layer
• No support for contract documentation
9
Upstream Leases Application - Technology
• New technology
• SQLServer 2005 – Alphanumeric database
• ArcSDE 9.3 – Geospatial database
• ArcGIS Server 9.3 – Map Server. Flex Viewer
• .Net + Ajax
© Upstream Information Management- GiS Team
• .Net + Ajax
• Expanded GIS functionality
• Load coordinates module
• CRS module
• Mapping
• Other Improvements: Lease sheet, predetermined reports and historical information
10
Upstream Leases Application - Architecture
Business layer
Presentation layerInternet Explorer ClientFlex Viewer
. Net
© Upstream Information Management- GiS Team
Da SQL Server 2005tabase Server
•ArcSDE 9.3
Web & GIS Server
• ArcGIS Server 9.3• IIS
Business layer
11
Data layer
Upstream Leases Application - Components
CRS Manager
© Upstream Information Management- GiS Team 12
Upstream Leases
GIS Manager
Upstream Leases Application
© Upstream Information Management- GiS Team
Upstream Leases Application
© Upstream Information Management- GiS Team
Upstream Leases - Reports
© Upstream Information Management- GiS Team
Upstream Leases - Reports
© Upstream Information Management- GiS Team 16
Upstream Leases - Administration
© Upstream Information Management- GiS Team 17
GIS Module – CRS Manager
XML
© Upstream Information Management- GiS Team 18
Create CRS:• From OGP ID• From a existing CRS• Completely new
Modify CRS
Master tables
• Create a new geodetic parameter dataset in CRS Master with EPSGassistance, by defining it:
• From an OGP ID
• From an existent geographic coordinates system
• From an existent geographic coordinates system
• As a New CRS
GIS Module – CRS Manager
© Upstream Information Management- GiS Team
• As a New CRS
19
• Modify Transformations stored in CRS Master database
• Add countries to existing CRS
GIS Module – CRS Manager
© Upstream Information Management- GiS Team
EPSG – Geodetic Parameter Dataset E.G. WGS84, OGP ID 4326
GIS Module – CRS Manager
© Upstream Information Management- GiS Team
GIS Module – CRS Manager
© Upstream Information Management- GiS Team 22
GIS Module – GIS Manager
• Allows single loading coordinates through the web application selecting standard CRS and Transformation from the CRS Master depending on the country
• Allows multiple leases loading of coordinates from xls files
• Validates the polygons topology
•
© Upstream Information Management- GiS Team 23
• Transform coordinates from the source CRS to the target CRS (WGS84) by using ArcGIS Server Engine
• Store original coordinates and all the related geodetic parameters in the database
• Create leases polygons into one unique layer
• Visualize the global locations of all leases in a modern Web Viewer
GIS Module – GIS Manager
•Transformation•Validation•Layer Creation
© Upstream Information Management- GiS Team 24
Read CRSLoad original Coordinates & Metadata
WGS84 Coord.
Master tables
GIS Module - GIS Manager
© Upstream Information Management- GiS Team 25
Conclusion
Master tables implementation
UPSTREAM LEASES IMPROVEMENTS
MANAGEMENT QUALITY
© Upstream Information Management- GiS Team
CRS MasterIntegrated UL management
Centralised data management
Real time information
Up to date technology
Feed all applications with the same CRS
Geodetic consistency
Position consistency
Quality and consistency of data
Data completeness & CRS awareness
UL data reception workflow
Implementation of procedures
Implementation of data definitions
Establishment of a data model
Responsible in each BU and WG
Future
• Business Value
• Portfolio applications suit will be interoperable
• Upstream Leases as primary data source - integration with
other GIS, G&G, Perforation, Production applications
• Data organised for new exploration areas
• Real Time Answers
© Upstream Information Management- GiS Team
• Real Time Answers
• Data Usage Increase across the Organisation
• Data model growth possibility
• Use ArcGIS Server 10
27
© Upstream Information Management- GiS Team 28© Dirección Compañía mes año 28© Upstream GIS Group – October 2011