I runmapserver7.6.4 compiled with gdal 3.2.1.
When I output various formats (CSV/KML/GPKG) from my layer (gpkg based), the
requested features are properly returned.
In the case of an ogroutput in geojson format, some of mycolumns are not
returned.The missing column are those with null values.
Here myOUTPUTFORMAT definition
#==============================================
END
OUTPUTFORMAT
NAME "geojson"
DRIVER "OGR/GEOJSON"
FORMATOPTION "LCO:COORDINATE_PRECISION=15"
FORMATOPTION "LCO:WRITE_BBOX=YES"
FORMATOPTION "STORAGE=memory"
FORMATOPTION "FORM=simple"
FORMATOPTION "USE_FEATUREID=true"
FORMATOPTION "FILENAME=%outfile%.geojson"
MIMETYPE "application/geo+json"
#===============================================
I've tested with these 2 additionnal properties without any
success....FORMATOPTION "LCO:WRITE_NON_FINITE_VALUES=YES"
FORMATOPTION "LCO:RFC7946=YES"
i've also tried with
gml_types auto
or
gml_val_cam_annee_1 Character (or Real) without success.
Here 2 links with the current issue.
- wfs output (geojson) with missing column -->
https://ws.mapserver.transports.gouv.qc.ca/swtq?outfile=requestedColumnIsMissing&service=wfs&version=2.0.0&request=getfeature&typename=ms:circulation_routier&outputformat=geojson&srsname=EPSG:4326&count=1&propertyName=val_cam_annee_1
- wfs output (kml) with requested column -->
https://ws.mapserver.transports.gouv.qc.ca/swtq?outfile=requestedcolumIsPresent&service=wfs&version=2.0.0&request=getfeature&typename=ms:circulation_routier&outputformat=kml&srsname=EPSG:4326&count=1&propertyName=val_cam_annee_1
I've found a workaround, I declare a sql syntax with a coalesce(field,'') ...
but I look for a proper fix.
I will probably push this fix on december 7. Here the getfeature responses:
- <?xml version="1.0" encoding="utf-8" ?>
<kml xmlns="http://www.opengis.net/kml/2.2";>
<Document id="root_doc">
<Schema name="circulation_routier" id="circulation_routier">
<SimpleField name="val_cam_annee_1" type="float"></SimpleField>
</Schema>
<Folder><name>circulation_routier</name>
<Placemark>
<Style><LineStyle><color>ff0000ff</color></LineStyle><PolyStyle><fill>0</fill></PolyStyle></Style>
<LineString><coordinates>.....</coordinates></LineString>
</Placemark>
</Folder>
</Document></kml>
- {
"type": "FeatureCollection",
"name": "circulation_routier",
"bbox": [ -72.5617697276407, 45.6593622104288, -72.4990762933546,
45.7595067353991 ],
"features": [
{ "type": "Feature", "id": 1, "properties": { }, "bbox": [ ... ], "geometry": {
"type": "LineString", "coordinates": [ ... ] } }
]}
PE_______________________________________________
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
