Wells and wellbores
Well identity, wellbore geometry, surface locations, trajectories, and directional survey stations.
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.
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_KEYSurrogate key for the well row, a stable string composed as {country}:{native_id_type}:{native_id} (e.g. US:API10:4212340567).
- Joins to
SELECT WELL_KEY, COUNTRY, NATIVE_ID_TYPE, NATIVE_ID, OPERATOR_IDFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLLIMIT 10- 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_ stringNORMALIZED - 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_IDcarries 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_idfor 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.
No columns match. Try a shorter word.
WELLBORE
Section titled “WELLBORE”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_KEYSurrogate 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).
- Joins to
WELL_KEYjoinsWELL.WELL_KEYSOURCE_IDjoinsSOURCE.SOURCE_ID
- Joined from
WELL_DETAILWELLBORE_COMPLETION_DESIGNWELLBORE_PRODUCTION_SUMMARYWELLBORE_DECLINE_PARAMETERSWELLBORE_SPACING_DETAILWELLBORE_SUBSURFACE_PROPERTY16 more
WELLBORE_TEST_HISTORYPRODUCTION_MONTHLYPRODUCTION_FORECAST_MONTHLYWELLBORE_TRAJECTORYDIRECTIONAL_SURVEY_STATIONPRODUCTIONWELL_PRODUCTION_SUMMARYWELL_TESTWELL_COMPLETIONFRAC_FOCUS_SUMMARYFRAC_FOCUS_INGREDIENTPRODUCTION_FORECASTPRODUCTION_FORECAST_ARPS_SEGMENTWELL_SPACINGSUBSURFACE_PROPERTYWELL_PERMIT
SELECT WELLBORE_KEY, COUNTRY, NATIVE_ID_TYPE, NATIVE_ID, WELL_KEYFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORELIMIT 10- 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_idcarries 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_ stringNORMALIZED - 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 inWELLBORE_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_NORMALIZEDandPRIMARY_STREAMuse 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_reportedbut for a specific lateral / sidetrack / re-entry).More
Independent input from
well.status_reported, wellbore status can differ from well status. - STATUS_
REPORTED_ stringNORMALIZED - 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_TVDandLATERAL_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 thenLATERAL_LENGTH_SOURCEis NULL too. - LATERAL_
LENGTH_ numberftCALCULATED_ PERF - 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_ numberftCALCULATED_ LP_ TO_ BHL - 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_ numberftCALCULATED_ KP_ TO_ BHL - 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_ numberftCALCULATED_ MD_ TVD - 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_ numberftCALCULATED_ SHL_ BHL - 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_ numberdegLONGITUDE - 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_ stringNORMALIZED - 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_ stringNORMALIZED - 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_HORIZONTALwhen 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 inDIRECTION_REPORTED. - WELLBORE_
LATERAL_ integerftLENGTH - 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_BHLfor that measurement, orLATERAL_LENGTHfor 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_LENGTHis 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 useWELLBORE_TYPE_NORMALIZED= 'PRODUCER' ANDPRIMARY_STREAMIN ('GAS', 'OIL_AND_GAS', 'CBM');OIL_AND_GASis 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 thenWELLBORE_TYPE_NORMALIZEDis NULL. NULL when the source does not establish a stream. - LATERAL_
LENGTH_ numberftCALCULATED_ U_ TURN - 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_ booleanAVAILABLE - 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_ stringDRILLED_ SURVEY - 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_AVAILABLEis false or NULL, which includes every Canadian wellbore. - WELLBORE_TYPEstring
- The wellbore's declared operational function.
More
It equals
WELLBORE_TYPE_NORMALIZEDand has the same values, meaning and limits; read that column's description. NULL whereverWELLBORE_TYPE_NORMALIZEDis NULL. - BASIN
- Basin name (e.g., Permian, Eagle Ford).
- SUBBASIN
- Subbasin name (e.g., Delaware, Midland).
- SOURCE_ID
- Foreign key to
source.source_idfor 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.
No columns match. Try a shorter word.
SURFACE_LOCATION
Section titled “SURFACE_LOCATION”Surface location and legal description for a well.
- Joins to
WELL_KEYjoinsWELL.WELL_KEYSOURCE_IDjoinsSOURCE.SOURCE_ID
SELECT SURFACE_LOCATION_ID, WELL_KEY, LATITUDE, LONGITUDE, CRSFROM NOVI_DATA_ACCESS.NOVI_WELLS.SURFACE_LOCATIONLIMIT 10- SURFACE_LOCATION_IDinteger
- Stable, immutable unique identifier for this surface location record.
- WELL_KEYstring
- Foreign key to
well.well_keythat 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.STATEviaWELL_KEY(orTX_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.STATEfor thisWELL_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.COUNTYfor thisWELL_KEY; the FIPS code is inWELL.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_idfor 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.
No columns match. Try a shorter word.
WELLBORE_TRAJECTORY
Section titled “WELLBORE_TRAJECTORY”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
TRAJECTORY_IDSurrogate key for the trajectory row.
- Joins to
SELECT WELLBORE_KEY, TRAJECTORY_ID, GEOMETRY_WKT, CRS, BASINFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELLBORE_TRAJECTORYLIMIT 10- WELLBORE_KEY
- Foreign key to
wellbore.wellbore_key. - 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_idfor 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.
No columns match. Try a shorter word.
DIRECTIONAL_SURVEY_STATION
Section titled “DIRECTIONAL_SURVEY_STATION”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
SURVEY_STATION_IDSurrogate key for the survey station row.
- Joins to
SELECT WELLBORE_KEY, SURVEY_STATION_ID, STATION_SEQUENCE, MD, TVDFROM NOVI_DATA_ACCESS.NOVI_WELLS.DIRECTIONAL_SURVEY_STATIONLIMIT 10- 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_idfor data lineage. - CREATED_ATtimestamp
- Timestamp the record was created.
- UPDATED_ATtimestamp
- Timestamp of the most recent update.
No columns match. Try a shorter word.