Geospatial Functions

AMPS includes a function for calculating the distance from a signed latitude and longitude.

Function Parameters Description

Function	Parameters	Description
`GEO_DISTANCE`	first_latitude, first_longitude, second_latitude, second_longitude	Returns a double that contains the distance between the point identified by first_latitude, first_longitude and second_latitude, second_longitude in meters. For example, given a home point and a message containing `/lat` and `/long` fields, you could use the following expression to calculate the distance from home. `GEO_DISTANCE( /lat, /long, 40.786337, -119.206508)` AMPS uses the haversine formula when computing distances.

GEO_DISTANCE

first_latitude, first_longitude, second_latitude, second_longitude

Returns a double that contains the distance between the point identified by first_latitude, first_longitude and second_latitude, second_longitude in meters.

For example, given a home point and a message containing /lat and /long fields, you could use the following expression to calculate the distance from home.

GEO_DISTANCE( /lat, /long, 40.786337, -119.206508)

AMPS uses the haversine formula when computing distances.