Brian Sperlongano

@cbeddow wondering if you're planning to continue working on this?

@TomPohys can we run CI on this please so we can have some sense of the tile size metrics at least?

I'm not a fan of using the ISO codes in the boundaries, and I think it was a mistake and a hack to do it at the `admin_level=2` level in...

> It would be great to be able to hide or show state boundaries by country from the style. I think this is out of scope for a general-purpose tile...

Good question. I'm going to run a full z14 .mbtiles of a US state, then run the same query, and then intersect that list against this list and see if...

That reduced the count slightly, to 265 unused indexes.

It appears that at least some of these indexes are actually auto-generated by imposm, so those should be filtered out so we're only looking at a list of indexes that...

I've updated this list to only include indexes that are actually created by the layer SQL (excludes imposm auto-generated indexes)

Results from incomplete planet run of the transportation layer(s): ``` openmaptiles=# select indexrelname, idx_scan from pg_stat_all_indexes where schemaname = 'public' and indexrelname like 'osm_transportation%'; indexrelname | idx_scan -------------------------------------------------------------+------------ osm_transportation_name_network_osm_id_idx |...

From overnight planet render of the place layer (aborted before completion): ``` indexrelname | idx_scan ---------------------------------------------------------+---------- spatial_ref_sys_pkey | 8 osm_island_point_pkey | 0 osm_island_point_geom | 23823324 osm_state_point_pkey | 8 osm_state_point_geom |...