<div dir="ltr"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>Thanks for laying everything out so clearly Régis! One other thing I
wondered about ancillary data is the ability to store images or other
external resources linked to a layer - there was some discussion about
how to manage this in Nødebo too….</div><div><br></div><div>Regards</div><div><br></div><div>Tim</div></blockquote><div><br></div><div>Hi Tim, <br></div><div>I missed that discussion sorry. I don't see why we couldn't use the sqlite DB as a blob container, as it is a supported type. <br>However, like in all electronic document storage stories, the cardinalities will probaby not fit well with the current use of simple joined layers where one layer as one joined auxiliary table.<br>Storing many pictures linked to one feature might require a "document" table and a relation table between layers and documents. <br>All this reminds me of the QEP 79 "Document Management Systems" a lot!<br><br></div><div>Cheers<br></div><div>Régis<br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-12-16 23:11 GMT+01:00 Tim Sutton <span dir="ltr"><<a href="mailto:tim@kartoza.com" target="_blank">tim@kartoza.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space">Hi<br><div><span class=""><br><blockquote type="cite"><div>On 15 Dec 2017, at 15:26, Régis Haubourg <<a href="mailto:regis.haubourg@gmail.com" target="_blank">regis.haubourg@gmail.com</a>> wrote:</div><br class="m_-6747847093353260195Apple-interchange-newline"><div><div dir="ltr"><div dir="auto">Hi all, <br><br></div><div>some years ago, we discussed of a new project file format able to store data and other ressources has been discussed. <br><br></div><div>We finally had the opportunity to make one step forward when working on the auxiliary data storage stuff. <br><br></div><div>What's the current status in QGIS 3:<br><br></div><div>- we now have an optional format ".qgz" that is a zipped file<br></div><div>- the auxiliary data storage is a sqlite database ".qgd" storing additional informations joined to classical layers (for manual labeling purposes for instance). It is NOT a spatialite database that could be the container for spatial data<br></div><div>- when zip fil format is chosen, the qgd file is stored inside the qgz. <br><br></div><div>So, the path is opened to modify the offline editing tools or other equivalent features to store their local datasource (either gpkg or sqlite) inside the qgz too. <br><br></div><div>We also now have a container for storing SVG, color ramps, pictures or any additionnal ressource that should be shipped within the project. <br><br></div><div>Now my opinion on the proposal about storing all inside a GPKG:<br><br></div><div>- I think we should first have a native "packaging" format using native qgs file, to adress what offline editing, Qconsolidate, or QFieldSync use cases requires. <br></div><div>- The "interoperability" use case should be adressed only as an option, not a default solution, since SLD conversion (and things that don't stick to standards) will alter the project. <br><br></div><div>I am in favor of discussing all that after QGIS3 is out so that we keep focused on that, and then discuss that at the Madeyra hackfest. I'd be pleased to animate a workgroup to reach common agreement, guidelines, and find a plan for that.<br></div></div></div></blockquote><div><br></div></span><div>Thanks for laying everything out so clearly Régis! One other thing I wondered about ancillary data is the ability to store images or other external resources linked to a layer - there was some discussion about how to manage this in Nødebo too….</div><div><br></div><div>Regards</div><div><br></div><div>Tim</div><div><div class="h5"><br><blockquote type="cite"><div><div dir="ltr"><div><br></div><div>Best regards !<br></div><div>Régis<br></div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">Le 15 déc. 2017 10:16, "Richard Duivenvoorde" <<a href="mailto:rdmailings@duif.net" target="_blank">rdmailings@duif.net</a>> a écrit :<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 14-12-17 13:59, Alessandro Pasotti wrote:<br>
> Hi Joana,<br>
><br>
> I think this would be a great addition to QGIS.<br>
><br>
> Big +1 from me, and thanks for the proposal.<br>
><br>
><br>
><br>
> On Thu, Dec 14, 2017 at 1:49 PM, doublebyte <<a href="mailto:joana@doublebyte.net" target="_blank">joana@doublebyte.net</a><br>
> <mailto:<a href="mailto:joana@doublebyte.net" target="_blank">joana@doublebyte.net</a>>> wrote:<br>
><br>
> Hello,<br>
><br>
> Maybe some of you are aware of the "geopackage" plugin<br>
> <<a href="https://eos.geocat.net/gitlab/joana.simoes/foss4g_gpkg/blob/master/foss4g_gpkg.pdf" rel="noreferrer" target="_blank">https://eos.geocat.net/gitla<wbr>b/joana.simoes/foss4g_gpkg/blo<wbr>b/master/foss4g_gpkg.pdf</a><br>
> <<a href="https://eos.geocat.net/gitlab/joana.simoes/foss4g_gpkg/blob/master/foss4g_gpkg.pdf" rel="noreferrer" target="_blank">https://eos.geocat.net/gitla<wbr>b/joana.simoes/foss4g_gpkg/blo<wbr>b/master/foss4g_gpkg.pdf</a>>><br>
> .The initial goal of this plugin was to enable users to save their QGIS<br>
> projects, including style and associated resources<br>
> in a extended geopackage - the qgis geopackage extension<br>
> <<a href="https://github.com/pka/qgpkg/blob/master/qgis_geopackage_extension.md" rel="noreferrer" target="_blank">https://github.com/pka/qgpkg<wbr>/blob/master/qgis_geopackage_<wbr>extension.md</a><br>
> <<a href="https://github.com/pka/qgpkg/blob/master/qgis_geopackage_extension.md" rel="noreferrer" target="_blank">https://github.com/pka/qgpkg<wbr>/blob/master/qgis_geopackage_<wbr>extension.md</a>>> <br>
> -,<br>
> and load it onto another QGIS installation; on this approach, the<br>
> project is<br>
> encoded as qgs, in a database table. Later the plugin was forked to<br>
> support<br>
> a different geopackage exension - the owc geopackage extension<br>
> <<a href="https://github.com/pka/qgpkg/blob/master/owc_geopackage_extension.md" rel="noreferrer" target="_blank">https://github.com/pka/qgpkg<wbr>/blob/master/owc_geopackage_<wbr>extension.md</a> <<a href="https://github.com/pka/qgpkg/blob/master/owc_geopackage_extension.md" rel="noreferrer" target="_blank">https://github.com/pka/qgpkg/<wbr>blob/master/owc_geopackage_ext<wbr>ension.md</a>>> <br>
> - ,<br>
> which is standards-based; in this approach<br>
> <<a href="https://www.geocat.net/announcing-the-extended-geopackage-qgis-plugin/" rel="noreferrer" target="_blank">https://www.geocat.net/annou<wbr>ncing-the-extended-geopackage-<wbr>qgis-plugin/</a><br>
> <<a href="https://www.geocat.net/announcing-the-extended-geopackage-qgis-plugin/" rel="noreferrer" target="_blank">https://www.geocat.net/annou<wbr>ncing-the-extended-geopackage-<wbr>qgis-plugin/</a>>> <br>
> ,<br>
> the style is encoded as OGC:SLD and the project as OGC:OWS context.<br>
> The goal<br>
> of this approach is to support the migration of GIS projects, as we can<br>
> implement this extension in any desktop or server side GIS (e.g.: ArcGIS<br>
> Desktop).<br>
><br>
> The fork was merged in August this year, and the latest release of the<br>
> plugin <<a href="https://plugins.qgis.org/plugins/QgisGeopackage/" rel="noreferrer" target="_blank">https://plugins.qgis.org/plug<wbr>ins/QgisGeopackage/</a><br>
> <<a href="https://plugins.qgis.org/plugins/QgisGeopackage/" rel="noreferrer" target="_blank">https://plugins.qgis.org/plu<wbr>gins/QgisGeopackage/</a>>> already contains<br>
> both extensions, covering both use cases of porting QGIS projects and<br>
> migrating GIS projects. Recently, it was added support in the core<br>
> to the<br>
> "qgis geopackage extension"<br>
> <<a href="https://github.com/qgis/QGIS/blob/master/src/providers/ogr/qgsogrprovider.cpp#L762" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS<wbr>/blob/master/src/providers/<wbr>ogr/qgsogrprovider.cpp#L762</a><br>
> <<a href="https://github.com/qgis/QGIS/blob/master/src/providers/ogr/qgsogrprovider.cpp#L762" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS<wbr>/blob/master/src/providers/<wbr>ogr/qgsogrprovider.cpp#L762</a>>><br>
> , in the qgsogrprovider class. This means that if a user loads a<br>
> geopackage<br>
> which was encoded using the "qgis geopackage extension", it will<br>
> automatically load the QGIS project from it. We think that it makes<br>
> sense to<br>
> also add the "ows geopackage extension" to the core; in that case,<br>
> users<br>
> could load projects exported from other GIS software seamlessly, without<br>
> having to load the plugin. The mechanism would be very similar to<br>
> what was<br>
> already implemented for the "qgis geopackage extension".<br>
><br>
> Before preparing any Pull Request, we would like to understand first<br>
> what is<br>
> the general feeling of the community about this feature; is this<br>
> something<br>
> which seems useful and interesting to add to the QGIS core? If yes,<br>
> we would<br>
> also appreciate any comments regarding any details the implementation.<br>
><br>
> Looking forward to hearing your feedback :-)<br>
<br>
Yes, please! I think there was an issue about not being able to load an<br>
extended gpkg:<br>
<br>
<a href="https://issues.qgis.org/issues/17698" rel="noreferrer" target="_blank">https://issues.qgis.org/issues<wbr>/17698</a><br>
<br>
so it looks like fixing a bug<br>
<br>
:-)<br>
<br>
R<br>
<br>
______________________________<wbr>_________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/qgis-developer</a></blockquote></div></div>
</div>
______________________________<wbr>_________________<br>QGIS-Developer mailing list<br><a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a><br>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a></div></blockquote></div></div></div><br><div>
<div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;line-height:normal;text-align:center"><span>—</span></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;line-height:normal;text-align:center"><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><br class="m_-6747847093353260195Apple-interchange-newline" style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span><span><span><span><span><span><span><span><span><img id="m_-67478470933532601955AB68416-2380-4050-A102-7E76CCCE9CE2" src="cid:1A5DF6DE-E302-4C28-BFBD-29663CBF1351"></span><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br class="m_-6747847093353260195Apple-interchange-newline"><br class="m_-6747847093353260195Apple-interchange-newline"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Tim Sutton</b></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Co-founder:</b><span class="m_-6747847093353260195Apple-converted-space"> </span>Kartoza</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Project chair:</b><span style="font-weight:normal"><span class="m_-6747847093353260195Apple-converted-space"> </span><a href="http://QGIS.org" target="_blank">QGIS.org</a></span></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Visit <a href="http://kartoza.com/" target="_blank"><span>http://kartoza.com</span></a> to find out about open source:</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Desktop GIS programming services</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Geospatial web development</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">GIS Training</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Consulting Services</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Skype</b>: timlinux </div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>IRC:</b><span class="m_-6747847093353260195Apple-converted-space"> </span>timlinux on #qgis at <a href="http://freenode.net" target="_blank">freenode.net</a></div>
</span></span></span></span></span></span></span></span></span></div>
</div><br></div></blockquote></div><br></div>