I need an advice for a service.

On our website we have a search for events. Users are especially interested in the location of event so they use that filter a lot but the problem is that in our database we have sometimes England sometimes UK so we cannot provide them the information they are looking for.

Do you have any experience with this? We store the location of events in plain text (e.g. "London, UK") and we would like to use something more sophisticated. So in the future user will be able to search for events in London and in 100km radius for example. (so we show them also the events in Oxford.)

I have no experience with GEO location so maybe it's something simple maybe not.

  • 1
    You can do this kind of thing in Elasticsearch, Solr, Postgres, MongoDB -- the list goes on. As it stands, though, your question is too broad, as it seems to include two questions. How to deal with England or UK and how to do combined geo/text searches. You might want to read the tour for guidelines on asking a focused question in this format. In the meantime, if you look at the docs for something like Elasticsearch, you should have something to get you started. – John Powell Feb 8 '16 at 11:26

You need either a Thesaurus that maps your search-terms to general terms (e.g. UK-->England, United Kingdom --> England, ...) or a gazetteer-service that does the same but also provides functionalties to search by geo-location and get the the name stored within that database that relates to that location (e.g. (60, 0) --> London).

Both are available on the web via open services, e.g. http://www.gazetteer.org.uk/

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy