Latest Contributions by ChristianWells

Hi Jamie, Here is how I set up my model. I put all of the shapefiles into a Personal Geodatabase, then used the iterate tool to loop through them and create a new feature class using the following expression:  [Area_SqFt] in (select MIN( [Area_SqFt]) from %Name%) ... View more

Finding the minimum value: This may be difficult to do as shapefiles don't fully support subqueries (See link here). However, if the data were stored within a Personal Geodatabase (MDB) this could be done using the following query: Elev_Diff in (select MIN(Elev_Diff) from <featureclass>) Exporting a file with the name of its input: I would suggest adding another tool to the end of the model, Copy Features, to copy the selected features to a new file. ... View more

Hi Harlan, I just had some quick questions about this: What is the current projection of each layer? Which tool did you use to do the projection to NAD 1983 HARN? ... View more

Can you upload a picture or text of the feature extent from the shapefile properties? ... View more

In this case, the two differences only point to the Schema owner in the database. If the base name "GDM_CO_AREA_83” has not changed, you could control for the schema owner name change. ... View more

Hi Jennifer, We can handle the issue of not having the same number of layers. The layer names may be a little harder to automate, but may be doable. How have the new names changed and do you have a list of which ones line up? ... View more

This should be some that is doable for your work. One tool that will be helpful in scripting is the Feature Compare tool which will compare a number of variables. Using this tool we should be able to script this for all of your layers. This could also be done through ModelBuilder. Feature Compare: ArcGIS Help (10.2, 10.2.1, and 10.2.2)‌ This is a sample workflow logic that could be used to script this process: import arcpy, os #Create DB Connections to both databases gdb91 = r"DB Connection" gdb101 = r"DB Connection" #Create a list to store the feature classes from both databases list91 = [] list101 = [] #List the feature classes arcpy.env.workspace=gdb91 fcList = arcpy.ListFeatureClasses() for fc in fcList:      list91.append(fc) arcpy.env.workspace=gdb101 fcList = arcpy.ListFeatureClasses() for fc in fcList:      list101.append(fc) #Compare the feature name and them compare the feature classes themselves for fc91 in list91:      try:           idx = list101.index(fc91)           fc101 = list101[idx]           path91 = os.path.join(gdb91,fc91)           path101 = os.path.join(gdb101,fc101)           arcpy.FeatureCompare_management(path91, path101, out_compare_file=r"C:\CompareFile\{0}.txt".format(fc91))      except:           print "Cannot compare layer {0}".format(fc91) ... View more

Can you provide some more information regarding this issue: What is the error (if any) you receive when running the GP tool? Do any locks exist on the data? Are you currently logged in as the data owner? Have you tried rebuilding the indexes from Oracle? CREATE INDEX cola_spatial_idx ON cola_markets(shape) INDEXTYPE IS MDSYS.SPATIAL_INDEX; ... View more

This is something that is doable with your rasters. The best way to accomplish is to load the rasters into aRaster Catalog or Mosaic Dataset within a file geodatabase. In a Raster Catalog, you have an attribute table that can be used to store year information for each raster within the catalog. This attribute can then be used to create the time series maps. Sample Workflow for Raster Catalog: 1. Rename your raster datasets with a year suffix (i.e. "Rainfall_2014.tif") 2. Load those rasters into a Raster Catalog 3. Add a field called to the Raster Catalog to represent your time field 4. Start an edit session in ArcMap to edit the time field to match your Rasters 5. Save your edits 6. Create a map using the Time Slider or Definition Query to query your rasters ... View more

Glad that I could help. I just submitted a ticket for that document to be reviewed. ... View more

Since you already have the bookmarks set up, you can use the Mapping module to complete this. In this module, you would have access to a list of the bookmarks. Each bookmark object would have an extent which can then be applied to the data frame and the map document could be exported. Sample workflow: import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") for bkmk in arcpy.mapping.ListBookmarks(mxd):      ext = bkmk.extent      df = arcpy.mapping.ListDataFrames(mxd)[0]      df.extent = ext      arcpy.mapping.ExportToPDF(mxd, r"C:\Temp\{0}".format(bkmk.name)) ListBookmarks: ArcGIS Help 10.1‌ MapDocument: ArcGIS Help 10.1‌ ... View more

You could try something like this to format your connection string: EditorList = ['user1', 'user2', 'user3'] SDEConnect = 'Database Connections\\Atlas2013 {0} as {0}.sde\\sde.CHELAN.LandBase\\sde.CHELAN.Property_Polygons' #Print single user connection print SDEConnect.format(EditorList[1]) #Print all users connection information for editor in EditorList:     print SDEConnect.format(editor) Results: Database Connections\Atlas2013 user1 as user1.sde\sde.CHELAN.LandBase\sde.CHELAN.Property_Polygons Database Connections\Atlas2013 user2 as user2.sde\sde.CHELAN.LandBase\sde.CHELAN.Property_Polygons Database Connections\Atlas2013 user3 as user3.sde\sde.CHELAN.LandBase\sde.CHELAN.Property_Polygons ... View more