Hi dear,
I am using SQL server 2008R2, but I am not sure I am using geometry or binary ... would anyone tell how I can find that?
Thanks Jake.
Is there any recommendation by ESRI to use one "preferable" than the other one?
- 1 person found this helpful
Hi Yasser
The default is always the recommendation. In this case it is geometry.
There are significant differences between Geography and Geometry spatial types in SQL, and I'd by no means accept the "default" without determining what storage format best fits your data needs. Without going down the rabbit hole of this is better than that, check out Spatial Data Types Overview for a detailed description of both. It boils down to your choice of coordinate system and desired precision of measurements. Personally, I'm a fan of geography....
- 3 people found this helpful
You can also look at the table from Management Studio. If the database reports the geometry column as an integer, then it's using SDEBINARY geometry storage.
- V
- 3 people found this helpful
Otherwise the DataType for the column will be geometry or geography for SQL Server spatial types.
You can check this from the table designer
or
select DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where COLUMN_name = 'shape' AND TABLE_NAME = 'YOUR_TABLE'
Thank you all.
Hi Yasser,
You can create/import a feature class, then right-click on the feature class > Properties. The geometry type will be listed under the General tab.