You are browsing a version that is no longer maintained.

Geospatial Queries

You can execute some special queries when using geospatial indexes like checking for documents within a rectangle or circle.

Mapping

First, setup some documents like the following:

  • PHP
    1<?php /** * @Document * @Index(keys={"coordinates"="2d"}) */ class City { /** @Id */ public $id; /** @Field(type="string") */ public $name; /** @EmbedOne(targetDocument="Coordinates") */ public $coordinates; /** @Distance */ public $distance; } /** @EmbeddedDocument */ class Coordinates { /** @Field(type="float") */ public $x; /** @Field(type="float") */ public $y; }
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
  • XML
    1<indexes> <index> <key name="coordinates" order="2d" /> </index> </indexes>
    2
    3
    4
    5
  • YAML
    1indexes: coordinates: keys: coordinates: 2d
    2
    3
    4

Near Query

Now you can execute queries against these documents like the following. Check for the 10 nearest cities to a given longitude and latitude with the near($longitude, $latitude) method:

1<?php $cities = $this->dm->createQuery('City') ->field('coordinates')->near(-120, 40) ->execute();
2
3
4
5

GeoNear Command

You can also execute the geoNear command using the query builder's geoNear() method. Additional builder methods can be used to set options for this command (e.g. distanceMultipler(), maxDistance(), spherical()). Unlike near(), which uses a query operator, geoNear() does not require the location field to be specified in the builder, as MongoDB will use the single geospatial index for the collection. Documents will be returned in order of nearest to farthest.

1<?php $cities = $this->dm->createQuery('City') ->geoNear(-120, 40) ->spherical(true) // Convert radians to kilometers (use 3963.192 for miles) ->distanceMultiplier(6378.137) ->execute();
2
3
4
5
6
7
8

If the model has a property mapped with @Distance, that field will be set with the calculated distance between the document and the query coordinates.

1<?php foreach ($cities as $city) { printf("%s is %f kilometers away.\n", $city->name, $city->distance); }
2
3
4
5

Within Box

You can also query for cities within a given rectangle using the withinBox($x1, $y1, $x2, $y2) method:

1<?php $cities = $this->dm->createQuery('City') ->field('coordinates')->withinBox(41, 41, 72, 72) ->execute();
2
3
4
5

Within Center

In addition to boxes you can check for cities within a circle using the withinCenter($x, $y, $radius) method:

1<?php $cities = $this->dm->createQuery('City') ->field('coordinates')->withinCenter(50, 50, 20) ->execute();
2
3
4
5