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
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
Choose the way to get to the Entity you want to filter
Select the criteria for sorting:


Select an element:
Filter:
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 the table as CSV

Column name, type, meaning and units
Import GeoJSON
Meaning source



GeoJSON source


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

Import Geopackage
Geopackage 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 geometry
Input





Type:



New column
DGGS codes table from geospatial extent
Geospatial extent




DGGS code type:


Create a new table
Geospatial user feedback
Target:





Graphic configuration

X axis

Y axis
Plot type:
Axes:



Image Sources:






Upload table as STA observations

Position:




Upload statistical values to STA

Completness omission


Logical consistency
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

Grouping mode