Geodatabase

Pre-computed field data retrieval.

Note: data for the prior month is typically populated by the 5th of the current month. To retrieve the latest data, check out the Raster endpoints.

Special: due to the ability to retrieve large amounts of data, geodatabase query results are compressed as .zip files.

Field IDs

Supports queries against OpenET's geodatabase to retrieve a list of field ids within a polygon specified by a list of longitude latitude pairs. Data is returned as a List. If the boundary of the polygon intersects a field, its unique id will be included as shown in the example below where the user provided boundary is the red rectangle. Each field id of the blue fields is included.

Field boundary retrieval example

Note, if asset_id is used in place of geometry, only the bounds of the asset geometry are considered. This means a single polygon is created and used. Single polygon asset is recommend here to avoid unexpected results.

Take a look at how you might call this method:

curl

curl -o field_identifiers.json.zip -L -X 'POST' \
  'https://openet-api.org/geodatabase/metadata/ids' \
  -H 'accept: application/json' \
  -H 'Authorization: YOUR_API_KEY' \
  -H 'Content-Type: application/json' \
  -d '{
  "geometry": [
    -121.67364,
    38.61593,
    -121.67364,
    38.65611,
    -121.65401,
    38.65611,
    -121.65401,
    38.61593
  ]
}'

Python

import gzip
import requests

# set your API key before making the request
header = {"Authorization": YOUR_API_KEY}

# endpoint arguments
args = {
  "geometry": [
    -121.67364,
    38.61593,
    -121.67364,
    38.65611,
    -121.65401,
    38.65611,
    -121.65401,
    38.61593
  ]
}

# query the api 
resp = requests.post(
    headers=header,
    json=args,
    url="https://openet-api.org/geodatabase/metadata/ids"
)

# unzip the data
data = eval(gzip.decompress(resp.content).decode())

print(data)

Field Properties

Supports queries against OpenET's geodatabase to retrieve metadata properties from a list of field ids. Metadata attributes include:

• Field ID

• Area in hectares

• USDA CDL crop type code by available year

• Date last modified

This endpoint will return properties from multiple states at a time.

Provides support for retrieving field ids in a region from OpenET's pre-computed database.

POST/geodatabase/metadata/properties

Authorization

APIKeyHeader

Body

application/json

field_ids*OpenET Field IDs

Response

200422

Successful Response

Body

application/json

any

Request

JavaScriptCurlPythonHTTP

const response = await fetch('/geodatabase/metadata/properties', {
    method: 'POST',
    headers: {
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      "field_ids": [
        "0651038",
        "0651039",
        "0651040",
        "0658785"
      ]
    }),
});
const data = await response.json();

Response

422

{
  "detail": [
    {
      "loc": [
        "text"
      ],
      "msg": "text",
      "type": "text"
    }
  ]
}

Take a look at how you might call this method:

curl

curl -o metadata.json.zip -L -X 'POST' \
  'https://openet-api.org/geodatabase/metadata/properties' \
  -H 'accept: application/json' \
  -H 'Authorization: YOUR_API_KEY' \
  -H 'Content-Type: application/json' \
  -d '{
  "field_ids": [
    "06183913",
    "06208981"
  ]
}'

Python

import gzip
import requests

# set your API key before making the request
header = {"Authorization": YOUR_API_KEY}

# endpoint arguments
args = {
  "field_ids": [
    "06183913",
    "06208981"
  ]
}

# query the api 
resp = requests.post(
    headers=header,
    json=args,
    url="https://openet-api.org/geodatabase/metadata/properties"
)

# unzip the data
data = eval(gzip.decompress(resp.content).decode())

print(data)

Timeseries by Field ID

Allows the user to define a list of field ids and export a subset of the OpenET geodatabase to retrieve timeseries data. Extractions will only include data within one US State at a time, however, multi-model and variable queries are supported in list format.

For large queries, uncompressed csv output is not an option and json must be selected.

Note: data in geodatabase are stored in metric (mm & hectares).

Provides support for retrieving timeseries from OpenET's pre-computed database.

