<div dir="ltr">Dear Jukka,<div><br></div><div>We have migrated data to the PostGIS database and now everything works fine.</div><div>Thank you for your support.</div><div><br></div><div>Best regards,</div><div>Marcin</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 2 Aug 2021 at 17:16, Rahkonen Jukka (MML) <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="FI" style="word-wrap:break-word">
<div class="gmail-m_-7888395159404322861WordSection1">
<p class="MsoNormal"><span>Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Attributes of type double can not really be nulls in shapefile. See
<a href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/shapefiles/geoprocessing-considerations-for-shapefile-output.htm#GUID-A10ADA3B-0988-4AB1-9EBA-AD704F77B4A2" target="_blank">
https://desktop.arcgis.com/en/arcmap/latest/manage-data/shapefiles/geoprocessing-considerations-for-shapefile-output.htm#GUID-A10ADA3B-0988-4AB1-9EBA-AD704F77B4A2</a>. A value
</span><span lang="EN-US">-1.7976931348623158e+308 might work as a null but I do not consider it generally reliable. Use some other format as a datasource.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka Rahkonen-</span><span lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal"><b>Lähettäjä:</b> mapserver-users <<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>>
<b>Puolesta </b>Marcin Grudzien<br>
<b>Lähetetty:</b> maanantai 2. elokuuta 2021 15.07<br>
<b>Vastaanottaja:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<b>Aihe:</b> [mapserver-users] WFS changing NULL values to 0.<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I am publishing an SHP file via the WFS service using Mapserver 7.2.2<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">In some cases, attributes of a type double have NULL values in the SHP. In such cases, MapServer is publishing them as "0" in GetFeature responses which may be confusing to the data users. I would like to achieve a situation that if the
attribute value is NULLin SHP, the attribute is not published in GetFeature response. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">For example the response instead of this <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><wfs:member><br>
<ms:Bazowa_pozioma><br>
<ms:msGeometry><br>
<gml:Point gml:id=".1" srsName="urn:ogc:def:crs:EPSG::2180"><br>
<gml:pos>419591.224000 697399.714000</gml:pos><br>
</gml:Point><br>
</ms:msGeometry><br>
<ms:NR_PUNKTU>284301500</ms:NR_PUNKTU><br>
<ms:X1992>419591.224</ms:X1992><br>
<ms:Y1992>697399.714</ms:Y1992><br>
<span style="color:red"><ms:H_PLKRON86>0</ms:H_PLKRON86><br>
<ms:MH_PLKRON8>0</ms:MH_PLKRON8></span><br>
</ms:Bazowa_pozioma><br>
</wfs:member><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Should look like this<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><wfs:member><br>
<ms:Bazowa_pozioma><br>
<ms:msGeometry><br>
<gml:Point gml:id=".1" srsName="urn:ogc:def:crs:EPSG::2180"><br>
<gml:pos>419591.224000 697399.714000</gml:pos><br>
</gml:Point><br>
</ms:msGeometry><br>
<ms:NR_PUNKTU>284301500</ms:NR_PUNKTU><br>
<ms:X1992>419591.224</ms:X1992><br>
<ms:Y1992>697399.714</ms:Y1992><br>
</ms:Bazowa_pozioma><br>
</wfs:member><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Can it be achieved in MapServer?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Best regards,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Marcin<u></u><u></u></p>
</div>
</div>
</div>
</div>
</blockquote></div>