[Qgis-user] Open ESRI Geodatabase file in QGIS

Andrea Giudiceandrea andreaerdna at libero.it
Mon Jan 13 03:43:45 PST 2025 

Hi Mangla,
given the following error displayed it the processing algorithm log
>
> GDAL command output:
>
> ERROR 1: Error occurred in 
> D:\src\osgeo4w\src\gdal\gdal-3.9.3\ogr\ogrsf_frmts\openfilegdb\filegdbtable.cpp 
> at line 659
>
if the "TreeCanopy" and the "TreeCanopy_Urban" layers are supposed to 
contain features, then it looks like either the ESRI FileGeodatabase 
dataset is malformed or it was created in a format not correctly 
recognized by the GDAL/OGR "OpenFileGDB" driver.

It would be useful if you shared such ESRI FileGeodatabase dataset. I'm 
CC'ing Even Rouault, since I think he is interested in such issue.


> The geospatial team of Halifax municipality, Canada (owner of the 
> dataset) has suggested using the fileGDB driver to open the dataset 
> instead of OpenfileGDB to resolve this issue. But we are unable to 
> find it in the 3.40 version of QGIS. 

In order to use the GDAL/OGR "ESRI FileGDB" driver, you need to:
- properly install the OSGeo4W package named "gdal-filegdb" using the 
OSGeo4W Setup program in "Advanced Install 
<https://nates-intro-to-qgis.readthedocs.io/en/latest/installation.html#adding-file-geodatabase-access>" 
mode
(since you are using QGIS 3.40.0 while the current version available on 
OSGeo4W is QGIS 3.40.2, then your QGIS installation will be updated to 
QGIS 3.40.2 and the dependencies will be updated accordingly)
- start QGIS and go to Settings -> Options -> Data Sources -> GDAL -> 
Vector Drivers
- disable the OpenFileGDB driver unchecking it from the list and clicking OK
- restart QGIS

Best regards.

Andrea Giudiceandrea

