infinite-industries / infinite

MIT License
5 stars 3 forks source link

Manually fix bad venue data #316

Open rlmead opened 1 year ago

rlmead commented 1 year ago

Currently, map links are the only address-related data that Infinite users can access, so we're going to prioritize fixing these links. They're used on the Directions button on an event's page:

Image

You can find a list of all venues that need corrected map links in the unmapped_venues sheet of this spreadsheet.

Here's a useful query to find some of the bad venue map links in the venues table:

select id, name, g_map_link from venues where g_map_link not like 'https://goo%' and g_map_link not like 'https://www.google.com%';

The list returned here may not be comprehensive - could be worth doing some other data validation checks, too.