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.
Question
Automatically populate a spreadsheet
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+52- Celebrity
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
+2Hi @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.