Latest Contributions by NateArnold

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

+1 on this 🙂 Referencing data already on our web server would be great, since we're not using AGO for data hosting.  We already have our own open data catalog in place, but it lacks the multiple format download options of open data.  I'm actually working on a rolling 180 day crime export right now (csv with lat/long), and it would be great to upload this to our web server and have it published to open data.  I imagine for others direct upload of csv (with an associated tool/arcpy element) to hosted AGO would be useful, plus as you mentioned upload from ESRI Maps for Office. Nate ... View more

The 'sdelayer -o register' command is used to register tables or views in native storage (or ST_GEOMETRY, where available) with ArcSDE Thanks for that.  Bummer more command line. Nate ... View more

Also, one other problem we had when coming from 9.3 to 10.1 was that we changed from the default LONGRAW storage in Oracle to Geometry in SQL Server.  Changing data sources in our AGS mxd's to the new gdb resulted in problems with the shape area and length fields.  ArcMap did not properly interpret the change in fields, and the publisher/analyzer did not catch the problem, which resulted in AGS map service errors.  I'm not sure if any of the newer builds have caught this though.  Nate ... View more

They certainly can be registered with an enterprise geodatabase, if you a) have an enterprise geodatabase, and b) choose to do so. Please explain how to do this.  I've created a view using CreateDatabaseView_management, in a SQL Server gdb, using an owner account, on a feature class owned by that account.  After creating the view, right-click context menu --> Regsiter with geodatabase is greyed out.  When I run RegisterWithGeodatabase_management against it, I receive ERROR 001399: Views are not supported. Query Layers are a way of accessing spatial databases without ArcSDE.. This is an interesting point.  True, CreateDatabaseView_management can be used for non-spatial table views too, but if it's used against feature classes that are already in ArcSDE, I think the tooling should be able to take advantage of registering the view instead of leaving it as a query layer. It's not just spatial views, it's all tables which involve GEOMETRY/GEOGRAPHY objects, but these are an aspect of Microsoft's database implementation (and the difficulty of tuning it), not anything Esri has control over. That's fine, just as an FYI to the original poster.  We found for best performance with our data, load datasets into ArcSDE with the SDEBINARY keyword, then build the registered spatial view with command line tools.  Of course, you should try it with one of the other storage types and compare 🙂 Nate ... View more

Vince, From an end user perspective, I think ESRI has done a terrible job of clarifying differences between spatial views and query layers:  When you use SSMS to make a "view that includes a spatial column", why would it not be interpreted as a "spatial view" (confusion in terms)?  When the CreateDatabaseView_management tool was introduced, why would an end user not think "I can use this tool to make a spatial view", when it actually gets interpreted in ArcGIS as a query layer?  Why can views created using SSMS or CreateDatabaseView_management not be registered with the GDB (and hence store feature type, extents, description/metadata, etc.)? ArcGIS 10.1+ has seen much of the command line tools become GP/GUI tasks, but creating actual spatial views is one are where ESRI needs to focus.  Since there is indeed a speed difference between spatial views and query layers, but views are much easier to manage using SSMS, our approach has been to make a "dummy" spatial view using command line, then modify the view definition in SSMS.  We've also seen a speed difference between spatial views built on feature classes stored in the default Geometry spatial type (slower) versus SDEBINARY (faster).  Nate ... View more

Paul, Thanks for posting your solution - I needed pip and poster, which required setuptools.  Your workaround helped me get everything working. Nate ... View more

Hi Jeff: Thanks for the response.  The help link you provided is specifically for publishing Image services, which I am not doing.  I'm trying to publish a map service based on an mxd that has a mosaic dataset in it.  This is the point of my question - why is the extension required for map services? ... View more