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 < andrea.a...@geosolutionsgroup.com> 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 <akshay.k.he...@gmail.com> > 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 >> >> >> Geoserver-users@lists.sourceforge.net >> 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users