Re: [Geoserver-users] Set a new style (sld file).

2021-08-10 Thread Tõnis Kärdi
Hey, I think some of the filters in the sld are missing a propertyname? e.g: http://www.opengis.net/ogc;> AFFLEUREMENT-EAU so there are no columns to enforce the rule on. All the best, Tõnis On 10.08.21 16:46, celati Laurent wrote: Good afternoon,

[Geoserver-users] Set a new style (sld file).

2021-08-10 Thread celati Laurent
Good afternoon, I'm taking the liberty to post a new message regarding this time style aspects. I try to upload a new style thanks to a sld file generated from qgis. But i have an error message when i try to browse the sld. Please find below the error message : - java.lang.RuntimeException:

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread celati Laurent
Thanks for your replies. Indeed, thanks to CREATE UNIQUE INDEX _idx ON xxx(gid); it's works well this times with no longer error message when loading WFS via qgis. Le mar. 10 août 2021 à 14:15, Bart Zwemmer | GIS Specialisten < b...@gisspecialisten.nl> a écrit : > Materialized views can not have

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread Bart Zwemmer | GIS Specialisten
Dear Laurant, Currently I am busy implementing Materialized Views for a client. In order to have a unique ID, you need to add that to the materialized view: The materialized view needs a unique column to support concurrent refreshing. That means you have to determine a “primary key” and create

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread Ian Turton
You need to tell GeoServer which column to use as a primary key - https://docs.geoserver.org/latest/en/user/data/database/primarykey.html Ian On Tue, 10 Aug 2021 at 12:19, celati Laurent wrote: > Good morning, > > I succeed in loading into geoserver a Postgis materialized view. > With qgis,

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread celati Laurent
Thanks for your reply. In your previous message, i can see indeed the line for create index. But i can't see the line for add a primary key. Is it possible to you to tell how do add the primary key? Because on my side i don't succeed in adding a primary key on my materilzed view thanks to folowing

[Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread celati Laurent
Good morning, I succeed in loading into geoserver a Postgis materialized view. With qgis, no problem for display the data in WMS . But the data does not display with WFS. I paste below the log. Geoserver logs seems to deal with especially to : "Caused by: java.io.IOException: Cannot do natural

Re: [Geoserver-users] WFS and Time dimension

2021-08-10 Thread Christian Mayer
Hi Luciano, yes, you can use the "filter" URL parameter in your WFS request for that. By providing an OGC Filter Encoding compliant XML you can filter your dataset by a date/time column. The slide at [1] will give you a XML snippet as a kind of starting point (the slides are in German but you