1. Info
  2. Global Oil Storage

Schema and Value Definitions

Query fields and response value definitions for Aggregate and Detailed endpoints

 

LAST UPDATED: 7/15/2024

Aggregate and Detailed Endpoint Query Fields

Aggregation type (agg_<Aggregation type>) 

Sum 

Avg 


Query fields (qry_<FieldName>=<Value>) 

TankEntity 

ReportTime

ResultTime

PublishTime

SubscriptionType 

Region 

Country 

Territory 

LocationName 

Company 

TerminalName 

CrudeConfidence 

StorageType 


Group by fields (grp_ValueOf=<Field name>) 

Country

Region 

SubscriptionType 

Company 

LocationName 

Territory 

TerminalName 

StorageType 


Temporal Windows (grp_<Time Window>=ReportTime) 

None 

Weekly 

Monthly 

Quarterly 

Annual 

 

Detailed Response Value Definitions

Field

Example

Definition

reportTime

2020-05-21T14:00:00.000Z

Thursday report date

resultTime

2020-05-14T00:10:12.000Z

Date the image was taken for this measurement

publishTime

2020-05-18T14:00:01.000Z

Date this measurement was published

axis_CarryForward

false

Indicates if this measurement was carried forward from last week

axis_Company

Plains All American Pipeline LP

Company that own the tank

axis_Country

United States

Tank country

axis_CrudeConfidence

Yes

Confidence that this is a crude tank. Values are Yes, Probable, Unconfirmed, No

axis_FirstReportTime

2017-04-26T14:00:00.000Z

Date Ursa started measuring this location

axis_IsOecd

true

Indicates if the tank is an OECD tank

axis_LocationName

Cushing

Tank location

axis_PublishTime

2020-05-18T14:00:01.000Z

Date this measurement was published

axis_Region

Americas

Tank region

axis_ReportTime

2020-05-21T14:00:00.000Z

Thursday report date

axis_StorageType

Non-Refinery

The tank’s storage type. Values are Refinery, Non-Refinery, SPR, Commercial

axis_SubscriptionType

All Regions,North America

Tanks subscriptions

axis_TankEntity

CUH001

Unique ID for tank

axis_TerminalName

Plains All American Pipeline, LP (Cushing)

Tank terminal 

axis_Territory

PADD 2

Tank territory

capacityBarrels

271215

Tank capacity in number of barrels

cylinderHeightM

14.1

Tank height in meters

errorBarrels

9834

Fill error range in number of barrels

fillBarrels

72264

Tank fill in number of barrels

heightDropM

10.3431

Distance between tank rim and tank lid in meters

latitude

35.9432

Tank latitude

longitude

-96.7488

Tank longitude

radiusAverageM

31.2

Tank radius in meters