Amazon Athena
User Guide  | API Reference

What is a Geospatial Query?

Geospatial queries are specialized types of SQL queries supported in Athena. They differ from non-spatial SQL queries in the following ways:

  • Using the following specialized geometry data types: point, line, multiline, polygon, and multipolygon.
  • Expressing relationships between geometry data types, such as distance, equals, crosses, touches, overlaps, disjoint, and others.

Using geospatial queries in Athena, you can run these and other similar operations:

  • Find the distance between two points.
  • Check whether one area (polygon) contains another.
  • Check whether one line crosses or touches another line or polygon.

For example, to obtain a pair of double type coordinates from the geographic coordinates of Mount Rainier in Athena, use the ST_POINT (double, double) ((longitude, latitude) pair) geospatial function, specifying the latitude and longitude:

ST_POINT(46.8527,-121.7602) ((longitude, latitude) pair)