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:








STA query URL:

/
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):
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


Import GeoJSON
Meaning source



GeoJSON source


Import dBASE III+, IV and MiraMon DBF Extended
DBF 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

Position:



Geospatial user feedback
Target:




Graphic configurations


Plot type:
Axes:



Image Sources:







Upload table as STA observations

Position: