Hello Dennis,
I don't know I understood your problem, but a GeoPackage is internally a
SQlite-Database with SpataLite-extension and without native field-types
GUID or UUID.
The SpatiaLite-provided function CreateUUID "returns a Version 4
(random) UUID (Universally unique identifier)"
(https://www.gaia-gis.it/gaia-sins/spatialite-sql-5.0.1.html). These
values can be stored in text or blob-columns, perhaps as default-value
and primary key, which then are usable in QGis as any other
text/blob-column.
I don't know a QGis-JOIN-function (?), but I successfully tested the
*SQL*-JOIN-Syntax in QGis DB-Manager and as source for a virtual layer
joining two tables via two columns type "text" containing common
CreateUUID-generated UUIDs (QGis 3.40.3 under Linux).
hth
Ludwig
Am 02.02.25 um 01:36 schrieb dennis mckay via QGIS-User:
I am building several interconnected geopackage tables. I am using
the JOIN function in QGIS (3.40.2, OSGeo4W, Windows 10) where I
noticed that the GUID fields do not appear as possibilities, nor do
they appear under Properties > Fields. All my JOINS are with GUID fields.
With tables without geometries, the GUID fields appear and will join
together nicely. In Spatiallite.exe, looking at the same geopackage
file, these GUID fields appear. QGIS also recognizes these GUIDs in
identical tables in PostGIS, where they are joined together nicely.
I would like help understanding how to get QGIS to recognize these
GUID fields, or is this behavior a "feature"?
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
