Automatically calculate country codes per quadkey & remove country_iso flag about open-buildings HOT 2 OPEN

@cholmes is it worth thinking about using the dataset-links.csv here https://github.com/microsoft/GlobalMLBuildingFootprints#what-does-the-data-include

We could cross ref that with another list that has the iso-2 codes perhaps?

from open-buildings.

Interesting - yeah, that dataset will be perfect for querying the microsoft buildings as in #27 as it doesn't use iso-2 code, it uses the region name. So for that we need the lookup from quadkey to region name. I'm curious what that one does if the quadkey overlaps two regions - my guess is it just uses the centroid as they use region for the hive column so you wouldn't really want too. It's at zoom 9 I think, but good to know that it's only 6.3mb.

I think it may make sense to start mostly from scratch, as I think we want all possible countries (or regions) that are in a quadkey. Starting at zoom 9 probably makes good sense. I think the ideal is columns for iso-2, region and quadkey. I don't think it should be too hard to generate this with a script - just iterate through every quadkey and if it overlaps with one or more countries then add a row with the quadkey and the country codes. It should correspond exactly to whatever country file was used to create the data. That reminds me I should upload the one I've been using to source.coop - I just made it from overture using their recommended way in the docs.

from open-buildings.