: maanantai 17. kesäkuuta 2024 20.14
Vastaanottaja: Andrea Aime
Kopio: GeoServer Mailing List List
Aihe: Re: [Geoserver-users] Omitting count(*) from WFS GetFeature request
Thanks Andrea, I was getting the specification numbers confused.
I am trying to reproduce your "when setting it, the numberR
etetty: maanantai 17. kesäkuuta 2024 20.19
Vastaanottaja: Jody Garnett
Kopio: GeoServer Mailing List List
Aihe: Re: [Geoserver-users] Omitting count(*) from WFS GetFeature request
I was testing main, but I guess I mixed GML 3.2 output format with a different
version of WFS because... I cannot reproduce
I was testing main, but I guess I mixed GML 3.2 output format with a
different version of WFS because... I cannot reproduce any longer LOL.
For reference, here is a layer where I disabled the count matched, using
the WFS 2.0 default output format:
curl "
https://gs-main.geosolutionsgroup.com/geos
Thanks Andrea, I was getting the specification numbers confused.
I am trying to reproduce your "when setting it, the numberReturn is zero"
with the 2.24.4 release in preflight testing...
- GeoServer 2.24.4 Layer Preview GML3.1: unknown
- GeoServer 2.24.4 Layer Preview GML3.2: unknown
-
Hi Andrea,
hi Jody,
thanks for that! The "Skip the counting of the numberMatched attribute"
did the trick :-) That's what I was looking for. Works great with both
GML and JSON format.
My client does not require any "numberXxx" attributes. Nevertheless,
with my version 2.22.3, numberMatched i
Hi Jody,
actually... the WFS 2.0 specification leaves out a possibility to return
"unknown" in the count numberMatched field, from the schemas:
To use it, configure the layer to skip number matched (publishing/wfs):
[image: image.png]
I believe this setting is not used often
It is part of GML specification. I have an idea of doing a count estimate
for postgis, kind of like the box estimate. It would only break the spec a
little as long as the answer is higher (until the last page when we would
know for sure).
Can you try a different format that does not require count?
Dear all,
is there a way to prevent GeoServer from issuing a count(*) on a layer's
table (using PostGIS) for every GetFeature WFS request?
Those tables have > 50 million rows. The query itself, which is quite
simple, is very fast as it's using an index (0.1 sec). However,
including the count
