<div dir="ltr"><div class="gmail_default" style="font-family:garamond,times new roman,serif;font-size:small">Jared came in at about 8:30am today.</div><div class="gmail_default" style="font-family:garamond,times new roman,serif;font-size:small">Ben</div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Mon, Feb 3, 2025 at 3:00 PM <<a href="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send QGIS-User mailing list submissions to<br>
<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:qgis-user-request@lists.osgeo.org" target="_blank">qgis-user-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:qgis-user-owner@lists.osgeo.org" target="_blank">qgis-user-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of QGIS-User digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Problems creating gpkg geometry columns, partial solution<br>
(Bo Victor Thomsen)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Mon, 3 Feb 2025 10:53:15 +0100<br>
From: Bo Victor Thomsen <<a href="mailto:bo.victor.thomsen@gmail.com" target="_blank">bo.victor.thomsen@gmail.com</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Problems creating gpkg geometry columns,<br>
partial solution<br>
Message-ID: <<a href="mailto:8300dea3-68ba-4075-a0e3-d1e4c70ec975@gmail.com" target="_blank">8300dea3-68ba-4075-a0e3-d1e4c70ec975@gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
To Dennis -<br>
<br>
Spatialite and GeoPackage is *not* the same.<br>
<br>
_How to create a GeoPackage using Spatialite SQL commands_ : <br>
<a href="https://gis.stackexchange.com/questions/321596/how-to-create-table-with-geometry-column-in-gpkg-with-spatialite" rel="noreferrer" target="_blank">https://gis.stackexchange.com/questions/321596/how-to-create-table-with-geometry-column-in-gpkg-with-spatialite</a><br>
<br>
_Using guid field af Primary Key in GeoPackage:_ The GeoPackage standard <br>
*requires* an integer as primary key. So You can't use GUID value as PK.<br>
<br>
However you can have a GUID value in a non-PK text field. And use these <br>
fields in both QGIS relations and joins to combine 2 tables containing <br>
guid text-fields.<br>
<br>
And you might consider _creating views in GeoPackages for permanent <br>
joins_. : <br>
<a href="https://gis.stackexchange.com/questions/438574/create-view-and-display-in-qgis-of-a-spatial-table-in-geopackage-or-spatialite" rel="noreferrer" target="_blank">https://gis.stackexchange.com/questions/438574/create-view-and-display-in-qgis-of-a-spatial-table-in-geopackage-or-spatialite</a><br>
<br>
The registered views will look like read-only tables in QGIS.<br>
<br>
-- <br>
Med venlig hilsen / Best regards<br>
<br>
Bo Victor Thomsen<br>
Civ.Ing. / M.Sc.Eng.<br>
aestasGIS Denmark<br>
<br>
<br>
On 02/02/2025 01.06, dennis mckay via QGIS-User wrote:<br>
> In Vol 227, Issue 8 I explained my bewilderment that the processes I <br>
> have used throughout the existence of Geopackages were now not <br>
> working.? I was able to solve this by downloading the latest <br>
> Spatialite and using the spatialite.exe command processor.<br>
><br>
> The successful command was of the form:? SELECT <br>
> AddGeometryColumn('','control','geom_control','4269','POINT',2,true); <br>
> This had worked with an earlier version of spatialite_gui.exe <br>
> (2.0.0-devel)? Same software.? Now, no go.<br>
><br>
> The other problem was having populated geometry fields that were not <br>
> recognized as geometry fields.? I had mistakenly been populating the <br>
> geopackage geometry columns with binary data from PostGIS tables.<br>
><br>
> I remedied this by exporting the data from PostGIS as textual <br>
> geometries, then imported into geopackage fields as <br>
> ST_GeomFromText().? A nice project would be to have both softwares <br>
> recognize the other's standards and accommodate.<br>
><br>
> An unsolved part of my mystery remains.? Why can't we convert PostGIS <br>
> tables to geopackage tables and retain the Primary Fields as GUIDs?? I <br>
> was able to work around this for now.<br>
><br>
> I regret providing a link to my free PDF book without clarifying that <br>
> I am not trying to sell anything.? It is not a trap.<br>
><br>
> Dennis K. McKay<br>
> Retired Federal Cadastral Surveyor<br>
><br>
><br>
> _______________________________________________<br>
> QGIS-User mailing list<br>
> <a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
> List info:<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe:<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20250203/6d46c8c3/attachment-0001.htm" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20250203/6d46c8c3/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
------------------------------<br>
<br>
End of QGIS-User Digest, Vol 228, Issue 3<br>
*****************************************<br>
</blockquote></div>
<br>
<font face="Georgia">Please consider Friends Seminary's commitment to environmental sustainability before printing this email.<br><br>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. <br></font>