<div style="font-family: Arial; font-size: 14px;"><span style="line-height:1.5">I run<span> </span><mark style="display:inline" data-auto-scroll="true">mapserver</mark><span> </span>7.6.4 compiled with gdal 3.2.1.</span><div style="line-height:1.5"><br></div><div style="line-height:1.5">When I output various formats (CSV/KML/GPKG) from my layer (gpkg based), the requested features are properly returned. </div><div style="line-height:1.5"><br></div><div style="line-height:1.5">In the case of an ogroutput in geojson format, some of my<span> </span><span style="background-color:rgb(255, 255, 255);display:inline !important">columns </span>are not returned.The missing column are those with null values. </div><div style="line-height:1.5"><br></div><div style="line-height:1.5">Here my<span> </span><span style="background-color:rgb(255, 255, 255);display:inline !important">OUTPUTFORMAT </span>definition </div><div style="line-height:1.5"><br></div><div style="line-height:1.5">#==============================================</div><div style="line-height:1.5"><span>END</span><div><span> OUTPUTFORMAT</span></div><div><span> NAME "geojson"</span></div><div><span> DRIVER "OGR/GEOJSON"</span></div><div><span> FORMATOPTION "LCO:COORDINATE_PRECISION=15"</span></div><div><span> FORMATOPTION "LCO:WRITE_BBOX=YES"</span></div><div><span> FORMATOPTION "STORAGE=memory"</span></div><div><span> FORMATOPTION "FORM=simple"</span></div><div><span> FORMATOPTION "USE_FEATUREID=true"</span></div><div><span> FORMATOPTION "FILENAME=%outfile%.geojson"</span></div><div><span>MIMETYPE "application/geo+json"</span></div><div>#===============================================</div><div><br></div><div>I've tested with these 2 additionnal properties without any success....</div><span>FORMATOPTION "LCO:WRITE_NON_FINITE_VALUES=YES"</span><br><span>FORMATOPTION "LCO:RFC7946=YES"</span></div><div style="line-height:1.5"><span><br></span></div><div style="line-height:1.5"><span>i've also tried with </span></div><div style="line-height:1.5"><span>gml_types auto</span></div><div style="line-height:1.5"><span>or</span></div><div style="line-height:1.5"><span>gml_val_cam_annee_1 Character (or Real) without success.</span></div><div style="line-height:1.5"><span><br></span></div><div style="line-height:1.5"><span><br></span></div><div style="line-height:1.5"><span>Here 2 links with the current issue.<br></span></div><div style="line-height:1.5"><ol style="margin:0px;padding:0px 0px 0px 2em;font-size:1em"><li><span>wfs output (geojson) with missing column --> <span><span><span><a style="color:var(--interaction-norm);text-decoration:underline;cursor:pointer" target="_blank" rel="noreferrer nofollow noopener" href="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">https://ws.<mark style="display:inline">mapserver</mark>.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</a></span></span><span style="background-color:rgb(255, 255, 255);display:inline !important"><br></span></span></span></li><li><span><span><span style="background-color:rgb(255, 255, 255);display:inline !important">wfs output (kml) with requested column --> </span><span style="background-color:rgb(255, 255, 255)"><span><span><a style="color:var(--interaction-norm);text-decoration:underline;cursor:pointer" target="_blank" rel="noreferrer nofollow noopener" href="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">https://ws.<mark style="display:inline">mapserver</mark>.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</a></span></span></span></span><br></span></li></ol><div><span><span><span style="background-color:rgb(255, 255, 255)"><br></span></span></span></div><div><span><span><span style="background-color:rgb(255, 255, 255)">I've found a workaround, I declare a sql syntax with a coalesce(field,'') ... but I look for a proper fix. </span></span></span></div><div><span><span><span style="background-color:rgb(255, 255, 255)">I will probably push this fix on december 7. Here the getfeature responses:</span></span></span></div><div><span><span><span style="background-color:rgb(255, 255, 255)"><br></span></span></span></div><div><ol style="margin:0px;padding:0px 0px 0px 2em;font-size:1em"><li><span><span><?xml version="1.0" encoding="utf-8" ?></span><div><span><kml xmlns="<a style="color:var(--interaction-norm);text-decoration:underline;cursor:pointer" target="_blank" rel="noreferrer nofollow noopener" href="http://www.opengis.net/kml/2.2">http://www.opengis.net/kml/2.2</a>"></span></div><div><span><Document id="root_doc"></span></div><div><span><Schema name="circulation_routier" id="circulation_routier"></span></div><div><span><SimpleField name="val_cam_annee_1" type="float"></SimpleField></span></div><div><span></Schema></span></div><div><span><Folder><name>circulation_routier</name></span></div><div><span> <Placemark></span></div><div><span><Style><LineStyle><color>ff0000ff</color></LineStyle><PolyStyle><fill>0</fill></PolyStyle></Style></span></div><div><span> <LineString><coordinates>.....</coordinates></LineString></span></div><div><span> </Placemark></span></div><div><span></Folder></span></div><div><span></Document></kml></span></div><span></span><br></span></li><li><span>{</span><div><span>"type": "FeatureCollection",</span></div><div><span>"name": "circulation_routier",</span></div><div><span>"bbox": [ -72.5617697276407, 45.6593622104288, -72.4990762933546, 45.7595067353991 ], </span></div><div><span>"features": [</span></div><div><span>{ "type": "Feature", "id": 1, "properties": { }, "bbox": [ ... ], "geometry": { "type": "LineString", "coordinates": [ ... ] } }</span></div><div><span>]</span></div><span>}</span><br></li></ol></div><div><br></div><span></span></div><br></div>
<div style="font-family: Arial; font-size: 14px;" class="protonmail_signature_block">
<div class="protonmail_signature_block-user">PE</div>
<div class="protonmail_signature_block-proton protonmail_signature_block-empty">
</div>
</div>