Latest Contributions by BlakeTerhune

You can start the enumeration at 1 so you don't have to add one when you return i. Pyhton enumerate() python - How to enumerate a range of numbers starting at 1 - Stack Overflow  for i, l in enumerate(f, 1):‍ ... View more

After working with Esri support, the solution was to add our internal server to the AGOL organization's Trusted Servers using the fully qualified url. Then also use the same fully qualified REST url when adding a layer from the web on that server. ... View more

We're on Oracle 11g and 10.2.2 and have always been able to disconnect everyone either using ArcCatalog administration or arcpy.DisconnectUser(). Not sure if you noticed but when you're in the Connections tab of geodatabase administration, you can Ctrl+A all connections and right click to disconnect all (although you have to Ctrl+click to deselect your own connection). You can also do this when viewing the Locks tab and disconnect everyone with locks on a particular feature class. ... View more

Hi Kelly, thanks for the reply. In attempting to make this available publicly, I found that if I used a different ArcGIS Server, I was unable to reproduce the issue. So I went back to my development server and further discovered that using a REST URL for the service through the web adaptor (with integrated AD authentication) would not work but the direct url (with port 6080) did work. I did finally open a case with Esri support but feel free to reply with any ideas you might have. ... View more

That's a strategy you'll have to discuss with your users and decide on. Every organization is a little different. This document might be helpful as a starting place for you. Using Python scripting to batch reconcile and post versions—ArcGIS Help | ArcGIS for Desktop  You don't necessarily need to delete the version, just make sure it is reconciled and posted. Deleting the version is the way to be absolutely sure everything is compressed. ... View more

Delete Version—Help | ArcGIS for Desktop  ... View more

You should start a new thread for your question. Be sure to include the information about what versions you have, what feature class you are looking at, and the owners of everything. ... View more

You should be running compress as SDE. ... View more

The best way to get a full compress is to disconnect all users, reconcile and post all versions, then run the compress. If that's not feasible, just reconcile all versions and disconnect any user with a lock on the feature class you are trying to get compressed, then run compress. ... View more

You really do have to be the owner of the table to run these tools. The SDE user can only run it on SDE tables. As for why you are seeing differences, I'm assuming it's because you're looking at a versioned feature class that has had edits made but the database hasn't been compressed. What Toad sees is only the base table but ArcGIS sees the combination of the base table and the delta tables (A and D tables with adds and deletes). Check the SDE.TABLE_REGISTRY to get the owner and registration_id of the feature class: select * from sde.table_registry where table_name = 'YOUR_FC_NAME';‍‍ Then use those values to look at the delta tables: select * from OWNER.Aregid; select * from OWNER.Dregid;‍‍‍‍‍‍ My guess is that you'll see the changes somewhere in the A or D table of the feature class. You can check the row count of SDE.STATES table. There is only one row if your database has a full compress. There will be a single row for each version you have. Anything extra represents changes that have been made but not compressed into the base table. If you run compress, you can check the SDE.COMPRESS_LOG table to see the result of the compress operation. ... View more

One note on the dataSource property of a layer I've found while doing this: Not all layers support the dataSource property (for example, annotation classes and web services), so it is good practice to test for this ahead of time using the supports method. if lyr.supports("DATASOURCE"):‍     print "Map: {} Layer: {} Data Source: {} Broken?:{}".format(mxd,lyr,lyr.dataSource, lyr.isBroken)‍‍ ... View more

You'd probably be better off using an integer sequence of your own allocation or a base-36 string sequence (AAAA-9999 stores 1679616 discrete values in 4 human-readable bytes). Hopefully I'm not derailing this thread too much, but do you have an example of how you would configure the trigger to insert the sequence value into the (versioned) table? We are doing something similar and have issues with sequence values occasionally getting skipped or not changed. We're on 10.2.2 in Oracle 11g. ... View more