Re: [Geoserver-users] SLD aggregate function COUNT and SUM

2021-11-21 Thread Akshay Hegde
Hi Andrea, Will you please share snippet of one working example of Either COUNT or SUM function ? This would help a lot. - count < 100 red color - count > 100 and count < 1000 green - count > 1000 Thank you. On Thu, Nov 18, 2021 at 4:52 PM Akshay Hegde wrote: > Hi Andrea, > > I just tested

Re: [Geoserver-users] SLD aggregate function COUNT and SUM

2021-11-18 Thread Akshay Hegde
Hi Andrea, I just tested with below version, it seems as you said MIN and MAX only works. Received same error since I am using shape files as backend unable to get what I want, with mysql / postgres I would have create sql layer. - GeoServer Version2.21-SNAPSHOT - Git Revisionade1dd70a986

Re: [Geoserver-users] SLD aggregate function COUNT and SUM

2021-11-18 Thread Andrea Aime
Hmm.. not sure there is a process that will work for you, on a stable version of GeoServer. The Aggregate process can do counts, but in order to paint a map, you need to aggregate on the geometry as well (otherwise it's not part of the aggregation output), which does not work. It was solved recentl

Re: [Geoserver-users] SLD aggregate function COUNT and SUM

2021-11-18 Thread Akshay Hegde
Hi Andrea, Thanks for reply. I was attempting below, as you can see I was attempting to count stations at specific location ( group by latitude, longitude ), Kindly find attached screenshot. similar to SQL select count(1) from sometable group by latitude, longitude.

Re: [Geoserver-users] SLD aggregate function COUNT and SUM

2021-11-18 Thread Andrea Aime
As per process documentation (look at the DescribeProcess output): "The aggregate operation to be computed, it can be MAX or MIN" This process selects for each group just one feature, the one that has either the min or the max value of a given attribute sum or count make no sense in that context.

Re: [Geoserver-users] SLD aggregate function COUNT and SUM

2021-11-17 Thread Brad Hards
On Thursday, 18 November 2021 4:22:55 PM AEDT Akshay Hegde wrote: > I had gone through > > https://docs.geoserver.org/stable/en/user/styling/sld/extensions/rendering-t > ransform.html#contour-extraction How does this relate to your expectation? > Unfortunately below transformation with COUNT and