[mapserver-dev] "ambiguity" of gml_[item name]_type = Date
Jeff McKenna
jmckenna at gatewaygeomatics.com
Tue Oct 22 15:09:46 PDT 2019
It seems I spend a lot of effort playing with datetime and PostGIS
MapServer, so I am a strong +1 in adding a "datetime" and "time" as
valid options for gml_[item name]_type
-jeff
On 2019-10-22 5:54 PM, Steve Lime wrote:
> Makes complete sense to me at firstĀ glance.
>
> On Tue, Oct 22, 2019 at 3:48 PM Even Rouault <even.rouault at spatialys.com
> <mailto:even.rouault at spatialys.com>> wrote:
>
> Hi,
>
> when serving vector through WFS currently, we can use the gml_[item
> name]_type
> to define the type of a field. Currently we have a value "Date" whose
> semantics is rather loose. All input backends (OGR, Oracle, MSSQL,
> PostGIS)
> use it whereas they have distinct types for Date (without time),
> DateTime, and
> Time (without date). MapServer having internally a single type makes
> that when
> using OGR output (for example GeoJSON), we'll have lost some
> information, and
> thus the OGR output currently prefers to use a OGR OFTDateTime to avoid
> potentially losses. But "2019-10-22T00:00:00Z" is not semantically
> equivalent
> to "2019-10-22".
> So my proposal would be to change (define) Date to be a Date without
> time
> information, and add DateTime and Time types.
>
> Thoughts ?
>
> (note: some backends like Oracle and PostGIS have distinctions between
> DateTime with or without timezone, but we probably don't need to go
> to that
> level of subtelty)
>
> Even
>
> --
> Spatialys - Geospatial professional services
> http://www.spatialys.com
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org <mailto:mapserver-dev at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/mapserver-dev
>
>
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-dev
>
--
Jeff McKenna
MapServer Consulting and Training Services
https://gatewaygeomatics.com/
More information about the mapserver-dev
mailing list