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

  <?php
  
  /**
   * @Document
   * @Index(keys={"coordinates"="2d"})
   */
  class City
  {
      /** @Id */
      public $id;
  
      /** @String */
      public $name;
  
      /** @EmbedOne(targetDocument="Coordinates") */
      public $coordinates;
  
      /** @Distance */
      public $distance;
  }
  
  /** @EmbeddedDocument */
  class Coordinates
  {
      /** @Float */
      public $x;
  
      /** @Float */
      public $y;
  }
  

• XML

  <indexes>
      <index>
          <key name="coordinates" value="2d" />
      </index>
  </indexes>
  

• YAML

  indexes:
    coordinates:
      keys:
        coordinates: 2d
  

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:

<?php

$cities = $this->dm->createQuery('City')
    ->field('coordinates')->near(-120, 40)
    ->execute();

Distance

When you use the near() functionality a distance will be calculated and placed in the property annotated with @Distance:

<?php

foreach ($cities as $city) {
    echo $city->name.': '.$city->distance."\n";
}

GeoNear Query

You can also execute queries based on spherical geometry to provide accurate distances over a sphere such as our planet Earth. Using the distanceMultiplier method you can let Mongo do the distance calculation in the measurement of your choice. Check for the nearest cities to a given latitude and longitude with the near($latitude, $longitude) method:

<?php

$cities = $this->dm->createQuery('City')
    ->field('coordinates')->geoNear(-120, 40)
    ->spherical(true)
    ->distanceMultiplier(6378.137) // Convert from radians with 6378.137 for km and 3963.192 miles
    ->execute();

Within Box

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

<?php

$cities = $this->dm->createQuery('City')
    ->field('coordinates')->withinBox(41, 41, 72, 72)
    ->execute();

Within Center

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

<?php

$cities = $this->dm->createQuery('City')
    ->field('coordinates')->withinCenter(50, 50, 20)
    ->execute();