Re: [Geoserver-users] CQL Filter Vectortiles Plugin

[Dave Blasby]

Hi, Ben,

It's unlikely the VectorTiles renderer pays attention to extra CQL filters
in the WMS request; the VT renderer is very simple.  However, the
functionality would likely be easy to add - just "and" the filter to the
filter being sent to the datastore.

Thanks,
Dave

On Wed, Feb 15, 2017 at 1:29 AM, Jerrim, Ben 
wrote:

> Hey all, we're using the geoserver-2.10-SNAPSHOT-vectortiles-plugin with
> CQL filters in WMS requests and it appears that the CQL filters do not
> apply to the response tiles. If I use the MVT extension (
> https://github.com/stefan0722/gs-mvt) rather than the vectortiles-plugin
> the filters apply correctly.
>
>
>
> Is this a bug in the vectortiles-plugin? Am I missing something? (I’m
> relatively new to the GS ecosystem btw)
>
>
>
>
>
> Cheers,
>
> _
>
> *Ben Jerrim*
>
> Powercor IT | Technical Lead - Digital
>
> A 40 Market Street Melbourne, VIC 3000
>
> P 03 5327 2217 | M 0407 533 043
>
> **
> CitiPower Pty Ltd and Powercor Australia Ltd. This email and any file
> attachments are confidential and intended solely for the use of the
> individual or entity to whom they are addressed. If you have received
> this email in error please tell us immediately by return email and
> delete the document.
> **
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Andrea Aime]

Hi Ian,
it depends on whether it has a reference layer or not in the request, it
might go into one of these:
https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/java/org/geoserver/wms/legendgraphic/BufferedImageLegendGraphicBuilder.java#L759
https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/java/org/geoserver/wms/legendgraphic/BufferedImageLegendGraphicBuilder.java#L780
https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/java/org/geoserver/wms/legendgraphic/BufferedImageLegendGraphicBuilder.java#L856

Not sure what they do, legend graphics generation is one of the places that
I'm not really familiar with :-p

Cheers
Andrea


On Wed, Feb 15, 2017 at 4:56 PM, Ian Turton  wrote:

