ComboSync SPGCI Connector
ComboCurve™
S&P Global Commodity Insights (SPGCI) Connector
ComboSync connector mapping and dataflow documentation for SPGCI data sources
Recommended Mapping Overview
Connector Mapping
SPGCI → ComboCurve Entity Mapping
The following table describes the recommended mapping between SPGCI source entities and ComboCurve destination entities.
| SPGCI Source | ComboCurve Destination |
|---|---|
| well / well_header | Well |
| well / completion_header | Well |
| production/allocated / production_header | Well, MonthlyProduction, DirectionalSurvey |
| production/unallocated / production_header | Well, MonthlyProduction, DirectionalSurvey |
| production/allocated / production_monthly | MonthlyProduction |
| production/unallocated / production_monthly | MonthlyProduction |
| well / well_directional_survey_station | DirectionalSurvey |
| impact/well / impact_well | Well |
| impact/historicalwellproduction / impact_well_and_prod | MonthlyProduction |
SPGCI Entities
Entity Relationship
SPGCI Entity Relationship Diagram
The diagram below illustrates the relationships between SPGCI source entities used by the connector.
SPGCI Dataflow
Data Pipeline
SPGCI → ComboCurve Dataflow
The dataflow illustrates how data moves from IHS/SPGCI through the Agent pull and push process into ComboCurve, with local SQL staging for monthly production.
Well — Field Mapping
Well Entity
Well — Source: well / well_header
FROM well_header LEFT JOIN completion_header ON completion_header.uwi = well_header.uwi JOIN production_header ON production_header.uwi = well_header.uwi
Referenced Entities & Derived Fields
- COMPLETION_HEADER — Referenced entity (LEFT JOIN on uwi)
- PRODUCTION_HEADER — Referenced entity
- Allocated:
production/allocated / production_header - Unallocated:
production/unallocated / production_header
- Allocated:
- CHOSEN_ID — On PRODUCTION_HEADER level
REPLACE(REPLACE(REPLACE(PRODUCTION_HEADER.entity, ' ', 'X'), '-', 'Y'), ',', 'Z') + 'A' or 'U' - UPDATED_DATE — Max value of
updated_date,COMPLETION_HEADER.last_activity_date,PRODUCTION_HEADER.updated_date - PRIMARY_PRODUCT —
PRODUCTION_HEADER.primary_product- Allowed values:
oil,gas,water crude oilis mapped tooil- Other values must be mapped to an empty value
- Allowed values:
| SPGCI Field | ComboCurve Field |
|---|---|
| CHOSEN_ID | ChosenID |
| 'ihs' | DataSource |
| abstract | Abstract |
| CASE WHEN country = 'UNITED STATES OF AMERICA' THEN LEFT(uwi, 10) ELSE NULL END | Api10 |
| CASE WHEN country = 'CANADA' THEN LEFT(uwi, 10) ELSE NULL END | CustomString16 |
| CASE WHEN country = 'UNITED STATES OF AMERICA' THEN LEFT(uwi, 12) ELSE NULL END | Api12 |
| CASE WHEN country = 'CANADA' THEN LEFT(uwi, 12) ELSE NULL END | CustomString17 |
| CASE WHEN country = 'UNITED STATES OF AMERICA' THEN uwi ELSE NULL END | Api14 |
| CASE WHEN country = 'CANADA' THEN uwi ELSE NULL END | CustomString18 |
| basin | Basin |
| block | Block |
| ISNULL(COMPLETION_HEADER.completion_date, completion_date) | CompletionStartDate |
| country | Country |
| county | County |
| current_operator | CurrentOperator |
| current_operator_common_name | currentOperatorAlias |
| current_operator_code | CurrentOperatorCode |
| current_operator_ticker | CurrentOperatorTicker |
| rig_release_date | DateRigRelease |
| district | District |
| first_spud_date | DrillStartDate |
| ground_elev | Elevation |
| field | Field |
| gross_perf_interval | GrossPerforatedInterval |
| hole_direction | HoleDirection |
| PRODUCTION_HEADER.entity + '-A' or '-U' | IhsId |
| lateral_length | LateralLength |
| lease | LeaseName |
| lease_num | LeaseNumber |
| max_td | MeasuredDepth |
| permit_license_date | PermitDate |
| play | Play |
| original_operator | PreviousOperator |
| original_operator_code | PreviousOperatorCode |
| range | Range |
| section | Section |
| spud_date | SpudDate |
| province_state | State |
| COALESCE(PRODUCTION_HEADER.production_status, current_status, activity_group) | Status |
| sub_play | Subplay |
| surface_latitude | SurfaceLatitude |
| surface_longitude | SurfaceLongitude |
| survey | Survey |
| td_date | DrillEndDate |
| target_formation | TargetFormation |
| bh_latitude | ToeLatitude |
| bh_longitude | ToeLongitude |
| township | Township |
| tvd | TrueVerticalDepth |
| well_name | WellName |
| well_num | WellNumber |
| latest_well_type | WellType |
| UPDATED_DATE | UpdatedAt |
| COMPLETION_HEADER.completion_design | CompletionDesign |
| COMPLETION_HEADER.total_proppant | FirstPropWeight |
| COMPLETION_HEADER.total_fluid | FirstFluidVolume |
| COMPLETION_HEADER.perf_interval_length | Perflaterallength |
| COMPLETION_HEADER.producing_formation | LandingZone |
| COMPLETION_HEADER.producing_formation_shallowest_interval | UpperPerforation |
| COMPLETION_HEADER.producing_formation_deepest_interval | LowerPerforation |
| COMPLETION_HEADER.total_num_stages | FirstStageCount |
| PRODUCTION_HEADER.production_start_date | FirstProdDate |
| CONCAT(PRODUCTION_HEADER.entity_type, ':ALLOCATED' or ':UNALLOCATED') | AllocationType |
| PRIMARY_PRODUCT | PrimaryProduct |
Impact Entity
Well — Source: impact/well / impact_well
| SPGCI Field | ComboCurve Field |
|---|---|
| api_14_uwi_unformatted | ChosenID |
| 'ihs' | DataSource |
| 'impact' | CustomString19 |
| CASE WHEN Country = 'United States' THEN LEFT(api_14_uwi_unformatted, 10) ELSE NULL END | API10 |
| CASE WHEN Country = 'Canada' THEN LEFT(api_14_uwi_unformatted, 10) ELSE NULL END | CustomString17 |
| CASE WHEN Country = 'United States' THEN api_14_uwi_unformatted ELSE NULL END | Api14 |
| CASE WHEN Country = 'Canada' THEN api_14_uwi_unformatted ELSE NULL END | CustomString18 |
| abstract | Abstract |
| azimuth | Azimuth |
| basin | Basin |
| block | Block |
| date_completion | CompletionStartDate |
| country | Country |
| county | County |
| operator | CurrentOperator |
| operator_ticker | CurrentOperatorTicker |
| district | District |
| field | Field |
| date_vintage | FirstProdDate |
| rate_ip_24_test_gas | FirstTestGasVol |
| rate_ip_24_test_oil | FirstTestOilVol |
| gatherer_gas | GasGatherer |
| footage_perf_interval | GrossPerforatedInterval |
| footage_perf_interval | PerfLateralLength |
| ground_elevation_ft | GroundElevation |
| ground_elevation_ft | Elevation |
| well_orientation | HoleDirection |
| spacing_neighbor_current_horiz_distance_in_ft | HzWellSpacingAnyZone |
| spacing_res_neighbor_current_horiz_distance_in_ft | HzWellSpacingSameZone |
| prod_entity_id | IhsId |
| REPLACE(reservoir, '##', ' ') | LandingZone |
| footage_lateral_length | LateralLength |
| lease_name | LeaseName |
| footage_md | MeasuredDepth |
| api_grav_liquids | OilApiGravity |
| spacing_neighbor_current_relationship | ParentChildAnyZone |
| date_permit_granted | PermitDate |
| play_designation | Play |
| original_operator | PreviousOperator |
| prod_type_rptd | PrimaryProduct |
| proppant_mesh_size | ProppantMeshSize |
| proppant_type | ProppantType |
| location_range | Range |
| artificial_lift_method | RecoveryMethod |
| location_section | Section |
| date_spud | SpudDate |
| frac_stages | FirstStageCount |
| state_province | State |
| status_current_prod | Status |
| play_subregion | Subplay |
| latitude_sh | SurfaceLatitude |
| longitude_sh | SurfaceLongitude |
| permit_reservoir | TargetFormation |
| latitude_bh | ToeLatitude |
| longitude_bh | ToeLongitude |
| fluid_volume | FirstFluidVolume |
| proppant_volume | FirstPropWeight |
| location_township | Township |
| footage_tvd | TrueVerticalDepth |
| spacing_neighbor_current_vert_distance_in_ft | VtWellSpacingAnyZone |
| spacing_res_neighbor_current_vert_distance_in_ft | VtWellSpacingSameZone |
| well_name | WellName |
| well_number | WellNumber |
MonthlyProduction — Field Mapping
Production
MonthlyProduction — Source: production/(un)allocated / production_monthly
- Allocated:
production/allocated / production_header - Unallocated:
production/unallocated / production_header - Grouping by
entity,production_vol_date - ChosenID is used from the production_header referenced by the
entityattribute
| SPGCI Field | ComboCurve Field |
|---|---|
| (from production_header) | ChosenID |
| production_vol_date | Date |
| 'ihs' | DataSource |
| MAX(days_on) | DaysOn |
| SUM(PM.combined_gas_vol) | Gas |
| SUM(PM.liquid_vol) | Oil |
| SUM(PM.water_vol) | Water |
Impact Entity
MonthlyProduction — Source: impact/historicalwellproduction / impact_well_and_prod
| SPGCI Field | ComboCurve Field |
|---|---|
| api_14_uwi_unformatted | ChosenID |
| proddate | Date |
| 'ihs' | DataSource |
| gas * 30.25 | Gas |
| liquids * 30.25 | Oil |
| water * 30.25 | Water |
DirectionalSurvey — Field Mapping
Survey Data
DirectionalSurvey — Source: well / well_directional_survey_station
- Allocated:
production/allocated / production_header - Unallocated:
production/unallocated / production_header - ChosenID is used from the production_header referenced by the
uwiattribute
| SPGCI Field | ComboCurve Field |
|---|---|
| (from production_header) | ChosenID |
| 'ihs' | DataSource |
| 'WGS84' | SpatialDataType |
| station_md_uscust | MeasuredDepth |
| station_tvd_uscust | TrueVerticalDepth |
| azimuth | Azimuth |
| inclination | Inclination |
| x_offset_uscust | DeviationEW |
| y_offset_uscust | DeviationNS |
| latitude | Latitude |
| longitude | Longitude |
Source: S&P Global Energy, ©2025 by S&P Global Inc. All rights reserved.
For any additional questions or concerns, please reach out to support@combocurve.com
Related Articles
ComboSync Enverus Connector
ComboCurve™ Enverus Connector ComboSync connector mapping and dataflow documentation for Enverus data sources Supported Enverus APIs Connector Enverus Data Sets The Enverus connector supports two data set families, each accessed through a different ...ComboSync Connector
ComboCurve™ Available ComboSync API Endpoints Supported ingestion and extraction endpoints available through the ComboSync integration platform Ingestions Push Data Into ComboCurve These are the items we can ingest into ComboCurve from client source ...ComboSync v2 Overview
ComboCurve™ ComboSync v2 Overview A software service to hide the REST API integration — standalone, no-code-on-the-customer solution for integrating client and public subscription data in and out of ComboCurve ComboSync v2 is a standalone, ...ComboSync Agent Installation Guide
ComboSync Agent Installation Guide Requirements Application Server OS Windows 10/11, Windows Server 2016+ Powershell 5+ for the installation/updating part CPU core 2+ RAM 8+ GB Disk space 600 MB + about 2 GB for logs Networking / Required outbound ...ComboSync Auto-Update Feature
ComboSync Agent Auto Update Introduction An automatic update feature is preferred. There is no action needed on the customer side. The update will be performed automatically. If the ComboCurve support team detects any auto-update issue, they will ...