# Wells and wellbores

Source: https://developers.novilabs.com/data/tables/wells/

> 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`.

## WELL

Canonical identity and slowly changing attributes for a well. 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`.

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| `WELL_KEY` | string |  | Surrogate key for the well row, a stable string composed as {country}:{native\_id\_type}:{native\_id} (e.g. US:API10:4212340567). Consistent with this row's country, native\_id\_type, and native\_id. |
| `COUNTRY` | string |  | Two-letter ISO 3166-1 alpha-2 country code where the well is located (e.g., US, CA). |
| `NATIVE_ID_TYPE` | string |  | Identifier scheme of native\_id, explicitly restricted to the well-grain schemes API10 or UWI-DLS. 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_ID` | string |  | External regulatory identifier at well grain, the well-level root (API10 for US, UWI-DLS for Canada). 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_ID` | integer |  | Current operator of record. Historical changes should be captured as events (e.g., `OPERATOR_CHANGE`) or in a dedicated attribute history. |
| `WELL_NAME` | string |  | Human-friendly well name (operator or regulatory naming). Use for display; not a key. |
| `COUNTY` | string |  | Name of the county (or parish in Louisiana) where the well is located, as reported (e.g., "Reeves"); a name, never a code. The FIPS code is in `COUNTY_CODE`. NULL when not reported. |
| `STATE` | string |  | US state (USPS two-letter) or Canadian province/territory (Statistics Canada two-letter) code where the well is located. |
| `FIELD_NAME` | string |  | Name of the oil/gas field the well is in. |
| `STATUS_REPORTED` | string |  | Raw reported well status value from the state regulatory agency filing. |
| `STATUS_REPORTED_NORMALIZED` | string |  | State-reported well status after normalization to a controlled vocabulary. |
| `STATUS` | string |  | Current coarse lifecycle state of the well (derived from events). 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_NUMBER` | string |  | State-issued lease or production-unit identifier for the well as filed with the regulator, verbatim. 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_GRAVITY` | number | deg API | Most recent oil API gravity reported for the well, in degrees API. Oil and gas gravities are reported independently and may come from different tests. NULL when none is reported. |
| `LATEST_GAS_GRAVITY` | number | SG | Most recent gas specific gravity reported for the well (air = 1.0). Not necessarily from the same test as `LATEST_OIL_GRAVITY`. NULL when none is reported. |
| `OPERATOR_REPORTED` | string |  | The well's current operator as reported for the well: a name, not resolved to an OPERATOR row (`OPERATOR_ID` carries the resolved operator). May hold a placeholder where no operator is assigned. A current value, not a history. NULL where no operator is reported. |
| `OPERATOR_ORIGINAL` | string |  | The well's operator as of first production: a name, not resolved to an OPERATOR row. It does not change when the well later changes operator. NULL where no original operator is recorded. |
| `COUNTY_CODE` | string |  | Five-digit FIPS code of the county (or parish in Louisiana) where the well is located (e.g., "48389" for Reeves County, Texas). 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_AT` | timestamp |  | Timestamp the well record was first created in this system (ingest or authoring time). |
| `UPDATED_AT` | timestamp |  | Timestamp of the most recent update to this well record. |

## WELLBORE

A specific bore/lateral associated with a well. One well can have multiple wellbores (laterals, sidetracks, re-entries). As-built attributes belong here; time-varying milestones belong in well\_event.

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| `WELLBORE_KEY` | string |  | 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). Consistent with this row's country, native\_id\_type, native\_id, and sequence\_number. |
| `COUNTRY` | string |  | Two-letter ISO 3166-1 alpha-2 country code where the wellbore is located (e.g., US, CA). First component of wellbore\_key; matches the parent well.country. |
| `NATIVE_ID_TYPE` | string |  | Identifier scheme of native\_id (API10, API14, UWI-DLS, or PLANNED). 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_ID` | string |  | Wellbore-level identifier. 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_KEY` | string |  | Foreign key to well.well\_key, linking this wellbore to its parent well. |
| `WELLBORE_TYPE_NORMALIZED` | string |  | 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). 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_REPORTED` | string |  | The well-type code the source supplies for the regulator filing, trimmed and otherwise as filed. 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_REPORTED` | string |  | 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). Independent input from well.status\_reported, wellbore status can differ from well status. |
| `STATUS_REPORTED_NORMALIZED` | string |  | Reported wellbore status mapped to a controlled vocabulary, at wellbore grain (analogous to well.status\_reported\_normalized). Distinct from wellbore.status (Novi-curated lifecycle enum); the reported/normalized pair preserves provenance for audit. |
| `STATUS` | string |  | Current lifecycle state for the wellbore (can differ from the well-level status). |
| `MD_TD` | number | ft | Measured depth at TD in feet. |
| `TVD_TD` | number | ft | True vertical depth at TD in feet. |
| `LATERAL_LENGTH` | number | ft | 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. 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_PERF` | number | ft | Lateral length in feet from the upper to the lower perforation, the completed (stimulated) interval rather than the drilled one. 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_BHL` | number | ft | 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. 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_BHL` | number | ft | Lateral length in feet between the kick-off point and the bottom hole, as the difference in measured depth between the two survey stations. 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_TVD` | number | ft | Lateral length in feet from measured depth minus true vertical depth at total depth, clamped at 24,000 ft. 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_BHL` | number | ft | Great-circle distance in feet between the surface and bottom hole locations. 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_LATITUDE` | number | deg | Latitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `MIDPOINT_LONGITUDE` | number | deg | Longitude of the approximate lateral midpoint in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `HEELPOINT_LATITUDE` | number | deg | Latitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `HEELPOINT_LONGITUDE` | number | deg | Longitude of the lateral heel point in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `BOTTOM_HOLE_LATITUDE` | number | deg | Latitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `BOTTOM_HOLE_LONGITUDE` | number | deg | Longitude of the bottom hole location in decimal degrees, WGS84 unless otherwise specified by the CRS. |
| `KB_ELEVATION` | integer | ft | Kelly bushing elevation in feet above sea level. |
| `LANDING_POINT_LATITUDE` | number | deg | Latitude of the landing point in decimal degrees, WGS84. |
| `LANDING_POINT_LONGITUDE` | number | deg | Longitude of the landing point in decimal degrees, WGS84. |
| `FORMATION_REPORTED` | string |  | Formation name as reported by the data source (raw regulatory filing string). |
| `FORMATION_REPORTED_NORMALIZED` | string |  | Source-reported formation mapped to a controlled vocabulary. |
| `FORMATION` | string |  | Canonical formation name used for analytics grouping. Represents Novi's best estimate of the landing zone formation. |
| `FORMATION_CALCULATED` | string |  | Novi-calculated formation based on wellbore geometry and formation tops (structural depth grids). Used as the standard grouping key for peer comparison. |
| `DIRECTION_REPORTED` | string |  | Raw reported slant/direction value from the state regulatory agency (e.g., "Horizontal", "Directional"). |
| `DIRECTION_REPORTED_NORMALIZED` | string |  | State-reported direction after normalization to a controlled vocabulary. |
| `DIRECTION_CALCULATED` | string |  | Slant that Novi infers from evidence other than the filed slant, such as the wellbore trajectory. It is derived, not filed. |
| `DIRECTION` | string |  | Novi's resolved well slant: the first of these that applies. `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_LENGTH` | integer | ft | 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. 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_SOURCE` | string |  | Label of the method that produced `LATERAL_LENGTH`, such as 'Manual Override', 'PerforationTop-PerforationBottom' or 'Landing-Bottom'. 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_NUMBER` | integer |  | Lateral ordinal within the well (0-based; 0 for the first lateral, aligning with API14 borehole/event codes). 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_STREAM` | string |  | 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). 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_TURN` | number | ft | Lateral length in feet stated for the wellbore as a U-turn (horseshoe) lateral length. 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_COUNT` | integer |  | Number of refracs (re-stimulations after the original frac) reported for this wellbore's well; 0 when none is reported. 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_AVAILABLE` | boolean |  | True when directional survey stations are reported for the wellbore, false when none are. 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_SURVEY` | string |  | 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. NULL when `DIRECTIONAL_SURVEY_AVAILABLE` is false or NULL, which includes every Canadian wellbore. |
| `WELLBORE_TYPE` | string |  | The wellbore's declared operational function. 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_AT` | timestamp |  | Timestamp the wellbore record was created in this system. |
| `UPDATED_AT` | timestamp |  | Timestamp of the most recent update to this wellbore record. |

