[Qgis-user] Open ESRI Geodatabase file in QGIS
Mangla Katyayani
mangla.katyayani at gramener.com
Mon Jan 13 02:25:49 PST 2025
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: 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: image.png]
On Mon, 13 Jan 2025 at 15:14, Andrea Giudiceandrea <andreaerdna at libero.it>
wrote:
> > Mangla Katyayani mangla.katyayani at 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
>
--
Disclaimer: This email may be confidential. Please don't share without
consent. Inform the sender if you got it by mistake.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250113/2c7fcb40/attachment-0001.htm>
-------------- 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/2c7fcb40/attachment-0003.png>
-------------- 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/2c7fcb40/attachment-0004.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/2c7fcb40/attachment-0005.png>
More information about the QGIS-User
mailing list