Storing spatial points in Symfony 2 / Doctrine 2 Entities?
doctrine, doctrine-orm, php, symfony
Solution
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/
Problem
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! :)