## SURFACE_LOCATION

Surface location and legal description for a well.

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| `SURFACE_LOCATION_ID` | integer |  | Stable, immutable unique identifier for this surface location record. |
| `WELL_KEY` | string |  | Foreign key to well.well\_key that currently references this location. |
| `LATITUDE` | number |  | Latitude in decimal degrees, WGS84 unless otherwise specified by crs. |
| `LONGITUDE` | number |  | Longitude in decimal degrees, WGS84 unless otherwise specified by crs. |
| `CRS` | string |  | Coordinate reference system identifier (e.g., 'EPSG:4326'). |
| `BLOCK_TOWNSHIP` | string |  | Township-level land identifier, consolidated across survey systems. 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. |
| `SECTION` | string |  | Section number within the block/township (~640 acres). Shared across all survey systems (PLSS, Texas, Alberta DLS). |
| `TX_SURVEY` | string |  | Texas only. Original land grant survey name (e.g., "T&STL RR CO"). Null for non-Texas wells. |
| `ABSTRACT_LOT` | string |  | Sub-section subdivision. 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. 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_AT` | timestamp |  | Timestamp the location record was created in this system. |
| `UPDATED_AT` | timestamp |  | Timestamp of the most recent update to this location record. |

## WELLBORE_TRAJECTORY

Stores a wellbore trajectory as a polyline for spatial analysis (spacing, overlap, inventory sizing, and map visualization). 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.

| Column | Description |
| --- | --- |
| `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\_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. |

