Skip to main content

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

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


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


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.


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

 

 


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.

 


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