1

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?

  • 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
  • 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
  • How many records in your csv files? When you done [Select menu Vector -> Spatial Query: Source - csv1shp, Reference - csv2shp, Where the feature - Equals] - in csv1shp selected features which equals with features of csv2shp layer. Then for output shapefile you should save selected features (Right click on csv1shp layer - Save SELECTED As...) – HasT Jul 26 '13 at 19:01
1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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