topic Re: SQL Error Shape.STContains is not allowed in Geodatabase Questions

SQL Error Shape.STContains is not allowed

DionO_Reilly — Thu, 15 Sep 2016 18:07:56 GMT

I am trying to create a SQL view to count the number of point features in a polygon. The following code works when run in a SQL Query, however when I try to create a view using the code I get "Shape.STContains is not allowed, and the column name dbo could not be found or is ambiguous"

SELECT POLYGON.NAME, Count(*)
from Point JOIN
POLYGON
On POLYGON.Shape.STContains(POINT.SHAPE) = 1
GROUP BY POLYGON.NAME

Any assistance would be appreciated.

Re: SQL Error Shape.STContains is not allowed

JoshuaBixby — Thu, 15 Sep 2016 18:26:47 GMT

It is always helpful to provide information on DBMS platform and version, and ArcGIS products and versions, if applicable.

Re: SQL Error Shape.STContains is not allowed

DionO_Reilly — Thu, 15 Sep 2016 19:37:54 GMT

SQL Server 2014 and Arcgis server 10.3.1

Re: SQL Error Shape.STContains is not allowed

JoshuaBixby — Thu, 15 Sep 2016 20:45:58 GMT

Are you trying to create the view from ArcCatalog or from within another database client, like SQL Server Management Studio? If the former, have you tried it from a different database client, a non-Esri one?

Re: SQL Error Shape.STContains is not allowed

DionO_Reilly — Fri, 16 Sep 2016 01:52:36 GMT

Creating in SQL management studio. It displays correct results in SQL query but when try to make the view it throws that error

Re: SQL Error Shape.STContains is not allowed

MartinRowe1 — Tue, 14 Mar 2017 16:06:32 GMT

Please tell me you managed to solve this one?

Then immediately thereafter tell me how you did it.

Have reinstalled servers and .net systems and this one has baffled me.

Thanks hugely in advance

Martin

Re: SQL Error Shape.STContains is not allowed

MartinRowe1 — Sun, 19 Mar 2017 10:23:21 GMT

down vote accept

YAAYYYYYYY. Got it.

It seems that the STContains function won't operate with a DBO schema in front of the field name.

If you add the database name to the query it works. Should look like this.

USE MyDatabase

Select dbo.PointTab.*, dbo.PolyTab.Name from dbo.PointTab

Inner Join dbo.PolyTab

On PolyTab.GeometryCol.STContains(dbo.PointTab.GeometryCol) = 1