2

I have two vector layers, one with points, and the other with catchment boundaries. This is showing where the points are in relation to catchment areas.

I want to be able to export a Excel file that will allow me to see the points broken down into each catchment.

Lets say the points are hospitals, and I want to be able to find out how many hospitals each catchment area has. One layer is the catchment area and the other vector is the hospitals. but both sets of data don't have any matching attributes so I cant export the layers data then match them up using matching "id"'s

I have attached an image to help explain. The catchment is the green and the points in maroon.

enter image description here

Taras
  • 32,823
  • 4
  • 66
  • 137
Mitch
  • 23
  • 3

1 Answers1

1

  1. On the point layer, create a new field with Field calculator to get the catchment area each point is within. Use this expression (replace polygon with the name of the catchment layer, id with the name of the field from there that you want: array_first(overlay_within ('polygon', id)).

  2. Right click layer / Export /Save Features as... and select Comma Separated Values (CSV) as output format. Then Open this in Excel.

Babel
  • 71,072
  • 14
  • 78
  • 208