Welcome, Guest
Username: Password: Remember me

TOPIC: Database Error Importing mbtiles Raster Image

Database Error Importing mbtiles Raster Image 6 years 1 month ago #11684

  • SkunkApe
  • SkunkApe's Avatar
  • Offline
Steps to Reproduce:
1. in ArcGIS Pro, create .tif using the MOSIAC Raster Function Template (NOAA survey .bag file & footprint clipped from ArcGIS hosted image service) - there's a few Raster Function templates I use to create final .tif as well, I can give those details if needed.
2. Export Mosaic from ArcGIS Pro using 'Copy Rastar' Geoprocessing tool
3. Convert .tif mosaic into mbtiles file using the 'Maptiler Desktop' tool. (I can provide specific Maptiler Desktop settings such as zoom levels and resampling if needed)
4. Import mbtiles image file into Reefmaster

Results: The following Database message displays four times in a row:
Database Error
SQL logic error or missing database views may not be indexed


The mbtiles image in question looks okay, resolution looks okay, however after exporting the Map Project from Reefmaster as .at5, ->Shaded Relief, the Map Project doesn't create the at5 files (ready to use files). The files look like they're being created in the C:\Users\matte\AppData\Local\Temp folder, but after IMC is done compiling, no Shaded Relief folder exists in the folder designated in Map Project Export dialog box.
Attachments:
Last Edit: 6 years 1 month ago by SkunkApe.
The administrator has disabled public write access.

Database Error Importing mbtiles Raster Image 6 years 1 month ago #11685

  • Matt
  • Matt's Avatar
  • Offline
So just to clarify, this MBTiles file has been created using Maptiler and then imported into RM?
An MBTiles file is just a SQLite database with entries for each image tile, and this error is being generated by SQLite itself.
Any chance you can share an example of one of these MBTiles files to This email address is being protected from spambots. You need JavaScript enabled to view it. so that I can take a look? Perhaps generate a smaller map area if the file is very large, so long as the original error remains.
The administrator has disabled public write access.

Database Error Importing mbtiles Raster Image 6 years 1 month ago #11687

  • SkunkApe
  • SkunkApe's Avatar
  • Offline
Hi Matt,
See answers below:

Q: "So just to clarify, this MBTiles file has been created using Maptiler and then imported into RM?"
A: Yes. I've been using Maptiler Desktop because it's so much faster to convert the large .tif files to mbtiles. Global Mapper is super slow and QGIS often crashes during mbtile conversion/export process. However my Maptiler Desktop just expired and I wanted wait to see if it's worth renewing considering all the database errors I'm getting when importing the mbtiles image files into Reefmaster

I sent a link to my Google Driive folder that has one of these mbtiles mosaics I converted from a .tif in ArcGIS. Let me if you need a smaller file and I'll try to create asap.
**UPDATE** I put a smaller MBTiles file in G-Drive folder and sent a to This email address is being protected from spambots. You need JavaScript enabled to view it.. I confirmed this file throws db errors when importing in RM.

Thanks again.
Last Edit: 6 years 1 month ago by SkunkApe.
The administrator has disabled public write access.
SCROLL TO TOP