Question

Automatically populate a spreadsheet


Hi all, I have a points dataset of planning applications. I also have a large number of environmental datsets as polygons. I have a spreadsheet(excel) with a list of all the polygons. Each layer will recieve a "tick" depending on whetether the point falls within the polygon, ie.yes/no boolean query. Any suggestions much appreciated.


2 replies

Userlevel 4
Badge +30

Hi @dorian, let me know if i understood well. Do you have three differents Source : Points , Polygons and XLS with attributes all polygons.

Your write file is a XLS and do you want to merger theses informations?

Thanks

Badge +2

Hi @dorian

 

If you used a PointOnAreaOverlayer, you could work out which polygons have points in them.

 

If you use a FeatureMerger with the list of polygons from Excel you'd see which row the polygons belong to in Excel (xlsx_row_id attribute, you may need to expose it). If you also know the column id or attribute name that you want the 'tick' to go in, you can just use these features to update the correct feature/column in the Excel spreadsheet.

Reply