Skip to content
Developers
Get an API token

Spacing and subsurface

Well spacing metrics, the settings behind them, and subsurface rock properties.

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.

18 columns

Spacing metrics for a single wellbore, including nearest neighbor distances, parent/child classification, and density metrics.

More about this view

One row per wellbore. Used for frac hit analysis, spacing optimization, and parent-child interference studies. All distance fields are non-additive.

Key columns
Sample query
SELECT WELL_SPACING_ID, WELLBORE_KEY, CLOSEST_WELL_XY, WELLS_IN_RADIUS, CLOSEST_TWO_AVG_XY
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_SPACING
LIMIT 10
Columns18
WELL_SPACING_IDinteger
Surrogate key.
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
CLOSEST_WELL_XYnumberft
XY distance to the closest lateral and staggered neighbor in feet.
More

Non-additive.

WELLS_IN_RADIUSinteger
Count of all wells within the neighbor distance radius.
CLOSEST_TWO_AVG_XYnumberft
Average XY distance to the two closest neighbors (includes staggered and stacked).
More

Non-additive.

WELLS_IN_RADIUS_AVG_XYnumberft
Total wells in radius converted to a distance = 2 * MaxNeighborDistance / (1 + WellsInRadius).
More

Non-additive.

IS_CHILDboolean
True if this well is classified as a child well (drilled after nearby parent wells were producing).
PARENT_COUNTinteger
Number of neighboring parent wells meeting spacing criteria.
PARENT_DAYS_ONLINEnumberday
Days the nearest parent well was online relative to this well's start.
LATERAL_CLOSER_XYnumberft
XY distance to the nearest well in the same lateral row.
More

Non-additive.

STAGGER_CLOSER_TANGENTnumberft
Tangent distance to the nearest staggered well.
More

Non-additive.

STACK_CLOSER_Zintegerft
Vertical distance to the nearest well in the same vertical stack.
More

Non-additive.

BOUNDEDNESS_SCOREinteger
Number of neighbor quadrants occupied by wells (0-8).
More

Non-additive.

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.
15 columns

Configuration settings used to compute well_spacing metrics.

More about this view

One row per (basin, subbasin): the source defines parameters per basin, and the same parameters are emitted for every subbasin under that basin, so a wellbore's basin resolves to exactly one config row. Includes search radii, cutoff angles, and threshold parameters.

Key columns
Joins to
Sample query
SELECT WELL_SPACING_CONFIG_ID, LENGTH_UNIT, MAX_NEIGHBOR_DISTANCE, MAX_VERTICAL_DISTANCE, MAX_PARENT_VERTICAL_DISTANCE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_SPACING_CONFIGURATION
LIMIT 10
Columns15
LENGTH_UNIT
Length unit for spacing data (e.g., "feet").
MAX_NEIGHBOR_DISTANCE
Search radius for neighbor detection.
MAX_VERTICAL_DISTANCE
Maximum vertical distance to count as a neighbor.
MAX_PARENT_VERTICAL_DISTANCE
Maximum vertical distance to count as a parent.
HORIZONTAL_CUTOFF_ANGLE
Angle threshold for lateral neighbor identification.
VERTICAL_CUTOFF_ANGLE
Angle threshold for stacked neighbor identification.
HORIZONTAL_MAX_OF_STACKED_NEIGHBORS
Max horizontal distance for stacked neighbor.
VERTICAL_MAX_OF_LATERAL_NEIGHBORS
Max vertical distance for lateral neighbor.
PARENT_CUTOFF_DAYS
Parent must be producing at least this many days before child.
MIN_LATERAL_LENGTH_FOR_NEIGHBORS
Minimum lateral length for a well to count as a neighbor.
DEFAULT_LATERAL_DISTANCE
Default distance when no neighbor is detected.
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.
44 columns

Subsurface petrophysical and geomechanical properties at a specific point/depth along a wellbore, optionally mapped to a directional survey station when one exists.

More about this view

Properties include porosity, permeability, brittleness, thickness, water saturation, TOC, and hydrocarbon-in-place estimates, all formation-averaged at the measurement point's depth. Every row anchors to a wellbore via wellbore_key; rows with directional-survey coverage additionally carry survey_station_id for station-grain analytics (along-trajectory and spatial queries).

