Latest Contributions by RussellBrennan

No problem, I am pleased that this worked for you. ... View more

Hi Steve, There is currently no option to create or alter query layers through Python at 9.x or 10. If you have access to the Beta program you can take a look at the "Make Query Layer" tool in 10.1 Beta. ... View more

Dan, Typically this message indicates that Python/ArcPy was not able to connect to the database. Double check that that specific connection file can be used to connect to the database. If you are using 3-tier (application server) connections double check that the service is running. If you are creating the connection file in the script, ensure that you are providing the correct username/password/version. I don't know what you are doing earlier on in your script but I have seen some issues where the workspace gets cached and this prevents the connection from succeeding. Try running ClearWorkspaceCache_management prior to what you have provided and see if that helps. You should be using this syntax: arcpy.ListVersions(ParentConnection) I was able to run your code on my machine and get a list of versions without issue. ... View more

Ted, You can use the following to get a list of domains for a geodatabase: arcpy.Describe(r'Database Connections\admin.sde').domains This will return a python list of domain names. DL = arcpy.Describe(r'Database Connections\admin.sde').domains for domain in DL:     do something... ... View more

Hopefully this helps: http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?topicname=users_and_schemas_on_sql_server_2005 I think that the first sentence in the last paragraph: "That means you must create a schema for each user who will own data, the schema must have the same name as the user, and that schema must be specified as the default schema for the corresponding user." The 10 Help: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_adding_and_administering_users_in_SQL_Server/002q00000028000000/ "When you add users, you also assign them a default schema in the database. If the user is going to own data in the geodatabase, the default schema must have the same name as the user name. If it does not, the user cannot create datasets, copy datasets into the geodatabase, or use geoprocessing tools that result in new datasets." ... View more

This is the structure of our SDE tree: �?� First SDE.Default �?� Second a child version from default called Pre-Production �?� Third an user version child of Pre-Production My advice: First, I would suggest that you do not choose a new name for the third version. Having two versions named Pre-Production seems like a recipe for problems down the road. My goal is to run a script that will perform the following operations: - move all the records that are completed in a feature class to an historical one, - and then remove features  from the  regular feature class that were archived.  The easiest way to do this would be to use archiving. If you enable archiving on your feature class you could reconcile and post your changes to the Default version. When the records are posted to the default version the archiving architecture will store those edits. You could then delete the edits in your edit version. You can then use the Archiving tools available to you in ArcGIS to view the data at specific points in time. It sounds like your workflow is exactly what Archiving was designed to address. In this case you do not need a second feature class to store the historical data. I was able to write a Model Builder that  creates a new child version from Pre-Production, selects records to be archived,  appends them to the historical feature class,  deletes these same records from the regular feature class and then running a reconcile with the option option �??Post Version after Reconcile�?� checked it works propagates all the updates for the child to the parent. But  if I uncheck this option  �??Post Version after Reconcile�?�  in the Reconcile box and I run a POST TO Pre-Produciton I get an error message. If you wish to post your changes I do not understand why you want to use a tool other than the reconcile tool to perform this operation. See my comments below... What does not work is adding a post box after the reconcile in ModelBuilder, it always fails, why? This is the error I got : Error 000533: the version can not be posted to the reconcile version. Reconcile must be performed before the post operation has been done. There are some known bugs with this tool where the reconcile will fail with the error message you are describing. This is the most likely reason you are running not able to get it to complete. I am not entirely sure I understand the exact steps you are going through so I will offer the recommended workflow. It is recommended that if posting changes, the reconcile tool is used to perform the post operation. The post tool is still available for older models or scripts but if you are implementing a new model please use the reconcile tool be used for both functions. ... View more

Jose, This will depend on how your versions were created and their child-parent relationships. The act of reconciling will pull edits from the parent version into the version that you edited (target) version. The act of posting will push the edits that you reconciled in your edit version to the parent version. Like I said, there can be many scenarios that will work for you but it will depend on how the two versions you are interested in are related to each other. -If the version that has the completed edits is a parent of the version you want to copy edits to all you need to do is reconcile the completed edit version with the other version. -If both versions have a common parent, for example sde.DEFAULT, you could reconcile and post the completed edits version with the default version and then reconcile the version you want to copy edits to with the default version. Keep in mind that the reconcile and post operations act on all edits in all versioned data in your geodatabase. If you are looking to just copy edits from one featureclass to another you might want to look at some of our programmatic methods for accessing version changes. Here is a link, look under the section "Data Changes object model" for some idea of how this works. http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#/Overview/0026000000r1000000/ ... View more

