Latest Contributions by AlanToms

I'll go with the append. Don't! Going the Python route (reading the join tables(s) into a dictionary using a search cursor and then updating the main table via an update cursor is by far the fastest method. This is true in v10.0 and below, but is especially true in v10.1+ using ethe data access cursors. In addition to faster processing, this method is far more flexible in that allows for all sorts of error handeling and whatnot through conditional expressions. For example, say you want to get the fields "ADDRESS" and "CITY" into the main table (key field being "NAME"): #UNTESTED! lutTbl = r"C:\temp\test.gdb\lookuptable" mainTbl = "r"C:\temp\test.gdb\maintable" lutDict= dict([(r[0], (r[1], r[2])) for r in arcpy.da.SearchCursor(lutTbl, ["NAME","ADDRESS","CITY")]) arcpy.AddField_managment(mainTbl, "ADDRESS", "TEXT", "", "", "75") arcpy.AddField_managment(mainTbl, "CITY", "TEXT", "", "", "30") updateRows = arcpy.da.UpdateCursor(mainTbl, ["NAME","ADDRESS","CITY"]) for updateRow in updateRows:     nameValue = updateRow[0]     if nameValue in lutDict:         updateRow[1] = lutDict[nameValue][1]  #Address         updateRow[2] = lutDict[nameValue][2]  #City     else:        print "Could not locate address/city info for " + str(nameValue)     updateRows.updateRow(updateRow) del updateRow, updateRows I went ahead and went down this path as it will work better for me in the long run.  I have to figure out how to "easily" include updates from additional tables.  The only hiccup was something with the index.  I'm novice with python so it may be something I should know. Instead of updateRow[1] = lutDict[nameValue][1] I had to use row[1] = PADataDict[PKValue][0]   It was almost like once it got into the if statement the index 0 was the first value, not the key.  Thank you for the help. Alan ... View more

Assuming the join fields are indexed on all of the tables, option 1 blew away cursors under the pre-da version cursors.  Have not tested the da version cursors.  However, even ArcObjects cursors perform slower than joins, so I doubt Option 2 would work faster even with a da cursor.  Hitting tables with repeated queries is much slower than a join, which does just one correlation of the tables, because each new query has to reset the table read, as far as I know.  Main reason to not use joins would be if there was a 1:M or M:M relationship to traverse. That's kind of what I figured; just needed some one else to back me up. 😄  I'll go with the append. Thank you Alan ... View more

Can someone tell me what the Contour Index is supposed to represent?  It is either 0 or 1 and how topo lines are symbolized in the template.  Thanks, Patricia The index contour is there to help certain elevations stand out so it is easier to read.  For example, I have 1ft contour feature class.  Any contour with an elevation divisible by 5 I have as my index contour.  As far as symbology, just make them a little bit different so they stand out; thicker lines, different dash lengths. Alan ... View more

Are you in an edit session and you can edit both layers when you run the tools? Yes I have been in an edit session and verified I could edit when I attempted to run the tool.  The tool still does fails when selecting the abandoned features on the enterprise database. ... View more

I do have a few additional fields in the wMain feature class that are not part of the local gov schema, but I don't think that is the issue because the tool works when it outputs to the file geodatabase.  /shrug ... View more

Alan,    Are both the water layers and the abandon layers editable? Yes, I can edit the feature classes. ... View more

Is this what you are looking for? http://www.arcgis.com/home/item.html?id=aedc78ca0be54a3b9bf4789aadb84f1d Yes it is thank you.  For some reason I was unable to find it. Alan ... View more

Yeah it took me a bit to get it as well.  The ArcSDE Command Line tools do not need to be installed unless you want to run stuff with a command line or need to do some major troubleshoot.  Hi, I'm trying to wrap my head around this, as I setup my test server for our upgrade. I have set up my server with Windows Server 2008 R2 sp1 and SQL Server 2012 standard edition. I have installed ArcGIS desktop 10.1 + sp1 I ran through the ArcGIS for Server 10.1 sp1 installer but did not create a ArcGIS Server site. (essentially I needed the authorization file for the create enterprise geodatabase tool ) I then ran the tool > 'Create Enterprise Geodatabase' I loaded some data into the geodatabase, registered as versioned. When exploring the schema all the SDE and GDB tables are present. Am I missing something? Do I need to install ArcSDE 10.1 to get the multi user/versioning/history capabilties of ArcSDE, or as this discussion indicates this is now inherent in the desktop. I still am not 100% clear why I would need to install the ArcSDE application server or command line tools. If I am managing data via desktop (ArcMap & ArcCatalog) I do not need to install anything further If I am managing data via web editing tools I do need to install the ArcSDE application server. Thank you for any clarification you can provide. Fiona ... View more