Key columns
Sample query
SELECT SUBSURFACE_PROPERTY_ID, WELLBORE_KEY, SURVEY_STATION_ID, LOCATION_TYPE, STRUCTURAL_DEPTH
FROM NOVI_DATA_ACCESS.NOVI_WELLS.SUBSURFACE_PROPERTY
LIMIT 10
Columns44
SUBSURFACE_PROPERTY_IDinteger
Surrogate key.
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key, the canonical anchor for every subsurface_property row.
More

Populated for all rows; the optional survey_station_id provides finer station-grain attachment when available.

SURVEY_STATION_IDinteger
Optional foreign key to directional_survey_station.survey_station_id.
More

Populated when the wellbore has a matching directional survey station for the row's location type; NULL when the parent wellbore has no directional-survey coverage. Use wellbore_key as the always-populated anchor.

LOCATION_TYPEinteger
Type of measurement point along the wellbore, shared value enum (not a foreign key) with directional_survey_station.location_type.
More

Part of the natural key: disambiguates multiple measurements at different points along the same wellbore and formation. Required even when survey_station_id is NULL so unmatched rows still carry positional context.

STRUCTURAL_DEPTHnumberft
Depth of the top of the formation (TVDSS).
BRITTLENESS_AVGnumber
Average brittleness of the formation, as an index whose unit and range are not defined; not a 0-1 fraction or a percentage.
More

Non-additive.

COMPETENCY_AVGnumber
Average rock competency of the formation, as an index whose unit and range are not defined; not a 0-1 fraction.
More

Non-additive.

THICKNESS_AVGnumberft
Gross isopach (formation thickness) in feet.
PERMEABILITY_AVGnumbermD
Average permeability calibrated to core and production matching, in millidarcies.
PERMEABILITY_HEIGHT_AVGnumbermD-ft
Average permeability times gross thickness (kh product) in millidarcy-feet.
POROSITY_AVGnumberpct
Effective porosity in percentage (porosity units).
POROSITY_HEIGHT_AVGnumberpct-ft
Average porosity times gross thickness (phi-h product).
STOIIP_AVGnumberMMbbl/sq_mi
Stock tank oil initially in place, million barrels per section (sq. mi).
SW_AVGnumberpct
Average water saturation as a percentage.
TOC_AVGnumberpct
Average total organic carbon as a percentage.
VCLAY_AVGnumberpct
Average volume of clay as a percentage.
BVI_AVGnumberpct
Average bulk volume irreducible water as a percentage.
NTG_AVGnumber
Net-to-gross ratio (dimensionless).
GIIP_AVGnumberBcf/sq_mi
Gas initially in place, billion cubic feet per section (sq. mi).
BRITTLENESS_OF_NETnumber
Brittleness averaged over net pay cutoffs within the formation, on the same scale as brittleness_avg.
More

Unit and range are not defined. Non-additive.

COMPETENCY_OF_NETnumber
Competency averaged over net pay cutoffs, on the same scale as competency_avg.
More

Unit and range are not defined. Non-additive.

THICKNESS_OF_NETnumberft
Net pay thickness in feet.
PERMEABILITY_OF_NETnumbermD
Permeability averaged over net pay cutoffs, in millidarcies.
PERMEABILITY_HEIGHT_OF_NETnumbermD-ft
Permeability-height product over net pay cutoffs, in millidarcy-feet.
POROSITY_OF_NETnumberpct
Porosity averaged over net pay cutoffs.
POROSITY_HEIGHT_OF_NETnumberpct-ft
Porosity-height product over net pay cutoffs.
STOIIP_OF_NETnumberMMbbl/sq_mi
Oil in place over net pay cutoffs.
SW_OF_NETnumberpct
Water saturation over net pay cutoffs.
TOC_OF_NETnumberpct
TOC over net pay cutoffs.
VCLAY_OF_NETnumberpct
Volume of clay over net pay cutoffs.
BVI_OF_NETnumberpct
Irreducible water over net pay cutoffs.
GIIP_OF_NETnumberBcf/sq_mi
Gas in place over net pay cutoffs.
FORMATIONstring
Novi's best estimate of the actual target formation.
REPORTED_FORMATIONstring
Target formation as reported by the state.
GRID_FORMATIONstring
Formation based on subsurface grid studies.
PERCENT_IN_ZONEintegerpct
Percentage of lateral in the grid formation.
DISTANCE_FROM_TOPintegerft
Feet from top of formation, based on grids and survey.
DISTANCE_FROM_BASEintegerft
Feet from base of formation, based on grids and survey.
NORMALIZED_DISTANCE_TO_TOPnumber
Value 0-1 where 0 = drilled at top of zone, 1 = drilled at base of zone.
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.