Yes I have this issue I have ~7000 sign post pictures of our highway network and a GDB with a signs layer. The unique photo file reference is named in a Photo column in the data but all I have is a file full of photos. I dont want to have to upload each picture to each asset is ther a way of loading the lot into the GDB and then pointing / configuring the software to pull up the correct photo based upon the unique id? Richard, In the next release of ArcGIS we are looking at adding a geoprocessing tool that would give you the ability to use a key field to match a record in your table/feature class with a file stored on disk. For example if you had a feature class containing sign posts with a photoID of 'sign1234' and you had a photo on disk named 'sign1234.jpg' you could attach photos based on this type of relationship. Would these tools be useful with the way your data is currently stored? ... View more

CEI_gis, Individual edits will appear in the base table in three situations: - when the edits are common to all versions (reconciled and posted between all versions) and a compress is executed. - if you are using the option to 'move edits to base' when you register your data as versioned and you save your edits in the Default version. - you use non-versioned editing. My best guess based on your description is that you have edits that are not showing up in all of your versions. This is normal for most geodatabases, unless you are attempting to edit your tables directly with SQL there is likely nothing to worry about. Versioning: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00270000000r000000.htm Here is some doc on deciding how to register as versioned: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Deciding_how_to_register_data/002700000005000000/ Compress doc: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00290000005v000000.htm http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/The_compress_operation_and_geodatabases/00270000001v000000/ If you have further questions it is likely best to contact Esri Technical Support and they can give you more info. Hope this helps, ... View more

I believe that the problem you are encountering is because of this line in your script: DB__VERSION_DBO_DEFAULT___2_ = "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\DB.mdf" In your script you are specifying the SQL Server data file for your geodatabase. This will not work in ArcGIS. When specifying the output geodatabase you need to use the database server connection or the database connection to your geodatabase usually this will be something like this: Database Server: r'Database Servers\RUSSELL_SQLEXPRESS.gds\QADatabase (VERSION:DBO.DEFAULT)' Database Connection: r'Database Connections\production.sde' ... View more

You could also take a look at the 'Cut Fill' tool. This tool sounds like it is what you are looking for. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//009z000000tz000000.htm http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/How_Cut_Fill_works/009z000000vt000000/ ... View more

If you are working with integer rasters to create the contours this KB article might be helpful: http://resources.arcgis.com/content/kbase?fa=articleShow&d=30845 ... View more

Yes, you already have a connection. The connection files that you use to access your enterprise geodatabase through ArcMap/ArcCatalog/ArcGlobe etc. are the same files that you use to access your data through Python. These are the connections you create through ArcGIS Desktop when you go to 'Database Connections' > 'Add Database Connection'. When you are working in ArcGIS Desktop you can think of these connection files as being the same as a file or personal geodatabase. You double click to view the contents and drag and drop contents from these connections into tools or into your map. The only difference is that the SDE Geodatabase has added functionality for managing permissions and editing transactions (more menu options). In Python this is the same story, you reference an existing SDE connection file the same way you reference a file or personal geodatabase 'connection'. You can think of the 'createArcSDEConnectionFile' tool as something on par with the 'create file geodatabase' or 'create personal geodatabase' tools. You only need to use these tools if your 'connection' (aka file or personal geodatabase or sde connection file) does not already. However if you have database connections or existing file or personal geodatabases you do not need to create them in every script that you write. I do not know why this is not working. I will need some more information to assist in answering that. - What is the Python code you are using? - What DBMS are you using (Oracle, SQL Server, PostGres, DB2, Informix) - What error messages are you getting? ... View more

You do not need to create the connection file in Python. If you already have a connection file you can reference the existing file. Here is an example of adding a layer. mxd = arcpy.mapping.MapDocument('CURRENT') df = arcpy.mapping.ListDataFrames(mxd)[0] addlayer = arcpy.mapping.Layer(r'Database Connections\Connection to database.sde\pythonDBO.GDB.houses') arcpy.mapping.AddLayer(df, addlayer,"AUTO_ARRANGE") ... View more

Working with SDE data should be the same as working with any other data. The path to the data can be slightly different but the behavior of the data should be the same. Take a look at this topic: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002t0000000v000000.htm ... View more