Skip to main content
  • EN

I have a database with polygons. The data is three buffers (dounuts) around some points of interest with a unique location id. All donuts should get data from one or two of the neighbouring donuts.

This is the starting table (first four attributes are the starting ones):

idlocation_idbuffer_nrimportance_valueimportance_value_new110111022 (10+7+5)21012712 (7+5)3101355 (5)410212034 (20+11+3)510221114 (11+3)6102333 (3)7103123-etc

My table is sorted on location_id and buffer_nr. Basically:

  • for each buffer_nr=1 I want to create a new value based on the sum of all importance_value with the same location_id
  • for each buffer_nr=2 I want to create a new value based on the sum importance_value wwith buffer_id 2 and 3.

Reverse sorting. Continously put values in global values tagged with buffer number (global.buffer3, global.buffer2 and global.buffer1). Conditional additions based on buffer number. Could that work?

Once you have sorted the features by buffer_nr descending with the Sorter, you can calculate cumulative sum of the importance_value with the StatisticsCalculator. If necessary, use another Sorter to restore the original order of features.

Once you have sorted the features by buffer_nr descending with the Sorter, you can calculate cumulative sum of the importance_value with the StatisticsCalculator. If necessary, use another Sorter to restore the original order of features.

This does not seem to solve the challenge of updating an attribute with data from offset objects.

 

 

Once you have sorted the features by buffer_nr descending with the Sorter, you can calculate cumulative sum of the importance_value with the StatisticsCalculator. If necessary, use another Sorter to restore the original order of features.

This is the result from the workflow I posted above (just corrected a typo in the attribute name "importance_value_new"). Isn't this your desired result?

 

 

Reply


Community Stats

31,799
Posts
120,800
Replies
39,417
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.