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
Related: