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
