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

[Benjamin Frisch]

Jared came in at about 8:30am today.
Ben

On Mon, Feb 3, 2025 at 3: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
> *****************************************
>

-- 
Please consider Friends Seminary's commitment to environmental 
sustainability before printing this email.

The contents of this message 
may be privileged and confidential.  If this message was received in error, 
please delete it without reading it.  Your receipt of this message is not 
intended to waive any applicable privilege. Please do not disseminate this 
message without the permission of the author. Any views or opinions 
expressed by the author of this email are not necessarily those of the 
School. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250203/d602f139/attachment.htm>