[Qgis-user] Problems creating gpkg geometry columns, partial solution

[Bo Victor Thomsen]

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
> QGIS-User at lists.osgeo.org
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250203/6d46c8c3/attachment.htm>