Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenCities Map
  • Product Communities
  • Geospatial
  • OpenCities Map
  • Cancel
OpenCities Map
OpenCities Map Wiki - Number  properties and setting decimal places for data entry
    • Sign In
    • -OpenCities Map Wiki
      • -OpenCities Map
        • - End of Support for Bentley Map V8i (SELECTseries) products
        • +Release Information
        • +Installation Information
        • +Getting Started
        • +Administration
        • +General Topics
        • -Geospatial Administrator
          • - About Expand Variables
          • - Automatically execute commands upon file open [XFM project]
          • - Automatically connect to a graphical source
          • - Base Source Directory and Files Node
          • - Base Source Directory configuration
          • - Built in XFM properties
          • - Capture point feature coordinates with two examples
          • - Change property order using text editor
          • - Changing project and workset information
          • - Concatenate properties to populate new property using Property Watcher
          • - Create a geospatial schema
          • - Create a new schema recommended workflow
          • - Customize Command Manager with help from Excel
          • - Customize dialogs
          • - Customize Operations to show property based on criteria
          • - Date Time Property Show None to set dates to null
          • - Decimal Precision in Analyze XFM Feature Results
          • - Defining polygons with holes or islands
          • - Domain list initial values
          • - Domain list width (Calculate List Width)
          • - Domain list width (Form View width)
          • - Feature Collection and Collection Name Property
          • - Files node in User Workspace
          • - Fix Cannot access a disposed object error
          • - Generate workspace from command line
          • - Increment property values
          • - Multiline text for PBA
          • - Number  properties and setting decimal places for data entry
          • - Open schema via desktop shortcut
          • - Property Watcher on an empty value
          • - Property Watcher to compute values
          • - Property Watcher to read Col2 of a Domain List
          • - Property Watcher to set true or false
          • - Property Watcher to update a date property
          • - Property Watchers to drive domain lists
          • - Replace text during Shapefile importing
          • - Replace text in cells using PBA with two examples
          • - Rounding numbers
          • - Set Area and Perimeter to Read Only
          • - Shortcut arguments –ws , -wr, -wu
          • - Shortcut Target path
          • - Sort properties by Display Name
          • - Store Last Value to define property fields for new feature placement
          • - Tabbed dialogs
          • - Text and Text Node Justification
          • - Text Annotation Subfeature
          • - Text features from PBA
          • - Text size settings
          • - Update property when Split/Merge used
          • - UpdatedBy and UpdatedDate properties
          • - Using raster images as a graphical source
          • - Value Col Name vs Edit Col Name
          • - Workspace location V8i compared to CONNECT Edition
        • +Feature Definitions and Inference Rules
        • +Interoperability
        • +Spatial Databases
        • +Spatial Analysis
        • +3D Geospatial
        • +Geographic Coordinate Systems
        • +Troubleshooting
        • +Freeware - Utilities - Applications - Programs
        • +Advanced Map Finishing
      • OpenCities Map Ultimate for Finland CONNECT Edition x64 (SES)
      • OpenCities Map Ultimate for Finland CONNECT Edition - Suomi
      • Bentley Descartes
      • +Other Geospatial Products

     
     Questions about this article, topic, or product? Click here. 

    - Number  properties and setting decimal places for data entry

    Consider this, you just installed OpenCities Map and created a Schema using the Geospatial Administrator.  You Run your Workspace, Place a new Feature and enter 123.45 or 123.45678 as an attribute property.  You Post the Feature then Query it to see the results - the decimal precision isn't anything like you entered it!  Your client's data modeling requirements have strict definitions - how can you resolve this?

    Display Format changes are needed for OpenCities Map to support the validation of the number of decimal places for Number-based properties.

    The suggested workaround is to change the Display Format in OpenCities Geospatial Administrator from the default value of %s to %w.

    This causes the property field to only accept numbers as defined by the working units of the design file.

    Therefore, if the design file has its working unit accuracy defined as 0.12, the property field will only accept two decimal places:

    When entering values exceeding the accuracy setting, automatic rounding will take place:

    For Spatial database users:

    Many feature settings cannot be modified directly in OpenCities Geospatial Administrator and will appear to be greyed out. To edit these values, simply open the XML in any robust text editor, look for your feature definition and manually edit the textbox formatToDisplay tag.

    For example:

    <textBox formatToDisplay="%f" formatToInternal="%s" />

     to

     <textBox formatToDisplay="%w" formatToInternal="%s" />

     

     For more information on the valid display types, please refer to the following section in the OpenCities Map Help document:

    https://docs.bentley.com/LiveContent/content/en/Bentley%20Map%20Help-v2/GUID-613C3CDA-B665-BBFA-D3DF-696133CE98C0

    • OpenCities Map
    • Geospatial Administrator (GSA)
    • Decimal
    • Share
    • History
    • More
    • Cancel
    • Inga Morozoff Created by Bentley Colleague Inga Morozoff
    • When: Tue, Nov 21 2017 11:53 AM
    • Nelson Hobdell Last revision by Bentley Colleague Nelson Hobdell
    • When: Tue, Jan 3 2023 6:49 PM
    • Revisions: 6
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies