Documentdb - GeoSpatial returning empty rows

Question

ST_WITHIN is not giving results, always return zero records.

here is the example:

select *
FROM Areas a
WHERE ST_WITHIN({'type': 'Point', 'coordinates':[31.9, -4.8]}, a.location)

Expecting above query should return one record.

my database entries are

{
  "id": "MyDesignatedLocation",
  "location": {
    "type": "Polygon",
    "coordinates": [
      [
        [
          31.8,
          -5
        ],
        [
          32,
          -5
        ],
        [
          32,
          -4.7
        ],
        [
          31.8,
          -4.7
        ],
        [
          31.8,
          -5
        ]
      ]
    ]
  }
}

Aravind Krishna R. · Accepted Answer · 2016-11-01 16:37:12Z

1

By default, DocumentDB returns results only for path-data type combinations that are indexed. Based on your description, it looks like you do not have Polygons included for Spatial indexing (in projection, the results will be returned via scans).

In order to get results back, please change the indexing policy to include Spatial index on the Polygon data type (See sample indexing policy below). More details here: https://azure.microsoft.com/en-us/documentation/articles/documentdb-geospatial/

{    
   "automatic":true,
   "indexingMode":"Consistent",
   "includedPaths":[
      {
         "path":"/*",
         "indexes":[
            {
               "kind":"Range",
               "dataType":"String",
               "precision":-1
            },
            {
               "kind":"Range",
               "dataType":"Number",
               "precision":-1
            },
            {
               "kind":"Spatial",
               "dataType":"Point"
            },
            {
               "kind":"Spatial",
               "dataType":"Polygon"
            }                
         ]
      }
   ],
   "excludedPaths":[
   ]
}

answered Nov 1, 2016 at 16:37

Aravind Krishna R.

8,00332 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Siva Over a year ago

For some reason it didn't save indexing policy. Above example is working fine. I am trying below coordinates but it's returning empty records. jsoneditoronline.org/?id=fee820b236ba62089566603fcfe20c7a here is the query SELECT * FROM c where ST_WITHIN({'type':'Point', 'coordinates': [81.136727, 16.188537]}, c.boundary)

David Makogon Over a year ago

@Siva - Please don't post additional issues / queries in comments. Instead, please edit your question. Otherwise, questions end up getting hidden within answers (so, they're less visible, and also disappear if the answer is ever removed). Also risks turning the comments area into a discussion (and this is an unsupported communication model).

Siva Over a year ago

It's working fine i figured out coordinates should be counterclockwise.

Collectives™ on Stack Overflow

Documentdb - GeoSpatial returning empty rows

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest