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

485
1
07-04-2022 04:44 AM
Status: Under Consideration
Labels (1)
Bud
by
Notable Contributor

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

Bud_0-1656934387029.png

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

Tags (4)
1 Comment
SSWoodward
Status changed to: Under Consideration