Skip to content
Developers
Get an API token

Wells and wellbores

Well identity, wellbore geometry, surface locations, trajectories, and directional survey stations.

View MarkdownOpen in Claude(opens in a new tab)

Views live in NOVI_DATA_ACCESS.NOVI_WELLS. Column descriptions are from the Wells data dictionary, release 26.4.3. Type is the data model’s logical type, and unit appears where the model declares one. For Snowflake column types, query NOVI_DATA_ACCESS.INFORMATION_SCHEMA.COLUMNS.

23 columns

Canonical identity and slowly changing attributes for a well.

More about this view

This record is the stable anchor used by planning, drilling, production, economics, and forecasting. Lifecycle changes are events in WELL_EVENT, and geometry is in SURFACE_LOCATION.

Key columns
  • WELL_KEY Surrogate key for the well row, a stable string composed as {country}:{native_id_type}:{native_id} (e.g. US:API10:4212340567).
Joins to
Sample query
SELECT WELL_KEY, COUNTRY, NATIVE_ID_TYPE, NATIVE_ID, OPERATOR_ID
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL
LIMIT 10
Columns23
WELL_KEYstring
Surrogate key for the well row, a stable string composed as {country}:{native_id_type}:{native_id} (e.g. US:API10:4212340567).
More

Consistent with this row's country, native_id_type, and native_id.

COUNTRYstring
Two-letter ISO 3166-1 alpha-2 country code where the well is located (e.g., US, CA).
NATIVE_ID_TYPEstring
Identifier scheme of native_id, explicitly restricted to the well-grain schemes API10 or UWI-DLS.
More

API14 is wellbore grain (its borehole/event suffix distinguishes laterals, which would fan one well into multiple well_keys) and PLANNED is wellbore-only, so neither is valid on a well. Second component of well_key.

NATIVE_IDstring
External regulatory identifier at well grain, the well-level root (API10 for US, UWI-DLS for Canada).
More

Must be the canonical form for its scheme (digits-only for API10, the DLS format for UWI-DLS; no hyphens) so one regulatory well maps to one well_key. The scheme is named by native_id_type, which conditionally validates this value's format; this value is the third component of well_key.

OPERATOR_IDinteger
Current operator of record.
More

Historical changes should be captured as events (e.g., OPERATOR_CHANGE) or in a dedicated attribute history.

WELL_NAMEstring
Human-friendly well name (operator or regulatory naming).
More

Use for display; not a key.

COUNTYstring
Name of the county (or parish in Louisiana) where the well is located, as reported (e.g., "Reeves"); a name, never a code.
More

The FIPS code is in COUNTY_CODE. NULL when not reported.

STATEstring
US state (USPS two-letter) or Canadian province/territory (Statistics Canada two-letter) code where the well is located.
FIELD_NAMEstring
Name of the oil/gas field the well is in.
STATUS_REPORTEDstring
Raw reported well status value from the state regulatory agency filing.
STATUS_REPORTED_NORMALIZEDstring
State-reported well status after normalization to a controlled vocabulary.
STATUSstring
Current coarse lifecycle state of the well (derived from events).
More

Includes 7 milestone-based values and 9 regulatory/operational ones; semantic overlaps (e.g. PERMITTED/PERMIT_APPROVED, DRILLING/SPUD, PRODUCING/ACTIVE, SHUT_IN/INACTIVE) are deliberately preserved as distinct values so you can tell which source vocabulary a row came from. Details live in well_event.

LEASE_NUMBERstring
State-issued lease or production-unit identifier for the well as filed with the regulator, verbatim.
More

Not a key: there is no lease table, and it is an identifier rather than the human-readable lease name. Format is state-specific and values compare only within one state: Texas carries the Railroad Commission of Texas (RRC) district and lease number joined by a semicolon (e.g. 08;39152; the semicolon joins district and lease, it is not a list separator; districts can be alphanumeric such as 7B); Oklahoma carries the 14-digit Oklahoma Tax Commission (OTC) production unit number. Exactly one identifier per well; the current assignment only. NULL where the state record carries no lease identifier, which is the case in every state other than Texas and Oklahoma today.

LATEST_OIL_GRAVITYnumberdeg API
Most recent oil API gravity reported for the well, in degrees API.
More

Oil and gas gravities are reported independently and may come from different tests. NULL when none is reported.

