Select to view content in your preferred language

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

709
2
07-04-2022 04:44 AM
Status: In Product Plan
Labels (1)
Bud
by
Esteemed 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)
2 Comments
SSWoodward
Status changed to: Under Consideration
 
SSWoodward
Status changed to: In Product Plan