Il 13/01/2025 11:25, Mangla Katyayani ha scritto:
> Hi All,
>
> Thanks for the quick response. The geospatial team of Halifax 
> municipality, Canada (owner of the dataset) has suggested using the 
> fileGDB driver to open the dataset instead of OpenfileGDB to resolve 
> this issue. But we are unable to find it in the 3.40 version of QGIS.
>
> Andreaerdna, yes we do get the *select items to add* dialog box.
> image.png
>
> There is no error message in the log. The file contains vector data 
> and 3 data layers. Output of vector information processing algorithm run:
>
> "QGIS version: 3.40.0-Bratislava
>
> QGIS code revision: b56115d874
>
> Qt version: 5.15.13
>
> Python version: 3.12.7
>
> GDAL version: 3.9.3
>
> GEOS version: 3.13.0-CAPI-1.19.0
>
> PROJ version: Rel. 9.5.0, September 15th, 2024
>
> PDAL version: 2.8.1 (git-version: a06325)
>
> Algorithm started at: 2025-01-13T15:45:55
>
> Algorithm 'Vector information' starting…
>
> Input parameters:
>
> { 'ALL_LAYERS' : True, 'EXTRA' : '', 'INPUT' : 
> 'C:/Users/e430227/Downloads/Tree_Canopy 
> (1)/Halifax_Tree_Canopy.gdb|layername=TreeCanopy_Urban', 'NO_METADATA' 
> : False, 'OUTPUT' : 'TEMPORARY_OUTPUT', 'SUMMARY_ONLY' : True }
>
>
> GDAL command:
>
> ogrinfo -al -so "C:\\Users\\e430227\\Downloads\\Tree_Canopy 
> (1)\\Halifax_Tree_Canopy.gdb"
>
> GDAL command output:
>
> ERROR 1: Error occurred in 
> D:\src\osgeo4w\src\gdal\gdal-3.9.3\ogr\ogrsf_frmts\openfilegdb\filegdbtable.cpp 
> at line 659
>
> INFO: Open of `C:\\Users\\e430227\\Downloads\\Tree_Canopy 
> (1)\\Halifax_Tree_Canopy.gdb'
> using driver `OpenFileGDB' successful.
>
> Layer name: TreeCanopy
> Geometry: 3D Measured Multi Polygon
> Feature Count: 0
> Layer SRS WKT:
> PROJCRS["NAD_1983_CSRS_2010_MTM_5_Nova_Scotia",
> BASEGEOGCRS["GCS_North_American_1983_CSRS_2010",
> DATUM["NAD83 Canadian Spatial Reference System",
> ELLIPSOID["GRS 1980",6378137,298.257222101,
> LENGTHUNIT["metre",1]],
> ID["EPSG",6140]],
> PRIMEM["Greenwich",0,
> ANGLEUNIT["Degree",0.0174532925199433]]],
> CONVERSION["unnamed",
> METHOD["Transverse Mercator",
> ID["EPSG",9807]],
> PARAMETER["Latitude of natural origin",0,
> ANGLEUNIT["Degree",0.0174532925199433],
> ID["EPSG",8801]],
> PARAMETER["Longitude of natural origin",-64.5,
> ANGLEUNIT["Degree",0.0174532925199433],
> ID["EPSG",8802]],
> PARAMETER["Scale factor at natural origin",0.9999,
> SCALEUNIT["unity",1],
> ID["EPSG",8805]],
> PARAMETER["False easting",25500000,
> LENGTHUNIT["metre",1],
> ID["EPSG",8806]],
> PARAMETER["False northing",0,
> LENGTHUNIT["metre",1],
> ID["EPSG",8807]]],
> CS[Cartesian,2],
> AXIS["(E)",east,
> ORDER[1],
> LENGTHUNIT["metre",1,
> ID["EPSG",9001]]],
> AXIS["(N)",north,
> ORDER[2],
> LENGTHUNIT["metre",1,
> ID["EPSG",9001]]]]
> Data axis to CRS axis mapping: 1,2
> Geometry Column = Shape
>
> Layer name: TreeCanopy_Urban
> Geometry: 3D Measured Multi Polygon
> Feature Count: 0
> Layer SRS WKT:
> PROJCRS["NAD_1983_CSRS_2010_MTM_5_Nova_Scotia",
> BASEGEOGCRS["GCS_North_American_1983_CSRS_2010",
> DATUM["NAD83 Canadian Spatial Reference System",
> ELLIPSOID["GRS 1980",6378137,298.257222101,
> LENGTHUNIT["metre",1]],
> ID["EPSG",6140]],
> PRIMEM["Greenwich",0,
> ANGLEUNIT["Degree",0.0174532925199433]]],
> CONVERSION["unnamed",
> METHOD["Transverse Mercator",
> ID["EPSG",9807]],
> PARAMETER["Latitude of natural origin",0,
> ANGLEUNIT["Degree",0.0174532925199433],
> ID["EPSG",8801]],
> PARAMETER["Longitude of natural origin",-64.5,
> ANGLEUNIT["Degree",0.0174532925199433],
> ID["EPSG",8802]],
> PARAMETER["Scale factor at natural origin",0.9999,
> SCALEUNIT["unity",1],
> ID["EPSG",8805]],
> PARAMETER["False easting",25500000,
> LENGTHUNIT["metre",1],
> ID["EPSG",8806]],
> PARAMETER["False northing",0,
> LENGTHUNIT["metre",1],
> ID["EPSG",8807]]],
> CS[Cartesian,2],
> AXIS["(E)",east,
> ORDER[1],
> LENGTHUNIT["metre",1,
> ID["EPSG",9001]]],
> AXIS["(N)",north,
> ORDER[2],
> LENGTHUNIT["metre",1,
> ID["EPSG",9001]]]]
> Data axis to CRS axis mapping: 1,2
> FID Column = OBJECTID
> Geometry Column = Shape
> ID: Real (0.0)
> Shape_Length: Real (0.0) DEFAULT FILEGEODATABASE_SHAPE_LENGTH
> Shape_Area: Real (0.0) DEFAULT FILEGEODATABASE_SHAPE_AREA
>
> Layer name: TreeCanopy_Rural
> Geometry: 3D Measured Multi Polygon
> Feature Count: 19156258
> Extent: (25520533.270490, 4921874.479563) - (25689884.745000, 
> 5016616.870129)
> Layer SRS WKT:
> PROJCRS["NAD_1983_CSRS_2010_MTM_5_Nova_Scotia",
> BASEGEOGCRS["GCS_North_American_1983_CSRS_2010",
> DATUM["NAD83 Canadian Spatial Reference System",
> ELLIPSOID["GRS 1980",6378137,298.257222101,
> LENGTHUNIT["metre",1]],
> ID["EPSG",6140]],
> PRIMEM["Greenwich",0,
> ANGLEUNIT["Degree",0.0174532925199433]]],
> CONVERSION["unnamed",
> METHOD["Transverse Mercator",
> ID["EPSG",9807]],
> PARAMETER["Latitude of natural origin",0,
> ANGLEUNIT["Degree",0.0174532925199433],
> ID["EPSG",8801]],
> PARAMETER["Longitude of natural origin",-64.5,
> ANGLEUNIT["Degree",0.0174532925199433],
> ID["EPSG",8802]],
> PARAMETER["Scale factor at natural origin",0.9999,
> SCALEUNIT["unity",1],
> ID["EPSG",8805]],
> PARAMETER["False easting",25500000,
> LENGTHUNIT["metre",1],
> ID["EPSG",8806]],
> PARAMETER["False northing",0,
> LENGTHUNIT["metre",1],
> ID["EPSG",8807]]],
> CS[Cartesian,2],
> AXIS["(E)",east,
> ORDER[1],
> LENGTHUNIT["metre",1,
> ID["EPSG",9001]]],
> AXIS["(N)",north,
> ORDER[2],
> LENGTHUNIT["metre",1,
> ID["EPSG",9001]]]]
> Data axis to CRS axis mapping: 1,2
> FID Column = OBJECTID
> Geometry Column = Shape
> Shape_Length: Real (0.0) DEFAULT FILEGEODATABASE_SHAPE_LENGTH
> Shape_Area: Real (0.0) DEFAULT FILEGEODATABASE_SHAPE_AREA
>
> Process completed successfully
>
> Execution completed in 0.48 seconds
>
> Results:
>
>   OUTPUT: 
> C:\Users\e430227\AppData\Local\Temp\processing_qHtvSe\38881aa795194175810e1e7d9594b812\OUTPUT.html
>
>
> Loading resulting layers
>
> Algorithm 'Vector information' finished
>
> HTML output has been generated by this algorithm.
> Open the results dialog to check it."
>
>
> QGIS version information
> image.png
>
>
> On Mon, 13 Jan 2025 at 15:14, Andrea Giudiceandrea 
> <andreaerdna at libero.it> wrote:
>
>     > Mangla Katyayani mangla.katyayani at gramener.com <http://gramener.com> > Sun Jan 12 20:38:25 PST 2025
>     > I am facing this problem while opening a geodatabase file in
>     QGIS. I have > followed the following steps: > Add layer> Add
>     vector layer>Directory> Type: openfilegdb Hi Mangla, looking at
>     the Name, Path and Source strings displayed in the provided
>     screenshot, it looks like you have added the ESRI File Geodatabase
>     layer using the "Add layer -> Add vector layer -> File" dialog
>     window instead of "Add layer -> Add vector layer -> Directory ->
>     Type: openfilegdb" Does a "Select Items to Add" dialog (like in
>     the attached screenshot) window pops up after adding the ESRI File
>     Geodatabase directory via "Add layer -> Add vector layer ->
>     Directory -> Type: openfilegdb"?Are there any error messages
>     displayed in the Log Messages panel? Is the ESRI File Geodatabase
>     supposed to contain vector layers or raster layers? Is the ESRI
>     File Geodatabase supposed to contain only 1 layer or multiple
>     layers? What is the output of the "Vector Information" processing
>     algorithm run selecting any *.gdbtable in the *.gdb folder as
>     "Input layer" and checking the "Enable listing of all layers in
>     the dataset" checkbox? It would be useful if you provided the QGIS
>     full version info (available in the menu Help -> About) and if you
>     provided a link to download a zipped archive of the ESRI File
>     Geodatabase directory. Best regards. Andrea Giudiceandrea
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250113/b929005b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 138877 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250113/b929005b/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 18950 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250113/b929005b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pAivWdDwLHTc92pX.png
Type: image/png
Size: 39819 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250113/b929005b/attachment-0005.png>

More information about the QGIS-User mailing list