> Andrea,
>
> That seems to indicate that our fake feature does contain a NULL - may be
> because the attribute allows NULLs?
>
> Infact I think I've been bitten by this before - assuming it is using
> DataUtilities.defaultValue which does return Null if it can get away with it
>
> I used a method like:
>
> private SimpleFeature generateDefaultFeature(SimpleFeatureType schema) {
> SimpleFeature defaultFeature = DataUtilities.template(schema,
> schema.getTypeName());
> // we have to do this as our nullable attributes will be null if not
> for (Property prop : defaultFeature.getProperties()) {
>   Object defaultValue = DataUtilities.defaultValue(
> prop.getType().getBinding());
>   defaultFeature.setAttribute(prop.getName(), defaultValue);
> }
> return defaultFeature;
>   }
>
> to avoid this issue.
>
> Ian
>
> On 15 February 2017 at 15:37, Julian Hollingbery 
> wrote:
>
>> Thanks, that did the trick J
>>
>>
>>
>> Still seem a bit odd that GetLegendGraphic  is more brittle than GetMap..
>>
>>
>>
>> *Fra:* Ian Turton [mailto:ijtur...@gmail.com]
>> *Sendt:* 15. februar 2017 16:22
>>
>> *Til:* Julian Hollingbery 
>> *Cc:* geoserver-users@lists.sourceforge.net
>> *Emne:* Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter
>> function round
>>
>>
>>
>> Then you'll need something like
>>
>> 
>>
>>  
>>
>> > name="isNull">hast_gaeld
>> 0.0,> PropertyName>hast_gaeld
>>
>>   
>>
>> 
>>
>>
>>
>>
>>
>> On 15 February 2017 at 15:17, Julian Hollingbery 
>> wrote:
>>
>> Two things I’d like to note:
>>
>>1. I can make GetMap and GetFeatureInfo requests just fine over the
>>entire area covered by the dataset. Only GetLegendGraphic fails.
>>2. As you can see from the table definition, the parameter to the
>>function is a double. I’ll admit that there are NULL values in a few rows,
>>but why should that prevent GeoServer from generating a legend?
>>
>>
>>
>> *Fra:* Ian Turton [mailto:ijtur...@gmail.com]
>> *Sendt:* 15. februar 2017 16:07
>> *Til:* Julian Hollingbery 
>> *Cc:* geoserver-users@lists.sourceforge.net
>> *Emne:* Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter
>> function round
>>
>>
>>
>> Nope it isn't a bug - the error is quite clear
>>
>>
>>
>> 
>>
>>   java.lang.IllegalArgumentException: Filter Function problem for
>> function round argument #0 - expected type float
>>
>> Filter Function problem for function round argument #0 - expected type
>> float
>>
>> 
>>
>>
>>
>> You are passing something that isn't a number into the round function -
>> you'll either need to check your attributes or add a check to the SLD to
>> limit the input to numbers (probably with an if_then_else and a regexp)
>>
>>
>>
>> On 15 February 2017 at 14:51, Julian Hollingbery 
>> wrote:
>>
>> Hi list,
>>
>>
>>
>> I wonder if anyone else has seen something like this.
>>
>>
>>
>> I have a PostGIS table defined basically as
>>
>>
>>
>> CREATE TABLE vdline
>>
>> (
>>
>>   ogc_fid serial NOT NULL,
>>
>>   hast_gener character varying,
>>
>>   kode_hast0 character varying,
>>
>>   hast_lokal double precision,
>>
>>   hast_gaeld double precision,
>>
>>   hast_anbef double precision,
>>
>>   hast_var_h character varying,
>>
>>   geometri geometry(MultiLineString),
>>
>>   CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
>>
>> )
>>
>> WITH (
>>
>>   OIDS=FALSE
>>
>> );
>>
>>
>>
>> I publish it through GeoServer 2.9.1, using a style looking basically
>> like this:
>>
>>
>>
>> 
>>
>> http://www
>> .opengis.net/sld StyledLayerDescriptor.xsd" xmlns="
>> http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc;
>> xmlns:xlink="http://www.w3.org/1999/xlink; xmlns:xsi="http://www.w3.org/2
>> 001/XMLSchema-instance">
>>
>>
>>
>>   vdline
>>
>>   
>>
>>
>> Hastighedsgrænser
>>
>>
>> Visualisering af hastighedsgrænsedata
>>
>>
>> 
>>
>>
>>
>>
>>
>>
>> Skiltet hastighed 40
>>
>>
>>
>> Skiltet hastighed 40 km/t
>>
>>
>>
>> Skiltet 

Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Ian Turton]

Andrea,

That seems to indicate that our fake feature does contain a NULL - may be
because the attribute allows NULLs?

Infact I think I've been bitten by this before - assuming it is using
DataUtilities.defaultValue which does return Null if it can get away with it

I used a method like:

private SimpleFeature generateDefaultFeature(SimpleFeatureType schema) {
SimpleFeature defaultFeature = DataUtilities.template(schema,
schema.getTypeName());
// we have to do this as our nullable attributes will be null if not
for (Property prop : defaultFeature.getProperties()) {
  Object defaultValue =
DataUtilities.defaultValue(prop.getType().getBinding());
  defaultFeature.setAttribute(prop.getName(), defaultValue);
}
return defaultFeature;
  }

to avoid this issue.

Ian

On 15 February 2017 at 15:37, Julian Hollingbery 
wrote:

