[Qgis-user] QGIS-User Digest, Vol 228, Issue 3

[dennis mckay]

Thank you Bo.

This explains a lot and I appreciate knowing that views will solve some other needs of mine.

My experience though is confusing. I created many spatialite databases before geopackages arrived. I created many geopackages containing tables with text fields as PK fields and these worked fine in QGIS, even with joins.  Recently I have replaced many text fields with GUID fields. The spatialite software allows this, even for PK fields. I would like for this software to warn me that these fields are not standard and to add sequential numbering as the PK. Otherwise it is like being led into a dark room with obstacles. Another solution would be to have a geopackage only app. A third solution would be to evolve the geopackage standards. 

Again, thanks.

Dennis K. McKay

> On Feb 3, 2025, at 12:00 PM, qgis-user-request at lists.osgeo.org wrote:
> 
> Send QGIS-User mailing list submissions to
>    qgis-user at lists.osgeo.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>    https://lists.osgeo.org/mailman/listinfo/qgis-user
> or, via email, send a message with subject or body 'help' to
>    qgis-user-request at lists.osgeo.org
> 
> You can reach the person managing the list at
>    qgis-user-owner at lists.osgeo.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of QGIS-User digest..."
> 
> 
> Today's Topics:
> 
>   1. Re: Problems creating gpkg geometry columns, partial solution
>      (Bo Victor Thomsen)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Mon, 3 Feb 2025 10:53:15 +0100
> From: Bo Victor Thomsen <bo.victor.thomsen at gmail.com>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Problems creating gpkg geometry columns,
>    partial solution
> Message-ID: <8300dea3-68ba-4075-a0e3-d1e4c70ec975 at gmail.com>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
> 
> 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-0001.htm>
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> 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
> 
> 
> ------------------------------
> 
> End of QGIS-User Digest, Vol 228, Issue 3
> *****************************************