Correction - all addresses that have a latitude/longitude have at least a location.
On Dec 3, 2011, at 10:58 AM, Manish M. Shah wrote: > All addresses have at least a location (city/country/postal/etc) and each > does have at least one listing. > > Heres the output: > > DEPRECATION WARNING: Rake tasks in vendor/plugins/thinking-sphinx/tasks are > deprecated. Use lib/tasks instead. (called from > /Library/Ruby/Gems/1.8/gems/rails-2.3.11/lib/tasks/rails.rb:10) > Stopped search daemon (pid 917). > Generating Configuration to > /Users/manish/AcceleWeb/srcror/getmethe.com/config/development.sphinx.conf > Sphinx 0.9.9-release (r2117) > Copyright (c) 2001-2009, Andrew Aksyonoff > > using config file > '/Users/manish/AcceleWeb/srcror/getmethe.com/config/development.sphinx.conf'... > indexing index 'address_core'... > collected 223 docs, 0.0 MB > sorted 0.0 Mhits, 100.0% done > total 223 docs, 5027 bytes > total 0.155 sec, 32263 bytes/sec, 1431.23 docs/sec > indexing index 'address_delta'... > collected 0 docs, 0.0 MB > total 0 docs, 0 bytes > total 0.037 sec, 0 bytes/sec, 0.00 docs/sec > distributed index 'address' can not be directly indexed; skipping. > total 5 reads, 0.000 sec, 16.8 kb/call avg, 0.1 msec/call avg > total 14 writes, 0.000 sec, 14.3 kb/call avg, 0.0 msec/call avg > Started successfully (pid 2838). > > On Dec 3, 2011, at 10:54 AM, Pat Allan wrote: > >> Right, well it's likely this is the bigger issue. Do all addresses have a >> city? And do all have at least one listing? What's the output when you run >> the ts:index rake task? >> >> -- >> Pat >> >> On 03/12/2011, at 10:43 PM, Manish M. Shah wrote: >> >>> There should be - but it's not returning all of them :( >>> >>> On Dec 3, 2011, at 10:36 AM, Pat Allan wrote: >>> >>>> Wait, there's 49 addresses, but only 11 get returned if you don't use a >>>> geo point? Surely there should be a full page of 20? >>>> >>>> -- >>>> Pat >>>> >>>> On 03/12/2011, at 10:32 PM, Manish M. Shah wrote: >>>> >>>>> >>>>> I have 49 total addresses and 15 don't have valid lat/lng values (they >>>>> are null). >>>>> >>>>> For those that are null, at least from an app perspective, this is fine - >>>>> but could that be causing Sphinx to get confused? >>>>> >>>>> >>>>> >>>>> On Dec 3, 2011, at 6:39 AM, Pat Allan wrote: >>>>> >>>>>> Right, well it seems Sphinx is doing something odd when you supply >>>>>> co-ordinates then, even through you're not filtering on geodist. Do all >>>>>> Addresses have valid lat/lng values? >>>>>> >>>>>> -- >>>>>> Pat >>>>>> >>>>>> On 02/12/2011, at 7:42 PM, Manish M. Shah wrote: >>>>>> >>>>>>> That's correct, this is the version I use if no lat/lng is set : >>>>>>> @addresses = Address.search :order => :listing_created_at, :sort_mode >>>>>>> => :desc >>>>>>> >>>>>>> It returns 11 results. >>>>>>> >>>>>>> >>>>>>> On Dec 2, 2011, at 4:47 AM, Pat Allan wrote: >>>>>>> >>>>>>>> Hm, and if you search with no arguments, you get a full paginated set >>>>>>>> of results, right? >>>>>>>> >>>>>>>> -- >>>>>>>> Pat >>>>>>>> >>>>>>>> On 02/12/2011, at 11:53 AM, Manish M. Shah wrote: >>>>>>>> >>>>>>>>> Ahh :) >>>>>>>>> >>>>>>>>> I got rid of has latitude, longitude and reindexed and got 2 items >>>>>>>>> for SF and 4 items for NY :< >>>>>>>>> >>>>>>>>> Manish >>>>>>>>> >>>>>>>>> On Dec 1, 2011, at 11:49 PM, Pat Allan wrote: >>>>>>>>> >>>>>>>>>> Sorry, just to confirm - you want to keep the radians attributes, >>>>>>>>>> but remove the ones that aren't in radians. So, keep these: >>>>>>>>>> has "RADIANS(latitude)", :as => :lat, :type => :float >>>>>>>>>> has "RADIANS(longitude)", :as => :lng, :type => :float >>>>>>>>>> >>>>>>>>>> But remove this: >>>>>>>>>> has latitude, longitude >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Pat >>>>>>>>>> >>>>>>>>>> On 02/12/2011, at 11:43 AM, Manish M. Shah wrote: >>>>>>>>>> >>>>>>>>>>> Without Radians - it returns 1 result for Chicago and 5 results for >>>>>>>>>>> San Francisco, much less then db has. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Dec 1, 2011, at 11:38 PM, Pat Allan wrote: >>>>>>>>>>> >>>>>>>>>>>> Is it any better if you don't have the non-radians latitude and >>>>>>>>>>>> longitude attributes? >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> Pat >>>>>>>>>>>> >>>>>>>>>>>> On 02/12/2011, at 11:35 AM, Manish M. Shah wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Hi Path, >>>>>>>>>>>>> >>>>>>>>>>>>> Thanks for helping - >>>>>>>>>>>>> >>>>>>>>>>>>> define_index looks like this in Address model: >>>>>>>>>>>>> >>>>>>>>>>>>> define_index do >>>>>>>>>>>>> has latitude, longitude >>>>>>>>>>>>> has "RADIANS(latitude)", :as => :lat, :type => :float >>>>>>>>>>>>> has "RADIANS(longitude)", :as => :lng, :type => :float >>>>>>>>>>>>> >>>>>>>>>>>>> indexes city >>>>>>>>>>>>> indexes listings.title, :as => :listing_title >>>>>>>>>>>>> indexes listings.description, :as => :listing_description >>>>>>>>>>>>> indexes listings.categories.name, :as => :category_names >>>>>>>>>>>>> indexes listings.created_at, :as => :listing_created_at, >>>>>>>>>>>>> :sortable => true >>>>>>>>>>>>> set_property :delta => true >>>>>>>>>>>>> end >>>>>>>>>>>>> >>>>>>>>>>>>> That's the full query I'm running. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Dec 1, 2011, at 11:31 PM, Pat Allan wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Is that the entire search query you're running? There's no >>>>>>>>>>>>>> keywords or distance filters? >>>>>>>>>>>>>> >>>>>>>>>>>>>> Also, what does your define_index block look like for the >>>>>>>>>>>>>> Address model? >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> Pat >>>>>>>>>>>>>> >>>>>>>>>>>>>> On 02/12/2011, at 11:24 AM, mrmanishs wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> When I do a: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> @addresses = Address.search :geo => [@lat, @lng], :order => >>>>>>>>>>>>>>> "@geodist >>>>>>>>>>>>>>> ASC, @relevance DESC" >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I only get 4 results back. I know for a fact that I have a lot >>>>>>>>>>>>>>> more >>>>>>>>>>>>>>> addresses available with further geo-distances then the 4 >>>>>>>>>>>>>>> returned >>>>>>>>>>>>>>> when I select the city of Chicago >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> However, for the city of San Francisco, I only get 2. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Is there a configuration that tells geo search to return only a >>>>>>>>>>>>>>> certain distance away, or is there a default set? >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I can't figure out what's going on... >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> 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. >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> 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. >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> 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. >>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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. >>>>>>> >>>>>>> -- >>>>>>> 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. >>>>> >>>>> -- >>>>> 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. >>> >>> -- >>> 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. > > -- > 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.
