Spatial ES|QL MVP with OGC functions

[craigtaverner]

Description

Based on the initial Spatial ES|QL feature set described in https://github.com/elastic/elasticsearch/issues/103587, we would like to see a modest subset of OGC compliant functions. These can be grouped into the following categories:

• Predicates
  • To be used in the WHERE clause as filters, for example FROM index | WHERE ST_WITHIN(location, "POLYGON(...)")
• Scalar functions
  • For performing calculations or transformations on spatial types, for example FROM index | EVAL area = ST_AREA(geometry)
• Statistics (Aggregations)
  • For aggregating spatial types, for example: FROM index | STATS centroid=ST_CENTROID(location) BY category)

[elasticsearchmachine]

Pinging @elastic/es-ql (Team:QL)

[elasticsearchmachine]

Pinging @elastic/elasticsearch-esql (:Query Languages/ES|QL)

[elasticsearchmachine]

Pinging @elastic/es-analytics-geo (Team:Analytics)