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 two maps in csv form, each has a latitude, longitude, and value column. Since not all the positions in one map are in another map, is there any way in QGIS to display a new map which only shows the points that are in both of the original maps? Besides, is it possible to display the value of each bin in the new map as a function (e.g. sum) of the values of original maps?

Thanks very much

share|improve this question
    
csv form - is csv files added in qgis project? If yes, save csv1 and csv2 in shape-file (Right click - Save As...). Select menu Vector -> Spatial Query: Source - csv1shp, Reference - csv2shp, Where the feature - Equals. Save selected features in new shapefile or copy selected records (attributes) in Excel for new csv file. –  HasT Jul 26 '13 at 17:44
    
Thanks very much!!!!! –  Kyle Jul 26 '13 at 18:16
    
BTW is their any 'Calculator' in QGIS that can allow us simply doing summations, etc. directly? I run the query and it is very slow for some reason and often 'not responding' so I have to restart QGIS many times... –  Kyle Jul 26 '13 at 18:19
    
Actually I tried many many times the spatial query and none is completed... Every time I try it, it makes QGIS 'Not responding'.... I checked the memory and CPU usage and everything was ok, any idea to resolve the 'Not responding' problem? Thanks –  Kyle Jul 26 '13 at 18:27
    
Finally I get it work, but I get another problem.. "The query from 'Map1' using 'FID' in field not possible"... Could anyone show me how to save the output file? Thanks again... –  Kyle Jul 26 '13 at 18:48
show 3 more comments

1 Answer

Save csv1 and csv2 in shape-file (Right click - Save As...). Select menu Vector -> Spatial Query: Source - csv1shp, Reference - csv2shp, Where the feature - Equals. Save selected features in new shapefile or copy selected records (attributes) in Excel for new csv

share|improve this answer
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.