Hi, I am new to FME and i need to build a model that does the following thing: 1. Select all Address Points that are inside an Area Polygon type= OSA by a given Id. 2. Filter out all addresses that are Allocation Status = No Build.3. Output should be the sum of the "Location Id" field of all addresses points that are "No Build" per polygons id..I need to create out put in excel format.
Question
New to FME
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.
+2- Contributor
Hi @srhjunaid,
Welcome to the FME Community!
It sounds like you will need a workspace that uses a Clipper to select the Address Points within the desired area, followed by a Tester to filter for addresses that have an Allocation Status = "No Build". Lastly, you can use a StatisticsCalculator to get the count / sum of the desired attribute before writing to Excel. I have attached a sample workspace that should help you get started with this - in my example, I am clipping school address points to the Fairview neighborhood and testing for Public Schools. Note: In order to correctly analyze spatial relationships, all features should be in the same coordinate system.
Hope this helps!
Useful Resources:
Calculating a Running Total or Cumulative Sum | StatisticsCalculator
Example using the Clipper Transformer
Getting Started with FME Desktop
Template:
Clip_and_Test_Example.fmwt