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 - Import coordinate and property information from an XLS or CSV file
    • 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. 

    - Import coordinate and property information from an XLS or CSV file

    Create a design file and attach a geographic coordinate system. This ensures that the imported graphics will be drawn in the correct space.

    In this example the Excel file contains location and property information for wells:

    ID, BOOK, OPERATOR, STATUS, X_SURF, L_SURF, ELEVATION, TD, FIELD, LEASENAME, LEASENUM and COMPDATE.

    Save the Excel file to the CSV format. In this example, the file is named Wells.csv.

    Create a new text file named "Well Import.vrt" and copy/paste the following lines of text:

    <OGRVRTDataSource>
      <OGRVRTLayer name="well">
        <SrcDataSource>well.csv</SrcDataSource>
        <SrcLayer>Well</SrcLayer>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>wgs84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="x_surf" y="y_surf"/>
      </OGRVRTLayer>
    </OGRVRTDataSource>
    

    In Bentley Map, choose File > Import > GIS Data Types and select the VRT file created above.

    Adjust the Feature Parameters, Feature Symbology and Cell Symbology as desired.

    When done, right click and choose Import.

    The graphics are imported into the open design file and are automatically converted to Bentley Map features with properties.

     

    Additional Information:

    The following VRT templates can be used to create custom VRT files based on linestrings, polygons and points.

    Edit the layer name, data source, and x/y columns as needed.

    Linestrings:

    <OGRVRTDataSource>
      <OGRVRTLayer name="Linestrings">
        <SrcDataSource relativeToVRT="1">linestrings.csv</SrcDataSource>
        <GeometryType> wkbLineString</GeometryType>
        <LayerSRS> WGS84</LayerSRS>
        <GeometryField encoding="WKT" field="WKT"/>
      </OGRVRTLayer>
    </OGRVRTDataSource>

     

    Polygons:

    <OGRVRTDataSource>
      <OGRVRTLayer name="Polygons">
        <SrcDataSource relativeToVRT="1">polygons.csv</SrcDataSource>
        <GeometryType> wkbPolygon</GeometryType>
        <LayerSRS> WGS84</LayerSRS>
        <GeometryField encoding="WKT" field="WKT"/>
      </OGRVRTLayer>
    </OGRVRTDataSource>

     

    Points:

    <OGRVRTDataSource>
      <OGRVRTLayer name="Points">
        <SrcDataSource relativeToVRT="1">points.csv</SrcDataSource>
        <GeometryType> wkbPoint</GeometryType>
        <LayerSRS> WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="X" y="Y"/>
      </OGRVRTLayer>
    </OGRVRTDataSource>
    

    Note: The element <LayerSRS> is not required. With this information the features are transformed to the local geographic coordinate system during import.

    A sample dataset for practice is attached for your reference.

    VRTPoints.zip

    • Excel
    • import
    • CSV
    • Interoperability
    • VRT
    • Bentley Map
    • Points
    • Share
    • History
    • More
    • Cancel
    • Anupama Joshi Created by Anupama Joshi
    • When: Tue, Mar 22 2016 3:13 AM
    • Kees van Prooijen [Bentley] Last revision by Bentley Colleague Kees van Prooijen [Bentley]
    • When: Wed, Mar 13 2019 6:02 AM
    • Revisions: 10
    • 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