I came up with an idea on a potential fix for this while talking about Challenges with my wife yesterday… I haven’t worked through all the phrasing, or the actual implementation, but the basic idea is:
I can add a boolean (true/false) field on the City records, so that I can mark certain cities as “subset”. I can then ignore those for Challenges that aren’t attached to a specific city.
So, there could still be a Challenge to complete every Street in La Cité-Limoilou within 2020, but the March Mania Challenge would only apply to streets in Québec.
I just realized, in scrolling back up this thread for two example cities, that @davemorin already suggested this when he wrote:
Features like “exclude streets in this selected city” or automatically verifying every street to ensure it only exists once seem really complicated.
I think I’ve set up the data in a way that should make this fairly manageable…
I did not save the admin level on the city record, so I think I just lost out on automating this. There are 5 regions that pull cities in bulk from multiple admin levels, and there are an unknown number of cities that I manually imported as a one-off that were at a different admin level from the rest of the cities in that region. This totals somewhere between 6k - 10k “subset” cities.