Serving GOMCubed from ArcSDE

1
Serving GOM-Cubed from ArcSDE

• Pros Cons of serving GOM3 from ArcSDE
• By
• Robert Graham
• GIS Manager
• 20070419

2
A Little bit about BHP Billiton

• ESRI shop
• GoogleEarth Server
• PetroSys geologic gridding application
• Landmark Seismic interpretation
• Petrel
• Seabed

3
Spatial Database Engine (SDE)

• Measures
• 879 layers (259 raster 620 vector)
• 100Gb of tablespace used
• 214 accounts
• 586 connections per day
• 46 average users per day

• Architecture
• Two tiered Unix system
• Version 9.1
• Shared Oracle resources with Finder OpenWorks

4
Guiding Principles

• Keep the value in the data, not the applications
• Educate users and give them tools, but do not
  dumb down apps for groups of users
• Buy Commercial Off The Shelf (C.O.T.S.) software,
  do not develop in-house software.
• Expand attribute names to give users a clue
• Feedback problems to vendors and contribute to
  industry groups

5
GOM Exploration at BHP Billiton Petroleum
requirements

• Use both ArcGIS and Petrosys and need access to
  consistently the same data from platform
  independent source.
• Publish maps to non-explorers
• Keep maps up-to-date
• Lots of complex labelling
• Needs to search for data with thematic keywords
• Advanced spatial analysis in repeatable models
• Advanced queries using SqlPlus
• Use Databaselinks to query OpenWorks, or Finder,
  or ______

6
Advantages of SDE vs. shapefiles

• Single point of access
• Finer security control
• Metadata searches
• Sqlplus queries
• Higher availability
• Expanded column names
• Descriptions in Petrosys
• Databaselinks
• Sdegroup
• Feature Linked annotation
• Less likely to be duplicated

7
What more can ESA put into SDE

• All the tables
• 3rd party Paleo data reports
• Production data
• Bathymetry grid
• State blocks
• Sale 181
• Proposed districts
• MMS Blocks
• Royalty lines areas
• Well log locations
• Log files
• Blocks available for next lease sale

8
What new functionality can ESA add to GoM-Cubed

• Put it in PowerPoint button
• Complex pre-built annotations
• Pre-built War Map
• Export to ZGF
• Travelling laptop using replication
• Metadata
• Metadata
• Metadata
• Weather data
• Real-time updates of drill ships

9
Serving GOM-Cubed from ArcSDE

• Pros Cons of serving GOM3 from ArcSDE
• By
• Robert Graham
• GIS Manager
• 20070419