Spacing and subsurface
Well spacing metrics, the settings behind them, and subsurface rock properties.
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_SPACING
Section titled “WELL_SPACING”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
WELL_SPACING_IDSurrogate key.
- Joins to
SELECT WELL_SPACING_ID, WELLBORE_KEY, CLOSEST_WELL_XY, WELLS_IN_RADIUS, CLOSEST_TWO_AVG_XYFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_SPACINGLIMIT 10- 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_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.
WELL_SPACING_CONFIGURATION
Section titled “WELL_SPACING_CONFIGURATION”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
WELL_SPACING_CONFIG_IDSurrogate key.
- Joins to
SELECT WELL_SPACING_CONFIG_ID, LENGTH_UNIT, MAX_NEIGHBOR_DISTANCE, MAX_VERTICAL_DISTANCE, MAX_PARENT_VERTICAL_DISTANCEFROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_SPACING_CONFIGURATIONLIMIT 10- WELL_SPACING_CONFIG_ID
- Surrogate key.
- 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_idfor data lineage.
No columns match. Try a shorter word.
SUBSURFACE_PROPERTY
Section titled “SUBSURFACE_PROPERTY”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
SUBSURFACE_PROPERTY_IDSurrogate key.
- Joins to
SELECT SUBSURFACE_PROPERTY_ID, WELLBORE_KEY, SURVEY_STATION_ID, LOCATION_TYPE, STRUCTURAL_DEPTHFROM NOVI_DATA_ACCESS.NOVI_WELLS.SUBSURFACE_PROPERTYLIMIT 10- 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_ numbermD-ftAVG - 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_ numbermD-ftOF_ NET - 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_ numberTO_ TOP - 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_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.