Latest Contributions by NateArnold

Amir, I can't find any additional information on this.  Would you please explain where to find this option? [Edit: I'm using 10.3.1] ... View more

Hannah, I've been through the articles on how to create an AGS service for ArcPad.  They suggest using exploded format, but don't specify an image storage type.  The default is MIXED, which will create both PNG (blank or partially so) tiles and JPEG (content tiles).  I added the service to ArcPad to make sure the NMF and L00-L03 folders were created, then took the map service offline.  I then copied all the tiles from the map service's cache folder into the NMF file's cache location.  The cache does indeed work offline, but it looks like it's turning everything into PNG files with world files and a projection xml.  In this screenshot, the JPG files are what was copied from the AGS service's cache directory, and the PNG, PGW, and xml files were created by ArcPad when viewing the layer: Is this the way it's supposed to function, or is there some ArcPad setting I need to change?  If it's the intended behavior, this will more than double the cache's size when using it. ... View more

I can't see ArcGIS Pro replacing ArcCatalog ever so long as you need to save a project when first opening Pro.  Who wants to do that just to run some GP tools and manage data?? ... View more

Chet, From my perspective, situations where a view needs to be registered with the gdb are: When you need to maintain metadata on the view When performance is critical  (credit Trevor Hart‌) When you don't want to explain to users why they're being prompted for unique ID and spatial extent Which is every time, really ... View more

Chet Dobbins‌ Vince Angelo‌ John Baleja‌ It's interesting the lengths people are going to in order to try to replace gdb registered spatial views.  Isn't it clear by now that this is functionality that's relied upon in your product?  As David Gifford‌ said (hoping you'd come to the rescue at the 11th hour ), please tell us you're planning spatial view improvements at 10.3.1.  If not, what more can this community do to tell you it's a priority for us? ... View more

A bit late, but I don't believe AlterField_management supports views - the input parameter is a Table View.  The input parameter for MakeTableView_management (which would go into AlterField_management) is a table or feature class - view is not specified.  Did you contact Support with this issue?  I'd be curious to hear if they had a workaround - it seems reasonable that since the alias of a field in a registered spatial view can be altered in ArcCatalog GUI, then it ought to be possible with GP (if not then it should be!). ... View more

Vince Angelo‌ Now that 10.3 Pre-release is out, can you clarify what the better solution is? ... View more

I'll add to this thread that in May of 2013, I submitted an incident which got tagged onto NIM085579, which is currently listed as Open and Assigned.  This bug was created TWO YEARS AGO and it has still not been fixed.  The analysts found that yes, a view created with CreateDatabaseView_management against a feature class using geometry storage (which is the default now) in SQL Server 2012 is indeed slower than command line spatial views against feature classes using sdebinary storage.  The analyst I was working with at the time said (c/p from an email):           So the slower drawing time seen in the view created with SQL is expected.  Please let me know if you have any questions about this. Please, ESRI, don't be surprised when users like Joshua Bixby‌, me, and everyone else in this thread get frustrated on the subject of spatial views, when "it's slower now by design" is the type of response we get from Tech Support.  Add to that command line tools going away, and what are we to do???  Please, please, please share the suggested workflow for making spatial views at 10.2+.  And don't say saving a .lyr file is part of the solution. ... View more

Melissa Jarman‌ I do not believe that database views were intentionally allowed to register with the geodatabase. It seems that there is somewhat of a loop hole that allows for this if the view is created with the SDE commandline tools or registered with the commandline (sdelayer -o register) first and then register with geodatabase is available in the client UI. What!?!  This is the workflow that Vince Angelo‌ said, is it not?  I always define my views with SQL, then register with 'sdelayer -o register'... That's what I'm trying to do - define the view in SSMS (or using CreateDatabaseView_management - they both give the same error in the end), then register the view with the geodatabase.  Vince, if that's not what you meant, please elaborate because I don't understand.  What is your intention or need for the database view to be registered with the geodatabase? I want to create a view in the database for which (1) users do not have to get bothered by a prompt for unique ID field or SR, and (2) geodatabase metadata can be modified.  Both of these were true of spatial views created with ArcSDE command line - if the capability exists at 10.2.x then I'm not aware of it - please share!! The administration reference you are sharing states 'table' and not view. I did find a reference in the 10.0 help regarding registering views with the geodatabase. I pulled the quote from the admincmdref directly from the document that gets installed with the ArcSDE command line tools 10.2.2 installer at %installdir%\ArcSDE\Documentation\Admin_Cmd_Refs\Support_files\admincmdref.htm.  If this is indeed a loophole, then it's still there at the current release.  Look in Data management commands --> sdelayer: Yes, it does say 'table' in this documentation, but if using this command is not exactly what Vince Angelo said to do, then I'm terribly confused. ... View more

Vince, the admincmdref documentation for 'sdelayer -o register' states: You can use the Register with Geodatabase command from the context menu of the table or the Register with Geodatabase geoprocessing tool to register a spatial table with both ArcSDE and the geodatabase. I've got feature class A stored in SQL Server with geometry storage, and table B.  I created a view (ABView) in SSMS that joins the table to the feature class.  The view includes A.Shape.  I'm using Desktop 10.2.2 against SDE 10.2(.0).  First, the Register with Geodatabase context menu item is disabled for this view.  Second, when I run RetisterWithGeodatabase_management against ABView I receive: ERROR 001399: Views are not supported. The command line help documentation does not seem to be correct, at least for views created in SQL.  The bigger issue is that (like you suggested) I am able to use 'sdelayer -o register' to register the view with the geodatabase.  So how are you going to be able to register views at 10.3+?  Has the behavior for RetisterWithGeodatabase_management changed at 10.3? ... View more

We've encountered similar circumstances with complex objects like topologies and geometric networks.  Once a delete or rename fails, the only way to clear the layer out of the table registry is sdetable -o delete.  If the table is not found, you're prompted to continue to remove metadata about the table (which removes the entry from the sde table registry if possible):      If not for command line, how are we to remove orphaned table registry items?  Does Delete_management have a similar table registry removal function?  ... View more

Hi Melissa: Thank you for your response.  I hadn't used the schemalockingenabled configuration for services and will definitely look into it.  However, the comment made by Tom Weisenberger was that command line sde doesn't care about map service locks in order to drop a spatial index. Does RemoveSpatialIndex_management need an exclusive lock or can it proceed with clients using the target layer? ... View more

This is a great thread, but also very troubling.  The most recent info we have from ESRI is: We're deprecating command line at 10.2 Vince Angelo says to register a sql view you need 2 steps - create the view then register it with soon-to-be-deprecated command line Drop the spatial index first in order to equate command line load_only.  Oh, by the way, this won't work when map services have locks on the data. We might have the ability to import/export dbtune past 10.2 I have to say that ESRI has been most unhelpful in providing info on what's coming up at 10.3 - just look at the number of threads there are on this topic!!  Your users rely on the type of spatial views that command line provided, and there is no combination of GP tools that allow you to create an "sde-registered" view.  Anyone who says using query layers in place of spatial views is an option seriously needs to go through this dialog when adding 30+ views to an mxd - you'll understand our pain: It's a joke that ESRI marked this idea as "implemented":  ArcGIS Idea - Create SDE spatial view from ArcGIS Desktop Please ESRI let us know what you have upcoming for 10.3 so we can plan accordingly. ... View more

Your frustrations will grow when you go to publish a mosaic dataset using AGS, only to find that the Image extension is required. ... View more