Skip to main content
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.

danilo_fme
Evangelist
Forum|alt.badge.img+41

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


Forum|alt.badge.img+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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings