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.