LATEST_GAS_GRAVITYnumberSG
Most recent gas specific gravity reported for the well (air = 1.0).
More

Not necessarily from the same test as LATEST_OIL_GRAVITY. NULL when none is reported.

OPERATOR_REPORTEDstring
The well's current operator as reported for the well: a name, not resolved to an OPERATOR row (OPERATOR_ID carries the resolved operator).
More

May hold a placeholder where no operator is assigned. A current value, not a history. NULL where no operator is reported.

OPERATOR_ORIGINALstring
The well's operator as of first production: a name, not resolved to an OPERATOR row.
More

It does not change when the well later changes operator. NULL where no original operator is recorded.

COUNTY_CODEstring
Five-digit FIPS code of the county (or parish in Louisiana) where the well is located (e.g., "48389" for Reeves County, Texas).
More

The name is in COUNTY.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_ATtimestamp
Timestamp the well record was first created in this system (ingest or authoring time).
UPDATED_ATtimestamp
Timestamp of the most recent update to this well record.
49 columns

A specific bore/lateral associated with a well.

More about this view

One well can have multiple wellbores (laterals, sidetracks, re-entries). As-built attributes belong here; time-varying milestones belong in well_event.

Key columns
  • WELLBORE_KEY Surrogate key for the wellbore row, a stable string composed as {country}:{native_id_type}:{native_id}:{sequence_number} (e.g. US:API10:4212340567:0 for US, CA:UWI-DLS:00/02-13-069-09W5/0:0 for Canada).
Sample query
SELECT WELLBORE_KEY, COUNTRY, NATIVE_ID_TYPE, NATIVE_ID, WELL_KEY
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE
LIMIT 10
Columns49
WELLBORE_KEYstring
Surrogate key for the wellbore row, a stable string composed as {country}:{native_id_type}:{native_id}:{sequence_number} (e.g. US:API10:4212340567:0 for US, CA:UWI-DLS:00/02-13-069-09W5/0:0 for Canada).
More

Consistent with this row's country, native_id_type, native_id, and sequence_number.

COUNTRYstring
Two-letter ISO 3166-1 alpha-2 country code where the wellbore is located (e.g., US, CA).
More

First component of wellbore_key; matches the parent well.country.

NATIVE_ID_TYPEstring
Identifier scheme of native_id (API10, API14, UWI-DLS, or PLANNED).
More

API14 when a borehole/event suffix is available, otherwise API10 (e.g. single-wellbore wells or API10-only sources), UWI-DLS in Canada, or PLANNED for planned wellbores with no regulatory identifier yet. Second component of wellbore_key.

NATIVE_IDstring
Wellbore-level identifier.
More

For regulatory schemes (API10/API14/UWI-DLS) this is the external regulatory id, API14 captures the sidetrack/event suffix (positions 11-14) that disambiguates per-wellbore borehole+event; the well-level well.native_id carries the well-level root (API10 for US, UWI-DLS for Canada). Use the contiguous 14-digit API14 (digits only, no hyphens). For the PLANNED scheme (planned wellbores with no regulatory id yet) this is the Novi-internal id (planned_well.planned_well_id). The scheme is named by native_id_type, which conditionally validates this value's canonical format per scheme; this value is the third component of wellbore_key.

WELL_KEYstring
Foreign key to well.well_key, linking this wellbore to its parent well.
WELLBORE_TYPE_NORMALIZEDstring
What the wellbore does: its declared operational function, from a controlled vocabulary (PRODUCER, INJECTOR, DISPOSAL, CYCLIC, STORAGE, OBSERVATION_TEST, and drainage and thermal-recovery roles).
More

It is the declared function, not current activity: a plugged or shut-in producer stays PRODUCER, so use STATUS for activity. What the wellbore produces or handles is on PRIMARY_STREAM. Functions other than PRODUCER come only from a recognised filed code in WELLBORE_TYPE_REPORTED; without one (for example, every Texas wellbore) the value is PRODUCER or NULL, so counts of injection, disposal or storage wells are incomplete there. NULL when the source does not establish a function, for example a dry hole (PRIMARY_STREAM = DRY) or a service well whose filing does not say which service.

WELLBORE_TYPE_REPORTEDstring
The well-type code the source supplies for the regulator filing, trimmed and otherwise as filed.
More

Codes, case and spelling vary by jurisdiction; they are not a controlled vocabulary. NULL where the source supplies no code (currently all Texas wellbores and most in Kansas and West Virginia). WELLBORE_TYPE_NORMALIZED and PRIMARY_STREAM use this code where it is recognised and a coarser classification otherwise, so they can hold a value when this column is NULL.

STATUS_REPORTEDstring
Raw reported wellbore status value from the regulator filing, at wellbore grain (analogous to well.status_reported but for a specific lateral / sidetrack / re-entry).
More

Independent input from well.status_reported, wellbore status can differ from well status.

STATUS_REPORTED_NORMALIZEDstring
Reported wellbore status mapped to a controlled vocabulary, at wellbore grain (analogous to well.status_reported_normalized).
More

Distinct from wellbore.status (Novi-curated lifecycle enum); the reported/normalized pair preserves provenance for audit.

STATUSstring
Current lifecycle state for the wellbore (can differ from the well-level status).
MD_TDnumberft
Measured depth at TD in feet.
TVD_TDnumberft
True vertical depth at TD in feet.
LATERAL_LENGTHnumberft
Selected lateral length in feet: a manual override where one exists, otherwise the first populated of LATERAL_LENGTH_CALCULATED_U_TURN, LATERAL_LENGTH_CALCULATED_PERF, LATERAL_LENGTH_CALCULATED_LP_TO_BHL, LATERAL_LENGTH_CALCULATED_KP_TO_BHL, LATERAL_LENGTH_CALCULATED_MD_TVD and LATERAL_LENGTH_CALCULATED_SHL_BHL, in that order.
More

The method varies by row and is named in LATERAL_LENGTH_SOURCE, so values are not comparable across rows without it. Non-additive. NULL when no method yields a value, and then LATERAL_LENGTH_SOURCE is NULL too.

LATERAL_LENGTH_CALCULATED_PERFnumberft
Lateral length in feet from the upper to the lower perforation, the completed (stimulated) interval rather than the drilled one.
More

One of six explicitly named derivations; there is no canonical choice between them. NULL on horseshoe (U-turn) wellbores, where direction_calculated is 'U_TURN_HORIZONTAL': this method is distorted on a reversing path. Where a horseshoe's lateral length is stated, it is in lateral_length_calculated_u_turn, unless it was set manually.

LATERAL_LENGTH_CALCULATED_LP_TO_BHLnumberft
Lateral length in feet between the landing point and the bottom hole, as the difference in measured depth between the two survey stations, the surveyed path along the borehole, not a straight line.
More

NULL on horseshoe (U-turn) wellbores, where direction_calculated is 'U_TURN_HORIZONTAL': this method is distorted on a reversing path. Where a horseshoe's lateral length is stated, it is in lateral_length_calculated_u_turn, unless it was set manually.

LATERAL_LENGTH_CALCULATED_KP_TO_BHLnumberft
Lateral length in feet between the kick-off point and the bottom hole, as the difference in measured depth between the two survey stations.
More

Includes the build section, so it reads longer than lateral_length_calculated_lp_to_bhl and adds no wellbore that column does not already cover. NULL on horseshoe (U-turn) wellbores, where direction_calculated is 'U_TURN_HORIZONTAL': this method is distorted on a reversing path. Where a horseshoe's lateral length is stated, it is in lateral_length_calculated_u_turn, unless it was set manually.

LATERAL_LENGTH_CALCULATED_MD_TVDnumberft
Lateral length in feet from measured depth minus true vertical depth at total depth, clamped at 24,000 ft.
More

A coarse beyond-vertical proxy rather than a survey-based measurement. NULL on horseshoe (U-turn) wellbores, where direction_calculated is 'U_TURN_HORIZONTAL': this method is distorted on a reversing path. Where a horseshoe's lateral length is stated, it is in lateral_length_calculated_u_turn, unless it was set manually.

LATERAL_LENGTH_CALCULATED_SHL_BHLnumberft
Great-circle distance in feet between the surface and bottom hole locations.
More

This is a horizontal DISPLACEMENT, not a lateral length: it includes the vertical and build sections, and on most wellbores where it is the only available derivation the value is under 500 ft. Do not use it as a lateral length without a minimum-length filter. NULL on horseshoe (U-turn) wellbores, where direction_calculated is 'U_TURN_HORIZONTAL': this method is distorted on a reversing path. Where a horseshoe's lateral length is stated, it is in lateral_length_calculated_u_turn, unless it was set manually.

