Yeah, that sounds about right. Duplicate records, with an attribute for path_id or equivalent, so you can group by it to ensure one record per path.
-- Pat On 12/08/2011, at 9:00 PM, Zack Ham wrote: > Oh ok I think we are talking about different things. So there will be > duplicate records (with different lat/lng) in the Sphinx index, you're > just talking about pulling out the positions in my application > database. Am I understanding correctly? > > On Fri, Aug 12, 2011 at 3:54 AM, Pat Allan <[email protected]> wrote: >> Hi Zack >> >> You can pull in association data - so, I'd have a single model, Point, which >> would pull in the fields and attributes from other models if necessary (eg: >> Path). There'll be some examples in the docs for this: >> http://freelancing-god.github.com/ts/en/indexing.html >> >> -- >> Pat >> >> On 12/08/2011, at 8:41 PM, Zack Ham wrote: >> >>> Would these be separate indexes then? I need to do full text search >>> and filter/sort on various attributes - is this still possible? >>> >>> On Fri, Aug 12, 2011 at 12:30 PM, Pat Allan <[email protected]> >>> wrote: >>>> I would have separate records for each point, which have a path_id, which >>>> would perhaps be your current table? Don't duplicate data, just use >>>> associations. >>>> >>>> -- >>>> Pat >>>> >>>> On 12/08/2011, at 5:36 PM, zackham wrote: >>>> >>>>> Thanks for the quick response! >>>>> >>>>> Would that require inserting duplicates of all records, with the only >>>>> difference being the lat/lng? Feels odd doubling my data set but I am >>>>> new to Sphinx and unfamiliar with the implications. >>>>> >>>>> On Aug 12, 4:37 am, Pat Allan <[email protected]> wrote: >>>>>> Sphinx only comprehends a single lat/lng value for a document/record - >>>>>> so, you'll need a record for each point you want to match on. You could >>>>>> then have a path_id for each point, and group by point_id - thus >>>>>> ensuring only one record per point. >>>>>> >>>>>> -- >>>>>> Pat >>>>>> >>>>>> On 12/08/2011, at 3:09 AM, zackham wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> We are implementing a search of paths where direction of the path is >>>>>>> not relevant. The paths can be pretty long (hundreds of miles or >>>>>>> more) so when we search for a path proximate to a particular location, >>>>>>> we need to look at the start and end points of the paths and only use >>>>>>> the more proximate of the two points for sorting/ranking. Any ideas >>>>>>> how this can be accomplished? >>>>>> >>>>>>> -- >>>>>>> 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 >>>>>>> athttp://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.
