在Symfony 2 / Doctrine 2实体中存储空间点？

Question

Symfony 2 doesn't have the spatial points datatype that MySQL supports. I couldn't find anything on the Doctrine 2 documentation about this particular data type, so, does anyone know how to work with points in Symfony 2? Also, how to query based on a radius? Thanks! :)

Answer 1

The easiest way would be to implement custom types for the spatial data types, and then declare custom DQL functions to make querying them simpler.

I wrote about this here: http://codeutopia.net/blog/2011/02/19/using-spatial-data-in-doctrine-2/