MIDPOINT_LATITUDEnumberdeg
Latitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS.
MIDPOINT_LONGITUDEnumberdeg
Longitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS.
HEELPOINT_LATITUDEnumberdeg
Latitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS.
HEELPOINT_LONGITUDEnumberdeg
Longitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS.
BOTTOM_HOLE_LATITUDEnumberdeg
Latitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS.
BOTTOM_HOLE_LONGITUDEnumberdeg
Longitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS.
KB_ELEVATIONintegerft
Kelly bushing elevation in feet above sea level.
LANDING_POINT_LATITUDEnumberdeg
Latitude of the landing point in decimal degrees, WGS84.
LANDING_POINT_LONGITUDEnumberdeg
Longitude of the landing point in decimal degrees, WGS84.
FORMATION_REPORTEDstring
Formation name as reported by the data source (raw regulatory filing string).
FORMATION_REPORTED_NORMALIZEDstring
Source-reported formation mapped to a controlled vocabulary.
FORMATIONstring
Canonical formation name used for analytics grouping.
More

Represents Novi's best estimate of the landing zone formation.

FORMATION_CALCULATEDstring
Novi-calculated formation based on wellbore geometry and formation tops (structural depth grids).
More

Used as the standard grouping key for peer comparison.

DIRECTION_REPORTEDstring
Raw reported slant/direction value from the state regulatory agency (e.g., "Horizontal", "Directional").
DIRECTION_REPORTED_NORMALIZEDstring
State-reported direction after normalization to a controlled vocabulary.
DIRECTION_CALCULATEDstring
Slant that Novi infers from evidence other than the filed slant, such as the wellbore trajectory.
More

It is derived, not filed.

DIRECTIONstring
Novi's resolved well slant: the first of these that applies.
More

U_TURN_HORIZONTAL when the calculated slant is a U-turn; HORIZONTAL when a directional survey not marked as planned shows a horizontal path; the normalized reported (filed) slant; the calculated slant. For a well whose survey-based resolution is not available, the survey step is skipped and the filed slant comes first. The filed wording is in DIRECTION_REPORTED.

WELLBORE_LATERAL_LENGTHintegerft
Deprecated and no longer maintained: it keeps the value last written before 2026-09-24 and is NULL on wellbores added since, so its coverage shrinks over time.
More

It was a measured-depth difference along the borehole from the landing point (or the kick-off point where no landing point is known) to the bottom hole. Use LATERAL_LENGTH_CALCULATED_LP_TO_BHL for that measurement, or LATERAL_LENGTH for the selected value.

LATERAL_LENGTH_SOURCEstring
Label of the method that produced LATERAL_LENGTH, such as 'Manual Override', 'PerforationTop-PerforationBottom' or 'Landing-Bottom'.
More

Distinguishes methods that share a calculated column, such as landing point to bottom hole and landing point to measured depth. NULL when LATERAL_LENGTH is NULL.

SEQUENCE_NUMBERinteger
Lateral ordinal within the well (0-based; 0 for the first lateral, aligning with API14 borehole/event codes).
More

Required, it is the fourth component of wellbore_key and guarantees wellbore uniqueness when native_id alone does not distinguish laterals (e.g. API10-only multi-lateral wells).

PRIMARY_STREAMstring
What the wellbore produces or handles, as declared, from a controlled vocabulary (OIL, GAS, OIL_AND_GAS, WATER, BRINE, WASTE, HELIUM, CO2, STEAM, BITUMEN, LITHIUM, POTASH, CBM, POLYMER, SOLVENT, AIR, ACID_GAS, DRY).
More

Pairs with WELLBORE_TYPE_NORMALIZED: GAS on a STORAGE or DISPOSAL wellbore is gas stored or disposed of, not produced. For gas producers use WELLBORE_TYPE_NORMALIZED = 'PRODUCER' AND PRIMARY_STREAM IN ('GAS', 'OIL_AND_GAS', 'CBM'); OIL_AND_GAS is a compound value, and coalbed methane wells currently carry GAS. Declared purpose, not observed production: a well declared for oil stays OIL while it dewaters, and the value asserts nothing about volumes. DRY appears only where a filed code classifies the bore as a dry hole, and then WELLBORE_TYPE_NORMALIZED is NULL. NULL when the source does not establish a stream.

