[mapserver-dev] [EXTERNAL] Re: WFS - numeric value truncated

[Ian Walberg]

Mike,

Many thanks for these details.

We are able to modify the overall output using a number of the layer object gml options.

However we have not found anything that gets the decimal places of the sqlite NUMERIC field to appear.

We have tried setting the type to Real and then adding a Precision of 1.

I am not sure where we should look next.

Thanks

Ian

From: Smith, Michael ERDC-RDE-CRREL-NH CIV [mailto:Michael.Smith at erdc.dren.mil]
Sent: Monday, June 13, 2016 6:54 AM
To: Ian Walberg <ian.walberg at airborne.aero>; Michael Smith <michael.smith.erdc at gmail.com>
Cc: mapserver-dev at lists.osgeo.org
Subject: Re: [EXTERNAL] Re: [mapserver-dev] WFS - numeric value truncated

Ian,

If adding  "gml_types"   "auto"  doesn't work, try something like "gml_fieldname_type"  "decimal"

http://mapserver.org/ogc/wfs_server.html#layer-object

Mike

--
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From: mapserver-dev <mapserver-dev-bounces at lists.osgeo.org<mailto:mapserver-dev-bounces at lists.osgeo.org>> on behalf of Ian Walberg <ian.walberg at airborne.aero<mailto:ian.walberg at airborne.aero>>
Date: Monday, June 13, 2016 at 8:09 AM
To: Michael Smith <michael.smith.erdc at gmail.com<mailto:michael.smith.erdc at gmail.com>>
Cc: "mapserver-dev at lists.osgeo.org<mailto:mapserver-dev at lists.osgeo.org>" <mapserver-dev at lists.osgeo.org<mailto:mapserver-dev at lists.osgeo.org>>
Subject: [EXTERNAL] Re: [mapserver-dev] WFS - numeric value truncated
Resent-From: Michael Smith <michael.smith at usace.army.mil<mailto:michael.smith at usace.army.mil>>

Michael,

Can you please send an example or a link to where we can find the details.

I had a look around but cannot find anything.

Thanks

Ian

From: Michael Smith [mailto:michael.smith.erdc at gmail.com]
Sent: Saturday, June 11, 2016 9:08 AM
To: Ian Walberg <ian.walberg at airborne.aero<mailto:ian.walberg at airborne.aero>>
Cc: mapserver-dev at lists.osgeo.org<mailto:mapserver-dev at lists.osgeo.org>
Subject: Re: [mapserver-dev] WFS - numeric value truncated

You should set a datatype at the metadata section of your layer. If auto doesn't work then you might need to set it just for the numeric fields.

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

On Jun 11, 2016, at 9:46 AM, Ian Walberg <ian.walberg at airborne.aero<mailto:ian.walberg at airborne.aero>> wrote:
Hello,

Our WFS server setup is using a sqlite database and we are seeing any NUMERIC fields have their decimal places truncated, any VARCHAR fields work ok with all the decimal places retained.

We want to avoid changing he schema in the short term so are looking for a work around.

It does not look like adding a CAST to the SELECT in the DATA statement is supported, are the details of what keywords the mapserver SELECT supports?

Thanks

Ian
_______________________________________________
mapserver-dev mailing list
mapserver-dev at lists.osgeo.org<mailto:mapserver-dev at lists.osgeo.org>
BlockedBlockedhttp://lists.osgeo.org/mailman/listinfo/mapserver-devBlocked
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20160613/87134057/attachment.html>