Hi Mark
I've not heard of this problem before - mind you, I've never used the geo
search in an app myself. It's really odd that it works if you're not converting
the args to radians... which leads me to wonder: are you certain the lat/lng
values in @geo_location aren't radians already?
Oh wait... (sorry, figuring this out as I type, too lazy to edit appropiately
;) - you've got the original lat/lng in there, as well as the converted
versions. I realise you need a reference to address in there to keep the join,
but I've added something for that recently.
So, instead of:
has address.lat, address.lng
Try:
join address
(This was only added in 1.3.18)
I'm wondering if Thinking Sphinx is getting confused between the lat/lng and
latitute/longitude attributes.
Hope this helps.
--
Pat
On 02/08/2010, at 3:17 AM, mark wrote:
> Hi Pat, et al,
>
> I am using Thinking Sphinx for a geo search of a large location
> database with multiple assocs.
>
> I am storing my lat/lngs as decimals in a postgres database. All of
> this stuff works nicely with GeoKit.
>
> Anyway, I really like the way TS searches and now that I have the geo
> stuff (sort of ) working I wanted to post a message about some
> interesting things I am seeing...
>
> First, when I convert from the floating point val from postgres to
> radians using the simple mixin:
>
> class Numeric
> def to_radians
> ( self / 360.0 ) * Math::PI * 2
> end
> end
>
>
> and add it to my search like such:
>
> @records = Location.search(@search_terms,
> #:geo => [...@geo_location[:lat].to_f.to_radians,
> @geo_location[:lng].to_f.to_radians ],
>
> I get records way off. I am in mission viejo and the location records
> that are coming back are in LA...
>
> However, when I remove the .to_radians and just pass in the floating
> point value for the lat/lng I get stuff very nearby...
>
> WIERD?
>
> So I am just not sure what is going on as the documentation says to
> convert lat/lng to radian.
>
> The distance is also way off... I know it is in meters so I am
> converting it to miles using alchemist:
>
> organic_map_popup.sphinx_attributes['@geodist'].meters.to.miles
>
> but it is still coming up 300 miles off!!
>
> my query looks something like this:
>
> @distance_in_miles_to_search = 300.miles.to.meters.value.to_f
>
>
> @records = Location.search(@search_terms,
> #:geo => [...@geo_location[:lat].to_f.to_radians,
> @geo_location[:lng].to_f.to_radians ],
> :geo => [...@geo_location[:lat].to_f, @geo_location[:lng].to_f ],
> :order => "@geodist ASC, @relevance DESC",
> :include => [:business, :address],
>
> :field_weights => {
> :tags => 9,
> :name => 10,
> :category => 8 },
>
> :with => {"@geodist" => 0....@distance_in_miles_to_search})
>
>
> If I change that to 30 miles it comes up with nothing...
>
>
> here is the define index on the searchable model:
>
> define_index do
>
> indexes business.name
> indexes tags.name, :as => :tags
>
> indexes business.categories.name
>
> has address.lat, address.lng
>
> has "RADIANS(addresses.lat)", :as => :latitude, :type => :float
> has "RADIANS(addresses.lng)", :as => :longitude, :type => :float
>
>
> end
>
>
> Anyway, I love thinking sphinx, but I just have never been able to use
> it correctly with geo searching...
>
> I am using:
> rails 2.3.8
> ruby 1.8.7 (ubuntu linux)
> thinking-sphinx (1.3.18)
> sphinx-0.9.9
>
> Any help would be totally appreciated!
>
> All the best,
> Mark McDonald
>
> --
> 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.
>
--
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.
