> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ST_LocateAlong

This function computes Point or MultiPoint geometries representing locations along a measured input geometry (LineString or MultiLineString) corresponding to the provided measure value(s). Polygonal geometry inputs are not supported. The output points lie directly on the input line at the specified measure positions.

Additionally, an optional `offset` parameter can shift the resulting points left or right from the input line. A positive offset displaces the points to the left side, while a negative value offsets them to the right side by the given distance.

This allows identifying precise locations along a measured linear geometry based on supplied measure values, with the ability to offset the output points if needed.

<img src="https://mintcdn.com/wherobots/fqh3gPDE0J25Lra_/images/sql-functions/ST_LocateAlong/ST_LocateAlong.svg?fit=max&auto=format&n=fqh3gPDE0J25Lra_&q=85&s=78ce2fa3a07a52594ae9027de8bf0b9f" alt="ST_LocateAlong" width="400" height="150" data-path="images/sql-functions/ST_LocateAlong/ST_LocateAlong.svg" />

## Signatures

```sql theme={"system"}
ST_LocateAlong(linear: Geometry, measure: Double, offset: Double)
```

```sql theme={"system"}
ST_LocateAlong(linear: Geometry, measure: Double)
```

## Parameters

<ParamField body="linear" type="Geometry" required>
  The linear value.
</ParamField>

<ParamField body="measure" type="Double" required>
  The measure value.
</ParamField>

<ParamField body="offset" type="Double">
  The offset value.
</ParamField>

## Return type

<ResponseField type="Geometry">
  The resulting geometry.
</ResponseField>

## Example

```sql theme={"system"}
SELECT ST_LocateAlong(
        ST_GeomFromText('LINESTRING M (10 30 1, 50 50 1, 30 110 2, 70 90 2, 180 140 3, 130 190 3)')
)
```

```
MULTIPOINT M((30 110 2), (50 100 2), (70 90 2))
```