LATERAL_LENGTH_CALCULATED_U_TURNnumberft
Lateral length in feet stated for the wellbore as a U-turn (horseshoe) lateral length.
More

Unlike the other lateral_length_calculated_* columns, its measurement basis (endpoints, along-hole or straight-line) is not defined, and the wellbore is not necessarily classified as U-turn. NULL where not stated.

REFRAC_COUNTinteger
Number of refracs (re-stimulations after the original frac) reported for this wellbore's well; 0 when none is reported.
More

Reported by the source, not counted from WELL_EVENT, which carries only the most recent REFRAC event, so a well with a count of 2 or 3 still has one REFRAC event. NULL when no count is reported, which includes every Canadian wellbore.

DIRECTIONAL_SURVEY_AVAILABLEboolean
True when directional survey stations are reported for the wellbore, false when none are.
More

Reported by the source rather than computed from DIRECTIONAL_SURVEY_STATION, so the two can briefly disagree while a new survey loads. NULL when survey coverage is not reported, which includes every Canadian wellbore.

PLANNED_AS_DRILLED_SURVEYstring
Whether the wellbore's directional survey is a planned trajectory (PLANNED) or one measured in the drilled hole (AS_DRILLED), as the source reports it.
More

NULL when DIRECTIONAL_SURVEY_AVAILABLE is false or NULL, which includes every Canadian wellbore.

WELLBORE_TYPEstring
The wellbore's declared operational function.
More

It equals WELLBORE_TYPE_NORMALIZED and has the same values, meaning and limits; read that column's description. NULL wherever WELLBORE_TYPE_NORMALIZED is NULL.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_ATtimestamp
Timestamp the wellbore record was created in this system.
UPDATED_ATtimestamp
Timestamp of the most recent update to this wellbore record.
16 columns

Surface location and legal description for a well.

Sample query
SELECT SURFACE_LOCATION_ID, WELL_KEY, LATITUDE, LONGITUDE, CRS
FROM NOVI_DATA_ACCESS.NOVI_WELLS.SURFACE_LOCATION
LIMIT 10
Columns16
SURFACE_LOCATION_IDinteger
Stable, immutable unique identifier for this surface location record.
WELL_KEYstring
Foreign key to well.well_key that currently references this location.
LATITUDEnumber
Latitude in decimal degrees, WGS84 unless otherwise specified by crs.
LONGITUDEnumber
Longitude in decimal degrees, WGS84 unless otherwise specified by crs.
CRSstring
Coordinate reference system identifier (e.g., 'EPSG:4326').
BLOCK_TOWNSHIPstring
Township-level land identifier, consolidated across survey systems.
More

PLSS: township, range and principal meridian as filed, separated by single spaces (e.g., "10S 62W Indian"): township is the first token, range the second, and the meridian is everything after the second space, which may itself contain spaces ("Sixth Principal", "New Mexico Principal") or be a California meridian code ("MD" Mount Diablo, "SB" San Bernardino, "H" Humboldt, filed beside the spelled-out "Humboldt"); the meridian vocabulary is not normalized. Township + range alone (e.g., "10S 62W") only when the state record carries no meridian. Texas: block number as filed (e.g., "143"), which may contain spaces. The model also defines an Alberta DLS format ("R15 T2 W4"), never returned here because this product carries US wells only. Token count does not identify the survey system: read the jurisdiction from WELL.STATE via WELL_KEY (or TX_SURVEY, which only Texas files), not from this value's shape.

SECTIONstring
Section number within the block/township (~640 acres).
More

Shared across all survey systems (PLSS, Texas, Alberta DLS).

TX_SURVEYstring
Texas only.
More

Original land grant survey name (e.g., "T&STL RR CO"). Null for non-Texas wells.

ABSTRACT_LOTstring
Sub-section subdivision.
More

Texas: abstract number (e.g., "3559"). PLSS: quarter/government lot (e.g., "NENW"). Alberta DLS: legal subdivision (e.g., "14").

STATE
US state (USPS two-letter) or Canadian province/territory (Statistics Canada two-letter) code of the well this location belongs to; the same value as WELL.STATE for this WELL_KEY.
COUNTY
Name of the county (or parish in Louisiana) of the well this location belongs to (e.g., "Reeves"); a name, never a code.
More

