[mapserver-users] feature_id not found as wfs feature_id in a spatialite db

[Andrea Peri]

Hi Even,
Your workaround is work and is perfect for me.

Thx,

A.


2016-07-18 10:02 GMT+02:00 Even Rouault <even.rouault at spatialys.com>:
> Andrea,
>
>> I like to understand why mapserver seem don't recognize a field that
>> is primary key as feature_id field.
>
> The issue is that PK_UID is recognized by OGR as the field for the OGR
> featureid and thus not exposed as an item to MapServer. One way to workaround
> this is to make the PK_UID field available as a regular field with a SELECT
>
> For example, like this :
>
>   NAME towns
>   DATA "SELECT ROWID as msFID, * FROM towns"
>   CONNECTIONTYPE OGR
>   CONNECTION "./data/db.sqlite"
>   METADATA
>     "ows_title"         "towns"
>     "wfs_featureid"     "msFID"
>     "gml_exclude_items" "msFID"
>     "gml_include_items" "all"
>     "gml_types"         "auto"
>   END
>
> Even
>
> --
> Spatialys - Geospatial professional services
> http://www.spatialys.com



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------