Latest Contributions by RussellBrennan

Yes, if it is required that you must use Windows authentication and are not able to grant DBO privileges to your geodatabase administrators then that method will work. If your requirement for Windows authentication is flexible, a slightly easier option is to use mixed mode authentication with an SDE schema that uses database authentication and have all users other than SDE use Windows authentication. ... View more

Jerry, You created a DBO schema geodatabase instead of an SDE schema geodatabase. The main difference between these two options is it determines who is the geodatabase administrator. If you are working with a DBO schema geodatabase you do not need to use mixed authentication as the DBO user is likely authenticated through windows. The DBO user will be able to perform all of the geodatabase administrative tasks that the SDE user would perform in an SDE schema geodatabase. When using the DBO schema geodatabase there is no need create an SDE user. Unless you want to use database authentication there is no need to enable mixed mode authentication. Here are some links to some helpful documentation: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_comparison_of_geodatabase_owners_in_SQL_Server/002q00000004000000/ http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/The_ArcSDE_administrative_account_in_SQL_Server/002q0000002n000000/ ... View more

Hi Gismoe, This python script should work to set the permissions appropriately. Just swap out the path to your server connection info, FDS name and username. # Purpose: Change user privileges on a dataset # Create the Geoprocessor object import arcgisscripting gp = arcgisscripting.create(9.3) try:     # Set the name of the feature dataset, feature class, or table to change privileges on.     objName = 'ADMIN.FDS'     # Set the name of the user or role to grant privileges to.     username= 'FC_EDIT'     # Process: Update user privileges     gp.ChangePrivileges("Database Connections/Connection to Server.sde/" + objName, username, "GRANT", "GRANT") except:     # If an error occurred while running a tool, print the messages     print gp.GetMessages() Hope this helps, Russell ... View more

Holly, What exactly are you trying to do with the shapefiles before loading them into the Geodatabase? There are a number of methods available through Python for loading data into the geodatabase but I would like to know more about your workflow before offering suggestions. Also, what version of ArcGIS Desktop are you using? What version of ArcSDE are you using? What DBMS is ArcSDE running on? ... View more

The behavior that you are describing is as the software was designed. There are a number of workflows where we have to be careful to avoid getting the database into an inconsistent state. Granting privileges in cases where there are schema locks will not cause harm. However there are cases where revoking privileges could cause inconsistency and therefore we prevent revoke when there are schema locks.       In the next release of the software we are working on making it easier to identify these locks and where they are coming from. This should make it much easier to avoid this type of locking issue. ... View more

We upgraded our file geodatabases from 9.3 to 10.0.  Suffice to say, all of our geodatabases which used relationship classes no longer have the relationship classes.  Additionally, all feature classes in their original feature datasets now appear in the geodatabase as stand-alone tables and the feature datasets are empty.  Many of our raster catalogs are no longer functional.... This is not something that we have seen before. Do you have a database that you could attach to this thread that we could take a look at? If so can you look to see if the upgrade log is available for that geodatabase? The upgrade messages are written to a log file, GDBUpgrade<n>.log, which is created in your system TEMP directory. ... View more

Hi Dan, Please contact Esri support so that we can determine what is causing this and get a bug logged if needed. ... View more

Chris, Here is some code that will find and print the centroid of a polygon using a Search Cursor. import arcpy polygonfc = 'c:\temp\fgdb.gdb\studyarea' rows = arcpy.SearchCursor(polygonfc)     for row in rows:     feat = row.getValue('SHAPE')     centroid = feat.centroid     print centroid You could then use the centroid values to create points. Here are some links that you may find useful: Working with geometry in Python: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z0000001s000000.htm Accessing data using cursors: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z0000001q000000.htm Insert Cursor: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v00000038000000.htm ... View more

Ralph, One other thing to double check is to ensure that the SDE connection file that you are using on the server is using exactly the same connection properties as the one you are using on the client machine. ... View more

Ted, I worked with Kevin from the GP team on this and we were able to  determine that this is only happening when you run this from a script.  If you step through the commands it will work fine. There is definitely a  bug here and we are trying to figure out the cause and another  workaround besides stepping through it. I can't make any promises but I  am hoping we will get this fixed for SP1. Kevin will be taking the lead on this so I am going to go ahead and close out this thread. You can continue to discuss this in the GP forum. Kevin hopes to have a NIM number for your reference shortly. ... View more

Steph, If you still have the source data that you used to build the TIN you can use this to build a new terrain. If you only have the TIN you can 'deconstruct' it back to features using the TinNode tool to get the point data, the TinLine tool to extract breaklines, and the TinDomain tool if a clip polygon was used. Russell ... View more

Hi Steph, It is not possible to create TIN's in a geodatabase. Terrains are the recommended option for storing this type of data in a geodatabase. The likely reason that the option to create a terrain is grayed out is because you have not turned on the extension. Here are instructions for enabling the extension: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/About_enabling_3D_Analyst/00q8000000rr000000/ESRI_SECTION1_DAAA53CB77F04F86BE2CC8D8F5AE58B2/ Here is a link to some documentation on terrains: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005v00000002000000.htm ... View more

Nathan, You mentioned that you were able to connect to the data and edit it in ArcMap. Are you using the same SDE connection file to make the connection for editing as  you are to run the geoprocessing tool? Everything seems to be pointing to permissions missing somewhere. I would recommend double checking the connection files that you are using and referencing this document: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n0000002v000000.htm ... View more

Dart, The delete features tool should work on unversioned data. Try double checking that that the correct user is specified in the connection properties of the connection file. You could also try testing while connected as the owner of the data. What version are you working with for both catalog and your geodatabase? What RDBMS are you using? ... View more

Hi Wesley, There is a geoprocessing tool called 'append' that will do exactly what you are looking for. You can find this tool in Toolbox under Data Management tools > General. ... View more