topic Re: Pro not respecting database field scale settings in ArcGIS Pro Questions

Pro not respecting database field scale settings

ZorbaConlen1 — Wed, 25 Jan 2023 18:21:32 GMT

Hi. I'm running into an issue with Pro, where it changes field properties for numeric field types. In the SDE (sql server) table, the field has a scale setting of 10. This indicates that 10 decimal places should be shown after the decimal. Actually, it's a spatial view, but the view properties show scale setting of 10, and 10 digits are shown when previewing the data.

When I add that view to Pro, the scale is shown as 8.

And when I publish it as a map service, only 8 places after the decimal are shown

The upshot is that I can't display the data properly in my web app.

One may ask why do we need to show 10 decimal places. Normally, it would not be an issue, but this is an app for professional land surveyors and for that audience it's significant to drop 2 decimal places.

Also, I'd like to avoid converting the field to text as a work-around.

Thanks in advance for any solutions to this issue.

Re: Pro not respecting database field scale settings

George_Thompson — Wed, 25 Jan 2023 19:19:32 GMT

I am not 100% but wonder if it is a limit on the double field; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/arcgis-field-data-types.htm

I would work with technical support on this.

Can you create a field in Pro (outside of the view) that has the precision you need?

Re: Pro not respecting database field scale settings

RhettZufelt — Wed, 25 Jan 2023 19:28:32 GMT

I set up a field in SQL with the same setting (numeric(38, 10)) and see the same thing in Pro.

However, in Fields, you can set the number format and decimal places. Setting to 10 Decimal Places will show you 10, unless there are zeros, then it will drop them and only show up to 10 places with value.

If you need 10 places regardless of the zeros on the end, use the pad with zeros option.

Re: Pro not respecting database field scale settings

ZorbaConlen1 — Wed, 25 Jan 2023 19:48:53 GMT

Hi Rhett,

I found that setting but it does not solve my issue. It appears to be a display setting and is ignored when I publish the map service.

Thanks for the suggestion.

Re: Pro not respecting database field scale settings

ZorbaConlen1 — Wed, 25 Jan 2023 19:50:23 GMT

Thanks George. In reading the docs, I'm not seeing it explicitly stated that there is a limit on scale.

I think you are right, it will probably require help from esri support.