MongoDB Geospatial queries in php

Question

I'm trying to use MongDBs 2d indexing to run geospatial queries, as outlined here - http://www.mongodb.org/display/DOCS/Geospatial+Indexing

It's working fine, and I'm able run queries such as

db.places.find( { point : { $near : [151.1955562233925,-33.87107475181752]  , $maxDistance : 0.1/111} } )

from the CLI tool, but when I try and run the query in PHP (using the PECL mongo driver) I'm not able to get any results.

Any help with how to write the above query for PHP? Does anyone know if the PHP driver supports geospatial queries?

Thanks

Answer 1

I have geo lookup with the PHP driver working in production. It looks something like this:

$latLong = $geo->lookupLatLong($address);
$cursor = $coats->find(Array('latLong' => Array('$near' => $latLong)))->limit(10);

Also, you might want to consider using $nearSphere as opposed to $near to get more accurate coordinates. See the mongo docs for more information.

Answer 2

According to documentation in MongoDB website

{ $near: { $geometry: { type: "Point" , coordinates: [ <longitude> , <latitude> ] }, $maxDistance: <distance in meters>, $minDistance: <distance in meters> } }

The php code for the above query would be:

$query = array(
                'loc' => array(
                    '$near' => array(
                        '$geometry' =>array(
                            'type' => 'Point',
                            'coordinates'=>array(floatval($lon),floatval($lat)),
                            '$maxDistance' => intval($max_distance),
                            '$mixDistance' => intval($min_distance)))));

Answer 3

An example of using the $nearSphere command in PHP would look something like:

$lonlat = array($lon, $lat);
$cursor = $this->collection->find(Array('loc' => Array('$nearSphere' => $lonlat)))->limit($limit);

Where 'loc' is the 2d geospatial index and limit is optional.