I want to use mbtiles in a project so I am generating mbtiles for a selected area of osm.
Extent (xmin, xmax, ymin, ymax):
I was a bit surprised to find out that I wasn't able to find a record for these values
z = 14 y = 5412 x = 8390
Query I am running:
select tile_data from tiles where zoom_level=14 and tile_column=8390 and tile_row=5412;
has no results.
select tile_data from tiles where zoom_level=14 and tile_column=8390;
has 28 results, where tile_row ranges from 10960 through 10987.
So I thought I would take xyz tile exports for the same area and settings to see if it has a tile for the given xyz and IT DOES!
I don't understand how this is possible! Is there something I am missing while exporting mbtiles? OR is this a bug in QGIS?