MBTiles for OpenCPN

[stelian]

Originally Posted by sailorF54

But I have done it...
(i.e. deleting the line)

Then maybe it's the other way around: you should put it back.

That line is only for libsqlite3-dev < 3.19, if you have an older version you shall keep the line, if it's newer you must remove it.

Try dpkg -l libsqlite3-dev to find out the installed version.

[sailorF54]

Originally Posted by stelian

Then maybe it's the other way around: you should put it back.

That line is only for libsqlite3-dev < 3.19, if you have an older version you shall keep the line, if it's newer you must remove it.

Try dpkg -l libsqlite3-dev to find out the installed version.

Yes, you and Cagney are right. It's now building ok

PS It displays my first mbtiles chart fine

[nohal]

Dave...
I must have done something really bad... Second dataset grabbed from the net - https://github.com/netAction/signalk...e-map/releases

The whole content of the metadata table:

"version"	"1"
"name"	"World Coastline"
"description"	"The whole earth up to zoom level 9"

We will need some more logic besides the current stuff relying on the meta information being present and correct...

While trying to simplify the GL crash case, it is now gone and I'm not at all sure why. Will keep trying

Pavel

[sailorF54]

Good news for linux users (at least Ubuntu 16.04)
SASplanet works fine with (the rather old version of) Wine (1:1.6.2-0ubuntu14.2)
and produces mbtiles charts that can be read by O !!!

[LeaseOnLife]

Dave and team, this is great news!

Originally Posted by conachair

Looks really handy! Thanks.

WHat seetings are you using in sasplanet? Can't seem to get it to work.



Works ok with this file -
https://gitlab.com/IvanSanchez/Leafl...raster.mbtiles

Conachair: I selected a square area, Bing satellite, and ticked zoom levels z10-z13, resulting in 256 files being stuffed into the mbtiles file.

Dave: Opencpn does display a satellite pic, but it does not show the deeper zoomlevels, instead I get the Overzoom warning. Is it intended to show multiple zoomlevels within one MBtiles file?

Dirk

Correction: I tried again with multiple zoom levels and it works. Must have done something wrong exporting from SASPlaneta the first time

[Gilletarom]

Hello,

With my Lenovo, W10, using USA Area 16 and 17. OpenGL ON.

I choice the chart group "All charts". By using only the MBtiles charts area, this seems to work properly. By moving the map area to have the southern boundary of the MBtiles charts in the middle of the screen, the display of the MBile charts remained correct, but the CM93 chart was bad. See screen copy On the top, MBtiles, Below CM93.

Then, I created a group of MBtiles charts. But I do not change the choice of chart group. So, initially, All charts.
The MBTiles have disappeared from the screen.
Then, switching between the groups of charts, I obtained again, either :
- the MBtiles, correct
- the CM93, correct
- or all the charts (but with the same problem that in the screen copy).

Gilletarom

[Hakan]

I've successfully built on Win10 VS2017.
Then tried to load the "MBTILES_21.mbtiles" from NOAA.
O halt on charts update procedure:
Log:

14:52:54: Searching directory: C:\Users\admin\Documents\Charts\mbTiles for *.kap
14:52:54: Searching directory: C:\Users\admin\Documents\Charts\mbTiles for *.geo
14:52:54: Searching directory: C:\Users\admin\Documents\Charts\mbTiles for *.000
14:52:54: Searching directory: C:\Users\admin\Documents\Charts\mbTiles for *.s57
14:52:54: Searching directory: C:\Users\admin\Documents\Charts\mbTiles for 00300000.a
14:52:54: Searching directory: C:\Users\admin\Documents\Charts\mbTiles for *.mbtiles
14:52:54: Loading chart data for C:\Users\admin\Documents\Charts\mbTiles\MBTILES_21.mbtiles
>>>>O hangs

OK - restart OCPN and a new attempt to load and update the Puerto Rico mbTiles set. Now succeed.
I found the chart on O and tried to zoom in further than "Overzoom". O hangs.
Log says:
15:10:09: Chart cache purge
15:10:49: Initializing Chart C:\Users\admin\Documents\Charts\mbTiles\MBTILES_21 .mbtiles
>> O hangs.

New attempt. This time much better.
It seems the square is not filled with charts and "Overzoom" indicated already at pictures 1&2
Not much details provided in the chart source i presume? Picture 3
Håkan

[Hakan]

OK - more details at Puerto Rico itself.

[seandepagnier]

Does this mean we can add the NOAA mbtiles to the chart downloader?

https://github.com/vokkim/noaa-nautical-charts

[BlackSea]

I don't know, what I am making wrong.

I'm building my mbtiles with mb-util (https://github.com/mapbox/mbutil/)
OpenCPN does not show any tiles.

I have suspicion, that OpenCPN needs metadata from mbtiles. But this tool doesn't produce this.

sqlite> .schema metadata
CREATE TABLE metadata
        (name text, value text);
CREATE UNIQUE INDEX name on metadata (name);
sqlite> select * from metadata;
sqlite>

[nohal]

Originally Posted by BlackSea

I don't know, what I am making wrong.

I'm building my mbtiles with mb-util (https://github.com/mapbox/mbutil/)
OpenCPN does not show any tiles.

I have suspicion, that OpenCPN needs metadata from mbtiles. But this tool doesn't produce this.

sqlite> .schema metadata
CREATE TABLE metadata
        (name text, value text);
CREATE UNIQUE INDEX name on metadata (name);
sqlite> select * from metadata;
sqlite>

Yes, at this moment the metadata is needed. But looking at the number of files having it missing or plain wrong, this will sure change.

[nohal]

Originally Posted by boat_alexandra

Does this mean we can add the NOAA mbtiles to the chart downloader?

https://github.com/vokkim/noaa-nautical-charts

I think so.

[bdbcat]

did-g...

re:
My main issue with mbtiles is there's no overzoom you can get/produce 1/3 000 tiles but if the source is 1/40 000 they will be wrong and you won't know it. Anyway it's already the case as you can find/produce these same bogus charts in kap format.

Couple of things:
- It's crazy but at least on linux debian libcurl is already pulling sqlite, using an internal version is likely asking for big troubles, same for plugins using it.

- CMake voodoo doesn't seem to work 100%; it doesn't stop on missing libsqlite3-dev but later make can't compile SQLiteCpp.

- Is it possible to use a git subtree for SQLiteCpp rather than a code dump?

1. Please explain MBTiles overzoom issue again?

2. Sure, the CMake voodoo needs work. We plan to use system sqlite3 library on linux, and embedded zero-conf version on Windows, at least. On linux, we need to query the sqlite3 version, and do the right thing with incompatible typedefs.

3. Tell me more about advantage of git subtree. I took the easy (brute-force) method with a code dump, as the CMake rules found in the SQLiteCpp git repo tries to be a Swiss army knife, and had some troubles on Windows. I also hacked it a wee bit...
Send some code improvements, if you like.

O5 Plugin API:
As always, we make a serious effort not to break existing plugins with OCPN API updates, but sometimes wxWidgets changes make it unavoidable. Situation on O5 is not yet clear....

Thanks
Dave

[bdbcat]

BlackSea...

Please post your mbtiles files that do not display.

Thanks
Dave

[bdbcat]

SailorF54...

re:
Trying to split the same zone in 4 different charts (zoom 14, 15...) with/without quilting creates havoc: not display, boat sent to 0,0 etc...
(The idea being to be able to zoom in /out on the various levels)

Sample tiles showing this problem?

Thanks
Dave