> Thanks, that did the trick J
>
>
>
> Still seem a bit odd that GetLegendGraphic  is more brittle than GetMap..
>
>
>
> *Fra:* Ian Turton [mailto:ijtur...@gmail.com]
> *Sendt:* 15. februar 2017 16:22
>
> *Til:* Julian Hollingbery 
> *Cc:* geoserver-users@lists.sourceforge.net
> *Emne:* Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter
> function round
>
>
>
> Then you'll need something like
>
> 
>
>  
>
>  name="isNull">hast_gaeld
> 0.0,
> hast_gaeld
>
>   
>
> 
>
>
>
>
>
> On 15 February 2017 at 15:17, Julian Hollingbery 
> wrote:
>
> Two things I’d like to note:
>
>1. I can make GetMap and GetFeatureInfo requests just fine over the
>entire area covered by the dataset. Only GetLegendGraphic fails.
>2. As you can see from the table definition, the parameter to the
>function is a double. I’ll admit that there are NULL values in a few rows,
>but why should that prevent GeoServer from generating a legend?
>
>
>
> *Fra:* Ian Turton [mailto:ijtur...@gmail.com]
> *Sendt:* 15. februar 2017 16:07
> *Til:* Julian Hollingbery 
> *Cc:* geoserver-users@lists.sourceforge.net
> *Emne:* Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter
> function round
>
>
>
> Nope it isn't a bug - the error is quite clear
>
>
>
> 
>
>   java.lang.IllegalArgumentException: Filter Function problem for
> function round argument #0 - expected type float
>
> Filter Function problem for function round argument #0 - expected type
> float
>
> 
>
>
>
> You are passing something that isn't a number into the round function -
> you'll either need to check your attributes or add a check to the SLD to
> limit the input to numbers (probably with an if_then_else and a regexp)
>
>
>
> On 15 February 2017 at 14:51, Julian Hollingbery 
> wrote:
>
> Hi list,
>
>
>
> I wonder if anyone else has seen something like this.
>
>
>
> I have a PostGIS table defined basically as
>
>
>
> CREATE TABLE vdline
>
> (
>
>   ogc_fid serial NOT NULL,
>
>   hast_gener character varying,
>
>   kode_hast0 character varying,
>
>   hast_lokal double precision,
>
>   hast_gaeld double precision,
>
>   hast_anbef double precision,
>
>   hast_var_h character varying,
>
>   geometri geometry(MultiLineString),
>
>   CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
>
> )
>
> WITH (
>
>   OIDS=FALSE
>
> );
>
>
>
> I publish it through GeoServer 2.9.1, using a style looking basically like
> this:
>
>
>
> 
>
> http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc;
> xmlns:xlink="http://www.w3.org/1999/xlink; xmlns:xsi="http://www.w3.org/
> 2001/XMLSchema-instance">
>
>
>
>   vdline
>
>   
>
>
> Hastighedsgrænser
>
>
> Visualisering af hastighedsgrænsedata
>
>
> 
>
>
>
>
>
>
> Skiltet hastighed 40
>
>
>
> Skiltet hastighed 40 km/t
>
>
>
> Skiltet hastighed (hast_lokal) 40 km/t. Etiket viser gældende
> hastighed (hast_gaeld)
>
>
>
> 
>
>
>
>
> 
>
>
>
>
> hast_lokal
>
>
>
>
> 40
>
>
>
>
> 
>
>
>
> 
>
>
>
> 
>
>
>
>
>
>
>
>
> #ff
>
>
>
>
> 1
>
>
>
>
>
>
>
> 
>
>
>
> 
>
>
>
>
>
>PropertyName>hast_gaeld
>
>
>
>
>
>
>
>
>
>
>
>
> 10
>
>
>
>
> Arial
>
>
>
>
> #aa
>
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
>
>
>
> 0
>
>
>
>
> 
>
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
>
>
> 1
>
>
>
>
> 
>
>
>
>
> 
>
>
>
>
> #f4faf6
>
>
>
>   
>
>
>
>
>
>
>
>
>
>
>
>
> #aa
>
>
>
>
>
>
>
>50 VendorOption>
>
>
>
>  

Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Julian Hollingbery]

Thanks, that did the trick ☺

Still seem a bit odd that GetLegendGraphic  is more brittle than GetMap..

Fra: Ian Turton [mailto:ijtur...@gmail.com]
Sendt: 15. februar 2017 16:22
Til: Julian Hollingbery 
Cc: geoserver-users@lists.sourceforge.net
Emne: Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function 
round

Then you'll need something like

 
hast_gaeld0.0,hast_gaeld
  



On 15 February 2017 at 15:17, Julian Hollingbery 
> wrote:
Two things I’d like to note:

  1.  I can make GetMap and GetFeatureInfo requests just fine over the entire 
area covered by the dataset. Only GetLegendGraphic fails.
  2.  As you can see from the table definition, the parameter to the function 
