Ideal way to search for records within short distances (1-20 miles) with Sunspot and Geokit?

[viatropos]

I read a bit about the GeoHash and precision in Sunspot from these
things:

- http://groups.google.com/group/ruby-sunspot/browse_thread/thread/d368944df356c5a6
- http://geohash.org/
- http://outoftime.github.com/sunspot/docs/classes/Sunspot/DSL/RestrictionWithNear.html#M000116

But I'm not quite sure how I should go about efficiently finding
records within say exactly 5 miles.

The basic setup is:

- Geokit
- ActiveRecord models with lat/lng fields
- distance_to calculated in ruby
- Search with User.all(:within => 5, :origin => lat_lng)

I want to do this in Solr, but it looks like all I have to work with
is `precision`. What's the recommended way to do this?

Thanks so much,
Lance

[Matthew A. Brown]

Hi Lance,

If you're already using GeoKit to calculate the collection of
proximate models, you could do something like:

users = User.all(:within => 5, :origin => lat_lng, :select => :id)
User.search do
any_of do
users.each { |user| with(user) }
end
end

Mat

> --
> You received this message because you are subscribed to the Google Groups "Sunspot" group.
> To post to this group, send email to ruby-s...@googlegroups.com.
> To unsubscribe from this group, send email to ruby-sunspot...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/ruby-sunspot?hl=en.
>
>

[viatropos]

Okay, that makes sense. Getting a new error though, do you know what
this is:

If I'm searching for lat/lng/ids of these:

LAT 41.8994744 LNG -87.9403418: [7, 72, 111, 102, 175, 101, 103, 147,
209, 211, 232, 37, 196, 189, 188, 58, 90, 93, 194, 200, 61, 81, 121,
192, 193, 39, 234, 198, 63, 64, 65, 100, 79, 86, 205, 55, 43, 146, 74,
71, 207, 51, 206, 36, 80, 1, 29, 225, 204, 76, 214, 22, 213, 221, 222,
208, 57, 107, 228, 195, 60, 31, 110, 258, 230, 229, 99, 33, 219, 218,
236, 197, 70, 49, 212, 68, 73, 45, 66, 203, 106, 220, 42, 44, 10, 25,
47, 46, 94, 95, 96, 88, 174, 87, 30, 24, 187, 112, 26, 56, 59, 252,
34, 199, 48, 191, 184, 185, 227, 35, 216, 75, 247, 91, 178, 38, 186,
89, 181, 190, 52, 108, 245, 202, 19, 237, 253, 210, 145, 40, 223, 97,
164, 82, 53, 226, 54, 62, 83, 84, 85, 104, 105, 98, 166, 21, 158, 41,
50, 254, 255, 256, 128, 249, 156, 124, 125, 155, 150, 233, 23, 163,
165, 241, 242, 183, 201, 133, 134, 144, 182, 131, 238, 20, 143, 176,
142, 157, 161, 177, 159, 244, 240, 130, 251, 135, 246, 126, 257, 123,
243, 13, 154, 120, 136, 138, 2, 127, 149, 67, 118, 119, 17, 151, 115,
116, 171, 167, 250, 170, 179, 153, 169, 168, 259, 235, 217, 18, 4,
148, 114, 117, 113, 160, 92, 172, 129, 8, 248, 224, 11, 162, 140, 77,
15, 152, 69, 122, 132, 141, 137, 139, 173, 28, 5, 9]

I get this:

EOFError: end of file reached
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/protocol.rb:
135:in `sysread'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/protocol.rb:
135:in `rbuf_fill'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/timeout.rb:67:in
`timeout'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/timeout.rb:101:in
`timeout'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/protocol.rb:
134:in `rbuf_fill'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/protocol.rb:
116:in `readuntil'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/protocol.rb:
126:in `readline'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/http.rb:2028:in
`read_status_line'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/http.rb:2017:in
`read_new'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/http.rb:1051:in
`request'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/http.rb:1037:in
`request'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/http.rb:543:in
`start'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/http.rb:1035:in
`request'
from .rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/net/http.rb:772:in
`get'
from .rvm/gems/ruby-1.8.7-p302@rails238/gems/rsolr-0.12.1/lib/
rsolr/connection/net_http.rb:16:in `get'
from .rvm/gems/ruby-1.8.7-p302@rails238/gems/rsolr-0.12.1/lib/
rsolr/connection/requestable.rb:36:in `request'
from .rvm/gems/ruby-1.8.7-p302@rails238/gems/rsolr-0.12.1/lib/
rsolr/client.rb:34:in `request'
from .rvm/gems/ruby-1.8.7-p302@rails238/gems/sunspot-1.2.1/lib/
sunspot/search/abstract_search.rb:35:in `execute'
from .rvm/gems/ruby-1.8.7-p302@rails238/gems/sunspot_rails-1.2.1/
lib/sunspot/rails/searchable.rb:306:in `solr_execute_search'
from .rvm/gems/ruby-1.8.7-p302@rails238/gems/sunspot_rails-1.2.1/
lib/sunspot/rails/searchable.rb:139:in `solr_search'
from (irb):1

What is this from?

On Feb 3, 9:35 pm, "Matthew A. Brown" <mat.a.br...@gmail.com> wrote:
> Hi Lance,
>
> If you're already using GeoKit to calculate the collection of
> proximate models, you could do something like:
>
> users = User.all(:within => 5, :origin => lat_lng, :select => :id)
> User.search do
>   any_of do
>     users.each { |user| with(user) }
>   end
> end
>
> Mat
>
>
>
> On Thu, Feb 3, 2011 at 20:06, viatropos <lancejpoll...@gmail.com> wrote:
> > I read a bit about the GeoHash and precision in Sunspot from these
> > things:
>

> > -http://groups.google.com/group/ruby-sunspot/browse_thread/thread/d368...
> > -http://geohash.org/
> > -http://outoftime.github.com/sunspot/docs/classes/Sunspot/DSL/Restrict...

[Matthew A. Brown]

Looks like an error at the Solr level -- check the Solr logs (they're
in your log/ directory as well)

[Greg]

Hi Lance

I stumbled across this error a few days ago.

By default, the Jetty package that ships with Sunspot is configured to
accept a maximum HTTP GET request of 4KB. If your query is any longer
than this, the request truncates and you will get the EOF error.

Take a look at the the patch that I submitted to increase the limit to
64KB:
https://github.com/outoftime/sunspot/commit/46ba229b291a895ddc1398005276809336ea5f1c

Hope that helps.

Greg