Enhancement: Venue Duplication in the Admin

[allella]

When adding events from the admin side, the venue list shows many of the address options twice.

You'd expect some overlap / duplication if organizers used slight variations , but I'm curious how that list is being generated and perhaps there's something causing many of them to show the same option twice.

OpenWorks shows 4 times, but there are two of each variant.

Originally posted by @allella in #240 (comment)

[bogdankharchenko]

after thinking about this - it will be a bit of challenge to actually de-duplicate this data -- since we are getting this data from providers who send us this data -- including lat/lon which sometimes come in slightly off depending on the precision they give provide us.

One option is, to take all the data that comes in, and standardize it, using a geocoder for example.

Thoughts? @allella @irby

[irby]

@bogdankharchenko Would be my first time working with geocoding. What did you have in mind in terms of how the inputs and outputs would be sanitized?

[allella]

I'm not opposed to pairing down the venue feature. It's causing a lot of trouble and we don't even have a feature on the site that's attempting to show events by venue.

It would be nice, but in the past we did a simple version of this by tagging organizations, like tag #1 = OpenWorks and I use that to do a dashboard at OpenWorks. It's not perfect, but certainly less trouble than trying to normalize venues across 3 or more event services.