TAPIS
Tables from APIs
or an API Explorer and a Table Manager

Co-funded by the European Union, Switzerland and the United Kingdom. Terms of Use
Privacy Statement
Access Policy


Window disposition:

Link to:









STA query URL:






Observations to create in STA Plus Service


Node with INaturalist observations

Show STAplus scheme

/
Separate columns:

Columns to separate:
Result


GroupBy:

GroupBy date rounding:
Attributes to aggregate:
Aggregations:
Select your operation:



Column name:




Select attributes:
Aggregations:

Set number of decimal figures:

Column name:







Operators and functions for the formula:
              
              
              
              
    



Set number of decimal figures:

Column name:



For each column, rows with the follow statistics will be created:
  • Mean
  • Median
  • Q1
  • Q3
  • Min. value
  • Max value
  • Mode
  • Standard deviation
  • Variance
  • Sum
  • Range
  • First value
  • Last value
  • Random value
  • Count

Rows become columns and columns become rows. Values of the header column become the new column names.
Columns
Rows
Values
Repited values aggregated by:
Choose one option

Select columns:
Select column with the entity to see more details (expand):
Title:
Author:
Geographic information
Columns
Manually

Date column
Column
Manually
Uncertainty



Temporal grouping
Column:
Period:
Time unit:
Positional grouping
Column X:
Column Y:
Distance:
m
Choose entities you want details (expand) and attributes to select
Select the criteria for sorting:


Select an element:
Select one or more elements:
Filter:
Filter Rows
Parent URL: (none)
$filter =
Filter Rows (OGC API Features)
Parent URL: (none)
filter =
Filter Rows (table)
filter =
API data and table tools
Period
To aggregate data by (Optional. Only available with "Observations"):
Position source Path:
Path:
Center Point

Row matching fields
Merged records that do not match


Node operations


Import CSV file table
Delimiter    
Encoding:


Meaning source




CSV source
Save table
CSV+CSVW
DBF
Column name, type, meaning and units
Import GeoJSON
Meaning source



GeoJSON source


Import dBASE III+, IV and MiraMon DBF Extended
DBF source

Import SQLite and GPKG
SQLite / GPKG source

Import JSON-LD
Include (Sometimes is too big to be imported)
(Forces to duplicate the geometry, if included)
JSON-LD source

Import JSON
JSON source


Title:
Position:
Geometry*:





Time Series (optional)

Add column with transformed point geometry
Input


Output
Type:


New column name(s)
Add column with transformed BoundingBox geometry
Input






Output
Type:

New column name(s)
DGGS codes table from geospatial extent
Geospatial extent




Create a new table
Geospatial user feedback
Target:


Data:
Options:
Title
Axes

Legend
Lines and points

If the chart looks odd, sort the data by the X axis column.
Type:
Data:
Error bars:
Bar values:
Options:
Bar colors:
Type:
Data layout:
Wide table:
Series mode:
All series from the selected node. Multi-node: Series mode.
Options:




Type:
Data:
One ring, or several if you choose a classification column.



Options:

Image Sources:






Upload table as STA observations

Position:




Upload statistical values to STA

Completeness

Format consistency

Format
Must contain @ and a . before the suffix.
Canonical shape: 8-4-4-4-12 hexadecimal digits.
International number: decimals after a . (e.g. 12.5). A comma as decimal separator is not accepted.
–

Misclassification matrix

Add columns to compare



Columns to compare:


In addition to the Misclassification Matrix, the following accuracy metrics will be calculated:

  • Overall Accuracy
  • Overall Error
  • Producer's Accuracy (Recall)
  • User's Accuracy (Precision)
  • Omission Error (1 − Recall)
  • Commission Error (1 − Precision)
  • Cohen's Kappa (Kappa Coefficient)

Logical consistency

Target data Reference data
Column 1 Column 1
Column 2 Column 2
Column 3 Column 3

Temporal quality

Grouping mode




Expected resolution (Values with higher resolutions will be accepted, but those with lower resolutions will not):

Format Description
YYYY Year
YYYY-MM Month
YYYY-MM-DD Day
YYYY-MM-DDTHH Hour
YYYY-MM-DDTHH:mm Minute
YYYY-MM-DDTHH:mm:ss Second
YYYY-MM-DDTHH:mm:ss.fff Fractions of a second
Number:
Time unit:

Tolerance:

Interval method:

⚠ This test may not be accurate if the data includes the original timezone’s daylight saving time change. The test applies the time change of your own country;
if your data comes from a different timezone, take this into account.
In this case, it is recommended to split the dataset into segments that do not include the transition






Positional quality

Geographic coordinates:

Grouping mode





Thematic quality

Thematic accuracy by accuracy column






Used for thematic accuracy by values and thematic validity
Grouping mode




Ask for my party information

Connect a sensor
Collected data

Sensor information
Read SD from sensor

Connect the sensor via USB. SD CSVs are listed; open one to preview, save, or use in TAPIS.

Files on the SD
CSV content

STA Entity Builder

Configure entities and observations with labelled groups (shared vs. varies). Relations are prepared per row via id_<label> columns. Does not publish; use STA Publisher.
STA Publisher