RoQC Tools for OpenWorks Data Type/Functionality Footprint


This is a generalised listing of the data types and functionality that are covered by RoQC Tools - split by functional area.

In short, RoQC Tools access every table in OpenWorks.

Data transfer/sync between projects

  • Curve dictionary
  • Curve aliases
  • Any VC_ table content
  • Any R_ table content
  • Any ow_data_dict content
  • Interpreters
  • Stratigraphic columns
  • Surface colours
  • Well templates
  • Public queries
  • 2D Nav data
  • Well lists
  • Fault names
  • Pointsets
  • Fault polygons
  • Grids
  • Log curves
  • CRS
  • Measurement systems

Data/Functionality footprint of Data Management tools

  • CRS - full management, multi-SID, multi-project, CRS translations.
  • Identify, change ownership or delete any interpreted data anywhere in OpenWorks.
  • Manage the 'ownership' of wells (multi-SID, multi-project).
  • Basic data loader to any table.
  • Well Header - comparison, updating or loading from NPD or other sources
    - Global management of country/operator/status/etc, including ALL related tables.
    - Output to GoogleEarth.
  • Pick - data source management (version control)
  • Stratigraphic data - identification and rectification of non standard data(picks/units/strat columns)
    - Auto strip a full strat column and generate a Top-to-Top column.
    - Update the "surf" table with the correct "strat_column_id" for OW2003.12 API.
  • Log data - auto correction of missing curve units
    - Identification and cleanup of non standard ('illegal') logs
    - Move official version to version -1
    - Logs not in aliases
    - List log aliases
    - Auto cleanup of load services.
    - Compare the contents of an OW project against POSC (Energistics)
  • Well depths - shifting of all depth related data to match changes in elev_ref
  • Well UWI - management of well names, inc flipping UWI's and common well names.
  • ACECA data check
  • UID - check and fix inconsistencies between ow_uid_values and all other tables.
  • Deviation data export
  • Lithology - remove all 'repeat' entries
  • List all projects - list all projects on a SID(s)
  • Time/Depth - report and fix time_depth data starting without 0.0.
  • Data type statistics - an Excel report on how many rows per table in OW.
    - List all data created or changed in a project after a certain date.
  • OW Users - List OpenWorks Users, their role and their interpreters.
    - Update (system) user names and their data source ownership in projects and OWSYS.
  • Project compare - compare most interpreted data types between projects (inc. between OW2003 and R5000).
    - Output to GoogleEarth.
  • Security manager - modifies the access to tables in an OpenWorks database.
  • Measurement system - distribution & management, multi-SID, multi-project
  • Curve dictionary - Delete unused/non-standard entries from the curve dictionary.
  • Reference data - manage the contents of the VC_ and R_ tables and data on all tables that reference these.
  • Loading of Markers & Zone Logs from Geoframe

Data/Functionality footprint of G&G tools

  • Picks - Interpret tops at the "lowest" level in hierarchy, and auto add bases and higher levels of the hierarchy.
    - Set the pick_kind attribute for selected picks in project
  • Core data - full management, SPWLA import/export, loading, export, generation of logs from core tables and vise versa.
  • Lithology - curves to computed lithology and vise versa.
  • Grids & Pointsets - full management/editing of grids/pointsets/fault polygons/fault centerlines
  • Interpreted data - full management.
  • Perforation data - export.
  • Position Logs - interpolate any depth along a pos log.
  • Directional survey - Make TVDMSL and DEVIATION curves from directional survey and/or position log.
  • RMS export - exports well data to RMS.
  • Templates - merge two or more StratWorks templates.
    - List the contents of StratWorks templates.
  • Stratigraphic Units - export interpreted picks in a project as units.
    - Check consistency of stratigraphic interpretations against the defined strat columns.
    - Rapid visualisation and editing of strat columns.
  • Curve dictionary - simple query tool to e.g. find all curves that use ms/ft, all MWD curves, or all porosity curves.
  • Log data - list all 'illegal' curves with data needed to fix them.
    - List all 'illegal' log services with data needed to fix them.
    - List/filter logs any way you want.
    - Z-index transformation of curves based on a translation curve (Curve Frame Work Translate).
    - Full management of logging jobs/runs/passes.
    - Full management of service names
    - Change the comments/remark for more than one log curve at a time.
    - Set the resample scheme of curves, based on curve type.
  • Picks - list all 'illegal' picks with data needed to fix them.
  • Picks & Units - detailed pick and/or unit information, including calculated (non stored) info.
  • Production rates - Report production rates based on PLT curves.
  • Prospect outlines - Send prospect outlines to mapdata.
  • Well Formation Test - Reports the results of well formation tests (MDT,RFT,etc).
  • Zone Attribute - Report writer for data stored on the zone attribute table.
  • Petroworks Parameters - Report writer for Petroworks parameters.
  • Fault - fault manager.
  • Horizons - Copy 2D/3D horizons between projects and regions.
    - Horizon manager (OW and *.hts) (no 2D).
    - Clip a horizon file to a polygon.
  • Navigation data - list details of the 2D navigation data, including calculated (non stored) info.
    - Compare 2D navigation data of lines present in different projects, calculate/display differences.
    - Output to GoogleEarth.
  • AVF - check a .avf file and skip any points that will create problems for TDQ.
    - Re-format the Diskos velocity file format to Landmark's .avf format.
  • Fluid contacts - edit and manage fluid contacts (all 3 representations)
    - Generate a report of the fluid contacts in one or more wells.




SSL Comodo