Accessing Data

In the overview of the GLODAP Collection, we can see that there are one tabular, and one raw dataset.

By clicking a dataset you are presented with the overview of the dataset. Here we can see all the information stored about the dataset, and how we easily can interact with it from the SDK / API. But we can't download tabular data from the portal.

Helpful identifiers to reference the dataset in the SDK

If we open the raw dataset, we can download it. But watch out, it's over 3 gigabytes!

List of files available in a raw dataset overview

Querying tabular data is done with the SDK.

Querying data with OQS (Object Query Structure)

To really dive deep into our data, we can use OQS. This is a powerful tool to query our data - and the platform in general.

We will cover the basics of OQS here, but for more in-depth information, check out the OQS documentation and existing examples.

# This query filters for numbers in the column "algaes" that are larger than 100
{
    "#GREATER_THAN": [
        "$algaes",
            100
    ]
}

# A more advanced example. If you have worked with postGIS before, you might recognize the function st_within.
# ST_WITHIN let's you query data based on where it's located. 

{
        "#ST_WITHIN": [ # We want to use the ST_WITHIN operator
            "$Location", # The column for geographic positioning to reference is called "Location"
            # The other variable passed to ST_WITHIN is a geojson polygon that defines an area of interest. 
            {
                "type": "Polygon",
                "coordinates": [
            [
              9.04377719472356,
              60.53184223620184
            ],
            [
              1.6375918981582913,
              60.53184223620184
            ],
            [
              1.6375918981582913,
              58.33547726647117
            ],
            [
              9.04377719472356,
              58.33547726647117
            ],
            [
              9.04377719472356,
              60.53184223620184
            ]
        ],
            },
        ]
    }