topic Re: Spatial view Problem in Geodatabase Questions

Spatial view Problem

HaniDraidi — Mon, 21 Dec 2015 11:29:57 GMT

I’ve created a spatial view in SQL Server 2014 in an enterprise geodatabase. When viewing this view in ArcMap, it acts as if it is in a non-spatial database (However, the database is enabled as enterprise geodatabase).

When adding this view to the dataframe, it asks about the ObjectID field, despite the fact that this filed is already available.

Moreover, all the enterprise management tools are greyed out (register as versioned, add global IDs,…..)

What might be the issue here?

This is better elaborated with the screenshots below,

Any help is highly appreciated

Best Regards,

Hani

Re: Spatial view Problem

NeilAyres — Mon, 21 Dec 2015 12:43:10 GMT

I think you should show us the columns in the spatial view. Is the geometry set up properly?

Re: Spatial view Problem

AsrujitSengupta — Mon, 21 Dec 2015 13:07:31 GMT

This is an expected behavior. I think you should read\research a bit more on this. There is a lot of discussions and Threads out there discussing this same thing.

To explain in brief....Starting from ArcGIS 10.1, Database Views can be created using ArcGIS Desktop, which like normal Views created from Database end, are not 'Registered with Geodatabase' or 'Registered with SDE'. This is why ArcGIS requests you to choose the Unique Identifier when you add the View to ArcMap. Instead if you create the View with SDE Command line tools, it automatically registers the View with ArcSDE and doesn't request you to choose the Unique Identifier.

The other scenario, where other than Analyze and Privileges, all other options are greyed out, that is expected as well. You cannot register a Database View as Versioned or do the other stuff listed under Manage. Have a look at the Online Links for more info.

Re: Spatial view Problem

VinceAngelo — Mon, 21 Dec 2015 14:59:51 GMT

Best practice is to create the view with SQL tools (or the Create Database View GP tool), then register the layer with ArcSDE via 'sdelayer -o register'.

'sdetable -o create_view' is only really intended for SDEBINARY storage geometry tables (where database-originated views are hampered by the Fn/Sn tables).

Views cannot have SDE-set rowids, and therefore cannot participate in geodatabase functionality (simple feature class only -- no "Register with Geodatabase")

- V

Re: Spatial view Problem

HaniDraidi — Mon, 21 Dec 2015 20:28:10 GMT

Hi Vince,

May you please elaborate how I can "register the layer with ArcSDE via 'sdelayer -o register'"; I am not able to find a tool in Arctoolbox that performs this. Should this be done in ArcMap, or in SQL Server?

Best,

Re: Spatial view Problem

AsrujitSengupta — Mon, 21 Dec 2015 20:39:19 GMT

There is no tool to do this from ArcGIS Desktop. 'sdelayer -o register' is a part of the SDE Command line toolset.

ArcSDE Administration Command Reference

sdelayer

Re: Spatial view Problem

HaniDraidi — Mon, 21 Dec 2015 21:12:11 GMT

Dear Asrujit,

I am using ArcMap 10.3.1, and seems that the SDE command line is deprecated in this version; if so, what is the equivalent solution?

BTW, may you please provide me with some of the resources you mentioned above,

Best,

Hani

Re: Spatial view Problem

AsrujitSengupta — Mon, 21 Dec 2015 21:30:18 GMT

You can use SDE Command line 10.2.2 for now.

44300 - Can ArcSDE command line tools be used against 10.3 and newer geodatabases?

Otherwise, you can wait for the following Enhancement request to add this functionality:

ENH-000086635 : Add functionality to register database views with the geodatabase

Re: Spatial view Problem

HaniDraidi — Tue, 22 Dec 2015 10:15:47 GMT

Dear all,

I am still strugeling with registering this spatial view with the geodatabase. My main question is: How can I do this in ArcMap 10.3, if this is not possible at ArcMap level, how can I do it in SQL Server? May you please elaborate with steps due to my shallow experience with SQL Server and the SQL programming language itself?

Thank you in Advance,

Best Regards,

Hani

