Add polygonContain to Query

[dplewis]

Mongo has a $geoIntersects that I want to use to return all polygons that contains a single point. Unfortunately it only supports 2dsphere indexes and parse-server currently doesn't use geoJson.

Maybe we can reopen #524 to support legacy coordinates (2d) as well as geoJSON (2dsphere) indexes.

Adding Type Polygon to Schema?

[flovilmart]

We need to introduce a new type to the schéma, i’m all Open for it as Long as we don’t break legacy points. We’ll also need to define those types in the client SDKs!

[dplewis]

I've also read the 2dsphere indexes can cover multiple geospatial fields in a document. It might get rid of that MongoDB only supports one GeoPoint field in a class error

[flovilmart]

Yeah if using polygons obviously :)

[dplewis]

Maybe a tool to convert legacy to 2dsphere would help.

[flovilmart]

Yeah but that imply migrating data in production more likely, which could be problematic at large scale.

[dplewis]

The main issue I see is $nearSphere. I can test for 2d vs 2dsphere but the rest format are different.

2d

location : { 
    $nearSphere : [ -73.9667, 40.78 ], 
    $maxDistance: 0.10 
}

2dsphere

location: {
    $nearSphere: {
        $geometry: {
              type : "Point",
              coordinates : [ -73.9667, 40.78 ]
        },
        $maxDistance: 0.10
    }
}

For polygonContain I could only use geojson for Type Polygon and keep geopoints 2d for now

[flovilmart]

Also the indexes are different and I’m not sure you can index the same column 2 2D and 2dsphere

[dplewis]

You can have multiple geospatial indexes per collection. Unless you are using $geoNear which we aren't using. I just created both on the same collection without problems.

https://docs.mongodb.com/manual/core/2dsphere/#geonear-and-geonear-restrictions

[dplewis]

I'll probably do 2dsphere indexes for legacy GeoPoints at a later date just closing this for now.

[madsb]

Could the $nearSphere dilemma be solved by adding the equivalent SDK methods for a $geoWithin query? We could have withinCenterSphereRadians and the equivalent withinCenterSphereMiles and withinCenterSphereKilometers convenience methods. Then, for people who wants to use 2dsphere indexes, add in the documentation that the legacy calls to $nearSphere are deprecated? I don't know about adding the indexes… maybe for starters we would have to do that manually?

[flovilmart]

@madsb do you wanna try adding a PR for it? Which version of mongodb do they start using those indexes?

[madsb]

I'll try to take a stab at it. I think $geoWithin queries are supported from version 2.4 and upwards: https://docs.mongodb.com/manual/reference/operator/query/geoWithin/