STS_SetDefaultParameters function

The STS_SetDefaultParameters function sets the default parameters for building subtrack tables.

Syntax

STS_SetDefaultParameters(
       parameters     BSON)
returns INTEGER

parameters: A BSON document that contains parameters for building the subtrack table and its associated indexes. For the syntax of the parameters, see Spatiotemporal indexing parameters.

Usage

Use the STS_SetDefaultParameters function to create a default BSON parameters document that is used when you omit the BSON parameters document from the STS_SubtrackCreate function. The STS_SetDefaultParameters function inserts the BSON parameters document into the STS_DefaultParametersTable table. The default BSON parameters document does not affect any existing subtrack definitions.

To update the existing BSON parameters document, run the STS_SetDefaultParameters function with a new BSON parameters document.

To remove the BSON parameters document, specify NULL in the STS_SetDefaultParameters function.

Returns

0 = The parameters are stored in the STS_DefaultParametersTable table.

An exception = An error.

Example

The following example creates a default properties document in the STS_DefaultParametersTable table:

EXECUTE FUNCTION STS_SetDefaultParameters(
        '{
        "averageMovingGPSRate":10,
        "minStationaryInterval":300,
        "maxStationaryDistance":1,
        "minNoDataInterval":900,
        "maxGPSTimeIntervalPerTrajectory":1800,
        "maxMovingTrajectoryArea":128000  
       }'::JSON::BSON
);

Readings for moving objects are taken at an average of every 10 seconds. Objects must not move more that 1 meter in 5 minutes to be considered stationary. If data is missing for an object for 15 minutes, the object has an interrupted signal status. Each trajectory is limited to 30 minutes and a bounding box area of 128000 m².