Come up with a strategy for preventing duplicate venues from being added. Some ideas:
Check venue name, case-insensitive
...and/or address
...and/or coordinates
Fix existing duplicate venues
All known duplicate venues were deduplicated on 4/2/2023. If we need to do more deduplication in the future, here's what we do for each set of duplicate venues:
Identify which one we'll keep and which one(s) we'll soft-delete
In the events table, change all venue IDs for those that will be soft-deleted to the ones that we're keeping
Prevent new duplicate venues from being added
Come up with a strategy for preventing duplicate venues from being added. Some ideas:
Fix existing duplicate venues
All known duplicate venues were deduplicated on 4/2/2023. If we need to do more deduplication in the future, here's what we do for each set of duplicate venues:
eventstable, change all venue IDs for those that will be soft-deleted to the ones that we're keeping