st_geometry_interpolation option

This database option takes a semicolon delimited set of key=value pairs (key1=value1;key2=value2;...). Allowed keys are relative-tolerance-percent and absolute-tolerance.

relative-tolerance-percent=DOUBLE Use relative-tolerance-percent to specify the maximum variation, expressed as a percent, allowed in the distance from the center point of the ST_CircularString segment to the interpolated ST_LineString segment, relative to the radius of the ST_CircularString segment. The minimum allowed value for relative-tolerance-percent is 0, meaning the absolute-tolerance setting is always used.
absolute-tolerance=DOUBLE Use absolute-tolerance to specify the maximum absolute variation, expressed in linear units, allowed in the distance from the center point of the ST_CircularString segment to the interpolated ST_LineString segment. The minimum value allowed for absolute-tolerance is also the tolerance specified by the SRID.

If neither key is specified, relative-tolerance-percent defaults to 0.3, which gives 40 points in a complete circle, and absolute-tolerance defaults to the tolerance specified by the SRID.

If only one key is specified, the other key is set to its minimum value.

If both keys are specified, the minimum number of points is produced such that all restrictions are satisfied.

Can be set for an individual connection or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role.

Regardless of the setting for this database option, there are at least three points per curve segment. Furthermore, no two consecutive points on the interpolated ST_LineString are within tolerance of each other.

Additional points may be added to ensure the ST_Envelope of the ST_LineString is the same as that of the original ST_CircularString.

st_geometry_interpolation option

Allowed values

Defaults

Scope

Remarks

See also