[GIS] Exporting images attached to a geodatabase using QGIS

arcgis-survey123attachmentsfile-geodatabaseqgis

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.

Best Answer

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.

Related Question