Ah cool ok. And as a last question I should separate these out into two indexes on elasticsearch, one for items and one for geocoding?
On 8 September 2014 14:12, Itamar Syn-Hershko <ita...@code972.com> wrote: > 1000 entries is a very small set. If you can have this local to your code > that would be best. Otherwise yes a 2-phase query is probably your best bet > - note you could also use the suggesters to improve speed > > -- > > Itamar Syn-Hershko > http://code972.com | @synhershko <https://twitter.com/synhershko> > Freelance Developer & Consultant > Author of RavenDB in Action <http://manning.com/synhershko/> > > On Mon, Sep 8, 2014 at 4:07 PM, James <m...@employ.com> wrote: > >> Thank you for the reply. It will be 1000 entries for the UK alone. Do I >> need to have two indexes, one for geocoding and one for item search, and >> then every time a location search is done I do two queries, the first to >> get the co-ordinates and the second to search items with the co-ordinates >> >> On 8 September 2014 14:04, Itamar Syn-Hershko <ita...@code972.com> wrote: >> >>> This is just a key/value lookup. If it's not too big I'd just hold it >>> all in memory. Otherwise of course you can use Elasticsearch for that. >>> >>> -- >>> >>> Itamar Syn-Hershko >>> http://code972.com | @synhershko <https://twitter.com/synhershko> >>> Freelance Developer & Consultant >>> Author of RavenDB in Action <http://manning.com/synhershko/> >>> >>> On Mon, Sep 8, 2014 at 3:39 PM, James <m...@employ.com> wrote: >>> >>>> It's a bit hard to word this so please bear with me. I want my users to >>>> be able to search by place-name, but elasticsearch needs co-ordinates. I >>>> have a premade SQL schema with place-names associated with co-ordinates. >>>> >>>> How can I implement this from my PHP website? >>>> >>>> A) On form submit, get my PHP website to do an SQL lookup to get the >>>> co-ordinate from the place-name and send the co-ordinate to elasticsearch. >>>> >>>> B) Import my place-name to co-ordinate database into elasticsearch, >>>> then on form submit send the place-name to elasticsearch and have >>>> elasticsearch do the conversion from place-name to location. >>>> >>>> I guess what I am saying is, can I use elasticsearch as a geocoder as >>>> part of my search query or will it only accept co-ordinates? >>>> >>>> On 3 September 2014 22:52, Itamar Syn-Hershko <ita...@code972.com> >>>> wrote: >>>> >>>>> Yes >>>>> >>>>> -- >>>>> >>>>> Itamar Syn-Hershko >>>>> http://code972.com | @synhershko <https://twitter.com/synhershko> >>>>> Freelance Developer & Consultant >>>>> Author of RavenDB in Action <http://manning.com/synhershko/> >>>>> >>>>> >>>>> On Thu, Sep 4, 2014 at 12:49 AM, Employ <m...@employ.com> wrote: >>>>> >>>>>> Thank you. And no plugin is required to filter by distance, this is >>>>>> included in the core ES module? >>>>>> >>>>>> >>>>>> >>>>>> On 3 Sep 2014, at 22:19, Itamar Syn-Hershko <ita...@code972.com> >>>>>> wrote: >>>>>> >>>>>> You don't need any external geo-data, see >>>>>> http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-geo-distance-filter.html >>>>>> >>>>>> You only need external data sources if you want to give some >>>>>> coordinates / polygons names (like countries, neighborhoods etc) >>>>>> >>>>>> -- >>>>>> >>>>>> Itamar Syn-Hershko >>>>>> http://code972.com | @synhershko <https://twitter.com/synhershko> >>>>>> Freelance Developer & Consultant >>>>>> Author of RavenDB in Action <http://manning.com/synhershko/> >>>>>> >>>>>> >>>>>> On Wed, Sep 3, 2014 at 11:13 PM, James <m...@employ.com> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> I'm a bit confused with this. If have results in elasticsearch with >>>>>>> lat and long coordinates, and I search using lat, long and distance >>>>>>> parameters, can elastic search return all the results within that given >>>>>>> area without me having to use any third party plugins? >>>>>>> >>>>>>> Do I need any external geo-data, or is it enough that I have my >>>>>>> co-ordinates already? >>>>>>> >>>>>>> James >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "elasticsearch" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to elasticsearch+unsubscr...@googlegroups.com. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/elasticsearch/c4626888-0014-43fb-81d8-cc6298bfd827%40googlegroups.com >>>>>>> <https://groups.google.com/d/msgid/elasticsearch/c4626888-0014-43fb-81d8-cc6298bfd827%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to a topic in >>>>>> the Google Groups "elasticsearch" group. >>>>>> To unsubscribe from this topic, visit >>>>>> https://groups.google.com/d/topic/elasticsearch/yQI82QIdEqU/unsubscribe >>>>>> . >>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>> elasticsearch+unsubscr...@googlegroups.com. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/elasticsearch/CAHTr4ZuyS053gYN-VK8ta1vzRH6vuBJAkQ%3D_XBw-y-gciXet4Q%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/elasticsearch/CAHTr4ZuyS053gYN-VK8ta1vzRH6vuBJAkQ%3D_XBw-y-gciXet4Q%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "elasticsearch" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to elasticsearch+unsubscr...@googlegroups.com. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/elasticsearch/86F7DFA5-4F62-4861-BEAF-29EA81317FD2%40employ.com >>>>>> <https://groups.google.com/d/msgid/elasticsearch/86F7DFA5-4F62-4861-BEAF-29EA81317FD2%40employ.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "elasticsearch" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/elasticsearch/yQI82QIdEqU/unsubscribe >>>>> . >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> elasticsearch+unsubscr...@googlegroups.com. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/elasticsearch/CAHTr4Zv%3DPT3jHE7YYT8dELSNx7GyhYL0qfK9%3DpwokhhxawvrzQ%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/elasticsearch/CAHTr4Zv%3DPT3jHE7YYT8dELSNx7GyhYL0qfK9%3DpwokhhxawvrzQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "elasticsearch" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to elasticsearch+unsubscr...@googlegroups.com. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/elasticsearch/CAPng%3D3fX5HxXA5KV4nyFrPb_EdDkzUmj2ZqB0Fxc5ZVLnD8jgg%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/elasticsearch/CAPng%3D3fX5HxXA5KV4nyFrPb_EdDkzUmj2ZqB0Fxc5ZVLnD8jgg%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "elasticsearch" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/elasticsearch/yQI82QIdEqU/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> elasticsearch+unsubscr...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/elasticsearch/CAHTr4ZsZ4-mP%3DKzrE3_dY8ErfMWzT9ymnjVDJn_ObuPfJJooxg%40mail.gmail.com >>> <https://groups.google.com/d/msgid/elasticsearch/CAHTr4ZsZ4-mP%3DKzrE3_dY8ErfMWzT9ymnjVDJn_ObuPfJJooxg%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "elasticsearch" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to elasticsearch+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/CAPng%3D3eZiXVO56Sz%3Dusb7KxoeH-mJ%3DDocAQch0kB5%2BAPxSjvSA%40mail.gmail.com >> <https://groups.google.com/d/msgid/elasticsearch/CAPng%3D3eZiXVO56Sz%3Dusb7KxoeH-mJ%3DDocAQch0kB5%2BAPxSjvSA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/elasticsearch/yQI82QIdEqU/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/CAHTr4Zv6Y9Tvee%3DvxkL2fKoXgzFs-ZFdu6K6xBNpx7ch3Y%2BQ7Q%40mail.gmail.com > <https://groups.google.com/d/msgid/elasticsearch/CAHTr4Zv6Y9Tvee%3DvxkL2fKoXgzFs-ZFdu6K6xBNpx7ch3Y%2BQ7Q%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAPng%3D3cTkeP9-hF-ofOCq%2BzUvvoufB7q31%2B7N2i0E5OwcrrVeg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.