Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
Geospatial
OpenCities Map
Cancel
OpenCities Map
OpenCities Map Forum
Sign In
All tags
SQL Server
API
Bentley Geospatial Administrator
Bentley Map
Database
DFS
Geospatial Administrator
Interoperability
Oracle
Oracle Spatial
Promote
Register Features
VBA
XFM
XFT
Register Feature from SQL Server table with bit datatype column
asj
I'm in the process of designing a SQL Server database where one of the tables contain a column with the datatype bit. When I try to register the features in the table, Geospatial Administrator doesn't seem to recognize this column. In the end, I want…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] User Data Linkages and Group Hole Elements
Jeff Bielefeld
Bruce, I appreciate the additional sample data. I've been out of the office for the past few days travelling on business but earlier today using the new data I ran the attached promote2.mvba process which created 4 new polygon collection feature instances…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] User Data Linkages and Group Hole Elements
Jeff Bielefeld
Bruce, thank you for that confirmation. If you could send me one more sample design file that contains shapes, complex shapes and grouped holes connecting to at least 3 different MSLINK values then I will complete verification testing of my revised code…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] What happens to User Data Linkages?
Jeff Bielefeld
Bruce, Please zip up and send me via private message... Your modified MVBA file. A sample design file containing the original MicroStation shape elements. A current copy of your Bentley Geospatial Administrator schema file. ...and I will…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] What happens to User Data Linkages?
Jeff Bielefeld
Bruce, The provided MVBA example code demonstrates how one could read the MSLINK value from the graphical element in the promoted polygon collection feature instances and write the value to a business property, which after posting would appear in a…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] What happens to User Data Linkages?
Jeff Bielefeld
Bruce, During the "Promote" process the database linkages should be preserved and remain available on the elements. However database linkage information is not automatically available on the feature instance or inserted into the spatial database during…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] Registered SQL*Server Feature has no Text Sub-Feature
Jeff Bielefeld
Bruce, I contacted one of my colleagues familiar with the "Insert > Polygon Placement Metadata..." process in the Bentley Geospatial Administrator and was able to determine that the "Align" annotation option is not available for polygon collection feature…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] Registered SQL*Server Feature has no Text Sub-Feature
Jeff Bielefeld
Bruce, It sounds as if you may have failed to select or define a "Text Expression" during registration of your point feature. In the following image... ...the "[NAME]" property was selected as the "Text Expression" which should result in... …
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] GSA and Registering Spatial Features
Jeff Bielefeld
Bruce, The documentation appears to be in error. I would recommend that you rename your columns to MS_X_SCALE and MS_Y_SCALE and register your feature class again, verifying that the expected columns are automatically selected and not showing up as…
over 7 years ago
OpenCities Map
OpenCities Map Forum
RE: [BM SS4] GSA and Registering Spatial Features
Jeff Bielefeld
During the "Register Features..." process columns named MS_ANGLE, MS_X_SCALE and MS_Y_SCALE are automatically selected as shown in the following. As Jerry mentions you can use any database column names for angle and rotation but manual selection in…
over 7 years ago
OpenCities Map
OpenCities Map Forum
Geospatial Administrator connect to SQL Server View
Nathan Lawrence
Hi All, I am wondering if it is possible to connect to a MS SQL Server view as a graphical source. I have created the view with an unique clustered index but when attempting to retrieve feature data from it via Graphical Sources> SQL Server Spatial…
Answered
over 9 years ago
OpenCities Map
OpenCities Map Forum
View related content throughout OpenCities Map
More
Cancel