Are there any QGIS tools or plugins that can display photos stored in a database? Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Are there any tools / plugins to develop mapbooks using QGIS?how to add a custom SRID to SpatialiteAre there any COGO tools in QGIS 1.9+?Building java based desktop map application using embedded database such as spatialiteQGIS Plugins & Tools that replicate Select ArcPy ToolsMaking QGIS display plugins that are installed on PC?Storing GPS and mobile sensor dataIs there a sequence stored in a QGIS layer that can be accessed via pyqgis?QGIS: evis — trying to use url rather than a pathQuerying & filtering raster data from PostGIS using GeoServer
Special flights
Why is a lens darker than other ones when applying the same settings?
Google .dev domain strangely redirects to https
How many time has Arya actually used Needle?
What adaptations would allow standard fantasy dwarves to survive in the desert?
How does light 'choose' between wave and particle behaviour?
What does Turing mean by this statement?
Should a wizard buy fine inks every time he want to copy spells into his spellbook?
How to ternary Plot3D a function
Test print coming out spongy
If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?
One-one communication
Asymptotics question
In musical terms, what properties are varied by the human voice to produce different words / syllables?
How can I prevent/balance waiting and turtling as a response to cooldown mechanics
A proverb that is used to imply that you have unexpectedly faced a big problem
Is multiple magic items in one inherently imbalanced?
Simple Http Server
Understanding p-Values using an example
Why is it faster to reheat something than it is to cook it?
Why datecode is SO IMPORTANT to chip manufacturers?
Is it dangerous to install hacking tools on my private linux machine?
How to write capital alpha?
Project Euler #1 in C++
Are there any QGIS tools or plugins that can display photos stored in a database?
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Are there any tools / plugins to develop mapbooks using QGIS?how to add a custom SRID to SpatialiteAre there any COGO tools in QGIS 1.9+?Building java based desktop map application using embedded database such as spatialiteQGIS Plugins & Tools that replicate Select ArcPy ToolsMaking QGIS display plugins that are installed on PC?Storing GPS and mobile sensor dataIs there a sequence stored in a QGIS layer that can be accessed via pyqgis?QGIS: evis — trying to use url rather than a pathQuerying & filtering raster data from PostGIS using GeoServer
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
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?
qgis postgis qgis-plugins spatialite photos
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
add a comment |
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?
qgis postgis qgis-plugins spatialite photos
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
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
add a comment |
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?
qgis postgis qgis-plugins spatialite photos
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
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?
qgis postgis qgis-plugins spatialite photos
qgis postgis qgis-plugins spatialite photos
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
edited Apr 12 at 8:19
PolyGeo♦
54.1k1782246
54.1k1782246
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
asked Nov 17 '17 at 23:09
Lee HachadoorianLee Hachadoorian
3,041931
3,041931
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
add a comment |
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
1
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
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
1
This sounds like Hyperlink or Attachment functionality so they may provide additional keywords to search on.
– PolyGeo♦
Apr 12 at 8:21
This sounds like Hyperlink or Attachment functionality so they may provide additional keywords to search on.
– PolyGeo♦
Apr 12 at 8:21
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f262273%2fare-there-any-qgis-tools-or-plugins-that-can-display-photos-stored-in-a-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f262273%2fare-there-any-qgis-tools-or-plugins-that-can-display-photos-stored-in-a-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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