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

[dennis mckay]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250202/f2fbc1d3/attachment.htm>