[Geoserver-users] WFS query to find lowest and highest value of a attribute in a layer

GeoServer GeoServer User
1

Hi Guys

i have gone through the documentation and it is said that ogc:max and
ogc:min function is just used to get max between provided numbers. also on
ogc and arcgis website it is said to use SortBy in WFS query filter.

i have 2 question :

1) does geoserver have support to use sortby in WFS filter query?

2)my requirement is to find the lowest and the highest value in a attribute
of layer published in geoserver
is there any WFS query function to do that?

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/WFS-query-to-find-lowest-and-highest-value-of-a-attribute-in-a-layer-tp5022702.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

WFS doesn’t support aggregation in queries, only filtering. (In other words, it’s not functionally compatible with SQL).

However, you can do this by using a WPS process. Have a look at the gs:Aggregate process.

On Thu, Dec 13, 2012 at 2:02 AM, zeliofern <zelio.fern@anonymised.com> wrote:

Hi Guys

i have gone through the documentation and it is said that ogc:max and
ogc:min function is just used to get max between provided numbers. also on
ogc and arcgis website it is said to use SortBy in WFS query filter.

i have 2 question :

  1. does geoserver have support to use sortby in WFS filter query?

2)my requirement is to find the lowest and the highest value in a attribute
of layer published in geoserver
is there any WFS query function to do that?

–
View this message in context: http://osgeo-org.1560.n6.nabble.com/WFS-query-to-find-lowest-and-highest-value-of-a-attribute-in-a-layer-tp5022702.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only – learn more at:
http://p.sf.net/sfu/learnmore_122712

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

Martin Davis
OpenGeo - http://opengeo.org
Expert service straight from the developers.