+9Hi there,
I wonder anyone can help me on my query. I have a Point dataset and a Polygon Dataset they on ESRI file Geodatabase format.
I have over 700 circles and 7million Points
Point Data contain Premise Count , so I will require to sum up all Premises by each Circle and assign that number to each circle, including overlapping
I have used Spatial Relater/Spatial Filter/Clipper none of them give me the correct answer.
Let me know if this can be done using FME
. 
thanks,
Regards,
Pushpa
Best answer by ebygomm
Initial thoughts are you want the Spatial Relator,but you need to build a list and then explode it before summing to get the correct answer
+34Initial thoughts are you want the Spatial Relator,but you need to build a list and then explode it before summing to get the correct answer
+9Initial thoughts are you want the Spatial Relator,but you need to build a list and then explode it before summing to get the correct answer
I am not sure how to generate a list and then explode.
would you be able to give me some help on that?
thanks
+34I am not sure how to generate a list and then explode.
would you be able to give me some help on that?
thanks
If your points are the requestors and the circles your suppliers, test for "requestor is within supplier". Then under Attribute Accumulation tick generate list and select whatever unique identifier you have for the circles. Then use a listexploder to explode the list (be deafult it will be called _relationships) just created and sum based on your circle unique identifier.
+9If your points are the requestors and the circles your suppliers, test for "requestor is within supplier". Then under Attribute Accumulation tick generate list and select whatever unique identifier you have for the circles. Then use a listexploder to explode the list (be deafult it will be called _relationships) just created and sum based on your circle unique identifier.
thanks very much. Its running at the moment. Hope I get the answer I am looking for. thanks again
+9thanks very much. Its running at the moment. Hope I get the answer I am looking for. thanks again
this workspace didn't give me the answer I was looking for. I removed the Statistic Calculator transformer and run the workspace just for a single Site (circle), including Premise count for each feature inside the circle. The results list shows the same value for all records, even though the Premise count for each point has values ie: 1/2/3/4/
Hence the Total Sum of the Premise by Site has the incorrect answer.
+34this workspace didn't give me the answer I was looking for. I removed the Statistic Calculator transformer and run the workspace just for a single Site (circle), including Premise count for each feature inside the circle. The results list shows the same value for all records, even though the Premise count for each point has values ie: 1/2/3/4/
Hence the Total Sum of the Premise by Site has the incorrect answer.
It looks like you have the requestor and the supplier the opposite way round to how I described.
Looking at the size of the data though, the comparison is probably best done that way, then use a list summer rather than exploding the list.
I've attached a simple example
premises_count.fmwt
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