Re: Spatial view Problem

AsrujitSengupta — Tue, 22 Dec 2015 13:56:51 GMT

You cannot do that using ArcGIS Deskop or using SQL Server. You will HAVE to you SDE Command line tools. Check the links I provided.

Re: Spatial view Problem

HaniDraidi — Sun, 17 Jan 2016 15:43:55 GMT

Hi Asrujit,

Still NOT able to run the commands above, I removed the 10.3.1 version, installed 10.2.2 version and the ArcSDE 10.2.2 Command Line Tools. However, the commands are still not recognized by CMD as shown below.

Are there any additional steps that I should do after finishing the installation?

Thanks in Advance,

Hani

Re: Spatial view Problem

JoshuaBixby — Sun, 17 Jan 2016 17:55:14 GMT

The error message you see implies one of two things: 1) you don't have the ArcSDE Command Line Tools installed, or 2) the ArcSDE Command Line Tools are installed but the system or user path was not updated to include the directory with the ArcSDE Command Line binaries. Since you installed the tools, it seems you just have a path problem. Since the current working directory is always in the user's path, I suggest navigating to the directory containing the binaries and try executing them from there. If it works, you know what the issue is, and you can just add that directory to the system or user path.

Re: Spatial view Problem

VinceAngelo — Sun, 12 Dec 2021 08:39:07 GMT

That error can also sometimes mean that the needed .Net Framework and/or C++ runtime libraries are not installed. But adding the install directory to the path is a good start.

Since a Direct Connect is required, it will also be necessary to set the SDEHOME environment variable to the install directory.

Using batch scripts is the easiest way to get there:

set SDEHOME=D:\Esri\arc102admin64-rel2\arcsde
set PATH=%SDEHOME%\bin;%PATH%

set SDEUSER=tableowner
set SDEINSTANCE=sde:sqlserver:servername
set SDEDATABASE=databasename

sdelayer -o register -l viewname,geomcolumn -e na+ -t GEOMETRY -R srid_of_base_table -C objectid,USER

Do NOT use 'sdetable -o create_view' -- ALWAYS define the view with SQL (or the Toolbox tool), then register it afterwards with 'sdelayer -o register'. Be sure to use a sensible name ("V" does not qualify, though "somedescriptivename_v" would).

Note: It's still possible that a 10.2.2 client will not be able to connect to SQL-Server 2014.

- V

Re: Spatial view Problem

HaniDraidi — Sun, 24 Jan 2016 12:50:01 GMT

Many Thanks Vince!

It worked Finally!

May you please help me in registering a non-spatial views and tables?

Re: Spatial view Problem

DanMcCoy — Mon, 31 Oct 2016 16:39:35 GMT

"Coming at the 10.5 release the ‘Register with Geodattabase’ tool will be enhanced with additional parameters and allows database views as acceptable input datasets."

https://community.esri.com/ideas/8897#comment-42312

Re: Spatial view Problem

RandyKreuziger — Mon, 12 Dec 2016 23:50:11 GMT

I hope the "Register with Geodatabase" tool fixes most of the problem ESRI created. I just encountered one with ObjectID that is going to require that I come up with a work around to keep many of my current scripts running!

In some databases we only have access to the spatial views and not the original data. I need to create copies of these geodatasets in other geodatabases both SDE (aka Enterprise) geodatabase and a file geodatabases. However, when copying a spatial view from one SDE database to another the spatial view created a physical feature class or just find. But with database views at 10.4.1, the ObjectID in the view is not recognized so an additional ObjectID_1 field is created! The schemas no long match and that breaks my workflow further downstream...

Re: Spatial view Problem

Asrujit_SenGupta — Tue, 13 Dec 2016 06:02:23 GMT

Randy Can you please post this as a separate Question.

Also post a bit more info, like:

1. Did you "Register with Geodatabase' that View

2. Which ArcGIS Desktop version did you use to copy the View

3. Does Copy\Paste, Import\Export...all show the same result?

4. The configuration details that you have (SQL Server version, gdb version, etc)

This should help others to test and share their observations as well.