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-requ...@lists.osgeo.org wrote: > > Send QGIS-User mailing list submissions to > qgis-user@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-requ...@lists.osgeo.org > > You can reach the person managing the list at > qgis-user-ow...@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.thom...@gmail.com> > To: qgis-user@lists.osgeo.org > Subject: Re: [Qgis-user] Problems creating gpkg geometry columns, > partial solution > Message-ID: <8300dea3-68ba-4075-a0e3-d1e4c70ec...@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@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@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 > ***************************************** _______________________________________________ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
