MBTiles don't show up randomly

[Kokkel]

Hi, I have an issue difficult to explain. Produced with QGIS (raster tools, XYZ-tiles (MBTiles)) a serie of MBTiles files containing arial IR photos of the Dutch Wadden Sea. Using Dutch RD-coordinates (Amersfoort coordinates, EPSG:28992). Using zoomlevels 1 to 16 and png 600 dpi. The 'production' of the MBTiles files works fine. Put them in a seperate folder. Made a chartgroup for them, scan and rebuild chart database in OpenCPN (several times). Now the files, parts of the Dutch Wadden Sea, show or do not show up randomly. I can't find a pattern in when OK en when not. It also shifts over time. So, randomly parts of the coverend area with several MBTiles files can be used, other parts can't. Not helpfull when sailing. Charts/MBTiles that don't show up are also not visible in the pianobar. OpenGL on. Thought it was a conflict between graphic cards and drivers. But that's not the case because this issue happens on two devices (desktop and laptop). What am I missing?

[nohal]

It is hard to say without actually seeing how your files look and how the area is covered by them.

[rgleason]

Do they load in other mbtile viewers? Can you load them one at a time in OpenCPN?
Do they have the right metadata?

[Kokkel]

Find attached a screenshot with a random situation of showed and not showed retangles of MBTiles files. The whole covered area in the screenshot has MBTiles available. Mark that the areas where no MBTiles files do show up they also not visible (e.g. de-activated) in the pianobar. The files itself are too large (around 50 Mb each) to upload. Will this screenshot help to understand the issue?

[Kokkel]

All the prepared files load occassional, sometimes they all show up, but I happenes that they are disapeared the next time I load OpenCPN and/or update the chart database. I asume the metadata is right, using the XYZ to MBTiles algoritme of QGIS. Where can I check the metadata within the MBTiles?

[Kokkel]

:-; Was able to read the metadata with QGIS. This the metadata of one of the files:
Algemeen

Naam105-120-540-550-1-16-600-Ewijksluis-png.mbtilesPadD:\Kaarten\Ortho25IR\105-120-540-550-1-16-600-Ewijksluis-png.mbtilesGrootte94.12 MBLaatst aangepastzondag 21 januari 2024 10:30:52Brontype=mbtiles&url=file:///D:/Kaarten/Ortho25IR/105-120-540-550-1-16-600-Ewijksluis-png.mbtilesProviderwms

Informatie van provider

Bereik516916.7581507897120900,6954357.393721152096 9868 : 541869.9576107834000140,6971154.4483670862391591Br eedteNiet beschikbaarHoogteNiet beschikbaarDatatypeKon het rasterdatatype niet bepalen.WMS-info Tile-laag eigenschappen Cache Statistieken
Server EigenschappenEigenschapWaardeWMS-Versie
Titel
Beschrijving
Zoek/sleutelwoorden
Internetbron -Contactpersoon

