Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
Bentley Map | OpenCities Map
  • Product Communities
  • Geospatial
  • Bentley Map | OpenCities Map
  • More
  • Cancel
Bentley Map | OpenCities Map
Bentley Map | OpenCities Map Wiki - Convert numerical properties upon import from SHP
    • Sign in
    • -Bentley Map | OpenCities Map Wiki
      • -OpenCities Map
        • Working from home with OpenCities Map
        • +Release Information
        • +Installation Information
        • +Getting Started
        • +Administration
        • +General Topics
        • +Geospatial Administrator
        • -Interoperability
          • - Add properties to MicroStation elements without a Map project
          • - Add properties to SHP files using Map
          • - Apply symbology when importing Esri Shapefiles
          • - Assign attributes when importing Shapefiles
          • - Connect to ESRI File Geodatabase
          • - Convert numerical properties upon import from SHP
          • - Create a join between Microsoft Excel and Esri Shapefile data
          • - Create join to SHP file 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 Bentley Map design file data in a MicroStation session
          • - Queries are not undoable
          • - Selecting specific feature properties when importing Shapefiles
          • - VRT file parameters to import Points, Lines, and Polygons
          • - VRT files to import ODBC and CSV data sources
        • +Spatial Databases
        • +Spatial Analysis
        • +3D Geospatial
        • +Geographic Coordinate Systems
        • +Troubleshooting
        • +Freeware - Utilities - Applications - Programs
        • +Advanced Map Finishing
        • +Bentley Cadastre
      • Bentley Descartes
      • +Other Geospatial Products
      • +Bentley Map Mobile
      • +Bentley Map Mobile Publisher

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

    - Convert numerical properties upon import from SHP

    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
    • Inga Morozoff Last revision by Bentley Colleague Inga Morozoff
    • When: Fri, Oct 19 2018 10:52 AM
    • 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

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