• 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 |