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

6
  • 4
    So, what is you question? What have you tried to answer it?
    – Erik
    Sep 29, 2021 at 6:49
  • I want to have an excel spreadsheet that I can sort by catchment area, and then I can see the points under each catchment area. Lets say the points are hospitals, and I want to be able to find out how many hospitals each catchment area area has. one vector is the catchment area and the other vector is the hospitals. but both sets of data don't have any matching attributes so i can jut match them up that way.
    – Mitch
    Sep 29, 2021 at 7:00
  • 1
    So, you want to know how to join attributes by location?
    – Erik
    Sep 29, 2021 at 7:02
  • That could be a start.
    – Mitch
    Sep 29, 2021 at 7:05
  • I suggest you try the tool yourself. Its fairly easy to handle.
    – Erik
    Sep 29, 2021 at 7:41

1 Answer 1

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.

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