Here's one that has me stumped: Members has_many Businesses has_many Addresses (geo coded).
I'd like to be able to do a geo search on members within a distance of an origin point. I have successfully implemented the search using a rolled up primary_address lat and long (rolled up to the member record). However, that doesn't quite address the need. Ideally, the search index would include a row for each member/business/address which I could then do a geo search against. I would then like to restrict the returned search result set to distinct instances of the matching members. This would allow me to display the single member record even if the geo search included two associated addresses for the member to business to address associations. Here's a real example: One member has a business located in Seattle and a second business located in Portland. I'd like to search for all members within 25 miles of Seattle and return the member. Then do a search within 500 miles of Seattle (which would match both address records) but return a single instance of the member. Any idea on how to configure this index and Sphinx query? Thanks for any assistance, Andrew Lippert CTO Biznik --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
