To Dennis -
Spatialite and GeoPackage is *not* the same.
_How to create a GeoPackage using Spatialite SQL commands_ :
https://gis.stackexchange.com/questions/321596/how-to-create-table-with-geometry-column-in-gpkg-with-spatialite
_Using guid field af Primary Key in GeoPackage:_ The GeoPackage standard
*requires* an integer as primary key. So You can't use GUID value as PK.
However you can have a GUID value in a non-PK text field. And use these
fields in both QGIS relations and joins to combine 2 tables containing
guid text-fields.
And you might consider _creating views in GeoPackages for permanent
joins_. :
https://gis.stackexchange.com/questions/438574/create-view-and-display-in-qgis-of-a-spatial-table-in-geopackage-or-spatialite
The registered views will look like read-only tables in QGIS.
--
Med venlig hilsen / Best regards
Bo Victor Thomsen
Civ.Ing. / M.Sc.Eng.
aestasGIS Denmark
On 02/02/2025 01.06, dennis mckay via QGIS-User wrote:
In Vol 227, Issue 8 I explained my bewilderment that the processes I
have used throughout the existence of Geopackages were now not
working. I was able to solve this by downloading the latest
Spatialite and using the spatialite.exe command processor.
The successful command was of the form: SELECT
AddGeometryColumn('','control','geom_control','4269','POINT',2,true);
This had worked with an earlier version of spatialite_gui.exe
(2.0.0-devel) Same software. Now, no go.
The other problem was having populated geometry fields that were not
recognized as geometry fields. I had mistakenly been populating the
geopackage geometry columns with binary data from PostGIS tables.
I remedied this by exporting the data from PostGIS as textual
geometries, then imported into geopackage fields as
ST_GeomFromText(). A nice project would be to have both softwares
recognize the other's standards and accommodate.
An unsolved part of my mystery remains. Why can't we convert PostGIS
tables to geopackage tables and retain the Primary Fields as GUIDs? I
was able to work around this for now.
I regret providing a link to my free PDF book without clarifying that
I am not trying to sell anything. It is not a trap.
Dennis K. McKay
Retired Federal Cadastral Surveyor
_______________________________________________
QGIS-User mailing list
[email protected]
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
QGIS-User mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
