Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

is it possible in QGIS to query a layer with data from another layer?
And if so ... how is the syntax for that?

Usecase: I have a lot of image-position points and a lot of monitoring sites. I would like to set the monitoring area layer, so that it only shows areas where we also have images for this year.
I then use the extent of the monitoring area as the coverage layer to render my image-position maps with the Atlas plugin.
Without querying the areas to reduce them, i get a lot unneccesary maps with no image-positions, so i want to get rid of those areas which do not match (and of course not manually)

So, is there kind of a query to find out if a value in table1 column xy exists also in table2 column xy ?

share|improve this question
    
Could you add a sample map or visualization? It's rather hard to just imagine. –  R.K. Oct 1 '12 at 7:34
add comment

1 Answer

A method I use to do something similar is as follows.

I go to the Vector Menu and use the Geoprocessing Tools to buffer my points layer. Then I go to the Vector Menu again and use the Data Management Tools and 'Join Attributes by Location' which adds the photos taken within the buffered area to a new shapefile.

share|improve this answer
    
Thanx for your hint, but the spatial way is no option in my case: The monitoring areas sometimes directly touch, and often images are taken from outside, but inside another area, into the respective monitoring area. To tidy up all those errors would maybe take as long as to manually select the proper areas. I think that my question is not answerable in my sense at the moment, cause there seems to be no such feature that i asked for. Best indicator for that is, that even underdark has no clue ;) Will maybe file a feature request ... –  Bernd V. Aug 2 '12 at 8:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.