I have a PostGIS-enabled PostrgeSQL db, using QGIS. I have a table with points with pk point_id and a table with images with fk point_id. I want to find all images with fk point_id that are greater than 5 metres from the matched points in the table points based on point_id. (I am doing this because I want to correct the GPS metadata in the images, with the first step being to find which images are more than 5 metres from their related point.)
I can create a buffer of radius 5 metres and then use an 'is disjoint' query, but this does not respect the ids (i.e. for some points that are close, an unrelated image will appear within a buffer, but not a paired buffer based on the point_id).
What query can I use in QGIS or PostGIS that will include an 'is disjoint' based on paired ids?
أكثر...
I can create a buffer of radius 5 metres and then use an 'is disjoint' query, but this does not respect the ids (i.e. for some points that are close, an unrelated image will appear within a buffer, but not a paired buffer based on the point_id).
What query can I use in QGIS or PostGIS that will include an 'is disjoint' based on paired ids?
أكثر...