New answers tagged

0

The line if layer.supports("DATASOURCE") should get your passed any group layers - I don't have issues with group layers running the code below import arcpy, os workspace = r"D:\temp\SE\updatePath" # Change to match your MXD folder path datapath = r"Database Connections\GISDatabase.sde" # Change to match your new SDE connection path for dirpath, dirnames, ...


0

According to http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-mapping/layer-class.htm There are two ways of determining if a layer is a group layer. First, you can check to see if the layer supports the isGroupLayer property. Second, you can evaluate the longNameproperty. A layer's longName value will include the group name in addition to the layer ...


0

I can think of 3 approaches using ArcObjects or ArcPy. Use a class extension to to check edits made in an edit session against the values in the parent version and reset the value or cancel the edit if a difference is found. You can also use a custom form to replace the editor window in ArcMap. This method isn't foolproof since editors can still edit the ...


0

Well - how about just creating the table using the standard Oracle tools. For example sqlplus (the command line) using the proper CREATE TABLE syntax ? You obviously have that since you run Oracle. And as Vince pointed out there are no such things as "geodatabase tables" and "database tables". There are only database tables. A "geodatabase" is just an ESRI ...


0

We resolved this issue by killing the locks in SDE_state_locks table. Restarting the sdeArc service on the server killed 7/10 of the locks. The remaining 3 had the SDE_state_locks.direct_connection set to Y, the other 7 were N. I don't know what that means. So then I dropped all the tempdb tables associated to these 3 remaining locks, restarted the sdeArc ...


2

I didn't find a pre-built tool to do this, but ended up using the following code which was easy enough to then query the dictionary to pass to arcpy.ChangePrivileges_management() import arcpy def retrieve_permissions(db, fc): sdeDBConn = arcpy.ArcSDESQLExecute(db) permissionsQuery = """SELECT permission_name, state, pr.name FROM sys....


1

GEODB reader, Excel reader, featuremerger (objectid), VertexCreator (replace point), GEODB writer (update, objectid). The SDE writer can create new tables but also, insert rows and update rows. I'm by no means an SDE export but I think OBJECTID is the unique ID created by SDE. This way only the rows that are merged with excel will get a new coordinate and ...


1

While I believe the error is correct and you shouldn't be able to enable archiving on an individual Feature Class (FC) within a Feature Dataset (FD), you can get around this in three ways (that I've tested so far). I'll outline what should be happening, and also what I found in my testing. Everything in a FD is done as a group (the entire dataset) - ...


0

I was facing same issue while working on the utility network database. It happens when two user modify the same feature attribute/geometry in two different ways. Try reconciling the version only after refreshing parent database .


3

From @Hornbydd's link above, the key section would be Attribute index names which says: In ArcSDE: Must be unique in the database Must start with a letter Cannot contain spaces Cannot contain reserved words but in File Geodatabases: There are no restrictions on how you can name an attribute index in a file geodatabase.


0

As Vince suggested, the query needed to return ST_Geometry, not ST_Point: SELECT OBJECTID, SDE.ST_GEOMETRY (SDE.ST_ASTEXT (SDE.ST_STARTPOINT (SHAPE)),300049) AS START_POINT FROM ENG.ROAD This SQL does not work for multi part lines. If you need to work with multi-part lines, my guess is you'll have to figure something out with the line string ...


0

Too bad you aren't using creating replicas from a feature service, then you could just use the REST API to unregister (pretty easy call with Python). I don't have an arcpy solution for you as I don't think it is available there yet. I do have a Python comtypes ArcObjects solution that works though. I am using a modified version of the Snippets module. ...


3

You need to install the SQL Server Native Client so that your client machine (your PC) can talk to SQL Server. To connect to a database or geodatabase in SQL Server from ArcGIS for Desktop, install the SQL Server native client on the ArcGIS for Desktop computer and create a connection file in the Catalog tree See Connect to SQL Server from ArcGIS ...



Top 50 recent answers are included