Improve coordinate formatting for ST_IsValidReason
|Reported by:||Mike Taves||Owned by:||pramsey|
A message from ST_IsValidReason(geometry) shows the message:
to describe a point with Easting/Northing coordinates. What I find odd is the mixed conventional numeric and exponential forms.
I [still] can't find the source code for this, but I'm certain there is a "%g %g" formatting code somewhere in there. Although %g is usually a nice formatter, it is unfortunate that it happens to change to exponential format numbers ≥1e+06, which is the range of many projected (i.g., UTM) coordinates (particularly northern ones). [Note, this is probably compiler/platform dependent.]
To make consistent formatting of these coordinates across platforms, and to make it show projected coordinates nicely, I suggest using the formatting code: "%.7g %.7g"
This will use exponential form for numbers ≥1e+07, which most earth-based Easting/Northing coordinates fall within.