topic Re: st_geometry function in SQL Server in Data Management Questions

st_geometry function in SQL Server

ErikEngstrom — Mon, 23 May 2011 19:09:40 GMT

Does this exist?
When referencing st_geometry in SQL Server I'm getting an

Invalid object name 'sde.st_geometry'.

I noticed in documentation that this is SQL syntax, but is the st_geometry only an Oracle command?
Does something similar exist in SQL Server?

I have a function I'm trying to build in silverlight to take my graphics layer and publish the geometry to a feature class and the way I thought I might be able to do this is to create a stored procedure in SQL Server to insert a record into the feature class table. The only way I've found to insert the geometry into the record is to use the st_geometry function... However it doesn't seem to be working.

Re: st_geometry function in SQL Server

KimPeter — Mon, 23 May 2011 19:32:27 GMT

Hi Erik,

The SQL Server spatial types are geometry and geography, and they were written by Microsoft. You'd need to check the Microsoft documentation for information on inserting geometry to a SQL Server spatial type.

http://msdn.microsoft.com/en-us/library/bb933876.aspx

Hope this helps.

-Kim

Re: st_geometry function in SQL Server

VinceAngelo — Mon, 23 May 2011 20:20:33 GMT

It's not Oracle-specific. Esri has a ST_GEOMETRY type implementation for all supported
database platforms *except* MS SQL-Server (the others support 'blade' creation).

Microsoft's GEOMETRY/GEOGRAPHY operators are case-sensitive, so be sure to match
case as you follow the documentation.

- V

Re: st_geometry function in SQL Server

ErikEngstrom — Tue, 24 May 2011 10:43:40 GMT

Thank you both, I will look into both the Geography and Geometry data types.
-Erik

Re: st_geometry function in SQL Server

ErikEngstrom — Tue, 24 May 2011 12:07:10 GMT

Looks like a data type specific to SQL Server 2008. We are currently on 2005.
I may be out of luck...

Re: st_geometry function in SQL Server

VinceAngelo — Tue, 24 May 2011 12:25:03 GMT

Yes, GEOMETRY and GEOGRAPHY were introduced at SQL-Server 2008.

You can still whip up a web service to do inserts using the 'C' or Java ArcSDE APIs, but this
will not be as simple.

- V

Re: st_geometry function in SQL Server

AleksanGhojoyan — Mon, 19 Dec 2011 20:19:10 GMT

As i understand there is no way to use ST_GEOMETRY type in MS SQL Server, right? In this case, is there ability to convert, some how, records of ST_GEOMETRY from db created by SDE to SQL server geometry type. I want to use this data in MS SQL Reporting Service to show Map in report.

Another question:
There is functions like: ST_Area, ST_ExteriorRing, ST_NumInteriorRing, ST_Centroid, ST_PointOnSurface ...
Is it possible somehow use them in MS SQL SERVER ?

Re: st_geometry function in SQL Server

VinceAngelo — Mon, 19 Dec 2011 21:13:39 GMT

Correct, there is no ST_GEOMETRY for SQL-Server. You can use Well-Known Text as a transfer
mechanism to Microsoft's native Geometry type. The capabilities of Geometry are documented
both online and in the SQL-Server documentation.

- V

Re: st_geometry function in SQL Server

HaniuHokkaido — Tue, 08 May 2012 07:05:36 GMT

Dear all,

I have never found the reason WHY ST_GEOMETRY IS NOT SUPPORTED in Ms SQL Server ?

Any reasons why..?

*curious*

Thanks