Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenCities Map
  • Product Communities
  • Geospatial
  • OpenCities Map
  • Cancel
OpenCities Map
OpenCities Map Wiki - Creating a Map schema for spatial features
    • 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
        • -Spatial Databases
          • - 3D arcs being stroked when posted and queried
          • - Angle of queried point feature is wrong
          • - Conflict Inspector
          • - Convert DGNs with MSLinks to MS SQL Server Spatial via FME
          • - Create domain lists in Microsoft SQL Server Spatial or Oracle
          • - Create XFM DGN file using Import from database
          • - Creating a Map schema for spatial features
          • - Creating Oracle Spatial multi-table views
          • - Creating Oracle Spatial Views
          • - Data streaming
          • - Data streaming and the Data Browser
          • - Date field settings for use with PBA in SQL Server
          • - Determine which features are locked and modified
          • - Difference between Erase and Delete for removing spatial database features
          • - Disable Connect to Database dialog
          • - Esri File Geodatabase as a Graphical Source
          • - Establish database connection upon startup
          • - Item names showing __x00##__
          • - Keep connection to database open when changing files
          • - Key-ins for interacting with spatial databases
          • - Key-ins to created queries incorporating a simple WHERE
          • - Long transactions - Versioned optimistic transactions
          • - Non planar polygon posting error ORA-54505
          • - Oracle views in spatial feature definitions
          • - Plane Constraint settings
          • - Register features times out with error
          • - Saving connection parameters to settings file
          • - SQL Server Features Not Displaying in Bentley Map
          • - Supported OGC geometry types
          • - Using joins to create custom searches
          • - WFS graphical source connection and feature registration
          • - Connecting to ArcGIS Server
        • +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. 

    - Creating a Map schema for spatial features

    The following is a brief description of how to create a maps schema and register spatial features.

    Start the Geospatial Administrator and select File > New.  Give your project a Name and press OK.  The Project Information dialog is populated with the Project Name, Description and Configuration Root Directory.

    Navigate to the Graphical Sources node and right-click the appropriate connection type.  Choose Add > New and the Build Connection dialog opens.

    Fill in the correct connection information and click Test.  The connection should be successful.

    Press OK to dismiss the test result dialog.

    Right-click the newly created graphical source connection and choose Register Features.  Fill in the password if needed, or check Use Windows Integrated Authentication.

    Click OK. The Register Features dialog opens. Select the features to register. The features presented in the list are those that are discovered as being spatial features in the database.  Each feature will be defined as a table with the appropriate columns that describe feature properties. Click Next.

    Specify the feature type if needed and click Next.  Note:  Oracle spatial tables include a geometry type, SQL Server and PostGIS do not. 

    In the Feature Names page, edit XFM feature and property names if needed.  Click Next.

    In the Point Geometry Rotation and Scale page, define the columns used to store point rotation and scale. These database columns are optional. Click Next.

    In the Point Geometry Text page, define the appropriate text expressions.  Text expressions are optional text values that are stored as properties and are stored as annotation tables. Click Next.

    In the ID Generators page, assign unique identifiers to the features. 

    In the Domain Registration page, select the relationships to be imported as list domains.  Click Next.

    Confirm the feature registration.  Click Finish.  The selected features are registered and added the  All Users > Features node.

    Registered features will show as being registered in the Feature Definition:

    Edit the feature symbology as desired.

    Insert the feature placement metadata by right-clicking on the feature and choosing Insert > Place xxxx 

    Update the Command Manager by selecting User Interface > Command Manager.  Then right-click and choose Add Command Manager List.

    Create a User Workset by choosing Add User Workset from the User Worksets node.

    Save the map schema.

    Export the map schema.

    Test the schema and workset by choosing Run from the new workset node.

    Open a file.  The graphical source will be available to connect to via the Map Connections dialog.

    Finally, test the registered spatial features by performing a query, lock, modify and post.

    • Share
    • History
    • More
    • Cancel
    • Inga Morozoff Created by Bentley Colleague Inga Morozoff
    • When: Fri, Nov 1 2019 4:02 PM
    • Inga Morozoff Last revision by Bentley Colleague Inga Morozoff
    • When: Mon, Nov 18 2019 1:39 PM
    • Revisions: 5
    • 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