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.
<Transformation>
<ogc:Function name="vec:GroupCandidateSelection">
<ogc:Function name="parameter">
<ogc:Literal>data</ogc:Literal>
</ogc:Function>
<ogc:Function name="parameter">
<ogc:Literal>operationAttribute</ogc:Literal>
<ogc:Literal>stations</ogc:Literal>
</ogc:Function>
<ogc:Function name="parameter">
<ogc:Literal>aggregation</ogc:Literal>
<ogc:Literal>COUNT</ogc:Literal>
</ogc:Function>
<ogc:Function name="parameter">
<ogc:Literal>groupingAttributes</ogc:Literal>
<ogc:Literal>latitude</ogc:Literal>
<ogc:Literal>longitude</ogc:Literal>
</ogc:Function>
</ogc:Function>
</Transformation>
On Thu, Nov 18, 2021 at 2:46 PM Andrea Aime <
[email protected]> wrote:
> 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.
>
> Cheers
> Andrea
>
>
> On Thu, Nov 18, 2021 at 6:26 AM Akshay Hegde <[email protected]>
> wrote:
>
>>
>> I had gone through
>>
>>
>> https://docs.geoserver.org/stable/en/user/styling/sld/extensions/rendering-transform.html#contour-extraction
>>
>> Unfortunately below transformation with COUNT and SUM never works. It
>> only works with MIN and MAX function.
>>
>> Is there any resolution ? my aim is to get count, by grouping few
>> attributes and to have colored marker based on count value.
>>
>> example
>>
>> - count < 100 red color
>> - count > 100 and count < 1000 green
>> - count > 1000
>>
>> <Transformation>
>> <ogc:Function name="vec:GroupCandidateSelection">
>> <ogc:Function name="parameter">
>> <ogc:Literal>data</ogc:Literal>
>> </ogc:Function>
>> <ogc:Function name="parameter">
>> <ogc:Literal>operationAttribute</ogc:Literal>
>> <ogc:Literal>st:numericAttribute</ogc:Literal>
>> </ogc:Function>
>> <ogc:Function name="parameter">
>> <ogc:Literal>aggregation</ogc:Literal>
>> <ogc:Literal>COUNT</ogc:Literal>
>> </ogc:Function>
>> <ogc:Function name="parameter">
>> <ogc:Literal>groupingAttributes</ogc:Literal>
>> <ogc:Literal>st:inferredAttribute</ogc:Literal>
>> <ogc:Literal>st:inferredAttribute2</ogc:Literal>
>> </ogc:Function>
>> </ogc:Function>
>> </Transformation>
>> --
>> _______________________________________________
>> Geoserver-users mailing list
>>
>> Please make sure you read the following two resources before posting to
>> this list:
>> - Earning your support instead of buying it, but Ian Turton:
>> http://www.ianturton.com/talks/foss4g.html#/
>> - The GeoServer user list posting guidelines:
>> http://geoserver.org/comm/userlist-guidelines.html
>>
>> If you want to request a feature or an improvement, also see this:
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>
>>
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
>
> --
>
> Regards,
>
> Andrea Aime
>
> ==
> GeoServer Professional Services from the experts!
>
> Visit http://bit.ly/gs-services-us for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions Group
> phone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob: +39 333 8128928
>
> https://www.geosolutionsgroup.com/
>
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
> Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
> 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
> precisa che ogni circostanza inerente alla presente email (il suo
> contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
> riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
> messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
> operazione è illecita. Le sarei comunque grato se potesse darmene notizia.
>
> This email is intended only for the person or entity to which it is
> addressed and may contain information that is privileged, confidential or
> otherwise protected from disclosure. We remind that - as provided by
> European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
> e-mail or the information herein by anyone other than the intended
> recipient is prohibited. If you have received this email by mistake, please
> notify us immediately by telephone or e-mail
>
--
<https://about.me/akshay.k.hegde?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb>
Akshay Hegde
about.me/akshay.k.hegde
<https://about.me/akshay.k.hegde?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb>
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
