Ability to create a spatial view inside of ArcMap in the Geodatabase Admin Toolbox

[TedCronin]

Ability to create a spatial view inside of ArcMap in the Geodatabase Admin Toolbox, post 10.1.  There is some fantastic functionality in GDB at 10.1, but not the ability to create actual spatial views.  These are still done via cmd line.  I can create database views, I can create query layers, I want to be able to create spatial views similiar and as easy as creating database views in ArcMap at 10.1.

[JeffSchenck1]

And can you please allow more than one spatial view per feature class?

[JohnFell]

Our workflows rely heavily on the sdetable -o create_view command. As Riverside has pointed out, we cannot create spatial views using ArcMap 10.1 without the sde command line tools. Even with the help of an ESRI tech support analyst we were not able to create a spatial view without the sde command line tools. According to the deprecation plan for ArcGIS 10.2 (on page 3 of 8):

"ArcGIS 10.2 will be the last major release to include the ArcSDE command line tools. Esri 

encourages use of the new Geodatabase Administration dialog box in ArcCatalog and 

ArcMap and the related geoprocessing tools that were introduced at 10.1"

If users cannot create spatial views using ArcGIS 10.2 suite of tools then what is esri's plan to provide another set of tools to do this?

[MelissaJarman]

There is a create database view tool that you can use and incorporate the spatial column within.  10.1 and 10.2 have this tool - the only gotcha is that because this tool is simply creating a database view it is not using the same logic that the sdetable -o create_view tool was for older geometry storage formats like SDELOB and SDEBINARY (where the feature geometry is stored in a separate table). This means that you won't be able to create a spatial view with this tool unless you have a geometry storage format that stores the feature geometry on the base attribute table (like SQL Server Geometry, ST_Geometry, SDO_GEOMETRY, etc.)

The following commandline enhancement has been logged for this:
NIM096539  SDETABLE: Create geoprocessing tools or arcpy functions for operations performed when using the 'sdetable' command.

Create database view - 10.2
http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000177000000

[TrevorHart1]

The Create View tool is useful but like the other comments state all it does is create a database view. If I drag/drop or add the view through the "Add Data" tool I have to specify the unique identifier each time. This is rather annoying for desktoip users. Can the unique identifier be stored in the GDB as part of the view creation?

[TrevorHart1]

I blogged about the problem http://gdbgeek.wordpress.com/2014/01/14/spatial-views-in-10-110-2/ 

[DanMcCoy]

Yes, unfortunately, the views created with Desktop (Catalog, ArcMap, Toolbox) are not registered with SDE and you must use the command line in order to make them appear as a feature class to avoid having to specifiy the OBJECTID every time you add them to ArcMap...
http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/datamgmt/sdelayer.htm#registerex

Please vote for this idea as well:

Create Views In ArcCatalog Like In SDE Command Line
https://community.esri.com/ideas/8897

[DanMcCoy]

Sounds like some new functionality at 10.5 should help with this...

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

[ShannonShields]

The Create Database View geoprocessing tool lets you create a view in a geodatabase, and the Register with Geodatabase geoprocessing tool supports the registration of views with the geodatabase.