nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I store two significance digits in GDB feature table?

XingboChen

I created a GDB line feature to store rivers and I wanted to add a field "LEN" to store river length which need to keep two significance digits. So I try to add a double field, but there was no precision and scale properties to set like add field in a shapefile.

I know how to display two significance digits by right click on the field, click properties and using number format, what I need to know is store two significance digits in attribute table. If anyone knows the solution, please help me, thanks!

QQ截图20150625234414.jpg

Find more posts tagged with

Accepted answers

All comments

WesMiller

Did you try float ? see this thread

JayantaPoddar

Hi Xingbo,

The field precision and scale are ignored while adding a field in Personal/File GDB table. You need to do it from Field properties, as you mentioned.

RichardFairhurst

You can set up Attribute Assistant to preform a rounding calculation on the field during an editing session as soon as the user posts their edit, if you set up the DynamicValue table to do that and include that table in you map project. The DynamicValue table can be set up to trigger field updates in response to feature creation, attribute changes, geometry updates or manual processing. The EXPRESSION value method uses VB Script like the following to update the specified field: Round([LEN], 2)

You can get Attribute Assistant as part of any of the Local Government Information Model component downloads here.

XingboChen

Yes, but there's still no precision and scale properties in float setting.

XingboChen

So there's no way to set precision and scale in Personal/File GDB table, why? Precision and scale are really helpful:(

XingboChen

Thank you sir, what I need is changing "14" into "14.00" in Personal/File GDB table. But I'll try Attribute Assistant in the future.

XingboChen

Thanks a lot, but this won't change the case.

RichardFairhurst

Personal and File GDBs will never be designed to satisfy the strict requirements of a DBA. Microsoft and Esri created them to be their low cost, easy to use databases that are marketed to attract Excel users to convert their data to a database. Ease of use will always trump precision and control for this market.

Also, both have an interest in making Personal/File GDB's unsatisfactory alternatives to users of their very high cost lines of Enterprise database solutions. Precision and control are key to maintaining a distinction in these product lines. Microsoft and Esri are both expert at keeping functionality out of their low cost product line to protect their high end markets. We are fortunate that the masses have as much functionality as we do. So don't hold your breath for this functionality to be added to these low end databases.

XingboChen

Thank you very much again, sir! Now I know what to explain to my boss.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.