4

I have an ESRI file geodatabase that was exported from their survey123 app, and the geodatabase has images attached to it.

I do not use ArcGIS, and was wondering how to export them from QGIS with their associated metadata.

Here's a Google Drive link to my gdb: https://drive.google.com/drive/folders/1KIJMea9bhF0cZrMc-y1uCLjLpzScWukd?usp=sharing

Once open in QGIS, I can see the point features, and below that in my layers panel is a table with the photos' names, etc.

Improve this question
0

1 Answer 1

Reset to default
9

You can do this easily in QGIS 3.6 and above (until QGIS 3.6 is officially released you can download a "nightly" version to test).

  1. Load the "_ATTACH" table from the gdb into QGIS

enter image description here

  1. From the Processing toolbox, search for "Extract Binary field". Double click to launch.
  2. Select the binary "DATA" field for "binary field" enter image description here
  3. Click the dropdown button to he right of "File name", select "edit", and enter an expression like "GLOBALID" || '.jpg' enter image description here
  4. Pick a destination folder, and run.

All attachments will be exported to the selected folder as jpg files.

Improve this answer
2
  • 1
    You might be able to just select the ATT_NAME field, which for the .gdb that I am working with has a better name and the .jpg suffix.
    – william3031
    Commented Feb 14, 2023 at 23:07
  • As William3031 said, I tested just selecting the ATT_NAME with no extra expression, and it worked flawlessly. Adding the expression gives each image an extra .jpg at the end. Still works, just an extra step that isn't needed. (Used QGIS 3.24).
    – wild_ecology
    Commented Mar 3, 2023 at 4:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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