Kosten
Toegangsbeperkingen
GetCapabilitiesUrlfile:///D:/Kaarten/Ortho25IR/105-120-540-550-1-16-600-Ewijksluis-png.mbtiles?x={x}&y={-y}&z={z}GetMapUrlfile:///D:/Kaarten/Ortho25IR/105-120-540-550-1-16-600-Ewijksluis-png.mbtiles?x={x}&y={-y}&z={z}GetFeatureInfoUrlfile:///D:/Kaarten/Ortho25IR/105-120-540-550-1-16-600-Ewijksluis-png.mbtiles?x={x}&y={-y}&z={z}GetLegendGraphic
Aantal tegellagen1GetTileUrl
Tile-sjablonen
FeatureInfo-sjablonen
Indelingen gereedschap Objecten identificeren
Tileset eigenschappenIdentificatieTile modusxyzXYZEigenschapWaardeTitel
Beschrijving
GeselecteerdJaCRSCRSBegrenzingsvakEPSG:3857516916. 7581507897120900,6954357.3937211520969868 : 541869.9576107834000140,6971154.4483670862391591Be schikbare tilesetstms0
Geselecteerde Tile-matrix set tms0SchaalTile-grootte [px]Tile-grootte [ke]Matrix grootteMatrixbereik [ke]GrenzenBreedteHoogteBreedteHoogteBreedteHoogteBree dteHoogteBovenLinksOnderRechts0256256611.496611.49 6655366553640075016.68557840075016.68557820037508. 342789-20037508.34278920037508.34278920037508.34278902562 561222.991222.99327683276840075016.68557840075016. 68557820037508.342789-20037508.34278920037508.34278920037508.34278902562 562445.982445.98163841638440075016.68557840075016. 68557820037508.342789-20037508.34278920037508.34278920037508.34278902562 564891.974891.978192819240075016.68557840075016.68 557820037508.342789-20037508.34278920037508.34278920037508.34278902562 569783.949783.944096409640075016.68557840075016.68 557820037508.342789-20037508.34278920037508.34278920037508.34278902562 5619567.919567.92048204840075016.68557840075016.68 557820037508.342789-20037508.34278920037508.34278920037508.34278902562 5639135.839135.81024102440075016.68557840075016.68 557820037508.342789-20037508.34278920037508.34278920037508.34278902562 5678271.578271.551251240075016.68557840075016.6855 7820037508.342789-20037508.34278920037508.34278920037508.34278902562 5615654315654325625640075016.68557840075016.685578 20037508.342789-20037508.34278920037508.34278920037508.34278902562 5631308631308612812840075016.68557840075016.685578 20037508.342789-20037508.34278920037508.34278920037508.34278902562 56626172626172646440075016.68557840075016.68557820 037508.342789-20037508.34278920037508.34278920037508.34278902562 561.25234e+061.25234e+06323240075016.6855784007501 6.68557820037508.342789-20037508.34278920037508.34278920037508.34278902562 562.50469e+062.50469e+06161640075016.6855784007501 6.68557820037508.342789-20037508.34278920037508.34278920037508.34278902562 565.00938e+065.00938e+068840075016.68557840075016. 68557820037508.342789-20037508.34278920037508.34278920037508.34278902562 561.00188e+071.00188e+074440075016.68557840075016. 68557820037508.342789-20037508.34278920037508.34278920037508.34278902562 562.00375e+072.00375e+072240075016.68557840075016. 68557820037508.342789-20037508.34278920037508.34278920037508.342789Cache-statistiekenEigenschapWaardeGoed0Ontbreekt0Fout0

[Kokkel]

All the files loads fine (and all together) in QGIS. It is an OpenCPN issue, and for me unpredictable.

[nohal]

Very unreadable At least please enclose stuff like this in the CODE tags next time to preserve formatting.
Yes, I was imagining something like what I see on your screenshot.

The algorithm composing the chart canvas was not optimized for tiled MBtiles coverage, as you can clearly see. The best I can suggest at the moment is to merge the various MBtiles files together. You can do it either in your production workflow or by merging the resulting MBTiles databases.
The size is not an issue, we have seen multigigabyte files work just fine.

[Kokkel]

Originally Posted by nohal

Very unreadable At least please enclose stuff like this in the CODE tags next time to preserve formatting.
Yes, I was imagining something like what I see on your screenshot.

The algorithm composing the chart canvas was not optimized for tiled MBtiles coverage, as you can clearly see. The best I can suggest at the moment is to merge the various MBtiles files together. You can do it either in your production workflow or by merging the resulting MBTiles databases.
The size is not an issue, we have seen multigigabyte files work just fine.

OK thanks, worth trying. I will report the results later.

[Kokkel]

Hi all, problem seems to be solved. Thanks to Nohal for the help. Solution? Less 'file-borders' by covering larger areas in one mbtiles-file, combined with not-complex filenames. I have skipped the habit to include coordinates and dpi in the filenames, just a toponym. Although the issue is not over completely it works for now.

[rgleason]

Is it worthwhile adding a note somewhere in the documentation?

Solution? Less 'file-borders' by covering larger areas in one mbtiles-file, combined with not-complex filenames. I have skipped the habit to include coordinates and dpi in the filenames, just a toponym

https://opencpn.org/wiki/dokuwiki/do...arts:mbtiles&s[]=mbtiles


This section needs some improvement by Users!