is a double. I’ll admit that there are NULL values in a few rows, but why 
should that prevent GeoServer from generating a legend?

Fra: Ian Turton [mailto:ijtur...@gmail.com]
Sendt: 15. februar 2017 16:07
Til: Julian Hollingbery >
Cc: 
geoserver-users@lists.sourceforge.net
Emne: Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function 
round

Nope it isn't a bug - the error is quite clear


  java.lang.IllegalArgumentException: Filter Function problem for function 
round argument #0 - expected type float
Filter Function problem for function round argument #0 - expected type float


You are passing something that isn't a number into the round function - you'll 
either need to check your attributes or add a check to the SLD to limit the 
input to numbers (probably with an if_then_else and a regexp)

On 15 February 2017 at 14:51, Julian Hollingbery 
> wrote:
Hi list,

I wonder if anyone else has seen something like this.

I have a PostGIS table defined basically as

CREATE TABLE vdline
(
  ogc_fid serial NOT NULL,
  hast_gener character varying,
  kode_hast0 character varying,
  hast_lokal double precision,
  hast_gaeld double precision,
  hast_anbef double precision,
  hast_var_h character varying,
  geometri geometry(MultiLineString),
  CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
)
WITH (
  OIDS=FALSE
);

I publish it through GeoServer 2.9.1, using a style looking basically like this:


http://www.opengis.net/sld StyledLayerDescriptor.xsd" 
xmlns="http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc; 
xmlns:xlink="http://www.w3.org/1999/xlink; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>
   
  vdline
  

  Hastighedsgrænser

  Visualisering af hastighedsgrænsedata

  

 

Skiltet hastighed 
40

Skiltet 
hastighed 40 km/t

Skiltet 
hastighed (hast_lokal) 40 km/t. Etiket viser gældende hastighed 
(hast_gaeld)




  


  
hast_lokal


 
40


  



   

Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Julian Hollingbery]

Two things I’d like to note:

  1.  I can make GetMap and GetFeatureInfo requests just fine over the entire 
area covered by the dataset. Only GetLegendGraphic fails.
  2.  As you can see from the table definition, the parameter to the function 
is a double. I’ll admit that there are NULL values in a few rows, but why 
should that prevent GeoServer from generating a legend?

Fra: Ian Turton [mailto:ijtur...@gmail.com]
Sendt: 15. februar 2017 16:07
Til: Julian Hollingbery 
Cc: geoserver-users@lists.sourceforge.net
Emne: Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function 
round

Nope it isn't a bug - the error is quite clear


  java.lang.IllegalArgumentException: Filter Function problem for function 
round argument #0 - expected type float
Filter Function problem for function round argument #0 - expected type float


You are passing something that isn't a number into the round function - you'll 
either need to check your attributes or add a check to the SLD to limit the 
input to numbers (probably with an if_then_else and a regexp)

On 15 February 2017 at 14:51, Julian Hollingbery 
> wrote:
Hi list,

I wonder if anyone else has seen something like this.

I have a PostGIS table defined basically as

CREATE TABLE vdline
(
  ogc_fid serial NOT NULL,
  hast_gener character varying,
  kode_hast0 character varying,
  hast_lokal double precision,
  hast_gaeld double precision,
  hast_anbef double precision,
  hast_var_h character varying,
  geometri geometry(MultiLineString),
  CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
)
WITH (
  OIDS=FALSE
);

I publish it through GeoServer 2.9.1, using a style looking basically like this:


http://www.opengis.net/sld StyledLayerDescriptor.xsd" 
xmlns="http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc; 
xmlns:xlink="http://www.w3.org/1999/xlink; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>
   
  vdline
  

  Hastighedsgrænser

  Visualisering af hastighedsgrænsedata

  

 

Skiltet hastighed 
40

Skiltet 
hastighed 40 km/t

Skiltet 
hastighed (hast_lokal) 40 km/t. Etiket viser gældende hastighed 
(hast_gaeld)




  


  
hast_lokal


 
40


  






   


  #ff


  1

  

Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Andrea Aime]

Hi Ian,
it might, or might not... to build legend graphics we create a sample
features with all default
values for the data types of the feature... it might be that map rendering
works,
but legend graphic fails

