Hi John,
Thanks for getting back to me.
The following commands are used to create the view (from a bash script), they
include creating the unique index on station_no. QGIS is still unable to load
the layer, despite listing it as a spatial table in the database.
I have not tried using the stati
Hi Brent,
I've often found that the problem with views has come from the id column. Does
the integer "station_no" column have a unique constraint? It may need one.
I put some notes on Spatialite views in this Stack Exchange answer a few years
ago.
https://gis.stackexchange.com/a/301444/64762
