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.

2
  • As per the Tour there should be only one question asked per question. I think your first question will already be found answered on this site.
    – PolyGeo
    Jan 22, 2019 at 19:19
  • Thanks for this but it's converting it to just one image...I should have over 100. I think it's because in the geodatabase, the image files all have the same name! So they're saving over each other which means I only have the most recent photo at the end. How do I easily re-name them? There are over 100 photos so I don't want to have to do it by hand. To make things worse, They're all saved in Arc123 Survey so I don't have the original files, only the geodatabase...Hence following your steps (which do appear to work)
    – user220057
    Feb 21, 2023 at 16:07

1 Answer 1

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.

3
  • 2
    This answer merits upvote and to be marked as the right response to the question!
    – Horizen
    Jan 13, 2022 at 20:23
  • 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. 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). 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.