Latest Contributions by JakeSkinner

The Prerequisite check saves you from starting the upgrade only to have it fail partway through due to one of these prerequisites not having been met.  Unchecking 'Perform Prerequisite check' will attempt to upgrade the database, but since the prerequisite check failed the database upgrade will most likely fail as well.  You can try the following: 1.  If the erroneous feature class is versioned, reconcile and post all versions 2.  Copy the feature class to a File Geodatabase 3.  Delete the feature class from SDE 4.  Execute the Prerequisite check to see if you still receive the same error If you don't receive the error you can go ahead and upgrade the geodatabase and then copy the feature class back into SDE. ... View more

Hi Roy, You'll need to checkout the spatial analyst extension first: arcpy.CheckOutExtension("Spatial") Then you can use 'arcpy.sa.Idw'.  Take a look here for further examples. ... View more

You could do this using the SelectLayerByAttributes function.  Here is an example: import arcpy from arcpy import env env.workspace = r"C:\temp\python\test.gdb" fc = "USNG_100Meter" arcpy.MakeFeatureLayer_management(fc, "USNG_lyr") x = 590 y = 1000 while x <= 740: # alter to the max value of the Easting     arcpy.SelectLayerByAttribute_management("USNG_lyr", "NEW_SELECTION", '"Easting" = ' + str(x) + "AND" + '"Northing" = ' + str(y))     # do something to selection     x += 10     y += 10 ... View more

Does your geometric network contain both Z-enabled and non Z-enabled feature classes?  If so, you are most likely encountering a bug: NIM068617 Editing ArcSDE geometric networks that involve a mix of Z-Enabled and Non Z-Enabled feature classes results in the the following errors: "Modify Feature: An unexpected failure occurred. Shapes of this entity type not allowed in this layer [SHAPE]" The workaround is to create a geometric network in an ArcSDE feature dataset that contains all Z-enabled feature classes or all non Z-enabled feature classes. ... View more

I would recommend executing the Repair Geometry tool on the GISADMIN.SCALE1000 feature class.  After doing so, try the upgrade again and see if you receive the same error message for this feature class. ... View more

The fastest way to do this would be to recreate the replica: 1.  Unregister the replica from each geodatabase 2.  Delete the feature class in the child geodatabase 3.  Replicate the data from the parent to the child geodatabase again ... View more

Hi Carme, If you are creating a custom tool to use within ArcMap, you should consider using the arcpy.GetParameterAsText function.  Here is some further information on how to set a script tool's parameters. ... View more

Hi Camron, Do any of these fields you are attempting to append contain dates?  If so, take a look at the following KB article. ... View more

Do you have ArcFM enabled for this geodatabase?  If you do, I believe you have to initialize the ArcFM license. http://forums.esri.com/Thread.asp?c=93&f=993&t=183747 ... View more

Hi Alan, 1.  There is no place in the model for Zip Code boundaries. Should I add them into an existing feature class, which one, and modify a domain or just create a new feature class? I would recommend creating a new feature class.  The Local Government Information Model (LGIM) supplies a number of feature classes, but there may be some that you need that are not supplied (and vice-versa).  2.  There are locations we refer to as Recycle Centers; basically it�??s the location for the neighborhood to come dispose of household garbage and recyclables. I want to put them in the FacilitySitePoint feature class. They are not a landfill so I cannot use that option. I could add recycle center to the domain but it�??s part of the subtype Industry (that�??s where landfill is). I do not believe that would be a proper use of the Industry subtype though. Any thoughts? I would recommend creating a new Domain and Subtype value if this would make it easier for you and other users to interpret.  The LGIM is not only great to help organize/manage your data, but it also makes it very easy to stand up web applications from the Resource Center's Local Government User Community.  The FacilitySitePoint feature class is used for mainly reference data, so no application will need to query specific fields/domains/subtypes values within this feature class for the application to work. ... View more

I've seen some hiccups with the overwriteOutput command after scripts have been executed and then it's added.  Try deleting the table, restarting Pythonwin/IDLE, and then re-execute the script. ... View more

Hi Michalis, You should be able to specify the output raster parameter if you call the 'arcpy.gp.ZonalStatistics' function.  Ex: # Local variables: int_example1 = "C:\\DATA\\RASTER\\DEM\\int_example1" example = "C:\\temp\\python\\zones.tif" ZonalSt_int_1 = "C:\\temp\\python\\zonal_stats.tif" # Process: Zonal Statistics arcpy.gp.ZonalStatistics_sa(int_example1, "VALUE", example, ZonalSt_int_1, "MEAN", "DATA") However, if you call the 'arcpy.sa.ZonalStatistics' function the raster will be written to a scratch workspace.  Ex: # Local variables: int_example1 = "C:\\DATA\\RASTER\\DEM\\int_example1" example = "C:\\temp\\python\\zones.tif" ZonalSt_int_1 = "C:\\temp\\python\\zonal_stats.tif" # Process: Zonal Statistics stats = arcpy.sa.ZonalStatistics(int_example1, "VALUE", example, "MEAN", "NODATA") The raster will be removed from the scratch workspace if you save a hard copy.  For example you would add the following at the end: stats.save(r"C:\temp\python\Zonal_Stats.tif") I would recommend setting 'arcpy.env.overwriteOutput = True' and using the 'arcpy.gp.ZonalStatistics_sa' function.  With this function you can easily specify where you want the raster written to, and you can overwrite the output raster each time. ... View more

Feel free to post your code, or upload your .py file and I can take a look. ... View more

Hi Bart, Add the following line of code: env.overwriteOutput = True This will allow you to overwrite existing feature classes. ... View more