[wp-hackers] Geodata storage

Otto otto at ottodestruct.com
Wed Jun 9 13:31:03 UTC 2010

On Wed, Jun 9, 2010 at 8:16 AM, Dougal Campbell <dougal at gunters.org> wrote:
> First of all, having a standard for geodata will be great. I've always been
> interested in geolocation apps, even if I don't do all that much with it in
> practice. I'm curious why you decided to store the lat and long values in
> separate entries? Seems like it would be extremely rare that you'd need one
> value without the other. I think a "lat, long" pair would be convenient,
> storage wise, even though you'd have to parse it out later.

If you're searching for posts based on location, you'll want them
separate so as to make use of SQL comparisons. WHERE latitude is
between X and Y, sort of thing.


More information about the wp-hackers mailing list