POST/geodatabase/timeseries

Authorization

APIKeyHeader

Body

application/json

date_range*Time Range

interval*Interval

field_ids*OpenET Field IDs

models*OpenET Models

variables*Variables

file_format*Output Extension

Response

200422

Successful Response

Body

application/json

any

Request

JavaScriptCurlPythonHTTP

const response = await fetch('/geodatabase/timeseries', {
    method: 'POST',
    headers: {
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      "date_range": [
        "2020-01-01",
        "2020-12-31"
      ],
      "field_ids": [
        "0651038",
        "0651039",
        "0651040",
        "0658785"
      ],
      "file_format": "CSV",
      "interval": "monthly",
      "models": [
        "Ensemble"
      ],
      "variables": [
        "ET"
      ]
    }),
});
const data = await response.json();

Response

422

{
  "detail": [
    {
      "loc": [
        "text"
      ],
      "msg": "text",
      "type": "text"
    }
  ]
}

Take a look at how you might call this method:

curl

curl -o timeseries.json.zip -L -X 'POST' \
  'https://openet-api.org/geodatabase/timeseries' \
  -H 'accept: application/json' \
  -H 'Authorization: YOUR_API_KEY' \
  -H 'Content-Type: application/json' \
  -d '{
  "date_range": [
    "2020-01-01",
    "2020-12-31"
  ],
  "interval": "monthly",
  "field_ids": [
    "06183913",
    "06208981"
  ],
  "models": [
    "Ensemble"
  ],
  "variables": [
    "ET"
  ],
  "file_format": "JSON"
}'

Python

import gzip
import requests

# set your API key before making the request
header = {"Authorization": YOUR_API_KEY}

# endpoint arguments
args = {
  "date_range": [
    "2020-01-01",
    "2020-12-31"
  ],
  "interval": "monthly",
  "field_ids": [
    "06183913",
    "06208981"
  ],
  "models": [
    "Ensemble"
  ],
  "variables": [
    "ET"
  ],
  "file_format": "JSON"
}

# query the api 
resp = requests.post(
    headers=header,
    json=args,
    url="https://openet-api.org/geodatabase/timeseries"
)

# unzip the data
data = eval(gzip.decompress(resp.content).decode())

print(data)

Field Boundaries

Allows the user to define a list of OpenET field ids and export a subset of the OpenET geodatabase geometries as an RFC 7946 formatted GeoJSON file. This endpoint will return boundaries from multiple states at a time.

Provides support for retrieving field geometries from OpenET's pre-computed database.

POST/geodatabase/metadata/boundaries

Authorization

APIKeyHeader

Body

application/json

field_ids*OpenET Field IDs

Response

200422

Successful Response

Body

application/json

any

Request

JavaScriptCurlPythonHTTP

const response = await fetch('/geodatabase/metadata/boundaries', {
    method: 'POST',
    headers: {
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      "field_ids": [
        "0651038",
        "0651039",
        "0651040",
        "0658785"
      ]
    }),
});
const data = await response.json();

Response

422

{
  "detail": [
    {
      "loc": [
        "text"
      ],
      "msg": "text",
      "type": "text"
    }
  ]
}

Take a look at how you might call this method:

curl

curl -o openet.geojson.zip -L -X 'POST' \
  'https://openet-api.org/geodatabase/metadata/boundaries' \
  -H 'accept: application/json' \
  -H 'Authorization: YOUR_API_KEY' \
  -H 'Content-Type: application/json' \
  -d '{
  "field_ids": [
    "06183913",
    "06208981"
  ]
}'

Python

import gzip
import requests

# set your API key before making the request
header = {"Authorization": YOUR_API_KEY}

# endpoint arguments
args = {
  "field_ids": [
    "06183913",
    "06208981"
  ]
}

# query the api 
resp = requests.post(
    headers=header,
    json=args,
    url="https://openet-api.org/geodatabase/metadata/boundaries"
)

# unzip the data
data = eval(gzip.decompress(resp.content).decode())

print(data)