<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">As a QGIS and ArcGIS user, I am glad the file geodatabase support is there, so please don’t take the following negatively. I <span style="background-color: rgba(255, 255, 255, 0);">am the Spatial Infrastructure Manager for a statewide Next Generation 9-1-1 implementation here in the U.S., and we have successfully shared data with local public safety agencies using GeoPackage generated from the Esri suite. Alex had mentioned this earlier, but I wanted to elaborate so you could pass it on to your constituents if need be. </span><p style="margin: 0px; font-stretch: normal; line-height: normal; min-height: 17.9px;"><span style="background-color: rgba(255, 255, 255, 0);"><br></span></p><p style="margin: 0px; font-stretch: normal; line-height: normal;"><span style="background-color: rgba(255, 255, 255, 0);">Users can create SpatiaLite or GeoPackage (v1.0, 1.1, 1.2) using either the Python Console or a Python script stored in the Workspace toolset under the Data Management Tools toolbox. This works at all license levels (Basic, Standard, or Advanced) and in Desktop (ArcMap\ArcCatalog) and ArcGIS Pro. </span></p><p style="margin: 0px; font-stretch: normal; line-height: normal; min-height: 17.9px;"><span style="background-color: rgba(255, 255, 255, 0);"><br></span></p><p style="margin: 0px; font-stretch: normal; line-height: normal;"><span style="background-color: rgba(255, 255, 255, 0);">Here is a link to the Desktop help which, in this case, is the same for Pro:</span></p><p style="margin: 0px; font-stretch: normal; line-height: normal;"><a href="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/create-sqlite-database.htm" style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);"><font color="#000000">http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/create-sqlite-database.htm</font></a></p><p style="margin: 0px; font-stretch: normal; line-height: normal; min-height: 17.9px;"><span style="background-color: rgba(255, 255, 255, 0);"><br></span></p><p style="margin: 0px; font-stretch: normal; line-height: normal;"><span style="background-color: rgba(255, 255, 255, 0);">Once created, it’s easy to drag-and-drop simple feature classes (points, lines, and polygons) from ESRI geodatabases into the OGC DB, and from OGC to Esri. We have no reported errors from QGIS users in the field with this type of data exchange, and vice versa. From my perspective, there is little use for file geodatabase exchange unless the other user is at a lesser ArcGIS Desktop version (as referenced by Alex). This also promotes the OGC portable database model over the use of shapefiles, in which we have seen degradation of attributes because of the DBF restrictions. </span></p><p style="margin: 0px; font-stretch: normal; line-height: normal; min-height: 17.9px;"><span style="background-color: rgba(255, 255, 255, 0);"><br></span></p><p style="margin: 0px; font-stretch: normal; line-height: normal;"><span style="background-color: rgba(255, 255, 255, 0);">v/r</span></p><p style="margin: 0px; font-stretch: normal; line-height: normal;"><span style="background-color: rgba(255, 255, 255, 0);">James</span></p><br><div id="AppleMailSignature">Sent from my iPhone</div><div><br>On Aug 2, 2018, at 08:17, Even Rouault <<a href="mailto:even.rouault@spatialys.com">even.rouault@spatialys.com</a>> wrote:<br><br></div><blockquote type="cite"><div><span>On jeudi 2 août 2018 19:34:54 CEST Nyall Dawson wrote:</span><br><blockquote type="cite"><span>On Thu, 2 Aug 2018 at 18:21, Andreas Neumann <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>> wrote:</span><br></blockquote><blockquote type="cite"><blockquote type="cite"><span>However - I wonder if there would be a way to support both drivers? The</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>Open Source driver as default for reading. And the FGDB driver for</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>writing?</span><br></blockquote></blockquote><blockquote type="cite"><span>That's a great idea!</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>In the QGIS world we'd have to compromise a bit here and not allow</span><br></blockquote><blockquote type="cite"><span>editing of existing layers (as you'd normally get with the closed</span><br></blockquote><blockquote type="cite"><span>driver). I.e. we'd only use it when writing an existing layer out to a</span><br></blockquote><blockquote type="cite"><span>copy on disk (e.g. via right click menu on a vector layer). But still,</span><br></blockquote><blockquote type="cite"><span>allowing layers to be saved as a geodatabase would be a step forward.</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>I'm not sure how this change would need to be made though. At the</span><br></blockquote><blockquote type="cite"><span>moment if you install the closed driver in osgeo4w it's always used,</span><br></blockquote><blockquote type="cite"><span>for both reading and writing layers. Even/Jürgen is this an osgeo4w</span><br></blockquote><blockquote type="cite"><span>thing or a GDAL thing? Is it possible to have two drivers installed</span><br></blockquote><blockquote type="cite"><span>for the one format and always read using the closed driver?</span><br></blockquote><span></span><br><span>As the FileGDB driver is loaded as a plugin by GDAL, it is registered first, </span><br><span>and then probed first when opening a dataset.</span><br><span>Banning one of the driver can be done by defining GDAL_SKIP=FileGDB or </span><br><span>GDAL_SKIP=OpenFileGDB and calling GDALAllRegister() again.</span><br><span>It is also possible to control which drivers are allowed at dataset opening </span><br><span>with GDALOpenEx() and the papszDriversAllowed argument (but that means you </span><br><span>need to know this is a FileGeodatabase)</span><br><span></span><br><span>Even</span><br><span></span><br><span>-- </span><br><span>Spatialys - Geospatial professional services</span><br><span><a href="http://www.spatialys.com">http://www.spatialys.com</a></span><br><span>_______________________________________________</span><br><span>QGIS-Developer mailing list</span><br><span><a href="mailto:QGIS-Developer@lists.osgeo.org">QGIS-Developer@lists.osgeo.org</a></span><br><span>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></span><br><span>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></span></div></blockquote></body></html>