AutoCAD Map 3D General Discussion

Reply
Contributor
JJuniewich
Posts: 12
Registered: ‎10-08-2007
Message 11 of 14 (253 Views)

Re: SQL Server Spatial - Geometry Types

11-11-2013 09:06 AM in reply to: Barry_Wheeler

In the style editor uncheck show in Layer List

Contributor
Barry_Wheeler
Posts: 21
Registered: ‎05-02-2011
Message 12 of 14 (238 Views)

Re: SQL Server Spatial - Geometry Types

11-13-2013 06:21 AM in reply to: AlbertKalman5692

Albert,

When we had the SDE running and when we added a geometry type that was say, a line, ONLY a line datatype would appear in the Task Pane window. The exact same data is loaded on to the SQL Server Spatial database and we get all three (2 are invalid) data types showing in the Task Pane. Our ArcGis users get only the proper data type once they load the same data without having to set a schema. The underlying question is why?

(The suggestion of doing a bulk copy is not practical as we get data updates very often which means we would have to bulk copy those to stay current. Further, why would we want to spend twice as much time administering two databases when the CAD and GIS users can share one?)

Contributor
Barry_Wheeler
Posts: 21
Registered: ‎05-02-2011
Message 13 of 14 (237 Views)

Re: SQL Server Spatial - Geometry Types

11-13-2013 06:27 AM in reply to: Murph

We in the CAD group do not export data to create our server database. We get the overwhelming majority of our shared (between GIS and CAD) data from outside (vendor) sources. We had this same data on a SDE database connection that we used to be able to access (before Civil 2013). Now, when we access the SQL Server Spatial database we get the three data types. In other words we didn't have to set up schemas on the SDE (or even burden ourselves with a bulk copy) and why is it we can't get the single data type as the ArcGis users do? They don't 'bulk copy' the data from the server either in the SDE or SQl Server servers. Why should we?

Contributor
AlbertKalman5692
Posts: 23
Registered: ‎03-18-2009
Message 14 of 14 (230 Views)

Re: SQL Server Spatial - Geometry Types

11-13-2013 07:11 AM in reply to: Barry_Wheeler
Feature classes stored using the Microsoft geometry or geography type in a SQL Server DBMS

 

 

Beginning with ArcGIS 9.3, geodatabases stored in a SQL Server 2008 database can use the Microsoft geometry or geography storage types for feature storage. Feature classes that use one of these storage types also have a business table, as described in the previous section. However, for this storage type, the business table contains a column of type GEOMETRY or GEOGRAPHY, in which the feature class geometry is stored; there is no associated feature table.

 

 

Feature class tables that use geometry or geography storage also have associated system tables plus associated views. Click the following link to see a diagram of a feature class that uses the Microsoft geometry or geography storage type.

  

 

In the diagram, the feature class business table, buildings, is linked to the system tables by way of the table name
 
You have in SDE schema definition for features, therefore ArcGIS user can see only one feature class type.
If you connect with Map Spatial connection to MS SQL Server the map 'can't read" this schema structure from SDE, therefore Map ignore it and show you all three  types.
 
Did you try use ARCSDE or ARCGIS provider ? Is available for 2013 version of map but as I know 'Read only'.
 
As I understand that GIS user works with ArcGIS and CAD user works Map(or Civil) and for CAD user is forbidden to modify data? Is need only to read the data from SDE ?
 
Albert

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community