# Spacing and subsurface

Source: https://developers.novilabs.com/data/tables/spacing-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

Spacing metrics for a single wellbore, including nearest neighbor distances, parent/child classification, and density metrics. One row per wellbore. Used for frac hit analysis, spacing optimization, and parent-child interference studies. All distance fields are non-additive.

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| `WELL_SPACING_ID` | integer |  | Surrogate key. |
| `WELLBORE_KEY` | string |  | Foreign key to wellbore.wellbore\_key. |
| `CLOSEST_WELL_XY` | number | ft | XY distance to the closest lateral and staggered neighbor in feet. Non-additive. |
| `WELLS_IN_RADIUS` | integer |  | Count of all wells within the neighbor distance radius. |
| `CLOSEST_TWO_AVG_XY` | number | ft | Average XY distance to the two closest neighbors (includes staggered and stacked). Non-additive. |
| `WELLS_IN_RADIUS_AVG_XY` | number | ft | Total wells in radius converted to a distance = 2 \* MaxNeighborDistance / (1 + WellsInRadius). Non-additive. |
| `IS_CHILD` | boolean |  | True if this well is classified as a child well (drilled after nearby parent wells were producing). |
| `PARENT_COUNT` | integer |  | Number of neighboring parent wells meeting spacing criteria. |
| `PARENT_DAYS_ONLINE` | number | day | Days the nearest parent well was online relative to this well's start. |
| `LATERAL_CLOSER_XY` | number | ft | XY distance to the nearest well in the same lateral row. Non-additive. |
| `STAGGER_CLOSER_TANGENT` | number | ft | Tangent distance to the nearest staggered well. Non-additive. |
| `STACK_CLOSER_Z` | integer | ft | Vertical distance to the nearest well in the same vertical stack. Non-additive. |
| `BOUNDEDNESS_SCORE` | integer |  | Number of neighbor quadrants occupied by wells (0-8). 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_AT` | timestamp |  | Timestamp the record was created. |
| `UPDATED_AT` | timestamp |  | Timestamp of the most recent update. |

## WELL_SPACING_CONFIGURATION

Configuration settings used to compute well\_spacing metrics. 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.

| Column | Description |
| --- | --- |
| `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\_id for data lineage. |

## 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. 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).

| Column | Type | Unit | Description |
| --- | --- | --- | --- |
| `SUBSURFACE_PROPERTY_ID` | integer |  | Surrogate key. |
| `WELLBORE_KEY` | string |  | Foreign key to wellbore.wellbore\_key, the canonical anchor for every subsurface\_property row. Populated for all rows; the optional survey\_station\_id provides finer station-grain attachment when available. |
| `SURVEY_STATION_ID` | integer |  | Optional foreign key to directional\_survey\_station.survey\_station\_id. 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_TYPE` | integer |  | Type of measurement point along the wellbore, shared value enum (not a foreign key) with directional\_survey\_station.location\_type. 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_DEPTH` | number | ft | Depth of the top of the formation (TVDSS). |
| `BRITTLENESS_AVG` | number |  | Average brittleness of the formation, as an index whose unit and range are not defined; not a 0-1 fraction or a percentage. Non-additive. |
| `COMPETENCY_AVG` | number |  | Average rock competency of the formation, as an index whose unit and range are not defined; not a 0-1 fraction. Non-additive. |
| `THICKNESS_AVG` | number | ft | Gross isopach (formation thickness) in feet. |
| `PERMEABILITY_AVG` | number | mD | Average permeability calibrated to core and production matching, in millidarcies. |
| `PERMEABILITY_HEIGHT_AVG` | number | mD-ft | Average permeability times gross thickness (kh product) in millidarcy-feet. |
| `POROSITY_AVG` | number | pct | Effective porosity in percentage (porosity units). |
| `POROSITY_HEIGHT_AVG` | number | pct-ft | Average porosity times gross thickness (phi-h product). |
| `STOIIP_AVG` | number | MMbbl/sq\_mi | Stock tank oil initially in place, million barrels per section (sq. mi). |
| `SW_AVG` | number | pct | Average water saturation as a percentage. |
| `TOC_AVG` | number | pct | Average total organic carbon as a percentage. |
| `VCLAY_AVG` | number | pct | Average volume of clay as a percentage. |
| `BVI_AVG` | number | pct | Average bulk volume irreducible water as a percentage. |
| `NTG_AVG` | number |  | Net-to-gross ratio (dimensionless). |
| `GIIP_AVG` | number | Bcf/sq\_mi | Gas initially in place, billion cubic feet per section (sq. mi). |
| `BRITTLENESS_OF_NET` | number |  | Brittleness averaged over net pay cutoffs within the formation, on the same scale as brittleness\_avg. Unit and range are not defined. Non-additive. |
| `COMPETENCY_OF_NET` | number |  | Competency averaged over net pay cutoffs, on the same scale as competency\_avg. Unit and range are not defined. Non-additive. |
| `THICKNESS_OF_NET` | number | ft | Net pay thickness in feet. |
| `PERMEABILITY_OF_NET` | number | mD | Permeability averaged over net pay cutoffs, in millidarcies. |
| `PERMEABILITY_HEIGHT_OF_NET` | number | mD-ft | Permeability-height product over net pay cutoffs, in millidarcy-feet. |
| `POROSITY_OF_NET` | number | pct | Porosity averaged over net pay cutoffs. |
| `POROSITY_HEIGHT_OF_NET` | number | pct-ft | Porosity-height product over net pay cutoffs. |
| `STOIIP_OF_NET` | number | MMbbl/sq\_mi | Oil in place over net pay cutoffs. |
| `SW_OF_NET` | number | pct | Water saturation over net pay cutoffs. |
| `TOC_OF_NET` | number | pct | TOC over net pay cutoffs. |
| `VCLAY_OF_NET` | number | pct | Volume of clay over net pay cutoffs. |
| `BVI_OF_NET` | number | pct | Irreducible water over net pay cutoffs. |
| `GIIP_OF_NET` | number | Bcf/sq\_mi | Gas in place over net pay cutoffs. |
| `FORMATION` | string |  | Novi's best estimate of the actual target formation. |
| `REPORTED_FORMATION` | string |  | Target formation as reported by the state. |
| `GRID_FORMATION` | string |  | Formation based on subsurface grid studies. |
| `PERCENT_IN_ZONE` | integer | pct | Percentage of lateral in the grid formation. |
| `DISTANCE_FROM_TOP` | integer | ft | Feet from top of formation, based on grids and survey. |
| `DISTANCE_FROM_BASE` | integer | ft | Feet from base of formation, based on grids and survey. |
| `NORMALIZED_DISTANCE_TO_TOP` | number |  | 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_AT` | timestamp |  | Timestamp the record was created. |
| `UPDATED_AT` | timestamp |  | Timestamp of the most recent update. |
