topic Spatial View that Reprojects Esri Geometry to SQL Server Geometry in Data Management Questions

Spatial View that Reprojects Esri Geometry to SQL Server Geometry

JoseSousa — Mon, 08 Apr 2013 00:00:42 GMT

Dear Esri ArcSDE Team,

I have ArcGIS 10.1 and have to use an enterprise geodatabase for storing some layers that require advanced capabilities of the gdb.
I also have to provide a partial view of the data to 3rd party systems.

I was thinking of creating a spatial view but have noticed that the Geometry Column is using Esri format. Is there any command I can use for reprojecting on the fly the esri format into SQL server native geometry type? I was thinking of applying that command on the spatial view. I know it will impact the performance but is much better than starting replicating data across all the different systems.

Any thoughts on this?

Cheers,
Jose

Re: Spatial View that Reprojects Esri Geometry to SQL Server Geometry

VinceAngelo — Mon, 08 Apr 2013 00:28:53 GMT

These are the Esri Forums, not a conduit to Development. Most of the folks who
answer questions are experienced users, and even those with Esri badges aren't
likely to be Development staff.

There is certainly no way to reproject *and* change storage type in one query,
and most certainly not as part of a spatial view. You may certainly migrate
or (better) recreate a layer with a different storage method. Changing the
projection as part of a view would be exceedingly difficult, since there would
be no way to reproject the spatial constraint on query. I urge you to find a
different way to solve this problem.

- V

Re: Spatial View that Reprojects Esri Geometry to SQL Server Geometry

JoseSousa — Mon, 08 Apr 2013 02:06:50 GMT

Hi Vince,

There is no reason for being upset.

From my mind Esri could be using dynamic queries or functions to enable this functionality. Esri already implements other functions so this could be just one more ...

E.g.:
create view dbo.ViewName as select dbo.Function(parameter) from dbo.TableName

The function could have the logic for reprojecting the geometries. I didn't knew there was a technical limitation for this as I haven't actually tested the script to see if that would work for this scenario. That was what I was trying to get from you guys and the reason I have addressed the post to Esri.

This is a very specific question and I needed a response that I could trust.

So I will have to assume considering your response that it is technically impossible to implement this functionality using Spatial Views.
Because a versioned view cannot be used when I am using advanced features of the GDB that means that I will have to be searching for a different solution but that always includes data replication is some extent.

Regards,
Jose

Re: Spatial View that Reprojects Esri Geometry to SQL Server Geometry

VinceAngelo — Mon, 08 Apr 2013 12:40:48 GMT

I'm not upset, just pointing out that your greeting would incline most folks
who saw your post to ignore it. If you want fellow users, post a message
in the User Forums. If you want Esri staff, create a Tech Support incident.
Directing either to the other is confusing.

- V