Cheers
Andrea


On Wed, Feb 15, 2017 at 4:07 PM, Ian Turton  wrote:

> Nope it isn't a bug - the error is quite clear
>
> 
>
>   java.lang.IllegalArgumentException: Filter Function problem for
> function round argument #0 - expected type float
>
> Filter Function problem for function round argument #0 - expected type
> float
>
> 
>
>
>
> You are passing something that isn't a number into the round function -
> you'll either need to check your attributes or add a check to the SLD to
> limit the input to numbers (probably with an if_then_else and a regexp)
>
> On 15 February 2017 at 14:51, Julian Hollingbery 
> wrote:
>
>> Hi list,
>>
>>
>>
>> I wonder if anyone else has seen something like this.
>>
>>
>>
>> I have a PostGIS table defined basically as
>>
>>
>>
>> CREATE TABLE vdline
>>
>> (
>>
>>   ogc_fid serial NOT NULL,
>>
>>   hast_gener character varying,
>>
>>   kode_hast0 character varying,
>>
>>   hast_lokal double precision,
>>
>>   hast_gaeld double precision,
>>
>>   hast_anbef double precision,
>>
>>   hast_var_h character varying,
>>
>>   geometri geometry(MultiLineString),
>>
>>   CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
>>
>> )
>>
>> WITH (
>>
>>   OIDS=FALSE
>>
>> );
>>
>>
>>
>> I publish it through GeoServer 2.9.1, using a style looking basically
>> like this:
>>
>>
>>
>> 
>>
>> http://www
>> .opengis.net/sld StyledLayerDescriptor.xsd" xmlns="
>> http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc;
>> xmlns:xlink="http://www.w3.org/1999/xlink; xmlns:xsi="http://www.w3.org/2
>> 001/XMLSchema-instance">
>>
>>
>>
>>   vdline
>>
>>   
>>
>>
>> Hastighedsgrænser
>>
>>
>> Visualisering af hastighedsgrænsedata
>>
>>
>> 
>>
>>
>>
>>
>>
>>
>> Skiltet hastighed 40
>>
>>
>>
>> Skiltet hastighed 40 km/t
>>
>>
>>
>> Skiltet hastighed (hast_lokal) 40 km/t. Etiket viser gældende
>> hastighed (hast_gaeld)
>>
>>
>>
>> 
>>
>>
>>
>>
>> 
>>
>>
>>
>>
>> hast_lokal
>>
>>
>>
>>
>> 40
>>
>>
>>
>>
>> 
>>
>>
>>
>> 
>>
>>
>>
>> 
>>
>>
>>
>>
>>
>>
>>
>>
>> #ff
>>
>>
>>
>>
>> 1
>>
>>
>>
>>
>>
>>
>>
>> 
>>
>>
>>
>> 
>>
>>
>>
>>
>>
>>   > >hast_gaeld
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> 10
>>
>>
>>
>>
>> Arial
>>
>>
>>
>>
>> #aa
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> 
>>
>>
>>
>>
>>
>> 0
>>
>>
>>
>>
>> 
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> 
>>
>>
>>
>>
>> 1
>>
>>
>>
>>
>> 
>>
>>
>>
>>
>> 
>>
>>
>>
>>
>> #f4faf6
>>
>>
>>
>>   
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> #aa
>>
>>
>>
>>
>>
>>
>>
>>50> dorOption>
>>
>>
>>
>>true> ndorOption>
>>
>>
>>
>>true> Option>
>>
>>
>>
>>true
>>
>>
>>
>> 
>>
>>
>>  
>>
>>
>> 
>>
>>   
>>
>>
>>
>> 
>>
>>
>>
>> The complete SLD contains multiple s for various values
>> of hast_lokal.
>>
>>
>>
>> If I make a GetLegendGraphic-request like
>>
>> http://hostname/workspace/wms?service=WMS=1.1.0
>> est=GetLegendGraphic=vdline=image/png
>>
>> I get the error:
>>
>> > ServiceExceptionReport SYSTEM "http://gs.demo.geoteamwork.co
>> m:80/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd"> > version="1.1.1" >   
>>
>>   java.lang.IllegalArgumentException: Filter Function problem for
>> function round argument #0 - expected type float
>>
>> Filter Function problem for function round argument #0 - expected type
>> float
>>
>> 
>>
>>
>>
>> If I modify the SLD, specifically the , removing the > name=”round”>, so that it becomes
>>
>>
>>
>>
>>
>>   hast_gaeld
>>
>>
>>
>>
>>
>>
>>
>> I get a nice legend. Is that a bug?
>>
>>
>>
>> Regards,
>>
>> /julian
>>
>>
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>> ___
>> Geoserver-users mailing list
>> 

Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Ian Turton]

Then you'll need something like



 

hast_gaeld
0.0,hast_gaeld

  




On 15 February 2017 at 15:17, Julian Hollingbery 
wrote:

> Two things I’d like to note:
>
>1. I can make GetMap and GetFeatureInfo requests just fine over the
>entire area covered by the dataset. Only GetLegendGraphic fails.
>2. As you can see from the table definition, the parameter to the
>function is a double. I’ll admit that there are NULL values in a few rows,
>but why should that prevent GeoServer from generating a legend?
>
>
>
> *Fra:* Ian Turton [mailto:ijtur...@gmail.com]
> *Sendt:* 15. februar 2017 16:07
> *Til:* Julian Hollingbery 
> *Cc:* geoserver-users@lists.sourceforge.net
> *Emne:* Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter
> function round
>
>
>
> Nope it isn't a bug - the error is quite clear
>
>
>
> 
>
>   java.lang.IllegalArgumentException: Filter Function problem for
> function round argument #0 - expected type float
>
> Filter Function problem for function round argument #0 - expected type
> float
>
> 
>
>
>
> You are passing something that isn't a number into the round function -
> you'll either need to check your attributes or add a check to the SLD to
> limit the input to numbers (probably with an if_then_else and a regexp)
>
>
>
> On 15 February 2017 at 14:51, Julian Hollingbery 
> wrote:
>
> Hi list,
>
>
>
> I wonder if anyone else has seen something like this.
>
>
>
> I have a PostGIS table defined basically as
>
>
>
> CREATE TABLE vdline
>
> (
>
>   ogc_fid serial NOT NULL,
>
>   hast_gener character varying,
>
>   kode_hast0 character varying,
>
>   hast_lokal double precision,
>
>   hast_gaeld double precision,
>
>   hast_anbef double precision,
>
>   hast_var_h character varying,
>
>   geometri geometry(MultiLineString),
>
>   CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
>
> )
>
> WITH (
>
>   OIDS=FALSE
>
> );
>
>
>
> I publish it through GeoServer 2.9.1, using a style looking basically like
> this:
>
>
>
> 
>
> http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc;
> xmlns:xlink="http://www.w3.org/1999/xlink; xmlns:xsi="http://www.w3.org/
> 2001/XMLSchema-instance">
>
>
>
>   vdline
>
>   
>
>
> Hastighedsgrænser
>
>
> Visualisering af hastighedsgrænsedata
>
>
> 
>
>
>
>
>
>
> Skiltet hastighed 40
>
>
>
> Skiltet hastighed 40 km/t
>
>
>
> Skiltet hastighed (hast_lokal) 40 km/t. Etiket viser gældende
> hastighed (hast_gaeld)
>
>
>
> 
>
>
>
>
> 
>
>
>
>
> hast_lokal
>
>
>
>
> 40
>
>
>
>
> 
>
>
>
> 
>
>
>
> 
>
>
>
>
>
>
>
>
> #ff
>
>
>
>
> 1
>
>
>
>
>
>
>
> 
>
>
>
> 
>
>
>
>
>
>PropertyName>hast_gaeld
>
>
>
>
>
>
>
>
>
>
>
>
> 10
>
>
>
>
> Arial
>
>
>
>
> #aa
>
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
>
>
>
> 0
>
>
>
>
> 
>
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
>
>
> 1
>
>
>
>
> 
>
>
>
>
> 
>
>
>
>
> #f4faf6
>
>
>
>   
>
>
>
>
>
>
>
>
>
>
>
>
> #aa
>
>
>
>
>
>
>
>50 VendorOption>
>
>
>
>true VendorOption>
>
>
>
>true VendorOption>
>
>
>
>true
>
>
>
> 
>
>
>  
>
>
> 
>
>   
>
>
>
> 
>
>
>
> The complete SLD contains multiple s for various values
> of hast_lokal.
>
>
>
> If I make a GetLegendGraphic-request like
>
> http://hostname/workspace/wms?service=WMS=1.1.0;
> request=GetLegendGraphic=vdline=image/png
>
> I get the error:
>
>  ServiceExceptionReport SYSTEM "http://gs.demo.geoteamwork.
> com:80/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd">
>
>
>   java.lang.IllegalArgumentException: Filter Function problem for
> function round argument #0 - expected type float
>
> Filter Function problem for function round argument #0 - expected type
> float
>
> 
>
>
>
> If I modify the SLD, specifically the , removing the  name=”round”>, so that it becomes
>
>
>
>
>
>   hast_gaeld
>
>
>
>
>
>
>
> I get a nice legend. Is that a bug?
>
>
>
> Regards,
>
> /julian
>
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> 

Re: [Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Ian Turton]

Nope it isn't a bug - the error is quite clear



  java.lang.IllegalArgumentException: Filter Function problem for
function round argument #0 - expected type float

Filter Function problem for function round argument #0 - expected type float





You are passing something that isn't a number into the round function -
you'll either need to check your attributes or add a check to the SLD to
limit the input to numbers (probably with an if_then_else and a regexp)

On 15 February 2017 at 14:51, Julian Hollingbery 
wrote:

> Hi list,
>
>
>
> I wonder if anyone else has seen something like this.
>
>
>
> I have a PostGIS table defined basically as
>
>
>
> CREATE TABLE vdline
>
> (
>
>   ogc_fid serial NOT NULL,
>
>   hast_gener character varying,
>
>   kode_hast0 character varying,
>
>   hast_lokal double precision,
>
>   hast_gaeld double precision,
>
>   hast_anbef double precision,
>
>   hast_var_h character varying,
>
>   geometri geometry(MultiLineString),
>
>   CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
>
> )
>
> WITH (
>
>   OIDS=FALSE
>
> );
>
>
>
> I publish it through GeoServer 2.9.1, using a style looking basically like
> this:
>
>
>
> 
>
> http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc;
> xmlns:xlink="http://www.w3.org/1999/xlink; xmlns:xsi="http://www.w3.org/
> 2001/XMLSchema-instance">
>
>
>
>   vdline
>
>   
>
>
> Hastighedsgrænser
>
>
> Visualisering af hastighedsgrænsedata
>
>
> 
>
>
>
>
>
>
> Skiltet hastighed 40
>
>
>
> Skiltet hastighed 40 km/t
>
>
>
> Skiltet hastighed (hast_lokal) 40 km/t. Etiket viser gældende
> hastighed (hast_gaeld)
>
>
>
> 
>
>
>
>
> 
>
>
>
>
> hast_lokal
>
>
>
>
> 40
>
>
>
>
> 
>
>
>
> 
>
>
>
> 
>
>
>
>
>
>
>
>
> #ff
>
>
>
>
> 1
>
>
>
>
>
>
>
> 
>
>
>
> 
>
>
>
>
>
>PropertyName>hast_gaeld
>
>
>
>
>
>
>
>
>
>
>
>
> 10
>
>
>
>
> Arial
>
>
>
>
> #aa
>
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
>
>
>
> 0
>
>
>
>
> 
>
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
>
>
> 1
>
>
>
>
> 
>
>
>
>
> 
>
>
>
>
> #f4faf6
>
>
>
>   
>
>
>
>
>
>
>
>
>
>
>
>
> #aa
>
>
>
>
>
>
>
>50 VendorOption>
>
>
>
>true VendorOption>
>
>
>
>true VendorOption>
>
>
>
>true
>
>
>
> 
>
>
>  
>
>
> 
>
>   
>
>
>
> 
>
>
>
> The complete SLD contains multiple s for various values
> of hast_lokal.
>
>
>
> If I make a GetLegendGraphic-request like
>
> http://hostname/workspace/wms?service=WMS=1.1.0;
> request=GetLegendGraphic=vdline=image/png
>
> I get the error:
>
>  ServiceExceptionReport SYSTEM "http://gs.demo.geoteamwork.
> com:80/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd">
>
>
>   java.lang.IllegalArgumentException: Filter Function problem for
> function round argument #0 - expected type float
>
> Filter Function problem for function round argument #0 - expected type
> float
>
> 
>
>
>
> If I modify the SLD, specifically the , removing the  name=”round”>, so that it becomes
>
>
>
>
>
>   hast_gaeld
>
>
>
>
>
>
>
> I get a nice legend. Is that a bug?
>
>
>
> Regards,
>
> /julian
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


