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.

I have one line shape file with lot of road sections and a point shapefile, some of these points are outside my area of interest.

The files have one attribute in common and I would like to do selection, where I select only those points that have matching attribute value with the line shape file.

Is this possible in some meaningful way?


I believe that in this particular case I could do line buffers and use those to select the point in buffer area - but I was wondering if its possible to match the values "straight away" with each other.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

With both layers loaded in your table of contents, go to the properties of your point layer. In the properties go to the Join tab and click the + button to add a new join, using the line layer as your target. If your line layer has a field you know is populated in all records, you can do a select from your point layer for the NOT NULL records in that field, eliminating the non-matching records.

This is an awkward work around. It would be better if QGIS had a "Keep only matching records" type join. Another, simpler work around would be to import your data into either a PostGIS or Spatialite database. Then you could do an INNER JOIN on the two tables, which would only return rows that have a match in both tables.

share|improve this answer

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.