: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
As quoted from Rahkonen Jukka (MML)
jukka.rahko...@maanmittauslaitos.fi:
By reading the GML 3 standard it for example defines that Real and
Number are
of type xsd:double, and following
As quoted from Eichner, Andreas - SID andreas.eich...@sid.sachsen.de:
And the implementation specification is also very imprecise about it:
The Literal element is used to encode literal scalar and geometric
values.
So the schema does not restrict the Literal's value to be xsd:double
As quoted from Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil:
Its also unclear to me if XML / WFS allows other characters as a decimal
character. I've yet to find any xsd or guide docs that indicate one way or the
other.
Easiest to read is from RELAX NG:
As quoted from Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi:
By reading the GML 3 standard it for example defines that Real and Number are
of type xsd:double, and following that path to
http://books.xmlschemata.org/relaxng/ch19-77065.html
[Missed Jukka's reply first time round.]
,
Michael Smith michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
Thank you all for this discussion.
We had different problems in our use case coming from gdal, mapserv, oracle
@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
here is the mapserver log with ogc:PropertyIsEqualTo
matchCase=trueogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61,8031
Steve,
Rerun this with DEBUG 3 on the LAYER and the generated SQL will show up in your
error logs. Then it should show why the generated sql is not valid.
Mike
--
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
___
mapserver-users
...@erdc.dren.mi
Aihe: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature
with filter on numeric field
Is there somewhere in the capabilities response where a user would declare what
decimal separators are supported?
From:
mapserver-users-boun
;
MapserverList OSGEO
Cc: michael.sm...@erdc.dren.mi
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
Jukka,
The issue is not only the NLS format, which would govern the output and how the
sql is interpreted, but there is also the issue
@lists.osgeo.org
Cc: michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi
michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
Resent-From: Michael Smith
michael.sm
@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Cc: michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi
michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
Resent-From: Michael
It looks like whats happening is that’s being converted into 3 Tokens and the
oracle driver converts it into a number + comma + number.
The tokenizer is not treating that value as a single value.
Mike
--
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
@lists.osgeo.org
Objet
Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature
with filter on numeric field
It looks like whats happening is that?s being converted into 3 Tokens and
the oracle driver converts it into a number + comma + number.
The tokenizer is not treating
-NH
Sent: Tuesday, May 19, 2015 11:27 AM
To: MapserverList OSGEO
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
It looks like whats happening is that's being converted into 3 Tokens and the
oracle driver converts it into a number
Hi,
I made some tests with SQL*Plus. I took a row which has an attribute nro
which is of type REAL and the value with my Finnish locale looks like 42.071.
I suggest you, Steve, to repeat this simple test.
SQL select nro from test_table where nro=42,071;
To: MapserverList OSGEO
Cc: michael.sm...@erdc.dren.mi
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs
getFeature with filter on numeric field
It seems to be a bug isn't?
Do you want me to open an issue?
Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.milmailto:michael.sm
Hey guys,
Its not clear to me that commas as the decimal separator is supported in
XML/GML. I can't find any documentation to indicate that it is. Can you
point some out to me?
Is there a documentation that says that it is not?
Folks from gdal list also think that it is not supported...I
Hi,
I think that the real trouble is that with certain database and client settings
the numerical data that is stored into Oracle is not interpreted correctly and
correct place to fix the issue is somewhere very close to Oracle. Not in making
GML parser to accept commas or to make WFS string
-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org,
thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs
getFeature with filter on numeric field
Is there a documentation that says that it is not?
Folks
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org,
thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs
getFeature with filter on numeric field
Thanks Mike for having a look at it.
Your
thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs
getFeature with filter on numeric field
Thanks Mike for having a look at it.
Your decimals are separated by a comma or a dot?
Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil
2015-05-13 18
mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature
with filter on numeric field
Steve,
I tested this out with 7.1 with numeric type fields and it works for me as
long as I don't use matchCase=false. That seems to kick it in to a
string
MapserverList OSGEO mapserver-users@lists.osgeo.org, thomas bonfort
thomas.bonf...@gmail.com
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature
with filter on numeric field
The matchCase triggers a string comparison. matchCase doesn't seem to make
sense
@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature
with filter on numeric field
Resent-From: Michael Smith
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil
Precision: we are using MS7.1
Removing matchcase part makes
24 matches
Mail list logo