TAPIS: Tables from APIs for Sensors (Sensor Things API plus Explorer)

TAPIS

Tables from APIS

or an API Explerer and a Table Manager

Open
Terms of Use
Privacy Statement
Access Policy

OGC query URL:

help

Table font size ratio: %
Window disposition:
Add geolocation header
Show start node buttons only

Network URL:
Suggested stored networks:

Landing page URL:
Suggested services:

Landing page URL:
Access Key:
Secret Key:
S3 Service:
Suggested services:

Catalog URL:
Catalog version:
Consumer URL:
Suggested services:

STA query URL:

How many multidatastreams do you want to introduce?

/

Separate columns:

Columns to separate: Columns with JSON objects
Lists in columns: delimited by:

Result separed into new records
separed into new columns

Remove already present elements

GroupBy: GroupBy date rounding:	Attributes to aggregate:
	Aggregations:

Select your operation: Constant value
Autoincemental value
Empty column

Column name: Personalized

List of columns to add

Select attributes:

Aggregations:

Set number of decimal figures: Yes:

Column name: Personalized
Suggested:

List of columns to add

Attribute:

Operators and functions for the formula:

Formula:

Set number of decimal figures: Yes:

Column name: Personalized

List of columns to add

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

Choose one option Concatenate all columns
Concatenate only repeated columns

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

Number records to request:

Select the criteria for sorting:

ascending descending

Number records to skip from the start:
Number records to request:

Select an element:

Filter:

Period Property: From: To:

To aggregate data by (Optional. Only available with "Observations"): Aggregate data by:

Position source FeatureOfInterest-feature Path:
Locations-location Path:

Center Point Coordinate X:
Coordinate Y:

Operator Distance

Row matching fields

Merged records that do not match Discard Add records of 1st table Add records from both tables

Node operations:

help

Import CSV file table

Delimiter Tab Auto

Encoding:
The first line contains field names
Import numbers as strings

Meaning source Local CSVW file:
CSVW URL:
Automatic retrieve of shared meaning

CSV source Local file:
URL:
Suggested CSV URLs:

Save the table as CSV
CSV delimiter:

Import GeoJSON

Meaning source Local GeoJSON schema file:
GeoJSON schema URL:
Automatic retrieve of shared meaning

GeoJSON source Local file:
URL:
Suggested GeoJSON URLs:
External data from:

Import dBASE III+, IV and MiraMon DBF Extended

DBF source Local file:
URL:

Import JSON-LD

Include Add geometry (Sometimes is too big to be imported)
Add observations (Forces to duplicate the geometry, if included)

JSON-LD source Local file:
URL:

Import JSON

JSON source Local file:
URL:

Position: Place description:
Longitude:
Latitude:

Date and time:

Geospatial user feedback

Target: Title (mandatory to add):
Code*:
Codespace*:


	Graphic configurations Left Y axis: Legend position Axis label: Right Y axis: Legend position Axis label:

Plot type: Bar Pie

Axes: Categories:
Classification (optional):
Values:

Value labels: None Value Percentage

Variable name (optional):

Image Sources: Image URL:
Label:

Image size (px):

Variable:
Alerting value (optional):
Observation time:
Refresh time (not applicable with WebSub enabled): seconds

Refresh time: seconds

To upload data in a STA server, you should Login first.

Upload table as STA observations
Each row represents a feature of interest with several observed properties
Several observed properties of the same feature in a single column and in multiple rows

Position: Place description:
Longitude:
Latitude:

Date and time:
Sensor instance id or name:
Sensor reference or type:
STA service URL: