The feed
The feed describes itself, so your BI tool discovers the tables and their columns automatically when you connect.
The tables
Section titled “The tables”- One table per survey type, named from the survey type, with that type’s fields as real, typed columns (text, number, date, and so on).
- A flat Observations table across all survey types, carrying just the common columns, for a quick cross-type view.
Every table includes a set of common columns alongside the survey’s own fields: an id, the survey type,
when it was created and updated, its review state and visibility, the data and location check results, and
a lat and lon pulled from the record’s geometry.
Filtering and shaping
Section titled “Filtering and shaping”The feed honors the query options BI tools send, so the tool can pull only what it needs:
- choose columns (
$select), - get a total count (
$count), - page through large tables automatically, and
- filter (
$filter) on the status columns (reviewState,visibility,qaStatus,geoVerdict,id) and any survey field, witheq,ne,gt,ge,lt,le,and,or,not, andcontains/startswith/endswith.
For example, a tool can ask for only approved records of one species.