Is it possible to store and query Array Spatial Data in CosmosDB?

user_447448 0
Viewed 300

Here is a sample document that we would like to store:


{
  "name": "Joe Bloggs",
   "locations": [
        { "type": "Point", "coordinates": [1,1] },
        { "type": "Point", "coordinates": [2,2] }
   ]
}

The key feature of the document is that the "locations" property is an array of GeoJSON points.

According to the documentation it is possible to define an indexing policy for the locations array.

However, it's not clear whether spatial queries such as ST_WITHIN can be used to search, for example, whether any of the points in the array fall within a certain radius of a specified point.

My question: Does CosmosDB support indexing and querying of spatial data when stored in an array?

azure-cosmosdb
1 Answers

From private conversation with CosmosDB:

Can it be indexed?

yes, you just need to index /locations/[]/? or /locations/*

Can it be queried?

yes, you can query over an array of points by using a JOIN to unwind the array.

SELECT * FROM c JOIN loc IN c.locations WHERE ST_DISTANCE(loc, @myLocation) < @distance

user_4474480
Related