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 m2.