idea Store blank M-values as null, not negative infinity/NaN in ArcGIS Pro Ideas

Store blank M-values as null, not negative infinity/NaN

Bud — Wed, 16 Aug 2023 20:54:03 GMT

If I understand correctly, ArcGIS Pro stores blank M-values as negative infinity/NaN:

--Oracle 18c SDE.ST_GEOMETRY EGDB
select
    sde.st_m(sde.st_endpoint(shape)) as endpoint_m
from
    my_line

ENDPOINT_M
----------
-Infinity

It seems weird to me that blank M-values would be stored as negative infinity/NaN. It wouldn't occur to me to query for negative infinity/NaN using SQL. I would query for null, since null means unknown or missing.

Could that behavior be changed, so that blank M-values are stored as null?

Edited Aug 16, 2023

Re: Store blank M-values as null, not negative infinity/NaN - Status changed to: Under Consideration

SSWoodward — Wed, 16 Aug 2023 14:34:51 GMT

Re: Store blank M-values as null, not negative infinity/NaN - Status changed to: In Product Plan

SSWoodward — Wed, 24 Apr 2024 00:40:13 GMT

Re: Store blank M-values as null, not negative infinity/NaN - Status changed to: Closed

SSWoodward — Fri, 18 Apr 2025 21:38:02 GMT

After investigating this as a potential change to the data model, this change will not be implemented. Undefined M values will continue to store a negative infinity in Oracle and return NaN in ArcGIS Pro.