<html dir="ltr"><head></head><body style="text-align:left; direction:ltr;"><div><br></div><div>Hi,</div><div><br></div><div><br></div><div>I want to georeference a very large SQlite file (MBTiles) and include it in QGIS3. The tiles can be displayed with QGIS, but the location is not correct.</div><div><br></div><div>What is the best strategy to georeference MBTiles?</div><div><br></div><div>According to manual MBTiles does not accept worldfile (wld).</div><div>Reference: <a href="https://gdal.org/drivers/raster/mbtiles.html">https://gdal.org/drivers/raster/mbtiles.html</a></div><div><br></div><div>For correct projection scaling and XY shift is enough.</div><div><br></div><div>Is it standard to create a Custom Coordinate Reference System (CRS) in such a case?</div><div><br></div><div>Or is GDAL suitable to make a coordinate transformation?</div><div><br></div><div>Does anyone know a manual? I am grateful for any hint.</div><div><br></div><div><br></div><div>Regards,</div><div>Christian Naujoks</div><div><br></div><div><br></div><div>gdalinfo:</div><div><br></div><div>Driver: MBTiles/MBTiles</div><div>Files: map_z6-18.mbtiles</div><div>Size is 2097152, 2097152</div><div>Coordinate System is:</div><div>PROJCS["WGS 84 / Pseudo-Mercator",</div><div> GEOGCS["WGS 84",</div><div> DATUM["WGS_1984",</div><div> SPHEROID["WGS 84",6378137,298.257223563,</div><div> AUTHORITY["EPSG","7030"]],</div><div> AUTHORITY["EPSG","6326"]],</div><div> PRIMEM["Greenwich",0,</div><div> AUTHORITY["EPSG","8901"]],</div><div> UNIT["degree",0.0174532925199433,</div><div> AUTHORITY["EPSG","9122"]],</div><div> AUTHORITY["EPSG","4326"]],</div><div> PROJECTION["Mercator_1SP"],</div><div> PARAMETER["central_meridian",0],</div><div> PARAMETER["scale_factor",1],</div><div> PARAMETER["false_easting",0],</div><div> PARAMETER["false_northing",0],</div><div> UNIT["metre",1,</div><div> AUTHORITY["EPSG","9001"]],</div><div> AXIS["X",EAST],</div><div> AXIS["Y",NORTH],</div><div> EXTENSION["PROJ4","+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m <a href="mailto:+nadgrids=@null">+nadgrids=@null</a> +wktext +no_defs"],</div><div> AUTHORITY["EPSG","3857"]]</div><div>Origin = (0.000000000000000,7514065.628809665329754)</div><div>Pixel Size = (1.194328566955879,-1.194328566955879)</div><div>Metadata:</div><div> ZOOM_LEVEL=17</div><div> name=Unnamed map</div><div> type=baselayer</div><div> version=1.2</div><div> format=jpg</div><div> bounds=0.00000000,40.97989807,22.50000000,55.77657302</div><div> attribution=</div><div> scheme=tms</div><div> minzoom=5</div><div> maxzoom=17</div><div> center=11.25000000, 48.37823554, 5</div><div>Image Structure Metadata:</div><div> INTERLEAVE=PIXEL</div><div>Corner Coordinates:</div><div>Upper Left ( 0.000, 7514065.629) ( 0d 0' 0.01"E, 55d46'35.66"N)</div><div>Lower Left ( 0.000, 5009377.086) ( 0d 0' 0.01"E, 40d58'47.63"N)</div><div>Upper Right ( 2504688.543, 7514065.629) ( 22d30' 0.00"E, 55d46'35.66"N)</div><div>Lower Right ( 2504688.543, 5009377.086) ( 22d30' 0.00"E, 40d58'47.63"N)</div><div>Center ( 1252344.271, 6261721.357) ( 11d15' 0.00"E, 48d55'21.00"N)</div><div>Band 1 Block=256x256 Type=Byte, ColorInterp=Red</div><div> Overviews: 1048576x1048576, 524288x524288, 262144x262144, 131072x131072, 65536x65536, 32768x32768, 16384x16384, 8192x8192, 4096x4096, 2048x2048, 1024x1024, 512x512</div><div> Mask Flags: PER_DATASET ALPHA </div><div> Overviews of mask band: 1048576x1048576, 524288x524288, 262144x262144, 131072x131072, 65536x65536, 32768x32768, 16384x16384, 8192x8192, 4096x4096, 2048x2048, 1024x1024, 512x512</div><div>Band 2 Block=256x256 Type=Byte, ColorInterp=Green</div><div> Overviews: 1048576x1048576, 524288x524288, 262144x262144, 131072x131072, 65536x65536, 32768x32768, 16384x16384, 8192x8192, 4096x4096, 2048x2048, 1024x1024, 512x512</div><div> Mask Flags: PER_DATASET ALPHA </div><div> Overviews of mask band: 1048576x1048576, 524288x524288, 262144x262144, 131072x131072, 65536x65536, 32768x32768, 16384x16384, 8192x8192, 4096x4096, 2048x2048, 1024x1024, 512x512</div><div>Band 3 Block=256x256 Type=Byte, ColorInterp=Blue</div><div> Overviews: 1048576x1048576, 524288x524288, 262144x262144, 131072x131072, 65536x65536, 32768x32768, 16384x16384, 8192x8192, 4096x4096, 2048x2048, 1024x1024, 512x512</div><div> Mask Flags: PER_DATASET ALPHA </div><div> Overviews of mask band: 1048576x1048576, 524288x524288, 262144x262144, 131072x131072, 65536x65536, 32768x32768, 16384x16384, 8192x8192, 4096x4096, 2048x2048, 1024x1024, 512x512</div><div>Band 4 Block=256x256 Type=Byte, ColorInterp=Alpha</div><div> Overviews: 1048576x1048576, 524288x524288, 262144x262144, 131072x131072, 65536x65536, 32768x32768, 16384x16384, 8192x8192, 4096x4096, 2048x2048, 1024x1024, 512x512</div></body></html>