-- 
Ian Turton
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] GetLegendGraphic fails if SLD uses filter function round

[Julian Hollingbery]

Hi list,

I wonder if anyone else has seen something like this.

I have a PostGIS table defined basically as

CREATE TABLE vdline
(
  ogc_fid serial NOT NULL,
  hast_gener character varying,
  kode_hast0 character varying,
  hast_lokal double precision,
  hast_gaeld double precision,
  hast_anbef double precision,
  hast_var_h character varying,
  geometri geometry(MultiLineString),
  CONSTRAINT vdline_pkey PRIMARY KEY (ogc_fid)
)
WITH (
  OIDS=FALSE
);

I publish it through GeoServer 2.9.1, using a style looking basically like this:


http://www.opengis.net/sld StyledLayerDescriptor.xsd" 
xmlns="http://www.opengis.net/sld; xmlns:ogc="http://www.opengis.net/ogc; 
xmlns:xlink="http://www.w3.org/1999/xlink; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>
   
  vdline
  

  Hastighedsgrænser

  Visualisering af hastighedsgrænsedata

  

 

Skiltet hastighed 
40

Skiltet 
hastighed 40 km/t

Skiltet 
hastighed (hast_lokal) 40 km/t. Etiket viser gældende hastighed 
(hast_gaeld)




  


  
hast_lokal


 
40


  






   


  #ff


  1


   






   
  hast_gaeld


   


   


  10

Re: [Geoserver-users] Database pooling for clustered Geoserver configuration

[dimmihel]

Hi Simone,

This is really useful; thanks for taking the time to reply.

Regards,
D.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Database-pooling-for-clustered-Geoserver-configuration-tp5306937p5308012.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Geoserver data stores

[dimmihel]

Hi Andrea,

The plan is to have one store only for the specific data which will be
published by that instance of Geoserver since all the data will be stored in
the same database, schema, and accessed using the same user.

Using the JNDI functionality is in my remit as well.

Regards,
D.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Geoserver-data-stores-tp5307897p5308010.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Geoserver data stores

[dimmihel]

Hi Daniel,

Thanks for the useful summary for the workspaces / layers security;
certainly this clears some things up in my head.

However as you also mention there still there is no need for many stores
accessing with the same database user (i.e. test_user) the same database
name (i.e. test_database), schema (i.e. test_schema).

Upgrading the current Geoserver version to the latest is also top priority
but need to untangle some of the configuration that I don't understand yet!

Cheers again,
D.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Geoserver-data-stores-tp5307897p5308009.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] CQL Filter Vectortiles Plugin

[Jerrim, Ben]

Hey all, we're using the geoserver-2.10-SNAPSHOT-vectortiles-plugin with CQL 
filters in WMS requests and it appears that the CQL filters do not apply to the 
response tiles. If I use the MVT extension 
(https://github.com/stefan0722/gs-mvt) rather than the vectortiles-plugin the 
filters apply correctly.

Is this a bug in the vectortiles-plugin? Am I missing something? (I’m 
relatively new to the GS ecosystem btw)


Cheers,
_
Ben Jerrim
Powercor IT | Technical Lead - Digital
A 40 Market Street Melbourne, VIC 3000
P 03 5327 2217 | M 0407 533 043
**
CitiPower Pty Ltd and Powercor Australia Ltd. This email and any file
attachments are confidential and intended solely for the use of the
individual or entity to whom they are addressed. If you have received
this email in error please tell us immediately by return email and
delete the document.
**
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users