Hi Jason
Simple things first: Are your city lat/lng values stored in degrees, or
radians? I'm guessing the former (from a database consistency perspective), so
you will need to convert them when passing them into a search.
If I've guessed wrong, let me know and I'll keep pondering.
Cheers
--
Pat
On 23/07/2012, at 8:24 PM, Jason Gilmore wrote:
> I am getting an odd result set returned from TS searching. Here is my index
> definition:
> <pre><code>
> # Thinking Sphinx #############################################
> define_index do
> indexes :name
> indexes :description
> indexes tags.name, :as => :tag_name
> indexes city.name, :as => :city_name
>
> has "RADIANS(locations.latitude)", :as => :latitude, :type =>
> :float
> has "RADIANS(locations.longitude)", :as => :longitude, :type =>
> :float
>
> set_property :latitude_attr => :latitude, :longitude_attr =>
> :longitude
>
> end
>
> ###############################################################
> </code></pre>
>
> I run searches based on distance from a lat/lon pair that is determined by
> current location or center of city lat/lon. The basic search is as follows:
>
> <pre><code>
> c = City.find_by_name("New York City")
> Location.search(:geo => [c.latitude, c.longitude], :order => "@geodist ASC")
> </code></pre>
>
> This should find the 20 closest locations to the center of New York City, but
> instead it finds 20 locations in Austin, Texas. If I instead search for the
> closest locations to the center of Austin, TX I get locations in San Diego,
> CA. San Diego returns Seattle, WA. Seattle returns Miami, FL. I have verified
> the lat/lon pair of each of these cities and the location lat/lon is
> automatically generated by a call to google maps.
>
> In addition, the results are in order of distance from the supplied lat/lon,
> they just aren't the closest by far.
>
> Is there some other config I'm missing? Did I do something wrong? Any help is
> much appreciated.
>
> Jason Gilmore
> developer - www.the42.com
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/thinking-sphinx/-/CUVdiKdZ89QJ.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/thinking-sphinx?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
