Latest Contributions by JakeSkinner

Here is an example on how you can do this: Codeblock: def update(field):   if field[0] in str(range(0, 9)) or field[0] == '#':     pass   else:     return field Field= update(!TAG!) Be sure 'Python' is checked on at the top of the field calculator.  Here is a screen shot. [ATTACH=CONFIG]16236[/ATTACH] ... View more

Are the text and integer values separated by a space?  You can most likely use the .split command to do this.  However, this will be a little more difficult if any of the river names contain spaces.  Are all the integer values the same length (i.e. 100, 220, 354, etc)?  It may be best to provide a screen shot of how the field looks in your attribute table. ... View more

Hi Cameron, Yes, that is a fair assessment.  The 10.1 help also provides examples on how you can create a python script to update your database statistics.  Updating database statistics can be an I/O-intensive operation, so you  might want to do this while most users are logged out of the database.  Having Windows Task Scheduler execute a script is the perfect solution for this. ... View more

Can you attach a screen shot of your Tool Validator tab, and a screen shot of your Parameters tab?  Also, are you working with Tables or Feature Classes? ... View more

Hi Karsten, Here is an example on how you can do this by updating the updateParameters function: def updateParameters(self):     if self.params[0].value:       list = []       mxd = arcpy.mapping.MapDocument("CURRENT")       df = arcpy.mapping.ListDataFrames(mxd)[0]       for layer in arcpy.mapping.ListLayers(mxd, "", df):         list.append(layer.name)       list.remove(str(self.params[0].value))       stringFilter = self.params[1].filter       stringFilter.list = list     return For the multivalue parameter, you will want to set the Data Type to 'String' within the Parameters tab. ... View more

Is the NULL value within the feature class's numeric field, or the database table's numeric field?  You can have NULL values within a feature class's numeric field as long as 'ALLOW NULL VALUES' is set to YES. ... View more

Hi Jamie, Take a look at the following tutorial on Publishing Geoprocessing Services. ... View more

Are any ArcGIS Server services accessing data within the File Geodatabase you are trying to delete?  This will cause a lock and prevent you from deleting the geodatabase. Could replication replace the copying of feature classes to a new File Geodatabase?  You could then perform a synchronization rather than a copy/paste of feature classes. ... View more

Hi Mike, Are you running ArcGIS 10.1, yet?  ArcGIS 10.1 added a new data access module (arcpy.da).  The previously existing cursors (that are still listed under arcpy) are still functional and valid; however, the new arcpy.da cursors include significantly faster performance.  I tested the new arcpy.da.UpdateCursor vs the older updateCursor and CalculateField_management.  The new arcpy.da.UpdateCursor provided faster performance than the other two.  For the error you are receiving, I would recommend incorporating print statements within your script and print each feature class you are updating.  That way you can pinpoint the problematic feature class when the error occurs.  The OBJECTID reported in the pop-up will tell you the specific feature within the feature class. ... View more

Try adding arcpy.RefreshTOC() and arcpy.RefreshActiveView to your script.  Ex: mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] arcpy.mapping.MoveLayer(df, "Contours 10m - MARANOA REGIONAL", "SPOT 2009 Image Date", "BEFORE") arcpy.RefreshTOC() arcpy.RefreshActiveView() mxd.save() del mxd Also, are you executing the python script within ArcMap? ... View more

Here is an example on how to create an XY event layer from your SQL table and then reproject the coordinates from decimal degrees to feet: import arcpy from arcpy import env env.workspace = r"Database Connections\PUBS.sde" table = "pubs.dbo.XY" arcpy.MakeXYEventLayer_management(table, "X", "Y", "XY_layer", r"C:\data\test.gdb\Airports_WGS84") rows = arcpy.SearchCursor("XY_layer", "", r"C:\data\test.gdb\Airports_NAD83_feet") for row in rows:     print row.shape.centroid.X, row.shape.centroid.Y del row, rows The XY event layer is created with the same coordinate system as the Airports_WGS84 feature class.  In this case it is geographic.  Then, the XY coordinates are returned based off of a NAD83_feet coordinate system using the SearchCursor function and printed out. If you are looking to update the SQL table with these values, SDE will need to be installed and the table will need to be registered with the geodatabse.  You can then use the 'UpdateCursor' to update new fields. ... View more

Is your SQL database spatially enabled (SDE installed)?  Or was the table created within SQL Server, and the database is not spatially enabled? ... View more