Querying Tabular Data

Querying tabular data happens in the /list endpoint of the tabular data controller.

This endpoint can be more easily accessed with our python SDK.

Example 1: Here, we are asking for data where the county is Hordaland and from the Year 2019, assuming we have a column called county which contains strings, and a column called Year which contains integers.

json

{
  "#AND": [
    {
      "#EQUALS": [
        "$County",
        "Hordaland"
      ]
    },
    {
      "#GREATER_THAN": [
        "$Year",
        2019
      ]
    }
  ]
}

Example 2: We can also query data based on the location of the data points. For example, we can query data points that are within a certain polygon.

json

{
  "#ST_WITHIN": [
    "$Location",
    "POLYGON((4.0 59.0, 5.0 59.0, 5.0 60.0, 4.0 60.0, 4.0 59.0))"
  ]
}

Coordinates can be filtered using two formats: Well-Known Text (WKT) or GeoJSON Format.

Check out our reference for more information on how to use query with OQS here.