Skip to main content
Solved

sum of features

  • October 26, 2018
  • 7 replies
  • 339 views

terezia86
Forum|alt.badge.img

Hello! I need to get a sum of some features. Please have a look at the picture, it is maybe easier to understand what I need.

I need to get a sum of these houses therea are in the different parts of city. The problem is that the name and amount of streets are allways different. I do not know how to automate it.. Any ideas?

Best answer by rileym

Hi @tereziastredna

Have a look at the documentation for the Aggregator and StatisticsCalculator transformers.Both allow you to specify a 'Group By' attribute and can sum the values of the attribute you group by.

In this case I'd recommend Aggregator to sum the values of your left/right hand values to street level. You could then place another Aggregator to sum the values of streets to neighbourhoods.

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

7 replies

Forum|alt.badge.img
  • Best Answer
  • October 26, 2018

Hi @tereziastredna

Have a look at the documentation for the Aggregator and StatisticsCalculator transformers.Both allow you to specify a 'Group By' attribute and can sum the values of the attribute you group by.

In this case I'd recommend Aggregator to sum the values of your left/right hand values to street level. You could then place another Aggregator to sum the values of streets to neighbourhoods.


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • October 26, 2018

Actually I don't think either of them can yield the result in your picture...;)


terezia86
Forum|alt.badge.img
  • Author
  • October 26, 2018
gio wrote:

Actually I don't think either of them can yield the result in your picture...;)

do you have any other idea? ;-)

 


Forum|alt.badge.img+2
  • October 26, 2018
terezia86 wrote:
do you have any other idea? ;-)

 

@tereziastredna How do you know when you're in a new part of the city, i.e. when part 1 ends and part 2 starts? Is it always two streets?

 


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • October 26, 2018

@tereziastredna

..it was a joke...

no transformer will get you 5+8 =15...

You need some change to mathematic fundamentals for that.


terezia86
Forum|alt.badge.img
  • Author
  • October 27, 2018
gio wrote:

@tereziastredna

..it was a joke...

no transformer will get you 5+8 =15...

You need some change to mathematic fundamentals for that.

Oh, I see! It is just a mistake! Sorry for that

 

 


terezia86
Forum|alt.badge.img
  • Author
  • October 27, 2018
markatsafe wrote:
@tereziastredna How do you know when you're in a new part of the city, i.e. when part 1 ends and part 2 starts? Is it always two streets?

 

Hi, I have different shape files, and there it is specified which part of city contains which street etc. That is why it is always different, and I need to have it automated. Not only for streets A,B,C or D...

 

 


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