|
POST
|
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
10-10-2014
12:25 PM
|
0
|
0
|
1881
|
|
POST
|
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
10-10-2014
12:14 PM
|
0
|
1
|
1881
|
|
POST
|
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
10-09-2014
08:45 AM
|
4
|
3
|
1881
|
|
POST
|
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
06-17-2014
10:58 AM
|
0
|
0
|
2225
|
|
POST
|
+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
04-30-2014
06:12 AM
|
0
|
0
|
4622
|
|
POST
|
Hello: Is there a method in the Attribute Assistant to populate the intersecting features on opposing sides of a line? If a line splits polygons A and B, I'd like an attribute from polygon A to go into the road's 'left' attribute and an attribute from polygon B into the road's 'right' attribute. Thanks, Nate
... View more
04-04-2014
09:55 AM
|
0
|
1
|
737
|
|
POST
|
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
03-13-2014
07:21 AM
|
0
|
0
|
1589
|
|
POST
|
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
03-11-2014
11:22 AM
|
0
|
0
|
3116
|
|
POST
|
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
03-11-2014
11:02 AM
|
0
|
0
|
3116
|
|
POST
|
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
03-11-2014
07:26 AM
|
1
|
0
|
3116
|
|
POST
|
Paul, Thanks for posting your solution - I needed pip and poster, which required setuptools. Your workaround helped me get everything working. Nate
... View more
11-14-2013
08:24 AM
|
1
|
0
|
1336
|
|
POST
|
Hi: Is it possible to use your own address locator service with Maps for Office (from an AGO organizational account or local Portal)? Nate
... View more
09-05-2013
07:23 AM
|
0
|
1
|
759
|
|
POST
|
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
05-07-2013
04:39 AM
|
0
|
0
|
1277
|
|
POST
|
Hello: I'd like to understand why ESRI requires the Image extension when serving map services that contain a mosaic dataset. Mosaic datasets work in all levels of ArcGIS for Destkop without an extension, so why is it required for Server? After some testing, we found that the performance of mosaic datasets blew away raster datasets stored in our SDE gdb. So, I've been steadily converting them all over to mosaic datasets. So far all our usage has been via Desktop, but this morning I went to change one of our map services so the mosaic and... cue the sad trombone. 😞 I can understand why the extension would be required for serving the mosaic dataset directly, but why for a map service)? Thanks, Nate
... View more
05-06-2013
09:36 AM
|
0
|
4
|
3298
|