## DIRECTIONAL_SURVEY_STATION

Station-level directional survey data for a wellbore. 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.

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| `WELLBORE_KEY` | string |  | Foreign key to wellbore.wellbore\_key. |
| `SURVEY_STATION_ID` | integer |  | Surrogate key for the survey station row. 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_SEQUENCE` | integer |  | Ordinal of this station within the wellbore's combined trajectory, 1-based (1 = the first, shallowest station) and ascending with measured depth. Because a wellbore has at most one combined trajectory, the per-wellbore and per-survey orderings are the same. |
| `MD` | number | ft | Measured depth of this survey station in feet. |
| `TVD` | number | ft | True vertical depth of this survey station in feet. |
| `SUB_SEA_TVD_CALCULATED` | number | ft | Novi-calculated sub-sea true vertical depth at this survey station, in feet. Negative values are above sea level. |
| `INCLINATION` | number | deg | Inclination angle at this station in degrees (0 = vertical, 90 = horizontal). |
| `AZIMUTH` | number | deg | Azimuth bearing at this station in degrees from north, 0 to 360 inclusive. 0 and 360 both denote due north; treat them as equal when comparing or grouping bearings. Non-additive. |
| `NS_OFFSET` | number | ft | North-South offset from wellhead in feet. Northbound is positive, southbound is negative. |
| `EW_OFFSET` | number | ft | East-West offset from wellhead in feet. Eastbound is positive, westbound is negative. |
| `LOCATION_TYPE` | integer |  | 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. The same code system is used by subsurface\_property.location\_type, so the two can be compared directly. |
| `LATITUDE` | number | deg | Latitude of this survey station in decimal degrees, WGS84. |
| `LONGITUDE` | number | deg | Longitude of this survey station in decimal degrees, WGS84. |
| `INTERPOLATED` | boolean |  | 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. 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_AT` | timestamp |  | Timestamp the record was created. |
| `UPDATED_AT` | timestamp |  | Timestamp of the most recent update. |
