idea Ability to create a spatial view inside of ArcMap in the Geodatabase Admin Toolbox in Data Management Ideas

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

TedCronin — Wed, 24 Aug 2022 23:24:24 GMT

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.

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

JeffSchenck1 — Wed, 20 Mar 2013 20:50:18 GMT

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

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

JohnFell — Fri, 26 Jul 2013 14:06:08 GMT

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?

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

MelissaJarman — Wed, 20 Nov 2013 13:34:08 GMT

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

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

TrevorHart1 — Tue, 14 Jan 2014 22:52:12 GMT

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?

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

TrevorHart1 — Tue, 14 Jan 2014 22:52:48 GMT

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

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

DanMcCoy — Tue, 22 Jun 2021 08:08:54 GMT

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

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

DanMcCoy — Mon, 31 Oct 2016 16:22:34 GMT

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

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

Re: Ability to create a spatial view inside of ArcMap in the Geodatabase Admin Toolbox - Status changed to: Implemented

ShannonShields — Wed, 24 May 2023 16:50:27 GMT

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.