there can be issues with views, especially if the resulting field list is long. Where there is limited screen space, it seems more natural to follow a join field.
*Mike Bundock* | CEO Augview | P O Box 125046, St Heliers, Auckland 1740, New Zealand p: +64 9 575 5298 | m: +64 27 575 5298 | e: mailto:[email protected] <[email protected]>| w: www.augview.net Winner of Innovation & Commercialisation and Supreme Awards at 2014 NZ Spatial Excellence Awards Winner of Innovation & Commercialisation Award at 2014 Asia Pacific Spatial Excellence Awards On Sat, 18 Oct 2025, 8:19 am John Stevenson - BGS, <[email protected]> wrote: > We have also had success with views. There are a few queries to run to > register them correctly. You can do this via the QGIS Database manager. > DB Browser for SQLite is also good. Note that the view must include an > integer ID to render correctly in some settings. > > > > CREATE VIEW IF NOT EXISTS "view_locality_geology" AS > > SELECT > > loc.fid as fid, > > loc.name as name, > > loc.rock_type, > > geo.minerals as colour, > > geo.age as age, > > loc.geometry as geometry > > FROM locality as loc > > LEFT JOIN geological_units geo on geo.rock_type= rock_type; > > > > INSERT INTO gpkg_contents > > VALUES('view_locality_geology,'features','view_locality_geology','View > with geology information at locality > positions','2023-09-15T13:21:52.679Z',NULL,NULL,NULL,NULL,4326); > > > > INSERT INTO gpkg_geometry_columns > > VALUES('view_locality_geometry','geometry','POINT',4326,1,0); > > > > > > *From:* QGIS-User <[email protected]> *On Behalf Of *Mike > Bundock via QGIS-User > *Sent:* 17 October 2025 20:28 > *To:* Simon Dietmann <[email protected]> > *Cc:* qgis-user <[email protected]> > *Subject:* Re: [Qgis-user] save a join between attribute and table in > gpkg? > > > > hi > > we had a similar issue in that we could not find a way of saving join > information. The technique we ended up using was to extend the qml syntax > to support join field definitions, and use a small function to re-establish > joins correctly. This is really useful if the same sets of tables are used > in multiple projects. Its simply a matter of loading the qml files using > the layer -> properties -> load style function. > > > > We also use it as an easy method to define the join fields within other > applications such as Augview. It means that UI behaviour within multiple > applications is consistent and only needs defining once. > > > > hope that is helpful. If you want to use the same syntax, let me know & i > will send some documentation. > > > > regards > > > > *Mike Bundock* | CEO > > Augview | P O Box 125046, St Heliers, Auckland 1740, New Zealand > > p: +64 9 575 5298 | m: +64 27 575 5298 | e: > mailto:[email protected] <[email protected]>| w: > www.augview.net > > [image: Image removed by sender.][image: Image removed by sender.] > [image: Image removed by sender.] > > Winner of Innovation & Commercialisation and Supreme Awards at 2014 NZ > Spatial Excellence Awards > > Winner of Innovation & Commercialisation Award at 2014 Asia Pacific > Spatial Excellence Awards > > > > On Fri, 17 Oct 2025, 11:13 pm Simon Dietmann via QGIS-User, < > [email protected]> wrote: > > Dear list, > > > > I am trying to export some feature classes inside a common gpkg that have > attribute joins to a table that’s also stored in the same gpkg. Afaics > there is no possibility to store the information about the table join also > inside the gpkg, is that correct? > > > > Is there a way to store (and share) the joins except sharing a .qgz file? > > > > Thanks for your advice, > > > > Regards > > > > Simon > > > > > > i.A. Simon Dietmann > Projektleiter | Geograph > > PGNU Planungsgesellschaft Natur & Umwelt mbH > Amtsgericht Frankfurt am Main, HRB 111938; > Geschäftsführer: Dr. Benjamin Hill, Dorit Thurm, Sebastian Braun > Hamburger Allee 45 +++ 60486 Frankfurt am Main > <https://www.google.com/maps/search/Hamburger+Allee+45+%2B%2B%2B+60486+Frankfurt+am+Main?entry=gmail&source=g> > Durchwahl: +49 69 952964-32 +++ Fax: +49 69 952964-99 > E-Mail: [email protected] +++ Web: www.pgnu.de > > > Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte > Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder > diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den > Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die > unbefugte Weitergabe dieser Mail sind nicht gestattet. > > This e-mail may contain confidential and/or privileged information. If > you are not the intended recipient (or have received this e-mail in error) > please notify the sender immediately and destroy this e-mail. Any > unauthorised copying, disclosure or distribution of the material in this > e-mail is strictly forbidden. > > _______________________________________________ > 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 > > > > This email and any attachments are intended solely for the use of the > named recipients. If you are not the intended recipient you must not use, > disclose, copy or distribute this email or any of its attachments and > should notify the sender immediately and delete this email from your > system. UK Research and Innovation (UKRI) has taken every reasonable > precaution to minimise risk of this email or any attachments containing > viruses or malware but the recipient should carry out its own virus and > malware checks before opening the attachments. UKRI does not accept any > liability for any losses or damages which the recipient may sustain due to > presence of any viruses. > >
_______________________________________________ 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
