1

I am trying to open the .gdbtable file in QGIS.

I have tried:

'open data source' -> vector -> vector databese -> a0000000a.gdbtable -> open

It gives me following error.

a0000000a.gdbtable is not a valid or recognized data source

1
  • Open data source - vector - directory and in the type drop down use ESRI FileGDB.
    – johns
    Aug 10 '21 at 12:54
3

File geodatabase is not a flat file data source. You cannot point to a single file and have it read by any application (for the reason that the descriptors for the file contents are not present in it). The other 42+ files are critical to the ability to read the file, and the parent directory must have a suffix of .gdb.

If you were only given this one file, you must ask the provider to give you either a complete file geodatabase with the table you want in it, or to provide a CSV or some other geo-format with the data.

If you were given a zipfile and extracted just one file, you must go back and extract the entire contents to local disk. Then you can "open" the .gdb parent folder, and the table(s) should be present.

5
  • Thanks for your feedback. would it possible to open the file in ARCGIS?
    – Jui Sen
    Aug 10 '21 at 3:24
  • No, not as a singleton file. You need the whole directory, or a different format.
    – Vince
    Aug 10 '21 at 3:29
  • I have downloaded the data from the following link: cms.agr.wa.gov/WSDAKentico/Documents/DO/NRAS/… I cannot see any mother .gdb file
    – Jui Sen
    Aug 10 '21 at 7:21
  • 1
    I see a zipfile with .gdb folder containing 50 files, a normal file geodatabase. ArcMap sees a table ("CropData" with 16 columns and 226971 rows) and a polygon feature class ("WSDACrop_2020" with 10 columns (12 with length/area) and 226971 rows). The other tables are hidden data dictionary, aka "catalog", reference tables.
    – Vince
    Aug 10 '21 at 12:54
  • Thank you very much. I have sorted this out. I basically took out all the files in a separate folder. Since, the new folder was not in .gdb format, I was facing that issue. Thank you for your time
    – Jui Sen
    Aug 10 '21 at 19:01
-1

Just trying to extend the answer a bit more, and im reading between the lines of what the OP is actually trying to achieve.

She mentions 'gdbtable' suggesting that the OP is wanting just the attribute information from the GDB. (im guessing here).

As a suggestion - if you have the File Geodatabase open in QGIS, you can use code to just retrieve attribute information, something similar to:

lyr = iface.activeLayer()

features = lyr.getFeatures()

for feat in features:
    attrs = feat.attributes()
    print(attrs[1])

There is some further discussion here: How to read the attribute values using PyQGIS?

Ideally, you could programmatically get pyQGIS to 'open' the File Geodatabase and use the above code to retrieve attribute schema and values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.