Geospatial Queries
MongoDB supports query operations on geospatial data. This section introduces MongoDB’s geospatial features.
Geospatial Data
In MongoDB, you can store geospatial data as GeoJSON objects or as legacy coordinate pairs.
GeoJSON Objects
To calculate geometry over an Earth-like sphere, store your location data as GeoJSON objects.
To specify GeoJSON data, use an embedded document with:
a field named
type
that specifies the GeoJSON object type anda field named
coordinates
that specifies the object’s coordinates.If specifying latitude and longitude coordinates, list the longitude first and then latitude:
- Valid longitude values are between
-180
and180
, both inclusive. - Valid latitude values are between
-90
and90
, both inclusive.
- Valid longitude values are between
For example, to specify a GeoJSON Point:
For a list of the GeoJSON objects supported in MongoDB as well as examples, see GeoJSON objects.
MongoDB geospatial queries on GeoJSON objects calculate on a sphere; MongoDB uses the WGS84 reference system for geospatial queries on GeoJSON objects.
Legacy Coordinate Pairs
To calculate distances on a Euclidean plane, store your location data as legacy coordinate pairs and use a 2d index. MongoDB supports spherical surface calculations on legacy coordinate pairs via a 2dsphere index by converting the data to the GeoJSON Point type.
To specify data as legacy coordinate pairs, you can use either an array (preferred) or an embedded document.
- Specify via an array ( Preferred):
-
If specifying latitude and longitude coordinates, list the longitude first and then latitude; i.e.
- Valid longitude values are between
-180
and180
, both inclusive. - Valid latitude values are between
-90
and90
, both inclusive.
- Valid longitude values are between
- Specify via an embedded document:
-
If specifying latitude and longitude coordinates, the first field, regardless of the field name, must contains the longitude value and the second field, the latitude value ; i.e.
- Valid longitude values are between
-180
and180
, both inclusive. - Valid latitude values are between
-90
and90
, both inclusive.
- Valid longitude values are between
To specify legacy coordinate pairs, arrays are preferred over an embedded document as some languages do not guarantee associative map ordering.
Geospatial Indexes
MongoDB provides the following geospatial index types to support the geospatial queries.
2dsphere
2dsphere indexes support queries that calculate geometries on an earth-like sphere.
To create a 2dsphere
index, use the db.collection.createIndex()
method and specify the string literal "2dsphere"
as the index type:
where the <location field>
is a field whose value is either a GeoJSON object or a legacy coordinates pair.
For more information on the 2dsphere
index, see 2dsphere Indexes.
2d
2d indexes support queries that calculate geometries on a two-dimensional plane. Although the index can support $nearSphere
queries that calculate on a sphere, if possible, use the 2dsphere index for spherical queries.
To create a 2d
index, use the db.collection.createIndex()
method, specifying the location field as the key and the string literal "2d"
as the index type:
where the <location field>
is a field whose value is a legacy coordinates pair.
For more information on the 2d
index, see 2d Indexes.
Geospatial Indexes and Sharded Collections
You cannot use a geospatial index as a shard key when sharding a collection. However, you can create a geospatial index on a sharded collection by using a different field as the shard key.
For sharded collections, queries using $near
and $nearSphere
are not supported. You can instead use either the geoNear
command or the $geoNear
aggregation stage.
You can also query for geospatial data for a sharded cluster using $geoWithin
and $geoIntersect
.
Covered Queries
Geospatial indexes cannot cover a query.
Geospatial Queries
Note
For spherical queries, use the 2dsphere
index result.
The use of 2d
index for spherical queries may lead to incorrect results, such as the use of the 2d
index for spherical queries that wrap around the poles.
Geospatial Query Operators
MongoDB provides the following geospatial query operators:
Name | Description |
---|---|
$geoIntersects |
Selects geometries that intersect with a GeoJSON geometry. The 2dsphere index supports $geoIntersects . |
$geoWithin |
Selects geometries within a bounding GeoJSON geometry. The 2dsphere and 2d indexes support $geoWithin . |
$near |
Returns geospatial objects in proximity to a point. Requires a geospatial index. The 2dsphere and 2d indexes support $near . |
$nearSphere |
Returns geospatial objects in proximity to a point on a sphere. Requires a geospatial index. The 2dsphere and 2d indexes support $nearSphere . |
For more details, including examples, see the individual reference page.
Geospatial Command
MongoDB provides the following geospatial command:
Command | Description |
---|---|
geoNear |
Performs a geospatial query that returns the documents closest to a given point.
|
For more details, including examples, see geoNear
reference page.
Geospatial Aggregation Stage
MongoDB provides the following geospatial aggregation pipeline stage:
Stage | Description |
---|---|
$geoNear |
Returns an ordered stream of documents based on the proximity to a geospatial point. Incorporates the functionality of
|
For more details, including examples, see <