Skip to main content
Solved

Calculate sum of features with in each circles (overlapping circles)


pushpa
Contributor
Forum|alt.badge.img+9

Hi 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

View original
Did this help you find an answer to your question?

6 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • Best Answer
  • April 11, 2019

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


pushpa
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • April 11, 2019
ebygomm wrote:

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

I am not sure how to generate a list and then explode.

would you be able to give me some help on that?

thanks


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • April 11, 2019
pushpa wrote:

I 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.


pushpa
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • April 11, 2019
ebygomm wrote:

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.

thanks very much. Its running at the moment. Hope I get the answer I am looking for. thanks again

 

 


pushpa
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • April 12, 2019
pushpa wrote:

thanks 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.

 


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • April 12, 2019
pushpa wrote:

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.

 

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


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