CQL Filter

I have installed the Elasticsearch plugin to Geoserver and I am trying to add the Elasticsearch data store. Does anyone know how to successfully create a CQL filter statement so that I can publish a subset of the data instead of all of the data in the store?

This is probably better discussed on the GeoServer Users List rather than here, but there is a fairly comprehensive page in the manual - https://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html

Ian

How do I get to the GeoServer Users list?

I am using the Elasticsearch plugin and I can successfully access an entire data set using Geoserver add layer, but when I try to filter that data set using CQL filter, I get a new layer but it is empty. For example, I have a worldwide facilities database that has data for facilities in most every country in the world. If I do not add a CQL filter, then I successfully get all the worldwide facilities and I can see them in Geosever using Openlayers, GML, and csv. But, when I try to filter such as country = ‘Germany’, the new layer is created but the layer is empty. Any suggestions?

This is the User list/forum (GeoServer User - OSGeo Discourse)

Perhaps Ian meant the Developer forum: GeoServer Developer - OSGeo Discourse. The reason being, because Elasticsearch is a community extension, and even though there is some pretty extensive documentation available at Elasticsearch data store — GeoServer 2.28.x User Manual, by definition these community extensions are not supported and are shared as source code to facilitate collaboration between interested parties.

If you have Java knowledge, you can inspect the source code yourself, starting from: geoserver/src/community/elasticsearch/src/main/java/org/geoserver/elasticsearch at main · geoserver/geoserver · GitHub, but from what I can see, no one has touched the code (apart from reformatting/security issues) for 5+ years.

Do you have further resources to put into this extension?

Peter

I am also trying to use the OGC API plugin. Can you provide the path to the OGC API plugin?

The OGC API extension is officially supported (i.e. it is no longer a community module), and can be found: geoserver/src/extension/ogcapi at main · geoserver/geoserver · GitHub

Sorry for the confusion. I think what might have happened here is @jprogers2 had posted to General channel and seeing it was a geoserver user question, I moved it to geoserver users list, but @ianturton commented before I moved it.

1 Like

Can the OGC API to Geoserver be installed using the files in the GitHub link that you provided?

Hello @jprogers2 and welcome to the user forum.

The link provided by @Peter earlier was to the source code only.

The GeoServer 2.27.0 release created today; includes the Features extension precompiled and available for download.

The User Manual includes installation instructions.