The same value as WELL.COUNTY for this WELL_KEY; the FIPS code is in WELL.COUNTY_CODE. NULL when not reported.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_ATtimestamp
Timestamp the location record was created in this system.
UPDATED_ATtimestamp
Timestamp of the most recent update to this location record.
9 columns

Stores a wellbore trajectory as a polyline for spatial analysis (spacing, overlap, inventory sizing, and map visualization).

More about this view

One row per wellbore, the polyline is updated in place as new survey stations are observed or existing stations are corrected. Geometry is stored as WKT LineString in WGS84 (EPSG:4326) unless otherwise specified by crs.

Key columns
Sample query
SELECT WELLBORE_KEY, TRAJECTORY_ID, GEOMETRY_WKT, CRS, BASIN
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_TRAJECTORY
LIMIT 10
Columns9
TRAJECTORY_ID
Surrogate key for the trajectory row.
GEOMETRY_WKT
Wellbore trajectory as WKT LineString in the specified crs.
CRS
Coordinate reference system identifier (e.g., 'EPSG:4326').
BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_AT
Timestamp the trajectory record was created in this system.
UPDATED_AT
Timestamp of the most recent update to this trajectory record.
19 columns

Station-level directional survey data for a wellbore.

More about this view

One row per survey station along the wellbore path, ordered by measured depth from surface to TD. Stations capture inclination, azimuth, TVD, and spatial offsets at each survey point. Used for wellbore trajectory reconstruction, spacing analysis, and subsurface mapping.

Key columns
Sample query
SELECT WELLBORE_KEY, SURVEY_STATION_ID, STATION_SEQUENCE, MD, TVD
FROM NOVI_DATA_ACCESS.NOVI_WELLS.DIRECTIONAL_SURVEY_STATION
LIMIT 10
Columns19
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
SURVEY_STATION_IDinteger
Surrogate key for the survey station row.
More

Deterministic and stable across reloads, and unique per station of a wellbore's combined trajectory: a shared pilot section copied into several wellbores' trajectories yields a distinct key in each.

STATION_SEQUENCEinteger
Ordinal of this station within the wellbore's combined trajectory, 1-based (1 = the first, shallowest station) and ascending with measured depth.
More

Because a wellbore has at most one combined trajectory, the per-wellbore and per-survey orderings are the same.

MDnumberft
Measured depth of this survey station in feet.
TVDnumberft
True vertical depth of this survey station in feet.
SUB_SEA_TVD_CALCULATEDnumberft
Novi-calculated sub-sea true vertical depth at this survey station, in feet.
More

Negative values are above sea level.

INCLINATIONnumberdeg
Inclination angle at this station in degrees (0 = vertical, 90 = horizontal).
AZIMUTHnumberdeg
Azimuth bearing at this station in degrees from north, 0 to 360 inclusive.
More

0 and 360 both denote due north; treat them as equal when comparing or grouping bearings. Non-additive.

NS_OFFSETnumberft
North-South offset from wellhead in feet.
More

Northbound is positive, southbound is negative.

EW_OFFSETnumberft
East-West offset from wellhead in feet.
More

Eastbound is positive, westbound is negative.

LOCATION_TYPEinteger
Type of survey point: -1=furthest point of a U-turn (horseshoe) lateral, 0=other, 1=wellhead, 2=bottom hole, 3=kickoff point, 4=landing point, 5=perforation top, 6=perforation bottom, 7=midpoint.
More

The same code system is used by subsurface_property.location_type, so the two can be compared directly.

LATITUDEnumberdeg
Latitude of this survey station in decimal degrees, WGS84.
LONGITUDEnumberdeg
Longitude of this survey station in decimal degrees, WGS84.
INTERPOLATEDboolean
True if any value on this station row was interpolated rather than read from the source survey, a row or page missing from the filed survey, or a section that could not be read by OCR, with the intervening points computed.
More

False when every value on the row came from the source. Row-level and deliberately coarse: it does not identify which value was interpolated, so a consumer needing confidence in the station's position specifically (spacing analysis) cannot separate an interpolated coordinate from an interpolated formation.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_ATtimestamp
Timestamp the record was created.
UPDATED_ATtimestamp
Timestamp of the most recent update.