Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenCities Map
  • Product Communities
  • Geospatial
  • OpenCities Map
  • Cancel
OpenCities Map
OpenCities Map Wiki - Convert numerical properties upon import from Shapefile
    • 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
        • +Feature Definitions and Inference Rules
        • -Interoperability
          • - Add properties to MicroStation elements without a Map project
          • - Add properties to Shapefiles using Map
          • - Apply symbology when importing Esri Shapefiles
          • - Assign attributes when importing Shapefiles
          • - Connect to ESRI File Geodatabase
          • - Convert numerical properties upon import from Shapefile
          • - Create a join between Microsoft Excel and Esri Shapefile data
          • - Create Join to Shapefile to update properties
          • - Export arcs and stroking tolerance
          • - Export textures to CityGML
          • - Export thematic symbology to MicroStation
          • - Export to Esri Shapefile format
          • - Export to Google Earth, polygon issues
          • - Export to Shapefile makes two Shapefiles
          • - Exporting a DGN to shapefile with properties
          • - File Geodatabase and Custom Coordinate Systems
          • - File Geodatabase reports unknown spatial reference
          • - Import coordinate and property information from an XLS or CSV file
          • - Import INSPIRE GML using FME (Video)
          • - Import multiple folders of Shapefiles by using GDI key-ins
          • - Import Oracle data using VRT
          • - Import requirements for geospatial file formats
          • - Import text strings from point SHP properties
          • - Importing 3D shapefiles with elevation
          • - Interoperability key-ins
          • - Key-in to execute import for an IMPX file
          • - Limitations of Esri File Geodatabase support
          • - MXD files
          • - Protecting OpenCities Map Design File data in a MicroStation session
          • - Queries are not undoable
          • - Selecting specific feature properties when importing Shapefiles
          • - Using SharePoint for Cloud storage
          • - VRT file parameters to import Points, Lines, and Polygons
          • - VRT files to import ODBC and CSV data sources
          • Configuring DGN2DB for Access ODBC
        • +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. 

    - Convert numerical properties upon import from Shapefile

    Using the freeware application Sync1, it's possible to convert numerical Shapefile properties upon import.

    In this example, the default import of a sample Shapefile shows the following attributes: block_id, FID (turned off for import), shape_area (sq ft) and shape_len (US ft).  When imported, Bentley Map adds the Geometry_Area (sq m) and Geometry_Perimeter (m) properties. 

    For learning purposes, a new Acres property is added and its value is derived from the existing shape_area property during the import process.  

    To do this, a new feature is created in a geospatial project and properties are added to correspond with those found in the Shapefile.  In addition to those, a new property named Acres is added and the Initial Values for the Editing key is set to: 

    Value Type = cexpression

    Value = [Parcels.Area] * [0.0000229568411]   Where 0.0000229568411 is the conversion factor for square feet to acres.  If your properties represent different units, substitute the correct conversion factor here.

    Without the Sync1 applicaiton, the Editing key is only applied when performing the Bentley Map EDIT FEATURE command.    This also means that MicroStation commands such as MODIFY ELEMENT or MOVE ELEMENT, as well as Maps import routines  do not trigger the Editing initial value key.

    To auto-load Sync1, define MS_GEOINTCMD = MDL LOAD SYNC1 in the workspace Macro node.  This will enable the Editing initial value key to be applied when performing an import or when using MicroStation commands such as MODIFY ELEMENT.  Without Sync1 loaded, only feature changes altered by Bentley Map's EDIT FEATURE COMMAND are invoked.

    During the import process, the shape_area is remapped to Area which will apply the formula above.

    Comparing the imported results to the values of Measure Area confirms that the Editing initial values were applied.  

    A sample XML and files are provided for your learning.

    Import with Sync1.zip

     

    • Geospatial Administrator
    • Freeware
    • Shapefile
    • Share
    • History
    • More
    • Cancel
    • Inga Morozoff Created by Bentley Colleague Inga Morozoff
    • When: Tue, Oct 16 2018 1:27 PM
    • Dan Weston Last revision by Bentley Colleague Dan Weston
    • When: Thu, Apr 8 2021 12:29 PM
    • Revisions: 7
    • 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