• Enverus API V2
• Enverus API V3
Enverus |
ComboCurve |
wells |
Well |
production |
MonthlyProduction |
full-directional-surveys |
DirectionalSurvey |
Source: wells
Enverus |
ComboCurve |
Abstract |
Abstract |
API_UWI_Unformatted |
Api10 |
API_UWI_12_Unformatted |
Api12 |
API_UWI_14_Unformatted |
Api14 |
ENVBasin |
Basin |
Block |
Block |
ChokeSize_64IN |
ChokeSize |
API_UWI_14_Unformatted |
ChosenID |
‘di’ |
DataSource |
‘DrillingInfo’ |
DataSourceCustomName |
CompletionDesign |
CompletionDesign |
CompletionDate |
CompletionEndDate |
Country |
Country |
County |
County |
CumProd_BOE |
CumBoe |
CumGas_MCF |
CumGas |
CumProd_MCFE |
CumMmcfge |
CumOil_BBL |
CumOil |
CumWater_BBL |
CumWater |
ENVOperator |
CurrentOperator |
ENVTicker |
CurrentOperatorTicker |
RigReleaseDate |
DateRigRelease |
District |
District |
DrillingEndDate |
DrillEndDate |
SpudDate |
DrillStartDate |
ENVElevationGL_FT |
Elevation |
WellID |
DrillinginfoId |
Field |
Field |
First12MonthProd_BOE |
First12Boe |
First12MonthGas_MCF |
First12Gas |
First12MonthProd_MCFE |
First12Mmcfge |
First12MonthOil_BBL |
First12Oil |
First12MonthWater_BBL |
First12Water |
First6MonthProd_BOE |
First6Boe |
First6MonthGas_MCF |
First6Gas |
First6MonthProd_MCFE |
First6Mmcfge |
First6MonthOil_BBL |
First6Oil |
First6MonthWater_BBL |
First6Water |
FirstProdDate |
FirstProdDate |
ENVFluidType |
FluidType |
GasGravity_SG |
GasSpecificGravity |
COALESCE(PerfInterval_FT, LateralLength_FT) |
PerfLateralLength |
PerfInterval_FT |
GrossPerforatedInterval |
ENVElevationGL_FT |
GroundElevation |
Trajectory |
HoleDirection |
Last12MonthProduction_BOE |
Last12Boe |
Last12MonthGasProduction_MCF |
Last12Gas |
Last12MonthOilProduction_BBL |
Last12Oil |
Last12MonthWaterProduction_BBL |
Last12Water |
LastMonthGasProduction_MCF |
LastMonthGas |
LastMonthLiquidsProduction_BBL |
LastMonthOil |
LastMonthWaterProduction_BBL |
LastMonthWater |
LastProducingMonth |
LastProdDateMonthly |
LateralLength_FT |
LateralLength |
LeaseName |
LeaseName |
Lease |
LeaseNumber |
LowerPerf_FT |
LowerPerforation |
MD_FT |
MeasuredDepth |
TotalProducingMonths |
MonthsProduced |
OilGravity_API |
OilApiGravity |
WellPadID |
PadName |
PermitApprovedDate |
PermitDate |
ENVPlay |
Play |
InitialOperator |
PreviousOperator |
ENVProducingMethod |
ProductionMethod |
ENVProppantType |
ProppantType |
RANGE |
RANGE |
Section |
Section |
SpudDate |
SpudDate |
AverageStageSpacing_FT |
StageSpacing |
FracStages |
FirstStageCount |
StateProvince |
State |
ENVWellStatus |
Status |
ENVSubPlay |
Subplay |
Latitude |
SurfaceLatitude |
Longitude |
SurfaceLongitude |
Formation |
TargetFormation |
Latitude_BH |
ToeLatitude |
Longitude_BH |
ToeLongitude |
TotalClusters |
FirstClusterCount |
TotalFluidPumped_BBL |
FirstFluidVolume |
Proppant_LBS |
FirstPropWeight |
Township |
Township |
TVD_FT |
TrueVerticalDepth |
UpperPerf_FT |
UpperPerforation |
WellName |
WellName |
WellNumber |
WellNumber |
ENVWellType |
WellType |
ENVInterval |
LandingZone |
Source: production
IHS Energy |
ComboCurve |
API_UWI_14_Unformatted |
ChosenID |
‘di’ |
DataSource |
ProducingMonth |
DATE |
ProducingDays |
DaysOn |
GasProd_MCF |
Gas |
InjectionGas_MCF |
GasInjection |
Prod_OilBBL |
Oil |
Prod_CondensateBBL |
Ngl |
WaterProd_BBL |
Water |
InjectionWater_BBL |
WaterInjection |
Source: full-directional-surveys
• ChosenID (API_UWI_14_Unformatted) is used from the wells referenced by the WellID attribute
Enverus |
ComboCurve |
|
ChosenID |
‘di’ |
DataSource |
‘WGS84’ |
SpatialDataType |
MeasuredDepth_FT |
MeasuredDepth |
TVD_FT |
TrueVerticalDepth |
Azimuth_DEG |
Azimuth |
Inclination_DEG |
Inclination |
E_W |
DeviationEW |
N_S |
DeviationNS |
Latitude |
Latitude |
Longitude |
Longitude |
Enverus |
ComboCurve |
well-rollups |
Well |
well-production-details |
MonthlyProduction |
trajectories |
DirectionalSurvey |
trajectory-stations |
|
Source: well-rollups
Enverus |
ComboCurve |
Abstract |
Abstract |
TotalAdditiveFirstTreatmentJob |
TotalAdditiveVolume |
API10 |
Api10 |
API12 |
Api12 |
API14 |
Api14 |
DIBasin |
Basin |
Block |
Block |
Api14 |
ChosenID |
CompletionDate |
CompletionEndDate |
Country |
Country |
CountyParish |
County |
CumBOE |
CumBoe |
CumGas |
CumGas |
CumGOR |
CumGor |
CumMMCFGE |
CumMmcfge |
CumOil |
CumOil |
CumWater |
CumWater |
OperatorCompanyName |
CurrentOperator |
OperatorAlias |
CurrentOperatorAlias |
OperatorTicker |
CurrentOperatorTicker |
‘di’ |
DataSource |
‘DrillingInfo’ |
DataSourceCustomName |
District |
District |
SpudDate |
DrillStartDate |
Elevation |
Elevation |
ElevationType |
ElevationType |
Field |
Field |
First12BOE |
First12Boe |
First12BOEPerPerforatedFt |
First12BoePerPerforatedInterval |
First12Gas |
First12Gas |
First12GasPerPerforatedFt |
First12GasPerPerforatedInterval |
First12MMCFGE |
First12Mmcfge |
First12Oil |
First12Oil |
First12OilPerPerforatedFt |
First12OilPerPerforatedInterval |
First12Water |
First12Water |
First6BOE |
First6Boe |
First6BOEPerPerforatedFt |
First6BoePerPerforatedInterval |
First6Gas |
First6Gas |
First6GasPerPerforatedFt |
First6GasPerPerforatedInterval |
First6Oil |
First6Oil |
First6OilPerPerforatedFt |
First6OilPerPerforatedInterval |
First6Water |
First6Water |
FirstProdDate |
FirstProdDate |
FirstTestFlowingTubingPressure |
FirstTestFlowTbgPress |
FirstTestGasVolume |
FirstTestGasVol |
FirstTestGOR |
FirstTestGor |
FirstTestOilVolume |
FirstTestOilVol |
FirstTestWaterVolume |
FirstTestWaterVol |
FootageInLandingZone |
FootageInLandingZone |
FracVendor |
FirstFracVendor |
GasGatherer |
GasGatherer |
GasGravity |
GasSpecificGravity |
GrossPerforatedInterval |
GrossPerforatedInterval |
GroundElevation |
GroundElevation |
DILandingZone |
LandingZone |
ToeInLandingZone |
ToeInLandingZone |
Last12Gas |
Last12Gas |
Last12Oil |
Last12Oil |
Last12Water |
Last12Water |
DILateralLength |
LateralLength |
LeaseName |
LeaseName |
ProducingEntityLeaseNumber |
LeaseNumber |
LowerPerforation |
LowerPerforation |
MaxInjectionPressureFirstTreatmentJob |
FirstMaxInjectionPressure |
MaxInjectionRateFirstTreatmentJob |
FirstMaxInjectionRate |
MeasuredDepth |
MeasuredDepth |
MonthsProduced |
MonthsProduced |
OilGravity |
OilApiGravity |
OilGatherer |
OilGatherer |
PercentInLandingZone |
PercentInZone |
DIPlay |
Play |
Range |
Range |
Section |
Section |
SpudDate |
SpudDate |
State |
State |
WellStatus |
Status |
DISubplay |
Subplay |
SurfaceHoleLatitudeWGS84 |
SurfaceLatitude |
SurfaceHoleLongitudeWGS84 |
SurfaceLongitude |
Survey |
Survey |
TargetFormation |
TargetFormation |
WellName |
WellName |
WellNumber |
WellNumber |
UpdatedDate |
UpdatedAt |
Source: well-production-details
Enverus |
ComboCurve |
Api14 |
ChosenID |
‘di’ |
DataSource |
ProdDate |
Date |
Days |
DaysOn |
Gas |
Gas |
Liq |
Oil |
Wtr |
Water |
Source: trajectory-stations
FROM
trajectory-stations
JOIN trajectories ON trajectories.TrajectoryID = trajectory-stations.TrajectoryID
JOIN well-rollups ON Wwell-rollups.API12 = trajectories.GovernmentID
• ChosenID (Api14) is used from the well-rollups
Enverus |
ComboCurve |
|
ChosenID |
‘DI’ |
DataSource |
‘WGS84’ |
SpatialDataType |
MD |
MeasuredDepth |
TVD |
TrueVerticalDepth |
Azimuth |
Azimuth |
Inclination |
Inclination |
XOffset |
DeviationEW |
YOffset |
DeviationNS |
Latitude |
Latitude |
Longitude |
Longitude |