Skip to main content

Spatial Functions (Locked)

Row-level spatial functions. Version-gated. All require compatible datatypes (Geographic role or spatial field).

Point / Line Construction​

FunctionSignatureReturnVersion
MAKEPOINTMAKEPOINT(latitude, longitude, [SRID])Geometry2019.2+
MAKELINEMAKELINE(spatial1, spatial2)Geometry2019.2+

Spatial Predicates​

FunctionSignatureReturnVersion
INTERSECTSINTERSECTS(spatial1, spatial2)Boolean2019.2+
BUFFERBUFFER(geometry, distance, unit)Geometry2024.1+

BUFFER units: 'miles', 'kilometers', 'meters', 'feet'. Case-insensitive.

Distance and Measurement​

FunctionSignatureReturnVersion
DISTANCEDISTANCE(spatial1, spatial2, unit)Number2019.2+
AREAAREA(polygon, unit)Number2020.4+
LENGTHLENGTH(line, unit)Number2020.4+
CENTROIDCENTROID(geometry)Geometry2022.4+

Coordinate Extraction​

FunctionSignatureReturnVersion
XX(point)NumberExtract longitude.
YY(point)NumberExtract latitude.

Common Patterns​

  • Distance between customer and store: DISTANCE(MAKEPOINT([Cust Lat], [Cust Lon]), [Store Location], 'miles').
  • Points within X miles: DISTANCE(MAKEPOINT([Lat], [Lon]), MAKEPOINT([Target Lat], [Target Lon]), 'miles') < 25.
  • Buffer around a point: BUFFER(MAKEPOINT([Lat], [Lon]), 5, 'miles').
  • Territory containment: INTERSECTS(MAKEPOINT([Lat], [Lon]), [Territory Polygon]).

Common Anti-Patterns​

  • Passing city name to MAKEPOINT (needs numeric lat/lon).
  • Missing unit argument on DISTANCE, AREA, LENGTH.
  • BUFFER with negative distance (results vary by connector).
  • Nested BUFFER on already-buffered geometries (perf concern).

Version Notes​

  • MAKEPOINT, MAKELINE, DISTANCE, INTERSECTS: Desktop 2019.2+.
  • AREA, LENGTH: Desktop 2020.4+.
  • CENTROID: Desktop 2022.4+.
  • BUFFER: Desktop 2024.1+.

If the user's Desktop version is older, refuse the write per HC#2 or route to alternative logic (e.g., pre-computed distance columns in the data source).