A colleague's team has been using the eVis plugin in QGIS to store research photos. eVis relies upon a filepath or URL stored in the data source (shapefile, Spatialite db, etc.). They are using a filepath on the local machine.

They recently ran into problems with photos not displaying, and after investigating, they found that folders had been moved or renamed. I have suggested that they organize their data (currently in shapefiles) in a spatial database (Spatialite or PostGIS), and they are interested in doing so. I also think they can benefit from storing the photos as BLOBs in the Spatialite or PostGIS database. I tested eVis and it works fine with data in Spatialite or PostGIS as long as the photo files are external and accessed through the file system or URL. It doesn't appear to provide a way to access photos stored as BLOBs in the database.

Is there a way that QGIS (or a plugin) can display photos stored as BLOBs in a Spatialite or PostGIS database?

  • 1
    The docs say that one can give evis a url. I have the same problem and I am looking at setting up a web server on the database machine that serves the photos in much the same way as a database would. i.e. under relative path set base path to something like http:// localhost/photos/ and check the first box so it just grabs the filename from the attribute. – Russell Fulton Jul 7 '18 at 22:24
  • 1
    This sounds like Hyperlink or Attachment functionality so they may provide additional keywords to search on. – PolyGeo Apr 12 at 8:21

Your Answer

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

Browse other questions tagged or ask your own question.