Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-38765

Geo within query requires custom crs to specify the larger of the two areas

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Works as Designed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Geo
    • Labels:
      None
    • Operating System:
      ALL

      Description

      In our Mongo database we have a test polygon defined by the following coordinates:

      0.026856601145655,53.3536401702337 -0.018187415636542,53.3543968971421 -0.016935805565727,53.381347118852 -0.01651815359378,53.3903304943447 -
      0.001490628678547,53.390079813912 -0.001911439808241,53.3810965200027 0.028136611683245,53.3805896527841 0.026856601145655,53.3536401702337

      We then use a within query to see if this polygon lies within a particular area. This one returns the above polygon:

      {{ "PId" : ObjectId("5c1bccda3930321b784dbade"), "GeoPnt" : { "$within" : { "$geometry" :

      { "type" : "Polygon", "coordinates" : [[[-33.353119999999997, -50.140853], [-33.353119999999997, 76.184997999999993], [146.24300500000001, 76.184997999999993], [146.24300500000001, -50.140853], [-33.353119999999997, -50.140853]]] }

      } } }}

      and this one does not:

      {{ "PId" : ObjectId("5c1bccda3930321b784dbade"), "GeoPnt" : { "$within" : { "$geometry" :

      { "type" : "Polygon", "coordinates" : [[[-34.353119999999997, -50.140853], [-34.353119999999997, 76.184997999999993], [146.24300500000001, 76.184997999999993], [146.24300500000001, -50.140853], [-34.353119999999997, -50.140853]]] }

      } } }}

      As you can see the test polygon is well within the polygon defined in both cases.

      I have been reading up about "big polygons" but both of these areas do not cover more than half a hemisphere so I have no idea why both of these queries do not work.

      We are using Mongo 3.6.5 and version 2.4 of the C# driver using the legacy query methods.

        Attachments

        1. secondQuery.png
          secondQuery.png
          300 kB
        2. firstQuery.png
          firstQuery.png
          297 kB

          Issue Links

            Activity

              People

              Assignee:
              kelsey.schubert Kelsey T Schubert
              Reporter:
              ihannah@meniscus.co.uk Ian Hannah
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: