Table types

Generated from the table-target documents (ophiolite.table-target/1) pinned by this release; do not edit by hand. Ophiolite reads a table as one of the types below. The mapping screen, the server’s checks and Python read the same documents, so they ask for the same things in the same words. A choice that describes the whole table (a unit, a reference) is asked once.

A pre-selected column carries a short caption saying why it was chosen: Stated in the connection settings, Used in your earlier import, Suggested from the column name, Project default or Not stated. A guess is never used until you confirm it.

Wells

Where each well is: one row per well with its identifier, name and surface position.

Column	Required	Holds
Well identifier	required	text, different on every row
Well name	required	text
Surface X	required	number
Surface Y	required	number
Depth	optional	number
Operating organization	optional	text

• Coordinate system of X and Y: one of the coordinate systems on the mapping screen
• Depth unit: Metres, International feet
• Depth type: Measured depth, True vertical depth
• Depth reference: Unknown, Ground level, Kelly bushing, Mean sea level

Well tops

Named depths along a well where a formation or marker begins, one row per top.

Column	Required	Holds
Well	optional	the name or identifier of a well
Top name	required	text
Measured depth	required	number
Vertical depth	optional	number
Source	optional	text

• Depth unit: Metres, International feet, or another short unit
• Depth reference: The same as the well log, Another reference

Deviation survey

The path of a well: measured depth with inclination and azimuth at each station, in increasing depth.

Column	Required	Holds
Well	optional	the name or identifier of a well
Measured depth	required	number
Inclination	required	number from 0 to 180
Azimuth	required	number from 0 up to but not including 360
Vertical depth	optional	number

• Depth unit: Metres, International feet, or another short unit
• Azimuth reference: True north, Grid north, Magnetic north
• Depth datum: free text, up to 128 characters

Points

Points with X, Y, an optional Z and up to sixteen numeric attributes, one row per point.

Column	Required	Holds
X	required	number
Y	required	number
Z	optional	number
Attributes	optional	any number of columns, kept as attributes

• Coordinate system of X and Y: one of the coordinate systems on the mapping screen, or any other EPSG code (EPSG: and 4 to 6 digits)
• Map unit: Metres, International feet, or another short unit
• Value unit: Metres, International feet, Milliseconds, Seconds, or another short unit
• What Z holds: Depth, Elevation, Time
• Positive direction: Up, Down
• Vertical datum: free text, up to 128 characters

Time-depth pairs

Depth and seismic time pairs of one well, both increasing, with an optional velocity.

Column	Required	Holds
Well	optional	the name or identifier of a well
Depth	required	number
Time	required	number
Velocity	optional	number

• Depth measured as: Measured depth, True vertical depth, Vertical depth below sea level
• Depth unit: Metres, International feet, or another short unit
• Time is: One-way time, Two-way time
• Time unit: Milliseconds, Seconds, Microseconds
• Depth datum: free text, up to 128 characters
• Seismic reference elevation: a number

Table

Any table kept as its columns, each with an optional unit, quantity and missing-value marker. This type can be described now; reading it waits for E58b.

• For each column: Unit, Quantity, Missing-value marker

In Python

The same documents are in the Python library, with the sentences a check gives:

from ophiolite import targets

tops = targets.target('well-tops')
print(tops.field_names)
sentence = targets.render('well-tops', {'rows_checked': 5}, {'field': 'well', 'code': 'reference-missing', 'severity': 'invalid', 'rows': 1, 'examples': []}, {})
print(sentence)  # 1 of 5 rows have no well.

From the command line, ophiolite targets lists the types and ophiolite targets well-tops describes one (--json prints its document).